Hi,
Le 07/04/2015 10:49, Andrea Aime a écrit :
On Tue, Apr 7, 2015 at 10:23 AM, Nicolas Fortin <geoto...@nettrader.fr
<mailto:geoto...@nettrader.fr>> wrote:
Hi,
Some additional comments on Erwan's answer.
Le 06/04/2015 09:13, Andrea Aime a écrit :
Interesting, could you compare that with the GeoTools H2 datastore?
GeoTools H2 datastore use blob as geometry columns and does not
include spatial index.
The H2 store has a spatial index, r-tree, implemented as a side table,
courtesy of the hatbox project:
http://hatbox.sourceforge.net/
But I don't think it has many functions, and the project has last made
a release in 2011.
H2GIS supports all SFS functions and several advanced spatial analysis
tools (network, noise map, constrained triangulation...). H2GIS is fully
linked with H2 engine that's not the case for hatbox wich uses its own
file index.
H2GIS use the new native Geometry columns and spatial index of H2.
Moreover H2GIS provides all SFS sql functions, geometry
constraints and file drivers.
File drivers?
With H2GIS you can create a virtual table on a shapefile (only in read
mode but spatial index is supported).
Cheers
Erwan
Since you seem to be an expert in H2, I have a question for you.
In GeoTools and GeoServer we use H2 in
multiple places, but an old version of it.
This is mostly because H2 changed the on disk format, and
apparently did not include an automatic upgrade
procedure for it... which is a serious problem when users are
upgrading existing installations.
Do you know of a way to make the upgrades transparent?
I think you are talking about the old storage before the
PageStore. The great issue here is the necessity of embedding two
versions of H2, one for creating a sql dump of the database and
the latest to execute the dump. Even if you could achieve that it
could failed. There is a discussion about that here
<https://groups.google.com/forum/?fromgroups=#%21searchin/h2-database/migration%7Csort:date/h2-database/3TuWJfFiQdc/7TGTJB1JEmoJ>.
As the user may loose some data if its done unnoticed; maybe it is
more secure to update h2 in a new major version of
geotools/geonetwork then warn about the database incompatibility.
Eh, that's a major issue, because H2 databases are not exactly in user
visible positions, they are used
internally by the program, often the end users are not even aware of them.
For example, in GWC they are used to store the disk quota database, in
GeoServer to store indexes
for the KML superoverlays, to collect the history of requests in the
monitoring module, or the
GeoServer catalog itself in the database driven catalog module.
People using the GeoServer importer have certain types of data (kml,
geojson, csv) importer by
default into a H2 store if they do not ask.
Cheers
Andrea
--
==
GeoServer Professional Services from the experts! Visit
http://goo.gl/NWWaa2 for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
*AVVERTENZE AI SENSI DEL D.Lgs. 196/2003*
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate.
Il loro utilizzo è consentito esclusivamente al destinatario del
messaggio, per le finalità indicate nel messaggio stesso. Qualora
riceviate questo messaggio senza esserne il destinatario, Vi preghiamo
cortesemente di darcene notizia via e-mail e di procedere alla
distruzione del messaggio stesso, cancellandolo dal Vostro sistema.
Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità
diverse, costituisce comportamento contrario ai principi dettati dal
D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely
for the attention and use of the named addressee(s) and may be
confidential or proprietary in nature or covered by the provisions of
privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New
Data Protection Code).Any use not in accord with its purpose, any
disclosure, reproduction, copying, distribution, or either
dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the
intended recipient, please contact immediately the sender by
telephone, fax or e-mail and delete the information in this message
that has been received in error. The sender does not give any warranty
or accept liability as the content, accuracy or completeness of sent
messages and accepts no responsibility for changes made after they
were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
-------------------------------------------------------
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
