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 Statistics Codes Statistics

What are the default statistics for a variable in the NWIS daily values.¶

Download Stat code CSV

To do this we ran a summary query below on the usgs database

SELECT     variablecode, DataType, count (sitecode) as NumberOfSites
FROM         odm_dv_seriesCatalog
group by variablecode, datatype
order by variablecode

But that is not the whole story, this shows stations where there is only one observation

SELECT     DataType, variablecode
FROM         odm_dv_seriesCatalog
group by datatype,variablecode
having count(variablecode) =1

And not the optimal query, but

SELECT     sitecode, variablecode, count( DataType)
FROM         odm_dv_seriesCatalog
where  not (datatype = 'Average')
group by sitecode, variablecode
having count(DataType) =1

And just the variable codes

select distinct variablecode,variablename from odm_dv_variables 
where variablecode in (
SELECT      variablecode
FROM         odm_dv_seriesCatalog
where  not (datatype = 'Average')
group by sitecode, variablecode
having count(DataType) =1
)

• 00010
• 00011
• 00020
• 00022
• 00045
• 00036
• 00054
• 00055
• 00060
• 00062
• 00065
• 00400
• 00403
• 61728
• 62611
• 72019
• 46529
• 72020
• 99772