[Geomoose-users] Identify and itemquery (Search)

Michael Reynolds Mike.Reynolds at dot.state.mn.us
Mon Oct 26 10:56:41 EDT 2009


Update:  hadn't tried this before...I left the Search By: text box empty and hit "Go!"  The itemquery.php returned everyone of the features.

So now I'm down to trying to figure out why it can't find specific values.

Mind numbing debugging details follow:

The feature attribute name is CABINET_ID (all caps), the values I can't find include but not limited to A05W, A05Y, A12X, etc (all caps too, no padded spaces).

$queryString eventually = /.*A05W.*/i as an example around line 91 of itemquery.php

$queryLayer->set('filteritem', $queryItem);  where $queryItem = 'CABINET_ID'

$queryLayer->queryByRect($queryLayer->getExtent()); where $queryLayer->getExtent() = ms_rect_obj Object ( [_handle_] => Resource id #41 [minx] => 189783.56 [miny] => 4816309.33 [maxx] => 761653.524114 [maxy] => 5472346.5 )

then ...

$queryLayer->open();
$numResults = $queryLayer->getNumResults();

and $numResults = 0 

Should be at least 1.  Returns 762 if I don't search a specific value; the total number of features in the layer.

I've tried with the METAFILE entry 'itemquery-filteritem' 'CABINET_ID' in and commented out leaving it to the service to pass the filteritem.  Neither made a difference; it seems either way its passing the correct thing.

Is my mapfile DATA line not compatible with adding a filter operation?

DATA 'SHAPE FROM username.LIT_CABINETS USING UNIQUE OBJECTID'
or (i've tried simple and advanced)
DATA 'SHAPE FROM (SELECT OBJECTID, CABINET_ID, SYSTEM_ID, LAYOUT_URL,  ROADWAY_NAME, DATE_LOGGED, DATE_INSTALLED, DATE_TURNON, DATE_RETIRED, LOCATION,  QUAD, METER_VENDOR, METER_ACCOUNT, METER_ADDRESS, METER_NBR, PREMISE_NBR,  OWNER_CODE, CABINET_TYPE, CABINET_VOLTS, GEOMSRC_CODE, SHAPE, GLOBALID FROM 
 username.LIT_CABINETS) USING UNIQUE OBJECTID' 


>>> "Michael Reynolds" <Mike.Reynolds at dot.state.mn.us> 10/26/2009 8:57 AM >>>
Your suggestion fixed the !$queryLayer->getExtent() issue.  

Still, the search (itemquery) returns no results while an identify works fine.

I'm going to brush up on and compare identify.php and itemquery.php to see what's diff.

>>> Dan Little <danlittle at yahoo.com> 10/25/2009 8:41 PM >>>
If you manually set the EXTENT in the LAYER it should fix the problem.


----- Original Message ----
> From: Michael Reynolds <Mike.Reynolds at dot.state.mn.us>
> To: geomoose-users at lists.sourceforge.net 
> Sent: Sun, October 25, 2009 12:18:47 PM
> Subject: [Geomoose-users] Identify and itemquery (Search)
> 
> I have a feature class in oracle that displays fine in geomoose.  The identify 
> tool also works with this layer.  The problem is, I cannot get the Search 
> service to work.
> 
> I feel I'm close if the data displays and I can identify a feature.  But why 
> would the itemquery.php not work?  I receive no errors but the info tab says "no 
> results found for your query".
> 
> When I watched what was going on in the itemquery.php I found that 
> $queryLayer->getExtent() against this particular layer is returning no extent or 
> zero values.  This seems to indicate bad communication between itemquery.php, 
> mapserver, and oraclespatial. 
> 
> Anyone familiar with mapserver oraclespatial connections that can give me a tip 
> on my DATA line in my mapfile or any other tips? 
> 
> My map-source in the mapbook.xml looks like this:
> 
>     
>         ./mte/lighting/lit_cabinets.map
>         
>     
> 
> 
> My service in the mapbook.xml looks like this:
> 
>     
>         php/itemquery.php
>         
>             
>                 Cabinet ID
>                 System ID
>             
>             
>             
> value="lit_cabinets/lit_cabinets"/>
>             
>             
>         
>     
> 
> My layer in the mapbook.xml looks like this:
> 
>                     
> 
> The mapfile looks like this:
> 
> MAP
>     NAME 'lit_cabinets'
>     SIZE 800 650
>     STATUS ON
>     EXTENT 189783.560000 4816309.330000 761653.524114 5472346.500000
>     UNITS METERS
>     FONTSET "../../fonts/fontset.list"
>     INCLUDE "../../geomoose_globals.map"
> 
>     WEB
>         INCLUDE "../../temp_directory.map"
>     END
>     
>     LEGEND
>        STATUS ON
>        LABEL
>             TYPE TRUETYPE
>             FONT vera_sans
>             SIZE 8
>             COLOR 0 0 0
>        END        
>     END    
> 
>     LAYER
>         NAME 'lit_cabinets'
>        CONNECTIONTYPE oraclespatial
>        CONNECTION "username/password at tgd"
>        #DATA 'SHAPE FROM username.LIT_CABINETS USING UNIQUE OBJECTID'
>        DATA 'SHAPE FROM (SELECT OBJECTID, CABINET_ID, SYSTEM_ID, LAYOUT_URL, 
> ROADWAY_NAME, DATE_LOGGED, DATE_INSTALLED, DATE_TURNON, DATE_RETIRED, LOCATION, 
> QUAD, METER_VENDOR, METER_ACCOUNT, METER_ADDRESS, METER_NBR, PREMISE_NBR, 
> OWNER_CODE, CABINET_TYPE, CABINET_VOLTS, GEOMSRC_CODE, SHAPE, GLOBALID FROM 
> username.LIT_CABINETS) USING UNIQUE OBJECTID' 
>         PROCESSING "CLOSE_CONNECTION=DEFER"      
>         STATUS DEFAULT
>         TYPE POINT
>         LABELITEM 'CABINET_ID'
>         LABELMAXSCALEDENOM 15000
>         CLASS
>             NAME 'Cabinets'
>             STYLE
>                 SYMBOL 'square'
>                 COLOR 0 150 150
>                 SIZE 8
>             END
>             LABEL
>               COLOR 0 50 50
>               BACKGROUNDCOLOR 200 200 200
>               TYPE TRUETYPE
>               FONT verdana
>               SIZE 8
>               ANTIALIAS TRUE
>               POSITION UC
>               BUFFER 4
>               OFFSET 5 5
>             END 
>         END
>         METADATA
>            'identify_record'    'identify_lit_cabinet.html'
>        #   'select_record'    'select_lit_cabinet.html'
>         #    'select_header' 'select_header_lit_cabinet.html'
>         #    'popups' 'lit_pole_popup.html'
>             'itemquery'    'lit_cabinet_itemquery.html'
> #            'itemquery-filteritem' 'CABINET_ID'
>             'itemquery-filter'    '/.*[qstring].*/i' 
>         #    'qstring_validation_pattern' '.'
>             
>         # Feature reports are stored in the conf/feature_report directory.
>         #    'feature_report' 'lit_pole.xml'
>         END
>       TOLERANCE .05               
>     END 
> END ## end Map
> 
> 
> 
> 
> ------------------------------------------------------------------------------
> Come build with us! The BlackBerry(R) Developer Conference in SF, CA
> is the only developer event you need to attend this year. Jumpstart your
> developing skills, take BlackBerry mobile applications to market and stay 
> ahead of the curve. Join us from November 9 - 12, 2009. Register now!
> http://p.sf.net/sfu/devconference 
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.sourceforge.net 
> https://lists.sourceforge.net/lists/listinfo/geomoose-users 



      

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference 
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/geomoose-users 



------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay 
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference 
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.sourceforge.net 
https://lists.sourceforge.net/lists/listinfo/geomoose-users 






More information about the Geomoose-users mailing list