Layers:

Layer: LOGGED WELLS (0)

Name: LOGGED WELLS

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This data set provides locations of wells with information about the available well logs, geologic data, groundwater levels, well construction details and general remarks.

Service Item Id: 2eca524425544f889015e7f69277524c

Copyright Text:

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:
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: false
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: ID, length: 15 )
• WELL_TYPE ( type: esriFieldTypeString, alias: WELL_TYPE, 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... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, length: 100 )
• DRLDATE ( type: esriFieldTypeString, alias: DRLDATE, length: 15 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SCANTYPE ( type: esriFieldTypeSmallInteger, alias: SCANTYPE , Coded Values: [0: None] , [1: Strip Log] , [2: Log Notes] , ...2 more... )
• SMPL_LOG ( type: esriFieldTypeSmallInteger, alias: SMPL_LOG , Coded Values: [0: No] , [1: Yes] )
• DRILL_LOG ( type: esriFieldTypeSmallInteger, alias: DRILL_LOG , Coded Values: [0: No] , [1: Yes] )
• OTHER_LOG ( type: esriFieldTypeSmallInteger, alias: OTHER_LOG , Coded Values: [0: No] , [1: Yes] )
• CUTTINGS_ ( type: esriFieldTypeSmallInteger, alias: CUTTINGS_ , Coded Values: [0: No] , [1: Yes] )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 35 , Coded Values: [Adair: Adair] , [Andrew: Andrew] , [Atchison: Atchison] , ...112 more... )
• FIPS ( type: esriFieldTypeString, alias: FIPS, length: 5 , Coded Values: [29001: Adair] , [29003: Andrew] , [29005: Atchison] , ...112 more... )
• QUADRANGLE ( type: esriFieldTypeString, alias: QUADRANGLE, length: 50 , Coded Values: [Acorn Ridge: Acorn Ridge] , [Adrian: Adrian] , [Advance: Advance] , ...1289 more... )
• TWP_TEXT ( type: esriFieldTypeString, alias: TWP_TEXT, length: 9 )
• RNG_TEXT ( type: esriFieldTypeString, alias: RNG_TEXT, length: 9 )
• SEC_TEXT ( type: esriFieldTypeString, alias: SEC_TEXT, length: 9 )
• PLSS_LABEL ( type: esriFieldTypeString, alias: PLSS_LABEL, length: 14 )
• LOCATOR ( type: esriFieldTypeString, alias: LOCATOR, length: 100 )
• UPDATELOC ( type: esriFieldTypeSmallInteger, alias: UPDATELOC , Coded Values: [2: Not relocated] , [1: Relocated] , [-1: Not resolved] )
• ELEV ( type: esriFieldTypeDouble, alias: ELEV )
• ELEV_SOURCE ( type: esriFieldTypeString, alias: ELEV_SOURCE, length: 50 )
• TOTDEPTH ( type: esriFieldTypeDouble, alias: TOTDEPTH )
• DEPTHBED ( type: esriFieldTypeDouble, alias: DEPTHBED )
• SWL_AFTER ( type: esriFieldTypeInteger, alias: SWL_AFTER )
• SWL_BEFORE ( type: esriFieldTypeInteger, alias: SWL_BEFORE )
• SWLA_ELEV ( type: esriFieldTypeSmallInteger, alias: SWLA_ELEV )
• SWLB_ELEV ( type: esriFieldTypeSmallInteger, alias: SWLB_ELEV )
• WATER_AT ( type: esriFieldTypeString, alias: WATER_AT, length: 100 )
• DRAWDOWN ( type: esriFieldTypeInteger, alias: DRAWDOWN )
• WELL_YIELD ( type: esriFieldTypeDouble, alias: WELL_YIELD )
• FORM_SUR ( type: esriFieldTypeString, alias: FORM_SUR, 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: FORM_UBK, 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: FORM_CP, 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: FORM_TD, 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: ALT_ID1, length: 15 )
• ALT_ID2 ( type: esriFieldTypeString, alias: ALT_ID2, length: 15 )
• SDWIS_ID ( type: esriFieldTypeInteger, alias: SDWIS_ID )
• WWIMSID ( type: esriFieldTypeString, alias: WWIMSID, length: 10 )
• API_ID ( type: esriFieldTypeString, alias: API_ID, length: 50 )
• XREF_NUM ( type: esriFieldTypeString, alias: XREF_NUM, length: 50 )
• MINERAL_BH ( type: esriFieldTypeString, alias: MINERAL_BH, length: 50 )
• ADDITIONAL ( type: esriFieldTypeString, alias: ADDITIONAL, length: 100 )
• LEASE ( type: esriFieldTypeString, alias: LEASE, length: 150 )
• DRILLER ( type: esriFieldTypeString, alias: DRILLER, length: 150 )
• LOGGER ( type: esriFieldTypeString, alias: LOGGER, length: 150 )
• LOGDATE ( type: esriFieldTypeString, alias: LOGDATE, length: 20 )
• G_STRUCTURE ( type: esriFieldTypeSmallInteger, alias: G_STRUCTURE , Coded Values: [0: No] , [1: Yes] )
• CAUTION ( type: esriFieldTypeSmallInteger, alias: CAUTION , Coded Values: [0: No] , [1: Yes] )
• REMARKS_ ( type: esriFieldTypeString, alias: REMARKS_, length: 1073741822 )
• INTCRDTP ( type: esriFieldTypeDouble, alias: INTCRDTP )
• INTCRDBT ( type: esriFieldTypeDouble, alias: INTCRDBT )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, length: 255 )
• 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: 2eca524425544f889015e7f69277524c

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: false
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: LOGGED WELLS (0)

Table: GEOLOGY.tblSTATIGRAPHY (2)

Name: GEOLOGY.tblSTATIGRAPHY

Display Field: INTERVAL_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 2eca524425544f889015e7f69277524c

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: false
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: LOGGED WELLS (0)