What is this?
A desktop application to import, standardise and visualise various UAP data sources. Importing both the UPDB and Hatch data sources will put 318,477 individual sighting events into a searchable database and visualisation tool.
When launching the tool, you may get a Windows warning about an "unsafe" program saying "Windows protected your PC" this is just due to the tool not currently being signed by my developer certificate, just click "More Info", then the "Run anyway" button.
Once downloaded you may have to set it as executable in order to launch, right-click -> properties -> permissions -> Execute
The tool isn't supplied with the Hatch JSON data file or the UPDB data file but it will automatically download the latest versions for you and import the data.
- Launch the executable by double-clicking the .exe file you just downloaded.
- Click one of the
Load xxxxbuttons - The tool will the run the various processes to load the data.
- if the file is not already there on disk, it will download it for you.
- Explore the data
The Larry Hatch JSON data file is here if you want to download it manually.
The UPDB data file is here if you want to download it manually.
If you wish to reset the import process or start from scratch, simply delete the database file (uapdb.ufo) and restart an import process.
The tool at the moment shows some of the basic statistics and various time related data visualisations. The data can be selected based on date ranges using the From and To controls. Some predefined date ranges are also selectable in the drop down menu.
If for any country or description search string you specify results in empty charts it's possible that any matching cases are outside the date range you have currently selected. To auto expand the date range simply click the All Dates button to ensure the entire database is included by date.
WARNING: Selections spanning the entire dataset if you have imported the UPDB can take some time to process as it calculates statistics.
You can use the Description text box to specify a word to filter the data on. The filter is applied to the contents of the description field. You can also use the toggle switch to invert the selection and exclude sighting events containing the specified term.
You can also filter the data based on individual countries using the country dropdown.
Once you have your filter set-up, click the Apply Filter button to filter the database and calculate the statistics.
The basic statistics view shows pie charts of each of the main characteristics of the selected data, such as Country, Time of Day etc.
The Time series breaks down the sighting by time of day. The series can also be configured in terms of the time slice size. Normal will plot in 15 minute slices, 30 minutes and 60 minutes (the default) groups cases into these time boxes to flatten out the trend line.
A breakdown of the average event duration plotted against the time of day.
These charts aggregate together certain collections of terms often quoted in relation to anomalous sightings. For instance, the Trained Observers series would include terms like pilot, police, astronomer or air traffic controller among others. Another example would be the shape series Cylinder, this aggregates together terms like cigar, torpedo and tube.
The raw data view allows you to view each complete event entry for the given set of active filters. The data can be sorted in ascending and descending order by clicking on the column headers. You can also sort on multiple columns by holding SHIFT and clicking on the column headers.
Individual sightings can be viewed in Google Maps by double clicking on a data row in the Raw Data view.
Individual sighting links can be viewed in your default browser by holding CTRL and double clicking on links column in the Raw Data view.
Currently the tool only supports 64-bit Windows & Linux, we have MacOS version incoming once I've had enough time to test the build.
If you encounter any issues using the tool or have any feature requests please do open an issue here on this repository.
Happy UAP'ing!
MORE DATA PLEASE!! Let us know if you want any data source added to the tool in the future.
More default charts and different pivots for data comparisons, ideas most welcome.
The data has been painstakingly formatted, sourced and processed by Rich Geldreich as part of his UFO Data project which you can find here. Thanks Rich!
