Hello to all,
This is my first mail to the list. Sorry for the bad english. I need
your help.
I import 8 shapefiles to a database of pgadmin, (4 stretes and 4 rides).
I want to determinate the street of each ride by the distance so i write
a query but in some cases, when i run one spatial query, i have a problem.
The query results fine in 2 cases but in the others don't have luck
because is the query don terminate and keep run, never ends. It works
with tables with less features so i don't understand the problem.
I tried merge two shapes (one that work and other that not work), import
to pgadmin but still don't work.
Can anybody help me?
Thanks
Query:
psql -d osm -c "UPDATE passeios SET rua = (SELECT FID_ FROM eixos_rua
ORDER BY ST_Distance(eixos_rua.wkb_geometry,passeios.wkb_geometry) ASC
LIMIT 1)"