我正在使用OpenStreetMap osm2pgsql数据库。它的一个表(planet_osm_line)有两个索引字段: osm_id (int,主键)和way (postgis几何学)。我想找出哪条街道与一条特定的街道相交,据我所知,它是osm_id。所以我想:WHERE highway IS NOT NULLAND ST_Intersects(way, (S
SELECT ST_AsGeoJSON(ST_Transform(way, 4326)) AS geometry'SELECT osm_id AS id, source, target, st_length(way) as cost FROM planet_osm_roads', ) as di FROM pgr_dijkstra(
'