Struct SpatialQuery 

pub struct SpatialQuery { /* private fields */ }

Spatial query builder

Implementations

impl SpatialQuery

pub fn new(table_name: impl Into<String>) -> Result<Self>

Creates a new spatial query

pub fn geometry_column(self, column: impl Into<String>) -> Self

Sets the geometry column name

pub fn id_column(self, column: impl Into<String>) -> Self

Sets the ID column name

pub fn select(self, columns: &[&str]) -> Self

Sets specific columns to select

pub fn where_clause(self, condition: impl Into<String>) -> Self

Adds a WHERE condition

pub fn where_bbox(self, bbox: &BoundingBox) -> Result<Self>

Adds a bounding box filter

pub fn where_intersects(self, _geometry: &Geometry) -> Result<Self>

Filters features that intersect with a geometry

pub fn where_contains(self, _geometry: &Geometry) -> Result<Self>

Filters features that contain a geometry

pub fn where_within(self, _geometry: &Geometry) -> Result<Self>

Filters features within a geometry

pub fn where_dwithin(self, _geometry: &Geometry, distance: f64) -> Result<Self>

Filters features within a distance

pub const fn srid(self, srid: i32) -> Self

Sets the SRID for spatial operations

pub const fn limit(self, limit: usize) -> Self

Sets the result limit

pub const fn offset(self, offset: usize) -> Self

Sets the result offset

pub fn order_by(self, column: impl Into<String>, ascending: bool) -> Self

Adds an ORDER BY clause

pub fn order_by_distance(self, _geometry: &Geometry) -> Result<Self>

Orders by distance from a geometry

pub fn build_sql(&self) -> Result<String>

Builds the SQL query

pub async fn execute(self, pool: &ConnectionPool) -> Result<Vec<Feature>>

Executes the query and returns features

pub async fn count(self, pool: &ConnectionPool) -> Result<i64>

Executes the query and returns count