FRS Geospatial Return File Format

System Data Searches

The Geospatial Return File Format is available to regions and states: and they are encouraged to submit latitude and longitude coordinates for use in Envirofacts mapping applications.
These coordinates are stored in the Geospatial Reference Tables.

The files returned from the EPA regions must be in a Fixed ASCII format. Fixed format means that fields should correspond in order and length to the data elements listed below and should not be separated by a delimiter. Address matched records should have actual address field values that reflect the address used to geocode the facility. In other words, if the actual address used to geocode a facility differs from the address that the facility is listed at, the geocoded address values are to be placed in the address fields.

NOTE: Records that do not contain the 4 required fields (PGM_SYS_ACRNM, PGM_SYS_ID, LATITUDE, LONGITUDE) and are not in the fixed file format as described below cannot be placed in the Geospatial Reference Tables.

PGM_SYS_ACRNM and PGM_SYS_ID values should originate from the EF_PROGRAM_FACILITY table.

On this page:

Geospatial File Format
Table 1: Program System Acronyms & Descriptions
Table 2: Sub Type Codes and Descriptions
Table 3: Geometric Type Codes and Descriptions
Table 4: Vertical Method Codes and Description
Table 5: Vertical Datum Codes and Descriptions
Table 6: Collection Method Codes and Descriptions
Table 7: Source Codes and Descriptions
Table 8: Horizontal Datum Codes and Descriptions
Table 9: Reference Point Codes and Descriptions

Geospatial File Format

Data Element	Description	Length	Format	Example
PGM_SYS_ACRNM (R)	Acronym of the EPA system containing the entity. Refer to Table 1 for valid values.	15	Alpha	PCS
PGM_SYS_ID (R)⁽¹⁾	Identification number to uniquely identify the entity within the PGM_SYS_ACRNM.	30	Alphanumeric	IN0003361
LATITUDE (R)	Latitude measurement (0 to 90 degrees). Units are in decimal degrees.	10	Numeric (+99.999999)	+40.096523
LONGITUDE (R)	Longitude measurement (0 to 180 degrees). First position indicates the direction "+" or "-". Units are in decimal degrees.	11	Numeric (-999.999999)	-110.098765
ACCURACY_VALUE	Accuracy of the collected Lat/Long. Units are in meters. Accuracy is recorded as a number.	5	Numeric	125.5
SUB_ID⁽²⁾	Identification for the subentity (ie, monitoring station, spill, pipe, stacks, or other operable unit). Refer to Table 9 for sub_id formats.	30	Alphanumeric	001A
SUB_TYPE_CODE	Code which identifies the type of operable unit of the subentity. Refer to Table 2 for valid codes.	4	Numeric (9999)	2
GEOMETRIC_TYPE_CODE	Point, Line, Area, Region, or Route. Refer to Table 3 for valid codes.	3	Alpha	001
VERTICAL_MEASURE	Vertical measurement of the point with respect to the vertical datum being used. Units are in meters.	10	Numeric	+1234.99 -15.3 0
VMETHOD_CODE	Code representing method used to collect vertical measurements. Refer to Table 4 for valid codes.	3	Numeric	001
VDATUM_CODE	Code representing the reference datum for the vertical measurements. Refer to Table 5 for valid codes.	3	Numeric	001
VACCURACY	Accuracy of the vertical measurement. Units are in meters. Accuracy is recorded as a number.	7	Numeric	10
COLLECT_MTH_CODE	Code representing the method used to obtain Lat/Long coordinates. Refer to Table 6 for valid codes.	3	Numeric	001
SCALE	Value representing the geographic scale of a map.	9	Numeric	100000
SOURCE_CODE	Description of organization responsible for sending data for inclusion into the Geospatial Reference Table. Refer to Table 7 for valid description values.	3	Numeric	001
HDATUM_CODE	Code representing the reference datum of the Lat/Long. Refer to Table 8 for valid codes.	3	Numeric	001
REF_POINT_CODE	Code for the category of feature referenced by Lat/Long. Refer to Table 9 for valid codes.	3	Numeric	001
COLLECTION_DATE	Latitude and longitude collection date.	8	DATE (yyyymmdd)	19990223
CITY_NAME	City name for the location of the entity / subentity.	30	Alpha	Greenlawn
COUNTY_NAME	County name for the location of the entity / subentity.	35	Alpha	Suffolk
LOCATION_ADDRESS	Street number and address of the entity / subentity.	50	Alphanumeric	23 Oak St.
POSTAL_CODE	U.S. Postal ZIP Code of physical or nearest location (ZIP, or ZIP+4) of the entity / subentity.	14	Numeric	11740
PRIMARY_NAME	Name of regulated or monitored entity / subentity.	50	Alphanumeric	CARGILL INC
STATE_CODE	U.S. Post Office state abbreviation of the entity / subentity.	2	Alpha	NY
COMMENT_TEXT	Text used to describe any information that is noteworthy concerning the collection of the coordinate values.	150	Alphanumeric	Alphanumeric

1. entity refers to PGM_SYS_ACRNM + PGM_SYS_ID
2. subentity refers to PGM_SYS_ACRNM + PGM_SYS_ID + SUB_ID

Table 1: Program System Acronyms & Descriptions

PGM_SYS_ACRNM	PGM_SYS_ACRNM_DESC
RCRAInfo	Resource Conservation Recovery Act Information System
PCS	Permit Compliance System
AFS/AIRS	Aerometric Information Retrieval System (AIRS)/Facility Subsystem (AFS)
SSTS	Section Seven Tracking System
CERCLIS	Comprehensive Environmental Response, Compensation, and Liability Information System
NCDB	National Compliance Data Base
FFIS	Federal Facility Information System
STATE	State Systems
PADS	PCB Handler Activity Data System
TRIS	Toxics Chemical Release Inventory System
TRIS-POTW	Toxics Chemical Release Inventory System - Public Owned Treatment Works
TRIS-OTHER	Toxics Chemical Release Inventory System - outside transfer facility
STORET	Storage and Retrieval
EMAP	Environmental Monitoring and Assessment Program
AIRS/AQS	Aerometric Information Retrieval System (AIRS)/Quality Subsystem (AQS)
SDWIS	Safe Drinking Water Information System

Top of Page

Table 2: Sub Type Codes and Descriptions

SUB_TYPE_CODE	SUB_TYPE_DESC
1	Point Of Record
2	Boundary Point
3	Sampling Point
4	End of Discharge Point
5	Well Head
6	Transect Origin
7	Grid Origin
20	Stack
40	Stack

Top of Page

Table 3: Geometric Type Codes and Descriptions

GEOMETRIC_TYPE_CODE	GEOMETRIC_TYPE DESC
001	Point
002	Line
003	Area
004	Region
005	Route

Top of Page

Table 4: Vertical Method Codes and Description

'Old' LRT	METHOD_CODE	VMETHOD_DESC
G1	001	GPS Carrier Phase Static Relative Position
G2	002	GPS Carrier Phase Kinematic Relative Position
G3	003	GPS Code (Pseudo Range) Differential
G4	004	GPS Code (Pseudo Range)Precise Position
G5	005	GPS Code (Pseudo Range)Standard Position (SA Off)
G6	006	GPS Code (Pseudo Range)Standard Position (SA On)
S1	007	Classical Surveying Techniques
OT	008	Other
A1	009	Altimery
L1	010	Precise Leveling-Bench mark
L2	011	Leveling-Non Bench Mark Control Points
L3	012	Trigonometric Leveling
P1	013	Photogrammetric
T1	014	Topographic Map Interpolation

Top of Page

Table 5: Vertical Datum Codes and Descriptions

'Old' LRT	VDATUM_CODE	VDATUM_DESC
1	001	NAVD88
2	002	NGVD29
3	003	Mean Sea-Level
4	004	Local Tidal Datum

Top of Page

Table 6: Collection Method Codes and Descriptions

'Old' LRT	COLLECT_MTH_CODE	COLLECT_MTH_DESC
A2	002	Address Matching-Block Face
A6	006	Address Matching-Digitized
A1	001	Address Matching-House Number
A4	004	Address Matching-Nearest Intersection
AO	007	Address Matching-Other
A5	005	Address Matching-Primary Name
A3	003	Address Matching-Street Centerline
C2	009	Census Block/Group-1990-Centroid
C3	010	Census Block/Tract-1990-Centroid
C1	008	Census Block-1990-Centroid
CO	011	Census-Other
S1	025	Classical Surveying Techniques
G0	028	GPS-Unspecified
G2	013	GPS Carrier Phase Kinematic Relative Position
G1	012	GPS Carrier Phase Static Relative Position
G3	014	GPS Code (Psuedo Range) Differential
G4	015	GPS Code (Psuedo Range) Precise Position
G5	016	GPS Code (Psuedo Range) Standard Position (SA Off)
G6	017	GPS Code (Psuedo Range) Standard Position (SA On)
G7	029	GPS, with Canadian Active Control System
I4	030	Interpolation - Digital Map Source (TIGER)
I5	031	Interpolation - SPOT
I6	032	Interpolation - MSS
I7	033	Interpolation - TM
I1	018	Interpolation - Map
I0	021	Interpolation - Other
I2	019	Interpolation - Photo
I3	020	Interpolation - Satellite
L1	022	Loran C
P3	034	Public Land Survey - Eighth Section
P5	036	Public Land Survey - Footing
P4	035	Public Land Survey - Sixteenth Section
P2	023	Public Land Survey - Quarter Section
P1	024	Public Land Survey - Section
UN	027	Unknown
Z1	026	ZIP Code - Centroid
Z2	038	ZIP +2 Centroid
Z3	037	ZIP +4 Centroid

Top of Page

Table 7: Source Codes and Descriptions

'Old' LRT	SOURCE_CODE	SOURCE_DESC
01	001	Alabama
02	002	Alaska
03	060	American Samoa
04	004	Arizona
05	005	Arkansas
06	006	California
08	008	Colorado
09	009	Connecticut
CR	080	Contractor
10	010	Delaware
11	011	District of Columbia
DB	081	Dun & Bradstreet
HQ	082	EPA Headquarters
64	064	Federated States of Micronesia
12	012	Florida
13	013	Georgia
66	066	Guam
15	015	Hawaii
16	016	Idaho
17	017	Illinois
18	018	Indiana
19	019	Iowa
20	020	Kansas
21	021	Kentucky
22	022	Louisiana
23	023	Maine
68	068	Marshall Islands
24	024	Maryland
25	025	Massachusetts
26	026	Michigan
27	027	Minnesota
28	028	Mississippi
29	029	Missouri
30	030	Montana
31	031	Nebraska
32	032	Nevada
33	033	New Hampshire
34	034	New Jersey
35	035	New Mexico
36	036	New York
37	037	North Carolina
38	038	North Dakota
69	069	Northern Mariana Islands
39	039	Ohio
40	040	Oklahoma
41	041	Oregon
OT	083	Other
FA	084	Other Federal Agency
70	070	Palau
42	042	Pennsylvania
PV	085	Private
72	072	Puerto Rico
R1	088	Region 1
R0	089	Region 10
R2	090	Region 2
R3	091	Region 3
R4	092	Region 4
R5	093	Region 5
R6	094	Region 6
R7	095	Region 7
R8	096	Region 8
R9	097	Region 9
RE	098	Regulated Entity
44	044	Rhode Island
45	045	South Carolina
46	046	South Dakota
47	047	Tennessee
48	048	Texas
TR	086	Tribe
74	074	U.S. Minor Outlying Islands
UN	087	Unknown
48	049	Utah
50	050	Vermont
78	078	Virgin Islands of the United States
51	051	Virginia
53	053	Washington
54	054	West Virginia
55	055	Wisconsin
56	056	Wyoming

Top of Page

Table 8: Horizontal Datum Codes and Descriptions

'Old' LRT	HDATUM_CODE	HDATUM_DESC
1	001	NAD27
2	002	NAD83
3	003	NAD84

Top of Page

Table 9: Reference Point Codes and Descriptions

'Old' LRT	REF_POINT_CODE	REF_POINT_DESC
UN	001	Unknown
PG	002	Plant Entrance (General)
OT	003	Other
PP	004	Plant Entrance (Personnel)
PF	005	Plant Entrance (Freight)
AS	006	Air Release Stack
AV	007	Air Release Vent
ST	008	Storage Tank
WR	009	Water Release Pipe
SP	010	Lagoon or Settling Pond
LW	011	Liquid Waste Treatment Unit
AE	012	Atmospheric Emissions Treatment Unit
SD	013	Solid Waste Treatment/Disp. Unit
SS	014	Solid Waste Storage Area
LF	015	Loading Facility
LC	016	Loading Area Centroid
PU	017	Process Unit
PC	018	Process Area Unit Centroid
AB	019	Administrative Building
FC	020	Facility Centroid
NE	021	NE Corner of Land Parcel
SE	022	SE Corner of Land Parcel
NW	023	NW Corner of Land Parcel
SW	024	SW Corner of Land Parcel
CE	025	Center of Facility
WA	027	Wellhead Protection Area
WM	028	Water Monitoring Station
IP	030	Intake Pipe
WL	026	Well
AM	029	Air Monitoring Station
-	032	Water Well
-	033	Spring
-	034	Source Water Area
-	035	Potential Contaminant Source
-	036	Source Water Protection Area

Top of Page