Skip to content

developmentseed/mrworldwide

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
bin
 
 
lib
 
 
sql
 
 
 
 
 
 
 
 
 
 
 
 
 
 

🌍 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.

About

Query OSM planet stats with AWS Athena

Resources

License

Stars

Watchers

Forks

Packages

No packages published