Hi Matthias,

Thanks a lot for your report,
Seems you did a good job for OpenJUMP promotion.

About point 5 I see different approaches :
1) define the link and load the joined data
2) define a link and read the joined data through a dynamic link (means 
also dynamic featureschema)
3) load the data and join the layers inside OpenJUMP

1 : that's what our "join TXT table" plugin already does, in a very 
basic way.
I can see several improvements like :
- accept other formats (excel would be a good candidate, jdbc another one)
- accept 1:n relations : not very difficult if we just want to duplicate 
features every time they match a table record
another option can be to aggregate attributes from external table

2 : creating dynamic link to an external datasource is probably not the 
simplest task.

3 : if you can load data first, performing the join inside OJ can be 
done with the matching plugin
To an attribute table OpenJUMP will need to add a geometry. This can 
easily be done
from a text file
0, 0, building, owner
or from a postgis database
SELECT ST_Point(0.0, 0.0), building, owner from ownerTable

Matching plugin can do purely semantic join (set geometric criteria to 
"match all")
You can aggregate several owners on each building, it will appear as 
owners=[owner1, owner2, owner3]

Michaël

> Hi,
>
> here comes my small report from the german FOSSGIS conference in Dessau.
>
> 1. Some people had the feeling that OJ was dead. These doubts I could
> eliminate :-) We make not the big, spectacular steps in development, but
> OJ is alive. One consequence can be, that we make more and better
> marketing for our "baby".
>
> 2. There was some questions about the WFS support in OJ. Especially the
> "T" letter will be more and more important for the users. I hope I have
> said nothing wrong, that the plugin have WFS-T support. At least that is
> on the wiki page.
>
> 3. A few users gave me the confirmation that a german website especially
> for the german speaking people is a good thing. On the www.openjump.de
> website you can see a photo from the OJ booth.
>
> 4. As you can see I had a rollup and flyers. If anyone need flyers or
> the rollup for a presentation, I can send him that. But both things are
> in german!
>
> 5. One question I couldn't answer. Is there a possibility to make a
> "Join" from an attribute to some external data? In the ArcGIS this is
> possible (but i have never seen any Arc produkt). For examle you have a
> shape file with a ID attribute column. This ID's are unique. And on the
> other side you have a CSV or Excel file with some metadata for the
> geometries in that shape file. In the external metadata file you have
> the same ID's to join both. But this is a 1:n relation! As an example
> you can imagine that you have a shape file with some buildings. Now you
> get a CSV/Excel file with the owners of this buildings from a external
> provider and you need to view or query all the owners for every building
> in the map. There is no problem to convert this metadata in some other
> formats or databases. But I see the problem to represent multiple
> metadata for one geometry. Any idea?????
>
> 6. And finally i met Sascha and Björn from the Intevation company. We
> had talked about some OJ stuff and possible or desirable works in the
> future. Such as improvements in the rendering or a integrated print
> function.
>
> Regards
>
> Matthias
>
>
>
> ------------------------------------------------------------------------------
> For Developers, A Lot Can Happen In A Second.
> Boundary is the first to Know...and Tell You.
> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
> http://p.sf.net/sfu/Boundary-d2dvs2
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>


------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel

Reply via email to