Added a new function to query the stations database: query_stations()
This function currently lives in my rmichie/wqdb package. I think it makes more sense that this function live in the AWQMSdata package. Ideally this function should replace AWQMS_Stations(). The limitation with AWQMS_Stations() is that it queries AWQMS. The station info in AWQMS is a view with certain fields joined from the Stations database. In practice I do not believe the station db fields in AWQMS are dynamically updated so the information is often incomplete or missing. Also not all fields are included in the join. I therefore think it's better to query the stations database directly.
TravisPritchardODEQ
commented
4 years ago
Added a new function to query the stations database: query_stations()
This function currently lives in my rmichie/wqdb package. I think it makes more sense that this function live in the AWQMSdata package. Ideally this function should replace AWQMS_Stations(). The limitation with AWQMS_Stations() is that it queries AWQMS. The station info in AWQMS is a view with certain fields joined from the Stations database. In practice I do not believe the station db fields in AWQMS are dynamically updated so the information is often incomplete or missing. Also not all fields are included in the join. I therefore think it's better to query the stations database directly.