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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
/**
* SPDX-License-Identifier: GPL-2.0-or-later
*
* This file is part of osm2pgsql (https://osm2pgsql.org/).
*
* Copyright (C) 2006-2021 by the osm2pgsql developer community.
* For a full list of authors see the git log.
*/
#include <catch.hpp>
#include "common-import.hpp"
#include "common-options.hpp"
static testing::db::import_t db;
static char const *const conf_file_3857 = "test_output_flex_area_3857.lua";
static char const *const conf_file_4326 = "test_output_flex_area_4326.lua";
static char const *const conf_file_mix = "test_output_flex_area_mix.lua";
static char const *const data_file = "test_output_pgsql_area.osm";
TEST_CASE("area calculation in default projection")
{
options_t const options = testing::opt_t().flex(conf_file_3857);
REQUIRE_NOTHROW(db.run_file(options, data_file));
auto conn = db.db().connect();
REQUIRE(2 == conn.get_count("osm2pgsql_test_polygon"));
conn.assert_double(
1.23927e+10,
"SELECT area FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
1.23927e+10,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(1.0, "SELECT ST_Area(ST_Transform(geom, 4326)) "
"FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
9.91828e+10,
"SELECT area FROM osm2pgsql_test_polygon WHERE name='multi'");
conn.assert_double(
9.91828e+10,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='multi'");
conn.assert_double(8.0, "SELECT ST_Area(ST_Transform(geom, 4326)) "
"FROM osm2pgsql_test_polygon WHERE name='multi'");
}
TEST_CASE("area calculation in latlon projection")
{
options_t const options = testing::opt_t().flex(conf_file_4326);
REQUIRE_NOTHROW(db.run_file(options, data_file));
auto conn = db.db().connect();
REQUIRE(2 == conn.get_count("osm2pgsql_test_polygon"));
conn.assert_double(
1.0, "SELECT area FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
1.0,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
8.0, "SELECT area FROM osm2pgsql_test_polygon WHERE name='multi'");
conn.assert_double(
8.0,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='multi'");
}
TEST_CASE("area calculation in latlon projection with way area reprojection")
{
options_t options = testing::opt_t().flex(conf_file_mix);
REQUIRE_NOTHROW(db.run_file(options, data_file));
auto conn = db.db().connect();
REQUIRE(2 == conn.get_count("osm2pgsql_test_polygon"));
conn.assert_double(
1.23927e+10,
"SELECT area FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
1.0,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='poly'");
conn.assert_double(
9.91828e+10,
"SELECT area FROM osm2pgsql_test_polygon WHERE name='multi'");
conn.assert_double(
8.0,
"SELECT ST_Area(geom) FROM osm2pgsql_test_polygon WHERE name='multi'");
}
|
