A Web GIS Module for Drupal and Joomla

A Web GIS Module for Drupal and Joomla! Content Management Systems - Historical GIS for Hanoi City, Vietnam- Venkatesh Raghavan, Nguyen Hoa Binh and Sarawut Ninsawat, Osaka City University, Japan Thanks to Gérald Fenoy, GEOLABS, France

PRESENT STATUS o o o FOSS Portal & CMS like Joomla!, Drupal provide an environment for collaborative content development. Available Web-GIS clients like Gmap, Open. Layers Ka. Map etc. are meeting the needs for Web. Mapping. However, there is currently few Web-GIS+CMS integrated solutions are available.

PROBLEMS o o o Stand-alone Web-GIS clients lack of information exchange functions and poor in conventional content management. Portal & CMS systems are powerful, functionsrich, modular designed; but lack of support for spatial information. Spatial data needs to be supported for community-oriented services in Web 2. 0 applications.

BOOK BORROW AND DELIVERY SYSTEM o A typical example of “loose Integration” model for 3 independent applications. n n n o Users browse books from OPAC application. Enter books’ information into Borrow cart application. Select a nearest convenient store on the map to have books delivered using Web-GIS application. Integration done in term of look-n’-feel only.

Application 2 Application 1 Application 3

RESEARCH OBJECTIVES o To enhance Geospatial support in existing CMS by integrating GIS content and functionalities: n n o To develop integrated Web-GIS clients as functional module for CMS: n n o GIS technology becomes more popular and available to general users community. CMS also become more powerful and functionality rich. Spatial content and GIS functions are supported by Portal’s content can be linked with map’s objects. To develop routing functionalities for Location-Based Services (LBS) in the spatially enabled Portals.

Portal & CMS ? ? ? Web-GIS Clients

CMS+Web GIS

MAIN TASKS o Developed Web-GIS functions, including: n n o Developed WMS-support capability to enable distributed spatial data-sources: n n o o Enhance functionality for Gmap (DM Solutions) Web-GIS client. Incorporate query function to link spatial and non-spatial contents. A WMS server is created as a data source for satellite images. WMS layers are embedded into the map file. Integrated Shortest path and Traveling Salesman Problem (TSP) functions using Pg. Routing engine. Implementd spatially enabled Historical Portal for Hanoi City

HANOI (1) o One of the oldest capital cities in South East Asia n n o o Hanoi City Thang Long: “Ascending Dragon” City, given by Ly dynasty in 1010 City of Peace: given by UNESCO in 1999 A multi-cultural city (Vietnamese, Chinese, French) with many heritages: places, life-style culture There are 2000 historical places: architectures, scenes, archeological sites N Urban zone

HANOI (2) o Rapid urban development is a threat to historical and archeological heritages n n o o o Housing development are trespassing cultural sites Proposed new parliament house leads to discovery of priceless “Thang Long old citadel” archeological site Great Hanoi 1000 years celebration in October 2010 There is a need of understanding and support from Hanoi People’s Committee for historical heritages preservation Research target: Application of ICT and GIS in n n Historical heritages preservation information support Develop a multi-purpose support tool used for urban development process

PROBLEMS o o o Online system for historical information support in Hanoi is not available. Researches about Hanoi history usually relates to the location of POI which need verified and authenticated The Historian community in Vietnam requested for a simple tool to gather and manage cultural and historical information through community participation

SOLUTIONS o Integration of GIS content and functions into the popular FOS web-Portals & Content Management Systems (CMS) n n o Hanoi-GIS: A spatially enabled FOSS-based Portal n n o GIS technology becomes more popular and available to general community Portal system is also stronger and information richer A data center of Hanoi history information Online co-operate working environment between researchers and open to Hanoi people community Spatial content and GIS functions are supported by Portal’s content can be linked with map’s objects The system can be used for multi-purpose: Disaster Management, Public Health…

INITIAL SYSTEM o Mandriva Linux 2006 operating system Zope multi-instances web server n n o o o Internal Database server Python programming language Plone Portal/CMS framework GIS functional support: Prima. GIS, ZCO, PCL University of Minnesota Map. Server Web Browser INTERNE T Others Modules & Components Java Script Map file Prima. GIS UMN Map Server ZCO, PCL… Plone Portal&CMS Instance 1 Instance 2 ZOPE Web Server CLIENT COMPUTER o Post. GIS … Python ZOPE Database LINUX OS on SERVER COMPUTER

DATA COLLECTION o Hanoi’s 300 Historical Places: n n n o Hanoi’s 150 French Architectures: n n o Information: Name, Address, Description, Write-up Spatial information: GPS location Multimedia information: Pictures, Videos, Panoramic photos Information: Name (Old/New), Address, Description in both Vietnamese and English Multimedia information: Pictures Collected from reliable sources: n n 3 field campaigns Published book: Terunobu, F. , Viet, P. D. , Shin, M. , Hoang, D. T. (1997), Preservation of Hanoi Architectural Heritage, Vietnam’s Construction Public House, pp. 184.

DATA INPUT o Using standard simple CMS functions of Plone Portal n n n o Content Initializing: Data contributors upload content and submit to the reviewers Content Management: Reviewers publish or deny the content Content Publish: Content is displayed on the Portal inside the appropriate folder Another simple CMS functions (check-in, check-out, remove, comment…) maintain a co-operate working environment among portal users

DATA INPUT (2) Reviewer Contributor Reader

MAPS DATA COLLECTION o Background maps – Shape files: n n n o n Stored in an external WMS with tile-index technique Source: Vietnam Institute of Physics, VAST. Historical maps: 8 Hanoi paper-maps in: 1831, 1873, 1898, 1902, 1915, 1925, 1936 and 1942 n o Source: Vietnam Institute of Geology, VAST. Satellite image: Ikonos at 2 m resolution n o Vietnam’s province and district border Hanoi’s roads and water boundaries Source: Vietnam Historical Science Association Point objects representing Historical POIs are put onto the map in 2 different ways: n n Import the list of GPS-location-available POIs Manually digitizing on the map for non-GPS-location POIs

LINK SPATIAL OBJECTS WITH PORTAL’S CONTENT

ADDING POIs (1) o o o Using creation script to put the POIs onto the map while creating Prima. GIS instant Used for 300 Historical Sites with GPS data available Sample Place ID script: GPS position Place name n ("Parliament House", 105. 835511, 21. 038191, "Parliament House", "<a href='http: //160. 193. 3. 69/hanoi/nhaquochoi. htm'>Nhà quố c hộ i <img supported for Description, HTML-embed interactive display src='http: //160. 193. 3. 69/hanoi/nhaquochoi_files/image 00 1. jpg'></a>Đ ặ c đ iể m: Nơ i diễ n ra các cuộ c họ p củ a Quố c hộ i VN. "),

ADDING POIs (2) o Manually put the points using Prima. GIS administration interface: n n o Online digitizing on the maps, no field-visit required Used for the 150 French Architectures without GPS data Bases on many different information: n n City paper-map Place’s street address and Picture Place’s characteristics Image interpreting using Ikonos and street layer

SAMPLE Building block Building Roof

PRIMAGIS AND PLONE PORTAL INTEGRATION o Hanoi-GIS: Spatially enabled FOSS-based Portal system n n o o A database for Hanoi history information. An online co-operate working environment between researchers. Spatial contents and GIS functions are supported by the Portal; Portal’s contents can be linked with map’s objects. However, Prima. GIS/Plone/Python is difficult to implement and requires high development & administration skills.

WEB-GIS INTEGRATION IN PHP PORTALS o Integration process of Gmap Web-GIS client into PHPbased Joomla! and Drupal Portals over three main steps: n n Why PHP-based Portal and CMS systems? Why Gmap Web-GIS client? Pre-process the standalone Gmap client Build Gmap Web-GIS module for the Portal -Compact the original Gmap’s GUI into a smaller layout. -Create -Convert and restructure Gmap’s PHP code to PHP 5. -Include -With -Declare OOP support, compatible with Portal framework, more secured. a dummy module then change path to all resource files. portal’s security check functions. Gmap’s public variables. -Save GET parameters of the portal for page returns. Deploy the integrated module -Make installation package using XML, following Portal’s rule -Install the module into a fresh Portal deployment -Contribute the output to the mainstream of Portal system -Further program, debug & fix all warnings and errors occur. Step 1 Step 2 Step 3

http: //gisws 1. media. osaka-cu. ac. jp/joomla/

http: //gisws 1. media. osaka-cu. ac. jp/drupal/

ENABLING ROUTING FUNCTIONS o o PGRouting is a FOSS tool for that provides routing functionality. Shortest path and TSP path search are implemented as stored functions of Postgre. SQL. Modifications are made into some PGRouting’s functions for compatible with UTM co-ordinate system of Hanoi’s roads dataset. Output result is generated as a spatial data in Postgre. SQL, then rendered to the map image in PHP application.

1 West Lake 0 Flag tower The optimal shortest path from “Flag tower” to “West lake”

West Lake 3 2 Ho Chi Minh mausoleum 1 Flag tower Van Mieu temple 4 0 TSP path to 5 famous places in Hanoi city Hoan Kiem Lake

CONCLUSIONS o o o Integration CMS and GIS helps in enhancing community services portals and promotes the widespread of Geospatial information and GIS technologies. Two routing functions provides added capabilities of Geoinformatics technology for specific purposes like tourism. The know-how of integration is applicable for another systems The prototypes for other applications like fleet management, disaster mitigation and health care. The output of this research will be contributed to the mainstream of Joomla! and Drupal projects.

THANK YOU VERY MUCH!!!