Delfos, Jacob wrote:
Hi All,
I was wondering if anyone has knows how to add a point feature to an
ESRI personal geodatabase, without using ESRI software (ideally through
SQL). The spatial column is "long binary data" according to MS Access.
I'm assuming I'd also have to update the spatial index. I'm using PHP,
which I believe supports binary data through ODBC.
I'm assuming it's possible, but I'm not sure yet how. Alternatively,
I'll have to use ODBC/OVF. Not a drama, but I'd like to keep it all in
one format.
Jacob,
The format of the geometry is based on the shapefile format, and there
is code to decode it in OGR (for the geodatabase driver). I think it
would be hard to construct these geometries properly using SQL, but then
my SQL-fu is weak.
I've never actually worked out how the spatial index works, so updating that
might be quite challenging.
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
