{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 33, "name": "wildlife_complaint_inquiry_logs", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "township_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "dnr_recorder_user", "type": "esriFieldTypeString", "alias": "dnr_recorder_user", "length": 64, "domain": null }, { "name": "inquiry_date", "type": "esriFieldTypeDate", "alias": "inquiry_date", "length": 8, "domain": null }, { "name": "complainant_party_id", "type": "esriFieldTypeInteger", "alias": "complainant_party_id", "domain": null }, { "name": "township_name", "type": "esriFieldTypeString", "alias": "township_name", "length": 255, "domain": null }, { "name": "complainant_loss_estimate", "type": "esriFieldTypeDouble", "alias": "complainant_loss_estimate", "domain": null }, { "name": "site_visit_needed_flag", "type": "esriFieldTypeSmallInteger", "alias": "site_visit_made_flag", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "emergency_action_flag", "type": "esriFieldTypeSmallInteger", "alias": "emergency_action_flag", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cdma_flag", "type": "esriFieldTypeSmallInteger", "alias": "cdma_flag", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 10000, "domain": null }, { "name": "cdma_id", "type": "esriFieldTypeInteger", "alias": "cdma_id", "domain": null }, { "name": "responsible_office", "type": "esriFieldTypeString", "alias": "responsible_office", "length": 4, "domain": { "type": "codedValue", "name": "dnr_wildlife_offices", "description": "Description", "codedValues": [ { "name": "Baudette", "code": "W111" }, { "name": "Bemidji", "code": "W112" }, { "name": "Crookston", "code": "W113" }, { "name": "Detroit Lakes", "code": "W114" }, { "name": "Fergus Falls", "code": "W115" }, { "name": "Glenwood", "code": "W116" }, { "name": "Karlstad", "code": "W117" }, { "name": "Park Rapids", "code": "W118" }, { "name": "Red Lake WMA", "code": "W119" }, { "name": "Roseau River WMA", "code": "W120" }, { "name": "Thief Lake WMA", "code": "W121" }, { "name": "Thief River Falls", "code": "W122" }, { "name": "Aitkin", "code": "W211" }, { "name": "Brainerd", "code": "S211" }, { "name": "Cloquet", "code": "W213" }, { "name": "Willow River", "code": "S213" }, { "name": "Tower", "code": "W215" }, { "name": "Grand Rapids", "code": "W218" }, { "name": "International Falls", "code": "W220" }, { "name": "Orr", "code": "S220" }, { "name": "Two Harbors", "code": "W222" }, { "name": "Grand Marais", "code": "S222" }, { "name": "Cambridge", "code": "W311" }, { "name": "Carlos Avery WMA", "code": "W312" }, { "name": "Little Falls", "code": "W313" }, { "name": "Mille Lacs WMA", "code": "W316" }, { "name": "Sauk Rapids", "code": "W317" }, { "name": "Vermillion River Complex", "code": "W318" }, { "name": "Rochester", "code": "W320" }, { "name": "Appleton", "code": "W411" }, { "name": "Marshall", "code": "W416" }, { "name": "Nicollet", "code": "W417" }, { "name": "Owatonna", "code": "W418" }, { "name": "Slayton-Talcot Lake", "code": "W422" }, { "name": "Talcot Lake WMA", "code": "W423" }, { "name": "New London", "code": "W425" }, { "name": "Redwood Falls", "code": "S425" }, { "name": "Windom", "code": "W426" }, { "name": "Forest Lake", "code": "W314" }, { "name": "Shakopee", "code": "W315" }, { "name": "Whitewater WMA", "code": "W324" }, { "name": "Lac qui Parle WMA", "code": "W413" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "wcil_id_historic", "type": "esriFieldTypeString", "alias": "wcil_id_historic", "length": 20, "domain": null }, { "name": "temp_source_row_id", "type": "esriFieldTypeInteger", "alias": "temp_source_row_id", "domain": null }, { "name": "created_by", "type": "esriFieldTypeString", "alias": "created_by", "length": 255, "domain": null }, { "name": "date_created", "type": "esriFieldTypeDate", "alias": "date_created", "length": 8, "domain": null }, { "name": "edited_by", "type": "esriFieldTypeString", "alias": "edited_by", "length": 255, "domain": null }, { "name": "date_last_edited", "type": "esriFieldTypeDate", "alias": "date_last_edited", "length": 8, "domain": null }, { "name": "temp_region", "type": "esriFieldTypeString", "alias": "temp_region", "length": 255, "domain": null }, { "name": "temp_annual_quarter", "type": "esriFieldTypeString", "alias": "temp_annual_quarter", "length": 255, "domain": null }, { "name": "temp_lossinfo", "type": "esriFieldTypeSmallInteger", "alias": "temp_lossinfo", "domain": null }, { "name": "temp_emergency", "type": "esriFieldTypeSmallInteger", "alias": "temp_emergency", "domain": null }, { "name": "temp_agreement", "type": "esriFieldTypeSmallInteger", "alias": "temp_agreement", "domain": null }, { "name": "temp_first_name", "type": "esriFieldTypeString", "alias": "temp_first_name", "length": 100, "domain": null }, { "name": "temp_last_name", "type": "esriFieldTypeString", "alias": "temp_last_name", "length": 100, "domain": null }, { "name": "work_area", "type": "esriFieldTypeString", "alias": "work_area", "length": 64, "domain": { "type": "codedValue", "name": "work_areas", "description": "Wildlife Work Areas (excluding satelite offices)", "codedValues": [ { "name": "Aitkin", "code": "Aitkin" }, { "name": "Appleton", "code": "Appleton" }, { "name": "Baudette", "code": "Baudette" }, { "name": "Bemidji", "code": "Bemidji" }, { "name": "Brainerd", "code": "Brainerd" }, { "name": "Cambridge", "code": "Cambridge" }, { "name": "Carlos Avery WMA", "code": "Carlos Avery WMA" }, { "name": "Cloquet", "code": "Cloquet" }, { "name": "Crookston", "code": "Crookston" }, { "name": "Detroit Lakes", "code": "Detroit Lakes" }, { "name": "Fergus Falls", "code": "Fergus Falls" }, { "name": "Glenwood", "code": "Glenwood" }, { "name": "Grand Rapids", "code": "Grand Rapids" }, { "name": "International Falls", "code": "International Falls" }, { "name": "Karlstad", "code": "Karlstad" }, { "name": "Little Falls", "code": "Little Falls" }, { "name": "Marshall", "code": "Marshall" }, { "name": "Mille Lacs WMA", "code": "Mille Lacs WMA" }, { "name": "New London", "code": "New London" }, { "name": "Nicollet", "code": "Nicollet" }, { "name": "Owatonna", "code": "Owatonna" }, { "name": "Park Rapids", "code": "Park Rapids" }, { "name": "Red Lake WMA", "code": "Red Lake WMA" }, { "name": "Rochester", "code": "Rochester" }, { "name": "Roseau River WMA", "code": "Roseau River WMA" }, { "name": "Sauk Rapids", "code": "Sauk Rapids" }, { "name": "Slayton-Talcot Lake", "code": "Slayton-Talcot Lake" }, { "name": "Talcot Lake WMA", "code": "Talcot Lake WMA" }, { "name": "Thief Lake WMA", "code": "Thief Lake WMA" }, { "name": "Thief River Falls", "code": "Thief River Falls" }, { "name": "Tower", "code": "Tower" }, { "name": "Two Harbors", "code": "Two Harbors" }, { "name": "Vermillion River Complex", "code": "Vermillion River Complex" }, { "name": "Windom", "code": "Windom" }, { "name": "Forest Lake", "code": "Forest Lake" }, { "name": "Shakopee", "code": "Shakopee" }, { "name": "Whitewater WMA", "code": "Whitewater WMA" }, { "name": "Lac qui Parle WMA", "code": "Lac qui Parle WMA" }, { "name": "Statewide", "code": "Statewide" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "county", "type": "esriFieldTypeInteger", "alias": "county", "domain": { "type": "codedValue", "name": "counties", "description": "County Integer", "codedValues": [ { "name": "Aitkin", "code": 1 }, { "name": "Anoka", "code": 2 }, { "name": "Becker", "code": 3 }, { "name": "Beltrami", "code": 4 }, { "name": "Benton", "code": 5 }, { "name": "Big Stone", "code": 6 }, { "name": "Blue Earth", "code": 7 }, { "name": "Brown", "code": 8 }, { "name": "Carlton", "code": 9 }, { "name": "Carver", "code": 10 }, { "name": "Cass", "code": 11 }, { "name": "Chippewa", "code": 12 }, { "name": "Chisago", "code": 13 }, { "name": "Clay", "code": 14 }, { "name": "Clearwater", "code": 15 }, { "name": "Cook", "code": 16 }, { "name": "Cottonwood", "code": 17 }, { "name": "Crow Wing", "code": 18 }, { "name": "Dakota", "code": 19 }, { "name": "Dodge", "code": 20 }, { "name": "Douglas", "code": 21 }, { "name": "Faribault", "code": 22 }, { "name": "Fillmore", "code": 23 }, { "name": "Freeborn", "code": 24 }, { "name": "Goodhue", "code": 25 }, { "name": "Grant", "code": 26 }, { "name": "Hennepin", "code": 27 }, { "name": "Houston", "code": 28 }, { "name": "Hubbard", "code": 29 }, { "name": "Isanti", "code": 30 }, { "name": "Itasca", "code": 31 }, { "name": "Jackson", "code": 32 }, { "name": "Kanabec", "code": 33 }, { "name": "Kandiyohi", "code": 34 }, { "name": "Kittson", "code": 35 }, { "name": "Koochiching", "code": 36 }, { "name": "Lac qui Parle", "code": 37 }, { "name": "Lake", "code": 38 }, { "name": "Lake of the Woods", "code": 39 }, { "name": "Le Sueur", "code": 40 }, { "name": "Lincoln", "code": 41 }, { "name": "Lyon", "code": 42 }, { "name": "McLeod", "code": 43 }, { "name": "Mahnomen", "code": 44 }, { "name": "Marshall", "code": 45 }, { "name": "Martin", "code": 46 }, { "name": "Meeker", "code": 47 }, { "name": "Mille Lacs", "code": 48 }, { "name": "Morrison", "code": 49 }, { "name": "Mower", "code": 50 }, { "name": "Murray", "code": 51 }, { "name": "Nicollet", "code": 52 }, { "name": "Nobles", "code": 53 }, { "name": "Norman", "code": 54 }, { "name": "Olmsted", "code": 55 }, { "name": "Otter Tail", "code": 56 }, { "name": "Pennington", "code": 57 }, { "name": "Pine", "code": 58 }, { "name": "Pipestone", "code": 59 }, { "name": "Polk", "code": 60 }, { "name": "Pope", "code": 61 }, { "name": "Ramsey", "code": 62 }, { "name": "Red Lake", "code": 63 }, { "name": "Redwood", "code": 64 }, { "name": "Renville", "code": 65 }, { "name": "Rice", "code": 66 }, { "name": "Rock", "code": 67 }, { "name": "Roseau", "code": 68 }, { "name": "St. Louis", "code": 69 }, { "name": "Scott", "code": 70 }, { "name": "Sherburne", "code": 71 }, { "name": "Sibley", "code": 72 }, { "name": "Stearns", "code": 73 }, { "name": "Steele", "code": 74 }, { "name": "Stevens", "code": 75 }, { "name": "Swift", "code": 76 }, { "name": "Todd", "code": 77 }, { "name": "Traverse", "code": 78 }, { "name": "Wabasha", "code": 79 }, { "name": "Wadena", "code": 80 }, { "name": "Waseca", "code": 81 }, { "name": "Washington", "code": 82 }, { "name": "Watonwan", "code": 83 }, { "name": "Wilkin", "code": 84 }, { "name": "Winona", "code": 85 }, { "name": "Wright", "code": 86 }, { "name": "Yellow Medicine", "code": 87 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "wildlife_species", "type": "esriFieldTypeString", "alias": "wildlife_species", "length": 64, "domain": null }, { "name": "wildlife_species_other", "type": "esriFieldTypeString", "alias": "wildlife_species_other", "length": 255, "domain": null }, { "name": "recording_area", "type": "esriFieldTypeString", "alias": "recording_area", "length": 64, "domain": { "type": "codedValue", "name": "work_areas", "description": "Wildlife Work Areas (excluding satelite offices)", "codedValues": [ { "name": "Aitkin", "code": "Aitkin" }, { "name": "Appleton", "code": "Appleton" }, { "name": "Baudette", "code": "Baudette" }, { "name": "Bemidji", "code": "Bemidji" }, { "name": "Brainerd", "code": "Brainerd" }, { "name": "Cambridge", "code": "Cambridge" }, { "name": "Carlos Avery WMA", "code": "Carlos Avery WMA" }, { "name": "Cloquet", "code": "Cloquet" }, { "name": "Crookston", "code": "Crookston" }, { "name": "Detroit Lakes", "code": "Detroit Lakes" }, { "name": "Fergus Falls", "code": "Fergus Falls" }, { "name": "Glenwood", "code": "Glenwood" }, { "name": "Grand Rapids", "code": "Grand Rapids" }, { "name": "International Falls", "code": "International Falls" }, { "name": "Karlstad", "code": "Karlstad" }, { "name": "Little Falls", "code": "Little Falls" }, { "name": "Marshall", "code": "Marshall" }, { "name": "Mille Lacs WMA", "code": "Mille Lacs WMA" }, { "name": "New London", "code": "New London" }, { "name": "Nicollet", "code": "Nicollet" }, { "name": "Owatonna", "code": "Owatonna" }, { "name": "Park Rapids", "code": "Park Rapids" }, { "name": "Red Lake WMA", "code": "Red Lake WMA" }, { "name": "Rochester", "code": "Rochester" }, { "name": "Roseau River WMA", "code": "Roseau River WMA" }, { "name": "Sauk Rapids", "code": "Sauk Rapids" }, { "name": "Slayton-Talcot Lake", "code": "Slayton-Talcot Lake" }, { "name": "Talcot Lake WMA", "code": "Talcot Lake WMA" }, { "name": "Thief Lake WMA", "code": "Thief Lake WMA" }, { "name": "Thief River Falls", "code": "Thief River Falls" }, { "name": "Tower", "code": "Tower" }, { "name": "Two Harbors", "code": "Two Harbors" }, { "name": "Vermillion River Complex", "code": "Vermillion River Complex" }, { "name": "Windom", "code": "Windom" }, { "name": "Forest Lake", "code": "Forest Lake" }, { "name": "Shakopee", "code": "Shakopee" }, { "name": "Whitewater WMA", "code": "Whitewater WMA" }, { "name": "Lac qui Parle WMA", "code": "Lac qui Parle WMA" }, { "name": "Statewide", "code": "Statewide" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "site_visit_date", "type": "esriFieldTypeDate", "alias": "site_visit_date", "length": 8, "domain": null }, { "name": "describe_problem", "type": "esriFieldTypeString", "alias": "describe_problem", "length": 10000, "domain": null }, { "name": "validated_flag", "type": "esriFieldTypeSmallInteger", "alias": "validated_flag", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "i82cdma_id", "fields": "cdma_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "i82complainant_p", "fields": "complainant_party_id", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r19_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "wcil_locations", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{1DB76F64-7473-4BEC-B22D-C9BDC6729CFD}" }, { "id": 41, "name": "wcil_species", "relatedTableId": 32, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9377E8CE-EBF4-4BE2-B68A-6807F736190B}" }, { "id": 39, "name": "wcil_damage", "relatedTableId": 31, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{CD067D09-8F3D-4B3E-B6E1-9EFED8510366}" }, { "id": 38, "name": "site_visits", "relatedTableId": 30, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{EBAA99B7-20C8-46D5-BF15-1E8698AE4D64}" }, { "id": 34, "name": "parties", "relatedTableId": 25, "role": "esriRelRoleDestination", "keyField": "complainant_party_id", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{60D2E569-A1FF-4339-8458-DF158E58F416}" }, { "id": 18, "name": "coop_damage_mgmt_agreement", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "cdma_id", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9FD86F29-7C77-45F2-8165-6BF47BCDACFD}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 50000, "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": false }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }