[Mapserver-west] Found the answer

[Tyler Mitchell]

Good sleuthing Dean.
For those who aren't familiar with the VRT format, it can be used to grab 
non-spatial (tabular) lists of coordinates and create point features.  Dean's 
example is a good one, using an (any!) ODBC data source that has an x and y 
column.  I've used this with a CSV data source before and found it worked 
great.  I think that it can be used with any OGR support data format as well.

Tyler

On April 20, 2005 10:56 pm, Dean C. Mikkelsen wrote:
> Hi all!
>
> I think I solved my question. I am working possibly with a non-spatial
> database - originally Oracle 8. The hope is to migrate to PostGIS or
> MySQL. I have experience with MySQL.
>
> It appears as though I have to use the Virtual File Format found with
> the OGR. The link is here:
>
> http://www.remotesensing.org/gdal/ogr/drv_vrt.html
>
> In my case, I would have code such as:
> <OGRVRTDataSource>
>
>     <OGRVRTLayer name="lease_polygons">
>
> <SrcDataSource>ODBC:gulf_of_mexico,lease_polygons</SrcDataSource>
>  	<SrcLayer>lease_polygons</SrcLayer>
> 	<GeometryType> wkbPolygon</GeometryType>
>         <LayerSRS>WGS84</LayerSRS>
> 	<GeometryField encoding="PointFromColumns" x="x" y="y"/>
>     </OGRVRTLayer>
>
> </OGRVRTDataSource>
>
> The answer was right in front of me, just a little digging, eh?
>
> Cheers,
> Dean
>
>
>
>
> _______________________________________________
> Mapserver-west mailing list
> Mapserver-west at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/mapserver-west