UW-Macrostrat / map-ingestion

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

Hope, Indiana #513

Open rleverett opened 4 years ago

rleverett commented 4 years ago

Name: Loope, H. M., 2015, Preliminary map showing Quaternary geology of the Hope 7.5-minute quadrangle, Indiana: Indiana Geological Survey Open-File Study 15-06, scale 1:24,000.

Source URL: Data: https://iu.app.box.com/s/v8rost5qi6eaet93xofamxnq5bzmzjru Publication: https://igws.indiana.edu/bookstore/details.cfm?Pub_Num=OFS15-06

Estimated scale: large

Folder name: Hope

Dataset names: in_hope

Number of bedrock polygons: 102

Lithology field:

Time field: age

Stratigraphy name field: strat_name

Description field: unitdescri

Comments field:

Comments:

Todo:

rleverett commented 4 years ago

I'm not sure what to do with the polygons labeled "X". There's nothing labeled "X" on the map and there are 1 more labels on the published map than there are in the files and "X" has no clear correlation to any of the labels on the map.

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,unitdescri,strat_name,late_id,early_id,ST_MakeValid(geom) FROM sources.in_hope where geom is not null;