View In:   ArcGIS Online Map Viewer

Name: Stormwater: Pipe

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: A pipe is a hollow cylinder of material (plastic or other) used for collecting and conveying Stormwater. A swPipe is mostly solid, but can be perforated to allow infiltration into the ground; therefore, a subsurface infiltration trench can be either a swPipe or swVault.

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2400

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: 1283035.1461159736
YMin: 231257.5087388903
XMax: 1356125.8178477287
YMax: 287700.4512989819
Spatial Reference: 2926  (2926)  VCSWkid(5702)  LatestVCSWkid(5702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 44, 148, 255]
Width: 1
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• AssetID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: AssetID )
• d_AssetType ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: d_AssetType , Coded Values: [Aquatic: Aquatic] , [Art: Art] , [AssetRepair: AssetRepair] , ...70 more... )
• d_Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: false, length: 6, defaultValue: ACT, modelName: d_Status , Coded Values: [ACT: Active] , [CONST: Construction] , [ABN: Abandon] , ...3 more... )
• d_Ownership ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: false, length: 6, defaultValue: UNK, modelName: d_Ownership , Coded Values: [RED: City of Redmond] , [PVT: Private] , [KCO: King County] , ...7 more... )
• d_PipeSize ( type: esriFieldTypeDouble, alias: Size (in), editable: true, nullable: true, defaultValue: 0, modelName: d_PipeSize , Coded Values: [0: 0 inch/Unknown] , [1: 1 inch] , [1.5: 1.5 inch] , ...57 more... )
• d_PipeMaterial ( type: esriFieldTypeString, alias: Material, editable: true, nullable: false, length: 6, defaultValue: XXX, modelName: d_PipeMaterial , Coded Values: [PVC: Polyvinyl Chloride] , [CMP: Corrugated metal pipe] , [CP: Concrete pipe (non-reinforced)] , ...4 more... )
• CalcLength ( type: esriFieldTypeDouble, alias: Length (ft), editable: true, nullable: true, defaultValue: null, modelName: CalcLength )
• d_LinerDiameter ( type: esriFieldTypeDouble, alias: Liner Diameter, editable: true, nullable: true, defaultValue: 999, modelName: d_LinerDiameter , Coded Values: [0: 0 inch/Unknown] , [1: 1 inch] , [1.5: 1.5 inch] , ...57 more... )
• d_LinerThickness ( type: esriFieldTypeString, alias: Liner Thickness, editable: true, nullable: true, length: 3, defaultValue: NA, modelName: d_LinerThickness , Coded Values: [6: 6 mm] , [7: 7 mm] , [NA: NA] , ...6 more... )
• d_LinerMaterial ( type: esriFieldTypeString, alias: Liner Material, editable: true, nullable: true, length: 4, defaultValue: NON, modelName: d_LinerMaterial , Coded Values: [CAC: Calcium Aluminate Cement] , [FGL: Fiberglass] , [GH2S: Griffin H2S Sewersafe] , ...7 more... )
• LinerInstallYear ( type: esriFieldTypeString, alias: Liner Install Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LinerInstallYear )
• ContractDocuments ( type: esriFieldTypeString, alias: Contract Documents, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ContractDocuments )
• RecSlope ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: RecSlope )
• d_Shape ( type: esriFieldTypeString, alias: Shape, editable: true, nullable: false, length: 3, defaultValue: C, modelName: d_Shape , Coded Values: [C: Circular] , [Z: Other (state in comments)] , [O: Oval] , ...1 more... )
• Height ( type: esriFieldTypeDouble, alias: Height (in), editable: true, nullable: true, defaultValue: null, modelName: Height )
• Width ( type: esriFieldTypeDouble, alias: Width (in), editable: true, nullable: true, defaultValue: null, modelName: Width )
• UpstreamNodeIE ( type: esriFieldTypeDouble, alias: US Invert, editable: true, nullable: true, defaultValue: null, modelName: UpstreamNodeIE )
• DownstreamNodeIE ( type: esriFieldTypeDouble, alias: DS Invert, editable: true, nullable: true, defaultValue: null, modelName: DownstreamNodeIE )
• d_Infiltration ( type: esriFieldTypeString, alias: Infiltration, editable: true, nullable: false, length: 3, defaultValue: NO, modelName: d_Infiltration , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• d_StreamPipe ( type: esriFieldTypeString, alias: Stream, editable: true, nullable: false, length: 3, defaultValue: NO, modelName: d_StreamPipe , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• IndicatorStructureNo ( type: esriFieldTypeInteger, alias: Indicator Structure ID, editable: true, nullable: true, defaultValue: null, modelName: IndicatorStructureNo )
• swInspectionSiteID ( type: esriFieldTypeInteger, alias: Private Inspection Site ID, editable: true, nullable: true, defaultValue: null, modelName: swInspectionSiteID )
• PipeName ( type: esriFieldTypeString, alias: Private Inspection Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PipeName )
• InstallYear ( type: esriFieldTypeString, alias: Install Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InstallYear )
• d_EstimatedInstallYear ( type: esriFieldTypeString, alias: Estimated Install Year, editable: true, nullable: true, length: 3, defaultValue: UNK, modelName: d_EstimatedInstallYear , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• ProjectName ( type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• RecordDrawing ( type: esriFieldTypeString, alias: Record Drawing, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RecordDrawing )
• RecordDrawing1 ( type: esriFieldTypeString, alias: Record Drawing 1, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RecordDrawing1 )
• RecordDrawing2 ( type: esriFieldTypeString, alias: Record Drawing 2, editable: true, nullable: true, length: 10, defaultValue: null, modelName: RecordDrawing2 )
• d_UICFacility ( type: esriFieldTypeString, alias: d_UICFacility, editable: true, nullable: true, length: 3, defaultValue: NO, modelName: d_UICFacility , Coded Values: [YES: Yes] , [NO: No] , [UNK: Unknown] )
• UICFacility ( type: esriFieldTypeString, alias: UICFacility, editable: true, nullable: true, length: 10, defaultValue: NA, modelName: UICFacility )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: swPipe
  Description:
  Prototype:
  RecordDrawing2: null
  d_Ownership: UNK
  RecSlope: null
  RecordDrawing1: null
  DownstreamNodeIE: null
  d_Infiltration: NO
  d_AssetType: null
  RecordDrawing: null
  d_UICFacility: NO
  ProjectName: null
  d_Status: ACT
  d_PipeSize: 0
  d_EstimatedInstallYear: UNK
  UICFacility: NA
  AssetID: null
  d_PipeMaterial: XXX
  CalcLength: null
  d_LinerDiameter: 999
  d_LinerThickness: NA
  d_LinerMaterial: NON
  LinerInstallYear: null
  ContractDocuments: null
  d_Shape: C
  Height: null
  Width: null
  UpstreamNodeIE: null
  d_StreamPipe: NO
  IndicatorStructureNo: null
  swInspectionSiteID: null
  PipeName: null
  InstallYear: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata