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

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: true
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:

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

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:

Service Item Id: 35ad78a0f88645b29272dc02d234f0d4

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: true
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:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• InspectPerf ( type: esriFieldTypeString, alias: Was an inspection performed?, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspectPerf , Coded Values: [yes: Yes] , [no: No] )
• OverallCond ( type: esriFieldTypeString, alias: What is the overall condition?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OverallCond , Coded Values: [1: Unknown] , [2: Poor] , [3: Fair] , ...1 more... )
• MaintPerf ( type: esriFieldTypeString, alias: What maintenance was done?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintPerf , Coded Values: [5: None] , [6: Cleaned] , [7: Repaired] , ...1 more... )
• MaintNeed ( type: esriFieldTypeString, alias: What maintenance is still needed?, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintNeed , Coded Values: [9: None] , [10: Clean] , [11: Repair] , ...1 more... )
• Notes ( type: esriFieldTypeString, alias: Inspector Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• ParentGUID ( type: esriFieldTypeGUID, alias: Parent GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ParentGUID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
Templates:
• Name: Culvert Inspection
  Description:
  Prototype:
  Notes: null
  ParentGUID: null
  InspectPerf: null
  OverallCond: null
  MaintPerf: null
  MaintNeed: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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