Link to home
Start Free TrialLog in
Avatar of dkaiser2222
dkaiser2222

asked on

Storing Google GeoCoded address details

I have a lost of retail addresses that I need to get geocoded. There will be locations that drop off and new ones added every week. I have all of the locations in a SQL 2005 database. I would like to create an SSIS package that can be run to geocode the locations whn they are added. What I have done so far is to create a web service that makes an HTTP call to google and passes the XML back. The SSIS package can make the call and retrieve the XML (see below) but then can not process it. Do I need to edit the XML and remove the reverences to the xmlns to get this to work?

<?xml version="1.0" encoding="utf-8" ?>
<kml xmlns="http://earth.google.com/kml/2.0">
<Response>
<name>100 w main,louisville,ky,40202,USA</name>
<Status>
<code>200</code>
<request>geocode</request>
</Status>
<Placemark id="p1">
<address>100 W Main St, Louisville, KY 40202, USA</address>
<AddressDetails Accuracy="8" xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0">
<Country>
<CountryNameCode>US</CountryNameCode>
<AdministrativeArea>
<AdministrativeAreaName>KY</AdministrativeAreaName>
<SubAdministrativeArea>
<SubAdministrativeAreaName>Jefferson</SubAdministrativeAreaName>
<Locality>
<LocalityName>Louisville</LocalityName>
<Thoroughfare>
<ThoroughfareName>100 W Main St</ThoroughfareName>
</Thoroughfare>
<PostalCode>
<PostalCodeNumber>40202</PostalCodeNumber>
</PostalCode>
</Locality>
</SubAdministrativeArea>
</AdministrativeArea>
</Country>
</AddressDetails>
<Point>
<coordinates>-85.751558,38.256067,0</coordinates>
</Point>
</Placemark>
</Response>
</kml>


 
SOLUTION
Avatar of climbingjaffa
climbingjaffa
Flag of Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial