boat
C++23 geospatial library
Loading...
Searching...
No Matches
meta.hpp
Go to the documentation of this file.
1// Andrew Naplavkov
2
3#ifndef BOAT_DB_META_HPP
4#define BOAT_DB_META_HPP
5
7#include <cstdint>
8#include <string>
9#include <vector>
10
11namespace boat::db {
12
13struct source {
14 std::string source_name;
15 std::string address;
16};
17
18struct layer {
19 std::string schema_name;
20 std::string table_name;
21 std::string column_name;
22 bool raster;
23
24 friend bool operator==(layer const&, layer const&) = default;
25};
26
27struct column {
28 std::string kind;
29 std::string column_name;
30 std::string type_name;
31 int length;
32 int srid;
33 int epsg;
34 std::string wkt;
35 std::string proj4;
36};
37
38inline bool has_coord_sys(column const& col)
39{
40 return col.epsg > 0 || !col.wkt.empty() || !col.proj4.empty();
41}
42
43struct index_key {
44 std::string schema_name;
45 std::string index_name;
46 std::string column_name;
48 bool partial;
49 bool primary;
50 bool unique;
51 int ordinal;
52};
53
54struct table {
55 std::string dbms;
56 std::string schema_name;
57 std::string table_name;
58 std::vector<column> columns;
59 std::vector<index_key> index_keys;
60};
61
62inline auto indices(table const& tbl)
63{
64 return tbl.index_keys | std::views::chunk_by([](auto& lhs, auto& rhs) {
65 return lhs.ordinal < rhs.ordinal;
66 });
67}
68
69struct bbox {
70 std::vector<std::string> select_list;
71 std::string layer_column;
72 geometry::cartesian::box bounds; //< Layer column's SRS.
73 int limit;
74};
75
76struct order_key {
77 std::string column_name;
79};
80
81struct page {
82 std::vector<std::string> select_list;
83 std::vector<order_key> order_by;
84 size_t offset;
85 int limit;
86};
87
88struct band {
89 std::string color_name;
90 std::string type_name;
91};
92
93struct raster {
94 std::string schema_name;
95 std::string table_name;
96 std::string column_name;
97 std::vector<band> bands;
99 double xorig;
100 double yorig;
101 double xscale;
102 double yscale;
103 double xskew;
104 double yskew;
105 int srid;
106 int epsg;
107 std::string wkt;
108 std::string proj4;
109};
110
113{
114 return {
115 {{r.xscale, r.xskew, r.xorig},
116 {r.yskew, r.yscale, r.yorig},
117 {0., 0., 1.}}};
118}
119
120} // namespace boat::db
121
122#endif // BOAT_DB_META_HPP
Definition geometry.hpp:9
geometry::matrix affine(raster const &r)
Maps pixels to spatial coordinates.
Definition meta.hpp:112
bool has_coord_sys(column const &col)
Definition meta.hpp:38
auto indices(table const &tbl)
Definition meta.hpp:62
boost::qvm::mat< double, 3, 3 > matrix
Definition vocabulary.hpp:104
Definition meta.hpp:88
std::string color_name
Lowercase.
Definition meta.hpp:89
std::string type_name
Lowercase.
Definition meta.hpp:90
Definition meta.hpp:69
geometry::cartesian::box bounds
Definition meta.hpp:72
int limit
Definition meta.hpp:73
std::string layer_column
Definition meta.hpp:71
std::vector< std::string > select_list
Definition meta.hpp:70
Definition meta.hpp:27
std::string kind
Definition meta.hpp:28
std::string proj4
Definition meta.hpp:35
int srid
Definition meta.hpp:32
std::string wkt
Definition meta.hpp:34
std::string type_name
Lowercase.
Definition meta.hpp:30
int length
Definition meta.hpp:31
std::string column_name
Definition meta.hpp:29
int epsg
Definition meta.hpp:33
Definition meta.hpp:43
int ordinal
One-based.
Definition meta.hpp:51
bool partial
Definition meta.hpp:48
bool primary
Definition meta.hpp:49
std::string column_name
Definition meta.hpp:46
std::string index_name
Definition meta.hpp:45
bool descending
Definition meta.hpp:47
std::string schema_name
Definition meta.hpp:44
bool unique
Definition meta.hpp:50
Definition meta.hpp:18
std::string table_name
Definition meta.hpp:20
std::string column_name
Definition meta.hpp:21
friend bool operator==(layer const &, layer const &)=default
std::string schema_name
Definition meta.hpp:19
bool raster
Definition meta.hpp:22
Definition meta.hpp:76
std::string column_name
Definition meta.hpp:77
bool descending
Definition meta.hpp:78
Definition meta.hpp:81
int limit
Definition meta.hpp:85
std::vector< order_key > order_by
Definition meta.hpp:83
size_t offset
Definition meta.hpp:84
std::vector< std::string > select_list
Definition meta.hpp:82
Definition meta.hpp:93
std::string proj4
Definition meta.hpp:108
double xorig
Definition meta.hpp:99
std::string column_name
Definition meta.hpp:96
double yskew
Definition meta.hpp:104
geometry::raster::point extent
Definition meta.hpp:98
std::vector< band > bands
Definition meta.hpp:97
std::string table_name
Definition meta.hpp:95
double xscale
Definition meta.hpp:101
double yorig
Definition meta.hpp:100
int epsg
Definition meta.hpp:106
int srid
Definition meta.hpp:105
std::string wkt
Definition meta.hpp:107
double yscale
Definition meta.hpp:102
std::string schema_name
Definition meta.hpp:94
double xskew
Definition meta.hpp:103
Definition meta.hpp:13
std::string source_name
Definition meta.hpp:14
std::string address
Definition meta.hpp:15
Definition meta.hpp:54
std::vector< index_key > index_keys
Definition meta.hpp:59
std::string table_name
Definition meta.hpp:57
std::string schema_name
Definition meta.hpp:56
std::vector< column > columns
Definition meta.hpp:58
std::string dbms
Lowercase.
Definition meta.hpp:55
model::box< point > box
Definition vocabulary.hpp:71
model::d2::point_xy< int, cs::cartesian > point
Definition vocabulary.hpp:65