[Geomoose-users] RE: query service with PostGis layer

[Bistrais, Bob]

I think that might be the problem.  Having trouble deciphering this one.
I added a getExtent and printed it to screen.  Here's what it's showing
for my extent, not what I was expecting to see:

 

ms_rect_obj Object ( [_handle_] => Resource id #40 [minx] =>
-3.40282346639E+38 [miny] => -3.40282346639E+38 [maxx] =>
3.40282346639E+38 [maxy] => 3.40282346639E+38 )

 

 

...First of all, not cords that I'm used to seeing, second, they are all
the same value, maybe indicating a point location, but I attempted to
select a polygon.

 

We should be in EPSG: 26919.  Looking on the database side, that appears
to be correct, and in the map file for that layer, we are also using
SRID=26919.

 

Does this make sense?

 

________________________________

From: TC Haddad [mailto:tchaddad at gmail.com] 
Sent: Wednesday, February 22, 2012 3:51 PM
To: Bistrais, Bob
Cc: Geomoose-users at lists.osgeo.org
Subject: Re: [Geomoose-users] RE: query service with PostGis layer

 

The second error is probably the reason

is it possible that when you imported the shapefile into PostGIS that
PostGIS was unaware of the projection? because if it is a different
projection than your overall map, then the BBOX being passed is likely
not picking up any records (because PostGIS doesn't know what space it
is in).

Tanya

On Wed, Feb 22, 2012 at 12:43 PM, Bistrais, Bob <Bob.Bistrais at maine.gov>
wrote:

A few more details on this- here's what I found on the error log:

 

[Wed Feb 22 15:42:11 2012].984000 <tel:11%202012%5D.984000>
getSymbol(): Symbol definition error. Parsing error near (geo_lot):(line
266)

[Wed Feb 22 15:42:12 2012].140000 <tel:2012%5D.140000>  msQueryByRect():
Search returned no results. No matching record(s) found.

[Wed Feb 22 15:42:12 2012].500000 <tel:2012%5D.500000>  msDrawMap():
Layer 0 (parcelspostgis), 0.344s

 

-But I don't know why it isn't returning any results, when a
corresponding shapefile of the same data will.

 

________________________________

From: Bistrais, Bob 
Sent: Tuesday, February 21, 2012 4:25 PM
To: Geomoose-users at lists.osgeo.org
Subject: query service with PostGis layer

 

Now that I've gotten some PostGIS layers to display in GeoMoose, the
next thing I'm trying to do is work with attribute queries.  I am
attempting this through query services and using query_custom.php.

 

So far, I am getting 0 results, when the same query would have worked
with a shapefile.  I'm thinking it's a format issue, maybe some quotes
or something out of place?  Here is an echo of my query string:

geo_lot = '11190_010-011'

 

Does this look right?  What else could I check for?


_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/geomoose-users

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20120223/c35cb74c/attachment-0001.html