Spatial data Management in PostGIS
07-18, 16:00–16:30 (Europe/Sarajevo), CA01

Got some vector data? Want to know how to manage it in PostGIS? We'll go over few tips and tricks from getting started to scaling the storage, showcasing "PostGIS is all you need"
- Basics of PostGIS - point, lines and polygons
- Indexing in PostGIS - GIST & BTree
- Uber h3 indexing
- Tiles from vector data
- Here comes the temporal dimension - TimescaleDB
- Building insights at database level
- Compress your data
- Deploying strategies: managed vs self-hosted | single node vs cluster
- Next steps for highly available database with least cost
- Shall we consider MongoDB?

Indicate what is (are) the open source project(s) essential in your talk –
  • PostGIS
  • Uber h3
  • TimescaleDB
  • Martin
  • Postgres Operator by Crunchy Data
  • pg_cirrus (HA Postgres)
 Assign a number between 1 and 3 indicating the level of technical complexity of your contribution. –

1 - no previous knowledge needed

 Select at least one general theme that best defines your proposal –

Data access, collection & sharing, Data processing and analysis

 I make my conference contribution available under the CC BY 4.0 license. The conference contribution comprises the abstract, the text contribution for the conference proceedings, the presentation materials as well as the video recording and live transmission of the presentation – yes
json singh

I have worked as a developer in Open Source GIS domain in multiple startups for the past 6 years and built many applications from scratch to production, managed teams, hired people and wore many other hats.I had the honor of working with companies from all over the world including Japan, Switzerland, Australia, US and more.

Now I am volunteering at OSGeo, giving back to the community that has given me access to the whole wide world.

Work: https://jsonsingh.com/work