By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,939 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,939 IT Pros & Developers. It's quick & easy.

Placing points on a map based on ZIP Code

P: n/a
I developed and maintain a database for a member-only organization. Among
other things, the main table contains a field called fldZIP, and it's pretty
obvious what's in there. The client wants to be able to print a map of a
selected geographic area, say Chicago, IL or Cook County, IL, and show on
that map the ZIP code areas and a number, super-imposed on the area, telling
how many members live in that area. So, for example, say the island of
Manhattan in New York was the area selected for study. The client would like
to select the geographic area somehow and have Access, or something feeding
off Access, print a picture of the island, define the boundaries of each ZIP
code (10001, 10017, etcetera) and in the area defined for each ZIP Code,
have a number telling how many of the members live there.

I know this may be beyond reason, but is it beyond doing? I've done the
query - this is just the next step.

Any help appreciated.
Steve E.
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I'm pretty sure I have heard other people claim that Microsoft MapPoint can be integrated
with Access to provide this type of feature. I have a copy of MapPoint, after doing a
Usability Study at Microsoft, but I haven't tried tying it into an Access database yet.

__________________________________________________ __

"Serious_Practitioner" <se******************@aat.not> wrote in message
news:Ca*********************@bgtnsc05-news.ops.worldnet.att.net...

I developed and maintain a database for a member-only organization. Among
other things, the main table contains a field called fldZIP, and it's pretty
obvious what's in there. The client wants to be able to print a map of a
selected geographic area, say Chicago, IL or Cook County, IL, and show on
that map the ZIP code areas and a number, super-imposed on the area, telling
how many members live in that area. So, for example, say the island of
Manhattan in New York was the area selected for study. The client would like
to select the geographic area somehow and have Access, or something feeding
off Access, print a picture of the island, define the boundaries of each ZIP
code (10001, 10017, etcetera) and in the area defined for each ZIP Code,
have a number telling how many of the members live there.

I know this may be beyond reason, but is it beyond doing? I've done the
query - this is just the next step.

Any help appreciated.
Steve E.

Nov 12 '05 #2

P: n/a
You'll likely need a GIS type product. Something along the lines of
ArcGIS
from ESRI. You can use Access as the data base feeding ArcGIS and it
handles all the geographic representations.

It isn't cheap to buy the production version you will need to set
things up,
so unless you see a lot of use for this type of service, you might
consider
subbing that part to somebody (email me and I can put you in touch
with
somebody good). ArcReader is the free viewer for your clients, so at
least they won't need to fork over $$$ to view the end product.
HTH

Tom Mitchell
"Tom Wickerath" <AO***********************@comcast.net> wrote in message news:<NM********************@comcast.com>...
I'm pretty sure I have heard other people claim that Microsoft MapPoint can be integrated
with Access to provide this type of feature. I have a copy of MapPoint, after doing a
Usability Study at Microsoft, but I haven't tried tying it into an Access database yet.

__________________________________________________ __

"Serious_Practitioner" <se******************@aat.not> wrote in message
news:Ca*********************@bgtnsc05-news.ops.worldnet.att.net...

I developed and maintain a database for a member-only organization. Among
other things, the main table contains a field called fldZIP, and it's pretty
obvious what's in there. The client wants to be able to print a map of a
selected geographic area, say Chicago, IL or Cook County, IL, and show on
that map the ZIP code areas and a number, super-imposed on the area, telling
how many members live in that area. So, for example, say the island of
Manhattan in New York was the area selected for study. The client would like
to select the geographic area somehow and have Access, or something feeding
off Access, print a picture of the island, define the boundaries of each ZIP
code (10001, 10017, etcetera) and in the area defined for each ZIP Code,
have a number telling how many of the members live there.

I know this may be beyond reason, but is it beyond doing? I've done the
query - this is just the next step.

Any help appreciated.
Steve E.

Nov 12 '05 #3

P: n/a
MS MapPoint will do that.

P
"Serious_Practitioner" <se******************@aat.not> wrote in message
news:Ca*********************@bgtnsc05-news.ops.worldnet.att.net...
I developed and maintain a database for a member-only organization. Among
other things, the main table contains a field called fldZIP, and it's pretty obvious what's in there. The client wants to be able to print a map of a
selected geographic area, say Chicago, IL or Cook County, IL, and show on
that map the ZIP code areas and a number, super-imposed on the area, telling how many members live in that area. So, for example, say the island of
Manhattan in New York was the area selected for study. The client would like to select the geographic area somehow and have Access, or something feeding off Access, print a picture of the island, define the boundaries of each ZIP code (10001, 10017, etcetera) and in the area defined for each ZIP Code,
have a number telling how many of the members live there.

I know this may be beyond reason, but is it beyond doing? I've done the
query - this is just the next step.

Any help appreciated.
Steve E.

Nov 12 '05 #4

P: n/a
Thank you all for your suggestions. I will try MapPoint, 'cause the price is
right, but I will save all the replies, just in case.

Steve E.

"Serious_Practitioner" <se******************@aat.not> wrote in message
news:Ca*********************@bgtnsc05-news.ops.worldnet.att.net...
I developed and maintain a database for a member-only organization. Among
other things, the main table contains a field called fldZIP, and it's pretty obvious what's in there. The client wants to be able to print a map of a
selected geographic area, say Chicago, IL or Cook County, IL, and show on
that map the ZIP code areas and a number, super-imposed on the area, telling how many members live in that area. So, for example, say the island of
Manhattan in New York was the area selected for study. The client would like to select the geographic area somehow and have Access, or something feeding off Access, print a picture of the island, define the boundaries of each ZIP code (10001, 10017, etcetera) and in the area defined for each ZIP Code,
have a number telling how many of the members live there.

I know this may be beyond reason, but is it beyond doing? I've done the
query - this is just the next step.

Any help appreciated.
Steve E.


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.