Locations like recTBXuIjttVmmZ88 not exported to mapbox or API due to availability tags

[simonw]

https://vial.calltheshots.us/api/exportMapboxPreview?id=recTBXuIjttVmmZ88 returns this:

{
  "geojson": []
}

It should return something that looks like https://vial.calltheshots.us/api/exportMapboxPreview?id=recfh4U54QFppdCRw

The https://vial.calltheshots.us/location/recTBXuIjttVmmZ88 page returns a 500 - which is caused by it trying to fetch that mapbox representation and failing: https://sentry.io/organizations/vaccinateca/issues/2457478645/?environment=production&project=5649843&query=is%3Aunresolved

Here it is in the database: https://vial.calltheshots.us/dashboard/?sql=select+id%2C+name%2C+full_address%2C+soft_deleted+from+location+where+public_id+%3D+%27recTBXuIjttVmmZ88%27%3Aco3pgz0qKdFPsd5YdtqRcT76JfHC2F5hKhLMZ9PiCb4 - it's not soft deleted.

And in our API search: https://vial.calltheshots.us/api/searchLocations?id=recTBXuIjttVmmZ88

[simonw]

Found this while investigating #702.

[simonw]

I now have 353 examples of IDs that were reported as missing in #702 and for which the mapbox export preview comes back as an empty JSON object. I'm going to tag them _issue:701.

[simonw]

{"update": {"recTBXuIjttVmmZ88": {"add": ["_issue:701"]}, "lxkmx": {"add": ["_issue:701"]}, "ltqzp": {"add": ["_issue:701"]}, "recqLxncNzaHFB3pH": {"add": ["_issue:701"]}, "recQk586YLNgNCgKZ": {"add": ["_issue:701"]}, "lzdfc": {"add": ["_issue:701"]}, "recfppJw1iohUIzkf": {"add": ["_issue:701"]}, "recBlF7wz1XWqnTiy": {"add": ["_issue:701"]}, "lfgcg": {"add": ["_issue:701"]}, "lwcpc": {"add": ["_issue:701"]}, "lfxym": {"add": ["_issue:701"]}, "rec5YJjLMDaq2WzLX": {"add": ["_issue:701"]}, "lymkm": {"add": ["_issue:701"]}, "recHJp3otkOV4XsxK": {"add": ["_issue:701"]}, "lrzzh": {"add": ["_issue:701"]}, "reco1qQ00tqM4uoUG": {"add": ["_issue:701"]}, "recwScURbz1wdNvaY": {"add": ["_issue:701"]}, "lcbffm": {"add": ["_issue:701"]}, "lxqmq": {"add": ["_issue:701"]}, "rec900HjC7frkO7Bw": {"add": ["_issue:701"]}, "lrtpw": {"add": ["_issue:701"]}, "lrfdf": {"add": ["_issue:701"]}, "recsrbNZaMIrnMrMf": {"add": ["_issue:701"]}, "lhcbz": {"add": ["_issue:701"]}, "rec1oX3E4pVUrTgUe": {"add": ["_issue:701"]}, "lrkpz": {"add": ["_issue:701"]}, "recAAs5NlIw5pyWz2": {"add": ["_issue:701"]}, "lwfzx": {"add": ["_issue:701"]}, "rec2SOFxyVbERClP7": {"add": ["_issue:701"]}, "reciOqJTJzlLmCiz1": {"add": ["_issue:701"]}, "lxyrd": {"add": ["_issue:701"]}, "rec01FPGB9PljgOyU": {"add": ["_issue:701"]}, "recfXZR9QpgEceQkP": {"add": ["_issue:701"]}, "recFWgSMNhHjq0AJi": {"add": ["_issue:701"]}, "lzdfq": {"add": ["_issue:701"]}, "lhfzr": {"add": ["_issue:701"]}, "recRqOaAyEvtBdRt8": {"add": ["_issue:701"]}, "lcckxb": {"add": ["_issue:701"]}, "recHw7mapkdBZ57LM": {"add": ["_issue:701"]}, "lzmzg": {"add": ["_issue:701"]}, "lxzgr": {"add": ["_issue:701"]}, "rec15R9HTq9pO7z12": {"add": ["_issue:701"]}, "lzdfm": {"add": ["_issue:701"]}, "rec1zCybNRxIiI3fx": {"add": ["_issue:701"]}, "rec2rqAzyhAHlj6cc": {"add": ["_issue:701"]}, "lthcd": {"add": ["_issue:701"]}, "recsd9KHhxULnnkGk": {"add": ["_issue:701"]}, "rechyCyko8Io67DGy": {"add": ["_issue:701"]}, "recHiTx88kN10qrLV": {"add": ["_issue:701"]}, "recgkfGPsukay6ycp": {"add": ["_issue:701"]}, "lzpbf": {"add": ["_issue:701"]}, "lrbbh": {"add": ["_issue:701"]}, "lzkct": {"add": ["_issue:701"]}, "lzdtd": {"add": ["_issue:701"]}, "recFbYWvQHO2x4VBR": {"add": ["_issue:701"]}, "recsgkNG8VyKcPWR4": {"add": ["_issue:701"]}, "lcbgzb": {"add": ["_issue:701"]}, "lwkbf": {"add": ["_issue:701"]}, "recGY0pVqlN5BGGya": {"add": ["_issue:701"]}, "lhfft": {"add": ["_issue:701"]}, "lymmx": {"add": ["_issue:701"]}, "lcbgzp": {"add": ["_issue:701"]}, "recYLyLKDFvfSRA1q": {"add": ["_issue:701"]}, "ltrfy": {"add": ["_issue:701"]}, "rec6V23ChSzRoWLvr": {"add": ["_issue:701"]}, "lrmmz": {"add": ["_issue:701"]}, "lrgth": {"add": ["_issue:701"]}, "lccktc": {"add": ["_issue:701"]}, "rechseBi0gmw7qv1u": {"add": ["_issue:701"]}, "lkrpz": {"add": ["_issue:701"]}, "recD9xp5vBRQN5nKq": {"add": ["_issue:701"]}, "lxktc": {"add": ["_issue:701"]}, "lxtyr": {"add": ["_issue:701"]}, "ltyqz": {"add": ["_issue:701"]}, "lhcbd": {"add": ["_issue:701"]}, "recVmDgwalHxjnb12": {"add": ["_issue:701"]}, "lrkwm": {"add": ["_issue:701"]}, "lttxg": {"add": ["_issue:701"]}, "lxzhz": {"add": ["_issue:701"]}, "lyhkg": {"add": ["_issue:701"]}, "recXVLzOmp9LWmfpU": {"add": ["_issue:701"]}, "lhbgz": {"add": ["_issue:701"]}, "lrmwz": {"add": ["_issue:701"]}, "lwpzg": {"add": ["_issue:701"]}, "recDlL3aOAxTcTCFF": {"add": ["_issue:701"]}, "lxyft": {"add": ["_issue:701"]}, "rec7YkYZdgCzSGPwx": {"add": ["_issue:701"]}, "lwbtf": {"add": ["_issue:701"]}, "lcbfxf": {"add": ["_issue:701"]}, "recZJgV2lbKd4PFPM": {"add": ["_issue:701"]}, "lhfdd": {"add": ["_issue:701"]}, "rec84P0O7xaUynbYc": {"add": ["_issue:701"]}, "ltygc": {"add": ["_issue:701"]}, "lzcdz": {"add": ["_issue:701"]}, "lcdhmd": {"add": ["_issue:701"]}, "recswntOb9F73dqR3": {"add": ["_issue:701"]}, "recWttM0DeBhRkCAJ": {"add": ["_issue:701"]}, "lxtmr": {"add": ["_issue:701"]}, "lrfqp": {"add": ["_issue:701"]}, "ldkty": {"add": ["_issue:701"]}, "recUFVGKor3nQLNIX": {"add": ["_issue:701"]}, "lcbhbd": {"add": ["_issue:701"]}, "recxXpuCQiHj8jX2f": {"add": ["_issue:701"]}, "lztrw": {"add": ["_issue:701"]}, "recFsSzCqRXCZQs6A": {"add": ["_issue:701"]}, "reckIuDqL8Hf1cFjR": {"add": ["_issue:701"]}, "ltmbk": {"add": ["_issue:701"]}, "rec3HKHENGsXizExo": {"add": ["_issue:701"]}, "recHiDtjJ9A750qfI": {"add": ["_issue:701"]}, "ltkfg": {"add": ["_issue:701"]}, "lzpwm": {"add": ["_issue:701"]}, "lhbkz": {"add": ["_issue:701"]}, "lxzfz": {"add": ["_issue:701"]}, "lhfbt": {"add": ["_issue:701"]}, "lyzfz": {"add": ["_issue:701"]}, "recHwbwWcypZlpioq": {"add": ["_issue:701"]}, "lwprf": {"add": ["_issue:701"]}, "lzdgt": {"add": ["_issue:701"]}, "rec2ra5FfLEkgFlmF": {"add": ["_issue:701"]}, "lxygx": {"add": ["_issue:701"]}, "lybcy": {"add": ["_issue:701"]}, "lrgwy": {"add": ["_issue:701"]}, "lxdwr": {"add": ["_issue:701"]}, "reczh0HKLU1A30EKd": {"add": ["_issue:701"]}, "recNp6jOu0RtvXj9k": {"add": ["_issue:701"]}, "ltqtf": {"add": ["_issue:701"]}, "lfycg": {"add": ["_issue:701"]}, "reccdmQRwTjKoFp7N": {"add": ["_issue:701"]}, "lrmdk": {"add": ["_issue:701"]}, "ltzbc": {"add": ["_issue:701"]}, "lrfwx": {"add": ["_issue:701"]}, "lzcdb": {"add": ["_issue:701"]}, "lzppf": {"add": ["_issue:701"]}, "lcbghy": {"add": ["_issue:701"]}, "recgOOCW2TxXGytjf": {"add": ["_issue:701"]}, "recj1jklQ0g6HY84a": {"add": ["_issue:701"]}, "lthwp": {"add": ["_issue:701"]}, "recer7TIMgaA3tY7J": {"add": ["_issue:701"]}, "lymmg": {"add": ["_issue:701"]}, "recw2AYCSuCCUJvw4": {"add": ["_issue:701"]}, "lzxzz": {"add": ["_issue:701"]}, "lycfx": {"add": ["_issue:701"]}, "rec0zMZ3rzZxjkaZ5": {"add": ["_issue:701"]}, "reca6goOAfmBgp55J": {"add": ["_issue:701"]}, "rec7CKKp6hRJTNArn": {"add": ["_issue:701"]}, "lthwq": {"add": ["_issue:701"]}, "lhbkm": {"add": ["_issue:701"]}, "lccmrx": {"add": ["_issue:701"]}, "lxzxw": {"add": ["_issue:701"]}, "ltmgx": {"add": ["_issue:701"]}, "lyxgg": {"add": ["_issue:701"]}, "recRDcbNg64kR3Lbu": {"add": ["_issue:701"]}, "recBJFsxwEmzyPwhP": {"add": ["_issue:701"]}, "recsJx9wTmle80Bq0": {"add": ["_issue:701"]}, "recOrLcEzhVCOI3d7": {"add": ["_issue:701"]}, "recvaxv0iZT02Xs9h": {"add": ["_issue:701"]}, "rec3t9YWYfdNi1V6P": {"add": ["_issue:701"]}, "recjb68iV16ATgg3b": {"add": ["_issue:701"]}, "rec66Z0IjoCgebIio": {"add": ["_issue:701"]}, "lthyz": {"add": ["_issue:701"]}, "lhfgf": {"add": ["_issue:701"]}, "lrytd": {"add": ["_issue:701"]}, "lyzmt": {"add": ["_issue:701"]}, "recmng7GWCoWg04Fq": {"add": ["_issue:701"]}, "lhfct": {"add": ["_issue:701"]}, "rec03PQ19zVqwhaa4": {"add": ["_issue:701"]}, "lkqrc": {"add": ["_issue:701"]}, "recNaIqjccrVvaIzi": {"add": ["_issue:701"]}, "recMR3TkrxDl9hrKG": {"add": ["_issue:701"]}, "lrdrz": {"add": ["_issue:701"]}, "recED3HQRYkPkyFpK": {"add": ["_issue:701"]}, "ltwgw": {"add": ["_issue:701"]}, "recxa4G5fg3jMw7XU": {"add": ["_issue:701"]}, "recdKSKHfSW0daan3": {"add": ["_issue:701"]}, "rec99QfWHToaXOBi7": {"add": ["_issue:701"]}, "recJjPgovBPu90dFe": {"add": ["_issue:701"]}, "reclLFuSS8LO02xlo": {"add": ["_issue:701"]}, "lyhwp": {"add": ["_issue:701"]}, "rec6qKu33bLsdTm19": {"add": ["_issue:701"]}, "lxdtt": {"add": ["_issue:701"]}, "lyccq": {"add": ["_issue:701"]}, "lhdth": {"add": ["_issue:701"]}, "lhcyk": {"add": ["_issue:701"]}, "ltxmx": {"add": ["_issue:701"]}, "recDpAO9vC7j0brKp": {"add": ["_issue:701"]}, "lrmdr": {"add": ["_issue:701"]}, "rec0FiETeE685rFOn": {"add": ["_issue:701"]}, "rec5XMnfIcacNtIBZ": {"add": ["_issue:701"]}, "lyxpx": {"add": ["_issue:701"]}, "rec7cpYqaluvmLBPn": {"add": ["_issue:701"]}, "recjXLrja5NsWJshj": {"add": ["_issue:701"]}, "recKcRIH7WoYlXQZH": {"add": ["_issue:701"]}, "recG4I7H3ATs44Exp": {"add": ["_issue:701"]}, "lcdktc": {"add": ["_issue:701"]}, "recmT9VgZwKpQL00k": {"add": ["_issue:701"]}, "lycfq": {"add": ["_issue:701"]}, "ldfqh": {"add": ["_issue:701"]}, "lcbhbc": {"add": ["_issue:701"]}, "lcyzt": {"add": ["_issue:701"]}, "lzmqx": {"add": ["_issue:701"]}, "lfgwz": {"add": ["_issue:701"]}, "recykgp0JgoCdKsVE": {"add": ["_issue:701"]}, "recI8I74IAjCu5ShS": {"add": ["_issue:701"]}, "lytbz": {"add": ["_issue:701"]}, "rec61TYXeQ1Uo5sp8": {"add": ["_issue:701"]}, "lrwpc": {"add": ["_issue:701"]}, "recIZcrlxBFulrLOE": {"add": ["_issue:701"]}, "recfDdQjXBcjRRMED": {"add": ["_issue:701"]}, "lzckz": {"add": ["_issue:701"]}, "ltyrc": {"add": ["_issue:701"]}, "lzxhb": {"add": ["_issue:701"]}, "recnI5q6e0fcTiION": {"add": ["_issue:701"]}, "lzkgh": {"add": ["_issue:701"]}, "lxfyp": {"add": ["_issue:701"]}, "lcbddm": {"add": ["_issue:701"]}, "lrywr": {"add": ["_issue:701"]}, "recZLbbvLSlm6SILi": {"add": ["_issue:701"]}, "lywrf": {"add": ["_issue:701"]}, "rec2angYqvkUUUlFo": {"add": ["_issue:701"]}, "recbcJfhX5y9eGbeM": {"add": ["_issue:701"]}, "recV6rXyl7vSho3Bf": {"add": ["_issue:701"]}, "lxzgh": {"add": ["_issue:701"]}, "lccfrt": {"add": ["_issue:701"]}, "recinulvFCTHW1ABq": {"add": ["_issue:701"]}, "lrbmt": {"add": ["_issue:701"]}, "lwzzf": {"add": ["_issue:701"]}, "lthtp": {"add": ["_issue:701"]}, "recEG2e4A206cdyNV": {"add": ["_issue:701"]}, "lxqwb": {"add": ["_issue:701"]}, "ltthh": {"add": ["_issue:701"]}, "rec9B2TxTP52p34PP": {"add": ["_issue:701"]}, "rec8AmUD3sgCiKFyq": {"add": ["_issue:701"]}, "recrr53rzR0DPGS6w": {"add": ["_issue:701"]}, "lhmym": {"add": ["_issue:701"]}, "ldccp": {"add": ["_issue:701"]}, "lyqqc": {"add": ["_issue:701"]}, "lzcyy": {"add": ["_issue:701"]}, "recYEJ6l9vYYNBKAJ": {"add": ["_issue:701"]}, "lrdyh": {"add": ["_issue:701"]}, "lzbbw": {"add": ["_issue:701"]}, "lzbgp": {"add": ["_issue:701"]}, "ltzkk": {"add": ["_issue:701"]}, "lxycm": {"add": ["_issue:701"]}, "lcbgxz": {"add": ["_issue:701"]}, "recUPB8UQW2FIqzRE": {"add": ["_issue:701"]}, "lhdtp": {"add": ["_issue:701"]}, "lxwqg": {"add": ["_issue:701"]}, "lwgwp": {"add": ["_issue:701"]}, "lypkf": {"add": ["_issue:701"]}, "recoY7DO5QwYXcuPv": {"add": ["_issue:701"]}, "recUS37nrxKI0JPfi": {"add": ["_issue:701"]}, "ltkkt": {"add": ["_issue:701"]}, "lcbhck": {"add": ["_issue:701"]}, "recH99X5ow4TgrNqX": {"add": ["_issue:701"]}, "lhfgg": {"add": ["_issue:701"]}, "recxKuhhPpXNJlS0i": {"add": ["_issue:701"]}, "recH8XWHPnM9KECva": {"add": ["_issue:701"]}, "ltwyp": {"add": ["_issue:701"]}, "lcbdfy": {"add": ["_issue:701"]}, "recs9cN8wkySQmmCk": {"add": ["_issue:701"]}, "lzcdc": {"add": ["_issue:701"]}, "ltbwq": {"add": ["_issue:701"]}, "recN25VCNEWfGhmo6": {"add": ["_issue:701"]}, "recvGCxuO9UK2MT0h": {"add": ["_issue:701"]}, "lhgbp": {"add": ["_issue:701"]}, "lyccw": {"add": ["_issue:701"]}, "rechzYO0YDakEBzur": {"add": ["_issue:701"]}, "rec26OFphOxLzWY4m": {"add": ["_issue:701"]}, "rec54T2PGJoJFD3fE": {"add": ["_issue:701"]}, "lxrzz": {"add": ["_issue:701"]}, "ltzxc": {"add": ["_issue:701"]}, "rec7SfZIKwTcBSyfn": {"add": ["_issue:701"]}, "recrCbRUKvzK6Q7Z1": {"add": ["_issue:701"]}, "lybwb": {"add": ["_issue:701"]}, "lcccyd": {"add": ["_issue:701"]}, "lcbfxx": {"add": ["_issue:701"]}, "lyyhk": {"add": ["_issue:701"]}, "recD2nRHGkh1LvczP": {"add": ["_issue:701"]}, "recbl94whMFKWO98b": {"add": ["_issue:701"]}, "recShELhvmow08rkR": {"add": ["_issue:701"]}, "ltdtf": {"add": ["_issue:701"]}, "lybrd": {"add": ["_issue:701"]}, "recrrawWyJk8XCJLF": {"add": ["_issue:701"]}, "recKmFPyANxN1ko7B": {"add": ["_issue:701"]}, "lzpdz": {"add": ["_issue:701"]}, "recWUAWLuIkCOcVof": {"add": ["_issue:701"]}, "lwgwt": {"add": ["_issue:701"]}, "lqzbt": {"add": ["_issue:701"]}, "lhcfc": {"add": ["_issue:701"]}, "reccP267ZUdsnqx0v": {"add": ["_issue:701"]}, "recQgzR9EYnCM6LUb": {"add": ["_issue:701"]}, "rec8eBmL1ecSH89Qs": {"add": ["_issue:701"]}, "rec2NjH3KQcTCPe18": {"add": ["_issue:701"]}, "lcccfw": {"add": ["_issue:701"]}, "lykhm": {"add": ["_issue:701"]}, "lyhyw": {"add": ["_issue:701"]}, "lxzpr": {"add": ["_issue:701"]}, "lcbgbb": {"add": ["_issue:701"]}, "lfczb": {"add": ["_issue:701"]}, "recFY48vxuCL6H2R1": {"add": ["_issue:701"]}, "recGBH39s356zhB2m": {"add": ["_issue:701"]}, "recWMiNhXtk3HIecF": {"add": ["_issue:701"]}, "lyqrd": {"add": ["_issue:701"]}, "lrfmx": {"add": ["_issue:701"]}, "lhffy": {"add": ["_issue:701"]}, "lzcfk": {"add": ["_issue:701"]}, "rec4bEIv54oaGuFQ7": {"add": ["_issue:701"]}, "lyrwd": {"add": ["_issue:701"]}, "lrtmf": {"add": ["_issue:701"]}, "recP43qC30kBKbZTt": {"add": ["_issue:701"]}, "lwzym": {"add": ["_issue:701"]}, "reckvwlFbVUSWEQUV": {"add": ["_issue:701"]}, "recnjgIFc1DdVkEHS": {"add": ["_issue:701"]}, "recIZkzvvMsI6xdLu": {"add": ["_issue:701"]}, "recblRVXzDznIwrW6": {"add": ["_issue:701"]}, "recwCKXNNlDrTwj3Z": {"add": ["_issue:701"]}, "lccmgw": {"add": ["_issue:701"]}, "lcbhdg": {"add": ["_issue:701"]}, "ltzmr": {"add": ["_issue:701"]}, "recE8opvVTr9fVpSQ": {"add": ["_issue:701"]}, "recOQ97NwRPOO5MJK": {"add": ["_issue:701"]}, "recuTCh97QZvSSbLI": {"add": ["_issue:701"]}, "lhdyx": {"add": ["_issue:701"]}, "rec0eMHw9oRnyeFBY": {"add": ["_issue:701"]}, "recE3VWBHK6jW5Wug": {"add": ["_issue:701"]}, "lqywk": {"add": ["_issue:701"]}, "lzchw": {"add": ["_issue:701"]}, "rec7xyFp31MZb8h3m": {"add": ["_issue:701"]}, "lwbdq": {"add": ["_issue:701"]}, "recUqc9pu57NiAbJs": {"add": ["_issue:701"]}, "recE5eQiq1NRAN6Jo": {"add": ["_issue:701"]}, "ltwfk": {"add": ["_issue:701"]}, "lwfqy": {"add": ["_issue:701"]}, "lxqdx": {"add": ["_issue:701"]}, "lqyzb": {"add": ["_issue:701"]}, "lhdxf": {"add": ["_issue:701"]}, "recKyEUibL9ZMyQOQ": {"add": ["_issue:701"]}, "lxzkh": {"add": ["_issue:701"]}, "rec1d3SdArWI3BPC9": {"add": ["_issue:701"]}, "recbRaFpRS6o7HNTG": {"add": ["_issue:701"]}, "ltmyq": {"add": ["_issue:701"]}, "recd1XPJqlDxwI13o": {"add": ["_issue:701"]}, "lwyqt": {"add": ["_issue:701"]}, "ltyfq": {"add": ["_issue:701"]}, "lttrq": {"add": ["_issue:701"]}, "ltgtc": {"add": ["_issue:701"]}}}

Pasted that into https://vial.calltheshots.us/api/updateLocationConcordances/debug

[simonw]

Here are the 346 locations to investigate (7 were soft-deleted): https://vial.calltheshots.us/dashboard/?sql=select+%2A+from+location+where+soft_deleted+%3D+false+and+id+in+%28select+location_id+from+concordance_location+where+concordanceidentifier_id+in+%28select+id+from+concordance_identifier+where+authority+%3D+%27_issue%27+and+identifier+%3D+%27701%27%29%29%3AbutiMXjjsSg7Pefj9Pfwj1YkZWSJ7N4Ph-fir7-U2Nk

[simonw]

Mapbox export code filters through this:

vial/vaccinate/api/search.py

Lines 347 to 361 in 3aca574

	def filter_for_export(qs):
	# Filter down to locations that we think should be exported
	# to the public map on www.vaccinatethestates.com
	return qs.exclude(
	dn_latest_non_skip_report__planned_closure__lt=datetime.date.today()
	).exclude(
	dn_latest_non_skip_report__availability_tags__slug__in=(
	"incorrect_contact_information",
	"location_permanently_closed",
	"may_be_a_vaccination_site_in_the_future",
	"not_open_to_the_public",
	"will_never_be_a_vaccination_site",
	"only_staff",
	)
	)

[simonw]

Yes, that's why:

https://vial.calltheshots.us/dashboard/?sql=select+location.public_id%2C+location.name%2C+location.full_address%2C+json_agg%28availability_tag.name%29%0D%0Afrom+location+join+report+on+location.dn_latest_non_skip_report_id+%3D+report.id%0D%0Ajoin+call_report_availability_tag+on+call_report_availability_tag.report_id+%3D+report.id%0D%0Ajoin+availability_tag+on+call_report_availability_tag.availabilitytag_id+%3D+availability_tag.id%0D%0Awhere+location.+soft_deleted+%3D+false+and+location.id+in+%28select+location_id+from+concordance_location+where+concordanceidentifier_id+in+%28select+id+from+concordance_identifier+where+authority+%3D+%27_issue%27+and+identifier+%3D+%27701%27%29%29+group+by+location.public_id%2C+location.name%2C+location.full_address%3A8uJ09NBBY1g6gwxdroyRN1TBgMF1yBu3dc9T8_fw-0c

[simonw]

https://vial.calltheshots.us/dashboard/?sql=select+%22json_agg%22%3A%3Atext%2C+count%28%2A%29+as+n+from+%28select+location.public_id%2C+location.name%2C+location.full_address%2C+json_agg%28availability_tag.name%29%0D%0Afrom+location+join+report+on+location.dn_latest_non_skip_report_id+%3D+report.id%0D%0Ajoin+call_report_availability_tag+on+call_report_availability_tag.report_id+%3D+report.id%0D%0Ajoin+availability_tag+on+call_report_availability_tag.availabilitytag_id+%3D+availability_tag.id%0D%0Awhere+location.+soft_deleted+%3D+false+and+location.id+in+%28select+location_id+from+concordance_location+where+concordanceidentifier_id+in+%28select+id+from+concordance_identifier+where+authority+%3D+%27_issue%27+and+identifier+%3D+%27701%27%29%29+group+by+location.public_id%2C+location.name%2C+location.full_address%29+as+results+group+by+%22json_agg%22%3A%3Atext+order+by+n+desc%3Ajuk3ZmfOTXV9ZUwQBhB8RWUAsrnKwrBKi9jqvcjo_sM

json_agg	n
"[""May be a vaccination site in the future""]"	208
"[""Will never be a vaccination site""]"	74
"[""Incorrect contact information""]"	38
"[""Not open to the public""]"	10
"[""Appointments available"", ""Appointment required""]"	6
"[""Location permanently closed""]"	3
"[""Walk-ins only""]"	3
"[""Appointment required"", ""Appointments available""]"	2
"[""Only vaccinating staff""]"	1
"[""Appointment required""]"	1

[simonw]

This is another hold-over from the world before we were importing most of our data: when we just had CA data and it was all based on reports, not exposing locations that had closed to our website and API made perfect sense. But now that we've reduced our report volume AND we're relying more on scrapers, that decision should be reconsidered

[simonw]

This work will happen in #704.