Name: TR.TR_ADMIN.NEEDSBOOK_Needsbook

Display Field: HIGHWAY_SUFFIX_KEY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: c7d4c952020446a39767c771e3cd3849

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata