[JPP-Devel] WMS 1.3

2013-04-10 Thread Michaël Michaud
Hi Jukka, WMS users, I added WMS 1.3.0 support but did not commit yet. code is available here : http://geo.michaelm.free.fr/OpenJUMP/ If it can be tested today to check I did not introduce a severe regression, I can commit the code this evening. Note : Beside 1.3.0, I've made a few changes to bou

[JPP-Devel] Change color text on statusbar

2013-04-10 Thread Giuseppe Aruta
Hi all, color text of messages on status bar is always black. Is there a way to use other colors, ex. red? I want to use on my measure plugin in order to show user if plugin is using JTS (under metric coordinates) or other libraries (ex. Vincenty's formula, under geographic coordinates). regards an

Re: [JPP-Devel] WMS 1.3

2013-04-10 Thread Rahkonen Jukka
Hi, WMS 1.3.0 works for me with EPSG:3067 which is Easting-Northing system. However, there seems to be something odd with the reversed axis order in systems like EPSG:4326 and EPSG:2393. I will collect some log info later today. I did not see a regression with WMS 1.1.1, it is just that WMS 1

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-10 Thread Uwe Dalluege
Hi Michaël, do you mean the option Options>View/Edit>Prevent edits resulting invalid geometries? I am not understanding this option. What is the use of drawing a selfintersection polygon? 1. In my opinion a program should never *compute* invalide geometries like multipolygon if it is not a valid

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-10 Thread Uwe Dalluege
Hi, sorry, the last point 2 should be a 3 :-( uwe Am 10.04.2013 10:24, schrieb Uwe Dalluege: > Hi Michaël, > > do you mean the option > Options>View/Edit>Prevent edits resulting invalid geometries? > > I am not understanding this option. > What is the use of drawing a selfintersection polygon? >

[JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Uwe Dalluege
Hi, I like to describe the function "Run Datastore Query" in my PostGIS tutorial but I can not find a desciption of this. What are the buttons "View, Fence and Selection" good for? Regards Uwe -- Precog is a next-gener

Re: [JPP-Devel] Change color text on statusbar

2013-04-10 Thread edgar . soldin
On 10.04.2013 09:37, Giuseppe Aruta wrote: > Hi all, > color text of messages on status bar is always black. Is there a way to use > other colors, ex. red? I want to use on my measure plugin in order to show > user if plugin is using JTS (under metric coordinates) or other libraries > (ex. Vince

Re: [JPP-Devel] The new geometry is invalid. Cancelled.

2013-04-10 Thread Rahkonen Jukka
Hi, 1) It should never happen but we are living in a not perfect world and it happens and will always happen. 2) For some use cases the invalid geometries may be good enough. Typical examples are polygons with tiny self-intersections or inner circles with only two vertices (A-B-A). Simplifica

Re: [JPP-Devel] Spatialite multigeometry trouble and JTS v. 1.13

2013-04-10 Thread edgar . soldin
On 10.04.2013 04:51, Larry Reeder wrote: > While testing the new 0.8.1 version of DB Query Plugin I noticed that I could > not read any multigeometries nor geometry collections from Spatialite. > Further research revealed that with a bit older OpenJUMP versions there are > no troubles at all wit

[JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread Uwe Dalluege
Hi, is it possible to change the default Layer Name of "Run Datastore Query" to a valid SQL table name? An inexperienced user with SQL maybe do not know that "New Query Layer" is not a valid layername (SQL-Tablename). Thanks. Uwe ---

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread edgar . soldin
On 10.04.2013 11:15, Uwe Dalluege wrote: > Hi, > > is it possible to change the > default Layer Name of > "Run Datastore Query" > to a valid SQL table name? > > An inexperienced user with SQL > maybe do not know that > "New Query Layer" is not a valid > layername (SQL-Tablename). > i'd rather s

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Rahkonen Jukka
Hi, They are helper shortcuts for adding a spatial filter into the query. The result will be something like select * from my_layer where geoloc && ${view:4326} Thus only features intersecting the view, box drawn with the fence tool or total extents of the selected features will be selected. -

Re: [JPP-Devel] Change color text on statusbar

2013-04-10 Thread Giuseppe Aruta
Hi Ede, I tried textual hint but I was not satisfied of it. thanks for suggestions > On 10.04.2013 09:37, Giuseppe Aruta wrote: > > Hi all, > > color text of messages on status bar is always black. Is there a way to > use other colors, ex. red? I want to use on my measure plugin in order to > sh

Re: [JPP-Devel] Change color text on statusbar

2013-04-10 Thread edgar . soldin
well with the new statusbar you could settle for showing more than one scale, several lines with the topmost the default ;) ..ede On 10.04.2013 12:03, Giuseppe Aruta wrote: > Hi Ede, > I tried textual hint but I was not satisfied of it. > thanks for suggestions > > > > 2013/4/10 mailto:edgar

Re: [JPP-Devel] Change color text on statusbar

2013-04-10 Thread Giuseppe Aruta
Hi Ede, what do you mean with "showing more than one scale"? Set different text dimensions? How does "several lines" works? Peppe 2013/4/10 > well with the new statusbar you could settle for showing more than one > scale, several lines with the topmost the default ;) > > ..ede > > On 10.04.201

Re: [JPP-Devel] Change color text on statusbar

2013-04-10 Thread edgar . soldin
On 10.04.2013 12:52, Giuseppe Aruta wrote: > Hi Ede, > what do you mean with "showing more than one scale"? show several scales computed by different algorithms separated by linebreaks >Set different text dimensions? How does "several lines" works? html formatting using "" ..ede -

[JPP-Devel] a couple of icons

2013-04-10 Thread Giuseppe Aruta
Hi all, I made a couple of icons, one for Beanshell console and the other for Jython Console, modified from famfamfam ones. I add to this mail just in case authors (or Ede) would like to add to these plugins. Note that I iconized also Jython>Tools plugins and realized that it is possible to "intern

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread edgar . soldin
On 10.04.2013 13:00, Giuseppe Aruta wrote: > Hi all, > I made a couple of icons, one for Beanshell console and the other for Jython > Console, modified from famfamfam ones. I add to this mail just in case > authors (or Ede) would like to add to these plugins. Note that I iconized > also Jython>T

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread Uwe Dalluege
Hi, Am 10.04.2013 11:27, schrieb edgar.sol...@web.de: > On 10.04.2013 11:15, Uwe Dalluege wrote: >> Hi, >> >> is it possible to change the >> default Layer Name of >> "Run Datastore Query" >> to a valid SQL table name? >> >> An inexperienced user with SQL >> maybe do not know that >> "New Query La

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread edgar . soldin
On 10.04.2013 13:41, Uwe Dalluege wrote: > Hi, > > Am 10.04.2013 11:27, schrieb edgar.sol...@web.de: >> On 10.04.2013 11:15, Uwe Dalluege wrote: >>> Hi, >>> >>> is it possible to change the >>> default Layer Name of >>> "Run Datastore Query" >>> to a valid SQL table name? >>> >>> An inexperienced

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread Giuseppe Aruta
Hi Ede, there are some reasons I cannot use Eclipse in this moment (I am using an external Internet Connection to write mails in these days). If you can do for me, I really appreciate and thank you (just in case to have them for 1.6 OpenJUMP) thanks again Peppe 2013/4/10 > On 10.04.2013 13:00

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Uwe Dalluege
Hi Jukka, thank you for this example. Do you know whether this works? : select st_intersection ( geometry, ${fence:0} ) from "Bauernhof" The table "Bauernhof" contains a geometry-column called "geometry" Inside the fence there is a polygon intersects the geometry from "Bauernhof" But this does

[JPP-Devel] How to get the Current Connection

2013-04-10 Thread Asma ouqalli
Hello everybody, am trying to get the the current connexion so as to execute some update queries. i tried to use getConnection of the datasource and then execute the query, but it doesn't work. Do i have to get the PostgisDataStoreDriver like this and the get the connection: PostgisDataStoreDrive

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Rahkonen Jukka
Uwe Dalluege wrote: > > Hi Jukka, > > thank you for this example. > Do you know whether this works? : > > select st_intersection ( geometry, ${fence:0} ) from "Bauernhof" > > The table "Bauernhof" contains a geometry-column called "geometry" > It works so that the resulting SQL for me looks li

Re: [JPP-Devel] WMS 1.3

2013-04-10 Thread Rahkonen Jukka
Hi, May I aski f you have even tried to handle the BBOX axis order, and if yes, in which way? WFS 1.3.0 does not work well with Lat-Lon and Northing-Easting systems now. -Jukka- Michaël Michaud wrote: > > Hi Jukka, WMS users, > > I added WMS 1.3.0 support but did not commit yet. > code is ava

Re: [JPP-Devel] WMS 1.3

2013-04-10 Thread Giuseppe Aruta
Hi Michael and Jukka I tried with lat/lon server and I get no display Peppe 2013/4/10 Rahkonen Jukka > Hi, > > May I aski f you have even tried to handle the BBOX axis order, and if > yes, in which way? WFS 1.3.0 does not work well with Lat-Lon and > Northing-Easting systems now. > > -Jukka- >

Re: [JPP-Devel] WMS 1.3

2013-04-10 Thread Rahkonen Jukka
Hi, Reason is simple, Lon-Lat is not turned into Lat-Lon in BBOX. But Michaël has been doing some other not totally correct changes which are causing troubles too. But everything is correctable. -Jukka- Giuseppe Aruta wrote: Hi Michael and Jukka I tried with lat/lon server and I get no displa

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread Rahkonen Jukka
Hi, Just tried the following with PostgreSQL and table was created. I do not know if it works with all versions and I agree that using spaces in table names is not a brilliant idea. CREATE TABLE "test space" as select * from table limit 1; -Jukka- edgar.sol...@web.de wrote: > On 10.04.2013

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Uwe Dalluege
Hi Jukka, thank you very much for your help! Now it works for me. But I receive two rows with GEOMETRYCOLLECTION EMPTY information in the OJ layer in my example. This selection produces empty geometries because it intersects only one of three geometries. Is it possible to check if the geometry

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread edgar . soldin
thanks Jukka. all i am saying is: the DBMS enforces this restriction so it should be implemented when writing to it, not when creating a new layer from a resultset, possibly even from another DBMS. ..ede On 10.04.2013 15:55, Rahkonen Jukka wrote: > Hi, > > Just tried the following with Postg

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Rahkonen Jukka
Hi, It is just a general SQL query tool and you must, or you have a great opportunity, to add the test directly into your SQL. This might get what you want with PostGIS 2.x select st_intersection(...) AS geom ... FROM... WHERE ST_GeometryType(geom)='ST_Polygon"; -Jukka- Uwe Dalluege wrote: >

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread Stefan Steiniger
yep - I like them too. Good work! Peppe the Icon-Master Am 10.04.13 07:03, schrieb edgar.sol...@web.de: > On 10.04.2013 13:00, Giuseppe Aruta wrote: >> Hi all, >> I made a couple of icons, one for Beanshell console and the other for Jython >> Console, modified from famfamfam ones. I add to this m

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread edgar . soldin
nP .. done in 3488. ede On 10.04.2013 14:14, Giuseppe Aruta wrote: > Hi Ede, > there are some reasons I cannot use Eclipse in this moment (I am using an > external Internet Connection to write mails in these days). If you can do for > me, I really appreciate and thank you (just in case to have

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread Michaël Michaud
Hi, Like them too, Thanks, Michaël > yep - I like them too. > Good work! > Peppe the Icon-Master > > Am 10.04.13 07:03, schrieb edgar.sol...@web.de: >> On 10.04.2013 13:00, Giuseppe Aruta wrote: >>> Hi all, >>> I made a couple of icons, one for Beanshell console and the other for >>> Jython Cons

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Michaël Michaud
Hi, Jukka gave great explanation about how to use RunDataStorePlugIn I've also written a bit of documentation in the wiki : http://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=Working_with_Databases Feel free to complete, Michaël > Hi, > > It is just a general SQL query tool and you

Re: [JPP-Devel] Decription of Run Datastore Query

2013-04-10 Thread Michaël Michaud
Hi, > You can see that the rectangular geometry of the fence itself, not any > features inside it, is placed into the query. The number after ":" is > SRID, I used -1 in my case. The query itself gives an error when I > tested it directly with PSQL "found non-noded intersection > between...". O

Re: [JPP-Devel] WMS 1.3

2013-04-10 Thread Michaël Michaud
Hi, Thanks for the tests. I still not master the lat/lon lon/lat problem, but with the help of Jukka, it should not be a problem to fix it... Michaël Hi, Reason is simple, Lon-Lat is not turned into Lat-Lon in BBOX. But Michaël has been doing some other not totally correct changes which ar

Re: [JPP-Devel] How to get the Current Connection

2013-04-10 Thread Michaël Michaud
Hi, What do you mean by "current connexion" When you query a database, you choose a connexion, then use it to perform your query. After that, you may have 10 layers in the project pointing to 10 different databases. You may have a look at the org.openjump.core.ui.plugin.datastore.postgis pack

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread Michaël Michaud
Hi, Original question was about the Layer Name of Run Datastore Query. But Layer Name is a OpenJUMP thing. There is no restriction about how to write a Layer Name and many OpenJUMP plugin write layer names with spaces. I guess your problem is that this layer name will be used again when you'll t

Re: [JPP-Devel] Spatialite multigeometry trouble and JTS v. 1.13

2013-04-10 Thread Michaël Michaud
Le 10/04/2013 11:12, edgar.sol...@web.de a écrit : > On 10.04.2013 04:51, Larry Reeder wrote: >> While testing the new 0.8.1 version of DB Query Plugin I noticed that I >> could not read any multigeometries nor geometry collections from Spatialite. >> Further research revealed that with a bit old

Re: [JPP-Devel] a couple of icons

2013-04-10 Thread Giuseppe Aruta
Thanks Ede, Openjump 1.6 looks more and more professional Peppe 2013/4/10 Michaël Michaud > Hi, > > Like them too, > Thanks, > > Michaël > > yep - I like them too. > > Good work! > > Peppe the Icon-Master > > > > Am 10.04.13 07:03, schrieb edgar.sol...@web.de: > >> On 10.04.2013 13:00, Giuseppe

Re: [JPP-Devel] Run Datastore Query - Layer Name

2013-04-10 Thread Uwe Dalluege
Hi Michaël, Am 10.04.2013 22:30, schrieb Michaël Michaud: > Hi, > > Original question was about the Layer Name of Run Datastore Query. > > But Layer Name is a OpenJUMP thing. > There is no restriction about how to write a Layer Name and many > OpenJUMP plugin write layer names with spaces. > > I g

[JPP-Devel] Run Datastore Query with no error-message

2013-04-10 Thread Uwe Dalluege
Hi Michaël, Am 10.04.2013 21:51, schrieb Michaël Michaud: > Hi, >> You can see that the rectangular geometry of the fence itself, not any >> features inside it, is placed into the query. The number after ":" is >> SRID, I used -1 in my case. The query itself gives an error when I >> tested it dire