View In:   ArcGIS Online Map Viewer

Name: Pipe

Display Field: Line_Type

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 9e30e417347b46259671f1b67107269b

Copyright Text:

Default Visibility: true

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: -9961888.828820888
YMin: 4957432.60948945
XMax: -9928158.739384964
YMax: 4973163.7711247625
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: ColStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Yes
  Label: Yes
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [38, 115, 0, 255]
  Width: 1
• Value: Dipped
  Label: Dipped not GPS'd
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 1
• Value: No
  Label: No
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: Abandoned
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: Can't locate
  Label: Could not locate
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 1
• Value: Not Accessible
  Label: Not Accessible
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 1
• Value: GIS Updated
  Label: GIS Updated
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [56, 168, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ColStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Line_Type ( type: esriFieldTypeSmallInteger, alias: Line Type, editable: true, nullable: true, defaultValue: 0, modelName: Line_Type )
• Material ( type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: 1, modelName: Material )
• Pipe_Length ( type: esriFieldTypeInteger, alias: Pipe Length, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Length )
• Grade ( type: esriFieldTypeString, alias: Grade, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Grade )
• USMH_Inv_Elev ( type: esriFieldTypeString, alias: USMH Inv Elev, editable: true, nullable: true, length: 8, defaultValue: null, modelName: USMH_Inv_Elev )
• DSMH_Inv_Elev ( type: esriFieldTypeString, alias: DSMH Inv Elev, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DSMH_Inv_Elev )
• Year_Built ( type: esriFieldTypeString, alias: Year Built, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Year_Built )
• Loc ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 15, defaultValue: Street, modelName: Loc )
• Admin ( type: esriFieldTypeString, alias: Jurisdiction, editable: true, nullable: true, length: 10, defaultValue: City, modelName: Admin )
• Pipe_ID ( type: esriFieldTypeString, alias: Pipe ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Pipe_ID )
• Basin ( type: esriFieldTypeString, alias: Basin, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Basin )
• Clean_Date ( type: esriFieldTypeDate, alias: Clean Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Clean_Date )
• TV_Date ( type: esriFieldTypeDate, alias: TV Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TV_Date )
• TV_File ( type: esriFieldTypeString, alias: TV File Link, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TV_File )
• Sub ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sub )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: Comments )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled )
• Map_Update ( type: esriFieldTypeString, alias: Map Update, editable: true, nullable: true, length: 7, defaultValue: Yes, modelName: Map_Update )
• Material_Types ( type: esriFieldTypeSmallInteger, alias: Material_Types, editable: true, nullable: true, defaultValue: null, modelName: Material_Types )
• GIS_Update ( type: esriFieldTypeDate, alias: GIS_Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GIS_Update )
• ArchiveOld ( type: esriFieldTypeString, alias: ArchiveOld, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ArchiveOld )
• SpatialUpdate ( type: esriFieldTypeDate, alias: Spatial Update, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SpatialUpdate )
• MaterialTxt ( type: esriFieldTypeString, alias: MaterialTxt, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MaterialTxt )
• P_Diameter ( type: esriFieldTypeString, alias: Pipe Diameter, editable: true, nullable: true, length: 5, defaultValue: null, modelName: P_Diameter )
• DecadeBuilt ( type: esriFieldTypeString, alias: Decade Built, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DecadeBuilt )
• Mat ( type: esriFieldTypeString, alias: Mat, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Mat )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Status )
• ColStatus ( type: esriFieldTypeString, alias: Collected?, editable: true, nullable: true, length: 255, defaultValue: No, modelName: ColStatus , Coded Values: [Yes: Yes] , [No: No] , [Dipped: Dipped not GPS'd] , ...4 more... )
• Point_Number ( type: esriFieldTypeString, alias: Point_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Point_Number )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Yes
Name: Yes
Domains:
• ColStatus:
  Inherited
Templates:
• Name: Yes
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: Yes
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Dipped
Name: Dipped not GPS'd
Domains:
• ColStatus:
  Inherited
Templates:
• Name: Dipped not GPS'd
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: Dipped
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: No
Name: No
Domains:
• ColStatus:
  Inherited
Templates:
• Name: No
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: No
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Abandoned
Name: Abandoned
Domains:
• ColStatus:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: Abandoned
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Can't locate
Name: Could not locate
Domains:
• ColStatus:
  Inherited
Templates:
• Name: Could not locate
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: Can't locate
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Not Accessible
Name: Not Accessible
Domains:
• ColStatus:
  Inherited
Templates:
• Name: Not Accessible
  Description:
  Prototype:
  Status: null
  Point_Number: null
  Line_Type: 0
  Year_Built: null
  Loc: Street
  Comments: null
  Enabled: 1
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  ColStatus: Not Accessible
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: GIS Updated
Name: GIS Updated
Domains:
• ColStatus:
  Inherited
Templates:
• Name: GIS Updated
  Description:
  Prototype:
  ColStatus: GIS Updated
  Point_Number: null
  Line_Type: 0
  Material: 1
  Pipe_Length: null
  Grade: null
  USMH_Inv_Elev: null
  DSMH_Inv_Elev: null
  Year_Built: null
  Loc: Street
  Admin: City
  Pipe_ID: null
  Basin: null
  Clean_Date: null
  TV_Date: null
  TV_File: null
  Sub: null
  Comments: null
  Enabled: 1
  Map_Update: Yes
  Material_Types: null
  GIS_Update: null
  ArchiveOld: null
  SpatialUpdate: null
  MaterialTxt: null
  P_Diameter: null
  DecadeBuilt: null
  Mat: null
  Status: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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