{ "layers": [], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 1, "name": "CWI Construction Information, Table 2", "type": "Table", "description": "This table conatains ADDITIONAL information describing the construction of the well. This includes the casing, the screen, open hole, and grout. This table has a many-to-one relationship to the c5ix (index) table.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RELATEID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "C5C2_SEQ_NO", "type": "esriFieldTypeBigInteger", "alias": "C5C2_SEQ_NO", "domain": null }, { "name": "RELATEID", "type": "esriFieldTypeString", "alias": "RELATEID", "length": 10, "domain": null }, { "name": "CONSTYPE", "type": "esriFieldTypeString", "alias": "CONSTYPE", "length": 1, "domain": null }, { "name": "FROM_DEPTH", "type": "esriFieldTypeDouble", "alias": "FROM_DEPTH", "domain": null }, { "name": "TO_DEPTH", "type": "esriFieldTypeDouble", "alias": "TO_DEPTH", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "DIAMETER", "domain": null }, { "name": "SLOT", "type": "esriFieldTypeSmallInteger", "alias": "SLOT", "domain": null }, { "name": "LENGTH", "type": "esriFieldTypeDouble", "alias": "LENGTH", "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "MATERIAL", "length": 1, "domain": null }, { "name": "AMOUNT", "type": "esriFieldTypeDouble", "alias": "AMOUNT", "domain": null }, { "name": "UNITS", "type": "esriFieldTypeString", "alias": "UNITS", "length": 1, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeBigInteger", "alias": "OBJECTID", "domain": null }, { "name": "WELLID", "type": "esriFieldTypeInteger", "alias": "WELLID", "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "64fdb7194e944ef0b7487d012a78ebf2" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "CWI Static Water Levels", "type": "Table", "description": "Historic static water level information.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RELATEID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "C5WL_SEQ_NO", "type": "esriFieldTypeBigInteger", "alias": "C5WL_SEQ_NO", "domain": null }, { "name": "RELATEID", "type": "esriFieldTypeString", "alias": "RELATEID", "length": 10, "domain": null }, { "name": "MEAS_TYPE", "type": "esriFieldTypeString", "alias": "MEAS_TYPE", "length": 2, "domain": null }, { "name": "MEAS_DATE", "type": "esriFieldTypeInteger", "alias": "MEAS_DATE", "domain": null }, { "name": "MEAS_TIME", "type": "esriFieldTypeInteger", "alias": "MEAS_TIME", "domain": null }, { "name": "M_PT_CODE", "type": "esriFieldTypeString", "alias": "M_PT_CODE", "length": 1, "domain": null }, { "name": "MEAS_POINT", "type": "esriFieldTypeDouble", "alias": "MEAS_POINT", "domain": null }, { "name": "MEASUREMT", "type": "esriFieldTypeDouble", "alias": "MEASUREMT", "domain": null }, { "name": "MEAS_ELEV", "type": "esriFieldTypeDouble", "alias": "MEAS_ELEV", "domain": null }, { "name": "DATA_SRC", "type": "esriFieldTypeString", "alias": "DATA_SRC", "length": 5, "domain": null }, { "name": "PROGRAM", "type": "esriFieldTypeString", "alias": "PROGRAM", "length": 7, "domain": null }, { "name": "ENTRY_DATE", "type": "esriFieldTypeInteger", "alias": "ENTRY_DATE", "domain": null }, { "name": "UPDT_DATE", "type": "esriFieldTypeInteger", "alias": "UPDT_DATE", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeBigInteger", "alias": "OBJECTID", "domain": null }, { "name": "WELLID", "type": "esriFieldTypeInteger", "alias": "WELLID", "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "64fdb7194e944ef0b7487d012a78ebf2" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 3, "name": "CWI Stratigraphy", "type": "Table", "description": "Driller's description, interpreted stratigraphy, lithology. The driller's description of geologic materials encountered while drilling the well and the geologist's corresponding geologic interpretation.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RELATEID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "C5ST_SEQ_NO", "type": "esriFieldTypeBigInteger", "alias": "C5ST_SEQ_NO", "domain": null }, { "name": "RELATEID", "type": "esriFieldTypeString", "alias": "RELATEID", "length": 10, "domain": null }, { "name": "DEPTH_TOP", "type": "esriFieldTypeInteger", "alias": "DEPTH_TOP", "domain": null }, { "name": "DEPTH_BOT", "type": "esriFieldTypeInteger", "alias": "DEPTH_BOT", "domain": null }, { "name": "DRLLR_DESC", "type": "esriFieldTypeString", "alias": "DRLLR_DESC", "length": 34, "domain": null }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "COLOR", "length": 8, "domain": null }, { "name": "HARDNESS", "type": "esriFieldTypeString", "alias": "HARDNESS", "length": 8, "domain": null }, { "name": "STRAT", "type": "esriFieldTypeString", "alias": "STRAT", "length": 4, "domain": null }, { "name": "LITH_PRIM", "type": "esriFieldTypeString", "alias": "LITH_PRIM", "length": 4, "domain": null }, { "name": "LITH_SEC", "type": "esriFieldTypeString", "alias": "LITH_SEC", "length": 4, "domain": null }, { "name": "LITH_MINOR", "type": "esriFieldTypeString", "alias": "LITH_MINOR", "length": 4, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeBigInteger", "alias": "OBJECTID", "domain": null }, { "name": "SIMSTRAT", "type": "esriFieldTypeString", "alias": "SIMSTRAT", "length": 4000, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "64fdb7194e944ef0b7487d012a78ebf2" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 4, "name": "CWI Main Index table (subset)", "type": "Table", "description": "This view of the CWI Main Index table contains only those columns that are needed for the MDH Wells Cross-Section ArcMap Addin.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RELATEID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RELATEID", "type": "esriFieldTypeString", "alias": "RELATEID", "length": 10, "domain": null }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "DEPTH_DRLL", "type": "esriFieldTypeDouble", "alias": "DEPTH_DRLL", "domain": null }, { "name": "CASE_DIAM", "type": "esriFieldTypeDouble", "alias": "CASE_DIAM", "domain": null }, { "name": "CASE_DEPTH", "type": "esriFieldTypeDouble", "alias": "CASE_DEPTH", "domain": null }, { "name": "AQUIFER", "type": "esriFieldTypeString", "alias": "AQUIFER", "length": 4, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "64fdb7194e944ef0b7487d012a78ebf2" } ] }