Name: Sign Support Inventory

Display Field: CRS

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ODOT's inventory of sign supports.

Service Item Id: 9ea9844ce73c4d2dbf4948b29f73c470

Copyright Text: ODOT Office of Roadway Engineering

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 577791

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: true

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9442114.5212
YMin: 4637310.143799998
XMax: -8963327.5518
YMax: 5155188.568400003
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUPPORT_STYLE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: All Other Values
UniqueValueInfos:
• Value: 1
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 99
  Label: Ground Mounted
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 11
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 13
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 14
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 15
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 16
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 17
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 18
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 19
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 20
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 21
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 22
  Label: Overhead
  Description: N/A
  Symbol:
  
• Value: 98
  Label: Overhead
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementAboveRight
Label Expression: [SUPPORT_STYLE]
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: baseline
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: italic
Font Weight: bold
Font Decoration: none

Min. Scale: 50000.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• NLFID ( type: esriFieldTypeString, alias: NLFID, length: 14 )
• CRS ( type: esriFieldTypeString, alias: CRS, length: 17 )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT_DISTRICT, length: 2 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 10 )
• COUNTY_CD ( type: esriFieldTypeString, alias: COUNTY_CD, length: 3 )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: ROUTE_TYPE, length: 2 )
• ROUTE_NBR ( type: esriFieldTypeString, alias: ROUTE_NBR, length: 5 )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: ROUTE_SUFFIX, length: 1 )
• STREET_NAME ( type: esriFieldTypeString, alias: STREET_NAME, length: 100 )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL_BEGIN_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL_BEGIN_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LATITUDE_DD_BEGIN )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LONGITUDE_DD_BEGIN )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP_DATE, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 1 )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: INSTALLATION_DATE, length: 8 )
• SUPPORT_FILE_NUMBER ( type: esriFieldTypeString, alias: SUPPORT_FILE_NUMBER, length: 10 )
• OLD_SUPPORT_ID ( type: esriFieldTypeString, alias: OLD_SUPPORT_ID, length: 25 )
• SUPPORT_OWNER ( type: esriFieldTypeString, alias: SUPPORT_OWNER, length: 10 )
• PID ( type: esriFieldTypeInteger, alias: PID )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, length: 10 )
• ROUTE_DESIGNATION ( type: esriFieldTypeString, alias: ROUTE_DESIGNATION, length: 8 )
• SUPPORT_STYLE ( type: esriFieldTypeInteger, alias: SUPPORT_STYLE )
• SUPPORT_TYPE ( type: esriFieldTypeString, alias: SUPPORT_TYPE, length: 20 )
• DESIGN_NUMBER ( type: esriFieldTypeString, alias: DESIGN_NUMBER, length: 2 )
• SUPPORT_SIZE ( type: esriFieldTypeString, alias: SUPPORT_SIZE, length: 50 )
• NUM_OF_SUPPORTS ( type: esriFieldTypeInteger, alias: NUM_OF_SUPPORTS )
• NUM_OF_SIGNS ( type: esriFieldTypeInteger, alias: NUM_OF_SIGNS )
• BRIDGE_MOUNTED ( type: esriFieldTypeString, alias: BRIDGE_MOUNTED, length: 1 )
• MEDIAN_WALL_PLATES ( type: esriFieldTypeString, alias: MEDIAN_WALL_PLATES, length: 1 )
• BREAKAWAY_MECHANISM ( type: esriFieldTypeString, alias: BREAKAWAY_MECHANISM, length: 1 )
• FLANGE_TYPE ( type: esriFieldTypeString, alias: FLANGE_TYPE, length: 15 )
• REFLECTOR_STRIP ( type: esriFieldTypeString, alias: REFLECTOR_STRIP, length: 1 )
• OVERHEAD_SPAN_LENGTH ( type: esriFieldTypeInteger, alias: OVERHEAD_SPAN_LENGTH )
• PATH_WEB_VIEWER ( type: esriFieldTypeString, alias: PATH_WEB_VIEWER, length: 500 )
• SUPPORT_INV_COMMENTS ( type: esriFieldTypeString, alias: SUPPORT_INV_COMMENTS, length: 2500 )
• FOUNDATION_CRACKS ( type: esriFieldTypeString, alias: FOUNDATION_CRACKS, length: 10 )
• FOUND_SPALLING ( type: esriFieldTypeString, alias: FOUND_SPALLING, length: 1 )
• FOUND_SOIL_EROSION ( type: esriFieldTypeString, alias: FOUND_SOIL_EROSION, length: 1 )
• FOUND_COVERED ( type: esriFieldTypeString, alias: FOUND_COVERED, length: 1 )
• FOUND_OTHER ( type: esriFieldTypeString, alias: FOUND_OTHER, length: 255 )
• FOUND_COMMENTS ( type: esriFieldTypeString, alias: FOUND_COMMENTS, length: 2500 )
• ANCHOR_BOLT_CORROSION ( type: esriFieldTypeString, alias: ANCHOR_BOLT_CORROSION, length: 25 )
• ANCHOR_BOLT_CRACKING ( type: esriFieldTypeString, alias: ANCHOR_BOLT_CRACKING, length: 10 )
• ANCHOR_NUTS_CORROSION ( type: esriFieldTypeString, alias: ANCHOR_NUTS_CORROSION, length: 25 )
• ANCHOR_NUTS_CRACKING ( type: esriFieldTypeString, alias: ANCHOR_NUTS_CRACKING, length: 10 )
• ANCHOR_NUTS_LOOSE ( type: esriFieldTypeString, alias: ANCHOR_NUTS_LOOSE, length: 1 )
• MISSING_WASHERS ( type: esriFieldTypeString, alias: MISSING_WASHERS, length: 1 )
• ANC_BOLT_NUTS_COMMENTS ( type: esriFieldTypeString, alias: ANC_BOLT_NUTS_COMMENTS, length: 2500 )
• EF_EP_CORROSION ( type: esriFieldTypeString, alias: EF_EP_CORROSION, length: 25 )
• EF_EP_DAMAGE ( type: esriFieldTypeString, alias: EF_EP_DAMAGE, length: 20 )
• EF_EP_CRACKING ( type: esriFieldTypeString, alias: EF_EP_CRACKING, length: 10 )
• EF_EP_WIRE_CAP_MISS ( type: esriFieldTypeString, alias: EF_EP_WIRE_CAP_MISS, length: 1 )
• EF_EP_COVERS_MISSING ( type: esriFieldTypeString, alias: EF_EP_COVERS_MISSING, length: 1 )
• EF_EP_CAP_MISSING ( type: esriFieldTypeString, alias: EF_EP_CAP_MISSING, length: 1 )
• EF_EP_BOLT_CORROSION ( type: esriFieldTypeString, alias: EF_EP_BOLT_CORROSION, length: 25 )
• EF_EP_MISSING_BOLTS ( type: esriFieldTypeString, alias: EF_EP_MISSING_BOLTS, length: 1 )
• EF_EP_WELD_CORROSION ( type: esriFieldTypeString, alias: EF_EP_WELD_CORROSION, length: 25 )
• EF_EP_WELD_CRACKING ( type: esriFieldTypeString, alias: EF_EP_WELD_CRACKING, length: 10 )
• EF_EP_OTHER ( type: esriFieldTypeString, alias: EF_EP_OTHER, length: 1 )
• EF_EP_COMMENTS ( type: esriFieldTypeString, alias: EF_EP_COMMENTS, length: 2500 )
• CANT_SPAN_CORROSION ( type: esriFieldTypeString, alias: CANT_SPAN_CORROSION, length: 25 )
• CANT_SPAN_DAMAGE ( type: esriFieldTypeString, alias: CANT_SPAN_DAMAGE, length: 10 )
• CANT_SPAN_CRACKING ( type: esriFieldTypeString, alias: CANT_SPAN_CRACKING, length: 10 )
• CANT_SPAN_FLANGE_CRACK ( type: esriFieldTypeString, alias: CANT_SPAN_FLANGE_CRACK, length: 10 )
• CANT_SPAN_BOLT_CORROS ( type: esriFieldTypeString, alias: CANT_SPAN_BOLT_CORROS, length: 25 )
• CANT_SPAN_MISS_BOLTS ( type: esriFieldTypeString, alias: CANT_SPAN_MISS_BOLTS, length: 1 )
• CANT_SPAN_WELD_CORROS ( type: esriFieldTypeString, alias: CANT_SPAN_WELD_CORROS, length: 25 )
• CANT_SPAN_WELD_CRACK ( type: esriFieldTypeString, alias: CANT_SPAN_WELD_CRACK, length: 10 )
• CANT_SPAN_ENDCAPS_MISS ( type: esriFieldTypeString, alias: CANT_SPAN_ENDCAPS_MISS, length: 1 )
• CANT_SPAN_OTHER ( type: esriFieldTypeString, alias: CANT_SPAN_OTHER, length: 1 )
• CANT_SPAN_COMMENTS ( type: esriFieldTypeString, alias: CANT_SPAN_COMMENTS, length: 2500 )
• SIGN_ATTACH_CORROSION ( type: esriFieldTypeString, alias: SIGN_ATTACH_CORROSION, length: 25 )
• SIGN_ATTACH_DEFOR ( type: esriFieldTypeString, alias: SIGN_ATTACH_DEFOR, length: 1 )
• ATTACH_MISS_HARDWARE ( type: esriFieldTypeString, alias: ATTACH_MISS_HARDWARE, length: 1 )
• SIGN_DAMAGE ( type: esriFieldTypeString, alias: SIGN_DAMAGE, length: 20 )
• LIGHTING_MISS_HARDWARE ( type: esriFieldTypeString, alias: LIGHTING_MISS_HARDWARE, length: 1 )
• OBSTRUCTION_OVERGROWTH ( type: esriFieldTypeString, alias: OBSTRUCTION_OVERGROWTH, length: 1 )
• SIGN_INSP_COMMENTS ( type: esriFieldTypeString, alias: SIGN_INSP_COMMENTS, length: 2500 )
• OVERALL_CONDITION ( type: esriFieldTypeInteger, alias: OVERALL_CONDITION )
• INSPECTION_COMMENTS ( type: esriFieldTypeString, alias: INSPECTION_COMMENTS, length: 2500 )
• INSPECTOR_INITIALS ( type: esriFieldTypeString, alias: INSPECTOR_INITIALS, length: 255 )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: INSPECTION_DATE, length: 8 )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, length: 1 )
• DIVIDED_HWY ( type: esriFieldTypeString, alias: DIVIDED_HWY, length: 1 )
• ACCESS_CONTROL ( type: esriFieldTypeInteger, alias: ACCESS_CONTROL )
• URBAN_AREA_CODE ( type: esriFieldTypeString, alias: URBAN_AREA_CODE, length: 5 )
• BASE_TYPE ( type: esriFieldTypeString, alias: BASE_TYPE, length: 1 )
• FUNCTIONAL_CLASS ( type: esriFieldTypeString, alias: FUNCTIONAL_CLASS, length: 5 )
• HPMS_SAMPLE_ID ( type: esriFieldTypeString, alias: HPMS_SAMPLE_ID, length: 12 )
• LANES ( type: esriFieldTypeInteger, alias: LANES )
• MAINTENANCE_AUTHORITY ( type: esriFieldTypeString, alias: MAINTENANCE_AUTHORITY, length: 5 )
• NHS ( type: esriFieldTypeString, alias: NHS, length: 1 )
• PRIORITY_SYSTEM ( type: esriFieldTypeString, alias: PRIORITY_SYSTEM, length: 1 )
• SURFACE_TYPE ( type: esriFieldTypeString, alias: SURFACE_TYPE, length: 5 )
• SURFACE_WIDTH ( type: esriFieldTypeInteger, alias: SURFACE_WIDTH )
• ESAL_TOTAL ( type: esriFieldTypeInteger, alias: ESAL_TOTAL )
• AADT_PASSENGER ( type: esriFieldTypeInteger, alias: AADT_PASSENGER )
• AADT_TOTAL ( type: esriFieldTypeInteger, alias: AADT_TOTAL )
• AADT_BC_TRUCK ( type: esriFieldTypeInteger, alias: AADT_BC_TRUCK )
• PAVE_TYPE ( type: esriFieldTypeString, alias: PAVE_TYPE, length: 10 )
• PCR_YEAR ( type: esriFieldTypeInteger, alias: PCR_YEAR )
• ROADWAY_WIDTH_NBR ( type: esriFieldTypeSmallInteger, alias: ROADWAY_WIDTH_NBR )
• Image_Attach_supInv ( type: esriFieldTypeString, alias: Image_Attach_SupInv, length: 255 )
• Image_Attach_supInsp ( type: esriFieldTypeString, alias: Image_Attach_SupInsp, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• MAINTENANCE_RECOMMEND ( type: esriFieldTypeString, alias: MAINTENANCE_RECOMMEND, length: 1 )
• MAINTENANCE_COMPLETED ( type: esriFieldTypeString, alias: MAINTENANCE_COMPLETED, length: 1 )
• MAINTENANCE_COMPLET_DT ( type: esriFieldTypeDate, alias: MAINTENANCE_COMPLET_DT, length: 8 )
• MAINTENANCE_COMMENT ( type: esriFieldTypeString, alias: MAINTENANCE_COMMENT, length: 2500 )
• supInsp_created_date ( type: esriFieldTypeDate, alias: supInsp_created_date, length: 8 )
• supInsp_last_edited_date ( type: esriFieldTypeDate, alias: supInsp_last_edited_date, length: 8 )
• END_CONSTRUCTION_DATE ( type: esriFieldTypeDate, alias: END_CONSTRUCTION_DATE, length: 8 )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: LET_PLANS_URL, length: 150 )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: MAINTAIN_RESPONSIBLE, length: 1 )
• INTERSECTION_ID ( type: esriFieldTypeString, alias: INTERSECTION_ID, length: 36 )
• CROSS_ROUTE_LEG_ID ( type: esriFieldTypeString, alias: CROSS_ROUTE_LEG_ID, length: 36 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 255 )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, length: 32 )
• SUPPORT_CATEGORY ( type: esriFieldTypeString, alias: SUPPORT_CATEGORY, length: 14 )
• ATTACHMENTS ( type: esriFieldTypeString, alias: ATTACHMENTS, length: 1 )
• ATTACHMENT_COMMENTS ( type: esriFieldTypeString, alias: ATTACHMENT_COMMENTS, length: 2500 )
• PAINTED ( type: esriFieldTypeString, alias: PAINTED, length: 1 )
• SIGN_SUPPORT_REPLACE ( type: esriFieldTypeString, alias: SIGN_SUPPORT_REPLACE, length: 25 )
• REPLACEMENT_DATE ( type: esriFieldTypeDate, alias: REPLACEMENT_DATE, length: 8 )
• MAINTAIN_RECOMMEND ( type: esriFieldTypeString, alias: MAINTAIN_RECOMMEND, length: 1 )
• INSPECTION_DUE ( type: esriFieldTypeString, alias: INSPECTION_DUE, length: 28 )
• supInv_created_date ( type: esriFieldTypeDate, alias: supInv_created_date, length: 8 )
• supInv_last_edited_date ( type: esriFieldTypeDate, alias: supInv_last_edited_date, length: 8 )

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

  Iteminfo   Thumbnail   Metadata