Name: Sign Support Inventory

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ODOT's inventory of roadway sign supports. Update frequency: Daily. For more information, visit: www.dot.state.oh.us/Divisions/Engineering/Roadway/DesignStandards/traffic/SDMM

Copyright Text: ODOT Office of Technical Services and Office of Roadway Engineering

Default Visibility: false

Max Result Window: N/A

Max Record Count: 2000

Standard Max Record Count No Geometry: 32000

Max Record Count Factor: 1

Standard MaxRecord Count: 32000

Tile Max Record Count: 8000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 577791.0

Max Scale: 0.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

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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 Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true

HasZ: false

HasM: false

Has Attachments: false

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: N/A

Fields:

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

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

  Iteminfo   Thumbnail   Metadata