Name: Water_Points

Display Field: Asset_Group

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 319bba4c48a7445d841f050660508842

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2558503.3159999996
YMin: 7621920.067000002
XMax: 2567523.3319999985
YMax: 7631626.664999999
Spatial Reference: 2036  (2953)  VCSWkid(6647)  LatestVCSWkid(6647)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: asset_subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 103
  Label: Water - Main Valve
  Description: N/A
  Symbol:
  
• Value: 104
  Label: Water - Fire Hydrant - Location
  Description: N/A
  Symbol:
  
• Value: 106
  Label: Water - Fire Hydrant - Valve
  Description: N/A
  Symbol:
  
• Value: 107
  Label: Water - Lateral - Shut Off Valve
  Description: N/A
  Symbol:
  
• Value: 108
  Label: Water - Lateral - Meter
  Description: N/A
  Symbol:
  
• Value: 110
  Label: Water - Lateral - DBH
  Description: N/A
  Symbol:
  
• Value: 111
  Label: Water - Main Fitting - Tee
  Description: N/A
  Symbol:
  
• Value: 112
  Label: Water - Main Fitting - Elbow
  Description: N/A
  Symbol:
  
• Value: 113
  Label: Water - Main Fitting - Union
  Description: N/A
  Symbol:
  
• Value: 114
  Label: Water - Main Fitting - Cap
  Description: N/A
  Symbol:
  
• Value: 115
  Label: Water - Flushing Unit - Location
  Description: N/A
  Symbol:
  
• Value: 116
  Label: Water - Pressure Reducing Valve - Location
  Description: N/A
  Symbol:
  
• Value: 117
  Label: Water - Check Valve - Location
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [178, 224, 97, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [26, 26, 26, 255] Width: 0
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Asset_Subtype

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• asset_group ( type: esriFieldTypeSmallInteger, alias: Asset Group , Coded Values: [-1: What is my asset group?] , [0: Unknown] , [1: Roads] , ...5 more... )
• asset_type ( type: esriFieldTypeSmallInteger, alias: Asset Type , Coded Values: [0: What type of entity am I?] , [1: Water Distribution System] , [2: Sanitary Sewer System] , ...8 more... )
• asset_subtype ( type: esriFieldTypeSmallInteger, alias: Asset Subtype )
• asset_id ( type: esriFieldTypeString, alias: Asset ID, length: 50 )
• serial_number ( type: esriFieldTypeInteger, alias: Serial Number )
• e_coder_serial ( type: esriFieldTypeDouble, alias: E-Coder Serial )
• related_pid ( type: esriFieldTypeString, alias: Related PID, length: 16 )
• closest_civic_address ( type: esriFieldTypeString, alias: Closest Civic Address, length: 50 )
• related_civic_number ( type: esriFieldTypeString, alias: Related Civic Number, length: 50 )
• related_street_name ( type: esriFieldTypeSmallInteger, alias: Related Street Name , Coded Values: [623: Ch. Lugar (623)] , [673: Abraham Rd. (673)] , [412: Agatha St. (412)] , ...415 more... )
• related_street_section ( type: esriFieldTypeDouble, alias: Related Street Section , Coded Values: [-1: Not Applicable] , [100.00099945: 100.001 (Murray Ave. To Main St.)] , [100.0019989: 100.002 (Main St. To Miramichi Ave.)] , ...592 more... )
• geolocation ( type: esriFieldTypeSmallInteger, alias: GeoLocation , Coded Values: [-1: Not Applicable] , [0: Unknown] , [1: From City's High Precision GPS] , ...6 more... )
• grid_reference ( type: esriFieldTypeString, alias: Grid Reference, length: 6 , Coded Values: [TBD: To Be Determined] , [28Q-E3: 28Q-E3] , [28Q-E2: 28Q-E2] , ...23 more... )
• installation_year ( type: esriFieldTypeSmallInteger, alias: Installation Year , Coded Values: [-1: Not Applicable] , [0: Unknown] , [1910: 1910] , ...120 more... )
• diameter ( type: esriFieldTypeSmallInteger, alias: Diameter , Coded Values: [-1: Not Applicable] , [0: Unknown] , [16: 16mm] , ...37 more... )
• type ( type: esriFieldTypeString, alias: Type, length: 65 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 50 )
• last_maintenance_inspection_dat ( type: esriFieldTypeSmallInteger, alias: Last Maintenance Inspection Date )
• link_to_as_built ( type: esriFieldTypeString, alias: Link to As-Built, length: 250 )
• link_to_ti_ins ( type: esriFieldTypeString, alias: Link to Ti-ins, length: 250 )
• feature_creator ( type: esriFieldTypeString, alias: Feature Creator, length: 150 )
• creation_date ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• last_editor ( type: esriFieldTypeString, alias: Last Editor, length: 255 )
• last_edit_date ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• jurisdiction ( type: esriFieldTypeSmallInteger, alias: Jurisdiction , Coded Values: [-1: Not Applicable] , [0: Unknown] , [1: Asset Owned by the City of Bathurst] , ...4 more... )
• tangible_capital_asset ( type: esriFieldTypeSmallInteger, alias: Tangible Capital Asset , Coded Values: [-1: Not Applicable] , [0: Unknown] , [1: Yes] , ...1 more... )
• expected_life_years ( type: esriFieldTypeSmallInteger, alias: Expected Life Years )
• end_of_life_date ( type: esriFieldTypeSmallInteger, alias: End of Life Date )
• remaining_life_years ( type: esriFieldTypeSmallInteger, alias: Remaining Life Years )
• remaining_life_percent ( type: esriFieldTypeDouble, alias: Remaining Life Percent )
• condition_rating ( type: esriFieldTypeSmallInteger, alias: Condition Rating (1 to 5) )
• cost_per_unit ( type: esriFieldTypeDouble, alias: Cost per Unit )
• asset_replacement_value ( type: esriFieldTypeDouble, alias: Asset Replacement Value )
• emergency_asset_replacement_val ( type: esriFieldTypeDouble, alias: Emergency Asset Replacement Value )
• loss_in_value ( type: esriFieldTypeDouble, alias: Loss in Value )
• remaining_value ( type: esriFieldTypeDouble, alias: Remaining Value )
• infrastructure_deficit__backlog ( type: esriFieldTypeDouble, alias: Infrastructure Deficit (Backlog) )
• duplicate ( type: esriFieldTypeSmallInteger, alias: Duplicate )
• enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• ancillaryrole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• plowing_status ( type: esriFieldTypeSmallInteger, alias: Plowing Status , Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more... )
• snow_plowing_status ( type: esriFieldTypeString, alias: Snow Plowing Status, length: 50 , Coded Values: [Not Applicable: Not Applicable] , [All Good: All Good] , [Plowing & Shoveling Required: Plowing & Shoveling Required] , ...1 more... )
• tempfield ( type: esriFieldTypeString, alias: TempField, length: 255 )
• tempfield2 ( type: esriFieldTypeString, alias: TempField2, length: 250 )
• asset_inspection_statut ( type: esriFieldTypeSmallInteger, alias: Asset Inspection Statut , Coded Values: [1: All Good] , [2: Work Required] , [3: Inspection not yet Performed] , ...1 more... )
• rotate ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• shape ( type: esriFieldTypeGeometry, alias: shape )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Types:

ID: 103
Name: Water - Main Valve
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 104
Name: Water - Fire Hydrant - Location
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 106
Name: Water - Fire Hydrant - Valve
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 107
Name: Water - Lateral - Shut Off Valve
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 108
Name: Water - Lateral - Meter
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 110
Name: Water - Lateral - DBH
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 111
Name: Water - Main Fitting - Tee
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 112
Name: Water - Main Fitting - Elbow
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 113
Name: Water - Main Fitting - Union
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 114
Name: Water - Main Fitting - Cap
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Coded Values: [-1: Not Applicable] , [0: All Good] , [1: Plowing & Shoveling Required] , ...1 more...
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 115
Name: Water - Flushing Unit - Location
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Inherited
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 116
Name: Water - Pressure Reducing Valve - Location
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Inherited
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

ID: 117
Name: Water - Check Valve - Location
Domains:
• asset_group:
  Inherited
• asset_type:
  Inherited
• related_street_name:
  Inherited
• related_street_section:
  Inherited
• geolocation:
  Inherited
• grid_reference:
  Inherited
• installation_year:
  Inherited
• diameter:
  Inherited
• jurisdiction:
  Inherited
• tangible_capital_asset:
  Inherited
• enabled:
  Inherited
• ancillaryrole:
  Inherited
• plowing_status:
  Inherited
• snow_plowing_status:
  Inherited
• asset_inspection_statut:
  Inherited

---

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata