Yes I want data creation/conversion from a user interactive query generated from a set of tables.<br>
<br>I maded some executions of ogr2ogr.<br>This tool looked as a good solution.<br>The problem is that the results may take long to execute( in case of a
join between two tables like 10 million rows history info and a 10
thousand spatial feature table ).<br>I will first try execute this tool by launching a PHP monitor script process using a shared memory buffer.<br>With the -progress flag i will try parse the output string to show some kind of progress bar.<br>
Put the monitor to sleep and in case of an abort/timeout from client kill the ogr2ogr process and free system resources.<br>On client side I will pool server for status info.<br><br><div class="gmail_quote">2010/8/9 Sumit Sharma <span dir="ltr"><<a href="mailto:sumit321@hotmail.com" target="_blank">sumit321@hotmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
Although I not an expert of PHP, still I assume you are looking for tool for<br>
data conversion. I use ogr2ogr utility. It is GDAL utility and very<br>
effective as well. Hope this will serve the purpose.<br>
<font color="#888888"><br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/About-shapefile-generation-in-PHP-with-DBF-tp5381714p5388011.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/About-shapefile-generation-in-PHP-with-DBF-tp5381714p5388011.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
</font><div><div></div><div>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br>