OSM Data Processing with PostgreSQL / PostGIS Jochen Topf - PowerPoint PPT Presentation

Jun 26, 2023 •3.45k likes •4.97k views

OSM Data Processing with PostgreSQL / PostGIS Jochen Topf jochentopf.com OpenStreetMap PostgreSQL Studley Tool Chest | CC-BY-SA | https://www.flickr.com/photos/publicresourceorg/493813720 From help.openstreetmap.org What we will talk

Snapshot vs. History most use cases only need current OSM data some need history of OSM data Much more effort needed !
Use Cases
Use Cases API DB Rendering Geocoding Routing Analytics

Recommend

Introduction to Spatial Data Management with Postgis Spatial Data Management Content

Introduction to Spatial Data Management with Postgis Spatial Data Management Content Introduction Managing Spatial Data with PostGIS PostGIS Data Model Creating a PostGIS enabled Database Insert Coordinates using SQL

496 views • 27 slides

POSTGIS berblick, Tips und Tricks Stefan Keller Topics What is PostGIS? Spatial table

Swiss PGDay 2016, 24. Juni 2016, HSR Rapperswil POSTGIS berblick, Tips und Tricks Stefan Keller Topics What is PostGIS? Spatial table Example with historical data OGC queries in PostGIS Spatial Joins OGC Layers /

770 views • 48 slides

Student Services Managers Meeting August 8, 2018 Online Syllabus Management (OSM) Tool

Student Services Managers Meeting August 8, 2018 Online Syllabus Management (OSM) Tool Access: https://osm.oasis.unc.edu/osm/ Tuesday, August 7, 2018 OSM opens OSM Managers send instructions to fall 2018 instructors, including

417 views • 13 slides

Easily Settjng up 4G/5G Testbeds Easily Settjng up 4G/5G Testbeds with OpenAirInterface using OSM

Easily Settjng up 4G/5G Testbeds Easily Settjng up 4G/5G Testbeds with OpenAirInterface using OSM with OpenAirInterface using OSM Thomas Dreibholz, dreibh@simula.no dreibh@simula.no Thomas Dreibholz, th OSM Hackfest, 9 th OSM Hackfest, Madrid

355 views • 16 slides

PostGIS Feature Frenzy!!! Wednesday, September 16, 15 frenzy because state of postgis

P AUL R AMSEY PRESENTS .... PostGIS Feature Frenzy!!! Wednesday, September 16, 15 frenzy because state of postgis talks only covered leading edge, nothing covering all the good features already there frenzy because our standard 20-25

1.69k views • 142 slides

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com FOSDEM 2019 February 3,

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com FOSDEM 2019 February 3, 2019 PostgreSQL Source Code Hacking PostgreSQL Final Code PostgreSQL Subsystems Hacking the PostgreSQL Way Stephen Frost Chief Technology

785 views • 37 slides

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com PGConf.EU 2018 October

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com PGConf.EU 2018 October 24, 2018 PostgreSQL Source Code Hacking PostgreSQL Final Code PostgreSQL Subsystems Hacking the PostgreSQL Way Stephen Frost Chief Technology

1.12k views • 36 slides

Modding the OSM Data Model Jochen Topf Modding the OSM Data Model Jochen Topf What we will talk

Modding the OSM Data Model Jochen Topf Modding the OSM Data Model Jochen Topf What we will talk about... 1. Background 2. Problems Objects Way nodes Nodes Ways Way geometry Relations Relations Tags Areas Object Identity and Object

725 views • 57 slides

PostgreSQL Who, What, When, Where, Why, How? 1 QUIS? Who's involved with PostgreSQL? Core

PostgreSQL Who, What, When, Where, Why, How? 1 QUIS? Who's involved with PostgreSQL? Core team: https://www.postgresql.org/community/contributors/ Large Users: https://www.postgresql.org/about/users/ Case Studies:

518 views • 7 slides

PostgreSQL SQL-MED Ibrar Ahmed Senior Software Engineer @ Percona PostgreSQL Consultant What?

PostgreSQL SQL-MED Ibrar Ahmed Senior Software Engineer @ Percona PostgreSQL Consultant What? Is an relational database Licence PostgreSQL: Released under the PostgreSQL management system (RDBMS) License. (Similar to the BSD or MIT)

232 views • 10 slides

Breaking PostgreSQL at Scale. Christophe Pettus PostgreSQL Experts pgDay Paris 2019

Breaking PostgreSQL at Scale. Christophe Pettus PostgreSQL Experts pgDay Paris 2019 Christophe Pettus CEO, PostgreSQL Experts, Inc. christophe.pettus@pgexperts.com thebuild.com twitter @xof So, what is this? PostgreSQL can

862 views • 60 slides

PostgreSQL Provider The PostgreSQL provider gives the ability to deploy and congure resources

PostgreSQL Provider The PostgreSQL provider gives the ability to deploy and congure resources in a PostgreSQL server. Use the navigation to the left to read about the available resources. Usage provider "postgresql" { host

243 views • 12 slides

How Deep Learning, could help to improve GeoSpatial data quality ? an OSM use case @o_courtin

How Deep Learning, could help to improve GeoSpatial data quality ? an OSM use case @o_courtin FOSDEM 2018 2007-12 http://www.osm.be/assets/images/road-completion2.gif 2010-07 http://www.osm.be/assets/images/road-completion2.gif 2016-11

772 views • 43 slides

Magical PostGIS In 3 Brief Movements Friday, September 18, 15 Friday, September 18, 15 thanks

Magical PostGIS In 3 Brief Movements Friday, September 18, 15 Friday, September 18, 15 thanks to the good folks at cartodb for employing me and letting me work on PostGIS. like a lot of SaaS companies, cartodb has a strong open source ethic

1.74k views • 139 slides

How to make R, PostGIS and QGis cooperate for statistical modelling duties a case study on

How to make R, PostGIS and QGis cooperate for statistical modelling duties How to make R, PostGIS and QGis cooperate for statistical modelling duties a case study on hedonic regressions Olivier Bonin UPE IFSTTAR LVMT OGRS 2012 How to make

421 views • 17 slides

Look It Up: Practical PostgreSQL Indexing Christophe Pettus PostgreSQL Experts

Look It Up: Practical PostgreSQL Indexing Christophe Pettus PostgreSQL Experts Postgres Open 2019 Christophe Pettus CEO, PostgreSQL Experts, Inc. christophe.pettus@pgexperts.com thebuild.com twitter @xof Indexes! We

1.14k views • 78 slides

AsterixDB A Scalable Open Source DBMS This presentation is based on slides made by Michael J.

AsterixDB A Scalable Open Source DBMS This presentation is based on slides made by Michael J. Carey, Chen Li, and Vassilis Tsotras 1 Big Data / Web Warehousing Whats going So what went on and why? on right now? Whats going on 2

241 views • 23 slides

Processor Design Pipelined Processor Hung-Wei Tseng Drawbacks of a single-cycle processor

Processor Design Pipelined Processor Hung-Wei Tseng Drawbacks of a single-cycle processor The cycle time is determined by the longest instruction Could be very long, thinking about fetch data from DRAM Hardware is mostly idle 3

869 views • 47 slides

!"#$"%&&'(%)#"'#+'(%$,#+-.' /#"01#"2%'3+,,-*,4%&

The image part with relationship ID rId14 was not found in the file. !"#$"%&&'(%)#"*'#+'(%$,#+-.' /#"01#"2%'3+,*,-*,4%& !"#$%&'($)*#+,-(,()."#+/"#0')12334$ The image part with relationship

787 views • 35 slides

Automatic Printer Driver Installation in Fedora 13 Presenter Tim Waugh Senior Software

Automatic Printer Driver Installation in Fedora 13 Presenter Tim Waugh Senior Software Engineer, Red Hat 1 Tim Waugh Automatic Printer Driver Installation in Fedora 13 The idea Current status Driver requirements Limitations

190 views • 14 slides

Polytype Semantics Dr. Mattox Beckman University of Illinois at Urbana-Champaign Department of

Introduction Polytypes Examples Polytype Semantics Dr. Mattox Beckman University of Illinois at Urbana-Champaign Department of Computer Science Introduction Polytypes Examples Objectives Use the Gen and Inst rules to introduce

398 views • 18 slides

!" # Chapter 3 Describing Syntax and Semantics CS-4337 Organization of Programming

!" # Chapter 3 Describing Syntax and Semantics CS-4337 Organization of Programming Languages Dr. Chris Irwin Davis Email: cid021000@utdallas.edu Phone: (972) 883-3574 O ffi ce: ECSS 4.705 Chapter 3 Topics Introduction The

1.18k views • 58 slides

Geant4 in Atlas Entering the production phase See also: A.D. talk @CHEP01, Beijing

Geant4 in Atlas Entering the production phase See also: A.D. talk @CHEP01, Beijing A.Rimoldis talk @G4 users meeting, SLAC 02 C.Leggetts talk @G4 users meeting, SLAC 02 A n d r e a D e l l A c C E R N q u

627 views • 18 slides

- Claim : Pye www.alctf-XCX IT Rb ' - - ( x - KH ) - D 1 IT partition deg = n k classes monic

Chromatic polynomial - ( V , E ) M - eyed f : V - s ti Efx ] VE EE - ' Eff Ci ) - Claim : Pye www.alctf-XCX IT Rb ' - - ( x - KH ) - D 1 IT partition deg = n k classes monic E legal HE 172 illegal Pfe '= pgelxi-pE.cn HE Hi

435 views • 11 slides

Download document

More recommend

Explore More Topics

Stay informed with curated content and fresh updates.

animals pets art culture automotive transportation business finance computer internet construction architecture education-career electronics communication

OSM Data Processing with PostgreSQL / PostGIS Jochen Topf - PowerPoint PPT Presentation

OSM Data Processing with PostgreSQL / PostGIS Jochen Topf jochentopf.com OpenStreetMap PostgreSQL Studley Tool Chest | CC-BY-SA | https://www.flickr.com/photos/publicresourceorg/493813720 From help.openstreetmap.org What we will talk

Introduction to Spatial Data Management with Postgis Spatial Data Management Content

POSTGIS berblick, Tips und Tricks Stefan Keller Topics What is PostGIS? Spatial table

Student Services Managers Meeting August 8, 2018 Online Syllabus Management (OSM) Tool

Easily Settjng up 4G/5G Testbeds Easily Settjng up 4G/5G Testbeds with OpenAirInterface using OSM

PostGIS Feature Frenzy!!! Wednesday, September 16, 15 frenzy because state of postgis

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com FOSDEM 2019 February 3,

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com PGConf.EU 2018 October

Modding the OSM Data Model Jochen Topf Modding the OSM Data Model Jochen Topf What we will talk

PostgreSQL Who, What, When, Where, Why, How? 1 QUIS? Who's involved with PostgreSQL? Core

PostgreSQL SQL-MED Ibrar Ahmed Senior Software Engineer @ Percona PostgreSQL Consultant What?

Breaking PostgreSQL at Scale. Christophe Pettus PostgreSQL Experts pgDay Paris 2019

PostgreSQL Provider The PostgreSQL provider gives the ability to deploy and congure resources

How Deep Learning, could help to improve GeoSpatial data quality ? an OSM use case @o_courtin

Magical PostGIS In 3 Brief Movements Friday, September 18, 15 Friday, September 18, 15 thanks

How to make R, PostGIS and QGis cooperate for statistical modelling duties a case study on

Look It Up: Practical PostgreSQL Indexing Christophe Pettus PostgreSQL Experts

AsterixDB A Scalable Open Source DBMS This presentation is based on slides made by Michael J.

Processor Design Pipelined Processor Hung-Wei Tseng Drawbacks of a single-cycle processor

!"#$"%&&'(%)#"'#+'(%$,#+-.' /#"01#"2%'3+,,-*,4%&

Automatic Printer Driver Installation in Fedora 13 Presenter Tim Waugh Senior Software

Polytype Semantics Dr. Mattox Beckman University of Illinois at Urbana-Champaign Department of

!" # Chapter 3 Describing Syntax and Semantics CS-4337 Organization of Programming

Geant4 in Atlas Entering the production phase See also: A.D. talk @CHEP01, Beijing

- Claim : Pye www.alctf-XCX IT Rb ' - - ( x - KH ) - D 1 IT partition deg = n k classes monic

Explore More Topics

Sambuz

Useful Links

Newsletter

Mail Us

OSM Data Processing with PostgreSQL / PostGIS Jochen Topf - PowerPoint PPT Presentation

OSM Data Processing with PostgreSQL / PostGIS Jochen Topf jochentopf.com OpenStreetMap PostgreSQL Studley Tool Chest | CC-BY-SA | https://www.flickr.com/photos/publicresourceorg/493813720 From help.openstreetmap.org What we will talk

Introduction to Spatial Data Management with Postgis Spatial Data Management Content

POSTGIS berblick, Tips und Tricks Stefan Keller Topics What is PostGIS? Spatial table

Student Services Managers Meeting August 8, 2018 Online Syllabus Management (OSM) Tool

Easily Settjng up 4G/5G Testbeds Easily Settjng up 4G/5G Testbeds with OpenAirInterface using OSM

PostGIS Feature Frenzy!!! Wednesday, September 16, 15 frenzy because state of postgis

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com FOSDEM 2019 February 3,

Hacking PostgreSQL Stephen Frost Crunchy Data stephen@crunchydata.com PGConf.EU 2018 October

Modding the OSM Data Model Jochen Topf Modding the OSM Data Model Jochen Topf What we will talk

PostgreSQL Who, What, When, Where, Why, How? 1 QUIS? Who's involved with PostgreSQL? Core

PostgreSQL SQL-MED Ibrar Ahmed Senior Software Engineer @ Percona PostgreSQL Consultant What?

Breaking PostgreSQL at Scale. Christophe Pettus PostgreSQL Experts pgDay Paris 2019

PostgreSQL Provider The PostgreSQL provider gives the ability to deploy and congure resources

How Deep Learning, could help to improve GeoSpatial data quality ? an OSM use case @o_courtin

Magical PostGIS In 3 Brief Movements Friday, September 18, 15 Friday, September 18, 15 thanks

How to make R, PostGIS and QGis cooperate for statistical modelling duties a case study on

Look It Up: Practical PostgreSQL Indexing Christophe Pettus PostgreSQL Experts

AsterixDB A Scalable Open Source DBMS This presentation is based on slides made by Michael J.

Processor Design Pipelined Processor Hung-Wei Tseng Drawbacks of a single-cycle processor

!&quot;#$&quot;%&amp;&amp;'(%)#&quot;*'#+'(%$,#+-.' /#&quot;01#&quot;2%'3+,*,-*,4%&amp;

Automatic Printer Driver Installation in Fedora 13 Presenter Tim Waugh Senior Software

Polytype Semantics Dr. Mattox Beckman University of Illinois at Urbana-Champaign Department of

!&quot; # Chapter 3 Describing Syntax and Semantics CS-4337 Organization of Programming

Geant4 in Atlas Entering the production phase See also: A.D. talk @CHEP01, Beijing

- Claim : Pye www.alctf-XCX IT Rb ' - - ( x - KH ) - D 1 IT partition deg = n k classes monic

Explore More Topics

Sambuz

Useful Links

Newsletter

Mail Us

!"#$"%&&'(%)#"'#+'(%$,#+-.' /#"01#"2%'3+,,-*,4%&

!" # Chapter 3 Describing Syntax and Semantics CS-4337 Organization of Programming