{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 9, "name": "Well Logs Related All", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ORIG_OWNER_FNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "WELL_LOG_NO", "type": "esriFieldTypeOID", "alias": "WELL_LOG_NO", "domain": null }, { "name": "WELL_TYPE_CODE", "type": "esriFieldTypeString", "alias": "WELL_TYPE_CODE", "length": 2, "domain": null }, { "name": "DRILLER_ID", "type": "esriFieldTypeInteger", "alias": "DRILLER_ID", "domain": null }, { "name": "COUNTY_CODE", "type": "esriFieldTypeString", "alias": "COUNTY_CODE", "length": 3, "domain": null }, { "name": "TOWNSHIP_CODE", "type": "esriFieldTypeString", "alias": "TOWNSHIP_CODE", "length": 4, "domain": null }, { "name": "ORIG_OWNER_FNAME", "type": "esriFieldTypeString", "alias": "ORIG_OWNER_FNAME", "length": 20, "domain": null }, { "name": "ORIG_OWNER_LNAME", "type": "esriFieldTypeString", "alias": "ORIG_OWNER_LNAME", "length": 35, "domain": null }, { "name": "DRILL_TYPE_CODE", "type": "esriFieldTypeString", "alias": "DRILL_TYPE_CODE", "length": 3, "domain": null }, { "name": "TEST_TYPE_CODE", "type": "esriFieldTypeString", "alias": "TEST_TYPE_CODE", "length": 1, "domain": null }, { "name": "WELL_USE_CODE", "type": "esriFieldTypeString", "alias": "WELL_USE_CODE", "length": 3, "domain": null }, { "name": "AQUIFER_TYPE_CODE", "type": "esriFieldTypeString", "alias": "AQUIFER_TYPE_CODE", "length": 3, "domain": null }, { "name": "LOCATION_MAP_YEAR", "type": "esriFieldTypeString", "alias": "LOCATION_MAP_YEAR", "length": 4, "domain": null }, { "name": "LOCATION_MAP_AREA", "type": "esriFieldTypeString", "alias": "LOCATION_MAP_AREA", "length": 2, "domain": null }, { "name": "LOCATION_NO", "type": "esriFieldTypeSingle", "alias": "LOCATION_NO", "domain": null }, { "name": "SUBDIVISION_NAME", "type": "esriFieldTypeString", "alias": "SUBDIVISION_NAME", "length": 40, "domain": null }, { "name": "SUBDIVISION_MAP_YEAR", "type": "esriFieldTypeString", "alias": "SUBDIVISION_MAP_YEAR", "length": 4, "domain": null }, { "name": "SUBDIVISION_NO", "type": "esriFieldTypeString", "alias": "SUBDIVISION_NO", "length": 2, "domain": null }, { "name": "PERMIT_NO", "type": "esriFieldTypeString", "alias": "PERMIT_NO", "length": 10, "domain": null }, { "name": "SEC_OWNER_NAME", "type": "esriFieldTypeString", "alias": "SEC_OWNER_NAME", "length": 20, "domain": null }, { "name": "LOT_NO", "type": "esriFieldTypeString", "alias": "LOT_NO", "length": 4, "domain": null }, { "name": "SECTION_NO", "type": "esriFieldTypeSmallInteger", "alias": "SECTION_NO", "domain": null }, { "name": "ST_DIR_CODE", "type": "esriFieldTypeString", "alias": "ST_DIR_CODE", "length": 2, "domain": null }, { "name": "ST_NO", "type": "esriFieldTypeInteger", "alias": "ST_NO", "domain": null }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "ST_NAME", "length": 35, "domain": null }, { "name": "ST_TYPE_CODE", "type": "esriFieldTypeString", "alias": "ST_TYPE_CODE", "length": 4, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 25, "domain": null }, { "name": "STATE_CODE", "type": "esriFieldTypeString", "alias": "STATE_CODE", "length": 2, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 10, "domain": null }, { "name": "LOCATION_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATION_DESCRIPTION", "length": 120, "domain": null }, { "name": "HORIZ_ZONE_CODE", "type": "esriFieldTypeString", "alias": "HORIZ_ZONE_CODE", "length": 1, "domain": null }, { "name": "HORIZ_X", "type": "esriFieldTypeDouble", "alias": "HORIZ_X", "domain": null }, { "name": "HORIZ_Y", "type": "esriFieldTypeDouble", "alias": "HORIZ_Y", "domain": null }, { "name": "HORIZ_DATUM_CODE", "type": "esriFieldTypeString", "alias": "HORIZ_DATUM_CODE", "length": 5, "domain": null }, { "name": "HORIZ_ACC_X", "type": "esriFieldTypeSingle", "alias": "HORIZ_ACC_X", "domain": null }, { "name": "HORIZ_ACC_Y", "type": "esriFieldTypeSingle", "alias": "HORIZ_ACC_Y", "domain": null }, { "name": "VERT_LOC", "type": "esriFieldTypeSingle", "alias": "VERT_LOC", "domain": null }, { "name": "VERT_ACC", "type": "esriFieldTypeSingle", "alias": "VERT_ACC", "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "SOURCE_OF_COORD", "type": "esriFieldTypeString", "alias": "SOURCE_OF_COORD", "length": 30, "domain": null }, { "name": "IS_FLOWING_IND", "type": "esriFieldTypeString", "alias": "IS_FLOWING_IND", "length": 1, "domain": null }, { "name": "TEST_RATE", "type": "esriFieldTypeSingle", "alias": "TEST_RATE", "domain": null }, { "name": "DRAW_DOWN", "type": "esriFieldTypeSingle", "alias": "DRAW_DOWN", "domain": null }, { "name": "DRAW_DOWN_TEST_DUR", "type": "esriFieldTypeSingle", "alias": "DRAW_DOWN_TEST_DUR", "domain": null }, { "name": "S_WATER_LEVEL", "type": "esriFieldTypeDouble", "alias": "S_WATER_LEVEL", "domain": null }, { "name": "S_WATER_MEAS_PT_CODE", "type": "esriFieldTypeString", "alias": "S_WATER_MEAS_PT_CODE", "length": 1, "domain": null }, { "name": "S_WATER_LEVEL_DATE", "type": "esriFieldTypeDate", "alias": "S_WATER_LEVEL_DATE", "length": 8, "domain": null }, { "name": "CASING_HEIGHT", "type": "esriFieldTypeSingle", "alias": "CASING_HEIGHT", "domain": null }, { "name": "TOTAL_DEPTH", "type": "esriFieldTypeSingle", "alias": "TOTAL_DEPTH", "domain": null }, { "name": "COMPLETION_DATE", "type": "esriFieldTypeDate", "alias": "COMPLETION_DATE", "length": 8, "domain": null }, { "name": "LOCATED_IND", "type": "esriFieldTypeString", "alias": "LOCATED_IND", "length": 1, "domain": null }, { "name": "ASSOC_RPT_IND", "type": "esriFieldTypeString", "alias": "ASSOC_RPT_IND", "length": 1, "domain": null }, { "name": "BEDROCK_DEPTH", "type": "esriFieldTypeSmallInteger", "alias": "BEDROCK_DEPTH", "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 1000, "domain": null }, { "name": "DATE_ADDED", "type": "esriFieldTypeDate", "alias": "DATE_ADDED", "length": 8, "domain": null }, { "name": "ADDED_BY", "type": "esriFieldTypeString", "alias": "ADDED_BY", "length": 150, "domain": null }, { "name": "DATE_CHANGED", "type": "esriFieldTypeDate", "alias": "DATE_CHANGED", "length": 8, "domain": null }, { "name": "CHANGED_BY", "type": "esriFieldTypeString", "alias": "CHANGED_BY", "length": 150, "domain": null }, { "name": "SUSTAINED_YIELD", "type": "esriFieldTypeSingle", "alias": "SUSTAINED_YIELD", "domain": null }, { "name": "ATTACH_STATUS", "type": "esriFieldTypeString", "alias": "ATTACH_STATUS", "length": 10, "domain": null }, { "name": "PUMP_TYPE_CODE", "type": "esriFieldTypeString", "alias": "PUMP_TYPE_CODE", "length": 10, "domain": null }, { "name": "PUMP_CAPACITY", "type": "esriFieldTypeSmallInteger", "alias": "PUMP_CAPACITY", "domain": null }, { "name": "PUMP_SET_AT", "type": "esriFieldTypeSmallInteger", "alias": "PUMP_SET_AT", "domain": null }, { "name": "PITLESS_TYPE", "type": "esriFieldTypeString", "alias": "PITLESS_TYPE", "length": 25, "domain": null }, { "name": "PUMP_INST_BY", "type": "esriFieldTypeString", "alias": "PUMP_INST_BY", "length": 35, "domain": null }, { "name": "DEM_ELEV", "type": "esriFieldTypeSingle", "alias": "DEM_ELEV", "domain": null }, { "name": "ASSOC_WELL_LOG_NO", "type": "esriFieldTypeInteger", "alias": "ASSOC_WELL_LOG_NO", "domain": null }, { "name": "ST_POST_DIR_CODE", "type": "esriFieldTypeString", "alias": "ST_POST_DIR_CODE", "length": 2, "domain": null }, { "name": "PROJECT_WELL_ID", "type": "esriFieldTypeString", "alias": "PROJECT_WELL_ID", "length": 15, "domain": null }, { "name": "BR_ELEV", "type": "esriFieldTypeSingle", "alias": "BR_ELEV", "domain": null }, { "name": "COMP_ELEV", "type": "esriFieldTypeSingle", "alias": "COMP_ELEV", "domain": null }, { "name": "EDIT_MADE", "type": "esriFieldTypeSmallInteger", "alias": "EDIT_MADE", "domain": null }, { "name": "LAT", "type": "esriFieldTypeDouble", "alias": "LAT", "domain": null }, { "name": "LON", "type": "esriFieldTypeDouble", "alias": "LON", "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 10, "domain": null }, { "name": "SubmittedDate", "type": "esriFieldTypeDate", "alias": "SubmittedDate", "length": 8, "domain": null }, { "name": "AcceptedDate", "type": "esriFieldTypeDate", "alias": "AcceptedDate", "length": 8, "domain": null }, { "name": "CoordinatesLocked", "type": "esriFieldTypeString", "alias": "CoordinatesLocked", "length": 1, "domain": null }, { "name": "DRILL_TYPE_OTHER", "type": "esriFieldTypeString", "alias": "DRILL_TYPE_OTHER", "length": 50, "domain": null }, { "name": "Include_Diagram_In_Rep", "type": "esriFieldTypeString", "alias": "Include_Diagram_In_Rep", "length": 1, "domain": null }, { "name": "COUNTY_DESC", "type": "esriFieldTypeString", "alias": "COUNTY_DESC", "length": 50, "domain": null }, { "name": "TOWNSHIP_DESC", "type": "esriFieldTypeString", "alias": "TOWNSHIP_DESC", "length": 20, "domain": null }, { "name": "AQUIFER_TYPE_DESC", "type": "esriFieldTypeString", "alias": "AQUIFER_TYPE_DESC", "length": 20, "domain": null }, { "name": "WELL_USE_DESC", "type": "esriFieldTypeString", "alias": "WELL_USE_DESC", "length": 15, "domain": null }, { "name": "DRILLER_NAME", "type": "esriFieldTypeString", "alias": "DRILLER_NAME", "length": 35, "domain": null }, { "name": "PUMP_TYPE_DESC", "type": "esriFieldTypeString", "alias": "PUMP_TYPE_DESC", "length": 25, "domain": null }, { "name": "BOREHOLE_CASING_ID", "type": "esriFieldTypeDouble", "alias": "BOREHOLE_CASING_ID", "domain": null }, { "name": "BOREHOLE_DEPTH", "type": "esriFieldTypeSingle", "alias": "BOREHOLE_DEPTH", "domain": null }, { "name": "BOREHOLE_DIAM", "type": "esriFieldTypeSingle", "alias": "BOREHOLE_DIAM", "domain": null }, { "name": "CASING_DIAM", "type": "esriFieldTypeSingle", "alias": "CASING_DIAM", "domain": null }, { "name": "CASING_LENGTH", "type": "esriFieldTypeSingle", "alias": "CASING_LENGTH", "domain": null }, { "name": "CASING_THICKNESS", "type": "esriFieldTypeSingle", "alias": "CASING_THICKNESS", "domain": null }, { "name": "CASING_TYPE_CODE", "type": "esriFieldTypeString", "alias": "CASING_TYPE_CODE", "length": 10, "domain": null }, { "name": "JOINT_TYPE_CODE", "type": "esriFieldTypeString", "alias": "JOINT_TYPE_CODE", "length": 10, "domain": null }, { "name": "CASING_PERF_FROM", "type": "esriFieldTypeSingle", "alias": "CASING_PERF_FROM", "domain": null }, { "name": "CASING_PERF_TO", "type": "esriFieldTypeSingle", "alias": "CASING_PERF_TO", "domain": null }, { "name": "JOINT_TYPE_OTHER", "type": "esriFieldTypeString", "alias": "JOINT_TYPE_OTHER", "length": 10, "domain": null }, { "name": "WELL_TEST_ID", "type": "esriFieldTypeInteger", "alias": "WELL_TEST_ID", "domain": null }, { "name": "WELL_TEST_DATE", "type": "esriFieldTypeDate", "alias": "WELL_TEST_DATE", "length": 8, "domain": null }, { "name": "STATIC_WATER_LEVEL", "type": "esriFieldTypeDouble", "alias": "STATIC_WATER_LEVEL", "domain": null }, { "name": "SWL_DATUM_CODE", "type": "esriFieldTypeString", "alias": "SWL_DATUM_CODE", "length": 1, "domain": null }, { "name": "PUMP_TEST_TYPE_CODE", "type": "esriFieldTypeString", "alias": "PUMP_TEST_TYPE_CODE", "length": 3, "domain": null }, { "name": "PUMP_TEST_RATE_GPM", "type": "esriFieldTypeSingle", "alias": "PUMP_TEST_RATE_GPM", "domain": null }, { "name": "PUMP_TEST_DURATION", "type": "esriFieldTypeSingle", "alias": "PUMP_TEST_DURATION", "domain": null }, { "name": "PUMP_TEST_DRAWDOWN_FT", "type": "esriFieldTypeSingle", "alias": "PUMP_TEST_DRAWDOWN_FT", "domain": null }, { "name": "WellTestSustainedYield", "type": "esriFieldTypeSingle", "alias": "WellTestSustainedYield", "domain": null }, { "name": "WATER_QUALITY", "type": "esriFieldTypeString", "alias": "WATER_QUALITY", "length": 500, "domain": null }, { "name": "fileVersionNumber", "type": "esriFieldTypeInteger", "alias": "fileVersionNumber", "domain": null }, { "name": "FILENAME", "type": "esriFieldTypeString", "alias": "FILENAME", "length": 50, "domain": null }, { "name": "GEO_TYPE_CODE", "type": "esriFieldTypeString", "alias": "GEO_TYPE_CODE", "length": 3, "domain": null }, { "name": "GEO_SEQ_NO", "type": "esriFieldTypeSmallInteger", "alias": "GEO_SEQ_NO", "domain": null }, { "name": "completion_year", "type": "esriFieldTypeInteger", "alias": "completion_year", "domain": null }, { "name": "LINKED_SRN", "type": "esriFieldTypeInteger", "alias": "LINKED_SRN", "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "00eee504e5f24dc5b157a47064bf125c" }