UW-Macrostrat / map-ingestion

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

Yantara, New South Wales #466

Open cvavrus opened 5 years ago

cvavrus commented 5 years ago

Name: Reid W.J. 2010. Yantara 1:100 000 Geological Sheet 7338, First edition. Geological Survey of New South Wales, Maitland.

Source URL: https://search.geoscience.nsw.gov.au/product/7

Estimated scale: large

Folder name: nsw_yantara

Dataset names: nsw_yantara nsw_yantara_lines nsw_yantara_points

Number of bedrock polygons: 1301

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: stratdes

Comments field:

Comments:

Todo:

cvavrus commented 5 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,display,age,stratdes,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nsw_yantara where geom is not null;
INSERT INTO lines.large (orig_id,source_id,descrip,new_type,geom) 
SELECT gid,1,codedescpt,new_type,ST_MakeValid(geom) FROM sources.nsw_yantara_lines where new_type is not null and geom is not null;

there were no points for this map