Create front-end to query psql db

[crypdick]

Once we have #3 #4 figured out we need to create a front-end with predefined fields that we can use to make queries of the PSQL db. We then hand off the results to some viz module.

[crypdick]

@duffrind here are the keys to put in the where clause dictionary, defaulting to None.

stop_date_MIN
stop_date_MAX
driver_gender_TUPLE
driver_age_MIN
driver_age_MAX
driver_race char_TUPLE
violation_TUPLE
search_conducted upper(BOOL)
search_type TUPLE
stop_outcome_TUPLE
officer_gender_TUPLE
officer_age_MIN
officer_age_MAX
officer_race_TUPLE
officer_rank_TUPLE
out_of_state upper(BOOL)

[duffrind]

Thanks, currently creating a header with these options.

I post a screenshot in a few

[duffrind]

driver_gender_TUPLE
driver_race char_TUPLE

I am confused what is meant by TUPLE. I can make this a string or something that matches the data, but I cannot think of a way that a (var1, var2, ..., varN) would help with the select statement.

Could someone post a header of the table so that I can make sure that everything is standardized?

[crypdick]

I'm being lazy. Some where clauses look like "WHERE officer_race IN ('b', 'w')" and when you print python lists it uses square brackets instead of round brackets. That wouldn't be hard to substitute.

…

On Nov 1, 2017 22:32, "David Duffrin" ***@***.***> wrote: driver_gender_TUPLE driver_race char_TUPLE I am confused what is meant by TUPLE. I can make this a string or something that matches the data, but I cannot think of a way that a (var1, var2, ..., varN) would help with the select statement. Could someone post a header of the table so that I can make sure that everything is standardized? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#5 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFKjYO8u294qrxOlg-4kc2wrf7HsneR_ks5sySnOgaJpZM4QG8pU> .

[duffrind]

There are a LOT of violations. Will we use regex for something like:

UI:
DUI
License
Equipment
Speeding
Paperwork
Other

Backend:
WHERE violation ~ '.*' + UI_violation + '.*'

[duffrind]

Also, there are 133 different ranks in the table... I think that I will skip this for now and add in the future if I have time.

[crypdick]

hmm. maybe we can figure out a way to show the top 5 violations per county. but first, let's an app working that shows counts and means and then we can implement fancier queries