[mapserver-users] OGR shapefile w/MySQL Join
Steve Lime
Steve.Lime at dnr.state.mn.us
Thu Sep 3 07:40:41 PDT 2009
Thanks, didn't search on the right terms. Lot's of "in theory"'s... Will give it a try. Fortunately
I only have 60 records so sucky performance may be tolerable.
Steve
>>> On 9/3/2009 at 8:34 AM, in message <4A9FC5D4.9050802 at mapgears.com>, Daniel
Morissette <dmorissette at mapgears.com> wrote:
> Steve Lime wrote:
>> This isn't an instance where a JOIN block is particularly useful. I need the
>> MySQL attributes for map making and JOINs are only used with query
>> results. Plus the MySQL join driver assumes integer keys and I have strings.
>> Hence my hope to do the join in OGR before the data even hit MapServer.
>>
>
> Here is a post by Frank from a couple of years ago that explains how to
> join shapefile and ODBC data with an OGR SQL statement in the layer's
> DATA parameter:
>
> http://lists.osgeo.org/pipermail/mapserver-users/2004-November/002149.html
>
> It should be easy to adapt this example to connect to MySQL instead of
> ODBC for the join, but I didn't test it myself. (The MySQL driver docs
> are at http://gdal.org/ogr/drv_mysql.html)
>
> Daniel
More information about the MapServer-users
mailing list