Opened 10 years ago
Closed 10 years ago
#2984 closed defect (invalid)
ST_GeomFromKML returns same response for 2 different coordinates
| Reported by: | andybo | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.1.5 |
| Component: | postgis | Version: | 2.1.x |
| Keywords: | Cc: |
Description
Below i have two sql statements which are returning geometry object. Returned response is same even though polygon are in different counties (same input coordinates). What is missing? Can this bug be fixed?
select ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>-121.7471466285088,38.39715448674667 -121.7490035211575,38.39749533104161 -121.7490419482125,38.39477128651279 -121.7489427323548,38.39462143372049 -121.7429440046871,38.39461448170549 -121.7399852619939,38.39459399305304 -121.7399641223717,38.39663113277838 -121.7399649351661,38.39708696667033 -121.7471466285088,38.39715448674667</coordinates></LinearRing></outerBoundaryIs></Polygon>') ;
st_geomfromkml
0103000020E61000000100000009000000C4B01740D16F5EC0B0044EF5D532434076FD76ACEF6F5EC076918320E1324340E8B9A34DF06F5EC0747C92DD873243409C827FADEE6F5EC0A81084F482324340FCB802658C6F5EC0FEB932BA823243404AF224EB5B6F5EC031AE530E8
232434030737A925B6F5EC0E6ED17CFC4324340692EE3955B6F5EC02AC2E7BED3324340C4B01740D16F5EC0B0044EF5D5324340 (1 row)
gsi_kml=# select ST_GeomFromKML('<Polygon><outerBoundaryIs><LinearRing><coordinates>-121.7471466187921,38.39715448624511 -121.7490035228899,38.39749533066244 -121.7490419501001,38.39477127712342 -121.7489427340871,38.39462143334127 -121.7429440064195,38.39461448132635 -121.7399852637263,38.39459399267393 -121.7399641241041,38.39663113239932 -121.7399649368986,38.39708696629123 -121.7471466187921,38.39715448624511</coordinates></LinearRing></outerBoundaryIs></Polygon>') ;
st_geomfromkml
0103000020E61000000100000009000000DC410D40D16F5EC0F3F04CF5D5324340A8D978ACEF6F5EC002C18220E1324340C5C0A54DF06F5EC097527EDD87324340C75E81ADEE6F5EC02E4083F4823243402F9504658C6F5EC08FE931BA823243407DCE26EB5B6F5EC0C6DD520E8
2324340634F7C925B6F5EC0821D17CFC4324340A30AE5955B6F5EC0C1F1E6BED3324340DC410D40D16F5EC0F3F04CF5D5324340 (1 row)
gsi_kml=# SELECT PostGIS_full_version();
postgis_full_version
POSTGIS="2.1.4dev r12951" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.9.1" TOPOLOGY RASTER
(1 row)
mistake in my understanding.