Adding point to ESRI Personal Geodatabasethrough ODBC

[Delfos, Jacob]

I didn't think it would be easy. I have tried in vain to obtain esri
documentation on it.....  I was hoping it would be a 'simple' binary
value for point data.
I'll stick with ODBC for now, which fulfills my requirements.

Thanks,

Jacob

> -----Original Message-----
> From: Frank Warmerdam [mailto:warmerdam at pobox.com] 
> Sent: 26 September 2006 21:58
> To: Delfos, Jacob
> Cc: MAPSERVER-USERS at LISTS.UMN.EDU
> Subject: Re: [UMN_MAPSERVER-USERS] Adding point to ESRI 
> Personal Geodatabasethrough ODBC
> 
> 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
> 
>