Skip to content
GitLab
Explore
Sign in
Primary navigation
Search or go to…
Project
D
database-gdetiles
Manage
Activity
Members
Labels
Plan
Issues
Issue boards
Milestones
Wiki
Code
Merge requests
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Build
Pipelines
Jobs
Pipeline schedules
Artifacts
Deploy
Releases
Package registry
Model registry
Operate
Environments
Terraform modules
Monitor
Incidents
Service Desk
Analyze
Value stream analytics
Contributor analytics
CI/CD analytics
Repository analytics
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
This is an archived project. Repository and other project resources are read-only.
Show more breadcrumbs
Global Dynamic Exposure
Libraries
database-gdetiles
Merge requests
!19
You need to sign in or sign up before continuing.
Create view for visualisation purposes
Code
Review changes
Check out branch
Download
Patches
Plain diff
Merged
Create view for visualisation purposes
feature/view_visualisation
into
master
Overview
1
Commits
2
Pipelines
15
Changes
1
Merged
Cecilia Nievas
requested to merge
feature/view_visualisation
into
master
3 years ago
Overview
1
Commits
2
Pipelines
15
Changes
1
Expand
\approve
@fd
@cnievas
Edited
3 years ago
by
Felix Delattre
0
0
Merge request reports
Compare
master
version 16
b2e6a785
3 years ago
version 15
fa5e193b
3 years ago
version 14
347a3866
3 years ago
version 13
347a3866
3 years ago
version 12
ad379f50
3 years ago
version 11
4d3b8e9b
3 years ago
version 10
c3f6673f
3 years ago
version 9
25dd80cc
3 years ago
version 8
cf37b8de
3 years ago
version 7
eb1eed01
3 years ago
version 6
2a6d543f
3 years ago
version 5
13715fff
3 years ago
version 4
888be71c
3 years ago
version 3
53c9a29c
3 years ago
version 2
9936f064
3 years ago
version 1
87e13c71
3 years ago
master (base)
and
latest version
latest version
b2e6a785
2 commits,
3 years ago
version 16
b2e6a785
3 commits,
3 years ago
version 15
fa5e193b
4 commits,
3 years ago
version 14
347a3866
3 commits,
3 years ago
version 13
347a3866
3 commits,
3 years ago
version 12
ad379f50
2 commits,
3 years ago
version 11
4d3b8e9b
2 commits,
3 years ago
version 10
c3f6673f
2 commits,
3 years ago
version 9
25dd80cc
2 commits,
3 years ago
version 8
cf37b8de
2 commits,
3 years ago
version 7
eb1eed01
2 commits,
3 years ago
version 6
2a6d543f
2 commits,
3 years ago
version 5
13715fff
2 commits,
3 years ago
version 4
888be71c
2 commits,
3 years ago
version 3
53c9a29c
2 commits,
3 years ago
version 2
9936f064
2 commits,
3 years ago
version 1
87e13c71
1 commit,
3 years ago
1 file
+
21
−
0
Inline
Compare changes
Side-by-side
Inline
Show whitespace changes
Show one file at a time
migrations/00014_create-view-gde-tiles.sql
0 → 100644
+
21
−
0
Options
DROP
TABLE
IF
EXISTS
public
.
gde_tiles
;
CREATE
VIEW
public
.
gde_tiles
AS
SELECT
data_unit_tiles
.
quadkey
AS
quadkey
,
SUM
(
COALESCE
(
data_unit_tiles
.
obm_buildings
,
0
)
+
COALESCE
(
data_unit_tiles
.
remainder_buildings
,
0
)
)
AS
buildings_total
,
-- total number of buildings in a tile
SUM
(
COALESCE
(
data_unit_tiles
.
obm_buildings
,
0
)
)
AS
buildings_available
,
-- total number of GDE buildings in a tile
SUM
(
COALESCE
(
data_unit_tiles
.
remainder_buildings
,
0
)
)
AS
buildings_remainder
-- total number of remainder buildings in a tile
FROM
data_unit_tiles
WHERE
data_unit_tiles
.
aggregated_source_id
=
1
GROUP
BY
data_unit_tiles
.
quadkey
;
ALTER
VIEW
public
.
gde_tiles
OWNER
TO
postgres
;
Loading