mrworldwide
v0.2.1
Published
Calculate OSM stats with AWS Athena and OSM PDS
Downloads
1
Readme
🌍 mrworldwide
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 runAWS_ACCESS_KEY_ID
: AWS access keyAWS_SECRET_ACCESS_KEY
: AWS secret keyAWS_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.