AWS Public Sector Blog

Category: Amazon Athena

AWS branded background design with text overlay that says "ASPPH scales data curation for members with a data lake on AWS"

ASPPH scales data curation for members with a data lake on AWS

The Association of Schools and Programs of Public Health (ASPPH) — a nonprofit association with a vision for improved health and well-being for everyone, everywhere — partnered with Amazon Web Services (AWS) Professional Services (AWS ProServe) to move their curated data to a managed data lake on AWS. In this blog post, we share how ASPPH and AWS designed and built the data lake and the results of moving to a modern, scalable data architecture.

AWS branded background design with text overlay that says "The benefits of running controlled substance databases with AWS"

The benefits of running controlled substance databases with AWS

Healthcare authorities and providers use state-run controlled substance databases (CSDs) to track prescriptions and identify patients for substance abuse. CSDs help evaluate treatment options, screen patients who may be at risk for drug abuse problems, and make informed decisions about prescribing medication. This post explains how healthcare authorities can leverage CSD data to enhance their decision-making processes within business operations by using Amazon Web Services (AWS).

AWS branded background with text overlay that says "Flexibility, cost-savings, and innovation: Kellogg School of Management chooses AWS"

Flexibility, cost-savings, and innovation: Kellogg School of Management chooses AWS

At the end of 2022, Northwestern University’s Kellogg School of Management had a decision to make. The on-premises SQL server used by faculty and students had reached the end of its life, and the school needed to identify a cost-effective way forward while ensuring that the datasets would remain highly available for researchers to use on demand. After weighing various options, Kellogg worked with Amazon Web Services (AWS) to create a data lake that fit its unique needs.

AWS branded background with text overlay that says "Estimating physical climate heat risk with NASA Global Daily Downscaled Projections on ASDI"

Estimating physical climate heat risk with NASA Global Daily Downscaled Projections on ASDI

Climate risk consists of transition risk and physical risk. Transition risk represents regulatory and market-based risks while physical climate risk covers climate-related earth processes and its effects on the built and natural environment. In this blog post, we highlight how to use Amazon Web Services (AWS) to enrich your asset portfolio with open climate data hosted in AWS.

AWS branded background with text overlay that says "How transit agencies can use AWS to improve safety and passenger experience"

How transit agencies can use AWS to improve safety and passenger experience

Fleet managers can use Amazon Web Services (AWS) to ingest and analyze fleet driver data. In this post, we share how a large public transit agency in the United States worked with AWS to create a proof-of-concept (POC) to analyze operator behavior and improve its visibility of sudden acceleration-based events.

How the Imaging Data Commons migrated 40 million medical images using AWS DataSync

How the Imaging Data Commons migrated 40 million medical images using AWS DataSync

Learn how the National Cancer Institute Imaging Data Commons (IDC) team migrated the Imaging Data Commons data to AWS using AWS DataSync. Plus, learn how to get started with IDC data, which is accessible at no cost through the AWS Open Data Sponsorship Program.

AWS brand themed background with text overlay that says "Build population healthy systems to enhance healthcare customer experiences on AWS"

Build population health systems to enhance healthcare customer experiences on AWS

As the amount of health data increases, different healthcare, life sciences, population health, and public health organizations are working to modernize their data infrastructure, unify their data, and innovate faster with technologies like artificial intelligence and machine learning (AI/ML). In this blog post, we dive deep on architecture guidance that enables healthcare providers to improve patient care.

Querying the Daylight OpenStreetMap Distribution with Amazon Athena

In 2020, Meta introduced the Daylight Map Distribution, which combines OpenStreetMap (OSM) data with quality and consistency checks from Daylight mapping partners to create a no-cost, stable, and simple-to-use global map. This blog post provides a brief overview of OSM and Daylight followed by a step-by-step tutorial using five real-world examples. We combine the powerful query capabilities of Amazon Athena from with the feature-rich Daylight OSM data to demonstrate a typical OSM data analysis workflow.

Analyzing vehicle fleet location data from a data lake with AWS

At AWS, many public sector customers operate fleets of vehicles (e.g. emergency response, public transportation) that generate location data, which is ultimately stored in a data lake. These customers frequently ask how they can quickly visualize this data and extract insights that can help them optimize how they operate their vehicle fleets. In this post, learn how to use Amazon Athena and Amazon Location Service to perform ad hoc reverse geocoding on a notional dataset of vehicle location history, and visualize the results on an Amazon QuickSight map.

Visualize data lake address datasets on a map with Amazon Athena and Amazon Location Service geocoding

Many public sector customers in government, healthcare, and life sciences have data lakes that contain addresses (e.g., 123 Main Street). These customers frequently ask how they can quickly visualize these addresses on a geographic map to get a more intuitive understanding of how these addresses are distributed. In this post, learn how to use Amazon Athena and Amazon Location Service to perform ad hoc geocoding on an example dataset and visualize these geocoded addresses on an Amazon QuickSight map.