{ "layers": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 0, "name": "Subsidence Incident Reports", "type": "Feature Layer", "description": "What is a Subsidence Incident? Sinkholes are closed depressions in areas underlain by soluble rock such as limestone, dolostone, gypsum, or salt. Sinkholes form when surface sediments subside into underground voids created by the dissolving action of groundwater in the underlying bedrock. Other subterranean events can cause holes, depressions or subsidence of the land surface that may mimic sinkhole activity. These include subsurface expansive clay or organic layers which compress as water is removed, collapsed or broken sewer and drain pipes or broken septic tanks, improperly compacted soil after excavation work, and even buried trash, logs and other debris. Commonly, a reported depression is not verified by a licensed professional geologist to be a true sinkhole, and the cause of subsidence is not known. Such an event is called a subsidence incident. The Florida Geological Survey maintains and provides a downloadable database of reported subsidence incidents statewide. While this data may include some true sinkholes, the majority of the incidents have not been field-checked and the cause of subsidence is not verified.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102967, "latestWkid": 6439, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -19550100, "falseY": -7526400, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "FDEP, Florida Geological Survey", "parentLayer": null, "subLayers": [], "minScale": 5000000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "564bf63a83dbaff22858299693a725cc", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACzklEQVQ4jb2UXUiTURjHf3MzNzWcOiwv1AK/CHWKeWF2E14Y+uIYzMBAlAIxNLwywg988WOUuxKVvAoFUczdDFS60W4yoRSnRjgzwg8MQ52BbuLX4t0sv7UgeuBwXt5zzo/n/3/OeRT841D8V6AoolxZoWh9naS9PS75+WFTq3lhNLL0V0BRxH9qileNjdy125Gp1eDtDcvL4ONDtSAwkZiIoa6OzxcCKyu5brEwNjNDQFkZFBRAWJhnbXUVzGaorSXBauVTWRk6k4n+M4GiiKKvjxG7nYCREYiOhrU11js6mHY42MvM5FphIRqDAXQ6FF1dWCoruXE40yPAuTlarVaCRkc9sOpqhqRsXC6CAAdw2WDgbWcnqRYLcq0WhdWKGdCeChwa4r4kMT4eWlp4X1NDNKAD3uxviTGb6QGGe3q4XVUFpaUklJdz5VehfgPLy0kwGlG1tIDLhau0FMm5x4dgUtiAHLOZ8YUFlg0GNEVFblseSY4dATqdJElzVBTMzvJtd5erQO8pl0CCfunvxyH5qdHAxgYxJyR7ebElzTs7oFS6/3sBSmDjFKivry+b0sf29sHZI0ClkndyOYyPg15PiEqFzenkAWA6BrsjkxEsCGjm591y8fdn7ASwvp7Z5GTs7e0E6vXQ28t2errHF+AluDMSgKaqKibUatKamiAwEFdwMK2nVjk1lWfNzTzv64OsLOIGBvgoCDx0OmkA9uRylhob+VpcTNr0NJhM7n2vRdEj/wSwuZmGrCzycnOJ6+ryQB0OWFzk+9YWOxERhMpkhE5OQnY2REbyIzaWe+c+vZQUUoAPgkCcTgf5+aDVEqJQwOAgdHdDWxskJrKakcFNUWT9XOB++vElJTwZHuZpTg6Bu7sH6zExOPPy6AwPp0gU2Tl+/sz2JckHGioqiNjc5JbUvlQqxoxGJmzSTTwjLmywUvXBPf4o/nnH/gkryPqIC3JhkAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "scaleSymbols": false, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 141644.40749999898, "ymin": 64049.7582, "xmax": 791244.458900001, "ymax": 775190.6995, "spatialReference": { "wkid": 102967, "latestWkid": 6439, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -19550100, "falseY": -7526400, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "REF_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REF_NUM", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 255, "domain": null }, { "name": "DATE_REV", "type": "esriFieldTypeDate", "alias": "Date Revised ", "length": 8, "domain": null }, { "name": "EVENT_DATE", "type": "esriFieldTypeDate", "alias": "Date of Reported Event", "length": 8, "domain": null }, { "name": "TRUE_SINK", "type": "esriFieldTypeString", "alias": "Verified Sinkhole", "length": 255, "domain": { "type": "codedValue", "name": "LOGICODE", "description": "Logical Coding: Yes, No, Unknown", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LONGDD", "type": "esriFieldTypeDouble", "alias": "Longitude Decimal Degrees", "domain": null }, { "name": "LATDD", "type": "esriFieldTypeDouble", "alias": "Latitude Decimal Degrees", "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 255, "domain": { "type": "codedValue", "name": "COUNTIES", "description": "Counties", "codedValues": [ { "name": "Alachua", "code": "ALACHUA" }, { "name": "Baker", "code": "BAKER" }, { "name": "Bay", "code": "BAY" }, { "name": "Bradford", "code": "BRADFORD" }, { "name": "Brevard", "code": "BREVARD" }, { "name": "Broward", "code": "BROWARD" }, { "name": "Calhoun", "code": "CALHOUN" }, { "name": "Charlotte", "code": "CHARLOTTE" }, { "name": "Citrus", "code": "CITRUS" }, { "name": "Clay", "code": "CLAY" }, { "name": "Collier", "code": "COLLIER" }, { "name": "Columbia", "code": "COLUMBIA" }, { "name": "Dade", "code": "DADE" }, { "name": "Desoto", "code": "DESOTO" }, { "name": "Dixie", "code": "DIXIE" }, { "name": "Duval", "code": "DUVAL" }, { "name": "Escambia", "code": "ESCAMBIA" }, { "name": "Flagler", "code": "FLAGLER" }, { "name": "Franklin", "code": "FRANKLIN" }, { "name": "Gadsden", "code": "GADSDEN" }, { "name": "Gilchrist", "code": "GILCHRIST" }, { "name": "Glades", "code": "GLADES" }, { "name": "Gulf", "code": "GULF" }, { "name": "Hamilton", "code": "HAMILTON" }, { "name": "Hardee", "code": "HARDEE" }, { "name": "Hendry", "code": "HENDRY" }, { "name": "Hernando", "code": "HERNANDO" }, { "name": "Highlands", "code": "HIGHLANDS" }, { "name": "Hillsborough", "code": "HILLSBOROUGH" }, { "name": "Holmes", "code": "HOLMES" }, { "name": "Indian River", "code": "INDIAN RIVER" }, { "name": "Jackson", "code": "JACKSON" }, { "name": "Jefferson", "code": "JEFFERSON" }, { "name": "Lafayette", "code": "LAFAYETTE" }, { "name": "Lake", "code": "LAKE" }, { "name": "Lee", "code": "LEE" }, { "name": "Leon", "code": "LEON" }, { "name": "Levy", "code": "LEVY" }, { "name": "Liberty", "code": "LIBERTY" }, { "name": "Madison", "code": "MADISON" }, { "name": "Manatee", "code": "MANATEE" }, { "name": "Marion", "code": "MARION" }, { "name": "Martin", "code": "MARTIN" }, { "name": "Monroe", "code": "MONROE" }, { "name": "Nassau", "code": "NASSAU" }, { "name": "Okaloosa", "code": "OKALOOSA" }, { "name": "Okeechobee", "code": "OKEECHOBEE" }, { "name": "Orange", "code": "ORANGE" }, { "name": "Osceola", "code": "OSCEOLA" }, { "name": "Palm Beach", "code": "PALM BEACH" }, { "name": "Pasco", "code": "PASCO" }, { "name": "Pinellas", "code": "PINELLAS" }, { "name": "Polk", "code": "POLK" }, { "name": "Putnam", "code": "PUTNAM" }, { "name": "St. Johns", "code": "ST. JOHNS" }, { "name": "St. Lucie", "code": "ST. LUCIE" }, { "name": "Santa Rosa", "code": "SANTA ROSA" }, { "name": "Sarasota", "code": "SARASOTA" }, { "name": "Seminole", "code": "SEMINOLE" }, { "name": "Sumter", "code": "SUMTER" }, { "name": "Suwannee", "code": "SUWANNEE" }, { "name": "Taylor", "code": "TAYLOR" }, { "name": "Union", "code": "UNION" }, { "name": "Volusia", "code": "VOLUSIA" }, { "name": "Wakulla", "code": "WAKULLA" }, { "name": "Walton", "code": "WALTON" }, { "name": "Washington", "code": "WASHINGTON" }, { "name": "Offshore", "code": "OFFSHORE" }, { "name": "To Be Assigned", "code": "To Be Assigned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TWNSHP", "type": "esriFieldTypeInteger", "alias": "PLSS Township", "domain": null }, { "name": "TWNSHP_D", "type": "esriFieldTypeString", "alias": "Township Cardinal Direction", "length": 255, "domain": { "type": "codedValue", "name": "DIRECTION", "description": "Cardinal Direction", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "W", "code": "W" }, { "name": "E", "code": "E" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RANGE", "type": "esriFieldTypeInteger", "alias": "PLSS Range", "domain": null }, { "name": "RANGE_D", "type": "esriFieldTypeString", "alias": "Range Cardinal Direction", "length": 255, "domain": { "type": "codedValue", "name": "DIRECTION", "description": "Cardinal Direction", "codedValues": [ { "name": "N", "code": "N" }, { "name": "S", "code": "S" }, { "name": "W", "code": "W" }, { "name": "E", "code": "E" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SECTION", "type": "esriFieldTypeInteger", "alias": "PLSS Section", "domain": null }, { "name": "QTRSECT1", "type": "esriFieldTypeString", "alias": "Quarter Section 1", "length": 255, "domain": null }, { "name": "QTRSECT2", "type": "esriFieldTypeString", "alias": "Quarter Section 2", "length": 255, "domain": null }, { "name": "ACCURACY", "type": "esriFieldTypeString", "alias": "Accuracy", "length": 50, "domain": null }, { "name": "RPT_SOURCE", "type": "esriFieldTypeString", "alias": "Source of Report", "length": 255, "domain": null }, { "name": "RPT_NAME", "type": "esriFieldTypeString", "alias": "Report Name", "length": 255, "domain": null }, { "name": "OCITY", "type": "esriFieldTypeString", "alias": "Owner's City", "length": 255, "domain": null }, { "name": "OZIP", "type": "esriFieldTypeInteger", "alias": "Owner's Zip Code", "domain": null }, { "name": "SIZDIM", "type": "esriFieldTypeString", "alias": "Dimensions", "length": 255, "domain": null }, { "name": "SINSHAPE", "type": "esriFieldTypeString", "alias": "Shape", "length": 255, "domain": null }, { "name": "SINLNGTH", "type": "esriFieldTypeDouble", "alias": "Length (ft)", "domain": null }, { "name": "SINWIDTH", "type": "esriFieldTypeDouble", "alias": "Width (ft)", "domain": null }, { "name": "SINDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth (ft)", "domain": null }, { "name": "SLOPE", "type": "esriFieldTypeInteger", "alias": "Slope of Sides", "domain": null }, { "name": "WATSIN", "type": "esriFieldTypeString", "alias": "Water Visible", "length": 255, "domain": null }, { "name": "WATBLS", "type": "esriFieldTypeInteger", "alias": "Water Below Land Surface (ft)", "domain": null }, { "name": "LIMVIS", "type": "esriFieldTypeString", "alias": "Limestone Visible", "length": 255, "domain": null }, { "name": "CAVVIS", "type": "esriFieldTypeString", "alias": "Cave Visible", "length": 255, "domain": null }, { "name": "SUBRATE", "type": "esriFieldTypeString", "alias": "Subsidence Rate", "length": 255, "domain": null }, { "name": "PROPDAM", "type": "esriFieldTypeString", "alias": "Property Damage", "length": 255, "domain": null }, { "name": "REPAIR_S", "type": "esriFieldTypeString", "alias": "Repair Status", "length": 50, "domain": null }, { "name": "DRAINSTR", "type": "esriFieldTypeString", "alias": "Drainage Structures Present", "length": 255, "domain": null }, { "name": "SOILTYPE", "type": "esriFieldTypeString", "alias": "Soil Type", "length": 255, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "COMMENTS_2", "type": "esriFieldTypeString", "alias": "Additional Comments", "length": 255, "domain": null }, { "name": "ACCESS_", "type": "esriFieldTypeString", "alias": "Access to Sink", "length": 255, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "G11690REF_NUM", "fields": "REF_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R468054_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A1647_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "FGS_TRIGGERS", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AF55D66A-0421-4D22-90F0-14E0AC569099}" }, { "id": 1, "name": "FGS_COLLAPSE", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{86F4A89A-FB73-4A22-AB31-499BC0DDF73C}" }, { "id": 2, "name": "FGS_TOPOS", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E24F6F68-2D19-4912-A192-9DA1CFD4C446}" }, { "id": 3, "name": "FGS_LANDUSE", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EDA51AC3-6921-4F9B-A871-499B3D4F0F9A}" } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "7971bf57e5ac44069ea758b7a379ce2d" } ], "tables": [ { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "DEP.FGS_TOPOS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "REF_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REF_NUM", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 255, "domain": null }, { "name": "TOPO", "type": "esriFieldTypeString", "alias": "Topography", "length": 50, "domain": { "type": "codedValue", "name": "TOPO", "description": "Topography codes for the feature location", "codedValues": [ { "name": "Flat", "code": "1" }, { "name": "Hill top", "code": "2" }, { "name": "Slope", "code": "3" }, { "name": "Valley", "code": "4" }, { "name": "Depression", "code": "5" }, { "name": "See Comments", "code": "6" }, { "name": "Unknown/Unknown-unknown", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G11693REF_NUM", "fields": "REF_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R468057_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "FGS_SUBSIDENCE_INCIDENTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{E24F6F68-2D19-4912-A192-9DA1CFD4C446}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "7971bf57e5ac44069ea758b7a379ce2d" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "DEP.FGS_TRIGGERS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "REF_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REF_NUM", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 255, "domain": null }, { "name": "TRIGGERS", "type": "esriFieldTypeString", "alias": "Triggers", "length": 50, "domain": { "type": "codedValue", "name": "TRIGGER", "description": "Trigger mechanism for the subsidence", "codedValues": [ { "name": "Unknown-unknown", "code": "0" }, { "name": "New Construction", "code": "1" }, { "name": "Well drilling", "code": "2" }, { "name": "Blasting", "code": "3" }, { "name": "Ground Loading", "code": "4" }, { "name": "Excessive Rainfall", "code": "5" }, { "name": "Pumpage", "code": "6" }, { "name": "Drought or low water table", "code": "7" }, { "name": "Known-unknown", "code": "8" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G11694REF_NUM", "fields": "REF_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R468058_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "FGS_SUBSIDENCE_INCIDENTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AF55D66A-0421-4D22-90F0-14E0AC569099}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "7971bf57e5ac44069ea758b7a379ce2d" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 3, "name": "DEP.FGS_COLLAPSE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "REF_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REF_NUM", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 255, "domain": null }, { "name": "COL_CODE", "type": "esriFieldTypeString", "alias": "Pre-Collapse Indicators", "length": 4, "domain": { "type": "codedValue", "name": "PRECOLLAPSE", "description": "Pre-collapse Indicators", "codedValues": [ { "name": "Runoff Pounding", "code": "1" }, { "name": "Ground Cracks/Fractures", "code": "2" }, { "name": "Tilting Objects", "code": "3" }, { "name": "Small Holes", "code": "4" }, { "name": "Well Turbidity", "code": "5" }, { "name": "Vegetation Changes", "code": "6" }, { "name": "Unknown", "code": "7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G11691REF_NUM", "fields": "REF_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R468055_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "FGS_SUBSIDENCE_INCIDENTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{86F4A89A-FB73-4A22-AB31-499BC0DDF73C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "7971bf57e5ac44069ea758b7a379ce2d" }, { "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 4, "name": "DEP.FGS_LANDUSE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "REF_NUM", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "REF_NUM", "type": "esriFieldTypeString", "alias": "Reference Number", "length": 255, "domain": null }, { "name": "LANDUSE", "type": "esriFieldTypeString", "alias": "Land Use", "length": 50, "domain": { "type": "codedValue", "name": "LUCODE", "description": "Land Use Code", "codedValues": [ { "name": "Cropland(Agriculture)", "code": "1" }, { "name": "Pasture", "code": "2" }, { "name": "Forest", "code": "3" }, { "name": "Grove", "code": "4" }, { "name": "Wetland", "code": "5" }, { "name": "Suburban(Low Density Residential)", "code": "6" }, { "name": "Urban (Medium/High Density Residential)", "code": "7" }, { "name": "Industrial/Commercial", "code": "8" }, { "name": "Unknown-unknown", "code": "0" }, { "name": "Known-unknown", "code": "9" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G11692REF_NUM", "fields": "REF_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R468056_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "FGS_SUBSIDENCE_INCIDENTS", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "REF_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{EDA51AC3-6921-4F9B-A871-499B3D4F0F9A}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": "7971bf57e5ac44069ea758b7a379ce2d" } ] }