Geostat + DHIS webservice

[Knut Staring]

On Fri, Nov 28, 2008 at 5:21 PM, Veltsos, Philippe <velt...@who.int> wrote:

So you are working on MapFish integration w/ DHIS?

We've done a bit of experimenting -  and knowing WFS, GeoJSON, OpenLayers, and Ext will probably be of use in any case. 

Basically, we found it nice to try and modify only the client side (i.e. no MapFish server) of the MF Geostat demo (which has both choropleths and proportional symbols)

http://demo.mapfish.org/mapfishsample/1.0/demos/geostat/geostat.html

We're linking data from a DHIS webservice to OpenLayers features (so far only with hardcoded parameters). In addition, we've taken a stab at "drill-down", i.e. clicking on a province zooms in to it's extent and changes to the District layer, clicking on a District gives you the next level etc. The attached file is my modification of the geostat.html file in tomcat\webapps\mapfish\demos\geostat

Some info here:

http://www.hisp.info/confluence/display/HTOOL/GIS+DHIS+solution+architecture

I think this can be one part of the solution - but I also think the functional prototype method of generating SLD remains viable, and think the two could complement each other. As Andreas said, the GeoJSON+WFS method is not so appropriate if there is a lot of data - converting all the 1200 polygons in the Admin4 layer for Zambia to GeoJSON will be very slow and take a lot of memory on the client  (better then to just send an image as WMS).

And then of course we need to link with the OLAP server (again, there could be two complementary paths - webservice with and without OLAP). We must handle the SLD generation in a smarter way than in the prototype, where every WMS call triggers a new SLD generation, which again triggers an OLAP query. In many cases (zooming, panning), the SLD should not change, and even if a change of colors is desired,  there's no need to to repeat the OLAP query. 

On another note, my brief attempt yesterday to build the Geoserver source code with RESTful API was not successful - but that remains a very interesting and relevant option:

http://geoserver.org/display/GEOSDOC/RESTful+Configuration+API

Comments on the sketch above of course very welcome.

Knut 

[Fabio D'Ovidio]

Hello,

Knut Staring ha scritto:

> On Fri, Nov 28, 2008 at 5:21 PM, Veltsos, Philippe <velt...@who.int
> <mailto:velt...@who.int>> wrote:
>
> So you are working on MapFish integration w/ DHIS?
>
> We've done a bit of experimenting - and knowing WFS, GeoJSON,
> OpenLayers, and Ext will probably be of use in any case.
>
> Basically, we found it nice to try and modify only the client side
> (i.e. no MapFish server) of the MF Geostat demo (which has both
> choropleths and proportional symbols)
> http://demo.mapfish.org/mapfishsample/1.0/demos/geostat/geostat.html

> We're linking data from a DHIS webservice to OpenLayers features (so
> far only with hardcoded parameters). In addition, we've taken a stab
> at "drill-down", i.e. clicking on a province zooms in to it's extent
> and changes to the District layer, clicking on a District gives you
> the next level etc. The attached file is my modification of the
> geostat.html file in tomcat\webapps\mapfish\demos\geostat

How can I test it ?

Fabio

[Knut Staring]

It is not really ready for testing - not in any way polished or robust, just a proof of concept. But it should be possible to set it up with your own shapefiles and data.

Basically, you need to copy the mapfish client to your tomcat\webapps, and place the file where I said.

Then replace the featuretype names in that file with some layer names from your geoserver.

Testing the linking with external data is quite a bit more involved, you would have to install Maven and check out the latest source code of DHIS 2, including the webservice. Then you need to populate your database, including with geocodes. We are planning to prepare a sample database, but I'm afraid that will take some time.

Knut

 

Fabio

--
Cheers,
Knut Staring

[Lemarchand, Johan]

you can also have a look at the link sent by
Andreas:http://geoext.opengeo.org/alachua/trunk/demo.html

You can play around with it to see the integration with OpenLayers and
ExtJs. You will find some of the components from our wish list is there.

Johan


________________________________

[Fabio D'Ovidio]

Hello,
we are implementing integration between Pentaho BI platform and Mapfish
Client in order to have GeoSpatial DashBoards that is different from
OLAP integration but I think it is the first step :-)
Our integration will be able to GetData using pentaho xaction + jsp and
display geometries trought GeoJson.
I'll give u more details asap.

Thank u!

--
Fabio D'Ovidio
Geospatial solutions

INOVA s.r.l.
Web : http://www.inovaos.it
Tel.: 081 197 57 600
mail: fabiod...@gmail.com



Knut Staring ha scritto:

> On Mon, Dec 1, 2008 at 10:13 AM, Fabio D'Ovidio
> <fabiod...@gmail.com <mailto:fabiod...@gmail.com>> wrote:
>
>
> Hello,
>
>
> Knut Staring ha scritto:
> > On Fri, Nov 28, 2008 at 5:21 PM, Veltsos, Philippe
> <velt...@who.int <mailto:velt...@who.int>

[Philippe Veltsos]

Fabio,

This sounds very interesting.
Would like to see more whenever you have something ready for a quick demo.
We would like to integrate (like in the Pentaho and Liferay integration) the data and maps in order to link the dashboard components and visualize the data w/ the maps and vice versa.

Not sure if any of you had seen the latest demo from Pentaho, but they have done some work to integrate their work in the Liferay portal solution. From there, they have a few examples of how they can represent KPI and other data using both their BI charts and tables as well as maps (the version I saw was w/ Google Maps).

Cheers
/Phil

--
Philippe Veltsos
Proud Gmail User :)