Coordinate datum code
rrc.lat_lon_datum
Which datum the coordinates on a completion packet were surveyed on. Ignoring this is worth up to about 200 metres of error in West Texas. The pipeline that loads this data resolves the code on the way in, so the warehouse column holds the text below rather than the raw RRC code. Both are recorded here so the original filing can be read either way.
3 of 3 codes
| Code | Means | Normalised | Valid |
|---|---|---|---|
1 |
NAD27 North American Datum 1927 (EPSG:4267). | NAD27 |
always |
2 |
NAD83 North American Datum 1983 (EPSG:4269). | NAD83 |
always |
3 |
WGS84 World Geodetic System 1984 (EPSG:4326). | WGS84 |
always |
Columns that use these codes
| Dataset | Column | Meaning |
|---|---|---|
| Drilling Permits Pending Approval (with latitudes and longitudes) | latlong_type_code |
The DATUM the applicant's coordinates were surveyed on — 1 NAD27, 2 NAD83, 3 WGS84 — not the form they are written in. NAD27 on 174 of the 258 rows held, so treating the column as WGS84 is worth about 200 metres in West Texas. |
Where this mapping came from: OilGasDataProcessing process_completions.packetData, inline lat_lon_code map (CMPL packet field 44)