Adding point to ESRI Personal Geodatabasethrough ODBC

[Trimble, Beheen]

Jacob,

I have done a polygon feature using sql in oracle spatial. However,
after that you have to make it a shapefile and the rest! The point is
simpler than the polygon but I am not sure if that is what you really
want. If you think you want it I go through my program and cut the piece
out for you.

Beheen



-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Delfos, Jacob
Sent: Tuesday, September 26, 2006 8:15 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Adding point to ESRI Personal
Geodatabasethrough ODBC

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
> 
>