Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Checkout

Change country

Modal Close icon
Country selected Country selected
country flag Germany
Country selected
country flag Slovakia
Country selected
country flag Canada
Country selected
country flag Brazil
Country selected
country flag Singapore
Country selected
country flag Hungary
Country selected
country flag Philippines
Country selected
country flag Mexico
Country selected
country flag Thailand
Country selected
country flag Ukraine
Country selected
country flag Luxembourg
Country selected
country flag Estonia
Country selected
country flag Lithuania
Country selected
country flag Norway
Country selected
country flag Chile
Country selected
country flag United States
Country selected
country flag Great Britain
Country selected
country flag India
Country selected
country flag Spain
Country selected
country flag South Korea
Country selected
country flag Ecuador
Country selected
country flag Colombia
Country selected
country flag Taiwan
Country selected
country flag Switzerland
Country selected
country flag Indonesia
Country selected
country flag Cyprus
Country selected
country flag Denmark
Country selected
country flag Finland
Country selected
country flag Poland
Country selected
country flag Malta
Country selected
country flag Czechia
Country selected
country flag New Zealand
Country selected
country flag Austria
Country selected
country flag Turkey
Country selected
country flag France
Country selected
country flag Sweden
Country selected
country flag Italy
Country selected
country flag Egypt
Country selected
country flag Belgium
Country selected
country flag Portugal
Country selected
country flag Slovenia
Country selected
country flag Ireland
Country selected
country flag Romania
Country selected
country flag Greece
Country selected
country flag Argentina
Country selected
country flag Malaysia
Country selected
country flag South Africa
Country selected
country flag Netherlands
Country selected
country flag Bulgaria
Country selected
country flag Latvia
Country selected
country flag Australia
Country selected
country flag Japan
Country selected
country flag Russia
Country selected
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Geospatial Data Analytics on AWS

You're reading from   Geospatial Data Analytics on AWS Discover how to manage and analyze geospatial data in the cloud

Arrow left icon
Product type Paperback
Published in Jun 2023
Publisher Packt
ISBN-13 9781804613825
Length 276 pages
Edition 1st Edition
Languages
Tools
Concepts
Arrow right icon
Authors (3):
Arrow left icon
Scott Bateman Scott Bateman
Author Profile Icon Scott Bateman
Scott Bateman
LinkedIn
Scott Bateman is a Principal Solutions Architect at AWS focused on customers in the energy industry. He holds a BS in Computer Science from Trinity University, and an Executive MBA from Quantic in addition to numerous AWS and Microsoft certifications. As part of the Geospatial Technical Field Community (TFC) group within AWS, Scott is able to regularly speak with customers about common challenges storing data, creating maps, tracking assets, optimizing driving routes, and better understanding facilities and property through remote sensing. When not working or writing, Scott enjoys snowboarding and international travel with his wife of over 2 decades, Angel, and 2 wonderful children Jackson and Emily.
Read more
See other products by Scott Bateman
Jeff DeMuth Jeff DeMuth
Author Profile Icon Jeff DeMuth
Jeff DeMuth
Jeff Demuth is a solutions architect who joined Amazon Web Services (AWS) in 2016. He focuses on the geospatial community and is passionate about geographic information systems (GIS) and technology. Outside of work, Jeff enjoys traveling, building Internet of Things (IoT) applications, and tinkering with the latest gadgets.
Read more
See other products by Jeff DeMuth
Janahan Gnanachandran Janahan Gnanachandran
Author Profile Icon Janahan Gnanachandran
Janahan Gnanachandran
LinkedIn
Janahan (Jana) is a Principal Solutions Architect at AWS. He partners with customers across industries to increase speed, agility, and drive innovation using the cloud for digital transformation. Jana holds a BE in Electronics and Communication Engineering from Anna University, India, and an MS in Computer Engineering from the University of Louisiana at Lafayette. Alongside designing scalable, secure, and cost-effective cloud solutions, Jana conducts workshops, training sessions, and public speaking engagements on cloud best practices, architectural best practices, and data and AI/ML strategies. When not immersed in cloud computing, he enjoys playing tennis or golf and traveling with his wife Dilakshana and their 2 kids, Jashwin and Dhruvish.
Read more
See other products by Janahan Gnanachandran
Arrow right icon
View More author details
Toc

Table of Contents (23) Chapters Close

Preface 1. Part 1: Introduction to the Geospatial Data Ecosystem
2. Chapter 1: Introduction to Geospatial Data in the Cloud FREE CHAPTER 3. Chapter 2: Quality and Temporal Geospatial Data Concepts 4. Part 2: Geospatial Data Lakes using Modern Data Architecture
5. Chapter 3: Geospatial Data Lake Architecture 6. Chapter 4: Using Geospatial Data with Amazon Redshift 7. Chapter 5: Using Geospatial Data with Amazon Aurora PostgreSQL 8. Chapter 6: Serverless Options for Geospatial 9. Chapter 7: Querying Geospatial Data with Amazon Athena 10. Part 3: Analyzing and Visualizing Geospatial Data in AWS
11. Chapter 8: Geospatial Containers on AWS 12. Chapter 9: Using Geospatial Data with Amazon EMR 13. Chapter 10: Geospatial Data Analysis Using R on AWS 14. Chapter 11: Geospatial Machine Learning with SageMaker 15. Chapter 12: Using Amazon QuickSight to Visualize Geospatial Data 16. Part 4: Accessing Open Source and Commercial Platforms and Services
17. Chapter 13: Open Data on AWS 18. Chapter 14: Leveraging OpenStreetMap on AWS 19. Chapter 15: Feature Servers and Map Servers on AWS 20. Chapter 16: Satellite and Aerial Imagery on AWS 21. Index 22. Other Books You May Enjoy

Connecting to your data source

To provide an example of a free, public dataset that can be used to create a map in QuickSight, you can leverage the Kaggle dataset of major league sports stadiums in the United States.

Figure 12.1: Sports stadium data .csv file contents

Figure 12.1: Sports stadium data .csv file contents

This data can be downloaded in tabular format and uploaded to Amazon Simple Storage Service (S3) as a comma-separated values (CSV) file:

Figure 12.2: Sports stadium data .csv file in an S3 bucket

Figure 12.2: Sports stadium data .csv file in an S3 bucket

Configuring Athena

You will now have a static dataset in S3 that we will expose to Amazon Athena in order to make the dataset accessible to Structured Query Language (SQL) queries. This approach is recommended for data that may change over time. Any changes made to the source data in S3 will automatically update the AWS Glue and Amazon Athena constructs that represent the data to QuickSight and other AWS services. The following query can be used in the Amazon Athena...

lock icon The rest of the chapter is locked
arrow left Previous Section
Section 4 of 9
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at $19.99/month. Cancel anytime

Authors (3)

Left arrow icon
Profile icon Scott Bateman
Scott Bateman
LinkedIn icon Github icon
Scott Bateman is a Principal Solutions Architect at AWS focused on customers in the energy industry. He holds a BS in Computer Science from Trinity University, and an Executive MBA from Quantic in addition to numerous AWS and Microsoft certifications. As part of the Geospatial Technical Field Community (TFC) group within AWS, Scott is able to regularly speak with customers about common challenges storing data, creating maps, tracking assets, optimizing driving routes, and better understanding facilities and property through remote sensing. When not working or writing, Scott enjoys snowboarding and international travel with his wife of over 2 decades, Angel, and 2 wonderful children Jackson and Emily.
Read more
See other products by Scott Bateman
Profile icon Jeff DeMuth
Jeff DeMuth
Jeff Demuth is a solutions architect who joined Amazon Web Services (AWS) in 2016. He focuses on the geospatial community and is passionate about geographic information systems (GIS) and technology. Outside of work, Jeff enjoys traveling, building Internet of Things (IoT) applications, and tinkering with the latest gadgets.
Read more
See other products by Jeff DeMuth
Profile icon Janahan Gnanachandran
Janahan Gnanachandran
LinkedIn icon
Janahan (Jana) is a Principal Solutions Architect at AWS. He partners with customers across industries to increase speed, agility, and drive innovation using the cloud for digital transformation. Jana holds a BE in Electronics and Communication Engineering from Anna University, India, and an MS in Computer Engineering from the University of Louisiana at Lafayette. Alongside designing scalable, secure, and cost-effective cloud solutions, Jana conducts workshops, training sessions, and public speaking engagements on cloud best practices, architectural best practices, and data and AI/ML strategies. When not immersed in cloud computing, he enjoys playing tennis or golf and traveling with his wife Dilakshana and their 2 kids, Jashwin and Dhruvish.
Read more
See other products by Janahan Gnanachandran
Right arrow icon
Banner background image

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Pragmatic Microservices with C# and Azure
Pragmatic Microservices with C# and Azure
Read more
This book empowers you with in-depth knowledge of microservices architecture using .NET and Azure. Through hands-on tutorials, you'll be able to build, deploy, and manage scalable applications, gaining crucial skills for modern software development.
Read more
May 2024 16h 56m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.
Read more
May 2024 9h 52m
Mastering Python Design Patterns
Mastering Python Design Patterns
Read more
Unlock the power of design patterns to build maintainable and scalable software and applications using Python. Authored by Python veterans, this book is your guide to mastering design patterns in Python.
Read more
May 2024 9h 52m
Right arrow icon