Name: SAN_MAIN

Display Field: COMMON_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

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: 511425.258136749
YMin: 129363.18839848
XMax: 551819.769867241
YMax: 195312.555187151
Spatial Reference: 103734 (103734)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• FACILITY_ID (type: esriFieldTypeString, alias: FACILITY_ID, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• YEAR_BUILT (type: esriFieldTypeInteger, alias: YEAR_BUILT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ACTIVE: Available for Use], [PENDEC: Pending Decommission], [ABANDONED: Inactive, In Place], ... 3 more ...)
• DOCUMENT_LINK (type: esriFieldTypeString, alias: DOCUMENT_LINK, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• BUILT_BY (type: esriFieldTypeString, alias: BUILT_BY, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [MPLS: CITY OF MINNEAPOLIS FORCES], [MPRB: MINNEAPOLIS PARK AND RECREATION BOARD], [HC: HENNEPIN COUNTY], ... 8 more ...)
• DATA_SOURCE (type: esriFieldTypeString, alias: DATA_SOURCE, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true, Coded Values: [PW: PUBLIC WORKS], [MPRB: MINNEAPOLIS PARK AND RECREATION BOARD], [HC: HENNEPIN COUNTY], ... 7 more ...)
• DATA_SOURCE_TYPE (type: esriFieldTypeString, alias: DATA_SOURCE_TYPE, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [PLAT: PLAT], [RDP: RECORD DRAWING PAPER], [RDD: RECORD DRAWING DIGITAL], ... 12 more ...)
• OWNER (type: esriFieldTypeString, alias: OWNER, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [MPLS: CITY OF MINNEAPOLIS], [MPRB: MINNEAPOLIS PARK AND RECREATION BOARD], [UOFM: UNIVERSITY OF MINNESOTA], ... 17 more ...)
• MAINTAINED_BY (type: esriFieldTypeString, alias: MAINTAINED_BY, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [OWN: OWNER], [MPRB: PWSWS MPRB AGREEMENT], [WOREIM: PWSWS WITHOUT REIMBURSEMENT AGREEMENT], ... 5 more ...)
• SUBTYPE_CODE (type: esriFieldTypeInteger, alias: SUBTYPE_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMMON_NAME (type: esriFieldTypeString, alias: COMMON_NAME, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true, Coded Values: [50: 2ND AV S], [51: 3RD AV N], [52: 3RD AV S], ... 12 more ...)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [RCP: REINFORCED CONCRETE], [VCP: CLAY], [PVC: POLYVINYL CHLORIDE], ... 21 more ...)
• SOURCE_LENGTH_FT (type: esriFieldTypeDouble, alias: SOURCE_LENGTH_FT, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 2600])
• LINED (type: esriFieldTypeString, alias: LINED, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [LINED: Lined], [UNLINED: Unlined])
• CAST_IN_PLACE (type: esriFieldTypeString, alias: CAST_IN_PLACE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• INVERT_IN_ELEV (type: esriFieldTypeDouble, alias: INVERT_IN_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [650 - 1050])
• INVERT_OUT_ELEV (type: esriFieldTypeDouble, alias: INVERT_OUT_ELEV, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [650 - 1050])
• DIAMETER_IN (type: esriFieldTypeDouble, alias: DIAMETER_IN, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Other], [0: Unknown], [0.75: 3/4"], ... 83 more ...)
• WIDTH_IN (type: esriFieldTypeDouble, alias: WIDTH_IN, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 192])
• HEIGHT_IN (type: esriFieldTypeDouble, alias: HEIGHT_IN, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 192])
• HEIGHT_FT (type: esriFieldTypeDouble, alias: HEIGHT_FT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PLAT (type: esriFieldTypeString, alias: PLAT, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• PIPE_SHAPE (type: esriFieldTypeString, alias: PIPE_SHAPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [C: CIRCULAR], [B: BOX], [SE: SEMI ELLIPTICAL], ... 8 more ...)
• UP_NODE (type: esriFieldTypeString, alias: UP_NODE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• DOWN_NODE (type: esriFieldTypeString, alias: DOWN_NODE, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CONFIDENCE (type: esriFieldTypeString, alias: CONFIDENCE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [M: MEDIUM], [H: HIGH], [L: LOW], ... 1 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• PACP_SHAPE (type: esriFieldTypeString, alias: PACP_SHAPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: ARCHED (WITH FLAT BOTTOM)], [B: BARREL (BEER BARREL SHAPE)], [C: CIRCULAR], ... 8 more ...)
• PACP_HEIGHT_IN (type: esriFieldTypeDouble, alias: PACP_HEIGHT_INCHES, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [1 - 192])
• PACP_CITY (type: esriFieldTypeString, alias: PACP_CITY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [MPLS: MINNEAPOLIS])
• PACP_LOCATION (type: esriFieldTypeString, alias: PACP_LOCATION, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• YEAR_LINED (type: esriFieldTypeDate, alias: YEAR_LINED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UDI (type: esriFieldTypeString, alias: UDI, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MODELING_PIPE_SHAPE (type: esriFieldTypeInteger, alias: MODELING_PIPE_SHAPE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CIRCULAR], [3: NON CIRCULAR])
• MODELING_PIPE_SHAPE_INDEX (type: esriFieldTypeInteger, alias: MODELING_PIPE_SHAPE_INDEX, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CIRCULAR], [2: RECTANGULAR], [3: SCC HORSESHOE], ... 16 more ...)
• PACP_YEAR_BUILT (type: esriFieldTypeDate, alias: PACP_YEAR_BUILT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PACP_MATERIAL (type: esriFieldTypeString, alias: PACP_MATERIAL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [AC: ASBESTOS CEMENT], [BR: BRICK], [CAS: CAST IRON], ... 23 more ...)
• PACP_RATING_OM (type: esriFieldTypeString, alias: PACP_PIPE_RATING_INDEX_OM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PACP_RATING_STRUCT (type: esriFieldTypeString, alias: PACP_PIPE_RATING_INDEX__STRUCTURAL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PACP_INSPECT_DATE (type: esriFieldTypeDate, alias: PACP_INSPECT_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PACP_LAST_MOD_DATE (type: esriFieldTypeDate, alias: PACP_LAST_MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PACP_EQUIV_DIA_IN (type: esriFieldTypeDouble, alias: PACP_EQUIVALENT_DIAMETER_INCHES, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Other], [0: Unknown], [0.75: 3/4"], ... 83 more ...)
• PACP_COMMENTS (type: esriFieldTypeString, alias: PACP_COMMENTS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PACP_LN_METHOD (type: esriFieldTypeString, alias: PACP_LINING_METHOD, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [CP: CURED IN PLACE], [FF: FOLD AND FORM OR DEFORM/REFORM], [SN: SEGMENTED PANEL], ... 3 more ...)
• FEATURE_TYPE (type: esriFieldTypeString, alias: FEATURE_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [GRAV: GRAVITY], [TUN: TUNNEL], [SIPIPE: SIPHON PIPE], ... 3 more ...)
• MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MXLOCATION (type: esriFieldTypeString, alias: MXLOCATION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CHANGEDATE (type: esriFieldTypeDate, alias: CHANGEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MXCREATIONSTATE (type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROWSTAMP (type: esriFieldTypeInteger, alias: ROWSTAMP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: AM_SYSTEM_TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Sanitary: Sanitary], [Storm: Stormwater])
• DISTRICT (type: esriFieldTypeString, alias: DISTRICT, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [N: NORTH], [NE: NORTHEAST], [S: SOUTH], ... 1 more ...)
• CLEANING_MAP (type: esriFieldTypeString, alias: CLEANING_MAP, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• PILING (type: esriFieldTypeString, alias: PILING, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• PLANKING (type: esriFieldTypeString, alias: PLANKING, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• ENCASEMENT (type: esriFieldTypeString, alias: ENCASEMENT, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• CREATED_BY (type: esriFieldTypeString, alias: CREATED_BY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_MODIFIED_BY (type: esriFieldTypeString, alias: LAST_MODIFIED_BY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LAST_MODIFIED_DATE (type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• MXCHANGEBY (type: esriFieldTypeString, alias: MXCHANGEBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• MXCHANGEDATE (type: esriFieldTypeDate, alias: MXCHANGEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Sanitary Main, Asset Under Construction
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: CONSTRUCTION
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 1
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Main, Pending Decommission
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: PENDEC
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 1
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Force Main, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 4
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Interceptor, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 6
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Interceptor Siphon, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 7
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Main, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 1
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Pipe In Pipe, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 5
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Siphon Pipe, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 3
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Tunnel, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 2
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Tunnel Drift, Available for Use
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ACTIVE
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 8
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Force Main, Inactive, Removed; Sanitary Interceptor, Inactive, Removed; Sanitary Main, Inactive, Removed
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: REMOVED
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 4
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Main, Inactive, In Place
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ABANDONED
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 1
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary
Name: Sanitary Pipe In Pipe, Inactive, In Place
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• STATUS: ABANDONED
• Enabled: 1
• ROWSTAMP: 0
• SUBTYPE_CODE: 5
• PACP_CITY: MPLS
• MXSITEID: COM
• MXCREATIONSTATE: 1
• SYSTEM: Sanitary

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/27/2023 8:19:49 PM

Schema Last Edit Date: 6/27/2023 8:19:49 PM

Data Last Edit Date: 6/27/2023 8:19:49 PM

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