PostGIS adds support for geographic objects to the PostgreSQL object-relational

database. In effect, PostGIS "spatially enables" the PostgreSQL server,
allowing it to be used as a backend spatial database for geographic information
systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
follows the OpenGIS "Simple Features Specification for SQL" and has been
certified as compliant with the "Types and Functions" profile.

PostGIS/PostgreSQL includes the following functionality:
* Simple Features as defined by the OpenGIS Consortium (OGC)
* Support for Well-Known Text and Well-Known Binary representations of GIS
  objects
* Fast spatial indexing using GiST
* Geospatial analysis functions
* PostgreSQL JDBC extension objects corresponding to the geometries
* Support for OGC access functions as defined by the Simple Features
  Specification

8 files changed, 267 insertions, 0 deletions

diff --git a/databases/postgresql-postgis/DESCR b/databases/postgresql-postgis/DESCR
new file mode 100644
index 00000000000..7533bf82849
--- /dev/null
+++ b/databases/postgresql-postgis/DESCR
@@ -0,0 +1,16 @@
+PostGIS adds support for geographic objects to the PostgreSQL object-relational
+database. In effect, PostGIS "spatially enables" the PostgreSQL server,
+allowing it to be used as a backend spatial database for geographic information
+systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
+follows the OpenGIS "Simple Features Specification for SQL" and has been
+certified as compliant with the "Types and Functions" profile.
+
+PostGIS/PostgreSQL includes the following functionality:
+* Simple Features as defined by the OpenGIS Consortium (OGC)
+* Support for Well-Known Text and Well-Known Binary representations of GIS
+  objects
+* Fast spatial indexing using GiST
+* Geospatial analysis functions
+* PostgreSQL JDBC extension objects corresponding to the geometries
+* Support for OGC access functions as defined by the Simple Features
+  Specification
diff --git a/databases/postgresql-postgis/Makefile b/databases/postgresql-postgis/Makefile
new file mode 100644
index 00000000000..bf374b9afca
--- /dev/null
+++ b/databases/postgresql-postgis/Makefile
@@ -0,0 +1,59 @@
+# $NetBSD: Makefile,v 1.1.1.1 2010/01/21 12:53:18 adam Exp $
+
+DISTNAME=	postgis-1.4.1
+PKGNAME=	postgresql${PGSQL_VERSION}-${DISTNAME}
+CATEGORIES=	databases geography
+MASTER_SITES=	http://postgis.refractions.net/download/
+
+MAINTAINER=	gdt@NetBSD.org
+HOMEPAGE=	http://postgis.refractions.net/
+COMMENT=	Spatial database capabilities for PostgreSQL
+
+LICENSE=	gnu-gpl-v2
+
+PKG_DESTDIR_SUPPORT=	user-destdir
+
+PGSQL_VERSIONS_ACCEPTED=	84 83
+
+DEPENDS+=		postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server
+
+CONFLICTS=		postgis-[0-9]*
+
+# gmake complains about adding + to parent rule
+MAKE_JOBS_SAFE=		no
+
+USE_LANGUAGES=		c c++
+USE_LIBTOOL=		yes
+USE_TOOLS+=		gmake lex pax perl
+GNU_CONFIGURE=		yes
+CONFIGURE_ARGS+=	--enable-rpath
+CONFIGURE_ARGS+=	--datadir=${PREFIX}/share/postgresql/contrib
+
+TEST_TARGET=		check
+
+DOCDIR=			${PREFIX}/share/doc/postgis
+
+SUBST_CLASSES+=		paths
+SUBST_FILES.paths=	extras/template_gis/profile \
+			extras/template_gis/createdb.postgis.1 \
+			extras/template_gis/mktemplate_gis.1 \
+			extras/template_gis/postgis_env.sh.in
+SUBST_VARS.paths+=	PKG_SYSCONFDIR
+SUBST_STAGE.paths=	pre-configure
+
+INSTALLATION_DIRS=	${DOCDIR} ${DOCDIR}/images ${PKGMANDIR}/man1
+
+post-install:
+	${LIBTOOL} --mode=install ${INSTALL_LIB} ${WRKSRC}/liblwgeom/liblwgeom.la ${DESTDIR}${PREFIX}/lib
+	${INSTALL_DATA} ${BUILD_DIRS:Q}/README.postgis ${DESTDIR}${DOCDIR}
+	${INSTALL_DATA} ${BUILD_DIRS:Q}/doc/html/postgis.html ${DESTDIR}${DOCDIR}
+	${INSTALL_DATA} ${BUILD_DIRS:Q}/doc/html/style.css ${DESTDIR}${DOCDIR}
+	${INSTALL_DATA} ${BUILD_DIRS:Q}/doc/html/images/* ${DESTDIR}${DOCDIR}/images
+	${INSTALL_DATA} ${BUILD_DIRS:Q}/postgis_comments.sql ${DESTDIR}${PREFIX}/share/postgresql/contrib
+	${INSTALL_MAN} ${BUILD_DIRS:Q}/doc/man/*.1 ${DESTDIR}${PREFIX}/${PKGMANDIR}/man1
+
+.include "../../geography/geos/buildlink3.mk"
+.include "../../misc/proj/buildlink3.mk"
+.include "../../mk/pgsql.buildlink3.mk"
+.include "../../mk/pthread.buildlink3.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql-postgis/PLIST b/databases/postgresql-postgis/PLIST
new file mode 100644
index 00000000000..e75cf331f67
--- /dev/null
+++ b/databases/postgresql-postgis/PLIST
@@ -0,0 +1,80 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2010/01/21 12:53:18 adam Exp $
+bin/pgsql2shp
+bin/shp2pgsql
+lib/liblwgeom.la
+lib/libpostgis-1.4.la
+man/man1/pgsql2shp.1
+man/man1/shp2pgsql.1
+share/doc/postgis/README.postgis
+share/doc/postgis/images/caution.png
+share/doc/postgis/images/check.png
+share/doc/postgis/images/important.png
+share/doc/postgis/images/note.png
+share/doc/postgis/images/st_buffer01.png
+share/doc/postgis/images/st_buffer02.png
+share/doc/postgis/images/st_buildarea01.png
+share/doc/postgis/images/st_buildarea02.png
+share/doc/postgis/images/st_centroid01.png
+share/doc/postgis/images/st_centroid02.png
+share/doc/postgis/images/st_centroid03.png
+share/doc/postgis/images/st_centroid04.png
+share/doc/postgis/images/st_contains01.png
+share/doc/postgis/images/st_contains02.png
+share/doc/postgis/images/st_contains03.png
+share/doc/postgis/images/st_contains04.png
+share/doc/postgis/images/st_contains05.png
+share/doc/postgis/images/st_contains06.png
+share/doc/postgis/images/st_convexhull01.png
+share/doc/postgis/images/st_crosses-math.gif
+share/doc/postgis/images/st_crosses01.gif
+share/doc/postgis/images/st_crosses01.png
+share/doc/postgis/images/st_crosses02.gif
+share/doc/postgis/images/st_crosses02.png
+share/doc/postgis/images/st_crosses03.gif
+share/doc/postgis/images/st_crosses03.png
+share/doc/postgis/images/st_crosses04.gif
+share/doc/postgis/images/st_crosses04.png
+share/doc/postgis/images/st_difference01.png
+share/doc/postgis/images/st_issimple01.png
+share/doc/postgis/images/st_issimple02.png
+share/doc/postgis/images/st_issimple03.png
+share/doc/postgis/images/st_issimple04.png
+share/doc/postgis/images/st_issimple05.png
+share/doc/postgis/images/st_issimple06.png
+share/doc/postgis/images/st_issimple07.png
+share/doc/postgis/images/st_isvalid01.png
+share/doc/postgis/images/st_isvalid02.png
+share/doc/postgis/images/st_isvalid03.png
+share/doc/postgis/images/st_isvalid04.png
+share/doc/postgis/images/st_isvalid05.png
+share/doc/postgis/images/st_isvalid06.png
+share/doc/postgis/images/st_isvalid07.png
+share/doc/postgis/images/st_isvalid08.png
+share/doc/postgis/images/st_line_interpolate_point01.png
+share/doc/postgis/images/st_line_substring01.png
+share/doc/postgis/images/st_linecrossingdirection01.png
+share/doc/postgis/images/st_linecrossingdirection02.png
+share/doc/postgis/images/st_linecrossingdirection03.png
+share/doc/postgis/images/st_linecrossingdirection04.png
+share/doc/postgis/images/st_minimumboundingcircle01.png
+share/doc/postgis/images/st_symdifference01.png
+share/doc/postgis/images/st_symdifference02.png
+share/doc/postgis/images/st_touches-math.gif
+share/doc/postgis/images/st_touches01.png
+share/doc/postgis/images/st_touches02.png
+share/doc/postgis/images/st_touches03.png
+share/doc/postgis/images/st_touches04.png
+share/doc/postgis/images/st_touches05.png
+share/doc/postgis/images/st_touches06.png
+share/doc/postgis/images/st_within01.png
+share/doc/postgis/images/tip.png
+share/doc/postgis/images/warning.png
+share/doc/postgis/postgis.html
+share/doc/postgis/style.css
+share/postgresql/contrib/postgis.sql
+share/postgresql/contrib/postgis_comments.sql
+share/postgresql/contrib/postgis_upgrade_12_to_14.sql
+share/postgresql/contrib/postgis_upgrade_13_to_14.sql
+share/postgresql/contrib/postgis_upgrade_14_minor.sql
+share/postgresql/contrib/spatial_ref_sys.sql
+share/postgresql/contrib/uninstall_postgis.sql
diff --git a/databases/postgresql-postgis/buildlink3.mk b/databases/postgresql-postgis/buildlink3.mk
new file mode 100644
index 00000000000..9b20e8dcd69
--- /dev/null
+++ b/databases/postgresql-postgis/buildlink3.mk
@@ -0,0 +1,16 @@
+# $NetBSD: buildlink3.mk,v 1.1.1.1 2010/01/21 12:53:19 adam Exp $
+
+BUILDLINK_TREE+=	postgresql-postgis
+
+.if !defined(POSTGRESQL_POSTGIS_BUILDLINK3_MK)
+POSTGRESQL_POSTGIS_BUILDLINK3_MK:=
+
+BUILDLINK_API_DEPENDS.postgresql-postgis+=	postgresql${PGSQL_VERSION}-postgis>=1.4
+BUILDLINK_PKGSRCDIR.postgresql-postgis?=	../../databases/postgresql-postgis
+
+.include "../../geography/geos/buildlink3.mk"
+.include "../../misc/proj/buildlink3.mk"
+.include "../../mk/pgsql.buildlink3.mk"
+.endif	# POSTGRESQL_POSTGIS_BUILDLINK3_MK
+
+BUILDLINK_TREE+=	-postgresql-postgis
diff --git a/databases/postgresql-postgis/distinfo b/databases/postgresql-postgis/distinfo
new file mode 100644
index 00000000000..a0cb5ab6075
--- /dev/null
+++ b/databases/postgresql-postgis/distinfo
@@ -0,0 +1,8 @@
+$NetBSD: distinfo,v 1.1.1.1 2010/01/21 12:53:18 adam Exp $
+
+SHA1 (postgis-1.4.1.tar.gz) = e30062d6e38f787374866a6f4bc2920e032bc0e7
+RMD160 (postgis-1.4.1.tar.gz) = 5c4b23dc4139297cbff03b023643bddd20183bfa
+Size (postgis-1.4.1.tar.gz) = 3273182 bytes
+SHA1 (patch-aa) = a33884dc72985b3ddc4f95072a352b8ff895eb59
+SHA1 (patch-ab) = 6c85596f0c7043e3c2dfb1be22c78c15c9da014d
+SHA1 (patch-ac) = 6783cf54b07286b5e9ae88fef8c10a51b213f626
diff --git a/databases/postgresql-postgis/patches/patch-aa b/databases/postgresql-postgis/patches/patch-aa
new file mode 100644
index 00000000000..e970a0338ec
--- /dev/null
+++ b/databases/postgresql-postgis/patches/patch-aa
@@ -0,0 +1,22 @@
+$NetBSD: patch-aa,v 1.1.1.1 2010/01/21 12:53:19 adam Exp $
+
+--- postgis/Makefile.in.orig	2009-11-13 22:26:00.000000000 +0000
++++ postgis/Makefile.in
+@@ -60,7 +60,7 @@ OBJS=$(PG_OBJS)
+ # older version of PostGIS, rather than with the static liblwgeom.a 
+ # supplied with newer versions of PostGIS
+ PG_CPPFLAGS+=@CPPFLAGS@ -I../liblwgeom
+-SHLIB_LINK+=@SHLIB_LINK@ ../liblwgeom/liblwgeom.a
++SHLIB_LINK+=@SHLIB_LINK@ ../liblwgeom/liblwgeom.la
+ 
+ # Extra files to remove during 'make clean'
+ EXTRA_CLEAN=$(SQL_OBJS)
+@@ -73,7 +73,7 @@ include $(PGXS)
+ 
+ # Borrow the $libdir substitution from PGXS but customise by adding the version number
+ %.sql: %.sql.in
+-	sed 's,MODULE_PATHNAME,$$libdir/$*-@POSTGIS_MAJOR_VERSION@.@POSTGIS_MINOR_VERSION@,g' $< >$@
++	sed 's,MODULE_PATHNAME,$$libdir/../lib$*-@POSTGIS_MAJOR_VERSION@.@POSTGIS_MINOR_VERSION@,g' $< >$@
+ 
+ postgis_upgrade_14_minor.sql: postgis.sql
+ 	$(PERL) ../utils/postgis_proc_upgrade.pl $< 1.4 > $@
diff --git a/databases/postgresql-postgis/patches/patch-ab b/databases/postgresql-postgis/patches/patch-ab
new file mode 100644
index 00000000000..831b04ed64a
--- /dev/null
+++ b/databases/postgresql-postgis/patches/patch-ab
@@ -0,0 +1,29 @@
+$NetBSD: patch-ab,v 1.1.1.1 2010/01/21 12:53:19 adam Exp $
+
+--- liblwgeom/Makefile.in.orig	2009-01-13 12:27:39.000000000 +0000
++++ liblwgeom/Makefile.in
+@@ -48,10 +48,12 @@ SA_HEADERS = \
+ 	liblwgeom.h \
+ 	lwalgorithm.h
+ 
+-all: liblwgeom.a
++all: liblwgeom.la
+ 
+-liblwgeom.a: $(SA_OBJS) $(SA_HEADERS) 
+-	ar rs liblwgeom.a $(SA_OBJS) 	
++liblwgeom.la: $(SA_OBJS) $(SA_HEADERS) 
++	${LIBTOOL} --mode=link ${CC} -o liblwgeom.la \
++		${SA_OBJS:.o=.lo} -rpath ${PREFIX}/lib \
++		-version-info @POSTGIS_MAJOR_VERSION@:@POSTGIS_MINOR_VERSION@
+ 
+ clean:
+ 	rm -f $(SA_OBJS) 
+@@ -62,7 +64,7 @@ check: liblwgeom.a
+ 
+ # Command to build each of the .o files
+ $(SA_OBJS): %.o: %.c 
+-	$(CC) $(CFLAGS) -c -o $@ $<
++	${LIBTOOL} --mode=compile $(CC) $(CFLAGS) -c -o $@ $<
+ 
+ # Commands to generate the lexer and parser from input files
+ wktparse.tab.c: wktparse.y
diff --git a/databases/postgresql-postgis/patches/patch-ac b/databases/postgresql-postgis/patches/patch-ac
new file mode 100644
index 00000000000..2a40b64741f
--- /dev/null
+++ b/databases/postgresql-postgis/patches/patch-ac
@@ -0,0 +1,37 @@
+$NetBSD: patch-ac,v 1.1.1.1 2010/01/21 12:53:19 adam Exp $
+
+--- loader/Makefile.in.orig	2009-10-06 08:51:49.000000000 +0000
++++ loader/Makefile.in
+@@ -39,7 +39,7 @@ PGSQL_FE_LDFLAGS=@PGSQL_FE_LDFLAGS@
+ ICONV_LDFLAGS=@ICONV_LDFLAGS@
+ 
+ # liblwgeom
+-LIBLWGEOM=../liblwgeom/liblwgeom.a
++LIBLWGEOM=../liblwgeom/liblwgeom.la
+ 
+ # GTK includes and libraries
+ GTK_CFLAGS = @GTK_CFLAGS@
+@@ -60,10 +60,10 @@ pgsql2shp.o: pgsql2shp.c
+ 	$(CC) $(CFLAGS) $(PGSQL_FE_CPPFLAGS) -c $<
+ 
+ $(PGSQL2SHP): shpopen.o dbfopen.o getopt.o pgsql2shp.o $(LIBLWGEOM) 
+-	$(CC) $(CFLAGS) $^ $(ICONV_LDFLAGS) $(PGSQL_FE_LDFLAGS) -lm -o $@ 
++	${LIBTOOL} --mode=link $(CC) $(CFLAGS) $^ $(ICONV_LDFLAGS) $(PGSQL_FE_LDFLAGS) -lm -o $@ 
+ 
+ $(SHP2PGSQL): shpopen.o dbfopen.o getopt.o  shp2pgsql.o $(LIBLWGEOM) 
+-	$(CC) $(CFLAGS) $^ $(ICONV_LDFLAGS) -lm -o $@ 
++	${LIBTOOL} --mode=link $(CC) $(CFLAGS) $^ $(ICONV_LDFLAGS) -lm -o $@ 
+ 
+ shp2pgsql-core-gui.o: shp2pgsql-core.c
+ 	$(CC) $(CFLAGS) -DPGUI -c -o $@ $^
+@@ -79,8 +79,8 @@ $(SHP2PGSQL-CLI): stringbuffer.o shpopen
+ 
+ install: all
+ 	@mkdir -p $(DESTDIR)$(bindir)
+-	$(INSTALL) $(PGSQL2SHP) $(DESTDIR)$(bindir)
+-	$(INSTALL) $(SHP2PGSQL) $(DESTDIR)$(bindir)
++	${LIBTOOL} --mode=install ${BSD_INSTALL_PROGRAM} $(PGSQL2SHP) $(DESTDIR)$(bindir)
++	${LIBTOOL} --mode=install ${BSD_INSTALL_PROGRAM} $(SHP2PGSQL) $(DESTDIR)$(bindir)
+ 
+ uninstall:
+ 	@rm -f $(DESTDIR)$(bindir)/$(PGSQL2SHP)