Citar y Licencia: https://doi.org/10.6084/m9.figshare.27907050.v1
VĂdeo: https://youtu.be/He8KbgDpq3I
municipios
red_hidrografica
distritos_hidrograficos
WITH rio_genil_grupo AS (
WITH rio_genil AS (
SELECT grupo
FROM red_hidrografica
WHERE nombre = 'RĂo Genil'
GROUP BY grupo
)
SELECT
1 AS id,
'RĂo Genil' as nombre,
ST_Union(geom) AS geom
FROM red_hidrografica
WHERE grupo =
(SELECT grupo FROM rio_genil)
GROUP BY grupo
)
SELECT
m.*
FROM
municipios m
JOIN
rio_genil_grupo r
ON
ST_Intersects(m.geom, r.geom);
nombre | tpc_dh |
---|---|
D.H. Cuencas Mediterráneas | 20.86736871557912 |
D.H. Guadalquivir | 78.64643599262249 |
D.H. Segura | 0.4706872424457691 |
ST_Intersects
ST_Buffer
, ST_Area
,
ST_Perimeter
ST_Union
, ST_Intersection
ST_Centroid
,
ST_PointOnSurface