search

joeyklee / bec-explorer

This repository is for building an interactive data viewer for the Biogeoclimate Ecosystem Classification (BEC) zones in North America
http://www.bc-climate-explorer.org/
MIT License
11 stars 4 forks source link

Scatterplot showing a small subset of units #21

Closed cmahony closed 8 years ago

cmahony commented 8 years ago

The scatterplot is only showing about 40 of the 200+ bec units. the ones that are showing up are the units whose BGC_LABEL has no spaces. Once the primary field is changed to MAP_LABEL, this problem might go away.

cmahony commented 8 years ago

yes, the data file for the scatterplot has BEC unit codes that are based on MAP_LABEL, but the tool is using BGC_LABEL as a lookup field. once this is fixed so that all lookups are done with MAP_LABEL, then the problem with the scatterplot will go away.

joeyklee commented 8 years ago

I changed all of the bgc_label to map_label but it seems that there may be some NULL values in the data table we're using for the scatter plot (https://becexplorer.cartodb.com/tables/bgcv10beta_200m_wgs84_merge) -- could be an issue with the table merging. I will look into it.

joeyklee commented 8 years ago

Ah-hah! I now know why the scatterplot is only showing the small selected portions. It seems that the dataset with the merged climate variables is simply missing the other regions for some reason. See:

screen shot 2016-06-24 at 12 55 05 pm

We will need to resolve this by merging in the data correctly

joeyklee commented 8 years ago

This issue is now fixed with the correct data merge method - using the column join rather than spatial join in cartodb on the field "map_label" (for the geometry layer) and the "id2" (for the csv data)