Name: Sign Inventory

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: ODOT's inventory of roadway signs. 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: esriServerPointLabelPlacementCenterRight
Label Expression: [SIGN_CATEGORY]
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: 9
Font Family: Arial
Font Style: italic
Font Weight: normal
Font Decoration: none

Min. Scale: 30000.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 )
• SIGN_FILE_NUMBER ( nullable: true, length: 10, alias: SIGN_FILE_NUMBER, type: esriFieldTypeString )
• OLD_SIGN_FILE_ID ( nullable: true, length: 25, alias: OLD_SIGN_FILE_ID, type: esriFieldTypeString )
• signInv_STATUS ( nullable: true, length: 1, alias: STATUS, type: esriFieldTypeString )
• SIGN_OWNER ( nullable: true, length: 20, alias: SIGN_OWNER, type: esriFieldTypeString )
• signInv_INSTALLATION_DATE ( nullable: true, length: 8, alias: INSTALLATION_DATE, type: esriFieldTypeDate )
• SIGN_CATEGORY ( nullable: true, alias: SIGN_CATEGORY, type: esriFieldTypeInteger )
• SIGN_CODE ( nullable: true, length: 255, alias: SIGN_CODE, type: esriFieldTypeString )
• SIGN_TEXT ( nullable: true, length: 255, alias: SIGN_TEXT, type: esriFieldTypeString )
• MOUNT_POSITION ( nullable: true, length: 20, alias: MOUNT_POSITION, type: esriFieldTypeString )
• TRAVEL_DIRECTION ( nullable: true, length: 1, alias: TRAVEL_DIRECTION, type: esriFieldTypeString )
• BLANK_MATERIAL ( nullable: true, length: 20, alias: BLANK_MATERIAL, type: esriFieldTypeString )
• SIGN_WIDTH_INCHES ( nullable: true, alias: SIGN_WIDTH_INCHES, type: esriFieldTypeInteger )
• SIGN_HEIGHT_INCHES ( nullable: true, alias: SIGN_HEIGHT_INCHES, type: esriFieldTypeInteger )
• SIGN_AREA_SQFT ( nullable: true, alias: SIGN_AREA_SQFT, type: esriFieldTypeDouble )
• SIGN_BEACON ( nullable: true, length: 1, alias: SIGN_BEACON, type: esriFieldTypeString )
• EXTERNAL_LIGHTING ( nullable: true, length: 1, alias: EXTERNAL_LIGHTING, type: esriFieldTypeString )
• INTERNAL_LIGHTING ( nullable: true, length: 1, alias: INTERNAL_LIGHTING, type: esriFieldTypeString )
• BLANKOUT ( nullable: true, length: 1, alias: BLANKOUT, type: esriFieldTypeString )
• LED_ENHANCED ( nullable: true, length: 1, alias: LED_ENHANCED, type: esriFieldTypeString )
• VARIABLE_MESSAGE ( nullable: true, length: 1, alias: VARIABLE_MESSAGE, type: esriFieldTypeString )
• FREEWAY_SIGN ( nullable: true, length: 1, alias: FREEWAY_SIGN, type: esriFieldTypeString )
• SIGN_INV_COMMENTS ( nullable: true, length: 2500, alias: SIGN_INV_COMMENTS, type: esriFieldTypeString )
• 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 )
• supInv_STATUS ( nullable: true, length: 1, alias: SupInvStatus, type: esriFieldTypeString )
• supInv_INSTALLATION_DATE ( nullable: true, length: 8, alias: SupInvInstallation_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 )
• 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: esriFieldTypeDouble )
• ACCESS_CONTROL ( nullable: true, alias: ACCESS_CONTROL, 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 )
• JURISDICTION ( nullable: true, length: 1, alias: JURISDICTION, type: esriFieldTypeString )
• DIVIDED_HWY ( nullable: true, length: 1, alias: DIVIDED_HWY, type: esriFieldTypeString )
• 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 )
• 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 )
• signInv_PID ( nullable: true, alias: signInv_PID, type: esriFieldTypeInteger )
• signInv_END_CONSTRUCTION_DATE ( nullable: true, length: 8, alias: signInv_END_CONSTRUCTION_DATE, type: esriFieldTypeDate )
• signInv_LET_PLANS_URL ( nullable: true, length: 150, alias: signInv_LET_PLANS_URL, type: esriFieldTypeString )
• signInv_MAINTAIN_RESPONSIBLE ( nullable: true, length: 1, alias: signInv_MAINTAIN_RESPONSIBLE, type: esriFieldTypeString )
• HINGED ( nullable: true, length: 1, alias: HINGED, type: esriFieldTypeString )
• EMS_EIMS_NUMBER ( nullable: true, alias: EMS_EIMS_NUMBER, type: esriFieldTypeInteger )
• SIGN_REFLECT_MEASURE ( nullable: true, alias: SIGN_REFLECT_MEASURE, type: esriFieldTypeInteger )
• SIGN_REFLECT_MEASUR_DT ( nullable: true, length: 8, alias: SIGN_REFLECT_MEASUR_DT, type: esriFieldTypeDate )
• signInv_created_user ( nullable: true, length: 255, alias: signInv_created_user, type: esriFieldTypeString )
• signInv_created_date ( nullable: true, length: 8, alias: signInv_created_date, type: esriFieldTypeDate )
• signInv_last_edited_user ( nullable: true, length: 255, alias: signInv_last_edited_user, type: esriFieldTypeString )
• signInv_last_edited_date ( nullable: true, length: 8, alias: signInv_last_edited_date, type: esriFieldTypeDate )
• signInv_OBJECTID ( nullable: false, alias: signInv_OBJECTID, type: esriFieldTypeInteger )
• supInv_PID ( nullable: true, alias: supInv_PID, type: esriFieldTypeInteger )
• supInv_END_CONSTRUCTION_DATE ( nullable: true, length: 8, alias: supInv_END_CONSTRUCTION_DATE, type: esriFieldTypeDate )
• supInv_LET_PLANS_URL ( nullable: true, length: 150, alias: supInv_LET_PLANS_URL, type: esriFieldTypeString )
• supInv_MAINTAIN_RESPONSIBLE ( nullable: true, length: 1, alias: supInv_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 )
• REPLACEMENT_PID ( nullable: true, alias: REPLACEMENT_PID, type: esriFieldTypeInteger )
• 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 )
• supInv_OBJECTID ( nullable: true, alias: supInv_OBJECTID, type: esriFieldTypeInteger )
• Image_Attach_supInsp ( nullable: true, length: 255, alias: Image_Attach_supInv, type: esriFieldTypeString )
• signInv_GlobalID ( nullable: false, length: 255, alias: signInv_GlobalID, type: esriFieldTypeString )
• signInv_REL_GLOBALID ( nullable: true, length: 255, alias: signInv_REL_GLOBALID, type: esriFieldTypeString )

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

  Iteminfo   Thumbnail   Metadata