Layers:

Layer: Well Logs (0)

Name: Well Logs

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a viewing service for Well Logs (also called logged wells) in Missouri. This data set provides locations of wells with information about the available well logs, geologic data, groundwater levels, well construction details and general remarks. Geologic stratigraphy and well construction details are on separate tables. This dataset was developed by the Missouri Department of Natural Resources. Metadata: https://info.mo.gov/dnr/DNR_GIS/metadata/GEOLOGY.WELL_LOGS.xml

Service Item Id: d49fb4bbc5e243cfba53ca530768acc9

Copyright Text: Missouri Office of Administration, Information Technology Services Division, Office of Geospatial Information; Missouri Department of Natural Resources

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 268405.56680000015
YMin: 3992362.977
XMax: 838839.6416999996
YMax: 4496170.4176
Spatial Reference: 26915  (26915)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 5.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ID ( type: esriFieldTypeString, alias: Assigned strip log number , length: 15 )
• OWNER ( type: esriFieldTypeString, alias: Well owner name or other reference to well, length: 100 )
• WELL_TYPE ( type: esriFieldTypeString, alias: Purpose for drilling and use of well, length: 55 , Coded Values: [Core Description: Core Description] , [Exploratory Hole (Mineral Prospect): Exploratory Hole (Mineral Prospect)] , [Exploratory Hole (Oil & Gas): Exploratory Hole (Oil & Gas)] , ...12 more... )
• SCANTYPE ( type: esriFieldTypeSmallInteger, alias: Description of scanned image , Coded Values: [0: None] , [1: Strip Log] , [2: Log Notes] , ...2 more... )
• SMPL_LOG ( type: esriFieldTypeSmallInteger, alias: Stratigraphic log for well on file , Coded Values: [0: No] , [1: Yes] )
• DRILL_LOG ( type: esriFieldTypeSmallInteger, alias: Driller log on file , Coded Values: [0: No] , [1: Yes] )
• OTHER_LOG ( type: esriFieldTypeSmallInteger, alias: Other non-stratigraphic logs for well , Coded Values: [0: No] , [1: Yes] )
• CUTTINGS_ ( type: esriFieldTypeSmallInteger, alias: Cuttings or samples retained , Coded Values: [0: No] , [1: Yes] )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude (decimal degrees) )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude (decimal degrees) )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 35 , Coded Values: [Adair: Adair] , [Andrew: Andrew] , [Atchison: Atchison] , ...112 more... )
• FIPS ( type: esriFieldTypeString, alias: State and County FIPS, length: 5 , Coded Values: [29001: Adair] , [29003: Andrew] , [29005: Atchison] , ...112 more... )
• QUADRANGLE ( type: esriFieldTypeString, alias: Name of quadrangle map, length: 50 , Coded Values: [Acorn Ridge: Acorn Ridge] , [Adrian: Adrian] , [Advance: Advance] , ...1289 more... )
• TWP_TEXT ( type: esriFieldTypeString, alias: (PLSS) Township and direction, length: 9 )
• RNG_TEXT ( type: esriFieldTypeString, alias: PLSS Range and direction, length: 9 )
• SEC_TEXT ( type: esriFieldTypeString, alias: PLSS Section number or Landgrant ID, length: 9 )
• PLSS_LABEL ( type: esriFieldTypeString, alias: Label for location (PLSS or landgrant), length: 14 )
• LOCATOR ( type: esriFieldTypeString, alias: Remarks on source(s) used to verify location, length: 100 )
• UPDATELOC ( type: esriFieldTypeSmallInteger, alias: Well location has been modified/corrected since original entry , Coded Values: [2: Not relocated] , [1: Relocated] , [-1: Not resolved] )
• ELEV ( type: esriFieldTypeDouble, alias: Ground elevation (ft) )
• ELEV_SOURCE ( type: esriFieldTypeString, alias: Source to determine elevation, length: 50 )
• TOTDEPTH ( type: esriFieldTypeDouble, alias: Total depth (feet) of borehole )
• DEPTHBED ( type: esriFieldTypeDouble, alias: Depth to first competent bedrock unit (ft) )
• SWL_AFTER ( type: esriFieldTypeInteger, alias: Static water level after casing )
• SWL_BEFORE ( type: esriFieldTypeInteger, alias: Static water level before casing )
• SWLA_ELEV ( type: esriFieldTypeSmallInteger, alias: Static water level elevation after casing )
• SWLB_ELEV ( type: esriFieldTypeSmallInteger, alias: Static water level elevation before casing )
• WATER_AT ( type: esriFieldTypeString, alias: Indication(s) of water as noted by driller (in feet below surface), length: 100 )
• DRAWDOWN ( type: esriFieldTypeInteger, alias: Measured drawdown (ft ) )
• WELL_YIELD ( type: esriFieldTypeDouble, alias: Pumping yield (gpm) )
• FORM_SUR ( type: esriFieldTypeString, alias: Formation name or material at the surface, length: 100 , Coded Values: [(CASING LENGTH EXCEEDS DEPTH OF WELL): (CASING LENGTH EXCEEDS DEPTH OF WELL)] , [(NO BEDROCK IDENTIFIED): (NO BEDROCK IDENTIFIED)] , [(NO OR INSUFFICIENT CASING INFORMATION): (NO OR INSUFFICIENT CASING INFORMATION)] , ...356 more... )
• FORM_UBK ( type: esriFieldTypeString, alias: First bedrock formation encountered, length: 100 , Coded Values: [(CASING LENGTH EXCEEDS DEPTH OF WELL): (CASING LENGTH EXCEEDS DEPTH OF WELL)] , [(NO BEDROCK IDENTIFIED): (NO BEDROCK IDENTIFIED)] , [(NO OR INSUFFICIENT CASING INFORMATION): (NO OR INSUFFICIENT CASING INFORMATION)] , ...356 more... )
• FORM_CP ( type: esriFieldTypeString, alias: Formation or material at casing depth, length: 100 , Coded Values: [(CASING LENGTH EXCEEDS DEPTH OF WELL): (CASING LENGTH EXCEEDS DEPTH OF WELL)] , [(NO BEDROCK IDENTIFIED): (NO BEDROCK IDENTIFIED)] , [(NO OR INSUFFICIENT CASING INFORMATION): (NO OR INSUFFICIENT CASING INFORMATION)] , ...356 more... )
• FORM_TD ( type: esriFieldTypeString, alias: Deepest formation or geologic description encountered, length: 100 , Coded Values: [(CASING LENGTH EXCEEDS DEPTH OF WELL): (CASING LENGTH EXCEEDS DEPTH OF WELL)] , [(NO BEDROCK IDENTIFIED): (NO BEDROCK IDENTIFIED)] , [(NO OR INSUFFICIENT CASING INFORMATION): (NO OR INSUFFICIENT CASING INFORMATION)] , ...356 more... )
• ALT_ID1 ( type: esriFieldTypeString, alias: Alternate ID1 (second log), length: 15 )
• ALT_ID2 ( type: esriFieldTypeString, alias: Alternate ID2 (third log), length: 15 )
• SDWIS_ID ( type: esriFieldTypeInteger, alias: SDWIS ID )
• WWIMSID ( type: esriFieldTypeString, alias: WIMS well reference number, length: 10 )
• API_ID ( type: esriFieldTypeString, alias: Oil and gas database ID, length: 50 )
• XREF_NUM ( type: esriFieldTypeString, alias: Other database ID referenced on log, length: 50 )
• MINERAL_BH ( type: esriFieldTypeString, alias: Mineral borehole database ID cross reference, length: 50 )
• ADDITIONAL ( type: esriFieldTypeString, alias: Additional database(s), length: 100 )
• LEASE ( type: esriFieldTypeString, alias: Lease name, length: 150 )
• DRLDATE ( type: esriFieldTypeString, alias: Date drilled , length: 15 )
• DRILLER ( type: esriFieldTypeString, alias: Driller name, length: 150 )
• LOGGER ( type: esriFieldTypeString, alias: Person(s) who logged well, length: 150 )
• LOGDATE ( type: esriFieldTypeString, alias: Date logged, length: 20 )
• G_STRUCTURE ( type: esriFieldTypeSmallInteger, alias: Evidence of a geologic structure in or near the well , Coded Values: [0: No] , [1: Yes] )
• CAUTION ( type: esriFieldTypeSmallInteger, alias: Caution using data on log , Coded Values: [0: No] , [1: Yes] )
• REMARKS_ ( type: esriFieldTypeString, alias: Additional information about the well, length: 1073741822 )
• INTCRDTP ( type: esriFieldTypeDouble, alias: Interval cored (feet) depth to top )
• INTCRDBT ( type: esriFieldTypeDouble, alias: Interval cored depth (feet) to bottom )
• HYPERLINK ( type: esriFieldTypeString, alias: Link to scanned image, length: 255 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 50 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

Relationships:

• tblConstruction (0) -- Related To: GEOLOGY_.tblConstruction (1)
• tblSTATIGRAPHY (1) -- Related To: GEOLOGY_tblSTATIGRAPHY (2)

Tables:

Table: GEOLOGY_.tblConstruction (1)

Name: GEOLOGY_.tblConstruction

Display Field: ID

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d49fb4bbc5e243cfba53ca530768acc9

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ID ( type: esriFieldTypeString, alias: ID, length: 15 )
• DATECOMP ( type: esriFieldTypeString, alias: DATECOMP, length: 15 )
• PLUGIND ( type: esriFieldTypeString, alias: PLUGIND, length: 10 )
• DATEPLUG ( type: esriFieldTypeString, alias: DATEPLUG, length: 15 )
• SRF_CAS_LNTH ( type: esriFieldTypeDouble, alias: SRF_CAS_LNTH )
• SRF_CAS_DIA ( type: esriFieldTypeDouble, alias: SURFACE CASEING DIAMETER )
• PRD_CAS_LNTH ( type: esriFieldTypeDouble, alias: PRODUCTION CASING LENGTH )
• PRD_CAS_DIA ( type: esriFieldTypeDouble, alias: PRODUCTION CASING DIAMETER )
• INT1_CAS_LNTH ( type: esriFieldTypeDouble, alias: INTERMEDIATE 1 CASING LENGTH )
• INT1_CAS_DIA ( type: esriFieldTypeDouble, alias: INTERMEDIATE 1 CASING DIAMETER )
• INT2_CAS_LNTH ( type: esriFieldTypeDouble, alias: INTERMEDIATE 2 CASING LENGTH )
• INT2_CAS_DIA ( type: esriFieldTypeDouble, alias: INTERMEDIATE 2 CASING DIAMETER )
• INOUT1 ( type: esriFieldTypeString, alias: INOUT1, length: 5 )
• TYPGRT1 ( type: esriFieldTypeString, alias: TYPGRT1, length: 25 , Coded Values: [Cement Grout: Cement Grout] , [Bentonite: Bentonite] , [Other: Other] )
• TYPGRT2 ( type: esriFieldTypeString, alias: TYPGRT2, length: 25 , Coded Values: [Cement Grout: Cement Grout] , [Bentonite: Bentonite] , [Other: Other] )
• TYPGRT3 ( type: esriFieldTypeString, alias: TYPGRT3, length: 25 , Coded Values: [Cement Grout: Cement Grout] , [Bentonite: Bentonite] , [Other: Other] )
• MULTCASE ( type: esriFieldTypeString, alias: MULTCASE, length: 5 )
• SZCASHOL ( type: esriFieldTypeDouble, alias: SZCASHOL )
• SZBELCAS ( type: esriFieldTypeDouble, alias: SZBELCAS )
• SIZSCRN ( type: esriFieldTypeDouble, alias: SIZSCRN )
• SLOTSIZE ( type: esriFieldTypeDouble, alias: SLOTSIZE )
• LENSCRN ( type: esriFieldTypeDouble, alias: LENSCRN )
• TYPESCRN ( type: esriFieldTypeString, alias: TYPESCRN, length: 25 )
• PUMPCAP ( type: esriFieldTypeDouble, alias: PUMPCAP )
• PUMPTDH ( type: esriFieldTypeDouble, alias: PUMPTDH )
• PUMPSET ( type: esriFieldTypeDouble, alias: PUMPSET )
• TOTAL_LNGT_CS ( type: esriFieldTypeSmallInteger, alias: TOTAL_LNGT_CS )
• CASING_DEPTH ( type: esriFieldTypeSmallInteger, alias: CASING_DEPTH )
• REMARKS ( type: esriFieldTypeString, alias: REMARKS, length: 800 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

Relationships:

• LOGGED_WELLS (0) -- Related To: Well Logs (0)

Table: GEOLOGY_tblSTATIGRAPHY (2)

Name: GEOLOGY_tblSTATIGRAPHY

Display Field: INTERVAL_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: d49fb4bbc5e243cfba53ca530768acc9

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ID ( type: esriFieldTypeString, alias: ID, length: 15 )
• FMTOP ( type: esriFieldTypeDouble, alias: FMTOP )
• FMBOT ( type: esriFieldTypeDouble, alias: FMBOT )
• INTERVAL_NAME ( type: esriFieldTypeString, alias: FORMATION_NAME, length: 50 , Coded Values: [(CASING LENGTH EXCEEDS DEPTH OF WELL): (CASING LENGTH EXCEEDS DEPTH OF WELL)] , [(NO BEDROCK IDENTIFIED): (NO BEDROCK IDENTIFIED)] , [(NO OR INSUFFICIENT CASING INFORMATION): (NO OR INSUFFICIENT CASING INFORMATION)] , ...356 more... )
• PRIMLITH ( type: esriFieldTypeString, alias: PRIMLITH, length: 40 , Coded Values: [DOLOMITE: DOLOMITE] , [LIMESTONE: LIMESTONE] , [SHALE: SHALE] , ...46 more... )
• SECLITH ( type: esriFieldTypeString, alias: SECLITH, length: 40 , Coded Values: [DOLOMITE: DOLOMITE] , [LIMESTONE: LIMESTONE] , [SHALE: SHALE] , ...46 more... )
• MINLITH ( type: esriFieldTypeString, alias: MINLITH, length: 40 , Coded Values: [DOLOMITE: DOLOMITE] , [LIMESTONE: LIMESTONE] , [SHALE: SHALE] , ...46 more... )
• PRIMMIN ( type: esriFieldTypeString, alias: PRIMMIN, length: 40 , Coded Values: [PYRITE (FeS2): PYRITE (FeS2)] , [HEMATITE (Fe2O3): HEMATITE (Fe2O3)] , [SPHALERITE ((Zn,Fe)S): SPHALERITE ((Zn,Fe)S)] , ...65 more... )
• SECMIN ( type: esriFieldTypeString, alias: SECMIN, length: 40 , Coded Values: [PYRITE (FeS2): PYRITE (FeS2)] , [HEMATITE (Fe2O3): HEMATITE (Fe2O3)] , [SPHALERITE ((Zn,Fe)S): SPHALERITE ((Zn,Fe)S)] , ...65 more... )
• MINRMIN ( type: esriFieldTypeString, alias: MINRMIN, length: 40 , Coded Values: [PYRITE (FeS2): PYRITE (FeS2)] , [HEMATITE (Fe2O3): HEMATITE (Fe2O3)] , [SPHALERITE ((Zn,Fe)S): SPHALERITE ((Zn,Fe)S)] , ...65 more... )
• SYSTEM ( type: esriFieldTypeString, alias: SYSTEM, length: 50 , Coded Values: [CAMBRIAN SYSTEM: CAMBRIAN SYSTEM] , [CARBONIFEROUS SYSTEMS: CARBONIFEROUS SYSTEMS] , [CRETACEOUS SYSTEM: CRETACEOUS SYSTEM] , ...10 more... )
• SERIES ( type: esriFieldTypeString, alias: SERIES, length: 75 , Coded Values: [CANADIAN (IBEXIAN) SERIES: CANADIAN (IBEXIAN) SERIES] , [CHESTERIAN SERIES: CHESTERIAN SERIES] , [CINCINNATIAN SERIES: CINCINNATIAN SERIES] , ...24 more... )
• GROUP_ ( type: esriFieldTypeString, alias: GROUP_, length: 100 , Coded Values: [ANCELL GROUP: ANCELL GROUP] , [CHEROKEE GROUP: CHEROKEE GROUP] , [CHOUTEAU GROUP: CHOUTEAU GROUP] , ...19 more... )
• SUBGROUP ( type: esriFieldTypeString, alias: SUBGROUP, length: 100 , Coded Values: [APPANOOSE SUBGROUP: APPANOOSE SUBGROUP] , [BRONSON SUBGROUP: BRONSON SUBGROUP] , [CABANISS SUBGROUP: CABANISS SUBGROUP] , ...8 more... )
• ELEMENTS ( type: esriFieldTypeString, alias: ELEMENTS, length: 255 )
• RMRK_STRAT ( type: esriFieldTypeString, alias: RMRK_STRAT, length: 250 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 50 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )

Relationships:

• LOGGED_WELLS (1) -- Related To: Well Logs (0)