General

Note: the options described on this page under the Admin tab can be accessed only by users with administrative privileges.

The General category of Administrative Tools includes lists of sources and resources, data codes and units, datasets and variables, library categories and document types, organizations, and tags for establishing associations within the ODP.

For each table, toggle between ascending and descending sorts for each column by clicking on the hyperlinked column headings.

Additional Resources

The Additional Resources table lists the organizations, programs, and databases that are visible to all users of the ODP on the Additional Resources page under the Data & Documents tab.  Here under the Admin tab, this list can be edited.

To add an entry to the Additional Resources table:

  1. Click on the add button Add Item Button to open the Additional Resource Details page.
  2. In the Display text field (mandatory), type the text you want users to see in the bulleted list on the Additional Resources page under the Data & Documents tab.
  3. Type the URL for the resource into the Web Site field (mandatory). There is no error-checking feature, so take care to ensure the address is free of errors.
  4. Characterize the nature of the resource by selecting an option from the Purpose drop-down list.
  5. Save your new entry Save icon or click on Cancel Cancel icon to abandon your changes.
  6. Use the green back arrow Back Arrow to return to the list of Additional Resources.

To edit an existing entry in the Additional Resources table:

  1. Click on the hyperlink in the Display Text column to open the entry you want to edit.
  2. On the Additional Resource Details page, click on the edit icon File Folder to make the entry editable.
  3. You can make changes to Display text, Web Site, and Purpose (see steps 2, 3 and 4 above).
  4. When done, Save your changes Save icon or Cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the list of Additional Resources.

The date and time of your additions/edits will be displayed on the Additional Resource Details page and in the main Additional Resources table along with your username.

To delete an entry from the Additional Resources table:

  1. Click on the hyperlink in the Display Text column to open the entry you want to delete.
  2. Click on the Delete icon Trash Can to remove the entry from the Additional Resources list.
  3. Deleted entries are no longer visible to users on the Additional Resources page under the Data & Documents tab.

Data Qualifier Codes

The Data Qualifier Codes table lists and briefly describes the data qualifier codes used in the ODP.  Qualifiers are used in the import templates.

To add an entry to the Data Qualifier Codes table:

  1. Click on the add button Add Item Button to open the Qualifier Code Details page.
  2. Enter a unique Name (numbers, letters, or both) and a brief Description of the new qualifier.  A warning message will appear if you enter a code that duplicates one already in the system. The Name field is mandatory.
  3. Save your new entry Save icon or click on Cancel Cancel icon to abandon your changes.
  4. Use the green back arrow Back Arrow to return to the list of Data Qualifier Codes.

To edit an existing entry in the Data Qualifier Codes table:

  1. Click on the hyperlink in the Name column to open the entry you want to edit.
  2. On the Qualifier Code Details page, click on the edit icon File Folder to make the entry editable.
  3. You can make changes to Name and Description (see step 2 above).
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the list of Data Qualifier Codes.

The date and time of your additions/edits will be displayed on the Qualifier Code Details page and in the main Data Qualifier Codes table along with your username.

To delete an entry from the Data Qualifier Codes table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry from the Data Qualifier Codes list.

A warning message will appear if you attempt to delete a code that is in use.

Data Sources

The Data Sources table lists the people and organizations that have provided the data accessible through the ODP.  Data sources are used in the import templates.

To add an entry to the Data Sources table:

  1. Click on the add button Add Item Button to open the Data Source Details page.
  2. Enter the Name of the source (individual, program, etc.). This field is mandatory.
  3. Select the name of the Organization from the drop-down list of the same name; if the organization you need is not listed, it can be added to the Organizations list.
  4. Enter a Description of the source, type a URL into the Web site field, and provide contact information for the source (Phone, Email, Address, City, State, Zip code fields).  Not all of the contact information fields need to be filled.  There is no error-checking feature, so take care to ensure the web site address and contact details are free of errors.
  5. Save your new entry Save icon or click on Cancel Cancel icon to abandon your changes.
  6. Use the green back arrow Back Arrow to return to the list of Data Sources.

To edit an existing entry in the Data Sources table:

  1. Click on the hyperlink in the Name column to open the entry you want to edit.
  2. On the Data Source Details page, click on the edit icon File Folder to make the entry editable.
  3. Make your changes (step 2 above).
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the list of Data Source Details.

The date and time of your additions/edits will be displayed on the Data Source Details page and in the main Data Sources table along with your username.

To delete an entry from the Data Sources table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry from the Data Sources list.

A warning message will appear if you attempt to delete a data source that is in use.

Datasets and Variables

The Datasets table lists the datasets and variables available for use in the ODP.  Datasets and variables are used in the import templates.

To add an entry to the Datasets table:

  1. Click on the add button Add Item Button to open the Dataset Details page.
  2. Enter the Name of the dataset (mandatory) and a Description.
  3. If you want the dataset to be accessible for querying (Tabular Data Query on the Data & Documents tab), check the Available in data query box.
  4. Save your new entry Save icon or click on Cancel Cancel icon to abandon your changes.

To add variables to a dataset:

  1. With your dataset open on the Dataset Details page, click on the add button ( Add Item Button ) under Dataset Variables to open the Variable Details page.
  2. Enter a Name (mandatory), select appropriate units from the Units drop-down list, and enter a Description for your variable.
  3. Enter an SQL query to control how the tabular data query outputs are returned on the Data Query page.
  4. If you want the variable to be accessible for querying (Tabular Data Query on the Data & Documents tab), check the Available in data query box; if you wish your variable to be accessible to the Time Series Analyst, check the Available in TSA box; check the Filter by location in data query box to include your variable in filters by location.
  5. Enter USGS codes as needed.
  6. Save your variable details Save icon or click on Cancel Cancel icon to abandon your changes.
  7. Use the green back arrow Back Arrow to return to the list of Dataset Details page.  The variable you just entered will be listed in a Dataset Variables table, along with the date and time of your additions/edits and your username.  This table also includes columns for Point Physical Observations and Depth Physical Observations.  These columns are populated automatically by a stored procedure in the database, and cannot be edited by the user; they provide a snapshot of the amount of data stored in the database for each given variable.
  8. Repeat steps 1 through 7 to enter additional variables into the Dataset Variables table.
  9. Use the green back arrow Back Arrow to return to the table of datasets on the Datasets page.

To edit an existing dataset:

    1. On the Datasets page, click on the hyperlink in the Name column to open the dataset you wish to edit.
    2. On the Dataset Details page, click on the edit icon  File Folder  to make the entry editable.
    3. Edit the dataset details as needed. You can also edit variables at this point (see steps 2 through 6, below).
    4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
    5. Use the green back arrow Back Arrow to return to the Dataset page.

To edit an existing variable:

    1. On the Datasets page, click on the hyperlink in the Name column to open the dataset that contains the variable you wish to edit.
    2. On the Dataset Details page, click on the hyperlinked name of the variable you wish to edit to open it.
    3. Click on the edit icon  File Folder  to make the entry editable.
    4. Edit the dataset variable as needed.
    5. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
    6. Use the green back arrow Back Arrow to return to the Dataset Details page, and again to return to the Datasets page.

To delete an entry from the Dataset Variables table, or the Datasets list:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Note that deleting a dataset also deletes all variables associated with it.  A warning message will appear if you attempt to delete a dataset or variable that is in use.

Document Library Categories

The Document Library Categories table lists the general types of information, e.g., meeting notes, reports, brochures, etc., accessible through the ODP.  These are the values in the Category drop-down list of the Document Details page, which is used when you add documents or reports to the ODP.

To add an entry to the Document Library Categories table:

  1. Click on the add button Add Item Button to open the Document Category Details page.
  2. Enter a descriptive Name for the category you wish to add.
  3. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  4. Your saved entry will be displayed on the Document Category Details page, along with the date and time of your addition and your username. A library ID code and external reference hyperlink are automatically assigned to each new entry.
  5. Use the green back arrow Back Arrow to return to the Document Library Categories page.

To edit a document category:

  1. On the Document Library Categories page, click on the hyperlink in the Name column to open the library category you wish to edit.
  2. On the Document Category Details page, click on the edit icon  File Folder  to make the entry editable.
  3. Make your changes to the Name field (the only field that can be edited).  The assigned library ID code and external reference hyperlink will remain unchanged.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Document Library Categories page.

To delete an entry from the Document Library Categories table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting a document category entry will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete a document category that is being used by any documents or reports.

Document Library Document Types

The Document Library Document Types table lists the different kinds of documents, e.g., maps, permits, photos, etc., accessible through the ODP.  These are the values in the Document type drop-down list of the Document Details page, which is used when you add documents or reports to the ODP.

To add an entry to the Document Library Document Types table:

  1. Click on the add button Add Item Button to open the Document Type Details page.
  2. Enter a descriptive Name for the document type you wish to add.
  3. Check the Available in the document library box if you want the new document type to be listed in the Document type drop-down list (Document Details page) so it is available as a choice when adding new documents or reports to the ODP.
  4. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Your saved entry will be displayed on the Document Type Details page, along with the date and time of your addition and your username.
  6. Use the green back arrow Back Arrow to return to the Document Library Document Types page.

To edit a document type:

  1. On the Document Library Document Types page, click on the hyperlink in the Name column to open the document type you wish to edit.
  2. On the Document Type Details page, click on the edit icon  File Folder  to make the entry editable.
  3. Make your changes.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Document Library Document Types page.

To delete an entry from the Document Library Document Types table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting a document type entry will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete a document type that is being used by any documents or reports.

Locations

The Locations table lists and describes the various locations used for entries in the ODP.  Locations are used in the import templates, and by the NWIS data retriever software (which runs nightly and pulls data streamflow data from the USGS NWIS site and imports it into the ODP database).

To add an entry to the Locations table:

  1. Click on the add button Add Item Button to open the Locations page.
  2. Enter the location Name (mandatory) and select a River system for the location you wish to add.  These fields are mandatory.
  3. Enter other location information as desired.  Note that Location code values match  USGS site numbers (http://help.waterdata.usgs.gov/codes-and-parameters/codes#search_site_no).
  4. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Your saved entry will be displayed on the Location Details page, along with the date and time of your addition and your username.
  6. Use the green back arrow Back Arrow to return to the Locations page.

To edit a location:

  1. On the Locations page, click on the hyperlink in the Name column to open the location you wish to edit.
  2. On the Location Details page, click on the edit icon  File Folder  to make the entry editable.
  3. Make your changes.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Locations page.

To delete an entry from the Locations table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Meeting Attachment Types

The Meeting Attachment Types table lists the sorts of attachments accessible through the ODP.  Meeting attachment types are used to characterize documents attached to meeting materials (see about editing Meeting Details).   

To add an entry to the Meeting Attachment Types table:

  1. Click on the add button Add Item Button to open the Meeting Attachment Type Details page.
  2. Enter a Name for the attachment type you wish to add.
  3. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  4. Your saved entry will be displayed on the Meeting Attachment Type Details page, along with the date and time of your addition and your username.
  5. Use the short codes listed for each meeting type for embedding meeting attachments in external web pages.
  6. Click on the green back arrow Back Arrow to return to the Meeting Attachment Types page.

To edit a meeting attachment type:

  1. On the Meeting Attachment Types page, click on the hyperlink in the Name column to open the attachment type you wish to edit.
  2. On the Meeting Attachment Type Details page, click on the edit icon  File Folder  to make the entry editable.
  3. The Name field is the only editable field; make your changes.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Meeting Attachment Types page.

To delete an entry from the Meeting Attachment Types table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting an attachment type will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete an attachment type that is being used.

Meeting Types

The Meeting Types table contains a list of different types of meetings, e.g., data team, fish working group, TMC, etc.  The terms in this table populate the Meeting Types drop-down list used for adding new meeting materials to the ODP (see about editing Meeting Details).

To add an entry to the Meeting Types table:

  1. Click on the add button Add Item Button to open the Meeting Type Details page.
  2. Enter a Name for the meeting type you wish to add.
  3. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  4. Your saved entry will be displayed on the Meeting Type Details page, along with the date and time of your addition and your username.
  5. Use the short codes listed for each meeting type for embedding meeting attachments in external web pages.
  6. Click on the green back arrow Back Arrow to return to the Meeting Types page.

To edit a meeting type:

  1. On the Meeting Types page, click on the hyperlink in the Name column to open the meeting type you wish to edit.
  2. On the Meeting Type Details page, click on the edit icon  File Folder  to make the entry editable.
  3. The Name field is the only editable field; make your changes.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Meeting Types page.

To delete an entry from the Meeting Types table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting a meeting type will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete an attachment type that is being used.

Organizations

The Organizations table lists the organizations represented in the ODP.  Organizations are used in the Data Sources list (Administrative Tools – General) and in the Users list (Administrative Tools – System Management). Organization are also used in the import templates.

To add an entry to the Organizations table:

  1. Click on the add button Add Item Button to open the Organization Details page.
  2. Enter a Name for the organization (mandatory); add an abbreviation and web site address.
  3. Check the Is Visible for Investigation Plans if you wish the new organization to be available for linking to investigation plans.
  4. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Your saved entry will be displayed on the Organization Details page, along with the date and time of your addition and your username.
  6. Click on the green back arrow Back Arrow to return to the Organizations page.

To edit an organization:

  1. On the Organizations page, click on the hyperlink in the Name column to open the organization entry you wish to edit.
  2. On the Organization Details page, click on the edit icon  File Folder  to make the entry editable.
  3. Make your changes.
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Organizations Types page.

To delete an entry from the Organizations table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting an organization will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete an organization that is being used.

Tags

Tags are used to refine the categorization of documents, meeting materials, and data. The tags entered here populate the drop-down lists in Document Details, Meeting Details, and Data Package Details pages.  The Tags table lists not only the tags, but also the number of times each tag has been assigned to an item in the ODP repository (Number of Associations field).

To add an entry to the Tags table:

  1. On the Tags page, enter a tag name into the text box and click on the add button Add Item Button  to add the new tag.
  2. Your entry will be displayed to the Tags table, along with the date and time of your addition and your username.
  3. New tags are automatically set to be active, i.e., available to users for creating new associations, and the Number of Associations is zero.

To edit or delete an existing tag:

  1. On the Tags page, click on the edit icon  File Folder  beside the tag you wish to edit.
  2. The Name and Active fields are editable.  Make your changes.
  3. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  4. Delete a tag by clicking on the delete icon Trash Can to remove it from the table.  Deleting a tag permanently removes it from the database, as well as all associations to it.

Deleting a tag will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete a tag that is being used.  Any established associations with a deleted tag will also be deleted, but the actual document, meeting, or data package will not.

Units of Measurement

The Units of Measurement table lists the units available for use in entering variable details.

To add an entry to the Units table:

  1. Click on the add button Add Item Button to open the Unit Details page.
  2. Enter a Name for the unit, briefly describe the Unit type, and enter an Abbreviation for the unit (all fields are mandatory).
  3. Save your changes Save icon or cancel Cancel icon to abandon your changes.
  4. Your saved entry will be displayed on the Unit Details page, along with the date and time of your addition and your username.
  5. Click on the green back arrow Back Arrow to return to the Units page.

To edit a unit of measurement:

  1. On the Units page, click on the hyperlink in the Name column to open the unit entry you wish to edit.
  2. On the Unit Details page, click on the edit icon  File Folder  to make the entry editable.
  3. Make your changes (remember, all fields must have content).
  4. When done, save your changes Save icon or cancel Cancel icon to abandon your changes.
  5. Use the green back arrow Back Arrow to return to the Units page.

To delete an entry from the Units table:

  1. Click on the hyperlink in the Name column to open the entry you want to delete.
  2. Click on the delete icon Trash Can to remove the entry.

Deleting a unit of measurement will remove it from any drop-downs in which it was listed.  A warning message will appear if you attempt to delete a unit that is being used in a variable.