PostGIS
3 posts
-
Where to put a polygon's label
Centroid, point on surface, or a point you already store. How MapSocket generates label points for polygon layers, and when to pick each one.
-
Country lookups in under a millisecond
Every location update needs a country and state. A plain point-in-polygon query took 450 ms. Subdividing the boundaries brought it to about one.
-
Dynamic vector tiles straight from PostGIS
Why we built MapSocket, and how a row change in your database becomes a fresh tile on every open map within seconds.