Closed rleverett closed 9 months ago
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,descriptio,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.nsw_nuchea where geom is not null;
INSERT INTO lines.large (orig_id,source_id,descrip,name,new_type,geom)
SELECT gid,1,codedescpt,strucname,new_type,ST_MakeValid(geom) FROM sources.nsw_nuchea_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,strike,dip,azimuth,point_type,codedescpt,ST_MakeValid(geom) FROM sources.nsw_nuchea_points where point_type is not null and geom is not null;
Processed during the initial round of candidates processing by Kate. (map_ingestion->sources)
Name: Sharp T.R., Buckley P.M., 2015, Nuchea 1:100 000 Geological Sheet 7335, 2nd edition. Geological Survey of New South Wales, Maitland
Source URL: https://search.geoscience.nsw.gov.au/product/14
Estimated scale: large
Folder name: nsw_nuchea
Dataset names: nsw_nuchea nsw_nuchea_lines nsw_nuchea_points
Number of bedrock polygons: 1515
Lithology field:
Time field: age
Stratigraphy name field: strat_name
Description field: descriptio
Comments field:
Comments:
Todo: