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, [email protected] <[email protected]> wrote:

From: [email protected] <[email protected]>
Subject: Re: [postgis-users] PostGIS to Web Map?
To: "PostGIS Users Discussion" <[email protected]>
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
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to