[Proj] EPSG and ToWGS84

[Paul Selormey]

Hello Markus Neteler and All,
The SQL statement could not solve my problem. I have adapted it
for the Microsoft Access.

What I really need is the Bursa Wolf transformation parameters
for a datum, normally formatted in WKT as

TOWGS84[Dx, Dy, Dz, Ex, Ey, Ez, PPm]

I am trying to retrieve datum values from the EPSG database
but could not find the Bursa Wolf transformation parameters.
(Sorry, if my earlier post was not clear enough).

Best regards,
Paul.


----- Original Message ----- 
From: "Paul Selormey" <paul at toolscenter.org>
To: <proj at remotesensing.org>
Sent: Wednesday, April 21, 2004 7:21 AM
Subject: Re: [Proj] EPSG and ToWGS84


> Thanks so much. I will study it today and see how to make
> maximum use of it.
> 
> Best regards,
> Paul.
> 
> ----- Original Message ----- 
> From: "Markus Neteler" <neteler at itc.it>
> To: <proj at remotesensing.org>
> Sent: Wednesday, April 21, 2004 1:04 AM
> Subject: Re: [Proj] EPSG and ToWGS84
> 
> 
> > On Tue, Apr 20, 2004 at 01:59:21PM +0900, proj-admin at remotesensing.org
> wrote:
> > > Hello All,
> > > Please can anyone help me find the ToWGS84 values for a datum in
> > > the EPSG database?
> > >
> > > I have being playing with the EPSG database but still could not find
> > > the ToWGS84 parameters anywhere!
> >
> > The SQL query should be something like this (I received this
> > SQL statement from an EPSG team member):
> >
> > SELECT o.coord_op_name, m.coord_op_method_name, p.parameter_name,
> > pu.sort_order, pv.parameter_value, u.unit_of_meas_name, a.area_name
> > FROM epsg_coordoperation o
> > JOIN epsg_coordoperationmethod m
> > ON m.coord_op_method_code = o.coord_op_method_code
> > JOIN epsg_coordoperationparamvalue pv
> > ON pv.coord_op_method_code = o.coord_op_method_code AND
> > pv.coord_op_code = o.coord_op_code
> > JOIN epsg_coordoperationparamusage pu
> > ON pu.coord_op_method_code = o.coord_op_method_Code AND
> > pu.parameter_code = pv.parameter_code
> > JOIN epsg_coordoperationparam p
> > ON p.parameter_code = pv.parameter_code
> > JOIN epsg_unitofmeasure u
> > ON u.uom_code = pv.uom_code
> > JOIN epsg_area a
> > ON a.area_code = o.area_of_use_code
> > WHERE o.coord_op_type = 'transformation' AND o.coord_op_name
> > LIKE '%WGS 84%' AND o.deprecated = 0
> > ORDER BY coord_op_name;
> >
> > Best regards,
> >
> >  Markus
> >
> > _______________________________________________
> > Proj mailing list
> > Proj at remotesensing.org
> > http://www.remotesensing.org/mailman/listinfo/proj
> >
> >
> 
> 
> _______________________________________________
> Proj mailing list
> Proj at remotesensing.org
> http://www.remotesensing.org/mailman/listinfo/proj
> 
>