View In:
ArcGIS Online Map Viewer
Name: Water_Lines
Display Field: Show_When_Page_Name_Is_Not
Type: Feature Layer
Geometry Type: esriGeometryPolyline
Description:
Service Item Id: f8e19747a8354795bd9a17fd453cab0f
Copyright Text:
Default Visibility: true
MaxRecordCount: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.0
Max Scale: 0.0
Supports Advanced Queries: true
Supports Statistics: true
Can Scale Symbols: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Supports Datum Transformation: true
Extent:
XMin: 2558503.3159999996
YMin: 7621897.941
XMax: 2567425.017999999
YMax: 7631616.695999999
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:
Default Label: N/A
UniqueValueInfos:
-
Value: 101
Label: Water - Main
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [0, 0, 255, 255]
Width: 1
-
Value: 102
Label: Water - Lateral
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [0, 0, 255, 255]
Width: 1
-
Value: 105
Label: Water - Fire Hydrant - Latera
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [255, 0, 0, 255]
Width: 1
-
Value: 109
Label: Water - Private Lateral
Description: N/A
Symbol:
Style: esriSLSSolid
Color: [115, 178, 255, 255]
Width: 1
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
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, editable: false, nullable: false, defaultValue: null, modelName: objectid
)
-
globalid
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
asset_group
(
type: esriFieldTypeSmallInteger, alias: Asset Group, editable: true, nullable: true, defaultValue: 1, modelName: Asset_Group
, Coded Values:
[-1: What is my asset group?]
, [0: Unknown]
, [1: Roads]
, ...5 more...
)
-
asset_type
(
type: esriFieldTypeSmallInteger, alias: Asset Type, editable: true, nullable: true, defaultValue: 1, modelName: 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, editable: true, nullable: true, defaultValue: 0, modelName: Asset_Subtype
)
-
asset_id
(
type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_ID
)
-
related_pid
(
type: esriFieldTypeString, alias: Related PID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Related_PID
)
-
closest_civic_address
(
type: esriFieldTypeString, alias: Closest Civic Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Closest_Civic_Address
)
-
related_civic_number
(
type: esriFieldTypeString, alias: Related Civic Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Related_Civic_Number
)
-
related_street_name
(
type: esriFieldTypeSmallInteger, alias: Related Street Name, editable: true, nullable: true, defaultValue: null, modelName: 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, editable: true, nullable: true, defaultValue: null, modelName: 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, editable: true, nullable: true, defaultValue: null, modelName: GeoLocation
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: From City's High Precision GPS]
, ...6 more...
)
-
grid_reference
(
type: esriFieldTypeString, alias: Grid Reference, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Grid_Reference
, Coded Values:
[TBD: To Be Determined]
, [28Q-E3: 28Q-E3]
, [28Q-E2: 28Q-E2]
, ...23 more...
)
-
installation_year
(
type: esriFieldTypeSmallInteger, alias: Installation Year (Finance), editable: true, nullable: true, defaultValue: null, modelName: Installation_Year
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1910: 1910]
, ...120 more...
)
-
diameter
(
type: esriFieldTypeSmallInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [16: 16mm]
, ...37 more...
)
-
material
(
type: esriFieldTypeSmallInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: Material
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Asbestos Cement]
, ...17 more...
)
-
pipe_class
(
type: esriFieldTypeSmallInteger, alias: Pipe Class, editable: true, nullable: true, defaultValue: null, modelName: Pipe_Class
, Coded Values:
[1: 14 Gauge]
, [8: ASDRM C76 CL3]
, [2: ASTM C76]
, ...69 more...
)
-
lateral_with_dbh
(
type: esriFieldTypeSmallInteger, alias: Lateral With DBH, editable: true, nullable: true, defaultValue: null, modelName: Lateral_With_DBH
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
)
-
depth
(
type: esriFieldTypeSmallInteger, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: Depth
)
-
ttyyppee
(
type: esriFieldTypeString, alias: TTYYPPEE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TTYYPPEE
)
-
comments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Comments
)
-
last_maintenance_inspection_dat
(
type: esriFieldTypeSmallInteger, alias: Last Maintenance Inspection Date, editable: true, nullable: true, defaultValue: null, modelName: Last_Maintenance_Inspection_Date
)
-
link_to_as_built
(
type: esriFieldTypeString, alias: Link to As-Built, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Link_to_As_Built
)
-
link_to_ti_ins
(
type: esriFieldTypeString, alias: Link to Ti-Ins, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Link_to_Ti_Ins
)
-
feature_creator
(
type: esriFieldTypeString, alias: Feature Creator, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Feature_Creator
)
-
creation_date
(
type: esriFieldTypeDate, alias: Creation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Creation_Date
)
-
last_editor
(
type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Last_Editor
)
-
last_edit_date
(
type: esriFieldTypeDate, alias: Last Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Last_Edit_Date
)
-
jurisdiction
(
type: esriFieldTypeSmallInteger, alias: Jurisdiction, editable: true, nullable: true, defaultValue: null, modelName: 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, editable: true, nullable: true, defaultValue: null, modelName: Tangible_Capital_Asset
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
)
-
expected_life_years
(
type: esriFieldTypeSmallInteger, alias: Expected Life Years, editable: true, nullable: true, defaultValue: null, modelName: Expected_Life_Years
)
-
end_of_life_date
(
type: esriFieldTypeSmallInteger, alias: End of Life Date, editable: true, nullable: true, defaultValue: null, modelName: End_of_Life_Date
)
-
remaining_life_years
(
type: esriFieldTypeSmallInteger, alias: Remaining Life Years, editable: true, nullable: true, defaultValue: null, modelName: Remaining_Life_Years
)
-
remaining_life_percent
(
type: esriFieldTypeDouble, alias: Remaining Life Percent, editable: true, nullable: true, defaultValue: null, modelName: Remaining_Life_Percent
)
-
condition_rating
(
type: esriFieldTypeSmallInteger, alias: Condition Rating (1 to 5), editable: true, nullable: true, defaultValue: null, modelName: Condition_Rating
)
-
cost_per_unit
(
type: esriFieldTypeDouble, alias: Cost_per_Unit, editable: true, nullable: true, defaultValue: null, modelName: Cost_per_Unit
)
-
asset_replacement_value
(
type: esriFieldTypeDouble, alias: Asset Replacement Value, editable: true, nullable: true, defaultValue: null, modelName: Asset_Replacement_Value
)
-
emergency_asset_replacement_val
(
type: esriFieldTypeDouble, alias: Emergency Asset Replacement Value, editable: true, nullable: true, defaultValue: null, modelName: Emergency_Asset_Replacement_Val
)
-
remaining_value
(
type: esriFieldTypeDouble, alias: Remaining Value, editable: true, nullable: true, defaultValue: null, modelName: Remaining_Value
)
-
infrastructure_deficit__backlog
(
type: esriFieldTypeDouble, alias: Infrastructure Deficit (Backlog), editable: true, nullable: true, defaultValue: null, modelName: Infrastructure_Deficit__Backlog
)
-
show_when_page_name_is_not
(
type: esriFieldTypeString, alias: Show When Page Name Is Not, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Show_When_Page_Name_Is_Not
)
-
psab_2016_comments
(
type: esriFieldTypeSmallInteger, alias: PSAB 2016 Comments, editable: true, nullable: true, defaultValue: null, modelName: PSAB_2016_Comments
)
-
psab_2017_comments
(
type: esriFieldTypeSmallInteger, alias: PSAB 2017 Comments, editable: true, nullable: true, defaultValue: null, modelName: PSAB_2017_Comments
)
-
enabled
(
type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled
, Coded Values:
[0: False]
, [1: True]
)
-
psab_2018_comments
(
type: esriFieldTypeSmallInteger, alias: PSAB 2018 Comments, editable: true, nullable: true, defaultValue: null, modelName: PSAB_2018_Comments
, Coded Values:
[0: Unchanged]
, [1: New entity added under capital contract]
, [2: New entity added for GIS accuracy reasons (not under capital contract)]
, ...6 more...
)
-
tempfield
(
type: esriFieldTypeString, alias: TempField, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TempField
)
-
cost_for_length
(
type: esriFieldTypeDouble, alias: Cost For Length, editable: true, nullable: true, defaultValue: null, modelName: Cost_For_Length
)
-
asset_category
(
type: esriFieldTypeSmallInteger, alias: Asset Category, editable: true, nullable: true, defaultValue: null, modelName: Asset_Category
, Coded Values:
[1: Essential Asset]
, [2: High Value Asset]
, [3: Tangible Capital Asset (5 000$ & up)]
, ...3 more...
)
-
related_service
(
type: esriFieldTypeSmallInteger, alias: Related Service, editable: true, nullable: true, defaultValue: null, modelName: Related_Service
)
-
asset_class
(
type: esriFieldTypeSmallInteger, alias: Asset Class, editable: true, nullable: true, defaultValue: null, modelName: Asset_Class
)
-
asset_subclass
(
type: esriFieldTypeSmallInteger, alias: Asset SubClass, editable: true, nullable: true, defaultValue: null, modelName: Asset_SubClass
)
-
asset_name
(
type: esriFieldTypeString, alias: Asset Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asset_Name
)
-
historical_acquisition_cost2
(
type: esriFieldTypeDouble, alias: Historical Acquisition Cost (Previous 2x), editable: true, nullable: true, defaultValue: null, modelName: Historical_Acquisition_Cost2
)
-
historical_acquisition_cost1
(
type: esriFieldTypeDouble, alias: Historical Acquisition Cost (Previous 1x), editable: true, nullable: true, defaultValue: null, modelName: Historical_Acquisition_Cost1
)
-
cost_per_unit_readjustment
(
type: esriFieldTypeString, alias: Cost per Unit Readjustment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Cost_per_Unit_Readjustment
)
-
residual_value
(
type: esriFieldTypeDouble, alias: Residual Value, editable: true, nullable: true, defaultValue: null, modelName: Residual_Value
)
-
condition_method
(
type: esriFieldTypeSmallInteger, alias: Condition Method, editable: true, nullable: true, defaultValue: null, modelName: Condition_Method
)
-
opening_book_value
(
type: esriFieldTypeDouble, alias: Opening Book Value, editable: true, nullable: true, defaultValue: null, modelName: Opening_Book_Value
)
-
closing_book_value
(
type: esriFieldTypeDouble, alias: Closing Book Value, editable: true, nullable: true, defaultValue: null, modelName: Closing_Book_Value
)
-
asset_totally_depreciated
(
type: esriFieldTypeSmallInteger, alias: Asset Totally Depreciated, editable: true, nullable: true, defaultValue: null, modelName: Asset_Totally_Depreciated
)
-
salvage_value
(
type: esriFieldTypeDouble, alias: Salvage Value, editable: true, nullable: true, defaultValue: null, modelName: Salvage_Value
)
-
lifecycle_maintenance_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Maintenance Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Maintenance_Cost
)
-
lifecycle_maintenance_source
(
type: esriFieldTypeSmallInteger, alias: LifeCycle Maintenance Source of Funding, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Maintenance_Source
)
-
lifecycle_operation_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Operation Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Operation_Cost
)
-
lifecycle_operation_source
(
type: esriFieldTypeSmallInteger, alias: LifeCycle Operation Source of Funding, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Operation_Source
)
-
lifecycle_renewal_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Renewal Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Renewal_Cost
)
-
lifecycle_renewal_source
(
type: esriFieldTypeSmallInteger, alias: LifeCycle Renewal Source, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Renewal_Source
)
-
lifecycle_end_of_life_cost
(
type: esriFieldTypeDouble, alias: LifeCycle End of Life Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_End_of_Life_Cost
)
-
lifecycle_replacement_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Replacement_Cost
)
-
lifecycle_emgreplacement_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Emergency Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_EmgReplacement_Cost
)
-
lifecycle_replacement_source
(
type: esriFieldTypeSmallInteger, alias: LifeCycle Replacement Source of Funding, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Replacement_Source
)
-
lifecycle_admin_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Administrative Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Admin_Cost
)
-
lifecycle_total_cost
(
type: esriFieldTypeDouble, alias: LifeCycle Total Cost, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Total_Cost
)
-
lifecycle_cost_annual
(
type: esriFieldTypeDouble, alias: LifeCycle_Cost_Annual, editable: true, nullable: true, defaultValue: null, modelName: LifeCycle_Cost_Annual
)
-
climate_change_risk
(
type: esriFieldTypeSmallInteger, alias: Climate Change Risk, editable: true, nullable: true, defaultValue: null, modelName: Climate_Change_Risk
)
-
climate_change_risk_type
(
type: esriFieldTypeSmallInteger, alias: Climate Change Risk Type, editable: true, nullable: true, defaultValue: null, modelName: Climate_Change_Risk_Type
)
-
climate_change_risk_probability
(
type: esriFieldTypeSmallInteger, alias: Climate Change Risk Probability, editable: true, nullable: true, defaultValue: null, modelName: Climate_Change_Risk_Probability
)
-
climate_change_risk_impact
(
type: esriFieldTypeSmallInteger, alias: Climate Change Risk Impact, editable: true, nullable: true, defaultValue: null, modelName: Climate_Change_Risk_Impact
)
-
priority_failure
(
type: esriFieldTypeSmallInteger, alias: Priority Failure, editable: true, nullable: true, defaultValue: null, modelName: Priority_Failure
)
-
priority_health_security
(
type: esriFieldTypeSmallInteger, alias: Priority Health Security, editable: true, nullable: true, defaultValue: null, modelName: Priority_Health_Security
)
-
priority_climate_change
(
type: esriFieldTypeSmallInteger, alias: Priority Climate Change, editable: true, nullable: true, defaultValue: null, modelName: Priority_Climate_Change
)
-
priority_essential_asset
(
type: esriFieldTypeSmallInteger, alias: Priority Essential Asset, editable: true, nullable: true, defaultValue: null, modelName: Priority_Essential_Asset
)
-
priority_high_value_asset
(
type: esriFieldTypeSmallInteger, alias: Priority High Value Asset, editable: true, nullable: true, defaultValue: null, modelName: Priority_High_Value_Asset
)
-
priority_positive_finance
(
type: esriFieldTypeSmallInteger, alias: Priority Positive Finance, editable: true, nullable: true, defaultValue: null, modelName: Priority_Positive_Finance
)
-
priority_strategic_plan
(
type: esriFieldTypeSmallInteger, alias: Priority Strategic Plan, editable: true, nullable: true, defaultValue: null, modelName: Priority_Strategic_Plan
)
-
priority_perceived_value
(
type: esriFieldTypeSmallInteger, alias: Priority Perceived Value, editable: true, nullable: true, defaultValue: null, modelName: Priority_Perceived_Value
)
-
priority_pertinence_need
(
type: esriFieldTypeSmallInteger, alias: Priority Pertinence Need, editable: true, nullable: true, defaultValue: null, modelName: Priority_Pertinence_Need
)
-
priority_final_index
(
type: esriFieldTypeSmallInteger, alias: Priority Final Index, editable: true, nullable: true, defaultValue: null, modelName: Priority_Final_Index
)
-
asset_description
(
type: esriFieldTypeString, alias: Asset Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asset_Description
)
-
replacement_cost_per_unit
(
type: esriFieldTypeDouble, alias: Replacement Cost per Unit, editable: true, nullable: true, defaultValue: null, modelName: Replacement_Cost_per_Unit
)
-
tempfield3
(
type: esriFieldTypeDouble, alias: TempField3, editable: true, nullable: true, defaultValue: null, modelName: TempField3
)
-
tempfield2
(
type: esriFieldTypeString, alias: TempField2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TempField2
)
-
fa_class_code
(
type: esriFieldTypeString, alias: FA_CLASS_CODE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FA_CLASS_CODE
)
-
fa_asset_code
(
type: esriFieldTypeString, alias: FA_ASSET_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FA_ASSET_CODE
)
-
sched_name
(
type: esriFieldTypeString, alias: SCHED_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SCHED_NAME
)
-
fa_sched_status
(
type: esriFieldTypeString, alias: FA_SCHED_STATUS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: FA_SCHED_STATUS
)
-
deprec_value
(
type: esriFieldTypeDouble, alias: DEPREC_VALUE, editable: true, nullable: true, defaultValue: null, modelName: DEPREC_VALUE
)
-
life_expectancy
(
type: esriFieldTypeInteger, alias: LIFE_EXPECTANCY, editable: true, nullable: true, defaultValue: null, modelName: LIFE_EXPECTANCY
)
-
start_date
(
type: esriFieldTypeDate, alias: START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: START_DATE
)
-
loss_in_value_year
(
type: esriFieldTypeDouble, alias: Loss in Value (This Year), editable: true, nullable: true, defaultValue: null, modelName: Loss_in_Value_Year
)
-
loss_in_value_total
(
type: esriFieldTypeDouble, alias: Loss in Value (Since Acquisition), editable: true, nullable: true, defaultValue: null, modelName: Loss_In_Value_Total
)
-
installation_year_ground
(
type: esriFieldTypeSmallInteger, alias: Installation Year (Ground), editable: true, nullable: true, defaultValue: null, modelName: Installation_Year_Ground
, Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1910: 1910]
, ...120 more...
)
-
psab_2019_comment
(
type: esriFieldTypeSmallInteger, alias: PSAB 2019 Comment, editable: true, nullable: true, defaultValue: null, modelName: PSAB_2019_Comment
, Coded Values:
[0: Unchanged]
, [1: New entity added under capital contract]
, [2: New entity added for GIS accuracy reasons (not under capital contract)]
, ...6 more...
)
-
project_name
(
type: esriFieldTypeString, alias: Project Name, editable: true, nullable: true, length: 255, defaultValue: N/A, modelName: Project_Name
)
-
project_description
(
type: esriFieldTypeString, alias: Project Description, editable: true, nullable: true, length: 255, defaultValue: N/A, modelName: Project_Description
)
-
project_start_date
(
type: esriFieldTypeDate, alias: Project Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Project_Start_Date
)
-
project_end_date
(
type: esriFieldTypeDate, alias: Project End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Project_End_Date
)
-
project_status
(
type: esriFieldTypeSmallInteger, alias: Project Status, editable: true, nullable: true, defaultValue: 0, modelName: Project_Status
, Coded Values:
[0: Not Applicable / Non Applicable]
, [1: Project Started / Projet démarré]
, [2: Project Paused / Projet en pause]
, ...1 more...
)
-
tempfield4
(
type: esriFieldTypeString, alias: TempField4, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TempField4
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user, required: true
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date, required: true
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user, required: true
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date, required: true
)
-
Shape__Length
(
type: esriFieldTypeDouble, alias: st_length(shape), editable: false, nullable: true, defaultValue: null, modelName: st_length(shape), required: true
)
Types:
ID: 101
Name: Water - Main
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
-
material:
Inherited
-
pipe_class:
Inherited
-
lateral_with_dbh:
Inherited
-
jurisdiction:
Inherited
-
tangible_capital_asset:
Inherited
-
condition_rating:
Coded Values:
[1: 1 - Very Good (80-100%)]
, [2: 2 - Good (60-79%)]
, [3: 3 - Average (40-59%)]
, ...2 more...
-
enabled:
Inherited
-
psab_2018_comments:
Inherited
-
asset_category:
Inherited
-
asset_class:
Coded Values:
[1: Building Asset]
, [2: Land Asset]
, [3: Land Improvement Asset]
, ...5 more...
-
asset_subclass:
Coded Values:
[1: Facilities - Police]
, [2: Facilities - Fire]
, [3: Facilities - Recreation]
, ...51 more...
-
condition_method:
Coded Values:
[1: Asset Age & Life Expectancy (1-5)]
, [2: Matrix 0-9 (Risk vs Propability vs Impact)]
-
asset_totally_depreciated:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
lifecycle_maintenance_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_operation_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_renewal_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_replacement_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
climate_change_risk:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
climate_change_risk_type:
Coded Values:
[0: Not Applicable]
, [1: Sea Level Rise]
, [2: Storm Surge (Quick Wave Damage)]
, ...5 more...
-
climate_change_risk_probability:
Coded Values:
[0: Not Applicable]
, [1: Low Probability]
, [2: Medium Probability]
, ...1 more...
-
climate_change_risk_impact:
Coded Values:
[0: Not Applicable]
, [1: Service Level Reduction]
, [2: Service Interuption]
, ...2 more...
-
priority_failure:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_health_security:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_climate_change:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_essential_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_high_value_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_positive_finance:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_strategic_plan:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_perceived_value:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_pertinence_need:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
Templates:
-
Name: Water - Main
Description:
Prototype:
project_end_date: null
project_status: null
tempfield4: null
asset_group: 1
asset_type: 1
asset_subtype: 101
asset_id: null
related_pid: null
closest_civic_address: null
related_civic_number: null
related_street_name: null
related_street_section: null
geolocation: null
grid_reference: null
installation_year: null
diameter: null
material: null
pipe_class: null
lateral_with_dbh: null
depth: null
ttyyppee: null
comments: null
last_maintenance_inspection_dat: null
link_to_as_built: null
link_to_ti_ins: null
feature_creator: null
creation_date: null
last_editor: null
last_edit_date: null
jurisdiction: 1
tangible_capital_asset: 1
expected_life_years: null
end_of_life_date: null
remaining_life_years: null
remaining_life_percent: null
condition_rating: null
cost_per_unit: null
asset_replacement_value: null
emergency_asset_replacement_val: null
remaining_value: null
infrastructure_deficit__backlog: null
show_when_page_name_is_not: null
psab_2016_comments: null
psab_2017_comments: null
enabled: 1
psab_2018_comments: null
tempfield: null
cost_for_length: null
asset_category: 3
related_service: null
asset_class: 7
asset_subclass: 608
asset_name: null
historical_acquisition_cost2: null
historical_acquisition_cost1: null
cost_per_unit_readjustment: null
residual_value: 0
condition_method: 1
opening_book_value: null
closing_book_value: null
asset_totally_depreciated: null
salvage_value: 0
lifecycle_maintenance_cost: null
lifecycle_maintenance_source: null
lifecycle_operation_cost: null
lifecycle_operation_source: null
lifecycle_renewal_cost: null
lifecycle_renewal_source: null
lifecycle_end_of_life_cost: null
lifecycle_replacement_cost: null
lifecycle_emgreplacement_cost: null
lifecycle_replacement_source: null
lifecycle_admin_cost: null
lifecycle_total_cost: null
lifecycle_cost_annual: null
climate_change_risk: 2
climate_change_risk_type: 0
climate_change_risk_probability: 0
climate_change_risk_impact: 0
priority_failure: 0
priority_health_security: 0
priority_climate_change: 0
priority_essential_asset: 0
priority_high_value_asset: 0
priority_positive_finance: 0
priority_strategic_plan: 0
priority_perceived_value: 0
priority_pertinence_need: 0
priority_final_index: null
asset_description: null
replacement_cost_per_unit: null
tempfield3: null
tempfield2: null
fa_class_code: null
fa_asset_code: null
sched_name: null
fa_sched_status: null
deprec_value: null
life_expectancy: null
start_date: null
loss_in_value_year: null
loss_in_value_total: null
installation_year_ground: null
psab_2019_comment: null
project_name: null
project_description: null
project_start_date: null
Drawing Tool: esriFeatureEditToolLine
ID: 102
Name: Water - Lateral
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
-
material:
Inherited
-
pipe_class:
Inherited
-
lateral_with_dbh:
Inherited
-
jurisdiction:
Inherited
-
tangible_capital_asset:
Inherited
-
condition_rating:
Coded Values:
[1: 1 - Very Good (80-100%)]
, [2: 2 - Good (60-79%)]
, [3: 3 - Average (40-59%)]
, ...2 more...
-
enabled:
Inherited
-
psab_2018_comments:
Inherited
-
asset_category:
Inherited
-
asset_class:
Coded Values:
[1: Building Asset]
, [2: Land Asset]
, [3: Land Improvement Asset]
, ...5 more...
-
asset_subclass:
Coded Values:
[1: Facilities - Police]
, [2: Facilities - Fire]
, [3: Facilities - Recreation]
, ...51 more...
-
condition_method:
Coded Values:
[1: Asset Age & Life Expectancy (1-5)]
, [2: Matrix 0-9 (Risk vs Propability vs Impact)]
-
asset_totally_depreciated:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
lifecycle_maintenance_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_operation_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_renewal_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_replacement_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
climate_change_risk:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
climate_change_risk_type:
Coded Values:
[0: Not Applicable]
, [1: Sea Level Rise]
, [2: Storm Surge (Quick Wave Damage)]
, ...5 more...
-
climate_change_risk_probability:
Coded Values:
[0: Not Applicable]
, [1: Low Probability]
, [2: Medium Probability]
, ...1 more...
-
climate_change_risk_impact:
Coded Values:
[0: Not Applicable]
, [1: Service Level Reduction]
, [2: Service Interuption]
, ...2 more...
-
priority_failure:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_health_security:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_climate_change:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_essential_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_high_value_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_positive_finance:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_strategic_plan:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_perceived_value:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_pertinence_need:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
Templates:
-
Name: Water - Lateral
Description:
Prototype:
project_end_date: null
project_status: null
tempfield4: null
asset_group: 1
asset_type: 1
asset_subtype: 102
asset_id: null
related_pid: null
closest_civic_address: null
related_civic_number: null
related_street_name: null
related_street_section: null
geolocation: null
grid_reference: null
installation_year: null
diameter: null
material: null
pipe_class: null
lateral_with_dbh: null
depth: null
ttyyppee: null
comments: null
last_maintenance_inspection_dat: null
link_to_as_built: null
link_to_ti_ins: null
feature_creator: null
creation_date: null
last_editor: null
last_edit_date: null
jurisdiction: 1
tangible_capital_asset: 2
expected_life_years: null
end_of_life_date: null
remaining_life_years: null
remaining_life_percent: null
condition_rating: null
cost_per_unit: null
asset_replacement_value: null
emergency_asset_replacement_val: null
remaining_value: null
infrastructure_deficit__backlog: null
show_when_page_name_is_not: null
psab_2016_comments: null
psab_2017_comments: null
enabled: 1
psab_2018_comments: null
tempfield: null
cost_for_length: null
asset_category: 4
related_service: null
asset_class: 7
asset_subclass: 608
asset_name: null
historical_acquisition_cost2: null
historical_acquisition_cost1: null
cost_per_unit_readjustment: null
residual_value: 0
condition_method: 1
opening_book_value: null
closing_book_value: null
asset_totally_depreciated: null
salvage_value: 0
lifecycle_maintenance_cost: null
lifecycle_maintenance_source: null
lifecycle_operation_cost: null
lifecycle_operation_source: null
lifecycle_renewal_cost: null
lifecycle_renewal_source: null
lifecycle_end_of_life_cost: null
lifecycle_replacement_cost: null
lifecycle_emgreplacement_cost: null
lifecycle_replacement_source: null
lifecycle_admin_cost: null
lifecycle_total_cost: null
lifecycle_cost_annual: null
climate_change_risk: 2
climate_change_risk_type: 0
climate_change_risk_probability: 0
climate_change_risk_impact: 0
priority_failure: 0
priority_health_security: 0
priority_climate_change: 0
priority_essential_asset: 0
priority_high_value_asset: 0
priority_positive_finance: 0
priority_strategic_plan: 0
priority_perceived_value: 0
priority_pertinence_need: 0
priority_final_index: null
asset_description: null
replacement_cost_per_unit: null
tempfield3: null
tempfield2: null
fa_class_code: null
fa_asset_code: null
sched_name: null
fa_sched_status: null
deprec_value: null
life_expectancy: null
start_date: null
loss_in_value_year: null
loss_in_value_total: null
installation_year_ground: null
psab_2019_comment: null
project_name: null
project_description: null
project_start_date: null
Drawing Tool: esriFeatureEditToolLine
ID: 105
Name: Water - Fire Hydrant - Lateral
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
-
material:
Inherited
-
pipe_class:
Inherited
-
lateral_with_dbh:
Inherited
-
jurisdiction:
Inherited
-
tangible_capital_asset:
Inherited
-
condition_rating:
Coded Values:
[1: 1 - Very Good (80-100%)]
, [2: 2 - Good (60-79%)]
, [3: 3 - Average (40-59%)]
, ...2 more...
-
enabled:
Inherited
-
psab_2018_comments:
Inherited
-
asset_category:
Inherited
-
asset_class:
Coded Values:
[1: Building Asset]
, [2: Land Asset]
, [3: Land Improvement Asset]
, ...5 more...
-
asset_subclass:
Coded Values:
[1: Facilities - Police]
, [2: Facilities - Fire]
, [3: Facilities - Recreation]
, ...51 more...
-
condition_method:
Coded Values:
[1: Asset Age & Life Expectancy (1-5)]
, [2: Matrix 0-9 (Risk vs Propability vs Impact)]
-
asset_totally_depreciated:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
lifecycle_maintenance_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_operation_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_renewal_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_replacement_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
climate_change_risk:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
climate_change_risk_type:
Coded Values:
[0: Not Applicable]
, [1: Sea Level Rise]
, [2: Storm Surge (Quick Wave Damage)]
, ...5 more...
-
climate_change_risk_probability:
Coded Values:
[0: Not Applicable]
, [1: Low Probability]
, [2: Medium Probability]
, ...1 more...
-
climate_change_risk_impact:
Coded Values:
[0: Not Applicable]
, [1: Service Level Reduction]
, [2: Service Interuption]
, ...2 more...
-
priority_failure:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_health_security:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_climate_change:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_essential_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_high_value_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_positive_finance:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_strategic_plan:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_perceived_value:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_pertinence_need:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
Templates:
-
Name: Water - Fire Hydrant - Lateral
Description:
Prototype:
project_end_date: null
project_status: null
tempfield4: null
asset_group: 1
asset_type: 1
asset_subtype: 105
asset_id: null
related_pid: null
closest_civic_address: null
related_civic_number: null
related_street_name: null
related_street_section: null
geolocation: null
grid_reference: null
installation_year: null
diameter: null
material: null
pipe_class: null
lateral_with_dbh: null
depth: null
ttyyppee: null
comments: null
last_maintenance_inspection_dat: null
link_to_as_built: null
link_to_ti_ins: null
feature_creator: null
creation_date: null
last_editor: null
last_edit_date: null
jurisdiction: 1
tangible_capital_asset: 2
expected_life_years: null
end_of_life_date: null
remaining_life_years: null
remaining_life_percent: null
condition_rating: null
cost_per_unit: null
asset_replacement_value: null
emergency_asset_replacement_val: null
remaining_value: null
infrastructure_deficit__backlog: null
show_when_page_name_is_not: null
psab_2016_comments: null
psab_2017_comments: null
enabled: 1
psab_2018_comments: null
tempfield: null
cost_for_length: null
asset_category: 4
related_service: null
asset_class: 7
asset_subclass: 608
asset_name: null
historical_acquisition_cost2: null
historical_acquisition_cost1: null
cost_per_unit_readjustment: null
residual_value: 0
condition_method: 1
opening_book_value: null
closing_book_value: null
asset_totally_depreciated: null
salvage_value: 0
lifecycle_maintenance_cost: null
lifecycle_maintenance_source: null
lifecycle_operation_cost: null
lifecycle_operation_source: null
lifecycle_renewal_cost: null
lifecycle_renewal_source: null
lifecycle_end_of_life_cost: null
lifecycle_replacement_cost: null
lifecycle_emgreplacement_cost: null
lifecycle_replacement_source: null
lifecycle_admin_cost: null
lifecycle_total_cost: null
lifecycle_cost_annual: null
climate_change_risk: 2
climate_change_risk_type: 0
climate_change_risk_probability: 0
climate_change_risk_impact: 0
priority_failure: 0
priority_health_security: 0
priority_climate_change: 0
priority_essential_asset: 0
priority_high_value_asset: 0
priority_positive_finance: 0
priority_strategic_plan: 0
priority_perceived_value: 0
priority_pertinence_need: 0
priority_final_index: null
asset_description: null
replacement_cost_per_unit: null
tempfield3: null
tempfield2: null
fa_class_code: null
fa_asset_code: null
sched_name: null
fa_sched_status: null
deprec_value: null
life_expectancy: null
start_date: null
loss_in_value_year: null
loss_in_value_total: null
installation_year_ground: null
psab_2019_comment: null
project_name: null
project_description: null
project_start_date: null
Drawing Tool: esriFeatureEditToolLine
ID: 109
Name: Water - Private Lateral
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
-
material:
Inherited
-
pipe_class:
Inherited
-
lateral_with_dbh:
Inherited
-
jurisdiction:
Inherited
-
tangible_capital_asset:
Inherited
-
condition_rating:
Coded Values:
[1: 1 - Very Good (80-100%)]
, [2: 2 - Good (60-79%)]
, [3: 3 - Average (40-59%)]
, ...2 more...
-
enabled:
Inherited
-
psab_2018_comments:
Inherited
-
asset_category:
Inherited
-
asset_class:
Coded Values:
[1: Building Asset]
, [2: Land Asset]
, [3: Land Improvement Asset]
, ...5 more...
-
asset_subclass:
Coded Values:
[1: Facilities - Police]
, [2: Facilities - Fire]
, [3: Facilities - Recreation]
, ...51 more...
-
condition_method:
Coded Values:
[1: Asset Age & Life Expectancy (1-5)]
, [2: Matrix 0-9 (Risk vs Propability vs Impact)]
-
asset_totally_depreciated:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
lifecycle_maintenance_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_operation_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_renewal_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
lifecycle_replacement_source:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Utility Operating]
, ...3 more...
-
climate_change_risk:
Coded Values:
[-1: Not Applicable]
, [0: Unknown]
, [1: Yes]
, ...1 more...
-
climate_change_risk_type:
Coded Values:
[0: Not Applicable]
, [1: Sea Level Rise]
, [2: Storm Surge (Quick Wave Damage)]
, ...5 more...
-
climate_change_risk_probability:
Coded Values:
[0: Not Applicable]
, [1: Low Probability]
, [2: Medium Probability]
, ...1 more...
-
climate_change_risk_impact:
Coded Values:
[0: Not Applicable]
, [1: Service Level Reduction]
, [2: Service Interuption]
, ...2 more...
-
priority_failure:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_health_security:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_climate_change:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_essential_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_high_value_asset:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_positive_finance:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_strategic_plan:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_perceived_value:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
-
priority_pertinence_need:
Coded Values:
[0: 0 (Not Prioritized)]
, [1: 1 (Low Priority)]
, [2: 2 (Medium Low Priority)]
, ...3 more...
Templates:
-
Name: Water - Private Lateral
Description:
Prototype:
project_end_date: null
project_status: null
tempfield4: null
asset_group: 1
asset_type: 1
asset_subtype: 109
asset_id: null
related_pid: null
closest_civic_address: null
related_civic_number: null
related_street_name: null
related_street_section: null
geolocation: null
grid_reference: null
installation_year: null
diameter: null
material: null
pipe_class: null
lateral_with_dbh: null
depth: null
ttyyppee: null
comments: null
last_maintenance_inspection_dat: null
link_to_as_built: null
link_to_ti_ins: null
feature_creator: null
creation_date: null
last_editor: null
last_edit_date: null
jurisdiction: 3
tangible_capital_asset: 2
expected_life_years: null
end_of_life_date: null
remaining_life_years: null
remaining_life_percent: null
condition_rating: null
cost_per_unit: null
asset_replacement_value: null
emergency_asset_replacement_val: null
remaining_value: null
infrastructure_deficit__backlog: null
show_when_page_name_is_not: null
psab_2016_comments: null
psab_2017_comments: null
enabled: 1
psab_2018_comments: null
tempfield: null
cost_for_length: null
asset_category: 4
related_service: null
asset_class: 7
asset_subclass: 608
asset_name: null
historical_acquisition_cost2: null
historical_acquisition_cost1: null
cost_per_unit_readjustment: null
residual_value: 0
condition_method: 1
opening_book_value: null
closing_book_value: null
asset_totally_depreciated: null
salvage_value: 0
lifecycle_maintenance_cost: null
lifecycle_maintenance_source: null
lifecycle_operation_cost: null
lifecycle_operation_source: null
lifecycle_renewal_cost: null
lifecycle_renewal_source: null
lifecycle_end_of_life_cost: null
lifecycle_replacement_cost: null
lifecycle_emgreplacement_cost: null
lifecycle_replacement_source: null
lifecycle_admin_cost: null
lifecycle_total_cost: null
lifecycle_cost_annual: null
climate_change_risk: 2
climate_change_risk_type: 0
climate_change_risk_probability: 0
climate_change_risk_impact: 0
priority_failure: 0
priority_health_security: 0
priority_climate_change: 0
priority_essential_asset: 0
priority_high_value_asset: 0
priority_positive_finance: 0
priority_strategic_plan: 0
priority_perceived_value: 0
priority_pertinence_need: 0
priority_final_index: null
asset_description: null
replacement_cost_per_unit: null
tempfield3: null
tempfield2: null
fa_class_code: null
fa_asset_code: null
sched_name: null
fa_sched_status: null
deprec_value: null
life_expectancy: null
start_date: null
loss_in_value_year: null
loss_in_value_total: null
installation_year_ground: null
psab_2019_comment: null
project_name: null
project_description: null
project_start_date: null
Drawing Tool: esriFeatureEditToolLine
Capabilities: Query,Create,Update,Delete,Uploads,Editing,ChangeTracking
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Supports OidReservation: 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: true
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Query Attachments
Apply Edits
Add Features
Update Features
Delete Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata