{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 10,
 "name": "cdma_materials",
 "type": "Table",
 "description": null,
 "copyrightText": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "abatement_material_type",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "objectid",
   "domain": null
  },
  {
   "name": "cdma_id",
   "type": "esriFieldTypeInteger",
   "alias": "cdma_id",
   "domain": null
  },
  {
   "name": "abatement_material_type",
   "type": "esriFieldTypeString",
   "alias": "abatement_material_type",
   "length": 64,
   "domain": {
    "type": "codedValue",
    "name": "abatement_material_types",
    "description": "Description",
    "codedValues": [
     {
      "name": "Battery, Deep cycle",
      "code": "Battery, Deep cycle"
     },
     {
      "name": "Clips, 3/8\" ss (20/pkg)",
      "code": "Clips, 3/8\" ss (20/pkg)"
     },
     {
      "name": "Clips, 3/8\" vinyl (20/pkg)",
      "code": "Clips, 3/8\" vinyl (20/pkg)"
     },
     {
      "name": "Clips, 7/8\" ss (20/pkg)",
      "code": "Clips, 7/8\" ss (20/pkg)"
     },
     {
      "name": "Clips, 7/8\" vinyl (20/pkg)",
      "code": "Clips, 7/8\" vinyl (20/pkg)"
     },
     {
      "name": "Clips, Cotter key twister (100/pkg)",
      "code": "Clips, Cotter key twister (100/pkg)"
     },
     {
      "name": "Deer Net,  Standard duty (8' x 330')",
      "code": "Deer Net,  Standard duty (8' x 330')"
     },
     {
      "name": "Econo Reel",
      "code": "Econo Reel"
     },
     {
      "name": "Energizer, B100",
      "code": "Energizer, B100"
     },
     {
      "name": "Energizer, B-11 no stand",
      "code": "Energizer, B-11 no stand"
     },
     {
      "name": "Energizer, B200",
      "code": "Energizer, B200"
     },
     {
      "name": "Energizer, B-60",
      "code": "Energizer, B-60"
     },
     {
      "name": "Energizer, S-17 (Self-contained solar)",
      "code": "Energizer, S-17 (Self-contained solar)"
     },
     {
      "name": "Energizer, S-20",
      "code": "Energizer, S-20"
     },
     {
      "name": "Fence, Safety HD diamond Orange (6' x 50')",
      "code": "Fence, Safety HD diamond Orange (6' x 50')"
     },
     {
      "name": "Flash Tape (1.5\" x 290')",
      "code": "Flash Tape (1.5\" x 290')"
     },
     {
      "name": "Flash Tape (7/16\" x 290')",
      "code": "Flash Tape (7/16\" x 290')"
     },
     {
      "name": "Gate, Anchor kit (2/pkg)",
      "code": "Gate, Anchor kit (2/pkg)"
     },
     {
      "name": "Gate, Fiber rod (24\" x 7/8\", cut 8' into 4)",
      "code": "Gate, Fiber rod (24\" x 7/8\", cut 8' into 4)"
     },
     {
      "name": "Gate, HD gate handle",
      "code": "Gate, HD gate handle"
     },
     {
      "name": "Gate, PVC schedule 80 Grey (1.25\" x 48\")",
      "code": "Gate, PVC schedule 80 Grey (1.25\" x 48\")"
     },
     {
      "name": "Geotextile, Black (15' x 360')",
      "code": "Geotextile, Black (15' x 360')"
     },
     {
      "name": "Ground rod, 6' w/clamp",
      "code": "Ground rod, 6' w/clamp"
     },
     {
      "name": "Ground rod, Kit (3 rods, clamps, and wire)",
      "code": "Ground rod, Kit (3 rods, clamps, and wire)"
     },
     {
      "name": "Ground wire, Double insulated (30')",
      "code": "Ground wire, Double insulated (30')"
     },
     {
      "name": "Ground wire, Smooth HT (4,000')",
      "code": "Ground wire, Smooth HT (4,000')"
     },
     {
      "name": "Maxi-shock cable (1,320')",
      "code": "Maxi-shock cable (1,320')"
     },
     {
      "name": "P spring",
      "code": "P spring"
     },
     {
      "name": "Porcelain donut insulator",
      "code": "Porcelain donut insulator"
     },
     {
      "name": "Posts, Fiber-rod (3/8  x 4.5')",
      "code": "Posts, Fiber-rod (3/8  x 4.5')"
     },
     {
      "name": "Posts, Fiber-rod (3/8\" x 4')",
      "code": "Posts, Fiber-rod (3/8\" x 4')"
     },
     {
      "name": "Posts, Fiber-rod drilled (7/8\" x 7')",
      "code": "Posts, Fiber-rod drilled (7/8\" x 7')"
     },
     {
      "name": "Posts, Fiber-rod not drilled (7/8\" x 5')",
      "code": "Posts, Fiber-rod not drilled (7/8\" x 5')"
     },
     {
      "name": "Posts, Fiber-rod not drilled (7/8\" x 7')",
      "code": "Posts, Fiber-rod not drilled (7/8\" x 7')"
     },
     {
      "name": "Posts, step-in",
      "code": "Posts, step-in"
     },
     {
      "name": "PVC (1.25\" x 46\")",
      "code": "PVC (1.25\" x 46\")"
     },
     {
      "name": "Sign, Energized fence",
      "code": "Sign, Energized fence"
     },
     {
      "name": "Sucker rod (1\" x 24\")",
      "code": "Sucker rod (1\" x 24\")"
     },
     {
      "name": "Sucker rod, 6-hole (1.25\" x 7')",
      "code": "Sucker rod, 6-hole (1.25\" x 7')"
     },
     {
      "name": "Turbo Tape (½\" x 1,312')",
      "code": "Turbo Tape (½\" x 1,312')"
     },
     {
      "name": "Turbo Wire, White (2624')",
      "code": "Turbo Wire, White (2624')"
     },
     {
      "name": "Voltmeter, Econo",
      "code": "Voltmeter, Econo"
     },
     {
      "name": "Clips, T-post",
      "code": "Clips, T-post"
     },
     {
      "name": "Wire, Woven 20-96-12",
      "code": "Wire, Woven 20-96-12"
     },
     {
      "name": "Wire, Woven 8-32-6",
      "code": "Wire, Woven 8-32-6"
     },
     {
      "name": "6\"x16' wood treated post",
      "code": "6\"x16' wood treated post"
     },
     {
      "name": "5\"x16' wood treated post",
      "code": "5\"x16' wood treated post"
     },
     {
      "name": "4\"x14' wood treated post",
      "code": "4\"x14' wood treated post"
     },
     {
      "name": "6\"x16' cedar treated post",
      "code": "6\"x16' cedar treated post"
     },
     {
      "name": "5\"x16' cedar treated post",
      "code": "5\"x16' cedar treated post"
     },
     {
      "name": "4\"x14' cedar treated post",
      "code": "4\"x14' cedar treated post"
     },
     {
      "name": "Gates Green pasture 4'",
      "code": "Gates Green pasture 4'"
     },
     {
      "name": "Gates Green pasture 6'",
      "code": "Gates Green pasture 6'"
     },
     {
      "name": "Gates Green pasture 8'",
      "code": "Gates Green pasture 8'"
     },
     {
      "name": "Gates Green pasture 10'",
      "code": "Gates Green pasture 10'"
     },
     {
      "name": "Gates Green pasture 12'",
      "code": "Gates Green pasture 12'"
     },
     {
      "name": "Gates Green pasture 14'",
      "code": "Gates Green pasture 14'"
     },
     {
      "name": "Gates Green pasture 16'",
      "code": "Gates Green pasture 16'"
     },
     {
      "name": "Gates Wire Mesh 4'",
      "code": "Gates Wire Mesh 4'"
     },
     {
      "name": "Gates Wire Mesh 6'",
      "code": "Gates Wire Mesh 6'"
     },
     {
      "name": "Gates Wire Mesh 8'",
      "code": "Gates Wire Mesh 8'"
     },
     {
      "name": "Gates Wire Mesh 10'",
      "code": "Gates Wire Mesh 10'"
     },
     {
      "name": "Gates Wire Mesh 12'",
      "code": "Gates Wire Mesh 12'"
     },
     {
      "name": "Gates Wire Mesh 14'",
      "code": "Gates Wire Mesh 14'"
     },
     {
      "name": "Gates Wire Mesh 16'",
      "code": "Gates Wire Mesh 16'"
     },
     {
      "name": "Cattle guard crossing",
      "code": "Cattle guard crossing"
     },
     {
      "name": "electronet product",
      "code": "electronet product"
     },
     {
      "name": "propane cannon single",
      "code": "propane cannon single"
     },
     {
      "name": "propane cannon double",
      "code": "propane cannon double"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "quantity",
   "type": "esriFieldTypeInteger",
   "alias": "quantity",
   "domain": null
  },
  {
   "name": "total_material_cost",
   "type": "esriFieldTypeDouble",
   "alias": "total_material_cost",
   "domain": null
  },
  {
   "name": "total_tax",
   "type": "esriFieldTypeDouble",
   "alias": "total_tax",
   "domain": null
  },
  {
   "name": "total_shipping",
   "type": "esriFieldTypeDouble",
   "alias": "total_shipping",
   "domain": null
  },
  {
   "name": "emergency_flag",
   "type": "esriFieldTypeSmallInteger",
   "alias": "emergency_flag",
   "domain": {
    "type": "codedValue",
    "name": "boolean",
    "description": "boolean 0/1",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "material_status_flag",
   "type": "esriFieldTypeString",
   "alias": "material_status_flag",
   "length": 16,
   "domain": {
    "type": "codedValue",
    "name": "material_status",
    "description": "Description",
    "codedValues": [
     {
      "name": "Loaned",
      "code": "Loaned"
     },
     {
      "name": "Returned",
      "code": "Returned"
     },
     {
      "name": "Long-term",
      "code": "Long-term"
     },
     {
      "name": "Producer",
      "code": "Producer"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "material_install_location",
   "type": "esriFieldTypeString",
   "alias": "material_install_location",
   "length": 2000,
   "domain": null
  },
  {
   "name": "mat_delivered_sign_date_produce",
   "type": "esriFieldTypeDate",
   "alias": "mat_delivered_sign_date_producer",
   "length": 8,
   "domain": null
  },
  {
   "name": "mat_sign_dnr_area_mgr_user",
   "type": "esriFieldTypeString",
   "alias": "mat_sign_dnr_area_mgr_user",
   "length": 64,
   "domain": null
  },
  {
   "name": "mat_deliver_sign_date_dnr",
   "type": "esriFieldTypeDate",
   "alias": "mat_deliver_sign_date_dnr",
   "length": 8,
   "domain": null
  },
  {
   "name": "mat_return_sign_date_producer",
   "type": "esriFieldTypeDate",
   "alias": "mat_check_in_sign_date_grower",
   "length": 8,
   "domain": null
  },
  {
   "name": "mat_return_dnr_area_mgr_user",
   "type": "esriFieldTypeString",
   "alias": "mat_check_in_dnr_area_mgr_user",
   "length": 64,
   "domain": null
  },
  {
   "name": "mat_return_sign_date_dnr",
   "type": "esriFieldTypeDate",
   "alias": "mat_check_in_sign_date_dnr",
   "length": 8,
   "domain": null
  },
  {
   "name": "loan_date",
   "type": "esriFieldTypeDate",
   "alias": "loan_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "materials_delivered_complete",
   "type": "esriFieldTypeSmallInteger",
   "alias": "materials_delivered_complete",
   "domain": {
    "type": "codedValue",
    "name": "boolean",
    "description": "boolean 0/1",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "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": "partial_return_flag",
   "type": "esriFieldTypeSmallInteger",
   "alias": "partial_return_flag",
   "domain": {
    "type": "codedValue",
    "name": "boolean",
    "description": "boolean 0/1",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "unit_cost",
   "type": "esriFieldTypeDouble",
   "alias": "unit_cost",
   "domain": null
  },
  {
   "name": "materials_returned_complete",
   "type": "esriFieldTypeSmallInteger",
   "alias": "materials_returned_complete",
   "domain": {
    "type": "codedValue",
    "name": "boolean",
    "description": "boolean 0/1",
    "codedValues": [
     {
      "name": "False",
      "code": 0
     },
     {
      "name": "True",
      "code": 1
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "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": "abatement_material_type_other",
   "type": "esriFieldTypeString",
   "alias": "abatement_material_type_other",
   "length": 255,
   "domain": null
  },
  {
   "name": "material_vendor",
   "type": "esriFieldTypeString",
   "alias": "material_vendor",
   "length": 255,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "i83cdma_id",
   "fields": "cdma_id",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "r20_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 13,
   "name": "coop_damage_mgmt_agreement",
   "relatedTableId": 12,
   "role": "esriRelRoleDestination",
   "keyField": "cdma_id",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": true,
   "catalogID": "{F39F9917-4F3A-4C6D-8E4C-3C6A916167DB}"
  }
 ],
 "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
 }
}