Back to fileView metadata
Schema
Oil and Natural Gas Wells / oil-and-natural-gas-wells / v1.0.0
Schema from GeoParquet, GCS hifld-next-datasets-prod, v1.0.0.
Columns
34 columns
Features
1,009,202
Geometry
Point
| Column | Type | Nullable | Nulls | Unique | Description | Examples / Values |
|---|---|---|---|---|---|---|
| geometry | geometry | No | 0 | — | — Range: —Length: — | Examples: — Values: — |
| id | string | No | 0 | — | — Range: —Length: 10 | Examples: W220000399, W220003834, W220004837, W220004573, W220000637 Values: — |
| name | string | No | 0 | — | — Range: —Length: 30 | Examples: VUA;SL 16995, RRBB TUSC SU;HAYNE, JAMES RB SUH;COVINGTON, HOSS B RA SUTT;SHAFFER, BURAS LEVEE DISTRICT K Values: — |
| state | string | No | 0 | — | — Range: —Length: 2 | Examples: LA, LA, LA, LA, LA Values: LA |
| type | string | No | 0 | — | — Range: —Length: 22 | Examples: OIL & NATURAL GAS WELL, OIL & NATURAL GAS WELL, OIL & NATURAL GAS WELL, OIL & NATURAL GAS WELL, OIL & NATURAL GAS WELL Values: OIL & NATURAL GAS WELL |
| status | string | No | 0 | — | — Range: —Length: 15 | Examples: NON-ACTIVE WELL, NON-ACTIVE WELL, NON-ACTIVE WELL, NON-ACTIVE WELL, NON-ACTIVE WELL Values: NON-ACTIVE WELL |
| county | string | No | 0 | — | — Range: —Length: 19 | Examples: VERMILION, RED RIVER, SABINE, BIENVILLE, PLAQUEMINES Values: — |
| countyfips | string | No | 0 | — | — Range: —Length: 5 | Examples: 22113, 22081, 22085, 22013, 22075 Values: — |
| country | string | No | 0 | — | — Range: —Length: 3 | Examples: USA, USA, USA, USA, USA Values: USA |
| latitude | float | No | 0 | — | — Range: 28.89956 to 33.01853Length: — | Examples: 29.7512, 32.09346, 31.81682, 32.50055, 29.20502 Values: — |
| longitude | float | No | 0 | — | — Range: -94.04269 to -89.04075Length: — | Examples: -92.16683, -93.41978, -93.78654, -93.08906, -89.42076 Values: — |
| naics_code | string | No | 0 | — | — Range: —Length: 6 | Examples: 213111, 213111, 213111, 213111, 213111 Values: 213111 |
| naics_desc | string | No | 0 | — | — Range: —Length: 26 | Examples: DRILLING OIL AND GAS WELLS, DRILLING OIL AND GAS WELLS, DRILLING OIL AND GAS WELLS, DRILLING OIL AND GAS WELLS, DRILLING OIL AND GAS WELLS Values: DRILLING OIL AND GAS WELLS |
| source | string | No | 0 | — | — Range: —Length: 41 | Examples: LOUISIANA DEPARTMENT OF NATURAL RESOURCES, LOUISIANA DEPARTMENT OF NATURAL RESOURCES, LOUISIANA DEPARTMENT OF NATURAL RESOURCES, LOUISIANA DEPARTMENT OF NATURAL RESOURCES, LOUISIANA DEPARTMENT OF NATURAL RESOURCES Values: LOUISIANA DEPARTMENT OF NATURAL RESOURCES |
| sourcedate | string | No | 0 | — | — Range: —Length: 19 | Examples: 2013-12-31T19:00:00, 2013-12-31T19:00:00, 2013-12-31T19:00:00, 2013-12-31T19:00:00, 2013-12-31T19:00:00 Values: 2013-12-31T19:00:00 |
| val_method | string | No | 0 | — | — Range: —Length: 5 | Examples: OTHER, OTHER, OTHER, OTHER, OTHER Values: OTHER |
| val_date | string | No | 0 | — | — Range: —Length: 19 | Examples: 2014-11-11T19:00:00, 2014-11-11T19:00:00, 2014-11-11T19:00:00, 2014-11-11T19:00:00, 2014-11-11T19:00:00 Values: 2014-11-11T19:00:00 |
| website | string | No | 0 | — | — Range: —Length: 33 | Examples: http://sonris-www.dnr.state.la.us, http://sonris-www.dnr.state.la.us, http://sonris-www.dnr.state.la.us, http://sonris-www.dnr.state.la.us, http://sonris-www.dnr.state.la.us Values: http://sonris-www.dnr.state.la.us |
| wellidno | string | No | 0 | — | — Range: —Length: 7 | Examples: 003, 020-14, 001, 001, 009 Values: — |
| api | string | No | 0 | — | — Range: —Length: 14 | Examples: 17113222850000, 17081200660000, 17085220310000, 17013208660000, 17075224090000 Values: — |
| permitno | float | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999.0, -999.0, -999.0, -999.0, -999.0 Values: — |
| operator | string | No | 0 | — | — Range: —Length: 40 | Examples: SHORELINE SOUTHEAST LLC, BSI OPERATING, LLC, PINNACLE OPERATING CO., INC., VERNON E. FAULCONER, INC., HILCORP ENERGY COMPANY Values: — |
| operatorid | float | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999.0, -999.0, -999.0, -999.0, -999.0 Values: — |
| prodtype | string | No | 0 | — | — Range: —Length: 12 | Examples: UNKNOWN WELL, UNKNOWN WELL, UNKNOWN WELL, UNKNOWN WELL, UNKNOWN WELL Values: UNKNOWN WELL |
| coordtype | string | No | 0 | — | — Range: —Length: 1 | Examples: T, T, T, T, T Values: T |
| surf_lat | float | No | 0 | — | — Range: 28.89956 to 33.01853Length: — | Examples: 29.7512, 32.09346, 31.81682, 32.50055, 29.20502 Values: — |
| surf_long | float | No | 0 | — | — Range: -94.04269 to -89.04075Length: — | Examples: -92.16683, -93.41978, -93.78654, -93.08906, -89.42076 Values: — |
| bot_lat | float | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999.0, -999.0, -999.0, -999.0, -999.0 Values: — |
| bot_long | float | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999.0, -999.0, -999.0, -999.0, -999.0 Values: — |
| posrel | string | No | 0 | — | — Range: —Length: 11 | Examples: THIRD PARTY, THIRD PARTY, THIRD PARTY, THIRD PARTY, THIRD PARTY Values: THIRD PARTY |
| field | string | No | 0 | — | — Range: —Length: 35 | Examples: INTRACOASTAL CITY, RED RIVER-BULL BAYOU, CONVERSE, ADA, WEST BAY Values: — |
| compdate | string | No | 0 | — | — Range: —Length: 19 | Examples: 2005-10-06T20:00:00, 1972-09-06T20:00:00, 2005-09-08T20:00:00, 1994-12-09T19:00:00, 1978-03-16T20:00:00 Values: — |
| totdepth | float | No | 0 | — | — Range: -999 to -999Length: — | Examples: -999.0, -999.0, -999.0, -999.0, -999.0 Values: — |
| objectid | integer | No | 0 | — | — Range: 1 to 5000Length: — | Examples: 399, 3834, 4837, 4573, 637 Values: — |
Invalid geometry count: 0
Columns hash: 032d885c5c2a32e01724d416d60540d4b7b16e42ec0812890a0d0e374791c0ac