Name: bc_aquatic_structures
Display Field: pscis_road_name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Min. Scale: 274003
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -2161807.31547318
YMin: 1189822.13584953
XMax: -1240401.386038
YMax: 2174336.6133976
Spatial Reference: 102009 (102009)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[65,145,40,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true
HasM: true
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)
- aggregated_crossings_id (type: esriFieldTypeString, alias: aggregated_crossings_id, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- modelled_crossing_id (type: esriFieldTypeInteger, alias: modelled_crossing_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- crossing_source (type: esriFieldTypeString, alias: crossing_source, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- crossing_feature_type (type: esriFieldTypeString, alias: crossing_feature_type, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- pscis_status (type: esriFieldTypeString, alias: pscis_status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- crossing_type_code (type: esriFieldTypeString, alias: crossing_type_code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- crossing_subtype_code (type: esriFieldTypeString, alias: crossing_subtype_code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barrier_status (type: esriFieldTypeString, alias: barrier_status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- pscis_road_name (type: esriFieldTypeString, alias: pscis_road_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- pscis_stream_name (type: esriFieldTypeString, alias: pscis_stream_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- pscis_assessment_comment (type: esriFieldTypeString, alias: pscis_assessment_comment, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- pscis_assessment_date (type: esriFieldTypeDateOnly, alias: pscis_assessment_date, SQL Type: sqlTypeOther, nullable: true, editable: true)
- transport_line_structured_name_1 (type: esriFieldTypeString, alias: transport_line_structured_name_1, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- rail_track_name (type: esriFieldTypeString, alias: rail_track_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- dam_name (type: esriFieldTypeString, alias: dam_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- dam_height (type: esriFieldTypeDouble, alias: dam_height, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dam_owner (type: esriFieldTypeString, alias: dam_owner, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- dam_use (type: esriFieldTypeString, alias: dam_use, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- dam_operating_status (type: esriFieldTypeString, alias: dam_operating_status, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- utm_zone (type: esriFieldTypeInteger, alias: utm_zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
- utm_easting (type: esriFieldTypeInteger, alias: utm_easting, SQL Type: sqlTypeOther, nullable: true, editable: true)
- utm_northing (type: esriFieldTypeInteger, alias: utm_northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
- blue_line_key (type: esriFieldTypeInteger, alias: blue_line_key, SQL Type: sqlTypeOther, nullable: true, editable: true)
- downstream_route_measure (type: esriFieldTypeDouble, alias: downstream_route_measure, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wscode (type: esriFieldTypeString, alias: wscode, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- localcode (type: esriFieldTypeString, alias: localcode, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- watershed_group_code (type: esriFieldTypeString, alias: watershed_group_code, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- gnis_stream_name (type: esriFieldTypeString, alias: gnis_stream_name, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barriers_anthropogenic_dnstr (type: esriFieldTypeString, alias: barriers_anthropogenic_dnstr, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barriers_anthropogenic_dnstr_count (type: esriFieldTypeInteger, alias: barriers_anthropogenic_dnstr_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- barriers_anthropogenic_habitat_wcrp_upstr (type: esriFieldTypeString, alias: barriers_anthropogenic_habitat_wcrp_upstr, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barriers_anthropogenic_habitat_wcrp_upstr_count (type: esriFieldTypeInteger, alias: barriers_anthropogenic_habitat_wcrp_upstr_count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- barriers_ch_cm_co_pk_sk_dnstr (type: esriFieldTypeString, alias: barriers_ch_cm_co_pk_sk_dnstr, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barriers_st_dnstr (type: esriFieldTypeString, alias: barriers_st_dnstr, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- barriers_wct_dnstr (type: esriFieldTypeString, alias: barriers_wct_dnstr, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
- ch_spawning_km (type: esriFieldTypeDouble, alias: ch_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ch_rearing_km (type: esriFieldTypeDouble, alias: ch_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ch_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: ch_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ch_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: ch_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cm_spawning_km (type: esriFieldTypeDouble, alias: cm_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- cm_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: cm_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_spawning_km (type: esriFieldTypeDouble, alias: co_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_rearing_km (type: esriFieldTypeDouble, alias: co_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_rearing_ha (type: esriFieldTypeDouble, alias: co_rearing_ha, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: co_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: co_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- co_rearing_belowupstrbarriers_ha (type: esriFieldTypeDouble, alias: co_rearing_belowupstrbarriers_ha, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pk_spawning_km (type: esriFieldTypeDouble, alias: pk_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- pk_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: pk_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_spawning_km (type: esriFieldTypeDouble, alias: sk_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_rearing_km (type: esriFieldTypeDouble, alias: sk_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_rearing_ha (type: esriFieldTypeDouble, alias: sk_rearing_ha, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: sk_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: sk_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- sk_rearing_belowupstrbarriers_ha (type: esriFieldTypeDouble, alias: sk_rearing_belowupstrbarriers_ha, SQL Type: sqlTypeOther, nullable: true, editable: true)
- st_spawning_km (type: esriFieldTypeDouble, alias: st_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- st_rearing_km (type: esriFieldTypeDouble, alias: st_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- st_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: st_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- st_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: st_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wct_spawning_km (type: esriFieldTypeDouble, alias: wct_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wct_rearing_km (type: esriFieldTypeDouble, alias: wct_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wct_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: wct_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wct_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: wct_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_spawning_km (type: esriFieldTypeDouble, alias: all_spawning_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_spawning_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: all_spawning_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_rearing_km (type: esriFieldTypeDouble, alias: all_rearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_rearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: all_rearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_spawningrearing_km (type: esriFieldTypeDouble, alias: all_spawningrearing_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- all_spawningrearing_belowupstrbarriers_km (type: esriFieldTypeDouble, alias: all_spawningrearing_belowupstrbarriers_km, SQL Type: sqlTypeOther, nullable: true, editable: true)
- set_id (type: esriFieldTypeDouble, alias: set_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
- total_hab_gain_set (type: esriFieldTypeDouble, alias: total_hab_gain_set, SQL Type: sqlTypeOther, nullable: true, editable: true)
- num_barriers_set (type: esriFieldTypeInteger, alias: num_barriers_set, SQL Type: sqlTypeOther, nullable: true, editable: true)
- avg_gain_per_barrier (type: esriFieldTypeDouble, alias: avg_gain_per_barrier, SQL Type: sqlTypeOther, nullable: true, editable: true)
- dnstr_set_ids (type: esriFieldTypeString, alias: dnstr_set_ids, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- rank_avg_gain_per_barrier (type: esriFieldTypeDouble, alias: rank_avg_gain_per_barrier, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rank_avg_gain_tiered (type: esriFieldTypeDouble, alias: rank_avg_gain_tiered, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rank_total_upstr_hab (type: esriFieldTypeDouble, alias: rank_total_upstr_hab, SQL Type: sqlTypeOther, nullable: true, editable: true)
- rank_combined (type: esriFieldTypeDouble, alias: rank_combined, SQL Type: sqlTypeOther, nullable: true, editable: true)
- tier_combined (type: esriFieldTypeString, alias: tier_combined, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
Templates:
Name: bc_aquatic_structures
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/17/2026 1:54:57 PM
Schema Last Edit Date: 4/17/2026 1:54:57 PM
Data Last Edit Date: 4/7/2026 2:29:55 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat