Geo

A collection of GIS functions. Handles conversions to and from WKT, WKB, and GeoJSON for the following geometries:

• Point
• LineString
• Polygon
• MultiPoint
• MulitLineString
• MultiPolygon
• GeometryCollection

Also includes a Postgrex extension for the PostGIS data types, Geometry and Geography

defp deps do
  [{:geo, "~> 1.1"}]
end

Documentation

Examples

• Encode and decode WKT and EWKT

  iex(1)> point = Geo.WKT.decode("POINT(30 -90)")
  %Geo.Point{ coordinates: {30, -90}, srid: nil}
  
  iex(2)> Geo.WKT.encode(point)
  "POINT(30 -90)"
  
  iex(3)> point = Geo.WKT.decode("SRID=4326;POINT(30 -90)")
  %Geo.Point{coordinates: {30, -90}, srid: 4326}

• Encode and decode WKB and EWKB

  iex(1)> point = Geo.WKB.decode("0101000000000000000000F03F000000000000F03F")
  %Geo.Point{ coordinates: {1.0, 1.0}, srid: nil }
  
  iex(2)> Geo.WKB.encode(point)
  "00000000013FF00000000000003FF0000000000000"
  
  iex(3)> point = Geo.WKB.decode("0101000020E61000009EFB613A637B4240CF2C0950D3735EC0")
  %Geo.Point{ coordinates: {36.9639657, -121.8097725}, srid: 4326 }
  
  iex(4)> Geo.WKB.encode(point)
  "0020000001000010E640427B633A61FB9EC05E73D350092CCF"

• Encode and decode GeoJSON

  Geo only encodes and decodes maps shaped as GeoJSON. JSON encoding and decoding must be done before and after.

  #Examples using Poison as the JSON parser
  
  iex(1)> Geo.JSON.encode(point)
  %{ "type" => "Point", "coordinates" => [100.0, 0.0] }
  
  iex(2)> point = Poison.decode!("{ \"type\": \"Point\", \"coordinates\": [100.0, 0.0] }") |> Geo.JSON.decode
  %Geo.Point{ coordinates: {100.0, 0.0}, srid: nil }
  
  iex(3)> Geo.JSON.encode(point) |> Poison.encode!
  "{\"type\":\"Point\",\"coordinates\":[100.0,0.0]}"

• A Postgrex Extension for the PostGIS data types, Geometry and Geography

  opts = [hostname: "localhost", username: "postgres", database: "geo_postgrex_test",
  extensions: [{Geo.PostGIS.Extension, []}] ]
  
  [hostname: "localhost", username: "postgres", database: "geo_postgrex_test",
   extensions: [{Geo.PostGIS.Extension, []}]]
  
  {:ok, pid} = Postgrex.Connection.start_link(opts)
  {:ok, #PID<0.115.0>}
  
  geo = %Geo.Point{coordinates: {30, -90}, srid: 4326}
  %Geo.Point{coordinates: {30, -90}, srid: 4326}
  
  {:ok, _} = Postgrex.Connection.query(pid, "CREATE TABLE point_test (id int, geom geometry(Point, 4326))")
  {:ok, %Postgrex.Result{columns: nil, command: :create_table, num_rows: 0, rows: nil}}
  
  {:ok, _} = Postgrex.Connection.query(pid, "INSERT INTO point_test VALUES ($1, $2)", [42, geo])
  {:ok, %Postgrex.Result{columns: nil, command: :insert, num_rows: 1, rows: nil}}
  
  Postgrex.Connection.query(pid, "SELECT * FROM point_test")
  {:ok, %Postgrex.Result{columns: ["id", "geom"], command: :select, num_rows: 1,
  rows: [{42, %Geo.Point{coordinates: {30.0, -90.0}, srid: 4326 }}]}}

• Can now be used with Ecto as well

  
  #Add extensions to your repo config
  config :thanks, Repo,
    database: "geo_postgrex_test",
    username: "postgres",
    password: "postgres",
    hostname: "localhost",
    adapter: Ecto.Adapters.Postgres,
    extensions: [{Geo.PostGIS.Extension, []}]
  
  
  #Create a model
  defmodule Test do
    use Ecto.Model
  
    schema "test" do
      field :name,           :string
      field :geom,           Geo.Geometry
    end
  end
  
  #Geometry or Geography columns can be created in migrations too
  defmodule Repo.Migrations.Init do
    use Ecto.Migration
  
    def up do
      create table(:test) do
        add :name,     :string
        add :geom,     :geometry
      end
    end
  
    def down do
      drop table(:test)
    end
  end

• Ecto migrations can also use more elaborate Postgis GIS Objects. These types are useful for enforcing constraints on {Lng,Lat} (order matters), or ensuring that a particular projection/coordinate system/format is used.

  defmodule Repo.Migrations.AdvancedInit do
    use Ecto.Migration
  
    def up do
      create table(:test) do
        add :name,     :string
      end
      # Add a field `lng_lat_point` with type `geometry(Point,4326)`.
      # This can store a "standard GPS" (epsg4326) coordinate pair {longitude,latitude}.
      execute("SELECT AddGeometryColumn ('test','lng_lat_point',4326,'POINT',2);")
    end
  
    def down do
      drop table(:test)
    end
  end

  Be sure to enable the Postgis extension if you haven't already done so:

  
  defmodule MyApp.Repo.Migrations.EnablePostgis do
    use Ecto.Migration
  
    def up do
      execute "CREATE EXTENSION IF NOT EXISTS postgis"
    end
  
    def down do
      execute "DROP EXTENSION IF EXISTS postgis"
    end
  end

• Postgis functions can also be used in ecto queries. Currently only the OpenGIS functions are implemented. Have a look at lib/geo/postgis.ex for the implemented functions. You can use them like:

  defmodule Example do
    import Ecto.Query
    import Geo.PostGIS
  
    def example_query(geom) do
      from location in Location, limit: 5, select: st_distance(location.geom, ^geom)
    end
  
  end

Development

After you got the dependencies via mix deps.get make sure that:

• postgis is installed
• your postgres user has the database "geo_postgrex_test"
• your postgres db user can login without a password or you set the PGPASSWORD environment variable appropriately

Then you can run the tests as you are used to with mix test.