Timeline for PostGIS Unknown Coordinates Format
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 14, 2016 at 18:55 | answer | added | Paul Ramsey | timeline score: 2 | |
| Jul 14, 2016 at 14:52 | history | edited | Mapperz♦ | CC BY-SA 3.0 |
Remove CAPS in Title
|
| Jul 14, 2016 at 14:38 | comment | added | elrobis |
Joao, if you want to see longitude/latitude values, do this: ST_Transform(geom, 4326), that will convert your projected coordinates to WGS84 (i.e. 4326) decimal degrees, assuming PostGIS recognizes your projection (EPSG 3763). If your projection is unrecognized, it'll give you dodgy results.
|
|
| Jul 14, 2016 at 14:33 | comment | added | John Powell | ST_Transform, from one coordinate reference system to another. | |
| Jul 14, 2016 at 13:06 | comment | added | Joao Castanheira | what you mean with 'reprojet' ? | |
| Jul 14, 2016 at 12:13 | comment | added | Vince | The coordinates are X and Y meters in a local Portugal projection. If you want something different, you'll need to reproject. | |
| Jul 14, 2016 at 11:32 | comment | added | Joao Castanheira | using prj2epsg.org, result are: 3763 - ETRS_1989_TM06-Portugal | |
| Jul 14, 2016 at 11:26 | comment | added | Vince | You'll need to provide the SRID or .prj contents before we could tell you what projection that might be (it could be any projected coordinate system) | |
| Jul 14, 2016 at 11:13 | review | First posts | |||
| Jul 14, 2016 at 11:31 | |||||
| Jul 14, 2016 at 11:06 | history | asked | Joao Castanheira | CC BY-SA 3.0 |