Solved

MS SQL Server 2000 with Visual Basic GeoCoding

Posted on 2008-10-16
1
309 Views
Last Modified: 2013-11-15
I have a database of 192K addresses in a MS SQL Server 2000 database.  I need to find a way to build a package or software to automate the geocoding the the addresses currently and then also any new addresses.

Can anyone suggest a place to start?
0
Comment
Question by:pda4me
1 Comment
 
LVL 18

Accepted Solution

by:
mdougan earned 500 total points
ID: 22731085
Well, you can try to build the geocoding software yourself.  There are geocode databases such as the Tiger database that I think the Post Office sells.  But, this would be a major undertaking.

Alternatively, there are service providers who will geocode addresses for you, for a fee.  Once you have an account with them, you can write code to submit addresses for geocoding, then receive them back and update your database.

We used this company, though, I don't see references to geocoding on their home page...

https://www.wizenterprise.com/default.aspx

0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question