[Mapserver-users] Create View with PostGis table
Vladimir Guzmán
vguzman at maintask.com
Tue Nov 11 10:03:23 PST 2003
opengis wrote:
>Howdy,
>
>I need to CREATE VIEW of PostGis table.
>
>My landusea_region table:
>Field Type
>gid int4
>polygon_id int8
>name varchar
>langcode varchar
>type varchar
>city varchar
>the_geom geometry
>
>Early I try with simple VIEW
>
>test=> CREATE VIEW only_pg_view AS SELECT * FROM landusea_region;
>test=# \dv
> List of relations
> Schema | Name | Type | Owner
>--------+------------------+------+----------
> public | only_pg_view | view | postgres
>(1 row)
>
>PostGres-PostGis work fine, but when I try to use this view in mapserver with mapfile like:
>LAYER
> NAME LandUseA_region
># DATA LandUseA_region # original shape file -- work fine
> CONNECTIONTYPE postgis
> CONNECTION "user=pg_user password=pg_passwd dbname=test host=linux_box"
># DATA "the_geom from landusea_region" # work fine
> DATA "the_geom from only_pg_land_use" # DOESNT WORK!!
> STATUS ON
> TYPE POLYGON
> LABELITEM "name"
> LABELMAXSCALE 50000
> CLASS
> TEMPLATE "land.html"
> EXPRESSION ('[type]' = 'PARK (CITY/COUNTY)' )
> NAME 'Urban park'
> COLOR 0 210 0
> LABEL
> COLOR 25 120 50
># POSITION AUTO
> END
> END
>END
>
>Ive this:
>Server error!
>The server encountered an internal error and was unable to complete your request.
>Error message:
>Premature end of script headers: mapserv
>If you think this is a server error, please contact the webmaster
>Error 500
>linux_box
>mar 11 nov 2003 17:31:31 CET
>Apache/2.0.40 (Red Hat Linux)
>
>
>
>I suppose need INSERT INTO geometry_columns table. I try to duplicate landusea_region record:
>f_table_schema f_table_name f_geometry_column coord_dimension srid type attrelid varattnum
>test landusea_region the_geom 2 -1 MULTIPOLYGON 17464 7
>in
> test only_pg_land_use the_geom 2 -1 MULTIPOLYGON 17464 7
>
>but mapserver send me same Server error!
>
>Environment
>RH9
>Mapserver4
>Postgres 7.3.2
>PostGis 0.5
>
>Any suggest, sample?
>
>Best regards
>
>P.S.
>Why I need to CREATE VIEW?
>Because Ive geo-data in PostGres-PostGis table and miscellaneous data in other tables (and other remote db).
>With a single VIEW I can map both of them.
>
>
>---
>opengis (at) libero (dot) it
>AOL: open2gis
>
>
>_______________________________________________
>Mapserver-users mailing list
>Mapserver-users at lists.gis.umn.edu
>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
>
>
Maybe the line:
DATA "the_geom from only_pg_land_use"
Must be:
DATA "the_geom from only_pg_view"
No?
--
Vladimir Ilich Guzmán R.
------------------------
http://www.maintask.com
More information about the MapServer-users
mailing list