Skip to content

Instantly share code, notes, and snippets.

@colindean

colindean/convert_pittmesh_nodes_to_geojson.bash

Last active September 6, 2017 02:25
Show Gist options
  • Save colindean/72b8143b2d2caaacc0ba2786f1a9b948 to your computer and use it in GitHub Desktop.
Save colindean/72b8143b2d2caaacc0ba2786f1a9b948 to your computer and use it in GitHub Desktop.
Download ZIP
http://www.pittmesh.net/node-data/nodes.json converted to GeoJSON format
Raw
convert_pittmesh_nodes_to_geojson.bash
#!/usr/bin/env bash
# nodes.json has JSONP crap on it so you have to remove
# the first and last line of the file before parsing it as JSON.
curl http://www.pittmesh.net/node-data/nodes.json | tail -n +2 | sed '$d' | jq -s '.[] | { type: "FeatureCollection", features: [ .[] | {type: "Feature", id: .name, properties: { address, hood, status, device_count }, geometry: { type: "Point", coordinates: [ .lon, .lat] } } ] }'
Display the source blob
Display the rendered blob
Raw
pittmesh-sites-20170905.geojson
{
"type": "FeatureCollection",
"features": [
{
"type": "Feature",
"id": "Onion Maiden",
"properties": {
"address": "639 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.99593829999998,
40.4217654
]
}
},
{
"type": "Feature",
"id": "AcademyPGH",
"properties": {
"address": "753 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.993901,
40.421875
]
}
},
{
"type": "Feature",
"id": "Squirrel Hill 1",
"properties": {
"address": "5618 Darlington Rd., Pittsburgh, PA 15217",
"hood": "Squirrel Hill",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.926868,
40.436666
]
}
},
{
"type": "Feature",
"id": "Sorgatron Media",
"properties": {
"address": "1619 Broadway Ave, Pittsburgh, PA 15216",
"hood": "Beechview",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-80.024493,
40.409928
]
}
},
{
"type": "Feature",
"id": "901 Wood Street 2401",
"properties": {
"address": "901 Wood Rear",
"hood": "Wilkinsburg",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.884627,
40.442785
]
}
},
{
"type": "Feature",
"id": "2301 Sarah",
"properties": {
"address": "2301 Sarah, Pittsburgh, PA 15203",
"hood": "South Side",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.9751609,
40.4276111
]
}
},
{
"type": "Feature",
"id": "Oporto and Gregory Street",
"properties": {
"address": "Gregory Street, Pittsburgh, PA 15213",
"hood": "South Side Slopes",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.979045,
40.423906
]
}
},
{
"type": "Feature",
"id": "Nyia Page Community Center",
"properties": {
"address": "416 Library Street, Braddock, PA 15104",
"hood": "Braddock",
"status": "planned",
"device_count": 0
},
"geometry": {
"type": "Point",
"coordinates": [
-79.865015,
40.401426
]
}
},
{
"type": "Feature",
"id": "Studebaker Metals",
"properties": {
"address": "534 Braddock, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.869668,
40.403726
]
}
},
{
"type": "Feature",
"id": "Wilkins 2401",
"properties": {
"address": "6739 Wilkins Ave, Pittsburgh, PA, 15217",
"hood": "Point Breeze",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.912112,
40.446954
]
}
},
{
"type": "Feature",
"id": "A Boss Opticians",
"properties": {
"address": "614 Braddock Ave, Braddock, PA, 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.868175,
40.402926
]
}
},
{
"type": "Feature",
"id": "Calvary United Methodist Church",
"properties": {
"address": "954 Beech Ave, Pittsburgh, PA 15233",
"hood": "North Side",
"status": "live",
"device_count": 6
},
"geometry": {
"type": "Point",
"coordinates": [
-80.018727,
40.452192
]
}
},
{
"type": "Feature",
"id": "Infamous Cutz",
"properties": {
"address": "704 Braddock Ave, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.86723,
40.402181
]
}
},
{
"type": "Feature",
"id": "United Steelworkers Building",
"properties": {
"address": "1070 Braddock Ave, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.862365,
40.398575
]
}
},
{
"type": "Feature",
"id": "Penguino Labs",
"properties": {
"address": "20-1/2 South 13th",
"hood": "South Side",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.985556,
40.430472
]
}
},
{
"type": "Feature",
"id": "Free Press Building",
"properties": {
"address": "528 Braddock Ave, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.869722,
40.40399
]
}
},
{
"type": "Feature",
"id": "Penn Forest",
"properties": {
"address": "121 Colorado st., Verona, PA 15147",
"hood": "Verona",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.824518,
40.512492
]
}
},
{
"type": "Feature",
"id": "Anonymous",
"properties": {
"address": "700 block Carnival Way., Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.994728,
40.422404
]
}
},
{
"type": "Feature",
"id": "5000 Hobart",
"properties": {
"address": "5000 Hobart st., Pittsburgh, PA 15217",
"hood": "Squirrel Hill",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.927568,
40.432635
]
}
},
{
"type": "Feature",
"id": "Braddock Farms",
"properties": {
"address": "1008 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.863357,
40.398973
]
}
},
{
"type": "Feature",
"id": "Braddock Employment Training Center",
"properties": {
"address": "1008 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.864795,
40.400654
]
}
},
{
"type": "Feature",
"id": "Braddock Bark Park",
"properties": {
"address": "717 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.866813,
40.401804
]
}
},
{
"type": "Feature",
"id": "Superior Motors",
"properties": {
"address": "1215 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.860623,
40.397696
]
}
},
{
"type": "Feature",
"id": "Golden Treasures",
"properties": {
"address": "709 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.867468,
40.402621
]
}
},
{
"type": "Feature",
"id": "UnSmoke Systems Art Space",
"properties": {
"address": "1137 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.860981,
40.397833
]
}
},
{
"type": "Feature",
"id": "Bell's Market",
"properties": {
"address": "603 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.868299,
40.403215
]
}
},
{
"type": "Feature",
"id": "Peppers N'at",
"properties": {
"address": "28 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.873747,
40.406155
]
}
},
{
"type": "Feature",
"id": "37 Wood Street",
"properties": {
"address": "37 Wood Street, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.859311,
40.398129
]
}
},
{
"type": "Feature",
"id": "Ink Division",
"properties": {
"address": "218 Braddock Ave., Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.872762,
40.405658
]
}
},
{
"type": "Feature",
"id": "79 Allen st.",
"properties": {
"address": "79 Allen St., Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.994101,
40.421025
]
}
},
{
"type": "Feature",
"id": "Hilltop Pharmacy",
"properties": {
"address": "818 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.992906,
40.421743
]
}
},
{
"type": "Feature",
"id": "Moose Mode",
"properties": {
"address": "112 E Sherman, Millvale, PA 15209",
"hood": "Millvale",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.971535,
40.479748
]
}
},
{
"type": "Feature",
"id": "125 Locust Street, Mt Oliver, PA 15210",
"properties": {
"address": "125 Locust Street, Mt Oliver, PA 15210",
"hood": "Mt. Oliver",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.986348,
40.416665
]
}
},
{
"type": "Feature",
"id": "127 Brownsville Rd., Mt Oliver, PA 15210",
"properties": {
"address": "127 Brownsville Rd., Mt Oliver, PA 15210",
"hood": "Mt. Oliver",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.986724,
40.416747
]
}
},
{
"type": "Feature",
"id": "600 E Warrington Ave",
"properties": {
"address": "600 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.99721378087997,
40.42162363944305
]
}
},
{
"type": "Feature",
"id": "WorkHardPGH",
"properties": {
"address": "744 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.99411851167679,
40.42178246558993
]
}
},
{
"type": "Feature",
"id": "1206 Arlington Ave",
"properties": {
"address": "1206 Arlington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.99228522181511,
40.42146770067946
]
}
},
{
"type": "Feature",
"id": "Subfortress",
"properties": {
"address": "1733 Arlington Ave, Pittsburgh, PA 15210",
"hood": "South Side Slopes",
"status": "live",
"device_count": 5
},
"geometry": {
"type": "Point",
"coordinates": [
-79.98515456914902,
40.417765492763436
]
}
},
{
"type": "Feature",
"id": "UniqueHome",
"properties": {
"address": "815 E Warrington Ave, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.9931352,
40.421876
]
}
},
{
"type": "Feature",
"id": "HackPGH",
"properties": {
"address": "1936 5th Avenue, Pittsburgh, PA 15219",
"hood": "Uptown",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.9780909717083,
40.437934569892626
]
}
},
{
"type": "Feature",
"id": "Paramount Film Exchange",
"properties": {
"address": "544 Miltenberger St., Pittsburgh, PA 15219",
"hood": "Uptown",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.9818112,
40.4359199
]
}
},
{
"type": "Feature",
"id": "RE360",
"properties": {
"address": "829 Industry Street, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.992794,
40.421108
]
}
},
{
"type": "Feature",
"id": "Caliguiri Building",
"properties": {
"address": "803 East Warrington Avenue, Pittsburgh, PA 15210",
"hood": "Allentown",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.993279,
40.422169
]
}
},
{
"type": "Feature",
"id": "South Side Comics",
"properties": {
"address": "1931 East Carson st, Pittsburgh, PA 15203",
"hood": "South Side",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.97786,
40.42872
]
}
},
{
"type": "Feature",
"id": "631 Brookline Blvd.",
"properties": {
"address": "631 Brookline Blvd., Pittsburgh, PA 15226",
"hood": "Brookline",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-80.021332,
40.395048
]
}
},
{
"type": "Feature",
"id": "Brew Gentlemen Brewery",
"properties": {
"address": "512 Braddock Ave, Braddock, PA 15104",
"hood": "Braddock",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.870165,
40.404438
]
}
},
{
"type": "Feature",
"id": "1415 Milan Ave",
"properties": {
"address": "1415 Milan Ave, Brookline, 15226",
"hood": "Brookline",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-80.008284,
40.394291
]
}
},
{
"type": "Feature",
"id": "Crookline Data Center",
"properties": {
"address": "1517 Milan Ave, Brookline, 15226",
"hood": "Brookline",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-80.004999,
40.394356
]
}
},
{
"type": "Feature",
"id": "The Free Store",
"properties": {
"address": "401-465 Braddock Ave",
"hood": "Braddock",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.870861,
40.404736
]
}
},
{
"type": "Feature",
"id": "421 Orchard Place",
"properties": {
"address": "421 Orchard Place",
"hood": "Allentown",
"status": "live",
"device_count": 3
},
"geometry": {
"type": "Point",
"coordinates": [
-79.996358,
40.418099
]
}
},
{
"type": "Feature",
"id": "Beehive Coffeehouse",
"properties": {
"address": "1327 East Carson Ave",
"hood": "South Side",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.98425,
40.428918
]
}
},
{
"type": "Feature",
"id": "Winton St. and Craighead St",
"properties": {
"address": "Winton St. and Craighead St",
"hood": "Allentown",
"status": "live",
"device_count": 2
},
"geometry": {
"type": "Point",
"coordinates": [
-79.998515,
40.423068
]
}
},
{
"type": "Feature",
"id": "97 South 23rd Street",
"properties": {
"address": "97 South 23rd Street",
"hood": "South Side",
"status": "live",
"device_count": 4
},
"geometry": {
"type": "Point",
"coordinates": [
-79.972932,
40.427916
]
}
},
{
"type": "Feature",
"id": "Black Beauty's Bar",
"properties": {
"address": "2037 Centre Ave, Pittsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.979147,
40.444325
]
}
},
{
"type": "Feature",
"id": "Warren United Methodist",
"properties": {
"address": "2606 Centre Ave, Pittsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.968122,
40.446502
]
}
},
{
"type": "Feature",
"id": "Hill CDC",
"properties": {
"address": "2015 Centre Ave, Pittsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.979942,
40.443991
]
}
},
{
"type": "Feature",
"id": "Hill District Federal Credit Union",
"properties": {
"address": "2021 Centre Ave, Pittsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.979709,
40.444092
]
}
},
{
"type": "Feature",
"id": "Gaudenzia Erie Inc",
"properties": {
"address": "2012 Centre Ave, Pittsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.979867,
40.443818
]
}
},
{
"type": "Feature",
"id": "MOKA Art Gallery",
"properties": {
"address": "502 Soho Street, Pitsburgh, PA 15219",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.973935,
40.445296
]
}
},
{
"type": "Feature",
"id": "Power 59 LLC",
"properties": {
"address": "2503 Centre Ave",
"hood": "Hill District",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-79.970507,
40.445591
]
}
},
{
"type": "Feature",
"id": "Riverview Park site A",
"properties": {
"address": "57 Riverview Ave. ",
"hood": "Perry North",
"status": "live",
"device_count": 1
},
"geometry": {
"type": "Point",
"coordinates": [
-80.016651,
40.483098
]
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment