Jump to content

 
Photo

Normalize for choropleth

- - - - -

  • Please log in to reply
3 replies to this topic

#1
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,301 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

Hi,

 

I have a little conundrum regarding the normalization for a choropleth map. I am working with the LandMatrix database of landgrabbing deals for a client.

Working with the data for the target ("victim") countries in the developing world was not so difficult, and there I normalized it as % area in deals as ratio of agricultural land (a figure I pulled out of the WorldBank statistics database).

...but for the investor ("buyer") countries, I find it more difficult. I think the client would like to highlight the big bad guys (China, US, Saudiarabia etc). I have data as area figures (sqkm) under contracts, per country. I tried to normalize it by population (e.g. area/capita in the investor countries), but that gives some results that I doubt that the client is interested in (Luxembourg and Finland are towards the top). Another thing I was thinking of is normalize it by GDP, but I have a feeling that will give results similar to population...

 

Any other tips on how I should normalize this? I think the client would prefer it if I used absolute values...


Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#2
hasecbinusr

hasecbinusr

    Contributor

  • Validated Member
  • PipPip
  • 14 posts
  • Gender:Male
  • United States

I'm assuming a percent of worldwide total wouldn't yield what you're looking for?



#3
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,301 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

I threw out the question on Twitter, and I got a good response from Kenneth Field (ESRI) - I have been a bit too locked in on the idea of having it as a choropleth - I should go with proportional symbols instead!


Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#4
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,301 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

I'm assuming a percent of worldwide total wouldn't yield what you're looking for?

That wouldn't normalize it, would it - it would just be change of scale.

 

For the record - for the target countries, I just realized that I can't calculate by agricultural land, I have to calculate out of total land area - some of the deals are non agricultural (e.g. forest).


Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->