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

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)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Lar" <(E-Mail Removed)> wrote in message news:31F5EF60-0F98-47F8-91D6-(E-Mail Removed)...
| 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

What part of the world are you in - It makes a difference depending on
how your country's post codes are set up.

Regards, John Prescott
Paymaster Systems Ltd,
e-mail: (E-Mail Removed) website <http://www.oursite.co.uk>


On Thu, 27 Jan 2005 07:43:05 -0800, Lar
<(E-Mail Removed)> wrote:

>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

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

Lar

"John Prescott" wrote:

> What part of the world are you in - It makes a difference depending on
> how your country's post codes are set up.
>
> Regards, John Prescott
> Paymaster Systems Ltd,
> e-mail: (E-Mail Removed) website <http://www.oursite.co.uk>
>
>
> On Thu, 27 Jan 2005 07:43:05 -0800, Lar
> <(E-Mail Removed)> wrote:
>
> >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
>
>

Lar, are you talking about voting or school districts?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Lar" <(E-Mail Removed)> wrote in message
news:73A7A29F-CB90-41FD-A386-(E-Mail Removed)...
> We're in the mid-west. Postal codes will not work for us - long story. Any
> other ideas?
>
> Lar
>
> "John Prescott" wrote:
>
>> What part of the world are you in - It makes a difference depending on
>> how your country's post codes are set up.
>>
>> Regards, John Prescott
>> Paymaster Systems Ltd,
>> e-mail: (E-Mail Removed) website <http://www.oursite.co.uk>
>>
>>
>> On Thu, 27 Jan 2005 07:43:05 -0800, Lar
>> <(E-Mail Removed)> wrote:
>>
>> >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
>>
>>

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: (E-Mail Removed) website <http://www.oursite.co.uk>

On Thu, 27 Jan 2005 07:43:05 -0800, Lar
<(E-Mail Removed)> wrote:

>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

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: (E-Mail Removed) website <http://www.oursite.co.uk>
>
> On Thu, 27 Jan 2005 07:43:05 -0800, Lar
> <(E-Mail Removed)> wrote:
>
> >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
>
>

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

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"Lar" <(E-Mail Removed)> wrote in message news1EFEEBF-6C37-4118-ABA1-(E-Mail Removed)...
| 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: (E-Mail Removed) website <http://www.oursite.co.uk>
| >
| > On Thu, 27 Jan 2005 07:43:05 -0800, Lar
| > <(E-Mail Removed)> wrote:
| >
| > >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
| >
| >

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: (E-Mail Removed) website <http://www.oursite.co.uk>

On Fri, 28 Jan 2005 11:59:04 -0800, Lar
<(E-Mail Removed)> wrote:

>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: (E-Mail Removed) website <http://www.oursite.co.uk>
>>
>> On Thu, 27 Jan 2005 07:43:05 -0800, Lar
>> <(E-Mail Removed)> wrote:
>>
>> >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
>>
>>