View In:   ArcGIS Online Map Viewer

Name: wServiceLineArchive

Display Field: DATESOURCE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water piping connection (through a tap connection) from water main to customer's meter or to a fire hydrant. A plugged service lines are pipes that are plugged on one end pending meter installation. Service 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: 2245354.06609264
YMin: 6886510.944829151
XMax: 2418288.7599207163
YMax: 7067543.896410808
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: WTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [109, 0, 176, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 3
  Label: Domestic
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [52, 0, 156, 255]
  Width: 1
• Value: 1
  Label: Fire
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [150, 83, 0, 255]
  Width: 1
• Value: 2
  Label: Irrigation
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 138, 94, 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: WTYPE

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: esriFieldTypeSmallInteger, alias: X_NO1_TEXT, editable: true, nullable: true, 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 )
• DATESOURCE ( type: esriFieldTypeString, alias: DATESOURCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DATESOURCE , Coded Values: [Record Drawing: Record Drawing] , [Notes: Notes] , [Field Verified: Field Verified] , ...3 more... )
• 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] , [Bethesda: Bethesda] , [Burleson: Burleson] , ...33 more... )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 255, defaultValue: Fort Worth, modelName: MAINTBY , Coded Values: [Benbrook: Benbrook] , [Bethesda: Bethesda] , [Burleson: Burleson] , ...33 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 )
• 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] )
• WTYPE ( type: esriFieldTypeInteger, alias: WTYPE, editable: true, nullable: true, defaultValue: 2, modelName: WTYPE )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [1: 1] , [1.5: 1.5] , [2: 2] , ...9 more... )
• DIAMETERSOURCE ( type: esriFieldTypeString, alias: DIAMETERSOURCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DIAMETERSOURCE , Coded Values: [Record Drawing: Record Drawing] , [Notes: Notes] , [Field Verified: Field Verified] , ...3 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MATERIAL , Coded Values: [A.C.: A.C.] , [C.I.: C.I.] , [CONCRETE: CONCRETE] , ...12 more... )
• MATERIALSOURCE ( type: esriFieldTypeString, alias: MATERIALSOURCE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MATERIALSOURCE , Coded Values: [Record Drawing: Record Drawing] , [Notes: Notes] , [Field Verified: Field Verified] , ...3 more... )
• LOCATIONDESC ( type: esriFieldTypeString, alias: LOCATIONDESC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESC )
• PRESPLANE ( type: esriFieldTypeString, alias: PRESPLANE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRESPLANE , Coded Values: [HO: HO] , [NS2: NS2] , [NS3: NS3] , ...17 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• SYSTEMTYPE ( type: esriFieldTypeString, alias: SYSTEMTYPE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SYSTEMTYPE , Coded Values: [Potable: Potable] , [Raw: Raw] )
• CPMS_NO ( type: esriFieldTypeString, alias: CPMS_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CPMS_NO )
• CALCLENGTH_FT ( type: esriFieldTypeDouble, alias: CALCLENGTH_FT, editable: true, nullable: true, defaultValue: null, modelName: CALCLENGTH )
• CALCLENGTH_MI ( type: esriFieldTypeDouble, alias: CALCLENGTH_MI, editable: true, nullable: true, defaultValue: null, modelName: CALCLENGTH_MI )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.len, editable: false, nullable: true, defaultValue: null, modelName: Shape.len, required: true )

Types:

ID: 3
Name: Domestic
Domains:
• DATESOURCE:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• DIAMETERSOURCE:
  Inherited
• MATERIAL:
  Inherited
• MATERIALSOURCE:
  Inherited
• PRESPLANE:
  Inherited
Templates:
• Name: Domestic
  Description:
  Prototype:
  CALCLENGTH_MI: null
  CALCLENGTH_FT: 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
  DATESOURCE: 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
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  WTYPE: 3
  DIAMETER: null
  DIAMETERSOURCE: null
  MATERIAL: null
  MATERIALSOURCE: null
  LOCATIONDESC: null
  PRESPLANE: null
  COMMENTS: null
  SYSTEMTYPE: null
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: Fire
Domains:
• DATESOURCE:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• DIAMETERSOURCE:
  Inherited
• MATERIAL:
  Inherited
• MATERIALSOURCE:
  Inherited
• PRESPLANE:
  Inherited
Templates:
• Name: Fire
  Description:
  Prototype:
  CALCLENGTH_MI: null
  CALCLENGTH_FT: 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
  DATESOURCE: 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
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  WTYPE: 1
  DIAMETER: null
  DIAMETERSOURCE: null
  MATERIAL: null
  MATERIALSOURCE: null
  LOCATIONDESC: null
  PRESPLANE: null
  COMMENTS: null
  SYSTEMTYPE: null
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: Irrigation
Domains:
• DATESOURCE:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
• DIAMETER:
  Inherited
• DIAMETERSOURCE:
  Inherited
• MATERIAL:
  Inherited
• MATERIALSOURCE:
  Inherited
• PRESPLANE:
  Inherited
Templates:
• Name: Irrigation
  Description:
  Prototype:
  CALCLENGTH_MI: null
  CALCLENGTH_FT: 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
  DATESOURCE: 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
  Hyperlink: null
  DATASOURCE: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  WTYPE: 2
  DIAMETER: null
  DIAMETERSOURCE: null
  MATERIAL: null
  MATERIALSOURCE: null
  LOCATIONDESC: null
  PRESPLANE: null
  COMMENTS: null
  SYSTEMTYPE: null
  CPMS_NO: 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