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

{
    "count": 52339,
    "next": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=641",
    "previous": "https://ports.macports.org/api/v1/ports/?format=api&ordering=-name&page=639",
    "results": [
        {
            "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-18"
                    ]
                },
                {
                    "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.25.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": "pg18-postgis-doc",
            "portdir": "databases/postgis",
            "version": "3.6.3",
            "license": "GPL-2+",
            "platforms": "any",
            "epoch": 0,
            "replaced_by": null,
            "homepage": "https://postgis.net/",
            "description": "Documentation of PostGIS for PostgreSQL 18",
            "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": 111
                }
            ],
            "variants": [],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "libtool",
                        "pkgconfig",
                        "protobuf-c",
                        "geos",
                        "libxslt",
                        "proj9",
                        "clang-18",
                        "postgresql18"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg18-postgis",
            "portdir": "databases/postgis",
            "version": "3.6.3",
            "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": 111
                }
            ],
            "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",
                        "postgresql18",
                        "gdal",
                        "geos",
                        "json-c",
                        "libiconv",
                        "libxml2"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pg18-pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg18-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.1",
            "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": 111
                }
            ],
            "variants": [
                "debug",
                "doc",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "cmake",
                        "perl5",
                        "clang-20"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "boost176",
                        "postgresql18",
                        "pg18-postgis"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg18-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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql18",
                        "zlib"
                    ]
                }
            ],
            "depends_on": [
                {
                    "type": "lib",
                    "ports": [
                        "pdal-pgpointcloud"
                    ]
                }
            ]
        },
        {
            "name": "pg17-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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",
                        "osm2pgsql",
                        "mod_tile",
                        "osm2pgrouting"
                    ]
                }
            ]
        },
        {
            "name": "pg17-pgrouting",
            "portdir": "gis/pgrouting",
            "version": "4.0.1",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql17",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg16-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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.1",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "libxml2",
                        "postgresql16",
                        "zlib"
                    ]
                }
            ],
            "depends_on": []
        },
        {
            "name": "pg15-timescaledb",
            "portdir": "databases/timescaledb",
            "version": "2.25.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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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.1",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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.1",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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.1",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "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.3",
            "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": 111
                }
            ],
            "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": 111
                },
                {
                    "name": "vince",
                    "github": "Veence",
                    "ports_count": 25
                }
            ],
            "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.3",
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "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": 111
                }
            ],
            "variants": [
                "tests",
                "universal"
            ],
            "dependencies": [
                {
                    "type": "build",
                    "ports": [
                        "autoconf",
                        "automake",
                        "pkgconfig",
                        "clang-18"
                    ]
                },
                {
                    "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-18"
                    ]
                },
                {
                    "type": "lib",
                    "ports": [
                        "ncurses",
                        "openssl",
                        "readline",
                        "libpftp",
                        "libpftputil"
                    ]
                }
            ],
            "depends_on": []
        }
    ]
}