Sorry, I didn't notice I had typo in the layer definition. I'm not actually
using the same point to create a line.I was looking for solutions through SQL
but unfortunately only SQL server 2012 has those builtin functions.
I think I will have to try the Ogr2ogr approach.
Thanks for all the suggestions
Date: Wed, 27 Jun 2012 07:54:44 -0700
From: [email protected]
To: [email protected]
Subject: Re: Curved Lines
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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> [hidden email]
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
If you reply to this email, your message will be added to the
discussion below:
http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066p4984263.html
To unsubscribe from Curved Lines, click here.
NAML
--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066p4984306.html
Sent from the Mapserver - User mailing list archive at Nabble.com._______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
