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