{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 3,
 "name": "TR.TR_ADMIN.NEEDSBOOK_Needsbook",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "HIGHWAY_SUFFIX_KEY",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "MAPID",
   "type": "esriFieldTypeInteger",
   "alias": "MAPID",
   "domain": null
  },
  {
   "name": "HIGHWAY_SUFFIX_KEY",
   "type": "esriFieldTypeString",
   "alias": "HIGHWAY_SUFFIX_KEY",
   "length": 6,
   "domain": null
  },
  {
   "name": "HIGHWAY",
   "type": "esriFieldTypeString",
   "alias": "HIGHWAY",
   "length": 4,
   "domain": null
  },
  {
   "name": "DIRECTION",
   "type": "esriFieldTypeString",
   "alias": "Direction",
   "length": 1,
   "domain": null
  },
  {
   "name": "SUFFIX_HWY_TYPE",
   "type": "esriFieldTypeString",
   "alias": "SUFFIX_HWY_TYPE",
   "length": 1,
   "domain": null
  },
  {
   "name": "FED_AID_SYSTEM",
   "type": "esriFieldTypeString",
   "alias": "Federal Aid System",
   "length": 6,
   "domain": null
  },
  {
   "name": "FED_AID_SYS_CODE",
   "type": "esriFieldTypeString",
   "alias": "FED_AID_SYS_CODE",
   "length": 1,
   "domain": null
  },
  {
   "name": "FUNDING_CATEGORY",
   "type": "esriFieldTypeString",
   "alias": "Funding Category",
   "length": 4,
   "domain": null
  },
  {
   "name": "FUNCTIONAL_CLASS",
   "type": "esriFieldTypeString",
   "alias": "Functional Classification",
   "length": 6,
   "domain": null
  },
  {
   "name": "FUNC_CLASS_CODE",
   "type": "esriFieldTypeString",
   "alias": "FUNC_CLASS_CODE",
   "length": 2,
   "domain": null
  },
  {
   "name": "BEGINNING_MRM",
   "type": "esriFieldTypeString",
   "alias": "Beginning MRM",
   "length": 6,
   "domain": null
  },
  {
   "name": "BEG_DISPLACEMENT",
   "type": "esriFieldTypeDouble",
   "alias": "MRM Displacement",
   "domain": null
  },
  {
   "name": "ENDING_MRM",
   "type": "esriFieldTypeString",
   "alias": "ENDING_MRM",
   "length": 6,
   "domain": null
  },
  {
   "name": "END_DISPLACEMENT",
   "type": "esriFieldTypeDouble",
   "alias": "END_DISPLACEMENT",
   "domain": null
  },
  {
   "name": "NEEDS_SEG_LENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "Segment Length",
   "domain": null
  },
  {
   "name": "YEAR_BUILT",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Year Built",
   "domain": null
  },
  {
   "name": "YEAR_LAST_IMPROVED",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Year Last Improved",
   "domain": null
  },
  {
   "name": "YEAR_LAST_SEALED",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Year Last Sealed",
   "domain": null
  },
  {
   "name": "COMPOSITE_INDEX",
   "type": "esriFieldTypeDouble",
   "alias": "Surface Condition Index",
   "domain": null
  },
  {
   "name": "ROUGHNESS_INDEX",
   "type": "esriFieldTypeDouble",
   "alias": "Roughness Index",
   "domain": null
  },
  {
   "name": "AVERAGE_STRENGTH",
   "type": "esriFieldTypeDouble",
   "alias": "AVERAGE_STRENGTH",
   "domain": null
  },
  {
   "name": "TRANS_CRACKING",
   "type": "esriFieldTypeDouble",
   "alias": "Transverse Cracking",
   "domain": null
  },
  {
   "name": "FATIGUE_CRACKING",
   "type": "esriFieldTypeDouble",
   "alias": "Fatigue Cracking",
   "domain": null
  },
  {
   "name": "PATCH_DETERIORATE",
   "type": "esriFieldTypeDouble",
   "alias": "Patching/Patch Deterioration",
   "domain": null
  },
  {
   "name": "BLOCK_CRACKING",
   "type": "esriFieldTypeDouble",
   "alias": "Block Cracking",
   "domain": null
  },
  {
   "name": "RUT_DEPTH",
   "type": "esriFieldTypeDouble",
   "alias": "Rut Index",
   "domain": null
  },
  {
   "name": "D_CRACKING_ASR",
   "type": "esriFieldTypeDouble",
   "alias": "D-Cracking/ASR",
   "domain": null
  },
  {
   "name": "JOINT_SPALLING",
   "type": "esriFieldTypeDouble",
   "alias": "Joint Spalling",
   "domain": null
  },
  {
   "name": "CORNER_CRACKING",
   "type": "esriFieldTypeDouble",
   "alias": "Corner Cracking",
   "domain": null
  },
  {
   "name": "FAULTING",
   "type": "esriFieldTypeDouble",
   "alias": "Faulting",
   "domain": null
  },
  {
   "name": "JOINT_SEAL_DAMAGE",
   "type": "esriFieldTypeDouble",
   "alias": "Joint Seal Damage",
   "domain": null
  },
  {
   "name": "PUNCH_OUTS",
   "type": "esriFieldTypeDouble",
   "alias": "Punchouts",
   "domain": null
  },
  {
   "name": "SURFACE_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Surface Type",
   "length": 5,
   "domain": null
  },
  {
   "name": "SHOULDER_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Shoulder Type - Prim/Secndry",
   "length": 7,
   "domain": null
  },
  {
   "name": "SHOULDER_TYPE_CODE",
   "type": "esriFieldTypeString",
   "alias": "SHOULDER_TYPE_CODE",
   "length": 1,
   "domain": null
  },
  {
   "name": "SURFACE_WIDTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Surface Width",
   "domain": null
  },
  {
   "name": "LEFT_SHLDR_WIDTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Lf Shldr Width-Prim/Secndry",
   "domain": null
  },
  {
   "name": "RIGHT_SHLDR_WIDTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Rt Shldr Width-Prim/Secndry",
   "domain": null
  },
  {
   "name": "ROW_WIDTH",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Widths-RDWY/ROW-Predom/MIN",
   "domain": null
  },
  {
   "name": "layer_1_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_1_year",
   "domain": null
  },
  {
   "name": "layer_1_code",
   "type": "esriFieldTypeString",
   "alias": "layer_1_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_1_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_1_thick",
   "domain": null
  },
  {
   "name": "layer_2_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_2_year",
   "domain": null
  },
  {
   "name": "layer_2_code",
   "type": "esriFieldTypeString",
   "alias": "layer_2_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_2_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_2_thick",
   "domain": null
  },
  {
   "name": "layer_3_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_3_year",
   "domain": null
  },
  {
   "name": "layer_3_code",
   "type": "esriFieldTypeString",
   "alias": "layer_3_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_3_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_3_thick",
   "domain": null
  },
  {
   "name": "layer_4_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_4_year",
   "domain": null
  },
  {
   "name": "layer_4_code",
   "type": "esriFieldTypeString",
   "alias": "layer_4_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_4_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_4_thick",
   "domain": null
  },
  {
   "name": "layer_5_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_5_year",
   "domain": null
  },
  {
   "name": "layer_5_code",
   "type": "esriFieldTypeString",
   "alias": "layer_5_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_5_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_5_thick",
   "domain": null
  },
  {
   "name": "layer_6_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_6_year",
   "domain": null
  },
  {
   "name": "layer_6_code",
   "type": "esriFieldTypeString",
   "alias": "layer_6_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_6_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_6_thick",
   "domain": null
  },
  {
   "name": "layer_7_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_7_year",
   "domain": null
  },
  {
   "name": "layer_7_code",
   "type": "esriFieldTypeString",
   "alias": "layer_7_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_7_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_7_thick",
   "domain": null
  },
  {
   "name": "layer_8_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_8_year",
   "domain": null
  },
  {
   "name": "layer_8_code",
   "type": "esriFieldTypeString",
   "alias": "layer_8_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_8_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_8_thick",
   "domain": null
  },
  {
   "name": "layer_9_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_9_year",
   "domain": null
  },
  {
   "name": "layer_9_code",
   "type": "esriFieldTypeString",
   "alias": "layer_9_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_9_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_9_thick",
   "domain": null
  },
  {
   "name": "layer_10_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_10_year",
   "domain": null
  },
  {
   "name": "layer_10_code",
   "type": "esriFieldTypeString",
   "alias": "layer_10_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_10_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_10_thick",
   "domain": null
  },
  {
   "name": "layer_11_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_11_year",
   "domain": null
  },
  {
   "name": "layer_11_code",
   "type": "esriFieldTypeString",
   "alias": "layer_11_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_11_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_11_thick",
   "domain": null
  },
  {
   "name": "layer_12_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "layer_12_year",
   "domain": null
  },
  {
   "name": "layer_12_code",
   "type": "esriFieldTypeString",
   "alias": "layer_12_code",
   "length": 3,
   "domain": null
  },
  {
   "name": "layer_12_thick",
   "type": "esriFieldTypeDouble",
   "alias": "layer_12_thick",
   "domain": null
  },
  {
   "name": "number_structure",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Structures",
   "domain": null
  },
  {
   "name": "number_box_culvert",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Box Culverts",
   "domain": null
  },
  {
   "name": "mainline_cost",
   "type": "esriFieldTypeInteger",
   "alias": "Mainline",
   "domain": null
  },
  {
   "name": "shoulder_cost",
   "type": "esriFieldTypeInteger",
   "alias": "Shoulders",
   "domain": null
  },
  {
   "name": "structure_cost",
   "type": "esriFieldTypeInteger",
   "alias": "Structure",
   "domain": null
  },
  {
   "name": "other_cost",
   "type": "esriFieldTypeInteger",
   "alias": "Other",
   "domain": null
  },
  {
   "name": "total_cost",
   "type": "esriFieldTypeInteger",
   "alias": "Total",
   "domain": null
  },
  {
   "name": "maint_contract_amt",
   "type": "esriFieldTypeInteger",
   "alias": "Tot 3yr Main Contract Amt",
   "domain": null
  },
  {
   "name": "current_adt",
   "type": "esriFieldTypeInteger",
   "alias": "Current ADT",
   "domain": null
  },
  {
   "name": "number_trucks",
   "type": "esriFieldTypeInteger",
   "alias": "Number Of Trucks",
   "domain": null
  },
  {
   "name": "accident_rate",
   "type": "esriFieldTypeDouble",
   "alias": "Weighted Crash Rate",
   "domain": null
  },
  {
   "name": "number_fatal",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Fatal",
   "domain": null
  },
  {
   "name": "number_injury",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Injury",
   "domain": null
  },
  {
   "name": "number_pdo",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Number of Property Damage",
   "domain": null
  },
  {
   "name": "project_programmed",
   "type": "esriFieldTypeString",
   "alias": "Project Programmed",
   "length": 3,
   "domain": null
  },
  {
   "name": "year_need",
   "type": "esriFieldTypeSmallInteger",
   "alias": "year_need",
   "domain": null
  },
  {
   "name": "pcems_1",
   "type": "esriFieldTypeString",
   "alias": "PCEMS Number",
   "length": 4,
   "domain": null
  },
  {
   "name": "improvement_type_1",
   "type": "esriFieldTypeString",
   "alias": "Improved Type",
   "length": 12,
   "domain": null
  },
  {
   "name": "improvement_cost_1",
   "type": "esriFieldTypeInteger",
   "alias": "Estimated Improvement Cost",
   "domain": null
  },
  {
   "name": "improvement_year_1",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Improvement Year",
   "domain": null
  },
  {
   "name": "pcems_2",
   "type": "esriFieldTypeString",
   "alias": "PCEMS Number",
   "length": 4,
   "domain": null
  },
  {
   "name": "improvement_type_2",
   "type": "esriFieldTypeString",
   "alias": "Improvement Type",
   "length": 12,
   "domain": null
  },
  {
   "name": "improvement_cost_2",
   "type": "esriFieldTypeInteger",
   "alias": "Estimated Improvement Cost",
   "domain": null
  },
  {
   "name": "improvement_year_2",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Improvement Year",
   "domain": null
  },
  {
   "name": "first_worst_rank",
   "type": "esriFieldTypeSmallInteger",
   "alias": "first_worst_rank",
   "domain": null
  },
  {
   "name": "need_book_year",
   "type": "esriFieldTypeSmallInteger",
   "alias": "need_book_year",
   "domain": null
  },
  {
   "name": "date_created",
   "type": "esriFieldTypeInteger",
   "alias": "date_created",
   "domain": null
  },
  {
   "name": "reconst_resurf",
   "type": "esriFieldTypeString",
   "alias": "reconst_resurf",
   "length": 4,
   "domain": null
  },
  {
   "name": "status_1",
   "type": "esriFieldTypeInteger",
   "alias": "status_1",
   "domain": null
  },
  {
   "name": "status_2",
   "type": "esriFieldTypeInteger",
   "alias": "status_2",
   "domain": null
  },
  {
   "name": "status_3",
   "type": "esriFieldTypeInteger",
   "alias": "status_3",
   "domain": null
  },
  {
   "name": "strength_yr",
   "type": "esriFieldTypeString",
   "alias": "strength_yr",
   "length": 4,
   "domain": null
  },
  {
   "name": "drs_yr",
   "type": "esriFieldTypeString",
   "alias": "drs_yr",
   "length": 4,
   "domain": null
  },
  {
   "name": "distress_yr",
   "type": "esriFieldTypeString",
   "alias": "distress_yr",
   "length": 4,
   "domain": null
  },
  {
   "name": "row_mnwdth",
   "type": "esriFieldTypeString",
   "alias": "row_mnwdth",
   "length": 3,
   "domain": null
  },
  {
   "name": "min_surfwdth",
   "type": "esriFieldTypeString",
   "alias": "min_surfwdth",
   "length": 3,
   "domain": null
  },
  {
   "name": "min_ltshldr",
   "type": "esriFieldTypeString",
   "alias": "min_ltshldr",
   "length": 2,
   "domain": null
  },
  {
   "name": "min_rtshldr",
   "type": "esriFieldTypeString",
   "alias": "min_rtshldr",
   "length": 2,
   "domain": null
  },
  {
   "name": "ave_rut",
   "type": "esriFieldTypeDouble",
   "alias": "Rut Depth (Inches) AVG/MAX",
   "domain": null
  },
  {
   "name": "max_rut",
   "type": "esriFieldTypeDouble",
   "alias": "max_rut",
   "domain": null
  },
  {
   "name": "sec_shldr_typ_code",
   "type": "esriFieldTypeString",
   "alias": "sec_shldr_typ_code",
   "length": 1,
   "domain": null
  },
  {
   "name": "sec_shldr_type",
   "type": "esriFieldTypeString",
   "alias": "sec_shldr_type",
   "length": 7,
   "domain": null
  },
  {
   "name": "sec_lt_shldr_width",
   "type": "esriFieldTypeString",
   "alias": "sec_lt_shldr_width",
   "length": 1,
   "domain": null
  },
  {
   "name": "min_secltshldr",
   "type": "esriFieldTypeString",
   "alias": "min_secltshldr",
   "length": 1,
   "domain": null
  },
  {
   "name": "sec_rt_shldr_width",
   "type": "esriFieldTypeString",
   "alias": "sec_rt_shldr_width",
   "length": 1,
   "domain": null
  },
  {
   "name": "min_secrtshldr",
   "type": "esriFieldTypeString",
   "alias": "min_secrtshldr",
   "length": 1,
   "domain": null
  },
  {
   "name": "roadway_width",
   "type": "esriFieldTypeString",
   "alias": "roadway_width",
   "length": 3,
   "domain": null
  },
  {
   "name": "adt_20yr",
   "type": "esriFieldTypeInteger",
   "alias": "Projected 20yr ADT",
   "domain": null
  },
  {
   "name": "region_no",
   "type": "esriFieldTypeSmallInteger",
   "alias": "region_no",
   "domain": null
  },
  {
   "name": "beg_mileage",
   "type": "esriFieldTypeDouble",
   "alias": "BEG_MILEAGE",
   "domain": null
  },
  {
   "name": "end_mileage",
   "type": "esriFieldTypeDouble",
   "alias": "END_MILEAGE",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R109_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "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": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "c7d4c952020446a39767c771e3cd3849"
}