The Data Janitorhttp://www.thedatajanitor.com
data! data! data!Wed, 04 Nov 2015 22:06:46 +0000en-UShourly1https://wordpress.org/?v=4.9.9The Neighborhood Map of U.S. Obesity and Food Deserts Available as Datahttp://www.thedatajanitor.com/?p=49
http://www.thedatajanitor.com/?p=49#respondWed, 04 Nov 2015 22:02:33 +0000http://www.thedatajanitor.com/?p=49Continue reading The Neighborhood Map of U.S. Obesity and Food Deserts Available as Data]]>RTI International released obesity data for the US at the neighborhood level in 250×250 meter grid squares. I downloaded the state files and joined them together into a single PostGIS layer.

The points were then joined to Census tracts and their values were averaged by tract.

CREATE TABLE obesity_tract AS
SELECT AVG(o.popgte20) as avg_popgte20,
AVG(o.popbmige30) AS avg_popbmige30,
AVG(o.bmivsus) as avg_bmivsus,
AVG(o.pctbmige30) as avg_octbmige30,
MAX(o.popgte20) as max_popgte20,
MAX(o.popbmige30) AS max_popbmige30,
MAX(o.bmivsus) as max_bmivsus,
MAX(o.pctbmige30) as max_octbmige30,
MIN(o.popgte20) as min_popgte20,
MIN(o.popbmige30) AS min_popbmige30,
MIN(o.bmivsus) as min_bmivsus,
MIN(o.pctbmige30) as min_octbmige30,
COUNT(*) as total_points,
t.censustract
FROM obesity_point as o, food_access_tracts as t
WHERE ST_Intersects(o.geom, t.geom)
GROUP BY t.censustract;

The tracts with the obesity data were then joined to the food desert tracts from the USDA.

]]>http://www.thedatajanitor.com/?feed=rss2&p=490USDA Food Desert data with Census tractshttp://www.thedatajanitor.com/?p=45
http://www.thedatajanitor.com/?p=45#respondThu, 15 Oct 2015 19:36:27 +0000http://www.thedatajanitor.com/?p=45Continue reading USDA Food Desert data with Census tracts]]>USDA provides data on food deserts in the US. The data is provided as an Excel spreadsheet and can be joined to Census tract Cartographic Boundary Files. A PostgresSQL dump of the table containing the food desert data joined to the Census tract geography is available for download.

]]>http://www.thedatajanitor.com/?feed=rss2&p=45020 Years of Texas Concealed Handgun License Data Availablehttp://www.thedatajanitor.com/?p=41
http://www.thedatajanitor.com/?p=41#respondWed, 01 Jul 2015 22:52:36 +0000http://www.thedatajanitor.com/?p=41I converted the pdf files at the Texas Department of Public Safety to csv files. Come and get your love.
]]>http://www.thedatajanitor.com/?feed=rss2&p=410Online desktop applicationshttp://www.thedatajanitor.com/?p=20
http://www.thedatajanitor.com/?p=20#respondMon, 20 Apr 2015 15:53:10 +0000http://www.thedatajanitor.com/?p=20Continue reading Online desktop applications]]>In a fit of Saturday morning creativity inspired by several cups of coffee, I wanted to make a weak troll of the Hillary campaign logo. However, I didn’t have Gimp installed on my computer because who wants Gimp installed on their computer?

The logo reminded me of Rimmer the hologram from Red Dwarf.

The Hillary Clinton campaign site generously provided the logo as an SVG. Which I converted on line to a PNG with a background transparency.

Again, the internet provides.

But what about Gimp, the dilettante’s answer to Photoshop? Fortunately there’s rollapp.com, that provides quite a number applications through the browser, including Gimp.

There are several options for online storage, i.e. a place for reading and writing files, including Google Drive and DropBox. I uploaded my files to DropBox, opened them in Gimp, and scaled the logo.

I placed the logo in the appropriate place, saved the file and tweeted away.

It’s amazing that I can run the full version of desktop software in browser and it’s not all running within the ecosystem of a single company <cough> oogle</cough>. Thanks @rollapp!

]]>http://www.thedatajanitor.com/?feed=rss2&p=200Public Land Ownership by Statehttp://www.thedatajanitor.com/?p=17
http://www.thedatajanitor.com/?p=17#respondWed, 18 Feb 2015 19:27:12 +0000http://www.thedatajanitor.com/?p=17I liked this map a lot and how it resizes the state to the proportion owned by the federal government.

I found the raw data in a pdf so I converted it to a Google Docs spreadsheet to make it easier to use. Get the data.

]]>http://www.thedatajanitor.com/?feed=rss2&p=170Week of 1/5/15http://www.thedatajanitor.com/?p=1
Wed, 07 Jan 2015 21:33:24 +0000http://www.thedatajanitor.com/?p=1The following items are in the lost and found.