RSS Parrot

Crunchy Data: Loading the World! OpenStreetMap Import In Under 4 Hours

https://www.crunchydata.com/blog/loading-the-world-openstreetmap-import-in-under-4-hours

Published: November 19, 2024 14:30

The OpenStreetMap (OSM) database builds almost 750GB of location data from a single file download. OSM notoriously takes a full day to run. A fresh open street map load involves both a massive write process and large index builds. It is a great performance…

PostGIS Development: PostGIS 3.5.0

https://postgis.net/2024/09/PostGIS-3.5.0/

Published: September 26, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.5.0! Best Served with PostgreSQL 17 RC1 and GEOS 3.13.0. This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+ is…

Crunchy Data: Vehicle Routing with PostGIS and Overture Data

https://www.crunchydata.com/blog/vehicle-routing-with-postgis-and-overture-data

Published: September 25, 2024 13:30

The Overture Maps collection of data is enormous, encompassing over 300 million transportation segments, 2.3 billion building footprints, 53 million points of interest, and a rich collection of cartographic features as well. It is a consistent global data…

PostGIS Development: PostGIS 3.5.0beta1

https://postgis.net/2024/09/PostGIS-3.5.0beta1/

Published: September 16, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.5.0beta1! Best Served with PostgreSQL 17 RC1 and GEOS 3.13.0. This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL 1.4+…

PostGIS Development: PostGIS 3.3.7

https://postgis.net/2024/09/PostGIS-3.3.7/

Published: September 5, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.4.7! This is a bug fix release. 3.3.7 source download md5 NEWS PDF docs: en

PostGIS Development: PostGIS 3.4.3

https://postgis.net/2024/09/PostGIS-3.4.3/

Published: September 4, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.4.3! This version requires PostgreSQL 12-17, GEOS 3.8+, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. To take advantage of all SFCGAL features, SFCGAL 1.5+ is needed. …

PostGIS Development: PostGIS 3.5.0alpha2

https://postgis.net/2024/07/PostGIS-3.5.0alpha2/

Published: July 6, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.5.0alpha2! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2. This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. SFCGAL…

PostGIS Development: PostGIS 3.5.0alpha1

https://postgis.net/2024/07/PostGIS-3.5.0alpha1/

Published: July 4, 2024 00:00

The PostGIS Team is pleased to release PostGIS 3.5.0alpha1! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2. This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. To take…

Crunchy Data: Converting DMS to PostGIS Point Geometry

https://www.crunchydata.com/blog/converting-dms-to-postgis-point-geometry

Published: May 23, 2024 17:00

I love taking random spatial data and turning it into maps. Any location data can be put into PostGIS in a matter of minutes. Often when I’m working with data that humans collected, like historic locations or things that have not yet traditionally been…

Crunchy Data: Inside PostGIS: Calculating Distance

https://www.crunchydata.com/blog/inside-postgis-calculating-distance

Published: March 19, 2024 13:00

Calculating distance is a core feature of a spatial database, and the central function in many analytical queries. "How many houses are within the evacuation radius?" "Which responder is closest to the call?" "How many more miles until the school bus…