Re: [postgis-users] NAD conversion problem

2011-01-29 Thread Stefan Keller
is.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stefan > Keller > Sent: Saturday, January 29, 2011 4:33 PM > To: PostGIS Users Discussion > Cc: Frank Warmerdam > Subject: Re: [postgis-users] NAD conversion problem > > Hi, > > I'

Re: [postgis-users] NAD conversion problem

2011-01-29 Thread Paragon Corporation
, January 29, 2011 4:33 PM To: PostGIS Users Discussion Cc: Frank Warmerdam Subject: Re: [postgis-users] NAD conversion problem Hi, I'm having problems with grid shift files and I suspect it's an installation or compilation-config. problem: This works: # SELECT ST_AsText(ST_Transform(&#x

Re: [postgis-users] NAD conversion problem

2011-01-29 Thread Stefan Keller
Hi, I'm having problems with grid shift files and I suspect it's an installation or compilation-config. problem: This works: # SELECT ST_AsText(ST_Transform('SRID=900913;POINT(977705 5981192)'::geometry, 21781)) But this... # SELECT ST_AsText(ST_Transform('SRID=900913;POINT(977705 5981192)'::geom

Re: [postgis-users] NAD conversion problem

2009-09-28 Thread Frank Warmerdam
Peter N. Schweitzer wrote: So my hypothesis--please help me understand how wrong this is--is that the @null has the effect of keeping proj going when I project a point that is not in the areas covered by the nad27-to-nad83 conversion tables. Peter, Yes, this is the expected behavior of inclu

Re: [postgis-users] NAD conversion problem

2009-09-28 Thread Peter N. Schweitzer
Mark Cave-Ayland wrote: Peter N. Schweitzer wrote: (cut) Peter I recently had this problem with packages downloaded from the opensuse repository. Once I hand built and installed proj with this "@null" patch the problem went away. Folks, I have not followed this discussion closely, but I a

Re: [postgis-users] NAD conversion problem

2009-09-28 Thread Mark Cave-Ayland
Peter N. Schweitzer wrote: (cut) Peter I recently had this problem with packages downloaded from the opensuse repository. Once I hand built and installed proj with this "@null" patch the problem went away. Folks, I have not followed this discussion closely, but I am pretty sure adding @nul

Re: [postgis-users] NAD conversion problem

2009-09-27 Thread Peter N. Schweitzer
Frank Warmerdam wrote: Don wrote: Peter N. Schweitzer wrote: I was able to trace the problem to a file in the proj source code. in proj-4.6.1/src/pj_datums.c 87,88c87,88 < "NAD27", "nadgri...@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat", <

Re: [postgis-users] NAD conversion problem

2009-09-26 Thread Frank Warmerdam
Don wrote: Peter N. Schweitzer wrote: I was able to trace the problem to a file in the proj source code. in proj-4.6.1/src/pj_datums.c 87,88c87,88 < "NAD27", "nadgri...@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat", < "clrk66", --- "

Re: [postgis-users] NAD conversion problem

2009-09-26 Thread Don
Peter N. Schweitzer wrote: > Richard Greenwood wrote: >> On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer >> wrote: >>> Richard Greenwood wrote: On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer wrote: > Hello, > > I have two PostgreSQL installations. One uses 8.3.3 w

Re: [postgis-users] NAD conversion problem

2008-12-18 Thread Richard Greenwood
On Thu, Dec 18, 2008 at 11:20 AM, Bruce Rindahl wrote: > So if you have a Debian install where do you get the grid shift files and > where do you copy them? > Thanks > Bruce Being a Ubuntu/Debian knob, I am probably not the best person to answer this, but one way is to build Proj from source. Bui

Re: [postgis-users] NAD conversion problem

2008-12-18 Thread Dylan Beaudette
On Thursday 18 December 2008, Dane Springmeyer wrote: > Dylan, > > On Dec 17, 2008, at 2:19 PM, Dylan Beaudette wrote: > > On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood > > > > wrote: > >> On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam >> > >> > wrote: > >> > > However, I am trouble

Re: [postgis-users] NAD conversion problem

2008-12-18 Thread Dane Springmeyer
Dylan, On Dec 17, 2008, at 2:19 PM, Dylan Beaudette wrote: On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood wrote: On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam > wrote: However, I am troubled that the Ubuntu proj distribution does not seem to include the grid ship files. I hav

Re: [postgis-users] NAD conversion problem

2008-12-18 Thread Bruce Rindahl
So if you have a Debian install where do you get the grid shift files and where do you copy them? Thanks Bruce Dylan Beaudette wrote: On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood wrote: On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam wrote: However, I am troubled that the

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Dylan Beaudette
On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood wrote: > On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam wrote: > >>> However, I am troubled that the Ubuntu proj distribution does not seem >>> to include the grid ship files. >> >> >> I have learned that the DebianGIS packagers are unwilling

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Richard Greenwood
On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam wrote: >> However, I am troubled that the Ubuntu proj distribution does not seem >> to include the grid ship files. > > > I have learned that the DebianGIS packagers are unwilling to distribute the > grid shift component until there is a licensing

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Frank Warmerdam
Richard Greenwood wrote: However, I am troubled that the Ubuntu proj distribution does not seem to include the grid ship files. Richard, I have learned that the DebianGIS packagers are unwilling to distribute the grid shift component until there is a licensing statement available for the grid

Re: [postgis-users] NAD conversion problem

2008-12-17 Thread Richard Greenwood
On Tue, Dec 16, 2008 at 9:57 PM, Richard Greenwood wrote: > On Mon, Dec 8, 2008 at 6:08 PM, Dylan Beaudette > wrote: >>> Richard Greenwood wrote: >>> The files in http://svn.osgeo.org/metacrs/proj/trunk/proj/nad/ are >>> ASCII. In the nad directory, you need to do: >>> ./configure >>> make >

Re: [postgis-users] NAD conversion problem

2008-12-16 Thread Richard Greenwood
On Mon, Dec 8, 2008 at 6:08 PM, Dylan Beaudette wrote: >> Richard Greenwood wrote: >> The files in http://svn.osgeo.org/metacrs/proj/trunk/proj/nad/ are >> ASCII. In the nad directory, you need to do: >> ./configure >> make >> install >> to create the binary grid shift files that proj actual

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Dylan Beaudette
On Thursday 11 December 2008, Frank Warmerdam wrote: > Peter N. Schweitzer wrote: > > Dylan Beaudette wrote: > >> Looks close to the output from proj4 above. > >> > >> Thoughts? > > > > Dylan, > > > > Thanks for showing me how to check the calculations. I get identical > > results using my copies

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Peter N. Schweitzer
Frank Warmerdam wrote: Adding @null to the end essentially means that if all else fails, just apply a null transformation and don't complain if the null file isn't found. Frank, Thanks, I figured it was an escape hatch of sorts. What worried me was that the error message appeared, implying th

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Frank Warmerdam
Peter N. Schweitzer wrote: Dylan Beaudette wrote: Looks close to the output from proj4 above. Thoughts? Dylan, Thanks for showing me how to check the calculations. I get identical results using my copies of cs2cs and postgis, on both systems. I conclude from this that the effect of adding @

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Peter N. Schweitzer
Dylan Beaudette wrote: Looks close to the output from proj4 above. Thoughts? Dylan, Thanks for showing me how to check the calculations. I get identical results using my copies of cs2cs and postgis, on both systems. I conclude from this that the effect of adding @null to the definition of NA

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Dylan Beaudette
On Thursday 11 December 2008, Peter N. Schweitzer wrote: > Dylan Beaudette wrote: > > Strange. I have never modified that code before, and regularly get the > > correct output... I will post back with a similar example that causes > > PostGIS to throw the '-38' error. > > Dylan, > > Another corresp

Re: [postgis-users] NAD conversion problem

2008-12-11 Thread Peter N. Schweitzer
Dylan Beaudette wrote: Strange. I have never modified that code before, and regularly get the correct output... I will post back with a similar example that causes PostGIS to throw the '-38' error. Dylan, Another correspondent indicated to me that when he applied this change, he got different

Re: [postgis-users] NAD conversion problem

2008-12-10 Thread Dylan Beaudette
On Tuesday 09 December 2008, Peter N. Schweitzer wrote: > Richard Greenwood wrote: > > On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer > > > > <[EMAIL PROTECTED]> wrote: > >> Richard Greenwood wrote: > >>> On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer > >>> > >>> <[EMAIL PROTECTED]> wrot

Re: [postgis-users] NAD conversion problem

2008-12-09 Thread Peter N. Schweitzer
Richard Greenwood wrote: On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer <[EMAIL PROTECTED]> wrote: Richard Greenwood wrote: On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer <[EMAIL PROTECTED]> wrote: Hello, I have two PostgreSQL installations. One uses 8.3.3 with PostGIS 1.3.3, GEOS

Re: [postgis-users] NAD conversion problem

2008-12-08 Thread Dylan Beaudette
On Monday 08 December 2008, Richard Greenwood wrote: > On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer > > <[EMAIL PROTECTED]> wrote: > > Richard Greenwood wrote: > >> On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer > >> > >> <[EMAIL PROTECTED]> wrote: > >>> Hello, > >>> > >>> I have two P

Re: [postgis-users] NAD conversion problem

2008-12-08 Thread Richard Greenwood
On Mon, Dec 8, 2008 at 12:19 PM, Peter N. Schweitzer <[EMAIL PROTECTED]> wrote: > Richard Greenwood wrote: >> >> On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer >> <[EMAIL PROTECTED]> wrote: >>> >>> Hello, >>> >>> I have two PostgreSQL installations. One uses 8.3.3 with PostGIS 1.3.3, >>> GEOS

Re: [postgis-users] NAD conversion problem

2008-12-08 Thread Peter N. Schweitzer
Richard Greenwood wrote: On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer <[EMAIL PROTECTED]> wrote: Hello, I have two PostgreSQL installations. One uses 8.3.3 with PostGIS 1.3.3, GEOS 3.0.1, and PROJ 4.6.1 (with proj-datumgrid-1.4). With it I am able to run a command like update county s

Re: [postgis-users] NAD conversion problem

2008-12-05 Thread Richard Greenwood
On Thu, Dec 4, 2008 at 1:19 PM, Peter N. Schweitzer <[EMAIL PROTECTED]> wrote: > Hello, > > I have two PostgreSQL installations. One uses 8.3.3 with PostGIS 1.3.3, > GEOS 3.0.1, and PROJ 4.6.1 (with proj-datumgrid-1.4). With it I am able to > run a command like > > update county set nad27_geom=ST

[postgis-users] NAD conversion problem

2008-12-04 Thread Peter N. Schweitzer
Hello, I have two PostgreSQL installations. One uses 8.3.3 with PostGIS 1.3.3, GEOS 3.0.1, and PROJ 4.6.1 (with proj-datumgrid-1.4). With it I am able to run a command like update county set nad27_geom=ST_Transform(the_geom,4267); My newer installation uses 8.3.5 with PostGIS 1.3.4, GEOS 3.