Name: PipeComplete

Display Field: 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: -10786331.0984753
YMin: 3819314.79060567
XMax: -10639171.5903996
YMax: 4008694.1741937
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[140,140,140,255],"width":1}},"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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• NAME (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LEGACY_ID (type: esriFieldTypeString, alias: Legacy ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_PLANT (type: esriFieldTypeString, alias: In Plant?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA], ... 1 more ...)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [Decommissioned: Decommissioned], [Operating: Operating], ... 3 more ...)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Allen: Allen], [McKinney: McKinney], [NTMWD: NTMWD], ... 17 more ...)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Bonham WTP: Bonham WTP], [Sherman WTP: Sherman WTP], [Tawakoni WTP: Tawakoni WTP], ... 131 more ...)
• ABANDONMENT_DATE (type: esriFieldTypeDate, alias: Abandonment Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• REHAB_TYPE (type: esriFieldTypeString, alias: Rehab Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• REHAB_DATE (type: esriFieldTypeDate, alias: Rehab Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3''], ... 35 more ...)
• MATERIAL (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AC: Asbestos Cement], [CMP: Corrugated Metal Pipe], [DIP: Ductile Iron Pipe], ... 11 more ...)
• COEFF (type: esriFieldTypeDouble, alias: Coefficient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINKED_IMAGES (type: esriFieldTypeString, alias: Linked Images, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Good: Good], [Minor Damage: Minor Damage], [Major Damage: Major Damage], ... 8 more ...)
• COMMENT (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 255, nullable: true, 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)
• MXLOCATION (type: esriFieldTypeString, alias: MXLOCATION, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MXLOCATIONSID (type: esriFieldTypeInteger, alias: MXLOCATIONSID, SQL Type: sqlTypeOther, 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)
• YR_INST (type: esriFieldTypeSmallInteger, alias: Year Installed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TYPE (type: esriFieldTypeSmallInteger, alias: Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Transmission], [2: Distribution], ... 1 more ...)
• LENGTH (type: esriFieldTypeDouble, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AER_CROSS (type: esriFieldTypeString, alias: Aerial Crossing, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA], ... 1 more ...)
• SLOPE (type: esriFieldTypeDouble, alias: Slope, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_COLLECTED (type: esriFieldTypeString, alias: GPS Collected?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA], ... 1 more ...)
• GPS_DATE (type: esriFieldTypeDate, alias: GPS Collection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SYSTEM (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [North: North], [South: South], [East: East], ... 13 more ...)
• TIE_IN (type: esriFieldTypeString, alias: Tie In?, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [NA: NA], ... 1 more ...)
• ProjectNo (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• PipeUse (type: esriFieldTypeString, alias: PipeUse, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [PLW: Plant Water], [Raw: Raw Water], [TRW: Treated Water])
• AsBuiltURL (type: esriFieldTypeString, alias: As Built URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• LayDrawingsURL (type: esriFieldTypeString, alias: Lay Drawings URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: <Null>,Operating
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Operating
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse:
Name: Plant Water,Operating
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Operating
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: PLW
Name: Raw Water,Not Ready
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Not Ready
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: Raw
Name: Raw Water,Operating
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Operating
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: Raw
Name: Treated Water,Not Ready
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Not Ready
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: TRW
Name: Treated Water,Operating
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Operating
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: TRW
Name: Treated Water,Planned
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• MXCREATIONSTATE: 0
• STATUS: Planned
• MXSITEID: 1000
• ROWSTAMP: 0
• PipeUse: TRW

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/12/2024 4:07:35 PM

Schema Last Edit Date: 12/12/2024 4:07:35 PM

Data Last Edit Date: 12/12/2024 4:07:35 PM

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