[JPP-Devel] OpenJUMP wiki and sf.net interface change after 22. April

[Rahkonen Jukka]

Hi,

Does the change have an effect on OJ wiki? Especially, if I make some edits now 
can they be loosed after couple of weeks?

-Jukka Rahkonen-

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[Uwe Dalluege]

Hi Jukka,

thank you for clarification!

Uwe

Am 10.04.2013 16:08, schrieb 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:
>>
>> 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 is empty and put it not to the OJ 
>> layer?
>>
>> Uwe
>> Am 10.04.2013 15:25, schrieb 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 like select
>>> ST_Intersection(geoloc,ST_GeomFromText('POLYGON
>> ((3424728.225608409
>>> 6715639.342894198, 3424728.225608409 6715738.683124313,
>>> 3424855.5848777858 6715738.683124313, 3424855.5848777858
>>> 6715639.342894198, 3424728.225608409 6715639.342894198))',-1)) from
>>> test_table;
>>>
>>> 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...".  OpenJUMP naturally
>> cannot get a result and it is also unable to show any reasonable error
>> message, just a general java.sql.SQLException.
>>>
>>> -Jukka-
>>>
 Inside the fence there is a polygon
 intersects the geometry from "Bauernhof"
 But this does not work.

 1. I do not see an error message.
 2. What is the 0 after fence:  ?

 Regards

 uwe

 Am 10.04.2013 11:40, schrieb 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.
>
> -Jukka Rahkonen-
>
> Uwe Dalluege wrote:
>
>> 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-generation analytics platform capable of
>> advanced analytics on semi-structured data. The platform includes
>> APIs for building apps and a phenomenal toolset for data science.
>> Developers can use our toolset for easy data analysis &
>> visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> ___
>> Jump-pilot-devel mailing list
>> Jump-pilot-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
> 
> --
>  Precog is a next-generation analytics platform capable of
> advanced analytics on semi-structured data. The platform includes
> APIs for building apps and a phenomenal toolset for data science.
> Developers can use our toolset for easy data analysis & visualization.
> Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>>>
>>> --
>>>  Precog is a next-generation analytics platform capable of
>>> advanced analytics on semi-structured data. The platform includes APIs
>>> for building apps and a phenomenal toolset for data science.
>>> Developers can use our toolset for easy data analysis & visualization.
>>> Get a free account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> ___
>>> Jump-pilot-devel mailing list
>>> Jump-pilot-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>>
>
> -

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

[Rahkonen Jukka]

Hi,

I think that Run Datastore Query should also stay as a general SQL tool so that 
users can use exactly the same SQL in this tool, in PSQL command line or in 
pgAdmin SQL window and so on.  It might be nice to have a spatial SQL query 
wizard with syntax highlight and help messages, menu for selecting the 
available db functions, possibility to save queries and query templates for 
future use etc. but I think it would be better to make another tool for that 
purpose and keep this existing tool simple.

However, the tool has already something that can't be copied into other SQL 
tools.  The View, Fence and Selection buttons exist because they offer two 
extremely useful features:
1) It is very a common task to select features by view, by some rectangle or by 
selection and having these buttons make it much easier to build the SQL query.
2) When these buttons are used the reference geometries are used as variables 
instead of copying then into the query as WKT or something. Because of this the 
SQL Query layers can be refreshed.  Basic use case is to make a layer as
SELECT * FROM table 
WHERE attribute='something'
AND geom && ${view:SRID}

Now you can pan to another location on the map and do Right click - Database - 
Refresh Database Query and run the same base query again but now  the current 
view is used in the spatial filter.  Attach the menu item to some EZ Button and 
you can fire  a new search with one button.  Same thing with the fence or 
selection: draw a new fence or do a new selection, refresh the SQL Query layer 
and that's it.

-Jukka Rahkonen-


Uwe Dalluege wrote:
 
> Hi Jukka,
> 
> thank you for clarification!
> 
> Uwe
> 
> Am 10.04.2013 16:08, schrieb 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:
> >>
> >> 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 is empty and put it not to the OJ
> layer?
> >>
> >> Uwe
> >> Am 10.04.2013 15:25, schrieb 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 like select
> >>> ST_Intersection(geoloc,ST_GeomFromText('POLYGON
> >> ((3424728.225608409
> >>> 6715639.342894198, 3424728.225608409 6715738.683124313,
> >>> 3424855.5848777858 6715738.683124313, 3424855.5848777858
> >>> 6715639.342894198, 3424728.225608409 6715639.342894198))',-1)) from
> >>> test_table;
> >>>
> >>> 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...".  OpenJUMP naturally cannot get a result and it is also
> >> unable to show any reasonable error message, just a general
> java.sql.SQLException.
> >>>
> >>> -Jukka-
> >>>
>  Inside the fence there is a polygon intersects the geometry from
>  "Bauernhof"
>  But this does not work.
> 
>  1. I do not see an error message.
>  2. What is the 0 after fence:  ?
> 
>  Regards
> 
>  uwe
> 
>  Am 10.04.2013 11:40, schrieb 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.
> >
> > -Jukka Rahkonen-
> >
> > Uwe Dalluege wrote:
> >
> >> 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-generation analytics platform capable
> >> of advanced analytics on semi-structured data. The platform
> >> inc

Re: [JPP-Devel] OpenJUMP wiki and sf.net interface change after 22. April

[edgar . soldin]

On 11.04.2013 09:12, Rahkonen Jukka wrote:
> Hi,
> 
> Does the change have an effect on OJ wiki? Especially, if I make some edits 
> now can they be loosed after couple of weeks?
> 

they assured us the wiki would be untouched. also we have a daily backup. but 
maybe it'd make sense to keep a copy of the whole page source and images you 
add in some folder and check afterwards. just in case, would be easy to readd 
again then.

..ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] final steps to OJ 1.6

[edgar . soldin]

i will include DBQuery into PLUS and create the release. if the addition and 
updating Readme takes longer i will create the release tomorrow.

..ede


--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[Uwe Dalluege]

Hi Ede,

do you mean with "DBQuery"
"Run Datastore Query" ?

Uwe

Am 11.04.2013 10:47, schrieb edgar.sol...@web.de:
> i will include DBQuery into PLUS and create the release. if the addition and 
> updating Readme takes longer i will create the release tomorrow.
>
> ..ede
>
>

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[Rahkonen Jukka]

He means this
http://jumpdbqplugin.sourceforge.net/

-Jukka-

Uwe Dalluege wrote:
 
> Hi Ede,
> 
> do you mean with "DBQuery"
> "Run Datastore Query" ?
> 
> Uwe
> 
> Am 11.04.2013 10:47, schrieb edgar.sol...@web.de:
> > i will include DBQuery into PLUS and create the release. if the addition and
> updating Readme takes longer i will create the release tomorrow.
> >
> > ..ede
> >
> >
> 
> --
> Precog is a next-generation analytics platform capable of advanced analytics
> on semi-structured data. The platform includes APIs for building apps and a
> phenomenal toolset for data science. Developers can use our toolset for
> easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[edgar . soldin]

On 11.04.2013 08:34, Uwe Dalluege wrote:
SNIP
> 
>> There is no restriction too, as tables are created with quoted
>> strings which accept any character (but maybe it is not a so
>> common habit among DB adm, and I don't know if quoted
>> strings for table or column names is part of the SQL standard)
>>
> 
> This page tells us something about identifiers:
> 
> http://www.postgresql.org/docs/9.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
> 
> ...
> SQL identifiers and key words must begin with a letter (a-z, but also 
> letters with diacritical marks and non-Latin letters) or an underscore 
> (_). Subsequent characters in an identifier or key word can be letters, 
> underscores, digits (0-9), or dollar signs ($). Note that dollar signs 
> are not allowed in identifiers according to the letter of the SQL 
> standard, so their use might render applications less portable. The SQL 
> standard will not define a key word that contains digits or starts or 
> ends with an underscore, so identifiers of this form are safe against 
> possible conflict with future extensions of the standard.
> ...
> 
> I think, this is the SQL standard
> but as you say
> maybe this is also SQL standard:
> 
> ...
> There is a second kind of identifier: the delimited identifier or quoted 
> identifier. It is formed by enclosing an arbitrary sequence of 
> characters in double-quotes ("). A delimited identifier is always an 
> identifier, never a key word. So "select" could be used to refer to a 
> column or table named "select", whereas an unquoted select would be 
> taken as a key word and would therefore provoke a parse error when used 
> where a table or column name is expected.
> ...

this is /only/ how PostgreSQL handles it. try to get documentation about the 
ANSI SQL92, which is the most spread. you will find it is diffcult to obtain as 
you theoretically would have to purchase it against a fee. if you've got a 
library access i would be interested what really is written there. but even if 
it is forbidden there it is up to the implementation of the DBMS to dis/allow 
any character for table names.

anyway. most DBMS i know support some kind of quoting or escaping that allows 
pretty much anything in a table name. would be interesting if the dot "." is 
forbidden :)
 
btw. interesting bit about the MySQL concept. it makes it depending on the file 
system the tables are saved on. the file naming conventions essentially apply 
to how you can name your tables.

..ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] DBQuery with/out connector jars

[edgar . soldin]

did we decide if we include them?

if not, please comment.

if yes, all except oracle?

..ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[Asma ouqalli]

Hello,
i loaded 2 tables from one database and i want to query the two tables when
the user delete a feature, i want to delete it from database so i want to
use a Delete Query, but to execute this query i need to get the current
connection that i opened with it the database.

-- 
*Asma OUQALLI*

Élève ingénieur : 3ème  Sciences d'Information Géographique (SIG).
Chef de commission développement professionnel  - Rotaract EHTP.
Chef de cellule Media - Olympiades EHTP 2012.
  Ecole Hassania des Travaux Publics.
   Mobile : +212 672 48 23 15.
   Email : asma.ouqa...@gmail.com
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] DBQuery license issue

[edgar . soldin]

Larry,

i see you licensed your extension under LGPL3. unfortunately it is based OJ 
sources (plugin,extension interface, probably other code) hence it must be 
licensed under GPL either 2 or 3. would you be willing to relicense?

while i am not in a position to force you, i assume it is just an oversight on 
your part. proper licensing unfortunately is necessary if we distribute third 
party code.


thanks.. ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] DBQuery integration into PLUS postponed

[edgar . soldin]

just checked the latest DBQuery plugin and found the following issues:

1. wrong licensing under LGPL3 (see other mail)
2. menu item should be under "File", and not under a not translated "Tools" menu
2a. we already have a DB Query item under File, how do we name the new one :)
3. (minor) dialog should appear centered on WorkbenchFrame 

because of these issue i'll postpone the integration and go on with preparing 
OJ 1.6.

..ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] SRID problem with Add Datastore Layer...

[Uwe Dalluege]

Hi,

there is a different between Add Datastore Layer...
and Open>Data Store Layer.

Tested with OJ-CORE rev.3488 and PostGIS 2.0.

I have a table with the SRID-value 31467.

This works:

1. Open>Data Store Layer.
The "Open..." window shows the correct
SRID value ... srid = 31467 of the table.

2. The layer of the table has the correct SRID
testing with Layer>Set SRID.


This is wrong:

1. Add Datastore Layer...
The "Add Datastore Layer" window shows the correct
SRID value ... srid = 31467 of the table.
2. But now the layer has the SRID value 0
testing with Layer>Set SRID.


Uwe







--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] DBQuery integration into PLUS postponed

[Rahkonen Jukka]

Hi,

How about putting it into "Plugins" once it comes the time for integration? 
Different main menus in CORE and PLUS versions might baffle the users. Having 
Aggregation tool in Plugins-Analysis is already following this model.

-Jukka-

edgar soldin wrote:

> just checked the latest DBQuery plugin and found the following issues:
> 
> 1. wrong licensing under LGPL3 (see other mail) 2. menu item should be
> under "File", and not under a not translated "Tools" menu 2a. we already
> have a DB Query item under File, how do we name the new one :) 3. (minor)
> dialog should appear centered on WorkbenchFrame
> 
> because of these issue i'll postpone the integration and go on with preparing
> OJ 1.6.
> 
> ..ede
> 
> --
> Precog is a next-generation analytics platform capable of advanced analytics
> on semi-structured data. The platform includes APIs for building apps and a
> phenomenal toolset for data science. Developers can use our toolset for
> easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] DBQuery with/out connector jars

[Rahkonen Jukka]

Hi,

I would say that the plugins in Plus should mostly work out-of-the box so +1 
from me for "all except oracle". Oracle would require at least a click through 
agreement from the users so it is "no". 
I made a quick test with the most recent Xerial SQLite driver and it works for 
me
https://bitbucket.org/xerial/sqlite-jdbc/downloads/sqlite-jdbc-3.7.15-SNAPSHOT-2.jar

The latest released version is from August, 2010 for a pretty old SQLite 3.7.2. 
version so I would rather select the snapshot which is for 3.7.15,

-Jukka-


edgar Soldin wrote:
 
> did we decide if we include them?
> 
> if not, please comment.
> 
> if yes, all except oracle?
> 
> ..ede
> 
> --
> Precog is a next-generation analytics platform capable of advanced analytics
> on semi-structured data. The platform includes APIs for building apps and a
> phenomenal toolset for data science. Developers can use our toolset for
> easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[Giuseppe Aruta]

Ede,
before OJ 1.6, I made two upgrades of Color


2013/4/11 Rahkonen Jukka 

> He means this
> http://jumpdbqplugin.sourceforge.net/
>
> -Jukka-
>
> Uwe Dalluege wrote:
>
> > Hi Ede,
> >
> > do you mean with "DBQuery"
> > "Run Datastore Query" ?
> >
> > Uwe
> >
> > Am 11.04.2013 10:47, schrieb edgar.sol...@web.de:
> > > i will include DBQuery into PLUS and create the release. if the
> addition and
> > updating Readme takes longer i will create the release tomorrow.
> > >
> > > ..ede
> > >
> > >
> >
> >
> --
> > Precog is a next-generation analytics platform capable of advanced
> analytics
> > on semi-structured data. The platform includes APIs for building apps
> and a
> > phenomenal toolset for data science. Developers can use our toolset for
> > easy data analysis & visualization. Get a free account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> > ___
> > Jump-pilot-devel mailing list
> > Jump-pilot-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] DBQuery integration into PLUS postponed

[edgar . soldin]

The current "Plugins" main menu item is "Tools" from my point of view. if 
AggregationTool is doing it differently we should think about streamlining it.

we already have quite a few (too many) main menu items. from a usability 
standpoint it is not always clear for a new user, where to expect what. adding 
one more unspecific item is not going to help this situation.

..ede

On 11.04.2013 12:48, Rahkonen Jukka wrote:
> Hi,
> 
> How about putting it into "Plugins" once it comes the time for integration? 
> Different main menus in CORE and PLUS versions might baffle the users. Having 
> Aggregation tool in Plugins-Analysis is already following this model.
> 
> -Jukka-
> 
> edgar soldin wrote:
> 
>> just checked the latest DBQuery plugin and found the following issues:
>>
>> 1. wrong licensing under LGPL3 (see other mail) 2. menu item should be
>> under "File", and not under a not translated "Tools" menu 2a. we already
>> have a DB Query item under File, how do we name the new one :) 3. (minor)
>> dialog should appear centered on WorkbenchFrame
>>
>> because of these issue i'll postpone the integration and go on with preparing
>> OJ 1.6.
>>
>> ..ede
>>

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[edgar . soldin]

when is that going to happen? ..ede

On 11.04.2013 13:03, Giuseppe Aruta wrote:
> Ede,
> before OJ 1.6, I made two upgrades of Color
> 
> 
> 2013/4/11 Rahkonen Jukka  >
> 
> He means this
> http://jumpdbqplugin.sourceforge.net/
> 
> -Jukka-
> 
> Uwe Dalluege wrote:
> 
> > Hi Ede,
> >
> > do you mean with "DBQuery"
> > "Run Datastore Query" ?
> >
> > Uwe
> >
> > Am 11.04.2013 10:47, schrieb edgar.sol...@web.de 
> :
> > > i will include DBQuery into PLUS and create the release. if the 
> addition and
> > updating Readme takes longer i will create the release tomorrow.
> > >
> > > ..ede
> > >
> > >
> >
> > 
> --
> > Precog is a next-generation analytics platform capable of advanced 
> analytics
> > on semi-structured data. The platform includes APIs for building apps 
> and a
> > phenomenal toolset for data science. Developers can use our toolset for
> > easy data analysis & visualization. Get a free account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> > ___
> > Jump-pilot-devel mailing list
> > Jump-pilot-devel@lists.sourceforge.net 
> 
> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 
> 
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net 
> 
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 
> 
> 
> 
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> 
> 
> 
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[Giuseppe Aruta]

Hi Ede ,
before OJ 1.6.  I made a couple odf upgrade of ISA Feature color chooser,
embedded in OJ plus
Please, check here (version 0.5.2 and 0.6)
https://sourceforge.net/projects/opensit/files/Openjump/PlugIn/colorchooser/
- icons resized on toolbar
- new icon for "Choose color option"
- (ver 0.6) now menu is dispayed in two columns*

*
*Peppe
*
**


2013/4/11 Giuseppe Aruta 

> Ede,
> before OJ 1.6, I made two upgrades of Color
>
>
> 2013/4/11 Rahkonen Jukka 
>
>> He means this
>> http://jumpdbqplugin.sourceforge.net/
>>
>> -Jukka-
>>
>> Uwe Dalluege wrote:
>>
>> > Hi Ede,
>> >
>> > do you mean with "DBQuery"
>> > "Run Datastore Query" ?
>> >
>> > Uwe
>> >
>> > Am 11.04.2013 10:47, schrieb edgar.sol...@web.de:
>> > > i will include DBQuery into PLUS and create the release. if the
>> addition and
>> > updating Readme takes longer i will create the release tomorrow.
>> > >
>> > > ..ede
>> > >
>> > >
>> >
>> >
>> --
>> > Precog is a next-generation analytics platform capable of advanced
>> analytics
>> > on semi-structured data. The platform includes APIs for building apps
>> and a
>> > phenomenal toolset for data science. Developers can use our toolset for
>> > easy data analysis & visualization. Get a free account!
>> > http://www2.precog.com/precogplatform/slashdotnewsletter
>> > ___
>> > Jump-pilot-devel mailing list
>> > Jump-pilot-devel@lists.sourceforge.net
>> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>
>>
>> --
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> ___
>> Jump-pilot-devel mailing list
>> Jump-pilot-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>
>
>
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] final steps to OJ 1.6

[edgar . soldin]

sorry, i am confused. what is it you want me to do? update ISA Feature color 
chooser in PLUS?

..ede

On 11.04.2013 13:10, Giuseppe Aruta wrote:
> Hi Ede ,
> before OJ 1.6.  I made a couple odf upgrade of ISA Feature color chooser, 
> embedded in OJ plus
> Please, check here (version 0.5.2 and 0.6) 
> https://sourceforge.net/projects/opensit/files/Openjump/PlugIn/colorchooser/
> - icons resized on toolbar
> - new icon for "Choose color option"
> - (ver 0.6) now menu is dispayed in two columns/
> 
> /
> /Peppe
> /
> //
> 
> 
> 2013/4/11 Giuseppe Aruta  >
> 
> Ede,
> before OJ 1.6, I made two upgrades of Color
> 
> 
> 2013/4/11 Rahkonen Jukka  >
> 
> He means this
> http://jumpdbqplugin.sourceforge.net/
> 
> -Jukka-
> 
> Uwe Dalluege wrote:
> 
> > Hi Ede,
> >
> > do you mean with "DBQuery"
> > "Run Datastore Query" ?
> >
> > Uwe
> >
> > Am 11.04.2013 10:47, schrieb edgar.sol...@web.de 
> :
> > > i will include DBQuery into PLUS and create the release. if the 
> addition and
> > updating Readme takes longer i will create the release tomorrow.
> > >
> > > ..ede
> > >
> > >
> >
> > 
> --
> > Precog is a next-generation analytics platform capable of advanced 
> analytics
> > on semi-structured data. The platform includes APIs for building 
> apps and a
> > phenomenal toolset for data science. Developers can use our toolset 
> for
> > easy data analysis & visualization. Get a free account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> > ___
> > Jump-pilot-devel mailing list
> > Jump-pilot-devel@lists.sourceforge.net 
> 
> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 
> 
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for 
> building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free 
> account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net 
> 
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 
> 
> 
> 
> 
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> 
> 
> 
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> 

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[Uwe Dalluege]

Hi Ede,

maybe this helps:

http://pubs.vmware.com/vfabric5/index.jsp?topic=/com.vmware.vfabric.sqlfire.1.0/reference/language_ref/sql_identifiers.html

All I like to say is that
delimited identifiers
can cause problems.

If you like delimited identifiers
use them!

Uwe

Am 11.04.2013 11:19, schrieb edgar.sol...@web.de:
> On 11.04.2013 08:34, Uwe Dalluege wrote:
> SNIP
>>
>>> There is no restriction too, as tables are created with quoted
>>> strings which accept any character (but maybe it is not a so
>>> common habit among DB adm, and I don't know if quoted
>>> strings for table or column names is part of the SQL standard)
>>>
>>
>> This page tells us something about identifiers:
>>
>> http://www.postgresql.org/docs/9.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
>>
>> ...
>> SQL identifiers and key words must begin with a letter (a-z, but also
>> letters with diacritical marks and non-Latin letters) or an underscore
>> (_). Subsequent characters in an identifier or key word can be letters,
>> underscores, digits (0-9), or dollar signs ($). Note that dollar signs
>> are not allowed in identifiers according to the letter of the SQL
>> standard, so their use might render applications less portable. The SQL
>> standard will not define a key word that contains digits or starts or
>> ends with an underscore, so identifiers of this form are safe against
>> possible conflict with future extensions of the standard.
>> ...
>>
>> I think, this is the SQL standard
>> but as you say
>> maybe this is also SQL standard:
>>
>> ...
>> There is a second kind of identifier: the delimited identifier or quoted
>> identifier. It is formed by enclosing an arbitrary sequence of
>> characters in double-quotes ("). A delimited identifier is always an
>> identifier, never a key word. So "select" could be used to refer to a
>> column or table named "select", whereas an unquoted select would be
>> taken as a key word and would therefore provoke a parse error when used
>> where a table or column name is expected.
>> ...
>
> this is /only/ how PostgreSQL handles it. try to get documentation about the 
> ANSI SQL92, which is the most spread. you will find it is diffcult to obtain 
> as you theoretically would have to purchase it against a fee. if you've got a 
> library access i would be interested what really is written there. but even 
> if it is forbidden there it is up to the implementation of the DBMS to 
> dis/allow any character for table names.
>
> anyway. most DBMS i know support some kind of quoting or escaping that allows 
> pretty much anything in a table name. would be interesting if the dot "." is 
> forbidden :)
>
> btw. interesting bit about the MySQL concept. it makes it depending on the 
> file system the tables are saved on. the file naming conventions essentially 
> apply to how you can name your tables.
>
> ..ede
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[edgar . soldin]

thanks, while not the standard document itself, at least they claim to cite it.

anyway, i am on par with Michael on that. it should be optional and implemented 
on writing to a DBMS connection.

..ede

PS: i am totally with that using alnum and underscore is the most common 
denominator and usually safest. however, we should not force people into a work 
flow that we deem as the only correct one. after all we provide a tool and it 
is not up to us to determine it's usage.

On 11.04.2013 13:25, Uwe Dalluege wrote:
> Hi Ede,
> 
> maybe this helps:
> 
> http://pubs.vmware.com/vfabric5/index.jsp?topic=/com.vmware.vfabric.sqlfire.1.0/reference/language_ref/sql_identifiers.html
> 
> All I like to say is that
> delimited identifiers
> can cause problems.
> 
> If you like delimited identifiers
> use them!
> 
> Uwe
> 
> Am 11.04.2013 11:19, schrieb edgar.sol...@web.de:
>> On 11.04.2013 08:34, Uwe Dalluege wrote:
>> SNIP
>>>
 There is no restriction too, as tables are created with quoted
 strings which accept any character (but maybe it is not a so
 common habit among DB adm, and I don't know if quoted
 strings for table or column names is part of the SQL standard)

>>>
>>> This page tells us something about identifiers:
>>>
>>> http://www.postgresql.org/docs/9.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
>>>
>>> ...
>>> SQL identifiers and key words must begin with a letter (a-z, but also
>>> letters with diacritical marks and non-Latin letters) or an underscore
>>> (_). Subsequent characters in an identifier or key word can be letters,
>>> underscores, digits (0-9), or dollar signs ($). Note that dollar signs
>>> are not allowed in identifiers according to the letter of the SQL
>>> standard, so their use might render applications less portable. The SQL
>>> standard will not define a key word that contains digits or starts or
>>> ends with an underscore, so identifiers of this form are safe against
>>> possible conflict with future extensions of the standard.
>>> ...
>>>
>>> I think, this is the SQL standard
>>> but as you say
>>> maybe this is also SQL standard:
>>>
>>> ...
>>> There is a second kind of identifier: the delimited identifier or quoted
>>> identifier. It is formed by enclosing an arbitrary sequence of
>>> characters in double-quotes ("). A delimited identifier is always an
>>> identifier, never a key word. So "select" could be used to refer to a
>>> column or table named "select", whereas an unquoted select would be
>>> taken as a key word and would therefore provoke a parse error when used
>>> where a table or column name is expected.
>>> ...
>>
>> this is /only/ how PostgreSQL handles it. try to get documentation about the 
>> ANSI SQL92, which is the most spread. you will find it is diffcult to obtain 
>> as you theoretically would have to purchase it against a fee. if you've got 
>> a library access i would be interested what really is written there. but 
>> even if it is forbidden there it is up to the implementation of the DBMS to 
>> dis/allow any character for table names.
>>
>> anyway. most DBMS i know support some kind of quoting or escaping that 
>> allows pretty much anything in a table name. would be interesting if the dot 
>> "." is forbidden :)
>>
>> btw. interesting bit about the MySQL concept. it makes it depending on the 
>> file system the tables are saved on. the file naming conventions essentially 
>> apply to how you can name your tables.
>>
>> ..ede
>>
>> --
>> Precog is a next-generation analytics platform capable of advanced
>> analytics on semi-structured data. The platform includes APIs for building
>> apps and a phenomenal toolset for data science. Developers can use
>> our toolset for easy data analysis & visualization. Get a free account!
>> http://www2.precog.com/precogplatform/slashdotnewsletter
>> ___
>> Jump-pilot-devel mailing list
>> Jump-pilot-devel@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[Uwe Dalluege]

I agree! We should not force people to use a special name-convention!

But, IMHO, if we know, from long time of experience, that a table-name like

New Query Layer

can cause problems
we should not force to use this name
by offer them as a good table-name.

uwe
Am 11.04.2013 13:35, schrieb edgar.sol...@web.de:
> thanks, while not the standard document itself, at least they claim to cite 
> it.
>
> anyway, i am on par with Michael on that. it should be optional and 
> implemented on writing to a DBMS connection.
>
> ..ede
>
> PS: i am totally with that using alnum and underscore is the most common 
> denominator and usually safest. however, we should not force people into a 
> work flow that we deem as the only correct one. after all we provide a tool 
> and it is not up to us to determine it's usage.
>
> On 11.04.2013 13:25, Uwe Dalluege wrote:
>> Hi Ede,
>>
>> maybe this helps:
>>
>> http://pubs.vmware.com/vfabric5/index.jsp?topic=/com.vmware.vfabric.sqlfire.1.0/reference/language_ref/sql_identifiers.html
>>
>> All I like to say is that
>> delimited identifiers
>> can cause problems.
>>
>> If you like delimited identifiers
>> use them!
>>
>> Uwe
>>
>> Am 11.04.2013 11:19, schrieb edgar.sol...@web.de:
>>> On 11.04.2013 08:34, Uwe Dalluege wrote:
>>> SNIP

> There is no restriction too, as tables are created with quoted
> strings which accept any character (but maybe it is not a so
> common habit among DB adm, and I don't know if quoted
> strings for table or column names is part of the SQL standard)
>

 This page tells us something about identifiers:

 http://www.postgresql.org/docs/9.2/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

 ...
 SQL identifiers and key words must begin with a letter (a-z, but also
 letters with diacritical marks and non-Latin letters) or an underscore
 (_). Subsequent characters in an identifier or key word can be letters,
 underscores, digits (0-9), or dollar signs ($). Note that dollar signs
 are not allowed in identifiers according to the letter of the SQL
 standard, so their use might render applications less portable. The SQL
 standard will not define a key word that contains digits or starts or
 ends with an underscore, so identifiers of this form are safe against
 possible conflict with future extensions of the standard.
 ...

 I think, this is the SQL standard
 but as you say
 maybe this is also SQL standard:

 ...
 There is a second kind of identifier: the delimited identifier or quoted
 identifier. It is formed by enclosing an arbitrary sequence of
 characters in double-quotes ("). A delimited identifier is always an
 identifier, never a key word. So "select" could be used to refer to a
 column or table named "select", whereas an unquoted select would be
 taken as a key word and would therefore provoke a parse error when used
 where a table or column name is expected.
 ...
>>>
>>> this is /only/ how PostgreSQL handles it. try to get documentation about 
>>> the ANSI SQL92, which is the most spread. you will find it is diffcult to 
>>> obtain as you theoretically would have to purchase it against a fee. if 
>>> you've got a library access i would be interested what really is written 
>>> there. but even if it is forbidden there it is up to the implementation of 
>>> the DBMS to dis/allow any character for table names.
>>>
>>> anyway. most DBMS i know support some kind of quoting or escaping that 
>>> allows pretty much anything in a table name. would be interesting if the 
>>> dot "." is forbidden :)
>>>
>>> btw. interesting bit about the MySQL concept. it makes it depending on the 
>>> file system the tables are saved on. the file naming conventions 
>>> essentially apply to how you can name your tables.
>>>
>>> ..ede
>>>
>>> --
>>> Precog is a next-generation analytics platform capable of advanced
>>> analytics on semi-structured data. The platform includes APIs for building
>>> apps and a phenomenal toolset for data science. Developers can use
>>> our toolset for easy data analysis & visualization. Get a free account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> ___
>>> Jump-pilot-devel mailing list
>>> Jump-pilot-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> __

Re: [JPP-Devel] final steps to OJ 1.6

[Giuseppe Aruta]

Sorry Ede, Bad Internet Connection
OpenJUMP NB (and stable realize 1.5) has ISA Feature  Color Chooser version
0.5.1 (ColorChooser0_5_1.jar). The main (stylistic) problem of this plugin
was that the icons of this plugin on toolbar were smaller than closer other
plugin icons. There must be a post of some months ago about it.
I made an upgrade with "regular" sized icons (ColorChooser 0.5.2) and a
variation of this where menu color is aligned on two columns (ColorChooser
0.6).
I ask you if it is possible to substitute original with one of these (it is
up to you; I trust in your "point of view").ù
regards
peppe



2013/4/11 

> sorry, i am confused. what is it you want me to do? update ISA Feature
> color chooser in PLUS?
>
> ..ede
>
> On 11.04.2013 13:10, Giuseppe Aruta wrote:
> > Hi Ede ,
> > before OJ 1.6.  I made a couple odf upgrade of ISA Feature color
> chooser, embedded in OJ plus
> > Please, check here (version 0.5.2 and 0.6)
> https://sourceforge.net/projects/opensit/files/Openjump/PlugIn/colorchooser/
> > - icons resized on toolbar
> > - new icon for "Choose color option"
> > - (ver 0.6) now menu is dispayed in two columns/
> >
> > /
> > /Peppe
> > /
> > //
> >
> >
> > 2013/4/11 Giuseppe Aruta  giuseppe_ar...@yahoo.it>>
> >
> > Ede,
> > before OJ 1.6, I made two upgrades of Color
> >
> >
> > 2013/4/11 Rahkonen Jukka  jukka.rahko...@mmmtike.fi>>
> >
> > He means this
> > http://jumpdbqplugin.sourceforge.net/
> >
> > -Jukka-
> >
> > Uwe Dalluege wrote:
> >
> > > Hi Ede,
> > >
> > > do you mean with "DBQuery"
> > > "Run Datastore Query" ?
> > >
> > > Uwe
> > >
> > > Am 11.04.2013 10:47, schrieb edgar.sol...@web.de  edgar.sol...@web.de>:
> > > > i will include DBQuery into PLUS and create the release. if
> the addition and
> > > updating Readme takes longer i will create the release
> tomorrow.
> > > >
> > > > ..ede
> > > >
> > > >
> > >
> > >
> --
> > > Precog is a next-generation analytics platform capable of
> advanced analytics
> > > on semi-structured data. The platform includes APIs for
> building apps and a
> > > phenomenal toolset for data science. Developers can use our
> toolset for
> > > easy data analysis & visualization. Get a free account!
> > > http://www2.precog.com/precogplatform/slashdotnewsletter
> > > ___
> > > Jump-pilot-devel mailing list
> > > Jump-pilot-devel@lists.sourceforge.net  Jump-pilot-devel@lists.sourceforge.net>
> > > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> >
> >
> --
> > Precog is a next-generation analytics platform capable of
> advanced
> > analytics on semi-structured data. The platform includes APIs
> for building
> > apps and a phenomenal toolset for data science. Developers can
> use
> > our toolset for easy data analysis & visualization. Get a free
> account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> > ___
> > Jump-pilot-devel mailing list
> > Jump-pilot-devel@lists.sourceforge.net  Jump-pilot-devel@lists.sourceforge.net>
> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> >
> >
> >
> >
> >
> >
> --
> > Precog is a next-generation analytics platform capable of advanced
> > analytics on semi-structured data. The platform includes APIs for
> building
> > apps and a phenomenal toolset for data science. Developers can use
> > our toolset for easy data analysis & visualization. Get a free account!
> > http://www2.precog.com/precogplatform/slashdotnewsletter
> >
> >
> >
> > ___
> > Jump-pilot-devel mailing list
> > Jump-pilot-devel@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
> >
>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
--
Precog is a next-generation analytics

[JPP-Devel] SQL test for tablenames

[Uwe Dalluege]

Hi,

I have made some tests for tablenames in PostgreSQL.

This works (name without delimiter):
create table Abc ( id int );
select * from abc;
select * from ABC;
select * from abC;
---
This causes problems:
create table "Def" ( id int );
select * from "Def"; // this is ok!

--Problems:
--select * from Def;
--select * from def;

-- But if you write (in lower case) this works:
create table "ghi" ( id int );
select * from ghi;
select * from Ghi;
select * from GHI;

Please, can somebody test this with other DBMS?

Thanks.

Uwe

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

[JPP-Devel] About new shortcuts

[Rahkonen Jukka]

Hi,

I noticed only now that with the new keyboard shortcuts the good old Zoom, Pan, 
Select and Info (Alt, Shift-Alt, Ctrl, Ctrl-Alt) do only work when some editing 
tool is selected.  In a normal map view for example Zoom in works with 
Ctrl-Plus which is not as easy to do with one-hand and it is also hard to 
remember that the same operation is accessed through different shortcuts in 
different modes. I am sad about not discovering this a bit earlier.

-Jukka-


--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] About new shortcuts

[edgar . soldin]

On 11.04.2013 15:53, Rahkonen Jukka wrote:
> Hi,
> 
> I noticed only now that with the new keyboard shortcuts the good old Zoom, 
> Pan, Select and Info (Alt, Shift-Alt, Ctrl, Ctrl-Alt) do only work when some 
> editing tool is selected.  In a normal map view for example Zoom in works 
> with Ctrl-Plus which is not as easy to do with one-hand and it is also hard 
> to remember that the same operation is accessed through different shortcuts 
> in different modes. I am sad about not discovering this a bit earlier.
> 

must have introduced that at the last minute. probably while fixing the 
NoteTool issue. will look at it before releasing.

..ede

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] About new shortcuts

[edgar . soldin]

and racing the clock.. *drumroll* fixed in under 30m minutes.. committing it 
later. ..ede

On 11.04.2013 16:00, edgar.sol...@web.de wrote:
> On 11.04.2013 15:53, Rahkonen Jukka wrote:
>> Hi,
>>
>> I noticed only now that with the new keyboard shortcuts the good old Zoom, 
>> Pan, Select and Info (Alt, Shift-Alt, Ctrl, Ctrl-Alt) do only work when some 
>> editing tool is selected.  In a normal map view for example Zoom in works 
>> with Ctrl-Plus which is not as easy to do with one-hand and it is also hard 
>> to remember that the same operation is accessed through different shortcuts 
>> in different modes. I am sad about not discovering this a bit earlier.
>>
> 
> must have introduced that at the last minute. probably while fixing the 
> NoteTool issue. will look at it before releasing.
> 
> ..ede
> 

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] About new shortcuts

[Stefan Steiniger]

nice!
:)

Am 11.04.13 10:24, schrieb edgar.sol...@web.de:
> and racing the clock.. *drumroll* fixed in under 30m minutes.. committing it 
> later. ..ede
>
> On 11.04.2013 16:00, edgar.sol...@web.de wrote:
>> On 11.04.2013 15:53, Rahkonen Jukka wrote:
>>> Hi,
>>>
>>> I noticed only now that with the new keyboard shortcuts the good old Zoom, 
>>> Pan, Select and Info (Alt, Shift-Alt, Ctrl, Ctrl-Alt) do only work when 
>>> some editing tool is selected.  In a normal map view for example Zoom in 
>>> works with Ctrl-Plus which is not as easy to do with one-hand and it is 
>>> also hard to remember that the same operation is accessed through different 
>>> shortcuts in different modes. I am sad about not discovering this a bit 
>>> earlier.
>>>
>>
>> must have introduced that at the last minute. probably while fixing the 
>> NoteTool issue. will look at it before releasing.
>>
>> ..ede
>>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

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

[Michaël Michaud]

  
  
Hi,


  

  With OJ rev. 3459
and W7 (64 bit) I do not
see errors or exceptions.
There is no dialog window or a message
in the status-line.

I tested  "Run Datastore Query"
with this simple query:

select * from xyz

The table xyz does not exists in my database!
But there is no error-message.

With a more recent version, I get the following :



  


  

Michaël

  
  
Uwe



  

  

  Inside the fence there is a polygon
intersects the geometry from "Bauernhof"
But this does not work.

1. I do not see an error message.
2. What is the 0 after fence:  ?

Regards

uwe

Am 10.04.2013 11:40, schrieb 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.

  
-Jukka Rahkonen-

Uwe Dalluege wrote:



  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-generation analytics platform capable of
advanced analytics on semi-structured data. The platform includes
APIs for building apps and a phenomenal toolset for data science.
Developers can use our toolset for easy data analysis &
visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel


--
 Precog is a next-generation analytics platform capable of
advanced analytics on semi-structured data. The platform includes APIs
for building apps and a phenomenal toolset for data science.
Developers can use our toolset for easy data analysis & visualization.
Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel


  

--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel


  
  --
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel






--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel


  
  
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
___
Jump-pilot-devel mail

[JPP-Devel] OpenJUMP 1.6.0 released

[edgar . soldin]

Good things come to those who wait. Find the latest, greatest OpenJUMP here
http://sourceforge.net/projects/jump-pilot/files/OpenJUMP/1.6.0/

Thank you all who contributed, filed bugs, fixed things, designed icons etc. 
etc.
This release is the result of all your efforts. Thanks!

Now everybody - Jump, Jump ..ede


Here a list of (most) of the changes:
  
New Features
  * adding support for GeoTIFF with transformation matrix georeferencing
courtesy of Nicolas Ribot
  * add arrange view horizontally and vertically to the view menu
  * add a PostGIS writer including 5 options to create a PostGIS table, to 
insert rows or to update an existing table.
  * add a "selection" parameter option to RunDataStoreQueryPlugIn
  * add Dynamic Attributes based on beanshell snippets + persistence in openjump
project files.
  * add Tools > Generate > Create Point Layer from Attribute Table
  * add Tools > Edit Attributes > Join Table... to attach attributes 
from an one layer to another layer based on a unique ID field
  * add 6 plugins derived from Noder plugin available in LayerView context menu
  * add Merge selected features in place in LayerView context menu (FR 3506380)
  * add Offset curve plugin
  * add View > Map decoration > NorthArrow plugin
  * add densifier function in Tools > Analysis > Geometry functions (FR 3516240)
  * add Tools > Edit Attributes > Add 3D Geometry Attributes plugin
  * add Tools > Edit Attributes > Add Geometry Attributes plugin
  * add detachable InternalFrame
  * add Generate > Create Grid plugin
  * add Generate > Voronoi Diagram plugin
  * add Generate > Triangulation plugin
  * added -h/-help, -v/-version, -p/-properties command line parameters
  * load project and data files when given via command line
  * Include CoverageCleanerPlugIn in Topology extension
  * general shortcut support, shortcut documentation under Help
  * Help > About > Info contains more details now 
  * status bar: enhanced resizablity, tooltips and look
  * windows starter automatically detects available ram now
  
Improvements
  * create a View > Map Decoration submenu including ScaleBarPlugin, 
ShowScalePlugIn and NorthArrowPlugin
  * add or changed icons in many menu items
  * improved command line parameters
  * improved Layer Name presentation
  * improved isSimple check in ValidateSelectedLayersPlugIn
  * migration from jts-1.12 to jts-1.13
  * clip to fence plugin : center dialog box and change default option
  * improved PlanarGraphPlugIn code
  * include csv-driver in the datasource framework
  * improvements of ExtractLayersByAttribute and SIDLayer courtesy of L Becker
  * improvement of SaveDatasetsPlugIn (ready for new drivers format persistence)
  * FR 3491966 Improve performance of label rendering with very large polygons.
  * Exceptions thrown by BeanshellTools are now shown to the user
  * Select and activate SelectFeaturesTool the first time OpenJUMP is opened
  * ViewAttributesPlugIn now saves/restores the window position and size
  * file formats with lower case description are now capitalized so they do not 
get sorted to the end of the file format list in file chooser any more
  * allow saving text based decoration styles in a project
  * change default Open Wizard to Open File (was Open Project)
  * Postgis Reader/Writer several important fixes
  * Beantools are now properly sorted uneder MacOSX and Linux
  
Bug Fixes
  * create Lattice from Raster failed in some cases
  * id 3590463 : in PlanarGraphPlugIn
  * xtiff_en_US.properties was not found by org.libtiff.jai.util.PropertyUtil
  * id 3077786 : makes referenced images resizable
  * id 3525977 : PNG rasters with void pixels not displayed
  * id 3570707 : LayerNameRenderer and Windows 7 issue
  * id 3575323 : fixed and changed the whole layout of Attribute Calculator
  * id 3571031 : Too long field names saved into dbf
  * SavaDatasetAsPlugIn now check that it produces a valid file name
  * id 3564137 : view containing a single RasterImageLayer can now be exported
  * id 3564039 : infinite loop possible in the raster rendering engine
  * id 3528917 : Open wizard looks weird with windows 64
  * id 3526653 : SaveImageAsPlugIn did not always scale the RasterImage
  * improved robustess of NoderPlugIn
  * fix three small bugs in sld export
  * fix an NPE in MergeSelectedPolygonsWithNeighbourPlugIn
  * fixed bug in OpenUMPSextanteRasterLayer
  * id 3526321 : bugfix  "switching L&F layout issues in OpenWizard"
  * id 3526277 : create polygon from closed area sometimes displayed
the progressbar forever
  * id 3446420 : fix import of zipped shapefiles with XML metadata file
  * bug 3600776 : regression in LabelStyle (caused by jts update to 1.13)
  * fix 1447907 : upgrade jdom.jar (1.0b8) to jdom-1.1.3.jar
  * fix 1472782 : date is now shown with time in attribute table. It is 
persisted as timestamp in postgis database and jml files, but time is lost
in shapefiles.
  * bug 3607970 : fix two problems in Simplif

Re: [JPP-Devel] DBQuery license issue

[Larry Reeder]

Hey Ede,

Too late for the 1.6 release, but, sure, I am fine to relicense as GPL3.
I'll create a new version of the plugin this weekend with a new license.

 -lreeder


On Thu, Apr 11, 2013 at 4:01 AM,  wrote:

> Larry,
>
> i see you licensed your extension under LGPL3. unfortunately it is based
> OJ sources (plugin,extension interface, probably other code) hence it must
> be licensed under GPL either 2 or 3. would you be willing to relicense?
>
> while i am not in a position to force you, i assume it is just an
> oversight on your part. proper licensing unfortunately is necessary if we
> distribute third party code.
>
>
> thanks.. ede
>
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] DBQuery integration into PLUS postponed

[Larry Reeder]

On Thu, Apr 11, 2013 at 4:33 AM,  wrote:

> just checked the latest DBQuery plugin and found the following issues:
>
> 1. wrong licensing under LGPL3 (see other mail)
>

Addressed this- the plugin can switch to GPL3


> 2. menu item should be under "File", and not under a not translated
> "Tools" menu

2a. we already have a DB Query item under File, how do we name the new one
> :)
>

Yes, that would be confusing.  The main difference from the current DBQuery
that I can see is it can query multiple DBs.  Maybe "Diverse DB Query"?
That's not great, I'm open to suggestions.

3. (minor) dialog should appear centered on WorkbenchFrame
>
>
I'll see if I can fix this.

   -Larry


> because of these issue i'll postpone the integration and go on with
> preparing OJ 1.6.
>
> ..ede
>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Re: [JPP-Devel] DBQuery integration into PLUS postponed

[Larry Reeder]

On Thu, Apr 11, 2013 at 5:04 AM,  wrote:

> The current "Plugins" main menu item is "Tools" from my point of view. if
> AggregationTool is doing it differently we should think about streamlining
> it.
>

I don't have a strong opinion about where this goes, but I don't see the
problem with putting it in plugins.


>
>
> --
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> ___
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
--
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter___
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel