[postgis-users] PostGIS to Web Map?

[James David Smith]

Afternoon,

Thanks for all of your help on this area. For information I already do
use QGIS, but wanted to experiment with ways to display the
information from my database on a webpage/webmap. So that a) I can
change what is displayed on the map using different queries and b) as
data changes in my database, the data being shown on the map should
change.

Given what you have all said, it seems like I should try one of QGIS
Server, Geoserver or OpenGeo. Which one would be the simplest do you
think?

Also, could someone clarify the flow for me? It is  PostGIS > (one of
above) > Webpage?  Where does OpenLayers come in, or doesn't it!?

THanks again everyone. James.



On 17 August 2011 16:40, Andreas Neumann <a.neumann at carto.net> wrote:
> To explore the data I would recommend QGIS (Quantum GIS).
>
> To publish the data you can either use:
> * QGIS server
> * Geoserver
> * UMN Mapserver
>
> QGIS server has the advantage that publishing an existing QGIS desktop
> project is fast and easy. However, it only publishes WMS (not WFS).
> Geoserver has the advantage that it is not only a WMS server, but also WFS
> and data export/import. UMN is probably the fastest of all three, if speed
> is an issue, but more complex to configure.
>
> Andreas
>
> On Wed, 17 Aug 2011 08:36:48 -0700 (PDT), muhammad imran wrote:
>>
>> Agreed with Bruce, Geoeserver or Openlayers are not merely to explore
>> the data stored in PostGIS. Rather, it is about exploring a theme that
>> is interested for a certain audience. Therefore, a logical flow is,
>> conceptualize a theme, conceptualize users, accordingly design
>> database and construct conceptual schema, transform your data
>> following the conceptual schema (could be only one table), construct
>> geoserver layers, and finally enrich the visualization and
>> interactivity through GPOS (Openlayers, google maps, ....). Shortly,
>> monstrous is still in the data.
>>
>> Imran
>>
>> --- On Wed, 8/17/11, bac at brucecallander.com <bac at brucecallander.com>
>> wrote:
>>
>>> From: bac at brucecallander.com <bac at brucecallander.com>
>>> Subject: Re: [postgis-users] PostGIS to Web Map?
>>> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
>>> Date: Wednesday, August 17, 2011, 8:18 PM
>>> James - My guess is that the
>>> straightforward answer is to use Geoserver or similar.
>>> Writing the software to extract data from PostGIS and turn
>>> it into a web service seems like unnecessary pain.
>>>
>>> I have come at this from the opposite point of view. I
>>> wanted to learn more about how WMS, WFS, WCS worked and how
>>> different http request formats could be tested so installed
>>> Geoserver. But I then needed sample data in the background
>>> on which Geoserver could operate so downloaded PostGIS.
>>> Getting that up and running is turning out to be a bigger
>>> challenge than installing Geoserver.
>>>
>>> Bruce Callander
>>>
>>>
>>>
>>> On 16 Aug 2011, at 19:11, James David Smith wrote:
>>>
>>> > Dear all,
>>> >
>>> > Bit of a geneal question this rather than something
>>> specific, but I've
>>> > been following a few of the other queries on here
>>> talking about Open
>>> > Layers, Geoserver and Google Maps, and it's reminded
>>> me that I really
>>> > want to try and learn how to connect/convert my local
>>> PostGIS database
>>> > into something that renders on a webpage. I realise
>>> that this is a big
>>> > question, but wondered if anyone could give me a basic
>>> few steps as
>>> > way of pointers - and then perhaps some links to more
>>> detail where I
>>> > can go and learn how to do each step myself? I'm very
>>> happy to learn -
>>> > just not sure where to start!
>>> >
>>> > To be clear, at the moment I have a local database on
>>> my machine. I
>>> > guess really I need to move this database to an online
>>> environment and
>>> > host it somewhere? Then I need to build some webpages
>>> with a map, that
>>> > interact with the database? There's no specific
>>> project here, just
>>> > something I want to learn in my spare time as it'll be
>>> useful for the
>>> > future.
>>> >
>>> > As you can see my knowledge of how to put all this
>>> together is a bit
>>> > vague to say the least. If it helps I have basic
>>> experience of Java +
>>> > Javescript including the Google Maps API, am decent at
>>> HTML and CSS,
>>> > and am becoming familiar with PostgreSQL and PostGIS -
>>> I just don't
>>> > know how to join them all up at the moment - or where
>>> the gaps in my
>>> > knowledge are.
>>> >
>>> > Best wishes
>>> >
>>> > James
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at postgis.refractions.net
>>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> --
> --
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Switzerland
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>