This is an automated email from the ASF dual-hosted git repository.

bchapuis pushed a commit to branch materialized-views
in repository https://gitbox.apache.org/repos/asf/incubator-baremaps.git


The following commit(s) were added to refs/heads/materialized-views by this 
push:
     new 1ccd27b01 Format sql scripts
1ccd27b01 is described below

commit 1ccd27b01103dd2d2b39fc1b350c82440870b8a9
Author: Bertil Chapuis <[email protected]>
AuthorDate: Mon Jan 13 15:53:27 2025 +0100

    Format sql scripts
---
 basemap/layers/amenity/create.sql | 5 -----
 basemap/layers/highway/create.sql | 3 +--
 basemap/layers/landuse/create.sql | 2 --
 basemap/layers/natural/create.sql | 1 -
 4 files changed, 1 insertion(+), 10 deletions(-)

diff --git a/basemap/layers/amenity/create.sql 
b/basemap/layers/amenity/create.sql
index 571b2ce3d..8388b5adc 100644
--- a/basemap/layers/amenity/create.sql
+++ b/basemap/layers/amenity/create.sql
@@ -135,7 +135,6 @@ CREATE
     INDEX IF NOT EXISTS osm_amenity_z12_filtered_tags_idx ON
     osm_amenity_z12_filtered(tag);
 
-
 DROP
     MATERIALIZED VIEW IF EXISTS osm_amenity_z12 CASCADE;
 
@@ -219,14 +218,12 @@ CREATE
         AND NOT ST_IsEmpty(geom)
         AND st_area(geom)> POWER( 78270 / POWER( 2, 11 ), 2 )* 32;
 
-
 DROP
     INDEX IF EXISTS osm_amenity_z11_filtered_geom_idx;
 
 DROP
     INDEX IF EXISTS osm_amenity_z11_filtered_tags_idx;
 
-
 CREATE
     INDEX IF NOT EXISTS osm_amenity_z11_filtered_geom_idx ON
     osm_amenity_z11_filtered
@@ -236,7 +233,6 @@ CREATE
     INDEX IF NOT EXISTS osm_amenity_z11_filtered_tags_idx ON
     osm_amenity_z11_filtered(tag);
 
-
 DROP
     MATERIALIZED VIEW IF EXISTS osm_amenity_z11 CASCADE;
 
@@ -980,4 +976,3 @@ CREATE
     INDEX IF NOT EXISTS osm_amenity_z1_tags_idx ON
     osm_amenity_z1
         USING GIN(tags);
-
diff --git a/basemap/layers/highway/create.sql 
b/basemap/layers/highway/create.sql
index da214444b..26078979f 100644
--- a/basemap/layers/highway/create.sql
+++ b/basemap/layers/highway/create.sql
@@ -153,7 +153,6 @@ CREATE
     FROM
         osm_highway_filtered;
 
-
 DROP
     INDEX IF EXISTS osm_highway_clustered_geom;
 
@@ -270,7 +269,6 @@ CREATE
             'residential'
         );
 
-
 DROP
     INDEX IF EXISTS osm_highway_z11_geom_idx;
 
@@ -312,6 +310,7 @@ CREATE
             'tertiary',
             'tertiary_link'
         );
+
 DROP
     INDEX IF EXISTS osm_highway_z10_geom_idx;
 
diff --git a/basemap/layers/landuse/create.sql 
b/basemap/layers/landuse/create.sql
index fc883e272..a15bfeaea 100644
--- a/basemap/layers/landuse/create.sql
+++ b/basemap/layers/landuse/create.sql
@@ -956,8 +956,6 @@ DROP
 DROP
     INDEX IF EXISTS osm_landuse_z2_tags_idx;
 
-
-
 CREATE
     INDEX IF NOT EXISTS osm_landuse_z2_geom_idx ON
     osm_landuse_z2
diff --git a/basemap/layers/natural/create.sql 
b/basemap/layers/natural/create.sql
index 63435322d..a34a889f2 100644
--- a/basemap/layers/natural/create.sql
+++ b/basemap/layers/natural/create.sql
@@ -487,7 +487,6 @@ CREATE
     osm_natural_z9
         USING GIN(tags);
 
-
 -- Zoom level 8
 DROP
     MATERIALIZED VIEW IF EXISTS osm_natural_z8 CASCADE;

Reply via email to