PDA

View Full Version : Displaying areas of cities



GV1629
10-29-2009, 05:57 PM
I'm new in this forum and this kind of products. But i'm looking for a product which can quiete easily display the area of cities (territory) in Belgium (Europe) and where I can change the colour of these regions (cities) based on input from excell. I'm not interested in roads etc...
Is Mappoint the right product for this (without to many programming)?

Kind regards,

Guy

davidb
10-30-2009, 05:30 AM
Belgian boundaries built into MapPoint Europe 2009 are

- 4-digit Postcodes (around 2800)
- Municipalities (approaching 600)
- Provinces (11?)
- Regions(3)

To be able to colour cities you need to use a detailed enough geography (postcodes or municipalities) and have an excel look up table that assigns each one to a particular urban area or classify as non-urban. I attach an example map for Brussels using municipalities. To allow flexibility in colouring the cities you can then write a small piece of code (I use excel vba). For flexibility in showing/hiding roads etc you may be advised to buy MapPoint 2010 due out in January.

davidb
10-30-2009, 06:02 AM
Or, just thinking about it, you could use the freeform drawing tool to draw boundaries around the cities and colour fill these without necessarily using any code.

Winwaed
10-30-2009, 08:20 AM
And if you had the shapes as ESRI shapefiles (or MapInfo MIF files), then our "MPSuperShape" product could import them into MapPoint as shapes highlighting the required city areas. It would be quicker and more accurate than hand-drawing them.


Richard

GV1629
10-31-2009, 01:34 PM
:yes:
Belgian boundaries built into MapPoint Europe 2009 are

- 4-digit Postcodes (around 2800)
- Municipalities (approaching 600)
- Provinces (11?)
- Regions(3)

To be able to colour cities you need to use a detailed enough geography (postcodes or municipalities) and have an excel look up table that assigns each one to a particular urban area or classify as non-urban. I attach an example map for Brussels using municipalities. To allow flexibility in colouring the cities you can then write a small piece of code (I use excel vba). For flexibility in showing/hiding roads etc you may be advised to buy MapPoint 2010 due out in January.

GV1629
10-31-2009, 01:42 PM
David,
Thanks for this example of Brussels. :yes:
I want now to highlight one of the cities (in another colour than the example) and another not highlighted in the urban of Brussels (plane map) based on an input in excell.
Could you give an example of the VBA ?

Kind regards,

Guy

davidb
11-02-2009, 03:39 AM
Before getting embroiled in coding I’d advise the following.

I assume you’ve set up a lookup table in excel that assigns postcodes to city areas (preferable) or municipalities to city areas. If so I would suggest experimenting with the following to see if MapPoint can deliver what you want.

1. Set up territories. Read your data into MP in 2 columns with this format

Postcode Territory
1000 Brussels
1005 Brussels
1006 Brussels
etc
2660 Antwerp
2070 Antwerp
etc
4102 Liege
4031 Liege
etc,etc

....using Territories on the Data tab. The map will then plot territories for your classification and colours can be modified easily by right clicking on any territory name in the legend. Disadvantages are unhelpful labelling and limited colour palette.

2. Add an extra numeric classification value to each record eg 1 for Brussels, 2 Antwerp, 4 Charleroi etc, rename the Territory column eg as City Name and read in using Import Data Wizard and choose Shaded Area and Full Spectrum colour range and plot. You can can control the colours by the classification value you set for each city. Disadvantages are it's a bit tortuous and only allows a maximum of 8 classes – if you need more you need to handle your data in 2 lots, geographically.

3. Draw (or import) manual boundaries around your areas and control the colour with Fill Color, Line Color and Order.

Once you’ve decided exactly what you want, and if MP can deliver, then you can start to automate with code. You’ll find a huge number of code snippets on this site but, based on experience, you won’t find anything to do exactly what you want, so you’ll need to do some development yourself.

Anyway, hope that helps.

GV1629
11-02-2009, 02:15 PM
:rolleyes6:

Thanks David

This what I was looking for!

Guy


Before getting embroiled in coding I’d advise the following.

I assume you’ve set up a lookup table in excel that assigns postcodes to city areas (preferable) or municipalities to city areas. If so I would suggest experimenting with the following to see if MapPoint can deliver what you want.

1. Set up territories. Read your data into MP in 2 columns with this format

Postcode Territory
1000 Brussels
1005 Brussels
1006 Brussels
etc
2660 Antwerp
2070 Antwerp
etc
4102 Liege
4031 Liege
etc,etc

....using Territories on the Data tab. The map will then plot territories for your classification and colours can be modified easily by right clicking on any territory name in the legend. Disadvantages are unhelpful labelling and limited colour palette.

2. Add an extra numeric classification value to each record eg 1 for Brussels, 2 Antwerp, 4 Charleroi etc, rename the Territory column eg as City Name and read in using Import Data Wizard and choose Shaded Area and Full Spectrum colour range and plot. You can can control the colours by the classification value you set for each city. Disadvantages are it's a bit tortuous and only allows a maximum of 8 classes – if you need more you need to handle your data in 2 lots, geographically.

3. Draw (or import) manual boundaries around your areas and control the colour with Fill Color, Line Color and Order.

Once you’ve decided exactly what you want, and if MP can deliver, then you can start to automate with code. You’ll find a huge number of code snippets on this site but, based on experience, you won’t find anything to do exactly what you want, so you’ll need to do some development yourself.

Anyway, hope that helps.