Crunchy Data
Crunchy Data
  • Видео 113
  • Просмотров 198 507
Run Postgres Anywhere with Crunchy Data and Red Hat
From healthcare to the automotive sector, cloud-native applications are driving innovation and efficiency. Discover how Crunchy Data supports data-intensive workloads, enabling you to run Postgres anywhere.
Просмотров: 118

Видео

Discover the power of the Postgres-anywhere data stack with Crunchy Data and Red Hat
Просмотров 662 месяца назад
From healthcare to the automotive sector, cloud-native applications are driving innovation and efficiency. Discover how Crunchy Data supports data-intensive workloads, enabling you to run Postgres anywhere.
Crunchy Bridge for Analytics Demo
Просмотров 2783 месяца назад
Crunchy Bridge for Analytics is a new offering in Crunchy Bridge that lets you query and interact with your data lake using PostgreSQL commands via extensions, with a vectorized, parallel query engine. To learn more visit www.crunchydata.com/products/crunchy-bridge-for-analytics
PostGIS Day Introduction
Просмотров 8168 месяцев назад
Welcome to PostGIS Day! Paul Ramsey kicks off the day with a brief introduction.
Using PostgREST to create PostGIS Functions Fast
Просмотров 2 тыс.8 месяцев назад
Krishna Lodha from Rotten Grapes Pvt. Ltd. brings us 'Using PostgREST to create PostGIS Functions Fast'. In this talk, we will introduce PostgREST, a powerful open-source tool that can dramatically simplify the creation of custom PostGIS functions. PostgREST provides a RESTful API over a PostgreSQL database, enabling developers to quickly expose database functions as web services with minimal e...
Trajectory Analysis Using PostGIS
Просмотров 6218 месяцев назад
Benjamin Trigona-Harany from Planet brings us 'Trajectory Analysis Using PostGIS'. PostGIS supports geometries with a Z dimension and geometries with M (measure) values, but there are not a lot of examples of both of these being used together. One use case is the analysis of airplane tracks which requires both - that is to say every vertex has an altitude and a timestamp. This talk will show ho...
Custom Road Network Contraction for Routing
Просмотров 3648 месяцев назад
Laure-Hélène Bruneton from CampToCamp brings us 'Custom Road Network Contraction for Routing'. When computing the shortest path between two locations, the size of the roads dataset is often the number one impacting factor on performances. Let's discuss some ideas on how to reduce the size of this dataset, while preserving topology and attributes. Here is the link to my blog post on the same sub...
Mapping Where the Data is Not
Просмотров 2578 месяцев назад
Brendan Farrell from Clockwork Micro brings us 'Mapping Where the Data is Not'. We present a solution to the problem of displaying the areas in a web map where no data (polygon data) is available. This problem comes up, for example, if polygons designate flood risk areas. One then wants to avoid interpreting an area that has not been mapped at all for flood risk as an area that has been mapped ...
Enabling Mobility Data in Multiple Computing Environments
Просмотров 2568 месяцев назад
Esteban Zimanyi from Université libre de Bruxelles brings us 'Enabling Mobility Data in Multiple Computing Environments'. MobilityDB is an open source data management and analytics platform for mobility data (github.com/MobilityDB). Its core function is to efficiently store and query mobility tracks, such as vehicle GPS trajectories. It implements the Moving Features specification from the Open...
Air Traffic Analysis with PostGIS and MobilityDB
Просмотров 3108 месяцев назад
Wendell Turner from CSSI, Inc. brings us 'Air Traffic Analysis with PostGIS and MobilityDB'. Aircraft flight tracks naturally lend themselves to being stored as moving objects, and the MobilityDB extension to PostGIS is used to store these tracks for analysis. These tracks can then be intersected both geospatially and temporally with airspace elements (called traffic management initiatives) and...
We are part of the infrastructure, not above it
Просмотров 1688 месяцев назад
Bonny McClain from Global Impact Assessment brings us 'We are part of the infrastructure, not above it...'. Recent advances in geospatial analysis and the availability of digital maps have revealed the importance of urban form and built infrastructure as fundamental to understanding the vulnerabilities and vitality of global and local cities. Understanding that in the same way a stethoscope doe...
The PRAM Stack in Production
Просмотров 2508 месяцев назад
Rhys Stewart from Auchindown brings us 'The PRAM Stack in Production'. The database *is* the application. This is my very opinionated take on back-end programming. I discuss running Livewire (see lvwr.io/), a Software-as-a-Service used by distribution engineers in electric utility companies to provide visibility to, and answers for the relevant questions they may have about the network. It also...
Postgres Spatial DBA in a Pinch
Просмотров 3068 месяцев назад
Elizabeth Christensen from Crunchy Data brings us 'Postgres Spatial DBA in a Pinch'. Let's review some of the most important DBA tasks involved in running a database.
Spatial SQL, the Modern Data Stack, and PostGIS
Просмотров 1,2 тыс.8 месяцев назад
Matt Forrest from Carto brings us 'Spatial SQL, the Modern Data Stack, and PostGIS'. SQL, and in turn spatial SQL, is fast becoming the leading language for analytics. More tools are adopting it from data warehouses, to DuckDB, to dbt, and beyond. I believe that PostGIS is and will be the central tool to any modern GIS infrastructure. In this talk we will show practical and ready to implement e...
PgRouting: A Practical Example
Просмотров 1 тыс.8 месяцев назад
Vicky Vergara from pgRouting PSC brings us 'PgRouting: A Practical Example'. The UN OpenGIS initiative along with OSGeo Foundation organized the OSGeo UN Committee Educational Challenge where Challenge 2 was to create material for pgRouting. The challenge supports the objectives of the OSGeo UN Committee, i.e. promoting the development and use of open-source software that meets UN needs and sup...
What about the Geopackage ....
Просмотров 4808 месяцев назад
What about the Geopackage ....
Refactoring the Way We Talk About SQL: It is Costing us Money
Просмотров 5218 месяцев назад
Refactoring the Way We Talk About SQL: It is Costing us Money
Simple Polygonal Coverages in PostGIS
Просмотров 3978 месяцев назад
Simple Polygonal Coverages in PostGIS
PostGIS Performance Tips
Просмотров 9738 месяцев назад
PostGIS Performance Tips
PostGIS Surprise Extensions
Просмотров 5278 месяцев назад
PostGIS Surprise Extensions
PostGIS Ask Me Anything with Paul and Regina
Просмотров 3248 месяцев назад
PostGIS Ask Me Anything with Paul and Regina
PostGIS Day 2023 Closing Remarks
Просмотров 848 месяцев назад
PostGIS Day 2023 Closing Remarks
How the USDA is Putting PostGIS to Work in the Dynamic Soils Hub
Просмотров 561Год назад
How the USDA is Putting PostGIS to Work in the Dynamic Soils Hub
Property Data Management with PostGIS, PostgreSQL, QGIS and QField
Просмотров 2,2 тыс.Год назад
Property Data Management with PostGIS, PostgreSQL, QGIS and QField
PostGIS Day 2022 Kick Off
Просмотров 1,9 тыс.Год назад
PostGIS Day 2022 Kick Off
PostGIS for Conservation Planning and Supply Chain Impact Analysis
Просмотров 452Год назад
PostGIS for Conservation Planning and Supply Chain Impact Analysis
Simple and Fast OGC API Servers for PostGIS with TiFeatures and TiMVT
Просмотров 1,1 тыс.Год назад
Simple and Fast OGC API Servers for PostGIS with TiFeatures and TiMVT
Building an Asset Inventory Database Using PostGIS: The Case of Giswater
Просмотров 757Год назад
Building an Asset Inventory Database Using PostGIS: The Case of Giswater
Kart: A Practical Tool for Versioning Geospatial Data
Просмотров 1,1 тыс.Год назад
Kart: A Practical Tool for Versioning Geospatial Data
Build Beautiful Isochrone Maps Using PostGIS and QGIS
Просмотров 1,4 тыс.Год назад
Build Beautiful Isochrone Maps Using PostGIS and QGIS

Комментарии

  • @amanvikram04
    @amanvikram04 Месяц назад

    Postgres is RDBMS

  • @xaviernogueira
    @xaviernogueira 2 месяца назад

    So sick, I jumped when I saw how few lines of SQL represented a much longer script in Python.

  • @gobajoseph5064
    @gobajoseph5064 3 месяца назад

    Super que pensez vous de supabase il facilite l'utilisation de postGis sans passer par les configurations de Postgresql

  • @BenFranklin-oc5ni
    @BenFranklin-oc5ni 3 месяца назад

    pretty awesome!

  • @abdoulayeleye5399
    @abdoulayeleye5399 3 месяца назад

    Amazing

  • @iamlauriano1962
    @iamlauriano1962 5 месяцев назад

    Is the site mandatory to use postgis, if not, should I use both banks?

  • @sashvosh
    @sashvosh 6 месяцев назад

    well did anyone ever write it in rust?

  • @israel-info
    @israel-info 7 месяцев назад

    Great talk, i wish i had the presentation...

  • @abdelhameedhamdy
    @abdelhameedhamdy 7 месяцев назад

    Awesome, according to the definition of a trajectory, we cannot add speed as M value, but what if we wanted to add timestamp + speed in M value, I think it is not applicable I guess.

  • @DylanYoung
    @DylanYoung 7 месяцев назад

    What's the benefit of hooking into notify rather than a logical subscription? In the latter case, you don't need triggers at all, right?

  • @DylanYoung
    @DylanYoung 7 месяцев назад

    Cool idea!

  • @elbertslonaker1874
    @elbertslonaker1874 8 месяцев назад

    Promo>SM 😏

  • @mandata143
    @mandata143 8 месяцев назад

    This is handy. I am currently working as GIS and I want to learn and upskill my skills relatively in GIS.

  • @sanatan_yogi_org
    @sanatan_yogi_org 8 месяцев назад

    Great Content. Keep up the good work

  • @JamesDavidSmith
    @JamesDavidSmith 8 месяцев назад

    How do we install the H3 extensions for PostGIS?

  • @zxtee
    @zxtee 8 месяцев назад

    quarter mil flag 😂

  • @albertodeluca4121
    @albertodeluca4121 8 месяцев назад

    This stuff is amazing. Thank you Martin!

  • @datamongerbonny
    @datamongerbonny 8 месяцев назад

    Carl Higgs! My neighbor is named Carl Hiatt and I misspoke!

  • @regix1964
    @regix1964 8 месяцев назад

    great talk

  • @pythonGIS
    @pythonGIS 8 месяцев назад

    Fantastic video! Thanks Matt!

  • @jerrittcollord
    @jerrittcollord 8 месяцев назад

    In the DuckDB FTS example, the note that results may not have the words "flash" or "flood" is misleading... it looks like the index was built on EPISODE_NARRATIVE but EVENT_NARRATIVE was retrieved and indeed may not contain "flash" or "flood".

  • @MagdogUnderbite
    @MagdogUnderbite 9 месяцев назад

    wow, unreal!

  • @mzezulka
    @mzezulka 9 месяцев назад

    Very insightful presentation, thank you!

  • @Escenda_0
    @Escenda_0 9 месяцев назад

    この動画はもっと評価されるべき。

  • @FerdausAlAmin
    @FerdausAlAmin 9 месяцев назад

    I am interested in this one..

  • @kevinsambuli6746
    @kevinsambuli6746 11 месяцев назад

    Very interesting presentation.. Am interested in learning more about how to manage different users in qgis projects and different access to datasets.. how can I achieve all this using all this open source tools

  • @waytop4916
    @waytop4916 11 месяцев назад

    ruclips.net/video/_dmH2jFdewo/видео.html, we offer dynamic vector tile solution. more tile format, more function

  • @waytop4916
    @waytop4916 11 месяцев назад

    ruclips.net/video/_dmH2jFdewo/видео.html, we offer dynamic vector tile solution. more tile format, more function

  • @kepasaugusius5595
    @kepasaugusius5595 Год назад

    I need some assistance of QGIS to develop a Geo-database.

  • @veraburak8049
    @veraburak8049 Год назад

    where all these we can copy?

  • @saurabhgupta6691
    @saurabhgupta6691 Год назад

    beautiful explaination, Can I use normal postgres update and insert query instead of pg_featureserv ?

  • @JV-pu8kx
    @JV-pu8kx Год назад

    Great video. Would like to know more about the PostgreSQL/PostGIS configuration, i.e. how you organized the databases/schemas and what roles were established and with what permissions they were given.

  • @mr_wormhole
    @mr_wormhole Год назад

    😂😂 biscuits and coffees lol

  • @TobyChampion
    @TobyChampion Год назад

    I came here to learn about using QGIS and PostgreSQL and this nailed it. Ms Kane is absolutely excellent at explaining things like this. I particularly liked the bit where she wanted people to understand that by PostGIS she's really talking about a PostgreSQL database with the PostGIS extension enabled. Also... the video capture the spirit of pandemic perfectly. The host is in a small, picture frames hung at random angles, and a healthy beard. Early technical issues help establish the tone. I love the random rectangle in the middle of the screen. And the coughs, sneezes, and seemingly non-diegetic laughter and other evidence that people are unmuted and just gettin' on with their lives makes it all the more real. I came for the content. Stayed for the coughs.

  • @ahmedismail1706
    @ahmedismail1706 Год назад

    Is there anyway to work with postgis data offline on qfield?

  • @jakajancar1767
    @jakajancar1767 Год назад

    Nice work and presentation, thank you!

  • @tauqeerahmad9516
    @tauqeerahmad9516 Год назад

    I tried the links and noting work. Pods are always stuck. Theni used openebs as storage class it works but finally I didn't manage install pho Clint and run the backups

  • @yehoriliushchenko4401
    @yehoriliushchenko4401 Год назад

    great presentation, thanks for the info!

  • @andrewz5981
    @andrewz5981 Год назад

    There was a very clear explanation of what STAC is, but I didn't really catch any explanation why STAC is more useful than any other metadata schema? It doesn't seem like there is any technological reason that searches would be more performant or efficacious with stac vs. ISO/FGDC or something bespoke?

  • @regix1964
    @regix1964 Год назад

    Great tutorial, thanks!

  • @christianshaw2892
    @christianshaw2892 Год назад

    You are my favorite content creator. Promote your social media with *Promo SM*!

  • @marieannabvl
    @marieannabvl Год назад

    Very impressive! Thank you for sharing!

  • @yuletide
    @yuletide Год назад

    legendary

  • @atlantroppus
    @atlantroppus Год назад

    "every thing I do is open source, I am not sure how this integrates with other platforms, like ..." I thought I was alone to do that! 😆I feel vindicated😛

  • @JacSteiner
    @JacSteiner Год назад

    This is such a good idea. Finally an OGC feature API implementation using modern tools and best practices.

  • @YoussefHarby
    @YoussefHarby Год назад

    Amazing 😍, thank you!

  • @Daagg
    @Daagg Год назад

    Nice talk and excellent job. I look forward to reading your new book.

  • @sonxuannguyen1207
    @sonxuannguyen1207 Год назад

    This video helps me solve the problem I’m facing at a fortune 500 company. Pls keep uploading more videos

  • @TechDevWizard
    @TechDevWizard Год назад

    share the download link of ghost town map db