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;