[mapserver-users] Curved Lines

[juliap]

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: ml-node+s1560n4984263h65 at n6.nabble.com
To: japr94 at hotmail.com
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120627/ebac58fe/attachment.html>