New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mejorar quieries de metro-manzanas #1

Open

plablo09 opened this issue Feb 22, 2021 · 1 comment

Member

plablo09 commented Feb 22, 2021

Los queries los queries de seleccionar manzanas a menos de 500 metros del metro están mal

Member Author

plablo09 commented Feb 22, 2021

select 1 as id, st_union(st_buffer(geom, 500)) as geom
from geo_estacion_metro

select m.*
from manzanas_zmv as m
join (select 1 as id, st_union(st_buffer(geom, 500)) as geom
	  from geo_estacion_metro) as buffer
on st_intersects(m.geom, buffer.geom)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment