PostGIS – How to Display a PostGIS Table on Google Maps

Question

I am attempting to take a shape file and display it on a map:

I can do something like this:

SELECT ST_AsText((ST_Dump(the_geom)).geom) as the_geom FROM shapes;

But the problem is I still have to do a lot of parsing of the data to get it to display on a google map. Is there a way to do this easily via google's javascript api?

Answer 1

GeoJSON seems to be a good way to deliver what your asking.

"This simple demo shows mountain backdrop preservation areas. We're using the showAll parameter since there are only a handful of features and there's no sense re-fetching features with each map pan or zoom."

http://geojason.info/google-vector-layers/demos/postgis-restful-web-service-framework/