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
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
[OSGeo-Discuss] relevance of Sun's acquisition of MySQL, and promoting support for open source
http://blogs.sun.com/jonathan/ - Sun says, "we're putting a billion dollars behind the M in LAMP." What are the implications of this for OSGeo and friends? Maybe some of Sun's resources will go into bringing MySQL spatial support up to scratch, at last, "spatially enable" a million web apps. Perhaps more relevant is the emphasis Sun's rhetoric places on *support arrangements* - taking quality of and demand for open source software for granted. A "platform vendor" becomes more of a consulting vendor offering "mission critical global support" for a whole stack of stuff, platform through application. MySQL's dual-licensing stance is unusual, in some sense Sun have relly bought the right not to have to relicense, who else will now take this license model more seriously for their product, especially for data. The SPD There's been a lot of setup work done on a directory of organisations offering support for OSGeo software projects. Just another 20% would make it actually useful. http://www.osgeo.org/search_profile is an interesting "advanced" interface but no-one's going to use it as-is, none of the SPD gets indexed by search engines because it's all query-based. A link-based browsable index to it would help catch people who type in phrases like "geoserver support" to yahoo and google. http://wiki.osgeo.org/index.php/SPD_Prioritization has some plans to highlight companies who employ committers, and of course Foundation sponsors, which would take this effort to the next level. But right now it's not at the first level. What is needed to move this effort forward, to get it linked from the main OSGeo page, to encourage contributions and make it easier to find? Who is focusing time on this right now? cheers, jo ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
Re: [OSGeo-Discuss] relevance of Sun's acquisition of MySQL, and promoting support for open source
[EMAIL PROTECTED] wrote: The SPD There's been a lot of setup work done on a directory of organisations offering support for OSGeo software projects. Just another 20% would make it actually useful. http://www.osgeo.org/search_profile is an interesting "advanced" interface but no-one's going to use it as-is, none of the SPD gets indexed by search engines because it's all query-based. A link-based browsable index to it would help catch people who type in phrases like "geoserver support" to yahoo and google. Jo, The Service Provider Directory deliberately does not allow free text in the OSGeo hosted portion of the service provider descriptions so I am dubious that making the existing listing info browseable by searchbots would provide much useful search capability. The SPD listings are intended to point to a web page hosted by the service provider themselves that would contain free text describing their services and that they presumably will make webbot accessable. If for nothing other than our limited "outbound link karma" perhaps it would be good to have our SPD listings indexable. I wonder if we could accomplish this with a pointer to a query for all service providers at some suitable location. You write "no-one's going to use it as-is". Is that because you think the SPD search interface is too hard to use? It really doesn't seem all that complicated to me. At it's simpliest you go to: http://www.osgeo.org/search_profile And hit the "Search" button with no other changes to get a list of all registered service providers. Selecting a locale, language or technology restricts the return list. http://wiki.osgeo.org/index.php/SPD_Prioritization has some plans to highlight companies who employ committers, and of course Foundation sponsors, which would take this effort to the next level. It is my intention to follow up on the prioritization proposal with the community. I'll do that in a separate message. But right now it's not at the first level. What is needed to move this effort forward, to get it linked from the main OSGeo page, to encourage contributions and make it easier to find? Who is focusing time on this right now? The Service Provider Directory is linked from www.osgeo.org. It is the "Service Providers" link under "OSGeo Community" on the left side. While I'll concede the SPD isn't exactly slick, I'm not sure why you feel it hasn't reached the "first level" yet. I'll try and connect in IRC to discuss it. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| President OSGeo, http://osgeo.org ___ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
