----- Forwarded by Philip Lesnik/General Growth Mgmt Inc/US on 08/25/2004
02:54 PM -----
Paul Green
To: Philip Lesnik/General Growth
Mgmt Inc/[EMAIL PROTECTED]
08/25/2004 02:48 cc:
PM Subject: Map Label Issue (Database
transformation?)
I have a dump from a database that I need to map with a complex label. The
database is in the schema below:
|--------+-----------+----------+----------------|
| Mall id| STORE TYPE| Store | SQ FT |
| | | NAME | |
|--------+-----------+----------+----------------|
| 1 | Supermkt | Shop Rite| 24000|
|--------+-----------+----------+----------------|
| 1 |Dept Store | Kohl's | 80000|
|--------+-----------+----------+----------------|
| 1 | Supermkt | Super | 40000|
| | | Stop & | |
| | | Shop | |
|--------+-----------+----------+----------------|
| 2 | Dept Store| Kohl's | 100000|
|--------+-----------+----------+----------------|
| 2 |Dept Store | JCPenney | 23000|
|--------+-----------+----------+----------------|
| 3 | Dept Store| JCPenney | 63000|
|--------+-----------+----------+----------------|
| 3 |Dept Store | Kohl's | 10002|
|--------+-----------+----------+----------------|
| 3 |Supermkt | Jewel | 80000|
|--------+-----------+----------+----------------|
| 3 |Dept Store | Kmart | 52310|
|--------+-----------+----------+----------------|
There is also a lat/lon in each row.
My problem is I want to plot the point, and label the point with Mall id
and ALL stores associated with that mall. As you can tell, there is no set
number of stores for each mall?one mall might have one store associated
with it, while another mall has 4 or more stores associated with it.
The first thing I thought of doing was a crosstab query in Access. There
are too many records (35,000+) to go through and make a separate column and
label each record "Store 1", "Store 2", "Store 3", etc for each mall. If I
could do that, I could perform the crosstab query in Access.
I am kind of at a loss. Do you have any suggestions?
Paul Green
Analyst
Market Research
General Growth Properties, Inc.
(312) 960-2706
-----------------------------------------
+++++++++++++++++++++++++++++++++++++++++++++++++++++++ Notice: This
e-mail including attachments) is covered by the Electronic Communications
Privacy Act, 18 U.S.C. §§ 2510-2521, is confidential and may be legally
privileged. If you are not the intended recipient, you are hereby notified
that any retention, dissemination, distribution, or copying of this
communication is strictly prohibited. Please reply to the sender that you
have received the message in error, then delete it. Thank you.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 13064
