| 1 |
# |
| 2 |
# NULL values. |
| 3 |
# |
| 4 |
# At least one NULL parameter. Should return NULL. |
| 5 |
SELECT ST_TRANSFORM(NULL, NULL); |
| 6 |
ST_TRANSFORM(NULL, NULL) |
| 7 |
NULL |
| 8 |
SELECT ST_TRANSFORM(NULL, 4326); |
| 9 |
ST_TRANSFORM(NULL, 4326) |
| 10 |
NULL |
| 11 |
SELECT ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL); |
| 12 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), NULL) |
| 13 |
NULL |
| 14 |
# |
| 15 |
# Invalid parameters. |
| 16 |
# |
| 17 |
# Invalid geometry. Should raise error. |
| 18 |
DO ST_TRANSFORM(x'00000000DEADBEEF', 4326); |
| 19 |
ERROR 22023: Invalid GIS data provided to function st_transform. |
| 20 |
# Non-existing SRID. Should raise error. |
| 21 |
DO ST_TRANSFORM( |
| 22 |
x'94007735010100000000000000000000000000000000000000', |
| 23 |
4326 |
| 24 |
); |
| 25 |
ERROR SR001: There's no spatial reference system with SRID 896991380. |
| 26 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000000000); |
| 27 |
ERROR SR001: There's no spatial reference system with SRID 1000000000. |
| 28 |
# |
| 29 |
# Transformation to/from SRID 0. |
| 30 |
# |
| 31 |
# Transformation from SRID 0 to SRID 0 is a no-op. Should return true. |
| 32 |
SELECT |
| 33 |
ST_EQUALS( |
| 34 |
ST_GEOMFROMTEXT('POINT(0 0)'), |
| 35 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 0) |
| 36 |
) AS is_noop; |
| 37 |
is_noop |
| 38 |
1 |
| 39 |
# Transformation between SRID 0 and geographic SRS. Should raise error. |
| 40 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 4326); |
| 41 |
ERROR 22S00: Transformation from SRID 0 is not supported. |
| 42 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 0); |
| 43 |
ERROR 22S00: Transformation to SRID 0 is not supported. |
| 44 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 4047); |
| 45 |
ERROR 22S00: Transformation from SRID 0 is not supported. |
| 46 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4047), 0); |
| 47 |
ERROR 22S00: Transformation to SRID 0 is not supported. |
| 48 |
# Transformation between SRID 0 and projected SRS. Should raise error. |
| 49 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)'), 3857); |
| 50 |
ERROR 22S00: Transformation from SRID 0 is not supported. |
| 51 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 3857), 0); |
| 52 |
ERROR 22S00: Transformation to SRID 0 is not supported. |
| 53 |
# |
| 54 |
# Transformation between geographic SRSs. |
| 55 |
# |
| 56 |
# Transformation of every geometry type. Should succeed. |
| 57 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 3819); |
| 58 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('LINESTRING(0 0, 1 1)', 4326), 3819); |
| 59 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POLYGON((0 0, 0 1, 1 1, 0 0))', 4326), 3819); |
| 60 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('GEOMETRYCOLLECTION(POINT(0 0))', 4326), 3819); |
| 61 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('MULTIPOINT((0 0))', 4326), 3819); |
| 62 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('MULTILINESTRING((0 0, 1 1))', 4326), 3819); |
| 63 |
DO ST_TRANSFORM( |
| 64 |
ST_GEOMFROMTEXT('MULTIPOLYGON(((0 0, 0 1, 1 1, 0 0)))', 4326), |
| 65 |
3819 |
| 66 |
); |
| 67 |
# Beginning of tests to verify that WGS 84 is recognized. |
| 68 |
# WGS 84 with no authority codes. Should raise error. |
| 69 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 70 |
NAME 'foo' |
| 71 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 72 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 73 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 74 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 75 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 76 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 77 |
# WGS 84 with no authority codes exept EPSG 4326 for the entire SRS. |
| 78 |
# Should succeed. |
| 79 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 80 |
NAME 'foo' |
| 81 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 82 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 83 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 84 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 85 |
# WGS 84 with incorrect authority code. Should raise error. |
| 86 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 87 |
NAME 'foo' |
| 88 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","0"]]'; |
| 89 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 90 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 91 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 92 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 93 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 94 |
# WGS 84 with authority code for the spheroid. Should succeed. |
| 95 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 96 |
NAME 'foo' |
| 97 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 98 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 99 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 100 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 101 |
# WGS 84 with incorrect authority code for the spheroid. Should raise |
| 102 |
# error. |
| 103 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 104 |
NAME 'foo' |
| 105 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","0"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 106 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 107 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 108 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 109 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 110 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 111 |
# WGS 84 with incorrect semi-major axis. Should raise error. |
| 112 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 113 |
NAME 'foo' |
| 114 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",1378137,298.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 115 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 116 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 117 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 118 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 119 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 120 |
# WGS 84 with incorrect inverse flattening. Should raise error. |
| 121 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 122 |
NAME 'foo' |
| 123 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,198.257223563,AUTHORITY["EPSG","7030"]]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 124 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 125 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 126 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 127 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 128 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 129 |
# WGS 84 with authority code for the datum. Should succeed. |
| 130 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 131 |
NAME 'foo' |
| 132 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 133 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 134 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 135 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 136 |
# WGS 84 with incorrect authority code for the datum. Should raise error. |
| 137 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 138 |
NAME 'foo' |
| 139 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],AUTHORITY["EPSG","0"]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 140 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 141 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 142 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 143 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 144 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 145 |
# WGS 84 with authority code for the prime meridian. Should succeed. |
| 146 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 147 |
NAME 'foo' |
| 148 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 149 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 150 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 151 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 152 |
# WGS 84 with incorrect authority code for the prime meridian. Should |
| 153 |
# raise error. |
| 154 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 155 |
NAME 'foo' |
| 156 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","0"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 157 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 158 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 159 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 160 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 161 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 162 |
# WGS 84 with incorrect prime meridian. Should raise error. |
| 163 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 164 |
NAME 'foo' |
| 165 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",1,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 166 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 167 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 168 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 169 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 170 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 171 |
# WGS 84 with authority code for the unit. Should succeed. |
| 172 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 173 |
NAME 'foo' |
| 174 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 175 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 176 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 177 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 178 |
# WGS 84 with incorrect authority code for the unit. Should raise error. |
| 179 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 180 |
NAME 'foo' |
| 181 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","0"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 182 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 183 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 184 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 185 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 186 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 187 |
# WGS 84 with incorrect unit. Should raise error. |
| 188 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 189 |
NAME 'foo' |
| 190 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.01,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4326"]]'; |
| 191 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 192 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 193 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 194 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 195 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 196 |
# WGS 84 with incorrect axes. Should raise error. |
| 197 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 198 |
NAME 'foo' |
| 199 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lon",EAST],AXIS["Lat",NORTH],AUTHORITY["EPSG","4326"]]'; |
| 200 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 201 |
ERROR 22S00: Transformation from SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 202 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 203 |
ERROR 22S00: Transformation to SRID 1000004326 is not supported. The spatial reference system has no TOWGS84 clause. |
| 204 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 205 |
# End of tests to verify that WGS 84 is recognized. |
| 206 |
# Geographic SRS with TOWGS84 clause. Should succeed. |
| 207 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 208 |
NAME 'foo' |
| 209 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 210 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 211 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 212 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 213 |
# Spherical SRS with TOWGS84 clause. Should succeed. |
| 214 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 215 |
NAME 'foo' |
| 216 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 217 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326); |
| 218 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326); |
| 219 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 220 |
# Prime meridian 1 degree East of Greenwich. |
| 221 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 222 |
NAME 'foo' |
| 223 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",1],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 224 |
SELECT |
| 225 |
ST_ASTEXT( |
| 226 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326) |
| 227 |
) AS lon_should_be_plus_one; |
| 228 |
lon_should_be_plus_one |
| 229 |
POINT(0 1) |
| 230 |
SELECT |
| 231 |
ST_ASTEXT( |
| 232 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326) |
| 233 |
) AS lon_should_be_minus_one; |
| 234 |
lon_should_be_minus_one |
| 235 |
POINT(0 -1) |
| 236 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 237 |
# Prime meridian 1 degree West of Greenwich. |
| 238 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 239 |
NAME 'foo' |
| 240 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",-1],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 241 |
SELECT |
| 242 |
ST_ASTEXT( |
| 243 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326) |
| 244 |
) AS lon_should_be_minus_one; |
| 245 |
lon_should_be_minus_one |
| 246 |
POINT(0 -1) |
| 247 |
SELECT |
| 248 |
ST_ASTEXT( |
| 249 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326) |
| 250 |
) AS lon_should_be_plus_one; |
| 251 |
lon_should_be_plus_one |
| 252 |
POINT(0 1) |
| 253 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 254 |
# Prime meridian 180 degrees East of Greenwich. |
| 255 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 256 |
NAME 'foo' |
| 257 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",180],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 258 |
SELECT |
| 259 |
ST_ASTEXT( |
| 260 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326) |
| 261 |
) AS lon_should_be_180; |
| 262 |
lon_should_be_180 |
| 263 |
POINT(0 180) |
| 264 |
SELECT |
| 265 |
ST_ASTEXT( |
| 266 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326) |
| 267 |
) AS lon_should_be_minus_180; |
| 268 |
lon_should_be_minus_180 |
| 269 |
POINT(0 -180) |
| 270 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 271 |
# Prime meridian 180 degrees West of Greenwich. |
| 272 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 273 |
NAME 'foo' |
| 274 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,0],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["foo",-180],UNIT["degree",0.017453292519943278],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 275 |
SELECT |
| 276 |
ST_ASTEXT( |
| 277 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326) |
| 278 |
) AS lon_should_be_minus_180; |
| 279 |
lon_should_be_minus_180 |
| 280 |
POINT(0 -180) |
| 281 |
SELECT |
| 282 |
ST_ASTEXT( |
| 283 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326) |
| 284 |
) AS lon_should_be_180; |
| 285 |
lon_should_be_180 |
| 286 |
POINT(0 180) |
| 287 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 288 |
# Transformation between degrees and gradians. |
| 289 |
CREATE SPATIAL REFERENCE SYSTEM 1000004326 |
| 290 |
NAME 'foo' |
| 291 |
DEFINITION 'GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563],TOWGS84[0,0,0,0,0,0,0]],PRIMEM["Greenwich",0],UNIT["grad",0.01570796326794895],AXIS["Lat",NORTH],AXIS["Lon",EAST]]'; |
| 292 |
SELECT |
| 293 |
ST_ASTEXT( |
| 294 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 1000004326), 4326) |
| 295 |
) AS should_be_0_0; |
| 296 |
should_be_0_0 |
| 297 |
POINT(0 0) |
| 298 |
SELECT |
| 299 |
ST_ASTEXT( |
| 300 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 1000004326) |
| 301 |
) AS should_be_0_0; |
| 302 |
should_be_0_0 |
| 303 |
POINT(0 0) |
| 304 |
SELECT |
| 305 |
ST_ASTEXT( |
| 306 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(100 100)', 1000004326), 4326) |
| 307 |
) AS should_be_90_90; |
| 308 |
should_be_90_90 |
| 309 |
POINT(90 90) |
| 310 |
SELECT |
| 311 |
ST_ASTEXT( |
| 312 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(90 90)', 4326), 1000004326) |
| 313 |
) AS should_be_100_100; |
| 314 |
should_be_100_100 |
| 315 |
POINT(100 100) |
| 316 |
SELECT |
| 317 |
ST_ASTEXT( |
| 318 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-100 -100)', 1000004326), 4326) |
| 319 |
) AS should_be_minus_90_minus_90; |
| 320 |
should_be_minus_90_minus_90 |
| 321 |
POINT(-90 -90) |
| 322 |
SELECT |
| 323 |
ST_ASTEXT( |
| 324 |
ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-90 -90)', 4326), 1000004326) |
| 325 |
) AS should_be_minus_100_minus_100; |
| 326 |
should_be_minus_100_minus_100 |
| 327 |
POINT(-100 -100) |
| 328 |
DROP SPATIAL REFERENCE SYSTEM 1000004326; |
| 329 |
# Transformations between European Datum 1950 (ED50) and WGS 84. |
| 330 |
# Positions in Western Europe will be further North and East in ED50 than |
| 331 |
# in WGS 84. |
| 332 |
# Trondheim. |
| 333 |
SELECT |
| 334 |
ST_ASTEXT( |
| 335 |
ST_TRANSFORM( |
| 336 |
ST_GEOMFROMTEXT('POINT(63.426912 10.396918)', 4326), |
| 337 |
4230 |
| 338 |
) |
| 339 |
) AS ED50; |
| 340 |
ED50 |
| 341 |
POINT(63.42724 10.398502) |
| 342 |
SELECT |
| 343 |
ST_ASTEXT( |
| 344 |
ST_TRANSFORM( |
| 345 |
ST_GEOMFROMTEXT('POINT(63.42724 10.398502)', 4230), |
| 346 |
4326 |
| 347 |
) |
| 348 |
) AS WGS84; |
| 349 |
WGS84 |
| 350 |
POINT(63.426912 10.396918) |
| 351 |
# Telegrafenberg, Potsdam (origin of ED50). |
| 352 |
SELECT |
| 353 |
ST_ASTEXT( |
| 354 |
ST_TRANSFORM( |
| 355 |
ST_GEOMFROMTEXT('POINT(52.381389 13.064444)', 4326), |
| 356 |
4230 |
| 357 |
) |
| 358 |
) AS ED50; |
| 359 |
ED50 |
| 360 |
POINT(52.382086 13.065521) |
| 361 |
SELECT |
| 362 |
ST_ASTEXT( |
| 363 |
ST_TRANSFORM( |
| 364 |
ST_GEOMFROMTEXT('POINT(52.382086 13.065521)', 4230), |
| 365 |
4326 |
| 366 |
) |
| 367 |
) AS WGS84; |
| 368 |
WGS84 |
| 369 |
POINT(52.381389 13.064444) |
| 370 |
# |
| 371 |
# Transformation to/from projected SRSs. |
| 372 |
# |
| 373 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(24.381786962 -100.33333332)', 4326), 3857)); |
| 374 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-11169055.574774178 2800000.005281789)', 3857), 4326)); |
| 375 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'webmodairy' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["Modified Airy / Pseudo-Mercator",GEOGCS["modairy",DATUM["modairy",SPHEROID["Bessel 1841", 6377340.189,299.324937365, AUTHORITY["EPSG","7004"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6120"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4120"]],PROJECTION["Popular Visualisation Pseudo Mercator",AUTHORITY["EPSG","1024"]],PARAMETER["Latitude of natural origin",0,AUTHORITY["EPSG","8801"]],PARAMETER["Longitude of natural origin",0.01,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",100,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",-10,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3857"]]'; |
| 376 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0.0008983333 0.001796667)', 4326, 'axis-order=long-lat'), 33001)); |
| 377 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-913.0663257585971 189.97410223677596)', 33001, 'axis-order=long-lat'), 4326), 'axis-order=long-lat'); |
| 378 |
DROP SPATIAL REFERENCE SYSTEM 33001; |
| 379 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["US National Atlas Equal Area",GEOGCS["Unspecified datum based upon the Clarke 1866 Authalic Sphere",DATUM["Not specified (based on Clarke 1866 Authalic Sphere)",SPHEROID["Clarke 1866 Authalic Sphere",6370997,0,AUTHORITY["EPSG","7052"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6052"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4052"]],PROJECTION["Lambert Azimuthal Equal Area (Spherical)",AUTHORITY["EPSG","1027"]],PARAMETER["Latitude of natural origin",45,AUTHORITY["EPSG","8801"]],PARAMETER["Longitude of natural origin",-100,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","2163"]]'; |
| 380 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001)); |
| 381 |
DROP SPATIAL REFERENCE SYSTEM 33001; |
| 382 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 4087)); |
| 383 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["World Equidistant Cylindrical (Sphere)",GEOGCS["Unspecified datum based upon the GRS 1980 Authalic Sphere",DATUM["Not specified (based on GRS 1980 Authalic Sphere)",SPHEROID["GRS 1980 Authalic Sphere",6371007,0,AUTHORITY["EPSG","7048"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6047"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4047"]],PROJECTION["Equidistant Cylindrical (Spherical)",AUTHORITY["EPSG","1029"]],PARAMETER["Latitude of 1st standard parallel",0,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","4088"]]'; |
| 384 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001)); |
| 385 |
DROP SPATIAL REFERENCE SYSTEM 33001; |
| 386 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.20901 16.84977)', 4326), 5514)); |
| 387 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(43.750000014 -83.166666653)', 4326), 6201)); |
| 388 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(4.7999999945 -74.250000023)', 4326), 6247)); |
| 389 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(17.932166647 -76.943683174)', 4326), 24200)); |
| 390 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(28.500000182 -95.99999989)', 4326), 32040)); |
| 391 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.679572292 5.80737015)', 4326), 31300)); |
| 392 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-3.0000001398 119.99999986)', 4326), 3002)); |
| 393 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52.999999796 52.999999796)', 4326), 3388)); |
| 394 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(10.000000275 -62.000000216)', 4326), 30200)); |
| 395 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.499999871 0.50000021429)', 4326), 27700)); |
| 396 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-25.732028354 28.282632944)', 4326), 2053)); |
| 397 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(53.000000025 5.9999999931)', 4326), 28992)); |
| 398 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(73.000000003 44.000000007)', 4326), 5041)); |
| 399 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-36.848461 174.763336)', 4326), 27200)); |
| 400 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(12 117)', 4326), 3079)); |
| 401 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-16.189799986 44.45757)', 4326), 8441)); |
| 402 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(5.3872536023 115.80550545)', 4326), 29873)); |
| 403 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(37.521562493 34.136469742)', 4326), 22700)); |
| 404 |
DO ST_AsText(ST_Transform(ST_GeomFromText('POINT(-6 -45)', 4674), 5880)); |
| 405 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50.20901 16.84977)', 4326), 5513)); |
| 406 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(50 5)', 4326), 3035)); |
| 407 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(42.749999987 -78.75)', 4326), 3174)); |
| 408 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(56 12)', 4326), 32600)); |
| 409 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-44 174)', 4326), 32700)); |
| 410 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(38.736946 -9.142685)', 4326), 5017)); |
| 411 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-75 120)', 4326), 3032)); |
| 412 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-66.605227791 140.07140001)', 4326), 2985)); |
| 413 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(13.33903845 144.63533131)', 4326), 3993)); |
| 414 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(9.5965258594 138.19303001)', 4326), 3295)); |
| 415 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'geocs3295' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'GEOGCS["Guam 1963",DATUM["Guam 1963",SPHEROID["Clarke 1866",6378206.4,294.9786982138982,AUTHORITY["EPSG","7008"]],TOWGS84[-100,-248,259,0,0,0,0],AUTHORITY["EPSG","6675"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278,AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4675"]]'; |
| 416 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(9.5965258594 138.19303)', 33001), 3295)); |
| 417 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(-16.841456514 179.99433651)', 4326), 3139)); |
| 418 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["NSIDC EASE-Grid Global",GEOGCS["Unspecified datum based upon the International 1924 Authalic Sphere",DATUM["Not specified (based on International 1924 Authalic Sphere)",SPHEROID["International 1924 Authalic Sphere",6371228,0,AUTHORITY["EPSG","7057"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6053"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4053"]],PROJECTION["Lambert Cylindrical Equal Area (Spherical)",AUTHORITY["EPSG","9834"]],PARAMETER["Latitude of 1st standard parallel",30,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","3410"]]'; |
| 419 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001)); |
| 420 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["WGS 84 / NSIDC EASE-Grid 2.0 Global",GEOGCS["WGS 84",DATUM["World Geodetic System 1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]], TOWGS84[0,0,0,0,0,0,0], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0, AUTHORITY["EPSG","8901"]],UNIT["degree",0.017453292519943278, AUTHORITY["EPSG","9122"]],AXIS["Lat",NORTH],AXIS["Lon",EAST], AUTHORITY["EPSG","4326"]],PROJECTION["Lambert Cylindrical Equal Area",AUTHORITY["EPSG","9835"]],PARAMETER["Latitude of 1st standard parallel",30,AUTHORITY["EPSG","8823"]],PARAMETER["Longitude of natural origin",0,AUTHORITY["EPSG","8802"]],PARAMETER["False easting",0,AUTHORITY["EPSG","8806"]],PARAMETER["False northing",0,AUTHORITY["EPSG","8807"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","6933"]]'; |
| 421 |
DO ST_ASTEXT(ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(52 10)', 4326), 33001)); |
| 422 |
DROP SPATIAL REFERENCE SYSTEM 33001; |
| 423 |
# Verify that it isn't possible to transform to/from the four not implemented projections: 1042, 1043, 9816, 9826 |
| 424 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 5515); |
| 425 |
ERROR 22S00: Transformation to SRID 5515 is not supported. |
| 426 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 5516); |
| 427 |
ERROR 22S00: Transformation to SRID 5516 is not supported. |
| 428 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 22300); |
| 429 |
ERROR 22S00: Transformation to SRID 22300 is not supported. The spatial reference system has no TOWGS84 clause. |
| 430 |
CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 33001 NAME 'userdef' ORGANIZATION 'EPSG' IDENTIFIED BY 33001 DEFINITION 'PROJCS["Carthage (Paris) / Tunisia Mining Grid",GEOGCS["Carthage (Paris)",DATUM["Carthage (Paris)",SPHEROID["Clarke 1880 (IGN)",6378249.2,293.4660212936269,AUTHORITY["EPSG","7011"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6816"]],PRIMEM["Paris",2.5969213,AUTHORITY["EPSG","8903"]],UNIT["grad",0.01570796326794895,AUTHORITY["EPSG","9105"]],AXIS["Lat",NORTH],AXIS["Lon",EAST],AUTHORITY["EPSG","4816"]],PROJECTION["Tunisia Mining Grid",AUTHORITY["EPSG","9816"]],PARAMETER["Latitude of false origin",36.5964,AUTHORITY["EPSG","8821"]],PARAMETER["Longitude of false origin",7.83445,AUTHORITY["EPSG","8822"]],PARAMETER["Easting at false origin",270,AUTHORITY["EPSG","8826"]],PARAMETER["Northing at false origin",360,AUTHORITY["EPSG","8827"]],UNIT["kilometre",1000,AUTHORITY["EPSG","9036"]],AXIS["X",EAST],AXIS["Y",NORTH],AUTHORITY["EPSG","22300"]]'; |
| 431 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 33001); |
| 432 |
ERROR 22S00: Transformation to SRID 33001 is not supported. |
| 433 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 4326), 2218); |
| 434 |
ERROR 22S00: Transformation to SRID 2218 is not supported. |
| 435 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 5515), 4326); |
| 436 |
ERROR 22S00: Transformation from SRID 5515 is not supported. |
| 437 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 5516), 4326); |
| 438 |
ERROR 22S00: Transformation from SRID 5516 is not supported. |
| 439 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 22300), 4326); |
| 440 |
ERROR 22S00: Transformation from SRID 22300 is not supported. The spatial reference system has no TOWGS84 clause. |
| 441 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 33001), 4326); |
| 442 |
ERROR 22S00: Transformation from SRID 33001 is not supported. |
| 443 |
DROP SPATIAL REFERENCE SYSTEM 33001; |
| 444 |
DO ST_TRANSFORM(ST_GEOMFROMTEXT('POINT(0 0)', 2218), 4326); |
| 445 |
ERROR 22S00: Transformation from SRID 2218 is not supported. |