Hi Stefan > but didn't write Erwans project a spatial extension to H2 already? > Yes, Erwan did a nice work, adding all the needed spatial functions to h2. (And I saw another project working in this field: http://code.google.com/p/h2spatial/)
But none of them did the hard part which is adding spatial indexing to the database core. H2 already included a "Multi-Dimensionnal" index, but such an index, probably quite efficient for points, is not well suited for complex sptial data like polygons. Also I don't know if geometry datatype is completly integrated in erwan's h2spatial (as there has been recent improvements in h2 management of domain specific datatypes). In fact, OrbisGIS now uses gdms, which is a kind of middleware between datasources and gis ui. I don't know if OrbisGis even need h2spatial. Michaël > see this page: > http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download > > Michael Michaud schrieb: > >> Hi >> >>> In general this seems like a nice way to go. Even nicer IMHO would be a >>> pure Java DB like H2. But someone needs to step to "spatializing" H2 >>> for this to be appealing for OJ. Probably a similar approach to >>> SpatialLite can be taken here, except for one thing - H2 doesn't have an >>> Rtree index. >>> >>> Ultimately it would be nice to see the spatial datatype more fully >>> integrated in H2, like it is in PostGIS. That's my dream, anyway... >>> >>> >> It's mine, too, as you can guess if you read my first comment on your >> blog post about JTS 1.10 release : >> http://lin-ear-th-inking.blogspot.com/2009/01/jts-version-110-released.html#links >> >> Michaël >> >>> P.Rizzi Ag.Mobilità Ambiente wrote: >>> >>> >>>> Good idea!!! >>>> >>>> I see there's even a JDBC driver for it: >>>> http://www.zentus.com/sqlitejdbc/ >>>> >>>> so I may take a look at it, but even if I can add SQLite support to the >>>> SISDB plugin, >>>> it will be read-only like any other OJ DataStore. >>>> >>>> But the great thing would be the adoption of a light DB, such as >>>> SQLite/SpatialLight, >>>> as the "native" file storage/exchange system of OpenJump!!! >>>> >>>> Bye >>>> Paolo Rizzi >>>> >>>> >>>> ________________________________ >>>> >>>> Da: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi] >>>> Inviato: ven 09/01/2009 14.09 >>>> A: OpenJump develop and use >>>> Oggetto: [JPP-Devel] (no subject) >>>> >>>> >>>> >>>> Hi, >>>> >>>> Sooner or later all data do not fit in the memory and OpenJUMP user has >>>> troubles. Having PostGIS or Oracle datastore solves size limits, but OJ >>>> does not support updates well. In addition, many people seem to fear >>>> PostGIS, and for sure it is a bit heavy weight pair for OpenJUMP which >>>> is very simple to install and run. How about trying some leight weight >>>> spatial database as well? It took 2 minutes for the first timer to >>>> download, install and launch the SpatiaLite database on a Windows >>>> machine. No admisnistrator rights are needed, and when installed it is >>>> just one single 3 MB exe file on a disk! Perhaps some developer could >>>> have a look and say if it could be useful with OpenJUMP? SpatiaLite >>>> seems to include Proj4, so is could give OpenJUMP support for >>>> projections as well. See: >>>> >>>> http://www.gaia-gis.it/spatialite-2.2/index.html >>>> >>>> Regards, >>>> >>>> -Jukka Rahkonen- >>>> > > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > ------------------------------------------------------------------------------ Check out the new SourceForge.net Marketplace. It is the best place to buy or sell services for just about anything Open Source. http://p.sf.net/sfu/Xq1LFB _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
