Changes between Version 43 and Version 44 of import layers postgis


Ignore:
Timestamp:
Sep 19, 2018 2:02:17 PM (7 years ago)
Author:
maria
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • import layers postgis

    v43 v44  
    88* [#BASSIN Select some bassins to calculate topology] 
    99* [#PORTUGAL Trial with Portugal layers] 
     10* [#COMBINE Combining postgis and R to calculate topology] 
     11 
    1012 
    1113=== Tickets === 
    … …  
    725727select portugal.write_chemin('Lis e Ribeiras Costeiras'); 
    726728}}} 
     729 
     730 
     731== Combining postgis and R to calculate topology == 
     732[=#COMBINE] 
     733 
     734After several issues calculating topology in PostGis (problem with the MB in max_stack_depth and the high calculation time when basins are big), some methods created in R for the CCM layers are used. 
     735 
     736At first, some parameters are created in sql: 
     737-- nextdownid: estimate the downstream gid located next to each segment 
     738-- dmer: adding zero for the downstream points (the method will calculate later the distance to the sea)