Layers:

Layer: Inlets (10)

Name: Inlets

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Stormwater inlets typically found along the side or roads or in drainage swales.

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 7999.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

Supports Datum Transformation: true

Extent:
XMin: 1962729.1202333868
YMin: 778266.1159036458
XMax: 1981020.0475622267
YMax: 807172.1624221504
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Inlet ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• INLETTYPE ( type: esriFieldTypeString, alias: Inlet Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INLETTYPE , Coded Values: [Catchbasin: Catch Basin] , [Combination Inlet: Combination Inlet] , [Curb Inlet: Curb Inlet] , ...15 more... )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• OFFICEDATE ( type: esriFieldTypeDate, alias: OFFICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OFFICEDATE )
• PWID ( type: esriFieldTypeDouble, alias: PWID, editable: true, nullable: true, defaultValue: null, modelName: PWID )
• DEVICEID ( type: esriFieldTypeDouble, alias: DEVICEID, editable: true, nullable: true, defaultValue: null, modelName: DEVICEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTION )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Rim ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: Rim )
• INVINELEV2 ( type: esriFieldTypeDouble, alias: Invert in Elevation 2, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV2 )
• INVINELEV3 ( type: esriFieldTypeDouble, alias: Invert In Elevation 3, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV3 )
• InletStructure ( type: esriFieldTypeString, alias: Inlet Structure, editable: true, nullable: true, length: 30, defaultValue: null, modelName: InletStructure , Coded Values: [Headwall: Headwall] , [Wingwall: Wingwall] , [Bare End: Bare End] , ...14 more... )
• InletStandard ( type: esriFieldTypeString, alias: Inlet Standard, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InletStandard , Coded Values: [JB: JB - NCDOT 840.31 and 840.32] , [JB Traffic: Traffic bearing JB - NCDOT 840.34] , [Manhole Carrboro: Manhole - Carrboro Standard 11] , ...22 more... )
• InletLabel ( type: esriFieldTypeInteger, alias: Inlet Label, editable: true, nullable: true, defaultValue: null, modelName: InletLabel )
• 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 )
Templates:
• Name: Inlets
  Description:
  Prototype:
  InletLabel: null
  FACILITYID: null
  INSTALLDATE: null
  INLETTYPE: null
  INVERTELEV: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  OFFICEDATE: null
  PWID: null
  DEVICEID: null
  INVINELEV: null
  INVOUTELEV: null
  DESCRIPTION: null
  InletStandard: null
  Rim: null
  INVINELEV2: null
  INVINELEV3: null
  InletStructure: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• PW_Stormwater_Inlet (0) -- Related To: Inlet Inspections (110)

Layer: Outlets (20)

Name: Outlets

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 7999.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

Supports Datum Transformation: true

Extent:
XMin: 1961990.14238064
YMin: 771963.4293620586
XMax: 1980980.757286474
YMax: 807006.2296831459
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Outfall ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• AVGDISCH ( type: esriFieldTypeString, alias: Average Discharge, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AVGDISCH )
• DISCHID ( type: esriFieldTypeString, alias: Outfall Label, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DISCHID )
• DISCHRGTYP ( type: esriFieldTypeString, alias: Outfall Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DISCHRGTYP , Coded Values: [Stormwater Outfall: Stormwater Outfall] , [Discharge to Stream: Discharge to Stream] , [Other: Other] , ...2 more... )
• PEAKDISCH ( type: esriFieldTypeString, alias: Peak Discharge, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PEAKDISCH )
• PERMIT ( type: esriFieldTypeString, alias: Permitted?, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PERMIT , Coded Values: [Yes: Yes] , [No: No] )
• PERMITID ( type: esriFieldTypeString, alias: Permit Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PERMITID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• DIAMETER ( type: esriFieldTypeDouble, alias: Pipe Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1-1/4"] , ...22 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• OFFICEDATE ( type: esriFieldTypeDate, alias: OFFICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OFFICEDATE )
• PWID ( type: esriFieldTypeDouble, alias: PWID, editable: true, nullable: true, defaultValue: null, modelName: PWID )
• DEVICEID ( type: esriFieldTypeDouble, alias: DEVICEID, editable: true, nullable: true, defaultValue: null, modelName: DEVICEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTION )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• StreamOrigin ( type: esriFieldTypeString, alias: Stream Origin?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: StreamOrigin , Coded Values: [Yes: Yes] , [No: No] )
• OutfallStructure ( type: esriFieldTypeString, alias: Outfall Structure, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OutfallStructure , Coded Values: [Endwall: Endwall] , [Wingwall: Wingwall] , [Headwall: Headwall] , ...14 more... )
• SCMType ( type: esriFieldTypeString, alias: SCM If Applicable, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCMType , Coded Values: [Armor fill slope: Armor Fill Slope] , [Bioretention area: Bioretention Area] , [Drained farm pond: Drained Farm Pond] , ...22 more... )
• Priority ( type: esriFieldTypeString, alias: Illicit Discharge Priority, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Priority , Coded Values: [Priority: Priority Outfall] , [Major: Major Outfall] , [Major Combined: Major Combined Outfall] , ...1 more... )
• EnergyDissipator ( type: esriFieldTypeString, alias: EnergyDissipator, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EnergyDissipator , Coded Values: [RipRapA: Class A Rip Rap] , [RipRapB: Class B Rip Rap] , [RipRapI: Class I Rip Rap] , ...2 more... )
• 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 )
Templates:
• Name: Outlets
  Description:
  Prototype:
  EnergyDissipator: null
  FACILITYID: null
  AVGDISCH: null
  DISCHID: null
  DISCHRGTYP: null
  PEAKDISCH: null
  PERMIT: null
  PERMITID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  DIAMETER: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  OFFICEDATE: null
  PWID: null
  DEVICEID: null
  INVINELEV: null
  INVOUTELEV: null
  DESCRIPTION: null
  Priority: null
  StreamOrigin: null
  OutfallStructure: null
  SCMType: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• PW_Stormwater_Outlet (1) -- Related To: Outlet Inspections (120)

Layer: Junctions/Manholes (30)

Name: Junctions/Manholes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Manhole features connect two or more pipes and control the flow of water in the network through pipe elevations. Manhole invert elevations are stored on the pipes, instead of the manholes themselves.

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 7999.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

Supports Datum Transformation: true

Extent:
XMin: 1962938.8553782254
YMin: 779028.3479749709
XMax: 1980435.4768809676
YMax: 802797.7171028107
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Junction ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• HIGHELEV ( type: esriFieldTypeDouble, alias: High Pipe Elevation, editable: true, nullable: true, defaultValue: null, modelName: HIGHELEV )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert Elevation 1, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• INVERT ( type: esriFieldTypeDouble, alias: Invert Elevation 2, editable: true, nullable: true, defaultValue: null, modelName: INVERT )
• RIMELEV ( type: esriFieldTypeDouble, alias: Rim Elevation, editable: true, nullable: true, defaultValue: null, modelName: RIMELEV )
• CVTYPE ( type: esriFieldTypeString, alias: Manhole Cover Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CVTYPE , Coded Values: )
• WALLMAT ( type: esriFieldTypeString, alias: Manhole Wall Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WALLMAT , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• MHTYPE ( type: esriFieldTypeString, alias: Manhole Type, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MHTYPE , Coded Values: [Access: Access] , [Inside Drop: Inside Drop] , [PTO: PTO] , ...8 more... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• CUTDEPTH ( type: esriFieldTypeDouble, alias: Manhole Pavement Cut Depth, editable: true, nullable: true, defaultValue: null, modelName: CUTDEPTH )
• LINED ( type: esriFieldTypeString, alias: Lined, editable: true, nullable: true, length: 3, defaultValue: null, modelName: LINED , Coded Values: [Yes: Yes] , [No: No] )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• PWID ( type: esriFieldTypeDouble, alias: PWID, editable: true, nullable: true, defaultValue: null, modelName: PWID )
• DEVICEID ( type: esriFieldTypeDouble, alias: DEVICEID, editable: true, nullable: true, defaultValue: null, modelName: DEVICEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• DESCRIPTION ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DESCRIPTION )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PWLabel ( type: esriFieldTypeInteger, alias: PW Label, editable: true, nullable: true, defaultValue: null, modelName: PWLabel )
• Standard ( type: esriFieldTypeString, alias: Standard, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Standard , Coded Values: [JB: JB - NCDOT 840.31 and 840.32] , [JB Traffic: Traffic bearing JB - NCDOT 840.34] , [Manhole Carrboro: Manhole - Carrboro Standard 11] , ...22 more... )
• JunctionType ( type: esriFieldTypeString, alias: Junction Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: JunctionType , Coded Values: [Junction: Junction] , [Junction Box w/ Manhole: Junction Box with Manhole] , [Virtual Junction: Virtual Junction] , ...5 more... )
• 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 )
Templates:
• Name: Junctions/Manholes
  Description:
  Prototype:
  JunctionType: null
  FACILITYID: null
  INSTALLDATE: null
  HIGHELEV: null
  INVERTELEV: null
  INVERT: null
  RIMELEV: null
  CVTYPE: null
  WALLMAT: null
  MHTYPE: null
  LOCDESC: null
  CUTDEPTH: null
  LINED: null
  GPSDATE: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  PWID: null
  DEVICEID: null
  INVINELEV: null
  INVOUTELEV: null
  DESCRIPTION: null
  Standard: null
  PWLabel: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• PW_Stormwater_JunctionManhole (2) -- Related To: Junction/Manhole Inspections (130)

Layer: Clean Outs (40)

Name: Clean Outs

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.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

Supports Datum Transformation: true

Extent:
XMin: 1962977.5652745515
YMin: 785854.2601761371
XMax: 1978805.945691213
YMax: 792066.4131061435
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Cleanout ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ACCESSDIAM ( type: esriFieldTypeDouble, alias: Access Diameter, editable: true, nullable: true, defaultValue: 24, modelName: ACCESSDIAM , Range: [0, 72] )
• ACCESSMAT ( type: esriFieldTypeString, alias: Access Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ACCESSMAT , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• ACCESSTYPE ( type: esriFieldTypeString, alias: Access Type, editable: true, nullable: true, length: 20, defaultValue: Cover, modelName: ACCESSTYPE , Coded Values: [Door: Door] , [Grate: Grate] , [Cover: Cover] , ...3 more... )
• INTDEPTH ( type: esriFieldTypeDouble, alias: Interior Depth, editable: true, nullable: true, defaultValue: null, modelName: INTDEPTH )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• DEVICETYPE ( type: esriFieldTypeString, alias: Cleanout Type, editable: true, nullable: true, length: 30, defaultValue: Cleanout, modelName: DEVICETYPE , Coded Values: [Cleanout: Cleanout] , [Flushing Structure: Flushing Structure] , [Lamp Hole: Lamp Hole] , ...2 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Dodd: Randy Dodd] , [Cochran: Emily Cochran] , [Crane: Evan Crane] , ...1 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Clean Outs
  Description:
  Prototype:
  LASTEDITOR: null
  FACILITYID: null
  ACCESSDIAM: 24
  ACCESSMAT: null
  ACCESSTYPE: Cover
  INTDEPTH: null
  INSTALLDATE: null
  DEVICETYPE: Cleanout
  ROTATION: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  
  Drawing Tool: esriFeatureEditToolPoint

Layer: Pipes (50)

Name: Pipes

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 19000.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

Supports Datum Transformation: true

Extent:
XMin: 1962729.1202333868
YMin: 775648.00007689
XMax: 1980984.4121347964
YMax: 807172.1624221504
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 230, 169, 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: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Pipe ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1-1/4"] , ...22 more... )
• MAINSHAPE ( type: esriFieldTypeString, alias: Pipe Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Rectangular: Rectangular] , ...3 more... )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINEDYEAR )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LINERTYPE , Coded Values: [Cured in Place: Cured in Place] , [Fold and Form: Fold and Form or Deform/Reform] , [Segmanted Panel: Segmented Panel] , ...5 more... )
• FROMMH ( type: esriFieldTypeString, alias: From Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: FROMMH )
• TOMH ( type: esriFieldTypeString, alias: To Manhole, editable: true, nullable: true, length: 11, defaultValue: null, modelName: TOMH )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• OFFICEDATE ( type: esriFieldTypeDate, alias: OFFICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OFFICEDATE )
• LINEID ( type: esriFieldTypeDouble, alias: LINEID, editable: true, nullable: true, defaultValue: null, modelName: LINEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Length ( type: esriFieldTypeDouble, alias: As-Built Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• PipedStream ( type: esriFieldTypeString, alias: Piped Stream?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PipedStream , Coded Values: [Yes: Yes] , [No: No] )
• PipeLiner ( type: esriFieldTypeString, alias: Pipe Liner?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PipeLiner , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• OPRI_Class ( type: esriFieldTypeSmallInteger, alias: OPRI Class, editable: true, nullable: true, defaultValue: null, modelName: OPRI_Class , Coded Values: [1: 1 - very good condition] , [2: 2 - good condition] , [3: 3 - monitor / schedule rehab] , ...3 more... )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength() )
Templates:
• Name: Pipes
  Description:
  Prototype:
  InspectionDate: null
  FACILITYID: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  LINEDYEAR: null
  LINERTYPE: null
  FROMMH: null
  TOMH: null
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  SLOPE: null
  OFFICEDATE: null
  LINEID: null
  INVINELEV: null
  INVOUTELEV: null
  COMMENT: null
  OPRI_Class: null
  Length: null
  PipedStream: null
  PipeLiner: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• PW_Stormwater_Pipe (3) -- Related To: Pipe Inspections (140)

Layer: Open Channels (60)

Name: Open Channels

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 14999.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

Supports Datum Transformation: true

Extent:
XMin: 1966912.298546806
YMin: 782846.9738678932
XMax: 1980358.9274933934
YMax: 807133.8832992315
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 169, 230, 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: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Channel ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• TOPWIDTH ( type: esriFieldTypeDouble, alias: Top Width, editable: true, nullable: true, defaultValue: null, modelName: TOPWIDTH )
• BOTWIDTH ( type: esriFieldTypeDouble, alias: Bottom Width, editable: true, nullable: true, defaultValue: null, modelName: BOTWIDTH )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• LEFTSLOPE ( type: esriFieldTypeDouble, alias: Left Slope, editable: true, nullable: true, defaultValue: null, modelName: LEFTSLOPE )
• RIGHTSLOPE ( type: esriFieldTypeDouble, alias: Right Slope, editable: true, nullable: true, defaultValue: null, modelName: RIGHTSLOPE )
• UPTOP ( type: esriFieldTypeDouble, alias: Upstream Top, editable: true, nullable: true, defaultValue: null, modelName: UPTOP )
• DWNTOP ( type: esriFieldTypeDouble, alias: Downstream Top, editable: true, nullable: true, defaultValue: null, modelName: DWNTOP )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• LINEID ( type: esriFieldTypeDouble, alias: LINEID, editable: true, nullable: true, defaultValue: null, modelName: LINEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• StreamChannel ( type: esriFieldTypeString, alias: Stream Channel?, editable: true, nullable: true, length: 3, defaultValue: No, modelName: StreamChannel , Coded Values: [Yes: Yes] , [No: No] )
• DrainageType ( type: esriFieldTypeString, alias: Channel Type, editable: true, nullable: true, length: 20, defaultValue: Ditch, modelName: DrainageType , Coded Values: [Swale: Swale] , [Ditch: Ditch] , [Riprap Channel: Riprap Channel] , ...5 more... )
• ChannelShape ( type: esriFieldTypeString, alias: ChannelShape, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ChannelShape , Coded Values: [Triangle: Triangular] , [Trapezoid: Trapezoid] , [Parabola: Parabolic] , ...2 more... )
• ChannelLiner ( type: esriFieldTypeString, alias: Channel Material, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ChannelLiner , Coded Values: [Paved: Paved] , [Other: Other] , [Unknown: Unknown] , ...2 more... )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: Open Channels
  Description:
  Prototype:
  ChannelShape: null
  FACILITYID: null
  INSTALLDATE: null
  TOPWIDTH: null
  BOTWIDTH: null
  DEPTH: null
  LEFTSLOPE: null
  RIGHTSLOPE: null
  UPTOP: null
  DWNTOP: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  LINEID: null
  INVINELEV: null
  INVOUTELEV: null
  COMMENT: null
  ChannelLiner: null
  StreamChannel: No
  DrainageType: Ditch
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• PW_Stormwater_OpenChannel (4) -- Related To: Ditch Inspections (150)

Layer: Culverts (70)

Name: Culverts

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2500.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

Supports Datum Transformation: true

Extent:
XMin: 1966967.4063762128
YMin: 779662.1344370544
XMax: 1979676.1667198092
YMax: 807077.7820334733
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [205, 137, 102, 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: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Culvert ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1-1/4"] , ...22 more... )
• MAINSHAPE ( type: esriFieldTypeString, alias: Culvert Shape, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSHAPE , Coded Values: [Circular: Circular] , [Horseshoe: Horseshoe] , [Rectangular: Rectangular] , ...3 more... )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• OFFICEDATE ( type: esriFieldTypeDate, alias: OFFICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OFFICEDATE )
• LINEID ( type: esriFieldTypeDouble, alias: LINEID, editable: true, nullable: true, defaultValue: null, modelName: LINEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Invert Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AsBuiltLength ( type: esriFieldTypeDouble, alias: As-Built Length, editable: true, nullable: true, defaultValue: null, modelName: AsBuiltLength )
• PipedStream ( type: esriFieldTypeString, alias: Piped Stream?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: PipedStream , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: Culverts
  Description:
  Prototype:
  AsBuiltLength: null
  FACILITYID: null
  INSTALLDATE: null
  MATERIAL: null
  DIAMETER: null
  MAINSHAPE: null
  OWNEDBY: 1
  MAINTBY: 1
  SUMFLOW: null
  LASTUPDATE: null
  LASTEDITOR: null
  DOWNELEV: null
  UPELEV: null
  OFFICEDATE: null
  LINEID: null
  INVINELEV: null
  INVOUTELEV: null
  COMMENT: null
  PipedStream: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• PW_Stormwater_Culvert (5) -- Related To: Culvert Inspections (160)

Layer: Curb and Gutter (80)

Name: Curb and Gutter

Display Field: Name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 19000.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

Supports Datum Transformation: true

Extent:
XMin: 1968033.7903982997
YMin: 778735.3177211434
XMax: 1981057.1419762224
YMax: 807161.193612054
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [197, 0, 255, 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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• StreetID ( type: esriFieldTypeSmallInteger, alias: StreetID, editable: true, nullable: true, defaultValue: null, modelName: StreetID )
• DirPrefix ( type: esriFieldTypeString, alias: DirPrefix, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DirPrefix )
• Name ( type: esriFieldTypeString, alias: Name, editable: true, nullable: true, length: 32, defaultValue: null, modelName: Name )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Type )
• DirSuffix ( type: esriFieldTypeString, alias: DirSuffix, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DirSuffix )
• FullName ( type: esriFieldTypeString, alias: FullName, editable: true, nullable: true, length: 36, defaultValue: null, modelName: FullName )
• LeftFrom ( type: esriFieldTypeSmallInteger, alias: LeftFrom, editable: true, nullable: true, defaultValue: null, modelName: LeftFrom )
• LeftTo ( type: esriFieldTypeSmallInteger, alias: LeftTo, editable: true, nullable: true, defaultValue: null, modelName: LeftTo )
• RightFrom ( type: esriFieldTypeSmallInteger, alias: RightFrom, editable: true, nullable: true, defaultValue: null, modelName: RightFrom )
• RightTo ( type: esriFieldTypeSmallInteger, alias: RightTo, editable: true, nullable: true, defaultValue: null, modelName: RightTo )
• LeftZip ( type: esriFieldTypeString, alias: LeftZip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LeftZip )
• RightZip ( type: esriFieldTypeString, alias: RightZip, editable: true, nullable: true, length: 5, defaultValue: null, modelName: RightZip )
• LeftMailCity ( type: esriFieldTypeString, alias: LeftMailCity, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LeftMailCity )
• RightMailCity ( type: esriFieldTypeString, alias: RightMailCity, editable: true, nullable: true, length: 12, defaultValue: null, modelName: RightMailCity )
• Jurisdiction_R ( type: esriFieldTypeString, alias: Jurisdiction_R, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Jurisdiction_R )
• Jurisdiction_L ( type: esriFieldTypeString, alias: Jurisdiction_L, editable: true, nullable: true, length: 2, defaultValue: null, modelName: Jurisdiction_L )
• SegmentID ( type: esriFieldTypeInteger, alias: SegmentID, editable: true, nullable: true, defaultValue: null, modelName: SegmentID )
• Maint ( type: esriFieldTypeString, alias: Maint, editable: true, nullable: true, length: 12, defaultValue: null, modelName: Maint )
• Surface ( type: esriFieldTypeString, alias: Surface, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Surface )
• RightSpeed ( type: esriFieldTypeSmallInteger, alias: RightSpeed, editable: true, nullable: true, defaultValue: null, modelName: RightSpeed )
• LeftSpeed ( type: esriFieldTypeSmallInteger, alias: LeftSpeed, editable: true, nullable: true, defaultValue: null, modelName: LeftSpeed )
• Direction ( type: esriFieldTypeSmallInteger, alias: Direction, editable: true, nullable: true, defaultValue: null, modelName: Direction )
• Class ( type: esriFieldTypeString, alias: Class, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Class )
• Curb ( type: esriFieldTypeString, alias: Curb, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Curb )
• Width ( type: esriFieldTypeSmallInteger, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: Width )
• Miles ( type: esriFieldTypeDouble, alias: Miles, editable: true, nullable: true, defaultValue: null, modelName: Miles )
• Cross1 ( type: esriFieldTypeString, alias: Cross1, editable: true, nullable: true, length: 36, defaultValue: null, modelName: Cross1 )
• Cross12 ( type: esriFieldTypeString, alias: Cross12, editable: true, nullable: true, length: 36, defaultValue: null, modelName: Cross12 )
• Cross2 ( type: esriFieldTypeString, alias: Cross2, editable: true, nullable: true, length: 36, defaultValue: null, modelName: Cross2 )
• Cross22 ( type: esriFieldTypeString, alias: Cross22, editable: true, nullable: true, length: 36, defaultValue: null, modelName: Cross22 )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 54, defaultValue: null, modelName: Comments )
• Symbology ( type: esriFieldTypeString, alias: Symbology, editable: true, nullable: true, length: 18, defaultValue: null, modelName: Symbology )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• GutterType ( type: esriFieldTypeString, alias: Gutter Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GutterType , Coded Values: [Curb: Curb] , [Island: Island] , [Shoulder: Shoulder Berm] , ...4 more... )
• INVINELEV ( type: esriFieldTypeDouble, alias: In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: Out Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: null, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• TransportationImpact ( type: esriFieldTypeString, alias: TransportationImpact, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TransportationImpact , Coded Values: [Low: Low] , [High: High] , [Lowest: Lowest] , ...2 more... )
• CensusPriority ( type: esriFieldTypeSmallInteger, alias: Census Block Priority, editable: true, nullable: true, defaultValue: null, modelName: CensusPriority )
• GutterOutfall ( type: esriFieldTypeString, alias: GutterOutfall, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GutterOutfall , Coded Values: [Pipe: Pipe] , [Ditch: Ditch] , [Gutter: Gutter] , ...2 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength() )
Templates:
• Name: Curb and Gutter
  Description:
  Prototype:
  GutterOutfall: null
  StreetID: null
  DirPrefix: null
  Name: null
  Type: null
  DirSuffix: null
  FullName: null
  LeftFrom: null
  LeftTo: null
  RightFrom: null
  RightTo: null
  LeftZip: null
  RightZip: null
  LeftMailCity: null
  RightMailCity: null
  Jurisdiction_R: null
  Jurisdiction_L: null
  SegmentID: null
  Maint: null
  Surface: null
  RightSpeed: null
  LeftSpeed: null
  Direction: null
  Class: null
  Curb: null
  Width: null
  Miles: null
  Cross1: null
  Cross12: null
  Cross2: null
  Cross22: null
  Comments: null
  Symbology: null
  FACILITYID: null
  GutterType: null
  INVINELEV: null
  INVOUTELEV: null
  OWNEDBY: null
  MAINTBY: null
  COMMENT: null
  LASTUPDATE: null
  LASTEDITOR: null
  TransportationImpact: null
  CensusPriority: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• PW_Stormwater_CurbGutter (6) -- Related To: Curb and Gutter Inspections (170)

Layer: SCMs (90)

Name: SCMs

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 14999.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

Supports Datum Transformation: true

Extent:
XMin: 1961975.5000214726
YMin: 771949.749927476
XMax: 1980047.3733264655
YMax: 807016.4908174723
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [190, 255, 232, 255]
Outline:
Style: esriSLSSolid
Color: [0, 230, 169, 255]
Width: 0
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: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: SCM ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• LENGTH ( type: esriFieldTypeDouble, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• WIDTH ( type: esriFieldTypeDouble, alias: Width, editable: true, nullable: true, defaultValue: null, modelName: WIDTH )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• SIDESLOPE ( type: esriFieldTypeDouble, alias: Side Slope, editable: true, nullable: true, defaultValue: null, modelName: SIDESLOPE )
• VOLUME ( type: esriFieldTypeDouble, alias: Volume, editable: true, nullable: true, defaultValue: null, modelName: VOLUME )
• BEDMATERIAL ( type: esriFieldTypeString, alias: Bed Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BEDMATERIAL , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• BNKMATERIAL ( type: esriFieldTypeString, alias: Bank Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BNKMATERIAL , Coded Values: [ABS: ABS Plastic] , [BR: Brick] , [CP: Concrete (Non-Reinforced)] , ...9 more... )
• INVERTELEV ( type: esriFieldTypeDouble, alias: Invert In Elevation, editable: true, nullable: true, defaultValue: null, modelName: INVERTELEV )
• OUTFLWELEV ( type: esriFieldTypeDouble, alias: Outflow Elevation, editable: true, nullable: true, defaultValue: null, modelName: OUTFLWELEV )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Carrboro] , [2: State] , [-1: Private] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR , Coded Values: [Not Functioning: Present Not Functioning] , [Disconnected: Disconnected] , [Category Change: Category Change (Different Feature Type)] , ...2 more... )
• BMPID ( type: esriFieldTypeString, alias: BMPID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BMPID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• DetentionType ( type: esriFieldTypeString, alias: SCM Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DetentionType , Coded Values: [Armor fill slope: Armor Fill Slope] , [Bioretention area: Bioretention Area] , [Drained farm pond: Drained Farm Pond] , ...22 more... )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• AreaSF ( type: esriFieldTypeDouble, alias: Area Sq Ft, editable: true, nullable: true, defaultValue: null, modelName: AreaSF )
• MediaElev ( type: esriFieldTypeDouble, alias: SCM Elevation, editable: true, nullable: true, defaultValue: null, modelName: MediaElev )
• WeirElev ( type: esriFieldTypeDouble, alias: Weir Elevation, editable: true, nullable: true, defaultValue: null, modelName: WeirElev )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Condition , Coded Values: [Excellent: Excellent] , [Good: Good] , [Fair: Fair] , ...3 more... )
• Permitted ( type: esriFieldTypeString, alias: Permitted?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Permitted , Coded Values: [Yes: Yes] , [No: No] )
• TownRegulated ( type: esriFieldTypeString, alias: Town Regulated?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: TownRegulated , Coded Values: [Yes: Yes] , [No: No] )
• 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 )
• Shape__Area ( type: esriFieldTypeDouble, alias: SHAPE.STArea(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STArea() )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength() )
Templates:
• Name: SCMs
  Description:
  Prototype:
  Permitted: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  LENGTH: null
  WIDTH: null
  DEPTH: null
  SIDESLOPE: null
  VOLUME: null
  BEDMATERIAL: null
  BNKMATERIAL: null
  INVERTELEV: null
  OUTFLWELEV: null
  OWNEDBY: 1
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  BMPID: null
  TownRegulated: null
  DetentionType: null
  COMMENT: null
  AreaSF: null
  MediaElev: null
  WeirElev: null
  Condition: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• PW_Stormwater_SCM (7) -- Related To: SCM Inspections (180)

Layer: Virtual Drainage to Stream (100)

Name: Virtual Drainage to Stream

Display Field: LASTEDITOR

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 15000.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

Supports Datum Transformation: true

Extent:
XMin: 1967914.8441138864
YMin: 771963.4293620586
XMax: 1981020.0475622267
YMax: 806810.0079627335
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [255, 150, 0, 255]
Width: 0
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: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• OFFICEDATE ( type: esriFieldTypeDate, alias: OFFICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OFFICEDATE )
• LINEID ( type: esriFieldTypeDouble, alias: LINEID, editable: true, nullable: true, defaultValue: null, modelName: LINEID )
• INVINELEV ( type: esriFieldTypeDouble, alias: INVINELEV, editable: true, nullable: true, defaultValue: null, modelName: INVINELEV )
• INVOUTELEV ( type: esriFieldTypeDouble, alias: INVOUTELEV, editable: true, nullable: true, defaultValue: null, modelName: INVOUTELEV )
• COMMENT ( type: esriFieldTypeString, alias: COMMENT, editable: true, nullable: true, length: 250, defaultValue: null, modelName: COMMENT )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength() )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
Templates:
• Name: Virtual Drainage to Stream
  Description:
  Prototype:
  LASTUPDATE: null
  OFFICEDATE: null
  LINEID: null
  INVINELEV: null
  INVOUTELEV: null
  COMMENT: null
  LASTEDITOR: null
  FacilityID: null
  
  Drawing Tool: esriFeatureEditToolLine

Tables:

Table: Inlet Inspections (110)

Name: Inlet Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspectType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspectType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspTypeCamera ( type: esriFieldTypeString, alias: InspTypeCamera, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspTypeCamera , Coded Values: [CCTV: CCTV] , [Pole: Pole] , [Visual: Visual] , ...1 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• Blocked50Pct ( type: esriFieldTypeString, alias: Blocked50PctOrMore, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Blocked50Pct , Coded Values: [Yes: Yes] , [No: No] )
• ErosionThreshold ( type: esriFieldTypeString, alias: ErosionGT6inWithin1ftOfInlet, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ErosionThreshold , Coded Values: [Yes: Yes] , [No: No] )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: No Damage, Like New] , [2: Minimal Damage, Small Chips and Some Weathering] , [3: Some Damage (e.g., Concrete Mortar and Cracking)] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Inlet Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspYear: null
  InspDate: null
  InspBy: null
  Inspector: null
  InspectType: null
  InspTypeCamera: null
  InspRef: null
  Blocked50Pct: null
  ErosionThreshold: null
  Condition: null
  MaintRequired: null
  Notes: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swInlet (0) -- Related To: Inlets (10)

Table: Outlet Inspections (120)

Name: Outlet Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• ScourDepthFt ( type: esriFieldTypeDouble, alias: ScourDepthFt, editable: true, nullable: true, defaultValue: null, modelName: ScourDepthFt )
• ScourLengthFt ( type: esriFieldTypeDouble, alias: ScoutLengthFt, editable: true, nullable: true, defaultValue: null, modelName: ScourLengthFt )
• ScourWidthFt ( type: esriFieldTypeDouble, alias: ScourWidthFt, editable: true, nullable: true, defaultValue: null, modelName: ScourWidthFt )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• Dissipator ( type: esriFieldTypeString, alias: EnergyDissipator, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Dissipator , Coded Values: [RipRapA: Class A Rip Rap] , [RipRapB: Class B Rip Rap] , [RipRapI: Class I Rip Rap] , ...2 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: No Scour] , [2: Minimal Scour (0-6" Depth)] , [3: Some Scour (6-12" Depth)] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Outlet Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  ScourDepthFt: null
  ScourLengthFt: null
  ScourWidthFt: null
  Notes: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  Dissipator: null
  Condition: null
  MaintRequired: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swDischargePoint (1) -- Related To: Outlets (20)

Table: Junction/Manhole Inspections (130)

Name: Junction/Manhole Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspectDate ( type: esriFieldTypeDate, alias: Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectDate )
• InspectYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspectYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• ConditionStructure ( type: esriFieldTypeString, alias: StructuralCondition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ConditionStructure , Coded Values: [Crack: Crack] , [Hole: Hole] , [Deformed: Deformed] , ...4 more... )
• Defects ( type: esriFieldTypeString, alias: ConditionDefects, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Defects , Coded Values: [Deposits: Deposits] , [Roots: Roots] , [Obstruction: Obstruction] , ...3 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Junction/Manhole Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspectDate: null
  InspectYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  Condition: null
  MaintRequired: null
  Notes: null
  ConditionStructure: null
  Defects: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swManhole (2) -- Related To: Junctions/Manholes (30)

Table: Pipe Inspections (140)

Name: Pipe Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• StructureCondition ( type: esriFieldTypeString, alias: StructuralCondition, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StructureCondition , Coded Values: [Crack: Crack] , [Hole: Hole] , [Deformed: Deformed] , ...4 more... )
• Defects ( type: esriFieldTypeString, alias: Defects, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Defects , Coded Values: [Deposits: Deposits] , [Roots: Roots] , [Obstruction: Obstruction] , ...3 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Pipe Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  Notes: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  StructureCondition: null
  Defects: null
  Condition: null
  MaintRequired: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swGravityMain (3) -- Related To: Pipes (50)

Table: Ditch Inspections (150)

Name: Ditch Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [Other: Other] , ...1 more... )
• BlockedGT50Pct_Ft ( type: esriFieldTypeInteger, alias: Length(Ft)BlockedGT50Pct, editable: true, nullable: true, defaultValue: null, modelName: BlockedGT50Pct_Ft )
• LengthErodedGT1Ft ( type: esriFieldTypeInteger, alias: Length(Ft)ErodedGT1Ft, editable: true, nullable: true, defaultValue: null, modelName: LengthErodedGT1Ft )
• DrivePipes ( type: esriFieldTypeSmallInteger, alias: NumberDrivePipes, editable: true, nullable: true, defaultValue: null, modelName: DrivePipes )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: No Blockage or Erosion] , [2: Minimal Blockage or 0-6" Erosion] , [3: > 25% Blocked or 6-12" Erosion] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Ditch Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  BlockedGT50Pct_Ft: null
  LengthErodedGT1Ft: null
  DrivePipes: null
  Condition: null
  MaintRequired: null
  Notes: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swOpenDrain (4) -- Related To: Open Channels (60)

Table: Culvert Inspections (160)

Name: Culvert Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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 )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: PW.Stormwater.InspectRef, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef )
• ApproachRoad ( type: esriFieldTypeSmallInteger, alias: ApproachRoadwayCondition, editable: true, nullable: true, defaultValue: null, modelName: ApproachRoad , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Embankment ( type: esriFieldTypeSmallInteger, alias: EmbankmentCondition, editable: true, nullable: true, defaultValue: null, modelName: Embankment , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Channel ( type: esriFieldTypeSmallInteger, alias: ChannelCondition, editable: true, nullable: true, defaultValue: null, modelName: Channel , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• EndTreatment ( type: esriFieldTypeSmallInteger, alias: EndTreatmentCondition, editable: true, nullable: true, defaultValue: null, modelName: EndTreatment , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Footing ( type: esriFieldTypeSmallInteger, alias: ConcreteSlabFootingCondition, editable: true, nullable: true, defaultValue: null, modelName: Footing , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• Barrel ( type: esriFieldTypeSmallInteger, alias: BarrelAlignmentCondition, editable: true, nullable: true, defaultValue: null, modelName: Barrel , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• AquaticOrganism ( type: esriFieldTypeSmallInteger, alias: AquaticOrganismPassage, editable: true, nullable: true, defaultValue: null, modelName: AquaticOrganism , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• CulvertRating ( type: esriFieldTypeSmallInteger, alias: CulvertRating, editable: true, nullable: true, defaultValue: null, modelName: CulvertRating , Coded Values: [1: 1 or fewer indicators fair and no indicators poor or failing] , [2: 3 or fewer indicators fair and no indicators poor or failing] , [3: 4 or fewer indicators fair amd 1 or fewer indicators poor, no indicators failing] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Culvert Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  ApproachRoad: null
  Embankment: null
  Channel: null
  EndTreatment: null
  Footing: null
  Barrel: null
  AquaticOrganism: null
  CulvertRating: null
  MaintRequired: null
  Notes: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swCulvert (5) -- Related To: Culverts (70)

Table: Curb and Gutter Inspections (170)

Name: Curb and Gutter Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• ObstructedFt ( type: esriFieldTypeInteger, alias: LengthObstructedFt, editable: true, nullable: true, defaultValue: null, modelName: ObstructedFt )
• DamagedFt ( type: esriFieldTypeInteger, alias: LengthDamagedFt, editable: true, nullable: true, defaultValue: null, modelName: DamagedFt )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: PW.Stormwater.InspectBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 15, defaultValue: null, modelName: InspRef , Coded Values: [AASHTO: AASHTO] , [NCDOT: NCDOT MCAP] , [NASSCO PACP: NASSCO PACP] , ...2 more... )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: No Damage, Like New] , [2: Minimal Damage, Small Chips and Some Weathering] , [3: Some Damage (e.g., Concrete Mortar and Cracking)] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: Curb and Gutter Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  ObstructedFt: null
  DamagedFt: null
  Notes: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  Condition: null
  MaintRequired: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swCurbGutter (6) -- Related To: Curb and Gutter (80)

Table: SCM Inspections (180)

Name: SCM Inspections

Display Field: FacilityID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: bdf53e5f3fd1452088fc140870ba4d4a

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• ReviewFlag ( type: esriFieldTypeSmallInteger, alias: ReviewFlag, editable: true, nullable: true, defaultValue: null, modelName: ReviewFlag , Coded Values: [1: True] , [0: False] )
• InspDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspDate )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• InspYear ( type: esriFieldTypeString, alias: InspectionYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: InspYear , Coded Values: [2022: 2022] , [2023: 2023] , [2024: 2024] , ...6 more... )
• InspBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: InspBy , Coded Values: [TOC: TOC Staff] , [Sungate: Sungate] , [Contractor: Contractor] , ...1 more... )
• Inspector ( type: esriFieldTypeString, alias: LeadInspector, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Inspector , Coded Values: [RD: Randy Dodd] , [HH: Heather Holley] , [DS: Deborah Shoffner] , ...9 more... )
• InspType ( type: esriFieldTypeString, alias: InspectionType, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InspType , Coded Values: [Initial: Initial] , [Routine: Routine] , [Special: Special] , ...2 more... )
• InspRef ( type: esriFieldTypeString, alias: InspectionReference, editable: true, nullable: true, length: 5, defaultValue: null, modelName: InspRef , Coded Values: )
• Condition ( type: esriFieldTypeSmallInteger, alias: ConditionRating, editable: true, nullable: true, defaultValue: null, modelName: Condition , Coded Values: [1: Very Good] , [2: Good] , [3: Fair] , ...2 more... )
• MaintRequired ( type: esriFieldTypeSmallInteger, alias: MaintenancePriority, editable: true, nullable: true, defaultValue: null, modelName: MaintRequired , Coded Values: [1: None Required] , [2: Maintenance Required for Debris] , [4: Both Maintenance and Repair Required] , ...2 more... )
• NextAction ( type: esriFieldTypeString, alias: DoNext, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NextAction , Coded Values: [Inspect: Inspect] , [Reinspect: Reinspect] , [Clean: Clean] , ...6 more... )
• RelateID ( type: esriFieldTypeGUID, alias: RelateID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: RelateID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
Templates:
• Name: SCM Inspections
  Description:
  Prototype:
  RelateID: null
  FacilityID: null
  ReviewFlag: null
  InspDate: null
  Notes: null
  InspYear: null
  InspBy: null
  Inspector: null
  InspType: null
  InspRef: null
  Condition: null
  MaintRequired: null
  NextAction: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• swDetention (7) -- Related To: SCMs (90)