Thanks for your feedback. I assume the book you are referring to is "Web Mapping Illustrated" I just happen to have that one. I have read a bit of it but hadn't got very far yet.<br><br><div><span class="gmail_quote">
On 23/11/2007, <b class="gmail_sendername">Chris Hermansen</b> <<a href="mailto:chris.hermansen@timberline.ca">chris.hermansen@timberline.ca</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Bradley, you might want to order Tyler Mitchell's book from O'Reilly. I<br>think you'll find lots of good stuff about using PostGIS together with<br>MapServer in there.<br><br>But basically you can store point geometry with attributes in PostGIS
<br>tables, and then access those through your MapServer interface. Think<br>of your search as a geometric and attribute query: I want to find all<br>the stores that sell Petrus and have more than 10 bottles in stock,<br>
within a 50Km radius of Bend, Oregon. That sort of thing. You can<br>express that as SQL which PostGIS can execute for you.<br><br>Bradley McLain wrote:<br>> Currently I am working on an Open Source GIS project and was looking
<br>> for some advice on which way to go with it.<br>><br>> What I am trying to do is use an openlayers front end which is<br>> queryable and searchable to display custom geodata (raster and vector)<br>> of our business using Google Maps as the backdrop.
<br>><br>> Currently I have Mapserver serving the custom data and OpenLayers<br>> importing and meshing it with Google maps (with some projection errors<br>> causing the maps to not line up perfect, but thats another topic for
<br>> another day).<br>><br>> I want to then hopefully use Openlayers to create a search function so<br>> users can search addresses of salespersons, growers etc and then they<br>> will be extracted from a database and the relevant data displayed.
<br>> This data needs to be easily maintainable so it can be regularly and<br>> easily be updated.<br>><br>> I have read a little about the postgreSQL database and PostGIS backend<br>> and was thinking about using this to house my salepersons etc data.
<br>> However I have no knowledge or either of these programs.<br>><br>> How do you suggest I go about this?<br>><br>> Is what I am trying to do achievable?<br>><br>> Has anything like this been done before and are there links to it?
<br>><br>> I would be very interested to hear all of your opinions on this and<br>> any tips or hints you may have.<br>><br>> Cheers<br>><br>> Brad<br>><br>><br>><br>> ------------------------------------------------------------------------
<br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br><br><br>--<br>Regards,<br><br>Chris Hermansen · mailto:<a href="mailto:clh@timberline.ca">clh@timberline.ca</a><br>tel:+1.604.714.2878 · fax:+1.604.733.0631
<br>Timberline Natural Resource Group · <a href="http://www.timberline.ca">http://www.timberline.ca</a><br>401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5<br><br>C'est ma façon de parler.<br><br>_______________________________________________
<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users
</a><br></blockquote></div><br>