UW-Macrostrat / map-ingestion

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

Iglulik, NWT #516

Open rleverett opened 4 years ago

rleverett commented 4 years ago

Name: Geology, Iglulik, Victoria Island, Northwest Territories; Bédard, J H; Rainbird, R H. Geological Survey of Canada, Canadian Geoscience Map 199, (ed. prelim.), 2015, 1 sheet

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

Estimated scale: large

Folder name: nwt_iglulik

Dataset names: nwt_iglulik nwt_iglulik_lines nwt_iglulik_points

Number of bedrock polygons: 171

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: descrip

Comments field:

Comments:

Todo:

rleverett commented 4 years ago

Suggested inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,descriptio,age,descrip,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nwt_iglulik where geom is not null;
INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom) 
SELECT gid,1,feature,subfeature,new_type,ST_MakeValid(geom) FROM sources.nwt_iglulik_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,strucclass,ST_MakeValid(geom) FROM sources.nwt_iglulik_points where point_type is not null and geom is not null;
cambro commented 4 years ago

These data are not on test strata