View In:   ArcGIS Online Map Viewer

Name: ssFitting

Display Field: VERSIONNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 3000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 2070402.2318805754
YMin: 221747.88321447372
XMax: 2112646.736630246
YMax: 253618.10293847322
Spatial Reference: 102677  (3419)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FITTINGTYPE
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [0, 168, 173, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: Bend
  Label: Bend
  Description:
  Symbol:
  
• Value: Cap
  Label: Cap
  Description:
  Symbol:
  
• Value: Offset
  Label: Offset
  Description:
  Symbol:
  
• Value: Repair Clamp
  Label: Repair Clamp
  Description:
  Symbol:
  
• Value: Sleeve
  Label: Sleeve
  Description:
  Symbol:
  
• Value: Tap
  Label: Tap
  Description:
  Symbol:
  
• Value: Saddle
  Label: Tapping Saddle
  Description:
  Symbol:
  
• Value: Tee
  Label: Tee
  Description:
  Symbol:
  
• Value: Wye
  Label: Wye
  Description:
  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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: FITTINGTYPE

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 )
• FITTINGTYPE ( type: esriFieldTypeString, alias: Fitting Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FITTINGTYPE , Coded Values: [Bend: Bend] , [Block: Block] , [Cap: Cap] , ...19 more... )
• BENDANGLE ( type: esriFieldTypeDouble, alias: Bend Angle, editable: true, nullable: true, defaultValue: null, modelName: BENDANGLE , Coded Values: [11.25: 11.25] , [22.5: 22.5] , [45: 45] , ...1 more... )
• DIAMETER1 ( type: esriFieldTypeDouble, alias: DIAMETER1, editable: true, nullable: true, defaultValue: 8, modelName: DIAMETER1 , Coded Values: [0.5: 1/2"] , [0.63: 5/8"] , [0.75: 3/4"] , ...34 more... )
• DIAMETER2 ( type: esriFieldTypeDouble, alias: DIAMETER2, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER2 , Coded Values: [0.5: 1/2"] , [0.63: 5/8"] , [0.75: 3/4"] , ...34 more... )
• DIAMETER3 ( type: esriFieldTypeDouble, alias: DIAMETER3, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER3 , Coded Values: [0.5: 1/2"] , [0.63: 5/8"] , [0.75: 3/4"] , ...34 more... )
• DIAMETER4 ( type: esriFieldTypeDouble, alias: DIAMETER4, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER4 , Coded Values: [0.5: 1/2"] , [0.63: 5/8"] , [0.75: 3/4"] , ...34 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: DI, modelName: MATERIAL , Coded Values: [Brass: Brass] , [Conc: Concrete] , [Cop: Copper] , ...9 more... )
• JOINTTYPE ( type: esriFieldTypeString, alias: JointType, editable: true, nullable: true, length: 20, defaultValue: MJ, modelName: JOINTTYPE , Coded Values: [MJ: Mechanical Joint] , [Tap: Tapping] , [Thread: Threaded] , ...10 more... )
• VERIFICATION ( type: esriFieldTypeString, alias: Verification, editable: true, nullable: true, length: 25, defaultValue: AsBuilt, modelName: VERIFICATION , Coded Values: [AsBuilt: Engineering As-Built] , [Field: Field Measurement] , [GPS: GPS] , ...4 more... )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LOCDESC )
• LOCMEASURE ( type: esriFieldTypeString, alias: Loc Measurements, editable: true, nullable: true, length: 120, defaultValue: null, modelName: LOCMEASURE )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: 1, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: City of Lawrence] , [-1: Private] , [-2: Other] , ...2 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [1: Collection Systems Operations] , [-1: Private] , [-2: Other] , ...8 more... )
• WORKORDERID ( type: esriFieldTypeString, alias: WORKORDERID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WORKORDERID )
• HYPERLINK ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HYPERLINK )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 200, defaultValue: null, modelName: COMMENTS )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• VERSIONNAME ( type: esriFieldTypeString, alias: VERSIONNAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VERSIONNAME )
• ND_NUMBER ( type: esriFieldTypeString, alias: Fitting Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ND_NUMBER )
• ND_ID ( type: esriFieldTypeInteger, alias: Node_RecID, editable: true, nullable: true, defaultValue: null, modelName: ND_ID )
• ND_DB ( type: esriFieldTypeSmallInteger, alias: In Lucity, editable: true, nullable: true, defaultValue: 0, modelName: ND_DB , Coded Values: [0: False] , [1: True] )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: Bend
Name: Bend
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Bend
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Bend
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Cap
Name: Cap
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Cap
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Cap
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Offset
Name: Offset
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Offset
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Offset
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Repair Clamp
Name: Repair Clamp
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Repair Clamp
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Repair Clamp
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Sleeve
Name: Sleeve
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Sleeve
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Sleeve
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Tap
Name: Tap
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Tap
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Tap
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Saddle
Name: Saddle
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Saddle
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Saddle
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Tee
Name: Tee
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Tee
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Tee
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Wye
Name: Wye
Domains:
• FITTINGTYPE:
  Inherited
• BENDANGLE:
  Inherited
• DIAMETER1:
  Inherited
• DIAMETER2:
  Inherited
• DIAMETER3:
  Inherited
• DIAMETER4:
  Inherited
• MATERIAL:
  Inherited
• JOINTTYPE:
  Inherited
• VERIFICATION:
  Inherited
• ENABLED:
  Inherited
• ACTIVEFLAG:
  Inherited
• OWNEDBY:
  Inherited
• MAINTBY:
  Inherited
• ND_DB:
  Inherited
Templates:
• Name: Wye
  Description:
  Prototype:
  ND_ID: null
  ND_DB: 0
  FACILITYID: null
  FITTINGTYPE: Wye
  BENDANGLE: null
  DIAMETER1: 8
  DIAMETER2: null
  DIAMETER3: null
  DIAMETER4: null
  MATERIAL: DI
  JOINTTYPE: MJ
  VERIFICATION: AsBuilt
  ELEVATION: null
  INSTALLDATE: null
  LOCDESC: null
  LOCMEASURE: null
  ROTATION: null
  ENABLED: 1
  ACTIVEFLAG: 1
  OWNEDBY: 1
  MAINTBY: 1
  WORKORDERID: null
  HYPERLINK: null
  COMMENTS: null
  POINT_X: null
  POINT_Y: null
  LASTUPDATE: null
  LASTEDITOR: null
  VERSIONNAME: null
  ND_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: 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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata