<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
On 03/25/2010 04:03 PM, Mapmaker wrote:
<blockquote cite="mid:1269525833325-4797746.post@n2.nabble.com"
type="cite">
<pre wrap="">
You can query PostGIS and use a PHP script to return the results as KML, GML,
GeoJson- and add that layer directly in OpenLayers.
</pre>
</blockquote>
<font size="+1">Thanks.<br>
Just to complete the thread, I'm doing the following in php to
dynamically create each GML layer from PostGIS views as needed:<br>
<br>
$ogrcmd = "/usr/local/bin/ogr2ogr ";<br>
$ogrcmd.= " -f \"GML\" -a_srs \"EPSG:2039\" -overwrite ";<br>
$ogrcmd.= $gml_path." PG:\"user=xxxxxxx dbname=xxxxxxx\" ";<br>
$ogrcmd.= " ".$event_code;<br>
system($ogrcmd, $resp);<br>
<br>
( $gml_path and $event_code are php vars created within the function)<br>
Then in I create the openlayers vector like:<br>
echo "var cur_data = new OpenLayers.Layer.GML(\"Current Rain
Data\",\"".$url_path."\",";<br>
....<br>
</font><br>
<pre class="moz-signature" cols="72">--
Micha Silver
<a class="moz-txt-link-freetext" href="http://www.surfaces.co.il/">http://www.surfaces.co.il/</a>
Arava Development Co. +972-52-3665918</pre>
</body>
</html>