Solved

MS SQL Server 2000 with Visual Basic GeoCoding

Posted on 2008-10-16
1
297 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

861 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now