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

[Bistrais, Bob]

No.  Here's some of the major coordinate/projection items in my map file
for this layer:

 

  EXTENT        134000 4700000 890900 5300000     --(yes, that's correct
for the state of Maine although a bit generous)

 

  PROJECTION

    "init=epsg:26919"   

  END

 

DATA "the_geom from parcels USING SRID=26919 USING Unique gid USING
unique geo_lot USING unique map_bk_lot"

 

Geo_lot is the item I'm trying to select on.

 

Those extent coordinates that I listed in the previous message really
don't look right to me.

 

________________________________

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

 

is there another projection in play at the top of the map file?

On Thu, Feb 23, 2012 at 7:08 AM, Bistrais, Bob <Bob.Bistrais at maine.gov>
wrote:

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/534b329d/attachment-0001.html