- 137
- 220 957
Crunchy Data
United States
Приєднався 31 бер 2017
Crunchy Data allows companies to build with confidence as the leading provider of trusted open source PostgreSQL and enterprise technology, support and training. Crunchy Data offers Crunchy Certified PostgreSQL, the most advanced and true open source RDBMS on the market. The company also offers Crunchy Bridge, a fully managed cloud Postgres service available on AWS, Azure and Google Cloud. PostgreSQL's active development community, proven architecture, and reputation for reliability, data integrity, and ease of use makes it a prime candidate for enterprises looking for a robust relational database alternative to expensive proprietary database technologies. Learn more at www.crunchydata.com.
Data remix: AI-Driven insights with Postgres w/ Crunchy Data and Red Hat OpenShift AI
Your enterprise applications generate large amounts of data dispersed across multiple systems. From your internal documentation, content management systems, helpdesk systems, and others, there are data sets ready to be leveraged for AI.
Enterprises can find value in reusing and amplifying that data with AI tools using Postgres. There’s some great tools out there already to let you connect to AI engines while keeping and storing the vector data so you can build applications, insights, and more. We’ll review how to use your data to create vector data and how to query those embeddings to get insights for AI tools using Postgres.
If your data isn't in Postgres yet, don’t worry, we’ll show you how to use open-source tools to connect your systems. The best part is, this already fits into all of your Red Hat® enterprise systems at no extra cost. You’ll leave this webinar with the tools to remix your data sets and bring AI intelligence into your existing systems.
Karen Jex and Andrew Sheet presenting.
Enterprises can find value in reusing and amplifying that data with AI tools using Postgres. There’s some great tools out there already to let you connect to AI engines while keeping and storing the vector data so you can build applications, insights, and more. We’ll review how to use your data to create vector data and how to query those embeddings to get insights for AI tools using Postgres.
If your data isn't in Postgres yet, don’t worry, we’ll show you how to use open-source tools to connect your systems. The best part is, this already fits into all of your Red Hat® enterprise systems at no extra cost. You’ll leave this webinar with the tools to remix your data sets and bring AI intelligence into your existing systems.
Karen Jex and Andrew Sheet presenting.
Переглядів: 79
Відео
On the Road Again: Postgres Strategies for Fleet Analysis with Brian Loomis
Переглядів 1872 місяці тому
The Postgres ecosystem contains a number of extensions and tools to analyzing and reporting on data. Notably, CARB, the California Air Resources Board, provides PostGIS table data for reporting and verifying fleet compliance. We'll cover how we report to CARB, and how we use other Postgres features and techniques to make fleet reporting and alerting simple and effective.
Simplify, simplify, simplify! with Brian Timoney
Переглядів 7482 місяці тому
When 19th century American mystic Henry Thoreau exclaimed "Our life is frittered away by detail. Simplify, simplify, simplify! ", you better believe he was urging you to reconsider your 2024 web mapping stack. Since the dominant use case for your web maps continues to be "user does a screen capture and jams it into a PowerPoint" it is time to reconsider your approach. Let's give the people what...
The Early History of Spatial Databases and PostGIS with Paul Ramsey
Переглядів 8012 місяці тому
Paul wraps up PostGIS Day with the history of spatial data and maybe where we’re headed in the future.
You Got Your Vectors in My Vectors: Geospatial and AI vectors with Steven Pousty
Переглядів 2382 місяці тому
This talk will give you a quick introduction to what machine learning folks mean when they use the term "vectors". From there it will be a demo of combining pg_vector with PostGIS. We are going to do an image similarity search and constrain it by geography. Come see what all the hubbub is about with this new AI vector thing.
PostGIS to Facilitate Polygonal Map Integration Without Edge Matching with Yao Cui
Переглядів 1512 місяці тому
This presentation will explain a geospatial frame data (GFD) model to simplify the map compilation and data integration of polygonal features, using bedrock geology as an example. PostGIS facilitates the implementation of the GFD model in managing geospatial data at different stages of its lifecycle, including the separation of observations from map products, polygonal map integration without e...
Analyzing UFO Risk with PostGIS and H3 with Martin Davis
Переглядів 2452 місяці тому
This talk describes the H3 Global Grid index and how to use it with PostGIS via the h3-pg extension. H3 facilitates visualization and analysis via a powerful API. A case study of UFO sightings shows how it enables grid-based clustering, density mapping, and bivariate analysis. These are delivered to the web via pg_tileserv, pg_feauturesev and MapLibre to create a dashboard showing the risk of c...
Building a Modern Spatial Stack with PostGIS and Felt with Michal Migurski
Переглядів 2772 місяці тому
Discover how to supercharge your PostGIS workflows and create cutting-edge spatial applications with unprecedented speed and efficiency. Join us as we demonstrate how Felt's innovative tools seamlessly integrate with your existing PostGIS infrastructure, allowing you to build powerful spatial dashboards and applications in minutes.
Web maps from PostGIS with pg_featureserv and pg_tileserv with Elizabeth Christensen
Переглядів 2952 місяці тому
Pg_featureserv and pg_tileserv are lightweight Go applications for getting your spatial data into web apps. This will be an introductory talk on how to set up these tools, use the sample code, and build your own spatial web maps.
Making a Dynamic Street Map Index with ST SquareGrid with Joshua Carlson
Переглядів 1452 місяці тому
The request was simple: recreate an old street map for the City of Yorkville with an alphanumeric street index (A-1, B-2, etc). The challenge: can we do this without creating any new layers? Can we do it entirely with OpenStreetMap Data from our PostGIS database? Of course! In this talk, we'll go through the query we wrote up to handle the situation.
FastCollection: A PostGIS API Built for Interacting with Geospatial Data with Michael Keller
Переглядів 1752 місяці тому
This talk will cover the open source FastCollections API which allows you to view/query/update geo-spatial data within a PostgreSQL database. FastCollections contains over 20 different endpoints which allows a consumer to view collections as geojson or vector tiles, perform statistical analysis, and download data in multiple formats for consumption within other tools. FastCollection is also OGC...
Geospatial Analytics with GeoParquet with Rekha Khandhadia
Переглядів 2112 місяці тому
Geoparquet and parquet files in cloud object stores like s3 now house huge lakes of data. I'll go over Geoparquet from the ground up covering what it is, how it is different from Parquet, and how analysis is being done at scale on Geoparquet. We'll also briefly cover Crunchy Bridge for Analytics, a query engine that fuses Postgres and DuckDB for fast, vectorized analytics.
PostGIS Surprise, the Sequel with Regina Obe
Переглядів 1652 місяці тому
In PostGIS Day 2023, PostGIS and friends demonstrated how to broadcast critical messages using a custom built imagery alphabet among other tidbits of spatial magic. What more can this cast of characters do? Come watch and leave awestruck.
On the Road Again: Postgres Strategies for Fleet Analysis with Brian Loomis
Переглядів 652 місяці тому
The Postgres ecosystem contains a number of extensions and tools to analyzing and reporting on data. Notably, CARB, the California Air Resources Board, provides PostGIS table data for reporting and verifying fleet compliance. We'll cover how we report to CARB, and how we use other Postgres features and techniques to make fleet reporting and alerting simple and effective.
Getting Started With Overture Maps with Dana Bauer and Jake Wasserman
Переглядів 2212 місяці тому
Overture Maps offers free and open global map data, continuously updated and released monthly as GeoParquet files. In this session, we'll give an overview of Overture's schema and six data themes: addresses, base, buildings, divisions, places, and transportation. We'll also share examples and workflows that are particularly relevant to the PostGIS community.
Custom Routing Solutions with PostGIS with Dennis Boachie Boateng
Переглядів 1292 місяці тому
Custom Routing Solutions with PostGIS with Dennis Boachie Boateng
Multi Entry Generalized Search Trees with Maxime Schoemans
Переглядів 1112 місяці тому
Multi Entry Generalized Search Trees with Maxime Schoemans
Simplify Space Relations like Country State Divisions with Postgis Topology with Felipe Matas
Переглядів 1812 місяці тому
Simplify Space Relations like Country State Divisions with Postgis Topology with Felipe Matas
SFCGAL and PostGIS: Integration, Use Cases, and Future with Loïc Bartoletti
Переглядів 1252 місяці тому
SFCGAL and PostGIS: Integration, Use Cases, and Future with Loïc Bartoletti
Writing the SQL: Revising the Framework of Cities with Bonny P McClain
Переглядів 1632 місяці тому
Writing the SQL: Revising the Framework of Cities with Bonny P McClain
PostGIS and Go: A Match Made in Large Z Values with Tom Payne
Переглядів 1172 місяці тому
PostGIS and Go: A Match Made in Large Z Values with Tom Payne
How to Connect PostGIS to ArcGIS with Pekka Sarkola
Переглядів 2202 місяці тому
How to Connect PostGIS to ArcGIS with Pekka Sarkola
FOSS4G Adoption in Danish Municipalities with Kurt Menke
Переглядів 1642 місяці тому
FOSS4G Adoption in Danish Municipalities with Kurt Menke
pgRouting and Beyond: Survey of pgRouting and Other Open Source Routing Tools with Ibrahim Saricicek
Переглядів 5802 місяці тому
pgRouting and Beyond: Survey of pgRouting and Other Open Source Routing Tools with Ibrahim Saricicek
Run Postgres Anywhere with Crunchy Data and Red Hat
Переглядів 2427 місяців тому
Run Postgres Anywhere with Crunchy Data and Red Hat
Discover the power of the Postgres-anywhere data stack with Crunchy Data and Red Hat
Переглядів 987 місяців тому
Discover the power of the Postgres-anywhere data stack with Crunchy Data and Red Hat
Using PostgREST to create PostGIS Functions Fast
Переглядів 2,4 тис.Рік тому
Using PostgREST to create PostGIS Functions Fast
can anyone explain why my browser in QGIS does not have PostGIS and only has PostgreSQL ?
I am trying to import and work with openstreetmap world. Not even the whole data, but a subset. It's easy to do a country but extremely challenging to do the world.
Who's the "fountain of wisdom"? Brian Freaking Timoney, that's what I say!
Wonderful ❤.
Wow this is awesome!
Cool I love this❤
Superb talk 👏
Interesting talk
Thanks for sharing such valuable information! Could you help me with something unrelated: My OKX wallet holds some USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How should I go about transferring them to Binance?
great talk, I learned a lot
👽👽🛸🛸
how Can Do Road Modeling
wonderful tutorial. this is a life saver. Thanks Ms Kane
This is absolutely awesome, thanks
The example of France made me want to add: always convert multi-parts to single-parts first.
Thanks for the video! How do you do validations for the different fields like a password having special characters, or emails, or phone numbers, etc...? I tried to look at the doc but I can't find it. For PostgREST should we do it by using triggers or constraints or domain constraints? Or can it understand all and return well-formed errors?
So I got my answer from the author. We need to leverage Postgres functions. It talks about it in a different section of the documentation. For use cases like this or transactions or any complex business logic we can write it in a Postgres function. Each function is made accessible by PostREST at the path POST /rpc/[functionName]... Also functions can be coded in plsql but also in JS with an extension. Check out v8 JS extension for Postgres. Check out also Graphile Worker. It’s a high performance job queue for Postgres. I have to say all this makes this project very interesting. And I learned a lot like roles, security definer, or row-level security. Def worth to at least diving into it.
Postgres is RDBMS
So sick, I jumped when I saw how few lines of SQL represented a much longer script in Python.
Super que pensez vous de supabase il facilite l'utilisation de postGis sans passer par les configurations de Postgresql
pretty awesome!
Amazing
Is the site mandatory to use postgis, if not, should I use both banks?
well did anyone ever write it in rust?
Great talk, i wish i had the presentation...
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.
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?
Cool idea!
Promo>SM 😏
This is handy. I am currently working as GIS and I want to learn and upskill my skills relatively in GIS.
Your experience so far?
Great Content. Keep up the good work
How do we install the H3 extensions for PostGIS?
quarter mil flag 😂
The audacity!
This stuff is amazing. Thank you Martin!
Carl Higgs! My neighbor is named Carl Hiatt and I misspoke!
great talk
Fantastic video! Thanks Matt!
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".
wow, unreal!
Very insightful presentation, thank you!
この動画はもっと評価されるべき。
I am interested in this one..
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
I guess you are talking about a multi-user system, which makes it sort of an enterprise system. One way to think about it is setting user access at the database level. With that all setup, your users can use the credentials from the client side of things. Reach out if you would like to chat more.
ua-cam.com/video/_dmH2jFdewo/v-deo.html, we offer dynamic vector tile solution. more tile format, more function
ua-cam.com/video/_dmH2jFdewo/v-deo.html, we offer dynamic vector tile solution. more tile format, more function
I need some assistance of QGIS to develop a Geo-database.
where all these we can copy?
beautiful explaination, Can I use normal postgres update and insert query instead of pg_featureserv ?
Yes.
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.
😂😂 biscuits and coffees lol