dbgeo

Convert database query results to GeoJSON or TopoJSON. Inspired by Bryan McBride's PHP-Database-GeoJSON. Works with your database of choice - ideally paired with node-mysql, node-postgres, or mongodb. It is a more flexible version of postgeo and mysql2geojson (both deprecated).

Installation

npm install dbgeo

Example Usage

var dbgeo = require('dbgeo')

// Query a database...

dbgeo.parse(data, {
  outputFormat: 'geojson'
}, function(error, result) {
  // This will log a valid GeoJSON FeatureCollection
  console.log(result)  
});

See test/test.js for more examples.

API

.parse(data, options, callback)

data (required)

An array of objects, usually results from a database query.

options (optional)

Configuration object that can contain the following keys:

argument	description	values	default value
geometryType	Format of input geometry	wkb, wkt, geojson, ll	wkb
geometryColumn	Name of column that contains geometry. If input geometry type is "ll", this is an array in the format ['longitude', 'latitude']	Any string	geom
outputFormat	Desired output format	geojson, topojson	geojson
precision	Trim the coordinate precision of the output to a given number of digits using geojson-precision	Any integer	null (will not trim precision)
quantization	Value for quantization process, typically specified as powers of ten, see topojson.quantize	Any integer greater than one	null (no quantization)

callback (required)

A function with two parameters: an error, and a result object.

Examples can be found in test/test.js.

.defaults{}

The default options for .parse(). You can set these before using .parse() if you plan to use the same options continuously.

License

CC0