UW-Macrostrat / map-ingestion

Managing ingestion of sources into burwell
1 stars 1 forks source link

N Beekman Peninsula, NU #417

Open cvavrus opened 5 years ago

cvavrus commented 5 years ago

Name: Steenkamp, H.M., Gilbert, C., and St-Onge, M.R., 2016. Geology, Beekman Peninsula (north), Baffin Island, Nunavut, NTS 25-P (north) and NTS 15-M (part); Geological Survey of Canada, Canadian Geoscience Map 268 (preliminary); Canada-Nunavut Geoscience Office, Open File Map 2016-05, scale 1:100 000. doi:10.4095/297352

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

Estimated scale: large

Folder name: nu_beek_n

Dataset names: nu_beek_n nu_beek_n_lines

Number of bedrock polygons: 47

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: descrip

Comments field:

Comments: 'unmapped area' polygon present There was an error importing the points .shp file to Postico

Todo:

cvavrus commented 5 years ago

Suggested insert:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,map_unit,age,descrip,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nu_beek_n 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.nu_beek_n_lines where new_type is not null and geom is not null;