{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 16, "name": "ddap_permits", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "date_created", "creatorField": "created_by", "editDateField": "date_last_edited", "editorField": "edited_by", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 24, "name": "eligible_hunters", "relatedTableId": 21, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "objectid", "composite": true, "catalogID": "{AE7DF485-3F65-4FDB-9BDC-4D74699C3237}" }, { "id": 21, "name": "ddap_conditions", "relatedTableId": 14, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "objectid", "composite": true, "catalogID": "{64F0F3A5-9309-46CB-B374-717AE25ADB3B}" }, { "id": 23, "name": "ddap_harvests", "relatedTableId": 15, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "objectid", "composite": true, "catalogID": "{35B82810-BC94-4101-8DDA-D4F79A9139C6}" }, { "id": 0, "name": "ddap_point_locations", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "objectid", "composite": true, "catalogID": "{0C913BF7-42DA-48DA-ABA7-2820EEC625D5}" }, { "id": 25, "name": "parties", "relatedTableId": 25, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "applicant_party_id", "composite": false, "catalogID": "{FF689A40-6F68-4CD1-BE59-DA6F071A50D2}" }, { "id": 17, "name": "coop_damage_mgmt_agreement", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "cdma_id", "composite": true, "catalogID": "{7ED2C324-9535-4805-B28F-71FB16269550}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "expiration_date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "expiration_date", "type": "esriFieldTypeDate", "alias": "expiration_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "expiration_date" }, { "name": "special_permit_number", "type": "esriFieldTypeString", "alias": "special_permit_number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "special_permit_number" }, { "name": "applicant_party_id", "type": "esriFieldTypeInteger", "alias": "applicant_party_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "applicant_party_id" }, { "name": "local_conservation_officer_user", "type": "esriFieldTypeString", "alias": "local_conservation_officer_user", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "local_conservation_officer_user" }, { "name": "dnr_area_wildlife_mgr_user", "type": "esriFieldTypeString", "alias": "dnr_area_wildlife_mgr_user", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "dnr_area_wildlife_mgr_user" }, { "name": "dnr_region_wildlife_mgr_user", "type": "esriFieldTypeString", "alias": "dnr_region_wildlife_mgr_user", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "dnr_region_wildlife_mgr_user" }, { "name": "dnr_section_wildlife_mgr_user", "type": "esriFieldTypeString", "alias": "dnr_section_wildlife_mgr_user", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "dnr_section_wildlife_mgr_user" }, { "name": "authoritative_signer_level", "type": "esriFieldTypeString", "alias": "authoritative_signer_level", "domain": { "type": "codedValue", "name": "manager_levels", "description": "Description", "codedValues": [ { "name": "Area Wildlife Manager", "code": "Area" }, { "name": "Region Wildlife Manager", "code": "Region" }, { "name": "Section Wildlife Manager", "code": "Section" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "authoritative_signer_level" }, { "name": "area_wildlife_mgr_sign_date", "type": "esriFieldTypeDate", "alias": "area_wildlife_mgr_sign_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "area_wildlife_mgr_sign_date" }, { "name": "region_wildlife_mgr_sign_date", "type": "esriFieldTypeDate", "alias": "region_wildlife_mgr_sign_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "region_wildlife_mgr_sign_date" }, { "name": "section_wildlife_mgr_sign_date", "type": "esriFieldTypeDate", "alias": "section_wildlife_mgr_sign_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "section_wildlife_mgr_sign_date" }, { "name": "permittee_sign_date", "type": "esriFieldTypeDate", "alias": "permittee_sign_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "permittee_sign_date" }, { "name": "revoker_user", "type": "esriFieldTypeString", "alias": "revoker_user", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "revoker_user" }, { "name": "revoke_date", "type": "esriFieldTypeDate", "alias": "revoke_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "revoke_date" }, { "name": "harvest_allowed", "type": "esriFieldTypeInteger", "alias": "harvest_allowed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "harvest_allowed" }, { "name": "cdma_id", "type": "esriFieldTypeInteger", "alias": "cdma_id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "cdma_id" }, { "name": "effective_date", "type": "esriFieldTypeDate", "alias": "effective_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "effective_date" }, { "name": "recommendation_flag", "type": "esriFieldTypeString", "alias": "recommendation_flag", "domain": { "type": "codedValue", "name": "recommendation_status", "description": "Description", "codedValues": [ { "name": "Deny", "code": "Deny" }, { "name": "Approve", "code": "Approve" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "recommendation_flag" }, { "name": "recommendation_text", "type": "esriFieldTypeString", "alias": "recommendation_text", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "recommendation_text" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "comments" }, { "name": "created_by", "type": "esriFieldTypeString", "alias": "created_by", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_by" }, { "name": "date_created", "type": "esriFieldTypeDate", "alias": "date_created", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_created" }, { "name": "edited_by", "type": "esriFieldTypeString", "alias": "edited_by", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "edited_by" }, { "name": "date_last_edited", "type": "esriFieldTypeDate", "alias": "date_last_edited", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_last_edited" }, { "name": "work_area", "type": "esriFieldTypeString", "alias": "work_area", "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" }, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "work_area" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "county" }, { "name": "temp_twp", "type": "esriFieldTypeSmallInteger", "alias": "temp_twp", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "temp_twp" }, { "name": "temp_rg", "type": "esriFieldTypeSmallInteger", "alias": "temp_rg", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "temp_rg" }, { "name": "temp_sec", "type": "esriFieldTypeSmallInteger", "alias": "temp_sec", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "temp_sec" }, { "name": "temp_qsec", "type": "esriFieldTypeSmallInteger", "alias": "temp_qsec", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "temp_qsec" }, { "name": "allowable_age", "type": "esriFieldTypeString", "alias": "allowable_age", "domain": { "type": "codedValue", "name": "allowable_age_types", "description": "", "codedValues": [ { "name": "Young", "code": "Young" }, { "name": "Adult", "code": "Adult" }, { "name": "Any age", "code": "Any age" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "allowable_age" }, { "name": "allowable_sex", "type": "esriFieldTypeString", "alias": "allowable_sex", "domain": { "type": "codedValue", "name": "allowable_sex_types", "description": "", "codedValues": [ { "name": "Male", "code": "M" }, { "name": "Female", "code": "F" }, { "name": "Either sex", "code": "Either sex" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "allowable_sex" }, { "name": "ddap_num", "type": "esriFieldTypeInteger", "alias": "ddap_num", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ddap_num" }, { "name": "local_conserv_officer_sign_date", "type": "esriFieldTypeDate", "alias": "local_conserv_officer_sign_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "local_conserv_officer_sign_date" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "internal_use_only" }, { "name": "sent_for_review_date", "type": "esriFieldTypeDate", "alias": "sent_for_review_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "sent_for_review_date" } ], "indexes": [ { "name": "i85applicant_par", "isAscending": true, "isUnique": false, "description": "", "fields": "applicant_party_id" }, { "name": "i85cdma_id", "isAscending": true, "isUnique": false, "description": "", "fields": "cdma_id" }, { "name": "r22_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "ddap_permits", "description": "", "prototype": { "attributes": { "internal_use_only": null, "sent_for_review_date": null, "expiration_date": null, "special_permit_number": null, "applicant_party_id": null, "local_conservation_officer_user": null, "dnr_area_wildlife_mgr_user": null, "dnr_region_wildlife_mgr_user": null, "dnr_section_wildlife_mgr_user": null, "authoritative_signer_level": null, "area_wildlife_mgr_sign_date": null, "region_wildlife_mgr_sign_date": null, "section_wildlife_mgr_sign_date": null, "permittee_sign_date": null, "revoker_user": null, "revoke_date": null, "harvest_allowed": null, "cdma_id": null, "effective_date": null, "recommendation_flag": null, "recommendation_text": null, "comments": null, "local_conserv_officer_sign_date": null, "ddap_num": null, "allowable_sex": null, "allowable_age": null, "work_area": null, "county": null, "temp_twp": null, "temp_rg": null, "temp_sec": null, "temp_qsec": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 50000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 50000, "maxRecordCountFactor": 1 }