Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
  

• Administration
• File Management
  

• Login/Logout
• Language Selection
• Your Profile
• Create Account
  

Quick Search
»
Advanced Search »

NWIS Loaded Data Checks

Queries to do counts for status needs to be a sql page, later

select count(sitecode) from odm_qw_sites
select count(seriesid) from odm_qw_seriescatalog
select count(*) from odm_qw_variables
 
select count(sitecode) from odm_dv_sites
select count(seriesid) from odm_dv_seriescatalog
select count(*) from odm_dv_variables
  
select count(sitecode) from odm_uv_sites
select count(seriesid) from odm_uv_seriescatalog
select count(*) from odm_uv_variables
 
select count(sitecode) from gw_flatfile
- 
select count(sitecode) from peak_flatfile

Checks:

Daily Values without stat codes. Should return no results:

select * from usgs_dv_por where stat_cd = OR stat_cd is null

select * from odm_dv_variables where stat_cd = OR stat_cd is null

Should be no duplicates:

select sitecode, variablecode, usgs_stat_cd, variableName, valuetype,datatype from odm_dv_seriescatalog
order by siteid