Layers:

Layer: Retaining Wall (18)

Name: Retaining Wall

Display Field: VENDOR_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 855a5f4e21ab435da1b92022a587b5c6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: -9787349.658121338
YMin: 4563311.550441969
XMax: -9436902.259723578
YMax: 5117388.679794316
Spatial Reference: 102100  (3857)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [80, 175, 172, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• VENDOR_NAME ( type: esriFieldTypeString, alias: Vendor name, length: 50 , Coded Values: [WSP: WSP] , [CTL: CTL] , [Resource International: Resource International] , ...1 more... )
• WORKFLOW_STATUS ( type: esriFieldTypeSmallInteger, alias: Workflow Status , Coded Values: [0: Collected] , [1: Reviewed] , [2: Returned] , ...1 more... )
• ARRIVAL_DATE_TIME ( type: esriFieldTypeDate, alias: Arrival date and time, length: 8 )
• DEPARTURE_DATE_TIME ( type: esriFieldTypeDate, alias: Departure date and time, length: 8 )
• OBSERVER_NAME ( type: esriFieldTypeString, alias: Observer name, length: 50 )
• WEATHER_CONDITION ( type: esriFieldTypeString, alias: Weather Condition, length: 100 )
• WALL_TYPE ( type: esriFieldTypeSmallInteger, alias: Wall Type , Coded Values: [0: Masonary] , [1: RC Cantilever] , [2: RC Counterfort] , ...12 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• ASSOC_FEATURE ( type: esriFieldTypeSmallInteger, alias: Associated Feature , Coded Values: [0: Bridge Abutment] , [1: Roadway Ramps] , [2: Railroad] , ...5 more... )
• INVENTORIED_FACING_DIRECTION ( type: esriFieldTypeString, alias: Inventoried Facing Direction, length: 5 , Coded Values: [N: North] , [NE: Northeast] , [E: East] , ...5 more... )
• WALL_FACING_TYPE ( type: esriFieldTypeString, alias: Wall Facing Type, length: 50 , Coded Values: [Precast Concrete Panel: Precast Concrete Panel] , [Modular Block: Modular Block] , [Wire Frame: Wire Frame] , ...5 more... )
• PANEL_HEIGHT ( type: esriFieldTypeDouble, alias: Panel Height (deci. ft) )
• PANEL_WIDTH ( type: esriFieldTypeDouble, alias: Panel Width (dec. ft) )
• PANEL_SHAPE ( type: esriFieldTypeString, alias: PANEL_SHAPE, length: 25 , Coded Values: [Rectangular: Rectangular] , [Cruciform: Cruciform] , [Square: Square] )
• WALL_DESIGN ( type: esriFieldTypeString, alias: Wall Design Method, length: 50 , Coded Values: [ASD: ASD] , [LFD: LFD] , [LRFD: LRFD] )
• WALL_VENDOR ( type: esriFieldTypeString, alias: MSE Wall Vendor Name, length: 50 , Coded Values: [Sanders: Sanders] , [Reco: Reco] , [Sinewall: Sinewall] , ...1 more... )
• BEGIN_EXPOSE_HEIGHT ( type: esriFieldTypeInteger, alias: Exposed Height at Beginning , Range: [0, 100] )
• COMMENTS_OBSERVATION ( type: esriFieldTypeString, alias: Comments / Observations, length: 256 )
• BREAK_EXPOSE_HEIGHT ( type: esriFieldTypeInteger, alias: Expose Height at Break , Range: [0, 100] )
• TURN_EXPOSED_HEIGHT ( type: esriFieldTypeInteger, alias: Exposed Height at Turn , Range: [0, 100] )
• END_EXPOSED_HEIGHT ( type: esriFieldTypeInteger, alias: Exposed Height at End , Range: [0, 100] )
• HEIGHT_ABOVE_SOIL ( type: esriFieldTypeInteger, alias: Height above Retained Soil , Range: [0, 10] )
• MAX_WALL_HEIGHT ( type: esriFieldTypeInteger, alias: Maxium Wall Height , Range: [0, 150] )
• WATER_DEPTH ( type: esriFieldTypeInteger, alias: Water Table Depth , Range: [0, 100] )
• BEARING_CAPACITY ( type: esriFieldTypeInteger, alias: Bearing Capacity , Range: [1000, 10000] )
• WALL_FACE_EXPOSED ( type: esriFieldTypeInteger, alias: Exposed Wall Facing Area )
• ERMS_LINK ( type: esriFieldTypeString, alias: Field Elevation View, length: 100 )
• FOUNDATION_INFO ( type: esriFieldTypeString, alias: Foundation Improvement Information, length: 256 )
• MAX_CONTACT_PRESSURE ( type: esriFieldTypeInteger, alias: Maximum Contact Pressure )
• COLLECTION_LOCATION ( type: esriFieldTypeString, alias: Collection Location, length: 50 , Coded Values: [Office: Office] , [Field: Field] , [FH: Field & Office] )
• WALL_OWNER ( type: esriFieldTypeString, alias: Retaining Wall Owner, length: 50 , Coded Values: [LPA: LPA] , [State: State] , [Federal: Federal] )
• NBI ( type: esriFieldTypeString, alias: NBI, length: 9 )
• DES ( type: esriFieldTypeString, alias: DES, length: 15 )
• PUBLICSAFETYRATING ( type: esriFieldTypeString, alias: Public Safety Rating, length: 50 )
• WALL_CONDITION ( type: esriFieldTypeSmallInteger, alias: Wall Condition )
• ADDITIONAL_COMMENTS ( type: esriFieldTypeString, alias: Additional Comments, length: 256 )
• ROUTE_NAME ( type: esriFieldTypeString, alias: Route Name, length: 50 )
• YEAER ( type: esriFieldTypeSmallInteger, alias: Year , Range: [1850, 2150] )
• DISTRICT ( type: esriFieldTypeString, alias: District, length: 25 )
• WALL_ID ( type: esriFieldTypeInteger, alias: WALL ID )
• FACE_ID ( type: esriFieldTypeString, alias: FACE ID, length: 256 )
• RETIRED_DATE ( type: esriFieldTypeDate, alias: Date Retired, length: 8 )
• ASSET_NAME ( type: esriFieldTypeString, alias: Asset Name, length: 20 )
• ESRIGNSS_RECEIVER ( type: esriFieldTypeString, alias: Receiver Name, length: 50 )
• ESRIGNSS_H_RMS ( type: esriFieldTypeDouble, alias: Horizontal Accuracy (m) )
• ESRIGNSS_V_RMS ( type: esriFieldTypeDouble, alias: Vertical Accuracy (m) )
• ESRIGNSS_LATITUDE ( type: esriFieldTypeDouble, alias: Latitude )
• ESRIGNSS_LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude )
• ESRIGNSS_ALTITUDE ( type: esriFieldTypeDouble, alias: Altitude )
• ESRIGNSS_PDOP ( type: esriFieldTypeDouble, alias: PDOP )
• ESRIGNSS_HDOP ( type: esriFieldTypeDouble, alias: HDOP )
• ESRIGNSS_VDOP ( type: esriFieldTypeDouble, alias: VDOP )
• ESRIGNSS_FIXTYPE ( type: esriFieldTypeSmallInteger, alias: Fix Type )
• ESRIGNSS_CORRECTIONAGE ( type: esriFieldTypeDouble, alias: Correction Age )
• ESRIGNSS_STATIONID ( type: esriFieldTypeSmallInteger, alias: Station ID )
• ESRIGNSS_NUMSATS ( type: esriFieldTypeSmallInteger, alias: Num Satellites )
• ESRIGNSS_FIXDATETIME ( type: esriFieldTypeDate, alias: Fix Date Time, length: 8 )
• ESRIGNSS_AVG_H_RMS ( type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m) )
• ESRIGNSS_AVG_V_RMS ( type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m) )
• ESRIGNSS_AVG_POSITIONS ( type: esriFieldTypeInteger, alias: Average Positions )
• ESRIGNSS_H_STDDEV ( type: esriFieldTypeDouble, alias: Standard Deviation (m) )
• CREATED_USER ( type: esriFieldTypeString, alias: Created User, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Date Created, 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 )

Relationships:

• RetainWall_Inspection (0) -- Related To: Retaining Wall Inspection (19)
• Retaining_Wall_Defects (1) -- Related To: Retaining Wall Defects (20)

Tables:

Table: Retaining Wall Inspection (19)

Name: Retaining Wall Inspection

Display Field: CREATED_USER

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 855a5f4e21ab435da1b92022a587b5c6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CREATED_USER ( type: esriFieldTypeString, alias: Created User, length: 255 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited User, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• INSPECTION_DATE ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• OVERALL_CONDITION ( type: esriFieldTypeSmallInteger, alias: Wall Condition , Coded Values: [3: 3 - Serious Condition] , [4: 4 - Poor Condition] , [5: 5 - Fair Condition] , ...5 more... )
• FACE_CONDITION ( type: esriFieldTypeSmallInteger, alias: Face Condition , Coded Values: [3: 3 - Serious Condition] , [4: 4 - Poor Condition] , [5: 5 - Fair Condition] , ...5 more... )
• VERTICALS_CONDITION ( type: esriFieldTypeSmallInteger, alias: Vertical(s) Condition , Coded Values: [3: 3 - Serious Condition] , [4: 4 - Poor Condition] , [5: 5 - Fair Condition] , ...5 more... )
• CAPS_CONDITION ( type: esriFieldTypeSmallInteger, alias: Cap(s) Condition , Coded Values: [3: 3 - Serious Condition] , [4: 4 - Poor Condition] , [5: 5 - Fair Condition] , ...5 more... )
• COMMENTS_OBSERVATION ( type: esriFieldTypeString, alias: Comments / Observations, length: 1073741822 )
• ADDITIONAL_COMMENTS ( type: esriFieldTypeString, alias: Additional Comments, length: 1073741822 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
• MONTHS_UNTIL_NEXT_INSPECTION ( type: esriFieldTypeSmallInteger, alias: MONTHS_UNTIL_NEXT_INSPECTION , Coded Values: [96: 96 Months - 8 years] , [72: 72 Months - 6 Years] , [48: 48 Months - 4 Years] , ...3 more... )

Relationships:

• Retaining_Wall (0) -- Related To: Retaining Wall (18)

Table: Retaining Wall Defects (20)

Name: Retaining Wall Defects

Display Field: DEFECT

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 855a5f4e21ab435da1b92022a587b5c6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DEFECT ( type: esriFieldTypeSmallInteger, alias: DEFECT )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• REL_GUID ( type: esriFieldTypeGUID, alias: REL_GUID, length: 38 )
• DEFECT_RATING ( type: esriFieldTypeSmallInteger, alias: DEFECT_RATING , Coded Values: [9: 9 - EXCELLENT - Perfect condition, recently installed or repaired] , [7: 7 - GOOD - No repairs needed, list specific items to consider for next inspection] , [5: 5 - FAIR - Acceptable condition, increase inspection frequency] , ...3 more... )
• ESTIMATED_DEFECT_AREA ( type: esriFieldTypeSmallInteger, alias: ESTIMATED DEFECT AREA (SQ FT) )
• ESTIMATED_DEFECT_LENGTH ( type: esriFieldTypeSmallInteger, alias: ESTIMATED DEFECT LENGTH (FT) )
• WALL_PART_TYPE ( type: esriFieldTypeSmallInteger, alias: WALL PART TYPE , Coded Values: [0: Anchored Bulkhead - Anchorage] , [1: Anchored Bulkhead - Horizontal Coping] , [2: Anchored Bulkhead - Vertical Elements/Slip Joints] , ...27 more... )
• ESTIMATED_DEFECT_WIDTH ( type: esriFieldTypeSmallInteger, alias: ESTIMATED DEFECT WIDTH(FT) )
• DEFECT_LOCATION ( type: esriFieldTypeString, alias: DEFECT LOCATION DESCRIPTION, length: 256 )
• RETIRE_DATE ( type: esriFieldTypeDate, alias: RETIRE DATE, length: 8 )
• CREATIONDATE ( type: esriFieldTypeDate, alias: CreationDate, length: 8 )
• CREATOR ( type: esriFieldTypeString, alias: Creator, length: 128 )
• EDITDATE ( type: esriFieldTypeDate, alias: EditDate, length: 8 )
• EDITOR ( type: esriFieldTypeString, alias: Editor, length: 128 )
• RELATE ( type: esriFieldTypeInteger, alias: Relate )

Relationships:

• Retaining_Wall (1) -- Related To: Retaining Wall (18)