OpenJUMP Wiki - User contributions [en]

Beanshell:Changing linewidth of selected layers

2015-05-25T04:48:52Z

Jratike80: Simplified code

{
width = 5;
for (lyr : wc.layerNamePanel.selectedLayers) {
lyr.basicStyle.setLineWidth(width);
}
wc.layerViewPanel.repaint();
}

Beanshell:Changing linewidth of selected layers

2015-05-21T12:22:02Z

Jratike80: Script that changes line width to 5 for all selected layers

{
width = 5;
for (lyr : wc.layerNamePanel.selectedLayers) {
lyr.getStyle(com.vividsolutions.jump.workbench.ui.renderer.style.BasicStyle.class).setLineWidth(width);
}
wc.layerViewPanel.repaint();
}

Scripting with BeanShell

2015-05-21T12:14:38Z

Jratike80:

== What is BeanShell? ==

BeanShell is a small, free, embeddable Java source interpreter with object scripting language features, written in Java. BeanShell dynamically executes standard Java syntax and extends it with common scripting conveniences such as loose types, commands, and method closures like those in Perl and JavaScript.

In the context of Jump, BeanShell enables the automation of repetative tasks or to accomplish tasks that are not possible using the GUI without the need for plugin modules or modification of the application source code.

See http://www.beanshell.org/ for more information on BeanShell.

== BeanShell in OpenJUMP ==

To open the BeanShell scripting window select the following menu option:

View -> BeanShell...

It is a good idea to surround all your scripts in a set of braces. I.e.

{
script...
}

In BeanShell you may access JavaBean properties as if they were fields. For example ''wc.layerManager'' is the same as ''wc.getLayerManager()''.

There is no facility to save and load a script. If you plan to reuse your scripts, develop the script in a text editor and then paste into the BeanShell window as needed.

If you want to write Beanshell scripts you can also use the [http://geo.michaelm.free.fr/OpenJUMP/resources/ Beanshell-Editor-JUMP Plugin (bsheditor4jump-0.2.jar)] that has been written by Michael Michaud.

== JUMP BeanShell examples ==

Some of the following scripts are not very useful. Instead they are indented as examples which can be easily adapted to perform useful tasks.

* [[Beanshell:Changing linewidth of selected layers]]
* [[Beanshell:Saving View as Image]]
* [[Beanshell:Loading an Image into the task]]
* [[Beanshell:Toggle Layer Visibility]]
* [[Beanshell:Set an attribute fore every feature of a Layer]]
* [[Beanshell:Combine two selected layers]]
* [[Beanshell:Replace point symbols with green pushpin]]
* [[Beanshell:Removing repeated points in selected layers feature geometries]]
* [[Beanshell:Opening a project]]
* [[Beanshell:Limit labels to one per street]]
* [[Beanshell:Scripts for Roadmatcher]]
* [[Beanshell:Create an image layer from a file or URL]]
* [[Beanshell:Find features with repeated points]]
* [[Beanshell:Get the WMS URL that JUMP is using]]
* [[Beanshell:Fill in a JUMP column]]
* [[Beanshell:Setting North Arrow options]]
* [[Beanshell:Setting Scale Bar options]]
* [[Beanshell:Converting JML files to shapefiles]]
* [[Beanshell:Chain Copy/Paste/Move using PlugIns and CursorTool]]

Working with Raster

2013-12-30T10:59:31Z

Jratike80: /* Open Raster Files */

'''back to''' New User Guide [[Index]] page

== Open Raster Files ==

All raster readers support georeferencing via world file (see http://en.wikipedia.org/wiki/World_file). Also see [[How to georeference rasters]].

To open raster image files
: click on '''File>Open''' and select '''File''' on the left side
: or
: use '''File>Open File'''
: or
: use drag and drop by selecting the image file in file manager window and dragging it into OpenJUMP project

There is a '''Layer>Image Layer Manager''' which allows you load several images into one layer and manage them.

=== '''Format support''' ===

Currently [29.11.2013 OJ snapshot] OpenJUMP can read

BMP, DCX, FPX, GIF, JB2, JBIG2, JPEG, PAM, PBM, PCX, PGM, PNG, PNM, PPM, PSD, TGA, TIFF, WBMP, XBM, XPM

files out of the box. Additionally OpenJUMP Plus supports reading

* ECW, JPEG2000
** via native ECW SDK libraries with 32bit java on Windows, Linux, MacOSX
** see [[ECW]], [[JPEG2000]]
* MRSID
** via mrsid console binaries
** see [[MrSID]]
* ECW, JPEG2000, MRSID, NITF and many more (currently on Windows, Linux only)
** via native GDAL libraries
** see [[#Referenced Image reader]]

=== '''Buffered Image Apache Commons reader ===

Reads a variety of raster formats
http://commons.apache.org/proper/commons-imaging/formatsupport.html
into memory, so be careful with big files.

=== '''GeoTIFF Plus (JAI) reader ===

The old GeoTIFF reader enhanced to support more formats. As the name suggests it supports GeoTIFF information.

=== '''Referenced Image reader ===

Supports reading raster files with all java APIs available in jre (ImageIO[ext], JAI, ImageCodec...). There maybe duplicate readers here to offer the user the choice to figure out which one works best or at all with the image files at hand.

Georeferencing is done via world files, GeoTIFF information or GDAL reader if installed like described below.

Additionally reads ECW, JPEG2000, MRSID and lots of [http://github.com/geosolutions-it/imageio-ext/wiki/GDAL-framework-and-plugins more formats] on '''Windows, Linux only''' provided
* OpenJUMP Plus is used
* native GDAL libraries are installed correctly
** download GDAL-*.zip from https://sourceforge.net/projects/jump-pilot/files/OpenJUMP_plugins/Drivers/
** install instruction can be found within the zip file
'''Note:''' while not very performant, it works :)

'''Note:''' GDAL reader has the widest support for different tiff/GeoTIFF variants. If other drivers fail, try with GDAL. Typical example is images which are compressed with "deflate" method. GDAL can also utilise overviews (subsampled versions of the images, pyramid layers) if they exist which can make browsing much faster in small scales.

=== '''Sextante Raster framework ===

Load an image/raster using the function '''File>Open...>'''. Select in the left window the "Sextante Raster Image" option.

OpenJUMPs PLUS edition contains the Sextante Toolbox. That toolbox contains lots of raster processing and analysis functions.

== Save Raster Files ==

OpenJUMP can save a project view to raster files.
To save the view to Raster file choose '''File>Save View as Image...'''

Currently only PNG and JPG are supported.

OpenJUMP can save to georeferenced file with world file. To save to georeferenced file make sure that the option '''Write World File''' is enabled.
The Fence function in the '''Save as Image''' window allows to save as Image the part of project within a fence.

== Raster Transparency ==

Most readers respect the transparency that can be set in the layer properties context dialogue.

== Georeference Raster ==

See [[How to georeference rasters]] page

== Raster Reprojection ==

Currently OpenJUMP does not support reprojection of Raster files.
You can use [http://fwtools.maptools.org/ FWTools]: a set of tools for Linux and Windowsto which can view/edit/save several raster and vector file formats.
Based on [http://www.gdal.org/ GDAL] and [http://gdal.org/ogr/ OGR] libraries, it includes the viewer [http://openev.sourceforge.net/ OpenEV] that provides access to the files with a graphic interface (see also [http://gdal.org/formats_list.html GDAL Raster Formats] and [http://gdal.org/ogr/ogr_formats.html OGR Vector Format]. There is also a tool to reproject raster files

See also [http://www.fsdeveloper.com/wiki/index.php?title=Working_with_FwTools_and_GeoTIFF_files Working with FwTools and GeoTIFF files] from fsdevelopers.com

Some usefull information about raster reprojection software can be found in Leszek Pawlowicz's post [http://freegeographytools.com/2008/reprojecting-raster-imagery-i Reprojecting Raster Imagery I] and [http://freegeographytools.com/2008/reprojecting-raster-imagery-ii-erdas-viewfinder Reprojecting Raster Imagery II - ERDAS Viewfinder]

Some usefull software for local or national coordinate raster reprojection: [http://www.progettotrio.it/html/mod_prof/cartografia/lucchesi/tut/tut_03_georeferenziazione_01.zip Traspunto] (Gauss-Boaga, datum Roma40 - UTM, datum ED50 - UTM, datum WGS84)

== Raster Filters ==

Image [http://gis.vsb.cz/ruzicka/Projekty/jump/plugins/imageenh.zip Plugin Enhancement], from Lenka Ferkova and Jan Kucharczyk, allows some filter operations on Image (edge, blur, inverse). User can define their own kernel filter.

<hr/>

'''back to''' New User Guide [[Index]] page

Working with Raster

2013-12-30T10:49:45Z

Jratike80: /* Referenced Image reader */

'''back to''' New User Guide [[Index]] page

== Open Raster Files ==

All raster readers support georeferencing via world file (see http://en.wikipedia.org/wiki/World_file). Also see [[How to georeference rasters]].

To open raster image files
: click on '''File>Open''' and select '''File''' on the left side
: or
: use '''File>Open File'''

There is a '''Layer>Image Layer Manager''' which allows you load several images into one layer and manage them.

=== '''Format support''' ===

Currently [29.11.2013 OJ snapshot] OpenJUMP can read

BMP, DCX, FPX, GIF, JB2, JBIG2, JPEG, PAM, PBM, PCX, PGM, PNG, PNM, PPM, PSD, TGA, TIFF, WBMP, XBM, XPM

files out of the box. Additionally OpenJUMP Plus supports reading

* ECW, JPEG2000
** via native ECW SDK libraries with 32bit java on Windows, Linux, MacOSX
** see [[ECW]], [[JPEG2000]]
* MRSID
** via mrsid console binaries
** see [[MrSID]]
* ECW, JPEG2000, MRSID, NITF and many more (currently on Windows, Linux only)
** via native GDAL libraries
** see [[#Referenced Image reader]]

=== '''Buffered Image Apache Commons reader ===

Reads a variety of raster formats
http://commons.apache.org/proper/commons-imaging/formatsupport.html
into memory, so be careful with big files.

=== '''GeoTIFF Plus (JAI) reader ===

The old GeoTIFF reader enhanced to support more formats. As the name suggests it supports GeoTIFF information.

=== '''Referenced Image reader ===

Supports reading raster files with all java APIs available in jre (ImageIO[ext], JAI, ImageCodec...). There maybe duplicate readers here to offer the user the choice to figure out which one works best or at all with the image files at hand.

Georeferencing is done via world files, GeoTIFF information or GDAL reader if installed like described below.

Additionally reads ECW, JPEG2000, MRSID and lots of [http://github.com/geosolutions-it/imageio-ext/wiki/GDAL-framework-and-plugins more formats] on '''Windows, Linux only''' provided
* OpenJUMP Plus is used
* native GDAL libraries are installed correctly
** download GDAL-*.zip from https://sourceforge.net/projects/jump-pilot/files/OpenJUMP_plugins/Drivers/
** install instruction can be found within the zip file
'''Note:''' while not very performant, it works :)

'''Note:''' GDAL reader has the widest support for different tiff/GeoTIFF variants. If other drivers fail, try with GDAL. Typical example is images which are compressed with "deflate" method. GDAL can also utilise overviews (subsampled versions of the images, pyramid layers) if they exist which can make browsing much faster in small scales.

=== '''Sextante Raster framework ===

Load an image/raster using the function '''File>Open...>'''. Select in the left window the "Sextante Raster Image" option.

OpenJUMPs PLUS edition contains the Sextante Toolbox. That toolbox contains lots of raster processing and analysis functions.

== Save Raster Files ==

OpenJUMP can save a project view to raster files.
To save the view to Raster file choose '''File>Save View as Image...'''

Currently only PNG and JPG are supported.

OpenJUMP can save to georeferenced file with world file. To save to georeferenced file make sure that the option '''Write World File''' is enabled.
The Fence function in the '''Save as Image''' window allows to save as Image the part of project within a fence.

== Raster Transparency ==

Most readers respect the transparency that can be set in the layer properties context dialogue.

== Georeference Raster ==

See [[How to georeference rasters]] page

== Raster Reprojection ==

Currently OpenJUMP does not support reprojection of Raster files.
You can use [http://fwtools.maptools.org/ FWTools]: a set of tools for Linux and Windowsto which can view/edit/save several raster and vector file formats.
Based on [http://www.gdal.org/ GDAL] and [http://gdal.org/ogr/ OGR] libraries, it includes the viewer [http://openev.sourceforge.net/ OpenEV] that provides access to the files with a graphic interface (see also [http://gdal.org/formats_list.html GDAL Raster Formats] and [http://gdal.org/ogr/ogr_formats.html OGR Vector Format]. There is also a tool to reproject raster files

See also [http://www.fsdeveloper.com/wiki/index.php?title=Working_with_FwTools_and_GeoTIFF_files Working with FwTools and GeoTIFF files] from fsdevelopers.com

Some usefull information about raster reprojection software can be found in Leszek Pawlowicz's post [http://freegeographytools.com/2008/reprojecting-raster-imagery-i Reprojecting Raster Imagery I] and [http://freegeographytools.com/2008/reprojecting-raster-imagery-ii-erdas-viewfinder Reprojecting Raster Imagery II - ERDAS Viewfinder]

Some usefull software for local or national coordinate raster reprojection: [http://www.progettotrio.it/html/mod_prof/cartografia/lucchesi/tut/tut_03_georeferenziazione_01.zip Traspunto] (Gauss-Boaga, datum Roma40 - UTM, datum ED50 - UTM, datum WGS84)

== Raster Filters ==

Image [http://gis.vsb.cz/ruzicka/Projekty/jump/plugins/imageenh.zip Plugin Enhancement], from Lenka Ferkova and Jan Kucharczyk, allows some filter operations on Image (edge, blur, inverse). User can define their own kernel filter.

<hr/>

'''back to''' New User Guide [[Index]] page

OpenJUMP with SpatialLite

2011-08-24T08:51:54Z

Jratike80: /* Introduction */

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here] Note! Does not work properly with OpenJUMP 1.4. Use version 1.3 instead.

== Using SpatiaLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using it).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above. Maximum speed of 0 km/h may feel odd. We will return to this later.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable error messages.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatiaLite with Spatialite Reader Plugin ==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, the SQL window of the plugin connects directly to SpatiaLite database and thus everything that can be done with Spatialite SQL is doable through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database. A new query SELECT * FROM roads will show that the values were really updated.

[[File:Spatialitereader_10.png]]

Plugins for OpenJUMP

2010-08-20T09:13:45Z

Jratike80: /* XI - GPS Plugins */

Below you will find a non-complte listing of available plugins for OpenJUMP. To add a plugin to OpenJUMP, simply put the JAR file into the OpenJUMP lib/ext directory. Eventually you need to unzip the file. See also our [[Installing Plugins]] page.

== Websites with several plugins ==

* The JUMP Project Plugins: http://www.jump-project.org/portal.php?PID=PL
* Project PIROL plugins: http://www.al.fh-osnabrueck.de/jump-download.html
* Edgar Soldin plugins : http://soldin.de/about/2004-jump_plugins/ If you have problems installing the Coordinate-Transformation-Plugin see here: [[Installing Plugins]] and [[Working with Projections]]
* project SIGLE: http://www.projet-sigle.org/
* Michael Michaud (in french): http://michael.michaud.free.fr/index_jump.html and http://geo.michaelm.free.fr
* GISAK.VSB: http://gis.vsb.cz/ruzicka/Projekty/jump/index.php
* CADPLAN Plugins: http://www.cadplan.com.au/jump.html
* GEOSTAF: http://digilander.libero.it/valruggero/download.html

== Plugins for OpenJUMP ==

=== '''I - Editing Plugins''' ===

* New ISA 2.5 tools for OpenJUMP deriving from SkyJUMP. Download "isa-2.5.jar":http://www.ashsiii.com/downloads/openjump/isa-2.5.jar and place it in your \OpenJUMP /lib/ext folder. Download also a modified [http://www.ashsiii.com/downloads/openjump/workbench-properties.xml workbench-properties.xml] and place it in your OpenJUMP /bin folder to enables the individual tools on OJ menus.
** KML datasource
** Text Block Annotation and Interactive Buffer, on Editing toolbox (1)
** Clip To Fence (1) , Orthogonalize and Auto Assign Attribute (1) on Tools menu.
(1) Added to \OpenJUMP nightly snapshot

<hr/>

=== '''II - Raster Image Plugins''' ===

OpenJUMP provides a basic raster support to display TIFF, JPG and PNG. ECW support is also provides if ECW drivers are correctly installed (see [[Working with Raster]] page). There are other raster plugins. Some of them require Java Advanced Imaging (JAI) libray. JAI for different platforms can be found [http://java.sun.com/products/java-media/jai/current.html here]

* an improved version is the image plugin from Project PIROL: [http://www.al.fh-osnabrueck.de/jump-download.html download here] - which in the new version also supports GeoTIFF files To work with the pirol plugin you need to install JAI and additionally to download the BaseClasses package.

* another fine image plugin is the TANATO plugin from SIGLE: [http://projetsigle.free.fr/ressources/logiciels/jdgal/OJRasterMap_Plugin1.0.zip download here] - which support apart from several image formats (ECW, TIF, JPG as Raster Catalog Data) the generation of TIN and TIN-Flow calculations (note: the page is in french!)

* To display ESRI ASCII raster the raster plugin from SIGLE team may help you [http://www.projet-sigle.org/IMG/zip/RasterPlugin-i18n.zip download here]

<hr/>

=== '''III - Print Plugins''' ===

* Basic Print PlugIn supporting also multiple sheets by Geoff (http://www.cadplan.com.au/). It should work also with JUMP - It requires [http://sourceforge.net/project/downloading.php?groupname=itext&filename=iText-2.1.3.jar&use_mirror=osdn iText] library to work.

* [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=219772 Print Layout Plugin] by [http://www.intevation.de Intevation]

<hr/>

=== '''IV - Database Plugins''' ===

* '''DB Query''' allows OpenJUMP users to give arbitrary database queries to retrieve and display geographic feature sets ([http://jumpdbqplugin.sourceforge.net/ see documentation]) from PostGIS, MySQL, SpatialLite and Oracle databases. See also the tutorial "[[OpenJUMP with SpatialLite]]".
* '''PostGIS''' database connector ([https://sourceforge.net/project/showfiles.php?group_id=118054 download]) : see also [[Installing Plugins]]
* '''PostGIS plugin''' ([http://r1.bocher.free.fr/logiciel/sqlbuilder/simplepostgisplugin-put-in-lib-ext.tar download)] by Erwan Brocher. See also Erwan's [http://r1.bocher.free.fr/index.php?n=Main.GeoSQLBuilder wiki page] for the description
* '''iSQLViewer''': SQL front end by Erwan Brocher([http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlviewer4openjump-put-in-lib-ext.tar download]).
* '''ArcSDE''' database reader (as separate [https://sourceforge.net/project/showfiles.php?group_id=118054 download] but also contained in ISA 2.0 tools package - see below)
* '''Oracle''' database reader ([https://sourceforge.net/project/showfiles.php?group_id=118054 download])
* '''SpatialLite''' database reader ([http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download download])

Note, an introduction on how to use OpenJUMP with PostGIS can be found in OpenJUMP 1.3 tutorial presented at OGRS 2009 (see the [[Downloadable Tutorials and Guides]] section of the wiki or our download area on SourceForge). Also the book "[http://www.manning.com/obe/ PostGIS in Action]" contains a chapter on that.

<hr/>

=== '''V - Other Dataformats''' ===

* '''DXF Driver''' Loads/write dxf files into/from OpenJUMP.
# from ''Michael Michaud': [http://geo.michaelm.free.fr/OpenJUMP/resources/drivers download]
# Another dxf plugin from ''Dante'' and ''Rammi'':
#* download JUMP plugin (jar): http://jump-pilot.sourceforge.net/download/driver-dxf.jar by Dante Fuster, Peru, contact: dante.fuster[=at=]gmail.com (note: download also the CAFF program below and place the file ''dxfviewer-swing-pro.jar'' as well in OpenJUMPs /lib/ext directory like driver-dxf.jar
#* download CAFF dxf viewer: http://jump-pilot.sourceforge.net/download/dxfviewer-swing-pro.jar by Rammi, contact: rammi[=at=]caff.de, note: just click on the jar file to start the application

* '''MIF/MID Driver''' - Loads/write mif-mid files into/fromOpenJUMP. From Michael Michaud, download: http://geo.michaelm.free.fr/OpenJUMP/resources/drivers

* '''GeoConcept Driver''' Loads/write GeoConcept files into/from OpenJUMP. From Michael Michaud, download http://geo.michaelm.free.fr/OpenJUMP/resources/drivers

* '''Excel file Driver''' - Loads Microsoft Excel files. From Dante Fuster, download (including example file): http://jump-pilot.sourceforge.net/download/excel_plugin.zip
<hr/>

=== '''VI - Internet Datasources and Web-Processing''' ===

* '''WFS PlugIn /WFS-T PlugIn''' for OGC WFS Standards 1.0 and 1.1 by Lat/Lon (http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=150819 , [[WFS PlugIn Description]])

* '''WPS PlugIn''' for OGC Web Processing Standard 1.0 by 52 North, info: http://52north.org/maven/project-sites/wps/52n-wps-client-jump/installation.html

<hr/>

=== '''VII - Spatial Analysis and Editing PlugIns''' ===

* '''Map Generalization Toolbox V1.0''' :https://sourceforge.net/project/showfiles.php?group_id=118054

* '''Sextante''', a set of free geospatial analysis tools developed by the Junta de Extremadura (ES). Download the latest beta Souceforge [http://forge.osor.eu/plugins/wiki/index.php?id=13&type=g page] by Victor Olay Download the [http://forge.osor.eu/plugins/wiki/index.php?Downloads&id=13&type=g latest version] for OpenJUMP. See also [[OpenJUMP and Sextante]] page

* Clean and explode with ArcGis generated contour lines: see authors homepage:http://www.geo.unizh.ch/~sstein/

* '''Landscape Ecology''': An extension to extract edges, core area, patches, corridors, branches and shortcut areas as described in (Vogt et al. 2007- Ecol. Ind.) but with buffer operations. It also provides several polygon metrics. - [http://www.geo.unizh.ch/publications/sstein/jumpplugins/landscapepatternextension.zip download]

* '''Quality Assurance Plugin''' from the original JUMP project to work with OpenJUMP: [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=243601 download]

* '''Road Matcher Plugin''' from the original JUMP project to work with OpenJUMP - [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=320958 download] Access to the source code: [http://github.com/ssinger/roadmatcher/tree/openjump here] - and on our project SVN. We thank Steve Singer for making the necessary adoptions - this way Road Matcher could be used in an [http://wiki.openstreetmap.org/wiki/Geobase_NRN_-_OSM_Map_Feature OpenStreetMap Conflation project]

* '''Graph Toolbox Plugin''' from Michaël Michaud - jar file and packaged source code are available at [http://sourceforge.net/projects/jump-pilot/files/p_%20More%20Plugins/ download], and a short documentation (available in english and in french) can be downloaded: [https//sourceforge.net/projects/jump-pilot/files/p_%20More%20Plugins/OJ%20graph%20toolbox/GraphExtension4OJ.pdf/download engl. doc], [http://jump-pilot.svn.sourceforge.net/viewvc/jump-pilot/plug-ins/GraphToolboxPlugin/trunk/doc/ general]

* '''Skeletonizer Plugin''' from the original JUMP project - creates skeletons of polygon objects. Download it from [http://sourceforge.net/downloads/jump-pilot/p_%20More%20Plugins/JUMP%20Skeletonizer%20Plugin/ here]

* '''GeOxygene Plugin''' for the GeOygene analysis & computation platform. Download from [http://sourceforge.net/projects/oxygene-project/files/ here]

<hr/>

=== '''VIII - Coordinate Tranformation PlugIn''' ===

* '''CTS extension''' [http://soldin.de/about/2004-jump_plugins/gt2jump.cts-0.1a.zip download] by Edgar Soldin. It allows the user to assign a coordinate reference system (CRS) to vector layers and reproject it. Please look at [[Working with Projections]] for installation and instructions.

<hr/>

=== '''IX - Security for Geodata''' ===

* '''Watermarking Plugin''' for Jump and Openjump by Julien Lafaye - please visit his [http://cedric.cnam.fr/~lafaye_j/ webpage] to download the [http://cedric.cnam.fr/~lafaye_j/index.php?n=Main.Software WaterGoatOpenJumpPlugin]. It is distributed under the LGPL license.

<hr/>

=== '''X - Programming and Scripting Support''' ===

* '''Beanshell Editor''' is a text editor using a very old version of jEdit for syntax color. You can use it to write, launch, and save your own beanshell scripts. You can download it [http://geo.michaelm.free.fr/OpenJUMP/resources/bsheditor4jump-0.2.jar here]

* '''Groovy''': we also have people that started to develop with [http://groovy.codehaus.org Groovy] and OpenJUMP. For more info check this page [[OpenJUMP and Groovy]]

<hr/>

=== '''XI - GPS Plugins''' ===

* '''GPS extension Plugin''' new version available at https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/gps_0.2rc4.zip/download

Coordinate transformation plugin is needed also if OpenJUMP task is using some other projection than the GPS output.
https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/cts_0.2rc4.zip/download

Instructions for using GPS extension available at https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=GPS_plugin

* '''nmeaRaw.jar Plugin''' for Openjump that reads GPS logs (GGA and RMC) : see download page of the PIROL Project http://www.al.fh-osnabrueck.de/jump-download.html
* script to convert the NMEA data into a Jump compatible GML file available by Joe Desbonet : see emails on Jump-User mail list from 21.01.2006 with subject: GPS

<hr/>

=== '''XII - Styles''' ===

* '''VertexSymbols''' Plugin adds vector or raster symbols to vertex. Download page from Cadplan http://www.cadplan.com.au/jump.html

* '''Jump Fill Pattern''' Plugin allows user to add their own fill patterns to an Openjump project from Cadplan http://www.cadplan.com.au/jump.html

<hr/>

=== '''XIII - Charts / Plots''' ===

* Create pie, column or stacked column charts for presenting your numeric attribute data of an Openjump layer: http://services.giub.uni-bonn.de/downloads/openjump/

* Based on the first one, Geoff created a newer Version which returns the charts as permanent layer: http://www.cadplan.com.au/jump.html

* A plugin that provides attribute classification tools and charts (scatter plot, bar plot, histogram): http://www.geo.uzh.ch/~sstein/

== Plugins for JUMP ==

These plugins are already (partly) integrated in OpenJUMP.

* Selection Tools Package: see authors homepage: http://www.geo.unizh.ch/~sstein/
* SVG image export PlugIn (exports max. 100 features per layer): see authors homepage: http://www.geo.unizh.ch/~sstein/
* ISA Tools Package: contains several useful tools especially for geometry editing. The plugin contains also the possibility to display \MrSid Raster Images and connect to \ArcSDE (download: https://sourceforge.net/project/showfiles.php?group_id=118054). It may work only with OpenJUMP 1.0
* The Looks Extension: http://jonathanaquino.com/looks_extension/looks-extension-1.0.zip applies the aesthetically pleasing JGoodies Looks look-and-feel to Openjump. Author: Jonathan Aquino
* Proportional symbols plugin for Openjump. It's accessible by the "Analyse" menu, and tested against Openjump 0.1 french version. http://www.geotests.net/jump/symboles.jar Hope his helps. Author: Laurent http://www.univ-tlse2.fr/geoprdc http://www.geotests.net/blog
* Roadmatcher Application : http://www.jump-project.org/project.php?PID=RM&SID=DETA#overview* plugin developed by The JUMP Project
* Jython - Python for JUMP contained in ISA 2.0 plugin (see below or http://sourceforge.net/project/showfiles.php?group_id=118054)

== Installing Plugins ==
* see [[Installing Plugins]]

== Popular Plugins ==
* see [[Popular Plugins]]

== Plugins for Kosmo ==
(Up to come..)

Plugins for OpenJUMP

2010-08-20T09:13:18Z

Jratike80: /* XI - GPS Plugins */

Below you will find a non-complte listing of available plugins for OpenJUMP. To add a plugin to OpenJUMP, simply put the JAR file into the OpenJUMP lib/ext directory. Eventually you need to unzip the file. See also our [[Installing Plugins]] page.

== Websites with several plugins ==

* The JUMP Project Plugins: http://www.jump-project.org/portal.php?PID=PL
* Project PIROL plugins: http://www.al.fh-osnabrueck.de/jump-download.html
* Edgar Soldin plugins : http://soldin.de/about/2004-jump_plugins/ If you have problems installing the Coordinate-Transformation-Plugin see here: [[Installing Plugins]] and [[Working with Projections]]
* project SIGLE: http://www.projet-sigle.org/
* Michael Michaud (in french): http://michael.michaud.free.fr/index_jump.html and http://geo.michaelm.free.fr
* GISAK.VSB: http://gis.vsb.cz/ruzicka/Projekty/jump/index.php
* CADPLAN Plugins: http://www.cadplan.com.au/jump.html
* GEOSTAF: http://digilander.libero.it/valruggero/download.html

== Plugins for OpenJUMP ==

=== '''I - Editing Plugins''' ===

* New ISA 2.5 tools for OpenJUMP deriving from SkyJUMP. Download "isa-2.5.jar":http://www.ashsiii.com/downloads/openjump/isa-2.5.jar and place it in your \OpenJUMP /lib/ext folder. Download also a modified [http://www.ashsiii.com/downloads/openjump/workbench-properties.xml workbench-properties.xml] and place it in your OpenJUMP /bin folder to enables the individual tools on OJ menus.
** KML datasource
** Text Block Annotation and Interactive Buffer, on Editing toolbox (1)
** Clip To Fence (1) , Orthogonalize and Auto Assign Attribute (1) on Tools menu.
(1) Added to \OpenJUMP nightly snapshot

<hr/>

=== '''II - Raster Image Plugins''' ===

OpenJUMP provides a basic raster support to display TIFF, JPG and PNG. ECW support is also provides if ECW drivers are correctly installed (see [[Working with Raster]] page). There are other raster plugins. Some of them require Java Advanced Imaging (JAI) libray. JAI for different platforms can be found [http://java.sun.com/products/java-media/jai/current.html here]

* an improved version is the image plugin from Project PIROL: [http://www.al.fh-osnabrueck.de/jump-download.html download here] - which in the new version also supports GeoTIFF files To work with the pirol plugin you need to install JAI and additionally to download the BaseClasses package.

* another fine image plugin is the TANATO plugin from SIGLE: [http://projetsigle.free.fr/ressources/logiciels/jdgal/OJRasterMap_Plugin1.0.zip download here] - which support apart from several image formats (ECW, TIF, JPG as Raster Catalog Data) the generation of TIN and TIN-Flow calculations (note: the page is in french!)

* To display ESRI ASCII raster the raster plugin from SIGLE team may help you [http://www.projet-sigle.org/IMG/zip/RasterPlugin-i18n.zip download here]

<hr/>

=== '''III - Print Plugins''' ===

* Basic Print PlugIn supporting also multiple sheets by Geoff (http://www.cadplan.com.au/). It should work also with JUMP - It requires [http://sourceforge.net/project/downloading.php?groupname=itext&filename=iText-2.1.3.jar&use_mirror=osdn iText] library to work.

* [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=219772 Print Layout Plugin] by [http://www.intevation.de Intevation]

<hr/>

=== '''IV - Database Plugins''' ===

* '''DB Query''' allows OpenJUMP users to give arbitrary database queries to retrieve and display geographic feature sets ([http://jumpdbqplugin.sourceforge.net/ see documentation]) from PostGIS, MySQL, SpatialLite and Oracle databases. See also the tutorial "[[OpenJUMP with SpatialLite]]".
* '''PostGIS''' database connector ([https://sourceforge.net/project/showfiles.php?group_id=118054 download]) : see also [[Installing Plugins]]
* '''PostGIS plugin''' ([http://r1.bocher.free.fr/logiciel/sqlbuilder/simplepostgisplugin-put-in-lib-ext.tar download)] by Erwan Brocher. See also Erwan's [http://r1.bocher.free.fr/index.php?n=Main.GeoSQLBuilder wiki page] for the description
* '''iSQLViewer''': SQL front end by Erwan Brocher([http://r1.bocher.free.fr/logiciel/sqlbuilder/isqlviewer4openjump-put-in-lib-ext.tar download]).
* '''ArcSDE''' database reader (as separate [https://sourceforge.net/project/showfiles.php?group_id=118054 download] but also contained in ISA 2.0 tools package - see below)
* '''Oracle''' database reader ([https://sourceforge.net/project/showfiles.php?group_id=118054 download])
* '''SpatialLite''' database reader ([http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download download])

Note, an introduction on how to use OpenJUMP with PostGIS can be found in OpenJUMP 1.3 tutorial presented at OGRS 2009 (see the [[Downloadable Tutorials and Guides]] section of the wiki or our download area on SourceForge). Also the book "[http://www.manning.com/obe/ PostGIS in Action]" contains a chapter on that.

<hr/>

=== '''V - Other Dataformats''' ===

* '''DXF Driver''' Loads/write dxf files into/from OpenJUMP.
# from ''Michael Michaud': [http://geo.michaelm.free.fr/OpenJUMP/resources/drivers download]
# Another dxf plugin from ''Dante'' and ''Rammi'':
#* download JUMP plugin (jar): http://jump-pilot.sourceforge.net/download/driver-dxf.jar by Dante Fuster, Peru, contact: dante.fuster[=at=]gmail.com (note: download also the CAFF program below and place the file ''dxfviewer-swing-pro.jar'' as well in OpenJUMPs /lib/ext directory like driver-dxf.jar
#* download CAFF dxf viewer: http://jump-pilot.sourceforge.net/download/dxfviewer-swing-pro.jar by Rammi, contact: rammi[=at=]caff.de, note: just click on the jar file to start the application

* '''MIF/MID Driver''' - Loads/write mif-mid files into/fromOpenJUMP. From Michael Michaud, download: http://geo.michaelm.free.fr/OpenJUMP/resources/drivers

* '''GeoConcept Driver''' Loads/write GeoConcept files into/from OpenJUMP. From Michael Michaud, download http://geo.michaelm.free.fr/OpenJUMP/resources/drivers

* '''Excel file Driver''' - Loads Microsoft Excel files. From Dante Fuster, download (including example file): http://jump-pilot.sourceforge.net/download/excel_plugin.zip
<hr/>

=== '''VI - Internet Datasources and Web-Processing''' ===

* '''WFS PlugIn /WFS-T PlugIn''' for OGC WFS Standards 1.0 and 1.1 by Lat/Lon (http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=150819 , [[WFS PlugIn Description]])

* '''WPS PlugIn''' for OGC Web Processing Standard 1.0 by 52 North, info: http://52north.org/maven/project-sites/wps/52n-wps-client-jump/installation.html

<hr/>

=== '''VII - Spatial Analysis and Editing PlugIns''' ===

* '''Map Generalization Toolbox V1.0''' :https://sourceforge.net/project/showfiles.php?group_id=118054

* '''Sextante''', a set of free geospatial analysis tools developed by the Junta de Extremadura (ES). Download the latest beta Souceforge [http://forge.osor.eu/plugins/wiki/index.php?id=13&type=g page] by Victor Olay Download the [http://forge.osor.eu/plugins/wiki/index.php?Downloads&id=13&type=g latest version] for OpenJUMP. See also [[OpenJUMP and Sextante]] page

* Clean and explode with ArcGis generated contour lines: see authors homepage:http://www.geo.unizh.ch/~sstein/

* '''Landscape Ecology''': An extension to extract edges, core area, patches, corridors, branches and shortcut areas as described in (Vogt et al. 2007- Ecol. Ind.) but with buffer operations. It also provides several polygon metrics. - [http://www.geo.unizh.ch/publications/sstein/jumpplugins/landscapepatternextension.zip download]

* '''Quality Assurance Plugin''' from the original JUMP project to work with OpenJUMP: [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=243601 download]

* '''Road Matcher Plugin''' from the original JUMP project to work with OpenJUMP - [http://sourceforge.net/project/showfiles.php?group_id=118054&package_id=320958 download] Access to the source code: [http://github.com/ssinger/roadmatcher/tree/openjump here] - and on our project SVN. We thank Steve Singer for making the necessary adoptions - this way Road Matcher could be used in an [http://wiki.openstreetmap.org/wiki/Geobase_NRN_-_OSM_Map_Feature OpenStreetMap Conflation project]

* '''Graph Toolbox Plugin''' from Michaël Michaud - jar file and packaged source code are available at [http://sourceforge.net/projects/jump-pilot/files/p_%20More%20Plugins/ download], and a short documentation (available in english and in french) can be downloaded: [https//sourceforge.net/projects/jump-pilot/files/p_%20More%20Plugins/OJ%20graph%20toolbox/GraphExtension4OJ.pdf/download engl. doc], [http://jump-pilot.svn.sourceforge.net/viewvc/jump-pilot/plug-ins/GraphToolboxPlugin/trunk/doc/ general]

* '''Skeletonizer Plugin''' from the original JUMP project - creates skeletons of polygon objects. Download it from [http://sourceforge.net/downloads/jump-pilot/p_%20More%20Plugins/JUMP%20Skeletonizer%20Plugin/ here]

* '''GeOxygene Plugin''' for the GeOygene analysis & computation platform. Download from [http://sourceforge.net/projects/oxygene-project/files/ here]

<hr/>

=== '''VIII - Coordinate Tranformation PlugIn''' ===

* '''CTS extension''' [http://soldin.de/about/2004-jump_plugins/gt2jump.cts-0.1a.zip download] by Edgar Soldin. It allows the user to assign a coordinate reference system (CRS) to vector layers and reproject it. Please look at [[Working with Projections]] for installation and instructions.

<hr/>

=== '''IX - Security for Geodata''' ===

* '''Watermarking Plugin''' for Jump and Openjump by Julien Lafaye - please visit his [http://cedric.cnam.fr/~lafaye_j/ webpage] to download the [http://cedric.cnam.fr/~lafaye_j/index.php?n=Main.Software WaterGoatOpenJumpPlugin]. It is distributed under the LGPL license.

<hr/>

=== '''X - Programming and Scripting Support''' ===

* '''Beanshell Editor''' is a text editor using a very old version of jEdit for syntax color. You can use it to write, launch, and save your own beanshell scripts. You can download it [http://geo.michaelm.free.fr/OpenJUMP/resources/bsheditor4jump-0.2.jar here]

* '''Groovy''': we also have people that started to develop with [http://groovy.codehaus.org Groovy] and OpenJUMP. For more info check this page [[OpenJUMP and Groovy]]

<hr/>

=== '''XI - GPS Plugins''' ===

* '''GPS extension Plugin''' new version available at https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/gps_0.2rc4.zip/download

Coordinate transform plugin is needed also if OpenJUMP task is using some other projection than the GPS output.
https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/cts_0.2rc4.zip/download

Instructions for using GPS extension available at https://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=GPS_plugin

* '''nmeaRaw.jar Plugin''' for Openjump that reads GPS logs (GGA and RMC) : see download page of the PIROL Project http://www.al.fh-osnabrueck.de/jump-download.html
* script to convert the NMEA data into a Jump compatible GML file available by Joe Desbonet : see emails on Jump-User mail list from 21.01.2006 with subject: GPS

<hr/>

=== '''XII - Styles''' ===

* '''VertexSymbols''' Plugin adds vector or raster symbols to vertex. Download page from Cadplan http://www.cadplan.com.au/jump.html

* '''Jump Fill Pattern''' Plugin allows user to add their own fill patterns to an Openjump project from Cadplan http://www.cadplan.com.au/jump.html

<hr/>

=== '''XIII - Charts / Plots''' ===

* Create pie, column or stacked column charts for presenting your numeric attribute data of an Openjump layer: http://services.giub.uni-bonn.de/downloads/openjump/

* Based on the first one, Geoff created a newer Version which returns the charts as permanent layer: http://www.cadplan.com.au/jump.html

* A plugin that provides attribute classification tools and charts (scatter plot, bar plot, histogram): http://www.geo.uzh.ch/~sstein/

== Plugins for JUMP ==

These plugins are already (partly) integrated in OpenJUMP.

* Selection Tools Package: see authors homepage: http://www.geo.unizh.ch/~sstein/
* SVG image export PlugIn (exports max. 100 features per layer): see authors homepage: http://www.geo.unizh.ch/~sstein/
* ISA Tools Package: contains several useful tools especially for geometry editing. The plugin contains also the possibility to display \MrSid Raster Images and connect to \ArcSDE (download: https://sourceforge.net/project/showfiles.php?group_id=118054). It may work only with OpenJUMP 1.0
* The Looks Extension: http://jonathanaquino.com/looks_extension/looks-extension-1.0.zip applies the aesthetically pleasing JGoodies Looks look-and-feel to Openjump. Author: Jonathan Aquino
* Proportional symbols plugin for Openjump. It's accessible by the "Analyse" menu, and tested against Openjump 0.1 french version. http://www.geotests.net/jump/symboles.jar Hope his helps. Author: Laurent http://www.univ-tlse2.fr/geoprdc http://www.geotests.net/blog
* Roadmatcher Application : http://www.jump-project.org/project.php?PID=RM&SID=DETA#overview* plugin developed by The JUMP Project
* Jython - Python for JUMP contained in ISA 2.0 plugin (see below or http://sourceforge.net/project/showfiles.php?group_id=118054)

== Installing Plugins ==
* see [[Installing Plugins]]

== Popular Plugins ==
* see [[Popular Plugins]]

== Plugins for Kosmo ==
(Up to come..)

GPS extension - Track & insert points from serial gps device

2010-08-11T12:55:31Z

Jratike80:

== Introduction ==

OpenJUMP GPS plugin is made by Edgar Soldin and it can be downloaded from
https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/

== Supported GPS units ==

GPS plugin is reading data through a serial (COM)port of a computer. GPS receivers which are connected to a physical serial port should work out of the box. GPS receivers which are connected through USB connection need some system on the computer side for directing GPS signal into virtual COM port. Wired USB mouses and Bluetooth GPS receivers often come with drivers and software made for this purpose. One commercial alternative is GpsGate software. It is mentioned here only because it has been tested to work with Garmin eTrex Vista HCx unit on 32 bit Window Vista OS. There are probably other as well working programs. What is important that the GPS plugin must be able to find GPS signal through a serial port, either physical or virtual.

== Installation ==

Installation is done by unzipping the two zip files from the above address into OpenJUMP lib/ext directory.

== Testing the GPS plugin installation and GPS unit ==

Be sure to turn on your GPS unit and virtual serial port software if you are using such. GPS plugin is scanning the serial ports during OpenJUMP start, and it will not see virtual ports which are appearing after startup.

After starting OpenJUMP you should see a new menu item 'GPS' in the main menu bar (Fig. 1).

[[File:OJ_GPS_01.png]]

Select GPS Options

[[File:OJ_GPS_02.png]]

Settings:
Processing Format

alternatives NMEA, Garmin or Sirf. Only NMEA tested so far.

Update every ...

Slider selects how often the plugin will center OpenJUMP map into the GPS coordinates. Scale is between 0 to 600 seconds. Zero setting means that the map is not centered automatically, 600 centers the map in 10 minutes intervals.

Notice that you cannot see your current location on the map between autotic map updates. However, OpenJUMP will refresh the GPS coordinates in the info window and current locations can be recorded at any moment.

GPS Receiver Output CS

This setting must suit the GPS output. The default is WGS 84 which is also supported by all GPS receivers. If GPS is configured to send out coordinates in some other systems, OpenJUMP GPS plugin needs to have definitions for that system. They are stored in the cs.conf file which is located in the lib/ext/cts directory. The format used for defining the coordinate system is OGC Well Known Text. Good source for findig the projection definitions is spatialreference.org. For example string needed to add support for UTM zone 35N projection can be found from http://spatialreference.org/ref/epsg/32635/ogcwkt/

Tracking CS

This setting must suit the projection that is used in the OpenJUMP task.

Serial port options

These setting must suit the serial port where GPS is connected. With virtual ports the defaults are usually working.

Test Settings

If GPS is workin OK and serial port is configured correctly then pressing the Test Settings button will list the messages sent by the GPS in the window abow. See Fig. 3

[[File:OJ_GPS_03.png]]

== Using the GPS plugin ==

Close the GPS Options window and turn on the GPS Tracker function from the GPS menu (Fig. 4).

[[File:OJ_GPS_04.png]]

GPS coordinates are shown in the bottom left corner. Coordinates are processed with the coordinate tranformation utility if different input and output systems were selected. In the Fig. 4 coordinates are WGS 84 coordinates. Fig. 5 shows how to select UTM zone 35N output and Fig. 6 shows the transformed GPS coordinates.

[[File:OJ_GPS_05.png]]

[[File:OJ_GPS_06.png]]

== Using GPS plugin together with vector files ==

The next example illustrates how to use GPS plugin together with a shapefile. Shapefile in this example is OpenStreetMap roads, downloaded from Geofabrik http://download.geofabrik.de/osm/europe/
Roads shapefile is in the WGS 84 projection (EPSG:4326) and when GPS plugin is configured accordingly the location seems to be somewhere in the Southern Finland (Fig. 7).

[[File:OJ_GPS_07.png]]

Closer zoom and slight styling with OpenJUMP styling wizard shows the location more accurately

[[File:OJ_GPS_08.png]]

== Working with raster images, vectors from a database, and other projections ==

Figures 9 and 10 are showing how to add two vector layers from a PostGIS database with the OpenJUMP standard Run Datastore Query tool. The first one is creating a park bench layer, the second finds out some waste baskets. Data in again OpenStreetMap data which is downloaded from Geofabrik in native osm format and imported into PostGIS database with osm2pgsql utility. Osm2pgsql was run with the -k parameter for getting all the OpenStreetMap tags into the database. After import the data in the PostGIS database was reprojected into EPSG:3067 projection, which is about the same as EPSG:32635.

[[File:OJ_GPS_09.png]]

[[File:OJ_GPS_10.png]]

Figure 11 shows an OpenJUMP task that is ready to be used for a field survey.

[[File:OJ_GPS_11.png]]

Map layers in this task are

- Raster base map rendered by Mapserver from OSM data
- The bench layer created as described above (Fig. 9)
- The waste_basket layer created as described above (Fig. 10)
- New bench layer for collecting missing benches
- New waste basket layer for collecting missing waste baskets

Screen capture shows also two nice OpenJUMP features:

- View - Map Tooltips is selected for getting the mouse-over functionality

- EZ-Buttons are used for giving a large button for recordind GPS locations. F1 function key can be used for the same purpose

Finally, Fig 12. shows the results of a rapid field visit. Two benches and three waste baskets were recorded.

[[File:OJ_GPS_12.png]]

GPS extension - Track & insert points from serial gps device

2010-08-11T12:41:15Z

Jratike80:

== Introduction ==

OpenJUMP GPS plugin is made by Edgar Soldin and it can be downloaded from
https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/

== Supported GPS units ==

GPS plugin is reading data through a serial (COM)port of a computer. GPS receivers which are connected to a physical serial port should work out of the box. GPS receivers which are connected through USB connection need some system on the computer side for directing GPS signal into virtual COM port. Wired USB mouses and Bluetooth GPS receivers often come with drivers and software made for this purpose. One commercial alternative is GpsGate software. It is mentioned here only because it has been tested to work with Garmin eTrex Vista HCx unit on 32 bit Window Vista OS. There are probably other as well working programs. What is important that the GPS plugin must be able to find GPS signal through a serial port, either physical or virtual.

== Installation ==

Installation is done by unzipping the two zip files from the above address into OpenJUMP lib/ext directory.

== Testing the GPS plugin installation and GPS unit ==

Be sure to turn on your GPS unit and virtual serial port software if you are using such. GPS plugin is scanning the serial ports during OpenJUMP start, and it will not see virtual ports which are appearing after startup.

After starting OpenJUMP you should see a new menu item 'GPS' in the main menu bar (Fig. 1).

[[File:OJ_GPS_01.png]]

Select GPS Options

[[File:OJ_GPS_02.png]]

Settings:
Processing Format

alternatives NMEA, Garmin or Sirf. Only NMEA tested so far.

Update every ...

Slider selects how often the plugin will center OpenJUMP map into the GPS coordinates. Scale is between 0 to 600 seconds. Zero setting means that the map is not centered automatically, 600 centers the map in 10 minutes intervals.

Notice that you cannot see your current location on the map between autotic map updates. However, OpenJUMP will refresh the GPS coordinates in the info window and current locations can be recorded at any moment.

GPS Receiver Output CS

This setting must suit the GPS output. The default is WGS 84 which is also supported by all GPS receivers. If GPS is configured to send out coordinates in some other systems, OpenJUMP GPS plugin needs to have definitions for that system. They are stored in the cs.conf file which is located in the lib/ext/cts directory. The format used for defining the coordinate system is OGC Well Known Text. Good source for findig the projection definitions is spatialreference.org. For example string needed to add support for UTM zone 35N projection can be found from http://spatialreference.org/ref/epsg/32635/ogcwkt/

Tracking CS

This setting must suit the projection that is used in the OpenJUMP task.

Serial port options

These setting must suit the serial port where GPS is connected. With virtual ports the defaults are usually working.

Test Settings

If GPS is workin OK and serial port is configured correctly then pressing the Test Settings button will list the messages sent by the GPS in the window abow. See Fig. 3

[[File:OJ_GPS_03.png]]

== Using the GPS plugin ==

Close the GPS Options window and turn on the GPS Tracker function from the GPS menu (Fig. 4).

[[File:OJ_GPS_04.png]]

GPS coordinates are shown in the bottom left corner. Coordinates are processed with the coordinate tranformation utility if different input and output systems were selected. In the Fig. 4 coordinates are WGS 84 coordinates. Fig. 5 shows how to select UTM zone 35N output and Fig. 6 shows the transformed GPS coordinates.

[[File:OJ_GPS_05.png]]

[[File:OJ_GPS_06.png]]

== Using GPS plugin together with vector files ==

The next example illustrates how to use GPS plugin together with a shapefile. Shapefile in this example is OpenStreetMap roads, downloaded from Geofabrik http://download.geofabrik.de/osm/europe/
Roads shapefile is in the WGS 84 projection (EPSG:4326) and when GPS plugin is configured accordingly the location seems to be somewhere in the Southern Finland (Fig. 7).

[[File:OJ_GPS_07.png]]

Closer zoom and slight styling with OpenJUMP styling wizard shows the location more accurately

[[File:OJ_GPS_08.png]]

== Working with raster images, vectors from a database, and other projections ==

Figures 9 and 10 are showing how to add two vector layers from a PostGIS database with the OpenJUMP standard Run Datastore Query tool. The first one is creating a park bench layer, the second finds out some waste baskets. Data in again OpenStreetMap data which is downloaded from Geofabrik in native osm format and imported into PostGIS database with osm2pgsql utility. Osm2pgsql was run with the -k parameter for getting all the OpenStreetMap tags into the database.

[[File:OJ_GPS_09.png]]

[[File:OJ_GPS_10.png]]

Figure 11 shows an OpenJUMP task that is ready to be used for a field survey.

[[File:OJ_GPS_11.png]]

Map layers in this task are

- Raster base map rendered by Mapserver from OSM data
- The bench layer created as described above (Fig. 9)
- The waste_basket layer created as described above (Fig. 10)
- New bench layer for collecting missing benches
- New waste basket layer for collecting missing waste baskets

Screen capture shows also two nice OpenJUMP features:

- View - Map Tooltips is selected for getting the mouse-over functionality

- EZ-Buttons are used for giving a large button for recordind GPS locations. F1 function key can be used for the same purpose

Finally, Fig 12. shows the results of a rapid field visit. Two benches and three waste baskets were recorded.

[[File:OJ_GPS_12.png]]

GPS extension - Track & insert points from serial gps device

2010-08-11T12:14:26Z

Jratike80:

GPS extension - Track & insert points from serial gps device

2010-08-11T11:39:58Z

Jratike80: Created page with '== Introduction == OpenJUMP GPS plugin is made by Edgar Soldin and it can be downloaded from https://sourceforge.net/projects/jump-pilot/files/p_GPS%2CCTS%20Extensions/ == Supp…'

File:OJ GPS 12.png

2010-08-11T11:13:39Z

Jratike80: Field visit performed. Two benches and three waste baskets collected with OpenJUMP GPS plugin.

Field visit performed. Two benches and three waste baskets collected with OpenJUMP GPS plugin.

File:OJ GPS 11.png

2010-08-11T11:11:44Z

Jratike80: OpenJUMP task ready for a field test. Layers: raster image from WMS server, two vector layers from PostGIS database, two editable layers for collecting GPS measurement data.

OpenJUMP task ready for a field test. Layers: raster image from WMS server, two vector layers from PostGIS database, two editable layers for collecting GPS measurement data.

File:OJ GPS 10.png

2010-08-11T11:08:02Z

Jratike80: Preparing for a field test: Reading waste baskets from PostGIS database by selecting either all the points with a tag 'amenity=waste_basket', or those park benches which have an additional tag 'waste_basket=yes'.

Preparing for a field test: Reading waste baskets from PostGIS database by selecting either all the points with a tag 'amenity=waste_basket', or those park benches which have an additional tag 'waste_basket=yes'.

File:OJ GPS 09.png

2010-08-11T11:04:26Z

Jratike80: Preparing for a field test: Reading park benches from PostGIS database by selecting 'amenity=bench' tag from 'tags' column which is of hstore datatype.

Preparing for a field test: Reading park benches from PostGIS database by selecting 'amenity=bench' tag from 'tags' column which is of hstore datatype.

File:OJ GPS 08.png

2010-08-11T10:49:16Z

Jratike80: Testing with real vector data. Finland roads shapefile slightly styled, labeled and zoomed in.

Testing with real vector data. Finland roads shapefile slightly styled, labeled and zoomed in.

File:OJ GPS 07.png

2010-08-11T10:47:37Z

Jratike80: Testing with real vector data. Finland roads shapefile in EPSG:4326 projection as a background.

Testing with real vector data. Finland roads shapefile in EPSG:4326 projection as a background.

File:OJ GPS 06.png

2010-08-11T10:45:30Z

Jratike80: Working in another projection: GPS coordinates are now in UTM 35N projection.

Working in another projection: GPS coordinates are now in UTM 35N projection.

File:OJ GPS 05.png

2010-08-11T10:44:11Z

Jratike80: Working in another projection: select the output projection and press OK.

Working in another projection: select the output projection and press OK.

File:OJ GPS 04.png

2010-08-11T10:42:41Z

Jratike80: GPS Tracker in turned on and GPS plugin is feeding coordinates into OpenJUMP task.

GPS Tracker in turned on and GPS plugin is feeding coordinates into OpenJUMP task.

File:OJ GPS 03.png

2010-08-11T10:41:02Z

Jratike80: Test Settings button shows the output of the selected COM port.

Test Settings button shows the output of the selected COM port.

File:OJ GPS 02.png

2010-08-11T10:38:54Z

Jratike80: OpenJUMP GPS plugin settings window.

OpenJUMP GPS plugin settings window.

File:OJ GPS 01.png

2010-08-11T10:35:49Z

Jratike80: Menu of the OpenJUMP GPS plugin

Menu of the OpenJUMP GPS plugin

OpenJUMP with SpatialLite

2010-02-09T10:29:55Z

Jratike80: /* Updating attribute values with Spatialite Reader Plugin */

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatiaLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using it).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above. Maximum speed of 0 km/h may feel odd. We will return to this later.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable error messages.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatiaLite with Spatialite Reader Plugin ==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, the SQL window of the plugin connects directly to SpatiaLite database and thus everything that can be done with Spatialite SQL is doable through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database. A new query SELECT * FROM roads will show that the values were really updated.

[[File:Spatialitereader_10.png]]

OpenJUMP with SpatialLite

2010-02-09T10:18:56Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatiaLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using it).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above. Maximum speed of 0 km/h may feel odd. We will return to this later.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable error messages.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatiaLite with Spatialite Reader Plugin ==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, because of the SQL window of the plugin everything that is possible to do with Spatialite SQL can be done through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database.

[[File:Spatialitereader_10.png]]

OpenJUMP with SpatialLite

2010-02-09T10:07:18Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using it).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above. Maximum speed of 0 km/h may feel odd. We will return to this later.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable error messages.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatialLite with Spatialite Reader Plugin (under construction)==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, because of the SQL window of the plugin everything that is possible to do with Spatialite SQL can be done through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database.

[[File:Spatialitereader_10.png]]

File:Dbqyery image004.png

2010-02-09T09:57:59Z

Jratike80: uploaded a new version of "File:Dbqyery image004.png": Reverted to version as of 22:21, 7 February 2010

File:Dbqyery image004.png

2010-02-09T09:54:52Z

Jratike80: uploaded a new version of "File:Dbqyery image004.png": Tried to send a new image because the first version did not show on the wiki page sometimes.

OpenJUMP with SpatialLite

2010-02-09T09:43:58Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using if).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query. Maximum speed of zero feels so odd that we will return to this later.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable error messages.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatialLite with Spatialite Reader Plugin (under construction)==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, because of the SQL window of the plugin everything that is possible to do with Spatialite SQL can be done through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database.

[[File:Spatialitereader_10.png]]

OpenJUMP with SpatialLite

2010-02-09T09:03:09Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using if).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable results.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatialLite with Spatialite Reader Plugin (under construction)==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

=== Updating attribute values with Spatialite Reader Plugin ===

It is not possible to update Spatialite features which are read into OpenJUMP. However, because of the SQL window of the plugin everything that is possible to do with Spatialite SQL can be done through the plugin as well. For example, updating the "roads" layer by changing all maxpeed=0 values into null (empty) values goes easily. Error message "No ResultSet was produced" indicates only that nothing was selected from the database.

[[File:Spatialitereader_10.png]]

File:Spatialitereader 10.png

2010-02-09T08:53:49Z

Jratike80:

OpenJUMP with SpatialLite

2010-02-09T08:42:15Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using if).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable results.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatialLite with Spatialite Reader Plugin (under construction)==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

[[File:Spatialitereader_01.png]]

Start via menu with Select Layer - Import Spatialite Layer

[[File:Spatialitereader_02.png]]

Press the only active button "+" and search the Spatialite database file.

[[File:Spatialitereader_03.png]]

The whole database structure comes visible.

[[File:Spatialitereader_04.png]]

By double clicking the layer title "roads" the SELECT clause is created automatically. You can also write is directly to the text box. The second button "SQL >" makes the query and lists results in the form without transferring them into OpenJUMP map yet.

[[File:Spatialitereader_05.png]]

After pressing the third button the query results, including geometries, are sent to OpenJUMP.

[[File:Spatialitereader_06.png]]

With the Spatialite reader plugin you can reach all the Spatialite functions through a menu. Menu items have tooltip help entries and double click tranfers a prototype text into query window. This query will return the road geometries in WGS84 UTM zone 33 projection (EPSG:32633).

[[File:Spatialitereader_07.png]]

Berlin roads reprojected from the native EPSG:4326 into EPSG:32633 by Spatialite. Note: This is possible only if the "spatial_ref_sys" table contains definitions for both the input and output projections. All the databases created with Spatialite-GUI tool have definitions for 3519 different projections.

[[File:Spatialitereader_08.png]]

This is not a Spatialite tutorial, but these two screenshots should give some idea about what kind of operations can be done inside Spatialite and visualised with OpenJUMP

[[File:Spatialitereader_09.png]]

File:Spatialitereader 09.png

2010-02-09T08:21:02Z

Jratike80:

File:Spatialitereader 08.png

2010-02-09T08:20:44Z

Jratike80:

File:Spatialitereader 07.png

2010-02-09T08:20:09Z

Jratike80:

File:Spatialitereader 06.png

2010-02-09T08:19:51Z

Jratike80:

File:Spatialitereader 05.png

2010-02-09T08:19:30Z

Jratike80:

File:Spatialitereader 04.png

2010-02-09T08:19:07Z

Jratike80:

File:Spatialitereader 03.png

2010-02-09T08:18:41Z

Jratike80:

File:Spatialitereader 02.png

2010-02-09T08:17:59Z

Jratike80:

File:Spatialitereader 01.png

2010-02-09T08:17:33Z

Jratike80:

OpenJUMP with SpatialLite

2010-02-09T08:12:34Z

Jratike80:

== Introduction ==
There are two plugins that allow to use SpatiaLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate Spatialite Reader Plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using if).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable results.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000

== Using SpatialLite with Spatialite Reader Plugin (under construction)==

=== Installing and using JUMP Spatialite Reader Plugin with Spatialite databases ===

Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* Spatialite Reader Plugin version 1.1

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/1.1/spatialliteplugin1.1.zip/download and download the plugin.

The readme.txt file is listing two URLs for downloading Spatialite precompiled libraries and SQLite3 JDBC driver. However, the zip file contained all the drivers needed for Windows. The plugin is using platform dependent components and for Linux and OS X users the plugin won't work as it is.

=== Installation ===

Windows users can just unzip the spatialliteplugin1.1.zip into bin\ext folder of OpenJUMP and the plugin is ready for use. After successful installation there is a new menu item: Layer - Import Spatialite Layer.

=== Using Spatialite Reader Plugin ===

The next examples are using the same Spatialite database as the previous tests with DB Query Plugin. The database is just renamed to "spatialitereader_test.sqlite"

OpenJUMP with SpatialLite

2010-02-09T07:51:41Z

Jratike80:

OpenJUMP with SpatialLite

2010-02-09T07:48:37Z

Jratike80: /* Introduction */

OpenJUMP with SpatialLite

2010-02-08T22:06:32Z

Jratike80: /* Hint: Limiting the size of the query result */

== Introduction ==
There are two plugins that allow to use SpatialLite with OpenJUMP:
* the [http://sourceforge.net/projects/jumpdbqplugin/files/ JUMP DB Query Plugin]
* a separate plugin available [http://sourceforge.net/projects/jump-pilot/files/p_database_plugins/p_SpatialLite_reader_plugin/SpatialitePlugin.zip/download here]

== Using SpatialLite with DB Query Plugin ==

this has been written by Jukka:

=== Installing and using JUMP Database Query Plugin with Spatialite databases ===
Tested with:
* Windows XP
* Java 1.6.0_ 06
* OpenJUMP 1.3.1
* DB Query Plugin 0.7.0 (19th January, 2010)
* SQLite JDBC driver downloaded from http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Getting the plugin and SQLite driver ===

Go to http://sourceforge.net/projects/jumpdbqplugin/files/ and download the plugin.

The readme file "README_jumpdbquery.txt" included in the downloaded zip file gives advice for downloading SQLite JDBC driver from http://www.zentus.com/sqlitejdbc/

I did my first test with the pure Java driver downloaded from zentus and plugin worked with it. However, next day I could not access the zentus web site any more. Fortunately I managed to find another SQLite JDBC driver from www.xerial.org and that worked with DB Query plugin as well. The one I used is this:

http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.6.20.1/sqlite-jdbc-3.6.20.1.jar

=== Installation ===

Installation is done simply by unzipping the contents of jumpdbplugin.zip and SQLite JDBC driver into bin\ext folder of OpenJUMP.

=== Configuring DB Query Plugin for Spatialite databases ===

DB Query plugin is configured by editing file "dbquery.properties" that is located at bin\ext folder. With Spatialite there is not much to configure, but there is a typo in the default properties file that comes with plugin version 0.7.0 and it needs to be corrected by hand. ''Note, that this problem has been corrected with the DB Query Plugin Version 0.7.1.''

There reads originally
<pre>
#"spatialite1" database
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.postgres.JumpSpatialiteDbQuery
jump.dbquery.driver.spatialite1=org.sqlite.JDBC
jump.dbquery.jdbcurl.spatialite1=jdbc:sqlite:/path_to_db_file.db
jump.dbquery.username.spatialite1=
#jump.dbquery.password.spatialite1=
</pre>
The classpath is wrong and is must be corrected like this:
<pre>
jump.dbquery.queryclass.spatialite1=org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialite
</pre>

Now the installation should be ready. This can be verified partly by starting OpenJUMP and checking if there new selection "Database Query" in the Tools menu list.

=== Creating a Spatialite database for testing ===

An easy way to create a Spatialite database for testing is to import some shapefiles with Spatialite-GUI utility. It can be downloaded from http://www.gaia-gis.it/spatialite/binaries.html
Running Spatialite-GUI is simple, it is only one executable file. The rest of the process is described below with a bunch of screen captures. Shapefiles in the example come from http://download.geofabrik.de/osm/europe/germany/
I used zip file "berlin.shp.zip" but that is not important, any shapefiles will do.

[[File:Dbqyery_image001.png]]

Spatialite-GUI started.

[[File:Dbqyery_image002.png]]

Dialogue for creating a new Spatialite database.

[[File:Dbqyery_image003.png]]

Select file path and feed in the name of the new database.

[[File:Dbqyery_image004.png]]

"Load Shapefile" button is for loading shapefiles.

[[File:Dbqyery_image005.png]]

Select the shapefile.

[[File:Dbqyery_image006.png]]

Feed in the table name to be used in the database, projection of the data and character encoding (with Geofabrik shapefile the correct setting is probably UTF-8 but there were some import problems when using if).

[[File:Dbqyery_image007.png]]

Message after successful import.

[[File:Dbqyery_image008.png]]

View after importing a bunch of shapefiles. Layer "roads" widened to show the fields in the table. "Geometry" holds the geometries. Attribute fields are "osm_id", "name", "ref", "type", "oneway" and "maxspeed".

=== Using DB Query Plugin with Spatialite database ===

Everything is now ready for the real test. DB Query Plugin is installed and there is a test database named db_query_test.sqlite located in the folder D:\TEMP\db_tutorial\

[[File:Dbqyery_image009.png]]

[[File:Dbqyery_image010.png]]

[[File:Dbqyery_image011.png]]

Entering the query. Windows accepts both forward and back slashes in the database path. Remember to insert some SELECT into query, otherwise you will not get anything back.

[[File:Dbqyery_image012.png]]

The result of the query.

[[File:Dbqyery_image013.png]]

A bit more complex database query.

[[File:Dbqyery_image014.png]]

The result of the query above.

[[File:Dbqyery_image015.png]]

It is a real database with more than one layer.

[[File:Dbqyery_image016.png]]

=== Troubleshooting ===

Some typical errors are error when writing the location of the Spatialite database or in the SQL queries. DB Query Plugin gives often rather understandable results.

[[File:Dbqyery_image017.png]]

[[File:Dbqyery_image018.png]]

There are many ways to store spatial data in SQLite databases. DB Query Plugin understands many alternative methods but there may be problems in interoperability. In such case try to open the database with other tools and possibly write is again by extracting layers first into shapefiles and importing them back to a new database. Spatialite-GUI and DB Query Plugin seem to play together.

=== Hint: Limiting the size of the query result ===

Spatialite databases can be big. They work fine at least up till many gigabytes. Selecting the whole table with

SELECT * from TABLE

may give more data than OpenJUMP can handle in the memory. Use LIMIT for limiting the number of rows returned by the query. For example, to select at maximum 1000 rows use

SELECT * from TABLE LIMIT 1000