{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 2, "name": "ConflictResponse", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "KP_permitteeName", "typeIdField": "ResponseType", "subtypeFieldName": "ResponseType", "subtypeField": "ResponseType", "defaultSubtypeCode": 0, "fields": [ { "name": "conflictReportID", "type": "esriFieldTypeGUID", "alias": "conflictReportID", "length": 38, "domain": null }, { "name": "responseStartDate", "type": "esriFieldTypeDate", "alias": "startDate", "length": 8, "domain": null }, { "name": "response_notes", "type": "esriFieldTypeString", "alias": "notes", "length": 3000, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "ResponseType", "type": "esriFieldTypeSmallInteger", "alias": "responseType", "domain": { "type": "codedValue", "name": "ResponseType_3", "description": "General response types", "codedValues": [ { "name": "Fencing", "code": 0 }, { "name": "Depredation hunt", "code": 1 }, { "name": "Kill Permit", "code": 2 }, { "name": "Directed Hunters", "code": 3 }, { "name": "Hazing", "code": 4 }, { "name": "Technical Assistance", "code": 5 }, { "name": "Trapping relocate", "code": 6 }, { "name": "Agency removal", "code": 7 }, { "name": "Pending", "code": 8 }, { "name": "New Claim/Agreement", "code": 9 }, { "name": "LPH Tag", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "result", "type": "esriFieldTypeSmallInteger", "alias": "result", "domain": { "type": "codedValue", "name": "responseResul", "description": "", "codedValues": [ { "name": "Pending", "code": 0 }, { "name": "undetermined", "code": 1 }, { "name": "unsuccessful", "code": 2 }, { "name": "successful", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ResponseTypeMethod", "type": "esriFieldTypeSmallInteger", "alias": "ResponseTypeMethod", "domain": null }, { "name": "responseEndDate", "type": "esriFieldTypeDate", "alias": "endDate", "length": 8, "domain": null }, { "name": "otherTypeMethod_desc", "type": "esriFieldTypeString", "alias": "otherTypeMethod_desc", "length": 255, "domain": null }, { "name": "HZ_hasPyroReleaseAgreement", "type": "esriFieldTypeSmallInteger", "alias": "HZ_hasPyroReleaseAgreement", "domain": { "type": "codedValue", "name": "yes_no", "description": "coded value for boolean yes no", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KP_isExtendedShootingHours", "type": "esriFieldTypeSmallInteger", "alias": "KP_isExtendedShootingHours", "domain": { "type": "codedValue", "name": "yes_no", "description": "coded value for boolean yes no", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KP_DP_LPH_numTagsAllocated", "type": "esriFieldTypeSmallInteger", "alias": "KP_DP_LPH_numTagsAllocated", "domain": { "type": "range", "name": "minMaxTags", "description": "min max tags awarded on a kill permit", "range": [ 1, 99 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "KP_permitteeName", "type": "esriFieldTypeString", "alias": "KP_permitteeName", "length": 255, "domain": null }, { "name": "KP_permitteeHuntingLicenseNum", "type": "esriFieldTypeInteger", "alias": "KP_permitteeHuntingLicenseNum", "domain": null }, { "name": "FN_length_ft", "type": "esriFieldTypeDouble", "alias": "FN_length_ft", "domain": null }, { "name": "FN_materialCost", "type": "esriFieldTypeDouble", "alias": "FN_materialCost", "domain": null }, { "name": "TR_earTagNum", "type": "esriFieldTypeInteger", "alias": "TR_earTagNum", "domain": null }, { "name": "TR_collarSerialNum", "type": "esriFieldTypeDouble", "alias": "TR_collarSerialNum", "domain": null }, { "name": "TR_collarFrequency", "type": "esriFieldTypeDouble", "alias": "TR_collarFrequency", "domain": null }, { "name": "AR_authorizationBy", "type": "esriFieldTypeString", "alias": "AR_authorizationBy", "length": 255, "domain": null }, { "name": "DP_huntNumber", "type": "esriFieldTypeString", "alias": "DP_huntNumber", "length": 255, "domain": null }, { "name": "responsePersonnel", "type": "esriFieldTypeString", "alias": "responsePersonnel", "length": 500, "domain": null }, { "name": "FN_isPermanentFencing", "type": "esriFieldTypeSmallInteger", "alias": "FN_isPermanentFencing", "domain": { "type": "codedValue", "name": "yes_no", "description": "coded value for boolean yes no", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "KP_HarvestAmount", "type": "esriFieldTypeSmallInteger", "alias": "KP_HarvestAmount", "domain": null }, { "name": "KP_LPH_DH_Species", "type": "esriFieldTypeInteger", "alias": "KP_LPH_DH_Species", "domain": { "type": "codedValue", "name": "DepredationSpeciesTaxonID", "description": "Common_Name", "codedValues": [ { "name": "Black Bear", "code": 15779 }, { "name": "Bobcat", "code": 20035 }, { "name": "Coyote", "code": 17263 }, { "name": "Deer", "code": 7918 }, { "name": "Elk", "code": 74374 }, { "name": "Grizzly Bear", "code": 16900 }, { "name": "Moose", "code": 77108 }, { "name": "Mountain Goat", "code": 18271 }, { "name": "Pronghorn", "code": 15532 }, { "name": "Fox", "code": 19641 }, { "name": "White-tailed Deer", "code": 18807 }, { "name": "Turkey", "code": 18410 }, { "name": "Beaver", "code": 15973 }, { "name": "Mule Deer", "code": 16300 }, { "name": "Wolf", "code": 80010 }, { "name": "Mountain Lion", "code": 16498 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "UUID_100", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G176conflictRepo", "fields": "conflictReportID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_100", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "id": 0, "name": "Fencing" }, { "domains": {}, "id": 1, "name": "Depredation Hunt" }, { "domains": {}, "id": 2, "name": "Kill Permit" }, { "domains": {}, "id": 3, "name": "Directed Hunters" }, { "domains": {}, "id": 4, "name": "Hazing" }, { "domains": {}, "id": 5, "name": "Technical Assistance" }, { "domains": {}, "id": 6, "name": "Trapping relocate" }, { "domains": { "ResponseTypeMethod": { "type": "codedValue", "name": "Euthanization Methods", "description": "euthanization values", "codedValues": [ { "name": "Injection", "code": 0 }, { "name": "Carbon Dioxide Exposure", "code": 1 }, { "name": "Cervical dislocation", "code": 2 }, { "name": "Decapitation", "code": 3 }, { "name": "Shot", "code": 4 }, { "name": "Trapping", "code": 5 }, { "name": "Other", "code": 6 }, { "name": "Not Applicable", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "id": 7, "name": "Agency Removal" }, { "domains": { "result": {"type": "inherited"}, "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "id": 8, "name": "Pending" }, { "domains": { "result": {"type": "inherited"}, "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "id": 9, "name": "New Claim/Agreement" } ], "subtypes": [ { "domains": { "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 0, "name": "Fencing" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 1, "name": "Depredation Hunt" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 2, "name": "Kill Permit" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 3, "name": "Directed Hunters" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 4, "name": "Hazing" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 5, "name": "Technical Assistance" }, { "domains": {}, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 6, "name": "Trapping relocate" }, { "domains": { "ResponseTypeMethod": { "type": "codedValue", "name": "Euthanization Methods", "description": "euthanization values", "codedValues": [ { "name": "Injection", "code": 0 }, { "name": "Carbon Dioxide Exposure", "code": 1 }, { "name": "Cervical dislocation", "code": 2 }, { "name": "Decapitation", "code": 3 }, { "name": "Shot", "code": 4 }, { "name": "Trapping", "code": 5 }, { "name": "Other", "code": 6 }, { "name": "Not Applicable", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 7, "name": "Agency Removal" }, { "domains": { "result": {"type": "inherited"}, "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 8, "name": "Pending" }, { "domains": { "result": {"type": "inherited"}, "HZ_hasPyroReleaseAgreement": {"type": "inherited"}, "KP_isExtendedShootingHours": {"type": "inherited"}, "KP_DP_LPH_numTagsAllocated": {"type": "inherited"} }, "defaultValues": { "conflictReportID": null, "responseStartDate": null, "response_notes": null, "GlobalID": null, "created_user": null, "created_date": null, "last_edited_user": null, "last_edited_date": null, "ResponseType": null, "result": null, "ResponseTypeMethod": null, "responseEndDate": null, "otherTypeMethod_desc": null, "HZ_hasPyroReleaseAgreement": null, "KP_isExtendedShootingHours": null, "KP_DP_LPH_numTagsAllocated": null, "KP_permitteeName": null, "KP_permitteeHuntingLicenseNum": null, "FN_length_ft": null, "FN_materialCost": null, "TR_earTagNum": null, "TR_collarSerialNum": null, "TR_collarFrequency": null, "AR_authorizationBy": null, "DP_huntNumber": null, "responsePersonnel": null, "FN_isPermanentFencing": null, "KP_HarvestAmount": null, "KP_LPH_DH_Species": null }, "code": 9, "name": "New Claim/Agreement" } ], "relationships": [ { "id": 4, "name": "Response Location (line)", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{B6F94991-90B0-4511-B7CA-9D52A8867DC5}" }, { "id": 5, "name": "Response Location (poly)", "relatedTableId": 6, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{6A741ACC-17B9-4CED-A002-A220FC198793}" }, { "id": 6, "name": "DBO.DesignatedShooters_killPermitResponse", "relatedTableId": 14, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{8B44B0A1-5B71-4799-AC1B-A51D45E199F6}" }, { "id": 3, "name": "Response Location (point)", "relatedTableId": 12, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{44BCB186-0B6E-492B-BD3F-EDB63C07A9B0}" }, { "id": 1, "name": "Conflict Report", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "conflictReportID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{4703984E-C249-46BA-8AAD-FCE7FC5DC4B2}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 0, "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, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Mountain Standard Time", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1695394004000 }, "serviceItemId": "e8a4963a96494600a142867eb4acca1b" }