Tips & Tricks

CartoDB

Simplify

Use PostGIS' simplify function to simplify complex geometries in your database. This is especially helpful at lower zoom levels where high numbers of vertices aren't necessary.

the_geom

When performing spatial functions like the simplify example above, be sure that the geometry returned is always in a field named the_geom. This is the field name that is necessary to create GeoJSON (what Leaflet Vector Layers uses for geometry).