Thanks Jody and Jesse,
That's very encouraging as a start.
If a project to get H2 into a portable and usable data format for uDIG
required funding (I am assuming over and above that which comes out of
the SOC project) how much work (and therefore $) would be required to
get it into a "solid" data format for uDIG (and would it perform as
well
or better than shapefiles ????)
Sorry, but my Java programming is very limited (ie I am more of a hack
these days and much better at "scripting" than pure programming as
such).
Cheers,
Shaun Kolomeitz,
Senior Technical Officer
Business and Asset Services
Queensland Parks and Wildlife Division
Environmental Protection Agency
Hi Shawn,
For uDig 1.1.x the options are not the best. There is a HSQL
datastore
but it does not have indexing and hasn't got a lot of bug fixes so
that is
not a good option. The postgis is the best but I imagine that you
want
something a little more light-weight. GML is not good because it is
more
of a interchange format and would be very slow for editing or even
zooming > in/out.
I believe the plan is to use the H2 datastore on trunk.
Jesse
Date: Tue, 13 May 2008 13:31:57 -0700
From: Jody Garnett <jgarnett@xxxxxxxxxxxxxxx>
Subject: Re: [udig-devel] Local data file formats supporting
relational data
To: User-friendly Desktop Internet GIS
<udig-devel@xxxxxxxxxxxxxxxxxxxxx>
Message-ID: <4829FABD.2090605@xxxxxxxxxxxxxxx>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi Shaun, in the past we have had an HSQL DataStore to handle this
sort
of work. HSQL did not offer transactional independence (ie threads
working at the same time would stomp all over each other). You will
find
on trunk that an H2 DataStore is available; and by all accounts if
very
capable. I have not intergrated it into uDig yet; but you are more
than
welcome to do so.
There other interesting part about H2 (the same dude who did HSQL
produced H2 as his next project) is that we have a Google Summer of
Code
student working on adding a spatial index; the combination of a small
Java database (H2) with a spatial indexed should be great. Right now
we
have it supporting all the SFSQL functions by virtue of dropping the
JTS
Geometry objects into the database, but without an index to make
them go
fast it cannot be recommended for large quantities of data.
So sign up today, join trunk, and let us know if the H2DataStore meets
your needs.
Jody
Shaun Kolomeitz wrote:
Dear UDIG Development Gurus,
I'm pretty happy with the way uDIG is progressing and the features
that you get "out of the box". You folks are doing a fantastic job
with it and it's coming along well - my congrats all round.
In the back end however I am wondering what format will help us to
manage a file-based geodatabase type structure ?
I am after a structure similar to shapefiles with "related" DBF's,
and
unfortunately we cannot have PostGIS running, just a set of files.
Will GML "do it for us" ?
The Shapefile format doesn't cut it for us because we have a need for
long-text (memo) fields and one to many relationships in the data.
Can anyone suggest a format that we should look at (or is anything on
the horizon like SQLite spatial ???) ?
Any ideas greatly appreciated.
+----------------------------------------------------------------+
Think B4U Print
1 ream of paper = 6% of a tree and 5.4kg CO2 in the atmosphere
3 sheets of A4 paper = 1 litre of water
+----------------------------------------------------------------+
_________________________
Disclaimer
WARNING: This e-mail (including any attachments) has originated from
a Queensland Government department and may contain information that
is confidential, private, or covered by legal professional
privilege, and may be protected by copyright.
You may use this e-mail only if you are the person(s) it was
intended to be sent to and if you use it in an authorised way. No
one is allowed to use, review, alter, transmit, disclose,
distribute, print or copy this e-mail without appropriate
authority. If you have received this e-mail in error, please inform
the sender immediately by phone or e-mail and delete this e-mail,
including any copies, from your computer system network and destroy
any hardcopies.
Unless otherwise stated, this e-mail represents the views of the
sender and not the views of the Environmental Protection Agency.
Although this e-mail has been checked for the presence of computer
viruses, the Environmental Protection Agency provides no warranty
that all viruses have been detected and cleaned. Any use of this e-
mail could harm your computer system. It is your responsibility to
ensure that this e-mail does not contain and is not affected by
computer viruses, defects or interference by third parties or
replication problems (including incompatibility with your computer
system).
E-mails sent to and from the Environmental Protection Agency will be
electronically stored, managed and may be audited, in accordance
with the law and Queensland Government Information Standards (IS31,
IS38, IS40, IS41 and IS42) to the extent they are consistent with
the law.
___________________________
!DEPTSTAMP1!
