Name: jsa_sewer_pipe

Display Field: Subtype_Code

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: jsa_sewer_pipe

Copyright Text:

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: 768555.994176645
YMin: 1888492.81402817
XMax: 839265.359193495
YMax: 1932833.41403856
Spatial Reference: 103056 (6475)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"Subtype_Code","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":1.5},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[204,252,250,255],"width":1},"value":"1","label":"Sanitary Pipe"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[242,184,252,255],"width":1},"value":"2","label":"Combined Pipe"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[252,200,189,255],"width":1},"value":"3","label":"Force Main Pipe"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[197,252,244,255],"toColor":[197,252,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,252,255],"toColor":[252,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,203,182,255],"toColor":[252,203,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[236,252,182,255],"toColor":[236,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,210,252,255],"toColor":[179,210,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,240,255],"toColor":[252,215,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,201,255],"toColor":[187,252,201,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[196,179,252,255],"toColor":[196,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,245,210,255],"toColor":[252,245,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,233,252,255],"toColor":[210,233,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,219,255],"toColor":[252,182,219,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,197,252,255],"toColor":[233,197,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,193,255],"toColor":[252,187,193,255]}]}}},"scaleSymbols":true,"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:

Type ID Field: Subtype_Code

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Subtype_Code (type: esriFieldTypeInteger, alias: Subtype_Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Full_ID (type: esriFieldTypeString, alias: Alt Pipe ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Element_Type (type: esriFieldTypeString, alias: Element_Type, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Sewer_Type (type: esriFieldTypeString, alias: Sewer_Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ABND: Abandoned], [CMBN: Combined], [FRCM: Force Main], ... 1 more ...)
• Pipe_Type (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [CMP: Corrugated Metal Pipe], [PVC: Polyvinyl Chloride], [RCP: Reinforced Concrete Pipe], ... 11 more ...)
• Pipe_Status (type: esriFieldTypeString, alias: Pipe_Status, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ABND: Abandoned], [ACTV: Active])
• Pipe_Shape (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [CIRC: Circular], [ELIP: Elliptical], [RECT: Rectangular], ... 1 more ...)
• Width_Diameter (type: esriFieldTypeDouble, alias: Width_Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pipe_Length (type: esriFieldTypeDouble, alias: Length (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_Constructed (type: esriFieldTypeDate, alias: Date Constructed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date_Status_Update (type: esriFieldTypeDate, alias: Date_Status_Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Upstrm_Invert (type: esriFieldTypeDouble, alias: Upstream Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Downstrm_Invert (type: esriFieldTypeDouble, alias: DS Invert, SQL Type: sqlTypeOther, nullable: true, editable: true)
• US_Full_ID (type: esriFieldTypeString, alias: US_Full_ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• DS_Full_ID (type: esriFieldTypeString, alias: DS_Full_ID, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• Source_Region (type: esriFieldTypeString, alias: Source_Region, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Downstream_MH (type: esriFieldTypeString, alias: Downstream_MH, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Upstream_MH (type: esriFieldTypeString, alias: Upstream_MH, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Sewer_Zone (type: esriFieldTypeString, alias: Sewer_Zone, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Rehab_Type (type: esriFieldTypeSmallInteger, alias: Rehabilitation Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [5: Strong Seal], [2: PrimeFlex Injection - PIpe Connections], ... 10 more ...)
• Rehab_Cont (type: esriFieldTypeSmallInteger, alias: Rehabilitation Contractor, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Tele-Vac], [2: Ace Pipe Cleaning], [0: Unknown], ... 13 more ...)
• Rehab_Date (type: esriFieldTypeDate, alias: Rehabilitation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Video_Pre_Rehab (type: esriFieldTypeString, alias: Video_Pre_Rehab, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Video_Post_Rehab (type: esriFieldTypeString, alias: Video_Post_Rehab, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Video_Report (type: esriFieldTypeString, alias: Video_Report, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• PACP_Score (type: esriFieldTypeString, alias: PACP_Score, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Date_Cleaned (type: esriFieldTypeDate, alias: Date_Cleaned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date_Root_Cut (type: esriFieldTypeDate, alias: Date_Root_Cut, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Date_SmokeTest (type: esriFieldTypeDate, alias: Date_SmokeTest, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GBAID (type: esriFieldTypeInteger, alias: GBAID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GBAUSMH (type: esriFieldTypeString, alias: US Structure, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GBADSMH (type: esriFieldTypeString, alias: DS Structure, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 1
Name: Sanitary Pipe
Domains:

• Field Name: Sewer_Type
  Inherited
  
• Field Name: Pipe_Type
  Inherited
  
• Field Name: Pipe_Status
  Inherited
  
• Field Name: Pipe_Shape
  Inherited
  
• Field Name: Enabled
  Inherited
  
• Field Name: Rehab_Type
  Inherited
  
• Field Name: Rehab_Cont
  Inherited
  
Templates:

Name: Sanitary Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Subtype_Code: 1
• Element_Type: Gravity
• Enabled: 1
• Rehab_Type: 0
• Rehab_Cont: 0

---

ID: 2
Name: Combined Pipe
Domains:

• Field Name: Sewer_Type
  Inherited
  
• Field Name: Pipe_Type
  Inherited
  
• Field Name: Pipe_Status
  Inherited
  
• Field Name: Pipe_Shape
  Inherited
  
• Field Name: Enabled
  Inherited
  
• Field Name: Rehab_Type
  Inherited
  
• Field Name: Rehab_Cont
  Inherited
  
Templates:

Name: Combined Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Subtype_Code: 2
• Enabled: 1
• Rehab_Type: 0
• Rehab_Cont: 0

---

ID: 3
Name: Force Main Pipe
Domains:

• Field Name: Sewer_Type
  Inherited
  
• Field Name: Pipe_Type
  Inherited
  
• Field Name: Pipe_Status
  Inherited
  
• Field Name: Pipe_Shape
  Inherited
  
• Field Name: Enabled
  Inherited
  
• Field Name: Rehab_Type
  Inherited
  
• Field Name: Rehab_Cont
  Inherited
  
Templates:

Name: Force Main Pipe
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• Subtype_Code: 3
• Enabled: 1
• Rehab_Type: 0
• Rehab_Cont: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/7/2020 3:43:18 PM

Schema Last Edit Date: 2/7/2020 3:43:18 PM

Data Last Edit Date: 2/7/2020 3:43:18 PM

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