<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>RE: [mapserver-users] how to create symbol on the START and END of aline</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Hi Ludwig<BR>
Today I do this, I create a layer with the line and then create another layer with the points (start and end) using SQL.<BR>
But I would do this without need to create 2 layers using the same SQL causing decrease the rendering time.<BR>
<BR>
<BR>
Any other Idea?<BR>
<BR>
<BR>
Thx<BR>
Juan<BR>
<BR>
-----Original Message-----<BR>
From: Ludwig Kniprath [<A HREF="mailto:ludwig@kni-online.de">mailto:ludwig@kni-online.de</A>]<BR>
Sent: Tue 3/29/2011 4:57 PM<BR>
To: mapserver-users@lists.osgeo.org<BR>
Cc: mapserver-users-request@lists.osgeo.org; Juan Carlos Monestel<BR>
Subject: Re: [mapserver-users] how to create symbol on the START and END of aline<BR>
<BR>
Hi,<BR>
perhaps a workaround for your problem:<BR>
If you use database-driven-layers, f. e. postgis, you can create two<BR>
spatial queries that return the start- end endpoints of your lines<BR>
(postgis-functions ST_StartPoint and ST_EndPoint), each of them for a<BR>
new point-layer for start and end-symbolization.<BR>
<BR>
hth<BR>
Ludwig<BR>
<BR>
<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>