View In:   ArcGIS.com Map

Name: Water Fittings

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Various water main fittings:</SPAN></P><P><SPAN>Tee - can connect pipes of different diameters or change the direction of a pipe run, or both. Three connections.</SPAN></P><P><SPAN>Bend - connect pipes to change the direction of a pipe run. Two connections. </SPAN></P><P><SPAN>Cross - connect pipes to change the direction of a pipe run or different diameters. Four connections.</SPAN></P><P><SPAN>Reducer - connect two pipes of different diameters. Usually leads from larger to smaller diameter pipe.</SPAN></P><P><SPAN>Wye - connect three pipes, potentially with different diameters. Configured in a "Y" shape.</SPAN></P><P><SPAN>Sleeve - Tapping Sleeves are used when tapping into a pipe while it is under pressure. </SPAN></P><P><SPAN>Plug - used to end a water main at an unused section.</SPAN></P></DIV></DIV></DIV>

Copyright Text: Originally created by Woolpert Inc. in 1997. Edited by Battle Creek DPW Records Division.

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000

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: -9498540.87806636
YMin: 5197555.323858744
XMax: -9469959.408848207
YMax: 5216641.23333009
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUB_TYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Bend
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Cross
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Plug
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Reducer
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Tee
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Wye
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Not Available
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [190, 232, 255, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 8
  Label: Sleeve
  Description: N/A
  Symbol:
  
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: SUB_TYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• SUB_TYPE ( type: esriFieldTypeInteger, alias: SUB_TYPE, editable: true, nullable: true, defaultValue: 1, modelName: SUB_TYPE )
• FIT_SIZE ( type: esriFieldTypeString, alias: FITTING SIZE, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FIT_SIZE , Coded Values: [4: 4 inch] , [6: 6 inch] , [8: 8 inch] , ...12 more... )
• FIT_ANGLE ( type: esriFieldTypeString, alias: FITTING ANGLE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FIT_ANGLE , Coded Values: [11.25: 11.25 Degree] , [22.5: 22.5 Degree] , [45: 45 Degree] , ...2 more... )
• CONTRACTOR ( type: esriFieldTypeString, alias: CONTRACTOR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTRACTOR , Coded Values: [City of Battle Creek: City of Battle Creek] , [Crest Construction: Crest Construction] , [Hoffman Brothers: Hoffman Brothers] , ...10 more... )
• YEAR_INSTALLED ( type: esriFieldTypeString, alias: YEAR_INSTALLED, editable: true, nullable: true, length: 10, defaultValue: null, modelName: YEAR_INSTALLED )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• GPS_Date ( type: esriFieldTypeDate, alias: GPS_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPS_Date )
• Duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate, editable: true, nullable: true, defaultValue: null, modelName: Duplicate )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MaintainedBy ( type: esriFieldTypeString, alias: Maintained By, editable: true, nullable: true, length: 75, defaultValue: null, modelName: MaintainedBy , Coded Values: [Bedford Township: Bedford Township] , [City of Battle Creek: City of Battle Creek] , [City of Springfield: City of Springfield] , ...7 more... )
• 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 )
• Verified ( type: esriFieldTypeString, alias: Verified, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Verified , Coded Values: [N: No] , [Y: Yes] , [N/A: N/A] )
• CreatedBy ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 75, defaultValue: null, modelName: CreatedBy )
• CreatedByDate ( type: esriFieldTypeDate, alias: Created By Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedByDate )
• EditedBy ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 75, defaultValue: null, modelName: EditedBy )
• EditedByDate ( type: esriFieldTypeDate, alias: EditedByDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditedByDate )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )

Types:

ID: 1
Name: Bend
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Bend
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 1
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Cross
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Cross
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 2
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Plug
Domains:
• FIT_SIZE:
  Coded Values: [4: 4 inch] , [6: 6 inch] , [8: 8 inch] , ...13 more...
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Plug
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 3
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Reducer
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Reducer
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 4
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Tee
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Tee
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 5
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Wye
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Wye
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 6
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Not Available
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Not Available
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 7
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Sleeve
Domains:
• FIT_SIZE:
  Inherited
• FIT_ANGLE:
  Inherited
• CONTRACTOR:
  Inherited
• Enabled:
  Inherited
• MaintainedBy:
  Inherited
• Verified:
  Inherited
Templates:
• Name: Sleeve
  Description:
  Prototype:
  FACILITYID: null
  Verified: null
  SUB_TYPE: 8
  FIT_SIZE: null
  FIT_ANGLE: null
  CONTRACTOR: null
  YEAR_INSTALLED: null
  ELEVATION: null
  GPS_Date: null
  Duplicate: null
  Enabled: 1
  COMMENTS: null
  MaintainedBy: null
  Latitude: null
  Longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedByDate
• Creator Field: CreatedBy
• Edit Date Field: EditedByDate
• Editor Field: EditedBy

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