Working with Spatial Data Part I – Geocoding Text-Based Spatial Data for Use In SSIS Packages


Execution:

The  development of our sample package is now complete. Add a data viewer between the Script transformation and the Multicast Transformation. Execute the package, and you should see the result as shown in the below screenshot. You can see the latitude and longitude values of the corresponding records we had in our “Address” table. If you used  some addresses that the Geocode webservice was not able to locate, no values would be returned for the latitude and longitude.



Keep in mind  that this code is not designed for geocoding huge batches of address information. Mappoint is more suited for the this purpose which allows you to  upload a batch and then have mappoint perform the geocoding and return  the geocoded data.
 

Summary:

Firstly We create some test data which contained location / address in textual format. We then subscribed to the Bing Maps webservices, and created a proxy class for Geocode webservice. Then, we created a package which reads this data, made a call to the Geocode function of Geocode webservice and retrieved the latitude and longitude information returned by the webservice.
 

Pages: 1 2 3




Related Articles :

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |