Patch Notes
Sept 28th 2025
- Started analysing PUBG sniper positions
Sept 27th 2025
- Figured out DataSpell SQL integration
- DataSpell feels amazing - think this is going to be my main tool going forward
- Created box plots for PUBG kill distance over the past year, categorised by weapon and weapon type
- These are interesting themselves, and will also be useful in defining what a "snipe" is
Sept 26th 2025
- Day off! Listened to the new VALORANT Vodfathers podcast
Sept 25th 2025
- PUBG telemetry now complete and up-to-date, start exploring weapon kill distance statistics
- Start exploring Jupyter notebook usage and SQL integration in DataSpell
Sept 24th 2025
- Continue refreshing derived data to use new telemetry data
Sept 23rd 2025
- Reading up on JavaScript classes.
Sept 22nd 2025
- Start refreshing derived data to use new telemetry data
Sept 21st 2025
- Finish downloading latest telemetry data
Sept 20th 2025
- Continuing work on building extraction
- Exploring possibility of tree extraction
- Start downloading latest telemetry data
Sept 19th 2025
- Continuing work on building extraction, separating buildings from other map features
Sept 18th 2025
- Initial work extracting building / map feature locations
Sept 17th 2025
- Telemetry data downloads
- Exploring PUBG building locations
Sept 16th 2025
- Continued downloading mising telemetry data
Sept 15th 2025
- Started downloading missing telemetry data
Sept 14th 2025
- Filled gaps in PUBG telemetry weapons info (weapons names, categories etc.)
- Explored damage categories present in telemetry data
- Started work downloading remaining missing telemetry data
Sept 13th 2025
- Process PUBG telemetry weapons info.
Sept 12th 2025
- PUBG telemetry SQL analysis.
Sept 11th 2025
- Setting up SQL views to reduce processing time of analysis on PUBG telemetry dataset.
Sept 10th 2025
- Producing a cleansed insta-kills / knocks table.
Sept 9th 2025
- Cleansing PUBG telemetry knocks data.
Sept 8th 2025
- Developing SQL scripts to cleanse PUBG telemetry kills data
Sept 7th 2025
- Finished reading initial batch of PUBG telemetry into database
- Started developing SQL scripts to analyse telemetry data
Sept 6th 2025
- Set up PUBG telemetry database structure
- Started reading PUBG telemetry into database
- Continued initial work on PUBG interactive map popups
Sept 5th 2025
- Working to fix various Python package incompatibility issues
Sept 4th 2025
- Initial work putting PUBG telemetry data into Postgres
Sept 3rd 2025
- Started experimenting with querying and analysing PUBG data with QGIS and PostGIS
- Started researching storing PUBG telemetry data in PostgreSQL
Sept 2nd 2025
- Updated interactive PUBG map
- Added loot item spawns
- Support for multiple layers
- Improved sidebar, with nested layers and descriptions
- Custom page title
Sept 1st 2025
- Made progress adding loot spawns to interactive PUBG map.
Aug 31st 2025
- Tidied up spawn data in PostGIS
- Started changing interactive PUBG map to better support multiple layers etc.
Aug 30th 2025
- Categorised Erangel spawn points by broad type (normal, bridge, church etc.)
- Started adding spawn data to PostGIS
- Finished downloading most PUBG tournament data
Aug 29th 2025
- Continued downloading latest PUBG tournament data
- Extracted Erangel loot spawn spots
- Started analysing spawn types, item probabilities etc.
Aug 28th 2025
- Released new browse content by game page
- Started downloading latest PUBG data
- Start work adding popups to PUBG map
Aug 27th 2025
- Working on creating thumbnail images for SMITE infographics
Aug 26th 2025
- Continued work revamping the browse content by games page
- Layout mostly sorted
- First few item descriptions sorted
Aug 25th 2025
- Published the initial version of an interactive PUBG map
- Very simple for now, displays the locations of vehicle spawns on Erangel using custom icons
- My first piece of content using the React / OpenLayers / GeoServer / PostGIS stack - learning lots!
- Started work refreshing the browse content by games page