user login 
FOSS4G2006 - Free And Open Source Software for Geoinformatics
FOSS4G2006 - Free And Open Source Software for Geoinformatics
11-15 September 2006 Lausanne, Switzerland
emailsupport
Home > Contribution details
get PDF of this contribution get XML of this contribution get ICal of this contribution
 
 
 
The development of OpenMap™ to support PostgreSQL/PostGIS queries and spatial data types
 
The theme of this paper is to report on the development of two graphical clients 
using
OpenMap™. The first client supports the native geometric data types of the
PostgreSQL DBMS. This development was exploratory in nature. Our main
goal was to develop a client that supports the spatial objects of PostGIS[2], the
spatial extension of PostgreSQL[3]. Both clients allow the user to issue SQL commands
to the DBMS using different JDBC extensions that support spatial data types. The
resulting data is displayed in OpenMap™. In both clients a layer was created capable
of converting the database types into the graphic objects required by the OpenMap™
framework.

The simple PostgreSQL client served as learning experience. It helped us understand
the nuances of both OpenMap™ and the non-standard spatial JDBC extension.
Obviously the development of the PostGIS client is of more value and of more
interest in the long term. To the best of our knowledge no queryable OpenMap™
client existed for PostgreSQL/PostGIS before this project. We feel that the ability 
to
send ad-hoc queries to PostgreSQL/PostGIS and display the results is a useful
contribution to the open source GIS community. From our own research perspective
the clients allows us to examine other issues, such security and authentication 
within
GIS. We must commend the quality of the open source products and the assistance
that we received from the developers of those products.
 
Id: 162
Place: Lausanne, Switzerland
Room: Amphipôle (niv. 3)
Starting date:
-- not yet scheduled --   
Duration: 00'
Contribution type: Poster
Primary Authors: Mr. BROWNE, Patrick (School of Computing, Dublin Institute of Technology)
Presenters: Mr. BROWNE, Patrick
 
Included in session: Posters
 

EPFL | Powered by Indico |  HELP