FRS Metadata
Table Name: V_GEO_PGM_COORDINATE_ALL
Description: Contains all program spatial data, associated facility name and address information, expanded spatial metadata code descriptions, spatially derived data, and the FRS facility representative point data for the parent facility.
Columns:
- PGM_SYS_ID
- PGM_SYS_ACRNM
- PRIMARY_NAME
- CITY_NAME
- COUNTY_NAME
- STATE_CODE
- POSTAL_CODE
- COUNTRY_NAME
- OBJECTID
- SUB_ID
- LATITUDE83
- LONGITUDE83
- SHAPE
- CONVEYOR
- HDATUM_DESC
- REF_POINT_DESC
- SOURCE_DESC
- SCALE
- ACCURACY_VALUE
- ACCURACY_SCORE
- TIMESTAMP
- DERIVED_ZIP
- DERIVED_STATE
- REGISTRY_ID
- REP_LATITUDE83
- REP_LONGITUDE83
- REP_OBJECTID
- REP_TIMESTAMP
- COLLECT_MTH_DESC
- DERIVED_CB_2010
- DERIVED_CD_112
- DERIVED_CITY
- DERIVED_COUNTY
- DERIVED_FIPS
- DERIVED_HUC
- DERIVED_WBD
- FIPS_ CODE
- LOCATION_ ADDRESS
- OZONE_8HR_1997_ AREA_NAME
- OZONE_8HR_2008_ AREA_NAME
- PB_2008_AREA_NAME
- PM25_1997_AREA_ NAME
- PM25_2006_AREA_ NAME
- VERTICAL_MEASURE