Bug #70406 for Geo-Coder-Bing-Bulk: Row ID option?

Mon Aug 22 03:28:42 2011 barryjprice [...] gmail.com - Ticket created

Subject:	Row ID option?
Date:	Mon, 22 Aug 2011 14:28:13 +0700
To:	bug-Geo-Coder-Bing-Bulk [...] rt.cpan.org
From:	Barry Price <barryjprice [...] gmail.com>

Hi, Your module Geo::Coder::Bing::Bulk looks really useful, but with one inconvenience - the lack of ID numbers for posted data. e.g. I have a database full of addresses, each row has a unique ID. I want to send them all to Bing, and retrieve Lat/Lon coordinates. Bing will then send me back a series of results with an ID to identify each row. However, your module doesn't seem to let me send an ID with each address to be geocoded. So Bing sends me back 50,000 rows with auto-generated ID numbers (1..50000) and I have to do fuzzy address matching to figure out which co-ordinates match which row of my original data. Request: Allow the user to send a set of ID/address pairs, eg: # ============================================================ my @locations; # location values are id (int), address (string) $locations[0] = (1, '123 Some Street, Some Town, USA'); $locations[1] = (231, '456 That Street, That Town, France'); $locations[2] = (87612, '789 The Other Street, The Other Town, Australia'); my $id = $bulk->upload(\@locations); sleep 30 while $bulk->is_pending; my $data = $bulk->download; # ============================================================ Does that make sense? Thanks, Barry

Mon Aug 22 11:59:13 2011 gray [...] cpan.org - Correspondence added

On Mon Aug 22 03:28:42 2011, barryjprice@gmail.com wrote: Show quoted text

> Hi, > > Your module Geo::Coder::Bing::Bulk looks really useful, but with one > inconvenience - the lack of ID numbers for posted data. > > e.g. I have a database full of addresses, each row has a unique ID. > > I want to send them all to Bing, and retrieve Lat/Lon coordinates. > > Bing will then send me back a series of results with an ID to identify

each Show quoted text

> row. > > However, your module doesn't seem to let me send an ID with each

address to Show quoted text

> be geocoded. > > So Bing sends me back 50,000 rows with auto-generated ID numbers

(1..50000) Show quoted text

> and I have to do fuzzy address matching to figure out which co-ordinates > match which row of my original data. > > Request: Allow the user to send a set of ID/address pairs, eg: > > # ============================================================ > > my @locations; > > # location values are id (int), address (string) > $locations[0] = (1, '123 Some Street, Some Town, USA'); > $locations[1] = (231, '456 That Street, That Town, France'); > $locations[2] = (87612, '789 The Other Street, The Other Town,

Australia'); Show quoted text

> > my $id = $bulk->upload(\@locations); > sleep 30 while $bulk->is_pending; > my $data = $bulk->download; > > # ============================================================ > > Does that make sense?

the ids aren't auto-generated by Bing- upload() assigns the ID corresponding to the index into the input list. so an ID of 0 will correspond to $locations[0]. that should be sufficient, no?

Mon Aug 22 11:59:14 2011 The RT System itself - Status changed from 'new' to 'open'

Tue Aug 23 00:58:56 2011 barryjprice [...] gmail.com - Correspondence added

Subject:	Re: [rt.cpan.org #70406] Row ID option?
Date:	Tue, 23 Aug 2011 11:58:28 +0700
To:	bug-Geo-Coder-Bing-Bulk [...] rt.cpan.org
From:	Barry Price <barryjprice [...] gmail.com>

Ah, I did read the source but somehow missed that. That is indeed sufficient, thanks!

Tue Aug 23 01:01:29 2011 gray [...] cpan.org - Status changed from 'open' to 'resolved'