Crunchy Data Warehouse
Accelerate Your Spatial Analytics
Crunchy Data Warehouse extends the power and familiarity of PostGIS with an optimized hybrid query engine to connect you to remote data stores of GeoParquet, Shapefiles, GeoJSON, and more.
Query the biggest spatial datasets on earth
Run quick summaries and rollups against large public or private datasets with ease.
Bring large spatial data sets into PostGIS
Import data with a simple URL and run the full range of PostGIS functions in moments.
Cost Efficient Spatial Data Management
Store, query, and analyze geospatial data at scale while benefiting from cost effect object storage such as S3.
Connect any geospatial data set to Postgres & PostGIS
Crunchy Data Warehouse empowers you to use PostGIS with a wide range of cloud native spatial data formats directly without the need to import them into local storage. Analyze and visualize GeoParquet, GeoJSON, KML, Shapefiles, and GeoPackages, all while keeping your data in its native environment. We automatically map columns and data types from a variety of source formats directly to your Postgres and PostGIS environment without manual intervention.
- - Public datasets in S3 or https url
- - Private datasets in S3
GeoParquet
Efficiently query GeoParquet files stored in S3 or other cloud storage, taking advantage of its columnar data structure for high-performance analytics on large datasets.
GeoJSON
Access and analyze GeoJSON files remotely, leveraging the flexibility of this lightweight format for web-based mapping and location-based services.
Shapefile
Perform queries on zipped shapefiles stored remotely, reducing data transfer overhead and enabling fast access to one of the most common geospatial formats used in GIS applications worldwide.
KML
Work with KML files directly from your remote storage locations, enabling easy integration with Google Earth and other GIS tools while maintaining full analytical capabilities.
GeoPackage
Utilize the rich feature set of GeoPackage files, a modern, open standard for geospatial information, directly from remote storage, combining the power of SQLite databases with the versatility of PostGIS for complex spatial queries.
CSV
Analyze spatial data stored in CSV files, including those with coordinate columns, directly from remote storage. This allows for easy integration of tabular data with geospatial coordinates into your PostGIS environment.
Simple and fast spatial analytics at your fingertips
Access a data store
Getting started is as easy as copying a URL or S3 location. no need No need for complicated data loading or ingest pipelines
Create tables
Create foreign tables to query data. Create local tables and views to work with data in PostGIS directly.
Build your projects
Import your data, create maps directly in QGIS, or run summary statistics on big spatial data.
PostGIS integrated with DuckDB
Hybrid Query Engine
By deeply integrating DuckDB into PostgreSQL, we delegate PostGIS functions and operators to DuckDB spatial where possible for fast queries on GeoParquet.
Simplified Data Management
Easily transfer data between S3 and Postgres / PostGIS Postgres, all without the need for complex ETL processes.
Capture analytics and data from Overture
Query Overture Directly
Crunchy Data Warehouse provides direct access to the Overture maps dataset, allowing you to execute complex queries and perform in-depth analyses on up-to-date, high-quality geospatial data. You can extract actionable data from Overture, enhancing your spatial applications without the need for cumbersome data transfers or manual processing.
Import from Overture
Integrate Overture data into PostGIS with an easy and efficient data import. Work with Overture data in PostGIS and leverage the powerful spatial functions, indexing capabilities, complex geospatial queries, and analysis. Effortlessly connect it to QGIS for advanced visualization and mapping.
Big Spatial Data Doesn't Have to be Complicated
Crunchy Data Warehouse offers a spatial analytics solution that significantly simplifies the process compared to traditional solutions. Unlike other platforms that require cumbersome data migration, complex setup procedures, and extensive manual configuration, Crunchy Data Warehouse provides a seamless, integrated experience for geospatial analytics. Our solution allows for direct querying of diverse spatial formats from remote storage, eliminating the need for tedious data imports and transformations.
