Changes between Version 45 and Version 46 of import layers postgis
- Timestamp:
- Sep 19, 2018 3:06:24 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
import layers postgis
v45 v46 675 675 -- and the source is all the nodes from the basin connected to that basin [[BR]] 676 676 -- To achieve the connection to all elements in the basin we used the recursive function upstream_segments [[BR]] 677 Details 677 Details: 678 678 -- this function uses a cursor, we could have used a for loop for the cursor [[BR]] 679 679 -- here following an example http://www.postgresqltutorial.com/plpgsql-cursor/ [[BR]] … … 735 735 736 736 At first, some parameters are created in sql: 737 -- nextdownid: estimate the downstream gid located next to each segment [[BR]]738 -- dmer: adding zerofor the downstream points (the method will calculate later the distance to the sea) [[BR]]737 -- nextdownid: estimate the downstream gid located next to each segment [[BR]] 738 -- dmer: adding zeros for the downstream points (the method will calculate later the distance to the sea) [[BR]] 739 739 740 740 {{{#!sql … … 765 765 }}} 766 766 767 This is the portuguese script, but it is the same for Spain (in Spain "nextdownid" did not exists, so it was also created) 768 767 This is the portuguese script, but it is the same for Spain (in Spain "nextdownid" did not exist, so it was also created)