View In:   ArcGIS Online Map Viewer

Name: rMainLineArchive

Display Field: ARCHIVEACTION

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Archived: Reuse Water main pipes connects the citywide reuse water distribution system. Reuse Water main pipes are mostly underground, are made of different materials (such as Steel, PVC, DI, VC, Copper, Concrete, CI, AC)and come in different sizes. reuse main lines are mapped from georeferenced engineering as-built record drawings. The drawings as well as GPS points collected after construction 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: 2233280.742798388
YMin: 6859789.788297817
XMax: 2418885.2206700593
YMax: 7091500.501384646
Spatial Reference: 102738  (2276)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 133, 108, 255]
Width: 1
Label: N/A
Description: N/A
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ARCHIVEACTION ( type: esriFieldTypeString, alias: ARCHIVEACTION, 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: YEARREMOVED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YEARREMOVED )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS_ID, editable: true, nullable: false, defaultValue: null, modelName: GIS_ID )
• 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 )
• 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: 255, defaultValue: null, modelName: X_NO1_TEXT )
• X_NO2 ( type: esriFieldTypeInteger, alias: X_NO2, editable: true, nullable: true, defaultValue: null, modelName: X_NO2 )
• XSHEET1 ( type: esriFieldTypeSmallInteger, alias: XSHEET1, editable: true, nullable: true, defaultValue: null, modelName: XSHEET1 )
• 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... )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: WARRANTYDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• ANNEXATIONDATE ( type: esriFieldTypeDate, alias: ANNEXATIONDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ANNEXATIONDATE )
• 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... )
• PRESPLANE ( type: esriFieldTypeString, alias: PRESPLANE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PRESPLANE )
• DIAMETER ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: 8, modelName: DIAMETER , Coded Values: [1.25: 1.25] , [1.5: 1.5] , [1.75: 1.75] , ...29 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] , ...6 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... )
• STRUCTTYPE ( type: esriFieldTypeString, alias: STRUCTTYPE, editable: true, nullable: true, length: 255, defaultValue: Standard, modelName: STRUCTTYPE , Coded Values: [Standard: Standard] , [Aerial: Aerial] , [Woop Down: Woop Down] )
• LINED ( type: esriFieldTypeSmallInteger, alias: LINED, editable: true, nullable: true, defaultValue: 0, modelName: LINED , Coded Values: [0: No] , [1: Yes] )
• LINEDDATE ( type: esriFieldTypeDate, alias: LINEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LINEDDATE )
• LINEDX_NO ( type: esriFieldTypeInteger, alias: LINEDX_NO, editable: true, nullable: true, defaultValue: null, modelName: LINEDX_NO )
• CATHODIC ( type: esriFieldTypeSmallInteger, alias: CATHODIC, editable: true, nullable: true, defaultValue: 0, modelName: CATHODIC , Coded Values: [0: No] , [1: Yes] )
• 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... )
• 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 )
• 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 )
• 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: FTW, modelName: MAXSITEID )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: 1, modelName: MXCREATIONSTATE , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• Hyperlink ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• 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 )

Templates:

• Name: rMainLineArchive
  Description:
  Prototype:
  CPMS_NO: null
  Hyperlink: null
  ARCHIVEACTION: null
  RESPONSIBLE_XNO: null
  YEARREMOVED: null
  GIS_ID: 0
  TO_NODE: null
  FROM_NODE: null
  DOE_NO1: null
  DOE_NO2: null
  X_NO1: null
  X_NO1_TEXT: null
  X_NO2: null
  XSHEET1: null
  INSTALLDATE: null
  DATESOURCE: null
  WARRANTYDATE: null
  ANNEXATIONDATE: null
  OWNEDBY: Fort Worth
  MAINTBY: Fort Worth
  PRESPLANE: null
  DIAMETER: 8
  DIAMETERSOURCE: null
  MATERIAL: null
  MATERIALSOURCE: null
  STRUCTTYPE: Standard
  LINED: 0
  LINEDDATE: null
  LINEDX_NO: null
  CATHODIC: 0
  DATASOURCE: null
  INSERVICE: 1
  CFWGRID: null
  MAPSCOGRID: null
  TADMAP: null
  LASTEDITOR: null
  LASTUPDATE: null
  MAXASSETNUM: null
  MAXSITEID: FTW
  MXCREATIONSTATE: 1
  COMMENTS: null
  Enabled: 1
  
  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