simonw/museums

A website recommending niche museums to visit

niche-museums.com

https://www.niche-museums.com/about

Read niche-museums.com, powered by Datasette for a detailed explanation of how this all works.

The content on this site (primary contained in museums.yaml) is licensed CC BY-NC-SA 4.0

museums's Issues

Normalize countries and make them searchable

There is an osm_country column at the moment but it's inconsistent:

It's included in the FTS configuration so ideally searching for "japan" would return all museums in Japan - but that doesn't actually work.

Solution: populate a new country column derived from the osm_country_code column, which appears to be more reliable.

Reduce CSS size by eliminating unused bits of Bulma

https://css-tricks.com/how-do-you-remove-unused-css-from-a-site/ is a useful guide to doing this.

I'm seeing promising results from https://purifycss.online/ by pasting in these two URLs (to ensure I get the "permanently closed" styles): https://www.niche-museums.com/ and https://www.niche-museums.com/browse/museums/3

Suggestion: add the Mmuseumm

See https://www.mmuseumm.com/ and https://en.wikipedia.org/wiki/Mmuseumm

Happy to open a PR if it can help! Thanks

Misalignment museum location - moved

The misalignment museum moved to out in front of Chase Stadium. I'm not sure how long their deal to stay there lasts. Might be nice to email them to ask, and ask for updates if/when the move again.

museums/museums.yaml

Line 2986 in 8917152

address: 201 Guerrero Street, San Francisco, CA 94103

Add an atom feed

Requested here: https://projects.metafilter.com/5697/Niche-Museums#14011

Hiller Aviation Museum listed twice

On the "near you" page:

Implement search

Prototype:

• https://www.niche-museums.com/browse?sql=select+museums.id%2C+museums.name%2C+museums_fts.rank+from+museums+join+museums_fts+on+museums.id+%3D+museums_fts.rowid+where+museums_fts+match+%3Asearch+order+by+museums_fts.rank&search=space
• https://www.niche-museums.com/browse?sql=select%0D%0A++museums.id%2C%0D%0A++museums.name%2C%0D%0A++museums_fts.rank%0D%0Afrom%0D%0A++museums%0D%0A++join+museums_fts+on+museums.id+%3D+museums_fts.rowid%0D%0Awhere%0D%0A++museums_fts+match+%3Asearch%0D%0Aorder+by%0D%0A++museums_fts.rank&search=san+francisco

Rogue <div style="white-space: normal"> in feeds

It looks like a change to Datasette has caused datasette-atom to start outputting feed items like this:

https://www.niche-museums.com/browse/feed.atom

<content type="html">
&lt;img src="https://niche-museums.imgix.net/hearst-castle.jpeg?w=800&amp;amp;h=400&amp;amp;fit=crop&amp;amp;auto=compress"&gt;
&amp;lt;div style="white-space: normal"&amp;gt;&lt;p&gt;In 1919 press baron William Randolph Hearst commissioned ...

That <div style="white-space: normal"> should not be there!

Dalby Datormuseum

http://www.datormuseum.se/

https://www.google.com/maps/place/Dalby+Datormuseum/@59.4897028,17.0471171,17z/data=!3m1!4b1!4m6!3m5!1s0x465e560d14c77e8b:0xbecd4550091cef1a!8m2!3d59.4897001!4d17.049692!16s%2Fg%2F11cjp9qt_w

Twitter cards aren't displaying

https://twitter.com/simonw/status/1502801454687424512

https://www.niche-museums.com/30

Shorter URLs for museum pages

Right now they are:

https://www.niche-museums.com/browse/museums/102

I'd like to shorten these to just:

https://www.niche-museums.com/102

Using the new custom template page parameters feature in Datasette 0.49.

Don't reverse geocode every museum on every commit

The reverse geocoding annotation script currently runs against every single museum on every commit, which is inefficient.

Instead, it should download the previous version of the database from https://www.niche-museums.com/browse.db and only run against the records that have not yet had their various osm_ columns populated.

This depends on simonw/sqlite-utils#66 so I can use a corrected version of upsert.

Tweet new listings automatically from @nichemuseums

I have an API key setup for this account. I want to tweet new listings from it.

Enable stemming for search

This search: https://www.niche-museums.com/browse/search?q=Train

Did not return this museum, which mentions "trains" in the description: https://www.niche-museums.com/13

Or this one (Mail Rail): https://www.niche-museums.com/68

Map tiles not loading

Currently on https://www.niche-museums.com/map (tried in FF and Chrome)

Include press and extra photos in the Atom feed

Press article dates should be YYYY-MM-DD

Also sanity check existing dates - I think the jAdis one is incorrect for example.

Upgrade to datasette-template-sql 1.0

I can clean this up:

museums/templates/row-browse-museums.html

Lines 69 to 74 in 842dfb9

	{% for museum in sql(
	"select *, haversine(latitude, longitude, " ~ museum["latitude"] ~
	", " ~ museum["longitude"] ~ ", 'mi') as distance_mi " ~
	"from museums where id != " ~ museum["id"] ~
	" and permanently_closed is null order by distance_mi limit 3"
	) %}

Refs simonw/datasette-template-sql#1

Add a map

The site deserves a map.

There's a secret one at https://www.niche-museums.com/browse/museums but I want an appropriately styled one at /map that's linked from the navigation.

Depends on simonw/datasette#648

Migrate to Cloud Run

Zeit v1 is being turned off in August.

Bug: everything says updated 17th April 2020 today

https://twitter.com/kevinmarks/status/1251260017241731074

JSON serializable in annotate_timestamps

Caused by #7.

https://circleci.com/gh/simonw/museums/123

Traceback (most recent call last):
  File "annotate_timestamps.py", line 39, in <module>
    for id in current
  File "annotate_timestamps.py", line 40, in <listcomp>
    if json.dumps(current[id], sort_keys=True)
  File "/usr/local/lib/python3.6/json/__init__.py", line 238, in dumps
    **kw).encode(obj)
  File "/usr/local/lib/python3.6/json/encoder.py", line 199, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "/usr/local/lib/python3.6/json/encoder.py", line 257, in iterencode
    return _iterencode(o, 0)
  File "/usr/local/lib/python3.6/json/encoder.py", line 180, in default
    o.__class__.__name__)
TypeError: Object of type 'date' is not JSON serializable

Redirect niche-museums.com to www.niche-museums.com

Split from #20

created and updated dates in DB, derived from git history

Needed for #5. I can use a similar technique to the code in https://github.com/simonw/pge-outages/blob/master/build_database.py

Figure out how to accept submissions

Originally I had intended to accept submissions, but over the past few weeks I've really enjoyed writing my own editorialized captions and using photos I've taken on the site (e.g. https://www.niche-museums.com/browse/museums/43)

But... now I'm getting offers of submissions! https://twitter.com/davidnunez/status/1199424444541751297 and https://twitter.com/brycem/status/1199415935263625216 for example.

I want both. I want to be able to keep my personal "museums I've been to" vibe going, but I also want to collect tips from other people (so when I'm traveling the "Use my location" button can show me places people have suggested).

Need to figure out the neatest way to combine tips from other people with my own personal notes on niche museums that I've visited and loved.

Add Google Analytics

I don't even have server logs at the moment. Would be nice to know if anyone is using it!

Remove the about.db and map.db hacks

museums/build.sh

Lines 3 to 4 in bc06dd7

	sqlite3 about.db ""
	sqlite3 map.db ""

These hacks are so I can have custom templates for the /about and /map pages - but they are no longer needed thanks to this Datasette feature: https://docs.datasette.io/en/stable/custom_templates.html#custom-pages

Show press articles on museum pages, if available

A few museums have press articles in the YAML file but these are not yet displayed on the site:

museums/museums.yaml

Lines 30 to 35 in 4e61f4a

	press:
	- url: https://roadtrippers.com/magazine/bigfoot-discovery-museum-santa-cruz/
	title: "Searching for Bigfoot: If the elusive creature exists, he’s probably hiding deep in the Santa Cruz Mountains"
	publication: Explore Magazine
	author: Shoshi Parks
	date: 20-06-2019

Twitter cards and Facebook og metadata for listings

<meta name="twitter:card" content="summary">
<meta name="twitter:site" content="@publisher_handle">
<meta name="twitter:title" content="Page Title">
<meta name="twitter:description" content="{{ ">
<meta name="twitter:creator" content="@author_handle">
<-- Twitter Summary card images must be at least 120x120px -->
<meta name="twitter:image" content="http://www.example.com/image.jpg">

<!-- Open Graph data -->
<meta property="og:title" content="Title Here" />
<meta property="og:type" content="article" />
<meta property="og:url" content="http://www.example.com/" />
<meta property="og:image" content="http://example.com/image.jpg" />

Atom feed should include paragraph breaks

I started using markdown in a9e1051 but it's not rendered in the Atom feed.

Since the feed is rendered using a SQL query and https://github.com/simonw/datasette-atom I can solve this by adding markdown rendering as a custom SQL function.

Switch photo gallery to photoswipe

I used it for this and really liked it: https://simonwillison.net/2022/May/16/weeknotes/