Tagged Questions

0
votes
0answers
15 views

Using PostGIS to create a grid map and count points in grids [duplicate]

Possible Duplicate: How to create a regular polygon grid in PostGIS? I'm trying to divide the map of an area into 1 km x 1 km square grids and ultimately, count and retrieve how many points ...
2
votes
2answers
1k views

Problem when calculating longitude and latitude for points

I have a PostGIS database with SRID=900913 (Google Mercator) and I would like to know the latitude and longitude of points. I use this command: ST_X(ST_TRANSFORM(the_geom,4283)) Following what is ...