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?
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.