Archive for March, 2011

Postgis: Convert X,Y Points into Geometries

Monday, March 28th, 2011

Easy way to convert x/y (or latitude/longitude) tables into postgis geometries: update cities set the_geom = ST_MakePoint(city_latitude, city_longitude);

The Size of China

Thursday, March 17th, 2011

China is huge – in ppopulation, in GDP. Compare its provinces to other countries. Amazing!