Kluachesi Lake, BC

[cvavrus]

Name: Fallas, K.M., and MacNaughton, R.B., 2003: A GIS dataset of geological features for the Kluachesi Lake map area (94G/13), Peace River District, British Columbia; Geological Survey of Canada, Open File 1796.

Source URL: https://doi.org/10.4095/214641

Estimated scale: large

Folder name: bc_kluachesi

Dataset names: bc_kluachesi bc_kluachesi_lines bc_kluachesi_points

Number of bedrock polygons: 169

Lithology field:

Time field: use_age

Stratigraphy name field: strat_name

Description field:

Comments field:

Comments:

Todo:

• [ ] Insert new source record
• [ ] Add data to database
• [ ] Process and add to homogenized tables
• [ ] Process and import lines
• [ ] Process and import points
• [ ] Match
• [ ] Roll tiles

[cvavrus]

Suggested inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,formation,use_age,gen_descr,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.bc_kluachesi where geom is not null;

INSERT INTO lines.large (orig_id,source_id,descrip,new_type,geom) 
SELECT gid,1,descrip,new_type,ST_MakeValid(geom) FROM sources.bc_kluachesi_lines where new_type is not null and geom is not null;

INSERT INTO points.points (orig_id,source_id,strike,dip,dip_dir,point_type,comments,geom) 
SELECT gid,1,strike,dip,dip_dir,point_type,concat_ws('; ',concat('lithology ',lithology),comment),ST_MakeValid(geom) FROM sources.bc_kluachesi_points where point_type is not null and geom is not null;

[cambro]

This source also has a messed up latitudinal position. projects into the equatorial Pacific Ocean