search

agrc / ugs-db

Database seeder for UGS data
2 stars 1 forks source link

Dictionary for populating `ParamGroup` #43

Closed inkenbrandt closed 8 years ago

inkenbrandt commented 8 years ago

Dictionary compiled from SDWIS, NWIS, SRS, and WQX to populate ParamGroup field in Results table. Would work well to replace https://github.com/agrc/ugs-db/blob/master/src/dbseeder/services.py#L255-264, although the functions that call the current lists would need to be changed to use a dictionary instead. I could break this into separate group lists as well if that would work better.

steveoh commented 8 years ago

This is not going to work. The file is too big. Can you tell me how you created it so I can come up with another method for working with these values?

inkenbrandt commented 8 years ago

Yes! https://github.com/inkenbrandt/ParamGroup/blob/master/Untitled.ipynb

inkenbrandt commented 8 years ago

I can provide more when I am in the office again.

inkenbrandt commented 8 years ago

Most of the matches come from the existing lists that you had in dbseeder and in the table PARAM_MATCH. There is a column in the PARAM_MATCH table named SDWIS_NAME that can be used to find the parameter_group_nm (aka the ParamGroup)

inkenbrandt commented 8 years ago

I could make one dictionary for each ParamGroup, which would make them more manageable.