Changes between Version 42 and Version 43 of import layers postgis

Timestamp:

Aug 27, 2018 1:43:13 PM (7 years ago)

Author:

maria

Comment:

--

import layers postgis

@@ -505 +505 @@
 }}}
 
-Create q view of coastal waters: first it is projected to the portugese projection 3763, and second we just need one big water mass for st_distance to the sea hence the UNION
+Create a view of coastal waters: first it is projected to the portugese projection 3763, and second we just need one big water mass for st_distance to the sea hence the UNION
 
 {{{#!sql
@@ -666 +666 @@
 UPDATE portugal.rivers set chemin=get_path(75270,u.source) from portugal.upstream_segments(75270) u
 where rivers.source = u.source; -- 5:13
-}}}
-
- -- Since this works, we use the second option to calculate topology in each basin (that are ordered by north/south)
-
-{{{#!sql
---select portugal.get_path(target, source) from portugal.rivers where nome = 'Minho';--Rivers in Spain
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Ancora e Ribeiras Costeiras';--37.4 secs
---select portugal.get_path(target, source) from portugal.rivers where nome = 'Lima';--Target outside the basin
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Neiva e Ribeiras Costeiras';--01:20 min
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Cávado e Ribeiras Costeiras';--07:46 min
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Ave';--06:29 min
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Leça e Ribeiras Costeiras';--01:30 min
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Douro';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Vouga e Ribeiras Costeiras';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Mondego';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Lis e Ribeiras Costeiras';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Ribeiras do Oeste';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Tejo';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Sado';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Ribeiras do Alentejo';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Mira';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Ribeiras do Algarve';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Arade';--
-select portugal.get_path(target, source) from portugal.rivers where nome = 'Guadiana';--
-}}}
-
- -- May be we can use the third option to calculate topology at the same time, but we have not tried yet
-
-{{{#!sql
-UPDATE portugal.rivers set chemin=get_path(u.target,u.source) from portugal.upstream_segments(target) u
-where rivers.target = u.target, rivers.source = u.source; -- could it work for all basins at the same time?
 }}}
 
@@ -749 +718 @@
 LANGUAGE plpgsql;
 
+}}}
+
+We run the next function for each portuguese basin (19 basins) to calculate the path of rivers that we will use later in te model
+
+{{{#!sql
 select portugal.write_chemin('Lis e Ribeiras Costeiras');
-select * from portugal.downstream_points where nome = 'Lis e Ribeiras Costeiras';
-
--- For the rest of basins (except Minho and Lima for the moment)
-select portugal.write_chemin('Neiva e Ribeiras Costeiras' ,'Cávado e Ribeiras Costeiras','Ave',
-        'Leça e Ribeiras Costeiras','Douro','Vouga e Ribeiras Costeiras','Mondego','Lis e Ribeiras Costeiras'
-        'Ribeiras do Oeste','Tejo','Sado','Ribeiras do Alentejo','Mira','Ribeiras do Algarve','Arade');
-}}}
+}}}