Skip to content

naturalatlas/tilestrata-postgis-geojson-tiles

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

19 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

tilestrata-postgis-geojson-tiles

Tilestrata plugin for generating geojson tiles from postgis.

Configuration

  • geometryField (string, required): name of column containing geometry. (default = "geom")
  • sql (function, required): method that returns a PostGIS query that will be executed. Be sure to protect against sql injection if doing dynamic filtering based on the request query string. The query can contain the following tokens:
    • {bbox} (box2d): the buffered tile bounding box
    • {geojson} (text): the geojson representation of the clipped and simplified geometry as text
  • pgConfig (object, required): postgres connection options
    • {host} (string)
    • {password} (string)
    • {user} (string)
    • {port} (string)
    • {database} (string)
  • simplifyFactor (number, optional): a constant affecting how much the geometry is simplified. (default = 0.75)
  • buffer (number, optional): the amount of buffer around each tile in pixels. (default = 16)
  • collectGeometry (boolean, optional): bundle all geometries together into a single geometry with ST_Collect before converting to GeoJSON. (default = false)
  • mergeMultiLineStrings (boolean, optional): whether to try merging MultiLineStrings with ST_LineMerge before converting to GeoJSON. (default = false)
  • dumpGeometry (boolean, optional): whether or not to use ST_Dump to break apart geometry collections. (default = false)

Example

var tilestrataPostGISGeoJSON = require('tilestrata-postgis-geojson-tiles');
var querystring = require('querystring');

var layer = server.layer('geojson-tiles', {minZoom: 5, maxZoom: 14});

// .../geojson-tiles/tile.json?id=12345
layer
  .route('tile.json')
    .use(headers({
      'Access-Control-Allow-Origin': '*'
    }))
    .use(tilestrataPostGISGeoJSON({
      geometryField: 'geom',
      sql: function(server, req) {
        var qs = querystring.parse(req.qs);
        var id = qs && qs.id ? parseInt(qs.id, 10) : null;

        return 'SELECT id, name, {geojson} FROM tablename WHERE ST_Intersects(geom, {bbox}) AND id = ' + id;
      },
      pgConfig: {
        username: 'postgres',
        password: 'password',
        host: 'localhost',
        port: '5432',
        database: 'postgres'
      }
    }));

About

Tilestrata plugin for generating geojson tiles from postgis

Resources

Stars

Watchers

Forks

Packages

No packages published