notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Ukraine
FreshPorts needs to find a new hosting provide willing to take a 2U chassis and host it free of charge. This is part of the FreshPorts project. Preferably in the Austin area. This is not a primary server, but it used for development.
Port details
spatialite Spatial Extensions for SQLite
5.0.1_2 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Version of this port present on the latest quarterly branch.
Maintainer: lbartoletti@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2008-07-18 12:44:22
Last Update: 2022-07-20 14:21:07
Commit Hash: d076ad9
People watching this port, also watch:: xerces-c3, py39-pycparser, ladspa, gstreamer1-plugins-pango, libkvkontakte
Also Listed In: geography
License: GPLv2
Description:
SVNWeb : git : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (44 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/spatialite-5.0.1_2/catalog.mk
  3. /usr/local/share/licenses/spatialite-5.0.1_2/LICENSE
  4. /usr/local/share/licenses/spatialite-5.0.1_2/GPLv2
  5. include/spatialite.h
  6. include/spatialite/control_points.h
  7. include/spatialite/debug.h
  8. include/spatialite/gaia_network.h
  9. include/spatialite/gaia_topology.h
  10. include/spatialite/gaiaaux.h
  11. include/spatialite/gaiaconfig-msvc.h
  12. include/spatialite/gaiaconfig-msvc.h.in
  13. include/spatialite/gaiaconfig.h
  14. include/spatialite/gaiaconfig.h.in
  15. include/spatialite/gaiaexif.h
  16. include/spatialite/gaiageo.h
  17. include/spatialite/gaiamatrix.h
  18. include/spatialite/geojson.h
  19. include/spatialite/geopackage.h
  20. include/spatialite/gg_advanced.h
  21. include/spatialite/gg_const.h
  22. include/spatialite/gg_core.h
  23. include/spatialite/gg_dxf.h
  24. include/spatialite/gg_dynamic.h
  25. include/spatialite/gg_formats.h
  26. include/spatialite/gg_mbr.h
  27. include/spatialite/gg_sequence.h
  28. include/spatialite/gg_structs.h
  29. include/spatialite/gg_wfs.h
  30. include/spatialite/gg_xml.h
  31. include/spatialite/spatialite_ext.h
  32. include/spatialite/sqlite.h
  33. include/spatialite/stored_procedures.h
  34. lib/libspatialite.a
  35. lib/libspatialite.so
  36. lib/libspatialite.so.7
  37. lib/libspatialite.so.7.1.2
  38. lib/mod_spatialite.so
  39. lib/mod_spatialite.so.7
  40. lib/mod_spatialite.so.7.1.1
  41. libdata/pkgconfig/spatialite.pc
  42. @owner
  43. @group
  44. @mode
Collapse this list.
Dependency lines:
  • spatialite>0:databases/spatialite
To install the port:
cd /usr/ports/databases/spatialite/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/spatialite
  • pkg install spatialite
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: spatialite
Flavors: there is no flavor information for this port.
distinfo:
Packages (timestamps in pop-ups are UTC):
spatialite
ABIlatestquarterly
FreeBSD:11:aarch644.3.04.3.0_1
FreeBSD:11:amd645.0.15.0.1
FreeBSD:11:armv64.3.0-
FreeBSD:11:i3865.0.15.0.1
FreeBSD:11:mips--
FreeBSD:11:mips644.3.0-
FreeBSD:12:aarch644.3.05.0.1_2
FreeBSD:12:amd645.0.1_25.0.1_2
FreeBSD:12:armv64.3.0-
FreeBSD:12:armv74.3.0-
FreeBSD:12:i3865.0.1_25.0.1_2
FreeBSD:12:mips--
FreeBSD:12:mips644.3.0-
FreeBSD:12:powerpc64-5.0.0_2
FreeBSD:13:aarch645.0.1_25.0.1_2
FreeBSD:13:amd645.0.1_25.0.1_2
FreeBSD:13:armv6-5.0.1_2
FreeBSD:13:armv75.0.1_25.0.1_2
FreeBSD:13:i3865.0.1_25.0.1_2
FreeBSD:13:mips--
FreeBSD:13:mips64--
FreeBSD:13:powerpc645.0.0_25.0.1
FreeBSD:14:aarch645.0.1_2-
FreeBSD:14:amd645.0.1_2-
FreeBSD:14:armv65.0.1_2-
FreeBSD:14:armv75.0.1_2-
FreeBSD:14:i3865.0.1_2-
FreeBSD:14:mips--
FreeBSD:14:mips64--
FreeBSD:14:powerpc645.0.0_2-
 

Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.3 : devel/gmake
  2. pkgconf>=1.3.0_1 : devel/pkgconf
Library dependencies:
  1. libgeos_c.so : graphics/geos
  2. libproj.so : graphics/proj
  3. libfreexl.so : textproc/freexl
  4. librttopo.so : devel/librttopo
  5. libxml2.so : textproc/libxml2
  6. libminizip.so : archivers/minizip
  7. libsqlite3.so : databases/sqlite3
This port is required by:
for Libraries
  1. databases/spatialite-tools
  2. databases/spatialite_gui
  3. graphics/gdal
  4. graphics/librasterlite2
  5. graphics/qgis
  6. graphics/qgis-ltr

Deleted ports which required this port:

Expand this list of 3 deleted ports
  1. databases/pyspatialite*
  2. graphics/librasterlite*
  3. graphics/libreatlas*
  4. Collapse this list of deleted ports.
* - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

Configuration Options:
Options name:

USES:

FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. http://www.gaia-gis.it/gaia-sins/libspatialite-sources/
Collapse this list.

Number of commits found: 56

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
20 Jul 2022 14:21:07
 files touched by this commit commit hash:d076ad94e206dda108061fe99ddb860d93cc6d16  5.0.1_2
Tobias C. Berner (tcberner) search for other commits by this committer
databases: remove 'Created by' lines

A big Thank You to the original contributors of these ports:

  *  "Choe, Cheng-Dae" whitekid
  *  "Mahdi Mokhtari <mokhi64@gmail.com>"
  *  "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
  *  <hvo.pm@xs4all.nl>
  *  <jsmith@resonatingmedia.com>
  *  <ports@c0decafe.net>
  *  Aaron Dalton <aaron@FreeBSD.org>
  *  Adam Weinberger <adamw@FreeBSD.org>
  *  Ade Lovett <ade@FreeBSD.org>
  *  Akinori MUSHA aka knu <knu@idaemons.org>
  *  Alan Snelson <Alan@Wave2.org>
(Only the first 15 lines of the commit message are shown above View all of this commit message)
10 Apr 2022 19:11:41
 files touched by this commit commit hash:d63665f7cd9c99880704a3c5bc221829cb009744  5.0.1_2
Charlie Li (vishwin) search for other commits by this committer
textproc/libxml2: bump all LIB_DEPENDS consumers

This is a separate commit to facilitate easier cherry-picking for
quarterly.

PR: 262853, 262940, 262877, 263126
Approved by: fluffy (mentor)
26 Mar 2022 08:27:27
 files touched by this commit commit hash:247c7db7513f1264922428278678da641c5a3f52  5.0.1_1
Matthias Fechner (mfechner) search for other commits by this committer
textproc/libxml2: bump all dependencies

This should make sure that all dependent ports will pick
up the new version commited with a13ec21cd733f67a9fc0dc00ab45268bdc236246
25 Jan 2022 06:35:22
 files touched by this commit commit hash:45ab80b9df9f54bd40b1d19e18bb9a3e76a2a33c  5.0.1
Loïc Bartoletti (lbartoletti) search for other commits by this committer
archivers/minizip*: Add minizip-ng and zlib-ng and create USES=minizip

Import minizip-ng and zlib-ng

Minizip was originally developed in 1998. It was first included in the zlib
distribution as an additional code contribution starting in zlib 1.1.2. Since
that time, it has been continually improved upon and contributed to by many
people.

+ Creating and extracting zip archives.
+ Adding and removing entries from zip archives.
+ Read and write raw zip entry data.
+ Reading and writing zip archives from memory.
+ Zlib, BZIP2, LZMA, and ZSTD compression methods.
+ Password protection through Traditional PKWARE and WinZIP AES encryption.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
19 Apr 2021 16:54:48
 files touched by this commit commit hash:804841a56e74c490f164220aa351d7ea7a0d567d  5.0.1
Loïc Bartoletti (lbartoletti) search for other commits by this committer
databases/spatialite and databases/spatialite-tools: Update to 5.0.1
06 Apr 2021 14:31:07
 files touched by this commit commit hash:305f148f482daf30dcf728039d03d019f88344eb  5.0.0_2
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
18 Nov 2020 05:27:29
Original commit files touched by this commit Revision:555622  5.0.0_2
lbartoletti search for other commits by this committer
graphics/proj: Update to 7.2.0

Changelog:
  - https://proj.org/news.html#release-notes
17 Nov 2020 09:23:59
Original commit files touched by this commit Revision:555543  5.0.0_1
lbartoletti search for other commits by this committer
graphics/proj: Update to 7.1.1

- Add a pkg-message explaining how to access or sync datum grids from the CDN
  (disabled by default)
- Add curl and tiff dependencies since proj can read datum grids from remote
  COG (Cloud Optimized Geotiff)
- Take maintainer'ship (ok wen@)

PR:		245611
Submitted by:	wen (first version)
Reviewed by:	wen, rhurlin
Approved by:	wen
Exp-run by:	antoine
23 Oct 2020 19:47:21
Original commit files touched by this commit Revision:553135  5.0.0
lbartoletti search for other commits by this committer
databases/spatialite: fix soname

I forgot to add this patch.

Reported by:	rhurlin
23 Oct 2020 16:27:08
Original commit files touched by this commit Revision:553111  5.0.0
lbartoletti search for other commits by this committer
databases/spatialite: Update to 5.0.0

- Add dependency on archivers/minizip and devel/librttopo.
- Remove postgis (lwgeom) dependency
- Fix license to GPLv2
14 Jan 2020 21:45:15
Original commit files touched by this commit Revision:523070  4.3.0_1
lbartoletti search for other commits by this committer
Change my mail address to lbartoletti@FreeBSD.org

Approved by:	tcberner (mentor)
Differential Revision:	https://reviews.freebsd.org/D23169
08 Nov 2019 09:37:30
Original commit files touched by this commit Revision:517042  4.3.0_1
tobik search for other commits by this committer
databases: Add missing USES={gnome,php}
27 Jun 2019 03:37:11
Original commit files touched by this commit Revision:505194  4.3.0_1
wen search for other commits by this committer
- Update to 6.1.0 and fix some ports
- Add missing DEPENDS
- Add TEST_TARGET
- Take maintainership

PR:		237932, 238795
Submitted by:	wenheping2000@hotmail.com,rhurlin@gwdg.de
Approved by:	maintainer(timeout, > 30 days), portmgr@(implicit, fix build)
Exp-run by:	antoine@
Thanks to:	antoine@, sunpoet@, rhurlin@gwdg.de
16 Jun 2019 08:56:03
Original commit files touched by this commit Revision:504284  4.3.0
rene search for other commits by this committer
databases/spatialite: bump optional PostGIS dependency from expired 2.1 to 2.3

Event:	Berlin hackathon 2019
04 Nov 2017 11:43:35
Original commit files touched by this commit Revision:453453  4.3.0
dbaio search for other commits by this committer
Update license of ports using MPL (without version)

All ports now should use MPL[10|11|20] license.

Approved by:	portmgr (blanket)
10 Jun 2017 14:54:35
Original commit files touched by this commit Revision:443096  4.3.0
dbaio search for other commits by this committer
Update maintainer email address

Ownership of the former email address confirmed by email

PR:		219791
Submitted by:	lbartoletti@tuxfamily.org (maintainer)
Approved by:	garga (mentor)
Differential Revision:	https://reviews.freebsd.org/D11088
25 May 2016 15:43:34
Original commit files touched by this commit Revision:415839  4.3.0
mat search for other commits by this committer
Remove useless WRKSRC definitions.

While there, correct DEV_WARNINGS when they occur.

Sponsored by:	Absolight
19 May 2016 10:21:25
Original commit files touched by this commit Revision:415498  4.3.0
amdmi3 search for other commits by this committer
- Fix trailing whitespace in pkg-descrs, categories [a-f]*

Approved by:	portmgr blanket
25 Apr 2016 16:13:39
Original commit files touched by this commit Revision:414014  4.3.0
mat search for other commits by this committer
Remove USE_SQLITE from bsd.databases.mk, replaced by USES=sqlite.

While there replace USE_SQLITE=x by USES=sqlite:x.

PR:		208971
Submitted by:	mat
Exp-run by:	antoine
With hat:	portmgr
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D5951
25 Apr 2016 09:12:10
Original commit files touched by this commit Revision:413991  4.3.0
sunpoet search for other commits by this committer
- Update WWW

PR:		208936
Submitted by:	Hans <j3377622@trbvm.com>
Approved by:	portmgr (blanket)
01 Apr 2016 14:00:57
Original commit files touched by this commit Revision:412346  4.3.0
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
16 Dec 2015 23:22:15
Original commit files touched by this commit Revision:403879  4.3.0
marino search for other commits by this committer
databases/spatialite: fix MASTERSITE to unbreak

The home site just reorganized; it's still hosting the distfile.
12 Dec 2015 23:02:03
Original commit files touched by this commit Revision:403636  4.3.0
bapt search for other commits by this committer
Mark as broken: does not fetch
20 Sep 2015 14:35:58
Original commit files touched by this commit Revision:397374  4.3.0
danfe search for other commits by this committer
Remove BROKEN on Tier-2 systems statements which no longer true at least
on PowerPC (verified for all of them) and some also on SPARC (whenever I
was able to test those on flame.freebsd.org) and even IA64 (which should
be OK to remove anyways, because it was never really supported system in
ports land and was officially killed in -CURRENT a while ago.
11 Jul 2015 13:37:54
Original commit files touched by this commit Revision:391738  4.3.0
robak search for other commits by this committer
databases/spatialite: update 4.2.0 -> 4.3.0

- Add new options for postgis

PR:		201310
Submitted by:	Bartoletti <coder@tuxfamily.org> (maintainer)
15 Jun 2015 13:03:12
Original commit files touched by this commit Revision:389704  4.2.0_1
wen search for other commits by this committer
- Update graphics/proj to 4.9.1
- Bump PORTREVISION to chase the update of proj

PR:		200434
Submitted by:	wen@(myself)
Approved by:	maintainer(timeout, >20 days)
20 Dec 2014 17:12:37
Original commit files touched by this commit Revision:375012  4.2.0
pawel search for other commits by this committer
- Update databases/spatialite to version 4.2.0 [1]
- Add LICENSE info [1]
- Fix WWW line in pkg-descr [1]
- Bump all affected ports

PR:		196150 [1]
Submitted by:	maintainer [1]
08 Dec 2014 16:48:41
Original commit files touched by this commit Revision:374303  4.1.1_6
tijl search for other commits by this committer
Replace USES=libtool:oldver with USES=libtool or USES=libtool:keepla in
the 32 ports that still use it.  Bump PORTREVISION on their dependent
ports except the ones that depend on these:

audio/libogg
audio/libvorbis
devel/pcre
ftp/curl
graphics/jpeg
graphics/libart_lgpl
graphics/tiff
textproc/expat2
textproc/libxslt

In these cases the same trick as in the recent gettext update is used.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
20 Oct 2014 10:41:13
Original commit files touched by this commit Revision:371255  4.1.1_5
bapt search for other commits by this committer
Cleanup plist
18 Jul 2014 13:07:24
Original commit files touched by this commit Revision:362205  4.1.1_5
sunpoet search for other commits by this committer
- Add missing USE_LDCONFIG
- Use USES=libtool
- Fix USE_PYTHON
- Convert to new options helper
- Bump PORTREVISION for package change
- Do not hard-coded PORTVERSION in PLIST
- Bump PORTREVISION for graphics/geos shlib change
04 Jul 2014 09:41:00
Original commit files touched by this commit Revision:360588  4.1.1_4
tijl search for other commits by this committer
Bump PORTREVISION on all ports with USE_SQLITE=yes or USE_SQLITE=3 that
have not been bumped yet after the latest libsqlite3.so library version
change.

Approved by:	portmgr (implicit)
23 Jun 2014 02:44:12
Original commit files touched by this commit Revision:358893  4.1.1_3
amdmi3 search for other commits by this committer
- Convert databases/spatialite to USES=libtool, drop .la files
- Bump dependent ports as .so version has changed

Approved by:	portmgr blanket
09 May 2014 21:13:10
Original commit files touched by this commit Revision:353520  4.1.1_2
amdmi3 search for other commits by this committer
- Don't remove mtree directories

Approved by:	portmgr
16 Apr 2014 18:28:50
Original commit files touched by this commit Revision:351411  4.1.1_2
zeising search for other commits by this committer
The FreeBSD x11@ and graphics team proudly presents
a zeising, kwm production, with help from dumbbell, bdrewery:

NEW XORG ON FREEBSD 9-STABLE AND 10-STABLE

This update switches over to use the new xorg stack by default on FreeBSD 9
and 10 stable, on osversions where vt(9) is available.
It is still possible to use the old stack by specifying WITHOUT_NEW_XORG in
/etc/make.conf .
FreeBSD 8-STABLE and released versions of FreeBSD still use
the old version.
A package repository with binary packages for new xorg will
be available soon.

This patch also contains updates of libxcb and related ports, pixman, as well
(Only the first 15 lines of the commit message are shown above View all of this commit message)
14 Feb 2014 15:42:12
Original commit files touched by this commit Revision:344268  4.1.1_1
miwi search for other commits by this committer
- Stage support
30 Nov 2013 14:55:34
Original commit files touched by this commit Revision:335294  4.1.1_1
wg search for other commits by this committer
databases/spatialite: enable libxml2

- Enable libxml2
- USES pathfix pkgconfig

PR:		ports/184099
Submitted by:	maintainer
05 Nov 2013 12:40:29
Original commit files touched by this commit Revision:332842  4.1.1
wen search for other commits by this committer
- Update to 4.1.1
- Pass maintainership to submitter

PR:		183533
Submitted by:	lbartoletti <coder@tuxfamily.org>
Approved by:	Wen Heping(previous maintainer, myself)
20 Sep 2013 16:13:49
Original commit files touched by this commit Revision:327717  3.0.1_2
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
13 Sep 2013 17:14:53
Original commit files touched by this commit Revision:327168  3.0.1_2
madpilot search for other commits by this committer
- Fix build after iconv change [1]
- Fix build with clang/libc++ ([2] for graphics/ipe)

While here for databases/spatialite:
- Trim Makefile headers
- Remove check for unsupported FreeBSD versions

Submitted by:	marino [1]
Reported by:	swills, antoine [1]
Submitted by:	bsam [2]
Approved by:	portmgr (bapt, implicit)
11 Sep 2013 13:58:27
Original commit files touched by this commit Revision:326981  3.0.1_2
wg search for other commits by this committer
graphics/geos: update to 3.4.2

- Update to 3.4.2 [1]
- Bump PORTREVISION for dependent ports
- USES gmake
- Use options helpers

PR:		ports/181422 [1]
Submitted by:	Rainer Hurling <rhurlin gwdg.de> (maintainer)
27 Apr 2013 08:50:47
Original commit files touched by this commit Revision:316654  3.0.1_1
mva search for other commits by this committer
- Convert USE_ICONV=yes to USES=iconv
- Change USE_GNOME=pkgconfig|gnomehack to USES=pathfix|pkgconfig while here

Reviewed by:	bapt, kwm
11 Sep 2012 17:49:21
Original commit files touched by this commit Revision:304112  3.0.1_1
pawel search for other commits by this committer
- spatialite: install pc file in correct place [1]
- spatialite_gui: unbreak, now configures properly and is able to
  find libspatialite installed by databases/spatialite

PR:		ports/170893 [1]
Submitted by:	myself [1]
Approved by:	maintainer timeout
08 Sep 2012 07:49:05
Original commit files touched by this commit Revision:303878  3.0.1
linimon search for other commits by this committer
Mark as broken on powerpc.

Hat:		portmgr
31 May 2012 01:29:23
Original commit files touched by this commit   3.0.1
wen search for other commits by this committer
- Mark BROKEN when ${OSVERSION} < 800000

Reported by:    pav@
24 May 2012 01:30:23
Original commit files touched by this commit   3.0.1
wen search for other commits by this committer
- Update to 3.0.1

PR:             168153
Submitted by:   lbartoletti <coder@tuxfamily.org>
07 May 2012 08:12:53
Original commit files touched by this commit   2.2_7
wen search for other commits by this committer
- Bump PORTREVISION to chase the update of graphics/proj
07 May 2012 07:10:22
Original commit files touched by this commit   2.2_6
wen search for other commits by this committer
- Bump PORTREVISION to chase the update of graphics/geos
26 Feb 2012 17:47:02
Original commit files touched by this commit   2.2_5
matthew search for other commits by this committer
 - Stylistic cleanup: remove trailing slashes from *_DEPENDS lines.

      audio/cd2mp3           [1]
      audio/mp3unicode       [2]
      databases/spatialite   [3]
      deskutils/aspostit
      devel/bennugd-modules  [4]
      net/hinfo
      www/caudium14          [5]

Approved by:    shaun (mentor) mark@foster.cc (maintainer[1]) makc
(maintainer[2]) wenheping@gmail.com (maintainer[3]) amdmi3 (maintainer[4])
johans (maintainer[5])
02 Jul 2011 23:50:43
Original commit files touched by this commit   2.2_5
wen search for other commits by this committer
- Fix build after geos update

Reported by: pav@
20 Mar 2011 12:54:45
Original commit files touched by this commit   2.2_4
miwi search for other commits by this committer
- Get Rid MD5 support
20 Dec 2009 09:13:58
Original commit files touched by this commit   2.2_4
wen search for other commits by this committer
- Bump PORTREVISION to chase the update of graphics/geos
27 Nov 2009 23:17:38
Original commit files touched by this commit   2.2_3
miwi search for other commits by this committer
- Chase graphics/proj shlib bump
14 Aug 2009 21:29:25
Original commit files touched by this commit   2.2_2
miwi search for other commits by this committer
- Chase graphics/geos shlib bump
11 Apr 2009 08:13:06
Original commit files touched by this commit   2.2_1
miwi search for other commits by this committer
- Chase graphics/geos shlib bump
01 Nov 2008 21:59:18
Original commit files touched by this commit   2.2
miwi search for other commits by this committer
- Update to 2.2

PR:             128457
Submitted by:   Wen Heping <wenheping@gmail.com> (maintainer)
18 Jul 2008 12:43:50
Original commit files touched by this commit   2.0
miwi search for other commits by this committer
SpatiaLite is just a small sized SQLite extension. Once you have installed
SpatiaLite (a very simple and elementary task), the SQLite DBMS is enable to
load, store and manipulate Spatial Data (aka GeographicData, GIS Data,
Cartographic Data, GeoSpatial Data, Geometry Data and alike). SpatiaLite
implements spatial extensions following the specification of the Open
Geospatial Consortium (OGC).

WWW:   http://www.gaia-gis.it/spatialite-2.0/index.html

PR:             ports/125528
Submitted by:   Wen Heping <wenheping at gmail.com>

Number of commits found: 56