PDA

View Full Version : excell mapping




Aniej
Dec 16, 2006, 03:47 PM
anyone know how to show different data level displayed against a map. so if you have a city and you want to show lets say 5 neighborhoods and want to compare the support a candidate has against another candidate in each of those 5 neighborhoods could you do it? I am thinking of something where like either the area is raised or a bar chart comes out or the color is a certain color, I don't know but I am just trying to show more support or less support in different regions. Thanks.



clayj
Dec 16, 2006, 04:01 PM
Sounds like you need something like Microsoft MapPoint.

Aniej
Dec 16, 2006, 04:02 PM
Sounds like you need something like Microsoft MapPoint.

Wow, I have heard of many thing, but never that? is it part of office or what?

WildCowboy
Dec 16, 2006, 04:09 PM
Wow, I have heard of many thing, but never that? is it part of office or what?

No...it's a stand-alone app updated yearly. Windows only. North American version is $299.

More info here (http://www.microsoft.com/mappoint/default.mspx).

Aniej
Dec 16, 2006, 04:19 PM
Yeah i just checked it out and discovered it is windows only also. Wildcowboy, any ideas on what to do? It doesn't even have to be a real map, as in it can be just a 2D outline of certain political boundaries with a 3D color representation of each candidate's support? The map part really just needs to be the most basic possible for example:

cr2sh
Dec 16, 2006, 06:52 PM
The map part really just needs to be the most basic possible for example:

There might be a bit of a learning curve.. but you could do what you're asking with an open-source GIS program like GRASS (http://grass.itc.it/) or QuantumGIS (http://www.qgis.org/).

It looks to me that the map you just posted was made in arcview (guessing from the north arrow.) I'm not sure if you'd be abe to get your hands on the shapefiles (http://en.wikipedia.org/wiki/Shapefile) or not.. but that'd make the task at hand very easy.

Aniej
Dec 16, 2006, 07:23 PM
There might be a bit of a learning curve.. but you could do what you're asking with an open-source GIS program like GRASS (http://grass.itc.it/) or QuantumGIS (http://www.qgis.org/).

It looks to me that the map you just posted was made in arcview (guessing from the north arrow.) I'm not sure if you'd be abe to get your hands on the shapefiles (http://en.wikipedia.org/wiki/Shapefile) or not.. but that'd make the task at hand very easy.

beleive it or not I have ArcGIS 9, would that make this a lot easier?

cr2sh
Dec 17, 2006, 03:32 AM
beleive it or not I have ArcGIS 9, would that make this a lot easier?

I was operating under the assumptions that you were a novice and a mac user. Apparently neither of those two are true? Is the map above the one you want to change? Do you have it's data sources?

Is the data geocoded already? What does the data table look like?

If it really is as simple as 5 communities and wanting to display their political preference.. I might just grab a map from google and using photoshop replace the background colors to represent the data.

Aniej
Feb 12, 2007, 02:56 PM
I am most certainly a Mac user, but have had to resort to me Dell when working on GIS related matters, which is why I was asking about Apple specific geocoding software. I am also not a newbie.

Yes the map above is the one I was looking a changing or I might just redo it entirely myself instead of trying to get my hands on the shape files.

Any more thoughts on how to go from here?


I was operating under the assumptions that you were a novice and a mac user. Apparently neither of those two are true? Is the map above the one you want to change? Do you have it's data sources?

Is the data geocoded already? What does the data table look like?

If it really is as simple as 5 communities and wanting to display their political preference.. I might just grab a map from google and using photoshop replace the background colors to represent the data.

Mydriasis
Feb 13, 2007, 11:35 AM
If its just about drawing an image why not use illustrator, photoshop or anything that does graphs. (I dont understand much about cartography)

If you want to make something 3d quick and easy you could try quartz and make the program yourself.

Here I whipped this up in like 35min with zero lines of code. (well there is a little javascript in there but I stole that from something else i had).

I know you probably need a real program but if you like I can send you the qz file I used.

EDIT: here is a picture of what the program looks like with content.

Aniej
Feb 13, 2007, 02:59 PM
That is a great rough sketch and shows how I could further develop it into a representative graphic. I would really appreciate it if you would send me the qz files as you offered. Thanks, this is a great step in the right direction.

Mydriasis
Feb 13, 2007, 05:29 PM
Here, you can download the entire xcode project from:

http://www.zimmerfamily.de/sebastian/motion/Excel%20Mapping.html