[mapserver-users] Integrate mapserver with PHP MIS

[Pietro Giannini]

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.58"N 12°29'13.39"E

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:danlittle at yahoo.com]
> Sent: Wednesday, October 08, 2008 8:47 PM
> To: Andre Schoonbee
> Cc: mapserver-users at 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 <andresch at iway.na>
>> To: mapserver-users at 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 at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>