Adding point to ESRI Personal Geodatabasethrough ODBC
Trimble, Beheen
btrimble at SFWMD.GOV
Thu Sep 28 05:13:02 PDT 2006
Okay. Let me today to do it.
B
-----Original Message-----
From: Delfos, Jacob [mailto:Jacob.Delfos at maunsell.com]
Sent: Wednesday, September 27, 2006 7:28 PM
To: Trimble, Beheen; MAPSERVER-USERS at LISTS.UMN.EDU
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: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
> >
> >
>
>
>
More information about the MapServer-users
mailing list