[Geomoose-users] highlighting missing from select feature tool - MS4W

[Jeff McKenna]

Hi Mark,

I figured out your problem file: you need to pass the name of the 
geometry column, in your DATA statement, for MapServer/OGR, and your 
file will work fine, such as:

MAP
   EXTENT -93.198 44.579 -93.161 44.602
   SIZE 400 300

   LAYER
     TYPE LINE
     STATUS ON
     NAME 'selected'
     CONNECTIONTYPE OGR
     CONNECTION '/ms4w/tmp/ms_tmp/select_132761447356573.db'
     DATA 'select wkt_geometry from features'	
     CLASS
       STYLE
	OUTLINECOLOR 255 255 0
	COLOR 0 0 0
       END
     END
   END
END #map

Have a nice weekend,

-jeff



-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/




On 2015-12-04 3:24 PM, Jeff McKenna wrote:
> Hi Mark,
>
> Sorry for my delay.
>
> Regarding your report of problems with MS4W 3.1.0 with
> spatialite/sqlite/db data, I have done thorough testing, and I can tell
> you that there is no issue.  I have tested with
> sqlite/spatialite/postgis layers, using your sample mapfile, no issues.
>
> However with your test DB there is issues (messages of "Rejecting
> feature...of incompatible type for this layer"), which was reported on
> the MapServer mailing list
> (http://osgeo-org.1560.x6.nabble.com/Trouble-with-spatialite-layer-td4899754.html#a4900764)
>
>
> Using the sample spatialite data provided in that thread (OSM Finland,
> download it at
> http://hip.latuviitta.org/tiedostot/OSM_Suomi_20120213.zip), I have no
> problem drawing this layer with MS4W 3.1.0 (using the shp2img
> commandline utility):
>
>
> MAP
>    EXTENT 61686.171875 6605839.000000 733170.500000 7776580.000000
>    SIZE 400 300
>
>    LAYER
>      TYPE LINE
>      STATUS ON
>      NAME 'selected'
>      CONNECTIONTYPE OGR
>      CONNECTION '/ms4w/tmp/ms_tmp/OSM_Suomi_20120213.sqlite'
>      DATA 'osm_polygon'
>      CLASS
>        STYLE
>      OUTLINECOLOR 255 255 0
>      COLOR 0 0 0
>        END
>      END
>    END
> END #map
>
> I also was successful with the spatialite sample data
> (https://www.gaia-gis.it/spatialite-2.3.1/resources.html), and also
> sample data from GDAL (http://download.osgeo.org/gdal/data/sqlite3/).
>
> Therefore, as mentioned in that thread, there could be something wrong
> with the geometry in your sample data.
>
> I hope that helps.
>
> -jeff
>
>
>