File: legacy_query_expected

package info (click to toggle)
postgis 2.5.1%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 75,792 kB
  • sloc: ansic: 139,314; sql: 136,281; xml: 48,954; sh: 4,906; perl: 4,509; makefile: 2,897; python: 1,198; yacc: 441; cpp: 305; lex: 132
file content (50 lines) | stat: -rw-r--r-- 1,840 bytes parent folder | download | duplicates (5)
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
BEGIN
t
9
22
26
COMMIT
BEGIN
1
2
3
COMMIT
4
features.big_parcels.the_geom SRID:0 TYPE:MULTIPOLYGON DIMS:2 
5
6
features.big_signs.the_geom SRID:0 TYPE:MULTIPOINT DIMS:2 
BEGIN
P1|1|MULTIPOLYGON(((21 14,21 6,9 6,9 14,9 22,21 22,21 14)))
P2|2|MULTIPOLYGON(((35 14,35 6,21 6,21 14,21 22,35 22,35 14)))
P3|3|MULTIPOLYGON(((47 14,47 6,35 6,35 14,35 22,47 22,47 14)))
P4|4|MULTIPOLYGON(((25 30,17 30,17 40,31 40,31 30,25 30)))
P5|5|MULTIPOLYGON(((8 30,3 30,3 38,16 38,16 30,8 30),(4 31,7 31,7 34,4 34,4 31)))
F3|6|MULTIPOLYGON(((9 22,21 22,21 14,9 14,9 22)))
F6|7|MULTIPOLYGON(((9 14,21 14,21 6,9 6,9 14)))
F3F4|8|MULTIPOLYGON(((9 22,21 22,35 22,35 14,21 14,9 14,9 22)))
F1|9|MULTIPOLYGON(((8 30,3 30,3 38,16 38,16 30,8 30),(4 31,7 31,7 34,4 34,4 31)))
S1|1|MULTIPOINT(21 14)
S2|2|MULTIPOINT(35 14)
S3|3|MULTIPOINT(57 33)
S4|4|MULTIPOINT(20 37)
N1N2N3|5|MULTIPOINT(8 30,25 30,25 35)
N1N6N14|6|MULTIPOINT(8 30,21 14,57 33)
N3N4|7|MULTIPOINT(20 37,25 35)
N4|8|MULTIPOINT(20 37)
R1|1|MULTILINESTRING((9 14,21 14,35 14))
R2|2|MULTILINESTRING((36 38,38 35,41 34,42 33,45 32,47 28,50 28,52 32,57 33,57 36,59 39,61 38,62 41,47 42,45 40,41 40))
R3|3|MULTILINESTRING((9 35,13 35))
R4|4|MULTILINESTRING((25 30,25 35))
E7E8|5|MULTILINESTRING((21 22,35 22,47 22))
E20E19|6|MULTILINESTRING((21 6,21 14,21 22))
E25|7|MULTILINESTRING((9 35,13 35))
R1a|8|MULTILINESTRING((9 14,21 14,35 14))
S1S2|MULTIPOINT(21 14,35 14)
R1R2|MULTILINESTRING((9 14,21 14,35 14),(36 38,38 35,41 34,42 33,45 32,47 28,50 28,52 32,57 33,57 36,59 39,61 38,62 41,47 42,45 40,41 40))
R4|MULTILINESTRING((25 30,25 35))
P1P2|MULTIPOLYGON(((21 6,9 6,9 14,9 22,21 22,35 22,35 14,35 6,21 6)))
P3P4|MULTIPOLYGON(((47 14,47 6,35 6,35 14,35 22,47 22,47 14)),((25 30,17 30,17 40,31 40,31 30,25 30)))
F3F6|MULTIPOLYGON(((21 14,21 6,9 6,9 14,9 22,21 22,21 14)))
COMMIT
Topology 'city_data' dropped