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

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

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

489 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 /

766 views • 48 slides

Extending PostgreSQL With Spatiotemporal Data Management Contacts: Esteban Zimanyi

Extending PostgreSQL With Spatiotemporal Data Management Contacts: Esteban Zimanyi (ezimanyi@ulb.ac.be) Mahmoud SAKR (mahmoud.sakr@ulb.ac.be) Mobility Data: PostGIS Mobility Data: Trajectories Mobility Data: Temporal Types tfloat:

693 views • 36 slides

Patterns and Packages in PostgreSQL for Privacy Preservation mantaq10 15 November 2019, Sydney

PostgreSQL, Planning, PostGIS, Partitioning, PaaS, Permissions and now. Patterns and Packages in PostgreSQL for Privacy Preservation mantaq10 15 November 2019, Sydney www.2019.pgdu.org Atif Rahman I was like her According to Pearson-R

508 views • 24 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.68k views • 142 slides

Hacking PostgreSQL with Eclipse Metin Dl metin@citusdata.com PGCONF.EU 2017 1

Hacking PostgreSQL with Eclipse Metin Dl metin@citusdata.com PGCONF.EU 2017 1 Motivation Postgres cant do everything You can extend it Eclipse makes it easy 2 Extensions postGIS - Spatial and Geographic objects pg_cron - Run

376 views • 19 slides

PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd ICTVET UNP Bukittingi, 16-17 Oct

PostgreSQL A Platform for Multiple Sources Data Retrieval 3 rd ICTVET UNP Bukittingi, 16-17 Oct 2015 Abdul Yadi abdulyadi.wordpress.com Software Developer, Datatrans Informatika Front End: GWT, Sencha GXT Database: PostgreSQL data data

745 views • 22 slides

Service 1 Service 2 Service 3 Postgresql/ MySQL Postgresql/ MySQL Data size: ~100GB to a few

Service 1 Service 2 Service 3 Postgresql/ MySQL Postgresql/ MySQL Data size: ~100GB to a few TB Latency: very fast since it was in a real DB Applications: Amazon S3 EMR Kafka 7 ETL/ Modelling City Ops Machine Learning

1.01k views • 58 slides

PostgreSQL As Data Integration Tool PostgreSQL SQL-MED pgDay Paris 2019/03/12 Stefanie Janine

PostgreSQL As Data Integration Tool PostgreSQL SQL-MED pgDay Paris 2019/03/12 Stefanie Janine Stlting @sjstoelting mail@stefanie-stoelting.de SQL/MED First defined in ISO/IEC 9075-9:2008, revised by ISO/IEC 9075-9:2016 Supported by DB2

694 views • 45 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.73k views • 139 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:

517 views • 7 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

783 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

Distributed Computing on PostgreSQL Marco Slot <marco@citusdata.com> Small data

Distributed Computing on PostgreSQL Marco Slot <marco@citusdata.com> Small data architecture Big data architecture Big data architecture using postgres Real-time analytics Messaging Records Data warehouse PostgreSQL is a perfect

746 views • 41 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

Crunchy Data PostgreSQL Operator September 2017 Crunchy Data Commitment to Community and Open

Crunchy Data PostgreSQL Operator September 2017 Crunchy Data Commitment to Community and Open Source Emphasis on Data Security and Compliance PostgreSQL for Public, Private and Hybrid Cloud 5 What is an Operator? 3 Operator Basics

1.36k views • 33 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

239 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

866 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

786 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

188 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

391 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

625 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