Solved

MS SQL Server 2000 with Visual Basic GeoCoding

Posted on 2008-10-16
1
330 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
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…

626 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