Danna,<br>
<div> </div> Regarding the update function you used to create
geom: you've got the right idea but coordinate pairs should be "x y".
For example instead of "north || ' ' || east" you should use "east || '
' || north".<br>
<br>
You can export the table as a shapefile using the pgsql2shp command
(<a href="http://postgis.refractions.net/docs/ch04.html#id2511474">http://postgis.refractions.net/docs/ch04.html#id2511474</a>) then check it
out in your favorite GIS viewer to make sure it's what you need.<br>
<br>
Once the data is set, you'll need to add the postgis table as a layer
in your mapfile (see
<a href="http://postgis.refractions.net/docs/ch04.html#id2512368">http://postgis.refractions.net/docs/ch04.html#id2512368</a>) This will
allow display the layer in your interface.<br>
<br>
Using mapserver CGI. In order to query the layer and link the selected
feature to content, you can use mapserver's template feature
(<a href="http://mapserver.gis.umn.edu/doc46/template-reference.html">http://mapserver.gis.umn.edu/doc46/template-reference.html</a>). I'm not
sure if this works with Chameleon so you might have to check the
Chameleon docs on how to get that working.<br>
<br>
Hope this gives you enough to start with. <br>
<br>
Matt Perry<br>
<br>
<div><span class="gmail_quote">On 10/12/05, <b class="gmail_sendername">Danna Dowdy</b> <<a href="mailto:Danna.Dowdy@noaa.gov">Danna.Dowdy@noaa.gov</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;">
I have recently been tasked to take over a sample web-gis application<br>that was built by a former colleague. I have zero experience with<br>post-gis and mapserver and was wondering if there were some good<br>introductions out there that may be helpful to me.
<br><br>postgresql 8.0.2<br>postgis 1.0.0<br>mapserver 4.4.2<br>chameleon 2.0<br><br>what I currently have is a postgresql database table that contains 4<br>columns: north, south, east, west...<br>I have created a polygon geometry column using:
<br>select AddGeometryColumn('collection', 'geom', 4326, 'POLYGON', 2 );<br><br>I populated the field using:<br>update collection set geom = geomfromtext('POLYGON((' ||<br>public.collection.north::varchar || ' ' ||<br>public.collection.east::varchar
||<br>
',' || public.collection.north::varchar || ' ' ||<br>public.collection.west::varchar ||<br>
',' || public.collection.south::varchar || ' ' ||<br>public.collection.west::varchar ||<br>
',' || public.collection.south::varchar || ' ' ||<br>public.collection.east::varchar ||'))', 4326);<br>The idea is to have a map that would display bounding boxes for all<br>collections in that area where you could further choose those
<br>collections to get the data associated with them from the database....<br><br>Any help would be greatly appreciated.....<br></blockquote></div><br><br clear="all"><br>-- <br>Matt Perry<br><a href="mailto:perrygeo@gmail.com">
perrygeo@gmail.com</a><br><a href="http://www.perrygeo.net">http://www.perrygeo.net</a>