Changes between Version 39 and Version 40 of import layers postgis


Ignore:
Timestamp:
Aug 21, 2018 12:18:31 PM (7 years ago)
Author:
maria
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • import layers postgis

    v39 v40  
    11back to start page [[..]] 
     2[[PageOutline]] 
     3* [#PROBLEM Fixing a problem with the database] 
     4* [#FIRST First trial with two layers] 
     5* [#PFAF Trials for the pfafsteter system] 
     6* [#ROUTING pg_routing] 
     7* [#LTREE ltree] 
     8* [#BASSIN Select some bassins to calculate topology] 
     9* [#PORTUGAL Trial with Portugal layers] 
    210 
    311= Import layer postgis = 
    412 
    513== first fixing a problem with the database == 
     14[=#PROBLEM] 
    615 
    716At first the following failed and I had to fix a problem in the database 
     
    2433 
    2534== First trial with two layers == 
     35[=#FIRST] 
    2636 
    2737Our objective is to test the best way to route the river network 
     
    123133 
    124134== Trials for the pfafsteter system == 
     135[=#PFAF] 
     136 
    125137To be able to explore the topology we could use pfafstetter 
    126138 
     
    177189 
    178190== pg_routing == 
     191[=#ROUTING] 
    179192 
    180193https://docs.pgrouting.org/2.5/en/pgRouting-concepts.html#description-of-the-edges-sql-query-for-dijkstra-like-functions 
     
    221234 
    222235== ltree == 
     236[=#LTREE] 
    223237 
    224238{{{#!sql 
     
    346360 
    347361== Select some bassins to calculate topology == 
     362[=#BASSIN] 
     363 
    348364{{{#!sql 
    349365set search_path to public, spain, european_wise2008 ; -- location of the tables in the scheme 
     
    413429 
    414430== Trial with Portugal layers == 
     431[=#PORTUGAL] 
    415432 
    416433In Command prompt(cmd) we need to create a new schema and import the shapefiles to Postgres