View In:   ArcGIS Online Map Viewer

Name: SW - Pipes by AGE

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The stormwater pipes later includes all the available stormwater pipes including pipes that are not in-use. The data in this layer includes the pipe slope, upstream and downstream inverts of the pipe and the respective manholes. Feature class developed in May 2018 under Task Order #9 – Enterprise GIS – Utilities (Stormwater Pilot – Phase 2). NCSU Project# 201722020

Service Item Id: 7e3344ba4b814a6db9c6dcedb0932c15

Copyright Text: ESP Associates, Inc. Neal Banerjee, PE, CFM (Project Manager) 803-835-0890

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -8763822.6932
YMin: 4261853.557899997
XMax: -8756528.0848
YMax: 4277206.053099997
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Class Breaks Renderer:
Field: yrinstall
Min. Value: 1899.0
ClassBreakInfos:
• Class Maximum Value: 1927
  Label: 1899 - 1927
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [245, 0, 0, 255]
  Width: 2
• Class Maximum Value: 1970
  Label: 1928 - 1970
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [240, 100, 0, 255]
  Width: 2
• Class Maximum Value: 1992
  Label: 1971 - 1992
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [237, 198, 0, 255]
  Width: 2
• Class Maximum Value: 2007
  Label: 1993 - 2007
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Class Maximum Value: 2024
  Label: 2008 - 2024
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementCenterAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• assetid ( modelName: AssetID, nullable: true, editable: true, defaultValue: null, length: 30, alias: AssetID, type: esriFieldTypeString )
• usfeatid ( modelName: USFeatID, nullable: true, editable: true, defaultValue: null, length: 30, alias: USFeatID, type: esriFieldTypeString )
• dsfeatid ( modelName: DSFeatID, nullable: true, editable: true, defaultValue: null, length: 30, alias: DSFeatID, type: esriFieldTypeString )
• pipetype ( modelName: PipeType, nullable: true, editable: true, defaultValue: null, length: 20, alias: PipeType, type: esriFieldTypeString , Coded Values: [Pipe System: Pipe System] , [Culvert: Culvert] , [Assumed: Assumed] , ...1 more... )
• pipeshape ( modelName: PipeShape, nullable: true, editable: true, defaultValue: null, length: 20, alias: PipeShape, type: esriFieldTypeString , Coded Values: [Round: Round] , [Rectangular: Rectangular] , [Arch: Arch] , ...3 more... )
• pipematrl ( modelName: PipeMatrl, nullable: true, editable: true, defaultValue: null, length: 30, alias: PipeMatrl, type: esriFieldTypeString , Coded Values: [RCP: Concrete] , [CMP: Corrugated Metal] , [CPP: Corrugated Plastic] , ...7 more... )
• pipewidth ( modelName: PipeWidth, nullable: true, editable: true, defaultValue: null, alias: PipeWidth, type: esriFieldTypeDouble )
• pipehght ( modelName: PipeHght, nullable: true, editable: true, defaultValue: null, alias: PipeHght, type: esriFieldTypeDouble )
• isfunctng ( modelName: IsFunctng, nullable: true, editable: true, defaultValue: null, length: 20, alias: IsFunctng, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] , ...1 more... )
• pipecndn ( modelName: PipeCndn, nullable: true, editable: true, defaultValue: null, length: 30, alias: PipeCndn, type: esriFieldTypeString , Coded Values: [Good: Good - No Issues] , [Fair: Fair - Needs Minor Maintenance] , [Poor: Poor - Needs Maintenance] , ...5 more... )
• cndtnissue ( modelName: CndtnIssue, nullable: true, editable: true, defaultValue: null, length: 30, alias: CndtnIssue, type: esriFieldTypeString , Coded Values: [Obstruction: Obstruction] , [Minor Structural Issue: Minor Structural Issue (e.g. cracking)] , [Major Structural Issue: Major Structural Issue (e.g. crushed)] , ...5 more... )
• usrefdepth ( modelName: USRefDepth, nullable: true, editable: true, defaultValue: null, alias: USRefDepth, type: esriFieldTypeDouble )
• dsrefdpth ( modelName: DSRefDpth, nullable: true, editable: true, defaultValue: null, alias: DSRefDpth, type: esriFieldTypeDouble )
• usinvert ( modelName: USInvert, nullable: true, editable: true, defaultValue: null, alias: USInvert, type: esriFieldTypeDouble )
• dsinv ( modelName: DSInv, nullable: true, editable: true, defaultValue: null, alias: DSInv, type: esriFieldTypeDouble )
• slope ( modelName: Slope, nullable: true, editable: true, defaultValue: null, alias: Slope, type: esriFieldTypeDouble )
• dtassessed ( modelName: DtAssessed, nullable: true, editable: true, defaultValue: null, length: 29, alias: DtAssessed, type: esriFieldTypeDate )
• asmntcmnts ( modelName: AsmntCmnts, nullable: true, editable: true, defaultValue: null, length: 200, alias: AsmntCmnts, type: esriFieldTypeString )
• hposaccrcy ( modelName: HPosAccrcy, nullable: true, editable: true, defaultValue: null, length: 30, alias: HPosAccrcy, type: esriFieldTypeString , Coded Values: [Survey Grade: Survey Grade (subfoot)] , [Mapping Grade: Mapping Grade (submeter)] , [Aerial/Topo Derived: Aerial / Topo Derived] , ...3 more... )
• vposaccrcy ( modelName: VPosAccrcy, nullable: true, editable: true, defaultValue: null, length: 30, alias: VPosAccrcy, type: esriFieldTypeString , Coded Values: [Survey Grade: Survey Grade (subfoot)] , [Mapping Grade: Mapping Grade (submeter)] , [Aerial/Topo Derived: Aerial / Topo Derived] , ...3 more... )
• owner ( modelName: Owner, nullable: true, editable: true, defaultValue: null, length: 20, alias: Owner, type: esriFieldTypeString , Coded Values: [NCSU: NCSU] , [NCDOT: NCDOT] , [City: City] , ...7 more... )
• maintainby ( modelName: MaintainBy, nullable: true, editable: true, defaultValue: null, length: 20, alias: MaintainBy, type: esriFieldTypeString , Coded Values: [NCSU: NCSU] , [NCDOT: NCDOT] , [City: City] , ...7 more... )
• datasrc ( modelName: DataSrc, nullable: true, editable: true, defaultValue: null, length: 60, alias: DataSrc, type: esriFieldTypeString )
• sourceid ( modelName: SourceID, nullable: true, editable: true, defaultValue: null, length: 30, alias: SourceID, type: esriFieldTypeString )
• isenabled ( modelName: IsEnabled, nullable: true, editable: true, defaultValue: null, length: 20, alias: IsEnabled, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] , ...1 more... )
• scmid ( modelName: SCMID, nullable: true, editable: true, defaultValue: null, length: 30, alias: SCMID, type: esriFieldTypeString )
• prjno ( modelName: PrjNo, nullable: true, editable: true, defaultValue: null, length: 50, alias: PrjNo, type: esriFieldTypeString )
• yrinstall ( modelName: YrInstall, nullable: true, editable: true, defaultValue: null, alias: YrInstall, type: esriFieldTypeSmallInteger )
• yrdiscnt ( modelName: YrDiscnt, nullable: true, editable: true, defaultValue: null, alias: YrDiscnt, type: esriFieldTypeSmallInteger )
• yrsservice ( modelName: YrsService, nullable: true, editable: true, defaultValue: null, alias: YrsService, type: esriFieldTypeSmallInteger )
• yrslifecyc ( modelName: YrsLifeCyc, nullable: true, editable: true, defaultValue: null, alias: YrsLifeCyc, type: esriFieldTypeSmallInteger )
• yrrplcmnt ( modelName: YrRplcmnt, nullable: true, editable: true, defaultValue: null, alias: YrRplcmnt, type: esriFieldTypeSmallInteger )
• cstinstall ( modelName: CstInstall, nullable: true, editable: true, defaultValue: null, alias: CstInstall, type: esriFieldTypeInteger )
• cstrplcmnt ( modelName: CstRplcmnt, nullable: true, editable: true, defaultValue: null, alias: CstRplcmnt, type: esriFieldTypeInteger )
• hascctv ( modelName: HasCCTV, nullable: true, editable: true, defaultValue: null, length: 20, alias: HasCCTV, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] , ...1 more... )
• dtcleaned ( modelName: DtCleaned, nullable: true, editable: true, defaultValue: null, length: 29, alias: DtCleaned, type: esriFieldTypeDate )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 200, alias: Comments, type: esriFieldTypeString )
• hyplnkpath ( modelName: HyplnkPath, nullable: true, editable: true, defaultValue: null, length: 80, alias: HyplnkPath, type: esriFieldTypeString )
• hyplnkfile ( modelName: HyplnkFile, nullable: true, editable: true, defaultValue: null, length: 50, alias: HyplnkFile, type: esriFieldTypeString )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 250, alias: Notes, type: esriFieldTypeString )
• createdby ( modelName: CreatedBy, nullable: true, editable: false, defaultValue: null, length: 255, alias: CreatedBy, type: esriFieldTypeString )
• createddt ( modelName: CreatedDt, nullable: true, editable: false, defaultValue: null, length: 29, alias: CreatedDt, type: esriFieldTypeDate )
• lasteditby ( modelName: LastEditBy, nullable: true, editable: false, defaultValue: null, length: 255, alias: LastEditBy, type: esriFieldTypeString )
• lasteditdt ( modelName: LastEditDt, nullable: true, editable: false, defaultValue: null, length: 29, alias: LastEditDt, type: esriFieldTypeDate )
• drawinglink ( modelName: DRAWINGLINK, nullable: true, editable: true, defaultValue: null, length: 255, alias: Drawing Link, type: esriFieldTypeString )
• isaccessible ( modelName: isaccessible, nullable: true, editable: true, defaultValue: null, length: 50, alias: IsAccessible, type: esriFieldTypeString )
• asmntby ( modelName: asmntby, nullable: true, editable: true, defaultValue: null, length: 50, alias: AsmntBy, type: esriFieldTypeString )
• campus_id ( modelName: campus_id, nullable: true, editable: true, defaultValue: null, length: 255, alias: Infrastucture Name, type: esriFieldTypeString )
• basin_id_2 ( modelName: basin_id_2, nullable: true, editable: true, defaultValue: null, alias: Basin_ID_2, type: esriFieldTypeSmallInteger )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: 1899 - 1927
  Description:
  Prototype:
  yrrplcmnt: null
  notes: null
  pipewidth: null
  yrslifecyc: null
  usrefdepth: null
  usfeatid: null
  cstinstall: null
  dtcleaned: null
  hposaccrcy: null
  hyplnkpath: null
  maintainby: null
  basin_id_2: null
  asmntcmnts: null
  pipeshape: null
  hyplnkfile: null
  isenabled: null
  dtassessed: null
  owner: null
  sourceid: null
  pipematrl: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  vposaccrcy: null
  isfunctng: null
  cstrplcmnt: null
  pipehght: null
  dsrefdpth: null
  slope: null
  pipecndn: null
  hascctv: null
  yrinstall: 1913
  campus_id: null
  cndtnissue: null
  isaccessible: null
  dsfeatid: null
  dsinv: null
  asmntby: null
  prjno: null
  assetid: null
  scmid: null
  usinvert: null
  drawinglink: null
  pipetype: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1928 - 1970
  Description:
  Prototype:
  yrrplcmnt: null
  notes: null
  pipewidth: null
  yrslifecyc: null
  usrefdepth: null
  usfeatid: null
  cstinstall: null
  dtcleaned: null
  hposaccrcy: null
  hyplnkpath: null
  maintainby: null
  basin_id_2: null
  asmntcmnts: null
  pipeshape: null
  hyplnkfile: null
  isenabled: null
  dtassessed: null
  owner: null
  sourceid: null
  pipematrl: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  vposaccrcy: null
  isfunctng: null
  cstrplcmnt: null
  pipehght: null
  dsrefdpth: null
  slope: null
  pipecndn: null
  hascctv: null
  yrinstall: 1948.5
  campus_id: null
  cndtnissue: null
  isaccessible: null
  dsfeatid: null
  dsinv: null
  asmntby: null
  prjno: null
  assetid: null
  scmid: null
  usinvert: null
  drawinglink: null
  pipetype: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1971 - 1992
  Description:
  Prototype:
  yrrplcmnt: null
  notes: null
  pipewidth: null
  yrslifecyc: null
  usrefdepth: null
  usfeatid: null
  cstinstall: null
  dtcleaned: null
  hposaccrcy: null
  hyplnkpath: null
  maintainby: null
  basin_id_2: null
  asmntcmnts: null
  pipeshape: null
  hyplnkfile: null
  isenabled: null
  dtassessed: null
  owner: null
  sourceid: null
  pipematrl: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  vposaccrcy: null
  isfunctng: null
  cstrplcmnt: null
  pipehght: null
  dsrefdpth: null
  slope: null
  pipecndn: null
  hascctv: null
  yrinstall: 1981
  campus_id: null
  cndtnissue: null
  isaccessible: null
  dsfeatid: null
  dsinv: null
  asmntby: null
  prjno: null
  assetid: null
  scmid: null
  usinvert: null
  drawinglink: null
  pipetype: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 1993 - 2007
  Description:
  Prototype:
  yrrplcmnt: null
  notes: null
  pipewidth: null
  yrslifecyc: null
  usrefdepth: null
  usfeatid: null
  cstinstall: null
  dtcleaned: null
  hposaccrcy: null
  hyplnkpath: null
  maintainby: null
  basin_id_2: null
  asmntcmnts: null
  pipeshape: null
  hyplnkfile: null
  isenabled: null
  dtassessed: null
  owner: null
  sourceid: null
  pipematrl: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  vposaccrcy: null
  isfunctng: null
  cstrplcmnt: null
  pipehght: null
  dsrefdpth: null
  slope: null
  pipecndn: null
  hascctv: null
  yrinstall: 1999.5
  campus_id: null
  cndtnissue: null
  isaccessible: null
  dsfeatid: null
  dsinv: null
  asmntby: null
  prjno: null
  assetid: null
  scmid: null
  usinvert: null
  drawinglink: null
  pipetype: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: 2008 - 2024
  Description:
  Prototype:
  yrrplcmnt: null
  notes: null
  pipewidth: null
  yrslifecyc: null
  usrefdepth: null
  usfeatid: null
  cstinstall: null
  dtcleaned: null
  hposaccrcy: null
  hyplnkpath: null
  maintainby: null
  basin_id_2: null
  asmntcmnts: null
  pipeshape: null
  hyplnkfile: null
  isenabled: null
  dtassessed: null
  owner: null
  sourceid: null
  pipematrl: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  vposaccrcy: null
  isfunctng: null
  cstrplcmnt: null
  pipehght: null
  dsrefdpth: null
  slope: null
  pipecndn: null
  hascctv: null
  yrinstall: 2015.5
  campus_id: null
  cndtnissue: null
  isaccessible: null
  dsfeatid: null
  dsinv: null
  asmntby: null
  prjno: null
  assetid: null
  scmid: null
  usinvert: null
  drawinglink: null
  pipetype: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: createddt
• Creator Field: createdby
• Edit Date Field: lasteditdt
• Editor Field: lasteditby

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata