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

[TC Haddad]

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/20120222/9e7b860c/attachment.html