Re: [Geotools-devel] DB2 Plugin

2008-12-30 Thread David Adler
The DB2 internal geometry representation uses integer coordinate values that are compressed. The ST_AsBinary and ST_AsText functions are provided as ways for applications to work with the spatial data in an industry standard (OGC and ISO) format. The various spatial constructors accept data in

Re: [Geotools-devel] DB2 Plugin

2008-12-26 Thread Christian Müller
DB2 stores the vector data in an internal format (using 4 byte Integers). This format is not official. Reading the data only as blob makes no sense because you cannot apply any operations on it. You have to use ST_ASBINARY if you want a WKB representation. Other possibilities are ST_ASTEXT f

[Geotools-devel] DB2 Plugin

2008-12-25 Thread Shyam Nagarajan
Hi, I want to reuse the code that has been written for the DB2 Plugin for another tool that I am developing. My question is on how to read the blob data that DB2 uses to store geometry data. I looked through the DB2 Plugin, from what I understand ST_AsBinary is used to convert the geometry blob d

Re: [Geotools-devel] db2 plugin ( jdbc-ng ) would be ready to commit

2008-10-29 Thread Justin Deoliveira
Christian Müller wrote: > the new db2 plugin would be ready to commit. The only showstoppers are > GEOT-2109 and especially GEOT-2095. > GEOT-2109 is an easy problem and if it is ok I would fix it. Feel free if you would like. I agree its trivial. > Since the development of my imagemosaic-jdbc plu

[Geotools-devel] db2 plugin ( jdbc-ng ) would be ready to commit

2008-10-28 Thread Christian Müller
the new db2 plugin would be ready to commit. The only showstoppers are GEOT-2109 and especially GEOT-2095. GEOT-2109 is an easy problem and if it is ok I would fix it. Since the development of my imagemosaic-jdbc plugin I have installed all our target databases (db2,oracle,postgis,mysql) and