Forum Discussion
Custom shape map and related data
Hi,
I am trying to display population per block in NY city with color saturation. I have a shape file (topojson) in which each bloc has a unique GEOID value.
I also have an Excel file with 2 columns GEOID and POPULATION (the topojson also bears the population value)
I am not sure about the best to do so, what i currently do is the following:
1) Load the Excel file
2) go to shape map and load the topojson
3) put the Excel GEOID in the 'location' bucket and the Excel POPULATION in the 'color saturation' bucket
For some reasons only 1/3 of the blocks on map are colored and show the population in the tooltip and i dont understand why.
I made sure geoid are both of the same format.
Am i doing something wrong?
thanks !
6 Replies
- AnonymousNot applicable
Hi Golani,
It will be help for troubleshooting if you share some detail content of your issue.
Regards,
Xiaoxin Sheng
- deldersveldResident Rockstar
How many rows are in your source Excel file and/or how many blocks are being plotted?
- GolaniRegular Visitor
Hi, i have a topojson with 33k street blocks, and the excel file has 33k rows as well
- deldersveldResident Rockstar
33k is too much for the visual to support. You might see an "i"/info icon in the top left corner that displays the message when you hover: "Too many values. Not showing all data."