[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 thanksItai 

[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

[johnowallter@gmail.com]

ty

[emily-lars]

One way is to use a tool like QGIS or Python (with geopandas) to extract relevant boundary information and merge it with your existing dataset. If you’re using Excel, you can try converting the GeoJSON file into CSV using an online converter, then use VLOOKUP or INDEX-MATCH to align the boundaries with your regions.

[Author]

Posts