[postgis-users] GIS Project

[Chris Hermansen]

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.