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