Okay. Let me today to do it. B
-----Original Message----- From: Delfos, Jacob [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 27, 2006 7:28 PM To: Trimble, Beheen; [email protected] Subject: RE: [UMN_MAPSERVER-USERS] Adding point to ESRI Personal Geodatabasethrough ODBC Hi Beheen, If it's not a lot of trouble to you, I wouldn't mind to have a look at the code. I do not know whether it's the same between Oracle (SDE?) and MDB, but it might be. It would make my implementation a bit cleaner if I had that ability. Regards, Jacob > -----Original Message----- > From: Trimble, Beheen [mailto:[EMAIL PROTECTED] > Sent: 27 September 2006 19:34 > To: Delfos, Jacob; [email protected] > Subject: RE: [UMN_MAPSERVER-USERS] Adding point to ESRI > Personal Geodatabasethrough ODBC > > 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 > > > > > > >
