[Geomoose-users] query.php configuration confusion

[Len Kne]

Hi Johan

Issue 2 - check conf/settings.ini to see what the projection is set to.  Server-based services use this value for the projection, while client-based services use the mapbook.

For issue 1, I think you are going to need "fieldnameX" for each layer you are querying.  As your service is now configured, I would expect it to only query Layer0 using fieldname0 and value0.  I do not believe you will be able to query across multiple layers with one value without some custom coding of query.php.

Len

-----Original Message-----
From: Johan Forsman [mailto:Johan.Forsman at LA.GOV] 
Sent: Wednesday, June 16, 2010 2:08 PM
To: geomoose-users at lists.sourceforge.net
Subject: [Geomoose-users] query.php configuration confusion

All:

Two issues to seek advice on this afternoon.

Platform is GM2.2, using webmaps as base with EPSG:900913 in the mapbook and settings.ini files. Source data is in EPSG:26915, being projected on-the-fly by MapServer to EPSG:900913. All layers I have render very nicely in all the right spots.

Issue 1:
I would like to use the new query.php function to search several tables in my PostGIS from one dialog. I have looked at the examples in the documentation but it appears I am not fully comprehending the syntax.

I have 5 layers I wish to search, each has its own table in PostGIS.
6 of the layers/tables have 2 identical fieldnames I wish to be able to search on, "pwsid" and "sysname".
The remaining table has two fields I wish to be able to search on, "regowner" and "newid" (ignore layer4 for now).

I used the "query.php" block from the demo mapbook and added/replaced my own layers.
When I test the query layer0 and layer1 are turned on in the map, but results are only returned for layer0.

I have a <input type...layer? for each layer.
I have a <input type...template? for each layer entry, but they all use value="itemquery" since each layer definition in the referenced mapfiles have unique templates defined there.

I am suspecting the problem lies somewhere with the "fieldname0" and "value0" parameters? In fieldname0 I have included all 4 of the fields, from 5 different tables, I wish to be able to specify the search from.

At the bottom of this message I have placed the query.php block as it looks currently. Please ignore the square footage bit; it's remaining from the demo, and I don't have an immediate need for the boolean functions.

I have been unable to stitch together a series of input types that covers the bases. Does someone on the list have a query block to share that does this that I may model mine after?


Issue 2:
All the layers plot where they should, but the highlights from the query results plot in Algeria. To emphasise, ONLY the highlights plot in the wrong place.  Clearly a projection error, but where? This also happens with the old itemquery.php since I switched from using EPSG:26915 in my mapbook to EPSG:900913.

Thanks for taking the time!
And I do apologize for the rudimentary XML skills that are apparently absent in my mapbook.

/Johan.

----------------------
	<service name="search_facilities">
		<url>php/query.php</url>
		<step type="input">
			<input type="hidden" name="highlight" value="true"/>
			<input type="hidden" name="mode" value="search"/>

			<input type="hidden" name="layer0" value="wells/sdwis_wells"/>
			<input type="hidden" name="layer1" value="surfacewater/intakes"/>
			<input type="hidden" name="layer2" value="surfacewater/treatmentplants"/>
			<input type="hidden" name="layer3" value="storage/all"/>
			<input type="hidden" name="layer4" value="wells/swap_wells"/>
			<input type="hidden" name="layer5" value="wells/ldotd_all"/>

			<input type="hidden" name="template0" value="itemquery"/>
			<input type="hidden" name="template1" value="itemquery"/>
			<input type="hidden" name="template2" value="itemquery"/>
			<input type="hidden" name="template3" value="itemquery"/>	
			<input type="hidden" name="template4" value="itemquery"/>	
			<input type="hidden" name="template5" value="itemquery"/>	
			
			<input type="select" name="fieldname0" title="Search By:">
				<option value="sysname">System Name</option>
				<option value="pwsid">PWSID</option>
				<option value="regowner">Registered owner</option>
				<option value="newid">Well id number</option>
			</input>
			<input type="select" name="comparitor0" title="That: ">
				<option value="like-icase">Contains</option>
				<option value="right-like-icase">Begins With</option>
				<option value="eq-str">Matches Exactly</option>
			</input>
			<input type="user" name="value0" title=""/>

			<input type="hidden" name="fieldname1" value="FIN_SQ_FT"/>
			<input type="select" name="operator1">
				<option value="or">OR</option>
				<option value="and">AND</option>
			</input>
			<input type="select" name="comparitor1" title="Having Fin. Sq. Ft. ">
				<option value="gt">Greater Than</option>
				<option value="eq">Equal To</option>
				<option value="lt">Less Than</option>
			</input>
			<input type="user" name="value1" title=""/>
		</step>
	</service>


------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-users