[UMN_MAPSERVER-USERS] center point using data from PostGIS

[Skweda O'Bomsawin]

You can take a look at the PostGIS user manual:
http://postgis.refractions.net/docs/

Look at the extent option from sql, something like that:

select xmin(extent(wkb_geometry)),
ymin(extent(wkb_geometry)),xmax(extent(wkb_geometry)),ymax(extent(wkb_geomet
ry)) from employes where emp='Annele Duguay';


Dans l'espoir de vous mettre sur la bonne voie!

Skweda O'Bomsawin


-----Message d'origine-----
De : UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] De la
part de Yannick Doiron
Envoyé : 25 octobre 2004 14:03
À : MAPSERVER-USERS at LISTS.UMN.EDU
Objet : [UMN_MAPSERVER-USERS] center point using data from PostGIS

Hi list,

I am using MapServer CGI 4.2 on window XP with PostGIS data connect to it.

I'a using the code below to center the map on a point choosed by the user
from a select list.

<select name="ViewEmploye" id=emp onchange="employe();" size="1">
<option value="-1">Employes</option>
<option value="-1">-------------</option>
<option value="359877 5276306"> Annelle Duguay </option>
<option value="336655 5297926"> Thérèse Haché </option>
<option value="357748 5295074"> Yannick Doiron </option>
</select>

I want to be able to get the coordinate from a PostGIS database instead of
writing it like the code above. I was able to import my data in PostGIS and
see it with MapServer. I know I will have to use PHPMapscript. I have it
install and working (I have the ms4w package from maptools.org installed)
but I am not very good php programming.

Can somone lead me at a tutorial or else on how to achieve this? If this
was asked and answered in the past, please forward me the link.

Thanks in advance,
Yannick

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 2004-10-19
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 2004-10-19