gis databases what is gis
play

GIS Databases What is GIS? "...the merging of cartography, - PowerPoint PPT Presentation

Dec 04, 2022 •25 likes •135 views

GIS Databases What is GIS? "...the merging of cartography, statistical analysis, and database technology." Open GIS: Background & History OGC (Open Geospatial Network Consortium) Unix, NASA, Corps of Engineers, Ag.

  1. GIS Databases

  2. What is GIS? "...the merging of cartography, statistical analysis, and database technology."

  4. Open GIS: Background & History ● OGC (Open Geospatial Network Consortium) ○ Unix, NASA, Corps of Engineers, Ag. Dept., Sun ○ GRASS (Geographic Resource Analysis Support System) ● Standards (Alphabet Soup...) ○ SFA (Simple Feature Access) ○ WKT (Well Known Text) ○ WKB (Well Known Binary) ○ WFS (Web Feature Service) ○ WMS (Web Map Service)

  5. Spatial Databases MongoDB PostgreSQL DBMS Esri MySQL DBMS SpaceBase Neo4j CouchDB AllegroGraph CartoDB Boeing's Spatial Query Server IBM DB2 Smallworld VMDS Oracle Spatial SpatiaLite extends Microsoft SQL Server Sqlite

  6. Standard OGC Geometry Types

  7. Spatial Queries: PostGIS Example ● Distance(geometry, geometry) : number ● Equals(geometry, geometry) : boolean ● Disjoint(geometry, geometry) : boolean ● Intersects(geometry, geometry) : boolean ● Touches(geometry, geometry) : boolean ● Crosses(geometry, geometry) : boolean ● Overlaps(geometry, geometry) : boolean ● Contains(geometry, geometry) : boolean ● Length(geometry) : number ● Area(geometry) : number ● Centroid(geometry) : geometry

  8. Spatial Indices: Optimizing Spacial Queries ● Grid ● R+ tree ● Z-order ● R* tree ● Quadtree ● Hilbert R-tree ● Octree ● X-tree ● UB-tree ● KD-tree ● R-tree ● M-tree

  9. Indexing Example: Minimum Bounding Rectangle

  10. GIS Technology Stack

  11. Bibliography File:GeoServer GeoNetwork with web app.png. (n.d.).Wikipedia, the free encyclopedia. Retrieved from http://en. wikipedia.org/wiki/File:GeoServer_GeoNetwork_with_web_app.png Geographic information system. (2012, November 3).Wikipedia, the free encyclopedia. Retrieved from http://en. wikipedia.org/w/index.php?title=Geographic_information_system&oldid=521136246 Simple feature access. (2012, October 22).Wikipedia, the free encyclopedia. Retrieved from http://en.wikipedia. org/w/index.php?title=Simple_feature_access&oldid=515909953 Spatial database. (2012, October 12).Wikipedia, the free encyclopedia. Retrieved from http://en.wikipedia.org/w/index. php?title=Spatial_database&oldid=517379046 Spatial query. (2012, October 16).Wikipedia, the free encyclopedia. Retrieved from http://en.wikipedia.org/w/index.php? title=Spatial_query&oldid=430843056 Well-known text. (2012, October 11).Wikipedia, the free encyclopedia. Retrieved from http://en.wikipedia.org/w/index. php?title=Well-known_text&oldid=515910084 Open Geospatial Consortium. (2012, November 4). OGC. Retrieved from http://www.opengeospatial.org/

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

Creating Databases and Tables Introduction to Databases in Python Creating Databases

Creating Databases and Tables Introduction to Databases in Python Creating Databases

INTRODUCTION TO DATABASES IN PYTHON Creating Databases and Tables Introduction to Databases in Python Creating Databases Varies by the database type Databases like PostgreSQL and MySQL have command line tools to initialize

878 views • 31 slides
Databases and PHP Accessing databases from PHP PHP & Databases l PHP can connect to

Databases and PHP Accessing databases from PHP PHP & Databases l PHP can connect to

Databases and PHP Accessing databases from PHP PHP & Databases l PHP can connect to virtually any database l There are specific functions built-into PHP to connect with some DB l There is also generic ODBC functions that will work with many

868 views • 28 slides
3. Text and document databases Normal databases: formatted records; document databases:

3. Text and document databases Normal databases: formatted records; document databases:

3. Text and document databases Normal databases: formatted records; document databases: free-form or semi-structured data (e.g. XML). Application areas: - Office automation, document archives - Digital libraries - Electronic dictionaries

741 views • 38 slides
Module 3: Creating and Managing Databases Overview Creating Databases Creating

Module 3: Creating and Managing Databases Overview Creating Databases Creating

Module 3: Creating and Managing Databases Overview Creating Databases Creating Filegroups Managing Databases Introduction to Data Structures Creating Databases Defining Databases How the Transaction Log Works

445 views • 18 slides
CSE 462 - Databases Oliver Kennedy okennedy@buffalo.edu 1 Why Study Databases? 2 3 3 2

CSE 462 - Databases Oliver Kennedy okennedy@buffalo.edu 1 Why Study Databases? 2 3 3 2

CSE 462 - Databases Oliver Kennedy okennedy@buffalo.edu 1 Why Study Databases? 2 3 3 2 Queries per Second 3 Interesting Problems Algorithms Systems Databases Hardware Theory 4 $$$ 8 of the top 10 Forbes Global 2000 Software &

1.12k views • 73 slides
Introduc)on*to*Databases 1 Rela%onal(Databases(with(PostgreSQL

Introduc)on*to*Databases 1 Rela%onal(Databases(with(PostgreSQL

Introduc)on*to*Databases 1 Rela%onal(Databases(with(PostgreSQL Databases(have(tables(to(classify(data Collec3ons(have: rows :(data(defining(an(en3re(rectod,(e.g.(a(user columns

862 views • 25 slides
Introduction to Databases Introduction to Databases in Python A database consists of tables

Introduction to Databases Introduction to Databases in Python A database consists of tables

INTRODUCTION TO DATABASES IN PYTHON Introduction to Databases Introduction to Databases in Python A database consists of tables Census State_Fact state sex age pop2000 pop2008 name abbreviation type New F 0 120355 122194 New York

699 views • 27 slides
HUDOC databases: CPT and ESC Patrick Mller HUDOC databases: CPT and ESC HUDOC HUDOC = Human

HUDOC databases: CPT and ESC Patrick Mller HUDOC databases: CPT and ESC HUDOC HUDOC = Human

HUDOC databases: CPT and ESC Patrick Mller HUDOC databases: CPT and ESC HUDOC HUDOC = Human Rights DOCumentation HUDOC is more than ECHR case-law CPT and ESC databases existed, but were not very visible, and technically

371 views • 9 slides
1 2 What is covered in this presentation? A brief history of databases NoSQL WHY, WHAT

1 2 What is covered in this presentation? A brief history of databases NoSQL WHY, WHAT

1 2 What is covered in this presentation? A brief history of databases NoSQL WHY, WHAT & WHEN? Characteristics of NoSQL databases Aggregate data models CAP theorem Ashwani Kumar 16 February 2018 NOSQL Databases 3

647 views • 31 slides
CS377: Database Systems Distributed Databases Distributed Databases

CS377: Database Systems Distributed Databases Distributed Databases

CS377: Database Systems Distributed Databases Distributed Databases Department of Mathematics and Computer Science Emory University 1 Centralized DBMS on a Network

669 views • 29 slides
Advanced topics in databases Multimedia Databases V. Megalooikonomou XML ( based on slides

Advanced topics in databases Multimedia Databases V. Megalooikonomou XML ( based on slides

Advanced topics in databases Multimedia Databases V. Megalooikonomou XML ( based on slides by Silberschatz, Korth and Sudarshan at Bell Labs and Indian Institute of Technology ) General Overview - XML Introduction Motivation

1.06k views • 71 slides
DISTRIBUTED DATABASES CHAPTER 25 LECTURE OVERVIEW What are distributed databases?

DISTRIBUTED DATABASES CHAPTER 25 LECTURE OVERVIEW What are distributed databases?

DISTRIBUTED DATABASES CHAPTER 25 LECTURE OVERVIEW What are distributed databases? Transparency and autonomy Fragmentation, allocation, replication Homogeneous vs. heterogeneous DDBMS Distributed transaction

1.27k views • 15 slides
Databases Peter Zaitsev Percona You Might Know I am passionate about Open Source Databases

Databases Peter Zaitsev Percona You Might Know I am passionate about Open Source Databases

Maximizing the Power and Value of Open Source Databases Peter Zaitsev Percona You Might Know I am passionate about Open Source Databases 2 Open Source Databases Leading in Growth Source: https://db-engines.com/en/ranking 3 Long Term

708 views • 42 slides
CSE 154 LECTURE 22:RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSE 154 LECTURE 22:RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSE 154 LECTURE 22:RELATIONAL DATABASES AND SQL Relational databases relational database : A method of structuring data as tables associated to each other by shared attributes. a table row corresponds to a unit of data called a record ; a

602 views • 26 slides
CSC 337 LECTURE 20: RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSC 337 LECTURE 20: RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSC 337 LECTURE 20: RELATIONAL DATABASES AND SQL Relational databases relational database : A method of structuring data as tables associated to each other by shared attributes. a table row corresponds to a unit of data called a record ;

1.1k views • 30 slides
CSE 154 LECTURE 13:RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSE 154 LECTURE 13:RELATIONAL DATABASES AND SQL Relational databases relational database : A

CSE 154 LECTURE 13:RELATIONAL DATABASES AND SQL Relational databases relational database : A method of structuring data as tables associated to each other by shared attributes. a table row corresponds to a unit of data called a record ; a

521 views • 27 slides
Distributed Simulations Tyler F. Cloutier Goal Focus on optimizing

Distributed Simulations Tyler F. Cloutier Goal Focus on optimizing

Distributed Simulations Tyler F. Cloutier Goal Focus on optimizing distributed calculations Create an easily generalizable system that can be applied to many

662 views • 38 slides
Making sense of 3D data Nico Blodow blodow@cs.tum.edu Intelligent Autonomous Systems, TUM,

Making sense of 3D data Nico Blodow blodow@cs.tum.edu Intelligent Autonomous Systems, TUM,

Making sense of 3D data Nico Blodow blodow@cs.tum.edu Intelligent Autonomous Systems, TUM, Germany June 14, 2012 Motivation Central question in many 3D perception applications: How can we at all times know what is going on around us?

861 views • 61 slides
AFastVolumeRenderingAlgorithm forTimevaryingFieldsusinga

AFastVolumeRenderingAlgorithm forTimevaryingFieldsusinga

AFastVolumeRenderingAlgorithm forTimevaryingFieldsusinga TimespacePar<<oning(TSP)Tree HanWeiShen,LingJenChiang, KwanLiuMa Vis1999

384 views • 23 slides
VALEOL Thirty Month Review Meeting 23 rd - 24 th November 2017, INRIA, Bordeaux Presented by

VALEOL Thirty Month Review Meeting 23 rd - 24 th November 2017, INRIA, Bordeaux Presented by

Funded by the European Union VALEOL Thirty Month Review Meeting 23 rd - 24 th November 2017, INRIA, Bordeaux Presented by Claire Taymans AEROGUST M30 PROGRESS MEETING 1 Funded by the European Union Summary WP 2 Task : Investigation of

359 views • 15 slides
Counting Backwards Fatima counts backwards from 10: -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 9

Counting Backwards Fatima counts backwards from 10: -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 9

Counting Backwards Fatima counts backwards from 10: -4 -3 -2 -1 0 1 2 3 4 5 6 7 8 9 10 Continue counting. Number Line Here is a number line with some numbers marked. Laura needs some help to complete the line. -10 -9 -8 -7

120 views • 8 slides
Foundation of proofs Jim Hefferon http://joshua.smcvt.edu/proofs The need to prove In

Foundation of proofs Jim Hefferon http://joshua.smcvt.edu/proofs The need to prove In

Foundation of proofs Jim Hefferon http://joshua.smcvt.edu/proofs The need to prove In Mathematics we prove things The base angles of an isoceles triangle are equal seems obvious to a person with mathematical aptitude. a if a = b

678 views • 52 slides
Learning Continuity and Attendance Plan Input Sessions Yolanda Valdez, Superintendent August

Learning Continuity and Attendance Plan Input Sessions Yolanda Valdez, Superintendent August

Learning Continuity and Attendance Plan Input Sessions Yolanda Valdez, Superintendent August 2020 Versatility, Effjciency, Effectiveness & Equity Senate Bill 98: Local Control and Accountability Plan (LCAP) vs. Learning Continuity and

333 views • 19 slides
Motivating Learning and Catering for Learner Diversity in LAC (A practical approach) By Mr. YIP

Motivating Learning and Catering for Learner Diversity in LAC (A practical approach) By Mr. YIP

Motivating Learning and Catering for Learner Diversity in LAC (A practical approach) By Mr. YIP Hoi Kit Vice-Chairperson of Academic Committee Vice-Panel Chairperson of Mathematics P.O.H. 80 th Anniversary Tang Ying Hei College School

714 views • 38 slides

More recommend