[Mapserver-users] bug postgis query alias

[Vladimir Guzmán]

The line 33 is just the draw method:

$mapa = $map->draw();

-- 
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
>>>
>>>
>>>
>>>
>>>      
>>>
>
>
>  
>