npub19lt4284mghqxekzm6n5njxurnxrxhqhrva2leusdsuu5ja5jeycq66qfjk (npub19lt…qfjk) I've noodled around with trying to write some code to turn all of OSM into a Foursquare-style venues database but haven't had the time.
My rough plan—a script that parses the entire OSM dataset and:
- filters out the features one wants based on a predicate (pubs, restaurants, public buildings, etc.)
- flattens ways/relations into points (calculate centroids)
- emits lat, long, label, OSM type+ID
Stick result in DB (SQLite+SpatiaLite appeals to me), index on coords, query N closest.
Tom Morris /
npub187…x3rzp
2024-01-28 16:19:10
in reply to nevent1q…cjrx
Author Public Key
npub187cryu7vlwfmgad5mgddh3msjhjejqg7knxn604nygqv604qge5q7x3rzpPublished at
2024-01-28 16:19:10Event JSON
{
"id": "4225e85aa385e6a8aaa41c427d34d09bbcfc0ab517af6decb81d0fd4f6288e7b",
"pubkey": "3fb03273ccfb93b475b4da1adbc77095e599011eb4cd3d3eb32200cd3ea04668",
"created_at": 1706458750,
"kind": 1,
"tags": [
[
"p",
"2fd7551ebb45c06cd85bd4e9391b8399866b82e36755fcf20d8739497692c930",
"wss://relay.mostr.pub"
],
[
"p",
"fddf487eea9db57a6e320f80e5cb63de50bedf539695a41c0d447be6c23643e1",
"wss://relay.mostr.pub"
],
[
"e",
"aa14a45a30e7d3c82f42a4f5b597c73125f36cdcd65883bb8893c6524e4fc1cb",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://mastodon.social/users/tommorris/statuses/111834480659858791",
"activitypub"
]
],
"content": "nostr:npub19lt4284mghqxekzm6n5njxurnxrxhqhrva2leusdsuu5ja5jeycq66qfjk I've noodled around with trying to write some code to turn all of OSM into a Foursquare-style venues database but haven't had the time.\n\nMy rough plan—a script that parses the entire OSM dataset and:\n\n- filters out the features one wants based on a predicate (pubs, restaurants, public buildings, etc.)\n- flattens ways/relations into points (calculate centroids)\n- emits lat, long, label, OSM type+ID\n\nStick result in DB (SQLite+SpatiaLite appeals to me), index on coords, query N closest.",
"sig": "6835d69268206ef1a584ef9d63306f00ecaae1679917e29d6a4e9c3e558a00a927ab82b5f2dc538c5db3c6167d1e98de33c76d0f008fc83e8c8a704fd0fa4425"
}