Skip to content

Instantly share code, notes, and snippets.

View mvexel's full-sized avatar

Martijn van Exel mvexel

View GitHub Profile
#!/bin/bash
DIR=~/osm/data/us-cities/
for city in austin charlotte chicago columbus dallas denver fort_worth houston indianapolis jacksonville los_angeles new_york_city philadelphia phoenix san_antonio san_diego san_francisco san_jose seattle washington_dc; do
echo "Processing $city (file $DIR${city}.osm.pbf)"
osmium tags-filter --overwrite -o $DIR${city}-just-freeways.osm.pbf $DIR${city}.osm.pbf w/highway=motorway,motorway_link,trunk,trunk_link
osmium cat --overwrite -o $DIR${city}-just-freeway-nodes.osm.pbf $DIR${city}-just-freeways.osm.pbf -t node
done
{
"extracts": [
{
"output": "new_york_city.osm.pbf",
"output_format": "pbf",
"description": "New York City, NY",
"bbox": {
"left": -74.2591,
"bottom": 40.4774,
"right": -73.7004,
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
tables:
admin:
columns:
- name: osm_id
type: id
- name: geometry
type: geometry
- key: name
name: name
type: string

Hi,

I noticed you recently started mapping in the Salt Lake City area. Welcome! I am a fellow mapper living in SLC. I have been contributing to OSM since 2007. If you have any questions please just drop me a line.

We have a small local group of OSM mappers that get together from time to time in / near downtown SLC, usually on the second Wednesday of the month. You’re welcome to join us! We announce our events on OSMCal.

If you’re a Slack user (or don’t mind becoming one), there is an active and friendly community of OSM mappers there, and we have a #local-utah channel on it. You can join via this link.

Happy mapping!

@mvexel
mvexel / amazon.oql
Created May 3, 2021 22:04
amazon query
area[name="Utah"]->.a;
nwr(user:"abidhm", "abirseng", "abvincen", "accheela", "achsaw", "achyutha", "aepunavy", "afurquan", "aggopak", "agnisn", "ahabdu", "airangam", "ajijohn", "ajitak", "akalohri", "allkrupa", "amanura", "amarajz", "ambarapu", "amitbish", "amithrav", "ammrita", "amzmkuma", "amznruth", "aniaswin", "anuds", "anukrits", "anuvashi", "appank", "apsai", "arehaan", "arfif", "arjuu", "arkdatta", "arrojuh", "ashbeesa", "ashradha", "asnghpi", "asrdd", "attaragi", "avipsha", "avssr", "bachurev", "baggg", "baigzake", "bakarapu", "bansimmi", "bashwith", "bathines", "bathis", "bdevek", "befit1", "begumfai", "bhanuban", "bhardwk", "bhavant", "bhiy", "bibasra", "bjnlm", "bmmh", "bmmundad", "bmuskaan", "bnilima", "boddushr", "bommbabu", "bongaram", "borramou", "borvikas", "branib", "bsreeja", "bttejas", "buchula", "buddhirv", "bvvams", "chagasru", "chandeek", "chatrags", "chaturvh", "chauaak", "chaubean", "chekasat", "chepteja", "chepurb", "chettups", "chharsha", "chhava", "chitikv", "chosayan", "cpalanki",
@mvexel
mvexel / counties.csv
Last active February 13, 2021 17:17
USA counties in OSM
@id name nist:fips_code nist:state_fips
36074 Erie County 36029 36
36267 Niagara County 36063 36
60803 Bennington County 50003 50
60807 Windham County 50025 50
60836 Windsor County 50027 50
60838 Rutland County 50021 50
61321 Berkshire County 25003 25
62000 Grand Isle County 50013 50
62001 Franklin County 50011 50