DMP Version 1
Reena
Thursday, August 08, 2019
Data Management Plan: Rio Grande Basin Hydrologic Geodatabase Compendium
Backgroud
(Map Source: Bartolino 1979)
usgs <- read.csv("data/usgs.csv")
head(usgs, 3)## Month ATRISCO_1_SP24.79 ATRISCO_2_SP22.79 ATRISCO_3_SP22.79
## 1 1/1/2001 13780000 5260000 17550000
## 2 2/1/2001 37120000 14480000 19430000
## 3 3/1/2001 46190000 17430000 21310000
## ATRISCO_4_SP22.79 BURTON_1_SP30.79 BURTON_2_SP14.79 BURTON_3_SP14.79
## 1 17540000 23620000 20750000 10290000
## 2 3710000 0 29370000 16760000
## 3 5890000 29070000 6660000 15900000
## BURTON_4_SP30.79 BURTON_5_SP37.79 CHARLES_1_SP16.79 CHARLES_2_SP16.79
## 1 20630000 47250000 0 0
## 2 29040000 44950000 0 0
## 3 28430000 67420000 890000 0
## CHARLES_3_SP16.79 CHARLES_4_SP16.79 CHARLES_5_SP33.79 COLLEGE_1_SP23.79
## 1 52130000 46420000 36870000 60000
## 2 44990000 52160000 40830000 30000
## 3 62460000 68490000 50070000 0
## COLLEGE_2_SP23.79 CORONADO_1_SP30.79 CORONADO_2_SP39.79
## 1 10210000 43150000 28310000
## 2 30000 23540000 52970000
## 3 5790000 34120000 56520000
## DURANES_1_SP13.79 DURANES_2_SP13.79 DURANES_3_SP12.79 DURANES_4_SP12.79
## 1 0 0 0 0
## 2 6550000 18880000 10920000 14300000
## 3 12480000 20540000 15600000 8000000
## DURANES_5_SP12.79 DURANES_6_SP12.79 DURANES_7_SP12.79 GONZALES_1_SP39.79
## 1 0 0 0 17450000
## 2 6500000 9250000 6300000 13650000
## 3 5980000 9190000 4930000 16220000
## GONZALES_2_SP36.79 GONZALES_3_SP52.79 GRIEGOS_1_SP13.79
## 1 25020000 0 8870000
## 2 25110000 0 23180000
## 3 30090000 0 30900000
## GRIEGOS_3_SP12.79 GRIEGOS_4_SP12.79 LEAVITT_1_SP17.79 LEAVITT_2_SP17.79
## 1 12150000 7200000 14570000 14370000
## 2 15620000 19380000 6320000 10700000
## 3 22130000 24930000 10360000 8820000
## LEAVITT_3_SP30.79 LEYENDCKR_1_SP13.79 LEYENDCKR_2_SP13.79
## 1 15610000 9170000 10810000
## 2 27790000 3380000 11970000
## 3 45940000 15750000 18810000
## LEYENDCKR_3_SP13.79 LEYENDCKR_4_SP13.79 LOMAS_1_SP14.79 LOMAS_5_SP30.79
## 1 31540000 40750000 21040000 0
## 2 21890000 37890000 29210000 0
## 3 24370000 46990000 35080000 0
## LOMAS_6_SP30.79 LOVE_1_SP13.79 LOVE_3_SP13.79 LOVE_4_SP13.79
## 1 0 0 32930000 41280000
## 2 0 0 1400000 1590000
## 3 0 0 28550000 42010000
## LOVE_5_SP13.53 LOVE_6_SP16.79 LOVE_7_SP16.79 LOVE_8_SP16.79
## 1 0 8920000 21080000 47940000
## 2 0 16750000 35940000 61350000
## 3 0 12430000 29150000 66640000
## METRODETCTR_SP58.79 MILES_1_SP19.65 NM_UTL_1_SP14.79 NM_UTL_2_SP15.79
## 1 NA 22670000 NA NA
## 2 NA 18800000 NA NA
## 3 NA 23320000 NA NA
## NM_UTL_3_SP23.79 NM_UTL_4_SP43.79 NM_UTL_5_SP49.79 NM_UTL_7 NM_UTL_8
## 1 NA NA NA NA NA
## 2 NA NA NA NA NA
## 3 NA NA NA NA NA
## NM_UTL_9 PONDEROSA_2_SP16.79 PONDEROSA_3_SP19.65 PONDEROSA_4_SP21.79
## 1 NA 25440000 20610000 17030000
## 2 NA 40510000 39920000 18440000
## 3 NA 45890000 37690000 20770000
## PONDEROSA_6_SP21.79 RIDGECREST_1_SP15.79 RIDGECREST_2_SP19.79
## 1 9510000 12420000 32190000
## 2 33240000 0 30550000
## 3 41360000 0 32980000
## RIDGECREST_3_SP16.79 RIDGECREST_4_SP16.79 RIDGECREST_5_SP35.79
## 1 23840000 28970000 77210000
## 2 43870000 39500000 71240000
## 3 52730000 62910000 73810000
## SAN_JOSE_1_SP12.58 SAN_JOSE_2A_SP30.79 SAN_JOSE_3A_SP22.79
## 1 1080000 16690000 25680000
## 2 1720000 11050000 15650000
## 3 4140000 19860000 30050000
## SANTABAR_1_SP15.79 THOMAS_1_SP13.79 THOMAS_2_SP13.64 THOMAS_3_SP13.56
## 1 68480000 0 4260000 0
## 2 28110000 4870000 13020000 0
## 3 71940000 24110000 13330000 0
## THOMAS_4_SP13.79 THOMAS_5_SP33.79 THOMAS_6_SP33.79 THOMAS_7_SP33.79
## 1 13990000 32120000 18270000 34140000
## 2 15360000 5650000 20040000 980000
## 3 13210000 33480000 11940000 29990000
## THOMAS_8_SP39.79 VOLANDIA_1_SP14.79 VOLANDIA_2_SP14.79
## 1 17680000 46800000 34590000
## 2 22180000 0 42080000
## 3 12760000 50570000 16120000
## VOLANDIA_3_SP14.79 VOLANDIA_4_SP14.79 VOLANDIA_5_SP14.79
## 1 21250000 5860000 38630000
## 2 11070000 24920000 31470000
## 3 21600000 6600000 37120000
## VOLANDIA_6_SP14.79 VOLCLIFFS_1_SP16.79 VOLCLIFFS_2_SP16.79
## 1 35620000 0 21620000
## 2 20570000 0 17280000
## 3 35320000 0 19460000
## VOLCLIFFS_3_SP30.79 WALKER_1_SP28.79 WALKER_2_SP31.79 WALKER_3_SP44.79
## 1 35670000 10730000 5800000 0
## 2 7580000 12550000 30530000 0
## 3 18900000 7110000 43310000 0
## WALKER_4_SP44.79 WEBSTER_1_SP23.79 WEBSTER_2_SP23.79 WEST_MESA_1_SP13.79
## 1 24680000 30070000 11110000 7270000
## 2 2290000 35730000 250000 7840000
## 3 8420000 18720000 31670000 3780000
## WEST_MESA_3_SP16.54 WEST_MESA_4_SP17.69 YALE_1_SP17.79 YALE_2_SP16.79
## 1 0 47220000 33100000 900000
## 2 0 31340000 18280000 5990000
## 3 0 45050000 42460000 9520000
## YALE_3_SP16.79 ZAMORA_1_SP39.79 ZAMORA_2_SP49.79
## 1 7330000 12450000 46170000
## 2 9360000 26270000 67210000
## 3 15930000 33710000 73230000This dataset has 202 samplings sites.
plot(faithful, main = "Do I wait longer for longer eruptions?")
1 Types of Data Produced
1.This project will result in the production of a relational spatially-enabled database integrating all known surface water, ground water, and water quality data for the middle Rio Grande basin study area. Additionally, Visual Basic for Applications (VBA) code and Structured Query Language (SQL) code are products of the project.
All updateable datasets are acquired from the original data source (for example, EPA websites).
Updatable data sources are acquired at specified intervals – quarterly, or as needed. As new static data sources are discovered, they will be integrated into the proposed compendium. -Data will be processed using dataset‐specific VBA programs. -Program file comment headers will be included in the code to explain required input variables, purpose of the program, and requirements needed by the user. -Code will be annotated to promote code readability.
1.1 Subheading for section 2
1.1.1 Subheding for sectio 2.1
2 Data and Metadata Standards
Microsoft Access Database format will be used since it is readily-accessible and it is compatible with ESRI ArcGIS, a Geographic Information System software package used by the stakeholders. Naming conventions will be consistent – no spaces will be used in table names or field names. The file naming convention will consist of the data source_data type format for raw data files. Data reporting functionality will be built into the VBA processing programs to provide output in .txt file format for number of records per source when updatable data sources are refreshed.
Every effort will be made to go back to the authoritative source for an identified dataset. Quality control of the database will be performed using SQL statements that capitalize on the database structure to ensure relational database integrity. Appropriate primary keys will be assigned to manage possible data duplicates. Potential duplicate site IDs, will be handled through automated procedures and the creation of alternate ID tables.
A data dictionary will be created that defines the table definition, table fields, and table field data types. An entity-relationship diagram will be created that defines the relational structure of the database. A metadata record will be produced using the FGDC standard that describes the entire geodatabase.
3 Policies for Access and Sharing
1.The data are public and will be obtainable thru the New Mexico Interstate Stream Commission (NMISC). Users of the data will primarily be water resource managers in the Rio Grande Basin. USGS publications will be released describing the methods and data sources and can be used as documentation for the data and to cite the data.
4 Policies for Re-use, Distribution
- Access to databases and associated software tools generated under the project will be available for educational, research and non-profit purposes. Such access will be provided using web-based applications, as appropriate.
2.Materials generated under the project will be disseminated in accordance with University/Participating institutional and NSF policies. (see, for example, Briney, Goben, and Zilinski 2015). Depending on such policies, materials may be transferred to others under the terms of a material transfer agreement.
The data files have a suggested citation, which will be described in the metadata in addition to the USGS publications.
5 Plans for Archiving and Preservation
All original raw data files and data source processing programs will be versioned over time and maintained in a date-stamped file structure with text files documenting the provenance. The database will be preserved in perpetuity, housed initially at the New Mexico Interstate Stream Commission Central Office in addition to an off-site copy maintained at an NMISC field office and mirrored at the Consortium of Universities for the Advancement of Hydrologic Science (CUAHSI). We will also identify appropriate archiving institutions that might serve as a mirror repository. A data policy and stewardship plan will be established. In addition to archiving, each database table will be exported to a delimited text format to ensure accessibility of the data by other software programs. The data manager at the NMISC will be responsible for the management of long-term storage and archived data.
6 Distribution Rights
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
References
Bartolino, Bart. 1979. “Map of the Middle Rio Grande Basin.”
Briney, Kristin, Abigail Goben, and Lisa Zilinski. 2015. “Do You Have an Institutional Data Policy? A Review of the Current Landscape of Library Data Services and Institutional Data Policies.” Journal of Librarianship and Scholarly Communication 3 (2). Pacific University Library. doi:10.7710/2162-3309.1232.
The FGDC standard was chosen due to required Federal government standards.↩