Wonnaminta, New South Wales

[rleverett]

Name: Mills K.G., Hicks M. G. & Cooper I.B. 2015. Wonnaminta 1:100 000 Geological Sheet 7336, 2nd Edition. Geological Survey of NSW

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

Estimated scale: large

Folder name: nsw_wonnaminta

Dataset names: nsw_wonnaminta nsw_wonnaminta_lines nsw_wonnaminta_points

Number of bedrock polygons: 2239

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: descriptio

Comments field:

Comments:

Todo:

• [x] Insert new source record
• [x] Add data to database
• [x] Process and add to homogenized tables
• [x] Process and import lines
• [ ] Process and import points
• [x] Match
• [x] Roll tiles

[rleverett]

Suggested Inserts:

INSERT INTO maps.large (orig_id,source_id,name,age,descrip,strat_name,t_interval,b_interval,geom) 
SELECT gid,288,unitname,age,descriptio,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nsw_wonnaminta where geom is not null;

INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom) 
SELECT gid, 288,surface1,surface2,surface3,strucname,new_type,ST_MakeValid(geom) FROM sources.nsw_wonnaminta_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, 288,strike,dip,azimuth,point_type,codedescpt,ST_MakeValid(geom) FROM sources.nsw_wonnaminta_points where point_type is not null and geom is not null;

[cambro]

points not added due to inconsistent strike/azimuth. source_id 288 https://dev.macrostrat.org/burwell#10/-30.75/142.25