  |
|
|
Ecology Home > Core Services > GIS Home > GIS Data > GIS Standards > Spatial Point Attributes
Standards for Spatial Point Attributes Stored in Non-Spatial Databases |
Washington State Department of Ecology
IIP GIS Data Standards Project
IS Council GIS Work Group
November 21, 1995
Updated February 13, 1996
List of Physical Attribute Names
Horizontal Data Attribute Definitions
Vertical Data Attributes
Original Data Collection Attributes
Tracking Data Attributes
Ecology databases should support the following spatial features and address methods throughout agency level database systems. This structure will insure: consistency; understanding; and ease of integration between both tabular and geospatial data systems.
A spatial address refers to the geographic point location of an object, and is used to define the point of that object or "Ecology thing" that information is being collected about (e.g. well, spill, facility).
The standard of point data collection method is in latitude-longitude degrees, minutes, seconds. This allows one standard way to collect and report information within the agency. This suggested format will provide the agency with greater pay back in uniformity, ease of data comparison and compilation, and lessen the storage of redundant data.
Physical Database Implementation
Physical Database Implementation Assumptions:
A unique or system generated identifier (ID) is required for each record stored in the tabular database (external to ArcInfo). It is suggested that a unique identifying system be established for the "object" being tracked. If you're interested in finding out if a unique identifier already exists for the object you're tracking, or to learning more about establishing one then contact your programs GIS representative or agency Data Administration.
It is assumed that an explicit description is being collected and carried in the tabular database (external to ArcInfo). It is important that a description is available for the "object" that's being tracked. This attribute field will describe the geographic characteristics of the map feature you wish to map.
Physical edit check or validation procedures should be established and run against the coordinate values and other attributes prior to being committed to the database system(s).
Acknowledgments
The GIS Standards Work Group was responsible for the development of the following GIS standards for the Department of Ecology. Participants included:
Chairperson:
Participants:
Reviewers:
* Denotes Mandatory Attributes
** Denotes Mandatory Attributes for Vertical Data
* Coordinate Point Latitude Degrees Number COORD_LAT_DEG_NR
* Coordinate Point Latitude Minutes Number COORD_LAT_MIN_NR
* Coordinate Point Latitude Seconds Number COORD_LAT_SEC_NR
* Coordinate Point Longitude Degrees Number COORD_LONG_DEG_NR
* Coordinate Point Longitude Minutes Number COORD_LONG_MIN-NR
* Coordinate Point Longitude Seconds Number COORD_LONG_SEC-NR
* Coordinate Point Horizontal Accuracy Code COORD_HOR_ACCU_CD
* Coordinate Point Horizontal Datum Code COORD_HOR_DTM_CD
* Coordinate Point Horizontal Collection Method CodeCOORD_HOR_COLL_METH_CD
* Coordinate Point Area Extent Code COORD_XTNT_CD
* Coordinate Point Geographic Position Code COORD_GEOG_POSN_CD
* Coordinate Point Source Scale Code COORD_SRC_SCL_CD
** Coordinate Point Vertical Datum Code COORD_VERT_DTM_CD
** Coordinate Point Vertical Reference Code COORD_VERT_REF_CD
** Coordinate Point Vertical Measurement Number COORD_VERT_MEAS_NR
** Coordinate Point Vertical Collection Method Code COORD_VERT_COLL_METH_CD
** Coordinate Point Vertical Accuracy Code COORD_VERT_ACCU_CD
** Coordinate Point Vertical Units Code COORD_VERT_UNT_CD
Coordinate Point Original Horizontal Datum Code COORD_ORIG_HOR_DTM_CD
Coordinate Point Original Provider Code COORD_ORIG_PROV_CD
Coordinate Point Original X Measurement Number COORD_ORIG_X_MEAS_NR
Coordinate Point Original Y Measurement Number COORD_ORIG_Y_MEAS_NR
Coordinate Point Original Reference System Code COORD_ORIG_REF_SYS_CD
Coordinate Point Original Reference Zone Code COORD_ORIG_REF_ZN_CD
Coordinate Point Original XY Units Code COORD_ORIG_XY_UNT_CD
* Coordinate Point Spatial Object Code COORD_SPATL_OBJ_CD
* Coordinate Point Provider Code COORD_PROV_CD
* Coordinate Point Last Update Date COORD_LAST_UPDATE_DT
* Coordinate Point Verified Initial Name COORD_VRY_INIT_NM
* Coordinate Point Verified Code COORD_VRY_CD
Full Logical Name: Coordinate Point Latitude Degrees Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the earth's equator as it's origin. An angular quantity expressed in degrees. The first of the three quantities that comprise the full latitude coordinate. Note: all coordinate information collected in Ecology database systems are reflected in positive values.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LAT_DEG_NR
Field Width: 2
Field Type: numeric
Codes: n/a
Value Range: 0 - 90
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Latitude Minutes Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the earth's equator as it's origin. An angular quantity expressed in minutes. The second of the three quantities that comprise the full latitude coordinate.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LAT_MIN_NR
Field Width: 2
Field Type: numeric
Codes: n/a
Value Range: 0 - 59
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Latitude Seconds Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the earth's equator as it's origin. An angular quantity expressed in seconds. The third of the three quantities that comprise the full latitude coordinate.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LAT_SEC_NR
Field Width: 2.2
Field Type: floating point
Codes: n/a
Value Range: 0.00 - 59.99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Longitude Degrees Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the prime meridian (through Greenwich, England) as it's origin. An angular quantity expressed in degrees. The first of the three quantities that comprise the full longitude coordinate.
Entity: Coordinate Point (COORD)
Item Name (abbreviated): COORD_LONG_DEG_NR
Field Width: 3
Field Type: numeric
Codes: n/a
Value Range: 0 - 180
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Longitude Minutes Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the prime meridian (Greenwich, England) as it's origin. An angular quantity expressed in minutes. The second of the three quantities that comprise the full longitude coordinate.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LONG_MIN_NR
Field Width: 2
Field Type: numeric
Codes: n/a
Value Range: 0 -59
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Longitude Seconds Number
Definition: Ellipsoidal coordinate representation that shows location on the earth's surface using the prime meridian (Greenwich, England) as it's origin. An angular quantity expressed in seconds. The third of the three quantities that comprise the full longitude coordinate.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LONG_SEC_NR
Field Width: 2.2
Field Type: floating point
Codes: n/a
Value Range: 0.00 - 59.99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Horizontal Accuracy Code
Definition: Describes the correctness of a measurement and its relative rank or position. Describes the closeness of the result of observation, computation, or estimates to the true value on the ground or the value being accepted as being true.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_HOR_ACCU_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | > 1/100 meter |
| 2 | < 1/10 meter and >= 1/100 meter |
| 3 | <1 meter and >= 1/10 meter |
| 4 | +- 10 feet (3 meters) |
| 5 | +- 20 feet (6 meters) |
| 6 | +- 40 feet (12 meters) |
| 7 | +- 100 feet (35 meters) |
| 8 | +- 180 feet (55 meters) |
| 9 | +- 250 feet |
| 10 | +- 500 feet |
| 11 | +- 1000 feet |
| 12 | +- 2000 feet |
| 13 | greater than 2000 feet |
| 99 | Unknown |
Value Range: 1 - 13 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Horizontal Datum Code
Definition: A point, line or surface used as a reference in mapping. Spheroid to which the earth's surface has been orthogonally transferred. Agency data collection standard is NAD83 ('91 adj).
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_HOR_DTM_CD
Field Width: 1
Field Type: numeric
Codes:
| 1 | North American Datum 1983 ('91 adj.) - NAD83 |
Value Range: 1
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Horizontal Collection Method Code
Definition: The manner used to collect the horizontal coordinates of an object. source materials How the measurement/value was obtained.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_HORZ_COLL_METH_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Address Matching - Block Face |
| 2 | Address Matching - House Number |
| 3 | Address Matching - Street Centerline |
| 4 | Address Matching - Unknown |
| 5 | Aerial Photography - Rectified |
| 6 | Aerial Photography - Unknown |
| 7 | Aerial Photography - Unrectified |
| 8 | Cadastral Survey |
| 9 | Census Block 1990 Centroid |
| 10 | Census Block Group 1990 Centroid |
| 11 | Conversion from Township/Section/Range (STR) |
| 12 | Digital or manual raw photo extraction |
| 13 | Digitized off CRT screen/digital data |
| 14 | Digitized from paper map |
| 15 | Global Positioning System (GPS) - Carrier/Geodetic |
| 16 | Global Positioning System (GPS) - Code/Geodetic |
| 17 | Global Positioning System (GPS) - Kinematic |
| 18 | Global Positioning System (GPS) - Unknown |
| 19 | Hand measured - paper map (map interpolation) |
| 20 | LORAN-C |
| 21 | Orthophotography - digital |
| 22 | Orthophotography - paper |
| 23 | Satellite Imagery - Landsat MSS (Multi-Spectral Scanning) |
| 24 | Satellite Imagery - Landsat TM (Thematic Mapper 30m) |
| 25 | Satellite Imagery - Other |
| 26 | Satellite Imagery - SPOT Panchromatic 10m |
| 27 | Satellite Imagery - SPOT Multi Spectral 30m |
| 28 | ZIP Code Centroid |
| 99 | Unknown |
Value Range: 1 - 28 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Area Extent Code
Definition: Provides a general description of the size or extent of the point feature being mapped.
Entity: Coordinate point (COORD) - associative entity
Item Name (abbreviated): COORD_XTNT_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Large facility/complex or area > than 10 acres |
| 2 | Small facility/complex or area > than 1 acre or < 10 acres |
| 3 | Large building or area > than 5000 sq. ft |
| 4 | Small building or area < than 5000 sq. ft |
| 5 | Crossing or intersection of two features e.g. bridge & stream |
| 6 | Small object or area < 10 sq. ft e.g. well |
| 99 | unknown |
Value Range: 1 - 6 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Geographic Position Code
Definition: Provides a general description of where the point feature being mapped resides in relationship to the ground.
Entity: Coordinate point (COORD) - associative entity
Item Name (abbreviated): COORD_GEOG_POSN_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Centroid of Section Township Range unit |
| 2 | Centroid of Section Township Range Quarter section |
| 3 | Centroid of Section Township Range QQ sections |
| 4 | Centroid of Section Township Range QQQ section |
| 5 | Facility/Site Centroid |
| 6 | NE Corner of Land Parcel |
| 7 | NW Corner of Land Parcel |
| 8 | Plant Entrance |
| 9 | SE Corner of Land Parcel |
| 10 | Street Address |
| 11 | SW Corner of Land Parcel |
| 21 | Stream center |
| 22 | Near left bank |
| 23 | Near right bank |
| 24 | Monitoring station |
| 99 | Unknown |
Value Range: 1 - 11, 21 - 24, and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):Access Restrictions:
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Source Scale Code
Definition: The scale of the source base map used to gather the horizontal/vertical coordinates. The density of the natural features being displayed on the base map will vary based on the map scale.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_SRC_SCL_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Not applicable |
| 2 | 1:500,000 |
| 3 | 1:250,000 |
| 4 | 1:125,000 |
| 5 | 1:100,000 |
| 6 | 1:63,360 |
| 7 | 1:62,500 |
| 8 | 1:50,000 |
| 9 | 1:25,000 |
| 10 | 1:24,000 |
| 11 | 1:20,000 |
| 12 | 1:15,840 |
| 13 | 1:10,000 |
| 14 | 1:12,000 |
| 15 | 1:25,001 - 1:50,000 |
| 16 | 1:50,001 - 1:100,000 |
| 17 | 1:20,001 - 1:25,000 |
| 18 | 1:15,001 - 1:20,000 |
| 19 | 1:10,000 - 1:15,000 |
| 20 | 1:5,001 - 1:10,000 |
| 21 | 1:501 - 1:5,000 |
| 22 | >= 1:500 |
| 23 | less than 1:500 |
| 99 | Unknown |
Value Range: 1 - 23 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Accuracy Code
Definition: Describes the correctness of a measurement and its relative rank or position. Describes the closeness of the result of observation, computation, or estimates to the true value on the ground or the value being accepted as being true.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VERT_ACCU_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | < 1/100 meter |
| 2 | >= 1/100 meter & < 1/10 meter |
| 3 | >= 1/10 meter & < 1 meter |
| 4 | +- 10 feet (3 meters) |
| 5 | +- 20 feet (6 meters) |
| 6 | +- 40 feet (12 meters) |
| 7 | +- 100 feet (35 meters) |
| 8 | +- 180 feet (55 meters) |
| 9 | +- 250 feet |
| 10 | +- 500 feet |
| 11 | +- 1000 feet |
| 12 | +- 2000 feet |
| 13 | Greater than 2000 feet |
| 99 | Unknown |
Value Range: 01- 13 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Datum Code
Definition: A code describing the reference datum for the elevation.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VERT_DTM_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | North American Vertical Datum 1988 - NAVD88 |
| 2 | North American Veritcal Datum 1929 - NGVD29 |
| 3 | WGS84 (GPS NAVD88) |
| 99 | Unknown |
Value Range: 1 - 3 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Reference Code
Definition: Describes the vertical reference point from which the vertical measurement is taken. Reference point of the elevational position on the earth's surface.
Item Name (abbreviated): COORD_VERT_REF_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Elevation from mean sea level |
| 2 | Elevation from mean high water |
| 3 | Elevation from mean higher high water |
| 4 | Elevation from mean low water |
| 5 | Elevation from mean lower low water |
| 6 | Local tidal datum |
| 7 | Highest Tide |
| 8 | Mean (half) Tide |
| 9 | Lowest Tide |
| 10 | Other |
| 99 | Unknown |
Value Range: 1 - 10 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Measurement Number
Definition: The number of meters or feet above or below the vertical reference point where the latitude/longitude was measured. This value is negative below ground level.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VERT_MEAS_NR
Field Width: 7.3
Field Type: floating point
Codes: n/a
Value Range: 0000000.000 - 9999999.999 (positive and negative values)
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Units Codes
Definition: The unit of measure used when collecting the vertical (Z) value.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VERT_UNT_CD
Field Width: 1
Field Type: numeric
Codes:
| 1 | Feet |
| 2 | Meters |
Value Range: 1 - 2
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Vertical Collection Method Code
Definition: The manner used to collect the vertical coordinate. How the measurement or value was obtained.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VERT_COLL_METH_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Bathymetric Sounding |
| 2 | Cadastral Survey |
| 3 | Derived from Digital Elevation Model (DEM) |
| 4 | Global Positioning System (GPS) - Code/Geodetic |
| 5 | Global Positioning System (GPS) - Carrier/Geodetic |
| 6 | Global Positioning System (GPS) - Kinematic |
| 7 | Global Positioning System (GPS) - unknown |
| 8 | Hand Measures (e.g. tape) |
| 9 | Map Derived |
| 10 | Other Engineering Survey |
| 11 | Photogrammetric Survey |
| 99 | Unknown |
Value Range: 1 - 11 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restriction:
Full Logical Name: Coordinate Point Original Horizontal Datum Code
Definition: A point, line or surface used as a reference in mapping. Spheroid to which the earth's surface has been orthogonally transferred. References the original input point coordinate collected by business representatives.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_HOR_DTM_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | North American Datum 1927 - NAD27 |
| 2 | North American Datum 1983 ('91 adj.) - NAD83 |
| 3 | HARN |
| 4 | WGS84 (GPS NAVD88) |
| 99 | Unknown |
Value Range: 1 - 4 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original Provider Code
Definition: Identifies the party responsible for collecting or otherwise providing the original X, Y, or Z values.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_PROV_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Private Citizen or Stakeholder |
| 2 | Volunteer |
| 3 | Dun & Bradstreet (Corporate ID) |
| 4 | Federal Agency (USGS, EPA etc.) |
| 5 | Tribe |
| 6 | Regulated Entity or Client (including contractors hired by that entity) |
| 7 | Ecology (including contractor hired by Ecology) |
| 8 | State Agency (other than Ecology) |
| 9 | Local government (County, City, Metro) |
| 10 | Other |
| 99 | Unknown |
Value Range: 1 - 10 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original X Measurement Number
Definition: The spatial address of an object, it corresponds to the conventional Cartesian coordinates. The X (latitude) measurement is one of two horizontal components needed to form the spatial address. It references the original input value.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_X_MEAS_NR
Field Width: 12.3
Field Type: floating point
Codes: n/a
Value Range: 0.000 - 999999999999.999
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original Y Measurement Number
Definition: The spatial address of an object, it corresponds to the conventional Cartesian coordinates. The Y (latitude) measurement is one of two horizontal components needed to form the spatial address. It references the original input value.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_Y_MEAS_NR
Field Width: 12.3
Field Type: floating point
Codes: n/a
Value Range: 0.000 - 99999999.999
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original Reference System Code
Definition: Identifies the spatial reference system used when collecting the original XY spatial address.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_REF_SYS_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Washington State Plane Coordinate System (SPCS) |
| 2 | Oregon State Plane Coordinate System (SPCS) |
| 3 | Idaho State Plane Coordinate System (SPCS) |
| 4 | Universal Transverse Mercator Grid System (UTM) |
| 5 | Latitude and Longitude (Lat/Long) |
Value Range: 1 - 5
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original Reference Zone Code
Definition: The spatial reference systems designated zone. Where the original XY coordinate pair (or spatial address) falls in relationship to that system.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_REF_ZN_CD
Field Width: 1
Field Type: numeric
Codes:
| 1 | WA North Zone (SPCS) |
| 2 | WA South Zone (SPCS) |
| 3 | OR North Zone (SPCS) |
| 4 | OR South Zone (SPCS) |
| 5 | ID East Zone (ID SPCS) |
| 6 | ID West Zone (ID SPCS) |
| 7 | ID Central Zone(ID SPCS) |
| 8 | Zone 10 (UTM) |
| 9 | Zone 11 (UTM) |
| 10 | Zone 12 (UTM) |
| 11 | Not applicable |
Value Range: 1 - 11
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Original XY Units Codes
Definition: The unit of measure used when collecting the original XY spatial address.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_ORIG_XY_UNT_CD
Field Width: 1
Field Type: numeric
Codes:
| 1 | Feet |
| 2 | Meters |
| 3 | Degrees/Minutes/Seconds |
| 4 | Decimal Degrees |
| 5 | Decimal Seconds |
Value Range: 1 - 5
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Data Attribute Definition
Full Logical Name: Coordinate Point Spatial Object Code
Definition: What the point occurrence represents on the ground. The geographic spatial data type -- Point, Line, Area, Volume.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_SPATL_OBJ_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Point (well, point of diversion, storage tank) |
| 2 | Line (in stream spill) |
| 3 | Area (polygon - large facility) |
| 4 | Volume (ground water plume) |
| 99 | Unknown |
Value Range: 1 - 4 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Provider Code
Definition: Identifies the party responsible for collecting or otherwise providing the X, Y, or Z values.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_PROV_CD
Field Width: 2
Field Type: numeric
Codes:
| 1 | Private Citizen or Stakeholder |
| 2 | Volunteer |
| 3 | Dun & Bradstreet (Corporate ID) |
| 4 | Federal Agency (USGS, EPA etc.) |
| 5 | Tribe |
| 6 | Regulated Entity or Client (including contractors hired by that entity) |
| 7 | Ecology (including contractor hired by Ecology) |
| 8 | State Agency (other than Ecology) |
| 9 | Local government (County, City, Metro) |
| 10 | Other |
| 99 | Unknown |
Value Range: 1 - 10 and 99
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Verified by Initial Name
Definition: The agency identifier of the person who last changed the geographic coordinate location field(s).
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VRY_INIT_NM
Field Width: 7
Field Type: character
Codes:
Value Range:
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Verified Code
Definition: A Yes/No variable showing whether the coordinate location has been verified through standard quality assurance / quality control (QA/QC) procedures.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_VFY_CD
Field Width: 1
Field Type: numeric
Codes:
| 1 | Yes |
| 2 | No |
Value Range: 1 - 2
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
Full Logical Name: Coordinate Point Last Update Date
Definition: The date when the geographic coordinate location was last changed.
Entity: Coordinate Point (COORD) - associative entity
Item Name (abbreviated): COORD_LAST_UPDT_DT
Field Width: 8
Field Type: date
Codes: n/a
Value Range:
Minimum/Maximum Attribute Occurrence/Entity:
Primary Key Candidate:
Synonym(s):
Components/Derivation Method:
Access Restrictions:
This information is meant to assist staff in input the correct accuracy code for location of point data. When you collect a latitude and longitude location for a feature in your database, you are also asked to provide information showing how accurate that location is. The Accuracy Code column shows your choices in the Coordinate Point Accuracy Level Code field. The Corresponding Collection Methods column describes some of the most common methods used to get an accuracy of that level. If you are using a 7.5' Quad map to get your location, the Measurement Error column shows how close you need to get to the true location to get that accuracy code.
7.5' Quad Accuracy Code Corresponding Collections Methods Measurement Errors
| 1 | < 3.33 feet (1 meter) GPS with Differential calculation and Ground Stations |
| 2 | +- 10 feet (3 meters) GPS with Open Forest Canopy or with Closed Canopy and Differential |
| 3 | +- 20 feet (6 meters) GPS with no error correcting or ground stations |
| 4 | +- 40 feet (12 meters) USGS 7.5' Quad Sheet or other 1:24,000 scale map data (feature printed on map) .02 inches |
| 5 | +- 100 feet (35 meters) USGS 15' Quad Sheet or other 1:48,000 scale map data (feature printed on map) .05 inches |
| 6 | +- 180 feet (55 meters) USGS 1:100,000 Scale Sheet or other 1:100K data (feature printed on map) .09 inches |
| 7 | +- 250 feet to nearest Quarter/Quarter/Quarter Section (10 acres) 263 feet 0.125 inches |
| 8 | +- 500 feet to nearest Quarter/Quarter Section (40 acres) 526 feet 0.25 inches |
| 9 | +- 1000 feet to nearest Quarter Section (160 acres) 1053 feet 0.5 inches |
| 10 | +- 2000 feet to nearest Section (640 acres) 2106 feet 1 inch |
| 11 | > 2000 feet |
| 12 | < 1/10 meter and > 1/100 meter Engineering Survey |
| 13 | < 1/100 meter Engineering Survey |
| 99 | Unknown |
Sources of Information for Collection Method Accuracies
Codes 1,2,3 Based on Vendor GPS information. Will vary depending on type of GPS Unit and method of differential calculation used.
Codes 4,5,6 These accuracies assume that the feature you are locating is printed on the map. When locating a feature that is not printed on the map (e.g. a water right ) by using the neighboring map features (streams, roads, section lines, topo), you will be less accurate.
The Facility/Site BSD meeting on 9/11/95 estimated that a person was likely to be within 1/8 inch when locating non-printed features from a 7 1/2" quad map, which would translate to a +-250 foot error.
Codes 7 through 10 calculated by Mel Schaefer's formula SQRT( .5/pi * (A)) where A = area in square feet and pi = 3.1417.
Page revised: Wednesday, September 23, 2009
Copyright © Washington State Department of Ecology. See http://www.ecy.wa.gov/copyright.html.
