A couple months ago I built Hazard Viewer, an app that uses federal data and @claudeai to generate a natural hazards risk assessment. It's my first AI app, it uses @postgis and @maplibre, it runs on @render, it was fun to make, check it out! hazardviewer-frontend.onrender.com
PostGIS
PostGIS ( POST-jis) is an open source software program that adds support for geographic objects to the PostgreSQL object-relational database. PostGIS follows the Simple Features for SQL specification from the Open Geospatial Consortium (OGC). More on Wikipedia
-
PostGIS reposted
Lyzi Diamond
@lyzidiamond
-
PostGIS reposted
Postgres FM
@PostgresFM
New episode: "PostGIS"
@samokhvalov and @michristofides are joined by @reginaobe and @pwramsey to discuss @PostGIS
🎧 postgres.fm/episodes/postgis
📺 youtu.be/JDULwjz1hDY -
PostGIS reposted
Artlembo
@artlembo
Only a couple more Classic ARC/INFO functions in @postgis to go. Today's post is multi-ring buffers.
www.artlembo.com/post/classic-arc-info-commands-in-postgi… -
PostGIS reposted
Artlembo
@artlembo
We're starting to get into the topological functions in ARC/INFO using SQL in @postgis. Today's post is explaining the spatial SQL for Symmetrical Difference:
www.artlembo.com/post/classic-arc-info-commands-in-postgi… -
PostGIS
@postgis
The call for papers for pgconf.dev is open, but not for long! Submit your abstracts soon! 2026.pgconf.dev/cfp
-
PostGIS reposted
Artlembo
@artlembo
with the holidays coming, I just added a new post in my series on Classic ARC/INFO commands in @PostGIS: this one is K-nearest neighbors. The next posts will include classic @esri topological overlay commands in SQL.
www.artlembo.com/post/classic-arc-info-commands-in-postgi… -
PostGIS
@postgis
Happy PostGIS Day Eve (or "GIS Day", to some) for all who celebrate it. www.snowflake.com/postgis-day-2025/
-
PostGIS reposted
sabman
@sabman
Speaking about embeddings and geo this @postgis day! signup! www.snowflake.com/postgis-day-2025/ #gischat
-
PostGIS
@postgis
PostGIS Day 2025 is almost here! Next week, November 20 (that's the day after GIS Day), over 20 talks about our favourite spatial database. Sign up now, there's a finite number of webinar slots and an infinite about of interest! www.snowflake.com/postgis-day-2025/
Post not available here, view on X
PostGIS
@postgis
We have a talk about using Apache Sedona and PostGIS together! Chocolate and peanut butter!
PostGIS
@postgis
Do we have talks about AI and geo? Duh! We have two!
-
PostGIS
@postgis
PostGIS 3.5.0rc1 postgis.net/2024/09/PostGIS-3.5.0rc1/
-
PostGIS
@postgis
PostGIS meets DuckDB: Crunchy Bridge for Analytics goes Spatial www.crunchydata.com/blog/postgis-meets-duckdb-crunchy-bri…
-
PostGIS
@postgis
PostGIS 3.5.0beta1 postgis.net/2024/09/PostGIS-3.5.0beta1/
-
PostGIS
@postgis
PostGIS 3.3.7 postgis.net/2024/09/PostGIS-3.3.7/
-
PostGIS
@postgis
PostGIS 3.4.3 postgis.net/2024/09/PostGIS-3.4.3/
-
PostGIS
@postgis
PostGIS 3.5.0alpha2 postgis.net/2024/07/PostGIS-3.5.0alpha2/
-
PostGIS
@postgis
PostGIS 3.5.0alpha1 postgis.net/2024/07/PostGIS-3.5.0alpha1/
-
PostGIS
@postgis
Converting DMS to PostGIS Point Geometry www.crunchydata.com/blog/converting-dms-to-postgis-point-…
-
PostGIS
@postgis
Inside PostGIS: Calculating Distance www.crunchydata.com/blog/inside-postgis-calculating-distance
-
PostGIS
@postgis
Connecting QGIS to Postgres and PostGIS www.crunchydata.com/blog/connecting-qgis-to-postgres-and-…
-
PostGIS
@postgis
PostGIS Clustering with K-Means www.crunchydata.com/blog/postgis-clustering-with-k-means
-
PostGIS
@postgis
PostGIS Patch Releases postgis.net/2024/02/PostGIS-Patch-Releases/
-
PostGIS
@postgis
Building the pgconf.dev Programme blog.cleverelephant.ca/2024/02/pgconf-program.html
-
PostGIS
@postgis
JSON and SVG from PostGIS into Google Sheets www.crunchydata.com/blog/json-and-svg-from-postgis-into-g…
-
PostGIS
@postgis
PostGIS Clustering with DBSCAN www.crunchydata.com/blog/postgis-clustering-with-dbscan
-
PostGIS
@postgis
PostGIS Day 2023 Summary www.crunchydata.com/blog/postgis-day-2023-summary
-
PostGIS
@postgis
Random Geometry Generation with PostGIS www.crunchydata.com/blog/random-geometry-generation-with-…
-
PostGIS
@postgis
SVG Images from Postgres www.crunchydata.com/blog/svg-images-from-postgis
-
PostGIS
@postgis
JSON and SVG from PostGIS into Google Sheets www.crunchydata.com/blog/json-and-svg-from-postgis-into-g…
-
PostGIS
@postgis
pgconf.dev @ Vancouver, May 28-31 blog.cleverelephant.ca/2024/01/pgconf-dev.html
-
PostGIS
@postgis
Data Science is Getting Ducky blog.cleverelephant.ca/2023/12/duck.html
-
PostGIS
@postgis
PostGIS Clustering with DBSCAN www.crunchydata.com/blog/postgis-clustering-with-dbscan
-
PostGIS
@postgis
Keynote @ FOSS4G NA 2023 blog.cleverelephant.ca/2023/12/foss4g-keynote-2023.html
-
PostGIS
@postgis
PostGIS Day 2023 Summary www.bostongis.com/blog/index.php?%2Farchives%2F283-PostGI…
-
PostGIS
@postgis
PostGIS Day 2023 Summary www.crunchydata.com/blog/postgis-day-2023-summary
-
PostGIS
@postgis
PostGIS Patch Releases postgis.net/2023/11/PostGIS-Patch-Releases/
-
PostGIS
@postgis
Random Geometry Generation with PostGIS www.crunchydata.com/blog/random-geometry-generation-with-…
-
PostGIS
@postgis
Why People care about PostGIS and Postgres and FOSS4GNA www.bostongis.com/blog/index.php?%2Farchives%2F282-Why-Pe…
-
PostGIS
@postgis
PostGIS 3.4.0 postgis.net/2023/08/PostGIS-3.4.0/
-
PostGIS
@postgis
PostGIS 3.4.0rc1 postgis.net/2023/08/PostGIS-3.4.0rc1/
-
PostGIS
@postgis
PostGIS 3.4.0beta2 postgis.net/2023/07/PostGIS-3.4.0beta2/
-
PostGIS
@postgis
PostGIS 3.3.4 Patch Release postgis.net/2023/07/PostGIS-3.3.4-Patch-Release/
-
PostGIS
@postgis
PostGIS 3.4.0beta1 postgis.net/2023/07/PostGIS-3.4.0beta1/
-
PostGIS
@postgis
MapScaping Podcast: Pg_EventServ blog.cleverelephant.ca/2023/07/mapscaping-pgeventserv.html
-
PostGIS
@postgis
PostGIS Bundle 3.3.3 for Windows with MobilityDB www.bostongis.com/blog/index.php?%2Farchives%2F281-PostGI…
-
PostGIS
@postgis
SVG Images from Postgres www.crunchydata.com/blog/svg-images-from-postgis
-
PostGIS
@postgis
PostGIS 3.3.3, 3.2.5, 3.1.9, 3.0.9 Patch Releases postgis.net/2023/05/PostGIS-3.3.3-3.2.5-3.1.9-3.0.9-Patch…
-
PostGIS
@postgis
Keynote @ CUGOS Spring Fling blog.cleverelephant.ca/2023/05/cugos.html
-
PostGIS
@postgis
PostGIS 3.3.2, 3.2.4, 3.1.8, 3.0.8 Patch Releases postgis.net/2022/11/PostGIS-3.3.2-3.2.4-3.1.8-3.0.8-Patch…
-
PostGIS
@postgis
PostGIS 2.5.9 EOL postgis.net/2022/11/PostGIS-2.5.9-EOL/
-
PostGIS
@postgis
PostGIS 3.3.1 postgis.net/2022/09/PostGIS-3.3.1/
-
PostGIS
@postgis
PostGIS 3.3.0 Released postgis.net/2022/08/PostGIS-3.3.0-Released/
-
PostGIS
@postgis
PostGIS 3.3.0rc2 postgis.net/2022/08/PostGIS-3.3.0rc2/
-
PostGIS
@postgis
PostGIS 3.2.3, 3.1.7, 3.0.7, 2.5.8 Released postgis.net/2022/08/PostGIS-3.2.3-3.1.7-3.0.7-2.5.8-Relea…
-
PostGIS
@postgis
PostGIS 3.3.0rc1 postgis.net/2022/08/PostGIS-3.3.0rc1/
-
PostGIS
@postgis
PostGIS 3.2.2 postgis.net/2022/07/PostGIS-3.2.2/
-
PostGIS
@postgis
PostGIS 3.1.6 postgis.net/2022/07/PostGIS-3.1.6/
-
PostGIS
@postgis
PostGIS 3.0.6 postgis.net/2022/07/PostGIS-3.0.6/
-
PostGIS
@postgis
MapScaping Podcast: Rasters and PostGIS blog.cleverelephant.ca/2023/05/mapscaping-pgraster.html
-
PostGIS
@postgis
PostGIS 3.3.2, 3.2.4, 3.1.8, 3.0.8 Patch Releases postgis.net/news/2022/11-13_postgis-patches/
-
PostGIS
@postgis
PostGIS 2.5.9 EOL postgis.net/news/2022/11-12_postgis-2.5.9/
-
PostGIS
@postgis
PostGIS 3.3.1 postgis.net/news/2022/09-10_postgis-3.3.1/
-
PostGIS
@postgis
PostGIS 3.3.0 Released postgis.net/news/2022/08-27_postgis-3.3.0/
-
PostGIS
@postgis
PostGIS 3.3.0rc2 postgis.net/news/2022/08-22_postgis-3.3.0rc2/
-
PostGIS
@postgis
PostGIS 3.2.3, 3.1.7, 3.0.7, 2.5.8 Released postgis.net/news/2022/postgis-patches/
-
PostGIS
@postgis
PostGIS 3.3.0rc1 postgis.net/news/2022/08-08_postgis-3.3.0rc1/
-
PostGIS
@postgis
PostGIS 3.2.2 postgis.net/news/2022/07-23_postgis-3.2.2/
-
PostGIS
@postgis
PostGIS 3.1.6 postgis.net/news/2022/07-20_postgis-3.1.6/
-
PostGIS
@postgis
PostGIS 3.0.6 postgis.net/news/2022/07-20_postgis-3.0.6/
-
PostGIS reposted
FOSS4G 2024 | https://fosstodon.org/@foss4g
@foss4g
📢 Registration for #foss4g2023 is now open!
📆 Early bird is available until April 15th, 2023.
2023.foss4g.org/register/ or direct to event.2023.foss4g.org/foss4g2023/
We look forward to seeing you at #foss4g 2023! 🎉
#osgeo @OSGeo -
PostGIS reposted
DBeaver
@dbeaver_news
In DBeaver, you can change the coordinate system using this drop-down list:
-
PostGIS
@postgis
Geocoding with Web APIs in Postgres www.crunchydata.com/blog/geocoding-with-web-apis-in-postgres
-
PostGIS
@postgis
Postgres Raster Query Basics www.crunchydata.com/blog/postgres-raster-query-basics
-
PostGIS
@postgis
Temporal Filtering in pg_featureserv with CQL www.crunchydata.com/blog/temporal-filtering-pgfeatureserv…
-
PostGIS
@postgis
Fun with Letters in PostGIS 3.3! www.crunchydata.com/blog/fun-with-letters-in-postgis-33
-
PostGIS
@postgis
Timezone Transformation Using Location Data & PostGIS www.crunchydata.com/blog/timezone-transformation-using-lo…
-
PostGIS
@postgis
PostGIS Day 2022 www.crunchydata.com/blog/postgis-day-2022
-
PostGIS
@postgis
Moving Objects and Geofencing with Postgres & PostGIS www.crunchydata.com/blog/moving-objects-and-geofencing-wi…
-
PostGIS
@postgis
Rise of the Anti-Join www.crunchydata.com/blog/rise-of-the-anti-join
-
PostGIS
@postgis
Postgres Indexes, Selectivity, and Statistics www.crunchydata.com/blog/indexes-selectivity-and-statistics
-
PostGIS
@postgis
Instant Heatmap with pg_featureserv www.crunchydata.com/blog/instant-heatmap-with-pg_featureserv
-
PostGIS
@postgis
PostGIS For Newbies www.crunchydata.com/blog/postgis-for-newbies
-
PostGIS
@postgis
Fixing a broken postgis raster install postgis.net/2023/02/03/tip-removing-raster-from-2-3/
-
PostGIS
@postgis
When Proj Grid-Shifts Disappear blog.cleverelephant.ca/2023/02/proj-network.html
-
PostGIS reposted
Crunchy Data
@crunchydata
Fun with Letters in PostGIS 3.3!
www.crunchydata.com/blog/fun-with-letters-in-postgis-33 -
PostGIS
@postgis
PostGIS Day 2022 Videos are out and some more highlights www.bostongis.com/blog/index.php?%2Farchives%2F280-PostGI…
-
PostGIS reposted
Dan Langille @dvl@bsd.network
@DLangille
The CFP for both @BSDCan & @PGCon are scheduled to be released today.
They are going to be late. Sorry. -
PostGIS
@postgis
Post GIS Day 2022 Celebrations www.bostongis.com/blog/index.php?%2Farchives%2F279-Post-G…
-
PostGIS
@postgis
Last three talks for PostGIS Day:
Making Production Vector Tiles Simple with db2vector
Brendan Farrell, Clockwork Micro
Building Dynamic Data Flows with Koop and PostGIS
Dan O'Neill
Web Sockets and Real-Time Updates for Postgres with pg_eventserv
Paul Ramsey, Crunchy Data
PostGIS
@postgis
Waking up in JP/AU/NZ/IN?
info.crunchydata.com/postgis-day-2022 -
PostGIS
@postgis
It's telecom hour at PostGIS Day!
info.crunchydata.com/postgis-day-2022Post not available here, view on X
PostGIS
@postgis
PgSTAC!
PostGIS
@postgis
I've got a good feeling about this...
-
PostGIS
@postgis
If you're not at PostGIS day right now, you're missing
"A Tour of the PostGIS Extended Family of Extensions
Regina Obe, Paragon Corporation"
!!!!!
info.crunchydata.com/postgis-day-2022 -
PostGIS
@postgis
The PostGIS Day don't stop... still 8 hours of talks to come! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
Holy noodle, it's the big day! Quick sign-up! info.crunchydata.com/postgis-day-2022
-
PostGIS reposted
Crunchy Data
@crunchydata
Tomorrow Nov 17, we'll be kicking off PostGIS Day at 8am ET! It's not too late to register and join us for this virtual event filled with talks about the uses of the PostGIS spatial database as a part of the GIS ecosystem.
info.crunchydata.com/postgis-day-2022 -
PostGIS
@postgis
I am once again asking you to sign up for @PostGIS Day (Thursday!) in advance to help in planning! It's Thursday! Check out the agenda! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
PostGIS 3.3.2, 3.2.4, 3.1.8, 3.0.8 Patch Releases postgis.net/2022/11/13/postgis-3.3.2-3.2.4-3.1.8-3.0.8-pa…
-
PostGIS
@postgis
PostGIS 2.5.9 EOL postgis.net/2022/11/12/postgis-2.5.9-eol/
-
PostGIS reposted
Crunchy Data
@crunchydata
Our full schedule for PostGIS day has been published. Register today and join us for free. Virtual drop in format and packed with awesome #postgis talks! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
Using pg_upgrade to upgrade PostgreSQL 9.6 PostGIS 2.4 to PostgreSQL 15 3.3 on Yum www.bostongis.com/blog/index.php?%2Farchives%2F278-Using-…
-
PostGIS
@postgis
Relational Properties of DE-9IM spatial predicates lin-ear-th-inking.blogspot.com/2022/10/relational-propert…
-
PostGIS reposted
PostGIS
@postgis
Eeep! @postgis day call-for-papers closes on Friday! Have you send in your talk? We reeeeeeeally want to see it! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
Eeep! @postgis day call-for-papers closes on Friday! Have you send in your talk? We reeeeeeeally want to see it! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
Learning PostgreSQL Internals blog.cleverelephant.ca/2022/10/postgresql-links.html
-
PostGIS
@postgis
Detecting close encounters using MobilityDB 1.0 anitagraser.com/2022/09/30/detecting-close-encounters-usi…
-
PostGIS reposted
Crunchy Data
@crunchydata
Don't forget to submit your talk for PostGIS Day 2022! Call for papers is open now through Oct. 7. info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
PostGIS Day call-for-papers closes this week! Please, pretty please, bring your tale of PostGIS-fu to the community, we really want to hear your stories! info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
Olivier Courtin Farewell postgis.net/2021/12/17/olivier-courtin/
-
PostGIS
@postgis
PostGIS 3.3.1 postgis.net/2022/09/10/postgis-3.3.1/
-
PostGIS reposted
@rjhale1971@fosstodon.org
@rjhale
It's on: FOSS4G Nashville. Show up and present something cool on FOSS4G: Cost $25. Probably 3 days of fun. At least 2 days of fun. Wiki: wiki.osgeo.org/wiki/20221201-Nashville-foss4g #foss4g #qgis #postgis #geoserver #gdal
-
PostGIS reposted
Crunchy Data
@crunchydata
📣Calling all of our #geospatial #postgis friends - PostGIS Day registration and call for papers is now open! 🎉 info.crunchydata.com/postgis-day-2022
-
PostGIS
@postgis
PostGIS 3.3.0 Released postgis.net/2022/08/27/postgis-3.3.0-released/
-
PostGIS
@postgis
Upgrading postgis_sfcgal to 3.1 or higher postgis.net/2022/08/25/tip-upgrading-postgis-sfcgal/
-
PostGIS
@postgis
And the heavens opened, and the angels sang. www.esri.com/arcgis-blog/products/arcgis-pro/data-managem…
-
PostGIS
@postgis
PostGIS 3.3.0rc2 postgis.net/2022/08/22/postgis-3.3.0rc2/
-
PostGIS
@postgis
Do you use PostGIS topology? If you do, please take this (short, short) survey! www.survey-xact.no/LinkCollector?key=91DSHGYXSP9P
-
PostGIS
@postgis
PostGIS 3.2.3, 3.1.7, 3.0.7, 2.5.8 Released postgis.net/2022/08/18/postgis-patches/
-
PostGIS
@postgis
I’m all the GIS you need. 😍
-
PostGIS
@postgis
PostGIS 3.3.0rc1 postgis.net/2022/08/08/postgis-3.3.0rc1/
-
PostGIS
@postgis
PostGIS 3.2.2 postgis.net/2022/07/23/postgis-3.2.2/
-
PostGIS
@postgis
PostGIS 3.1.6 postgis.net/2022/07/20/postgis-3.1.6/
-
PostGIS
@postgis
PostGIS 3.0.6 postgis.net/2022/07/20/postgis-3.0.6/
-
PostGIS
@postgis
PostGIS 2.5.7 postgis.net/2022/07/19/postgis-2.5.7/
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
. @postgis 3.2, 3.1 and 3.0 also landed RHEL 9. Please note that this is the community repository at:
yum.postgresql.org
#postgresql #rhel #gis -
PostGIS
@postgis
PostGIS 3.3.0beta2 postgis.net/2022/07/13/postgis-3.3.0beta2/
-
PostGIS
@postgis
"Optimizing Wind Farm Road Networks with Routing", serious GIS with @postgis
gis-ops.com/nordex-energy-case-study/ -
PostGIS
@postgis
PostGIS 3.3.0beta1 postgis.net/2022/07/03/postgis-3.3.0beta1/
-
PostGIS
@postgis
GEOS 3.11.0 released! libgeos.org/posts/2022-07-01-geos-3-11-0-released/
-
PostGIS reposted
Claire Giordano ✨
@clairegiordano
The State of Postgres 2022 survey is OPEN thanks to ppl @TimescaleDB like @acoustik & @ryanbooz
It CLOSES SOON @ 11:59pm PDT on Thu June 30
⏰If you use + love @citusdata be sure to take the survey, there is a Q about 3 favorite #postgresql extensions! timescale.typeform.com/state-of-pg-22 -
PostGIS
@postgis
Technology, Magic & PostgreSQL blog.cleverelephant.ca/2022/06/postgresql-magic.html
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Postgres Indexes, Selectivity, and Statistics postgr.es/p/5my
-
PostGIS
@postgis
Some More PostGIS Users blog.cleverelephant.ca/2022/06/postgis-logos-3.html
-
PostGIS reposted
daryl herzmann
@akrherz
I admitted to it in 2003 :) lists.osgeo.org/pipermail/postgis-users/2003-February/002…
-
PostGIS
@postgis
Some PostGIS Users blog.cleverelephant.ca/2022/06/postgis-logos-2.html
-
PostGIS
@postgis
Who are the Biggest PostGIS Users? blog.cleverelephant.ca/2022/06/postgis-logos.html
-
PostGIS
@postgis
Some PostGIS Users blog.cleverelephant.ca/2022/04/postgis-logos-2.html
-
PostGIS reposted
Toni Carneros
@tonicarneros
Aquest juliol, nova edició del curs de #postgis!
Si t'interessa:
- aprendre #sql
- consultar i gestionar una #basededades
- gestionar informació geogràfica des d'una base de dades com si fos un #sig
Inscriu-te ja!: forms.gle/zY1TQaTVPDvFjLyR9
Més informació: toni.carneros@ub.edu -
PostGIS
@postgis
Who are the Biggest PostGIS Users? blog.cleverelephant.ca/2022/04/postgis-logos.html
-
PostGIS
@postgis
Who are the Biggest PostGIS Users? by @pwramsey
blog.cleverelephant.ca/2022/04/postgis-logos.html -
PostGIS
@postgis
New GEOS patch releases! 3.7.4, 3.8.3, 3.9.3, 3.10.3 ... update, update, update! libgeos.org/posts/2022-06-03-geos-3-10-3-released/ #borkborkbork
-
PostGIS
@postgis
Algorithm for Concave Hull of Polygons lin-ear-th-inking.blogspot.com/2022/05/algorithm-for-conc…
-
PostGIS
@postgis
PostGIS 3.3.0alpha1 postgis.net/2022/05/21/postgis-3.3.0alpha1/
-
PostGIS
@postgis
Inscribed and bounding circles in PostGIS anitagraser.com/2022/05/03/inscribed-and-bounding-circles…
-
PostGIS
@postgis
PostGIS For Newbies blog.crunchydata.com/blog/postgis-for-newbies
-
PostGIS
@postgis
Spatial Filters in pg_featureserv with CQL blog.crunchydata.com/blog/spatial-filters-in-pg_featurese…
-
PostGIS
@postgis
PostGIS vs GPU: Performance and Spatial Joins blog.crunchydata.com/blog/performance-and-spatial-joins
-
PostGIS
@postgis
CQL Filtering in pg_featureserv blog.crunchydata.com/blog/cql-filtering-in-pg_featureserv
-
PostGIS
@postgis
Elevation Profiles and Flightlines with PostGIS blog.crunchydata.com/blog/elevation-profiles-and-flightli…
-
PostGIS
@postgis
PostGIS 3.2 New and Improved blog.crunchydata.com/blog/postgis-3.2-new-and-improved
-
PostGIS
@postgis
Tricks for Faster Spatial Indexes blog.crunchydata.com/blog/tricks-for-faster-spatial-indexes
-
PostGIS
@postgis
PostGIS Day 2021 blog.crunchydata.com/blog/postgis-day-2021
-
PostGIS
@postgis
Querying Spatial Data with PostGIS and ogr_fdw blog.crunchydata.com/blog/querying-spatial-data-with-post…
-
PostGIS
@postgis
Waiting for PostGIS 3.2: Secure Cloud Raster Access www.crunchydata.com/blog/waiting-for-postgis-3.2-secure-c…
-
PostGIS
@postgis
PostGIS 2.4.10 postgis.net/2022/04/24/postgis-2.4.10/
-
PostGIS
@postgis
PostGIS 2.5.6 postgis.net/2022/04/21/postgis-2.5.6/
-
PostGIS
@postgis
PostGIS For Newbies www.crunchydata.com/blog/postgis-for-newbies
-
PostGIS reposted
GIS • OPS . SԀO • SI⅁
@gis_ops
Map matching your collection of linestrings in #postgresql #postgis via PL/Python & Valhalla Routing made easy - find out how it works ➡️ gis-ops.com/map-matching-postgis-plpython/ #gis #strava #python3 🌎🌍🌏
-
PostGIS
@postgis
PostGIS 3.2.1 postgis.net/2022/02/12/postgis-3.2.1/
-
PostGIS
@postgis
PostGIS 3.0.5 postgis.net/2022/02/02/postgis-3.0.5/
-
PostGIS
@postgis
PostGIS 3.1.5 postgis.net/2022/02/01/postgis-3.1.5/
-
PostGIS
@postgis
Upgrading raster from 2.* to 3.* postgis.net/2022/01/14/tip-upgrading-raster-from-2-3/
-
PostGIS
@postgis
PostGIS 3.2.0 Released postgis.net/2021/12/18/postgis-3.2.0-released/
-
PostGIS
@postgis
Olivier Courtin Farewell postgis.net/2021/12/17/olivier-courtin-farewell/
-
PostGIS
@postgis
PostGIS 3.2.0rc1 Released postgis.net/2021/12/10/postgis-3.2.0rc1-released/
-
PostGIS
@postgis
PostGIS 3.2.0beta3 Released postgis.net/2021/12/04/postgis-3.2.0beta3-released/
-
PostGIS
@postgis
PostGIS 3.2.0beta2 Released postgis.net/2021/11/26/postgis-3.2.0beta2-released/
-
PostGIS
@postgis
PostGIS 3.2.0alpha1 Released postgis.net/2021/09/11/postgis-3.2.0alpha1-released/
-
PostGIS
@postgis
PostGIS 3.2.1 postgis.net/2022/02/12/postgis-3.2.1/
-
PostGIS
@postgis
PostGIS 3.0.5 postgis.net/2022/02/02/postgis-3.0.5/
-
PostGIS
@postgis
PostGIS 3.1.5 postgis.net/2022/02/01/postgis-3.1.5/
-
PostGIS
@postgis
Upgrading raster from 2.* to 3.* postgis.net/2022/01/14/tip-upgrading-raster-from-2-3/
-
PostGIS
@postgis
PostGIS 3.2.0 Released dlvr.it/SMqCMD
-
PostGIS
@postgis
Olivier Courtin Farewell postgis.net/2021/12/17/olivier-courtin-farewell/
-
PostGIS
@postgis
PostGIS 3.2.0rc1 Released postgis.net/2021/12/10/postgis-3.2.0rc1-released/
-
PostGIS
@postgis
PostGIS 3.2.0beta3 Released postgis.net/2021/12/04/postgis-3.2.0beta3-released/
-
PostGIS
@postgis
PostGIS 3.2.0beta2 Released dlvr.it/SMqCLb
-
PostGIS
@postgis
PostGIS 3.2.0alpha1 Released postgis.net/2021/09/11/postgis-3.2.0alpha1-released/
-
PostGIS
@postgis
Spatial Filters in pg_featureserv with CQL www.crunchydata.com/blog/spatial-filters-in-pg_featureser…
-
PostGIS reposted
Levente Juhász
@juhaszlevi
Stay tuned for news about my new @postgis @PostgreSQL workshop in the Fall. It will be a 2-day, intensive, in-person course. Hope to see lots of South Florida geospatial folks there 🌐🗺️👨💻🧑💻👩💻💻
FIU CED-GIS Center
@fiugis
Hey South Florida tech and geospatial people! We are organizing a 2-day PostgreSQL/PostGIS workshop in the Fall semester. Stay tuned for course news and additional details. Final announcement coming soon! #geospatial #gischat @FAUGeoscience @Resilient305 @ufgeomatics @FIU
-
PostGIS
@postgis
PostGIS vs GPU: Performance and Spatial Joins www.crunchydata.com/blog/performance-and-spatial-joins
-
PostGIS
@postgis
CQL Filtering in pg_featureserv www.crunchydata.com/blog/cql-filtering-in-pg_featureserv
-
PostGIS reposted
Crunchy Data
@crunchydata
Safer Application Users in Postgres blog.crunchydata.com/blog/safer-application-users-in-post…
-
PostGIS
@postgis
PostGIS 3.2.1 postgis.net/2022/02/12/postgis-3.2.1
-
PostGIS
@postgis
PostGIS 3.0.5 postgis.net/2022/02/02/postgis-3.0.5
-
PostGIS
@postgis
Tell your @postgis story @cituscon, the call for speakers is closing soon! www.citusdata.com/cituscon/2022/cfp/
-
PostGIS
@postgis
PostGIS 3.1.5 postgis.net/2022/02/01/postgis-3.1.5
-
PostGIS reposted
Jamie Popkin
@jamiepopkin
This little nearest neighbor trick just saved me a ton of time!! blog.cleverelephant.ca/2021/12/knn-syntax.html Thanks for posting @pwramsey #postgis
-
PostGIS
@postgis
Concave Hulls in JTS
lin-ear-th-inking.blogspot.com/2022/01/concave-hulls-in-j… -
PostGIS
@postgis
Elevation Profiles and Flightlines with PostGIS www.crunchydata.com/blog/elevation-profiles-and-flightlin…
-
PostGIS
@postgis
Concave Hulls in JTS lin-ear-th-inking.blogspot.com/2022/01/concave-hulls-in-j…
-
PostGIS
@postgis
GEOS 3.10.2 released libgeos.org/posts/2021-11-02-geos-3-10-2-released/
-
PostGIS
@postgis
Upgrading raster from 2.* to 3.* postgis.net/2022/01/14/tip-upgrading-raster-from-2-3
-
PostGIS
@postgis
PostGIS 3.2 New and Improved www.crunchydata.com/blog/postgis-3.2-new-and-improved
-
PostGIS
@postgis
Very pretty intro slide deck. slides.com/fxku/postgis/fullscreen
-
PostGIS
@postgis
Did you know that... since 2017 you can live-update your QGIS layers in response to database-side changes? So multiple editors can be kept in sync, for example. oslandia.com/en/2017/10/07/refresh-your-maps-from-postgre…
-
PostGIS reposted
Crunchy Data
@crunchydata
Looking to learn more about #postgis? Explore the many extensions of PostGIS with @reginaobe with this recording of her presentation at PostGIS Day 2021. www.crunchydata.com/videos/exploring-the-many-extensions-…
-
PostGIS
@postgis
PostGIS Day 2021 Highlights www.bostongis.com/blog/index.php?%2Farchives%2F277-PostGI…
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
REGINA OBE (@reginaobe): PostGIS Day 2021 Highlights postgr.es/p/5eb
-
PostGIS
@postgis
PostGIS 3.2.0 Released postgis.net/2021/12/18/postgis-3.2.0
-
PostGIS
@postgis
Olivier Courtin Farewell postgis.net/2021/12/17/olivier-courtin
-
PostGIS
@postgis
PostGIS Nearest Neighbor Syntax blog.cleverelephant.ca/2021/12/knn-syntax.html
-
PostGIS
@postgis
This use of the ORDER BY <target-column-number> is a very clever syntax to both get the distance and KNN order on it while only calculating it once and only having to provide the reference geometry literal once. ❤️ ❤️ ❤️
Joel Haasnoot
@webguy
It's slightly more subtle because our query is finding the nearest object and its distance:
`SELECT id, $point <-> geom
FROM geoms
WHERE foo
ORDER BY 2
LIMIT 1`
It's in the order by clause but we're also returning the distance as a by-product (and taking advantage of the index) -
PostGIS
@postgis
PostGIS 3.2.0rc1 Released postgis.net/2021/12/10/postgis-3.2.0rc1
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
Added raster support for @postgis 3.1 RPMs on SLES 15. On their way to the #postgresql RPM repo. Enjoy.
-
PostGIS reposted
Bruce Rindahl
@BruceRindahl
Creating a Cardioid in @postgis . Inspired by Martin Davis talk on SVG during PostGIS Day
-
PostGIS reposted
FOSS4G 2024 | https://fosstodon.org/@foss4g
@foss4g
📢 Call for paper is out!
You can now submit your talk, workshop or academic paper proposals.
Read all the info on the #foss4g2022 website ➡ 2022.foss4g.org/call_for_paper.php
#foss4g #osgeo @OSGeo
#gischat -
PostGIS
@postgis
PostGIS 3.2.0beta3 Released postgis.net/2021/12/04/postgis-3.2.0beta3
-
PostGIS
@postgis
Tricks for Faster Spatial Indexes www.crunchydata.com/blog/tricks-for-faster-spatial-indexes
-
PostGIS reposted
Crunchy Data
@crunchydata
New blog with some #postgis tricks from @pwramsey: blog.crunchydata.com/blog/tricks-for-faster-spatial-indexes
-
PostGIS reposted
Zalando Technology
@ZalandoTech
Did you know that you can create and stream web maps from #sql queries? Our blog post shows how to accomplish it with @PostgreSQL @postgis and #pg_tileserv running on #kubernetes engineering.zalando.com/posts/2021/12/maps-with-postgresq…
-
PostGIS
@postgis
PostGIS Day 2021 www.crunchydata.com/blog/postgis-day-2021
-
PostGIS
@postgis
Virtual @PostGIS day 2021 videos are out! 🌎 www.youtube.com/playlist?list=PLesw5jpZchudjKjwvFks-gAbz9…
-
PostGIS
@postgis
PostGIS 3.2.0beta2 Released postgis.net/2021/11/26/postgis-3.2.0beta2
-
PostGIS reposted
ntrip.bsky.social
@MapAspects
PostGIS talks are under way today! Registration is still open
PostGIS
@postgis
Yes, virtual PostGIS Day is happening again! November 18! Sign up now, while we still have space! info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
PostGIS Day is just two days away! November 18! Register now for the last few spaces. info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
Yes, virtual PostGIS Day is happening again! November 18! Sign up now, while we still have space! info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
Is this what it feels like to be an industry standard?
-
PostGIS reposted
@rjhale1971@fosstodon.org
@rjhale
Loading a DEM into PostGIS www.northrivergeographic.com/archives/loading-a-dem-into-…
-
PostGIS reposted
RustProof Labs 🐘
@RustProofLabs
Hexagons, day 4.
Tree counts around Denver, CO. Requires PostGIS 3.1 minimum.
#30daymapchallenge
RustProof Labs 🐘
@RustProofLabs
Polygons, day 3. Are you within 100km of I-80?
#30daymapchallenge -
PostGIS
@postgis
GEOS 3.9.2 released, with a passel of bug fixes and enhancements. lists.osgeo.org/pipermail/geos-devel/2021-November/010526…
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
UPDATE: @postgis 3.2.0 beta1-2 packages are syncing to repos. I built them agains the new #geos 3.10.0 in order to fully utilize 3.2 features. #postgresql
-
PostGIS
@postgis
Very complete summary of current situation with postgres apt repo and UbuntuGIS repo. TLDR: choose one, don’t mix and match. github.com/pramsey/pgsql-ogr-fdw/issues/223
-
PostGIS
@postgis
PostGIS day 2021 agenda is out! info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
PostGIS 3.2.0beta1 Released postgis.net/2021/10/23/postgis-3.2.0beta1
-
PostGIS
@postgis
FOSS4G 2021 Bueno Aires Videos are out dlvr.it/SB2sPj
-
PostGIS
@postgis
"The GEOS PSC is somewhat amused to set the 3.10.0 release of GEOS free to fly the skies of the digisphere, bringing valid geometries and fast operations to entities everywhere."
lists.osgeo.org/pipermail/geos-devel/2021-October/010484.… -
PostGIS reposted
Crunchy Data
@crunchydata
(The Many) Spatial Indexes of PostGIS
blog.crunchydata.com/blog/the-many-spatial-indexes-of-pos… -
PostGIS reposted
Crunchy Data
@crunchydata
Brent Tucker, Principal Consultant Infrastructure Analytics at CPCS, talks about the role of Postgres and PostGIS as a central component of data science and visualization of their platform at #postgisday2020. www.crunchydata.com/videos/postgis-in-the-data-science-pi…
-
PostGIS reposted
Sophie (she/her)
@SophieKolston
I'm trying to fight hard to get QGIS (and FOSS in general) taught at UoA over ArcGIS. Any tips for a compelling argument? I am not eloquent enough #gischat #foss4geo #qgis
-
PostGIS
@postgis
We want you! to share your #postgis stories on PostGIS Day 2021. Sign up to attend, or to present, the closing date for presentation proposals is Friday! info.crunchydata.com/en/postgis-day-2021
-
PostGIS reposted
Crunchy Data
@crunchydata
Last call for #postgis day submissions. We are closing the call on Friday. If you have an interesting PostGIS use case in the public or private sector, submit a talk summary or idea for this year’s meetup. info.crunchydata.com/en/postgis-day-2021
-
PostGIS reposted
Frank Pientka☁️
@fpientka
Amazon RDS for PostgreSQL Supports PostGIS 3.1 aws.amazon.com/about-aws/whats-new/2021/10/amazon-rds-pos…
-
PostGIS reposted
Crunchy Data
@crunchydata
Routing with PostgreSQL and Crunchy Spatial
blog.crunchydata.com/blog/routing-with-postgresql-and-cru… -
PostGIS
@postgis
Share your @postgis story on PostGIS day this year! Call for talks closing out next week! info.crunchydata.com/en/postgis-day-2021
-
PostGIS reposted
Maanmittauslaitos
@Maanmittaus
The National Land Survey of Finland is upgrading the topographic data production system. The new system will be based on open source technologies – @postgis and @qgis.
This selection has proven its worth, read more here: www.maanmittauslaitos.fi/en/topical_issues/topographic-da…
#postgis #qgis #opensource -
PostGIS reposted
Astrid Emde 🇺🇦
@astroidex
Big crowd joined the #postgresql #postgis for beginner workshop on Monday at #foss4g 2021.
You find the workshop material online
github.com/astroidex/foss4g-2021-workshop-postgresql-post…
Note that you can always run the workshop together with #osgeolive on your own.
Enjoy #foss4g!
#osgeo #fossgis -
PostGIS reposted
Crunchy Data
@crunchydata
Calling presenters and speakers for the 3rd annual #postgis day. Join us for a virtual meeting of the geospatial minds, Nov 18th, early registration open now. Call for presentations closes October 8th. info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
Virtual PostGIS Day is on once more, Nov 18, 2021! So many good talks last year, join us again for a day of cool stories from the frontiers of spatial SQL. info.crunchydata.com/en/postgis-day-2021
-
PostGIS
@postgis
Waiting for PostGIS 3.2: ST_MakeValid www.crunchydata.com/blog/waiting-for-postgis-3.2-st_makev…
-
PostGIS
@postgis
Performance Improvements in GEOS www.crunchydata.com/blog/performance-improvements-in-geos
-
PostGIS
@postgis
Production PostGIS Vector Tiles: Caching www.crunchydata.com/blog/production-postgis-vector-tiles-…
-
PostGIS
@postgis
Interested in learning about @postgis? There's a whole workshop online, check it out! postgis.net/workshops/postgis-intro/
-
PostGIS
@postgis
Compiling http extension on ubuntu 18.04 www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS
@postgis
Joining Crunchy Data to work on PostGIS lin-ear-th-inking.blogspot.com/2019/02/joining-crunchy-da…
-
PostGIS
@postgis
Using pg_upgrade to upgrade PostgreSQL 9.3 PostGIS 2.1 to PostgreSQL 11 2.5 on Yum dlvr.it/S7MDQR
-
PostGIS reposted
Brian DeRocher
@openbrian
Tacking a stab at building VA districts. Here, I'm mapping centroids of 2010 census tab blocks to the nearest OSM node to be used in a Johnson's based distance metric in a modified k-means clustering algorithm. @1VA2021 @CommissionVa #postgis
-
PostGIS reposted
David Bitner
@bitnerd
I'll match your offer by giving a copy of PostGIS as well!
-
PostGIS
@postgis
Pretty sure that they are all migrating to get access to @postgis 😉
Matt Asay
@mjasay
Just occurred to me that one reason for @PostgreSQL's rising strength (borne out by the DB-Engines' shift in rankings) is that companies want off Oracle, SQL Server, DB2...but aren't yet considering a move off SQL. Postgres (with its quality and community) makes a nice change
-
PostGIS reposted
Manning Publications
@ManningBooks
PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on any geodata task - PostGIS in Action, 3rd Ed. teaches you how to use #postgis. mng.bz/PXnn @planetpostgres #postgre #gis
-
PostGIS reposted
🥔🗺️ ᴘᴏᴋᴀᴛᴇᴏ ᴍᴀᴘs
@pokateo_maps
Ask and you shall receive #mappymeme
-
PostGIS
@postgis
Lake skeletonization using just @postgis and @pgrouting, very clever.
Bruce Rindahl
@BruceRindahl
Two part blog:
berrie.ddns.net?page_id=13 -
PostGIS reposted
Julio Gontor 🌎
@JulioGontor
Solving spatial problems with PostGIS with @reginaobe callforpapers.2021.foss4g.org/foss4g2021/talk/9EPAAQ/ #foss4g
-
PostGIS reposted
Reymar Sanchez
@SanchezReymar
@postgis ✌️
-
PostGIS reposted
-
PostGIS reposted
Bruce Rindahl
@BruceRindahl
Flow path through a lake b/w two points along medial axis using only native @postgis functions.
-
PostGIS reposted
Topi Tjukanov
@tjukanov
Did it in PostGIS with a simple inner join and by averaging the neighboring values. Now I just have to think which of these maps is more meaningful and gives more accurate results.
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Waiting for PostGIS 3.2: ST_Contour and ST_SetZ postgr.es/p/57O
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Waiting for PostGIS 3.2: ST_MakeValid postgr.es/p/57o
-
PostGIS
@postgis
Serving OpenStreetMap vector tiles with PostGIS and pg_tileserv pieterprovoost.be/blog/vector-tiles-with-postgis
-
PostGIS
@postgis
PostGIS 3.1.3 dlvr.it/S2yL4H
-
PostGIS reposted
Regina Obe
@reginaobe
@postgis #postgis - here is the code postgis.us/presentations/postgres_vision_2021.sql and slides postgis.us/presentations/PostgresVision2021_PostGIS.html used in the presentation
-
PostGIS
@postgis
Yes, there *is* a 36 section highly detailed workshop on @PostGIS available for free online, why do you ask? postgis.net/workshops/postgis-intro/index.html
-
PostGIS
@postgis
3.1 has big spatial join performance increases, overlay performance and robustness, overlay with precision tolerances.
Crunchy Data
@crunchydata
We’re excited to ship PostGIS 3.1 support for Crunchy Bridge: www.crunchydata.com/products/crunchy-bridge/
-
PostGIS reposted
Clement Keirua
@clemkeirua
📝PostgreSQL/PostGIS: a 80x cost drop by using ST_Distance with ST_DWithin
blog.keiruaprod.fr/2021/06/11/postgis-st-distance-vs-st-d…
(credits go to @sraimbault for the fix and @_kemar for the analysis) -
PostGIS reposted
Lachlan Hurst
@lachlanhurst
GDAL has played such a significant part in so many projects we've delivered. Really happy to be part of an organisation that contributes back.
FrontierSI
@_FrontierSI_
We're excited to announce that we have joined as a silver #sponsor to the #sustainable @GdalOrg #initiative. Our #support of this foundation #technology, like that of several other notable organisations, will go towards growing the geospatial ecosystem frontiersi.com.au/gdal/
-
PostGIS
@postgis
Looking for the PostgreSQL slack community? Join it here postgres-slack.herokuapp.com
-
PostGIS reposted
David Rowley
@davidrowley_pg
I knew of a few of PostgreSQL's common lineages, but this image shows quite a few more that I didn't know about. Credit to Felix Naumann. hpi.de/naumann/projects/rdbms-genealogy.html
-
PostGIS
@postgis
PostGIS at 20, The Beginning blog.cleverelephant.ca/2021/05/postgis-20-years.html
-
PostGIS reposted
Astrid Emde 🇺🇦
@astroidex
Happy Birthday @postgis! All the best to the project & the amazing team.
20 years ago the initial release 0.1 was announced lists.osgeo.org/pipermail/postgis-users/2001-May/000000.h…
We all love #postgis. Geodata in the database is great fun, full of power & provides many possibilities.
#osgeo #foss4g #fossgis -
PostGIS
@postgis
Faster IsSimple() puts us on the road to faster IsValid() lin-ear-th-inking.blogspot.com/2021/05/jts-issimple-gets-…
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
✔️ Recent updates in the #postgresql #rpm repo:
* @PostGIS 3.1.2
* Orafce 3.15.1
* postgresql_faker 0.4.0 (@daamien) (@DaliboLabs )
* sqlite_fdw 2.0.0
* pg_auto_failover 1.5.2 (@citusdata)
* @GdalOrg 3.2.3
* Proj 8.0.1
Enjoy! -
PostGIS
@postgis
Vector tile generators may find this includes a substantial performance improvement, particularly if they have more than one ST_Transform() in their generating query.
PostGIS
@postgis
PostGIS 3.1.2 postgis.net/2021/05/21/postgis-3.1.2
-
PostGIS
@postgis
PostGIS 3.1.2 postgis.net/2021/05/21/postgis-3.1.2
-
PostGIS
@postgis
What would you add to the @postgis dream journal? docs.google.com/presentation/d/1iqTLwt95rEBISBcPoaA31_clq…
-
PostGIS reposted
Supabase
@supabase
We absolutely Love this Open Sourced Geo-Video Sharing App using Supabase Storage by @dshukertjr and built with some @FlutterDev magic.
💚💚💚💚💚
github.com/dshukertjr/spot -
PostGIS
@postgis
Waiting for PostGIS 3.2: ST_InterpolateRaster www.crunchydata.com/blog/waiting-for-postgis-3.2-st_inter…
-
PostGIS reposted
Nithya Ruff
@nithyaruff
Hi #opensource community. Could you send me the names of projects that have women maintainers or co-maintainers? Appreciate retweets to increase reach. Made these cookies yesterday that was fabulous. And happy to share the recipe.
-
PostGIS reposted
RustProof Labs 🐘
@RustProofLabs
The next PgOSM Flex release (0.2.0) is waiting for the next tagged osm2pgsql release.
osm2pgsql introduced a breaking change in the flex output in order to provide built-in JSON/JSONB support! 👍
#postgis #openstreetmap -
PostGIS
@postgis
Share your memories of @postgis with @astroidex as part of a 20th birthday presentation! lists.osgeo.org/pipermail/postgis-devel/2021-May/028922.html
-
PostGIS reposted
Ryan Booz
@ryanbooz
✨ The State of PostgreSQL 2021 is live✨
We surveyed developers to learn how (& why) @PostgreSQL is being used, including:
🛠 Ecosystem & tools
💬 Community experiences
💻 Use cases
🎟 Events
Full results & download data: tsdb.co/state-of-pg-2021
Highlights below 👇 1/ -
PostGIS reposted
MapScaping
@MapScaping
. @GdalOrg is a critical piece of geospatial infrastructure!
@pwramsey walks us through what #gdal is, where it can be found in the wild, and the business model behind it.
Thanks, @EvenRouault you are a legend!
podcasts.apple.com/us/podcast/gdal-geospatial-data-abstra… -
PostGIS
@postgis
(The Many) Spatial Indexes of PostGIS www.crunchydata.com/blog/the-many-spatial-indexes-of-postgis
-
PostGIS
@postgis
Spatial Indexes and Bad Queries blog.cleverelephant.ca/2021/05/indexes-and-queries.html
-
PostGIS
@postgis
Spherical data on a flat map got you down? Maybe you need to postgis.net/docs/ST_WrapX.html
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
✔️Update: Looks like it was a build server issue (thanks SFCGAL folks for their patience and help). PostGIS 3.1 for PostgreSQL 12/13 on Fedora 34 is also out.
Enjoy! -
PostGIS
@postgis
Creating mosaics, clipping and removing overlapping satellite images wsdookadr.github.io/posts/p5/
-
PostGIS
@postgis
Polygon gridding using Geopandas and Shapely wsdookadr.github.io/posts/p4/
-
PostGIS reposted
Crunchy Data
@crunchydata
PostGIS and the Geography Type
blog.crunchydata.com/blog/postgis-and-the-geography-type -
PostGIS
@postgis
GEOS 3.8.2 is released. lists.osgeo.org/pipermail/geos-devel/2021-April/010201.html
-
PostGIS
@postgis
Dumping a ByteA with psql blog.cleverelephant.ca/2021/04/psql-binary.html
-
PostGIS reposted
TimescaleDB (by Tiger Data)
@TimescaleDB
We 💛 the @PostgreSQL ecosystem of 20K+ extensions (S/O @ZomboDB + @PostGIS)
Share the ones *you* use and love, how and why you use Postgres, and more 👇
tsdb.co/postgres-2021-survey
✅ We'll publish key findings + make source data available for everyone -
PostGIS reposted
TimescaleDB (by Tiger Data)
@TimescaleDB
👋 Calling all #postgresql community members - the 2021 State of Postgres survey is now open 🎉!
Share your feedback, favorite extensions, community experiences, and more 👇
tsdb.co/postgres-2021-survey
Survey closes April 6, 2021 @ 11:59pm PT -
PostGIS reposted
Crunchy Data
@crunchydata
Performance Improvements in GEOS @pwramsey blog.crunchydata.com/blog/performance-improvements-in-geos
-
PostGIS
@postgis
ArcGIS Feature Service to PostGIS: The QGIS Way www.crunchydata.com/blog/arcgis-feature-service-to-postgi…
-
PostGIS reposted
Caribbean GIS
@caribbeangis
Does @ETAPsoftware work easily with #gis, e.g. #shapefiles created in @qgis, or @postgis datasets?
-
PostGIS reposted
Postgres Weekly 🐘
@PostgresWeekly
Where Can Postgres Config Parameters Be Set? www.depesz.com/2021/03/01/starting-with-pg-where-how-can-… (Proving that it's not just in `postgresql.conf`.)
-
PostGIS
@postgis
Spatial overlay explained www.crunchydata.com/videos/postgis-spatial-overlay/
-
PostGIS reposted
Microsoft for PostgreSQL
@MSFTforPostgres
ICYMI our Citus open source team has released Citus 10, including:
- columnar storage
- single-node Citus
- & more!
We're working to bring Citus 10 to y'all in #azuredbpostgres soon soon. All the details are in @marcoslot's blog post: www.citusdata.com/blog/2021/03/05/citus-10-release-open-s… -
PostGIS reposted
Dan Langille @dvl@bsd.network
@DLangille
Here we have the PGCon 2020 playlist:
www.youtube.com/playlist?list=PLuJmmKtsV1dP8IGGH6Z_sYQKxf…
My apologies for it taking so long. -
PostGIS reposted
Bruce Rindahl
@BruceRindahl
@postgis and @PostgreSQL continue to amaze. Needed to selectively create a non-overlapping set of polygons from an overlapping set based on an attribute. st_intersect and st_diff wrapped in a recursive query FTW
-
PostGIS reposted
📡 rkaneko 📡
@__rkaneko
“GitHub - CrunchyData/pg_tileserv: A very thin PostGIS-only tile server in Go. Takes in HTTP tile requests, executes SQL, returns MVT tiles.” (1 user) htn.to/37qynGn3CW
-
PostGIS
@postgis
ArcGIS Feature Service to PostGIS: The QGIS Way www.crunchydata.com/blog/arcgis-feature-service-to-postgi…
-
PostGIS
@postgis
Joining Crunchy Data to work on PostGIS lin-ear-th-inking.blogspot.com/2019/02/joining-crunchy-da…
-
PostGIS
@postgis
PostGIS 2.5.1 Bundle for Windows www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS reposted
DBeaver
@dbeaver_news
Good news for everyone who works with spatial data in DBeaver: now you can use not only predefined maps but add your own as well. 🌏
-
PostGIS reposted
Jimmy Rocks™ 🗺️
@jimmyrocks
I'm pretty sure PostGIS is my career at this point, "PostGIS in Action" is probably the most influential book in my life.
-
PostGIS reposted
(((TheSteve0))) @TheSteve0@data-folks.masto.host
@TheSteve0
Thinking the Big Cloud Providers spatial capabilities are even close to #postgis, think again!
ual.sg/post/2020/07/03/a-comparison-of-spatial-functions-… -
PostGIS reposted
Paul Kernfeld
@occupy_paul_st
This is an incredibly creative (ab)use of DB geospatial features: the Tantan app used 4D Postgres indexing to efficiently match users not only on geographic location but other properties like age and activity!
www.youtube.com/watch?v=ty0-TtPF-ws -
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Fuzzy Name Matching in Postgres postgr.es/p/50z
-
PostGIS
@postgis
ArcGIS Feature Service to PostGIS: The QGIS Way www.crunchydata.com/blog/arcgis-feature-service-to-postgi…
-
PostGIS
@postgis
“Catchment areas” with PostgreSQL and PostGIS www.cybertec-postgresql.com/en/catchment-areas-with-postg…
-
PostGIS
@postgis
Randomization to the Rescue! lin-ear-th-inking.blogspot.com/2020/12/randomization-to-r…
-
PostGIS
@postgis
Running commands in the JTS TestBuilder lin-ear-th-inking.blogspot.com/2020/02/running-commands-i…
-
PostGIS
@postgis
Better/Faster ST_PointOnSurface for PostGIS lin-ear-th-inking.blogspot.com/2019/02/betterfaster-stpoi…
-
PostGIS
@postgis
Don't be worried, PostGIS 3.1 + GEOS 3.9 can overlay all your geometries, you just might have to ST_MakeValid() them before processing. lin-ear-th-inking.blogspot.com/2021/02/overlayng-and-inva…
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Martin Davis: OverlayNG and Invalid Geometry postgr.es/p/4_L
-
PostGIS reposted
Crunchy Data
@crunchydata
Help us solve an internal debate, what is the best Postgres extension?
-
PostGIS
@postgis
PostGIS 3.1.1 dlvr.it/RrYHP6
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Ryan Lambert (@RustProofLabs): Better OpenStreetMap places in PostGIS postgr.es/p/4_j
-
PostGIS
@postgis
Production PostGIS Vector Tiles: Caching www.crunchydata.com/blog/production-postgis-vector-tiles-…
-
PostGIS reposted
Paul Laurence
@prlaurence
To the extent you havent come across this already, there is quite a bit you can do with R within Postgres/PostGIS: info.crunchydata.com/blog/spatial-analytics-with-postgres…
-
PostGIS reposted
(((TheSteve0))) @TheSteve0@data-folks.masto.host
@TheSteve0
Hey #postgis peeps - the @crunchydata PostGIS day 2020 videos are now LIVE. They are the first page and a half videos here:
www.crunchydata.com/videos/
Get 'em while their hot!
#postgisday -
PostGIS reposted
-
PostGIS
@postgis
Loading Data into PostGIS: An Overview www.crunchydata.com/blog/loading-data-into-postgis-an-ove…
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Kat Batuigas (@alsokrista): Loading Data into PostGIS: An Overview postgr.es/p/4-h
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
✔️@PostGIS 3.1.0 RPMs are out! They are built against #geos 3.9.0, and #proj 7.2.0. The latest, the greatest!
I also rebuilt PostGIS 3.0, 2.5 and 2.4 RPMs against new GEOS.
Enjoy!
#postgresql #gis #rpm #yum #fedora #centos #rhel #rockylinux #dnf #oraclelinux -
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
I know many of you are waiting for @PostGIS 3.1.0 RPMs. Using this opportunity to upgrade to GeOS 3.9 as well. Package will be ready soon, and will be out after a quick testing. #postgresql
-
PostGIS
@postgis
PostGIS 3.1.0 postgis.net/2020/12/18/postgis-3.1.0
-
PostGIS
@postgis
PostGIS Raster and Crunchy Bridge www.crunchydata.com/blog/postgis-raster-and-crunchy-bridge
-
PostGIS
@postgis
Waiting for PostGIS 3.1: Grid Generators blog.cleverelephant.ca/2020/12/waiting-postgis-31-2.html
-
PostGIS
@postgis
Waiting for PostGIS 3.1: Performance blog.cleverelephant.ca/2020/12/waiting-postgis-31-1.html
-
PostGIS
@postgis
Waiting for Postgis 3.1: Performance with large geometries rmr.ninja/2020-12-14-waiting-for-postgis-3-1-large_geomet…
-
PostGIS
@postgis
PostGIS 3.1.0rc1 postgis.net/2020/12/14/postgis-3.1.0rc1
-
PostGIS
@postgis
Using WebAssembly to add Argon2 to Snowflake rmr.ninja/2020-12-14-Snowflake-WebAssembly/
-
PostGIS reposted
PostGIS
@postgis
PostGIS 3.1.0beta1 postgis.net/2020/12/09/postgis-3.1.0beta1
-
PostGIS
@postgis
PostGIS 3.1.0beta1 postgis.net/2020/12/09/postgis-3.1.0beta1
-
PostGIS
@postgis
Waiting for PostGIS 3.1: GEOS 3.9 www.crunchydata.com/blog/waiting-for-postgis-3.1-geos-3.9
-
PostGIS
@postgis
Waiting for Postgis 3.1: Output functions dlvr.it/RnBBsz
-
PostGIS
@postgis
Waiting for Postgis 3.1: Vector tile improvements dlvr.it/RnBBpL
-
PostGIS
@postgis
PostGIS Day 2020 Roundup www.crunchydata.com/blog/postgis-day-2020-roundup
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
❗️ATTN: Relased gdal32 3.2.0-2 RPMs which fixes @PostGIS crash issues. Thanks @magnushagander and others for reporting this issue and helping me to test the packages.
#postgresql -
PostGIS
@postgis
Waiting for PostGIS 3.1: Grid Generators www.crunchydata.com/blog/waiting-for-postgis-3.1-grid-gen…
-
PostGIS
@postgis
PostGIS 3.0.3 dlvr.it/Rm7HJK
-
PostGIS reposted
Jorge Mendes 🇪🇺🏳️🌈✨🐍💻✡
@JMendesDeJesus
A new vacancy @ISRICorg for a PostGIS manager / ICT
www.academictransfer.com/en/295713/databaseit-expert-at-t…
#postgis #foss4g #ogc #sdi #soil #soils #ictvacature #ictjobs -
PostGIS
@postgis
PostGIS 3.1.0alpha3 postgis.net/2020/11/19/postgis-3.1.0alpha3
-
PostGIS
@postgis
Waiting for Postgis 3.1: Vector tile improvements dlvr.it/Rm2bsL
-
PostGIS
@postgis
Waiting for PostGIS 3.1: Performance www.crunchydata.com/blog/waiting-for-postgis-3.1-performance
-
PostGIS
@postgis
Virtual PostGIS Day 2020 is Nov. 19 www.crunchydata.com/blog/postgis-day-2020
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Waiting for PostGIS 3.1: Performance postgr.es/p/4YC
-
PostGIS
@postgis
PostGIS day is almost upon us. Hang your PostGIS advent calendars on the wall. Practice your PostGIS carols. For PostGIS day is near. info.crunchydata.com/blog/postgis-day-2020
-
PostGIS reposted
Crunchy Data
@crunchydata
Agenda now available for Virtual PostGIS Day 2020. Join us for a day filled with talks about all things PostGIS on Nov. 19: info.crunchydata.com/en/postgis-day-2020-crunchy-data
-
PostGIS reposted
Crunchy Data
@crunchydata
Save the date: Virtual PostGIS Day, Nov 19! We're excited to host PostGIS Day 2020 with the collaboration of several community members and @crunchydata friends! Agenda and speaker details to come. Register: info.crunchydata.com/en/postgis-day-2020-crunchy-data
-
PostGIS reposted
UN Mappers
@UN_Mappers
We are #hiring!
#linux system admin, experience in #postgresql/PostGIS DB and #osm. Join #unitemaps team in #brindisi (Italy) to support the #un in delivering services and products to our #peacekeepers and #unmappers in #africa 👉www.trigyn.com/job/system-administrator-linux
#gischat @gischatbot -
PostGIS
@postgis
PostGIS db help and manual in different languages www.bostongis.com/blog/index.php?%2Farchives%2F267-PostGI…
-
PostGIS
@postgis
Drive-time Isochrones from a single Shapefile using QGIS, PostGIS, and Pgrouting anitagraser.com/2017/09/11/drive-time-isochrones-from-a-s…
-
PostGIS
@postgis
geography type is not limited to earth www.bostongis.com/blog/index.php?%2Farchives%2F266-geogra…
-
PostGIS
@postgis
And Then What? spatiallyadjusted.com/and-then-what/
-
PostGIS
@postgis
Uber and Google Sign 4 Year Agreement on Google Maps spatiallyadjusted.com/uber-and-google-sign-4-year-agreeme…
-
PostGIS
@postgis
Abandoning the Digital Notetaking dlvr.it/RkKRW6
-
PostGIS
@postgis
Using PostgreSQL to Shape and Prepare Scientific Data www.crunchydata.com/blog/1-using-postgresql-to-shape-and-…
-
PostGIS
@postgis
Logical Replication Upgrade in Postgres www.crunchydata.com/blog/logical-replication-upgrade-in-p…
-
PostGIS
@postgis
Tuning Your Postgres Database for High Write Loads www.crunchydata.com/blog/tuning-your-postgres-database-fo…
-
PostGIS
@postgis
Write support for GDAL PostGIS Raster driver on its way dlvr.it/RjY9mz
-
PostGIS
@postgis
PostgreSQL Monitoring for App Developers: Alerts & Troubleshooting www.crunchydata.com/blog/postgresql-monitoring-for-app-de…
-
PostGIS
@postgis
Talking PostGIS on Podcasts blog.cleverelephant.ca/2020/10/podcasts.html
-
PostGIS
@postgis
PostgreSQL Monitoring for Application Developers: The DBA Fundamentals www.crunchydata.com/blog/postgresql-monitoring-for-applic…
-
PostGIS
@postgis
PostgreSQL Monitoring for Application Developers: The Vitals www.crunchydata.com/blog/postgresql-monitoring-applicatio…
-
PostGIS
@postgis
How to Setup PostgreSQL Monitoring in Kubernetes www.crunchydata.com/blog/setup-postgresql-monitoring-in-k…
-
PostGIS
@postgis
Synchronous Replication in PostgreSQL dlvr.it/Rhh6LH
-
PostGIS reposted
Crunchy Data
@crunchydata
Spatial Constraints with PostGIS in PostgreSQL- Part 1 (@pwramsey) info.crunchydata.com/blog/spatial-constraints-with-postgi…
-
PostGIS
@postgis
PostgreSQL 13 Upgrade and Performance Check on Ubuntu/Debian: 1.6GB/s random reads www.crunchydata.com/blog/postgresql-13-upgrade-and-perfor…
-
PostGIS
@postgis
PostgreSQL 13 Upgrade and Performance Check on Ubuntu/Debian: 1.6GB/s random reads www.crunchydata.com/blog/postgresql-13-upgrade-and-perfor…
-
PostGIS
@postgis
New in QGIS 3.2 Save Project to PostgreSQL www.bostongis.com/blog/index.php?%2Farchives%2F271-New-in…
-
PostGIS
@postgis
Coming PostGIS 2.5 ST_OrientedEnvelope www.bostongis.com/blog/index.php?%2Farchives%2F270-Coming…
-
PostGIS
@postgis
PostgresVision 2018 Slides and Impressions www.postgresonline.com/journal/index.php?%2Farchives%2F38…
-
PostGIS reposted
Miguel Fernandez
@miguelf2416
I’ve really been enjoying this podcast and this episode about PostGIS. podcasts.apple.com/us/podcast/the-mapscaping-podcast/id14…
-
PostGIS
@postgis
Three Easy Things To Remember About Postgres Indexes www.crunchydata.com/blog/three-easy-things-to-remember-ab…
-
PostGIS
@postgis
Introducing the Postgres Prometheus Adapter www.crunchydata.com/blog/using-postgres-to-back-prometheu…
-
PostGIS
@postgis
Why PostgreSQL 13 is a Lucky Release www.crunchydata.com/blog/why-postgresql-13-is-a-lucky-rel…
-
PostGIS reposted
PostgreSQL
@PostgreSQL
News: PostgreSQL 13 Released! www.postgresql.org/about/news/2077/
-
PostGIS reposted
@rjhale1971@fosstodon.org
@rjhale
...and I'm doing it - 20 minutes on #postgis at the #tngic conference coming up. Ya'll should sign up - it's free: www.eventbrite.com/e/tngic-virtual-fall-forum-registratio… #tennessee #gis #geo
-
PostGIS reposted
PostgreSQL
@PostgreSQL
News: PostgreSQL 13 RC 1 Released! www.postgresql.org/about/news/2072/
-
PostGIS reposted
MapScaping
@MapScaping
GIS without the GIS?
The co-founder of #postgis @pwramsey delivers what might be the best sales pitch for #spaital #sql that I have ever heard.
If you haven't already decided what #gis programming language to learn next, you should listen to this.
plnk.to/MapScaping -
PostGIS reposted
𝕯𝖊𝖓𝖓𝖎𝖘 𝕭𝖆𝖚𝖘𝖟𝖚𝖘
@DBauszus
Hi Megan, not specifically for Q but we assign data in regards to spatial overlap from polygon boundaries to hex grid cells in PostGIS. Have a look at the last script in this article. Hope this helps.👉🏼 medium.com/geolytix/hex-grid-algorithm-for-postgis-4ac45f…
-
PostGIS reposted
Crunchy Data
@crunchydata
Preprocessing Data for Spatial Analysis with PostGIS and PL/R - info.crunchydata.com/blog/preprocessing-data-for-spatial-…
-
PostGIS reposted
Topi Tjukanov
@tjukanov
When making these I have used QGIS to create the hexagon grid. But apparently there will be ST_HexagonGrid function coming up in #postgis 3.1. so the whole analysis can be done with a single SQL query! postgis.net/docs/manual-dev/ST_HexagonGrid.html
Blog post coming up!
Topi Tjukanov
@tjukanov
2020 version of 'Most common words in (all) place names describing nature in the US'
-
PostGIS reposted
Gary Sherman
@shermange
Short talk with @timlinux about the good old days. Here’s the 0.0.1 announcement of #qgis:
-
PostGIS reposted
@rjhale1971@fosstodon.org
@rjhale
One small anniversary. It's been 2 years that the very small PostGIS/QGIS project for the 911 has been running. Scripts firing. Maps getting made. Addressing getting assigned. No crashes.
-
PostGIS
@postgis
PostGIS 3.0.2, 2.5.5, 2.4.9 Released dlvr.it/Rdk5VN
-
PostGIS
@postgis
Pg12 + PostGIS3 = More spatial parallelism, in scans, aggs, and joins.
-
PostGIS reposted
Manning Publications
@ManningBooks
PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on any geodata task - PostGIS in Action, 3rd Ed. teaches you how to use #postgis. mng.bz/AN8x @planetpostgres #postgre #gis
-
PostGIS reposted
Kurt Menke - @geomenke.bsky.social
@geomenke
This Friday is Day 3 of #qgisna2020!
I'll be talking about the Best New Features of #qgis 3.x at 5:30pm EDT- 2:30pm PDT
Check out the rest of the program here:
qgis.us/qgis-na-2020.html
Field data collection, #qgisserver, #postgis and Processing are all covered! -
PostGIS reposted
NaturalGIS 🇺🇦
@naturalgis
When you can split your 1.4M VS 658K polygons intersection query and have some spare cores to use... @postgis @PostgreSQL
-
PostGIS reposted
Thomas Gratier - @ThomasG77@mastodon.social
@ThomasG77
Nothing new but since ST_AsGeoJSON(record) exists, you can get a FeatureCollection out of PostGIS with "select json_build_object('type', 'FeatureCollection', 'features', json_agg(ST_AsGeoJSON(t.*)::json)) from ( SELECT * FROM your_table) as t"
-
PostGIS
@postgis
PostGIS 3.1.0alpha2 dlvr.it/Rbvm79
-
PostGIS
@postgis
Three Fridays of QGIS learning goodness kick off this Friday, July 17. qgis.us/qgis-na-2020
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
. @postgis 3.1 Alpha1 RPMs are out for RHEL 7 , 8 and Fedora 31,32 .#postgresql
-
PostGIS reposted
Andrew Cutts
@map_andrew
New blog. #geopandas and #postgis www.acgeospatial.co.uk/geopandas-and-postgis/ A quick look at using GeoPandas and PostGIS will just a few lines of #geospatial #python code
-
PostGIS
@postgis
You give, and you give, and you give and you give....
-
PostGIS reposted
Aritra Das
@aritra__das
I recently had an opportunity to work with PostGIS in order to solve a very interesting problem.
Thought of writing an article to share a thing or two which I learned on the way.
So here it is :D
dev.to/aritra/hands-on-postgis-exploring-the-geospatial-c…
#postgis #geospatial #nodejs -
PostGIS reposted
Will Skora
@skorasaurus
in the geospatial and cartography spaces, E$RI and its ARC GIS are a prime example of software that are financially prohibitive for many people to use (esp. in relatively less wealthy countries), compared to (FOSS) free to use tools like QGIS and postgis.
-
PostGIS reposted
Mykola Kozyr 🇺🇦🇩🇪🇪🇺
@MykolaKozyr
Using @postgis' ST_ShortestLine is a great option to visualize the distribution of settlements comparing to major water bodies.
Works great with different geometry types
P.S. Aliases are copied 😉 -
PostGIS reposted
(((TheSteve0))) @TheSteve0@data-folks.masto.host
@TheSteve0
Friday at 9:45 AM pacific, live stream is on pg-tileserv. As opposed to other spatial servers out there: pg-tileserv is a lightweight, simple app server focused on kicking butt at serving MVT tiles from PostGIS. @pwramsey, lead dev, will join - WOOT!!
youtu.be/dHMupaWqVjY -
PostGIS reposted
GeoPandas
@geopandas
GeoPandas 0.8.0 has arrived!
It's a big one: more IO (PostGIS, Parquet, Feather), optional speed-up using PyGEOS, better support for multiple geometry columns, and lots of other fixes and improvements.
Thanks to all contributors for making this possible!
github.com/geopandas/geopandas/releases/tag/v0.8.0 -
PostGIS
@postgis
What’s new and coming in @PostGIS www.postgresvision.com/agenda
-
PostGIS reposted
Russell Mercer
@GetSpatial
Used ArcGIS for maps for years. Since city GIS is in PostgreS/PostGIS, and all editing happens in QGIS, I’ve started doing all visualizations there as well. The transition was quite easy, functionality is all there, with some cool things QGIS can do that ArcGIS cannot. #gischat
-
PostGIS reposted
Michael Diener
@spatialmounty
Spatial Constraints with PostGIS in PostgreSQL- Part 3 info.crunchydata.com/blog/spatial-constraints-with-postgi…
-
PostGIS reposted
Julian Simioni
@juliansimioni
This is a great overview of the concepts and (many) challenges of geocoding, even if you aren't using PostGIS.
Most of the techniques used by @pelias_geocoder and @geocodeearth are similar. It's all full-text search after all
Crunchy Data
@crunchydata
Geocoding and Text Search in PostGIS presented by Paul Ramsey (@pwramsey) www.youtube.com/watch?v=7RumQ9oXA9Q
-
PostGIS reposted
Niene Boeijen
@BNiene
I made the blog! So check nieneb.nl/online-projects/colorscales/ for the code. AND I will be talking about this afternoon in The Great Geo Show!!! @osgeonl 16:00 on Twitch & YouTube > tv.osgeo.nl
-
PostGIS reposted
Niene Boeijen
@BNiene
Perrrrfect stack: PostGIS for data storage, R for statistical investigation, D3.js Color scales & legend, MapboxGL.js for visualising. Yeah I am using D3 to make my json styling rules ✨
-
PostGIS reposted
Régis Haubourg
@RegisHaubourg
Hey #qgis users!
Have big datasets in your database?
Configure your DB connection like this if you don''t want to kill your database and wrongly accuse QGIS of being slow. -
PostGIS
@postgis
Developers Diary 2 dlvr.it/RYXSrS
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Spatial Constraints with PostGIS in PostgreSQL- Part 3 postgr.es/p/4N_
-
PostGIS
@postgis
PostGIS 2.3.11 dlvr.it/RXkKd4
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Spatial Constraints with PostGIS - Part 1 postgr.es/p/4Nd
-
PostGIS
@postgis
Compiling http extension on ubuntu 18.04 dlvr.it/RWrX8s
-
PostGIS
@postgis
PGConf US 2019 Data Loading Slides up www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS
@postgis
PostGIS 2.5.1 Bundle for Windows dlvr.it/RWrX8g
-
PostGIS
@postgis
Developers Diary 1 blog.cleverelephant.ca/2020/04/developer-life.html
-
PostGIS reposted
GeoPandas
@geopandas
Finally .. the next release of GeoPandas will finally have a method to write to PostGIS ! 🎉
Thanks to @tenkahen for the contribution, and to many others that contributed before to the discussion and previous PRs!
github.com/geopandas/geopandas/pull/1248 -
PostGIS
@postgis
PostGIS Data Anonymization dlvr.it/RW3LML
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Routing with PostgreSQL and Crunchy Spatial postgr.es/p/4Me
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Martin Davis: A Deep Dive into PostGIS Nearest Neighbor Search postgr.es/p/4KW
-
PostGIS reposted
Paul Ramsey
@pwramsey
"Why does PostGIS geography say this point is outside my box, when it is clearly inside my box?!?!" Part XCVII.
-
PostGIS reposted
geoMusings
@geomusingsblog
Blogged - Attribute Transfer in PostGIS Using Spatial SQL #gischat blog.geomusings.com/2020/04/06/attribute-transfer-in-post…
-
PostGIS reposted
Microsoft for PostgreSQL
@MSFTforPostgres
We would be remiss (which my phone wants to autocorrect to "tennis") if we did not thank @tjukanov for this super useful #postgis post on the Azure Postgres blog: Thank you Topi. 🙏 techcommunity.microsoft.com/t5/azure-database-for-postgre…
-
PostGIS reposted
LeendertvWolfswinkel
@LJvWolfswinkel
What is the most useful @postgis function in the supermarket these days? #gischat #corona
-
PostGIS reposted
@chrismarx@mapstodon.space @chris-marx.bsky.social
@chrismarx
It depends on the size of your datasets and how much of that data needs to be visible at one time, but in general, tiles right out of postgis has been working great for us so far - info.crunchydata.com/blog/dynamic-vector-tiles-from-postgis
-
PostGIS reposted
Paul Ramsey
@pwramsey
GEOS 3.8.1 is out. Important bug fixes within, upgrade when you can. lists.osgeo.org/pipermail/geos-devel/2020-March/009478.html
-
PostGIS reposted
-
PostGIS reposted
Kaiter Enless
@KaiterEnless
22 million points of GPS ship locations, rendered from PostGIS via QGIS.
-
PostGIS reposted
Tina Cormier
@TinaACormier
Do you work with spatial data? I know you're out there & I'd love to know what tools you use! We are at n=101. I'm shooting for at least 500! Please take 5 min on this survey!
forms.gle/V2a6Ty84LhurfLaW7
#gis #remotesensing #qgis #esri #python #rspatial #postgis #js #datascience -
PostGIS reposted
NaturalGIS 🇺🇦
@naturalgis
Vacancy at @SAERI_FI: "Data Centre Project Officer" for a person knowledgeable in #qgis and #postgis, among the other skills. saeri.breathehr.com/recruitment/vacancies/12175
-
PostGIS
@postgis
When I want to enable PostGIS I...
-
PostGIS reposted
CSE
@HelloCSE
Join us! We're looking for a Software Engineer (up to £45,743 pa) to join our existing team of 3 software designers/engineers. Knowledge of e.g. Java, Clojure, R, SQLite, PostGIS or PostgreSQ.L required | www.webrecruit.co/job-seekers/job-details/?id=2MLA0
-
PostGIS
@postgis
Movement data in GIS #29: power your web apps with movement data using mobilitydb-sqlalchemy anitagraser.com/2020/03/02/movement-data-in-gis-29-power-…
-
PostGIS
@postgis
PostGIS 2.5.4 dlvr.it/RQxgtz
-
PostGIS
@postgis
PostGIS Day in STL dlvr.it/RQtZCV
-
PostGIS
@postgis
PostGIS 3.0.1 dlvr.it/RQYrb6
-
PostGIS
@postgis
PostGIS 3.1.0alpha1 postgis.net/2020/02/02/postgis-3.1.0alpha1
-
PostGIS
@postgis
French Ministry in charge of the ecological transition selected Oslandia oslandia.com/en/2018/10/15/french-ministry-in-charge-of-t…
-
PostGIS
@postgis
Celebrating @shapefile day by making all my tables shapefile compliant…
UPDATE pg_attribute
SET attname = left(attname,10) -
PostGIS
@postgis
Final reminder, shut off all your PostGIS servers tomorrow, in solidarity with those who built spatial applications using Google Fusion Tables… then turn them back on again, because you aren’t chumps. #cloudservicesftw
-
PostGIS
@postgis
OGR FDW Spatial Filtering dlvr.it/RJZZjN
-
PostGIS
@postgis
Movement data in GIS #25: moving object databases dlvr.it/RJQ22f
-
PostGIS
@postgis
ST_Subdivide all the Things dlvr.it/RJCfrk
-
PostGIS
@postgis
GZip in PostgreSQL dlvr.it/RHmFmZ
-
PostGIS reposted
T-REX 🦖
@DowntownTREX
On Nov. 14, we're teaming up with @crunchydata to celebrate #postgisday (day after #gisday). This is a FREE session as part of Geography Awareness Week and serves to highlight the features and capabilities of PostGIS. #stlmade
-
PostGIS
@postgis
PostGIS 3.0.0 dlvr.it/RGYy5B
-
PostGIS
@postgis
PostGIS 3.0.0 coming soon - Try 3.0.0rc2 at a package repo near you www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS
@postgis
PostGIS 3.0.0rc2 postgis.net/2019/10/13/postgis-3.0.0rc2
-
PostGIS reposted
Vanuatu GIS Feed
@vanuatugis
ArcGIS Union equivalent in PostGIS? gis.stackexchange.com/questions/179533/arcgis-union-equiv… #gisstackexchange
-
PostGIS
@postgis
PostGIS 3.0.0rc1 dlvr.it/RFl0CT
-
PostGIS reposted
Steven Ottens 🐈
@stvno
Thanks to the lovely people at @eScienceCenter we have a location for the #postgisday 2019
So put it in your agenda:
14 november Post GIS day in Amsterdam; an unconference for PostGIS powerusers
for more info: postgisdag.nl
#postgis @OSGeo @osgeonl -
PostGIS reposted
Topi Tjukanov
@tjukanov
I am going to be at the next Helsinki #postgresql Meetup talking about (surprise surprise): #postgis! 🐘
www.meetup.com/Helsinki-PostgreSQL-Meetup/events/265371503 -
PostGIS
@postgis
St Louis @PostGIS Day 2019 is 2019/11/14 at T-Rex, with special guest @pwramsey. info.crunchydata.com/postgis-day-by-crunchy-data
-
PostGIS reposted
Hector Castro 🍮😎
@hectcastro
For anyone curious about the implementation details, this is currently powered by ST_AsMVT via PostgreSQL and PostGIS 2.4. In other words, PostgreSQL is baking the facilities vector tiles for us.
-
PostGIS reposted
RustProof Labs 🐘
@RustProofLabs
I just noticed the "Spatial" results (on the left, with Grid and Text) will display results from multiple spatial columns in different colors! 😁
Well played, @dbeaver_news, well played!
@PostGIS @PostgreSQL -
PostGIS
@postgis
Shout out to @PostGIS :) www.infoq.com/articles/postgres-handles-more-than-you-think/
-
PostGIS
@postgis
PostGIS 3.0.0beta1 dlvr.it/RF6936
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
GDAL 3.0.1 is about to land to #postgresql #yum repository in a few days. OGDI 4.1.0 will follow soon, so that the #gis components will use the latest and greatest.
#postgis -
PostGIS
@postgis
QGIS Plugin Development: Getting Started dlvr.it/RCZZyS
-
PostGIS
@postgis
Serving Mapbox Vector Tiles with PostGIS, Nginx and Python Backend dlvr.it/RCZZyM
-
PostGIS
@postgis
Using pg_upgrade to upgrade PostGIS without installing an older version of PostGIS www.bostongis.com/blog/index.php?%2Farchives%2F268-Using-…
-
PostGIS
@postgis
Waiting for PostGIS 3: ST_AsMVT Performance blog.cleverelephant.ca/2019/08/postgis-3-mvt.html
-
PostGIS
@postgis
Waiting for PostGIS 3: Hilbert Geometry Sorting blog.cleverelephant.ca/2019/08/postgis-3-sorting.html
-
PostGIS
@postgis
Waiting for PostGIS 3: ST_AsGeoJSON(record) dlvr.it/RCQ1ND
-
PostGIS
@postgis
pgAdmin4 now offers PostGIS geometry viewer dlvr.it/RBl35P
-
PostGIS
@postgis
New in QGIS 3.2 Save Project to PostgreSQL www.bostongis.com/blog/index.php?%2Farchives%2F271-New-in…
-
PostGIS
@postgis
Coming PostGIS 2.5 ST_OrientedEnvelope www.bostongis.com/blog/index.php?%2Farchives%2F270-Coming…
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Paul Ramsey (@pwramsey): Waiting for PostGIS 3: Parallelism in PostGIS postgr.es/p/4yJ
-
PostGIS reposted
(((TheSteve0))) @TheSteve0@data-folks.masto.host
@TheSteve0
More goodness from @pwramsey where he talks about @postgis raster getting it's very own extension and shows what mid range sea level rise would do to vancouver
info.crunchydata.com/blog/waiting-for-postgis-3-separate-… -
PostGIS
@postgis
PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 Released dlvr.it/RB2jC1
-
PostGIS reposted
Astrid Emde 🇺🇦
@astroidex
Do not forget to book a workshop at #foss4g 2019!
#postgresql/#postgis for Beginner
@astroidex @mapwebbing will give you an introduction to the power of PostgreSQL & PostGIS.
2019.foss4g.org/schedule/workshops/ -
PostGIS reposted
Koko Alberti
@kokoalberti
Update on my PostGIS Baselayers project: kokoalberti.com/articles/postgis-baselayers-importing-pop… and new version up on Github: github.com/kokoalberti/postgis-baselayers
-
PostGIS
@postgis
Simple SQL GIS blog.cleverelephant.ca/2019/07/simple-sql-gis.html
-
PostGIS
@postgis
PostGIS Overlays blog.cleverelephant.ca/2019/07/postgis-overlays.html
-
PostGIS reposted
Anne van der Veen
@veenspace
Figured out how to use Delaunay triangles with #postgis today! Making a map Rijksdriehoekenstelsel:
-
PostGIS reposted
FOSS4G:UK 2024 South West
@foss4guk
For #foss4guk2019, we've received a generous sponsorship to help widen participation with a particular emphasis on enabling parents, who otherwise might not be able to attend, to come along.
If you could fill out our quick survey, it would really help: foss4guk2019.typeform.com/to/XoVLSV -
PostGIS reposted
PostgresOpen
@PostgresOpen
"Put some 'where' in your WHERE clause" with @pwramsey from @crunchydata & co-founder of @postgis in his presentation regarding #geospatial #postgresql from PostgresOpen 2018. Watch here:
www.youtube.com/watch?v=ZCodEn4EZdw&list=PLN8NEqxwuywTzv6…
#opensource #postgres #learntocode #developer #devops #tech #sql -
PostGIS
@postgis
PostGIS 3.0.0alpha3 postgis.net/2019/07/01/postgis-3.0.0alpha3
-
PostGIS
@postgis
Tracing golden monkeys through time smathermather.com/2019/06/28/tracing-golden-monkeys-throu…
-
PostGIS reposted
Kurt Menke - @geomenke.bsky.social
@geomenke
After all these are just tools. Why limit your students to a single suite? In my experience, incorporating PostGIS, Spatial SQL, QGIS & GeoServer alongside with Esri tools provides students a much better geospatial education. BTW...This book was written for exactly this purpose.
-
PostGIS reposted
Andrea Borruso
@aborruso
“Creating your own reverse geocoder with OSM and PostGIS” www.stevegattuso.me/2019/05/29/postgis-reverse-geocoder.html
-
PostGIS reposted
(((TheSteve0))) @TheSteve0@data-folks.masto.host
@TheSteve0
Hey friendly folks - curious about @tableau? Love @postgis? Well have I got a blog post for you!
www.tableau.com/about/blog/2019/6/how-combine-postgis-and…
//CC @crunchydata -
PostGIS reposted
PostgreSQL
@PostgreSQL
News: PostgreSQL 11.4, 10.9, 9.6.14, 9.5.18, 9.4.23, and 12 Beta 2 Released! www.postgresql.org/about/news/1949/
-
PostGIS reposted
𝕯𝖊𝖓𝖓𝖎𝖘 𝕭𝖆𝖚𝖘𝖟𝖚𝖘
@DBauszus
Drawing and editing geometries from a #mvt layer with @OpenLayers 5. 🗺️ Vector tiles being created and cached in @PostGIS through the #xyz middleware. Look ma, no #wfs or #geoserver required.
👉medium.com/@goldrydigital/drawing-and-editing-geometries-… -
PostGIS reposted
-
PostGIS reposted
Sarah Battersby
@mapsOverlord
Dynamic routing between locations in Tableau? Yeah, it's possible. You just need a little @postgis and @pgrouting and some sweet @tableau Parameter Actions (the gory details are here: tabsoft.co/2WrTO4X )
-
PostGIS
@postgis
Parallel PostGIS and PgSQL 12 (2) dlvr.it/R6DZbb
-
PostGIS
@postgis
A Beginner’s Guide to… Bulk Database Updates with FME fme.safe.com/blog/2018/10/beginners-database-updates-evan…
-
PostGIS
@postgis
PostGIS 3.0.0alpha2 postgis.net/2019/06/02/postgis-3.0.0alpha2
-
PostGIS
@postgis
Parallel PostGIS and PgSQL 12 dlvr.it/R5XK9C
-
PostGIS
@postgis
PostGIS 3.0.0alpha1 postgis.net/2019/05/26/postgis-3.0.0alpha1
-
PostGIS
@postgis
. @pwramsey at @geodcmeetup earlier this year www.youtube.com/watch?v=v9MA9KaNzoM
-
PostGIS
@postgis
Movement data in GIS #23: trajectories in context anitagraser.com/2019/05/22/movement-data-in-gis-23-trajec…
-
PostGIS reposted
Koko Alberti
@kokoalberti
Side project: PostGIS-Baselayers. Simple web app to automagically download and import popular vector datasets (Natural Earth, Geonames, GADM, etc) into a PostGIS database at the click of a button. github.com/kokoalberti/postgis-baselayers (cc @postgis @OSGeo)
-
PostGIS
@postgis
Keynote @ FOSS4G NA 2019 dlvr.it/R4wKl7
-
PostGIS reposted
Rémi Bovard
@RemiBovard
No more reason to stay on #pgadmin to administer @postgis databases, @dbeaver_news now displays all geometries regardless of the projection on an #osm background! dbeaver.io
-
PostGIS reposted
HackerNoon | Learn Any Technology
@hackernoon
"Building a Pincode Mapper and Routing engine with Postgis and pgrouting" hackernoon.com/building-a-pincode-mapper-and-routing-engi… #maps #gis
-
PostGIS
@postgis
Lazyweb: Do you know about PostGIS use in the FAA? Please DM me, I am collecting government case studies.
-
PostGIS
@postgis
Movement data in GIS #10: open tools for AIS tracks from marinecadastre.gov dlvr.it/R2m2CV
-
PostGIS
@postgis
QGIS Plugin Development: Getting Started dlvr.it/R2m2CP
-
PostGIS
@postgis
Serving Mapbox Vector Tiles with PostGIS, Nginx and Python Backend www.zimmi.cz/posts/2017/serving-mapbox-vector-tiles-with-…
-
PostGIS
@postgis
The One About PostGIS dlvr.it/R1nzGq
-
PostGIS
@postgis
GeoJSON Features from PostGIS dlvr.it/R1h7XL
-
PostGIS
@postgis
Notes for FDW in PostgreSQL 12 dlvr.it/R1c2xV
-
PostGIS
@postgis
PGConf US 2019 Data Loading Slides up www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS
@postgis
PostGIS functions in GraphQL (it’s an API for web services) blog.hasura.io/native-support-for-postgis-topology-operat…
-
PostGIS
@postgis
PostGIS 2.5.2, 2.4.7, 2.3.9 Released dlvr.it/R0dGMc
-
PostGIS
@postgis
ST_PointOnSurface will be as fast as (faster) than ST_Centroid when GEOS 3.8 is released lin-ear-th-inking.blogspot.com/2019/02/betterfaster-stpoi…
-
PostGIS
@postgis
Proj6 in PostGIS dlvr.it/QzVB5T
-
PostGIS reposted
Artlembo
@artlembo
I just got my students working on a multi-user, simultaneous digitizing project using @postgis and @qgis. Super easy to do, and I explained how to do it with an 8 minute video. Great way to teach your students new things: artlembo.com/2019/02/21/multiuser-editing/
-
PostGIS reposted
RustProof Labs 🐘
@RustProofLabs
Excited to speak about @PostGIS and @openstreetmap at @postgresconf next month! Lucky for me, counting down is a simple query... @amplifypostgres
postgresconf.org/conferences/2019/program/proposals/right… -
PostGIS
@postgis
Better and Faster Interior Point for Polygons in JTS/GEOS
lin-ear-th-inking.blogspot.com/2019/02/better-and-faster-… -
PostGIS
@postgis
Compiling http extension on ubuntu 18.04 www.postgresonline.com/journal/index.php?%2Farchives%2F39…
-
PostGIS
@postgis
PostGIS for data driven organizing medium.com/civis-analytics/now-available-on-civis-platfor…
-
PostGIS
@postgis
Dr. JTS comes to Crunchy dlvr.it/Qy9Cn2
-
PostGIS
@postgis
The next PGConf APAC will be held from 19th – 21st March, 2019 in Singapore. 2019.pgconfapac.org
-
PostGIS reposted
Sarah Battersby
@mapsOverlord
No wkt directly yet, but we do have a prerelease you can try with PostGIS support. Just use a Geometry or Geography column and skip the hassle of exporting to geojson ... prerelease.tableau.com/key/3b4027a799c74d4cb95fef678cddb931
-
PostGIS reposted
Javier de la Torre
@jatorre
Congrats to the @citusdata team on their acquisition by @Microsoft! This is great news for PostgreSQL and therefore PostGIS too. www.citusdata.com/blog/2019/01/24/microsoft-acquires-citu…
-
PostGIS reposted
Chinigo
@MichaelChinigo
PostGIS, a love story, con't.
We now have good 2D paths for all the aqueducts in the NYC water supply system, and we'd like to generate elevation profiles for each of them, like this.
We'll need to calculate a few things. -
PostGIS
@postgis
PostGIS @ UK Ordnance Survey osgeouk.github.io/pgday/assets/postgis_day_tjmartin.pdf
-
PostGIS reposted
Paul Rossman
@p7_stats
Related to my last tweet, new blog post: An Introduction to PostGIS (with a use case in QGIS)
cc: @datakmart, @mapsOverlord
p7stats.wordpress.com/2019/01/19/an-introduction-to-postg… -
PostGIS
@postgis
Update your links, this is where the “Intro to PostGIS” workshop lives from now on: postgis.net/workshops/postgis-intro/
-
PostGIS reposted
OSGeo US
@OSGeoUS
We are truly fortunate to have @CrunchyDB as a GOLD #sponsor for #fedgeoday. They are a powerful force for #oss and #postgis. They will also be doing a panel on whats hot in Geospatial Open Source. www.fedgeo.us
-
PostGIS
@postgis
Interesting email for those working with large topology problems lists.osgeo.org/pipermail/postgis-users/2019-January/0431…
-
PostGIS reposted
Daniel Aragon
@DanielA88729076
“Why should you care about PostGIS? — A gentle introduction to spatial databases” by @tjukanov link.medium.com/NRUUaAhrqT
-
PostGIS reposted
Chinigo
@MichaelChinigo
Progress report:
- Calculate sum of watersheds for all streams entering a body of water.
- Iterate over all NYC reservoirs.
- Store everything in PostGIS to simplify composition, after getting GRASS to talk to Postgres.
It comes out pretty well! Compare against the DEM's map. -
PostGIS
@postgis
Using pg_upgrade to upgrade PostgreSQL 9.3 PostGIS 2.1 to PostgreSQL 11 2.5 on Yum www.bostongis.com/blog/index.php?%2Farchives%2F273-Using-…
-
PostGIS
@postgis
CentOS PostGIS Upgrade Hell… Yet Again dlvr.it/Qtx18Y
-
PostGIS
@postgis
PostGIS 2.5.1 Bundle for Windows dlvr.it/QtDsST
-
PostGIS reposted
𝕯𝖊𝖓𝖓𝖎𝖘 𝕭𝖆𝖚𝖘𝖟𝖚𝖘
@DBauszus
Dynamic @mapbox vector tiles #mvt. Created and cached in @PostGIS with @GEOLYTIX 🌍XYZ platform. Built with @fastifyjs 🐯 , cloud hosted on @zeithq ⚡️. Read all about it. 👉medium.com/@goldrydigital/xyz-dynamic-vector-tiles-create… 🔥🔥🔥
-
PostGIS
@postgis
Implementing Linked List with PostgreSQL Recursive CTE dlvr.it/Qs9pGH
-
PostGIS
@postgis
PostGIS 2.3.8, 2.4.6 dlvr.it/Qs2Tj6
-
PostGIS
@postgis
PostGIS 2.2.8 EOL dlvr.it/QrtXMM
-
PostGIS
@postgis
PostGIS 2.5.1 dlvr.it/QrYYPY
-
PostGIS
@postgis
Spatial Representation of a Communications Pit dlvr.it/QrRcdK
-
PostGIS
@postgis
PostGIS: Creating a line inside a polygon dlvr.it/QrP5Vl
-
PostGIS
@postgis
Martin, the MVT server for PostGIS github.com/urbica/martin
-
PostGIS
@postgis
Howard Hughes Medical Institute postgis.net/2018/11/03/howard_hughes
-
PostGIS
@postgis
Vanguard Appraisals dlvr.it/QqNNf5
-
PostGIS reposted
UKTechEvents
@UKTechEvents
Oct 25 - thinkWhere: PostGIS User (Training) An introductory course for those wanting to learn how to load and manage spatial data within PostGIS (PostgreSQL spatial extension). Topics cover geometries, projections, loading data, spatial que... twib.in/l/ABng8aEb85Lq #uk #event
-
PostGIS reposted
Cartoview
@CartoView
try github.com/cartologic/fgdb2postgis to convert ESRI fgdb to PostGIS maintaining domains and subtypes
-
PostGIS
@postgis
A Beginner’s Guide to… Bulk Database Updates with FME dlvr.it/QpRrbG
-
PostGIS
@postgis
Submit your abstract to FOSS4G-NA in San Diego! www.papercall.io/fossa4gna2019
-
PostGIS
@postgis
. @artlembo is crushing his big data with @postgis artlembo.com/2018/10/16/bigdataresults/
-
PostGIS
@postgis
French Ministry in charge of the ecological transition selected Oslandia oslandia.com/en/2018/10/15/french-ministry-in-charge-of-t…
-
PostGIS
@postgis
PostGIS Code Sprint 2018 #2 dlvr.it/Qlykrv
-
PostGIS
@postgis
PostGIS Code Sprint 2018 #1 blog.cleverelephant.ca/2018/09/postgis-sprint-1.html
-
PostGIS
@postgis
5x Faster Spatial Join with this One Weird Trick dlvr.it/Qlh1g0
-
PostGIS
@postgis
PostGIS 2.5.0 postgis.net/2018/09/23/postgis-2.5.0
-
PostGIS
@postgis
PostGIS 2.5.0rc2 dlvr.it/QkQZqB
-
PostGIS
@postgis
PGAdmin Finally Has A Spatial Viewer dlvr.it/Qk6qxN
-
PostGIS reposted
PostgreSQL
@PostgreSQL
When you create and use an index @postgresql, what is the database actually doing? @louisemeta's presentation explains how each index works, with a crocodile there to help tell the story: www.slideshare.net/LouiseGrandjonc/indexes-in-postgres
-
PostGIS
@postgis
PostGIS Patch Release 2.4.5 postgis.net/2018/09/12/postgis-2.4.5
-
PostGIS
@postgis
Parallel PostGIS and PgSQL 11 blog.cleverelephant.ca/2018/09/parallel-postgis-3.html
-
PostGIS
@postgis
PGOpen 2018 Data Loading Presentation Slides dlvr.it/QjbDxP
-
PostGIS
@postgis
pgAdmin4 now offers PostGIS geometry viewer dlvr.it/Qjb5By
-
PostGIS
@postgis
Moving on to CrunchyData blog.cleverelephant.ca/2018/09/crunchydata.html
-
PostGIS
@postgis
PostGIS 2.5.0rc1 dlvr.it/QgRCQD
-
PostGIS reposted
Chris Whong
@chris_whong
If you use @postgis and have web dev skills, we could use your help on postgis-preview. github.com/NYCPlanning/labs-postgis-preview/issues/86
-
PostGIS reposted
Pano Voudouris
@the_mapoholic
Offset points in #mapserver and #postgis #linear referencing mapoholic.wordpress.com/2018/08/18/offset-points-in-mapse…
-
PostGIS
@postgis
PostGIS 2.5.0beta2 dlvr.it/QfXj3P
-
PostGIS
@postgis
How to apply spatial constraints to PostGIS tables [2] dlvr.it/QdfF0F
-
PostGIS reposted
Gregers H. Petersen
@GregersP
See how @nycplanninglabs is using my colleague, @bjornharrtell s, PostGIS-function for a quick implementation of a vector tile service. medium.com/nycplanninglabs/using-the-new-mvt-function-in-…
-
PostGIS
@postgis
Movement data in GIS #15: writing a PL/pgSQL stop detection function for PostGIS trajectories anitagraser.com/2018/07/19/movement-data-in-gis-15-writin…
-
PostGIS reposted
Artlembo
@artlembo
I'm getting ready to put together an Advanced Spatial SQL course for @postgis. I'd like to make this course user-derived. So, please let me know your requests - I'm hoping for 100 ideas....
docs.google.com/forms/d/e/1FAIpQLSdueffRnRyL3JfuGURxt3QlZ… -
PostGIS
@postgis
Using procedures for batch geocoding and other batch processing dlvr.it/QZvfYM
-
PostGIS
@postgis
Many thanks to OSGeo and osgeo.uk for sponsoring the PostGIS code sprint. Still looking for a few more (corporate?) sponsors to defray developer travel costs. trac.osgeo.org/postgis/wiki/PostGISCodeSprint2018
-
PostGIS
@postgis
Pros and cons of ST_Simplify() blog.rustprooflabs.com/2018/07/postgis-tame-your-data
-
PostGIS
@postgis
PostGIS 2.5.0beta1 dlvr.it/QZN9gB
-
PostGIS reposted
Harukasan's RSS
@harukasan_rss
How postgis changed the insurance market in Brazil speakerdeck.com/arturcp/how-postgis-changed-the-insurance…
-
PostGIS reposted
Anwar Sounny-Slitine
@sounny
How to explain PostGIS to a Postgres user.
-
PostGIS reposted
Derrick Reimer
@derrickreimer
💡Did you know you can use regular expressions to extract substrings from columns in Postgres?
This example pulls the domain part out of an email address column. -
PostGIS
@postgis
New in QGIS 3.2 Save Project to PostgreSQL www.bostongis.com/blog/index.php?%2Farchives%2F271-New-in…
-
PostGIS
@postgis
PostGIS Polygon Splitting dlvr.it/QYBVPr
-
PostGIS
@postgis
Coming PostGIS 2.5 ST_OrientedEnvelope dlvr.it/QXl0JX
-
PostGIS reposted
Sanghee Shin
@endofcap
Getting started with @postgis (Korean version)!
www.slideshare.net/ybh0616/postgis-101511460 -
PostGIS
@postgis
PostgresVision 2018 Slides and Impressions dlvr.it/QWjbxP
-
PostGIS reposted
Étienne BERSAC
@EtienneBersac
@postgis , l'incroyable extension qui innove en s'appuyant sur les fondations solide de #postgres. #pgcon Pas besoin de réinventer la concurrence, la réplication, etc. Bien joué !
-
PostGIS
@postgis
PostGIS 2.5.0alpha dlvr.it/QVQ3C8
-
PostGIS reposted
Joseph Conway
@jconway
My slides from #foss4gna are available here: www.joeconway.com/presentations/plr-spatial-FOSS4GNA-2018… @rstatsbot1234 @postgresql @postgis
-
PostGIS reposted
David Bitner
@bitnerd
Slides for my #foss4gna talk on working with temporal data in postgis/postgresql available at docs.google.com/presentation/d/1E3CtVTCFNYRUyYkvvGA-AW7v0… video from when I presented at #foss4g in BOS at vimeo.com/246143260
-
PostGIS
@postgis
PostGIS Talks @ FOSS4G North America dlvr.it/QSyvMH
-
PostGIS
@postgis
Movement data in GIS #12: Why you should be using PostGIS trajectories dlvr.it/QPlXyn
-
PostGIS reposted
Artlembo
@artlembo
Here is a quick 8 minute video demonstrating 6 different ways of getting spatial data into @postgis : PGAdmin III, ogr2ogr, shp2pgsql, @qgis database manager, Manifold 8, and Manifold 9. Hope you enjoy it. artlembo.com/2018/04/11/56-ways-to-get-data-into-postgres…
-
PostGIS reposted
Mike Miller
@millermountainl
Learn how to deploy your PostGIS database to a hosting service for only a few dollars/month #gis #postgis... youtu.be/Ze3ykLHqUiU?a
-
PostGIS reposted
Charlie Roscoe, PhD
@CharlieJRoscoe
Today I'm updating a GIS for Public Health @postgis tutorial on ethnicity mapping with Bristol data ✅ Sign up here: www.imperial.ac.uk/school-public-health/study/short-cours…
-
PostGIS
@postgis
PostgreSQL Backup and Recovery Orchestration: systemd Automation dlvr.it/QP2j4B
-
PostGIS
@postgis
PostGIS Patch Releases 2.2.7, 2.3.7, and 2.4.4 dlvr.it/QNcCY7
-
PostGIS reposted
Jeff Piestrak (on Mastodon at social.coop/@jeff)
@Jeff_Piestrak
Great technical overview of free & #opensource software (#foss) @nycplanninglabs using to power sophisticated tools like zola.planning.nyc.gov
Lots to learn from as we implement our #postgis #geoserver @GeoBlacklight stack supporting fellow New Yorkers @ cugir.library.cornell.edu
NYC Planning Tech
@NYCPlanningTech
Fresh Blog: Our Modern FOSS Spatial Stack.
See how me make beautiful functional web mapping apps with the latest geo tools medium.com/nycplanninglabs/our-modern-foss-spatial-stack-… #gistribe -
PostGIS
@postgis
Leveraging the Power of Spatial Databases from @johnjreiser njgeo.org/2018/03/07/leveraging-the-power-of-spatial-data…
-
PostGIS
@postgis
Patching Plain PostgreSQL for Parallel PostGIS Plans carto.com/blog/inside/postgres-parallel/ #postgresql #postgis
-
PostGIS
@postgis
PostgreSQL Backup and Recovery Orchestration: Bash Automation www.zimmi.cz/posts/2018/postgresql-backup-and-recovery-or…
-
PostGIS
@postgis
PostgreSQL in Italiano? Si! 2018.pgday.it/en/
-
PostGIS reposted
Joseph Conway
@jconway
Hope to see you in St. Louis! 2018.foss4g-na.org/node/2736
@postgresql @postgis #rstats -
PostGIS
@postgis
Interesting use case! Storing colors in HSV might result in better “nearest color” search.
Duncan Crombie
@theartofweb
New Article: Storing and comparing colors with PostGIS: www.the-art-of-web.com/sql/postgis-compare-colors/
-
PostGIS reposted
Jakob Miksch
@JakobMiksch
"PostGIS in Action" by @reginaobe and Leo S. Hsu is such a nicely written book 📖 - using @postgis brings "GIS" to the next level
www.manning.com/books/postgis-in-action-second-edition -
PostGIS reposted
-
PostGIS
@postgis
Database migrations and Pum oslandia.com/en/2018/02/23/database-migrations-and-pum/
-
PostGIS reposted
CARTO
@CARTO
As part of our #spatial Data Science Conference, CARTO Solutions Engineer @pwramsey dives into scaling PostgreSQL and PostGIS vimeo.com/250498574
-
PostGIS
@postgis
UK open sorcerer? Go to foss4g.uk, perhaps? Tell your friends. uk.osgeo.org/foss4guk2018/foss4guk2018-agenda.pdf uk.osgeo.org/foss4guk2018/
-
PostGIS
@postgis
PostgreSQL Backup and Recovery Orchestration: Recovery dlvr.it/QGytgg
-
PostGIS reposted
Zev Ross
@zevross
Here's a spatial analysis example with #rstats -- data from PostGIS + tabular, simplify, project and map with mapview. Using poverty data. I put code and links in a gist: gist.github.com/zross/857978baba866f7894cc3fbe2fa52868
-
PostGIS
@postgis
FDWS for PostgreSQL Windows 32 and 64-bit www.postgresonline.com/journal/index.php?%2Farchives%2F38…
-
PostGIS
@postgis
Installing pgTap in windows with msys2 and mingw64 dlvr.it/QGQVP1
-
PostGIS
@postgis
Dollar-quoting for escaping single quotes dlvr.it/QGQVNm
-
PostGIS
@postgis
I pronounce PostGIS …
-
PostGIS reposted
Liz Scott
@birdmaps
Developer role building spatial data infrastructures for use in nature and social research: WebGIS/ #python developer at Norwegian Institute for Nature Research #foss4g #geoserver #postgis #gisjobs www.nina.no/english/News/News-article/ArticleId/4427/Spen…
-
PostGIS
@postgis
PostgreSQL Backup and Recovery Orchestration: WAL Archiving dlvr.it/QG2WBm
-
PostGIS reposted
Dave Jenkins
@davejenk1ns
Some great insight on managing PostGIS data with clustering:
www.endpoint.com/blog/2018/02/08/regionating-with-postgis -
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Craig Kerstiens (@craigkerstiens): How Citus rebalances your data postgr.es/p/40O
-
PostGIS reposted
Alexandre Neto
@AlexNetoGeo
Do you use #postgis on Windows? For free? Did you know that you can positively impact the PostGIS project and those who take care of it for you. Consider being Regina Obe patreon www.patreon.com/reginaobe and let her do her thing :-)
-
PostGIS reposted
Craig Kerstiens
@craigkerstiens
Whats your favorite hidden gem of Postgres that you wish more people knew about?
-
PostGIS reposted
PostgreSQL
@PostgreSQL
Looking to get into spatial analytics? This post helps get you started with PostGIS and R: info.crunchydata.com/blog/spatial-analytics-with-postgres…
-
PostGIS reposted
PostgreSQL
@PostgreSQL
Ever wonder how to get the definition of a view (or a materialized view) in @postgresql ? Check out pg_get_viewdef(), one of the many system information functions available- all documented here: www.postgresql.org/docs/current/static/functions-info.html
-
PostGIS reposted
Bill Dollins
@billdollins
We are standardized on PostGIS at @spatialnetworks
-
PostGIS reposted
thinkWhere (an Idox Company)
@thinkWhere1
If you're interested in learning @postgis , our next training courses are running on 15th and 16th February in Stirling, Scotland (PostGIS User and PostGIS Admin). Enquiries to info@thinkwhere.com #skillsdevelopment #learn #retrain #opensource #technology
-
PostGIS
@postgis
PostGIS Patch Releases 2.3.6 and 2.4.3 dlvr.it/QBY38K
-
PostGIS reposted
PostgresWorld
@PostgresWorld
. @BAESystemsInc seeking Senior Database Developer to work in Durham, NC w/ #postgresql & #postgis data store for geospatial trajectory data (MOVINT).
For more info and to apply:
jobs.baesystems.com/global/en/job/BAE1US1843/Senior-Datab… @amplifypostgres -
PostGIS reposted
Abel Vázquez Montoro
@abel_vm
Some real-life tips&tricks for #postgresql and @postgis using little-known features abelvm.github.io/sql/sql-tricks/ #spatial #gis #postgis
-
PostGIS reposted
Mayra Zurbarán
@mazucci
Packt's $5 sale is now on! Grab my @packtpub book PostGIS Cookbook, Second Edition for just $5 at www.packtpub.com/application-development/postgis-cookbook…
-
PostGIS reposted
spiros mousouris
@SpirosMousouris
#postgis #newbie ? Check this out . Trust me. workshops.boundlessgeo.com/postgis-intro/
-
PostGIS
@postgis
PostGIS Scaling dlvr.it/Q60sh8
-
PostGIS reposted
Topi Tjukanov
@tjukanov
Doing my first tests with the Danish AIS marine data and cleaning it up in PostGIS. This will probably look pretty nice animated...
-
PostGIS reposted
Matthias Kuhn
@_mkuhn
@postgis on @Raspberry_Pi a nice geek moment for a friday 🤓
-
PostGIS
@postgis
PostGIS "Fund Me" Milestone dlvr.it/Q4gzd3
-
PostGIS
@postgis
QGIS Plugin Development: Testing Your Code dlvr.it/Q3gJjZ
-
PostGIS reposted
Yann Kacenelen
@ykacenelen
BD UNI = base de données pivot des productions de @IGNFrance. 150 millions d'objets, 400 Go stockés dans @planetpostgres @postgis. Sont dérivées de la BD UNI : BD TOPO et BD ADRESSE.
#géoSDIS -
PostGIS
@postgis
Nested Loop Join with FDW blog.cleverelephant.ca/2017/11/fdw-nested-loop.html
-
PostGIS
@postgis
QGIS Plugin Development: AttributeTransfer Plugin www.zimmi.cz/posts/2017/qgis-plugin-development-attribute…
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
If you are a @Postgis user on Red Hat / CentOS, I need your help testing the new packages. Due to nature of RHEL/CentOS, GeOS and Proj versions are too old. Instead, I now pushed custom proj49, geos36 and new PostGIS 2.4 RPMs to PGDG 10 *Testing* repo: yum.postgresql.org/testing/10/fedora/fedora-27-x86_64/rep…
-
PostGIS reposted
CARTO
@CARTO
Read how #postgis day was celebrated last week at CARTO in the post below:
carto.com/blog/inside/postgis-day/ -
PostGIS reposted
Evan Carroll
@TheEvanCarroll
PostgreSQL calculates on a sphere using the average mean radius of the WGS84 reference ellipsoid. MySQL uses a total random value that originates from a constant in PostgreSQL 20 years ago. gis.stackexchange.com/q/262457/6052 #postgis #postgresql #mysql
-
PostGIS reposted
Micho Garcia
@michogar
#postgis Raster workshop #sasig2017
-
PostGIS
@postgis
Happy PostGIS Day 2017 dlvr.it/Q1Lb8x
-
PostGIS
@postgis
QGIS Plugin Development: Creating GUI with Qt Designer dlvr.it/Q1H9KW
-
PostGIS reposted
💧 Tim Bowden
@tim_bowden
So my #postgisday effort went much better than I feared, less than I would have liked. Taste test later this morning.
-
PostGIS
@postgis
PostGIS Patch Releases postgis.net/2017/11/15/postgis-patches
-
PostGIS reposted
Abel Vázquez Montoro
@abel_vm
Using PostGIS for isovists calculation abelvm.github.io/sql/isovists/
-
PostGIS reposted
@chrismarx@mapstodon.space @chris-marx.bsky.social
@chrismarx
And done. Look ma no tileserver! These are California water boundaries-
-
PostGIS
@postgis
QGIS Plugin Development: Finding Nearest Neighbors dlvr.it/Q03G4c
-
PostGIS
@postgis
QGIS Plugin Development: Getting Started dlvr.it/PzsSxq
-
PostGIS
@postgis
Serving Mapbox Vector Tiles with PostGIS, Nginx and Python Backend dlvr.it/PzsSxm
-
PostGIS
@postgis
PostgreSQL Dollar Quoting inside Bash Heredoc dlvr.it/PzsSxk
-
PostGIS
@postgis
PostgreSQL Development History Revealed with PostgreSQL dlvr.it/PzsSxc
-
PostGIS
@postgis
PostGIS as a Mapbox Vector Tiles generator www.zimmi.cz/posts/2017/postgis-as-a-mapbox-vector-tiles-…
-
PostGIS
@postgis
Fighting Raster GeoPackage with GDAL dlvr.it/PzsSx6
-
PostGIS
@postgis
Mapping North America with QGIS: Tips and Tricks www.zimmi.cz/posts/2017/mapping-north-america-with-qgis-t…
-
PostGIS
@postgis
Routing with GRASS GIS: Catchment Area Calculation dlvr.it/PzsSn6
-
PostGIS
@postgis
Exploiting Prague Open Data without API www.zimmi.cz/posts/2017/exploiting-prague-open-data-witho…
-
PostGIS
@postgis
Move PostGIS extension to a different schema dlvr.it/Pzmk49
-
PostGIS
@postgis
Parallel PostGIS IIA dlvr.it/PzZWfC
-
PostGIS reposted
javi santana
@javisantana
postgis performance blogpost by @pwramsey => carto.com/blog/inside/postgis-performance/
-
PostGIS
@postgis
Parallel PostGIS II dlvr.it/PyZ6Q2
-
PostGIS
@postgis
Movement data in GIS #10: open tools for AIS tracks from marinecadastre.gov dlvr.it/Py2WzP
-
PostGIS
@postgis
160TB @PostGIS database @TomTom, wow! www.postgresql.eu/events/sessions/pgconfeu2017/session/16…
-
PostGIS
@postgis
Amazon Aurora supports @PostGIS aws.amazon.com/blogs/aws/now-available-amazon-aurora-with…
-
PostGIS reposted
Evan Carroll
@TheEvanCarroll
Just read @pwramsey's blog entry on sorting and equality in PostGIS 2.4. Great read! blog.cleverelephant.ca/2017/09/postgis-operators.html #gis #postgis #postgresql
-
PostGIS
@postgis
PostGIS Patch Releases dlvr.it/PwNyTz
-
PostGIS reposted
Mike Miller
@millermountainl
What can a spatial database do for you? #gis #postgis @gis_sharer #geospatial #mapping #gistribe millermountain.com/geospatialblog/2017/10/18/spatial-data…
-
PostGIS
@postgis
Using pg_upgrade to upgrade PostGIS without installing an older version of PostGIS dlvr.it/Pvf5vC
-
PostGIS
@postgis
Undo Redo stack is back QGIS Transaction groups dlvr.it/PtYtzM
-
PostGIS
@postgis
Refresh your maps FROM postgreSQL ! dlvr.it/PsyJRN
-
PostGIS
@postgis
PostgreSQL 10 is out! www.postgresql.org/about/news/1786/
-
PostGIS
@postgis
PostGIS 2.4.0 Released dlvr.it/PrR5MR
-
PostGIS reposted
-
PostGIS
@postgis
PostGIS 2.4.0rc3 Released dlvr.it/PqknVc
-
PostGIS
@postgis
PostGIS db help and manual in different languages dlvr.it/Pq5RC4
-
PostGIS
@postgis
PostGIS 2.4.0rc2 Released dlvr.it/Pq509r
-
PostGIS reposted
Felix Kunde
@FlxKu
My @PostGIS slide deck for @InsideIntergeo is ready slides.com/fxku/postgis2 Come to @OSGeo Park next week! @fossgis_eV
-
PostGIS
@postgis
PostGIS 2.1.9 Released postgis.net/2017/09/19/postgis-2.1.9
-
PostGIS
@postgis
PostGIS Operators in 2.4 blog.cleverelephant.ca/2017/09/postgis-operators.html
-
PostGIS
@postgis
PostGIS 2.4.0rc1 Released postgis.net/2017/09/13/postgis-2.4.0rc1
-
PostGIS
@postgis
Drive-time Isochrones from a single Shapefile using QGIS, PostGIS, and Pgrouting dlvr.it/PmKhKd
-
PostGIS
@postgis
PostGIS 2.4.0beta1 Released dlvr.it/PkLp3r
-
PostGIS
@postgis
geography type is not limited to earth dlvr.it/PgMtvx
-
PostGIS
@postgis
PostGIS 2.4.0alpha Released dlvr.it/Pc25p2
-
PostGIS
@postgis
BigSQL + PostGIS: Reprojecting Your Spatial Data with ST_Transform dlvr.it/PbkgPF
-
PostGIS reposted
US PostgreSQL Assoc.
@pgus
Visit us at @foss4g Aug 14-19, let's talk about @postgresql in addition to @postgis.
-
PostGIS
@postgis
Code Sprint in Boston after FOSS4G 2017 dlvr.it/Pb6yFq
-
PostGIS
@postgis
Using OSGeoLive with VirtualBox www.bostongis.com/blog/index.php?%2Farchives%2F264-Using-…
-
PostGIS
@postgis
PostGIS 2.3.3 is Now Available! dlvr.it/PYCwC6
-
PostGIS reposted
Transitional Justice Working Group 전환기 정의 워킹그룹
@TJWGSeoul
Thank you @QGIS @OSGeo @PostGIS @planetpostgres @openstreetmap and many more. Also, this could not happen w/o imagery from @googleearth TY!!
New York Times World
@nytimesworld
Maps seek to catalog the crimes of North Korea, pointing to places where executions and mass graves are suspected www.nytimes.com/2017/07/19/world/asia/north-korea-executi…
-
PostGIS reposted
PostgresConf
@postgresconf
Come check out "Attaching flexible metadata to geometries: marrying PostGIS and JSONB" by @dpdohler postgresconf.org/conferences/Philly2017/program/proposals… @amplifypostgres
-
PostGIS
@postgis
Setting Up LDAP with Active Directory in PostgreSQL dlvr.it/PV2fjJ
-
PostGIS
@postgis
Installing pgTap in windows with msys2 and mingw64 dlvr.it/PRxJ3q
-
PostGIS
@postgis
PostGIS 2.3.3 Released dlvr.it/PRVlYz
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Joshua Drake (@linuxhiker): Where is the Postgres community? postgr.es/p/3R-
-
PostGIS
@postgis
pgAdmin3 LTS Now Supports PostgreSQL 10 www.openscg.com/2017/06/pgadmin3-lts-now-supports-postgre…
-
PostGIS
@postgis
GDAL New Release 2.2 – BigSQL Makes it Easy to Install www.openscg.com/2017/06/gdal-new-release-2-2-bigsql-makes…
-
PostGIS
@postgis
Dollar-quoting for escaping single quotes dlvr.it/PN64d7
-
PostGIS
@postgis
Bruce Momjian on when to use db-side functions in your architecture: it depends. momjian.us/main/blogs/pgblog/2017.html
-
PostGIS
@postgis
Me and @geoserver on Azure, running government infra customers.microsoft.com/en-us/story/somersetcountycouncil
-
PostGIS
@postgis
Refreshing a PostGIS Materialized View in FME dlvr.it/PL3x5S
-
PostGIS
@postgis
OSGeo CS 2016 report : PostGIS oslandia.com/en/2016/03/16/osgeo-cs-2016-report-postgis/
-
PostGIS
@postgis
QGIS versioning plugin oslandia.com/en/2013/07/13/qgis-versioning-plugin/
-
PostGIS
@postgis
QGIS plugin for water management oslandia.com/en/2014/02/19/qgis-plugin-for-water-management/
-
PostGIS
@postgis
PostGIS 3D – Foss4g video and workshop dlvr.it/PKyfYp
-
PostGIS
@postgis
QGIS Community meeting in Brighton dlvr.it/PKyfXm
-
PostGIS
@postgis
Oslandia and Mappy towards OpenSource dlvr.it/PKyfWn
-
PostGIS
@postgis
Full Spatial database power in 2 lines dlvr.it/PKyfW3
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Holly Orr (@orrholly): The Easy Way to Setup PostgreSQL 10 Logical Replication postgr.es/p/3R9
-
PostGIS
@postgis
Working with Materialized Views in PostGIS dlvr.it/PKX1nh
-
PostGIS reposted
geoMusings
@geomusingsblog
Working with Materialized Views in PostGIS blog.geomusings.com/2017/06/06/working-with-materialized-…
-
PostGIS reposted
Devrim Gündüz
@DevrimGunduz
I also changed @postgis package naming in #postgresql #yum repo. Now it contains full version number: postgis22, postgis23.
-
PostGIS
@postgis
Geometry becomes invalid after a simple shift (black magic)
trac.osgeo.org/postgis/ticket/3768 -
PostGIS
@postgis
Causes for 'postgis.backend' is already set dlvr.it/PK52Xv
-
PostGIS
@postgis
Connecting to Remote Spatial Data Sources with ogr_fdw dlvr.it/PGxyLq
-
PostGIS reposted
Regina Obe
@reginaobe
Our @PGConfUS video on Top 10 Problems Solved by #postgis (@postgis) www.pgconf.us/conferences/2017/program/proposals/223
-
PostGIS
@postgis
Temporal Tables PostgreSQL Extension
github.com/arkhipov/temporal_tables -
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Dan Robinson: How Basic Performance Analysis Saved Us Millions postgr.es/p/3PE
-
PostGIS
@postgis
PostGIS 2.4.0, Code Sprints and other extensions to try with PostgreSQL 10 beta1 dlvr.it/PC194K
-
PostGIS reposted
ErikEJ
@ErikEJ
Announcing Azure Database for PostgreSQL Preview azure.microsoft.com/blog/announcing-azure-database-for-po…
-
PostGIS reposted
Cesar Rojas
@CesarDataTech
Looking forward to learning more how to run @postgis on a massively parallel #database.Wednesday,May 17 at 6:30pm PT www.youtube.com/watch?v=G0Gme954KVY
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Joe Conway (@jconway): Using R Analytic Functions in PostGIS postgr.es/p/3Ox
-
PostGIS
@postgis
ETL (Extract, Transform, Load) PostGIS Data with ogr2ogr dlvr.it/Nz0Tlh
-
PostGIS
@postgis
Slides from PGConfUS 2017 PostGIS talk dlvr.it/NpYxpH
-
PostGIS
@postgis
Google Cloud SQL for PostgreSQL supports PostGIS www.bostongis.com/blog/index.php?%2Farchives%2F260-Google…
-
PostGIS reposted
-
PostGIS
@postgis
PGConfUS 2017 Getting Stuff done in PostGIS www.bostongis.com/blog/index.php?%2Farchives%2F259-PGConf…
-
PostGIS
@postgis
Importing Shapefiles into PostGIS with shp2pgsql www.openscg.com/2017/03/importing-shapefiles-into-postgis…
-
PostGIS reposted
angelo arboleda
@ghelobytes
It's happening! PostgreSQL/PostGIS available on Google Cloud SQL!
cloud.google.com/sql/docs/postgres/extensions
#postgis #gcp #googlecloudplatform #gis -
PostGIS
@postgis
Clever Maps dlvr.it/NcCSnd
-
PostGIS
@postgis
OSGeo CS 2016 report : PostGIS dlvr.it/NcCSbh
-
PostGIS reposted
PostgresOpen
@PostgresOpen
Psst. Have you heard? PostgresOpen is coming to Silicon Valley this Sep. 6-8! Check out our new website: goo.gl/I42lVz #pgopen2017
-
PostGIS reposted
Joshua Chamberlain
@jchmbrln
Such a pretty sight. Parallelism in @postgresql 9.6 + @postgis lets me max out my 16-core @linode doing millions of proportional sums.
-
PostGIS reposted
Mike Foster
@mjfoster83
The first accepted @foss4g 2017 workshops are online. Submit your own until March 13! 2017.foss4g.org/workshops @qgis @postgis @OSGeo #rolling
-
PostGIS reposted
@rjhale1971@fosstodon.org
@rjhale
Have I mentioned we've got people coming from: Fla, Al, TN, and NC to this event wiki.osgeo.org/wiki/Knoxfoss4g20170519 #foss4g #qgis #postgis
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Joshua Drake (@pgconfus): Are you ready for Next-Generation Parallel Query? postgr.es/p/3M0
-
PostGIS reposted
Elizabeth Tulanowski
@hethbill
What can open source do for you? PostGIS Brown Bag+Hands-on Workshop. Tues. 2/28, CSU Morgan Library, 12-2pm,@Centroid_CSU @Spatial_Punk
-
PostGIS
@postgis
Taking Slices from LiDAR data: Part IX dlvr.it/NR4GML
-
PostGIS
@postgis
Taking Slices from LiDAR data: Part VIII dlvr.it/NQ8jN6
-
PostGIS
@postgis
Taking Slices from LiDAR data: Part VI dlvr.it/NNsQ2c
-
PostGIS reposted
pdxpug
@pdxpug
Are you ready for Just Enough PostGIS with @nixzusehen this Thursday? pdxpug.wordpress.com/2017/02/03/pdxpug-february-meeting-4/
-
PostGIS reposted
Björn Harrtell
@bjornharrtell
Happy to see my first significant contribution to #postgis, ST_AsMVT, now accepted for next version (2.4.0) - github.com/postgis/postgis/commit/fee914f1174c1ab6869fbc9…
-
PostGIS reposted
NRGS
@NorthRiverGeo
PostGIS and Me. www.northrivergeographic.com/archives/postgis-and-me
-
PostGIS
@postgis
PostGIS – How to create a Spatial Database with PGC Command Line dlvr.it/NLL7m5
-
PostGIS
@postgis
Are you a Yoda or a Diego? www.openscg.com/2017/02/are-you-a-yoda-or-a-diego/
-
PostGIS
@postgis
PostGIS 2.3.2 Released dlvr.it/NFV8Cg
-
PostGIS
@postgis
PostGIS 2.2.5 Released dlvr.it/NDz9P9
-
PostGIS
@postgis
Meilleurs vœux 2017 ! Best wishes for 2017 ! dlvr.it/NBKPSP
-
PostGIS
@postgis
LocationTech Tour 2016 dlvr.it/N7Xxlf
-
PostGIS reposted
PDAL
@pointcloudpipe
PDAL 1.4.0 is released. See github.com/PDAL/PDAL/releases/tag/1.4.0 for release notes and download at www.pdal.io/download.html
-
PostGIS
@postgis
PostgreSQL "Compatible" Aurora dlvr.it/MsJjyr
-
PostGIS
@postgis
LocationTech Tour 2016 dlvr.it/MrZlRY
-
PostGIS
@postgis
PostGIS 2.3.1 Released dlvr.it/MmBVMG
-
PostGIS
@postgis
PostGIS 2.2.4 Released postgis.net/2016/11/26/postgis-2.2.4
-
PostGIS reposted
Planet PostgreSQL
@planetpostgres
Regina Obe (@reginaobe): PostGIS 2.2.4 Released postgr.es/p/3Hb
-
PostGIS
@postgis
py3dtiles dlvr.it/MlXt2D
-
PostGIS
@postgis
ODBC FDW now supports 9.5 and 9.6 www.postgresonline.com/journal/archives/372-ODBC-FDW-now-…
-
PostGIS
@postgis
LOPoCS : Stream your Point Cloud from Postgis dlvr.it/MlXt20
-
PostGIS
@postgis
Rencontres QGIS utilisateurs les 1er et 2 décembre 2016 à Montpellier dlvr.it/MlXt0d
-
PostGIS
@postgis
Personal Geospatial Workflows, July 2016 Edition dlvr.it/MlXszS
-
PostGIS
@postgis
Extending Hibernate Spatial dlvr.it/MlXYm9
-
PostGIS
@postgis
PostgreSQL table drop — a little fun with ouroboros dlvr.it/MlXYgg
-
PostGIS reposted
Kasper Van Lombeek
@kvanlombeek
Why is postgis awesome? Slides of our #datascience talk at @DataScienceBe Antwerp. www.slideshare.net/kaspervanlombeek/why-is-postgis-awesome
-
PostGIS reposted
@delawen@floss.social
@delawen
-
PostGIS reposted
Pekka Sarkola
@posiki
#openstreetmap #geobeers in Helsinki #postgisday: www.facebook.com/events/591689511017587/ @postgis
-
PostGIS reposted
Pekka Sarkola
@posiki
#openstreetmap #postgisday activity tomorrow in #espoo: www.facebook.com/events/1788957704713332/ @postgis
-
PostGIS
@postgis
PostGIS Day in YYJ, beers and convos www.meetup.com/Victoria-GeoGeeks/events/235423953/
-
PostGIS reposted
Amazon Web Services
@awscloud
RDS PostgreSQL now supports 9.6.1! oak.ctx.ly/r/58e39 #cloudcomputing




































































































































































































































































