Finding which points from dataset within specified boundary using CartoDB?

Question

I'm a non-coder using Cartodb. I've uploaded a dataset that has longitudinal and latitudinal coordinates, and overlayed that with a map with neighborhood boundaries. Is there a way to easily compare (or sort) these two layers? I want to be able to quickly find out which locations reside inside a certain area, without having to look at the visualization and figure it out manually. Thoughts?

Answer 1

You can use SQL to combine your two datasets like you are requesting. CartoDB has a tutorial on how to do this.

The basics of it are that you find whether a point is in a polygon... if so, you can select attributes from either data set to create a new table from. Once you have a new table, you can configure the visualization style (choropleth, category, etc.), infowindows, and more based on the new attributes in the combined table.

You can see this in the following query:

SELECT 
  table_1.the_geom, 
  table_1.iso_code, 
  count(*) as count
FROM 
  table_1
JOIN 
  table_2
 ON 
   ST_Intersects(table_1.the_geom, table_2.the_geom)
GROUP BY 
   table_1.the_geom, 
   table_1.iso_code

In your case, it seems that you want the polygons instead of the points, but want information from your points to be listed in the select statement.