N Albert Hills, NU

[rleverett]

Name: Geology, northern part of Prince Albert Greenstone Belt, Prince Albert Hills, Melville Peninsula, Nunavut; Machado, G; Corrigan, D; Nadeau, L; Rigg, J. Geological Survey of Canada, Canadian Geoscience Map 81, (ed. prelim.), 2012, 1 sheet; 1 CD-ROM

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

Estimated scale: large

Folder name: nu_prince_albert_n

Dataset names: nu_prince_albert_n nu_prince_albert_n_lines nu_prince_albert_n_points

Number of bedrock polygons: 74

Lithology field:

Time field: age

Stratigraphy name field: group/subgroup

Description field: type

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

[rleverett]

Lines have some missing parts Suggested Inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,comments,geom) 
SELECT gid,1,code,age,group.subgroup,type,late_id,early_id,ST_MakeValid(geom) FROM sources.nu_prince_albert_n where geom is not null;

INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom) 
SELECT gid,1,lin_misc,descrip,new_type,ST_MakeValid(geom) FROM sources.nu_prince_albert_n_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,azimuth,dipplunge,dip_dir,point_type,structype,ST_MakeValid(geom) FROM sources.nu_prince_albert_n_points where point_type is not null and geom is not null;