search

CartoDB / odyssey.js

Making it easy to merge map and narrative
BSD 3-Clause "New" or "Revised" License
1.62k stars 188 forks source link

Error: Column "points_density" does not exist, showing a density map #196

Closed jorgeas80 closed 9 years ago

jorgeas80 commented 9 years ago

Created a odyssey map, loading a visualization based on a density map. Got this error:

Postgis Plugin: ERROR: column "points_density" does not exist LINE 1: ...ify("the_geom_webmercator", 6.74483e-06)) AS geom,"points_de... ^ in executeQuery Full sql was: 'SELECT ST_AsBinary(ST_Simplify("the_geom_webmercator", 6.74483e-06)) AS geom,"points_density" FROM (SELECT * FROM mallorca_points_to_heatmap) as cdbq WHERE "the_geom_webmercator" && ST_SetSRID('BOX3D(-20037508.3 20037508.29613578,-20037508.29613578 20037508.3)'::box3d, 3857)'

You can click here to see the error live

matallo commented 9 years ago

this is not an odyssey issue

does mallorca_points_to_heatmap exist in your mallorca_points_to_heatmap table?

jorgeas80 commented 9 years ago

The table mallorca_points_to_heatmap does exist, but looks like the query is trying to access a field "points_density" in that table. That field doesn't exist.