Naty Clementi ncclementi

## best_try_for layout.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ncclementi
                / best_try_for layout.ipynb
            
            
              Last active
              May 14, 2021 21:55
            
              
                best_try_for_layout.ipynb
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## tg_viz.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ncclementi
                / tg_viz.ipynb
            
            
              Last active
              June 11, 2021 13:05
            
              
                tg_viz.ipynb
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## read_gbq_timeseries_groupby.html


<!DOCTYPE html>
<html lang="en">

  <head>

      <meta charset="utf-8">

## coiled-afar-gpus.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ncclementi
                / coiled-afar-gpus.ipynb
            
            
              Created
              October 12, 2021 22:29
            
              
                coiled-afar-gpus.ipynb
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## tcp-192_168_0_211-58212.json
{"$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,

## tcp-192_168_0_211-58433.json
{"$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,

## postgres_duckdb_geo_compat.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ncclementi
                / postgres_duckdb_geo_compat.md
            
            
              Last active
              October 27, 2023 14:15
            
          
    Compatibility inventory of Postgress vs DuckDB geospatial fucntions

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


## st_unionagg_disc_reproducer.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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.
      
          Viewer requires iframe.
      
    
## ddb-geo-ibis-support.md

      
              1 file
            
          
              0 forks
            
          
              4 comments
            
          
              0 stars
            
          
                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


## repro_geo_literal.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                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.
      
          Viewer requires iframe.
`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
`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