OGR and ArcSDE
Sture Dingsøyr
candalt at ONLINE.NO
Wed Feb 22 14:06:45 PST 2006
Hi
I have been doing some testing displaying points from a database with X/Y columns from an SQL database (ACCESS/SQL SERVER) using OGR in Mapserver.
This is an excellent function, and it works great. It enables you to display POINT data from other databases than PostgreSQL with PostGIS in Mapserver.
This is an example of my mapfile:
LAYER
CLASSITEM "servicename"
CONNECTION "<OGRVRTDataSource>
<OGRVRTLayer name='test'><SrcDataSource>ODBC:@test</SrcDataSource>
<SrcSQL>SELECT * FROM reiseliv</SrcSQL>
<GeometryField encoding='PointFromColumns' x='x_utm33' y='y_utm33'/>
<GeometryType>wkbPoint</GeometryType>
</OGRVRTLayer>
</OGRVRTDataSource>"
CONNECTIONTYPE ogr
DATA "test"
STATUS on
TYPE point
NAME "1"
CLASS
COLOR 0 0 0
NAME "Test access"
OUTLINECOLOR 255 255 255
SIZE 5
SYMBOL "square"
EXPRESSION "Camping"
END
END
On the OGR homepage I can see that OGR also enables support for ArcSDE data (http://gdal.maptools.org/ogr/ogr_formats.html).
My question is this:
I use Mapserver 4.8.1 on Windows downloaded from DM Solutions. Does this Mapserver compilation support displaying data from ArcSDE via OGR?
In case this is true, does anybody have an example of syntax, like the one I use for displaying ODBC data, but for ArcSDE (to use in the mapfile)?
Does it also support displaying POINT/LINE/POLYGON?
Regards Sture
More information about the MapServer-users
mailing list