Update: NPSTORET and Natural Resource Database Template NRDT

1
Update NPSTORET andNatural Resource Database
Template(NRDT)

• Dean Tucker, Water Resources Division
• Margaret Beer, IM, WASO

2
NPSTORET

• NPSTORET Workshop Friday 830am until ...

• Version 0.96 Currently Available
• http//nrdata.nps.gov/Programs/Water/NPStoret/NPST
  ORET.ZIP
• Current efforts focusing on importing data

Seamless Import

• NPSEDD (Eddy) Available
• http//nrdata.nps.gov/Programs/Water/NPSEDD/NPSEDD
  .ZIP

3
NPStoret User Board
4
Natural Resource Database Template

• A standardized yet flexible database core for
  developing natural resource-related applications.

5
Why NRDT?

• Realization that 32 networks would each be
  creating databases --some kind of guidelines were
  needed!
• and
• NRDT standardizes data elements that are common
  to most IM data sets (e.g., locations, events).
• This sets the stage for higher-level
  integration of data sets across networks or
  regions.
• andEconomy of scale in application development

6
Why should I use NRDT?

• NRDT decreases the level of database divergence
  among the 32 networks.
• Data managers and data users can easily
  familiarize themselves with a variety of data
  sets when a similar core structure is used.

7
Why should I use NRDT?

• NRDT is supported by staff at the NPS Washington
  Service Office (WASO).
• It is also a peer-supported system NRDT users
  across the country can share code, share
  approaches or solutions to specific problems, and
  use a common database vocabulary.
• The direction and standards of NRDT are
  determined by the users, via an active user board
  and subcommittees.

8
Core Tables
Protocol-specific Tables
Core Tables
9
Exceptions

• There may be situations where NRDT standards are
  simply not practical or applicable.
• legacy data, remotely-sensed data, etc.
• Let the NRDT User Board know of situations where
  compliance isnt possible.
• This may lead to a revision or extension of
  standards, or the development of a data model
  that could benefit multiple networks.

10
NRDT User Board

• The NRDT User Board, established in January,
  2006, comprises members from the NRDT user
  community.
• The board is responsible for guiding the overall
  direction on NRDT evaluating, establishing, and
  revising standards and promoting NRDT use among
  parks and networks.
• Any NRDT user can submit suggestions to the user
  board for changes or improvements to NRDT.
• Charter, minutes, other board material will be
  posted on intranet

Goal is to keep the decision process open and
transparent to all.
11
User Board NRDT
12
Primary Keys

• NRDT v3.1 Options for Primary Keys
• Option 1
• GUID as binary
• Option 2
• GUID as text string
• Option 3
• Aggregate text string
• Option 4
• Autonumber

4645DABE-34FF-49A6-8E85-EFF8F97C4E0C
?
2AE74CFA-2FD5-46B6-971C-5CFBC0AA26E2
?
MOJN_herp22_20050521-1442_1
2443
13
Upcoming

• Documenting enterprise approach to NRDT
• Geodatabase model
• Expert database review
• Extended models and templates
• Ability to provide more tech support
• BOFAT hasnt been forgotten