California State Water Resources Control Board

[Pages:35]California State Water Resources Control Board

TM

Survey XYZ, Well Data, and Site Map Guidelines & Restrictions

Electronic Deliverable Format and Data Dictionary

Revision 6.1 April, 2005

Web site:

Table of Contents

ACRONYMS .................................................................................................................................. IV

1 INTRODUCTION.................................................................................................................... 1

1.1 Document Conventions .................................................................................................. 2 1.1.1 Figure Representation of Files ...................................................................................... 2 1.1.2 Table Representation of GeoTracker Survey_XYZ EDD Files .................................... 3 1.1.3 Conventions for Text...................................................................................................... 4

1.2 Valid Values (VVLs) ......................................................................................................... 4

2 DATA DELIVERABLE DESCRIPTION ................................................................................ 5

3 RELATIONAL FILES FORMAT............................................................................................ 6

3.1 GEO_XY: The Location Measurement File ................................................................... 6 3.1.1 File Guidelines and Restrictions:................................................................................... 7 3.1.2 The GEO_XY File Format ............................................................................................. 8 3.1.3 Valid Value Lists for GEO_XY..................................................................................... 10 3.1.4 Limitations of Several XY Data Collection Methods ................................................... 13

3.2 GEO_Z: The Elevation Measurement File................................................................... 14 3.2.1 File Guidelines and Restrictions:................................................................................. 14 3.2.2 The GEO_Z File Format.............................................................................................. 15 3.2.3 Valid Value Lists for GEO_Z ....................................................................................... 17

3.3 GEO_WELL: Groundwater Well Measurement File................................................... 18 3.3.1 File Guidelines and Restrictions:................................................................................. 18 3.3.2 The GEO_WELL File Format ...................................................................................... 19 3.3.3 Valid Value Lists for GEO_WELL................................................................................ 20

3.4 GEO_MAP: The Site Map File....................................................................................... 21

4.0 SUBMITTAL FILE, RECORD, AND DATA FIELD REQUIREMENTS ......................... 21

4.1 Submittal File Requirements ........................................................................................ 21

4.2 Submittal Data Field Requirements............................................................................. 22 4.2.1 Tab Delimited Formats ................................................................................................ 22 4.2.2 Comma Delimited Format ........................................................................................... 23 4.2.3 Fixed Length Format ................................................................................................... 23

4.3 Procedure for EDD Submittal....................................................................................... 23

APPENDIX A: GLOSSARY OF TERMS .............................................................................. 24

GeoTracker Survey_XYZ Guidelines & Restrictions

i

Rev. 6.1 April, 2005

List of Tables

Table 1: GEO_XY Format .......................................................................................................8 Table 2: XY_FIELD_PT_CLASS valid values.................................................................... 10 Table 3: XY_METHOD valid values.................................................................................... 11 Table 4: XY_DATUM valid values....................................................................................... 11 Table 5: GEO_Z Format....................................................................................................... 15 Table 6: ELEV_METHOD valid values ............................................................................... 17 Table 7: ELEV_DATUM valid values.................................................................................. 17 Table 8: GEO_WELL Format............................................................................................... 19 Table 9: STATUS valid values ............................................................................................ 20 Table 10: SHEEN valid values ............................................................................................ 20

GeoTracker Survey_XYZ Guidelines & Restrictions

ii

Rev. 6.1 April, 2005

List of Figures

Figure 1: Data Flow for GeoTracker Survey_XYZ Deliverable ................................. 1 Figure 2: Relational Structure of GeoTracker Survey_XYZ Files.............................. 5

GeoTracker Survey_XYZ Guidelines & Restrictions

iii

Rev. 6.1 April, 2005

Acronyms

CSV EDD EDF GIS GPS LUST PK RP SWRCB UST VVL

Comma Separated Values (also known as comma/quote delimited) Electronic Data Deliverable Electronic Deliverable Format Geographic Information System Global Positioning System Leaking Underground Storage Tank Primary Key Responsible Party (California) State Water Resources Control Board Underground Storage Tank Valid Value List

GeoTracker Survey_XYZ Guidelines & Restrictions

iv

Rev. 6.1 April, 2005

1 Introduction

In September 2004, the State Water Resources Control Board (SWRCB) adopted regulations that require electronic submittal of information (ESI) for groundwater cleanup programs. These regulations gained approval from the Office of Administrative Law (OAL) in November 2004. For several years, parties responsible for cleanup of leaks from underground storage tanks (LUST) have been required to submit groundwater analytical data, the surveyed locations of monitoring wells, and certain other data to the SWRCB's GeoTracker database over the internet. Beginning January 1, 2005, electronic submittal of these items and a portable data format (PDF) copy of the full report is being extended to include all SWRCB groundwater cleanup programs including the LUST, non-LUST (SLIC), Department of Defense (DOD), and Chapter 15 land disposal programs. These regulations also added new data dictionaries (the format for electronic data submittals) to Title 27, CCR, in coordination with existing Cal/EPA Unified Program data dictionaries.

The GeoTracker Survey_XYZ electronic data deliverable (EDD) consists of X, Y, and Z coordinates measurement data, and groundwater well measurement data. This deliverable is intended to be produced by the Responsible Party (or their consultant) and to be imported into the GeoTracker system via Internet. The GeoTracker Survey_XYZ data, when uploaded into the SWRCB GeoTracker database, will provide essential information pertaining to groundwater and soil sampling points.

GeoTracker

Integrated GIS Data Warehouse

Lead Agency receives data

Holding Database

Secure GeoTracker Pages for Data Submission GEO_XY GEO_Z GEO_WELL SITE_MAP

Responsible Parties

Figure 1: Data Flow for the GeoTracker Survey_XYZ Deliverable

GeoTracker Survey_XYZ Guidelines & Restrictions

1

Rev. 6.1 April, 2005

1.1 Document Conventions

This document presents the structure and guidelines and restrictions for creating GeoTracker Survey_XYZ electonic data deliverables. Each data file of the deliverable is discussed in a level of detail that assists the user in creating an electronic deliverable that meets the criteria of the data standard. Included is a discussion of guidelines and restrictions that apply to files and those that apply to individual fields.

1.1.1 Figure Representation of Files Each file discussion begins with a figure representing the fields in the file. Refer to Error! Reference source not found. as an example. The fields are listed in the order in which they exist within the structure, and primary key fields are underlined. "Primary key" means a selected field (or fields in combination) that makes a record unique in a database. Refer to the Glossary in Appendix B for a technical definition of this and other terms. The order of the fields in the figure is the order expected for delivery.

GeoTracker Survey_XYZ Guidelines & Restrictions

2

Rev. 6.1 April, 2005

1.1.2 Table Representation of GeoTracker Survey_XYZ EDD Files

The following table is a representation of the tables defining files of the GeoTracker Survey_XYZ.

Field Name

NAME1

Attrb VVL C18 Yes

RE Dscr. Q Name Definition

Yes Field 1

NAME2 D10 No Yes Field 2

NAME3 N5 No No Field 3

Guidelines & Restrictions

Field 1 is a character field with 18 available positions. Field 2 is a date field with an expected format of MM/DD/YYYY.

Field 3 is a numeric field with a total of 5 spaces available for numbers and decimals, with no restriction on the number of digits to the right of the decimal point other than the overall field size.

The "Field Name" is the actual structural name of the field. All primary key fields are shaded within these tables (e.g., FIELD1 and FIELD2). Primary key fields are identified within the tables by shading. Fields are listed in their structural order within these tables.

"Attrb" describes the field attributes (type and size). For example: ? C18 is an 18-character field (alphanumeric). ? D10 is a date field with an expected format of MM/DD/YYYY (i.e., 01/01/2001). ? N5 is a numeric field with a total of 5 spaces available for numbers and decimals, with no restriction on the number of digits to the right of the decimal point other than the overall field size (e.g., 12345 or 123.4 or 1.234).

The "VVL" column indicates with a "Yes" or "No" whether the data field requires a valid value code.

The "REQ" column indicates with a "Yes" or "No" whether entry into a field is required.

The "Dscr. Name" column gives the descriptive name of the field.

The "Definition" is a brief definition and/or explanation of the field.

The "Guidelines & Restrictions" describe expectations for entry into the field.

GeoTracker Survey_XYZ Guidelines & Restrictions

3

Rev. 6.1 April, 2005

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download