More types for cached data

[MiklerGM]

I would propose to add more data to cached data:

Common military operations:
Bombings, military offensive

Special events
Nuclear Disasters, Atomic Bombings, Terrorist Attacks

Life is not only about deaths or disasters
Inventions
Space flights or Orbital station launch

I would propose to add more types like special events, inventions, probably more.

UPD:
Adding landmarks along with wonders of the world might be interesting too

[quorth0n]

All sound good to me. Landmarks would be cool, I'm not sure how they would be displayed on the map though. Too many pins in the global narrative might make the map feel crowded, but it's a frontend issue

[MiklerGM]

Overlapping is handled automatically by mapbox plus we have limit for 20 pins per year, per tile on backend, so I think it is manageable on frontend.

backend/project/api/views.py

Lines 215 to 224 in 490ba91

	" SELECT ST_AsMVT(tile, 'events') as events FROM ("
	" SELECT wikidata_id, event_type, rank, year, geom FROM ("
	" SELECT *, row_number() OVER (PARTITION BY year order by rank desc) as i"
	" FROM ( SELECT * FROM ("
	" SELECT *, EXTRACT(year from date) as year,"
	" ST_AsMVTGeom(ST_Transform(location, 3857), TileBBox(%s, %s, %s)) as geom"
	" FROM api_cacheddata"
	" ORDER BY rank DESC"
	" ) as foo WHERE geom IS NOT NULL ) as foo) as foo"
	" WHERE i <= 20) AS tile"

We need to do a research and find out

• what do we want to add
• how should we group new wikidata entities
• how we can fetch this data

[MiklerGM]

Wow, they have class for natural disasters and volcanic eruptions

[v1kun]

Query of getting something what is the instance of %class%

SELECT ?item ?itemLabel 
WHERE 
{
  ?item wdt:P31 wd: %class%.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}```

[MiklerGM]

With specific classes we've got only ~200 results or less per class
https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fstart%20%3Flaunch%20WHERE%20{%20%20%3Fitem%20wdt%3AP31%20wd%3AQ25956%20.%20%20OPTIONAL%20{%20%20%20%20%3Fitem%20wdt%3AP1427%20%3Fstart.%20%20%20%20%3Fitem%20wdt%3AP619%20%3Flaunch%20%20}%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20"[AUTO_LANGUAGE]%2Cen".%20}}

For inventions and inventors we need to filter out galaxies and add locations
https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Finventor%20%3Fdate%20WHERE%20{%20%20%3Fitem%20wdt%3AP31%20%3Fclass%20.%20%20%3Fitem%20wdt%3AP61%20%3Finventor%20.%20%20OPTIONAL%20{%20%20%20%20%3Fitem%20wdt%3AP575%20%3FtimeOfDiscovery%20.%20%20%20%20%3Fitem%20wdt%3AP577%20%3FpublicationDate%20.%20%20%20%20%3Fitem%20wdt%3AP571%20%3Finception%20.%20%20}%20%20%20%20SERVICE%20wikibase%3Alabel%20{%20bd%3AserviceParam%20wikibase%3Alanguage%20"[AUTO_LANGUAGE]%2Cen".%20}}

[v1kun]

30 bombings

376 Olympic Games (both modern and accient)