Geographical Visualization of Government Contracts In Colombia – VGICC

July 31st, 2008 by juanmendez

Project Description: (You can read the spanish version of this article here)

VGICC is a Proof of concept using the new Google Earth Browser Plug-in. This application takes advantage of the plug-in to visualize and interact with statistical and geographical information of government contracts in Colombia.

(Note: The information available in this application is only for testing purposes. Official data can be found at the Official Contracting Site of Colombia, “PUC, Portal Único de Contratación” http://www.contratos.gov.co/puc/ )

Online Links

Project Challenge:

Provide an interactive Geographic Rich Internet Application that allows users to visually explore and discover new relations of Government’s investments using spatial, statistical and public contract information of Colombia.

This Geographic Rich Internet Application uses Interactive Web Mapping techniques as an alternative tool to explore PUC´s data. (Current search engine is based solely on plain text filters).

Technical Challenge:

During development stages of this proof of concept some technical challenges must be confronted:

  • Information Extraction:Although PUC (http://www.contratos.gov.co/puc/) lets public search options for general users, it doesn’t provide any free Web Service, RSS or interoperable API that could be integrated with external systems. However, thanks to the implementation of Web Scrapping techniques it was possible to automatically extract information from web pages published at PUC’s search portal.

  • Transformation, Georreferencing and Data Loading: Once information extraction was accomplished, it was necessary to transform and georeference each one of the contracts against the available database of political-administrative divisions of Colombia. Furthermore, all data was stored in a geographic database managed by Postgres and Postgis.

  • Interactive Visualization of Geographical and Statistical Information through Internet: May one of the biggest technical challenges of the VGICC was related to the implementation of the web visualization of geographical and statistical data using modern web technologies and tools.  Firstly, Google’s brand new “Google Earth Browser Plug-in”  was used to enable web browser based geographic visualization of data. One of the most interesting features of Google Earth and KML is the possibility of draw 3D objects over the earth globe. In this case, 3D objects are used to represent the amount of government investment in a particular state or county.  Secondly, it was possible to programmatically interact with the GE plug-in using JavaScript and KML (perhaps this is the most appealing feature of the plug-in for programmers and system integrators).  Finally, to provide a single and unified user experience based on Html it was necessary to use different JavaScript/Ajax techniques and tools.  This framework, as a whole, proved to be a suitable alternative for the implementation of geospatial browser based applications.

Basic Features:

Basically, the application allows geographic visualization of consolidated data by State and County.  There are two basic interactions:

Page 1 of 2 | Next page

Share

Posted in Rich Internet Applications | 3 comments

Previous post:
Next post: