Re: [postgis-users] Paris data

2010-11-04 Thread Ravi
ThanQ --- On Thu, 4/11/10, Paragon Corporation l...@pcorp.us wrote: From: Paragon Corporation l...@pcorp.us Subject: Re: [postgis-users] Paris data To: 'PostGIS Users Discussion' postgis-users@postgis.refractions.net Date: Thursday, 4 November, 2010, 9:28 AM Ravi,   The code and data

[postgis-users] suitable projection in metric system ?

2010-11-04 Thread ahmet temiz
hello I was wondering if you could tell me which projection in metric system is suitable for whole country (TURKEY) ? I thought to use UTM, but it has three different zones. If you answer me, I will appreciate regards -- Ahmet Temiz Jeoloji Müh. Planlama ve Zarar Azaltma Dairesi Başkanlığı

Re: [postgis-users] suitable projection in metric system ?

2010-11-04 Thread Emilie Laffray
2010/11/4 ahmet temiz ahmettemi...@gmail.com hello I was wondering if you could tell me which projection in metric system is suitable for whole country (TURKEY) ? I thought to use UTM, but it has three different zones. If you answer me, I will appreciate If you are using Postgis 1.5, I

Re: [postgis-users] Query using ST_transform fails

2010-11-04 Thread Torsten Mohr
Am Dienstag, 2. November 2010 22:48:08 schrieb Mike Toews: select distinct st_srid(way) from planet_osm_point; Hello, i have to say i don't know exactly, but placing that query i got: gis= select distinct st_srid(way) from planet_osm_point; st_srid - 900913 (1 Zeile) Best regards,

Re: [postgis-users] Query using ST_transform fails

2010-11-04 Thread Torsten Mohr
Hello, thanks for your help. Regarding your questions: No, i don't use www.pgrpms.org, my system is openSuse 11.2, i installed their postgresql, which is version 8.4.4. Yes, i installed Proj4 from source. I have to say i'm not sure any more if i installed Proj-datumgrid in the /nad

Re: [postgis-users] Query using ST_transform fails

2010-11-04 Thread Mike Toews
I'm not sure why proj would require the NAD gridshift files for converting a google (900913) projection to WGS84 long/lat. Do you get any errors with this: select st_X(wayLL), st_Y(wayLL) from ( select ST_Transform('SRID=900913;POINT(653103 6.63036e+06 0)'::geometry, 4326) as wayLL ) as

Re: [postgis-users] suitable projection in metric system ?

2010-11-04 Thread Francis Markham
Hi Ahmet, My quick Googling hasn't come up with a widely used pre-defined projection for Turkey that is non zonal (either UTM or Gauss-Kruger), at least not in the EPSG database. Apparently, MapInfo ships with a Turkish Lambert projection in its