NWIS Data Source Notes

RSS

Modified on 2009/03/03 09:18 by valentinedwv Categorized as 3rd Party Data Sources, WaterOneFlow

» ODM - Series Catelog - Future Possibilities » NWIS Statistics Codes Statistics » NWIS Data Source Notes

Vocabularies: http://waterdata.usgs.gov/nwis/help?codes_help

We get USGS Database contact dave briar at the usgs it was at: ftp://ftpext.usgs.gov/pub/cr/mt/helena/

Issues:

Addressed:
got usgs groundwater and peak period of records
NWIS Match USGS Units to ODM Units
NWIS Loaded Data Checks

--- In collaboration with the USGS, there is an internal server hosting the USGS Daily Values:

http://nwisvaws02.er.usgs.gov:8080/NWISQuery/GetWSService?wsdl
oct 15. Not working java no such method error.

xsw2XSW@vwd

Move to River:

NWIS
Remove Developemental and testing phase

Sample DB queries ¶

Method and paramaters

select parm_cd
FROM USGS_PARM_METH
GROUP BY parm_cd
HAVING COUNT(*) > 1
)
and not (Meth_cd = );

SELECT  meth_cd, parm_cd
FROM USGS_PARM_METH
WHERE meth_cd IN(

select meth_cd
FROM USGS_PARM_METH
GROUP BY meth_cd
HAVING COUNT(*) > 1
)
and not (Meth_cd = )
order by meth_cd

DailyValues, Unit Values and IID (qw) Variable count

SELECT     
SeriesCatalog.VariableName,SeriesCatalog.VariableCode,
 COUNT(SeriesCatalog.SiteCode) AS SiteCount

FROM         odm_uv_SeriesCatalog  as seriescatalog
GROUP BY  SeriesCatalog.VariableName,
SeriesCatalog.VariableCode

ORDER BY  SiteCount DESC

go
SELECT     
SeriesCatalog.VariableName,SeriesCatalog.VariableCode,
 COUNT(SeriesCatalog.SiteCode) AS SiteCount

FROM         odm_qw_SeriesCatalog  as seriescatalog
GROUP BY  SeriesCatalog.VariableName,
SeriesCatalog.VariableCode

ORDER BY  SiteCount DESC

go 

SELECT     
SeriesCatalog.VariableName,SeriesCatalog.VariableCode,
SeriesCatalog.usgs_stat_cd,
 COUNT(SeriesCatalog.SiteCode) AS SiteCount

FROM         odm_dv_SeriesCatalog  as seriescatalog
GROUP BY  SeriesCatalog.VariableName,
SeriesCatalog.VariableCode,
SeriesCatalog.usgs_stat_cd
ORDER BY  SiteCount DESC

Peak and groundwater

SELECT     
SeriesCatalog.VariableName,SeriesCatalog.VariableCode,
 COUNT(SeriesCatalog.SiteCode) AS SiteCount

FROM        gw_flatfile as seriescatalog
GROUP BY  SeriesCatalog.VariableName,
SeriesCatalog.VariableCode

ORDER BY  SiteCount DESC

go

SELECT     
SeriesCatalog.VariableName,SeriesCatalog.VariableCode,
 COUNT(SeriesCatalog.SiteCode) AS SiteCount

FROM         peak_flatfile as seriescatalog
GROUP BY  SeriesCatalog.VariableName,
SeriesCatalog.VariableCode

ORDER BY  SiteCount DESC