PDF《Downloading？&燯sing燚ata爁rom炉he?》

Downloading?&

?Using?Data?from?the?STORET?Warehouse:?An?Exercise? August?2012? ? ? This?exercise?addresses?querying?or?searching?for?specific?water?resource?data,?and?the?respective? methods?used?in?collecting?and?analyzing?data?for?a?given?state?and?county.

??The?following?exercises?will? guide?you?through?steps?to?generate,?download,?access?and?organize?a?typical?query?for?the?STORET?Data? Warehouse.??Please?contact?STORET?Technical?Support?at?1\800\424\9067?toll?free?or?at? [email protected]??for?comments?or?questions.? ? Part?1.??How?to?query?and?download?the?data?C?step?by?step?guide?to?generating?and?downloading?a?? typical?query?for?the?STORET?Warehouse.? ? Part?2.??Making?sense?of?your?downloaded?file?Cdescription?of?the?format?of?the?downloaded?file,?and?? how?to?extract?data?in?your?file.??? ? Part?3.??How?to?import?and?analyze?the?data?in?Microsoft?Excel? ? Part?4.??How?to?import?and?analyze?the?data?in?Microsoft?Access? ? Part?5.??Downloading?a?watershed?summary?from?the?STORET?Warehouse:?an?exercise? ? ? Part?1:??How?to?Query?and?Download?the?Data?? The?STORET?database?can?be?used?to?access?data?on?specific?water?resource?chemical,?physical? and?biological?characteristics?and?parameters?as?well?as?methods?used?in?assessments.?All?Data? downloaded?from?the?STORET?warehouse?references?a?data?owning?organization,?or?the?organization? responsible?for?collecting?the?data.?STORET?can?be?queried?for?monitoring?location?information,?as?well?as? the??data?collected?at?monitoring?locations.?? ? ? Biological?Data?Habitat?Data?Chemical?Data? ? STORET?queries?generate?a?file?containing?result?data?files,?metadata?files,?and?available? reference?documents?associated?with?the?data?owning?organizations.?Downloaded?data?and?document? files?are?compressed?in?a?(zipped)?.tar.gz?file?format.?The?following?exercises?will?guide?you?through?steps? to?generate,?download,?access?and?organize?a?typical?query?for?the?STORET?data?Warehouse??Below?is?an? example?detailing?a?query?for?dissolved?oxygen?(DO)?values?from?all?monitoring?sites?in?Denver?County,? Colorado,?with?no?specific?timeframe.?? Step?1.??Access?the?STORET?Data?Warehouse? ??????a.)?Go?to?the?STORET?main?page:?http://www.epa.gov/storet/? ??????b.)?Under?the?box?titled?Features,?click?the?Download?Data?link? ??????c.)??Under?The?STORET?Data?Warehouse,?click?the?yellow?button?titled?Browse?or?Download??? Modernized?STORET?Data.?? TIP:?Legacy?(pre\1999)?data?is?also?available?(flat?filed)?by?State/?County?for?easy?downloading? ? Step?2.??Define?Your?Query? ?Queries?can?be?defined?by?one?or?multiple?parameters?including?Geographic?Location,?Organizations,??? ?Stations,?Projects,?Station?Types,?Date,?Activity?Intent,?Community?Sampled,?Characteristics?and?Activity???? ?Medium.??? ??????d.)?Under?STORET/WQX?Warehouse?Reports\STORET?Results?click?the?link?titled?Results?Download?? TIP:??Dissolved?oxygen?is?a?physical/?chemical?(regular)?parameter?(not?bio?or?habitat)? ??????e.)?Geographic?Location?information?can?be?further?subdivided?by?State/County,?Latitude?Longitude?? Coordinates?or?drainage?basin/HUC.??? ? ? ??????f.)?Under?the?State?Name?drop\list,?select? Colorado ? ??????g.)?Under?County?Name,?click?on?the?Look?up?button?and?select? Denver ?from?the?drop\list? TIP:??Leaving?the?State/?County?defaults?gives?you?a?national?query?(but?a?very?large?dataset)? ??????h.)?Under?Station?Type,?leave?the?defaults;

?this?will?capture?all?station?types? ??????i.)?Under?Date,?leave?defaults;

?this?will?capture?all?date?ranges?of?STORET?Date?Warehouse?(non\? legacy?datasets)?? TIP:??Use?Date?to?refine?a?large?query?result?into?multiple?smaller?downloads? ??????j.)?Under?ACTIVITY?MEDIUM?,?Select? Water ? ?????k.)?Under?ACTIVITY?INTENT?and?COMMUNITY?SAMPLED,?leave?the?defaults:?this?will?capture?all??? sampling?intents.? ??????l.)?Under?Characteristic,?place?the?cursor?in?the?Characteristic?Search?Box? i.?Type? dissolved?oxygen ??in?the?Characteristic?Search?box??and?click?the?Search?button.?? TIP:?The?Characteristic?Search?box?utilizes?a?Beginning?with?type?search.??For?example,?in?? regards??to?dissolved?oxygen,??typing?in?leading?characteristics?such?as? disso ??will?return?a?? list?of?matching?parameters?with?characteristic?names?starting?with? disso ?like?dissolved?? oxygen.?? TIP:?The?percent?sign? % ?is?a?wildcard?search?prefix?that?searches?for?parts?of?a?characteristic??? name?if?the?full?name?is?unknown?(example:??typing? %disso ?or? ?%oxy ?or? %DO ?all?work)?? ii.??Select? dissolved?oxygen?(DO) ?from?the?Characteristic?Name?list?and?click?the?Select??? button.? ?????m.)?Click?the?Continue?button?at?the?bottom?of?the?screen? ? Step?3.??Download?Your?Query?Results? ???????n.)?Note?the?number?of?records?found?? TIP:?MS?Excel?holds?one?million?records?per?sheet,?MS?Access?holds?more?but?limited?to?3?gigabytes?? TIP:?If?there?are?too?many?records,?you?may?have?to?go?back?to?narrow?your?query?? TIP:?You?can?adjust?your?query?by?narrowing?the?date?fields?or?limiting?characteristics?? ???????o.)?Select?the?report?types?(REGULAR,?BIOLOGICAL?HABITAT,METRICS,?and?INDEX)? ???????p.)?In?the?Please?select?the?appropriate?user?profile?box?Indicate?the,?specify?your?profile. ???????q.)?Type?your?email?address?in?the?Please?enter?your?email?address?box?? TIP:?Emails?are?used?to?notify?you?that?your?download?is?first?processing?and?then?completed?? ???????r.)?Type?a?three?character?prefix?like? XYZ ?in?Please?specify?three?characters?to?prefix?your?report?name?box?? TIP:?This?prefix?will?help?to?identify?your?download?file?later?? ???????s.)?Scroll?to?the?bottom?of?the?screen?to?the?Select?Data?Elements?for?Report?checklist?C?? i.?Under?Select?Data?Elements?for?Report?(s),?click? Clear?All ,?then? Select?All ?data?elements.? TIP:?These?are?the?fields?you?will?see?in?your?report,?you?can?select/de\select?any?you?choose?? ???????t.)?Under?Batch?Processing,?click........