[mapserver-users] MapServer and ArcSDE
Hello List,
I'm making this post so that others may avoid the pain that I just went
through. We finaly have a working install of MapServer 6.2.1 compiled with
GDAL 1.9 on 64 Bit Linux Red Hat 6 Enterprise displaying and querying data from
ArcSDE 10.0. At first the data displayed fine with a patch to the mapsde.c
file from Steve Lime, thanks Steve. The problem we struggled with for weeks
was querying SDE. After a lot of internet searching and sleepless nights I
came across the blurb of code below that was the game changer. We added this
to the mods that Steve made to the mapsde.c file and presto. Anyway if anyone
want to know more you can contact me through the list or at my email below.
Steve, I owe you a beer.
void msSDELayerFreeItemInfo(layerObj *layer)
{
#ifdef USE_SDE
msSDELayerInfo *sde = NULL;
int i;
if (!msSDELayerIsOpen(layer)) {
msSetError( MS_SDEERR,
SDE layer has not been opened.,
msSDELayerFreeItemInfo());
}
sde = layer-layerinfo;
if (sde != NULL sde-basedefs) {
SE_table_free_descriptions(sde-basedefs);
sde-basedefs = NULL;
}
if (sde != NULL sde-joindefs) {
SE_table_free_descriptions(sde-joindefs);
sde-joindefs = NULL;
}
if (layer-iteminfo) {
:
Thanks,
Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisb...@wapa.govmailto:weisb...@wapa.gov
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer and ArcSDE
I'd say the other way around (beer that is)... ;-) Can you open a ticket so
this change doesn't get lost? It needs to be pushed into the upcoming 6.4
release.
Steve
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Weisbender, Eric
Sent: Thursday, July 11, 2013 2:50 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] MapServer and ArcSDE
Hello List,
I'm making this post so that others may avoid the pain that I just went
through. We finaly have a working install of MapServer 6.2.1 compiled with
GDAL 1.9 on 64 Bit Linux Red Hat 6 Enterprise displaying and querying data from
ArcSDE 10.0. At first the data displayed fine with a patch to the mapsde.c
file from Steve Lime, thanks Steve. The problem we struggled with for weeks
was querying SDE. After a lot of internet searching and sleepless nights I
came across the blurb of code below that was the game changer. We added this
to the mods that Steve made to the mapsde.c file and presto. Anyway if anyone
want to know more you can contact me through the list or at my email below.
Steve, I owe you a beer.
void msSDELayerFreeItemInfo(layerObj *layer)
{
#ifdef USE_SDE
msSDELayerInfo *sde = NULL;
int i;
if (!msSDELayerIsOpen(layer)) {
msSetError( MS_SDEERR,
SDE layer has not been opened.,
msSDELayerFreeItemInfo());
}
sde = layer-layerinfo;
if (sde != NULL sde-basedefs) {
SE_table_free_descriptions(sde-basedefs);
sde-basedefs = NULL;
}
if (sde != NULL sde-joindefs) {
SE_table_free_descriptions(sde-joindefs);
sde-joindefs = NULL;
}
if (layer-iteminfo) {
:
Thanks,
Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisb...@wapa.govmailto:weisb...@wapa.gov
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer and ArcSDE
Hi All, I have an ArcSDE 10 database in SQL server. Can you let me know the best approach to viewing this data in MapServer - for example, should I compile SDE support into MapServer or alternatively use the OGR approach to viewing it? Any hints would be much appreciated - I don't have a lot of experience with ArcSDE but have a lot with MapServer. Regards Simon ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
