Monday, May 3, 2010


Recently started to work on Geocoding project where in there is going to be use of report builder 3.0 mapping report features. To begin with what does geocoding mean: as per wikipedia( definition:Geocoding is the process of finding associated geographic coordinates (often expressed as latitude and longitude) from other geographic data, such as street addresses, or zip codes (postal codes).  The idea here we have a list of addresses and pass it to a geocoding software, the one being used is alteryx, The software in turn produces a list of geocoded locations, these can then transferred to a spreadsheet or the out put can be directly routed to a spatial database, in this context is to use the spatial data types in sql server and receive the data, This portion is still being tested out. The issues is whether the geocoded locations can be stored as a geometry or geography data type or store the latitude,longitude as an integer. Once the geocoded locations are stored in a sql server table, this can be used for reporting purposes using report builder 3.0/SSRS.

No comments:

Post a Comment