Changes between Version 45 and Version 46 of import layers postgis


Ignore:
Timestamp:
Sep 19, 2018 3:06:24 PM (7 years ago)
Author:
maria
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • import layers postgis

    v45 v46  
    675675 -- and the source is all the nodes from the basin connected to that basin [[BR]] 
    676676 -- To achieve the connection to all elements in the basin we used the recursive function upstream_segments [[BR]] 
    677 Details : 
     677Details: 
    678678 -- this function uses a cursor, we could have used a for loop for the cursor [[BR]] 
    679679 -- here following an example http://www.postgresqltutorial.com/plpgsql-cursor/ [[BR]] 
     
    735735 
    736736At first, some parameters are created in sql: 
    737 -- nextdownid: estimate the downstream gid located next to each segment [[BR]] 
    738 -- dmer: adding zero for 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]] 
    739739 
    740740{{{#!sql 
     
    765765}}} 
    766766 
    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  
     767This is the portuguese script, but it is the same for Spain (in Spain "nextdownid" did not exist, so it was also created)