Name: Retaining Wall Inventory

Display Field: PROJECT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Inventory of retaining walls on Ohio roadways. Update frequency: Daily. For more information, visit: www.dot.state.oh.us/Divisions/Engineering/Geotechnical/Pages/FoundRW.aspx

Copyright Text: The information contained within this dataset is maintained by the Ohio Department of Transportation (ODOT), and is deemed to be public information. While every effort is made to assure the data is accurate and current, it must be accepted and used by the recipient with the understanding that no warranties, expressed or implied, concerning the accuracy, reliability or suitability of this data have been made. ODOT, its agents, and the developers of this data set assume no liability whatsoever associated with the use or misuse of the data contained herein.

Default Visibility: false

MaxRecordCount: 200000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9440305.3604
YMin: 4638665.706699997
XMax: -8965900.1038
YMax: 5152970.951099999
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 170, 0, 255]
Width: 3
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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 )
• 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 )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL_BEGIN_NBR )
• CTL_END_NBR ( type: esriFieldTypeDouble, alias: CTL_END_NBR )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL_BEGIN_NBR )
• STL_END_NBR ( type: esriFieldTypeDouble, alias: STL_END_NBR )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LATITUDE_DD_BEGIN )
• LATITUDE_DD_END ( type: esriFieldTypeDouble, alias: LATITUDE_DD_END )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: LONGITUDE_DD_BEGIN )
• LONGITUDE_DD_END ( type: esriFieldTypeDouble, alias: LONGITUDE_DD_END )
• 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 )
• LET_PLANS_URL ( type: esriFieldTypeString, alias: LET_PLANS_URL, length: 150 )
• PID ( type: esriFieldTypeInteger, alias: PID )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: MAINTAIN_RESPONSIBLE, length: 1 )
• RETAINING_WALL_FILENUM ( type: esriFieldTypeString, alias: RETAINING_WALL_FILENUM, length: 9 )
• SECTION_ID ( type: esriFieldTypeString, alias: SECTION_ID, length: 10 )
• ABOVE_BELOW_ROAD ( type: esriFieldTypeString, alias: ABOVE_BELOW_ROAD, length: 5 )
• LOCATION_DESCRIPTION ( type: esriFieldTypeString, alias: LOCATION_DESCRIPTION, length: 2500 )
• ACCESS_CONSTRAINTS ( type: esriFieldTypeString, alias: ACCESS_CONSTRAINTS, length: 255 )
• ADJACENT_FEATURE_ABOVE ( type: esriFieldTypeString, alias: ADJACENT_FEATURE_ABOVE, length: 255 )
• ADJACENT_FEATURE_BELOW ( type: esriFieldTypeString, alias: ADJACENT_FEATURE_BELOW, length: 255 )
• PROJECT_NAME ( type: esriFieldTypeString, alias: PROJECT_NAME, length: 32 )
• STATE_PROJECT_NUMBER ( type: esriFieldTypeString, alias: STATE_PROJECT_NUMBER, length: 6 )
• WALL_NAME ( type: esriFieldTypeString, alias: WALL_NAME, length: 10 )
• WALL_TYPE ( type: esriFieldTypeString, alias: WALL_TYPE, length: 4 )
• WALL_SUPPLIER ( type: esriFieldTypeString, alias: WALL_SUPPLIER, length: 255 )
• WALL_FUNCTION ( type: esriFieldTypeString, alias: WALL_FUNCTION, length: 2 )
• WALL_FACE_MATERIAL ( type: esriFieldTypeString, alias: WALL_FACE_MATERIAL, length: 4 )
• MAX_EXPOSED_WALL_HT ( type: esriFieldTypeDouble, alias: MAX_EXPOSED_WALL_HT )
• WALL_SECTION_LENGTH ( type: esriFieldTypeDouble, alias: WALL_SECTION_LENGTH )
• WALL_FACE_SLOPE ( type: esriFieldTypeString, alias: WALL_FACE_SLOPE, length: 8 )
• UPSLOPE_ANGLE ( type: esriFieldTypeString, alias: UPSLOPE_ANGLE, length: 6 )
• DOWNSLOPE_ANGLE ( type: esriFieldTypeString, alias: DOWNSLOPE_ANGLE, length: 6 )
• FOUNDATION_TYPE ( type: esriFieldTypeString, alias: FOUNDATION_TYPE, length: 3 )
• FOUNDATION_DEPTH ( type: esriFieldTypeDouble, alias: FOUNDATION_DEPTH )
• WALL_EMBEDMENT_DEPTH ( type: esriFieldTypeDouble, alias: WALL_EMBEDMENT_DEPTH )
• MAX_TOTAL_WALL_HEIGHT ( type: esriFieldTypeDouble, alias: MAX_TOTAL_WALL_HEIGHT )
• WALL_HEIGHT_ABOVE_SOIL ( type: esriFieldTypeDouble, alias: WALL_HEIGHT_ABOVE_SOIL )
• BRIDGE_CULVERT_ASSOC ( type: esriFieldTypeString, alias: BRIDGE_CULVERT_ASSOC, length: 8 )
• BRIDGE_CULVERT_REF ( type: esriFieldTypeString, alias: BRIDGE_CULVERT_REF, length: 125 )
• WALL_DRAINAGE ( type: esriFieldTypeString, alias: WALL_DRAINAGE, length: 1 )
• DRAINAGE_DESCRIPTION ( type: esriFieldTypeString, alias: DRAINAGE_DESCRIPTION, length: 2500 )
• INVENTORY_COMMENTS ( type: esriFieldTypeString, alias: INVENTORY_COMMENTS, length: 2500 )
• NEXT_INSPECTION_DUE ( type: esriFieldTypeSmallInteger, alias: NEXT_INSPECTION_DUE )
• Invcreated_user ( type: esriFieldTypeString, alias: Invcreated_user, length: 255 )
• Invcreated_date ( type: esriFieldTypeDate, alias: Invcreated_date, length: 8 )
• Invlast_edited_user ( type: esriFieldTypeString, alias: Invlast_edited_user, length: 255 )
• Invlast_edited_date ( type: esriFieldTypeDate, alias: Invlast_edited_date, length: 8 )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, length: 8 )
• InvGlobalID ( type: esriFieldTypeString, alias: InvGlobalID, length: 100 )
• InvGDB_ARCHIVE_OID ( type: esriFieldTypeInteger, alias: InvGDB_ARCHIVE_OID )
• InvGDB_FROM_DATE ( type: esriFieldTypeDate, alias: InvGDB_FROM_DATE, length: 8 )
• InvGDB_TO_DATE ( type: esriFieldTypeDate, alias: InvGDB_TO_DATE, length: 8 )
• InvOBJECTID ( type: esriFieldTypeInteger, alias: InvOBJECTID )
• DEFORMATION_PRESENT ( type: esriFieldTypeString, alias: DEFORMATION_PRESENT, length: 1 )
• DAMAGE_PRESENT ( type: esriFieldTypeString, alias: DAMAGE_PRESENT, length: 1 )
• DRAINAGE_OUTLETS_OPER ( type: esriFieldTypeString, alias: DRAINAGE_OUTLETS_OPER, length: 3 )
• DRAINAGE_CHANNELS_OPER ( type: esriFieldTypeString, alias: DRAINAGE_CHANNELS_OPER, length: 3 )
• OVERALL_WALL_CONDITION ( type: esriFieldTypeString, alias: OVERALL_WALL_CONDITION, length: 4 )
• CONDITION_DESCRIPTION ( type: esriFieldTypeString, alias: CONDITION_DESCRIPTION, length: 2500 )
• REC_ENGINEER_INSP ( type: esriFieldTypeString, alias: REC_ENGINEER_INSP, length: 1 )
• MAINT_REPAIR_MOD ( type: esriFieldTypeString, alias: MAINT_REPAIR_MOD, length: 2500 )
• INSPECTOR ( type: esriFieldTypeString, alias: INSPECTOR, length: 50 )
• INSPECTION_date ( type: esriFieldTypeDate, alias: INSPECTION_date, length: 8 )
• NEEDS_MAINTENANCE ( type: esriFieldTypeString, alias: NEEDS_MAINTENANCE, length: 1 )
• InspREL_GLOBALID ( type: esriFieldTypeString, alias: InspREL_GLOBALID, length: 100 )
• Inspcreated_date ( type: esriFieldTypeDate, alias: Inspcreated_date, length: 8 )
• Insplast_edited_date ( type: esriFieldTypeDate, alias: Insplast_edited_date, length: 8 )
• InspGlobalID ( type: esriFieldTypeString, alias: InspGlobalID, length: 100 )
• Inspcreated_user ( type: esriFieldTypeString, alias: Inspcreated_user, length: 255 )
• Insplast_edited_user ( type: esriFieldTypeString, alias: Insplast_edited_user, length: 255 )
• InspGDB_ARCHIVE_OID ( type: esriFieldTypeInteger, alias: InspGDB_ARCHIVE_OID )
• InspGDB_FROM_DATE ( type: esriFieldTypeDate, alias: InspGDB_FROM_DATE, length: 8 )
• InspGDB_TO_DATE ( type: esriFieldTypeDate, alias: InspGDB_TO_DATE, length: 8 )
• InspOBJECTID ( type: esriFieldTypeInteger, alias: InspOBJECTID )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, length: 1 )
• DIVIDED_HWY ( type: esriFieldTypeString, alias: DIVIDED_HWY, 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_Inv ( type: esriFieldTypeString, alias: Image_Attach_Inv, length: 255 )
• Image_Attach_Insp ( type: esriFieldTypeString, alias: Image_Attach_Insp, 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 )
• Shape ( type: esriFieldTypeGeometry, alias: SHAPE )
• Shape.STLength() ( type: esriFieldTypeDouble, alias: Shape.STLength() )

Supported Operations:   Query   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata