Forum Discussion

Golani's avatar
Golani
Regular Visitor
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Golani,

     

    It will be help for troubleshooting if you share some detail content of your issue.

     

    Regards,

    Xiaoxin Sheng

  • deldersveld's avatar
    deldersveld
    Resident Rockstar

    How many rows are in your source Excel file and/or how many blocks are being plotted? 

    • Golani's avatar
      Golani
      Regular Visitor

      Hi, i have a topojson with 33k street blocks, and the excel file has 33k rows as well

      • deldersveld's avatar
        deldersveld
        Resident 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."