Wikipersonneld'ErwanBocher
Il faut mieux pomper même s'il ne se passe rien que risquer qu'il se passe quelque chose de pire en ne pompant pas. J.Rouxel

geoSQL Builder

Currently I'm working on a SQL builder to manage spatial database. The aim is to execute SQL code using spatial operators and predicats. Result is displayed like a table or like a geographic layer.

The data must be stored and exchanged using OGC specifications.

Technology

SIG front end : OpenJUMP (projet-sigle version) and gvSIG (0.61)

Plugin : official postgis OpenJUMP plugin http://openjump.org/wiki/show/Plugins

Spatial database : PostgreSQL with Postgis extension

SQL front end : iSQLViewer

OS : Xubuntu and WindowsXP

Screenshots

Official postgis plugin modified

	Load a postgis layer : Official plugin postgis
	Postgis layer loading
	Under construction
	Under construction

iSQLViewer for OpenJUMP

	New plugin to use iSQLViewer with OpenJUMP
	Under construction
	Under construction

Download

'Official postgis plugin modified binary and sources' : http://r1.bocher.free.fr/logiciel/sqlbuilder/simplepostgisplugin-put-in-lib-ext.tar

iSQLViewer for OpenJUMP binary and sources : http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlviewer4openjump-put-in-lib-ext.tar