View In:   ArcGIS Online Map Viewer

Name: sMainLineArchive

Display Field: X_NO1_TEXT

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Sewer main pipes connects the citywide sewer distribution system. The pipes carry raw sewer from various sources in to treatment plants. Sewer main pipes are mostly underground, are made of different materials (such as Steel, PVC, DI, VC, Concrete, CI, AC, Fiberglass, Tin, HDPE)and come in different sizes. Main lines are mapped from georeferenced engineering as-built record drawings. The engineering drawings, as well as GPS points collected in the field, provide various attribute information.

Copyright Text: City of Fort Worth, Water Department, Water IT GIS

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2245871.5368424654
YMin: 6888691.83580856
XMax: 2419884.570049301
YMax: 7067128.571125984
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [75, 0, 156, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 3
  Label: Forced
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [130, 150, 0, 255]
  Width: 1
• Value: 1
  Label: Gravity
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [148, 0, 150, 255]
  Width: 1
• Value: 2
  Label: Low Pressure
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [145, 90, 0, 255]
  Width: 1
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: STYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS_ID, editable: true, nullable: false, defaultValue: null, modelName: GIS_ID )
• LEGACY_ID ( type: esriFieldTypeInteger, alias: LEGACY_ID, editable: true, nullable: true, defaultValue: null, modelName: LEGACY_ID )
• DOE_NO1 ( type: esriFieldTypeInteger, alias: DOE_NO1, editable: true, nullable: true, defaultValue: null, modelName: DOE_NO1 )
• DOE_NO2 ( type: esriFieldTypeInteger, alias: DOE_NO2, editable: true, nullable: true, defaultValue: null, modelName: DOE_NO2 )
• X_NO1 ( type: esriFieldTypeInteger, alias: X_NO1, editable: true, nullable: true, defaultValue: null, modelName: X_NO1 )
• X_NO1_TEXT ( type: esriFieldTypeString, alias: X_NO1_TEXT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: X_NO1_TEXT )
• XSHEET1 ( type: esriFieldTypeSmallInteger, alias: XSHEET1, editable: true, nullable: true, defaultValue: null, modelName: XSHEET1 )
• X_NO2 ( type: esriFieldTypeInteger, alias: X_NO2, editable: true, nullable: true, defaultValue: null, modelName: X_NO2 )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• ANNEXATIONDATE ( type: esriFieldTypeDate, alias: ANNEXATIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ANNEXATIONDATE )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• OWNEDBY ( type: esriFieldTypeString, alias: OWNEDBY, editable: true, nullable: true, length: 255, defaultValue: Fort Worth, modelName: OWNEDBY , Coded Values: [Benbrook: Benbrook] , [Blue Mound: Blue Mound] , [Burleson: Burleson] , ...36 more... )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 255, defaultValue: Fort Worth, modelName: MAINTBY , Coded Values: [Benbrook: Benbrook] , [Blue Mound: Blue Mound] , [Burleson: Burleson] , ...36 more... )
• INSERVICE ( type: esriFieldTypeSmallInteger, alias: INSERVICE, editable: true, nullable: true, defaultValue: 1, modelName: INSERVICE , Coded Values: [0: No] , [1: Yes] )
• CFWGRID ( type: esriFieldTypeString, alias: CFWGRID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CFWGRID )
• MAPSCOGRID ( type: esriFieldTypeString, alias: MAPSCOGRID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAPSCOGRID )
• TADMAP ( type: esriFieldTypeString, alias: TADMAP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TADMAP )
• TO_NODE ( type: esriFieldTypeInteger, alias: TO_NODE, editable: true, nullable: true, defaultValue: null, modelName: TO_NODE )
• FROM_NODE ( type: esriFieldTypeInteger, alias: FROM_NODE, editable: true, nullable: true, defaultValue: null, modelName: FROM_NODE )
• UPELEV ( type: esriFieldTypeDouble, alias: UPELEV, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• DOWNELEV ( type: esriFieldTypeDouble, alias: DOWNELEV, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• SUBAREA ( type: esriFieldTypeString, alias: SUBAREA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUBAREA )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• DATASOURCE ( type: esriFieldTypeString, alias: DATASOURCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DATASOURCE , Coded Values: [Assumed: Assumed] , [GPS Verified: Field Verified] , [Notes: Notes] , ...1 more... )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 12, defaultValue: null, modelName: LASTEDITOR )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• ARCHIVEACTION ( type: esriFieldTypeString, alias: Archive Action, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ARCHIVEACTION , Coded Values: [Abandoned: Abandoned] , [Removed: Removed] , [Replaced: Replaced] , ...2 more... )
• RESPONSIBLE_XNO ( type: esriFieldTypeInteger, alias: RESPONSIBLE_XNO, editable: true, nullable: true, defaultValue: null, modelName: RESPONSIBLE_XNO )
• YEARREMOVED ( type: esriFieldTypeDate, alias: Year Removed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YEARREMOVED )
• MAXASSETNUM ( type: esriFieldTypeString, alias: MAXASSETNUM, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MAXASSETNUM )
• MAXSITEID ( type: esriFieldTypeString, alias: MAXSITEID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MAXSITEID )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: 1, modelName: MXCREATIONSTATE , Coded Values: [0: No] , [1: Yes] )
• STYPE ( type: esriFieldTypeInteger, alias: STYPE, editable: true, nullable: true, defaultValue: 1, modelName: STYPE )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: 8, modelName: DIAMETER , Coded Values: [1.25: 1.25] , [1.5: 1.5] , [2: 2] , ...50 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MATERIAL , Coded Values: [A.B.S.: A.B.S.] , [A.C.: A.C.] , [ARMCO TRUSS: ARMCO TRUSS] , ...10 more... )
• STRUCTTYPE ( type: esriFieldTypeString, alias: STRUCTTYPE, editable: true, nullable: true, length: 255, defaultValue: Standard, modelName: STRUCTTYPE , Coded Values: [Standard: Standard] , [Aerial: Aerial] , [Siphon: Siphon] , ...1 more... )
• INTLINER ( type: esriFieldTypeSmallInteger, alias: INTLINER, editable: true, nullable: true, defaultValue: 0, modelName: INTLINER , Coded Values: [0: No] , [1: Yes] )
• INTLINERTYPE ( type: esriFieldTypeString, alias: INTLINERTYPE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INTLINERTYPE )
• INTLINERDATE ( type: esriFieldTypeDate, alias: INTLINERDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INTLINERDATE )
• INTLINERX_NO ( type: esriFieldTypeInteger, alias: INTLINERX_NO, editable: true, nullable: true, defaultValue: null, modelName: INTLINERX_NO )
• CALCLENGTH ( type: esriFieldTypeDouble, alias: CALCLENGTH, editable: true, nullable: true, defaultValue: null, modelName: CALCLENGTH )
• MAINNUMBER ( type: esriFieldTypeString, alias: MAINNUMBER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINNUMBER )
• LEGACY_MAINLATERAL ( type: esriFieldTypeString, alias: LEGACY_MAINLATERAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEGACY_MAINLATERAL )
• LEGACY_USSN ( type: esriFieldTypeString, alias: USSN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: USSN )
• LEGACY_DSSN ( type: esriFieldTypeString, alias: DSSN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DSSN )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• CPMS_NO ( type: esriFieldTypeString, alias: CPMS_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CPMS_NO )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.len, editable: false, nullable: true, defaultValue: null, modelName: Shape.len, required: true )

Types:

ID: 3
Name: Forced
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• STRUCTTYPE:
  Inherited
• INTLINER:
  Inherited
Templates:
• Name: Forced
  Description:
  Prototype:
  CPMS_NO: null
  COMMENTS: null
  GIS_ID: 0
  LEGACY_ID: null
  DOE_NO1: null
  DOE_NO2: null
  X_NO1: null
  X_NO1_TEXT: null
  XSHEET1: null
  X_NO2: null
  INSTALLDATE: null
  ANNEXATIONDATE: null
  WARRANTYDATE: null
  OWNEDBY: Fort Worth
  MAINTBY: Fort Worth
  INSERVICE: 1
  CFWGRID: null
  MAPSCOGRID: null
  TADMAP: null
  TO_NODE: null
  FROM_NODE: null
  UPELEV: null
  DOWNELEV: null
  SUBAREA: null
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  STYPE: 3
  DIAMETER: 8
  MATERIAL: null
  STRUCTTYPE: Standard
  INTLINER: 0
  INTLINERTYPE: null
  INTLINERDATE: null
  INTLINERX_NO: null
  CALCLENGTH: null
  MAINNUMBER: null
  LEGACY_MAINLATERAL: null
  LEGACY_USSN: null
  LEGACY_DSSN: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Gravity
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• STRUCTTYPE:
  Inherited
• INTLINER:
  Inherited
Templates:
• Name: Gravity
  Description:
  Prototype:
  CPMS_NO: null
  COMMENTS: null
  GIS_ID: 0
  LEGACY_ID: null
  DOE_NO1: null
  DOE_NO2: null
  X_NO1: null
  X_NO1_TEXT: null
  XSHEET1: null
  X_NO2: null
  INSTALLDATE: null
  ANNEXATIONDATE: null
  WARRANTYDATE: null
  OWNEDBY: Fort Worth
  MAINTBY: Fort Worth
  INSERVICE: 1
  CFWGRID: null
  MAPSCOGRID: null
  TADMAP: null
  TO_NODE: null
  FROM_NODE: null
  UPELEV: null
  DOWNELEV: null
  SUBAREA: null
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  STYPE: 1
  DIAMETER: 8
  MATERIAL: null
  STRUCTTYPE: Standard
  INTLINER: 0
  INTLINERTYPE: null
  INTLINERDATE: null
  INTLINERX_NO: null
  CALCLENGTH: null
  MAINNUMBER: null
  LEGACY_MAINLATERAL: null
  LEGACY_USSN: null
  LEGACY_DSSN: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Low Pressure
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• MATERIAL:
  Inherited
• STRUCTTYPE:
  Inherited
• INTLINER:
  Inherited
Templates:
• Name: Low Pressure
  Description:
  Prototype:
  CPMS_NO: null
  COMMENTS: null
  GIS_ID: 0
  LEGACY_ID: null
  DOE_NO1: null
  DOE_NO2: null
  X_NO1: null
  X_NO1_TEXT: null
  XSHEET1: null
  X_NO2: null
  INSTALLDATE: null
  ANNEXATIONDATE: null
  WARRANTYDATE: null
  OWNEDBY: Fort Worth
  MAINTBY: Fort Worth
  INSERVICE: 1
  CFWGRID: null
  MAPSCOGRID: null
  TADMAP: null
  TO_NODE: null
  FROM_NODE: null
  UPELEV: null
  DOWNELEV: null
  SUBAREA: null
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  STYPE: 2
  DIAMETER: 8
  MATERIAL: null
  STRUCTTYPE: Standard
  INTLINER: 0
  INTLINERTYPE: null
  INTLINERDATE: null
  INTLINERX_NO: null
  CALCLENGTH: null
  MAINNUMBER: null
  LEGACY_MAINLATERAL: null
  LEGACY_USSN: null
  LEGACY_DSSN: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata