[mapserver-users] Curved Lines

[Stephen Woodbridge]

Does this do what you want?

DATA "SELECT ST_MAKELINE(ST_MAKEPOINT(Geo.STX, Geo.STY)) FROM column 
WHERE DATEDIFF(mi, CreatedON, CURRENT_TIMESTAMP) <='%x%'"

There is a postGIS function MAKELINE() that aggregates points into a 
line. I don't know if there are equivalent function in MSSQL.

-Steve W

On 6/27/2012 10:33 AM, Brent Fraser wrote:
> I don't understand the question.  What kind of "curved line" would you
> make given only two points?  And the from the SELECT statement, the two
> points have the same coordinates.
>
> Best Regards,
> Brent Fraser
>
> On 6/26/2012 2:43 PM, juliap wrote:
>> Hi all,
>>
>> I have the following layer of type line :
>>
>> LAYER
>>     NAME line
>>     STATUS ON
>>     TYPE LINE
>>     CONNECTIONTYPE OGR
>>     CONNECTION "MSSQL:server=server;database=database;uid=id;pwd=pwd"
>>     DATA "SELECT geometry::STLineFromText('LINESTRING ('
>>           +CAST(Geo.STX AS VARCHAR(54))
>>           +' '
>>               +CAST(Geo.STY AS VARCHAR(54))
>>           +', '
>>           +CAST(Geo.STX AS VARCHAR(54))
>>           +' '
>>           +CAST(Geo.STY AS VARCHAR(54))
>>           +')'
>>           ,4326)
>>     FROM column WHERE DATEDIFF(mi, CreatedON, CURRENT_TIMESTAMP) <='%x%'"
>>     CLASS
>>     STYLE
>>             WIDTH 3
>>             SIZE 1
>>             COLOR 0 0 128
>>     END # end of style
>>     END # end of class
>>     PROJECTION
>>         "init=epsg:4326"
>>     END # end of projection
>> END # end of layer
>>
>> I was wondering how to get a curved line from this data. I tried using
>> angle
>> and gap, but I don't see any changes.
>> Any suggestions?
>>
>>
>>
>> --
>> View this message in context:
>> http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066.html
>> Sent from the Mapserver - User mailing list archive at Nabble.com.
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users