#postgre-sql #gis #geo #post-gis

postgis

An extension to rust-postgres, adds support for PostGIS

18 releases

0.9.0 Sep 23, 2021
0.8.0 Feb 7, 2021
0.7.0 Mar 25, 2020
0.6.0 Mar 17, 2018
0.1.6 Jun 13, 2015

#10 in Science

Download history 837/week @ 2021-09-29 1082/week @ 2021-10-06 1315/week @ 2021-10-13 800/week @ 2021-10-20 927/week @ 2021-10-27 1184/week @ 2021-11-03 896/week @ 2021-11-10 926/week @ 2021-11-17 1192/week @ 2021-11-24 1050/week @ 2021-12-01 774/week @ 2021-12-08 790/week @ 2021-12-15 508/week @ 2021-12-22 604/week @ 2021-12-29 769/week @ 2022-01-05 800/week @ 2022-01-12

2,807 downloads per month
Used in 10 crates (8 directly)

MIT license

155KB
3.5K SLoC

rust-postgis

Build Status Crates.io

Documentation

An extension to rust-postgres, adds support for PostGIS.

  • PostGIS type helper
  • GCJ02 support (used offically in Mainland China)
  • Tiny WKB (TWKB) support

Usage

use postgres::{Client, NoTls};
use postgis::{ewkb, LineString};

fn main() {
    let mut client = Client::connect("host=localhost user=postgres", NoTls).unwrap();
    for row in &client.query("SELECT * FROM busline", &[]).unwrap() {
        let route: ewkb::LineString = row.get("route");
        let last_stop = route.points().last().unwrap();
        let _ = client.execute("INSERT INTO stops (stop) VALUES ($1)", &[&last_stop]);
    }
}

Handling NULL values:

let route = row.try_get::<_, Option<ewkb::LineString>>("route");
match route {
    Ok(Some(geom)) => { println!("{:?}", geom) }
    Ok(None) => { /* Handle NULL value */ }
    Err(err) => { println!("Error: {}", err) }
}

Writing other geometry types into PostGIS

rust-postgis supports writing geometry types into PostGIS which implement the following traits:

  • Point, LineString, ...
  • AsEwkbPoint, AsEwkbLineString, ...

See the TWKB implementation as an example.

An example for reading a TWKB geometry and writing it back as EWKB:

use postgis::twkb;
use postgis::LineString;

for row in &conn.query("SELECT ST_AsTWKB(route) FROM busline", &[]).unwrap() {
    let route: twkb::LineString = row.get(0);
    let last_stop = route.points().last().unwrap();
    let _ = conn.execute("INSERT INTO stops (stop) VALUES ($1)", &[&last_stop.as_ewkb()]);
}

Unit tests

Unit tests which need a PostgreSQL connection are ignored by default. To run the database tests, declare the connection in an environment variable DBCONN. Example:

export DBCONN=postgresql://user@localhost/testdb

Run the tests with

cargo test -- --ignored

Dependencies

~2.5MB
~70K SLoC