Open rleverett opened 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,main_name,use_age,descrip,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nsw_rankins where geom is not null;
INSERT INTO lines.large (orig_id,source_id,descrip,new_type,geom)
SELECT gid,1,descriptio,new_type,ST_MakeValid(geom) FROM sources.nsw_rankins_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_plunge,dip_dir,point_type,struct_sub,ST_MakeValid(geom) FROM sources.nsw_rankins_points where point_type is not null and geom is not null;
Name: Cameron R.G., Meakin N.S., Vassallo J.J. and Hendrickx M.A., 2008, Rankins Springs 1:100 000 Geological Sheet 8130, 1st edition. Geological Survey of New South Wales, Sydney
Source URL: https://search.geoscience.nsw.gov.au/product/133
Estimated scale: large
Folder name: nsw_rankins
Dataset names: nsw_rankins nsw_rankins_lines nsw_rankins_points
Number of bedrock polygons: 1016
Lithology field:
Time field: use_age
Stratigraphy name field: strat_name
Description field: descrip
Comments field:
Comments:
Todo: