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

[TC Haddad]

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 getSymbol(): Symbol definition error.
> Parsing error near (geo_lot):(line 266)****
>
> [Wed Feb 22 15:42:12 2012].140000 msQueryByRect(): Search returned no
> results. No matching record(s) found.****
>
> [Wed Feb 22 15:42:12 2012].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/42bcc449/attachment.html