<div dir='ltr'>
<br>Sorry, I didn't notice I had typo in the layer definition. I'm not actually using the same point to create a line.<div>I was looking for solutions through SQL but unfortunately only SQL server 2012 has those builtin functions.</div><div><br></div><div>I think I will have to try the<span style="color: rgb(42, 42, 42); font-family: 'Segoe UI', Tahoma, Verdana, Arial, sans-serif; line-height: 17px; background-color: rgb(255, 255, 255); "> Ogr2ogr approach.</span></div><div><font color="#2a2a2a" face="Segoe UI, Tahoma, Verdana, Arial, sans-serif"><span style="line-height: 17px;"><br></span></font></div><div><font color="#2a2a2a" face="Segoe UI, Tahoma, Verdana, Arial, sans-serif"><span style="line-height: 17px;">Thanks for all the suggestions</span></font></div><div><font color="#2a2a2a" face="Segoe UI, Tahoma, Verdana, Arial, sans-serif"><span style="line-height: 17px;"><br></span></font></div><div><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">Date: Wed, 27 Jun 2012 07:54:44 -0700<br>From: <a href="/user/SendEmail.jtp?type=node&node=4984306&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a><br>To: <a href="/user/SendEmail.jtp?type=node&node=4984306&i=1" target="_top" rel="nofollow" link="external">[hidden email]</a><br>Subject: Re: Curved Lines<br><br>
Does this do what you want?
<br><br>DATA "SELECT ST_MAKELINE(ST_MAKEPOINT(Geo.STX, Geo.STY)) FROM column
<br>WHERE DATEDIFF(mi, CreatedON, CURRENT_TIMESTAMP) <='%x%'"
<br><br>There is a postGIS function MAKELINE() that aggregates points into a
<br>line. I don't know if there are equivalent function in MSSQL.
<br><br>-Steve W
<br><br>On 6/27/2012 10:33 AM, Brent Fraser wrote:
<div class="ecxshrinkable-quote"><div class='shrinkable-quote'><br>> I don't understand the question. What kind of "curved line" would you
<br>> make given only two points? And the from the SELECT statement, the two
<br>> points have the same coordinates.
<br>>
<br>> Best Regards,
<br>> Brent Fraser
<br>>
<br>> On 6/26/2012 2:43 PM, juliap wrote:
<br>>> Hi all,
<br>>>
<br>>> I have the following layer of type line :
<br>>>
<br>>> LAYER
<br>>> NAME line
<br>>> STATUS ON
<br>>> TYPE LINE
<br>>> CONNECTIONTYPE OGR
<br>>> CONNECTION "MSSQL:server=server;database=database;uid=id;pwd=pwd"
<br>>> DATA "SELECT geometry::STLineFromText('LINESTRING ('
<br>>> +CAST(Geo.STX AS VARCHAR(54))
<br>>> +' '
<br>>> +CAST(Geo.STY AS VARCHAR(54))
<br>>> +', '
<br>>> +CAST(Geo.STX AS VARCHAR(54))
<br>>> +' '
<br>>> +CAST(Geo.STY AS VARCHAR(54))
<br>>> +')'
<br>>> ,4326)
<br>>> FROM column WHERE DATEDIFF(mi, CreatedON, CURRENT_TIMESTAMP) <='%x%'"
<br>>> CLASS
<br>>> STYLE
<br>>> WIDTH 3
<br>>> SIZE 1
<br>>> COLOR 0 0 128
<br>>> END # end of style
<br>>> END # end of class
<br>>> PROJECTION
<br>>> "init=epsg:4326"
<br>>> END # end of projection
<br>>> END # end of layer
<br>>>
<br>>> I was wondering how to get a curved line from this data. I tried using
<br>>> angle
<br>>> and gap, but I don't see any changes.
<br>>> Any suggestions?
<br>>>
<br>>>
<br>>>
<br>>> --
<br>>> View this message in context:
<br>>> <a href="http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066.html" rel="nofollow" target="_blank" link="external">http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066.html</a><br>>> Sent from the Mapserver - User mailing list archive at Nabble.com.
<br>>> _______________________________________________
<br>>> mapserver-users mailing list
<br>>> <a href="http:///user/SendEmail.jtp?type=node&node=4984263&i=0" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br>>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank" link="external">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>>>
<br>>
<br>>
<br>>
<br>> _______________________________________________
<br>> mapserver-users mailing list
<br>> <a href="http:///user/SendEmail.jtp?type=node&node=4984263&i=1" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank" link="external">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></div></div><br>_______________________________________________
<br>mapserver-users mailing list
<br><a href="http:///user/SendEmail.jtp?type=node&node=4984263&i=2" rel="nofollow" target="_blank" link="external">[hidden email]</a>
<br><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="nofollow" target="_blank" link="external">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br>
<br>
<hr size="1" color="#cccccc">
<div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066p4984263.html" target="_blank" rel="nofollow" link="external">http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066p4984263.html</a>
</div>
<div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;line-height:1.5em">
To unsubscribe from Curved Lines, <a href="" target="_blank" rel="nofollow" link="external">click here</a>.<br>
<a href="http://osgeo-org.1560.n6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble:email.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble:email.naml-instant_emails%21nabble:email.naml-send_instant_email%21nabble:email.naml" rel="nofollow" style="font:9px serif" target="_blank" link="external">NAML</a>
</div></div></div> </div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.n6.nabble.com/Curved-Lines-tp4984066p4984306.html">RE: Curved Lines</a><br/>
Sent from the <a href="http://osgeo-org.1560.n6.nabble.com/Mapserver-User-f4226646.html">Mapserver - User mailing list archive</a> at Nabble.com.<br/>