[Mapserver-users] RE: VirtualSpatialData (OGR Connectiontype)

[Julien, Heryk]

Corrections made on the original message:
_________________________________________________


Hi,
I'm trying out the Virtual Spatial Data procedure in MapServerWiki
(http://mapserver.gis.umn.edu/cgi-bin/wiki.pl?VirtualSpatialData) with IIS
and an Access 2000 ODBC connection.

I keep on getting the following error message when I attempt to see my map:

msDrawMap(): Image handling error. Failed to draw layer named 'MGWI_TBLLOC'.

msOGRFileOpen(): OGR error. Open failed for OGR connection `mgwi.ovf'. File
not found or unsupported format.

Anyone can help me?



Here is my virtual file (mgwi.ovf):

<OGRVRTDataSource>
    <OGRVRTLayer name="MGWI_TBLLOC">
        <SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource> 
 	<SrcLayer>tblloc</SrcLayer> 
	<GeometryType>wkbPoint</GeometryType>
	<!-- LayerSRS>WGS84</LayerSRS !-->         
	<GeometryField encoding="PointFromColumns" x="x" y="y"/> 
    </OGRVRTLayer>
</OGRVRTDataSource>




My virtual layer is in the same directory as my shapefiles:

SHAPEPATH "d:\webcgcq\lcnp\mapserver_demo\maritimes\data\shp\geo83"




Here is the section of my mapfile where I call my virtual layer:

LAYER
	NAME "MGWI_TBLLOC"
	TYPE POINT
	CONNECTIONTYPE OGR
	CONNECTION "mgwi.ovf"
	DATA "MGWI_TBLLOC"
	STATUS DEFAULT
	LABELITEM "LOCID"
	PROJECTION
		"init=epsg:26920"
	END #projection
	CLASS
		SYMBOL 'circle'
		SIZE 8
		LABEL
			COLOR 132 31 31
			SHADOWCOLOR 218 218 218
			SHADOWSIZE 2 2
			TYPE TRUETYPE
			FONT arial-bold
			FORCE true
			SIZE 10
			POSITION auto
			PARTIALS FALSE
			MINDISTANCE 0
			BUFFER 2
		END # end of label
	    TEMPLATE
"d:\webcgcq\lcnp\mapserver_demo\maritimes\templates\field_capt_query.html"
	END # CLASS
END # LAYER






==========================================
Héryk
NRCan

-----Message d'origine-----
De : Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
Envoyé : Wednesday, January 14, 2004 8:44 AM
À : 'spencer at dmsolutions.ca'
Cc : 'Mapserver-users at lists.gis.umn.edu'
Objet : RE: TR: [Mapserver-users] MySQL and Mapserver


Thanks

Héryk

-----Message d'origine-----
De : Paul Spencer [mailto:pagameba at magma.ca]
Envoyé : Tuesday, January 13, 2004 5:00 PM
À : Julien, Heryk
Cc : 'Paul Spencer '; 'Mapserver-users at lists.gis.umn.edu'
Objet : Re: TR: [Mapserver-users] MySQL and Mapserver


Maybe you missed it?

http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0401/msg00111.html

Cheers,

Paul

Julien, Heryk wrote:

> Hi Paul,
> Could you send me or post information on the "new format in 
> OGR to set up a virtual layer that can draw columns from any ODBC data 
> source and map two of the columns to x and y locations"?
> 
> Thanks
> Héryk
> 
> -----Message d'origine-----
> De : Julien, Heryk [mailto:hjulien at nrcan.gc.ca]
> Envoyé : Monday, January 05, 2004 9:23 AM
> À : 'spencer at dmsolutions.ca'
> Cc : 'Mapserver-users at lists.gis.umn.edu'
> Objet : RE: [Mapserver-users] MySQL and Mapserver
> 
> 
> Hi,
> I am also very interseted in that fonction. I would like to be able to map
> well positions from a database x and y colums. Would this permit me to
have
> an up to date point geometry layer which reflects the changes in my well
> database? Can you send me more details?
> 
> Thanks
> 
> Héryk
> NRCan
> 
> -----Message d'origine-----
> De : Paul Spencer [mailto:pagameba at magma.ca]
> Envoyé : Saturday, January 03, 2004 4:28 PM
> À : bartvde at xs4all.nl
> Cc : mapserver-users at lists.gis.umn.edu
> Objet : Re: [Mapserver-users] MySQL and Mapserver
> 
> 
> Bart,
> 
> if you are interested in point geometries only, there is a new format in 
> OGR to set up a virtual layer that can draw columns from any ODBC data 
> source and map two of the columns to x and y locations.  We've used it 
> for a couple of clients and it works very nicely.  If you are interested 
> I can send you more details.
> 
> Cheers,
> 
> Paul
> 
> Bart van den Eijnden wrote:
> 
> 
>>Hi list,
>>
>>I see in the history log that there has been some work done recently 
>>(early December) by Attila on supporting MySQL 4.X for the MyGIS 
>>connector. Can it be used already?
>>
>>Also, is it possible to keep the geometries in shapefiles and use 
>>Mapserver JOINS to link to tables in MySQL?
>>
>>Thanks in advance for the info.
>>
>>Best regards,
>>Bart
>>_______________________________________________
>>Mapserver-users mailing list
>>Mapserver-users at lists.gis.umn.edu
>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
> 
> 

-- 
  -----------------------------------------------------------------
|Paul Spencer                           spencer at dmsolutions.ca    |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users