forked from google/open-location-code
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathtests_script_l.sql
More file actions
152 lines (138 loc) · 4.14 KB
/
Copy pathtests_script_l.sql
File metadata and controls
152 lines (138 loc) · 4.14 KB
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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
--Test script for openlocationcode functions
--###############################################################
--pluscode_latitudeToInteger
select pluscode_latitudeToInteger(149.18);
-- pluscode_latitudeToInteger
-----------------
-- 4499999999
-- (1 row)
--###############################################################
--pluscode_cliplatitude
select pluscode_cliplatitude(149.18);
-- pluscode_cliplatitude
-----------------
-- 90
-- (1 row)
select pluscode_cliplatitude(49.18);
-- pluscode_cliplatitude
---------------------
-- 49.18
-- (1 row)
--###############################################################
--pluscode_normalizelongitude
select pluscode_normalizelongitude(188.18);
-- pluscode_normalizelongitude
---------------------------
-- -171.82
-- (1 row)
select pluscode_normalizelongitude(288.18);
-- pluscode_normalizelongitude
---------------------------
-- -71.82
-- (1 row)
--###############################################################
--pluscode_isvalid
select pluscode_isvalid('XX5JJC23+23');
-- pluscode_isvalid
----------------
-- t
-- (1 row)
select pluscode_isvalid('XX5JJC23+0025');
-- pluscode_isvalid
----------------
-- f
-- (1 row)
--###############################################################
--pluscode_codearea
select pluscode_codearea(49.1805,-0.378625,49.180625,-0.3785,10::int);
-- pluscode_codearea
--------------------------------------------------------------
-- (49.1805,-0.378625,49.180625,-0.3785,10,49.1805625,-0.3785625)
-- (1 row)
select pluscode_codearea(49.1805,-1000000,49.180625,-0.3785,9::int);
-- pluscode_codearea
---------------------------------------------------------------
-- (49.1805,-1000000,49.180625,-0.3785,9,49.1805625,-500000.18925)
-- (1 row)
--###############################################################
-- pluscode_isshort
select pluscode_isshort('XX5JJC+');
-- pluscode_isshort
----------------
-- t
-- (1 row)
select pluscode_isshort('XX5JJC+23');
-- pluscode_isshort
----------------
-- t
-- (1 row)
--###############################################################
-- pluscode_isfull
select pluscode_isfull('cccccc23+');
-- pluscode_isfull
---------------
-- t
-- (1 row)
select pluscode_isfull('cccccc23+24');
-- pluscode_isfull
---------------
-- t
-- (1 row)
--###############################################################
-- pluscode_encode
select pluscode_encode(49.05,-0.108,12);
-- pluscode_encode
---------------
-- 8CXX3V2R+2R22
-- (1 row)
select pluscode_encode(49.05,-0.108);
-- pluscode_encode
---------------
-- 8CXX3V2R+2R
-- (1 row)
--###############################################################
--pluscode_decode
select pluscode_decode('CCCCCCCC+');
-- pluscode_decode
----------------------------------------------------
-- (78.42,-11.58,78.4225,-11.5775,8,78.42125,-11.57875)
-- (1 row)
select pluscode_decode('CC23CCCC+');
-- pluscode_decode
----------------------------------------------------
-- (70.42,-18.58,70.4225,-18.5775,8,70.42125,-18.57875)
-- (1 row)
select pluscode_decode('CCCCCCCC+23');
-- pluscode_decode
----------------------------------------------------------------
-- (78.42,-11.579875,78.420125,-11.57975,10,78.4200625,-11.5798125)
-- (1 row)
--###############################################################
--pluscode_shorten
select pluscode_shorten('8CXX5JJC+6H6H6H',49.18,-0.37);
-- pluscode_shorten
----------------
-- JC+6H6H6H
-- (1 row)
select pluscode_shorten('8CXX5JJC+',49.18,-0.37);
-- pluscode_shorten
----------------
-- JC+
-- (1 row)
--###############################################################
--pluscode_recovernearest
select pluscode_recovernearest('XX5JJC+', 49.1805,-0.3786);
-- pluscode_recovernearest
-----------------------
-- 8CXX5JJC+
-- (1 row)
select pluscode_recovernearest('XX5JJC+23', 49.1805,-0.3786);
-- pluscode_recovernearest
-----------------------
-- 8CXX5JJC+23
-- (1 row)
select pluscode_recovernearest('XX5JJC+2323', 49,-0.3);
-- pluscode_recovernearest
-----------------------
-- 8CXX5JJC+2322
-- (1 row)