Elizabeth Garrett Christensen
@sqlliz.bsky.social
#Postgres @snowflake via @crunchydata.com. Board member @pgus.bsky.social. Co-host of #PostGIS day.
PostGIS tip: Get faster spatial queries and maps with st_simplfy. ⚡ When you don't need exact topology and want to make things faster and simpler, look at the ST_Simplify and ST_SimplifyPreserveTopology functions. Example in the video.
May 27, 2025 at 8:55 PM
PostGIS tip: Get faster spatial queries and maps with st_simplfy. ⚡ When you don't need exact topology and want to make things faster and simpler, look at the ST_Simplify and ST_SimplifyPreserveTopology functions. Example in the video.
Today I got to play around with @crunchydata.com's new data warehouse.
- connected to the entire world's building footprint data in
@overturemaps.bsky.social
- made a local table of tornado path data from FEMA
- joined them together
- set up a web browser to view the join with pg_tileserv
💥
- connected to the entire world's building footprint data in
@overturemaps.bsky.social
- made a local table of tornado path data from FEMA
- joined them together
- set up a web browser to view the join with pg_tileserv
💥
February 6, 2025 at 11:56 PM
Today I got to play around with @crunchydata.com's new data warehouse.
- connected to the entire world's building footprint data in
@overturemaps.bsky.social
- made a local table of tornado path data from FEMA
- joined them together
- set up a web browser to view the join with pg_tileserv
💥
- connected to the entire world's building footprint data in
@overturemaps.bsky.social
- made a local table of tornado path data from FEMA
- joined them together
- set up a web browser to view the join with pg_tileserv
💥