GeoJSON to PostgresSQL/PostGis
JavaScript
Switch branches/tags
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
bin
lib
test
.gitignore
.travis.yml
LICENSE.md
README.md
package.json
sample.config.json

README.md

Coati Build Status

coati

Streams GeoJSON data to a PostGIS configured PostgreSQL database.

Note: Casts all geometry using ST_Multi, let me know if this is a problem

Usage

To get started, install coati, via npm install --save coati.

var coati = require('coati');
var config = require('./config');

coati.go('insert', {
  config: config,
  inputFilePath: 'data.json',
  tableName: 'countries',
  propertiesMap: ['ObjID:id', 'Country_Name:name'],
  geometryColumnName: 'geom'
});

The config format is JSON with the following structure:

{
  "user": "test",
  "password": "password",
  "database": "myDb",
  "host": "localhost"
}

Command Line

npm install -g coati
coati insert -f data.json -c db.config -t providers -g geom 'OBJECTID:id, ProvName:name'

See help, via coati -h for more information and available options.

Todo

  • Allow passing db arguments individually, e.g. --db.name, --db.host, --db.user, --db.password
  • Up for suggestions..

Special Thanks

To Calvin Metcalf, who wrote most of the original code.

License

License is located here.