Company
Date Published
Author
CARTO Contributors
Word count
1133
Language
English
Hacker News points
None

Summary

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.