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?

2 Answers 2


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

enter image description here

"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."


  • 1
    I agree - the ST_AsGeoJSONfunction is what you can use for this.
    – djq
    Mar 27, 2012 at 16:34

There is also a simple option, http://postgis.net/docs/ST_AsKML.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.