<div dir="ltr">Hi Lars,<div><br></div><div>I want to create a styling for each placemark in .map file. Means If i have a KML containing one folder with multiple placemarks as shown below. I want to create a .map file which will contain style for each placemark.</div><div>What if i have the same names of placemarks. Please help me to get the solution</div><div><br></div><div>Eg.</div><div><br></div><div>KML</div><div>----------------</div><div><br></div><div><div><Folder></div><div><span class="" style="white-space:pre"> </span><name>NE Third Route</name></div><div><span class="" style="white-space:pre"> </span><Folder></div><div><span class="" style="white-space:pre"> </span><name>Fibertech solution</name></div><div><span class="" style="white-space:pre"> </span><Placemark></div><div><span class="" style="white-space:pre"> </span><name>Westborough MSC - Build</name></div><div><span class="" style="white-space:pre"> </span><styleUrl>#msn_ylw-pushpin4</styleUrl></div><div><span class="" style="white-space:pre"> </span><LineString></div><div><span class="" style="white-space:pre"> </span><tessellate>1</tessellate></div><div><span class="" style="white-space:pre"> </span><coordinates></div><div><span class="" style="white-space:pre"> </span>-71.58570500983306,42.28745742866225,0 -71.58563778135751,42.28308954118536,0 -71.58466087108053,42.28307704913402,0 </div><div><span class="" style="white-space:pre"> </span></coordinates></div><div><span class="" style="white-space:pre"> </span></LineString></div><div><span class="" style="white-space:pre"> </span></Placemark></div><div><span class="" style="white-space:pre"> </span><Placemark></div><div><span class="" style="white-space:pre"> </span><name>Westborough MSC to Westborugh</name></div><div><span class="" style="white-space:pre"> </span><styleUrl>#msn_ylw-pushpin8</styleUrl></div><div><span class="" style="white-space:pre"> </span><LineString></div><div><span class="" style="white-space:pre"> </span><tessellate>1</tessellate></div><div><span class="" style="white-space:pre"> </span><coordinates></div><div><span class="" style="white-space:pre"> </span>-71.62172195712955,42.27186897741407,0 -71.62194000095552,42.27189433043378,0 -71.6225634332947,42.27210480296427,0 -71.62308968672842,42.27236391420707,0 -71.62394597288645,42.27309147863262,0 -71.62737594489003,42.27740640295431,0 -71.62822373584245,42.27893783334968,0 -71.63091971519079,42.28164762788888,0 -71.63207040059587,42.28370221254578,0 -71.62599732629406,42.28418518334991,0 -71.60795611539982,42.28517668969011,0 -71.60267209851122,42.28504601944216,0 -71.60188701357249,42.28516492137062,0 -71.58850360403626,42.28849573666959,0 -71.5858004650346,42.28852197680775,0 -71.58571706491037,42.2874804233345,0 </div><div><span class="" style="white-space:pre"> </span></coordinates></div><div><span class="" style="white-space:pre"> </span></LineString></div><div><span class="" style="white-space:pre"> </span></Placemark></div><div><span class="" style="white-space:pre"> </span><Placemark></div><div><span class="" style="white-space:pre"> </span><name>NEW Danbury</name></div><div><span class="" style="white-space:pre"> </span><Camera></div><div><span class="" style="white-space:pre"> </span><longitude>-73.45375129836707</longitude></div><div><span class="" style="white-space:pre"> </span><latitude>41.390460041635</latitude></div><div><span class="" style="white-space:pre"> </span><altitude>419.0806930250601</altitude></div><div><span class="" style="white-space:pre"> </span><heading>13.43312150541231</heading></div><div><span class="" style="white-space:pre"> </span><tilt>28.58299225276625</tilt></div><div><span class="" style="white-space:pre"> </span><roll>-0.685026358787494</roll></div><div><span class="" style="white-space:pre"> </span><gx:altitudeMode>relativeToSeaFloor</gx:altitudeMode></div><div><span class="" style="white-space:pre"> </span></Camera></div><div><span class="" style="white-space:pre"> </span><styleUrl>#msn_ylw-stars</styleUrl></div><div><span class="" style="white-space:pre"> </span><Point></div><div><span class="" style="white-space:pre"> </span><gx:drawOrder>1</gx:drawOrder></div><div><span class="" style="white-space:pre"> </span><coordinates>-73.45404626023216,41.3929335947184,0</coordinates></div><div><span class="" style="white-space:pre"> </span></Point></div><div><span class="" style="white-space:pre"> </span></Placemark></div><div><span class="" style="white-space:pre"> </span><Placemark></div><div><span class="" style="white-space:pre"> </span><name>NEW Scotland Amp</name></div><div><span class="" style="white-space:pre"> </span><LookAt></div><div><span class="" style="white-space:pre"> </span><longitude>-72.09703050755105</longitude></div><div><span class="" style="white-space:pre"> </span><latitude>41.69579944328172</latitude></div><div><span class="" style="white-space:pre"> </span><altitude>0</altitude></div><div><span class="" style="white-space:pre"> </span><heading>-0.790587312931665</heading></div><div><span class="" style="white-space:pre"> </span><tilt>19.0106770482321</tilt></div><div><span class="" style="white-space:pre"> </span><range>445.0511788150669</range></div><div><span class="" style="white-space:pre"> </span><gx:altitudeMode>relativeToSeaFloor</gx:altitudeMode></div><div><span class="" style="white-space:pre"> </span></LookAt></div><div><span class="" style="white-space:pre"> </span><styleUrl>#msn_ylw-stars</styleUrl></div><div><span class="" style="white-space:pre"> </span><Point></div><div><span class="" style="white-space:pre"> </span><gx:drawOrder>1</gx:drawOrder></div><div><span class="" style="white-space:pre"> </span><coordinates>-72.09643061038489,41.6960553015771,0</coordinates></div><div><span class="" style="white-space:pre"> </span></Point></div><div><span class="" style="white-space:pre"> </span></Placemark></div><div><span class="" style="white-space:pre"> </Folder></span></div></div><div><br></div><div><br></div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Mar 11, 2015 at 6:38 PM, Schylberg Lars <span dir="ltr"><<a href="mailto:lars.schylberg@saabgroup.com" target="_blank">lars.schylberg@saabgroup.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">The OGR style is the variable that is returned in the variable that is casted.
<u></u><u></u></p>
<p class="MsoNormal">Please look at the Layer definitions that I sent yesterday in the mapfile example.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p>DATA "SELECT Name as NAME, CAST(OGR_STYLE AS character(32)) AS STYLE FROM 'Fibertech solution' WHERE OGR_GEOMETRY='LINESTRING'"<u></u><u></u></p>
<p>CLASSITEM "STYLE"<u></u><u></u></p>
<p>LABELITEM "NAME"<u></u><u></u></p>
<p><u></u> <u></u></p>
<p>CLASS<u></u><u></u></p>
<p> EXPRESSION "@msn_ylw-pushpin4"<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">That is the STYLE value used in the CLASSITEM expression.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">The description is shown in the label that uses the labelitem. Also shown in the mapfile example yesterday.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">If You only want to get the features with the style ‘@msn_ylw-pushpin4' with ogrinfo you should write it like this:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">ogrinfo -ro doc_test.kml \<br>
-sql "SELECT *, CAST(OGR_STYLE AS character(255)) AS STYLE FROM 'Fibertech solution' \<br>
WHERE OGR_GEOMETRY='LINESTRING' AND OGR_STYLE='@msn_ylw-pushpin4'" –al<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">That returns the geometry and variables according to this criteria, i.e. only lines and specific style.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">But I guess that You most likely would like to do this filtering in the Class section of the mapfile and not in the DATA statement.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">/Lars<span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapserver-users-bounces@lists.osgeo.org" target="_blank">mapserver-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>alok mathur<br>
<b>Sent:</b> den 11 mars 2015 05:46<br>
<b>To:</b> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<b>Subject:</b> [mapserver-users] KML reading through OGR<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Hi,</span><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">I am unable to get the Styleurl using Ogrinfo. I am trying the command <u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">ogrinfo -al doc_test.kml -where "ogr_style='@msn_ylw-pushpin4'"<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">but the result is <u></u><u></u></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Layer name: Fibertech solution<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Geometry: 3D Unknown (any)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Feature Count: 0<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Layer SRS WKT:<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">GEOGCS["WGS 84",<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> DATUM["WGS_1984",<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> SPHEROID["WGS 84",6378137,298.257223563,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> AUTHORITY["EPSG","7030"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> TOWGS84[0,0,0,0,0,0,0],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> AUTHORITY["EPSG","6326"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> PRIMEM["Greenwich",0,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> AUTHORITY["EPSG","8901"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> UNIT["degree",0.0174532925199433,<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> AUTHORITY["EPSG","9108"]],<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"> AUTHORITY["EPSG","4326"]]<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Name: String (0.0)<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Description: String (0.0)<u></u><u></u></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Also i want to show the description of placemark on map.<u></u><u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><u></u> <u></u></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt">Thanks!<u></u><u></u></span></p>
</div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt"><img src="https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif"><u></u><u></u></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<p><a name="14c08f3f5b2c2dc6_SafeHtmlFilter__MailAutoSig"><b><span style="font-family:"Arial","sans-serif"">Alok Mathur</span></b></a><span style="font-family:"Arial","sans-serif""> <span style="color:red">|</span>
<span style="color:gray">Software Engineer 2A</span> <span style="color:red">|</span><span style="color:purple"> </span><span style="color:gray">Ciena<br>
Mobile +91 9899413266</span></span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><p><font><a name="SafeHtmlFilter__MailAutoSig"><b><span style="font-family:Arial,sans-serif">Alok Mathur</span></b></a><span style="font-family:Arial,sans-serif"> <span style="color:red">|</span> <span style="color:gray">Software Engineer 2A</span> <span style="color:red">|</span><span style="color:purple"> </span><span style="color:gray">Ciena</span></span><span style="font-family:Arial,sans-serif;color:gray"><br></span><span style="font-family:Arial,sans-serif;color:gray">Mobile +91 9899413266</span></font></p></div></div></div></div>
</div>