UW-Macrostrat / map-ingestion

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

Forbes, New South Wales #490

Open rleverett opened 5 years ago

rleverett commented 5 years ago

Name: Raymond O.L., Duggan M.B., Lyons P., Scott M.M., Sherwin L., Wallace D.A., Krynen J.P., Young G.C., Wyborn D, Glen R.A., Percival I.G. and Leys M., 2000, Forbes 1:250 000 Geological Sheet SI/55-07, 2nd edition, Geological Survey of New South Wales, Sydney. Geoscience Australia, Canberra

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

Estimated scale: large

Folder name: nsw_forbes_250

Dataset names: nsw_forbes_250 nsw_forbes_250_lines

Number of bedrock polygons: 3112

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: lith_desc

Comments field:

Comments:

Todo:

rleverett commented 5 years ago

Some unmapped units. Overlaps with a few 1:100k maps but mostly not. No points files in the folder

Suggested Inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,1,unitname,age,lith_desc,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nsw_forbes_250 where geom is not null;
INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom) 
SELECT gid,1,feature,name,new_type,ST_MakeValid(geom) FROM sources.nsw_forbes_250_lines where new_type is not null and geom is not null;