Name: RALEIGH.PipeIO

Display Field: PHOTONAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: City of Raleigh Stormwater Management Division

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2054052.05766597
YMin: 686559.359685048
XMax: 2156372.36221132
YMax: 808169.515086293
Spatial Reference: 102719 (2264)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[241,181,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FEATURE (type: esriFieldTypeString, alias: FEATURE, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• IOTYPE (type: esriFieldTypeString, alias: IOTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Inlet: Inlet], [Outlet: Outlet], [Abandoned: Abandoned])
• TAG (type: esriFieldTypeString, alias: TAG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CONFIG (type: esriFieldTypeString, alias: CONFIG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Headwall: Headwall], [Wingwall: Wingwall], [Other: Other], ... 3 more ...)
• ACCESSIBILITY (type: esriFieldTypeString, alias: Accessibility, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Accessible: Accessible], [Inaccessible: Inaccessible])
• ACCURACY (type: esriFieldTypeString, alias: ACCURACY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Visual: Visual], [GPS: GPS], [Other: Other], ... 4 more ...)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Functional: Functional], [Needs Service: Needs Service], [Abandoned: Abandoned])
• OBSTRUCTION (type: esriFieldTypeString, alias: Obstruction, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [No (<25%): No (<25%)], [Yes (>25%): Yes (>25%)])
• SCOUR (type: esriFieldTypeString, alias: SCOUR, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• NPDES_OUTFALL (type: esriFieldTypeString, alias: NPDES_Outfall, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• PHOTONAME (type: esriFieldTypeString, alias: PHOTONAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• INV_DATE (type: esriFieldTypeDate, alias: INV_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BASIN_NAME (type: esriFieldTypeString, alias: BASIN_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SSR_TYPE (type: esriFieldTypeString, alias: SSR_Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Maintenance Issue: Maintenance Issue], [Pole Camera: Pole Camera], [Traffic Control: Traffic Control], ... 7 more ...)
• SSR_PROBLEM (type: esriFieldTypeString, alias: SSR_Problem, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sediment obstruction: Sediment obstruction], [Vegetation obstruction: Vegetation obstruction], [Trash obstruction: Trash obstruction], ... 25 more ...)
• SSR_PROBLEM2 (type: esriFieldTypeString, alias: SSR_Problem2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sediment obstruction: Sediment obstruction], [Vegetation obstruction: Vegetation obstruction], [Trash obstruction: Trash obstruction], ... 25 more ...)
• SSR_PROBLEM3 (type: esriFieldTypeString, alias: SSR_Problem3, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Sediment obstruction: Sediment obstruction], [Vegetation obstruction: Vegetation obstruction], [Trash obstruction: Trash obstruction], ... 25 more ...)
• SSR_OBSTRUCTION (type: esriFieldTypeString, alias: SSR_Obstruction, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1-25: 1-25], [26-50: 26-50], [51-75: 51-75], ... 1 more ...)
• SSR_COMMENTS (type: esriFieldTypeString, alias: SSR_COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PHOTO_EXTERIOR (type: esriFieldTypeString, alias: PHOTO_EXTERIOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PHOTO_INTERIOR (type: esriFieldTypeString, alias: PHOTO_INTERIOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DESIGNSTORM (type: esriFieldTypeInteger, alias: DESIGNSTORM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NORTHING (type: esriFieldTypeDouble, alias: NORTHING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EASTING (type: esriFieldTypeDouble, alias: EASTING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_UPDATED (type: esriFieldTypeDate, alias: LAST_UPDATED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EDITOR_COMMENTS (type: esriFieldTypeString, alias: EDITOR_COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATUS (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: AncillaryRole, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Source], [2: Sink])
• BASINABBREVIATION (type: esriFieldTypeString, alias: BASINABBREVIATION, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• UNIQUEID (type: esriFieldTypeString, alias: UNIQUEID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• APPROX_INV_ELEV (type: esriFieldTypeDouble, alias: Approx_Inv_Elev, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SSR_DATE (type: esriFieldTypeDate, alias: SSR_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NPDES_PRIORITY_LEVEL (type: esriFieldTypeString, alias: NPDES_Priority_Level, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Low: Low], [Medium: Medium], [High: High])

Templates:

Name: RALEIGH.PipeIO
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• FEATURE: PipeIO
• ACCESSIBILITY: Accessible
• CONDITION: Functional
• OBSTRUCTION: No (<25%)
• SCOUR: No
• NPDES_OUTFALL: No
• STATUS: 1
• ENABLED: 1
• ANCILLARYROLE: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/20/2020 4:20:36 PM

Schema Last Edit Date: 7/20/2020 4:20:36 PM

Data Last Edit Date: 7/20/2020 4:20:36 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat