View In:   ArcGIS Online Map Viewer

Name: Water Main

Display Field: Diameter

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 1b4765e23368404696151a7ab237291e

Copyright Text:

Default Visibility: true

MaxRecordCount: 50000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 50000

Max Scale: 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: 1590060.6114128083
YMin: 674148.1399359703
XMax: 1748070.7018880546
YMax: 754098.7910579741
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 197, 255, 255]
Width: 2
Default Label: Owned By Others
UniqueValueInfos:
• Value: Abandoned In Place
  Label: Abandoned In Place
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 0, 255]
  Width: 2
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: In Field
  Label: In Field
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 2
• Value: Retired
  Label: Retired
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [182, 249, 252, 255]
  Width: 1
• Value: Trashed
  Label: Trashed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 197, 234, 255]
  Width: 1
• Value: Warehouse
  Label: Warehouse
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [252, 251, 182, 255]
  Width: 1
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 112, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 20000.0
Max. Scale: 0.0

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: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: 8, modelName: Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
• INSTALLYEAR ( type: esriFieldTypeSmallInteger, alias: Year Install, editable: true, nullable: true, defaultValue: 2023, modelName: Yr_Install )
• PROJECTNO ( type: esriFieldTypeString, alias: Project No, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Project_No )
• COMMENT ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RECORDDRAW ( type: esriFieldTypeString, alias: Record Drawing, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Record_Drawing )
• Polywrap ( type: esriFieldTypeString, alias: Polywrap, editable: true, nullable: true, length: 10, defaultValue: Yes, modelName: Polywrap , Coded Values: [Yes: Yes] , [No: No] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 30, defaultValue: PVC, modelName: Material , Coded Values: [ABS: ABS Plastic] , [CAS: Cast Iron] , [CIPP: Cured In Place] , ...18 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: Active, modelName: Status , Coded Values: [In Field: In Field] , [Trashed: Trashed] , [Warehouse: Warehouse] , ...4 more... )
• RESJOINTS ( type: esriFieldTypeString, alias: Res Joints, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Res_Joints , Coded Values: [Yes: Yes] , [No: No] )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 5, modelName: OWNEDBY , Coded Values: [0: Toledo City of] , [1: Waterville City of] , [2: Oregon City of] , ...4 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Length ( type: esriFieldTypeInteger, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• LEGACY_ID ( type: esriFieldTypeString, alias: Legacy ID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEGACY_ID )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION , Coded Values: [Amboy Twp - Fulton County: Amboy Township - Fulton County] , [City of Maumee: City of Maumee] , [City of Oregon: City of Oregon] , ...32 more... )
• WARRANTYDATE ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WARRANTYDATE )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition, editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• CREATED_USER ( type: esriFieldTypeString, alias: Created User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: Created Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: Last Edited User, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: Last Edited Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• INSPECTED_DATE ( type: esriFieldTypeDate, alias: Inspected Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSPECTED_DATE )
• INSPECTED_BY ( type: esriFieldTypeString, alias: Inspected By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSPECTED_BY )
• SERVICE_DATE ( type: esriFieldTypeDate, alias: Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICE_DATE )
• SERVICE_BY ( type: esriFieldTypeString, alias: Serviced By, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERVICE_BY )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: Abandoned In Place
Name: Abandoned In Place
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: Abandoned In Place
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: Abandoned In Place
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Active
Name: Active
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: Active
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: In Field
Name: In Field
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: In Field
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: In Field
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Retired
Name: Retired
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: Retired
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: Retired
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Trashed
Name: Trashed
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: Trashed
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: Trashed
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Warehouse
Name: Warehouse
Domains:
• Diameter:
  Inherited
• Polywrap:
  Inherited
• Material:
  Inherited
• Status:
  Inherited
• RESJOINTS:
  Inherited
• OWNEDBY:
  Inherited
• LOCATION:
  Inherited
Templates:
• Name: Warehouse
  Description:
  Prototype:
  Material: PVC
  SERVICE_BY: null
  Diameter: 8
  INSTALLYEAR: 2023
  PROJECTNO: null
  COMMENT: null
  RECORDDRAW: null
  Polywrap: Yes
  Status: Warehouse
  RESJOINTS: null
  FACILITYID: null
  OWNEDBY: 5
  SERVICE_DATE: null
  Length: null
  LEGACY_ID: null
  LOCATION: null
  WARRANTYDATE: null
  CONDITION: null
  CONDITIONDATE: null
  CREATED_USER: null
  CREATED_DATE: null
  LAST_EDITED_USER: null
  LAST_EDITED_DATE: null
  INSPECTED_DATE: null
  INSPECTED_BY: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata