How to Run Ad Hoc Database Queries in Open Jump?

Question

Which plugin allows you to run ad hoc queries from postgis in Openjump? How do you install it in Ubuntu?

underdark · Accepted Answer · 2012-01-22 11:06:49Z

2

Assuming you are using postgresql with postgis extension I don't think you need a special plugin. The core application can do that for you.

Just go to Layer -> Run Database Query
Click the Connection Manager icon next to Connection.
Press Add, give it a name, choose driver POSTGIS and fill out the details how to reach your database.
Connect to it.
Enter a query (e.q. SELECT some_geometry_column FROM some_table_with_a_geometry_column;) and press OK

You should now see a layer showing your geospatial data.

Just install Open Jump through the package manager in Ubuntu. Or if you do not know how to do that see: http://geomaniaa.blogspot.com/2009/07/openjump-how-to-setup-on-linux-in-seven.html

underdark

84.1k22 gold badges231 silver badges413 bronze badges

answered Jan 22, 2012 at 10:07

mrg

1,5653 gold badges17 silver badges27 bronze badges

The confusion was that the package manager only has version 1.0.4. Latest is 1.4.2, which has the run datastore query option. Instead of finding the run datastore query under the layer menu, I found it under the file menu.
– Steve
Jan 22, 2012 at 13:39
I would vote this answer up and mark it as answer, but it tells me I need to be logged in...but I already am.
– Steve
Jan 22, 2012 at 13:41

Add a comment |

1 Answer 1