activerecord-postgis-adapter - ActiveRecord connection adapter for PostGIS, based on postgresql and rgeo

  •        23

The activerecord-postgis-adapter provides access to features of the PostGIS geospatial database from ActiveRecord. It extends the standard postgresql adapter to provide support for the spatial data types and features added by the PostGIS extension. It uses the RGeo library to represent spatial data in Ruby. First, it provides spatial migrations. It extends the ActiveRecord migration syntax to support creating spatially-typed columns and spatial indexes. You can control the various PostGIS-provided attributes such as srid, dimension, and geographic vs geometric math.



Related Projects


  •    Ruby

ActiveRecord connection adapter for PostGIS, based on postgresql and rgeo


  •    Ruby

Spatial Adapter for ActiveRecord and Rails 2.x and 3.0.x - no longer in active development (try RGeo for Rails 3.1+)

rgeo - Geospatial data library for Ruby

  •    Ruby

RGeo is a geospatial data library for Ruby. RGeo is a key component for writing location-aware applications in the Ruby programming language. At its core is an implementation of the industry standard OGC Simple Features Specification, which provides data representations of geometric objects such as points, lines, and polygons, along with a set of geometric analysis operations. This makes it ideal for modeling geolocation data. It also supports a suite of optional add-on modules that provide various geolocation-related services.

docker-postgis - Docker image for PostGIS

  •    Shell

The mdillon/postgis image provides a Docker container running Postgres 9 or 10 with PostGIS 2.4 installed. This image is based on the official postgres image and provides variants for each version of Postgres 9 supported by the base image (9.3-9.6) and Postgres 10. Unless -e POSTGRES_DB is passed to the container at startup time, this database will be named after the admin user (either postgres or the user specified with -e POSTGRES_USER). If you would prefer to use the older template database mechanism for enabling PostGIS, the image also provides a PostGIS-enabled template database called template_postgis.

postgis - PostGIS spatial database extension to PostgreSQL [mirror]

  •    PLpgSQL

This file is here to play nicely with modern code repository facilities. Actual readme is here. Official chat room is the #postgis channel on the freenode network.

PostGIS - Spatial and Geographic objects for PostgreSQL

  •    C

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

activerecord-sqlserver-adapter - SQL Server Adapter For Rails

  •    Ruby

Both TinyTDS and the Rails SQL Server Adapter are MIT-licensed open source projects. Its ongoing development is made possible thanks to the support by these awesome backers. If you'd like to join them, check out our Patreon Campaign. The SQL Server adapter for ActiveRecord v5.1 using SQL Server 2012 or higher.

GeoMedia PostGIS data server


GeoMedia PostGIS data server is a GDO (Geographic Database Object) component that enables read and write to a Postgre/PostGIS database from Intergraph GeoMedia product family.

activerecord-multi-tenant - Rails/ActiveRecord support for distributed multi-tenant databases like Postgres+Citus

  •    Ruby

ActiveRecord/Rails integration for multi-tenant databases, in particular the open-source Citus extension for PostgreSQL. Enables easy scale-out by adding the tenant context to your queries, enabling the database (e.g. Citus) to efficiently route queries to the right database node.

oracle-enhanced - Oracle enhaced adapter for ActiveRecord

  •    Ruby

Oracle enhanced ActiveRecord adapter provides Oracle database access from Ruby on Rails applications. Oracle enhanced adapter can be used from Ruby on Rails versions between 2.3.x and 5.2 and it is working with Oracle database versions from 10g to 12c. where instead of 1.6.0 you can specify any other desired version. It is recommended to specify version with ~> which means that use specified version or later patch versions (in this example any later 1.6.x version but not 1.7.x version). Oracle enhanced adapter maintains API backwards compatibility during patch version upgrades and therefore it is safe to always upgrade to latest patch version.

DXF to PostGIS converter

  •    VB

A tool to convert DXF files to PostGIS geometry tables. A single DXF file is converted to a PostgreSQL - PostGIS SQL script to create and populate five tables, using the AutoCAD information of point, line, polyline, text, circle, insert, and layer.

PostGIS-Arc Connector

  •    VB

This project produces an Extension and VBA module that allows ESRIs ArcMap (v8.x) product to access Open Source Postgresql/PostGIS spatial data tables. Includes importing tables and exporting/updating back to the database. Currently using Postgresql OD

nyc-taxi-data - Import public NYC taxi and Uber trip data into PostgreSQL / PostGIS database, analyze with R

  •    R

This repo provides scripts to download, process, and analyze data for over 1.8 billion taxi and for-hire vehicle (Uber, Lyft, etc.) trips originating in New York City since 2009. The data is stored in a PostgreSQL database, and uses PostGIS for spatial calculations, in particular mapping latitude/longitude coordinates to census tracts. Most of the raw data comes from the NYC Taxi & Limousine Commission. The 2014 Uber data comes via FiveThirtyEight, who obtained it via a FOIL request. In August 2016, the TLC began providing for-hire vehicle trip records in addition to taxi trips.

activerecord-activesalesforce-adapter - An ActiveRecord adapter for the API

  •    Ruby

An ActiveRecord adapter for the API

arproxy - Arproxy is a proxy between ActiveRecord and database adapter

  •    Ruby

Arproxy is a proxy between ActiveRecord and Database adapters. You can make a custom proxy what analyze and/or modify SQLs before DB adapter executes them. Then you can see the backtrace of SQLs in the Rails' log.

E00 to PostGIS


An ESRI-E00 to PostgreSQL/PostGIS filter.


  •    VBNET

ShapeImEx is a Windows tool for importing/exporting shape files from/to a with PostGIS spatially enabled PostgreSQL database. ShapeImEx is a GUI frontend for pgsql2shp and shp2pgsql which come with the PostGIS extension.

imposm3 - Imposm imports OpenStreetMap data into PostGIS

  •    Go

Imposm is an importer for OpenStreetMap data. It reads PBF files and imports the data into PostgreSQL/PostGIS. It can also automatically update the database with the latest changes from OSM. It is designed to create databases that are optimized for rendering (i.e. generating tiles or for WMS services).

with_advisory_lock - Advisory locking for ActiveRecord

  •    Ruby

Adds advisory locking (mutexes) to ActiveRecord 4.2, 5.1, and 5.2, with ruby 2.5, 2.4 and 2.3, when used with MySQL or PostgreSQL. SQLite resorts to file locking. An advisory lock is a mutex used to ensure no two processes run some process at the same time. When the advisory lock is powered by your database server, as long as it isn't SQLite, your mutex spans hosts.