GIS_Web.SDE.Seal_Mar2018
The Well Management database was queried and data extracted on December 31, 2012. Data was processed from 10 tables and reconstructed to create a file geodatabase with only the actual well sealing records. Geocoding was accomplished in a phased approach. 1. Match to a County Well Index located well. 2. Match to an inventoried PCSI location 3. Match to a physical address with zipcode using a composite address locator. 4. Match to Public Land Survey System (PLSS) coordinates. Townhip, Range, Section and subsection. Finally a shapefile was generated for general distribution. About 2,000 records did not have any location information and are not included in the data distribution.
[{'name': 'OBJECTID', 'type': 'esriFieldTypeOID', 'alias': 'FID', 'domain': None}, {'name': 'WELL_SNUM', 'type': 'esriFieldTypeDouble', 'alias': 'WELL_SNUM', 'domain': None}, {'name': 'REP_STAT', 'type': 'esriFieldTypeString', 'alias': 'REP_STAT', 'length': 3, 'domain': None}, {'name': 'SEALED_D', 'type': 'esriFieldTypeDate', 'alias': 'SEALED_D', 'length': 8, 'domain': None}, {'name': 'ENTRY_D', 'type': 'esriFieldTypeDate', 'alias': 'ENTRY_D', 'length': 8, 'domain': None}, {'name': 'SEAL_DEP', 'type': 'esriFieldTypeInteger', 'alias': 'SEAL_DEP', 'domain': None}, {'name': 'SEAL_CAS', 'type': 'esriFieldTypeInteger', 'alias': 'SEAL_CAS', 'domain': None}, {'name': 'OTHER_WELL', 'type': 'esriFieldTypeString', 'alias': 'OTHER_WELL', 'length': 1, 'domain': None}, {'name': 'NOTES', 'type': 'esriFieldTypeString', 'alias': 'NOTES', 'length': 254, 'domain': None}, {'name': 'UNIQUE_', 'type': 'esriFieldTypeString', 'alias': 'UNIQUE', 'length': 10, 'domain': None}, {'name': 'RELATEID', 'type': 'esriFieldTypeString', 'alias': 'RELATEID', 'length': 10, 'domain': None}, {'name': 'SEAL_ID', 'type': 'esriFieldTypeString', 'alias': 'SEAL_ID', 'length': 10, 'domain': None}, {'name': 'WELL_LABEL', 'type': 'esriFieldTypeString', 'alias': 'WELL_LABEL', 'length': 10, 'domain': None}, {'name': 'LOC_ID', 'type': 'esriFieldTypeDouble', 'alias': 'LOC_ID', 'domain': None}, {'name': 'NAME', 'type': 'esriFieldTypeString', 'alias': 'NAME', 'length': 60, 'domain': None}, {'name': 'ADDR', 'type': 'esriFieldTypeString', 'alias': 'ADDR', 'length': 90, 'domain': None}, {'name': 'CITY', 'type': 'esriFieldTypeString', 'alias': 'CITY', 'length': 28, 'domain': None}, {'name': 'STATE_ABB', 'type': 'esriFieldTypeString', 'alias': 'STATE_ABB', 'length': 2, 'domain': None}, {'name': 'ZIP5_CODE', 'type': 'esriFieldTypeString', 'alias': 'ZIP5_CODE', 'length': 5, 'domain': None}, {'name': 'LOC_DESC', 'type': 'esriFieldTypeString', 'alias': 'LOC_DESC', 'length': 120, 'domain': None}, {'name': 'COUNTY_C', 'type': 'esriFieldTypeInteger', 'alias': 'COUNTY_C', 'domain': None}, {'name': 'TOWNSHIP', 'type': 'esriFieldTypeInteger', 'alias': 'TOWNSHIP', 'domain': None}, {'name': 'TOWN_DIR', 'type': 'esriFieldTypeString', 'alias': 'TOWN_DIR', 'length': 1, 'domain': None}, {'name': 'RANGE', 'type': 'esriFieldTypeInteger', 'alias': 'RANGE', 'domain': None}, {'name': 'RANGE_DIR', 'type': 'esriFieldTypeString', 'alias': 'RANGE_DIR', 'length': 1, 'domain': None}, {'name': 'SECT', 'type': 'esriFieldTypeInteger', 'alias': 'SECT', 'domain': None}, {'name': 'SUBSECT', 'type': 'esriFieldTypeString', 'alias': 'SUBSECT', 'length': 6, 'domain': None}, {'name': 'PIN', 'type': 'esriFieldTypeString', 'alias': 'PIN', 'length': 15, 'domain': None}, {'name': 'STATUS_C', 'type': 'esriFieldTypeString', 'alias': 'STATUS_C', 'length': 2, 'domain': None}, {'name': 'LCM_CODE', 'type': 'esriFieldTypeString', 'alias': 'LCM_CODE', 'length': 3, 'domain': None}, {'name': 'DBNAME_ABB', 'type': 'esriFieldTypeString', 'alias': 'DBNAME_ABB', 'length': 8, 'domain': None}, {'name': 'ACCURACY', 'type': 'esriFieldTypeInteger', 'alias': 'ACCURACY', 'domain': None}, {'name': 'GEOC_DATE', 'type': 'esriFieldTypeDate', 'alias': 'GEOC_DATE', 'length': 8, 'domain': None}, {'name': 'COMMENTS', 'type': 'esriFieldTypeString', 'alias': 'COMMENTS', 'length': 200, 'domain': None}, {'name': 'GlobalID', 'type': 'esriFieldTypeGlobalID', 'alias': 'GlobalID', 'length': 38, 'domain': None}, {'name': 'Shape', 'type': 'esriFieldTypeGeometry', 'alias': 'Shape', 'domain': None}]
[{'name': 'R1756_pk', 'fields': 'OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'UUID_1756', 'fields': 'GlobalID', 'isAscending': True, 'isUnique': False, 'description': ''}, {'name': 'UUID_OID_1756', 'fields': 'GlobalID,OBJECTID', 'isAscending': True, 'isUnique': True, 'description': ''}, {'name': 'S1719_idx', 'fields': 'Shape', 'isAscending': True, 'isUnique': True, 'description': ''}]
[]
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriPMS', 'url': 'a7817bd5ad4b38be0c007f3e286ecf4d', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAQpJREFUKJGd0r8rhXEUx/GXuvUtC92k7iSl6MpCUXdgwSwzf4DBxqT8A1c32WyMFruy3BLlx2C5o/wYngFPKalvch/Lk8F1r/hMpz7nfTrn0yn4pwqdzGKxOJmm6fmfwTRNK/gDmBn0oKZuyqIJ3TZ0ue8Mnphx5siAoB+3ljQtyozpctMefLNjTgC3KONJt4Y9TP8Ilkql0aSc9LcM68ONkZZV8/QqSZIMufDuLnev8ZHXVzKsoYlaAfLIz9ETXsNzXIibX6MryGThMuxHcavdjS9xOTaUrYTxsBrFYU0NNadxPVZbVv2mg1AJszHGKuZRxyEefwPFGI/zshe7P/V0/JxO+g3cbmd8AngQVYRPuQ2WAAAAAElFTkSuQmCC', 'contentType': 'image/png', 'width': 10, 'height': 10, 'angle': 0, 'xoffset': 0, 'yoffset': 0}, 'label': '', 'description': ''}, 'transparency': 0, 'labelingInfo': None}
nan
nan