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


Table of Contents

Background

List of Physical Attribute Names

Horizontal Data Attribute Definitions

Vertical Data Attributes

Original Data Collection Attributes

Tracking Data Attributes

Reference Source Documents

Accuracy Information Table


Background

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:


List of Physical Attribute Names

* Denotes Mandatory Attributes

** Denotes Mandatory Attributes for Vertical Data

Horizontal 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

 

Vertical Data

** 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

 

Original Data Collected

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

 

Tracking Data

* 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


Horizontal Data Attribute Definitions


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:


Vertical Data Data Attribute Definition


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:


Original Data Collection Data Attribute Definition


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:


Tracking Data Attributes

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:


Reference Source Documents:


Acuracy Information Table

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