automated geographical location with physical address?

L

Lar

Not sure the right venue, but here's the question.
We are a mid-sized community with 90%+ home and business internet
connectivity. Our community is divided into district, as many communities
are. I need the functionality on our webpage for a resident to input his/her
physical street address and immediately obtain information as to what
District they, the street address entered, are in. We have five district
with approx. 1100 streets, 35,000 residences. Ideas?

Lar
 
S

Stefan B Rusynko

You need a Database and Server side scripting in solution (like Access and ASP on a Windows hosted server that support them)
The database would need all of the addresses in it
- there are also commercial "postal" sites that you may want to look at (if the district is part of the postal information)




| Not sure the right venue, but here's the question.
| We are a mid-sized community with 90%+ home and business internet
| connectivity. Our community is divided into district, as many communities
| are. I need the functionality on our webpage for a resident to input his/her
| physical street address and immediately obtain information as to what
| District they, the street address entered, are in. We have five district
| with approx. 1100 streets, 35,000 residences. Ideas?
|
| Lar
 
L

Lar

We're in the mid-west. Postal codes will not work for us - long story. Any
other ideas?

Lar
 
T

Thomas A. Rowe

Lar, are you talking about voting or school districts?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
J

John Prescott

As a matter of interest, if there are only 5 districts in your
community, why do the residents not know which one they live in? Can
you not simply ask them or am I missing something?

What you are proposing is quite simply done in a SQL or Foxpro
application though it seems rather a long way round.

Regards, John Prescott
Paymaster Systems Ltd,
e-mail: [email protected] website <http://www.oursite.co.uk>
 
L

Lar

Perhaps you're missing something! I said 90%+ connected, nothing about
smarts. So how quite simply done is this? Is it something I can contract
out to do or do myself? Can I contract out the nuts and bolts then choose to
populate the data myslef?
 
S

Stefan B Rusynko

Yes you could contract it out (build the DB and interface) and then populate the DB yourself
- but 35,000 records is a lot to manually add
Search for a zip code package (for your area) that is customizable to get the base data




| Perhaps you're missing something! I said 90%+ connected, nothing about
| smarts. So how quite simply done is this? Is it something I can contract
| out to do or do myself? Can I contract out the nuts and bolts then choose to
| populate the data myslef?
|
|
| "John Prescott" wrote:
|
| > As a matter of interest, if there are only 5 districts in your
| > community, why do the residents not know which one they live in? Can
| > you not simply ask them or am I missing something?
| >
| > What you are proposing is quite simply done in a SQL or Foxpro
| > application though it seems rather a long way round.
| >
| > Regards, John Prescott
| > Paymaster Systems Ltd,
| > e-mail: [email protected] website <http://www.oursite.co.uk>
| >
| > On Thu, 27 Jan 2005 07:43:05 -0800, Lar
| >
| > >Not sure the right venue, but here's the question.
| > >We are a mid-sized community with 90%+ home and business internet
| > >connectivity. Our community is divided into district, as many communities
| > >are. I need the functionality on our webpage for a resident to input his/her
| > >physical street address and immediately obtain information as to what
| > >District they, the street address entered, are in. We have five district
| > >with approx. 1100 streets, 35,000 residences. Ideas?
| > >
| > >Lar
| >
| >
 
J

John Prescott

This is something we could write for you.

Thought would be needed as to the program design. Does one street go
across the border into another district? Are there two streets of the
same name in one or more districts? If the answer is yes to either of
these then the program would throw up a page giving the user a choice
of relevant districts to choose from where it found similar streets.
If there was only one street in the five districts, It would instead
immediatelly tell them what district the street is in.

The website would need a lookup database with all the street names
listed together with the appropriate district names. This could be
populated by you from an Excel file at the outset and from time to
time when new streets are added.

I think the above would suffice. Alternatively the lookup table can
be populated with residences with street numbers and districts.
35,000 houses is not a large lookup table to search.

Regards, John Prescott
Paymaster Systems Ltd,
e-mail: [email protected] website <http://www.oursite.co.uk>
 
Top