The EPA Storet data cube, contains about 45 million observation values from the EPA. The data was given to the Geo spatial group from Bora Boran. Matt Rodriguez performed a lot preprocessing to match observations to variables and to sites. Each observation in the data cube needs to be associated with a variable and a site. Foreign keys should be established in the EPA STORET database to ensure data integrity.
Measures are the data, the dimensions determine the kind of queries that can be made. The pivot table interface abstracts most of these details, so if you just want to start exploring the data, you can ignore the following sections.
Measures
Average
Count
Cumulative
MaximumValue
MinimumValue
Site
HierarchiesLatitude Bands are bands of 10 degrees
Longitude Bands are bands of 20 degrees
HUC-Site: Drills down from HUC to individual site name
LatitudeBand-Latitude: Drills down to individual latitudes
LatitudeBand-Site-Name: Drills down to individual site names
LongitudeBand-Latitude: Drills down to individual longitudes
LongitudeBand-Site-Name: Drills down to individual site names
State-County-Site: Drills from State to County to site name
AttributesComments: County:Canada, Country:US
County: Lots of Counties
HUC
HUCNumeric
LatitudeBand:(see above)
LatitudeBand:(see above)
LongitudeBand: (see above)
Organization: EPA, Florida Keys National Marine Sanctuary, Minnesota Pollution Control
State: US States and provinces
Timeline
HierarchiesDecade-Day: Drill down path is decade, year, day of year
Decade-Month: Drill down path is decade, year, month, day of month
AttributesDay of Year
Decade
Year
Month of Year
Variables
HierarchiesMedium-VariableName: Drill down path is Medium, VariableName
AttributesEPAOriginalUnits: Units
SampleMedium:
ValueType: FieldObs/Sample
VariableCode: EPA-VariableCode-MediumCode
Variables: Variable Name
Variable Units: Units description