We already have the solution, thanks for the support.
Greetings
Cristian
2009/4/21 Cristian Vera
> Walter, we only define a view crossing two tables with spatial information,
> the result of this is what we want to show in pmapper.
>
> The tables are for example: cities and countries. And we w
Walter, we only define a view crossing two tables with spatial information,
the result of this is what we want to show in pmapper.
The tables are for example: cities and countries. And we want to show all
the cities contained in one country, with the particularity that we want to
do that using a s
There's nothing special with p.mapper and PG layers. If you cannot get
it running with pure Mapserver, e.g. shp2img then it will not work
neither with p.mapper. And the question should be placed on the
Mapserver mailing list and not here.
armin
On Tue, Apr 21, 2009 at 8:23 AM, Walter Lorenzetti
Hi Cristian,
have you add your view in the geometry_columns table?
Walter
Cristian Vera ha scritto:
> Dear list,
>
> we want to load a layer from a database view, but we can't do it yet.
>
> we have the next .map file config for this
>
> LAYER
> NAME "layername"
> TYPE POINT
>
Dear list,
we want to load a layer from a database view, but we can't do it yet.
we have the next .map file config for this
LAYER
NAME "layername"
TYPE POINT
CONNECTIONTYPE POSTGIS
CONNECTION "user=* password=* dbname=* host=*"
DATA "the_geom from (select
