All Layers and Tables (tEST8)

Layers:

Layer: SAN_MAIN (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

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

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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:

STATUS: CONSTRUCTION
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 1
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: PENDEC
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 1
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 4
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 6
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 7
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 1
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

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

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 3
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 2
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: ACTIVE
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 8
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

STATUS: REMOVED
Enabled: 1
ROWSTAMP: 0
SUBTYPE_CODE: 4
PACP_CITY: MPLS
MXSITEID: COM
MXCREATIONSTATE: 1
SYSTEM: Sanitary

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

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

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: