[Mapserver-users] bug postgis query alias

[strk]

On Tue, Jun 01, 2004 at 07:08:59AM -0500, Vladimir Guzmán wrote:
> The line 33 is just the draw method:
> 
> $mapa = $map->draw();

That tells me nothing...
I'm afraid the bug is in php-mapscript or mapserver itself.
--strk;

> 
> -- 
> Vladimir Ilich Guzmán R.
> ------------------------
> http://maintask.com
> 
> strk wrote:
> 
> >On Tue, Jun 01, 2004 at 06:56:45AM -0500, Vladimir Guzmán wrote:
> > 
> >
> >>Yes, the query runs fine in the pgsql monitor:
> >>gps=> select gid,'>' as sentido,tiempo,360-rumbo+90 as 
> >>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-31 
> >>05:00:00' and tiempo<='2004-06-02 04:59:59';
> >>gid  | sentido |       tiempo        | rumbo | velocidad |            
> >>gps_geom             |   oid
> >>-------+---------+---------------------+-------+-----------+---------------------------------+---------
> >>46275 | >       | 2004-05-31 15:16:09 |   450 |         0 | 
> >>SRID=1;POINT(-74.06318 4.67302) | 7731018
> >>46276 | >       | 2004-05-31 15:16:15 |   450 |         0 | 
> >>SRID=1;POINT(-74.06318 4.67302) | 7731019
> >>46277 | >       | 2004-05-31 15:16:21 |   450 |         0 | 
> >>SRID=1;POINT(-74.06319 4.67301) | 7731020
> >>...
> >>...
> >>
> >>The error is just:
> >>
> >>*Warning*:  MapServer Error in msDrawMap(): Failed to draw layer named 
> >>'puntosgps'.
> >>in */usr/local/apache/htdocs/gps/index.phtml* on line *33*
> >>   
> >>
> >
> >Ooh.. I see.. php involved!
> >There are lot's of auto handling of special chars with php...
> >Showing that line '33' would also be useful.
> >
> >--strk;
> >
> >
> > 
> >
> >>Vladimir Ilich Guzmán R.
> >>------------------------
> >>http://maintask.com 
> >>
> >>
> >>
> >>strk wrote:
> >>
> >>   
> >>
> >>>On Mon, May 31, 2004 at 03:29:45PM -0500, Vladimir Guzmán wrote:
> >>>
> >>>
> >>>     
> >>>
> >>>>Hello.
> >>>>I'm implementing a gps tracking system.
> >>>>I want to show the car's orientation like this:
> >>>>http://maintask.com/test.png
> >>>>The layer's data is something like this:
> >>>>-----------------------------
> >>>>gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as 
> >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 
> >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid 
> >>>>using srid=1
> >>>>-----------------------------
> >>>>The field 'sentido' contains '>'.
> >>>>
> >>>>The problem is that if I use something like this:
> >>>>-----------------------------
> >>>>gps_geom from (select gid,'>' as sentido,tiempo,360-rumbo+90 as 
> >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 
> >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid 
> >>>>using srid=1
> >>>>-----------------------------
> >>>>The query doesn't work.
> >>>>
> >>>>So I had to create a column in potgres called 'sentido' and all the 
> >>>>rows containing '>'.
> >>>>
> >>>>Is this a bug?
> >>>> 
> >>>>
> >>>>       
> >>>>
> >>>What's the error message ?
> >>>Can you run the query from the pgsql monitor ?
> >>>--strk;
> >>>
> >>>
> >>>
> >>>     
> >>>
> >>>>The rest of the layer:
> >>>>
> >>>>LAYER
> >>>>NAME "puntosgps"
> >>>>CONNECTIONTYPE postgis
> >>>>CONNECTION "user=gps password=gps dbname=gps host=localhost"
> >>>>DATA "gps_geom from (select gid,sentido,tiempo,360-rumbo+90 as 
> >>>>rumbo,velocidad,gps_geom,oid from gps_vehi where tiempo>='2004-05-29 
> >>>>05:00:00' and tiempo<='2004-05-30 04:59:59') as foo using unique gid 
> >>>>using srid=1"
> >>>>TYPE POINT
> >>>>PROJECTION
> >>>>"proj=latlong"
> >>>>"datum=WGS84"
> >>>>END
> >>>>LABELANGLEITEM 'rumbo'
> >>>>LABELITEM 'sentido'
> >>>>CLASS
> >>>>NAME 'Parado'
> >>>>EXPRESSION ([velocidad] = 0)
> >>>>SIZE 14
> >>>>SYMBOL 'circle'
> >>>>COLOR 0 0 215
> >>>>OUTLINECOLOR 204 204 204
> >>>>END
> >>>>CLASS
> >>>>NAME '0-10'
> >>>>EXPRESSION ([velocidad] > 0 AND[velocidad] <= 10)
> >>>>SIZE 14
> >>>>SYMBOL 'circle'
> >>>>COLOR 255 255 204
> >>>>OUTLINECOLOR 204 204 204
> >>>>LABEL
> >>>>  TYPE TRUETYPE
> >>>>  FORCE TRUE
> >>>>  FONT arial
> >>>>  ANTIALIAS TRUE
> >>>>  COLOR 0 0 0
> >>>>  OUTLINECOLOR 255 255 255
> >>>>  SIZE 8
> >>>>END
> >>>>END
> >>>>...
> >>>>...
> >>>>
> >>>>Thanks a lot.
> >>>>
> >>>>-- 
> >>>>Vladimir Ilich Guzmán R.
> >>>>------------------------
> >>>>http://maintask.com 
> >>>>
> >>>>
> >>>>_______________________________________________
> >>>>Mapserver-users mailing list
> >>>>Mapserver-users at lists.gis.umn.edu
> >>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >>>> 
> >>>>
> >>>>       
> >>>>
> >>>_______________________________________________
> >>>Mapserver-users mailing list
> >>>Mapserver-users at lists.gis.umn.edu
> >>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >>>
> >>>
> >>>
> >>>
> >>>     
> >>>
> >
> >
> > 
> >