From: altinsel <altinsel@...>
Date: 2008-09-16T05:57:47+09:00
Subject: Re: ruby / rexml / xpath bug?

The funny result is the Ron Jon store in Orange, CA (second from
last)...



On Sep 15, 1:59 pm, altinsel <altin...@gmail.com> wrote:
> Thank you for your reply, Robert.  Here is the code with output and
> puts of the XML (the Stores are coming from a local database).  Does
> this help?
>
> ##CODE##
>
> require 'open-uri'
> require 'rexml/document'
>
> # Retrieve geocode information for all records in the Stores table
> task :google_geocode => :environment do
>   api_key=GOOGLE_MAPS_KEY
>
>     (Store.find :all).each do |store|
>
>       puts "\nStore: #{store.name}"
>       puts "Source Address: #{store.full_address}"
>
>       xml=open("http://maps.google.com/maps/geo?
> q=#{CGI.escape(store.full_address)}&output=xml&key=#{api_key}").read
>       doc=REXML::Document.new(xml)
>
>       puts "Status: "+doc.elements['//kml/Response/Status/code'].text
>
>       if doc.elements['//kml/Response/Status/code'].text != '200'
>         puts "Unable to parse Google response for #{store.name}"
>       else
>         puts doc
>         doc.root.each_element('//Response') do |response|
>           puts "****"
>           puts response
>           puts "****"
>           response.each_element('//Placemark') do |place|
>             # puts "****"
>             # puts place.elements['//Point'];
>             # puts "****"
>             lng,lat=place.elements['Point/
> coordinates'].text.split(',')
>             puts "  Result Address: " << place.elements['//
> address'].text
>             puts "  ID: " << place.attributes['id']
>             puts "  Latitude: #{lat}"
>             puts "  Longitude: #{lng}"
>             puts "^^^^^^^^^^^^^^^^^^^^^^^^^"
>           end # end each place
>         end # end each response
>       end # end if result == 200
>     end # end each store
>   end # end rake task
>
> ##OUTPUT##
>
> rake google_geocode
> (in /Users/acar/Documents/Design/Code/magicmaponrails)
>
> Store: The Original Ron Jon Surf Shop
> Source Address: 901 Central Avenue, Long Beach Island, NJ, 08008
> Status: 200
> <?xml version='1.0' encoding='UTF-8'?><kml xmlns='http://
> earth.google.com/kml/2.0'><Response><name>901 Central Avenue, Long
> Beach Island, NJ, 08008</name><Status><code>200</
> code><request>geocode</request></Status><Placemark
> id='p1'><address>901 Central Ave, Beach Haven, NJ 08008, USA</
> address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>NJ</
> AdministrativeAreaName><Locality><LocalityName>Beach Haven</
> LocalityName><Thoroughfare><ThoroughfareName>901 Central Ave</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>08008</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-74.107299,39.756819,0</
> coordinates></Point></Placemark></Response></kml>
> ****
> <Response><name>901 Central Avenue, Long Beach Island, NJ, 08008</
> name><Status><code>200</code><request>geocode</request></
> Status><Placemark id='p1'><address>901 Central Ave, Beach Haven, NJ
> 08008, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>NJ</
> AdministrativeAreaName><Locality><LocalityName>Beach Haven</
> LocalityName><Thoroughfare><ThoroughfareName>901 Central Ave</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>08008</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-74.107299,39.756819,0</
> coordinates></Point></Placemark></Response>
> ****
>   Result Address: 901 Central Ave, Beach Haven, NJ 08008, USA
>   ID: p1
>   Latitude: 39.756819
>   Longitude: -74.107299
> ^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Store: One of aKind Ron Jon Surf Shop
> Source Address: 4151 North Atlantic Avenue, Cocoa Beach, FL, 32931
> Status: 200
> <?xml version='1.0' encoding='UTF-8'?><kml xmlns='http://
> earth.google.com/kml/2.0'><Response><name>4151 North Atlantic Avenue,
> Cocoa Beach, FL, 32931</name><Status><code>200</code><request>geocode</
> request></Status><Placemark id='p1'><address>4151 N Atlantic Ave,
> Cocoa Beach, FL 32931, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Cocoa Beach</
> LocalityName><Thoroughfare><ThoroughfareName>4151 N Atlantic Ave</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>32931</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-80.608106,28.356747,0</
> coordinates></Point></Placemark></Response></kml>
> ****
> <Response><name>4151 North Atlantic Avenue, Cocoa Beach, FL, 32931</
> name><Status><code>200</code><request>geocode</request></
> Status><Placemark id='p1'><address>4151 N Atlantic Ave, Cocoa Beach,
> FL 32931, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Cocoa Beach</
> LocalityName><Thoroughfare><ThoroughfareName>4151 N Atlantic Ave</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>32931</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-80.608106,28.356747,0</
> coordinates></Point></Placemark></Response>
> ****
>   Result Address: 4151 N Atlantic Ave, Cocoa Beach, FL 32931, USA
>   ID: p1
>   Latitude: 28.356747
>   Longitude: -80.608106
> ^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Store: Ron Jon Surf Shop - Sunrise
> Source Address: 2610 Sawgrass Mills Circle, Sunrise, FL, 33323
> Status: 200
> <?xml version='1.0' encoding='UTF-8'?><kml xmlns='http://
> earth.google.com/kml/2.0'><Response><name>2610 Sawgrass Mills Circle,
> Sunrise, FL, 33323</name><Status><code>200</code><request>geocode</
> request></Status><Placemark id='p1'><address>2610 Sawgrass Mills Cir,
> Fort Lauderdale, FL 33323, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Fort Lauderdale</
> LocalityName><Thoroughfare><ThoroughfareName>2610 Sawgrass Mills Cir</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>33323</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-80.315710,26.154207,0</
> coordinates></Point></Placemark></Response></kml>
> ****
> <Response><name>2610 Sawgrass Mills Circle, Sunrise, FL, 33323</
> name><Status><code>200</code><request>geocode</request></
> Status><Placemark id='p1'><address>2610 Sawgrass Mills Cir, Fort
> Lauderdale, FL 33323, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Fort Lauderdale</
> LocalityName><Thoroughfare><ThoroughfareName>2610 Sawgrass Mills Cir</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>33323</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-80.315710,26.154207,0</
> coordinates></Point></Placemark></Response>
> ****
>   Result Address: 2610 Sawgrass Mills Cir, Fort Lauderdale, FL 33323,
> USA
>   ID: p1
>   Latitude: 26.154207
>   Longitude: -80.315710
> ^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Store: Ron Jon Surf Shop - Orlando
> Source Address: 5160 International Drive, Orlando, FL, 32819
> Status: 200
> <?xml version='1.0' encoding='UTF-8'?><kml xmlns='http://
> earth.google.com/kml/2.0'><Response><name>5160 International Drive,
> Orlando, FL, 32819</name><Status><code>200</code><request>geocode</
> request></Status><Placemark id='p1'><address>5160 International Dr,
> Orlando, FL 32819, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Orlando</
> LocalityName><Thoroughfare><ThoroughfareName>5160 International Dr</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>32819</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-81.450308,28.469598,0</
> coordinates></Point></Placemark></Response></kml>
> ****
> <Response><name>5160 International Drive, Orlando, FL, 32819</
> name><Status><code>200</code><request>geocode</request></
> Status><Placemark id='p1'><address>5160 International Dr, Orlando, FL
> 32819, USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Orlando</
> LocalityName><Thoroughfare><ThoroughfareName>5160 International Dr</
> ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>32819</
> PostalCodeNumber></PostalCode></Locality></AdministrativeArea></
> Country></AddressDetails><Point><coordinates>-81.450308,28.469598,0</
> coordinates></Point></Placemark></Response>
> ****
>   Result Address: 5160 International Dr, Orlando, FL 32819, USA
>   ID: p1
>   Latitude: 28.469598
>   Longitude: -81.450308
> ^^^^^^^^^^^^^^^^^^^^^^^^^
>
> Store: Ron Jon Surf Shop - Key West
> Source Address: 503 Front Street`, Key West, FL, 33040
> Status: 200
> <?xml version='1.0' encoding='UTF-8'?><kml xmlns='http://
> earth.google.com/kml/2.0'><Response><name>503 Front Street`, Key West,
> FL, 33040</name><Status><code>200</code><request>geocode</request></
> Status><Placemark id='p1'><address>503 Front St, Key West, FL 33040,
> USA</address><AddressDetails Accuracy='8'
> xmlns='urn:oasis:names:tc:ciq:xsdschema:xAL:
> 2.0'><Country><CountryNameCode>US</
> CountryNameCode><AdministrativeArea><AdministrativeAreaName>FL</
> AdministrativeAreaName><Locality><LocalityName>Key West</
> LocalityName><Thoroughfare><ThoroughfareName>503 Front St</...
>
> read more »