MaptimeNYC's favorite SQL statements for CartoDB

MaptimeNYC recently hosted an event at CartoDB's New York office, bringing together mappers from across the city to share ideas and build community around mapping. The group showcased a skill or technique presented by a fellow mapper, then transitioned into problem-solving working sessions that tackled various aspects of developing and mapping technologies. The session featured part 2 of a series on SQL using PostGIS, providing handy queries for connecting dots with lines, finding points within geographic areas, and visualizing differences in data. These queries utilize functions such as ST_Makeline, ST_Contains, CDB_LatLng, and lag(). The event aimed to create a safe space for mappers to experiment, make mistakes, and learn from each other's experiences.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.