1 / 6

Nontidal Network Database

Nontidal Network Database. Implementation on CIMS- where do we stand now?. DATABASE. All data from Mike’s database is now in a database for the NTID network stations 1965 thru dec 2005 I can currently query this data for users This is not available to the public yet

blythe
Download Presentation

Nontidal Network Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nontidal Network Database Implementation on CIMS- where do we stand now?

  2. DATABASE • All data from Mike’s database is now in a database for the NTID network stations 1965 thru dec 2005 • I can currently query this data for users • This is not available to the public yet • Eventually all data submitters will have their own submittal page on our QA tool (internet accessed), and will need to upload their data in an Access 97 file • Most 2006 data needs to be added • IT department has been contacted, will move forward in December with getting data uploaded from submitters to CIMS

  3. NTN STATIONS by State These are all stations that are currently ACTIVE: DO WE WANT ALL OF THESE (RIM stations?!) included in the database?? • DELAWARE (2) : 1) 01488500 2) 01487000 • MARYLAND (13 + 4RIM) : 1)   ANT0047 (01619500) 14) 01491000 (RIM) 2)   BEL0053 (01495000) 15) 01594440 (RIM) 3)   GWN0115 (01589300) 16) CB1.0 (01578310) (RIM) 4)   DER0015 (01580520) 17) TF2.0 (01594526) (RIM) 5)   NPA0165 (01586000) 6)   TF1.2 (01594526) 7)   MON0546 (01639000) 8)   TUK0181 (01491500) 9)   WIL0013 (01601500) 10) GEO0009 (01599000) 11) GUN0258 (01582500) 12)  PXT0972 (01591000) 13) CAC0148 (01637500)

  4. NEW YORK (5) 01502500 01503000 01515000 01529500 01531000 PENNSYLVANIA (27) 01531500 01536500 01540500 01542500 01548085 01549760 01553500 01555000 01562000 01567000 01568000 01570000 01573560 01574000 01576000 01576754 01576787 01578475 01609000 01610155 01613095 01613525 01614500 01619000 01571500 01520000 01518700 VIRGINIA (18 + 5 RIM, +6 RIM2) 1AACO014.57 (01654000) 1ACAX004.57 (01638480) 1BSSF100.10 (01628500) 1BSTH027.85 (01626000) 2-APP110.93 (02039500) 2-BCC004.71 (02011500) 2-BLP000.79 (02015700) 2-CFP004.67 (02020500) 2-DPC005.20 (02041000) 2-MCM005.12 (02031000) 2-MRY014.78(02024000) 2-PNY005.29 (02027500) 3-ROB001.90 (01666500) 3-RPP147.49 (01664000) 8-LTL009.54 (01671100) 8-MPN094.94 (01674000) 8-NAR005.42 (01671020) 8-POR008.97 (01673800) 01634000 (RIM2) 1BSSF003.56 (01631000) (RIM2) 2-CHK035.26 (02042500) (RIM2) 2-JMS113.20 (02037618) (RIM2) 2-JMS279.41 (02024752) (RIM2) 3-RAP030.21 (01667500) (RIM2) 8-NAR005.42 (01671020) (RIM2) TF3.0 (01668000) (RIM) TF4.0M (01674500) (RIM) TF4.0P (01673000) (RIM) TF5.0A (02041650) (RIM) TF5.0J (02035000) (RIM) WEST VIRGINIA (4) 01604500 01608500 01611500 01616500 NTN Stations by State

  5. Data Attributes ** Are we missing any necessary attributes to the data? ** Each of these represents a field in a table in the database: • USGS Gage (associated to station or actual station) • Station name • Phase 5 Code • Dropped or relocated, when each done • Start date, end date (of station in NTN) • State • Lat/long (NAD83) • Water Body • Storm or Baseflow (Sampling_type) • Primary/Secondary (station_type) • Core/trend/RIM type • ANY OTHER STATION INFO WANTED? Basin, TS_Basin, HUC11, etc • Parameter (CBP) • USGS Parameter Code • Qualifier • **BMDL value (need?) • Method • Requests already suggested: • Add a “load/trend” field for sample records – 3yrs of records for loads, 10 yrs - trends • Project (core, trend, NTN, etc) • Sampling: baseflow or storm

  6. Open Discussion • Are there specific outputs that people use now or would like the database to perform? • Is something missing from the database that can be useful? Or something that in general for analyses (besides maps) could be posted to CIMS internet NTN database site? • How important is cross-querying with the tidal database on CIMS? We will be moving all duplicate data (NTN) to this new database from the TIDAL one. • Anything else?

More Related