databases/postgis33 3.3.10_1 FreeBSD
Geographic objects support for PostgreSQL databases
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
463980a20d- License
- GPLv2
- Categories
- databases, geography
Description
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 development was started by Refractions Research as a project in open source spatial database technology. PostGIS is released under the GNU General Public License. PostGIS continues to be developed by a group of contributors led by a Project Steering Committee and new features continue to be added.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/postgis33 | 3.3.10_1 |
| DragonFly | databases/postgis33 | 3.3.8 |
Install
Binary package:
pkg install postgis33
From the ports tree:
cd /usr/ports/databases/postgis33/ && make install clean
To depend on this port in another port's Makefile:
RUN_DEPENDS= postgis33>0:databases/postgis33
Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | - | - | - | 3.3.8_5 | - |
| FreeBSD:14:quarterly | - | - | n/a | 3.3.8_4 | - |
| FreeBSD:15:latest | - | - | n/a | 3.3.8_5 | 3.3.8_5 |
| FreeBSD:15:quarterly | - | - | n/a | n/a | n/a |
| FreeBSD:16:latest | - | - | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Library 5
libproj.so: graphics/projlibgeos.so: graphics/geoslibjson-c.so: devel/json-clibgdal.so: graphics/gdallibpcre2-8.so: devel/pcre2
The full lists below include those, and their dependencies in turn.
Build dependencies 92
- archivers/brotli
- archivers/libdeflate
- archivers/liblz4
- archivers/minizip
- archivers/zstd
- converters/libiconv
- databases/postgresql14-client
- databases/postgresql14-contrib
- databases/postgresql14-server
- databases/postgresql18-client
- databases/sfcgal
- databases/spatialite
- databases/sqlite3
- devel/abseil
- devel/binutils
- devel/boost-libs
- devel/gettext-runtime
- devel/gettext-tools
- devel/gmake
- devel/icu
- devel/json-c
- devel/jsoncpp
- devel/libedit
- devel/libffi
- devel/librttopo
- devel/libtextstyle
- devel/libunistring
- devel/llvm19
- devel/npth
- devel/nspr
- devel/pcre
- devel/pcre2
- devel/pkgconf
- devel/protobuf
- devel/protobuf-c
- devel/readline
- dns/libidn2
- dns/libpsl
- ftp/curl
- graphics/gdal
- graphics/geos
- graphics/giflib
- graphics/jbigkit
- graphics/jpeg-turbo
- graphics/lcms2
- graphics/lerc
- graphics/libgeotiff
- graphics/openjpeg
- graphics/png
- graphics/poppler
- graphics/poppler-data
- graphics/proj
- graphics/tiff
- graphics/webp
- lang/gcc14
- lang/perl5.42
- lang/python312
- lang/tcl86
- math/gmp
- math/libtommath
- math/mpc
- math/mpdecimal
- math/mpfr
- math/qhull
- net/uriparser
- print/freetype2
- print/indexinfo
- science/hdf5
- science/libaec
- science/libkml
- science/netcdf
- security/gnupg
- security/gnutls
- security/gpgme
- security/gpgmepp
- security/libassuan
- security/libgcrypt
- security/libgpg-error
- security/libksba
- security/libssh2
- security/libtasn1
- security/nettle
- security/nss
- security/p11-kit
- security/pinentry
- security/pinentry-curses
- textproc/expat2
- textproc/freexl
- textproc/libxml2
- textproc/xerces-c3
- www/libnghttp2
- x11-fonts/fontconfig
Run dependencies 86
- archivers/brotli
- archivers/libdeflate
- archivers/liblz4
- archivers/minizip
- archivers/zstd
- converters/libiconv
- databases/postgresql14-client
- databases/postgresql14-contrib
- databases/postgresql14-server
- databases/postgresql18-client
- databases/sfcgal
- databases/spatialite
- databases/sqlite3
- devel/abseil
- devel/binutils
- devel/boost-libs
- devel/gettext-runtime
- devel/icu
- devel/json-c
- devel/jsoncpp
- devel/libedit
- devel/libffi
- devel/librttopo
- devel/libunistring
- devel/llvm19
- devel/npth
- devel/nspr
- devel/pcre
- devel/pcre2
- devel/pkgconf
- devel/protobuf
- devel/protobuf-c
- devel/readline
- dns/libidn2
- dns/libpsl
- ftp/curl
- graphics/gdal
- graphics/geos
- graphics/giflib
- graphics/jbigkit
- graphics/jpeg-turbo
- graphics/lcms2
- graphics/lerc
- graphics/libgeotiff
- graphics/openjpeg
- graphics/png
- graphics/poppler
- graphics/poppler-data
- graphics/proj
- graphics/tiff
- graphics/webp
- lang/gcc14
- lang/tcl86
- math/gmp
- math/libtommath
- math/mpc
- math/mpfr
- math/qhull
- net/uriparser
- print/freetype2
- print/indexinfo
- science/hdf5
- science/libaec
- science/libkml
- science/netcdf
- security/gnupg
- security/gnutls
- security/gpgme
- security/gpgmepp
- security/libassuan
- security/libgcrypt
- security/libgpg-error
- security/libksba
- security/libssh2
- security/libtasn1
- security/nettle
- security/nss
- security/p11-kit
- security/pinentry
- security/pinentry-curses
- textproc/expat2
- textproc/freexl
- textproc/libxml2
- textproc/xerces-c3
- www/libnghttp2
- x11-fonts/fontconfig
No port depends on this one.
Configuration
Options name: databases_postgis
| Option | Default | Description |
|---|---|---|
| ADDRSTD | on | Enable address standardizer |
| JSON | on | Enable JSON support |
| LOADERGUI | off | Enable shp2pgsql-gui |
| NLS | on | Enable international language support |
| PROTOBUF | on | Enable protocol buffers |
| RASTER | on | Enable raster support |
| SFCGAL | on | Enable sfcgal |
| TOPOLOGY | on | Topology support |
| WAGYU | on | Enable WAGYU support |
- USES
- compiler:c++14-lang cpe gmake gnome iconv:wchar_t libtool:keepla localbase perl5 pkgconfig pgsql:14-17 shebangfix
- Service scripts
- none
- Conflicts with
- postgis[0-9][0-9]
Files
pkg-plist 928
- bin/pgsql2shp
- bin/pgtopo_export
- bin/pgtopo_import
- bin/raster2pgsql
- bin/shp2pgsql
- bin/shp2pgsql-gui
- lib/postgresql/address_standardizer-3.so
- lib/postgresql/postgis-3.so
- lib/postgresql/postgis_raster-3.so
- lib/postgresql/postgis_sfcgal-3.so
- lib/postgresql/postgis_topology-3.so
- share/postgis33/tiger_geocoder/COPYING
- share/postgis33/tiger_geocoder/README
- share/postgis33/tiger_geocoder/create_geocode.bat
- share/postgis33/tiger_geocoder/create_geocode.sh
- share/postgis33/tiger_geocoder/create_geocode.sql
- share/postgis33/tiger_geocoder/geocode/census_tracts_functions.sql
- share/postgis33/tiger_geocoder/geocode/geocode.sql
- share/postgis33/tiger_geocoder/geocode/geocode_address.sql
- share/postgis33/tiger_geocoder/geocode/geocode_intersection.sql
- share/postgis33/tiger_geocoder/geocode/geocode_location.sql
- share/postgis33/tiger_geocoder/geocode/includes_address.sql
- share/postgis33/tiger_geocoder/geocode/interpolate_from_address.sql
- share/postgis33/tiger_geocoder/geocode/other_helper_functions.sql
- share/postgis33/tiger_geocoder/geocode/rate_attributes.sql
- share/postgis33/tiger_geocoder/geocode/reverse_geocode.sql
- share/postgis33/tiger_geocoder/geocode_settings.sql
- share/postgis33/tiger_geocoder/legacy_import/tiger2008/import_tiger_shps.sh
- share/postgis33/tiger_geocoder/normalize/count_words.sql
- share/postgis33/tiger_geocoder/normalize/end_soundex.sql
- share/postgis33/tiger_geocoder/normalize/get_last_words.sql
- share/postgis33/tiger_geocoder/normalize/location_extract.sql
- share/postgis33/tiger_geocoder/normalize/location_extract_countysub_exact.sql
- share/postgis33/tiger_geocoder/normalize/location_extract_countysub_fuzzy.sql
- share/postgis33/tiger_geocoder/normalize/location_extract_place_exact.sql
- share/postgis33/tiger_geocoder/normalize/location_extract_place_fuzzy.sql
- share/postgis33/tiger_geocoder/normalize/normalize_address.sql
- share/postgis33/tiger_geocoder/normalize/pprint_addy.sql
- share/postgis33/tiger_geocoder/normalize/state_extract.sql
- share/postgis33/tiger_geocoder/pagc_normalize/pagc_normalize_address.sql
- share/postgis33/tiger_geocoder/pagc_normalize/pagc_tables.sql
- share/postgis33/tiger_geocoder/regress/geocode_regress
- share/postgis33/tiger_geocoder/regress/geocode_regress.sql
- share/postgis33/tiger_geocoder/regress/normalize_address_desired_regress
- share/postgis33/tiger_geocoder/regress/normalize_address_regress
- share/postgis33/tiger_geocoder/regress/normalize_address_regress.sql
- share/postgis33/tiger_geocoder/regress/pagc_normalize_address_desired_regress
- share/postgis33/tiger_geocoder/regress/pagc_normalize_address_regress
- share/postgis33/tiger_geocoder/regress/pagc_normalize_address_regress.sql
- share/postgis33/tiger_geocoder/regress/regress.sql
- share/postgis33/tiger_geocoder/regress/reverse_geocode_regress
- share/postgis33/tiger_geocoder/regress/reverse_geocode_regress.sql
- share/postgis33/tiger_geocoder/tables/lookup_tables_2011.sql
- share/postgis33/tiger_geocoder/tiger_loader_2011.sql
- share/postgis33/tiger_geocoder/tiger_loader_2012.sql
- share/postgis33/tiger_geocoder/tiger_loader_2013.sql
- share/postgis33/tiger_geocoder/tiger_loader_2014.sql
- share/postgis33/tiger_geocoder/tiger_loader_2015.sql
- share/postgis33/tiger_geocoder/tiger_loader_2016.sql
- share/postgis33/tiger_geocoder/tiger_loader_2017.sql
- share/postgis33/tiger_geocoder/tiger_loader_2018.sql
- share/postgis33/tiger_geocoder/tiger_loader_2019.sql
- share/postgis33/tiger_geocoder/tiger_loader_2020.sql
- share/postgis33/tiger_geocoder/tiger_loader_2021.sql
- share/postgis33/tiger_geocoder/tiger_loader_2022.sql
- share/postgis33/tiger_geocoder/topology/README
- share/postgis33/tiger_geocoder/topology/tiger_topology_loader.sql
- share/postgis33/tiger_geocoder/upgrade_geocode.sql
- share/postgis33/tiger_geocoder/upgrade_geocoder.bat
- share/postgis33/tiger_geocoder/upgrade_geocoder.sh
- share/postgis33/tiger_geocoder/utility/cull_null.sql
- share/postgis33/tiger_geocoder/utility/levenshtein_ignore_case.sql
- share/postgis33/tiger_geocoder/utility/nullable_levenshtein.sql
- share/postgis33/tiger_geocoder/utility/set_search_path.sql
- share/postgis33/tiger_geocoder/utility/standardize_tiger_data.sql
- share/postgis33/tiger_geocoder/utility/utmzone.sql
- share/postgis33/utils/README
- share/postgis33/utils/check_all_upgrades.sh
- share/postgis33/utils/check_cluster_upgrade.sh
- share/postgis33/utils/check_distclean.sh
- share/postgis33/utils/check_news.sh
- share/postgis33/utils/check_tests_enabled.sh
- share/postgis33/utils/create_extension_unpackage.pl
- share/postgis33/utils/create_or_replace_to_create.pl
- share/postgis33/utils/create_skip_signatures.pl
- share/postgis33/utils/create_spatial_ref_sys_config_dump.pl
- share/postgis33/utils/create_undef.pl
- share/postgis33/utils/create_unpackaged.pl
- share/postgis33/utils/create_upgrade.pl
- share/postgis33/utils/postgis_restore.pl
- share/postgis33/utils/postgis_restore_data.generated
- share/postgis33/utils/postgis_restore_data.hardcoded
- share/postgis33/utils/profile_intersects.pl
- share/postgis33/utils/read_scripts_version.pl
- share/postgis33/utils/repo_revision.pl
- share/postgis33/utils/test_estimation.pl
- share/postgis33/utils/test_geography_estimation.pl
- share/postgis33/utils/test_geography_joinestimation.pl
- share/postgis33/utils/test_joinestimation.pl
- share/doc/postgresql/extension/README.address_standardizer
The first 100 are listed.
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| postgis-3.3.10.tar.gz | 1.7825705e+07 | 7fb63851a79a2ab64e1de5dddf6dd00d593cc1830b6e9e0de81199b63168a82a |
Master sites 1
- https://download.osgeo.org/postgis/source/