Layers:

Layer: Stormwater - Culvert (0)

Name: Stormwater - Culvert

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Stormwater culverts is an inventory based on known construction asbuilt data and field inspections. This can include either road cross culverts or driveway culverts.</SPAN></P></DIV></DIV></DIV>

Service Item Id: a4cdcaa49b4d4cccb5a14cff83dedeab

Copyright Text: Schema provided by ESRI's small stormwater system

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: 1578453.3489135504
YMin: 96190.10138081014
XMax: 1871809.020075053
YMax: 389335.7824767232
Spatial Reference: 102748  (2285)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [78, 78, 78, 255]
Width: 2
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: true

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: Object ID )
• assetid ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• assettype ( type: esriFieldTypeSmallInteger, alias: Asset Type , Coded Values: [0: Unknown] , [81: Pipe Culvert] , [82: Pipe Arch] , ...6 more... )
• installdate ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• ownedby ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• maintby ( type: esriFieldTypeSmallInteger, alias: Maintained By , Coded Values: [1: Our Agency] , [2: Private] , [100: Other] )
• pipe_material ( type: esriFieldTypeSmallInteger, alias: Pipe Material , Coded Values: [0: Unknown] , [1: ABS Plastic - ABS] , [3: Asphalt - ASP] , ...16 more... )
• diameter ( type: esriFieldTypeDouble, alias: Diameter , Coded Values: [0: Unknown] , [0.5: 1/2"] , [0.75: 3/4"] , ...29 more... )
• upelev ( type: esriFieldTypeDouble, alias: Upstream Elevation )
• downelev ( type: esriFieldTypeDouble, alias: Downstream Elevation )
• slope ( type: esriFieldTypeDouble, alias: Slope )
• pipeshape ( type: esriFieldTypeSmallInteger, alias: Shape , Coded Values: [0: Unknown] , [1: Circular] , [2: Horseshoe] , ...5 more... )
• lined ( type: esriFieldTypeSmallInteger, alias: Lined? )
• lineryear ( type: esriFieldTypeSmallInteger, alias: Liner Year )
• linermethod ( type: esriFieldTypeSmallInteger, alias: Liner Method )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• lifecyclestatus ( type: esriFieldTypeSmallInteger, alias: Life Cycle Status , Coded Values: [0: Unknown] , [1: Proposed] , [2: Proposed - Approved] , ...4 more... )
• shape ( type: esriFieldTypeGeometry, alias: Shape )
• shape.STLength() ( type: esriFieldTypeDouble, alias: shape.STLength()gth )
• created_date ( type: esriFieldTypeDate, alias: Created Date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: Created User, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited User, length: 255 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, length: 38 )

Relationships:

• PWSDE.SDE.CulvertInspection (0) -- Related To: Culvert Inspection (1)

Tables:

Table: Culvert Inspection (1)

Name: Culvert Inspection

Display Field: InspectPerf

Type: Table

Geometry Type: N/A

Description: null

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 )
• InspectPerf ( type: esriFieldTypeString, alias: Was an inspection performed?, length: 10 , Coded Values: [yes: Yes] , [no: No] )
• OverallCond ( type: esriFieldTypeString, alias: What is the overall condition?, length: 50 , Coded Values: [1: Unknown] , [2: Poor] , [3: Fair] , ...1 more... )
• MaintPerf ( type: esriFieldTypeString, alias: What maintenance was done?, length: 50 , Coded Values: [5: None] , [6: Cleaned] , [7: Repaired] , ...1 more... )
• MaintNeed ( type: esriFieldTypeString, alias: What maintenance is still needed?, length: 50 , Coded Values: [9: None] , [10: Clean] , [11: Repair] , ...1 more... )
• Notes ( type: esriFieldTypeString, alias: Inspector Notes, length: 255 )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, length: 38 )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• PWSDE.SDE.Culvert (0) -- Related To: Stormwater - Culvert (0)