I agree with Kai. This is typically what I do with data in CSV, tab-delimited, XML, KML, etc. I write a shell script of XSLT transform to convert to a SQL file I can load into PostGIS, the use the pgsql2shp program top convert to shapefile. This would be more ideal than keeping in PostGIS as MapServer is optimized for shapefiles. Other than that you could try using C# MapScript to generate layers on-the-fly
<br><br>here's a PHP MapScript example:<br><br> function drawPoint($oMap,$x,$y,$text = '') {<br> $nSymbolId = ms_newSymbolObj($oMap, "my_point");<br> $oSymbol = $oMap->getsymbolobjectbyid($nSymbolId);
<br> $oSymbol->set("type", MS_SYMBOL_ELLIPSE);<br> $oSymbol->set("filled", MS_TRUE);<br> $aPoints[0] = 1;<br> $aPoints[1] = 1;<br> $oSymbol->setpoints($aPoints);
<br><br> // Create a layer to hold circle<br> $oLayerPoints = ms_newLayerObj($oMap);<br> $oLayerPoints->set("name", "my_point_outline" . mt_rand(abs(ceil($x)),abs(ceil($y))));<br>
$oLayerPoints->set("type", MS_LAYER_POINT);<br> $oLayerPoints->set("status", MS_DEFAULT);<br> $pointObj = ms_newLineObj();<br> $pointObj->addXY($x,$y);<br> $oPointShape = ms_newShapeObj(MS_SHAPE_POINT);
<br> $oPointShape->add($pointObj);<br> if ($text != '') {<br> $oPointShape->set("text", $text);<br> }<br> $oLayerPoints->addFeature($oPointShape);<br><br> // Create a class object to set feature drawing styles.
<br> $oMapClass = ms_newClassObj($oLayerPoints);<br> // Create a style object defining how to draw features<br> $oPointStyle = ms_newStyleObj($oMapClass);<br> $oPointStyle->color->setRGB(250,0,0);
<br> $oPointStyle->outlinecolor->setRGB(255,255,255);<br> $oPointStyle->set("symbolname", "my_point");<br> $oPointStyle->set("size", "10");<br><br> // Create label settings for drawing text labels
<br> $oMapClass->label->set( "position", MS_AUTO);<br> $oMapClass->label->color->setRGB(250,0,0);<br> $oMapClass->label->outlinecolor->setRGB(255,255,255);<br> }<br>
<br><br><br><div><span class="gmail_quote">On 12/4/06, <b class="gmail_sendername">Kai Behncke</b> <<a href="mailto:kbehncke@igf.uni-osnabrueck.de">kbehncke@igf.uni-osnabrueck.de</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Mon, 4 Dec 2006 11:16:22 +0100, Martijn van Exel wrote<br>> Dear scripters,<br>><br>> I have a tab-separated text file containing numbered points (number<br>> / x / y). I want to parse this file and put the points on the map as
<br>> numbered dots. How do I go about doing this in (C#) MapScript? Can I<br>> determine the size of the dots and the size, font and colour of the<br>> numbers? Can I make the numbers appear centered inside the dots?
<br>><br>> Much appreciated,<br>><br>Hello Martijn,<br>this sounds quite interesting.<br>You can do this easily with PHP/Mapscript.<br>You can parse the text file in a way, that the x and y -koordinates are<br>written in a database (PostgreSQL/PostGIS or even Mysql (even without the
<br>spatial extension)).<br><br>You can determine the size of the dots.<br>For example, if your data are in postgresql/postgis, use a new Layer<br>like:<br><br>LAYER<br> NAME "poi"<br> STATUS on<br> TYPE point
<br> LABELCACHE on<br><br> CONNECTIONTYPE postgis<br> CONNECTION "user=postgres dbname=data host=localhost port=5432"<br> DATA "the_geom from yourtable"<br>LABELITEM 'punktnumber'<br> CLASS<br>
<br><br> STYLE<br> SYMBOL punkt<br>COLOR 120 0 0<br> SIZE 14 # this determines the size of the dot<br><br> END<br><br><br> LABEL #this determines the label.<br>#You can determine size, font and colour of the
<br># numbers. And you can make the numbers appear centered inside the dots.<br> TYPE truetype<br> FONT "arialbd"<br> SIZE 8<br> COLOR 0 0 0<br> OUTLINECOLOR 255 255 255
<br> POSITION cc<br> ANGLE auto<br> MINFEATURESIZE auto<br> END<br> END<br>END<br><br>Regards, Kai<br>--<br>Dipl.-Geogr. Dipl.-Umweltw. Kai Behncke<br><br>Institut für Geoinformatik und Fernerkundung (IGF)
<br>Universität Osnabrück<br>Kolpingstr. 7<br>49074 Osnabrück<br><br>Raum: 01/308<br>Tel.: +49 541 969-4450<br>E-Mail: mailto:<a href="mailto:kbehncke@igf.uni-osnabrueck.de">kbehncke@igf.uni-osnabrueck.de</a><br>Web: <a href="http://www.igf.uni-osnabrueck.de">
http://www.igf.uni-osnabrueck.de</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br><br>Mark Thomas<br><a href="mailto:spatialguru.net@gmail.com">spatialguru.net@gmail.com</a><br>205.529.9013<br><br>"Commit to the Lord whatever you do,
<br> and your plans will succeed." - Proverbs 16:3