Hi, Just a side note about OpenJUMP + personnal database : I'm sure that SQLite database has great qualities and can add great capabilities to OpenJUMP, but I've always been reluctant to introduce dll into OpenJUMP distribution (difficulty to keep it multiplatform, lack of visibility on C code due to my ignorance, code duplication to achieve the same goal like JTS/Geos in this case...) For these reasons, good or bad, I'd be much more enthousiast to integrate java projects like h2 database (a small java database which can be used both as an embeded database or as a server), hatbox (a spatial index for h2 which works a bit like the one of spatialite (as far as I know), Jaspa (a project adding to all ST_xxx geometry functions to h2). Unfortunately, there is still some work to integrate such projects into OpenJUMP and my time and my skill are too limited for that. Just wanted to share this thought, but I admit that Spatialite is a mature project which can add nice capabilities with a smaller effort.
My 2 cents, Michaël > Hi, > > Not really, Spatialite is a spatial extension for SQLite database engine and > it does not work with other databases. > > However, this is not the whole truth and it is indeed possible to use SQLite > and Spatialite functions for handling external data that is not stored into > the SQLite data file at all. SQLite has some magic system called "virtual > table" which makes it possible to connect a CSV file or Excel spreadsheet > virtually from SQLite database without importing data. When this connection > is made it is possible to do SQL queries agains the native files as they were > real database tables. Of course this connection is not optimal when it comes > to speed. > GDAL can also utilise SQLite and Spatialite as a database engine. For > example, it is possible to do a spatial query against a shapefile (or any > other format which is supported by GDAL/OGR) as in this example from the > document http://www.gdal.org/ogr/ogr_sql_sqlite.html > SELECT EAS_ID, ST_Area(GEOMETRY) AS area FROM poly WHERE > ST_Intersects(GEOMETRY, BuildCircleMbr(479750.6875,4764702.0,100)) > > I don't know how easy or difficult it would be to utilise those advanced > features and tricks from Java and OpenJUMP. However, there are many > interesting things to do with plain SQL by considering Spatialite just as a > zero-configuration relational database http://sqlite.org/zeroconf.html > > -Jukka. > ________________________________________ > Lähettäjä: edgar.sol...@web.de [edgar.sol...@web.de] > Lähetetty: 8. huhtikuuta 2013 17:59 > Vastaanottaja: OpenJump develop and use > Aihe: Re: [JPP-Devel] Enhancing DB Query Plugin with Spatialite functions. > > well, done.. thanks. will definitely put that into my queue! one question > still: > do i understand correctly that spatiallite extensions will pretty much work > with any database connection? e.g. postgis, mysql as well? > > ..ede > > > On 08.04.2013 16:38, Rahkonen Jukka wrote: >> Hi, >> >> Well, I made a test database from Hamburg and wrote a short manual about >> installing and testing >> http://latuviitta.org/documents/OpenJUMP_Spatialite_test_manual.pdf >> >> >> -Jukka- >> >> Jukka Rahkonen wrote: >> >>> edgar Soldin wrote: >>> >>>> ok, this sounds too difficult for a last minute inclusion. but we can >>>> start on integrating over the course of the next months. >>>> can you give me a data test set and/or step by step instructions how >>>> it is supposed to work? spatiallite input and spatiallite functions, >>>> which seems to be something different? >>> I can make a test database for you from the OpenStreetMap data. What part >>> of Germany would you like to play with? Select from here >>> http://download.geofabrik.de/europe/germany.html >>> >>> -Jukka- >>> >>> >>> ------------------------------------------------------------------------------ >>> Minimize network downtime and maximize team effectiveness. >>> Reduce network management and security costs.Learn how to hire the most >>> talented Cisco Certified professionals. Visit the Employer Resources Portal >>> http://www.cisco.com/web/learning/employer_resources/index.html >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> ------------------------------------------------------------------------------ >> Minimize network downtime and maximize team effectiveness. >> Reduce network management and security costs.Learn how to hire >> the most talented Cisco Certified professionals. Visit the >> Employer Resources Portal >> http://www.cisco.com/web/learning/employer_resources/index.html >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
