HN user

miljen

154 karma
Posts27
Comments7
View on HN
attractionsineurope.com 1y ago

Smallest Town in the World

miljen
1pts0
www.iflscience.com 2y ago

55 years since the Allende meteorite

miljen
1pts0
www.iflscience.com 2y ago

What Are All Those Black Dots on Your Car Windscreen for Anyway?

miljen
1pts0
github.com 2y ago

Show HN: Async.MQTT5, a C++20 MQTT client based on Boost.Asio

miljen
6pts0
github.com 3y ago

Efficient DBC file format parser in C++, built on top of Boost Spirit

miljen
4pts1
blog.mireo.com 3y ago

We predict Tesla 3's range better than Tesla

miljen
3pts0
indianexpress.com 3y ago

Bard’s incorrect answer sees Alphabet lose over $100B

miljen
2pts0
www.telegraph.co.uk 3y ago

Google must cut thousands more ‘overpaid’ workers, investor demands

miljen
3pts0
blog.mireo.com 3y ago

AI may defeat EV Range Anxiety

miljen
1pts0
siamtoo.com 3y ago

17-Year-Old Student Discovers a New Planet on the Third Day of Internship NASA

miljen
2pts0
www.inverse.com 4y ago

NASA's Webb Telescope Crosses a Critical Milestone

miljen
4pts0
www.iflscience.com 4y ago

MS Symptoms May Have Been “Reversed” in Immunotherapy Breakthrough

miljen
10pts0
blog.mireo.hr 4y ago

SpaceTime is 17x faster than GeoMesa

miljen
3pts0
www.notion.so 5y ago

The Unicorn World Order

miljen
2pts0
www.wired.com 5y ago

Jeff Bezos Touches Space

miljen
1pts0
blog.mireo.hr 5y ago

The Future of Embedded Navigation

miljen
2pts0
blog.mireo.hr 5y ago

How a China bank uses GPS data to assess local factory's financial health?

miljen
1pts0
www.fiercebiotech.com 5y ago

BioNTech CEO applies Covid-19 vaccine's mRNA tech to multiple sclerosis

miljen
215pts71
www.blog.google 5y ago

Google Maps 101: How AI helps predict traffic and determine routes

miljen
3pts0
futurism.com 6y ago

New Research: There Could Be 36 Alien Civilizations in Our Galaxy

miljen
1pts0
www.wired.com 6y ago

On Instagram, Black Squares Overtook Activist Hashtags

miljen
2pts0
blog.google 6y ago

A reintroduction to our Knowledge Graph and knowledge panels

miljen
2pts0
electrek.co 6y ago

Volvo CEO: Pandemic will rapidly accelerate shift to electric cars

miljen
2pts0
blog.mireo.hr 6y ago

Why would a normal person build its own spatiotemporal database?

miljen
13pts3
covid19-research-explorer.appspot.com 6y ago

Covid-19 Research Explorer

miljen
1pts1
www.sciencealert.com 6y ago

We might have first-ever detection of a fast radio burst in our own galaxy

miljen
2pts0
blog.mireo.hr 6y ago

Bringing Genius Maps to CarPlay

miljen
19pts0

Google set up the COVID-19 Research Explorer. Reading more than 50,000 papers about COVID-19, and allowing to ask natural language questions over that corpus.

Of course. MSQL queries can be as simple as "select * from st.trips", but can also include geospatial functions that we implemented and that are not part of standard SQL: "select vid, sum(sphere_length(x[0], y[0], x[1], y[1])) as mileage from st.segments where ST_Intersects( ST_GeomFromText('POLYGON ((11955008 38520960,11995328 38530624,11998976 38531456,11955008 38520960))'), ST_Line(x[0], y[0], x[1], y[1]) ) and t[0] >= 1569888000 and t[1] < 1572566400 and vid >= 3200 and vid <= 3300 group by vid"

Actually, a query very similar to the one listed above generates the report mileage-in-area mentioned in the blog.