MySQL2GeoJSON

A Node.js module for returning MySQL query results as usable GeoJSON or TopoJSON objects. Ideally paired with node-mysql.

Installation

npm install mysql2geojson

Example Usage

var mysql2geojson = require("mysql2geojson");

// MySQL query...

mysql2geojson.parse({
	"data": data,
	"format": "geojson",
	"callback": function(error, result) {
		if (error) {
		   console.log(error);
		}
		// This will log a valid GeoJSON object
		console.log(result)
	}
});

API

parse(params)

params is an object that contains the following keys:

• data (required) - Results from a MySQL query. Geometry must be selected AsWKT.
• format - can be either "geojson" or "topojson". Default is "geojson".
• geometry - name of column that contains geometry. Default is "geometry".
• callback(error, result) (required) - a function with two parameters: an error, and a result object

License

CC0