Adding point to ESRI Personal Geodatabasethrough ODBC

[Delfos, Jacob]

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:btrimble at sfwmd.gov] 
> Sent: 27 September 2006 19:34
> To: Delfos, Jacob; MAPSERVER-USERS at LISTS.UMN.EDU
> 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: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
> > 
> > 
> 
> 
>