Cacher les modifications mineures - Affichage du code
http://perso0.free.fr/cgi-bin/wwwcount.cgi?dd=C&df=r1.bocher.gif
geoSQL Builder
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
http://r1.bocher.free.fr/logiciel/sqlbuilder/loadpostgislayer.png | Load a postgis layer : Official plugin postgis |
http://r1.bocher.free.fr/logiciel/sqlbuilder/postgislayer.png | Postgis layer loading |
http://r1.bocher.free.fr/logiciel/sqlbuilder/simplepostgisbuilder.png | Under construction |
http://r1.bocher.free.fr/logiciel/sqlbuilder/simplepostgisbuilderTree.png | Under construction |
iSQLViewer for OpenJUMP
http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlopenjump.png | New plugin to use iSQLViewer with OpenJUMP |
http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlopenjumpimport.png | Under construction |
http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlopenjumpcompletion.png | 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
geoSQL Builder