Name: Rockford_Pipe

Display Field: LifeCycleStatus

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2582212.79682284
YMin: 2051550.36252493
XMax: 2586040.781949
YMax: 2053211.3323001
Spatial Reference: 102672 (3436)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Subtype","field2":null,"field3":null,"defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[16,0,156,255],"width":1},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[34,0,171,255],"width":1},"value":"1","label":"At Grade","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,158,8,255],"width":1},"value":"2","label":"Below Grade","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,161,118,255],"width":1},"value":"3","label":"Connector","description":""}],"fieldDelimiter":","},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: Subtype

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycleStatus, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Abandoned: Abandoned], [Killed: Killed], ... 4 more ...)
• Material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ACP: Asbestos Cement Pipe (ACP)], [BR: Brick (BR)], [DIP: Ductile Iron (DIP)], ... 12 more ...)
• GroundType (type: esriFieldTypeString, alias: Ground Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Unk: Unknown], [Dirt: Dirt], [Asphalt: Asphalt], ... 6 more ...)
• PipeShape (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Arch: Arch], [Box: Box], [Circular: Circular], ... 6 more ...)
• Slope (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FromCondition (type: esriFieldTypeString, alias: From Condition, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• ToCondition (type: esriFieldTypeString, alias: To Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 3 more ...)
• ConstNum (type: esriFieldTypeString, alias: ConstNum, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• InspectedBy (type: esriFieldTypeString, alias: Inspected By, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• InspectedDate (type: esriFieldTypeDate, alias: Inspected Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ModifiedBy (type: esriFieldTypeString, alias: Modified By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ModifiedDate (type: esriFieldTypeDate, alias: Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Ownership (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Private: Private], [Rockford: Rockford], [LP: Loves Park], ... 9 more ...)
• SharePointLink (type: esriFieldTypeString, alias: SharePointLink, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DataSource (type: esriFieldTypeString, alias: DataSource, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asbuilt: As-Built Drawing], [EngDrawing: Engineering Drawing], [Auto: Auto Generated], ... 7 more ...)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Watershed (type: esriFieldTypeString, alias: Watershed, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [AE: Airport East], [BH: Blackhawk], [FH: Forest Hills], ... 15 more ...)
• YearLined (type: esriFieldTypeString, alias: Year Lined, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• YearTelevised (type: esriFieldTypeString, alias: Year Televised, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Subtype (type: esriFieldTypeSmallInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: At Grade], [2: Below Grade], [3: Connector])
• Perforated (type: esriFieldTypeSmallInteger, alias: Perforated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• UnitID (type: esriFieldTypeString, alias: UpStructureID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitID2 (type: esriFieldTypeString, alias: DownStructureID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MainComp1 (type: esriFieldTypeSmallInteger, alias: MainComp1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MainComp2 (type: esriFieldTypeSmallInteger, alias: MainComp2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CompType (type: esriFieldTypeSmallInteger, alias: CompType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CompKey (type: esriFieldTypeInteger, alias: CompKey, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstDate (type: esriFieldTypeDate, alias: InstDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InstYear (type: esriFieldTypeString, alias: InstYear, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• PipeID (type: esriFieldTypeString, alias: PipeID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Cues_Total_Pipe_Score (type: esriFieldTypeDouble, alias: Cues Total Pipe Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cues_Maximum_Score (type: esriFieldTypeDouble, alias: Cues Maximum Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cues_Mean_Score (type: esriFieldTypeDouble, alias: Cues Mean Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UpInvertElev (type: esriFieldTypeDouble, alias: UpInvertElev, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DwnInvertElev (type: esriFieldTypeDouble, alias: DwnInvertElev, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RecordedLen (type: esriFieldTypeDouble, alias: RecordedLen, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeLen (type: esriFieldTypeDouble, alias: PipeLen, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeHt (type: esriFieldTypeDouble, alias: PipeHt, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeWidth (type: esriFieldTypeDouble, alias: PipeWidth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PipeDiam (type: esriFieldTypeDouble, alias: PipeDiam, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: 4 in.], [5: 5 in.], [6: 6 in.], ... 34 more ...)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: At Grade
Domains:

• Field Name: LifeCycleStatus
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: GroundType
  Inherited
  
• Field Name: PipeShape
  Inherited
  
• Field Name: FromCondition
  Inherited
  
• Field Name: ToCondition
  Inherited
  
• Field Name: Ownership
  Inherited
  
• Field Name: DataSource
  Inherited
  
• Field Name: Watershed
  Inherited
  
• Field Name: Perforated
  Inherited
  
• Field Name: PipeDiam
  Inherited
  
• Field Name: Enabled
  Inherited
  
Templates:

Name: At Grade
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• Subtype: 1

---

ID: 2
Name: Below Grade
Domains:

• Field Name: LifeCycleStatus
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: GroundType
  Inherited
  
• Field Name: PipeShape
  Inherited
  
• Field Name: FromCondition
  Inherited
  
• Field Name: ToCondition
  Inherited
  
• Field Name: Ownership
  Inherited
  
• Field Name: DataSource
  Inherited
  
• Field Name: Watershed
  Inherited
  
• Field Name: Perforated
  Inherited
  
• Field Name: PipeDiam
  Inherited
  
• Field Name: Enabled
  Inherited
  
Templates:

Name: Below Grade
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• Subtype: 2

---

ID: 3
Name: Connector
Domains:

• Field Name: LifeCycleStatus
  Inherited
  
• Field Name: Material
  Inherited
  
• Field Name: GroundType
  Inherited
  
• Field Name: PipeShape
  Inherited
  
• Field Name: FromCondition
  Inherited
  
• Field Name: ToCondition
  Inherited
  
• Field Name: Ownership
  Inherited
  
• Field Name: DataSource
  Inherited
  
• Field Name: Watershed
  Inherited
  
• Field Name: Perforated
  Inherited
  
• Field Name: PipeDiam
  Inherited
  
• Field Name: Enabled
  Inherited
  
Templates:

Name: Connector
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Enabled: 1
• Subtype: 3

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/10/2021 10:26:31 PM

Schema Last Edit Date: 5/10/2021 10:26:31 PM

Data Last Edit Date: 5/10/2021 10:26:31 PM

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