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

Wed Jan 21 14:25:48 PST 2004

Julien,

Just because I do not know all the steps you have done, can you tell me 
if you were able to have some output form "ogrinfo" command?

Norm

Julien, Heryk wrote:

>Hi Paul,
>What do I write in the virtual file SrcDataSource tag when I log on a Access
>db with no user restrictions and pass word?
>I've tried the following combinations without success:
>
><SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource>
><SrcDataSource>ODBC:@MGWI_MAPSERVER</SrcDataSource>
><SrcDataSource>ODBC:/@MGWI_MAPSERVER</SrcDataSource>
><SrcDataSource>ODBC:administor/@MGWI_MAPSERVER</SrcDataSource> 
><SrcDataSource>ODBC:administeur/@MGWI_MAPSERVER</SrcDataSource>
>
>Thanks
>Héryk
>
>
>-----Message d'origine-----
>De : Paul Spencer [mailto:pagameba at magma.ca]
>Envoyé : Wednesday, January 21, 2004 1:43 PM
>À : Julien, Heryk
>Cc : 'spencer at dmsolutions.ca'; 'Mapserver-users at lists.gis.umn.edu';
>Anctil, Martin
>Objet : [Mapserver-users] Re: VirtualSpatialData (OGR Connectiontype)
>
>
>I believe there is a limitation in the OGR OBDC connection that requires 
>that you provide a user name and password in the OVF file (I think that 
>is mentioned in the wiki also).
>
>Cheers,
>
>Paul
>
>Julien, Heryk wrote:
>  
>
>>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 ton 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 (mgw.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
>>>>
>>>>        
>>>>
>>>      
>>>
>
>  
>