Automatic generation of web based gis database applications
Sponsored Links
This presentation is the property of its rightful owner.
1 / 44

Automatic Generation of Web-Based GIS/Database Applications PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Automatic Generation of Web-Based GIS/Database Applications. Nirut Chalainanont Junya Sano Toshimi Minoura Department of Computer Science Oregon State University Corvallis, Oregon, 97331-4602 Outline. Web-based GIS/database applications WebGD Framework

Download Presentation

Automatic Generation of Web-Based GIS/Database Applications

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Automatic generation of web based gis database applications

Automatic Generation of Web-Based GIS/Database Applications

Nirut Chalainanont

Junya Sano

Toshimi Minoura

Department of Computer Science

Oregon State University

Corvallis, Oregon, 97331-4602



  • Web-based GIS/database applications

  • WebGD Framework

  • Automatic generation of Web-form scripts

  • Automatic generation of map-layer configuration files

  • Conclusions

Capabilities of webgd applications

Capabilities of WebGD Applications

  • Geographical features can be inserted, queried, and deleted from a map interface.

  • A map interface and Web-form scripts can be automatically generated.

  • Dynamic switching of spatial references is supported.

Capabilities of webgd applications cont d

Capabilities of WebGD Applications (cont’d)

  • GIS data in an area selected by the user can be exported as a shapefile.

  • A treeview can be automatically created.

  • A PDF file containing the map image and data retrieved from the database can be created.

  • Photo images can be uploaded.

Natural heritage information system

Natural Heritage Information System

Searching in a selected area

Searching in a Selected Area

Getting information

Getting Information

Inserting a new motel

Inserting a New Motel



Pdf file generation

PDF File Generation

Uploading photo images

Uploading Photo Images

Webgd architecture

WebGD Architecture

PHP scripts create the map object and access the database.

Web Browser

Defines PHP classes for GIS objects.


Web Server


Provides functions to manage geospatial data



Generates map images.


Stores geospatial and business data.



  • The object-relational feature of PostgreSQL simplifies manipulation of geographical objects:

select gid

from sites

where geom_col &&

setSRID(BOX2D(10 20, 80 90)::box2d, 6010));

select X(geom_col), Y(geom_col)

from sites

where gid = 100;

Dynamic switching of spatial references

Dynamic Switching of Spatial References

  • World Longitude/Latitude

  • North America  Albers Equal Area

  • California UTM 10 and 11

  • Oregon  Lambert Conformal Conic

World in longitude latitude

World in Longitude/Latitude

North america in albers equal area

North America in Albers Equal Area

Continental united states in albers equal area

Continental United States in Albers Equal Area

Oregon in lambert conformal conic

Oregon in Lambert Conformal Conic

Corvallis in lambert conformal conic

Corvallis in Lambert Conformal Conic

Dynamic switching of spatial references1

Dynamic Switching of Spatial References

  • The world is divided into regions with sizes ranging from the entire world to a state/province in a country.

  • Each region has an associated rank number.

  • Each time a user changes the extent by zooming or panning, many regions may cover the new map extent. The region with the largest rank number, which is normally the smallest region that includes the extent, is selected

Selecting a region

Selecting a Region

Region 1 (rank 1)

Region 2 (rank 11)

Region 2 selected

Region 3(rank 12)

Region 3 selected

Region 1 selected

Webgd framework

WebGD Framework

  • A collection of scripts common to all WebGD applications

  • Customizable with configuration files

  • Sever-side scripts written in PHP

  • Client-side scripts written in JavaScript

Region configuration

Region Configuration

  • Map projection

  • Unit distance of measurement

  • Name of the map file for the region

  • Name of the map layer configuration file

  • Name of quick view configuration file

Region configuration1

Region Configuration

Map layer configuration

Map Layer Configuration

The following information is kept for each map legend entry:

  • Spatial reference ID

  • Geometry type

  • Icon and label for the layer

  • Database table associated with the layer

  • Actions associated with the layer

Map layer configuration1

Map Layer Configuration

Quick view configuration

Quick View Configuration

The quick view mechanism allows the user

to go to a predefined area directly:

  • Spatial reference for each area

  • Extent of each area

  • Name of each area

Quick view configuration1

Quick View Configuration

Weggd application generator

WegGD Application Generator

  • WebGD-Gen automatically generates a consistent set of Web scripts from configuration files, including those for a map interface.

  • Configuration files are again automatically generated from a relational database schema.

  • The cost of application development is greatly reduced.

Form script generation process































Form Script Generation Process

Linked forms

Linked Forms

Department Select Form

Selected ID

Department Search Form

Student Edit Form

Department Edit Form

Course Select Form

Webgen configuration file

WebGen Configuration File

  • $search_fieldsfor the search script.

  • $search_fields, $select_fields and$search_join_tables for the select script

  • $edit_fields for the edit script

  • $info_blocks for information script

Search and select forms for table students

Search and Select Forms for Table students

Search fields




"label"=>"Student ID",





"label"=>"First Name",




. . .


Search join tables


joined_tableindicates the associated table linked to the anchor table:

$search_join_tables = array(

"departments" => array(


"departments ON departments.department_id = students.department_id",

"used"=>"false", "select"=>"true"),


Configuration parameters for a map interface

Configuration Parametersfor a Map Interface

  • WebGD-Gen can generate the statements for inserting, searching, and deleting geographical features from the following lines in a Web-script configuration file:

$web_gd = ‘MULTIPOLYGON’;

$layer_name = ’grp_eo_py’; $geometry_column = ‘the_geom’;

$gid_column = ‘gid’;

$db_table_srid = 32119;

Process of creating map layer configuration file for region xxx

Process of Creating Map-Layer Configuration File for Region xxx


Map File



User Customization

Customized xxx_maplayer.mconfig



Map layer meta configuration file

Map-Layer Meta Configuration File

  • The default map-layer meta configuration file is created by map_mconfgen from

    • table geometry_columns in the database and

    • the layer-group names in the map file

  • User can customize the meta configuration file.

Meta configuration file

Meta Configuration File

  • Default meta configuration file

  • User customized meta configuration file

'grp_eo_py' => array(

'layer_selectable' => true,

'legend_label' => 'Eo Py',


'grp_eo_py' => array(

'layer_selectable' => true,

'legend_label' => 'EO Polygons',

'search_script' => 'forms/eo/eo_py_search.phtml',

'select_script' => 'forms/eo/eo_py_select.phtml',

'edit_script' => 'forms/eo/eo_py_edit.phtml',

'img_src' => 'images/eo_poly.png',


Map layer configuration file

Map-Layer Configuration File

  • map_confgengenerates the map-layer configuration file by applying customized data in the meta configuration file to the meta data retrieved from

    • table geometry_columns in the database and

    • the layer-group names in the map file

Definition of a layer configuration

Definition of a Layer Configuration

'grp_eo_py' => array(

'geom_type' => ‘POLYGON',

'table' => 'eo_py',

'layer_selectable' => true,

'legend_label' => 'EO Polygons',

'geom_col' => 'the_geom',

'gid_column' => 'gid',

'normal_layer' => 'eo_py',

'img_width' => 26,

'img_height' => 26,

'img_src' => 'images/eo_poly.png',

'data_srid' => 32119,

'search_script' => 'forms/eo/eo_py_search.phtml',

'select_script' => 'forms/eo/eo_py_select.phtml',

'edit_script' => 'forms/eo/eo_py_edit.phtml',

'searched_layer' => 'eo_py_searched',

'checked_layer' => 'eo_py_checked',

'selected_layer' => 'eo_py_selected',

'onclick' => 'activate_layer("grp_eo_py")',




Web-based GIS/database applications have a great potential for user-participatory applications.

  • Users can add geographical features and associated data with Web browsers.

  • The major part of creating a WebGD application can be automated.

  • The whole world or the entire USA can be seamlessly covered.


Dileep Arur

Haris Gunadi

Surya Halim

Hong Gyu Han

Mariko Imaeda

Junya Sano

Akash Sharma

Hiroshi Tashiro

Naroot Wanalertlak

Paphun Wangmutitakul

Teerawat Wuttiwat


Automatic generation of web based gis database applications


  • Login