[R-sig-Geo] Geometry in tables - well-known binary?

Michael Sumner mdsumner at utas.edu.au
Thu Aug 12 13:43:20 CEST 2004


Hello, does anyone know about "storing geometry in tables" using binary 
record types?  Manifold GIS 6.00 http://www.manifold.net supports the 
storage of drawing object (points, lines and areas) coordinates in tables - 
using a binary "Geometry" type.  Geometry can be stored in databases (or 
other tables supporting the binary Geom format such as .mdb).

These binary records can be accesed by SQL queries within Manifold

I.e. SELECT Geom(ID) AS [Geom], [Drawing].* FROM [Drawing];  results in
a table like:
<geom, area, branches: 1, coords: 10>	6	Area	1	10	-156.579937304075

These drawing objects can be reconstructed simply by importing or linking 
to the table.
This makes Manifold a very powerful tool for manipulating vector data on 
the fly.

Apparently there are "Geometry (SHP)" and "Geometry (WKB)" (well-known binary)
for ESRI geodatabases and OpenGIS respectively.  Does anyone know how to read
such binary records using generic tools, like R?

I can already read table data from Manifold projects using RODBC, extending 
this with
binary "Geometry in tables" could be very powerful.

Cheers, Mike.




###############################################

Michael Sumner - PhD. candidate
Maths and Physics (ACE CRC & IASOS) and Zoology (AWRU)
University of Tasmania
Private Bag 77, Hobart, Tas 7001, Australia
Phone: 6226 1752

R tips
http://www.ku.edu/~pauljohn/R/Rtips.html

Matlab has two problems: 1) it's expensive, and 2) it costs a lot:

http://www.dspguru.com/sw/opendsp/mathclo2.htm




More information about the R-sig-Geo mailing list