Explore UFO sightings datasets and find correlations with US military bases location.

This is the next part of the previous article called UFO datasets, the truth is out there… about UFO sightings data manipulation.
Locate UFO sightings by count all over the time
It is a bit more tricky to do, but you can achieve it in a few steps:
- Fetch data
- Map data to replace the actual value by an HHCODE with a MACROMAPPER.
- Compute the sum of sightings for each location
- Build a new artificial time series with the count as a value
To understand MAXOPS, please have a look at this post about limits.

DISCLAIMER
For those particular dataviz, please wait for a future post about a UFO dashboard.
Display military bases location
Now we will try to find a relationship between UFO sightings and military bases locations in the USA.
So we need a US military bases datasets, here is one: https://public.opendatasoft.com/explore/dataset/military-bases/information/
And here is the Warp 10 data to import to your instance: bases.zip.
At first, let's have a look at the datasets on a map:

Well, it seems there is a relationship. Now let's display both.
The smartest way is to use a regular expression to fetch both bases and sightings, and then, filter the result to retain only the time series we want.

Military bases and UFO sightings relationship
Now, I would like to know how many sightings there is below 50 km of a military base.
To achieve that, here are the steps:
- Fetch data
- Filter by series
- For each military base (hopefully, they are not thousands)
- Compute a 50 km radius circle
- Aggregate those circles
- Count sightings inside those circles
- Get the overall sightings count
Ok, but in percent? Modify the end of the previous script.
75% of UFO sightings in the USA take place at less than 50 km from a military base!
That could mean two things:
- The US military bases secretly host aliens
- The US army is made of aliens
Read more about when do you need a Time Series Database. |
Final though
With these datasets, we have seen how to do a MACROMAPPER, how to manipulate HHCODE, GeoShapes, how to filter data by a geographic area, and how to compute the value distribution.
Like said before, in a future post, we will build a UFO dashboard with all of what we discovered.
Live long and prosper.
Part 3 of UFO sightings datasets is right here.
Read more
Upload Geo Time Series from a Warp 10 instance to another
All about the Geo Time Series Model
AIS data made easy

Senior Software Engineer