{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Sinkhole Measurements", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "karst_prod.karst.to_karst_features", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "karst_guid", "composite": true, "catalogID": "{270BF5BB-5283-41B9-8090-7613D95CD422}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "relateid", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "relateid", "type": "esriFieldTypeString", "alias": "Relateid", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "relateid" }, { "name": "observer", "type": "esriFieldTypeString", "alias": "Observer", "domain": { "type": "codedValue", "name": "people_1", "description": "People", "codedValues": [ { "name": "Aaren Mathison", "code": "Aaren Mathison" }, { "name": "Andrew Luhmann", "code": "Andrew Luhmann" }, { "name": "Andrew Peters", "code": "Andrew Peters" }, { "name": "Andrew Retzler", "code": "Andrew Retzler" }, { "name": "Beau Kennedy", "code": "Beau Kennedy" }, { "name": "Bob Tipping", "code": "Bob Tipping" }, { "name": "Caitlin Meyer", "code": "Caitlin Meyer" }, { "name": "Clay Krauss", "code": "Clay Krauss" }, { "name": "Dan Dornik", "code": "Dan Dornik" }, { "name": "Dave Gerboth", "code": "Dave Gerboth" }, { "name": "Dawn Ryan", "code": "Dawn Ryan" }, { "name": "Devin Ehler", "code": "Devin Ehler" }, { "name": "E. Calvin Alexander, Jr.", "code": "E. Calvin Alexander, Jr." }, { "name": "George Schwint", "code": "George Schwint" }, { "name": "Greg Brick", "code": "Greg Brick" }, { "name": "Group Member", "code": "Group Member" }, { "name": "Jake Stacken", "code": "Jake Stacken" }, { "name": "John Ackerman", "code": "John Ackerman" }, { "name": "John Barry", "code": "John Barry" }, { "name": "Julia Steenberg", "code": "Julia Steenberg" }, { "name": "Kevin Kuehner", "code": "Kevin Kuehner" }, { "name": "Martin Larsen", "code": "Martin Larsen" }, { "name": "Neighbor", "code": "Neighbor" }, { "name": "Nikki Wheeler", "code": "Nikki Wheeler" }, { "name": "None", "code": "None" }, { "name": "Owner", "code": "Owner" }, { "name": "Ron Spong", "code": "Ron Spong" }, { "name": "Scott Alexander", "code": "Scott Alexander" }, { "name": "Staff", "code": "Staff" }, { "name": "Tony Runkel", "code": "Tony Runkel" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "observer" }, { "name": "observer_org", "type": "esriFieldTypeString", "alias": "Observer Organization", "domain": { "type": "codedValue", "name": "organization_1", "description": "Organization", "codedValues": [ { "name": "Chosen Valley Testing", "code": "Chosen Valley Testing" }, { "name": "Dakota County Environmental Resources", "code": "Dakota County Environmental Resources" }, { "name": "Dodge County SWCD", "code": "Dodge County SWCD" }, { "name": "ENVIRON Consulting", "code": "ENVIRON Consulting" }, { "name": "Environmental Protection Agency", "code": "Environmental Protection Agency" }, { "name": "Goodhue County SWCD", "code": "Goodhue County SWCD" }, { "name": "Hennepin Conservation District", "code": "Hennepin Conservation District" }, { "name": "Houston County SWCD", "code": "Houston County SWCD" }, { "name": "Middle St. Croix Watershed Management Organization", "code": "Middle St. Croix Watershed Management Organization" }, { "name": "Minnesota Departement of Agriculture", "code": "Minnesota Departement of Agriculture" }, { "name": "Minnesota Department of Health", "code": "Minnesota Department of Health" }, { "name": "Minnesota Department of Natural Resources", "code": "Minnesota Department of Natural Resources" }, { "name": "Minnesota Department of Transportation", "code": "Minnesota Department of Transportation" }, { "name": "Minnesota Geological Survey", "code": "Minnesota Geological Survey" }, { "name": "Minnesota Pollution Control Agency", "code": "Minnesota Pollution Control Agency" }, { "name": "MNDNR Land and Minerals", "code": "MNDNR Land and Minerals" }, { "name": "Mower County SWCD", "code": "Mower County SWCD" }, { "name": "None", "code": "None" }, { "name": "Olmsted County SWCD", "code": "Olmsted County SWCD" }, { "name": "Pollution Control Agency", "code": "Pollution Control Agency" }, { "name": "Soil and Water Conservation District", "code": "Soil and Water Conservation District" }, { "name": "Soil Conservation Service", "code": "Soil Conservation Service" }, { "name": "United States Geological Survey", "code": "United States Geological Survey" }, { "name": "University of Minnesota, Earth and Environmental Sciences", "code": "University of Minnesota, Earth and Environmental Sciences" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Wabasha County SWCD", "code": "Wabasha County SWCD" }, { "name": "Washington Conservation District", "code": "Washington Conservation District" }, { "name": "Winona County", "code": "Winona County" }, { "name": "Winona County SWCD", "code": "Winona County SWCD" }, { "name": "Winona State University", "code": "Winona State University" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "observer_org" }, { "name": "observation_date", "type": "esriFieldTypeDate", "alias": "Observation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "observation_date" }, { "name": "size", "type": "esriFieldTypeString", "alias": "Size", "domain": { "type": "codedValue", "name": "kfsk_size", "description": "Sinkhole Size", "codedValues": [ { "name": "medium, 3-10 meters in diameter", "code": "M" }, { "name": "large, 10-30 meters in diameter", "code": "L" }, { "name": "extra-large, > 30 meters in diameter", "code": "X" }, { "name": "not field checked", "code": "U" }, { "name": "very small, <1m", "code": "V" }, { "name": "small, 1-3 meters in diameter", "code": "S" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "size" }, { "name": "shapes", "type": "esriFieldTypeString", "alias": "Shape of Sinkhole Walls", "domain": { "type": "codedValue", "name": "kfsk_shape", "description": "Shape of Sinkhole Sides or Walls", "codedValues": [ { "name": "Bowl", "code": "B" }, { "name": "Compound", "code": "C" }, { "name": "Funnel", "code": "F" }, { "name": "Shallow Bowl", "code": "O" }, { "name": "Shallow", "code": "S" }, { "name": "Steep", "code": "T" }, { "name": "Not Field Checked", "code": "U" }, { "name": "Vertical", "code": "V" }, { "name": "Complex", "code": "X" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "shapes" }, { "name": "length_meters", "type": "esriFieldTypeDouble", "alias": "Length (Meters)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "length_meters" }, { "name": "width_meters", "type": "esriFieldTypeDouble", "alias": "Width (Meters)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "width_meters" }, { "name": "depth_meters", "type": "esriFieldTypeDouble", "alias": "Depth (Meters)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "depth_meters" }, { "name": "dimension_method", "type": "esriFieldTypeString", "alias": "Dimension Method", "domain": { "type": "codedValue", "name": "kfsk_dim_method", "description": "Method of Generating Sinkhole Dimensions", "codedValues": [ { "name": "taken from engineer's drawings", "code": "D" }, { "name": "estimated in the field", "code": "E" }, { "name": "recalled by landowner or other person", "code": "L" }, { "name": "surveyed", "code": "S" }, { "name": "tape measured", "code": "T" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "dimension_method" }, { "name": "sides", "type": "esriFieldTypeString", "alias": "Sides", "domain": { "type": "codedValue", "name": "kfsk_sides", "description": "Sinkhole Sides", "codedValues": [ { "name": "Shallow", "code": "S" }, { "name": "Steep", "code": "T" }, { "name": "Not Field Checked", "code": "U" }, { "name": "Vertical", "code": "V" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sides" }, { "name": "setting", "type": "esriFieldTypeString", "alias": "Setting", "domain": { "type": "codedValue", "name": "kfsk_setting", "description": "Sinkhole Setting", "codedValues": [ { "name": "crest/plain, topographic high location", "code": "C" }, { "name": "slope, gently to steeply sloped w/out incised waterway", "code": "S" }, { "name": "not field checked", "code": "U" }, { "name": "valley/lowland, topographic low location", "code": "V" }, { "name": "waterway, sloped or level ground w/incised waterway and focused surface runoff", "code": "W" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "setting" }, { "name": "trend", "type": "esriFieldTypeSmallInteger", "alias": "Trend of Sinhole's Long Axis", "domain": { "type": "range", "name": "kfsk_trend", "description": "Trend of Sinkhole", "range": [ 0, 360 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "trend" }, { "name": "activity", "type": "esriFieldTypeString", "alias": "Activity", "domain": { "type": "codedValue", "name": "kfsk_activity", "description": "Sinkhole Activity", "codedValues": [ { "name": "ambiguous", "code": "A" }, { "name": "shows evidence of recent collapse", "code": "C" }, { "name": "inactive sinkhole, no obvious opening, appears to be in-filling w/out water infiltration, includes sinkhole ponds and filled sinkholes", "code": "I" }, { "name": "open sinkhole allowing water infiltration, including those with open drain", "code": "O" }, { "name": "not field checked", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "activity" }, { "name": "treatment", "type": "esriFieldTypeString", "alias": "Treatment", "domain": { "type": "codedValue", "name": "kfsk_treatment", "description": "Most Recent Sinkhole Treatment Method", "codedValues": [ { "name": "surface water diversion way constructed by engineer (i.e. SCS)", "code": "E" }, { "name": "filled with permeable material by engineer", "code": "F" }, { "name": "filled with impermeable seal by engineer, requires grout plus plastic and/or clay", "code": "G" }, { "name": "surface water diversion way contracted by landowner, including ringed sinkholes", "code": "L" }, { "name": "filled with permeable filter material by landowner", "code": "M" }, { "name": "filled with impermeable seal by landowner, requires grout plus plastic and/or clay", "code": "N" }, { "name": "open, untreated", "code": "O" }, { "name": "surface water control, including grass strip, terrace, slope stabilization", "code": "S" }, { "name": "not field checked", "code": "U" }, { "name": "excavated to look for a cave entrance", "code": "X" }, { "name": "filled, treatment unknown", "code": "H" }, { "name": "filled, other - see remarks", "code": "J" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "treatment" }, { "name": "treatment_date", "type": "esriFieldTypeDate", "alias": "Treatment Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "treatment_date" }, { "name": "contents", "type": "esriFieldTypeString", "alias": "Contents in Sinkhole", "domain": { "type": "codedValue", "name": "kfsk_contents", "description": "Sinkhole Contents Deposited by Humans", "codedValues": [ { "name": "animal waste or carcasses", "code": "A" }, { "name": "brush, logs, tree stumps", "code": "B" }, { "name": "demolition debris, including lumber, concrete, metal", "code": "D" }, { "name": "empty", "code": "E" }, { "name": "field rock", "code": "F" }, { "name": "hazardous waste, including pesticide cans and tires", "code": "H" }, { "name": "mixed undifferentiated waste, including household waste and automobiles", "code": "M" }, { "name": "N", "code": "N" }, { "name": "other", "code": "O" }, { "name": "pond", "code": "P" }, { "name": "not field checked", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "contents" }, { "name": "formed_before", "type": "esriFieldTypeDate", "alias": "Sinkhole Formed Before", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "formed_before" }, { "name": "formed_after", "type": "esriFieldTypeDate", "alias": "Sinkhole Formed After", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "formed_after" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "Created User", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "karst_guid", "type": "esriFieldTypeGUID", "alias": "karst_guid", "domain": null, "editable": false, "nullable": true, "length": 38, "defaultValue": null, "modelName": "karst_guid" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" } ], "indexes": [ { "name": "gdb_46_activity", "fields": "activity", "isAscending": true, "isUnique": false, "description": "" }, { "name": "karst_guid_23", "fields": "karst_guid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r23_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Sinkhole Measurements", "description": "", "prototype": { "attributes": { "created_date": null, "relateid": null, "observer": null, "observer_org": null, "observation_date": null, "size": null, "shapes": null, "length_meters": null, "width_meters": null, "depth_meters": null, "dimension_method": null, "sides": null, "setting": null, "trend": null, "activity": null, "treatment": null, "treatment_date": null, "contents": null, "formed_before": null, "formed_after": null, "created_user": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 40000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 40000, "maxRecordCountFactor": 1, "serviceItemId": "f27300e1a8fd4b7caf8a677b5383863c" }