Download the PHP package ajthinking/laravel-postgis without Composer

Laravel Wrapper for PostgreSQL's Geo-Extension Postgis

For Laravel 9+, PHP 8+ only

Features

• Work with geometry classes instead of arrays.

• Adds helpers in migrations.

Installation

Usage

To start, ensure you have PostGIS enabled in your database - you can do this in a Laravel migration or manually via SQL.

Enable PostGIS via a Laravel migration

You need to publish the migration to easily enable PostGIS:

And then you run the migrations:

These methods are safe to use and will only enable / disable the PostGIS extension if relevant - they won't cause an error if PostGIS is / isn't already enabled.

If you prefer, you can use the enablePostgis() method which will throw an error if PostGIS is already enabled, and the disablePostgis() method twhich will throw an error if PostGIS isn't enabled.

Enable PostGIS manually

Use an SQL client to connect to your database and run the following command:

CREATE EXTENSION postgis;

To verify that PostGIS is enabled you can run:

SELECT postgis_full_version();

Migrations

Now create a model with a migration by running

php artisan make:model Location

If you don't want a model and just a migration run

php artisan make:migration create_locations_table

Open the created migrations with your editor.

Available blueprint geometries:

• point
• multipoint
• linestring
• multilinestring
• polygon
• multipolygon
• geometrycollection

other methods:

• enablePostgis
• disablePostgis

Models

All models which are to be PostGis enabled must use the PostgisTrait.

You must also define an array called $postgisFields which defines what attributes/columns on your model are to be considered geometry objects. By default, all attributes are of type geography. If you want to use geometry with a custom SRID, you have to define an array called $postgisTypes. The keys of this assoc array must match the entries in $postgisFields (all missing keys default to geography), the values are assoc arrays, too. They must have two keys: geomtype which is either geography or geometry and srid which is the desired SRID. Note: Custom SRID is only supported for geometry, not geography.

Available geometry classes:

• Point
• MultiPoint
• LineString
• MultiLineString
• Polygon
• MultiPolygon
• GeometryCollection

Achnowledgements

This is a fork from the work of great people. Thanks to :

• https://github.com/njbarrett
• https://github.com/phaza
• https://github.com/mirzap