Hi Andreas,<br><br>Thanks for your note. I'm afraid I have to reinvent the wheel. My issue is that my hands are tied with regard to what software I can use. I wouldn't even bother with GML if I could use Geoserver or Mapserver. I'm developing for a university which doesn't want to give us a VPS and won't let me use anything besides Jscript, Php, and Mysql. Initially they had suggested an entirely clientside solution. I had initially developed using PGsgl and Mapserver, and now I'm trying to build more or less the same functionality without Mapserver (or an equivalent piece of the software) as the keystone.<br>
<br>The issue is I have a point file that has a number of many-to-one relationships, which should be filterable through search parameters (i.e. SELECT _type, _phase, etc FROM Sites Where X Like Y). There are only some 400 points total, and If I could load them all and hide and reveal them based on user input, that might work as well. I was envisioning individual site markers as well based on attributes, but that might not happen by the time it goes live.<br>
<br><div class="gmail_quote">On Wed, Jun 10, 2009 at 3:24 AM, Andreas Hocevar <span dir="ltr"><<a href="mailto:ahocevar@opengeo.org">ahocevar@opengeo.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<div><div></div><div class="h5"><br>
On Wed, Jun 10, 2009 at 4:08 AM, Nicholas<br>
Efremov-Kendall<<a href="mailto:n.e.kendall@gmail.com">n.e.kendall@gmail.com</a>> wrote:<br>
> I apologize for the deluge of questions. Does anyone have a reference for<br>
> getting a postgres/mysql database query into a gml file for export?<br>
<br>
</div></div>I am not sure there is one, because you would be re-inventing the<br>
wheel by implementing this in PHP. You may want to have a look at<br>
GeoServer [1] (configurable via web-based GUI, requires Java JDK) or<br>
FeatureServer (config file, requires Python). The former implements<br>
various OGC [3] standards, and can also render map tiles (using the<br>
WMS standard, like e.g. also UMN MapServer [4]), the latter provides a<br>
lean REST API. All of the mentioned products work well with<br>
OpenLayers.<br>
<br>
Regards,<br>
Andreas.<br>
<br>
[1] <a href="http://geoserver.org/" target="_blank">http://geoserver.org/</a><br>
[2] <a href="http://featureserver.org/" target="_blank">http://featureserver.org/</a><br>
[3] <a href="http://opengeospatial.org/" target="_blank">http://opengeospatial.org/</a><br>
[4] <a href="http://mapserver.org/" target="_blank">http://mapserver.org/</a><br>
<font color="#888888"><br>
--<br>
Andreas Hocevar<br>
OpenGeo - <a href="http://opengeo.org/" target="_blank">http://opengeo.org/</a><br>
Expert service straight from the developers.<br>
</font></blockquote></div><br>