如何根据到点的距离过滤带有LineString字段的对象？

-- 创建一个包含LineString字段的表
CREATE TABLE lines (
    id SERIAL PRIMARY KEY,
    geom GEOMETRY(LineString, 4326)
);

-- 插入一些示例数据
INSERT INTO lines (geom) VALUES (
    ST_GeomFromText('LINESTRING(0 0, 1 1, 2 1)')
);

-- 查询距离点(1, 1)小于10米的LineString对象
SELECT id, ST_AsText(geom)
FROM lines
WHERE ST_DWithin(
    geom,
    ST_GeomFromText('POINT(1 1)', 4326),
    10
);

import geopandas as gpd
from shapely.geometry import Point, LineString

# 创建一个包含LineString字段的GeoDataFrame
data = {
    'id': [1],
    'geom': [LineString([(0, 0), (1, 1), (2, 1)])]
}
gdf = gpd.GeoDataFrame(data, geometry='geom')

# 创建一个点
point = Point(1, 1)

# 过滤距离点小于10米的LineString对象
result = gdf[gdf.geometry.distance(point) < 10]
print(result)