View In:   ArcGIS Online Map Viewer

Name: Sanitary Sewer Force Main

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Separated and combined sewer pressure mains.

Service Item Id: 7551cfe6718d4600a6e857d44d098864

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 1608234.565550387
YMin: 673464.3939281404
XMax: 1762639.967040807
YMax: 754018.0513900667
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: OWNEDBY
Field 2: STATUS
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 5,Active
  Label: Lucas County (Active)
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [56, 168, 0, 255]
  Width: 3
• Value: 5,Abandoned In Place
  Label: Lucas County (Abandoned In Place)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 2
• Value: 0,Active
  Label: City of Toledo (Active)
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 170, 0, 255]
  Width: 2
• Value: 1,Active
  Label: City of Waterville (Active)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 170, 0, 255]
  Width: 2
• Value: 4,Active
  Label: Private (Active)
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [255, 0, 197, 255]
  Width: 2
• Value: ,Abandoned In Place
  Label: Unknown (Abandoned In Place)
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [219, 166, 255, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [201, 49, 0, 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: 8
Font Family: Source Sans Pro
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 1000.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: OWNEDBY

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: PVC, modelName: MATERIAL )
• 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... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: Raw, modelName: WATERTYPE )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: null, modelName: OWNEDBY , Coded Values: [0: Toledo City of] , [1: Waterville City of] , [2: Oregon City of] , ...4 more... )
• MAINTAINEDBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 5, modelName: MAINTBY , Coded Values: [0: Toledo City of] , [1: Waterville City of] , [2: Oregon City of] , ...4 more... )
• PROJECTNO ( type: esriFieldTypeString, alias: Project No, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Project_No )
• COMMENT ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• RECORDEDDRAW ( type: esriFieldTypeString, alias: Record Drawing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Record_Dra )
• FLUSHYEAR ( type: esriFieldTypeString, alias: Year Flush, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Year_Flush )
• FLUSHREPORT ( type: esriFieldTypeString, alias: Flush Report, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Flush_Repo )
• LINEDYEAR ( type: esriFieldTypeString, alias: Year Lined, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LINEDYEAR )
• LINERTYPE ( type: esriFieldTypeString, alias: Liner Type, editable: true, nullable: true, length: 20, defaultValue: NONE, modelName: LINERTYPE )
• SUMFLOW ( type: esriFieldTypeDouble, alias: Flow Summary, editable: true, nullable: true, defaultValue: null, modelName: SUMFLOW )
• DOWNELEV ( type: esriFieldTypeDouble, alias: Downstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: DOWNELEV )
• UPELEV ( type: esriFieldTypeDouble, alias: Upstream Elevation, editable: true, nullable: true, defaultValue: null, modelName: UPELEV )
• SLOPE ( type: esriFieldTypeDouble, alias: Slope, editable: true, nullable: true, defaultValue: null, modelName: SLOPE )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STATUS , Coded Values: [In Field: In Field] , [Trashed: Trashed] , [Warehouse: Warehouse] , ...4 more... )
• INSTALLYEAR ( type: esriFieldTypeString, alias: Intsall Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: YearInstall )
• ToMH ( type: esriFieldTypeString, alias: ToMH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ToMH )
• FromMH ( type: esriFieldTypeString, alias: FromMH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FromMH )
• Length ( type: esriFieldTypeInteger, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• 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 )
• 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 )
• SOURCE ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 255, defaultValue: 1, modelName: SOURCE )
• Private ( type: esriFieldTypeString, alias: Private, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Private )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: false, defaultValue: null, modelName: SHAPE.STLength() )

Types:

ID: 5
Name: Lucas County (Active)
Domains:
• DIAMETER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTAINEDBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Lucas County (Active)
  Description:
  Prototype:
  WATERTYPE: Raw
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  OWNEDBY: 5
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Active
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine
• Name: Lucas County (Abandoned In Place)
  Description:
  Prototype:
  WATERTYPE: Raw
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  OWNEDBY: 5
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Abandoned In Place
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 0
Name: City of Toledo (Active)
Domains:
• DIAMETER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTAINEDBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: City of Toledo (Active)
  Description:
  Prototype:
  WATERTYPE: Raw
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  OWNEDBY: 0
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Active
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: City of Waterville (Active)
Domains:
• DIAMETER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTAINEDBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: City of Waterville (Active)
  Description:
  Prototype:
  WATERTYPE: Raw
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  OWNEDBY: 1
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Active
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: Private (Active)
Domains:
• DIAMETER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTAINEDBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Private (Active)
  Description:
  Prototype:
  WATERTYPE: Raw
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  OWNEDBY: 4
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Active
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: null
Name: Unknown (Abandoned In Place)
Domains:
• DIAMETER:
  Inherited
• OWNEDBY:
  Inherited
• MAINTAINEDBY:
  Inherited
• STATUS:
  Inherited
Templates:
• Name: Unknown (Abandoned In Place)
  Description:
  Prototype:
  SLOPE: null
  Private: null
  FACILITYID: null
  MATERIAL: PVC
  DIAMETER: 8
  WATERTYPE: Raw
  OWNEDBY: null
  MAINTAINEDBY: 5
  PROJECTNO: null
  COMMENT: null
  RECORDEDDRAW: null
  FLUSHYEAR: null
  FLUSHREPORT: null
  LINEDYEAR: null
  LINERTYPE: NONE
  SUMFLOW: null
  DOWNELEV: null
  UPELEV: null
  STATUS: Abandoned In Place
  INSTALLYEAR: null
  ToMH: null
  FromMH: null
  Length: null
  LOCATION: null
  CONDITIONDATE: null
  SOURCE: 1
  SERVICE_BY: null
  SERVICE_DATE: null
  INSPECTED_BY: null
  INSPECTED_DATE: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

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   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata