Grasmere, New South Wales

[rleverett]

Name: Buckley P.M., Senior B.R & Senior D.A., 2015. Grasmere 1:100 000 Geological Sheet 7435, 2nd edition. Geological Survey of New South Wales, Maitland.

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

Estimated scale: large

Folder name: nsw_grasmere

Dataset names: nsw_grasmere nsw_grasmere_lines nsw_grasmere_points

Number of bedrock polygons: 2185

Lithology field:

Time field:

Stratigraphy name field:

Description field: descriptio

Comments field:

Comments:

Todo:

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

[rleverett]

Suggested Inserts:

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

INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom) 
SELECT gid,1,codedescpt,descrip,new_type,ST_MakeValid(geom) FROM sources.nsw_grasmere_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,dip,dip_dir,point_type,codedescpt,ST_MakeValid(geom) FROM sources.nsw_grasmere_points where point_type is not null and geom is not null;