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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
