SW Norman Wells, NWT

[cvavrus]

Name: Fallas, K.M., MacNaughton, R.B., MacLean, B.C., and Hadlari, T., 2013. Geology, Norman Wells (southwest), Northwest Territories; Geological Survey of Canada, Canadian Geoscience Map 101, scale 1:100 000. doi:10.4095/292293

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

Estimated scale: large

Folder name: nwt_norman_sw

Dataset names: nwt_norman_sw nwt_norman_sw_lines nwt_norman_sw_points

Number of bedrock polygons: 79

Lithology field: lith_list

Time field: use_age

Stratigraphy name field: strat_name

Description field: descrip

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,lith,descrip,comments,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,map_unit,use_age,lith_list,descrip,genesis,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nwt_norman_sw where geom is not null;

INSERT INTO lines.large (orig_id,source_id,name,descrip,new_type,geom) 
SELECT gid,1,name,concat_ws('; ',subfeature,concat('location ',confidence),concat('age ',concat(max_age,'- ',min_age))),new_type,ST_MakeValid(geom) FROM sources.nwt_norman_sw_lines where new_type is not null and geom is not null;

points unclear

[cvavrus]

Drift map units in a separate .shp file

[cvavrus]

Suggested insert:

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('; ',subfeature,remarks),ST_MakeValid(geom) FROM sources.nwt_norman_sw_points where point_type is not null and geom is not null;