DuckDB-Backed Spatial Data Structures
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘DuckDBSpatial’ version 0.99.6
Help Pages
-- A --
| asCoordinateTransform | Coerce a transform dict into a CoordinateTransform |
-- C --
| coordinate-transforms | Coordinate-transform constructors (OME-NGFF RFC-5) |
| coordinateSystem | Define a named coordinate system |
| ctAffine | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctAffineMatrix | Lower a coordinate transform to a homogeneous affine matrix |
| ctApply | Apply a coordinate transform to a matrix of points |
| ctBetween | Transform points between two coordinate systems |
| ctBijection | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctByDimension | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctGraph | Build a coordinate-transform graph |
| ctIdentity | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctInvert | Invert a coordinate transform |
| ctMapAxis | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctPath | Resolve the transform between two coordinate systems |
| ctRotation | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctScale | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctSequence | Coordinate-transform constructors (OME-NGFF RFC-5) |
| ctTranslation | Coordinate-transform constructors (OME-NGFF RFC-5) |
-- D --
| DuckDBColumn-spatial | Spatial operations on DuckDBColumn objects |
| DuckDBTable-spatial | Spatial operations on DuckDBTable objects |
-- E --
| enableGeoParquetConversion | Enable DuckDB GeoParquet conversion on a connection |
-- L --
| layerBboxRange | Subset a points layer to a bounding box with a prunable range predicate |
| layerSpatialMatch | Match points in a lazy table layer to a geometry table |
| layerSpatialOverlaps | Test spatial intersection for a lazy table layer |
| layerSubsetByBbox | Row indices of a layer inside a bounding box |
| layerSubsetByGeometry | Row indices of a layer intersecting a geometry |
-- R --
| readGeoParquet | Read a GeoParquet file as a lazy 'DuckDBDataFrame' |
-- S --
| spatialSortPoints | Reorder a points table by a Morton (Z-order) spatial key |
| st_affine | Apply a 2-D affine coordinate transform to geometries |
| st_area.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_area.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_as_binary.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_as_binary.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_as_sfc.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_as_sfc.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_as_text.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_as_text.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_bbox.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_boundary.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_boundary.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_buffer.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_buffer.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_build_area | Spatial operations on DuckDBTable objects |
| st_build_area.default | Spatial operations on DuckDBTable objects |
| st_build_area.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_build_area.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_centroid.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_centroid.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_collect | Spatial operations on DuckDBTable objects |
| st_collect.default | Spatial operations on DuckDBTable objects |
| st_collect.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_collection_extract.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_collection_extract.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_collect_agg | Spatial operations on DuckDBTable objects |
| st_concave_hull.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_concave_hull.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_contains | Spatial operations on DuckDBTable objects |
| st_contains.default | Spatial operations on DuckDBTable objects |
| st_contains.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_contains.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_contains_properly | Spatial operations on DuckDBTable objects |
| st_contains_properly.default | Spatial operations on DuckDBTable objects |
| st_contains_properly.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_contains_properly.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_convex_hull.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_convex_hull.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_coordinates.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_covered_by | Spatial operations on DuckDBTable objects |
| st_covered_by.default | Spatial operations on DuckDBTable objects |
| st_covered_by.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_covered_by.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_covers | Spatial operations on DuckDBTable objects |
| st_covers.default | Spatial operations on DuckDBTable objects |
| st_covers.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_covers.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_crosses | Spatial operations on DuckDBTable objects |
| st_crosses.default | Spatial operations on DuckDBTable objects |
| st_crosses.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_crosses.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_difference.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_difference.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_dimension | Spatial operations on DuckDBTable objects |
| st_dimension.default | Spatial operations on DuckDBTable objects |
| st_dimension.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_dimension.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_disjoint | Spatial operations on DuckDBTable objects |
| st_disjoint.default | Spatial operations on DuckDBTable objects |
| st_disjoint.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_disjoint.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_distance | Spatial operations on DuckDBTable objects |
| st_distance.default | Spatial operations on DuckDBTable objects |
| st_distance.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_distance.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_end_point | Spatial operations on DuckDBTable objects |
| st_end_point.default | Spatial operations on DuckDBTable objects |
| st_end_point.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_end_point.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_envelope | Spatial operations on DuckDBTable objects |
| st_envelope.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_envelope.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_envelope_agg | Spatial operations on DuckDBTable objects |
| st_equals | Spatial operations on DuckDBTable objects |
| st_equals.default | Spatial operations on DuckDBTable objects |
| st_equals.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_equals.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_exterior_ring.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_exterior_ring.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_filter.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_flip_coordinates | Spatial operations on DuckDBTable objects |
| st_flip_coordinates.default | Spatial operations on DuckDBTable objects |
| st_flip_coordinates.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_flip_coordinates.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_geometry_type | Spatial operations on DuckDBTable objects |
| st_geometry_type.default | Spatial operations on DuckDBTable objects |
| st_geometry_type.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_geometry_type.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_geomfromtext_sql | Spatial operations on DuckDBTable objects |
| st_inscribed_circle | Spatial operations on DuckDBTable objects |
| st_inscribed_circle.default | Spatial operations on DuckDBTable objects |
| st_inscribed_circle.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_inscribed_circle.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_intersection.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_intersection.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_intersects.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_intersects.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_intersects_table | Spatial operations on DuckDBTable objects |
| st_is_closed | Spatial operations on DuckDBTable objects |
| st_is_closed.default | Spatial operations on DuckDBTable objects |
| st_is_closed.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_closed.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_is_empty | Spatial operations on DuckDBTable objects |
| st_is_empty.default | Spatial operations on DuckDBTable objects |
| st_is_empty.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_empty.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_is_ring | Spatial operations on DuckDBTable objects |
| st_is_ring.default | Spatial operations on DuckDBTable objects |
| st_is_ring.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_ring.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_is_simple | Spatial operations on DuckDBTable objects |
| st_is_simple.default | Spatial operations on DuckDBTable objects |
| st_is_simple.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_simple.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_is_valid.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_valid.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_is_within_distance | Spatial operations on DuckDBTable objects |
| st_is_within_distance.default | Spatial operations on DuckDBTable objects |
| st_is_within_distance.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_is_within_distance.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_join.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_length | Spatial operations on DuckDBTable objects |
| st_length.default | Spatial operations on DuckDBTable objects |
| st_length.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_length.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_line_interpolate | Spatial operations on DuckDBTable objects |
| st_line_interpolate.default | Spatial operations on DuckDBTable objects |
| st_line_interpolate.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_line_interpolate.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_line_merge.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_line_merge.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_line_project | Spatial operations on DuckDBTable objects |
| st_line_project.default | Spatial operations on DuckDBTable objects |
| st_line_project.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_line_project.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_line_substring | Spatial operations on DuckDBTable objects |
| st_line_substring.default | Spatial operations on DuckDBTable objects |
| st_line_substring.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_line_substring.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_make_envelope_sql | Spatial operations on DuckDBTable objects |
| st_make_valid.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_make_valid.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_minimum_rotated_rectangle.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_minimum_rotated_rectangle.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_nearest_points.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_nearest_points.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_node.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_node.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_normalize.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_normalize.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_num_geometries | Spatial operations on DuckDBTable objects |
| st_num_geometries.default | Spatial operations on DuckDBTable objects |
| st_num_geometries.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_num_geometries.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_num_interior_rings | Spatial operations on DuckDBTable objects |
| st_num_interior_rings.default | Spatial operations on DuckDBTable objects |
| st_num_interior_rings.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_num_interior_rings.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_num_points | Spatial operations on DuckDBTable objects |
| st_num_points.default | Spatial operations on DuckDBTable objects |
| st_num_points.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_num_points.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_overlaps | Spatial operations on DuckDBTable objects |
| st_overlaps.default | Spatial operations on DuckDBTable objects |
| st_overlaps.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_overlaps.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_perimeter | Spatial operations on DuckDBTable objects |
| st_perimeter.default | Spatial operations on DuckDBTable objects |
| st_perimeter.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_perimeter.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_point_on_surface.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_point_on_surface.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_point_sql | Spatial operations on DuckDBTable objects |
| st_reduce_precision | Spatial operations on DuckDBTable objects |
| st_reduce_precision.default | Spatial operations on DuckDBTable objects |
| st_reduce_precision.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_reduce_precision.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_remove_repeated_points | Spatial operations on DuckDBTable objects |
| st_remove_repeated_points.default | Spatial operations on DuckDBTable objects |
| st_remove_repeated_points.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_remove_repeated_points.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_reverse.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_reverse.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_simplify.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_simplify.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_start_point | Spatial operations on DuckDBTable objects |
| st_start_point.default | Spatial operations on DuckDBTable objects |
| st_start_point.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_start_point.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_touches | Spatial operations on DuckDBTable objects |
| st_touches.default | Spatial operations on DuckDBTable objects |
| st_touches.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_touches.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_union.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_union.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_union_agg | Spatial operations on DuckDBTable objects |
| st_voronoi.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_voronoi.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_within | Spatial operations on DuckDBTable objects |
| st_within.default | Spatial operations on DuckDBTable objects |
| st_within.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_within.DuckDBTable | Spatial operations on DuckDBTable objects |
| st_within_properly | Spatial operations on DuckDBTable objects |
| st_within_properly.default | Spatial operations on DuckDBTable objects |
| st_within_properly.DuckDBColumn | Spatial operations on DuckDBColumn objects |
| st_within_properly.DuckDBTable | Spatial operations on DuckDBTable objects |
-- T --
| transformLayer | Apply a coordinate transform to a spatial layer |
-- W --
| writeGeoParquet | Write spatial data as GeoParquet |
| writeSpatialPointsParquet | Write a coord-indexed (Morton-sorted) points Parquet |