![\"University_of_California_Seal.svg\"](\"http:\/\/blog.light42.com\/wordpress\/wp-content\/uploads\/2012\/11\/University_of_California_Seal.svg_.png\")
<\/p>\n<\/p>\n
I took a short course on the US Census<\/strong> at the University of California, Berkeley D-Lab<\/a> recently. Of course, the first topic was the shutdown<\/a> of census.gov. People using the convenient, interactive Census API have been left without access to census data. <\/p>\n Two hours of condensed lecture was just enough time to cover the basics of the breadth of the Census, and the Instructor Dr. Jon Stiles<\/a> did an expert job.<\/p>\n Following up on some leads from the class, I looked into “points of interest in the 2013 Census data versus OpenStreetMap.” The Census includes a table called pointlm<\/strong>. In the case of California, the file I looked at is called tl_2013_06_pointlm.shp<\/em>. It is a simple layout, with the state code, an ANSI code, point ID, fullname and something called mtfcc. Rather than dig through 1000 pages of census docs, on a site that is out of service, I found this table <\/a>, which has an easy to read format and a pointer to the definitions. A quick summary in SQL shows: I used a tool called imposm<\/a> (ignoring the latest-latest new version 3.0 and using the 2.x I was familiar with..) and imported<\/a> a dump of OpenStreetMap California ‘latest’ to postgresql. <\/p>\n After seeing some of the other counts in the 2013 Census pointlm classes, I quickly became more interested in the OSM dataset for further refinements.<\/p>\n Important Links<\/em> <\/p>\n","protected":false},"excerpt":{"rendered":" I took a short course on the US Census at the University of California, Berkeley D-Lab recently. Of course, the first topic was the shutdown of census.gov. People using the convenient, interactive Census API have been left without access to census data. Two hours of condensed lecture was just enough time to cover the basics […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1426"}],"collection":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1426"}],"version-history":[{"count":12,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1426\/revisions"}],"predecessor-version":[{"id":1470,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1426\/revisions\/1470"}],"wp:attachment":[{"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1426"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.light42.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\nUS Census<\/strong><\/p>\n\r\nCensus 2013 pointlm California\r\n Definition | count\r\n--------------------------------------------------\r\n...\r\n\"Hospital\/Hospice\/Urgent Care Facility\" | 292\r\n\"School or Academy\" | 3547\r\n...\r\n<\/pre>\n
\nOpenStreetMap<\/strong><\/p>\n\r\nOpenStreetMap California latest-snapshot\r\n Definition | count\r\n--------------------------------------------------\r\n...\r\nhospital | 829\r\nschool | 9201\r\n...\r\n\r\n<\/pre>\n
\n—
\nucdata.berkeley.edu<\/a>
\nMABLE\/Geocorr12<\/a>
\nImport “ACS2012 1 Year” to PostgreSQL script<\/a>
\nTGRSHP2013_TechDoc.pdf<\/a><\/p>\n