Changes between Version 34 and Version 35 of import layers postgis

Timestamp:

Jul 13, 2018 1:21:01 PM (7 years ago)

Author:

maria

Comment:

--

import layers postgis

@@ -67 +67 @@
 }}}
 
-Creating a table corresponding to ORIA
+Creating a table corresponding to ORIA 
 
 Table of basins
@@ -94 +94 @@
 
 [[Image(source:eda/data/Docs/trac/sudoang/oria.png,200px)]]
+
+Creating a table corresponding to UROLA 
+
+Table of basins
+
+{{{#!sql
+create table spain.urola_cuenca as select * from a_cuencas_rios_atl_norte where pfafrio like '1003716%';
+
+CREATE INDEX urola_cuenca_geom_idx
+  ON urola_cuenca
+  USING gist
+  (geom);
+}}}
+
+Table of rivers
+
+{{{#!sql
+create table spain.urola_a_rios_v2 as select * from a_rios_v2 where pfafrio like '1003716%';
+
+CREATE INDEX urola_a_rios_v2_geom_idx
+  ON urola_a_rios_v2
+  USING gist
+  (geom);
+}}}
+
+[[Image(source:eda/data/Docs/trac/sudoang/urola.png,200px)]]
+
 
 == Trials for the pfafsteter system ==
@@ -344 +371 @@
 }}}
 
-Check in QGis the basins created according to the 6th and 7th position of code in pfafrio [[BR]]
+Check in QGis the rivers created according to the 6th and 7th position of code in pfafrio [[BR]]
 [[Image(source:eda/data/Docs/trac/sudoang/test_biscay_coast.png,400px)]]
-