Adding boundary map data manually to excel file

[lalzaril@gmail.com]

Hi guys,

Is there a way of adding boundary data to an existing excel file? I was trying to copy paste the syntax from either GeoJason file or from CODAP export data file but it didn’t work.

Attached is a subset file of my data, which includes water availability of the population according to region and year. If I could add boundary to each location it would be another nice way to demonstrate the correlation between GDP and water availability.

Many thanks

Itai

 

Attachments:

1. water-availbilty-map-data.csv

[Dan Damelin]

Hi Itai,

Do you have the GeoJSON that contains the boundary information for these regions? If so, you can load both the csv and the GeoJSON into the same CODAP document and then drag your “REGION” column onto the matching region name column in the CODAP table that has the boundary information. See these help docs for how to join tables:

https://codap.concord.org/help/work-tables/join-two-tables

https://codap.concord.org/help/work-maps/create-map-custom-boundaries

[lalzaril@gmail.com]

Dear Dan,

Thank you for you reply, indeed it will help. Just have to find the regions.

I will let you know 🙂

Itai

[Author]

Posts