{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 12, "name": "coop_damage_mgmt_agreement", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "temp_last_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null }, { "name": "lt_mgmt_detail_text", "type": "esriFieldTypeString", "alias": "lt_mgmt_detail_text", "length": 10000, "domain": null }, { "name": "emergency_plan_detail_text", "type": "esriFieldTypeString", "alias": "emergency_plan_detail_text", "length": 10000, "domain": null }, { "name": "emergency_mgmt_start_date", "type": "esriFieldTypeDate", "alias": "emergency_mgmt_start_date", "length": 8, "domain": null }, { "name": "emergency_mgmt_end_date", "type": "esriFieldTypeDate", "alias": "emergency_mgmt_end_date", "length": 8, "domain": null }, { "name": "agreement_sign_date_producer", "type": "esriFieldTypeDate", "alias": "agreement_sign_date_grower", "length": 8, "domain": null }, { "name": "agr_sign_dnr_area_mgr_user", "type": "esriFieldTypeString", "alias": "agr_sign_dnr_area_mgr_user", "length": 64, "domain": null }, { "name": "agr_sign_date_dnr_area_mgr", "type": "esriFieldTypeDate", "alias": "agr_sign_date_dnr_area_mgr", "length": 8, "domain": null }, { "name": "depredation_specialist_user", "type": "esriFieldTypeString", "alias": "depredation_specialist_user", "length": 64, "domain": null }, { "name": "total_abatement_value", "type": "esriFieldTypeDouble", "alias": "total_abatement_value", "domain": null }, { "name": "cdma_active_status", "type": "esriFieldTypeSmallInteger", "alias": "cdma_active_status", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "cdma_5_yr_status", "type": "esriFieldTypeString", "alias": "cdma_5_yr_status", "length": 2000, "domain": null }, { "name": "cdma_10_yr_status", "type": "esriFieldTypeString", "alias": "cdma_10_yr_status", "length": 2000, "domain": null }, { "name": "cdma_15_yr_status", "type": "esriFieldTypeString", "alias": "cdma_15_yr_status", "length": 2000, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 2000, "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_year", "type": "esriFieldTypeString", "alias": "temp_year", "length": 255, "domain": null }, { "name": "temp_last_name", "type": "esriFieldTypeString", "alias": "temp_last_name", "length": 255, "domain": null }, { "name": "temp_first_name", "type": "esriFieldTypeString", "alias": "temp_first_name", "length": 255, "domain": null }, { "name": "temp_business", "type": "esriFieldTypeString", "alias": "temp_business", "length": 255, "domain": null }, { "name": "temp_address", "type": "esriFieldTypeString", "alias": "temp_address", "length": 255, "domain": null }, { "name": "temp_city", "type": "esriFieldTypeString", "alias": "temp_city", "length": 255, "domain": null }, { "name": "temp_state", "type": "esriFieldTypeString", "alias": "temp_state", "length": 255, "domain": null }, { "name": "temp_zip", "type": "esriFieldTypeString", "alias": "temp_zip", "length": 255, "domain": null }, { "name": "temp_phone", "type": "esriFieldTypeString", "alias": "temp_phone", "length": 255, "domain": null }, { "name": "temp_county", "type": "esriFieldTypeString", "alias": "temp_county", "length": 255, "domain": null }, { "name": "temp_type", "type": "esriFieldTypeString", "alias": "temp_type", "length": 255, "domain": null }, { "name": "temp_crop", "type": "esriFieldTypeString", "alias": "temp_crop", "length": 255, "domain": null }, { "name": "temp_damage", "type": "esriFieldTypeString", "alias": "temp_damage", "length": 255, "domain": null }, { "name": "temp_loss", "type": "esriFieldTypeDouble", "alias": "temp_loss", "domain": null }, { "name": "temp_emergency", "type": "esriFieldTypeSmallInteger", "alias": "temp_emergency", "domain": null }, { "name": "temp_shoot_prmt", "type": "esriFieldTypeSmallInteger", "alias": "temp_shoot_prmt", "domain": null }, { "name": "temp_shooting_permit_date", "type": "esriFieldTypeString", "alias": "temp_shooting_permit_date", "length": 255, "domain": null }, { "name": "temp_agreement", "type": "esriFieldTypeSmallInteger", "alias": "temp_agreement", "domain": null }, { "name": "temp_area_office", "type": "esriFieldTypeString", "alias": "temp_area_office", "length": 255, "domain": null }, { "name": "temp_region", "type": "esriFieldTypeString", "alias": "temp_region", "length": 255, "domain": null }, { "name": "temp_repellent_program", "type": "esriFieldTypeSmallInteger", "alias": "temp_repellent_program", "domain": null }, { "name": "temp_permanent_fence", "type": "esriFieldTypeSmallInteger", "alias": "temp_permanent_fence", "domain": null }, { "name": "temp_total_project_cost", "type": "esriFieldTypeDouble", "alias": "temp_total_project_cost", "domain": null }, { "name": "temp_fiscal_year", "type": "esriFieldTypeString", "alias": "temp_fiscal_year", "length": 255, "domain": null }, { "name": "temp_mgr_first_name", "type": "esriFieldTypeString", "alias": "temp_mgr_first_name", "length": 200, "domain": null }, { "name": "temp_mgr_last_name", "type": "esriFieldTypeString", "alias": "temp_mgr_last_name", "length": 200, "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": "temp_special_permit", "type": "esriFieldTypeString", "alias": "temp_special_permit", "length": 50, "domain": null }, { "name": "short_stop_funding_source", "type": "esriFieldTypeString", "alias": "short_stop_funding_source", "length": 255, "domain": null }, { "name": "cdma_id_historic", "type": "esriFieldTypeSmallInteger", "alias": "cdma_id_historic", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "agreement_boilerplate_text_id", "type": "esriFieldTypeInteger", "alias": "agreement_boilerplate_text_id", "domain": null }, { "name": "cdma_num", "type": "esriFieldTypeInteger", "alias": "cdma_num", "domain": null }, { "name": "internal_use_only", "type": "esriFieldTypeSmallInteger", "alias": "internal_use_only", "domain": { "type": "codedValue", "name": "boolean", "description": "boolean 0/1", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "shipped_to_id", "type": "esriFieldTypeInteger", "alias": "shipped_to_id", "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" } }, { "name": "agr_sign_dnr_section_chief_user", "type": "esriFieldTypeString", "alias": "agr_sign_dnr_section_chief_user", "length": 64, "domain": null }, { "name": "agr_sign_date_dnr_section_chief", "type": "esriFieldTypeDate", "alias": "agr_sign_date_dnr_section_chief", "length": 8, "domain": null } ], "indexes": [ { "name": "r16_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 14, "name": "cdma_species", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{CB1C8096-8978-4668-9D4F-D94AA662E71F}" }, { "id": 9, "name": "cdma_contractors", "relatedTableId": 7, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{CE237A3A-2EBB-4F8C-B96F-2E0C80B90357}" }, { "id": 3, "name": "fence_locations", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F687FA16-B064-4D37-82D3-A51ECC66F5B6}" }, { "id": 11, "name": "cdma_emergency_mgmt_plan", "relatedTableId": 8, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{72443F98-28C4-47BE-A43D-2373DCF02A5B}" }, { "id": 19, "name": "documents", "relatedTableId": 20, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{72A56C9A-E297-4423-BEDE-9C672DBC743B}" }, { "id": 17, "name": "ddap_permits", "relatedTableId": 16, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7ED2C324-9535-4805-B28F-71FB16269550}" }, { "id": 18, "name": "wildlife_complaint_inquiry_logs", "relatedTableId": 33, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{9FD86F29-7C77-45F2-8165-6BF47BCDACFD}" }, { "id": 16, "name": "removal_permits", "relatedTableId": 29, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{A1110203-E32A-428A-93B1-A359A2F2EB77}" }, { "id": 12, "name": "cdma_long_term_mgmt_plan", "relatedTableId": 9, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{DACB27AF-0C87-40D2-B078-248CA442979B}" }, { "id": 1, "name": "cdma_point_locations", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{5E94CDAE-3D39-4E01-8CA0-87C862EF6958}" }, { "id": 13, "name": "cdma_materials", "relatedTableId": 10, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{F39F9917-4F3A-4C6D-8E4C-3C6A916167DB}" }, { "id": 5, "name": "enclosed_areas", "relatedTableId": 5, "role": "esriRelRoleOrigin", "keyField": "objectid", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6F2499BE-8BBA-46B5-87FF-3B368E68E659}" } ], "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 } }