August 2022 Summaries

The winner of the Spatial Data Scientist of the Year award will be announced at the Spatial Data Science Conference New York in October, with a focus on recognizing individuals who have pushed the boundaries of spatial analysis and made significant impacts using new types of data and advanced methodologies. The award committee will consider nominations submitted by September 23rd and will base their decision on criteria such as the use of new data types, impact of projects delivered, and innovation in methodology. The winner will receive a complimentary ticket to the event or the opportunity to join live virtually.

The Ultimate Guide to Spatial Joins & Predicates with SQL` is a comprehensive resource for understanding spatial joins, filters, and predicates in SQL, particularly in the context of location intelligence and geospatial analysis. The guide covers various aspects of spatial joins, including their syntax, examples, and applications, as well as different types of spatial predicates such as ST_INTERSECTS, ST_CONTAINS, ST_WITHIN, ST_DWITHIN, ST_TOUCHES, and others. It also discusses the importance of geometry in spatial joins, the challenges of performing spatial joins, and provides tips for optimizing spatial join performance. The guide is aimed at newcomers to Spatial SQL or geospatial analysis, but its content is relevant to developers and data scientists working with location intelligence applications. By mastering spatial joins and predicates, users can gain insights from location data and perform complex analyses that require understanding spatial relationships between different geographic features.

You can embed Google Street View images into your pop-ups in CARTO, allowing users to explore locations as if they were looking at them in person. To do this, you need a dataset representing physical structures, access to CARTO and a Google account, enabling the Google Maps API, accessing your API key, configuring your pop-ups with HTML mode, adding a Street View image URL, and incorporating it into your pop-up. With 200 USD free credits per month, users can customize their pop-ups further, making them more impactful for their users and bringing analysis to life.

The Great Resignation in Logistics` refers to the phenomenon where employees are leaving their jobs in enormous numbers, with over 47 million people quitting their jobs in the United States in 2021. This trend is not uniform across industries and locations, with some areas experiencing a significant increase in resignations while others remain relatively stable. To combat this trend, logistics companies can consider locating new distribution centers in areas of high relative unemployment, where the ratio of potential staff to job openings is less competitive for employers. Unemployment is inherently spatial, and analyzing data at a more granular level, such as census block groups or H3 hexagonal cells, can provide insights into the availability of skilled workers. By considering factors such as proximity to major transport infrastructure, population density, and unemployed population, logistics companies can identify optimal locations for distribution centers that minimize disruption to local infrastructure while maximizing the potential for skilled workers. The example of Amazon's new distribution center in Mt. Juliet, Tennessee, demonstrates how location planning can be a symbiotic benefit for both businesses and local residents. By leveraging Location Intelligence tools like CARTO, logistics companies can optimize their operations and make data-driven decisions about distribution center locations.

The Eurovision Song Contest, set to be hosted by the United Kingdom in 2023, has sparked a fierce competition among cities and venues vying for the honor of hosting the event. A venue suitability analysis was conducted using Spatial Data Science, considering four key criteria: capacity, international access, internal access, and accommodation. The top 10 most suitable venues were identified, with Principality Stadium in Cardiff emerging as the winner due to its massive capacity, excellent transport links, and city center location. The analysis was performed in just three seconds using CARTO's cloud-native Spatial SQL, allowing for rapid iteration and customization of the analysis. A visualization tool was used to present the results, enabling users to quickly identify the most suitable venue and explore additional details about each site.