[Mapserver-users] Virtual Spatial Data Wiki Question

[Van Ulden, Joost]

Nikolai, you can also put the code right in the mapfile like this:

LAYER
  NAME OGRPoints
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION 
  
  '<OGRVRTDataSource>
       <OGRVRTLayer name="story">
 
<SrcDataSource>ODBC:user_name/password at system_dsn,table_name</SrcDataSource>

         <SrcLayer>Desc_story</SrcLayer> 
        <GeometryType>wkbPoint</GeometryType> 
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="story_x" y="story_y"/>

      </OGRVRTLayer>
  </OGRVRTDataSource>'

  DUMP TRUE # for WFS only
  DATA "story"
  STATUS default
  CLASS
    SYMBOL 'circle'
    SIZE 25
    COLOR 255 0 0
  END
END

Regards,

============================================
Joost van Ulden
Programmer/Analyst
Natural Resources Canada / Ressources naturelles Canada
Geological Survey of Canada / Commission geologique du Canada
101 - 605 Robson Street / 101 - 605 rue Robson
Vancouver, B.C. / Vancouver (C.-B.)
V6B 5J3
Office/Bureau:  604.666.7525
fax/telecopieur: 604.666.1124
jvanulde at nrcan.gc.ca
============================================


> -----Original Message-----
> From: Nikolai Schwertner [mailto:nikolai.schwertner at tufts.edu] 
> Sent: Friday, March 05, 2004 8:04 AM
> To: spencer at dmsolutions.ca; warmerdam at pobox.com
> Cc: mapserver-users at lists.gis.umn.edu
> Subject: Re: [Mapserver-users] Virtual Spatial Data Wiki Question
> 
> 
> Thank you, Paul and Frank!
> 
> I updated MapServer to 4.1. The virtual layer works like a charm!
> 
> Cheers,
> Nikolai
> 
> ----- Original Message ----- 
> From: "Paul Spencer" <pagameba at magma.ca>
> To: "Nikolai Schwertner" <nikolai.schwertner at tufts.edu>
> Cc: <mapserver-users at lists.gis.umn.edu>
> Sent: Thursday, March 04, 2004 6:47 PM
> Subject: Re: [Mapserver-users] Virtual Spatial Data Wiki Question
> 
> 
> > if it works with ogrinfo and not with mapserver/mapscript then you 
> > need a more recent version of mapserver binaries.  It is not 
> > sufficient to replace gdalxx.dll, you must have a mapserver 
> that was 
> > compiled against the newer gdal source code.  You can find 
> the latest 
> > 4.1 compiled for windows as of today here:
> >
> > http://www.maptools.org/dl/mapserver-4.1-dev-win32-php4.3.4.zip
> >
> > Cheers,
> >
> > Paul
> >
> > Nikolai Schwertner wrote:
> >
> > > Hi all,
> > >
> > > I am following the instructions from the wiki on "Virtual Spatial 
> > > Data"
> to
> > > create a virtual layer from an ODBC data source (under Windows 
> > > 2000).
> The
> > > OVF file works great with ogrinfo.exe, but fails with the 
> following
> message
> > > when I try to load it in MapServer:
> > >
> > >   msDrawMap(): Image handling error. Failed to draw layer 
> named 'sb_pt'.
> > >   msOGRFileOpen(): OGR error. Open failed for OGR connection 
> > > `w:\app\virtual.ovf'. File not found or unsupported format.
> > >
> > > Past posts suggest that this problem may be related to the 
> > > permissions
> of
> > > the Apache user over the OVF file. I don't think that this is the
> problem in
> > > this case. All permissions are in order and Apache has no problem
> accessing
> > > the file.
> > >
> > > I will appreciate any suggestions regarding this problem.
> > >
> > > Sincerely,
> > > Nikolai
> > >
> > > --
> > > Nikolai Schwertner
> > > TCCS/Academic Technology
> > > Tufts University
> > > Medford, MA 02155
> > >
> > > Phone: 617.627.2821
> > > Fax: 617.627.3667
> > > Email: nikolai.schwertner at tufts.edu
> > >
> > > _______________________________________________
> > > 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
> >
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu 
> http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users
>