View In:
ArcGIS Online Map Viewer
Name: wFittings
Display Field: facilityid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Service Item Id: e50c3a18d1ea49c49cf961bb0f1ca085
Copyright Text:
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 10000
Max Scale: 0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: false
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
XMin: 812692.5770049952
YMin: 402639.2419414073
XMax: 914966.8688470796
YMax: 477606.4765210748
Spatial Reference: 102666
(2239)
Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: fittingtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label:
UniqueValueInfos:
-
Value: 45 Bend
Label: 45 Bend
Description: 45 Bend
Symbol:
-
Value: 90 Bend
Label: 90 Bend
Description: 90 Bend
Symbol:
-
Value: Cap
Label: Cap
Description: Cap
Symbol:
-
Value: Cross
Label: Cross
Description: Cross
Symbol:
-
Value: Hydra-Stop
Label: Hydra-Stop
Description: Hydra-Stop
Symbol:
-
Value: Increaser
Label: Increaser
Description: Increaser
Symbol:
-
Value: Other
Label: Other
Description: Other
Symbol:
-
Value: Plug
Label: Plug
Description: Plug
Symbol:
-
Value: Reducer
Label: Reducer
Description: Reducer
Symbol:
-
Value: Sleeve
Label: Sleeve
Description: Sleeve
Symbol:
-
Value: Tap
Label: Tap
Description: Tap
Symbol:
-
Value: Tapping Saddle
Label: Tapping Saddle
Description: Tapping Saddle
Symbol:
-
Value: Tee
Label: Tee
Description: Tee
Symbol:
-
Value: Wye
Label: Wye
Description: Wye
Symbol:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: fittingtype
Fields:
-
objectid
(
nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID
)
-
facilityid
(
modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility Identifier, type: esriFieldTypeString
)
-
installdate
(
modelName: installdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Install Date, type: esriFieldTypeDate
)
-
fittingtype
(
modelName: FITTINGTYPE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Fitting Type, type: esriFieldTypeString
, Coded Values:
[Cap: Cap]
, [Coupling: Coupling]
, [Cross: Cross]
, ...18 more...
)
-
rotation
(
modelName: ROTATION, nullable: true, editable: true, defaultValue: null, alias: Rotation, type: esriFieldTypeDouble
)
-
enabled
(
modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
)
-
activeflag
(
modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger
, Coded Values:
[0: False]
, [1: True]
)
-
ownedby
(
modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: JWSC]
, ...5 more...
)
-
maintby
(
modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger
, Coded Values:
[-1: Private]
, [-2: Other]
, [1: JWSC]
, ...3 more...
)
-
lastupdate
(
modelName: lastupdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last Update, type: esriFieldTypeDate
)
-
lasteditor
(
modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString
)
-
ancillaryr
(
modelName: ANCILLARYR, nullable: true, editable: true, defaultValue: null, alias: Ancillary Roll, type: esriFieldTypeSmallInteger
)
-
subtype
(
modelName: SUBTYPE, nullable: true, editable: true, defaultValue: null, alias: Subtype, type: esriFieldTypeDouble
)
-
material
(
modelName: MATERIAL, nullable: true, editable: true, defaultValue: null, length: 20, alias: Material, type: esriFieldTypeString
, Coded Values:
[ABS: ABS Plastic]
, [AC: Asbestos Cement]
, [ASP: Asphalt]
, ...39 more...
)
-
comment
(
modelName: COMMENT, nullable: true, editable: true, defaultValue: null, length: 50, alias: Comment, type: esriFieldTypeString
)
-
fitting_size
(
modelName: FITTING_SIZE, nullable: true, editable: true, defaultValue: null, length: 9, alias: Fitting Size, type: esriFieldTypeString
)
-
ruleid
(
modelName: RULEID, nullable: true, editable: true, defaultValue: null, alias: Rule ID, type: esriFieldTypeInteger
)
-
gps_source
(
modelName: GPS_SOURCE, nullable: true, editable: true, defaultValue: null, length: 50, alias: GPS Source, type: esriFieldTypeString
)
-
location
(
modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 250, alias: Location, type: esriFieldTypeString
)
-
lifecycle
(
modelName: LIFECYCLE, nullable: true, editable: true, defaultValue: null, length: 25, alias: Lifecycle, type: esriFieldTypeString
, Coded Values:
[ABN: Abandoned]
, [ACT: Active]
, [REP: Being Repaired]
, ...5 more...
)
-
condition
(
modelName: CONDITION, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeSmallInteger
, Coded Values:
[EXCELLENT: EXCELLENT]
, [GOOD: GOOD]
, [POOR: POOR]
, ...2 more...
)
-
conditiondate
(
modelName: conditiondate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Condition Date, type: esriFieldTypeDate
)
-
warrantydate
(
modelName: warrantydate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Warranty Date, type: esriFieldTypeDate
)
-
criticalasset
(
modelName: CRITICALASSET, nullable: true, editable: true, defaultValue: null, length: 20, alias: Critical Asset, type: esriFieldTypeString
)
-
installvalue
(
modelName: INSTALLVALUE, nullable: true, editable: true, defaultValue: null, alias: Install Value, type: esriFieldTypeInteger
)
-
depreciatedvalue
(
modelName: DEPRECIATEDVALUE, nullable: true, editable: true, defaultValue: null, alias: Depreciated Value, type: esriFieldTypeInteger
)
-
usefullife
(
modelName: USEFULLIFE, nullable: true, editable: true, defaultValue: null, alias: Useful Life, type: esriFieldTypeInteger
)
-
legacyid
(
modelName: LEGACYID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Legacy ID, type: esriFieldTypeString
)
-
globalid
(
nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: GlobalID, alias: GlobalID
)
-
workorder
(
modelName: WorkOrder, nullable: true, editable: true, defaultValue: null, length: 15, alias: Work Order, type: esriFieldTypeString
)
-
northing
(
modelName: Northing, nullable: true, editable: true, defaultValue: null, alias: Northing, type: esriFieldTypeDouble
)
-
easting
(
modelName: Easting, nullable: true, editable: true, defaultValue: null, alias: Easting, type: esriFieldTypeDouble
)
-
gps
(
modelName: gps, nullable: true, editable: true, defaultValue: null, length: 5, alias: GPS, type: esriFieldTypeString
, Coded Values:
[Yes: Yes]
, [No: No]
, [Dip: Dip]
, ...1 more...
)
-
created_user
(
modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString
)
-
created_date
(
modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate
)
-
last_edited_user
(
modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString
)
-
last_edited_date
(
modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate
)
-
gpsdate
(
modelName: gpsdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GPS Date, type: esriFieldTypeDate
)
Types:
ID: 45 Bend
Name: 45 Bend
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: 45 Bend
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: 45 Bend
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: 90 Bend
Name: 90 Bend
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: 90 Bend
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: 90 Bend
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Cap
Name: Cap
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Cap
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Cap
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Cross
Name: Cross
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Cross
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Cross
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Hydra-Stop
Name: Hydra-Stop
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Hydra-Stop
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Hydra-Stop
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Increaser
Name: Increaser
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Increaser
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Increaser
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Other
Name: Other
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Other
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Other
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Plug
Name: Plug
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Plug
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Plug
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Reducer
Name: Reducer
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Reducer
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Reducer
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Sleeve
Name: Sleeve
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Sleeve
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Sleeve
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Tap
Name: Tap
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Tap
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Tap
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Tapping Saddle
Name: Tapping Saddle
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Tapping Saddle
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Tapping Saddle
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Tee
Name: Tee
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Tee
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Tee
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
ID: Wye
Name: Wye
Domains:
-
lifecycle:
Inherited
-
condition:
Inherited
-
material:
Inherited
-
fittingtype:
Inherited
-
maintby:
Inherited
-
gps:
Inherited
-
ownedby:
Inherited
-
enabled:
Inherited
-
activeflag:
Inherited
Templates:
-
Name: Wye
Description:
Prototype:
installdate: null
facilityid: null
depreciatedvalue: null
northing: null
enabled: 1
lifecycle: null
subtype: null
warrantydate: null
fitting_size: null
gpsdate: null
ownedby: 1
conditiondate: null
easting: null
criticalasset: null
rotation: null
gps: null
lasteditor: null
activeflag: 1
condition: null
gps_source: null
material: null
ancillaryr: null
fittingtype: Wye
legacyid: null
maintby: 1
location: null
comment: null
installvalue: null
lastupdate: null
ruleid: null
workorder: null
usefullife: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query,Sync,Extract
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: true
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
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Attachments
Query Analytic
Query Top Features
Query Bins
Append
Validate SQL
Generate Renderer
Return Updates
Metadata
Update Metadata