Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 3 down vote accepted

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


share|improve this answer
I agree - the ST_AsGeoJSONfunction is what you can use for this. –  djq Mar 27 '12 at 16:34

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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