From e13f4e2173e6b497a409d2dff816d93cb0de3476 Mon Sep 17 00:00:00 2001 From: gdt Date: Wed, 16 Aug 2006 14:37:21 +0000 Subject: This package provides a database of geodetic parameters in a form suitable for loading into mysql or PostgreSQL. From Brook Milligan via pkgsrc-wip. --- geography/epsg/DESCR | 22 ++++++++++++++++++ geography/epsg/MESSAGE | 29 +++++++++++++++++++++++ geography/epsg/Makefile | 61 +++++++++++++++++++++++++++++++++++++++++++++++++ geography/epsg/PLIST | 12 ++++++++++ geography/epsg/distinfo | 14 ++++++++++++ 5 files changed, 138 insertions(+) create mode 100644 geography/epsg/DESCR create mode 100644 geography/epsg/MESSAGE create mode 100644 geography/epsg/Makefile create mode 100644 geography/epsg/PLIST create mode 100644 geography/epsg/distinfo (limited to 'geography') diff --git a/geography/epsg/DESCR b/geography/epsg/DESCR new file mode 100644 index 00000000000..060c652402d --- /dev/null +++ b/geography/epsg/DESCR @@ -0,0 +1,22 @@ +EPSG Geodetic Parameters + +The OGP Surveying and Positioning Committee, through its geodesy +sub-committee, maintains and publishes a dataset of parameters for +coordinate reference system and coordinate transformation description. +The EPSG Geodetic Parameter Dataset has been included as reference +data in UKOOA and SEG positioning data exchange formats, the GeoTIFF +interchange format for georeferenced raster imagery, the IHS Energy +Iris21, PPDM and POSC Epicentre data models. The dataset is +distributed in an MS Access relational database and SQL script files. + +This current release (Version 6.11) of the EPSG Geodetic Parameter +Dataset comprises of data updates to the v6.10 release of April 2006. +It also replaces interim releases v6.10.1 of May 2006 and v6.10.2 of +June 2006 which included updates to the SQL scripts accompanying the +v6.10 release. The EPSG Geodetic Parameter Dataset, or EPSG dataset, +is maintained by the Geodesy Subcommittee of the Surveying and +Positioning Committee of the International Association of Oil and Gas +Producers (OGP). + +This package includes the PostgreSQL and mySQL scripts for creating +the EPSG database. diff --git a/geography/epsg/MESSAGE b/geography/epsg/MESSAGE new file mode 100644 index 00000000000..ab84ab26a52 --- /dev/null +++ b/geography/epsg/MESSAGE @@ -0,0 +1,29 @@ +=========================================================================== +$NetBSD: MESSAGE,v 1.1.1.1 2006/08/16 14:37:21 gdt Exp $ + +You need to install the EPSG data into a relational database. The +data files are installed in ${EPSGDIR}. Suitable commands +are (assuming ${EPSGDB} refers to the target database). + +For PostgreSQL: + cd ${EPSGDIR} + psql -f EPSG_v6_11.mdb_Tables_PostgreSQL.sql ${EPSGDB} + psql -f EPSG_v6_11.mdb_Data_PostgreSQL.sql ${EPSGDB} + psql -f EPSG_v6_11.mdb_FKeys_PostgreSQL.sql ${EPSGDB} + +For MySQL: + cd ${EPSGDIR} + mysql -f EPSG_v6_11.mdb_Tables_MySQL.sql ${EPSGDB} + mysql -f EPSG_v6_11.mdb_Data_MySQL.sql ${EPSGDB} + mysql -f EPSG_v6_11.mdb_FKeys_MySQL.sql ${EPSGDB} + +See the following two documents, which are located in ${DOCDIR}, +for a complete description. + + Using the EPSG Geodetic Parameter Dataset (Surveying and + Positioning Guidance Note Number 7, part 1) + + Coordinate Conversions and Transformations including Formulas + (Surveying and Positioning Guidance Note Number 7, part 2) + +=========================================================================== diff --git a/geography/epsg/Makefile b/geography/epsg/Makefile new file mode 100644 index 00000000000..2a9ab1c4032 --- /dev/null +++ b/geography/epsg/Makefile @@ -0,0 +1,61 @@ +# $NetBSD: Makefile,v 1.1.1.1 2006/08/16 14:37:21 gdt Exp $ +# + +DISTNAME= epsg-v6_11sql-PostgreSQL +PKGNAME= epsg-6.11 +CATEGORIES= geography databases +MASTER_SITES+= http://www.epsg.org/databases/ \ + http://www.epsg.org/guides/docs/ +DISTFILES+= epsg-v6_11sql-PostgreSQL.zip \ + epsg-v6_11sql-mySQL.zip \ + G7-1.pdf G7-2.pdf +EXTRACT_ONLY= epsg-v6_11sql-PostgreSQL.zip \ + epsg-v6_11sql-mySQL.zip +DIST_SUBDIR= epsg-6.11 + +MAINTAINER= brook@nmsu.edu +HOMEPAGE= http://www.epsg.org/ +COMMENT= EPSG Geodetic Parameters database + +LICENSE= epsg-license +RESTRICTED= No commercial redistribution +NO_SRC_ON_CDROM= ${RESTRICTED} +NO_BIN_ON_CDROM= ${RESTRICTED} + +WRKSRC= ${WRKDIR}/epsg-v6_11sql-postgresql +WRKSRC.pgsql= ${WRKDIR}/epsg-v6_11sql-PostgreSQL +WRKSRC.mysql= ${WRKDIR}/epsg-v6_11sql-mySQL + +NO_BUILD= yes + +DOCDIR= ${PREFIX}/share/doc/epsg +EPSGDIR= ${PREFIX}/share/epsg + +MESSAGE_SUBST+= DOCDIR=${DOCDIR:Q} +MESSAGE_SUBST+= EPSGDIR=${EPSGDIR:Q} + +DATAFILES.pgsql+= EPSG_v6_11.mdb_Data_PostgreSQL.sql +DATAFILES.pgsql+= EPSG_v6_11.mdb_FKeys_PostgreSQL.sql +DATAFILES.pgsql+= EPSG_v6_11.mdb_Tables_PostgreSQL.sql + +DATAFILES.mysql+= EPSG_v6_11.mdb_Data_MySQL.sql +DATAFILES.mysql+= EPSG_v6_11.mdb_FKeys_MySQL.sql +DATAFILES.mysql+= EPSG_v6_11.mdb_Tables_MySQL.sql + +post-extract: + ${CP} ${_DISTDIR}/G7-1.pdf ${WRKSRC} + ${CP} ${_DISTDIR}/G7-2.pdf ${WRKSRC} + +do-install: + ${INSTALL_DATA_DIR} ${EPSGDIR} + ${INSTALL_DATA_DIR} ${DOCDIR} + ${INSTALL_DATA} ${WRKSRC}/G7-1.pdf ${DOCDIR:Q} + ${INSTALL_DATA} ${WRKSRC}/G7-2.pdf ${DOCDIR:Q} + ${INSTALL_DATA} ${WRKSRC}/epsg-v6_11-readme.pdf ${DOCDIR:Q} +.for d in pgsql mysql +.for f in ${DATAFILES.${d}} + ${INSTALL_DATA} ${WRKSRC.${d}}/${f} ${EPSGDIR:Q}/${f} +.endfor +.endfor + +.include "../../mk/bsd.pkg.mk" diff --git a/geography/epsg/PLIST b/geography/epsg/PLIST new file mode 100644 index 00000000000..aa24f5b3207 --- /dev/null +++ b/geography/epsg/PLIST @@ -0,0 +1,12 @@ +@comment $NetBSD: PLIST,v 1.1.1.1 2006/08/16 14:37:21 gdt Exp $ +share/doc/epsg/G7-1.pdf +share/doc/epsg/G7-2.pdf +share/doc/epsg/epsg-v6_11-readme.pdf +share/epsg/EPSG_v6_11.mdb_Data_MySQL.sql +share/epsg/EPSG_v6_11.mdb_Data_PostgreSQL.sql +share/epsg/EPSG_v6_11.mdb_FKeys_MySQL.sql +share/epsg/EPSG_v6_11.mdb_FKeys_PostgreSQL.sql +share/epsg/EPSG_v6_11.mdb_Tables_MySQL.sql +share/epsg/EPSG_v6_11.mdb_Tables_PostgreSQL.sql +@dirrm share/epsg +@dirrm share/doc/epsg diff --git a/geography/epsg/distinfo b/geography/epsg/distinfo new file mode 100644 index 00000000000..a963da482c1 --- /dev/null +++ b/geography/epsg/distinfo @@ -0,0 +1,14 @@ +$NetBSD: distinfo,v 1.1.1.1 2006/08/16 14:37:21 gdt Exp $ + +SHA1 (epsg-6.11/epsg-v6_11sql-PostgreSQL.zip) = 4c3733da69b9ca59ba76483f656cea8333428df1 +RMD160 (epsg-6.11/epsg-v6_11sql-PostgreSQL.zip) = 1359739ebb2bfce4ed09be38c93a80ae5f51cca5 +Size (epsg-6.11/epsg-v6_11sql-PostgreSQL.zip) = 1082987 bytes +SHA1 (epsg-6.11/epsg-v6_11sql-mySQL.zip) = 9aea90ac8d7c0e9715735625fd57f4754dbbdabe +RMD160 (epsg-6.11/epsg-v6_11sql-mySQL.zip) = 4247d8c7b0d10a2fa67c60b1a46483c64b5d9b5b +Size (epsg-6.11/epsg-v6_11sql-mySQL.zip) = 1083069 bytes +SHA1 (epsg-6.11/G7-1.pdf) = fdf31f6d4fe534011e62a1498d8b054bb1fd1025 +RMD160 (epsg-6.11/G7-1.pdf) = f331d158d241b128a2b9e1d2a63c06c0f6ae855c +Size (epsg-6.11/G7-1.pdf) = 831907 bytes +SHA1 (epsg-6.11/G7-2.pdf) = 3fcd4d6d9f028716a27ea4f40b43e9c3f016cb32 +RMD160 (epsg-6.11/G7-2.pdf) = 06620849762a5b1419487850272fa7fe809d849f +Size (epsg-6.11/G7-2.pdf) = 954725 bytes -- cgit v1.2.3