View In:   ArcGIS Online Map Viewer

Name: SWSCMs

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: The Stormwater Control Measures layer is a polygon feature class representing the existing stormwater control measures designed and placed by NCSU to control stormwater runoff.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: true

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: -8763250.8434
YMin: 4262581.293099999
XMax: -8756563.6002
YMax: 4273561.732199997
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [0, 197, 255, 255]
Outline:
Style: esriSLSSolid
Color: [0, 92, 230, 255]
Width: 3
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: 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 )
• join_note ( modelName: join_note, nullable: true, editable: true, defaultValue: null, length: 255, alias: Join Comparrison, type: esriFieldTypeString )
• scmtype ( modelName: SCMType, nullable: true, editable: true, defaultValue: null, length: 30, alias: SCMType, type: esriFieldTypeString , Coded Values: [Bioretention: Bioretention] , [Disconnected Impervious: Disconnected Impervious] , [Dry Detention: Dry Detention] , ...14 more... )
• scmdesc ( modelName: SCMDesc, nullable: true, editable: true, defaultValue: null, length: 100, alias: SCMDesc, type: esriFieldTypeString )
• isaccsble ( modelName: IsAccsble, nullable: true, editable: true, defaultValue: null, length: 20, alias: IsAccsble, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Applicable: Not Applicable] , ...1 more... )
• 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... )
• scmcndn ( modelName: SCMCndn, nullable: true, editable: true, defaultValue: null, length: 30, alias: SCMCndn, 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... )
• areaac ( modelName: AreaAc, nullable: true, editable: true, defaultValue: null, alias: AreaAc, type: esriFieldTypeDouble )
• desvolume ( modelName: DesVolume, nullable: true, editable: true, defaultValue: null, alias: DesVolume, type: esriFieldTypeDouble )
• pcttrtuse ( modelName: PctTrtUse, nullable: true, editable: true, defaultValue: null, alias: PctTrtUse, 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: 120, alias: AsmntCmnts, type: esriFieldTypeString )
• 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 )
• 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 )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 160, 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 )
• 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 )
• regulatory ( modelName: Regulatory, nullable: true, editable: true, defaultValue: null, length: 15, alias: Regulatory, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Green Roof: Green Roof] , ...2 more... )
• aimlink ( modelName: URL, nullable: true, editable: true, defaultValue: null, length: 250, alias: URL, type: esriFieldTypeString )
• priority ( modelName: Priority, nullable: true, editable: true, defaultValue: null, length: 50, alias: Priority, type: esriFieldTypeString )
• drawinglink ( modelName: DRAWINGLINK, nullable: true, editable: true, defaultValue: null, length: 255, alias: Drawing Link, type: esriFieldTypeString )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: SWSCMs
  Description:
  Prototype:
  yrrplcmnt: null
  scmtype: null
  desvolume: null
  yrslifecyc: null
  latitude: null
  regulatory: null
  cstinstall: null
  hyplnkpath: null
  isaccsble: null
  areaac: null
  maintainby: null
  asmntcmnts: null
  scmcndn: null
  hyplnkfile: null
  longitude: null
  dtassessed: null
  owner: null
  sourceid: null
  yrsservice: null
  yrdiscnt: null
  comments: null
  aimlink: null
  scmdesc: null
  isfunctng: null
  cstrplcmnt: null
  priority: null
  join_note: null
  yrinstall: null
  cndtnissue: null
  pcttrtuse: null
  assetid: null
  prjno: null
  drawinglink: null
  datasrc: null
  
  Drawing Tool: esriFeatureEditToolPolygon

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