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?

score 4 · Accepted Answer · answered Mar 27 '12 at 13:59

4

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

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

answered Mar 27 '12 at 13:59

Mapperz

49,701
9
73
132

1

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

score 4 · Answer 2 · edited Nov 13 '13 at 20:57

4

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

edited Nov 13 '13 at 20:57

Paul Ramsey

19,865
1
47
57

answered Mar 28 '12 at 10:35

relet

1,459
12
19

How to display a PostGIS table on Google maps?

2 Answers2

Linked