The data fields associated with the tables in the GIS Module are documented, by table, below. Click here to see the GIS Structure Chart.
English Name | Oracle Name | Edit Rule | Description |
EPA Handler ID | HANDLER_ID | GS1-010 | Unique RCRA identification number assigned by the implementing State or Region to each RCRA site (e.g., generators; transporters; and treatment, storage, disposal facilities). Note: Handlers associated with Navajo Nation should be assigned Handler Ids beginning with "NN" regardless of where the handler is physically located. |
GIS Owner | GIS_OWNER | GS1-020 |
Indicates the location of the agency that owns the GIS data. |
GIS Sequence Number | GIS_SEQ | GS1-030 | System-generated value used to uniquely identify GIS data. |
Data Collection Date | DATA_COLLECTION_DATE | GS1-040 | The date the data was collected. |
Feature Name | NAME | Optional name or identifier of the feature; may be used to store Regional Supplemental Control ID from Cleanup Site Geospatial Data Schema. | |
Feature Type Code Owner | FEATURE_TYPE_OWNER | GS1-050 | Indicates the agency that defined the Feature Type Code. |
Feature Type Code | FEATURE_TYPE_CODE | GS1-060 | Code that categorizes the feature of a site the geometry represents. [see nationally-defined values] |
Coordinate Data Code Owner | COORDINATE_DATA_OWNER | GS1-070, GS1-080 | Indicates the agency that defined the Coordinate Data Code. |
Coordinate Data Code | COORDINATE_DATA_CODE | GS1-080, GS1-090 |
Code that represents the party responsible for collecting or otherwise providing geographic coordinates. [see nationally-defined values] |
Tier Accuracy Code Owner | TIER_ACCURACY_OWNER | GS1-100 | Indicates the agency that defined the Tier Accuracy Code. |
Tier Accuracy Code | TIER_ACCURACY_CODE | GS1-110 | Code that represents the measure of accuracy (in a range of meters) of the feature's coordinates. [see nationally-defined values] |
Geometric Code Owner | GEOMETRIC_OWNER | GS1-120, GS1-130 | Indicates the agency that defined the Geometric Code. |
Geometric Code | GEOMETRIC_CODE | GS1-130, GS1-140 | Code that represents the geometric entity described by the coordinates. [see nationally-defined values] |
Geographic Reference Point Code Owner | GEO_REF_POINT_OWNER | GS1-150, GS1-160 | Indicates the agency that defined the Geographic Reference Point Code. |
Geographic Reference Point | GEO_REF_POINT_CODE | GS1-160, GS1-170 | Code that represents the place for which geographic coordinates were established. [see nationally-defined values] |
Horizontal Collection Code Owner | HORIZONTAL_COLL_OWNER | GS1-180 | Indicates the agency that defined the Horizontal Collection Code. |
Horizontal Collection Code | HORIZONTAL_COLL_CODE | GS1-190 | Code that represents the method used to determine the coordinates of the feature. [see nationally-defined values] |
Horizontal Reference Code Owner | HORIZONTAL_REF_OWNER | GS1-200 | Indicates the agency that defined the Horizontal Reference Code. |
Horizontal Reference Code | HORIZONTAL_REF_CODE | GS1-210 | Code that represents the reference datum used in determining the latitude and longitude coordinates for the site location. Note: This value must be '003' (World Geodetic System of 1984) and the geospatial data provided must use the WGS 84 coordinate reference frame for accurate representation in RCRAInfo and associated products. |
Verification Method Code Owner | VERIFICATION_METH_OWNER | GS1-220, GS1-230 | Indicates the agency that defined the Verification Method Code. |
Verification Method Code | VERIFICATION_METH_CODE | GS1-230, GS1-240 | Code that represents the method used to verify the coordinates. [see nationally-defined values ] |
Geometry | GEOMETRY | Oracle object that contains the geometric description (type and coordinates) of a spatial object. | |
Geometry Json | GEOMETRY_JSON | The geometric description of a spatial object (type and coordinates) in JSON format. | |
Corrective Action Event Activity Location1 | EVENT_ACTIVITY_LOCATION | GS1-250, GS1-260 | Indicates the location of the agency regulating the Corrective Action activity. |
Corrective Action Event Sequence Number1 | EVENT_SEQ | GS1-250, GS1-260 | System-generated value used to uniquely identify multiple occurences of a Corrective Action event. |
Corrective Action Event Agency1 | EVENT_AGENCY | GS1-250, GS1-260 | Code indicating the agency responsible for overseeing a specific Corrective Action event. |
Corrective Action Event Code Owner1 | EVENT_OWNER | GS1-250, GS1-260 | Indicates the agency that defined the Corrective Action event. |
Corrective Action Event Code1 | EVENT_CODE | GS1-250, GS1-260 | Code that corresponds to a specific Corrective Action event or event type. The first two characters indicate the event category and the last three characters the numeric event number. |
Evaluation Activity Location2 | EVAL_ACTIVITY_LOCATION | GS1-270, GS1-280 | The location (i.e., State) where the activity took place. |
Evaluation Identifier2 | EVAL_IDENTIFIER | GS1-270, GS1-280 | Name or number assigned by the implementing agency to identify an evaluation (inspection). |
Evaluation Start Date2 | EVAL_START_DATE | GS1-270, GS1-280 | The first day of the evaluation, inspection, or record review regardless of the duration of the activity. |
Evaluation Agency2 | EVAL_AGENCY | GS1-270, GS1-280 | Code indicating the agency responsible for conducting the evaluation (inspection). |
Area Sequence Number3 | AREA_SEQ | GS1-290 | System-generated value used to uniquely identify a Corrective Action area. |
Unit Sequence Number4 | UNIT_SEQ | GS1-300 | System-generated value used to uniquely identify a process unit. |
Date of GIS Record Creation | CREATED_DATE | Records the date that the GIS record was created. | |
User Id of GIS Record Creation | CREATED_BY_USERID | Records the user identification of the person who created the GIS record. | |
Origin of Data | DATA_ORIGIN | Computer-generated field that indicates the method by which the GIS data was created. [see nationally-defined values] | |
Date of Last Change | LAST_CHANGE | Records the date that the data was last changed. | |
User ID of Last Change | USERID | Records the user ID of the last person to change the data. | |
Notes | NOTES | Optional comments with additional descriptive information about the feature (publicly releasable). |
1 - These columns represent the primary key information to a Corrective Action event that exists in RCRAInfo. This information may be provided to establish a link between this GIS feature and the Corrective Action event.
2 - These columns represent the primary key information to an CM&E evaluation that exists in RCRAInfo. This information may be provided to establish a link between this GIS feature and the CM&E evaluation.
3 - This column represents the primary key information to a Corrective Action area that exists in RCRAInfo. This information may be provided to establish a link between this GIS feature and the Corrective Action area.
4 - This column represents the primary key information to a Permit, Closure, and Post-Closure unit that exists in RCRAInfo. This information may be provided to establish a link between this GIS feature and the Permit, Closure, and Post-Closure unit.