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:[EMAIL PROTECTED] On Behalf Of Delfos, Jacob Sent: Tuesday, September 26, 2006 8:15 PM To: [email protected] 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:[EMAIL PROTECTED] > Sent: 26 September 2006 21:58 > To: Delfos, Jacob > Cc: [email protected] > 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, > [EMAIL PROTECTED] > light and sound - activate the windows | http://pobox.com/~warmerdam > and watch the world go round - Rush | President OSGeo, > http://osgeo.org > >
