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

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: 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

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• signInv_STATUS ( type: esriFieldTypeString, alias: STATUS, length: 1 )
• signInv_INSTALLATION_DATE ( type: esriFieldTypeDate, alias: INSTALLATION_DATE, length: 8 )
• signInv_PID ( type: esriFieldTypeInteger, alias: signInv_PID )
• signInv_END_CONSTRUCTION_DATE ( type: esriFieldTypeDate, alias: signInv_END_CONSTRUCTION_DATE, length: 8 )
• signInv_LET_PLANS_URL ( type: esriFieldTypeString, alias: signInv_LET_PLANS_URL, length: 150 )
• signInv_MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: signInv_MAINTAIN_RESPONSIBLE, length: 1 )
• SIGN_FILE_NUMBER ( type: esriFieldTypeString, alias: SIGN_FILE_NUMBER, length: 10 )
• OLD_SIGN_FILE_ID ( type: esriFieldTypeString, alias: OLD_SIGN_FILE_ID, length: 25 )
• SIGN_OWNER ( type: esriFieldTypeString, alias: SIGN_OWNER, length: 20 )
• SIGN_CATEGORY ( type: esriFieldTypeInteger, alias: SIGN_CATEGORY )
• SIGN_CODE ( type: esriFieldTypeString, alias: SIGN_CODE, length: 255 )
• SIGN_TEXT ( type: esriFieldTypeString, alias: SIGN_TEXT, length: 100 )
• MOUNT_POSITION ( type: esriFieldTypeString, alias: MOUNT_POSITION, length: 20 )
• TRAVEL_DIRECTION ( type: esriFieldTypeString, alias: TRAVEL_DIRECTION, length: 1 )
• BLANK_MATERIAL ( type: esriFieldTypeString, alias: BLANK_MATERIAL, length: 20 )
• SIGN_WIDTH_INCHES ( type: esriFieldTypeInteger, alias: SIGN_WIDTH_INCHES )
• SIGN_HEIGHT_INCHES ( type: esriFieldTypeInteger, alias: SIGN_HEIGHT_INCHES )
• SIGN_AREA_SQFT ( type: esriFieldTypeDouble, alias: SIGN_AREA_SQFT )
• SIGN_BEACON ( type: esriFieldTypeString, alias: SIGN_BEACON, length: 1 )
• EXTERNAL_LIGHTING ( type: esriFieldTypeString, alias: EXTERNAL_LIGHTING, length: 1 )
• INTERNAL_LIGHTING ( type: esriFieldTypeString, alias: INTERNAL_LIGHTING, length: 1 )
• BLANKOUT ( type: esriFieldTypeString, alias: BLANKOUT, length: 1 )
• LED_ENHANCED ( type: esriFieldTypeString, alias: LED_ENHANCED, length: 1 )
• VARIABLE_MESSAGE ( type: esriFieldTypeString, alias: VARIABLE_MESSAGE, length: 1 )
• HINGED ( type: esriFieldTypeString, alias: HINGED, length: 1 )
• EMS_EIMS_NUMBER ( type: esriFieldTypeInteger, alias: EMS_EIMS_NUMBER )
• SIGN_REFLECT_MEASURE ( type: esriFieldTypeInteger, alias: SIGN_REFLECT_MEASURE )
• SIGN_REFLECT_MEASUR_DT ( type: esriFieldTypeDate, alias: SIGN_REFLECT_MEASUR_DT, length: 8 )
• FREEWAY_SIGN ( type: esriFieldTypeString, alias: FREEWAY_SIGN, length: 1 )
• SIGN_INV_COMMENTS ( type: esriFieldTypeString, alias: SIGN_INV_COMMENTS, length: 2500 )
• signInv_created_user ( type: esriFieldTypeString, alias: signInv_created_user, length: 255 )
• signInv_created_date ( type: esriFieldTypeDate, alias: signInv_created_date, length: 8 )
• signInv_last_edited_user ( type: esriFieldTypeString, alias: signInv_last_edited_user, length: 255 )
• signInv_last_edited_date ( type: esriFieldTypeDate, alias: signInv_last_edited_date, length: 8 )
• signInv_OBJECTID ( type: esriFieldTypeInteger, alias: signInv_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 )
• supInv_STATUS ( type: esriFieldTypeString, alias: SupInvStatus, length: 1 )
• supInv_INSTALLATION_DATE ( type: esriFieldTypeDate, alias: SupInvInstallation_Date, length: 8 )
• supInv_PID ( type: esriFieldTypeInteger, alias: supInv_PID )
• supInv_END_CONSTRUCTION_DATE ( type: esriFieldTypeDate, alias: supInv_END_CONSTRUCTION_DATE, length: 8 )
• supInv_LET_PLANS_URL ( type: esriFieldTypeString, alias: supInv_LET_PLANS_URL, length: 150 )
• supInv_MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: supInv_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 )
• 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 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 255 )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, length: 32 )
• PROJECT_NUMBER ( type: esriFieldTypeString, alias: PROJECT_NUMBER, length: 10 )
• ROUTE_DESIGNATION ( type: esriFieldTypeString, alias: ROUTE_DESIGNATION, length: 8 )
• SUPPORT_CATEGORY ( type: esriFieldTypeString, alias: SUPPORT_CATEGORY, length: 14 )
• 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: esriFieldTypeDouble, alias: OVERHEAD_SPAN_LENGTH )
• 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 )
• REPLACEMENT_PID ( type: esriFieldTypeInteger, alias: REPLACEMENT_PID )
• ACCESS_CONTROL ( type: esriFieldTypeInteger, alias: ACCESS_CONTROL )
• PATH_WEB_VIEWER ( type: esriFieldTypeString, alias: PATH_WEB_VIEWER, length: 500 )
• MAINTAIN_RECOMMEND ( type: esriFieldTypeString, alias: MAINTAIN_RECOMMEND, length: 1 )
• INSPECTION_DUE ( type: esriFieldTypeString, alias: INSPECTION_DUE, length: 28 )
• SUPPORT_INV_COMMENTS ( type: esriFieldTypeString, alias: SUPPORT_INV_COMMENTS, length: 2500 )
• supInv_created_user ( type: esriFieldTypeString, alias: supInv_created_user, length: 255 )
• supInv_created_date ( type: esriFieldTypeDate, alias: supInv_created_date, length: 8 )
• supInv_last_edited_user ( type: esriFieldTypeString, alias: supInv_last_edited_user, length: 255 )
• supInv_last_edited_date ( type: esriFieldTypeDate, alias: supInv_last_edited_date, length: 8 )
• supInv_GlobalID ( type: esriFieldTypeString, alias: supInv_GlobalID, length: 255 )
• supInv_OBJECTID ( type: esriFieldTypeInteger, alias: supInv_OBJECTID )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, length: 1 )
• DIVIDED_HWY ( type: esriFieldTypeString, alias: DIVIDED_HWY, length: 1 )
• 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_supInv, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• signInv_GlobalID ( type: esriFieldTypeString, alias: signInv_GlobalID, length: 255 )
• signInv_REL_GLOBALID ( type: esriFieldTypeString, alias: signInv_REL_GLOBALID, length: 255 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata