162 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. FOSS4G2006 - Free And Open Source Software for Geoinformatics Posters Patrick Browne patrick.browne@comp.dit.ie Patrick Browne patrick.browne@comp.dit.ie <MaKaC.conference.ContributionType object at 0xb4934fac>