|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
|
|
[PostGIS] #262: Possible bug in Geography ST_Covers#262: Possible bug in Geography ST_Covers
---------------------+------------------------------------------------------ Reporter: robe | Owner: pramsey Type: defect | Status: new Priority: medium | Milestone: postgis 1.5.0 Component: postgis | Version: Keywords: | ---------------------+------------------------------------------------------ I would expect the answer to my UTM to agree with Geography answer. Also the platte-care answer is woo really screwed. That I think is a bug in the casting or somethng I don't understand about the casting which I'll put in as a separate ticket. {{{ SELECT ST_AsText(pt.the_geog) As wkt_pt, ST_Covers(poly.the_geog, pt.the_geog) As geog, ST_Covers( ST_Transform(CAST(poly.the_geog As geometry),32611), ST_Transform(CAST(pt.the_geog As geometry),32611)) As utm, ST_Covers( CAST(poly.the_geog As geometry), CAST(pt.the_geog As geometry) ) As pca FROM (SELECT ST_GeographyFromText('SRID=4326;POLYGON((-119.5434 34.9438,-119.5437 34.9445,-119.5452 34.9442,-119.5434 34.9438))') As the_geog) As poly CROSS JOIN (VALUES ( ST_GeographyFromText('SRID=4326;POINT(-119.5434 34.9438)') ) , ( ST_GeographyFromText('SRID=4326;POINT(-119.5452 34.9442)') ) , ( ST_GeographyFromText('SRID=4326;POINT(-119.5434 34.9438)') ), ( ST_GeographyFromText('SRID=4326;POINT(-119.5438 34.9443)') ) ) As pt(the_geog); }}} I'm expecting all these to yield an answer of true. Instead I get {{{ wkt_pt | geog | utm | pca --------------------------+------+-----+----- POINT(-119.5434 34.9438) | t | t | f POINT(-119.5452 34.9442) | f | t | f POINT(-119.5434 34.9438) | t | t | f POINT(-119.5438 34.9443) | t | t | f }}} The pca answer is particularly troubling which I think is a separate issue. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/262> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel |
|
|
Re: [PostGIS] #262: Possible bug in Geography ST_Covers#262: Possible bug in Geography ST_Covers
----------------------+----------------------------------------------------- Reporter: robe | Owner: pramsey Type: defect | Status: new Priority: medium | Milestone: postgis 1.5.0 Component: postgis | Version: Resolution: | Keywords: ----------------------+----------------------------------------------------- Comment (by pramsey): I get the right (?) answer {{{ wkt_pt | geog | utm | pca --------------------------+------+-----+----- POINT(-119.5434 34.9438) | t | t | t POINT(-119.5452 34.9442) | t | t | t POINT(-119.5434 34.9438) | t | t | t POINT(-119.5438 34.9443) | t | t | t (4 rows) }}} as of r4640. Could be the precision issues that manifest in your cunit failures. Those remain on my list (though a ticket wouldn't hurt). -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/262#comment:1> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel |
|
|
Re: [PostGIS] #262: Possible bug in Geography ST_Covers#262: Possible bug in Geography ST_Covers
----------------------+----------------------------------------------------- Reporter: robe | Owner: pramsey Type: defect | Status: new Priority: medium | Milestone: postgis 1.5.0 Component: postgis | Version: Resolution: | Keywords: ----------------------+----------------------------------------------------- Comment (by robe): That is the answer I would expect. Mine is still wrong even after r4640. I thought it was maybe a bbox issue again but && returns true on all accounts. ST_Distance also returns 0 on all accounts. Anyrate I'll put in another ticket for Cunit issue once I've cataloged the various ways its failing on different boxes. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/262#comment:2> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel |
|
|
Re: [PostGIS] #262: Possible bug in Geography ST_Covers#262: Possible bug in Geography ST_Covers
----------------------+----------------------------------------------------- Reporter: robe | Owner: pramsey Type: defect | Status: new Priority: medium | Milestone: postgis 1.5.0 Component: postgis | Version: Resolution: | Keywords: ----------------------+----------------------------------------------------- Comment (by pramsey): I'm still getting the right answer. Has anything changed on your end? -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/262#comment:3> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel |
|
|
Re: [PostGIS] #262: Possible bug in Geography ST_Covers#262: Possible bug in Geography ST_Covers
----------------------+----------------------------------------------------- Reporter: robe | Owner: pramsey Type: defect | Status: closed Priority: medium | Milestone: postgis 1.5.0 Component: postgis | Version: Resolution: fixed | Keywords: ----------------------+----------------------------------------------------- Changes (by robe): * status: new => closed * resolution: => fixed Comment: Yap works now. -- Ticket URL: <http://trac.osgeo.org/postgis/ticket/262#comment:4> PostGIS <http://trac.osgeo.org/postgis/> PostGIS _______________________________________________ postgis-devel mailing list postgis-devel@... http://postgis.refractions.net/mailman/listinfo/postgis-devel |
| Free embeddable forum powered by Nabble | Forum Help |