Naty Clementi ncclementi
ncclementi
/ colima-docker.md
Created
February 20, 2024 16:02
References:
- Goodbye Docker Desktop for Mac, Hello Colima
- Installing Colima as a Docker Engine provider with Buildx and Compose plugins installed
Colima is container runtimes on macOS (and Linux) with minimal setup, that has M1 macs support.
ncclementi
/ repro_geo_literal.ipynb
Created
December 5, 2023 18:35
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
ncclementi
/ ddb-geo-ibis-support.md
Created
December 1, 2023 17:58
duckdb ST |
ibis ops |
ibis + duckdb support | Summary |
|---|---|---|---|
ST_Area |
GeoArea |
✅ | Returns the area of a geometry. |
ST_Area_Spheroid |
Returns the area of a geometry in meters, using an ellipsoidal model of the earth | ||
ST_AsGeoJSON |
Returns the geometry as a GeoJSON fragment | ||
ST_AsHEXWKB |
Returns the geometry as a HEXWKB string | ||
ST_AsText |
GeoAsText |
✅ | Returns the geometry as a WKT string |
ST_AsWKB |
GeoAsBinary |
TODO next | Returns the geometry as a WKB blob |
ST_Boundary |
Returns the "boundary" of a geometry | ||
ST_Buffer |
GeoBuffer |
✅ | Retur |
ncclementi
/ st_unionagg_disc_reproducer.ipynb
Created
November 21, 2023 22:01
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
ncclementi
/ postgres_duckdb_geo_compat.md
Last active
February 5, 2025 00:22
Here is a table of what we have in ibis/ibis/backends/base/sql/alchemy/registry.py compared against DuckDB spatial extension docs
ops |
postgress |
duckdb supported |
postgress docs |
|---|---|---|---|
ops.GeoArea |
unary(sa.func.ST_Area) |
✅ | https://postgis.net/docs/ST_Area.html |
ops.GeoAsBinary |
unary(sa.func.ST_AsBinary) |
❌ | https://postgis.net/docs/ST_AsBinary.html |
ops.GeoAsEWKB |
unary(sa.func.ST_AsEWKB) |
❌ | https://postgis.net/docs/ST_AsEWKB.html |
ncclementi
/ tcp-192_168_0_211-58433.json
Created
November 2, 2022 18:03
2-worker-profile-q1-5GB-localcluster
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"$schema":"https://www.speedscope.app/file-format-schema.json","profiles":[{"type":"sampled","name":"Process 87203 Thread 0x100CA0580 \"MainThread\"","unit":"seconds","startValue":0.0,"endValue":3.85,"samples":[[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,27,26,25],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,28],[4,24,23,22,21,20,19,18,17,16,15,27,26,30,29],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24, |
ncclementi
/ tcp-192_168_0_211-58212.json
Last active
November 2, 2022 18:01
1-worker-profile-q1-5GB-localcluster
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"$schema":"https://www.speedscope.app/file-format-schema.json","profiles":[{"type":"sampled","name":"Process 85804 Thread 0x1028DC580 \"MainThread\"","unit":"seconds","startValue":0.0,"endValue":0.22,"samples":[[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22,21,20,19,18,17,16,15,14,13],[4,24,23,22, |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
ncclementi
/ read_gbq_timeseries_groupby.html
Created
September 30, 2021 10:32
read_gbq_timeseries_groupby
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> |
NewerOlder