Maptitude - http://research.umbc.edu/~roswell/maptitude.html
Steve,
To make sure I was clear in our conversation offline, in order to join your
sales data to the correct enclosing zip:
1. Open the table with your sales data and check the zip field to see
whether it's numeric or character (if its numeric there will be no leading
zeroes in the northeast).
2. Open the attribute file for the zip point file (cczip5pt.bin) and add a
field with a name like "ZIP_ALT" as integer or character depending on what
you found in (1).
3. Highlight the field and use Edit-Fill-Formula with the following
formula(assumes sales zip field is numeric; if character, use string(zip)
and string(enclosing_zip) for the "then" and "else" clauses):
if ENCLOSING_ZIP=null then ZIP else ENCLOSING_ZIP
4. Join your sales data to the table on the "ZIP_ALT" field and run
Tools-Merge by Value on that field, aggregating sales.
5. To create a theme on sales, join the resulting merge table to the zip
boundary file. Once again, be careful to join using the proper field type
(character or numeric) so that you don't miss sales in the Northeast!
If you do this a lot for a lot of stores, ask me about a Maptitude add-in
that we wrote ($) that batch processes thematic maps on zip code sales and
saves them to acrobat files.
Regards,
Jim Stone
Geonomics, Inc.
Boston, MA
617-451-2520 x.103
----- Original Message -----
From: "Steve-Hendel" <[EMAIL PROTECTED]>
To: "'McCann, Michael J. (Mike)'" <[EMAIL PROTECTED]>
Cc: "'Maptitude List'" <[EMAIL PROTECTED]>
Sent: Monday, February 05, 2001 12:39 PM
Subject: RE: [Maptitude] Wish - Mapping Data for Enclosing Zips
> Maptitude - http://research.umbc.edu/~roswell/maptitude.html
>
> Mike,
> Point ZIP codes are used by the USPS in those cases where a building,
> facility or organization gets a ZIP code all by itself. As such, the ZIP
> code does not cover an area, but rather a point. You can find these on
the
> Zip centroid layer. To do this, add a layer to an existing map (of a
city,
> for example) and choose Cczip5pt.cdf. Then look at the dataview and
you'll
> see what I'm talking about. In the Charlotte example, you'll see that
28289
> is Southern National Bank, 28286 is Cameron Brown, and 28228 is the
General
> Mail Facility. All are point ZIPs enclosed in 28208.
> Steve
>
> -----Original Message-----
> From: McCann, Michael J. (Mike) [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 11:53 AM
> To: '[EMAIL PROTECTED]'
> Subject: FW: [Maptitude] Wish - Mapping Data for Enclosing Zips
>
>
> Steve,
>
> Quick question:
>
> A couple of quick questions:
>
> What are these other point zip codes? How can you have a zip code within
a
> zip code? Are these other zip codes just PO boxes?
> Have you verified these zips via US Post Office?
>
> Mike
>
> -----Original Message-----
> From: Steve-Hendel [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 05, 2001 11:23 AM
> To: 'Maptitude List'
> Subject: [Maptitude] Wish - Mapping Data for Enclosing Zips
>
> Maptitude - http://research.umbc.edu/~roswell/maptitude.html
> Hello to everyone. I have been a fan of Maptitude for a long time, since
it
> is cheap. powerful, and relatively easy to use. We are not yet using it
for
> any production applications here at Office Depot, but I and some others
> occasionally use it for desktop work. Other departments are using MapInfo
> and formerly Atlas GIS as they have connections with other vendors whose
> products we use.
> We often create ZIP code area maps denoting things like sales, market
> potential and market penetration. Maptitude provides some great data on
> USPS 5-digit ZIP code areas and ZIP code centroids. But you can't create
an
> area map for point data, which is what the ZIP centroids are. My wish is
> that there be a way, inside of Maptitude, to include data for enclosed
point
> ZIP codes in their enclosing ZIP areas.
> For example, in Charlotte NC, the area ZIP 28208 encloses thirteen point
> ZIPSs (28219, 28228, 28240, 28254, 28258, 28260, 28265, 28266, 28272,
28275,
> 28289, 28290, and 28296). We have sales data for each of these 14 ZIP
> codes, as that is provided by the customer address. Yet we have area data
> and demographic information only for the area ZIP 28208. Is there a way,
> without external processing, that we can specify to have point ZIP data
> mapped into the area ZIP in which the point ZIPs are enclosed? If not,
> please add it to the wish list.
> Thanks. This is a most interesting, active, and helpful list. I am happy
> to finally be able to contribute, if only a question. Maybe in the
future,
> I can help provide some answers too.
>
> Steve Hendel
> Director - Systems Development
> Office Depot
> 2200 Old Germantown Rd
> Delray Beach FL 33445-8299
> 561-438-1321
>
>
> ______________________________________________________________________
> To unsubscribe, write to [EMAIL PROTECTED]
>
>
> ______________________________________________________________________
> To unsubscribe, write to [EMAIL PROTECTED]
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
