kartotherian/geoshapes

Name: geoshapes

Owner: kartotherian

Description: Kartotherian service to generate geometric shapes from PostgreSQL data

Created: 2016-06-19 02:50:40.0

Updated: 2017-03-25 03:33:20.0

Pushed: 2017-10-12 22:45:29.0

Homepage: null

Size: 38

Language: JavaScript

GitHub Committers

User	Most Recent Commit	# Commits

Other Committers

User	Email	Most Recent Commit	# Commits

README

@kartotherian/geoshapes

Kartotherian service to generate geometric shapes from PostgreSQL data

See https://github.com/kartotherian/kartotherian

To configure, add geoshapes section to the kartotherian configuration with the following parameters:

hapes:
st: localhost
tabase: gis
ble: planet_osm_polygon
er: ...
ssword: ...

xidcount: (int, optional, default=500) - Maximum number of IDs to allow per request
lowUserQueries: (bool, optional, default=false) - If true, allow sql parameter + args to specify which SQL to use
kidataQueryService: (string, optional, default=https://query.wikidata.org/bigdata/namespace/wdq/sparql) - Lets user get a list of WikidataIDs from an external Wikidata Query Service. if false, disables.

Without this config block, the service will skip its loading

Make sure to create a Postgres index, e.g.:

TE INDEX planet_osm_polygon_wikidata
 planet_osm_polygon ((tags -> 'wikidata'))
ERE tags ? 'wikidata';

Service will return topojson to the queries such as /geoshape?ids=Q1384,Q1166 (get New York and Michigan state shapes). Save result as a file and upload to http://www.mapshaper.org/ to visualize.

Additionally, the service allows query=... parameter to get the Wikidata IDs from the http://query.wikidata.org service. It calls the service to execute a query, extracts IDs, and matches them with the shapes in the OSM database. All other values are returned as topojson object properties.

Optional truthy parameter getgeojson=1 will force the result to be returned as geojson rather than topojson.