-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcreate.sql
75 lines (67 loc) · 2.19 KB
/
create.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
-- create the database
\i 'database/db_geography.sql';
-- switch to using the database
\c geography_test;
-- setup any extensions
\i 'database/db_extensions.sql';
-- set client encoding
set client_encoding = 'UTF8';
-- create tables
\i 'tables/tbl_built_up_area_boundary.sql';
\i 'tables/tbl_county_boundary.sql';
\i 'tables/tbl_country_boundary.sql';
\i 'tables/tbl_lad_boundary.sql';
\i 'tables/tbl_lsoa_boundary.sql';
\i 'tables/tbl_lsoa_population.sql';
\i 'tables/tbl_lsoa_imd.sql';
\i 'tables/tbl_lsoa_wimd.sql';
\i 'tables/tbl_lsoa_upper_lookup.sql';
\i 'tables/tbl_lsoa_rural_urban.sql';
\i 'tables/tbl_lsoa11_lsoa21.sql';
\i 'tables/tbl_lsoa11_lsoa21_exact.sql';
\i 'tables/tbl_datazone_boundary.sql';
\i 'tables/tbl_datazone_imd_population.sql';
\i 'tables/tbl_ni_sa_boundary.sql';
\i 'tables/tbl_ni_sa_imd.sql';
\i 'tables/tbl_ni_sa_population.sql';
\i 'tables/tbl_region_boundary.sql';
\i 'tables/tbl_ward_boundary.sql';
\i 'tables/tbl_postcode_lookup.sql';
\i 'tables/tbl_administrative_names.sql';
\i 'tables/tbl_lower_upper_lookup.sql';
\i 'tables/tbl_generated_mvt_type.sql';
\i 'tables/tbl_generated_mvt.sql';
\i 'tables/tbl_oa_bua.sql';
\i 'tables/tbl_oa_population.sql';
\i 'tables/tbl_oa11_oa21.sql';
\i 'tables/tbl_oa11_lsoa11.sql';
\i 'tables/tbl_place_name.sql';
-- create views
\i 'views/vw_built_up_area_boundaries.sql';
\i 'views/vw_county_boundaries.sql';
\i 'views/vw_country_boundaries.sql';
\i 'views/vw_lad_boundaries.sql';
\i 'views/vw_lsoa_boundaries.sql';
\i 'views/vw_lsoa.sql';
\i 'views/vw_region_boundaries.sql';
\i 'views/vw_ward_boundaries.sql';
\i 'views/vw_library_boundaries.sql';
\i 'views/vw_postcodes.sql';
\i 'views/vw_smallareas_uk.sql';
\i 'views/vw_postcode_smallarea_uk.sql';
\i 'views/vw_place_names.sql';
-- create functions
\i 'functions/fn_bbox.sql';
\i 'functions/fn_built_up_areas_mvt.sql';
\i 'functions/fn_counties_mvt.sql';
\i 'functions/fn_countries_mvt.sql';
\i 'functions/fn_lads_mvt.sql';
\i 'functions/fn_library_authorities_mvt.sql';
\i 'functions/fn_lsoas_mvt.sql';
\i 'functions/fn_regions_mvt.sql';
\i 'functions/fn_wards_mvt.sql';
\i 'functions/fn_postcodelsoasfromsectors.sql';
\i 'functions/fn_generate_mvt.sql';
-- load in data
\i 'load.sql';
vacuum analyze;