RE: [OSGeo-Discuss] Open Geo Database
just as another note, as of GRASS 7 it looks like they will be moving their
default DB format to SQLITE instead of the traditional DBF format
http://grass.gdf-hannover.de/wiki/GRASS_7_ideas_collection#Database
it might make sense to have a community effort contribute to this as a whole.
The positive side is that there is already adoption of an OSGEO product as
GRASS is moving in this direction. Determine a comon schema that can be shared
around between projects and voila.
Or we could ignore this and then revist this same issue again in the future
with no movement forward.
just thought I'd share.
Cheers
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Basques
Sent: Wednesday, January 16, 2008 09:40
To: OSGeo Discussions
Subject: Re: [OSGeo-Discuss] Open Geo Database
All,
Don't know the specifics about the engine being used, but we discussed using
the Plone storage mechanism, a few times, for spatial data. Just didn't seem
like a quick enough payoff to try anything out. At least not on the surface.
There was a thought that there might be something to start with though.
bobb
Miguel Montesinos wrote:
Hi,
¿Does anyone know about similar projects using object oriented
databases, such as db4objects[1], which is a GPL product with native engines
for Java, Java ME, Mono, .NET, ...?
Cheers
[1] http://www.db4o.com/
-
Miguel Montesinos
Director Técnico
PRODEVELOP
C/ Conde Salvatierra, 34 - 10
46004 Valencia. Spain
e-mail: [EMAIL PROTECTED]
http://www.prodevelop.es
Tlf: +34 963510612
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Frank Hardisty
Sent: Tuesday, January 15, 2008 4:08 PM
To: OSGeo Discussions
Subject: Re: [OSGeo-Discuss] Open Geo Database
David and All,
A nice up-and-coming open Java geodatabase format is H2 +
spatial extensions.
The H2 database is by the same guy that wrote that HSQL db. H2
has some good properties, most importantly, it's small (1 Mb),
works well in embedded mode, and is fast. Adding in spatial
data in JTS format, and providing a spatial index, is the
basic concept.
Two implementations that I know of are
1. The French research group IRSTV, lead programmer seems to
be Erwan Bocher.
http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download
2. GeoTools has a H2 spatial module, written by Justin
Deoliveira.
Here's a link to the compiled jars:
http://maven.geotools.fr/repository/org/geotools/gt2-h2/2.5-SNAPSHOT/
Both are under active development.
regards,
-Frank
On Jan 14, 2008 3:14 PM, Sampson, David <[EMAIL PROTECTED]>
<mailto:[EMAIL PROTECTED]> wrote:
Hey Folks,
Just wondering if there is still thought out there from
the previous
thread about a portable and open geodatabase. I came
across the
nemesis project "an experimental finite element code.
Utilizes SQLite
to store, handle and retrieve geometry and analysis
data. "
http://www.nemesis-project.org/index.php/Main_Page
Thought that might be a good place to start that is
already using
geometry in sqlite.
As for software adoptions it looks like GRASS already
has an
SQLITE driver.
QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE
tutorial
http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-tool
box.html
GDAL has some SQLITE
http://www.gdal.org/ogr/drv_sqlite.html
Just some more info for the fire.
Re: [OSGeo-Discuss] Open Geo Database
All, Don't know the specifics about the engine being used, but we discussed using the Plone storage mechanism, a few times, for spatial data. Just didn't seem like a quick enough payoff to try anything out. At least not on the surface. There was a thought that there might be something to start with though. bobb Miguel Montesinos wrote: Hi, ¿Does anyone know about similar projects using object oriented databases, such as db4objects[1], which is a GPL product with native engines for Java, Java ME, Mono, .NET, ...? Cheers [1] http://www.db4o.com/ - Miguel Montesinos Director Técnico PRODEVELOP C/ Conde Salvatierra, 34 - 10 46004 Valencia. Spain e-mail: [EMAIL PROTECTED] http://www.prodevelop.es Tlf: +34 963510612 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Frank Hardisty Sent: Tuesday, January 15, 2008 4:08 PM To: OSGeo Discussions Subject: Re: [OSGeo-Discuss] Open Geo Database David and All, A nice up-and-coming open Java geodatabase format is H2 + spatial extensions. The H2 database is by the same guy that wrote that HSQL db. H2 has some good properties, most importantly, it's small (1 Mb), works well in embedded mode, and is fast. Adding in spatial data in JTS format, and providing a spatial index, is the basic concept. Two implementations that I know of are 1. The French research group IRSTV, lead programmer seems to be Erwan Bocher. http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download 2. GeoTools has a H2 spatial module, written by Justin Deoliveira. Here's a link to the compiled jars: http://maven.geotools.fr/repository/org/geotools/gt2-h2/2.5-SNAPSHOT/ Both are under active development. regards, -Frank On Jan 14, 2008 3:14 PM, Sampson, David <[EMAIL PROTECTED]> wrote: Hey Folks, Just wondering if there is still thought out there from the previous thread about a portable and open geodatabase. I came across the nemesis project "an experimental finite element code. Utilizes SQLite to store, handle and retrieve geometry and analysis data. " http://www.nemesis-project.org/index.php/Main_Page Thought that might be a good place to start that is already using geometry in sqlite. As for software adoptions it looks like GRASS already has an SQLITE driver. QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE tutorial http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-tool box.html GDAL has some SQLITE http://www.gdal.org/ogr/drv_sqlite.html Just some more info for the fire. Cheers ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss -- Frank Hardisty [EMAIL PROTECTED] GeoVISTA Center 210 Walker Building Dutton e-Education Institute 415 Earth and Engineering Sciences Building 814-867-1471 http://www.geovista.psu.edu/grants/cdcesda/software/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
RE: [OSGeo-Discuss] Open Geo Database
Hi, ¿Does anyone know about similar projects using object oriented databases, such as db4objects[1], which is a GPL product with native engines for Java, Java ME, Mono, .NET, ...? Cheers [1] http://www.db4o.com/ - Miguel Montesinos Director Técnico PRODEVELOP C/ Conde Salvatierra, 34 - 10 46004 Valencia. Spain e-mail: [EMAIL PROTECTED] http://www.prodevelop.es Tlf: +34 963510612 >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Frank Hardisty >Sent: Tuesday, January 15, 2008 4:08 PM >To: OSGeo Discussions >Subject: Re: [OSGeo-Discuss] Open Geo Database > >David and All, > >A nice up-and-coming open Java geodatabase format is H2 + >spatial extensions. > >The H2 database is by the same guy that wrote that HSQL db. H2 >has some good properties, most importantly, it's small (1 Mb), >works well in embedded mode, and is fast. Adding in spatial >data in JTS format, and providing a spatial index, is the >basic concept. > >Two implementations that I know of are > >1. The French research group IRSTV, lead programmer seems to >be Erwan Bocher. >http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download > >2. GeoTools has a H2 spatial module, written by Justin Deoliveira. >Here's a link to the compiled jars: >http://maven.geotools.fr/repository/org/geotools/gt2-h2/2.5-SNAPSHOT/ > >Both are under active development. > >regards, >-Frank > > >On Jan 14, 2008 3:14 PM, Sampson, David <[EMAIL PROTECTED]> wrote: >> >> >> >> Hey Folks, >> >> Just wondering if there is still thought out there from the previous >> thread about a portable and open geodatabase. I came across the >> nemesis project "an experimental finite element code. >Utilizes SQLite >> to store, handle and retrieve geometry and analysis data. " >> >> http://www.nemesis-project.org/index.php/Main_Page >> >> Thought that might be a good place to start that is already using >> geometry in sqlite. >> >> As for software adoptions it looks like GRASS already has an >SQLITE driver. >> >> QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE tutorial >> >http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-tool >> box.html >> >> GDAL has some SQLITE http://www.gdal.org/ogr/drv_sqlite.html >> >> >> Just some more info for the fire. >> >> Cheers >> ___ >> Discuss mailing list >> Discuss@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/discuss >> >> > > > >-- > >Frank Hardisty >[EMAIL PROTECTED] > >GeoVISTA Center >210 Walker Building > >Dutton e-Education Institute >415 Earth and Engineering Sciences Building > >814-867-1471 >http://www.geovista.psu.edu/grants/cdcesda/software/ >___ >Discuss mailing list >Discuss@lists.osgeo.org >http://lists.osgeo.org/mailman/listinfo/discuss > ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Open Geo Database
David and All, A nice up-and-coming open Java geodatabase format is H2 + spatial extensions. The H2 database is by the same guy that wrote that HSQL db. H2 has some good properties, most importantly, it's small (1 Mb), works well in embedded mode, and is fast. Adding in spatial data in JTS format, and providing a spatial index, is the basic concept. Two implementations that I know of are 1. The French research group IRSTV, lead programmer seems to be Erwan Bocher. http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download 2. GeoTools has a H2 spatial module, written by Justin Deoliveira. Here's a link to the compiled jars: http://maven.geotools.fr/repository/org/geotools/gt2-h2/2.5-SNAPSHOT/ Both are under active development. regards, -Frank On Jan 14, 2008 3:14 PM, Sampson, David <[EMAIL PROTECTED]> wrote: > > > > Hey Folks, > > Just wondering if there is still thought out there from the previous thread > about a portable and open geodatabase. I came across the nemesis project > "an experimental finite element code. Utilizes SQLite to store, handle and > retrieve geometry and analysis data. " > > http://www.nemesis-project.org/index.php/Main_Page > > Thought that might be a good place to start that is already using geometry > in sqlite. > > As for software adoptions it looks like GRASS already has an SQLITE driver. > > QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE tutorial > http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-toolbox.html > > GDAL has some SQLITE http://www.gdal.org/ogr/drv_sqlite.html > > > Just some more info for the fire. > > Cheers > ___ > Discuss mailing list > Discuss@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/discuss > > -- Frank Hardisty [EMAIL PROTECTED] GeoVISTA Center 210 Walker Building Dutton e-Education Institute 415 Earth and Engineering Sciences Building 814-867-1471 http://www.geovista.psu.edu/grants/cdcesda/software/ ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] Open Geo Database
Sampson, David ha scritto: > Hey Folks, > > Just wondering if there is still thought out there from the previous > thread about a portable and open geodatabase. I came across the nemesis > project "an experimental finite element code. Utilizes SQLite to store, > handle and retrieve geometry and analysis data. " > > _http://www.nemesis-project.org/index.php/Main_Page_ > > Thought that might be a good place to start that is already using > geometry in sqlite. Hi all. Here in Italy one of our GFOSS.it associates is developing a spatial extension for SQLite. It should be released soon. I tested it and it works smoothly. All the best. pc -- Paolo Cavallini, see: http://www.faunalia.it/pc ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
RE: [OSGeo-Discuss] Open Geo Database
It looks like nemesis stores geometry as ASCII text. Which means it would be SLOW to put stuff in and get stuff out of the database (atof and sprint are the, ahem, nemesis of speed). I got my information from reading the source file SQLiteDatabase.cpp (http://nemesis-code.googlecode.com/svn/trunk/src/database/SQLiteDatabase.cpp), not sure if that was the right place to look. Traian From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sampson, David Sent: Monday, January 14, 2008 3:14 PM To: discuss@lists.osgeo.org Subject: [OSGeo-Discuss] Open Geo Database Hey Folks, Just wondering if there is still thought out there from the previous thread about a portable and open geodatabase. I came across the nemesis project "an experimental finite element code. Utilizes SQLite to store, handle and retrieve geometry and analysis data. " http://www.nemesis-project.org/index.php/Main_Page Thought that might be a good place to start that is already using geometry in sqlite. As for software adoptions it looks like GRASS already has an SQLITE driver. QGIS looks hopeful. Here is a GRASS/QGIS-SQLITE tutorial http://whatnick.blogspot.com/2007/12/using-sqlite-with-qgis-grass-toolbox.html GDAL has some SQLITE http://www.gdal.org/ogr/drv_sqlite.html Just some more info for the fire. Cheers ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
