Adding point to ESRI Personal Geodatabase through ODBC

[Frank Warmerdam]

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, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGeo, http://osgeo.org