Using the MS4W tools:
C:\> ogrinfo mlra_v42.shx -sql "select LRR_NAME,MLRARSYM FROM mlra_v42 where MLRARSYM in ('105','112') Returns data for both regions. C:\> ogrinfo -summary mlra_v42.shp mlra_v42 INFO: Open of `mlra_v42.shp' using driver `ESRI Shapefile' successful. Layer name: mlra_v42 Geometry: Polygon Feature Count: 2748 Extent: (-179.130478, -14.381652) - (179.788041, 71.397535) Layer SRS WKT: GEOGCS["GCS_North_American_1983", DATUM["North_American_Datum_1983", SPHEROID["GRS_1980",6378137.0,298.257222101]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]] MLRARSYM: String (4.0) MLRA_ID: Integer (3.0) MLRA_NAME: String (200.0) LRRSYM: String (2.0) LRR_NAME: String (135.0) -----Original Message----- From: W.John Guineau [mailto:guin...@earthlink.net] Sent: Monday, December 07, 2009 9:08 PM To: 'W.John Guineau'; 'Steve Lime'; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Shapefile, itemnquery and HTML image map generation problem If I reduce the query string to just one that does work: http://localhost/cgi-bin/mapserv?map=/NWPL_CRREL/MLRA/mlra.map&qlayer=coe_m& mode=itemnquery&searchmap=true&layer=states&mapext=-91+34+-89+49&mapsize=600 +400&qitem=MLRARSYM&qstring=(%22[MLRARSYM]%22%20in%20%22105%22) I get a map with jus the one MLRA (#105) in yellow. If I select on that does not work (#112): http://localhost/cgi-bin/mapserv?map=/NWPL_CRREL/MLRA/mlra.map&qlayer=coe_m& mode=itemnquery&searchmap=true&layer=states&mapext=-91+34+-89+49&mapsize=600 +400&qitem=MLRARSYM&qstring=(%22[MLRARSYM]%22%20in%20%22112%22) I get this error in the browser: msQueryByAttributes(): Search returned no results. No matching record(s) found. msSearchDiskTree(): Search returned no results. Unable to open spatial index for c:\shape\MLRA_42_low_res/mlra_v42.qix. In most cases you can safely ignore this message, otherwise check file names and permissions But 112 is clearly rendering in the CLASS of the LAYER. john -----Original Message----- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of W.John Guineau Sent: Monday, December 07, 2009 8:50 PM To: 'Steve Lime'; mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Shapefile, itemnquery and HTML image map generation problem I think the missing ones are from random places n the query string. I have tried putting just one of the missing MLRA in the query string and it still does not generate <area> How do I label? (I am really new to MapServer!) john -----Original Message----- From: Steve Lime [mailto:steve.l...@state.mn.us] Sent: Monday, December 07, 2009 7:57 PM To: W.John Guineau; mapserver-users@lists.osgeo.org; 'Steve Lime' Subject: RE: [mapserver-users] Shapefile,itemnquery and HTML image map generation problem Do the ones not selected fall at the end of your qstring? I'm wondering if something is getting truncated. I'd think you'd get a parsing error in that case, but perhaps not. Can you label the polygons with the value for MLRARSYM? Steve >>> On 12/7/2009 at 6:19 PM, in message <01dc01ca779c$2c19eae0$844dc0...@net>, W.John Guineau <guin...@earthlink.net> wrote: > Hi Steve, > > > > OK, I added the QUERYMAP section and changed the URL: > > > > http://localhost/cgi-bin/mapserv?map=/NWPL_CRREL/MLRA/mlra.map > <http://localhost/cgi-bin/mapserv?map=/NWPL_CRREL/MLRA/mlra.map&qlayer=coe_m > &mode=itemnquerymap&searchmap=true&layer=states&mapext=-91+34+-89+49&mapsize > =600+400&qitem=MLRARSYM&qstring=(%22%5bMLRARSYM%5d%22%20in%20%22102A,102B,10 > 2C,103,104,105,106,107A,107B,108A,108B,108C,108D,109,110,111A,111B,111C,111D > ,111E,112,113,114A,114B,115A,115B,115C%22)> > &qlayer=coe_m&mode=itemnquerymap&searchmap=true&layer=states&mapext=-91+34+- > 89+49&mapsize=600+400&qitem=MLRARSYM&qstring=("[MLRARSYM]"%20in%20"102A,102B > ,102C,103,104,105,106,107A,107B,108A,108B,108C,108D,109,110,111A,111B,111C,1 > 11D,111E,112,113,114A,114B,115A,115B,115C") > > > > > > Now I get the map with some of the items highlighted in yellow, and the rest > green: > > > > > > > > -----Original Message----- > From: Steve Lime [mailto:steve.l...@state.mn.us] > Sent: Monday, December 07, 2009 7:04 PM > To: W.John Guineau; mapserver-users@lists.osgeo.org; 'Steve Lime' > Subject: RE: [mapserver-users] Shapefile,itemnquery and HTML image map > generation problem > > > > Just add a querymap object to your mapfile, like so: > > > > QUERYMAP > > STATUS ON > > END > > > > Then change your URL to use the mode itemnquerymap and that should return > just an image with the > > selected features highlighted in yellow. > > > > Steve > > > >>>> On 12/7/2009 at 5:56 PM, in message > <01ce01ca7798$dd4b89d0$97e29d...@net>, > > W.John Guineau <guin...@earthlink.net> wrote: > >> I'm new to mapserver, how do I quickly generate a querymap? > >> > >> I'm using mapserver 5.4.2 from the latest MS4W on Windows 7 x64. I've also > >> tried 5.2.1 that I compiled myself. > >> > >> john > >> > >> > >> -----Original Message----- > >> From: Steve Lime [mailto:steve.l...@state.mn.us] > >> Sent: Monday, December 07, 2009 6:40 PM > >> To: 'W.John Guineau'; mapserver-users@lists.osgeo.org > >> Subject: RE: [mapserver-users] Shapefile,itemnquery and HTML image map > >> generation problem > >> > >> GDAL's not in play here at all. If you generate a query map instead of an > >> html image map does > >> the output map look ok? What version are you using? > >> > >> Steve > >> > >>>>> On 12/4/2009 at 8:11 AM, in message > >> <04e001ca74eb$bc473400$34d59c...@net>, > >> W.John Guineau <guin...@earthlink.net> wrote: > >>> How would I go about debugging this? > >>> > >>> > >>> > >>> I think this is GDAL and its query of shapefiles, right? > >>> > >>> > >>> > >>> The bottom line is that MapServer finds all the items when it is > rendering > >>> the map by layer/class EXPRESSION, but the qstring in a URL using the > >> exact > >>> same EXPRESSION string misses some of the items. > >>> > >>> > >>> > >>> I can also use ogrinfo from MAP4W to execute an SQL query directly on the > >>> shapefile and the items in questions are certainly there. > >>> > >>> > >>> > >>> In the image below, the green areas are result of the mapfile layer class > >>> EXPRESSION - all are correctly rendered. However, several of them do not > >> get > >>> generated (HTML imagemap <area> tags not generated) when using a URL and > >>> itemnquery/qstring with the identical EXPRESSION. > >>> > >>> > >>> > >>> How do I enable debug (enabling mapfile DEBUG does not seem to give any > >>> useful info as to why GDAL is skipping certain items) Am I better off > >> using > >>> MAP4W or similar to get debug/trace info for shapefile queries? > >>> > >>> > >>> > >>> john > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> > >>> From: mapserver-users-boun...@lists.osgeo.org > >>> [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of W.John > >> Guineau > >>> Sent: Thursday, December 03, 2009 3:11 PM > >>> To: mapserver-users@lists.osgeo.org > >>> Subject: [mapserver-users] Shapefile, itemnquery and HTML image map > >>> generation problem > >>> > >>> > >>> > >>> I have a basic vector shapefile that I am trying to generate HTML > >> clickable > >>> maps from. It seems to work well for the most part, however there is a > >>> problem where some items from the shapefile do not get processed from the > >>> qstring in the browser, but they are processed fine in the mapfile layer > >> (to > >>> color them differently). > >>> > >>> > >>> > >>> So the map that renders shows all the items colored properly as the layer > >>> class defines. Using the exact same list of items in the HTTP query > string > >>> causes several items to be ignored (the HTML image map area is not > >>> generated). > >>> > >>> > >>> > >>> > >> > http://localhost/cgi-bin/mapserv?map=/NWPL_CRREL/MLRA/mlra.map&qlayer=coe_m& > > >> > >>> > >> > mode=itemnquery&searchmap=true&layer=states&mapext=-91+34+-89+49&mapsize=600 > >>> > >> > +400&qitem=MLRARSYM&qstring=("[MLRARSYM]"%20in%20"102A,102B,102C,103,104,105 > >>> > >> > ,106,107A,107B,108A,108B,108C,108D,109,110,111A,111B,111C,111D,111E,112,113, > >>> 114A,114B,115A,115B,115C") > >>> > >>> > >>> > >>> Below is the layer section from the mapfile. I can post whatever else is > >>> helpful. > >>> > >>> > >>> > >>> Thanks for any help on this. > >>> > >>> > >>> > >>> john > >>> > >>> > >>> > >>> LAYER > >>> > >>> NAME map_m > >>> > >>> DATA "map_shape" > >>> > >>> TEMPLATE "bodytemplate.html" > >>> > >>> HEADER "imapheader.html" > >>> > >>> FOOTER "imapfooter.html" > >>> > >>> PROJECTION > >>> > >>> "proj=latlong" > >>> > >>> "ellps=GRS80" > >>> > >>> "init=epsg:4326" > >>> > >>> END > >>> > >>> TYPE polygon > >>> > >>> STATUS ON > >>> > >>> TRANSPARENCY 70 > >>> > >>> CLASS > >>> > >>> NAME "MLRA" > >>> > >>> COLOR 0 200 0 > >>> > >>> OUTLINECOLOR 0 0 0 > >>> > >>> EXPRESSION( "[MLRARSYM]" in > >>> > >> > "102A,102B,102C,103,104,105,106,107A,107B,108A,108B,108C,108D,109,110,111A,1 > >>> 11B,111C,111D,111E,112,113,114A,114B,115A,115B,115C" ) > >>> > >>> END > >>> > >>> METADATA > >>> > >>> qstring_validation_pattern ".*" > >>> > >>> END > >>> > >>> END > >> > >> _______________________________________________ > >> mapserver-users mailing list > >> mapserver-users@lists.osgeo.org > >> http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users