Gerald Evenden gerald.evenden at verizon.net
Tue Feb 17 15:06:10 EST 2004

While doing the finishing tests for PJ_omerc I looked into the EPSG_v65
data base for some info, especially for Malaya.  Spent the weekend 
perl, installed the db into MySQL and everything looked rosy in spite of
weak EPSG documentation.

My question to anyone familiar with this relational data base is how to 
an ellipsoid to a projection given a place name like Malaya?  I can 
find the projection associated with the area but no link to the 
tables.  Similarly, I can go into the coordinate reference system table
but links to datum code or ellipsoid are NULL.

What I would like to do, and this seems reasonable, is key in an area
name, do a REGEXP search of char field in appropriate table and come
up with a list of ellipsoids used in that area and a list of grid 
cartographic projections.
For datum shifters, that information should be available also with the 
basic search method.  That's probably too naïve an expectation.

These problems are the same for Borneo as well.

It is a nifty way to handle information on non-ellipsoid projection 
and would seem like a useful method to use with a proj parameter DB.

Comments appreciated, including guffaws.
Jerry and the low riders: Daisy Mae and Joshua
PROJ.4 Discussion List
See http://www.remotesensing.org/proj for subscription, unsubscription
and other information.

More information about the Proj mailing list