<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>Hi all,</DIV>
<DIV> </DIV>
<DIV>Is it possible to show postgis data in openlayers?</DIV>
<DIV> </DIV>
<DIV>If yes can some body points me to some links or upload a working example to illustrate.</DIV>
<DIV> </DIV>
<DIV>A usecase can be:</DIV>
<DIV>Consider a road table (road_id, geom, road_name) in the postgre/postgis database. In SQL the select statement can be [SELECT road_id, ST_AsText(road_geom) AS geom, road_name FROM roads;] to select all the roads. Now how to give it to openlayers to show them on the map.</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>--</DIV>
<DIV>Matt</DIV></div><br>
</body></html>