This package provides a database of geodetic parameters in a form

suitable for loading into mysql or PostgreSQL.

From Brook Milligan via pkgsrc-wip.

5 files changed, 138 insertions, 0 deletions

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