Changes between Version 86 and Version 87 of CCM2 download and load

Timestamp:

Jun 22, 2018 9:51:15 PM (7 years ago)

Author:

cedric

Comment:

--

CCM2 download and load

@@ -61 +61 @@
 
 See ["CookBook shptopostgres"] the same procedure was applied to obtain : (refer to your version so far Cédric or Céline)
-{{{
+{{{#!sh
 REM Ouvrir ce fichier avec notepad++ et copier coller les commandes dans une invite de commande
 REM================================================
@@ -125 +125 @@
 == change schema to ccm21 ==
 Which can be downloaded at source:eda/EDACCM/ccm21_build.bat [[BR]] open this file with notepad++ and copy / paste to the command batch
-{{{
+{{{#!sql
 CREATE SCHEMA ccm21;
 ALTER TABLE riversegments SET SCHEMA ccm21;
@@ -139 +139 @@
 == A PLSQL function to get the upstream segments ==
 === creating indexes ===
-{{{
+{{{#!sql
 DROP INDEX IF EXISTS ccm21.indexriversegments_wso_id;
 CREATE INDEX indexriversegments_wso_id
@@ -210 +210 @@
 
 === plpgsql function which returns the id of the primary catchments within the catchment corresponding to the strahler order ===
-{{{
+{{{#!sql
 -- it is necessary to create a type to hold the output type
 DROP TYPE IF EXISTS wso1_id;
@@ -372 +372 @@
 ["Function mycatchment"]
 
-{{{
+{{{#!sql
 --examples of use