<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>Thanks, Steve for your reply.</DIV>
<DIV><BR>Ok if your are talking about a mapping server, than lets put it this way. I have installed and configured GeoServer and using the postgis option available in it, the layers are published. Now using WMS or WFS services, layers are requested and shown on the map.</DIV>
<DIV> </DIV>
<DIV>Some question arises:</DIV>
<DIV> </DIV>
<DIV>(1) What is the benefit of using PostGIS then? Where the use of postgis can benefit me? These layers can be easily published in the same way through shape files and shown on the map. OR may be I misunderstood it.</DIV>
<DIV> </DIV>
<DIV>(3) About searching: suppose there is a textbox on the page through which the user can search and zoom to a specified feature. (Relating to my example, suppose user enters the name of a road). How this can be achieved. Would the postgis or geoserver sort this problem out?</DIV>
<DIV> </DIV>
<DIV>(4) If there are multiple layers (For e.g roads, cities, train stations, schools, etc). How can the functionality of searching through a single textbox be implemented.</DIV>
<DIV> </DIV>
<DIV>(5) How one can perform some spatial analysis and show it on the web? (e.g. A user wants to view major roads with in 5km radius reference to his home)</DIV>
<DIV> </DIV>
<DIV>I have seen question/topic related to these issues on the forum, but unfortunately no satisfactory answer was given.</DIV>
<DIV> </DIV>
<DIV>What are your suggestions?</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>--</DIV>
<DIV>Matt</DIV>
<DIV> </DIV>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 13px"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Stephen Woodbridge <woodbri@swoodbridge.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> George Matt <georgematt99@yahoo.co.uk><BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> users@openlayers.org<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Sat, 24 July, 2010 19:19:10<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [OpenLayers-Users] How to display PostGIS data through Openlayers and JSP<BR></FONT><BR>George Matt wrote:<BR>> Hi all,<BR>> Is it possible to show postgis data in openlayers?<BR>> If yes can some body points me to some links or upload a working example to illustrate.<BR>> A usecase can be:<BR>> 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.<BR><BR><BR>George,<BR><BR>You need some application on the server side like:<BR><BR>- mapserver that can connect to the database and render a map image. There are other application that can do this, some in java if you prefer.<BR><BR>- or you can do the query on the servlet and format the results into GML or GeoJSON, but this in only viable if you have under 1000 features that you are rendering at any give time. And 1000 might be pushhing the limit depending on the browser performance and memory.<BR><BR>-Steve W<BR></DIV></DIV></div><br>
</body></html>