Changes between Version 39 and Version 40 of import layers postgis
- Timestamp:
- Aug 21, 2018 12:18:31 PM (7 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
import layers postgis
v39 v40 1 1 back 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] 2 10 3 11 = Import layer postgis = 4 12 5 13 == first fixing a problem with the database == 14 [=#PROBLEM] 6 15 7 16 At first the following failed and I had to fix a problem in the database … … 24 33 25 34 == First trial with two layers == 35 [=#FIRST] 26 36 27 37 Our objective is to test the best way to route the river network … … 123 133 124 134 == Trials for the pfafsteter system == 135 [=#PFAF] 136 125 137 To be able to explore the topology we could use pfafstetter 126 138 … … 177 189 178 190 == pg_routing == 191 [=#ROUTING] 179 192 180 193 https://docs.pgrouting.org/2.5/en/pgRouting-concepts.html#description-of-the-edges-sql-query-for-dijkstra-like-functions … … 221 234 222 235 == ltree == 236 [=#LTREE] 223 237 224 238 {{{#!sql … … 346 360 347 361 == Select some bassins to calculate topology == 362 [=#BASSIN] 363 348 364 {{{#!sql 349 365 set search_path to public, spain, european_wise2008 ; -- location of the tables in the scheme … … 413 429 414 430 == Trial with Portugal layers == 431 [=#PORTUGAL] 415 432 416 433 In Command prompt(cmd) we need to create a new schema and import the shapefiles to Postgres