Name: Mains

Display Field: UNITID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Min. Scale: 500000

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -13660503.8999
YMin: 5699390.965
XMax: -13656539.1069
YMax: 5702041.3814
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"SYMBOL_GROUP","field2":null,"field3":null,"fieldDelimiter":", ","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,0,0,255],"width":0.2},"defaultLabel":"Unknown Type","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[230,0,0,255],"width":1.5},"value":"SANITARY GRAVITY MAIN","label":"Sanitary Gravity Mains","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[56,168,0,255],"width":2},"value":"STORM GRAVITY MAIN","label":"STORM GRAVITY MAIN","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[230,0,0,255],"width":1.5},"value":"SANITARY PRESSURE MAIN","label":"Sanitary Pressure Mains","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":1.5},"value":"COMBINED GRAVITY MAIN","label":"Combined Gravity Mains","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[169,0,230,255],"width":1.5},"value":"COMBINED PRESSURE MAIN","label":"Combined Pressure Mains","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[169,0,230,255],"width":5},"value":"COMBINED SEWER OVERFLOW MAIN","label":"Combined Sewer Overflow Mains","description":""},{"symbol":{"type":"esriSLS","style":"esriSLSDashDot","color":[112,168,0,255],"width":5},"value":"COMBINED SEWER OVERFLOW","label":"Combined Sewer Overflows","description":""}]},"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_2

Type ID Field: SYMBOL_GROUP

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• UNITID (type: esriFieldTypeString, alias: Hansen UnitID, SQL Type: sqlTypeOther, length: 41, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: Hansen Unit Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMPKEY (type: esriFieldTypeInteger, alias: Hansen Component Key, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPTYPE (type: esriFieldTypeInteger, alias: Hansen Component Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeInteger, alias: Global Identifier, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OWNRSHIP (type: esriFieldTypeString, alias: Ownership, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SERVSTAT (type: esriFieldTypeString, alias: Service Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FRM_NODE (type: esriFieldTypeString, alias: Upstream UnitID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• TO_NODE (type: esriFieldTypeString, alias: Downstream UnitID, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• FRM_ELEV (type: esriFieldTypeDouble, alias: Upstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_ELEV (type: esriFieldTypeDouble, alias: Downstream Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FRM_DEPTH (type: esriFieldTypeDouble, alias: Upstream Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TO_DEPTH (type: esriFieldTypeDouble, alias: Downstream Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SRVY_LEN (type: esriFieldTypeDouble, alias: Surveyed Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPESIZE (type: esriFieldTypeDouble, alias: Pipe Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPEHEIGHT (type: esriFieldTypeDouble, alias: Pipe Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIPESHPE (type: esriFieldTypeString, alias: Pipe Shape, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: Pipe Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• JobNo (type: esriFieldTypeString, alias: JobNo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• X_COORD (type: esriFieldTypeDouble, alias: X Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y_COORD (type: esriFieldTypeDouble, alias: Y Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DATA_SRC (type: esriFieldTypeString, alias: Data Source, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Install_Date (type: esriFieldTypeDate, alias: Install_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EDIT_DATE (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: SYSTEM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LAYER_GROUP (type: esriFieldTypeString, alias: Layer Group, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SYMBOL_GROUP (type: esriFieldTypeString, alias: Symbol Group, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DETAIL_SYMBOL (type: esriFieldTypeString, alias: Detail Symbol, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SHAPE_STLength__ (type: esriFieldTypeDouble, alias: SHAPE_STLength__, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sub_Area (type: esriFieldTypeString, alias: Hansen Sub Area, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Map_Number (type: esriFieldTypeString, alias: Hansen Map Number, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Parallel_Line_Number (type: esriFieldTypeString, alias: Parallel Line Number, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• Sheet_Number (type: esriFieldTypeString, alias: AsBuilt Sheet Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Abandoned_By_Job (type: esriFieldTypeString, alias: Abandoned By Job, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Date_Abandoned (type: esriFieldTypeDate, alias: Date Abandoned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Agreement_ID (type: esriFieldTypeString, alias: Agreement ID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Responsible_Party (type: esriFieldTypeString, alias: Responsible Party, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Agreement_End (type: esriFieldTypeDate, alias: Agreement End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Hansen_LastModBy (type: esriFieldTypeString, alias: Hansen Last Modified By, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Hansen_LastModDate (type: esriFieldTypeDate, alias: Hanen Last Modified Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Lateral Address, SQL Type: sqlTypeOther, length: 65, nullable: true, editable: true)
• Service_Line_Type (type: esriFieldTypeString, alias: Service Line Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Lateral_Depth (type: esriFieldTypeDouble, alias: Lateral Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TAPDIST (type: esriFieldTypeDouble, alias: Lateral Tap Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tap_Location (type: esriFieldTypeString, alias: Lateral Tap Location, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• TAP_LABEL (type: esriFieldTypeString, alias: TAP_LABEL, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• Angled_Lateral_Dist (type: esriFieldTypeDouble, alias: Angled_Lateral_Dist, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cleanout_Location (type: esriFieldTypeString, alias: Lateral Cleanout Location, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Cleanout_Present (type: esriFieldTypeString, alias: Lateral Cleanout Present, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• ChannelType (type: esriFieldTypeString, alias: Channel Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Swale_Liner_Coverage (type: esriFieldTypeString, alias: Swale Liner Coverage, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUBTYPE (type: esriFieldTypeString, alias: SUBTYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Inlet_Type (type: esriFieldTypeString, alias: Inlet Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SOURCE_TABLE (type: esriFieldTypeString, alias: Hansen Source, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• STLength__ (type: esriFieldTypeDouble, alias: STLength__, SQL Type: sqlTypeOther, nullable: false, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Types:

ID: COMBINED GRAVITY MAIN
Name: Combined Gravity Mains
Domains:

Templates:

Name: Combined Gravity Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: COMBINED GRAVITY MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: SANITARY PRESSURE MAIN
Name: Sanitary Pressure Mains
Domains:

Templates:

Name: Sanitary Pressure Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: SANITARY PRESSURE MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: COMBINED PRESSURE MAIN
Name: Combined Pressure Mains
Domains:

Templates:

Name: Combined Pressure Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: COMBINED PRESSURE MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: STORM GRAVITY MAIN
Name: STORM GRAVITY MAIN
Domains:

Templates:

Name: STORM GRAVITY MAIN
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: STORM GRAVITY MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: SANITARY GRAVITY MAIN
Name: Sanitary Gravity Mains
Domains:

Templates:

Name: Sanitary Gravity Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: SANITARY GRAVITY MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: COMBINED SEWER OVERFLOW MAIN
Name: Combined Sewer Overflow Mains
Domains:

Templates:

Name: Combined Sewer Overflow Mains
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: COMBINED SEWER OVERFLOW MAIN
• Parallel_Line_Number:
• STLength__: 0

---

ID: COMBINED SEWER OVERFLOW
Name: Combined Sewer Overflows
Domains:

Templates:

Name: Combined Sewer Overflows
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FRM_NODE:
• TO_NODE:
• SYMBOL_GROUP: COMBINED SEWER OVERFLOW
• Parallel_Line_Number:
• STLength__: 0

---

Relationships:

• SOM_INSP_MAINS (0) -- Related To: Inspections (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/29/2019 9:12:43 PM

Schema Last Edit Date: 10/29/2019 9:12:43 PM

Data Last Edit Date: 10/29/2019 9:12:43 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat