GET /api/v1/ports/?format=api&ordering=-name&page=609
HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 50506,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=610",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=608",
    "results": [
        {
            "name": "pg_back",
            "portdir": "databases/pg_back",
            "version": "2.6.0",
            "license": "MIT",
            "platforms": "darwin freebsd linux",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://github.com/orgrim/pg_back",
            "description": "Simple backup tool for PostgreSQL",
            "long_description": "pg_back is a dump tool for PostgreSQL. The goal is to dump all or some databases with globals at once in the format you want, because a simple call to pg_dumpall only dumps databases in the plain SQL format. Behind the scene, pg_back uses pg_dumpall to dump roles and tablespaces definitions, pg_dump to dump all or each selected database to a separate file in the custom format. It also extract database level ACL and configuration that is not dumped by pg_dump older than 11. Finally, it dumps all configuration options of the PostgreSQL instance.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "herby.gillot",
                    "github": "herbygillot",
                    "ports_count": 1020
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "go",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pgAdmin3",
            "portdir": "aqua/pgAdmin3",
            "version": "1.22.2",
            "license": "Permissive",
            "platforms": "macosx",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.pgadmin.org",
            "description": "An administration program to PostgreSQL",
            "long_description": "pgAdmin III is a powerful administration and development platform for the PostgreSQL database, free for any use. The application works on several platforms, e.g. GNU/Linux, FreeBSD, OS X and Windows 2000/XP. This port is for OS X.",
            "active": true,
            "categories": [
                "aqua"
            ],
            "maintainers": [],
            "variants": [
                "postgresql91",
                "postgresql92",
                "postgresql93",
                "postgresql94",
                "postgresql95",
                "postgresql96",
                "debug"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcrypt",
                        "openssl",
                        "postgresql96",
                        "libxml2",
                        "libxslt",
                        "wxWidgets-3.0"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg2xbase",
            "portdir": "databases/pg2xbase",
            "version": "2.4.1",
            "license": "unknown",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://web.archive.org/web/20080504010314/http://www.klaban.torun.pl/prog/pg2xbase/",
            "description": "Convert data between PostgreSQL and DBF files",
            "long_description": "pg2xbase provides utilities for converting between PostgreSQL databases and DBF files.",
            "active": false,
            "categories": [
                "databases"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-15"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql81",
                        "xbase"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg18-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.23.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql18"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "timescaledb"
                    ]
                }
            ]
        },
        {
            "name": "pg17-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.23.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 17",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 17",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql17"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg17-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg17-postgis",
            "long_description": "This port has been replaced by pg17-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql17",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg17-pgrouting",
                        "mod_tile",
                        "osm2pgrouting",
                        "osm2pgsql"
                    ]
                }
            ]
        },
        {
            "name": "pg17-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql17",
                        "pg17-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg17-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql17",
                        "zlib"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pdal-pgpointcloud"
                    ]
                }
            ]
        },
        {
            "name": "pg16-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.23.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql16"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 16",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 16",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql16",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg16-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg16-postgis",
            "long_description": "This port has been replaced by pg16-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "osm2pgsql-lua"
                    ]
                }
            ]
        },
        {
            "name": "pg16-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql16",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg16-pgrouting",
                        "tinyows"
                    ]
                }
            ]
        },
        {
            "name": "pg16-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql16",
                        "pg16-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql16",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.23.0",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql15"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 15",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql15",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 15",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "postgresql15",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg15-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg15-postgis",
            "long_description": "This port has been replaced by pg15-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "proj9",
                        "protobuf-c",
                        "postgresql15",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg15-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg15-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql15",
                        "pg15-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql15",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.19.3",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql14"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 14",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "postgresql14",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 14",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "postgresql14",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg14-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg14-postgis",
            "long_description": "This port has been replaced by pg14-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql14",
                        "protobuf-c",
                        "proj9",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg14-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg14-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql14",
                        "pg14-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg14-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql14",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.15.3",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 13",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql13",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 13",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql13",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg13-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg13-postgis",
            "long_description": "This port has been replaced by pg13-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql13",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg13-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg13-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.0",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13",
                        "boost176",
                        "pg13-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg13-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql13",
                        "libxml2",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.11.2",
            "license": "Apache-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www.timescaledb.com/",
            "description": "A time-series database that integrates with PostgreSQL.",
            "long_description": "TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension.",
            "active": true,
            "categories": [
                "databases"
            ],
            "maintainers": [
                {
                    "name": "blair",
                    "github": "blair",
                    "ports_count": 26
                }
            ],
            "variants": [
                "timescale_license",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5.34",
                        "p5.34-ipc-run",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql12"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 12",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql12",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis3-doc",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 12",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format. This adds documentation.",
            "active": false,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "postgresql12",
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis3",
            "portdir": "databases/postgis3",
            "version": "3.6.0",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": "pg12-postgis",
            "homepage": "https://www.macports.org",
            "description": "Obsolete port, replaced by pg12-postgis",
            "long_description": "This port has been replaced by pg12-postgis.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-18"
                    ]
                },
                {
                    "type": "extract",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "fetch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "patch",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        null
                    ]
                },
                {
                    "type": "test",
                    "ports": [
                        null
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.1",
            "license": "GPL-2+",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "PostGIS is the spatial extension to the PostGreSQL database.",
            "long_description": "PostGIS adds geometrical, geographical and topological types, and functions operating thereon, to the PostGreSQL database. It also handles raster tiles and MVT format.",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "address_standardizer",
                "lto",
                "proj6",
                "proj7",
                "proj8",
                "proj9",
                "raster",
                "sfcgal",
                "topology",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "libxslt",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql12",
                        "proj9",
                        "protobuf-c",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg12-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg12-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "3.6.3",
            "license": "LGPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://www.pgrouting.org/",
            "description": "Routing algorithms for PostgreSQL/PostGIS",
            "long_description": "pgRouting is a PostGreSQL/PostGIS extension that contains a variety of algorithms to solve traditional network problems such as finding shortest paths or the Traveling Sales Person (TSP).",
            "active": true,
            "categories": [
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 68
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql12",
                        "boost176",
                        "pg12-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg12-pgpointcloud",
            "portdir": "databases/pgpointcloud",
            "version": "1.2.5",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://pgpointcloud.github.io/pointcloud/",
            "description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "long_description": "pgPointcloud is a PostgreSQL extension for storing point cloud (LIDAR) data",
            "active": true,
            "categories": [
                "databases",
                "gis"
            ],
            "maintainers": [
                {
                    "name": "n_larsson",
                    "github": "nilason",
                    "ports_count": 105
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-17"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "postgresql12",
                        "libxml2",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pftp",
            "portdir": "net/pftp",
            "version": "0.4",
            "license": "GPL-2",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "http://pftp.sourceforge.net/",
            "description": "ftp client with FXP, SSL, and TLS support",
            "long_description": "PFTP is a portable FTP client, with many useful features, such as FXP, SSL, and TLS support",
            "active": true,
            "categories": [
                "net"
            ],
            "maintainers": [],
            "variants": [
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ncurses",
                        "openssl",
                        "readline",
                        "libpftp",
                        "libpftputil"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pflogsumm",
            "portdir": "mail/pflogsumm",
            "version": "1.1.5",
            "license": "GPL-2+",
            "platforms": "{darwin any} freebsd",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://jimsun.linxnet.com/postfix_contrib.html",
            "description": "Produce Postfix MTA logfile summary",
            "long_description": "Pflogsumm is a log analyzer/summarizer for the Postfix MTA. It is designed to provide an over-view of Postfix activity, with just enough detail to give the administrator a heads up for potential trouble spots. Pflogsumm generates summaries and, in some cases, detailed reports of mail server traffic volumes, rejected and bounced email, and server warnings, errors and panics. Also installs Chris Cappuccio's CGI script for browser access to the Pflogsumm output.",
            "active": true,
            "categories": [
                "mail"
            ],
            "maintainers": [],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-14"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "perl5.34"
                    ]
                },
                {
                    "type": "run",
                    "ports": [
                        "p5.34-date-calc"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pficommon",
            "portdir": "devel/pficommon",
            "version": "2.0.0",
            "license": "BSD",
            "platforms": "darwin",
            "epoch": 1,
            "replaced_by": null,
            "homepage": "https://github.com/retrieva/pficommon",
            "description": "Common Library of C++",
            "long_description": "pficommon is a general purpose C++ library.",
            "active": true,
            "categories": [
                "devel"
            ],
            "maintainers": [],
            "variants": [
                "mysql56",
                "mysql55",
                "mysql51",
                "mariadb",
                "postgresql94",
                "postgresql93",
                "postgresql92",
                "postgresql91",
                "postgresql90",
                "postgresql84",
                "fcgi",
                "mprpc",
                "magickpp",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "python27",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "msgpack0"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "normalizeNumexp"
                    ]
                }
            ]
        },
        {
            "name": "pfft",
            "portdir": "math/pfft",
            "version": "1.0.8-alpha",
            "license": "GPL-3",
            "platforms": "darwin",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://www-user.tu-chemnitz.de/~potts/workgroup/pippig/software.php.en#pfft",
            "description": "An extension of FFTW to massively parallel architectures",
            "long_description": "PFFT is a parallel FFT software library based on MPI.",
            "active": true,
            "categories": [
                "math"
            ],
            "maintainers": [
                {
                    "name": "dstrubbe",
                    "github": "dstrubbe",
                    "ports_count": 38
                }
            ],
            "variants": [
                "clang10",
                "clang11",
                "clang90",
                "g95",
                "gcc10",
                "gcc7",
                "gcc9",
                "gfortran",
                "mpich",
                "openmpi",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "clang-9.0",
                        "gcc11"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libgcc",
                        "fftw-3",
                        "mpich-clang90"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}