hallo Andre,
in a php environment you can query both PostgreSQL and MySQL data.
If you want click over a POI to read his data, your application should
query the MySQL MIS via the FeatureID and retrieve the budget data, then
display them in a window or in a layer on your web page.
It is different to show the POIs with a legend that depends of the budget
data: it is better if you can set up an ETL to import mysql data into
PostgreSQL, or vice versa only the X/Y coordinates of POIs from PostgreSQL
to MySQL. These solutions allows you to create a legend for the POIs, i.e.
a more exaustive classification of the POIs: not only grey red but with
a color ramp.
Anoter way: you can to do this on the fly whit the php application,
adding programmatically the POIs that overspends to a red dots layer
I hope this can help
greetings
pg
--
Pietro Giannini
Bytewise srl - Area GIS
41°50'38.58N 12°29'13.39E
On Mer, Ottobre 8, 2008 21:26, Andre Schoonbee wrote:
See, the map data is currently in postgis, and in the MySQL database, I
have
a FeatureID field that relates to the relevant PostGIS data element.
I know this is doable, but my personal PHP development skills is extremely
limited. I can setup mapserver and have got the basic PHP system going,
but
going beyond - out of my current scope.
-Original Message-
From: Dan Little [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2008 8:47 PM
To: Andre Schoonbee
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Integrate mapserver with PHP MIS
It is certainly possible to do this with mapserver. More accurately, it
is
very easy to setup these types of queries with mapscript the scripting
library provided with mapserver.
There is also some constraints on your data. You'll need to have a table
(or column) describing the geographic locations of all of your projects.
Or
have a geocoder that can translate the project into geographic coordinates
on the fly.
- Original Message
From: Andre Schoonbee [EMAIL PROTECTED]
To: mapserver-users@lists.osgeo.org
Sent: Wednesday, October 8, 2008 12:41:33 PM
Subject: [mapserver-users] Integrate mapserver with PHP MIS
Hi List
I want to get expert opinion on if mapserver would be the best platform
for
the following:
I have a Management Information system (PHP, mySQL) and want to link it
to
a
map. When I click on a POI on the map I want to see the projects at that
POI, the staff or budget for that place. OR if I want to see all POI
that
overspend their budget, I want to display the POI as RED Dots on the
map.
Comments would be appreciated!
And if this is a great platform, any developers out there willing to
assist?
Andre
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
__ Information from ESET Smart Security, version of virus
signature
database 3504 (20081008) __
The message was checked by ESET Smart Security.
http://www.eset.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
