Changes between Version 13 and Version 14 of import layers postgis

Timestamp:

Jun 22, 2018 8:57:09 PM (7 years ago)

Author:

cedric

Comment:

--

import layers postgis

@@ -41 +41 @@
 }}}
 
+in fact the system of projection indicated on the inspire layers is wrong it is 25830
+http://www.mapama.gob.es/es/cartografia-y-sig/ide/directorio_datos_servicios/caracteristicas_wms.aspx
+{{{#!sql
+select UpdateGeometrySRID('spain','a_cuencas_rios_atl_norte', 'geom', 25830 );
+select UpdateGeometrySRID('spain','a_rios_v2', 'geom', 25830 );
+}}}
+
 
 Now we need to select only the Oria and neighbouring rivers for our trial
@@ -62 +69 @@
 Creating a table corresponding to ORIA
 
+Table of basins
+
 {{{#!sql
-drop table if exists spain.oria_test;
-create table spain.oria_test as select * from a_cuencas_rios_atl_norte where pfafrio like '1003714%';--422
+drop table if exists spain.oria_cuenca;
+create table spain.oria_cuenca as select * from a_cuencas_rios_atl_norte where pfafrio like '1003714%';--422
 
-CREATE INDEX oria_test_geom_idx
-  ON oria_test
+CREATE INDEX oria_cuenca_geom_idx
+  ON oria_cuenca
   USING gist
   (geom);
 }}}
 
+Table of rivers
 
-in fact the system of projection indicated on the inspire layers is wrong it is 25830
-http://www.mapama.gob.es/es/cartografia-y-sig/ide/directorio_datos_servicios/caracteristicas_wms.aspx
 {{{#!sql
-select UpdateGeometrySRID('spain','oria_test', 'geom', 25830 );
+drop table if exists spain.oria_a_rios_v2;
+create table spain.oria_a_rios_v2 as select * from a_rios_v2 where pfafrio like '1003714%';--422
+
+CREATE INDEX oria_a_rios_v2_geom_idx
+  ON oria_a_rios_v2
+  USING gist
+  (geom);
 }}}
+
+[[Image(source:eda/data/Docs/trac/oria.png,200px)]]