[Talk-us] Duplicate TIGER imports

[Minh Nguyen]

On 4/14/09 5:25 PM, Dave Hansen wrote:
> On Tue, 2009-04-14 at 19:22 -0500, Chris Lawrence wrote:
>    
>> On Tue, Apr 14, 2009 at 5:41 PM, Minh Nguyen<mxn at 1ec5.org>  wrote:
>>      
>>> A few weeks after DaveHansen imported the TIGER data for Ohio [1],
>>> RSatterf reimported the data for Greene County, Ohio [2]. As a result,
>>> every single way in the county is duplicated. On top of that, RSatterf's
>>> import also added a "loose" node (not connected to any way) for every
>>> node of every way in the county. Here's an example at the
>>> Montgomery–Greene county line [3]. It's a real mess, and it looks like
>>> we just need to delete every node or way last edited by RSatterf. We
>>> should keep ways that've been edited by another user since then, because
>>> in some cases DaveHansen's motorways etc. have probably been deleted in
>>> favor of RSatterf's. So does anyone have a handy mass deletion script?
>>>        
>> It probably wouldn't be too hard to whip up something that uses the
>> extended API to query the database and generate an OSM XML file you
>> could churn through using the bulk uploader script (probably just an
>> XSLT transform of the returned XML would do it).  The only issue is
>> that you might have some shared nodes that are in-use by ways that you
>> don't want to delete.
>>      
> I used the xapi interface and I'm already running through them to clean
> out the duplicates.  Minh, I seee 27 standalone nodes of yours that
> you've fixed up.  Do you mind if we just delete these?
>
> -- Dave
>    
Be my guest. Thanks for your help!

-- 
Minh Nguyen<mxn at zoomtown.com>
AIM: trycom2000; Jabber: mxn at 1ec5.org; Blog: http://notes.1ec5.org/