-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhosp.sql
131 lines (130 loc) · 6.06 KB
/
hosp.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
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
gid | objectid | latitude | longitude
-------+----------+--------------+--------------
11054 | 12119 | -35.02239343 | 137.60372179
11225 | 12436 | -34.91150523 | 138.58754497
11588 | 12664 | -34.06307920 | 137.58892735
13642 | 14518 | -35.65404972 | 137.63992144
13885 | 14976 | -32.11878000 | 133.67253000
14051 | 13450 | -36.31322904 | 140.77977612
15750 | 16715 | -33.60291568 | 137.93346848
16832 | 15920 | -34.72571263 | 135.84876588
16901 | 15941 | -32.51129991 | 137.77470330
17013 | 15390 | -33.69963455 | 136.49270551
17575 | 19639 | -32.87973411 | 138.34947425
18374 | 18384 | -34.06231919 | 137.58759734
18393 | 17675 | -34.92063532 | 138.60032496
18482 | 18428 | -34.37194827 | 137.67291331
20738 | 20188 | -34.88382546 | 138.59224548
21466 | 20360 | -34.85415615 | 138.63800650
21485 | 20529 | -34.96526543 | 138.63376462
21858 | 23087 | -34.86077596 | 138.62470624
22495 | 23627 | -32.35259351 | 138.03688855
22556 | 23519 | -34.85084624 | 138.64410663
22698 | 22000 | -33.78849766 | 138.21154873
22853 | 22303 | -34.96069515 | 138.60633437
22870 | 22842 | -34.87226569 | 138.60705584
23144 | 21838 | -34.95820545 | 138.63228472
24447 | 25094 | -33.17885880 | 138.00384582
24626 | 25687 | -34.52950166 | 138.95974560
24990 | 24149 | -34.93137537 | 138.61047490
25444 | 24705 | -32.79271000 | 134.21750000
25915 | 27665 | -34.91309535 | 138.59855507
26025 | 27420 | -34.88541477 | 138.53186475
26432 | 27257 | -34.99244475 | 138.58860364
26619 | 27974 | -34.91772326 | 139.30792341
27414 | 27218 | -33.21383520 | 138.61496223
27663 | 26467 | -34.18387484 | 139.98365340
27954 | 26821 | -34.83554683 | 138.68924741
28289 | 29554 | -34.74891706 | 138.66327853
28439 | 29842 | -34.77523126 | 139.05328270
28502 | 29855 | -34.91297534 | 138.59783506
28554 | 29618 | -37.83848154 | 140.76923038
28828 | 29696 | -34.91309535 | 138.59855507
28829 | 29697 | -34.92914569 | 138.63742526
28933 | 30118 | -34.87682491 | 138.53972498
29082 | 29499 | -34.25078978 | 140.47035832
30324 | 31920 | -36.83675744 | 139.84720698
30479 | 32400 | -34.93527541 | 138.61595490
30403 | 31950 | -36.96819698 | 140.74286602
30614 | 32442 | -36.31342134 | 140.76536789
30982 | 31851 | -35.69490381 | 139.33453891
31468 | 30668 | -33.92891051 | 137.63530001
31678 | 30727 | -34.26552937 | 135.73115473
33763 | 33634 | -37.38433535 | 140.83505966
34419 | 35855 | -34.91454534 | 138.59857504
35756 | 35598 | -34.92167539 | 138.60647502
37017 | 38263 | -34.82764902 | 138.88019979
37095 | 38283 | -35.69490381 | 139.33453891
37955 | 37872 | -34.92938538 | 138.61029494
38079 | 37960 | -34.95761820 | 138.87669761
38571 | 37529 | -35.65404972 | 137.63992144
39466 | 40190 | -34.87683491 | 138.53972498
39888 | 39927 | -34.43582720 | 138.50872183
40044 | 39999 | -35.25891904 | 140.90097748
40756 | 39705 | -34.90894538 | 138.59930515
40809 | 39444 | -34.92227538 | 138.60666501
41577 | 42344 | -34.86246590 | 138.62037616
41711 | 42369 | -35.13083167 | 139.27869953
41796 | 42402 | -35.00587384 | 138.51493255
41848 | 42403 | -35.00587384 | 138.51493255
42006 | 41941 | -34.91309535 | 138.59855507
42211 | 42244 | -34.98658392 | 138.51153283
42225 | 42172 | -34.99093391 | 138.51323278
42288 | 42283 | -35.00587384 | 138.51494255
43369 | 45491 | -35.32970432 | 140.51314141
45554 | 46923 | -33.84804039 | 138.49114100
45908 | 46819 | -34.91292534 | 138.59780506
46248 | 46441 | -34.42772065 | 137.91593515
46543 | 45919 | -31.89467984 | 138.42651953
47305 | 49325 | -34.93423549 | 138.62295500
47569 | 48332 | -34.85192616 | 138.63755654
47711 | 48369 | -35.08355736 | 138.86925543
48406 | 48217 | -34.16602318 | 140.74337305
48505 | 48295 | -34.93604538 | 138.61410487
48607 | 47627 | -37.60007831 | 140.35771949
48939 | 47475 | -34.83524450 | 138.48099498
48993 | 47492 | -35.00862606 | 138.71351483
49250 | 51446 | -34.99138389 | 138.51124275
49402 | 50692 | -34.93469541 | 138.61609492
49623 | 50993 | -34.94473548 | 138.62707488
49773 | 51162 | -34.86348593 | 138.62382618
50467 | 50361 | -34.91297534 | 138.59783506
50492 | 49878 | -34.36032949 | 138.67590499
51904 | 52934 | -34.88431622 | 138.66037627
52077 | 53359 | -34.45734035 | 138.80379493
53188 | 52363 | -34.84789440 | 138.47907475
53477 | 55621 | -34.45593971 | 140.56331623
54392 | 54399 | -35.56279139 | 138.60568422
55258 | 54316 | -34.87683491 | 138.53972498
55327 | 54338 | -34.94254532 | 138.61167473
55558 | 57724 | -34.14122792 | 138.41866552
55585 | 57076 | -33.68691609 | 138.93292864
55806 | 57811 | -34.92161539 | 138.60713503
55958 | 57857 | -30.59332506 | 138.39730101
56078 | 57577 | -37.85938223 | 140.84001092
56585 | 56269 | -34.59842897 | 138.75382205
57081 | 55851 | -35.00415496 | 138.61321373
58164 | 60191 | -31.20304076 | 136.82426882
58290 | 59606 | -33.03515793 | 137.57617594
59758 | 58086 | -34.27700105 | 140.59970952
61883 | 60950 | -30.44389367 | 137.16688772
62584 | 60778 | -29.65106289 | 138.06085893
64672 | 66968 | -34.89325237 | 138.61011336
64960 | 66468 | -34.94959958 | 138.57535924
64961 | 66469 | -34.92682715 | 138.56620469
65001 | 67104 | -34.75720093 | 138.65499819
65826 | 65606 | -36.83677661 | 139.84711908
67028 | 67712 | -34.95066943 | 138.62354202
67157 | 67250 | -35.02317433 | 138.56736288
67222 | 67284 | -34.92911095 | 138.63729255
67239 | 67537 | -35.00692509 | 138.62639384
218 | 253 | -34.99138389 | 138.51124275
1397 | 1492 | -34.77557487 | 137.59239578
2107 | 3908 | -27.54657000 | 135.44454000
2853 | 3644 | -34.90802961 | 138.61213016
2855 | 3646 | -34.95824837 | 138.64320969
3016 | 2064 | -33.95891126 | 137.71880046
4847 | 5252 | -34.37194827 | 137.67291331
7871 | 7008 | -33.68727656 | 136.91981056
8645 | 9854 | -33.05183691 | 135.46577677
(127 rows)