View In:   ArcGIS Online Map Viewer

Name: sFittingArchive

Display Field: X_NO1_TEXT

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Various mechanical joint fittings for sewer pipes including tees, reducers, sleeves, plugs, caps etc. Fittings 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: 6887438.5600999
XMax: 2413355.44006297
YMax: 7067537.511252984
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: esriSMSCircle
Color: [0, 121, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 5
  Label: Cross
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 74, 153, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: Plug
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [161, 94, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Reducer
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [173, 0, 26, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Tee
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [138, 0, 71, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Wye
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [129, 0, 168, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 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: true, 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 )
• 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 )
• XCOORDINATE ( type: esriFieldTypeDouble, alias: XCOORDINATE, editable: true, nullable: true, defaultValue: null, modelName: XCOORDINATE )
• YCOORDINATE ( type: esriFieldTypeDouble, alias: YCOORDINATE, editable: true, nullable: true, defaultValue: null, modelName: YCOORDINATE )
• 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... )
• SYMBOL_ROTATION ( type: esriFieldTypeDouble, alias: SYMBOL_ROTATION, editable: true, nullable: true, defaultValue: null, modelName: SYMBOL_ROTATION )
• 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 )
• STYPE ( type: esriFieldTypeInteger, alias: STYPE, editable: true, nullable: true, defaultValue: 1, modelName: STYPE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• USSTATIONNUMBER ( type: esriFieldTypeString, alias: USSTATIONNUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: USSTATIONNUMBER )
• DSSTATIONNUMBER ( type: esriFieldTypeString, alias: DSSTATIONNUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: DSSTATIONNUMBER )
• 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: null, modelName: MXCREATIONSTATE , Coded Values: [0: No] , [1: Yes] )
• CPMS_NO ( type: esriFieldTypeString, alias: CPMS_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: CPMS_NO )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )

Types:

ID: 5
Name: Cross
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
Templates:
• Name: Cross
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  GIS_ID: null
  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
  SUBAREA: null
  Hyperlink: null
  XCOORDINATE: null
  YCOORDINATE: null
  DATASOURCE: null
  SYMBOL_ROTATION: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  STYPE: 5
  COMMENTS: null
  USSTATIONNUMBER: null
  DSSTATIONNUMBER: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Plug
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
Templates:
• Name: Plug
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  GIS_ID: null
  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
  SUBAREA: null
  Hyperlink: null
  XCOORDINATE: null
  YCOORDINATE: null
  DATASOURCE: null
  SYMBOL_ROTATION: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  STYPE: 1
  COMMENTS: null
  USSTATIONNUMBER: null
  DSSTATIONNUMBER: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Reducer
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
Templates:
• Name: Reducer
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  GIS_ID: null
  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
  SUBAREA: null
  Hyperlink: null
  XCOORDINATE: null
  YCOORDINATE: null
  DATASOURCE: null
  SYMBOL_ROTATION: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  STYPE: 2
  COMMENTS: null
  USSTATIONNUMBER: null
  DSSTATIONNUMBER: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Tee
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
Templates:
• Name: Tee
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  GIS_ID: null
  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
  SUBAREA: null
  Hyperlink: null
  XCOORDINATE: null
  YCOORDINATE: null
  DATASOURCE: null
  SYMBOL_ROTATION: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  STYPE: 3
  COMMENTS: null
  USSTATIONNUMBER: null
  DSSTATIONNUMBER: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Wye
Domains:
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• INSERVICE:
  Inherited
• DATASOURCE:
  Inherited
• ARCHIVEACTION:
  Inherited
• MXCREATIONSTATE:
  Inherited
Templates:
• Name: Wye
  Description:
  Prototype:
  LATITUDE: null
  LONGITUDE: null
  GIS_ID: null
  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
  SUBAREA: null
  Hyperlink: null
  XCOORDINATE: null
  YCOORDINATE: null
  DATASOURCE: null
  SYMBOL_ROTATION: null
  LASTEDITOR: null
  LASTUPDATE: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  STYPE: 4
  COMMENTS: null
  USSTATIONNUMBER: null
  DSSTATIONNUMBER: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  CPMS_NO: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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