{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 15,
 "name": "ddap_harvests",
 "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": 23,
   "name": "ddap_permits",
   "relatedTableId": 16,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "ddap_permit_id",
   "composite": true,
   "catalogID": "{35B82810-BC94-4101-8DDA-D4F79A9139C6}"
  },
  {
   "id": 22,
   "name": "eligible_hunters",
   "relatedTableId": 21,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "eligible_hunter_id",
   "composite": false,
   "catalogID": "{FC95EE0A-5F3C-417E-823D-E281CBB8F579}"
  }
 ],
 "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,
  "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": "age_flag",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "objectid",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "objectid"
  },
  {
   "name": "ddap_permit_id",
   "type": "esriFieldTypeInteger",
   "alias": "ddap_permit_id",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "ddap_permit_id"
  },
  {
   "name": "eligible_hunter_id",
   "type": "esriFieldTypeInteger",
   "alias": "eligible_hunter_id",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "eligible_hunter_id"
  },
  {
   "name": "harvest_date",
   "type": "esriFieldTypeDate",
   "alias": "harvest_date",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "harvest_date"
  },
  {
   "name": "age_flag",
   "type": "esriFieldTypeString",
   "alias": "age_flag",
   "domain": {
    "type": "codedValue",
    "name": "age_types",
    "description": "Description",
    "codedValues": [
     {
      "name": "Adult",
      "code": "Adult"
     },
     {
      "name": "Young",
      "code": "Young"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 16,
   "defaultValue": null,
   "modelName": "age_flag"
  },
  {
   "name": "sex_flag",
   "type": "esriFieldTypeString",
   "alias": "sex_flag",
   "domain": {
    "type": "codedValue",
    "name": "sex_types",
    "description": "Description",
    "codedValues": [
     {
      "name": "Male",
      "code": "M"
     },
     {
      "name": "Female",
      "code": "F"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 1,
   "defaultValue": null,
   "modelName": "sex_flag"
  },
  {
   "name": "harvest_location",
   "type": "esriFieldTypeString",
   "alias": "harvest_location",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 2000,
   "defaultValue": null,
   "modelName": "harvest_location"
  },
  {
   "name": "disposition_notes",
   "type": "esriFieldTypeString",
   "alias": "disposition_notes",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 2000,
   "defaultValue": null,
   "modelName": "disposition_notes"
  },
  {
   "name": "season",
   "type": "esriFieldTypeString",
   "alias": "season",
   "domain": {
    "type": "codedValue",
    "name": "seasons",
    "description": "Description",
    "codedValues": [
     {
      "name": "Bow",
      "code": "Bow"
     },
     {
      "name": "Gun-Season A",
      "code": "Gun-Season A"
     },
     {
      "name": "Gun-Season B",
      "code": "Gun-Season B"
     },
     {
      "name": "Muzzleloader",
      "code": "Muzzleloader"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 64,
   "defaultValue": null,
   "modelName": "season"
  },
  {
   "name": "permit_area",
   "type": "esriFieldTypeString",
   "alias": "permit_area",
   "domain": {
    "type": "codedValue",
    "name": "permit_areas",
    "description": "Description",
    "codedValues": [
     {
      "name": "101",
      "code": "101"
     },
     {
      "name": "103",
      "code": "103"
     },
     {
      "name": "105",
      "code": "105"
     },
     {
      "name": "108",
      "code": "108"
     },
     {
      "name": "110",
      "code": "110"
     },
     {
      "name": "111",
      "code": "111"
     },
     {
      "name": "113",
      "code": "113"
     },
     {
      "name": "114",
      "code": "114"
     },
     {
      "name": "117",
      "code": "117"
     },
     {
      "name": "118",
      "code": "118"
     },
     {
      "name": "119",
      "code": "119"
     },
     {
      "name": "122",
      "code": "122"
     },
     {
      "name": "126",
      "code": "126"
     },
     {
      "name": "127",
      "code": "127"
     },
     {
      "name": "152",
      "code": "152"
     },
     {
      "name": "155",
      "code": "155"
     },
     {
      "name": "156",
      "code": "156"
     },
     {
      "name": "157",
      "code": "157"
     },
     {
      "name": "159",
      "code": "159"
     },
     {
      "name": "169",
      "code": "169"
     },
     {
      "name": "171",
      "code": "171"
     },
     {
      "name": "172",
      "code": "172"
     },
     {
      "name": "173",
      "code": "173"
     },
     {
      "name": "176",
      "code": "176"
     },
     {
      "name": "177",
      "code": "177"
     },
     {
      "name": "178",
      "code": "178"
     },
     {
      "name": "179",
      "code": "179"
     },
     {
      "name": "180",
      "code": "180"
     },
     {
      "name": "181",
      "code": "181"
     },
     {
      "name": "182",
      "code": "182"
     },
     {
      "name": "183",
      "code": "183"
     },
     {
      "name": "184",
      "code": "184"
     },
     {
      "name": "197",
      "code": "197"
     },
     {
      "name": "199",
      "code": "199"
     },
     {
      "name": "201",
      "code": "201"
     },
     {
      "name": "203",
      "code": "203"
     },
     {
      "name": "208",
      "code": "208"
     },
     {
      "name": "209",
      "code": "209"
     },
     {
      "name": "210",
      "code": "210"
     },
     {
      "name": "213",
      "code": "213"
     },
     {
      "name": "214",
      "code": "214"
     },
     {
      "name": "215",
      "code": "215"
     },
     {
      "name": "218",
      "code": "218"
     },
     {
      "name": "219",
      "code": "219"
     },
     {
      "name": "221",
      "code": "221"
     },
     {
      "name": "222",
      "code": "222"
     },
     {
      "name": "223",
      "code": "223"
     },
     {
      "name": "224",
      "code": "224"
     },
     {
      "name": "225",
      "code": "225"
     },
     {
      "name": "227",
      "code": "227"
     },
     {
      "name": "229",
      "code": "229"
     },
     {
      "name": "230",
      "code": "230"
     },
     {
      "name": "232",
      "code": "232"
     },
     {
      "name": "233",
      "code": "233"
     },
     {
      "name": "234",
      "code": "234"
     },
     {
      "name": "235",
      "code": "235"
     },
     {
      "name": "236",
      "code": "236"
     },
     {
      "name": "237",
      "code": "237"
     },
     {
      "name": "238",
      "code": "238"
     },
     {
      "name": "239",
      "code": "239"
     },
     {
      "name": "240",
      "code": "240"
     },
     {
      "name": "241",
      "code": "241"
     },
     {
      "name": "242",
      "code": "242"
     },
     {
      "name": "246",
      "code": "246"
     },
     {
      "name": "247",
      "code": "247"
     },
     {
      "name": "248",
      "code": "248"
     },
     {
      "name": "249",
      "code": "249"
     },
     {
      "name": "250",
      "code": "250"
     },
     {
      "name": "251",
      "code": "251"
     },
     {
      "name": "252",
      "code": "252"
     },
     {
      "name": "253",
      "code": "253"
     },
     {
      "name": "254",
      "code": "254"
     },
     {
      "name": "255",
      "code": "255"
     },
     {
      "name": "256",
      "code": "256"
     },
     {
      "name": "257",
      "code": "257"
     },
     {
      "name": "258",
      "code": "258"
     },
     {
      "name": "259",
      "code": "259"
     },
     {
      "name": "260",
      "code": "260"
     },
     {
      "name": "261",
      "code": "261"
     },
     {
      "name": "262",
      "code": "262"
     },
     {
      "name": "263",
      "code": "263"
     },
     {
      "name": "264",
      "code": "264"
     },
     {
      "name": "265",
      "code": "265"
     },
     {
      "name": "266",
      "code": "266"
     },
     {
      "name": "267",
      "code": "267"
     },
     {
      "name": "268",
      "code": "268"
     },
     {
      "name": "269",
      "code": "269"
     },
     {
      "name": "270",
      "code": "270"
     },
     {
      "name": "271",
      "code": "271"
     },
     {
      "name": "272",
      "code": "272"
     },
     {
      "name": "273",
      "code": "273"
     },
     {
      "name": "274",
      "code": "274"
     },
     {
      "name": "275",
      "code": "275"
     },
     {
      "name": "276",
      "code": "276"
     },
     {
      "name": "277",
      "code": "277"
     },
     {
      "name": "278",
      "code": "278"
     },
     {
      "name": "279",
      "code": "279"
     },
     {
      "name": "280",
      "code": "280"
     },
     {
      "name": "281",
      "code": "281"
     },
     {
      "name": "282",
      "code": "282"
     },
     {
      "name": "283",
      "code": "283"
     },
     {
      "name": "284",
      "code": "284"
     },
     {
      "name": "285",
      "code": "285"
     },
     {
      "name": "286",
      "code": "286"
     },
     {
      "name": "287",
      "code": "287"
     },
     {
      "name": "288",
      "code": "288"
     },
     {
      "name": "289",
      "code": "289"
     },
     {
      "name": "290",
      "code": "290"
     },
     {
      "name": "291",
      "code": "291"
     },
     {
      "name": "292",
      "code": "292"
     },
     {
      "name": "293",
      "code": "293"
     },
     {
      "name": "294",
      "code": "294"
     },
     {
      "name": "295",
      "code": "295"
     },
     {
      "name": "296",
      "code": "296"
     },
     {
      "name": "297",
      "code": "297"
     },
     {
      "name": "298",
      "code": "298"
     },
     {
      "name": "299",
      "code": "299"
     },
     {
      "name": "338",
      "code": "338"
     },
     {
      "name": "339",
      "code": "339"
     },
     {
      "name": "341",
      "code": "341"
     },
     {
      "name": "342",
      "code": "342"
     },
     {
      "name": "343",
      "code": "343"
     },
     {
      "name": "344",
      "code": "344"
     },
     {
      "name": "345",
      "code": "345"
     },
     {
      "name": "346",
      "code": "346"
     },
     {
      "name": "347",
      "code": "347"
     },
     {
      "name": "348",
      "code": "348"
     },
     {
      "name": "349",
      "code": "349"
     },
     {
      "name": "601",
      "code": "601"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 3,
   "defaultValue": null,
   "modelName": "permit_area"
  },
  {
   "name": "els_processed",
   "type": "esriFieldTypeSmallInteger",
   "alias": "els_processed",
   "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": "els_processed"
  },
  {
   "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"
  }
 ],
 "indexes": [
  {
   "name": "i105ddap_permit_",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "ddap_permit_id"
  },
  {
   "name": "i105eligible_hun",
   "isAscending": true,
   "isUnique": false,
   "description": "",
   "fields": "eligible_hunter_id"
  },
  {
   "name": "r42_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_harvests",
   "description": "",
   "prototype": {
    "attributes": {
     "els_processed": null,
     "permit_area": null,
     "ddap_permit_id": null,
     "eligible_hunter_id": null,
     "harvest_date": null,
     "age_flag": null,
     "sex_flag": null,
     "harvest_location": null,
     "disposition_notes": null,
     "season": 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
}