[Talk-us] identifying TIGER deserts

[Michal Migurski]

On Dec 20, 2012, at 11:19 AM, Michal Migurski wrote:

>> next steps
>> 
>> A few obvious steps stand out, including rendering a national version of these maps. I'd also love to figure out whether it makes sense to join forces with Mike Migurski's Green Means Go map.
>> 
>> It'd also be interesting to use a smarter Osmosis command (and the full history file) to limit the input data to just those ways created by the 3 primary user accounts associated with the TIGER import:https://github.com/MapQuest/TIGER-Edited-map/blob/master/inc/layer-tiger.xml.inc#L45 (h/t Migurski)
> 
> Joining forces would be fun!
> 
> For the past two days, I've been processing the Full History file into a form that's easier to cope with for a big categorization run. I want to look at the individual nodes, using their associated changesets to pick up on non-import edits that fell through the cracks when I looked only at OSM ways.
> 
> Here's where I'm at now:
> 	http://www.openstreetmap.us/~migurski/TIGER-Raster/nodes/


I've updated the page above with a preliminary rendering showing non-TIGER node density, preview and full GeoTIFF here:

	http://www.openstreetmap.us/~migurski/TIGER-Raster/nodes/non-tiger-uids.jpg
	http://www.openstreetmap.us/~migurski/TIGER-Raster/nodes/out-full-history-uids-no.tif.bz2

I'm processing the full history planet file a second time now, paying attention to just the nodes that make up ways with highway tags, since I'm noticing a lot of large non-road imports in this dataset.

Also, what's the deal with the Massachusetts TIGER import? When did it happen? The state is conspicuously missing when I use the Mapquest TIGER edits case statement:

                    (case when osm_uid = '7168' -- DaveHansenTiger
                                and osm_timestamp::timestamp >= '2007-08-03'::timestamp
                                and osm_timestamp::timestamp <= '2008-05-04'::timestamp
                              then 0
                          when osm_uid = '15169' -- Milenko
                                and osm_timestamp::timestamp >= '2007-10-29'::timestamp
                                and osm_timestamp::timestamp <= '2007-12-12'::timestamp
                              then 0
                          when osm_uid = '20587' -- balrog-kun
                                and osm_timestamp::timestamp >= '2010-03-21'::timestamp
                                and osm_timestamp::timestamp <= '2010-04-08'::timestamp
                                and osm_version::int < 3 -- maybe someone else edited between import and name expansion
                              then 0
                          else 1 end) as is_touched

(Github currently dead but it's from https://github.com/MapQuest/TIGER-Edited-map/blob/master/inc/layer-tiger.xml.inc)

-mike.

----------------------------------------------------------------
michal migurski- contact info and pgp key:
sf/ca            http://mike.teczno.com/contact.html