[Mapserver-users] Re: VirtualSpatialData (OGR Connectiontype)
Normand Savard
nsavard at dmsolutions.ca
Thu Jan 22 13:41:24 EST 2004
Julien,
Forget about preceeding email. I made a mistake on the error message.
Norm
Normand Savard wrote:
> Julien,
>
> Try
> LABELITEM MGWI_TBLLOC #may need to use table.name or just name
> depending on your OVF file.
>
> in the map file, in the virtual layer section.
>
>
> Example of a map file:
>
> ...
> LAYER
> NAME "MyVirtualLayer"
> TYPE POINT
> CONNECTIONTYPE OGR
> CONNECTION "virtual.ovf" # the name and path to the virtual.ovf
> file, relative to shapepath may work?
> DATA "capitalNames" # the name of the OGRVrtLayer
> STATUS ON
> LABELITEM capitalName #may need to use table.name or just name
> depending on your OVF file.
> PROJECTION
> "init=epsg:4326"
> END
> CLASS
> SYMBOL star
> SIZE 10
> COLOR 255 0 0
> LABEL
> SIZE MEDIUM
> TYPE BITMAP
> COLOR 0 0 0
> END
> END
> END # Layer
>
> ...
>
> Example of an "ovf" file
>
> <OGRVRTDataSource>
>
> <OGRVRTLayer name="capitalNames">
> <SrcDataSource>ODBC:NormMyDSN,capital</SrcDataSource>
> <SrcLayer>capital</SrcLayer>
> <GeometryType>wkbPoint</GeometryType>
> <LayerSRS>WGS84</LayerSRS>
> <GeometryField encoding="PointFromColumns" x="XCoord" y="YCoord"/>
> </OGRVRTLayer>
>
> </OGRVRTDataSource>
>
>
>
> Norm
>
> Julien, Heryk wrote:
>
>> Hi to all,
>>
>> I replaced my version of Mapserver with a precompiled one. I also
>> installed
>> the latest version of gdal11.dll and ogrinfo from the OpenEV_FW zip.
>>
>> As suggested by Frank Warmerdam I used the following SrcDataSource
>> tag in
>> the virtual file:
>> <SrcDataSource>ODBC:MGWI_MAPSERVER</SrcDataSource>. MGWI_MAPSERVER is
>> the
>> DSN for my ODBC data source.
>>
>> Here is the orginfo output:
>>
>> D:\WebScripts\MapServer>ogrinfo --formats
>> Loaded OGR Format Drivers:
>> -> "ESRI Shapefile" (read/write)
>> -> "UK .NTF" (readonly)
>> -> "SDTS" (readonly)
>> -> "TIGER" (read/write)
>> -> "S57" (read/write)
>> -> "MapInfo File" (read/write)
>> -> "DGN" (read/write)
>> -> "VRT" (readonly)
>> -> "AVCBin" (readonly)
>> -> "REC" (readonly)
>> -> "Memory" (read/write)
>> -> "GML" (read/write)
>> -> "ODBC" (read/write)
>> -> "OGDI" (readonly)
>> -> "FMEObjects Gateway" (readonly)
>>
>> D:\WebScripts\MapServer>ogrinfo
>> D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf
>> ERROR 4: Update access not supported for VRT datasources.
>> Had to open data source read-only.
>> INFO: Open of
>> `D:\webCGCq\lcnp\mapserver_demo\maritimes\data\shp\geo83\mgwi.ovf'
>> using driver `VRT' successful.
>> 1: MGWI_TBLLOC (Point)
>>
>> When I execute Mapserver I got the following message:
>> 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.
>>
>>
>> Thanks for the help
>>
>> Héryk
>>
>>
>>
>> -----Message d'origine-----
>> De : Normand Savard [mailto:nsavard at dmsolutions.ca]
>> Envoyé : Wednesday, January 21, 2004 5:26 PM
>> À : Julien, Heryk
>> Cc : 'spencer at dmsolutions.ca'; 'Mapserver-users at lists.gis.umn.edu';
>> Anctil, Martin
>> Objet : Re: [Mapserver-users] Re: VirtualSpatialData (OGR
>> Connectiontype)
>>
>>
>> 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
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>
>>
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>
>>
>>
>
>
>
More information about the mapserver-users
mailing list