[Geomoose-users] Identify and itemquery (Search)

[Dan Little]

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