PostGIS multiple table query

david techer davidtecher at YAHOO.FR
Tue Oct 25 08:21:21 PDT 2005


If U try without giving 'users':

DATA "location from (select cars.location, cars.date from
cars where cars.id = users.id) as myquery using unique location
using srid = -1"

Can U tell us what mapserver told u as message in "declare asbinay(....)" before error's message?

--david;
-------------------------------------------------
Jean David TECHER
e-mail: davidtecher(at)yahoo(dot)fr
site: http://techer.pascal.free.fr/postgis/
-------------------------------------------------



Edward Nuttall a écrit :

>Dear all,
>
>I am trying to get a PostGIS Layer working, the following layer works fine:
>
>
>      LAYER
>             NAME "my_layer"
>             TYPE POINT
>             STATUS ON
>             CONNECTIONTYPE POSTGIS
>             CONNECTION "dbname=my_db user=me host=localhost port=5432"
>
>             DATA "location from (select cars.location, cars.date from
>cars) as myquery using unique location using srid = -1"
>
>              TEMPLATE "/home/qgis/mariss/image_info.html"
>
>              CLASS
>                     NAME "My Layer"
>                     OUTLINECOLOR 0 0 0
>                     COLOR 220 220 0
>                     SIZE 7
>                     SYMBOL "circle"
>              END
>              PROJECTION
>                     "+proj=latlong"
>              END
>
>              METADATA
>                     WMS_TIMEEXTENT "2005-02-05/2009-10-01"
>                     WMS_TIMEITEM "date"
>              END
>
>     END
>
>
>However, when I extend the Query to included another table, as shown below:
>
>
>      LAYER
>             NAME "my_layer"
>             TYPE POINT
>             STATUS ON
>             CONNECTIONTYPE POSTGIS
>             CONNECTION "dbname=my_db user=me host=localhost port=5432"
>
>             DATA "location from (select cars.location, cars.date from
>cars, users where cars.id = users.id) as myquery using unique location
>using srid = -1"
>
>             TEMPLATE "/home/qgis/mariss/image_info.html"
>
>             CLASS
>                     NAME "My Layer"
>                     OUTLINECOLOR 0 0 0
>                     COLOR 220 220 0
>                     SIZE 7
>                     SYMBOL "circle"
>             END
>
>             PROJECTION
>                     "+proj=latlong"
>             END
>
>             METADATA
>                     WMS_TIMEEXTENT "2005-02-05/2009-10-01"
>                     WMS_TIMEITEM "date"
>             END
>
>     END
>
>
>
>I get the following error:
>
>"Postgresql reports the error as 'ERROR: find_srid() - couldnt find the
>corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS
>table?"
>
>All geometry columns in all the tables are 'working' as layers in the
>mapfile and have been registered in the GEOMETRY_COLUMNS table, also the
>select query does return a result set. I can see there is some SRID error,
>and this is where I get confused, when I've added my geometry columns I
>have always used -1, indeed anywhere SRID pops up I have just used -1.
>
>Any help would be much appreciated,
>
>Thanks
>Ed
>
>  
>

	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com



More information about the MapServer-users mailing list