[postgis-users] GIS Project

[Bradley McLain]

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.

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