[postgis-tickets] r17624 - Add regression tests for using -s from_srid:to_srid with -D (copy mode) for both geometry and geography
Regina Obe
lr at pcorp.us
Sun Jul 28 06:11:07 PDT 2019
Author: robe
Date: 2019-07-28 18:11:07 -0700 (Sun, 28 Jul 2019)
New Revision: 17624
Added:
trunk/regress/loader/ReprojectPtsD-post.sql
trunk/regress/loader/ReprojectPtsD-pre.sql
trunk/regress/loader/ReprojectPtsD.dbf
trunk/regress/loader/ReprojectPtsD.opts
trunk/regress/loader/ReprojectPtsD.select.expected
trunk/regress/loader/ReprojectPtsD.select.sql
trunk/regress/loader/ReprojectPtsD.shp
trunk/regress/loader/ReprojectPtsD.shx
trunk/regress/loader/ReprojectPtsGeogD-post.sql
trunk/regress/loader/ReprojectPtsGeogD-pre.sql
trunk/regress/loader/ReprojectPtsGeogD-w.select.expected
trunk/regress/loader/ReprojectPtsGeogD.dbf
trunk/regress/loader/ReprojectPtsGeogD.opts
trunk/regress/loader/ReprojectPtsGeogD.select.expected
trunk/regress/loader/ReprojectPtsGeogD.select.sql
trunk/regress/loader/ReprojectPtsGeogD.shp
trunk/regress/loader/ReprojectPtsGeogD.shx
Modified:
trunk/regress/core/Makefile.in
Log:
Add regression tests for using -s from_srid:to_srid with -D (copy mode) for both geometry and geography
Closes #4403
Modified: trunk/regress/core/Makefile.in
===================================================================
--- trunk/regress/core/Makefile.in 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/core/Makefile.in 2019-07-29 01:11:07 UTC (rev 17624)
@@ -61,7 +61,9 @@
../loader/NotReallyMultiPoint \
../loader/MultiToSinglePoint \
../loader/ReprojectPts \
+ ../loader/ReprojectPtsD \
../loader/ReprojectPtsGeog \
+ ../loader/ReprojectPtsGeogD \
../loader/Latin1 \
../loader/Latin1-implicit \
../loader/mfile \
Added: trunk/regress/loader/ReprojectPtsD-post.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsD-post.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsD-post.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,2 @@
+-- Cleanup
+DELETE FROM spatial_ref_sys;
Added: trunk/regress/loader/ReprojectPtsD-pre.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsD-pre.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsD-pre.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,11 @@
+--- In case this test is running in an extension context
+TRUNCATE spatial_ref_sys;
+---
+--- EPSG 4326 : WGS 84
+---
+INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (4326,'EPSG',4326,'GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]','+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs ');
+---
+--- EPSG 2260 : NAD83 / New York East (ftUS)
+---
+INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (2260,'EPSG',2260,'PROJCS["NAD83 / New York East (ftUS)",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4269"]],UNIT["US survey foot",0.3048006096012192,AUTHORITY["EPSG","9003"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",38.83333333333334],PARAMETER["central_meridian",-74.5],PARAMETER["scale_factor",0.9999],PARAMETER["false_easting",492125],PARAMETER["false_northing",0],AUTHORITY["EPSG","2260"],AXIS["X",EAST],AXIS["Y",NORTH]]','+proj=tmerc +lat_0=38.83333333333334 +lon_0=-74.5 +k=0.9999 +x_0=150000 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=us-ft +no_defs ');
+
Added: trunk/regress/loader/ReprojectPtsD.dbf
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsD.dbf
===================================================================
--- trunk/regress/loader/ReprojectPtsD.dbf 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsD.dbf 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsD.dbf
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/loader/ReprojectPtsD.opts
===================================================================
--- trunk/regress/loader/ReprojectPtsD.opts (rev 0)
+++ trunk/regress/loader/ReprojectPtsD.opts 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,3 @@
+# This happens to be a multipoint shapefile that has only single points, so use -S.
+# It is in NJ State Plane NAD83, so reproject to 4326 using copy mode
+-D -S -s 2260:4326
Added: trunk/regress/loader/ReprojectPtsD.select.expected
===================================================================
--- trunk/regress/loader/ReprojectPtsD.select.expected (rev 0)
+++ trunk/regress/loader/ReprojectPtsD.select.expected 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,66 @@
+SRID=4326;POINT(-74.17782492 41.08263361)
+SRID=4326;POINT(-74.44881286 40.50133744)
+SRID=4326;POINT(-74.00376358 40.28149688)
+SRID=4326;POINT(-75.12863742 39.7797389)
+SRID=4326;POINT(-74.57629014 40.85597595)
+SRID=4326;POINT(-74.47160401 40.52369066)
+SRID=4326;POINT(-75.46891683 39.69688334)
+SRID=4326;POINT(-75.11458618 39.70739231)
+SRID=4326;POINT(-74.22643701 40.09726563)
+SRID=4326;POINT(-74.26766926 40.83522615)
+SRID=4326;POINT(-74.42152037 40.76232181)
+SRID=4326;POINT(-74.18666598 40.89980341)
+SRID=4326;POINT(-74.20201874 40.94448827)
+SRID=4326;POINT(-74.31866663 40.6680465)
+SRID=4326;POINT(-74.83205963 40.84912898)
+SRID=4326;POINT(-74.64402101 39.96633708)
+SRID=4326;POINT(-74.22194028 40.09559148)
+SRID=4326;POINT(-74.60375255 40.75504208)
+SRID=4326;POINT(-74.09376018 40.86569336)
+SRID=4326;POINT(-74.4430374 40.77797967)
+SRID=4326;POINT(-74.76841703 40.22038455)
+SRID=4326;POINT(-74.19078182 40.73914574)
+SRID=4326;POINT(-74.19628444 40.79591416)
+SRID=4326;POINT(-74.19130306 40.74330253)
+SRID=4326;POINT(-74.17636308 40.73783123)
+SRID=4326;POINT(-74.53148731 39.49029456)
+SRID=4326;POINT(-74.16618054 40.73634864)
+SRID=4326;POINT(-74.35732607 40.80076793)
+SRID=4326;POINT(-74.17573811 40.73901418)
+SRID=4326;POINT(-74.66491581 40.34572735)
+SRID=4326;POINT(-74.36625323 40.51061374)
+SRID=4326;POINT(-74.17631876 40.74329159)
+SRID=4326;POINT(-74.4544664 40.52427239)
+SRID=4326;POINT(-74.02836656 40.89756584)
+SRID=4326;POINT(-75.00833975 39.82895026)
+SRID=4326;POINT(-74.13132221 40.33161528)
+SRID=4326;POINT(-74.67999522 39.46203859)
+SRID=4326;POINT(-74.08904806 40.9515804)
+SRID=4326;POINT(-75.12091068 39.94826917)
+SRID=4326;POINT(-74.08628025 40.70929009)
+SRID=4326;POINT(-74.73270242 40.27825159)
+SRID=4326;POINT(-74.16625303 40.01000431)
+SRID=4326;POINT(-75.01837982 40.74472398)
+SRID=4326;POINT(-74.65920653 40.34951097)
+SRID=4326;POINT(-74.24751143 40.74434122)
+SRID=4326;POINT(-74.65122484 40.25151634)
+SRID=4326;POINT(-74.43880205 40.4659008)
+SRID=4326;POINT(-74.2355417 40.68231466)
+SRID=4326;POINT(-74.49892935 40.80763833)
+SRID=4326;POINT(-74.0625762 40.73086062)
+SRID=4326;POINT(-75.03600164 39.78659251)
+SRID=4326;POINT(-75.05591643 39.44084942)
+SRID=4326;POINT(-74.39804333 40.50086907)
+SRID=4326;POINT(-74.07131567 40.72720191)
+SRID=4326;POINT(-74.19117919 40.74196293)
+SRID=4326;POINT(-74.02494262 40.74676479)
+SRID=4326;POINT(-74.68894668 40.6094749)
+SRID=4326;POINT(-74.44600226 40.49825884)
+SRID=4326;POINT(-74.19898991 40.85779571)
+SRID=4326;POINT(-74.7828046 40.27094999)
+SRID=4326;POINT(-74.25017536 40.217432)
+SRID=4326;POINT(-74.16960551 40.91844326)
+SRID=4326;POINT(-74.75788852 41.06754763)
+SRID=4326;POINT(-74.03363729 40.72689071)
+SRID=4326;POINT(-74.5760699 40.53743164)
+SRID=4326;POINT(-74.43925667 40.77359187)
Added: trunk/regress/loader/ReprojectPtsD.select.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsD.select.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsD.select.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,2 @@
+select ST_Asewkt(ST_SnapToGrid(the_geom,0.00000001)) from loadedshp;
+
Added: trunk/regress/loader/ReprojectPtsD.shp
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsD.shp
===================================================================
--- trunk/regress/loader/ReprojectPtsD.shp 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsD.shp 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsD.shp
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/loader/ReprojectPtsD.shx
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsD.shx
===================================================================
--- trunk/regress/loader/ReprojectPtsD.shx 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsD.shx 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsD.shx
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/loader/ReprojectPtsGeogD-post.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD-post.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD-post.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,2 @@
+-- cleanup
+DELETE FROM spatial_ref_sys;
Added: trunk/regress/loader/ReprojectPtsGeogD-pre.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD-pre.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD-pre.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,9 @@
+---
+--- EPSG 4326 : WGS 84
+---
+INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (4326,'EPSG',4326,'GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]','+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs ');
+---
+--- EPSG 2260 : NAD83 / New York East (ftUS)
+---
+INSERT INTO "spatial_ref_sys" ("srid","auth_name","auth_srid","srtext","proj4text") VALUES (2260,'EPSG',2260,'PROJCS["NAD83 / New York East (ftUS)",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4269"]],UNIT["US survey foot",0.3048006096012192,AUTHORITY["EPSG","9003"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",38.83333333333334],PARAMETER["central_meridian",-74.5],PARAMETER["scale_factor",0.9999],PARAMETER["false_easting",492125],PARAMETER["false_northing",0],AUTHORITY["EPSG","2260"],AXIS["X",EAST],AXIS["Y",NORTH]]','+proj=tmerc +lat_0=38.83333333333334 +lon_0=-74.5 +k=0.9999 +x_0=150000 +y_0=0 +ellps=GRS80 +datum=NAD83 +units=us-ft +no_defs ');
+
Added: trunk/regress/loader/ReprojectPtsGeogD-w.select.expected
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD-w.select.expected (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD-w.select.expected 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,66 @@
+SRID=4326;POINT(-74.17782492 41.08263361)
+SRID=4326;POINT(-74.44881286 40.50133744)
+SRID=4326;POINT(-74.00376358 40.28149688)
+SRID=4326;POINT(-75.12863742 39.7797389)
+SRID=4326;POINT(-74.57629014 40.85597595)
+SRID=4326;POINT(-74.47160401 40.52369066)
+SRID=4326;POINT(-75.46891683 39.69688334)
+SRID=4326;POINT(-75.11458618 39.70739231)
+SRID=4326;POINT(-74.22643701 40.09726563)
+SRID=4326;POINT(-74.26766926 40.83522615)
+SRID=4326;POINT(-74.42152037 40.76232181)
+SRID=4326;POINT(-74.18666598 40.89980341)
+SRID=4326;POINT(-74.20201874 40.94448827)
+SRID=4326;POINT(-74.31866663 40.6680465)
+SRID=4326;POINT(-74.83205963 40.84912898)
+SRID=4326;POINT(-74.64402101 39.96633708)
+SRID=4326;POINT(-74.22194028 40.09559148)
+SRID=4326;POINT(-74.60375255 40.75504208)
+SRID=4326;POINT(-74.09376018 40.86569336)
+SRID=4326;POINT(-74.4430374 40.77797967)
+SRID=4326;POINT(-74.76841703 40.22038455)
+SRID=4326;POINT(-74.19078182 40.73914574)
+SRID=4326;POINT(-74.19628444 40.79591416)
+SRID=4326;POINT(-74.19130306 40.74330253)
+SRID=4326;POINT(-74.17636308 40.73783123)
+SRID=4326;POINT(-74.53148731 39.49029456)
+SRID=4326;POINT(-74.16618054 40.73634864)
+SRID=4326;POINT(-74.35732607 40.80076793)
+SRID=4326;POINT(-74.17573811 40.73901418)
+SRID=4326;POINT(-74.66491581 40.34572735)
+SRID=4326;POINT(-74.36625323 40.51061374)
+SRID=4326;POINT(-74.17631876 40.74329159)
+SRID=4326;POINT(-74.4544664 40.52427239)
+SRID=4326;POINT(-74.02836656 40.89756584)
+SRID=4326;POINT(-75.00833975 39.82895026)
+SRID=4326;POINT(-74.13132221 40.33161528)
+SRID=4326;POINT(-74.67999522 39.46203859)
+SRID=4326;POINT(-74.08904806 40.9515804)
+SRID=4326;POINT(-75.12091068 39.94826917)
+SRID=4326;POINT(-74.08628025 40.70929009)
+SRID=4326;POINT(-74.73270242 40.27825159)
+SRID=4326;POINT(-74.16625303 40.01000431)
+SRID=4326;POINT(-75.01837982 40.74472398)
+SRID=4326;POINT(-74.65920653 40.34951097)
+SRID=4326;POINT(-74.24751143 40.74434122)
+SRID=4326;POINT(-74.65122484 40.25151634)
+SRID=4326;POINT(-74.43880205 40.4659008)
+SRID=4326;POINT(-74.2355417 40.68231466)
+SRID=4326;POINT(-74.49892935 40.80763833)
+SRID=4326;POINT(-74.0625762 40.73086062)
+SRID=4326;POINT(-75.03600164 39.78659251)
+SRID=4326;POINT(-75.05591643 39.44084942)
+SRID=4326;POINT(-74.39804333 40.50086907)
+SRID=4326;POINT(-74.07131567 40.72720191)
+SRID=4326;POINT(-74.19117919 40.74196293)
+SRID=4326;POINT(-74.02494262 40.74676479)
+SRID=4326;POINT(-74.68894668 40.6094749)
+SRID=4326;POINT(-74.44600226 40.49825884)
+SRID=4326;POINT(-74.19898991 40.85779571)
+SRID=4326;POINT(-74.7828046 40.27094999)
+SRID=4326;POINT(-74.25017536 40.217432)
+SRID=4326;POINT(-74.16960551 40.91844326)
+SRID=4326;POINT(-74.75788852 41.06754763)
+SRID=4326;POINT(-74.03363729 40.72689071)
+SRID=4326;POINT(-74.5760699 40.53743164)
+SRID=4326;POINT(-74.43925667 40.77359187)
Added: trunk/regress/loader/ReprojectPtsGeogD.dbf
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsGeogD.dbf
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.dbf 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsGeogD.dbf 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsGeogD.dbf
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/loader/ReprojectPtsGeogD.opts
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.opts (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD.opts 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,3 @@
+# This happens to be a multipoint shapefile that has only single points, so use -S.
+# It is in NJ State Plane NAD83, using the -D copy mode, -s reproject to 4326, -G flag cast a geography.
+-D -S -s 2260:4326 -G
Added: trunk/regress/loader/ReprojectPtsGeogD.select.expected
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.select.expected (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD.select.expected 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,66 @@
+SRID=4326;POINT(-74.17782492 41.08263361)
+SRID=4326;POINT(-74.44881286 40.50133744)
+SRID=4326;POINT(-74.00376358 40.28149688)
+SRID=4326;POINT(-75.12863742 39.7797389)
+SRID=4326;POINT(-74.57629014 40.85597595)
+SRID=4326;POINT(-74.47160401 40.52369066)
+SRID=4326;POINT(-75.46891683 39.69688334)
+SRID=4326;POINT(-75.11458618 39.70739231)
+SRID=4326;POINT(-74.22643701 40.09726563)
+SRID=4326;POINT(-74.26766926 40.83522615)
+SRID=4326;POINT(-74.42152037 40.76232181)
+SRID=4326;POINT(-74.18666598 40.89980341)
+SRID=4326;POINT(-74.20201874 40.94448827)
+SRID=4326;POINT(-74.31866663 40.6680465)
+SRID=4326;POINT(-74.83205963 40.84912898)
+SRID=4326;POINT(-74.64402101 39.96633708)
+SRID=4326;POINT(-74.22194028 40.09559148)
+SRID=4326;POINT(-74.60375255 40.75504208)
+SRID=4326;POINT(-74.09376018 40.86569336)
+SRID=4326;POINT(-74.4430374 40.77797967)
+SRID=4326;POINT(-74.76841703 40.22038455)
+SRID=4326;POINT(-74.19078182 40.73914574)
+SRID=4326;POINT(-74.19628444 40.79591416)
+SRID=4326;POINT(-74.19130306 40.74330253)
+SRID=4326;POINT(-74.17636308 40.73783123)
+SRID=4326;POINT(-74.53148731 39.49029456)
+SRID=4326;POINT(-74.16618054 40.73634864)
+SRID=4326;POINT(-74.35732607 40.80076793)
+SRID=4326;POINT(-74.17573811 40.73901418)
+SRID=4326;POINT(-74.66491581 40.34572735)
+SRID=4326;POINT(-74.36625323 40.51061374)
+SRID=4326;POINT(-74.17631876 40.74329159)
+SRID=4326;POINT(-74.4544664 40.52427239)
+SRID=4326;POINT(-74.02836656 40.89756584)
+SRID=4326;POINT(-75.00833975 39.82895026)
+SRID=4326;POINT(-74.13132221 40.33161528)
+SRID=4326;POINT(-74.67999522 39.46203859)
+SRID=4326;POINT(-74.08904806 40.9515804)
+SRID=4326;POINT(-75.12091068 39.94826917)
+SRID=4326;POINT(-74.08628025 40.70929009)
+SRID=4326;POINT(-74.73270242 40.27825159)
+SRID=4326;POINT(-74.16625303 40.01000431)
+SRID=4326;POINT(-75.01837982 40.74472398)
+SRID=4326;POINT(-74.65920653 40.34951097)
+SRID=4326;POINT(-74.24751143 40.74434122)
+SRID=4326;POINT(-74.65122484 40.25151634)
+SRID=4326;POINT(-74.43880205 40.4659008)
+SRID=4326;POINT(-74.2355417 40.68231466)
+SRID=4326;POINT(-74.49892935 40.80763833)
+SRID=4326;POINT(-74.0625762 40.73086062)
+SRID=4326;POINT(-75.03600164 39.78659251)
+SRID=4326;POINT(-75.05591643 39.44084942)
+SRID=4326;POINT(-74.39804333 40.50086907)
+SRID=4326;POINT(-74.07131567 40.72720191)
+SRID=4326;POINT(-74.19117919 40.74196293)
+SRID=4326;POINT(-74.02494262 40.74676479)
+SRID=4326;POINT(-74.68894668 40.6094749)
+SRID=4326;POINT(-74.44600226 40.49825884)
+SRID=4326;POINT(-74.19898991 40.85779571)
+SRID=4326;POINT(-74.7828046 40.27094999)
+SRID=4326;POINT(-74.25017536 40.217432)
+SRID=4326;POINT(-74.16960551 40.91844326)
+SRID=4326;POINT(-74.75788852 41.06754763)
+SRID=4326;POINT(-74.03363729 40.72689071)
+SRID=4326;POINT(-74.5760699 40.53743164)
+SRID=4326;POINT(-74.43925667 40.77359187)
Added: trunk/regress/loader/ReprojectPtsGeogD.select.sql
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.select.sql (rev 0)
+++ trunk/regress/loader/ReprojectPtsGeogD.select.sql 2019-07-29 01:11:07 UTC (rev 17624)
@@ -0,0 +1,2 @@
+select ST_Asewkt(ST_SnapToGrid(the_geom::geometry,0.00000001)) from loadedshp;
+
Added: trunk/regress/loader/ReprojectPtsGeogD.shp
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsGeogD.shp
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.shp 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsGeogD.shp 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsGeogD.shp
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
Added: trunk/regress/loader/ReprojectPtsGeogD.shx
===================================================================
(Binary files differ)
Index: trunk/regress/loader/ReprojectPtsGeogD.shx
===================================================================
--- trunk/regress/loader/ReprojectPtsGeogD.shx 2019-07-28 21:37:00 UTC (rev 17623)
+++ trunk/regress/loader/ReprojectPtsGeogD.shx 2019-07-29 01:11:07 UTC (rev 17624)
Property changes on: trunk/regress/loader/ReprojectPtsGeogD.shx
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+application/octet-stream
\ No newline at end of property
More information about the postgis-tickets
mailing list