mrworldwide
Calculate OSM stats with AWS Athena and OSM PDS
Last updated 3 years ago by kamicut .
MIT · Original npm · Tarball · package.json
$ cnpm install mrworldwide 
SYNC missed versions from official npm registry.

???? mrworldwide npm version

Command line tool that queries the AWS OSM public datasets.

Installation

npm install -g mrworldwide

Usage

Currently to use the query command you should manually setup an Athena database and osm tables. The cli requires the following environment variables to be set:

  • ATHENA_PREFIX: A namespace for the database and database tables.
  • AWS_REGION: Region where the S3 bucket and Athena queries will run
  • AWS_ACCESS_KEY_ID: AWS access key
  • AWS_SECRET_ACCESS_KEY: AWS secret key
  • AWS_OUTPUT_BUCKET: Bucket where query results are stored

API

The cli is aliased to worldwide

Usage
  $ worldwide query <sql>
  $ echo <sql> | worldwide query

Examples
  $ worldwide query "SELECT count(*) from osm.changesets"

Built With

Under the hood, mrworldwide uses Amazon Athena and little-owl to run queries.

License

MIT - See LICENSE.md

Acknowledgments

This tool wouldn't be possible without @mojodna laying the groundwork with transcoding OSM to ORC and making it queryable with Athena.

Current Tags

  • 0.2.1                                ...           latest (3 years ago)

3 Versions

  • 0.2.1                                ...           3 years ago
  • 0.2.0                                ...           3 years ago
  • 0.1.0                                ...           3 years ago
Maintainers (1)
Downloads
Today 0
This Week 0
This Month 1
Last Day 0
Last Week 0
Last Month 3
Dependencies (9)
Dev Dependencies (0)
None
Dependents (0)
None

Copyright 2014 - 2016 © taobao.org |