ovf layer (mysql) won't show

[Tero Alén]

Hi,

I have problems to showing ovf layer on MapServer 4.8.1. Layer contains
linestring-geometry from MySQL 5.0.18.

MapServer doesn't print any errors but layer won't show. Could somebody tell
me what's wrong?

Here is what is in ovf-file:

<OGRVRTDataSource>

    <OGRVRTLayer name="article_poly">
        <SrcDataSource>ODBC:opus at myodbc</SrcDataSource>
        <SrcSQL>select id, astext(article_poly.linest) as geometry from
article_poly</SrcSQL>
        <GeometryField encoding="WKT" field="geometry"/>
     </OGRVRTLayer>

</OGRVRTDataSource>

And what I get from ogrinfo:

ERROR 4: Update access not supported for VRT datasources.
Had to open data source read-only.
INFO: Open of `/var/www/workshop/ovf/espoo.ovf'
using driver `VRT' successful.

Layer name: article_poly
Geometry: Unknown (any)
Feature Count: 9
ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
Extent: (34349.795000, 7989.500000) - (40567.791000, 79948.282000)
Layer SRS WKT:
(unknown)
id: Integer (2.0)
geometry: String (111.0)
ERROR 1: SetAttributeFilter() not supported on ExecuteSQL() results.
OGRFeature(article_poly):0
  id (Integer) = 1
  geometry (String) = LINESTRING(36389.217 75489.802,36580.774 75200)
  LINESTRING (36389.217 75489.802,36580.774 75200.000)

OGRFeature(article_poly):1
  id (Integer) = 2
  geometry (String) = LINESTRING(34501.916 76285.895,34349.795 76149.853)
  LINESTRING (34501.916 76285.895,34349.795 76149.853)

OGRFeature(article_poly):2
  id (Integer) = 10
  geometry (String) = LINESTRING(40567.791 79786.741,40566.862 79786.955,
40558.5 79809,40561 7989.5,40567.791 79822.157)
  LINESTRING (40567.791 79786.741,40566.862 79786.955,40558.500 79809.000,
40561.000 7989.500,40567.791 79822.157)

OGRFeature(article_poly):3
  id (Integer) = 4
  geometry (String) = LINESTRING(40567.791 79812.987,40566.526 79813.667,
40567.791 79815.626)
  LINESTRING (40567.791 79812.987,40566.526 79813.667,40567.791 79815.626)

OGRFeature(article_poly):4
  id (Integer) = 5
  geometry (String) = LINESTRING(40241.658 79840.44,40247.668 79840.383,
40247.559 79828.962,40241.551 79829.08,40241.658 79840.44)
  LINESTRING (40241.658 79840.440,40247.668 79840.383,40247.559 79828.962,
40241.551 79829.080,40241.658 79840.440)

OGRFeature(article_poly):5
  id (Integer) = 6
  geometry (String) = LINESTRING(40567.791 79808.936,40567.054 79805.977,
40566.933 79802.648,40567.495 79798.888,40567.791 79798.958)
  LINESTRING (40567.791 79808.936,40567.054 79805.977,40566.933 79802.648,
40567.495 79798.888,40567.791 79798.958)

OGRFeature(article_poly):6
  id (Integer) = 7
  geometry (String) = LINESTRING(40273.209 79941.596,40271.197 79945.203,
40276.716 79948.282,40280.146 79942.135,40281.583 79939.558)
  LINESTRING (40273.209 79941.596,40271.197 79945.203,40276.716 79948.282,
40280.146 79942.135,40281.583 79939.558)

OGRFeature(article_poly):7
  id (Integer) = 8
  geometry (String) = LINESTRING(40227.602 79816.024,40226.05 79815.86,
40222.053 79815.437,40222.736 79808.973,40228.096 79809.54)
  LINESTRING (40227.602 79816.024,40226.050 79815.860,40222.053 79815.437,
40222.736 79808.973,40228.096 79809.540)

OGRFeature(article_poly):8
  id (Integer) = 9
  geometry (String) = LINESTRING(40267.509 79884.152,40265.504 79887.333,
40267.102 79888.341,40269.108 79885.161,40267.687 79884.264)
  LINESTRING (40267.509 79884.152,40265.504 79887.333,40267.102 79888.341,
40269.108 79885.161,40267.687 79884.264)

And layer definition from map-file:

       LAYER
                CONNECTION "ovf/espoo.ovf"
                CONNECTIONTYPE OGR
                NAME article_poly
                TYPE LINE
                STATUS DEFAULT
                CLASS
                 DEBUG ON
                  STYLE
                   COLOR 255 0 0
                  END
                END

        END

--
Best Regards, Tero
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060208/eb495e39/attachment.htm>