[postgis-users] PostGIS to Web Map?

Wed Aug 17 09:58:09 PDT 2011

James, Geoserver is good option for the beginner (windows user), but presently it is less powerful as compared to the UMN mapserver. Geosever could also generate the output in the Openlayers format (some basic functionality). But, if you need some extra interactivity (client side functionality) with the maps, you have to enrich the generated output with extra coding ...

Imran 

--- On Wed, 8/17/11, James David Smith <james.david.smith at gmail.com> wrote:

> From: James David Smith <james.david.smith at gmail.com>
> Subject: Re: [postgis-users] PostGIS to Web Map?
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Wednesday, August 17, 2011, 10:09 PM
> 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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 