<div dir="ltr">HI Spencer,<div><br></div><div>Another thought is to get these boundaries out of OHM directly. We do have them in OHM as shown here:</div><div><a href="https://www.openhistoricalmap.org/#map=4/40.55/-96.37&layers=O&date=1890&daterange=1,2021">https://www.openhistoricalmap.org/#map=4/40.55/-96.37&layers=O&date=1890&daterange=1,2021</a><br></div><div><br></div><div>And we are running Overpass, so it is possible to query just for admin_level=4 from the bbox of the continental US with a link like this (slow to load since it is a log of data:</div><div><a href="https://openhistoricalmap.github.io/overpass-turbo/?Q=relation%0A%20%20%5Badmin_level%3D4%5D%0A%20%20(%7B%7Bbbox%7D%7D)%3B%0A(._%3B%3E%3B)%3B%0Aout%3B&C=38.099983;-82.263291;4">https://openhistoricalmap.github.io/overpass-turbo/?Q=relation%0A%20%20%5Badmin_level%3D4%5D%0A%20%20(%7B%7Bbbox%7D%7D)%3B%0A(._%3B%3E%3B)%3B%0Aout%3B&C=38.099983;-82.263291;4</a><br></div><div><br></div><div>For me that generated a 250MB file that took forever to load into QGIS, but then I could filter it there, though it's a bit painful. If you have a SHP of the other states at that point, you could also query just for the territories in what is now Oklahoma. Would take some googling of how basic Overpass queries work. </div><div><br></div><div>For a simple choropleth map. Nico's approach might be easier!</div><div><br></div><div>There might be a way to write an Overpass query to filter by start_date and end_date using < and >, but I'm not very good at writing Overpass queries, so I'm not sure how to do that, since I think the values are treated as strings and not dates.</div><div><br></div><div>Dan</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Sep 7, 2021 at 4:40 PM Nico Tripcevich <<a href="mailto:ntripcevich@gmail.com">ntripcevich@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>If you can find a shapefile showing the modern 50 states you could save out a copy and edit your copy using the QGIS vector editing tools.</div><div>Perhaps this shapefile? It should be public domain from <a href="http://data.gov" target="_blank">data.gov</a></div><div><a href="https://catalog.data.gov/dataset/tiger-line-shapefile-2017-nation-u-s-current-state-and-equivalent-national" target="_blank">https://catalog.data.gov/dataset/tiger-line-shapefile-2017-nation-u-s-current-state-and-equivalent-national</a></div><div><br></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Sep 7, 2021 at 10:20 AM Spencer Graves <<a href="mailto:spencer.graves@effectivedefense.org" target="_blank">spencer.graves@effectivedefense.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello:<br>
<br>
<br>
Thanks for the reply.<br>
<br>
<br>
How can I get shapefiles to match the US as of 1890-05-31, so I can <br>
add numbers or colors or shading to represent the percent of deaths due <br>
to malaria in each of the 50 "states and territories"?<br>
<br>
<br>
Thanks,<br>
Spencer Graves<br>
<br>
<br>
On 9/7/21 8:07 AM, ntripcevich wrote:<br>
> Something like this QGIS Chloropleth tutorial<br>
> <a href="https://m.youtube.com/watch?v=ttW9ptW7Y74" rel="noreferrer" target="_blank">https://m.youtube.com/watch?v=ttW9ptW7Y74</a><br>
> <br>
> -------- Original message --------<br>
> From: Spencer Graves <<a href="mailto:spencer.graves@effectivedefense.org" target="_blank">spencer.graves@effectivedefense.org</a>><br>
> Date: 9/7/21 2:07 AM (GMT-08:00)<br>
> To: <a href="mailto:historic@openstreetmap.org" target="_blank">historic@openstreetmap.org</a><br>
> Subject: [OHM] map for 1890 US Census<br>
> <br>
> Hello:<br>
> <br>
> <br>
> What do you suggest I do to plot data from the 1990 US Census on a map?<br>
> <br>
> <br>
> I have data on the percent of deaths due to malaria in each of 50<br>
> "states and territories" from the 1890 census, "during the census year<br>
> ended May 31, 1890".[1] It's essentially a modern map of the contiguous<br>
> 48 with two differences: (1) Oklahoma is split in two with roughly the<br>
> southeastern 40 percent being "Indian territory" and the rest labeled,<br>
> "Oklahoma".[2] (2) The District of Columbia is counted separately.<br>
> <br>
> <br>
> Thanks,<br>
> Spencer Graves<br>
> <br>
> <br>
> [1] The percentages range from 0.2 to 10.6, which I computed from raw<br>
> counts of total deaths and deaths from malaria given in Tables 4 and 5,<br>
> on pages numbered 16 - 425, which give deaths "from each specified<br>
> disease and class of diseases, with the distinction of age and sex,<br>
> during the census year ending May 31, 1890" in John S. Billings, M.D.<br>
> (1894) Report on the Vital and Social Statistics in the United States at<br>
> the Eleventh Census: 1890. Part III. -- Statistics of Deaths<br>
> (Washington, D.C., Government Printing Office).<br>
> <br>
> <br>
> [2] There are Wikipedia articles on "Indian Territory" and "Oklahoma<br>
> territory". The boundaries of the two seem to have been specified in<br>
> "The Oklahoma organic act of 1890", 1890-05-02. They were later merged<br>
> by "Oklahoma statehood", 1907-11-16.<br>
> <br>
> <br>
> _______________________________________________<br>
> Historic mailing list<br>
> <a href="mailto:Historic@openstreetmap.org" target="_blank">Historic@openstreetmap.org</a><br>
> <a href="https://lists.openstreetmap.org/listinfo/historic" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/historic</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><div dir="ltr"><div><div dir="ltr"><div>----------------------------<br>Nicholas Tripcevich<br><a href="mailto:nico@mapaspects.org" target="_blank">n</a><a href="mailto:tripcevich@gmail.com" target="_blank">tripcevich@gmail.com</a></div><div>510.926.9412</div></div></div></div></div>
_______________________________________________<br>
Historic mailing list<br>
<a href="mailto:Historic@openstreetmap.org" target="_blank">Historic@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/historic" rel="noreferrer" target="_blank">https://lists.openstreetmap.org/listinfo/historic</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><b><span style="font-size:12.8px">Dan Rademacher, </span><span style="font-size:12.8px">Executive Director</span></b></div><div><div style="font-size:12.8px"><a href="mailto:dan@greeninfo.org" target="_blank">dan@greeninfo.org</a> </div><div style="font-size:12.8px"><span style="font-size:12.8px">Office: (510) 350-8700 x310. </span><span style="font-size:12.8px">Mobile: (510) 928-7799</span></div></div><div><span style="font-size:12.8px">GreenInfo Network - Information and Mapping in the Public Interest</span><br></div><div>2201 Broadway, Suite M5, Oakland CA 94612</div><div>Pronouns: he/him</div><div><br></div><div><a href="http://www.greeninfo.org/" style="font-size:12.8px" target="_blank">www.GreenInfo.org</a><br></div><div>Twitter: @greeninfo, @danrademacher</div><div><a href="http://instagram.com/greeninfonetwork" target="_blank">instagram.com/greeninfonetwork</a></div><div>Subscribe to MapLines, our e-newsletter, at <a href="http://www.GreenInfo.org" target="_blank">www.GreenInfo.org</a></div><div><br></div></div></div></div></div></div></div></div></div></div></div></div>