The city site has a variety of export formats. I tried "File Geodatabase" and was able to load it from the console into a database. Slow but it worked in 3.42; next test 4.2.1.
{
"id":"f044eace73ee29c44fb9d79dccf52abc74e02a3e729976d459af8d19cdf84ae1",
"pubkey":"54295cb470d978a9d46c65a02c8a94f6eddf3f0a57bd536e72b18b557fff67c5",
"created_at":1787231012,
"kind":1,
"tags": [
[
"p",
"df40f8a27a121771783ce5b714faf03a8ab0c57a5d3eac30844923d139836c2b",
"wss://relay.ditto.pub"
],
[
"p",
"c6eb8b83550145d5a7a803b4a7ae0be9ebd5286a5fee9a0d56c24236c0174589",
"wss://relay.ditto.pub"
],
[
"e",
"b78232d4f231039b164bb085bfc512fdca79962dcaa9913c455dd172ea5454cf",
"wss://relay.ditto.pub",
"reply"
],
[
"imeta",
"url https://assets.chaos.social/media_attachments/files/117/127/952/823/204/724/original/c9f23c446371d3c6.png",
"m image/png",
"dim 1389x986",
"blurhash UOQJcP-?pMxaayR.Z~o#IWRjoaW=M~n#kCWB"
],
[
"imeta",
"url https://assets.chaos.social/media_attachments/files/117/127/966/774/996/155/original/0915c6812018cc1e.png",
"m image/png",
"dim 816x288",
"blurhash UIR3Wc_34nxCD%NGRPkD%fRk%MWW~qRjxuV@"
],
[
"proxy",
"https://chaos.social/users/jspath55/statuses/117127971629551525",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content":"nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqmaq03gn6zgthz7puukm3f7hs829tp3t6t5l2cvyyfy3azwvrds4sw5kwhx Once I learned you can drag a layer created from a file in QGIS into a PG database I got spoilt! Hard to go back and look at SQL/DDL code. Ha.\n\nThe city site has a variety of export formats. I tried \"File Geodatabase\" and was able to load it from the console into a database. Slow but it worked in 3.42; next test 4.2.1.\n\nhttps://assets.chaos.social/media_attachments/files/117/127/952/823/204/724/original/c9f23c446371d3c6.png\nhttps://assets.chaos.social/media_attachments/files/117/127/966/774/996/155/original/0915c6812018cc1e.png",
"sig":"f06ef1ffa789a44ccbc4fab9830bda08805ab07d06d7b8bd6a1c4ceea616757c202957a1be8d2cc47e57c3a2861a6246f7340ec151c482274911ddbac36178ae"
}