Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

People with location ID of 0 do not show up at all #11

Open
Sheeri opened this issue Jun 8, 2016 · 2 comments
Open

People with location ID of 0 do not show up at all #11

Sheeri opened this issue Jun 8, 2016 · 2 comments

Comments

@Sheeri
Copy link

Sheeri commented Jun 8, 2016

Arlene Istar Lev LCSW, CASAC, - should show up in the "Therapists" category - they're labeled as category 5 - but they do not.

I think this is because their location is 0, so there's no location category to put them in.

We should contact or look at websites for listings with location 0.

@Sheeri
Copy link
Author

Sheeri commented Jun 8, 2016

Good news, there's only a few dozen. https://docs.google.com/spreadsheets/d/1CD_ITDj2s_flzeN_TB7vwTCTEmFLVTst9xCQghORAVE/edit#gid=0 - tab marked "no location/address". I put in the id and the name of the person, not sure if other information is desired. If so, let me know, it's easy to do :D

(or if you're querying, you want SELECT [fields] FROM polylistBetaDB.professionals WHERE lcoation_id=0;)

@Sheeri
Copy link
Author

Sheeri commented Jun 8, 2016

(the spreadsheet is open to me, Geri, Tom, feel free to share with volunteers but I'm not sure we want it public so I haven't done that).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant