I now have it put in place along with the PSMSL and WPS seaport databases.
But, there are still integration issues to be worked out because the weather records begin in 1880 and proceed to 2016 (one month so far).
The other data sets may begin and end at other times, so integration requires synchronization.
Anyway, I said in the previous post:
I completed the downloading and preliminary implementing of the GISS databases.(It Is A Lovely Day In The Neighborhood). The very next day, on Monday, the work of some scientists was published.
They are now located within the Dredd Blog SQL database system.
Man, over a million months of weather data, geological, and flora data about those stations.
To be exact, there are 4,813,380 monthly GISS temperature records within 401,115 annual temperature records at 7,364 weather stations.
The really neato part is that I have associated them with the Dredd Blog Zone, quadrant, and sub-quadrant system.
So now I can fuse them with the tide gauge stations and seaports within a small area, and graph the sea level change, temperatures, and the impact those have on seaports in that area over the years.
Their work concerned the same question (what impact does temperature change have on sea level change?).
They had been working for some time on the idea of combining temperature and sea level change data (Temperature-driven global sea-level variability in the Common Era).
Their effort was about knowledge "motivating the construction of a semiempirical model that relates the rate of GSL change to global mean temperature" (ibid, at p. 5).
I like their paper, except for the use of global mean average sea level and temperature to argue their points.
Regular readers know that I divide the globe up into small latitude and longitude sections called "Zones, zone quadrants, and zone sub-quadrants" (e.g. The Warming Science Commentariat - 2).
I have the databases set up in a way that I can focus on relevant tide gauge stations, seaports, and now weather stations, within a small area.
IMO, the use of temperature and sea level change data within those relatively small zones can better inform those who live and work in those zones.
Here are the zones that qualify with at least 1 PSMSL tide gauge station, at least 1 seaport, and at least 1 weather station:
1) Zone AA.SW.SE [lat (67.5, 60) lon (-150, -165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 18
WPS ports in this zone: 14
2) Zone AA.SE.NE [lat (75, 67.5) lon (-120, -135)]
PSMSL stations in this zone: 1
GISS stations in this zone: 6
WPS ports in this zone: 6
3) Zone AA.SE.SW [lat (67.5, 60) lon (-135, -150)]
PSMSL stations in this zone: 4
GISS stations in this zone: 33
WPS ports in this zone: 13
4) Zone AB.NE.SE [lat (82.5, 75) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 1
5) Zone AC.SE.SW [lat (67.5, 60) lon (-15, -30)]
PSMSL stations in this zone: 1
GISS stations in this zone: 7
WPS ports in this zone: 22
6) Zone AC.SE.SE [lat (67.5, 60) lon (0, -15)]
PSMSL stations in this zone: 2
GISS stations in this zone: 3
WPS ports in this zone: 18
7) Zone AD.NW.SW [lat (82.5, 75) lon (15, 0)]
PSMSL stations in this zone: 2
GISS stations in this zone: 1
WPS ports in this zone: 2
8) Zone AD.SW.NE [lat (75, 67.5) lon (30, 15)]
PSMSL stations in this zone: 6
GISS stations in this zone: 11
WPS ports in this zone: 28
9) Zone AD.SW.SW [lat (67.5, 60) lon (15, 0)]
PSMSL stations in this zone: 7
GISS stations in this zone: 15
WPS ports in this zone: 44
10) Zone AD.SW.SE [lat (67.5, 60) lon (30, 15)]
PSMSL stations in this zone: 17
GISS stations in this zone: 23
WPS ports in this zone: 81
11) Zone AD.SE.NW [lat (75, 67.5) lon (45, 30)]
PSMSL stations in this zone: 2
GISS stations in this zone: 4
WPS ports in this zone: 5
12) Zone AE.SW.NW [lat (75, 67.5) lon (75, 60)]
PSMSL stations in this zone: 2
GISS stations in this zone: 1
WPS ports in this zone: 1
13) Zone AE.SW.NE [lat (75, 67.5) lon (90, 75)]
PSMSL stations in this zone: 2
GISS stations in this zone: 2
WPS ports in this zone: 3
14) Zone AF.SW.NW [lat (75, 67.5) lon (135, 120)]
PSMSL stations in this zone: 2
GISS stations in this zone: 2
WPS ports in this zone: 1
15) Zone AG.NW.NW [lat (60, 52.5) lon (-165, -180)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 6
16) Zone AG.NW.NE [lat (60, 52.5) lon (-150, -165)]
PSMSL stations in this zone: 3
GISS stations in this zone: 5
WPS ports in this zone: 42
17) Zone AG.NW.SW [lat (52.5, 45) lon (-165, -180)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 2
18) Zone AG.NE.NW [lat (60, 52.5) lon (-135, -150)]
PSMSL stations in this zone: 3
GISS stations in this zone: 8
WPS ports in this zone: 14
19) Zone AG.NE.NE [lat (60, 52.5) lon (-120, -135)]
PSMSL stations in this zone: 4
GISS stations in this zone: 74
WPS ports in this zone: 47
20) Zone AG.NE.SE [lat (52.5, 45) lon (-120, -135)]
PSMSL stations in this zone: 18
GISS stations in this zone: 118
WPS ports in this zone: 102
21) Zone AG.SE.NE [lat (45, 37.5) lon (-120, -135)]
PSMSL stations in this zone: 9
GISS stations in this zone: 74
WPS ports in this zone: 48
22) Zone AG.SE.SE [lat (37.5, 30) lon (-120, -135)]
PSMSL stations in this zone: 2
GISS stations in this zone: 15
WPS ports in this zone: 8
23) Zone AH.NW.NE [lat (60, 52.5) lon (-90, -105)]
PSMSL stations in this zone: 1
GISS stations in this zone: 36
WPS ports in this zone: 1
24) Zone AH.NE.SE [lat (52.5, 45) lon (-60, -75)]
PSMSL stations in this zone: 17
GISS stations in this zone: 129
WPS ports in this zone: 66
25) Zone AH.SW.SW [lat (37.5, 30) lon (-105, -120)]
PSMSL stations in this zone: 5
GISS stations in this zone: 150
WPS ports in this zone: 16
26) Zone AH.SE.NW [lat (45, 37.5) lon (-75, -90)]
PSMSL stations in this zone: 8
GISS stations in this zone: 367
WPS ports in this zone: 157
27) Zone AH.SE.NE [lat (45, 37.5) lon (-60, -75)]
PSMSL stations in this zone: 17
GISS stations in this zone: 129
WPS ports in this zone: 147
28) Zone AH.SE.SW [lat (37.5, 30) lon (-75, -90)]
PSMSL stations in this zone: 14
GISS stations in this zone: 241
WPS ports in this zone: 38
29) Zone AH.SE.SE [lat (37.5, 30) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 3
30) Zone AI.NW.SW [lat (52.5, 45) lon (-45, -60)]
PSMSL stations in this zone: 3
GISS stations in this zone: 44
WPS ports in this zone: 34
31) Zone AI.NE.NE [lat (60, 52.5) lon (0, -15)]
PSMSL stations in this zone: 13
GISS stations in this zone: 38
WPS ports in this zone: 133
32) Zone AI.NE.SE [lat (52.5, 45) lon (0, -15)]
PSMSL stations in this zone: 12
GISS stations in this zone: 30
WPS ports in this zone: 82
33) Zone AI.SE.NW [lat (45, 37.5) lon (-15, -30)]
PSMSL stations in this zone: 1
GISS stations in this zone: 4
WPS ports in this zone: 5
34) Zone AI.SE.NE [lat (45, 37.5) lon (0, -15)]
PSMSL stations in this zone: 5
GISS stations in this zone: 37
WPS ports in this zone: 31
35) Zone AI.SE.SW [lat (37.5, 30) lon (-15, -30)]
PSMSL stations in this zone: 1
GISS stations in this zone: 3
WPS ports in this zone: 2
36) Zone AI.SE.SE [lat (37.5, 30) lon (0, -15)]
PSMSL stations in this zone: 6
GISS stations in this zone: 37
WPS ports in this zone: 36
37) Zone AJ.NW.NW [lat (60, 52.5) lon (15, 0)]
PSMSL stations in this zone: 40
GISS stations in this zone: 42
WPS ports in this zone: 186
38) Zone AJ.NW.NE [lat (60, 52.5) lon (30, 15)]
PSMSL stations in this zone: 9
GISS stations in this zone: 46
WPS ports in this zone: 55
39) Zone AJ.NW.SW [lat (52.5, 45) lon (15, 0)]
PSMSL stations in this zone: 19
GISS stations in this zone: 145
WPS ports in this zone: 67
40) Zone AJ.SW.NW [lat (45, 37.5) lon (15, 0)]
PSMSL stations in this zone: 4
GISS stations in this zone: 75
WPS ports in this zone: 82
41) Zone AJ.SW.NE [lat (45, 37.5) lon (30, 15)]
PSMSL stations in this zone: 14
GISS stations in this zone: 144
WPS ports in this zone: 114
42) Zone AJ.SW.SE [lat (37.5, 30) lon (30, 15)]
PSMSL stations in this zone: 6
GISS stations in this zone: 32
WPS ports in this zone: 39
43) Zone AJ.SE.NW [lat (45, 37.5) lon (45, 30)]
PSMSL stations in this zone: 3
GISS stations in this zone: 158
WPS ports in this zone: 25
44) Zone AL.NW.SE [lat (52.5, 45) lon (150, 135)]
PSMSL stations in this zone: 1
GISS stations in this zone: 9
WPS ports in this zone: 13
45) Zone AL.NE.NW [lat (60, 52.5) lon (165, 150)]
PSMSL stations in this zone: 2
GISS stations in this zone: 7
WPS ports in this zone: 2
46) Zone AL.SW.NW [lat (45, 37.5) lon (135, 120)]
PSMSL stations in this zone: 3
GISS stations in this zone: 71
WPS ports in this zone: 32
47) Zone AL.SW.NE [lat (45, 37.5) lon (150, 135)]
PSMSL stations in this zone: 20
GISS stations in this zone: 39
WPS ports in this zone: 33
48) Zone AL.SW.SW [lat (37.5, 30) lon (135, 120)]
PSMSL stations in this zone: 48
GISS stations in this zone: 120
WPS ports in this zone: 100
49) Zone AL.SW.SE [lat (37.5, 30) lon (150, 135)]
PSMSL stations in this zone: 35
GISS stations in this zone: 61
WPS ports in this zone: 49
50) Zone AM.NW.NW [lat (30, 22.5) lon (-165, -180)]
PSMSL stations in this zone: 2
GISS stations in this zone: 1
WPS ports in this zone: 2
51) Zone AM.NW.SW [lat (22.5, 15) lon (-165, -180)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 1
52) Zone AM.NW.SE [lat (22.5, 15) lon (-150, -165)]
PSMSL stations in this zone: 5
GISS stations in this zone: 15
WPS ports in this zone: 24
53) Zone AM.SW.SE [lat (7.5, 0) lon (-150, -165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 1
54) Zone AN.NW.NE [lat (30, 22.5) lon (-90, -105)]
PSMSL stations in this zone: 5
GISS stations in this zone: 61
WPS ports in this zone: 29
55) Zone AN.NW.SE [lat (22.5, 15) lon (-90, -105)]
PSMSL stations in this zone: 1
GISS stations in this zone: 52
WPS ports in this zone: 16
56) Zone AN.NE.NW [lat (30, 22.5) lon (-75, -90)]
PSMSL stations in this zone: 7
GISS stations in this zone: 37
WPS ports in this zone: 26
57) Zone AN.NE.SW [lat (22.5, 15) lon (-75, -90)]
PSMSL stations in this zone: 3
GISS stations in this zone: 36
WPS ports in this zone: 43
58) Zone AN.NE.SE [lat (22.5, 15) lon (-60, -75)]
PSMSL stations in this zone: 4
GISS stations in this zone: 52
WPS ports in this zone: 58
59) Zone AN.SE.NW [lat (15, 7.5) lon (-75, -90)]
PSMSL stations in this zone: 1
GISS stations in this zone: 34
WPS ports in this zone: 32
60) Zone AN.SE.NE [lat (15, 7.5) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 24
WPS ports in this zone: 61
61) Zone AO.NE.NE [lat (30, 22.5) lon (0, -15)]
PSMSL stations in this zone: 1
GISS stations in this zone: 6
WPS ports in this zone: 3
62) Zone AO.SE.SE [lat (7.5, 0) lon (0, -15)]
PSMSL stations in this zone: 1
GISS stations in this zone: 16
WPS ports in this zone: 12
63) Zone AP.SE.NW [lat (15, 7.5) lon (45, 30)]
PSMSL stations in this zone: 1
GISS stations in this zone: 26
WPS ports in this zone: 6
64) Zone AQ.NW.NW [lat (30, 22.5) lon (75, 60)]
PSMSL stations in this zone: 2
GISS stations in this zone: 31
WPS ports in this zone: 10
65) Zone AQ.NW.NE [lat (30, 22.5) lon (90, 75)]
PSMSL stations in this zone: 2
GISS stations in this zone: 31
WPS ports in this zone: 1
66) Zone AQ.NW.SW [lat (22.5, 15) lon (75, 60)]
PSMSL stations in this zone: 3
GISS stations in this zone: 8
WPS ports in this zone: 14
67) Zone AQ.NW.SE [lat (22.5, 15) lon (90, 75)]
PSMSL stations in this zone: 5
GISS stations in this zone: 7
WPS ports in this zone: 6
68) Zone AQ.NE.NE [lat (30, 22.5) lon (120, 105)]
PSMSL stations in this zone: 1
GISS stations in this zone: 83
WPS ports in this zone: 17
69) Zone AQ.NE.SE [lat (22.5, 15) lon (120, 105)]
PSMSL stations in this zone: 5
GISS stations in this zone: 23
WPS ports in this zone: 21
70) Zone AQ.SW.NW [lat (15, 7.5) lon (75, 60)]
PSMSL stations in this zone: 2
GISS stations in this zone: 3
WPS ports in this zone: 3
71) Zone AQ.SW.NE [lat (15, 7.5) lon (90, 75)]
PSMSL stations in this zone: 3
GISS stations in this zone: 12
WPS ports in this zone: 16
72) Zone AQ.SE.NW [lat (15, 7.5) lon (105, 90)]
PSMSL stations in this zone: 4
GISS stations in this zone: 22
WPS ports in this zone: 24
73) Zone AQ.SE.NE [lat (15, 7.5) lon (120, 105)]
PSMSL stations in this zone: 1
GISS stations in this zone: 6
WPS ports in this zone: 12
74) Zone AQ.SE.SW [lat (7.5, 0) lon (105, 90)]
PSMSL stations in this zone: 7
GISS stations in this zone: 19
WPS ports in this zone: 43
75) Zone AR.NW.NW [lat (30, 22.5) lon (135, 120)]
PSMSL stations in this zone: 5
GISS stations in this zone: 24
WPS ports in this zone: 20
76) Zone AR.NW.SE [lat (22.5, 15) lon (150, 135)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 1
77) Zone AR.NE.SE [lat (22.5, 15) lon (180, 165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 1
78) Zone AR.SW.NW [lat (15, 7.5) lon (135, 120)]
PSMSL stations in this zone: 3
GISS stations in this zone: 37
WPS ports in this zone: 54
79) Zone AR.SW.NE [lat (15, 7.5) lon (150, 135)]
PSMSL stations in this zone: 2
GISS stations in this zone: 7
WPS ports in this zone: 4
80) Zone AR.SW.SW [lat (7.5, 0) lon (135, 120)]
PSMSL stations in this zone: 2
GISS stations in this zone: 16
WPS ports in this zone: 17
81) Zone AR.SE.NE [lat (15, 7.5) lon (180, 165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 1
82) Zone AR.SE.SW [lat (7.5, 0) lon (165, 150)]
PSMSL stations in this zone: 1
GISS stations in this zone: 10
WPS ports in this zone: 3
83) Zone AR.SE.SE [lat (7.5, 0) lon (180, 165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 2
84) Zone AS.NW.NW [lat (0, -7.5) lon (-165, -180)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 1
85) Zone AS.NW.SW [lat (-7.5, -15) lon (-165, -180)]
PSMSL stations in this zone: 1
GISS stations in this zone: 6
WPS ports in this zone: 3
86) Zone AS.SE.NW [lat (-15, -22.5) lon (-135, -150)]
PSMSL stations in this zone: 1
GISS stations in this zone: 4
WPS ports in this zone: 1
87) Zone AS.SE.SE [lat (-22.5, -30) lon (-120, -135)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 1
88) Zone AT.NE.NW [lat (0, -7.5) lon (-75, -90)]
PSMSL stations in this zone: 1
GISS stations in this zone: 35
WPS ports in this zone: 11
89) Zone AT.SE.SE [lat (-22.5, -30) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 21
WPS ports in this zone: 9
90) Zone AU.SW.SW [lat (-22.5, -30) lon (-45, -60)]
PSMSL stations in this zone: 1
GISS stations in this zone: 26
WPS ports in this zone: 9
91) Zone AU.SW.SE [lat (-22.5, -30) lon (-30, -45)]
PSMSL stations in this zone: 1
GISS stations in this zone: 1
WPS ports in this zone: 7
92) Zone AV.SW.SE [lat (-22.5, -30) lon (30, 15)]
PSMSL stations in this zone: 2
GISS stations in this zone: 38
WPS ports in this zone: 1
93) Zone AV.SE.NE [lat (-15, -22.5) lon (60, 45)]
PSMSL stations in this zone: 1
GISS stations in this zone: 10
WPS ports in this zone: 10
94) Zone AV.SE.SW [lat (-22.5, -30) lon (45, 30)]
PSMSL stations in this zone: 3
GISS stations in this zone: 10
WPS ports in this zone: 5
95) Zone AW.SE.NE [lat (-15, -22.5) lon (120, 105)]
PSMSL stations in this zone: 2
GISS stations in this zone: 12
WPS ports in this zone: 5
96) Zone AW.SE.SE [lat (-22.5, -30) lon (120, 105)]
PSMSL stations in this zone: 1
GISS stations in this zone: 23
WPS ports in this zone: 3
97) Zone AX.NW.SE [lat (-7.5, -15) lon (150, 135)]
PSMSL stations in this zone: 2
GISS stations in this zone: 11
WPS ports in this zone: 10
98) Zone AX.SW.NE [lat (-15, -22.5) lon (150, 135)]
PSMSL stations in this zone: 4
GISS stations in this zone: 37
WPS ports in this zone: 7
99) Zone AX.SE.NE [lat (-15, -22.5) lon (180, 165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 10
WPS ports in this zone: 11
100) Zone AX.SE.SW [lat (-22.5, -30) lon (165, 150)]
PSMSL stations in this zone: 3
GISS stations in this zone: 55
WPS ports in this zone: 5
101) Zone AZ.NE.NE [lat (-30, -37.5) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 30
WPS ports in this zone: 19
102) Zone AZ.SE.NE [lat (-45, -52.5) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 11
WPS ports in this zone: 8
103) Zone AZ.SE.SE [lat (-52.5, -60) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 4
WPS ports in this zone: 12
104) Zone A0.NW.NW [lat (-30, -37.5) lon (-45, -60)]
PSMSL stations in this zone: 3
GISS stations in this zone: 29
WPS ports in this zone: 20
105) Zone A0.NW.SW [lat (-37.5, -45) lon (-45, -60)]
PSMSL stations in this zone: 1
GISS stations in this zone: 2
WPS ports in this zone: 2
106) Zone A1.NW.NE [lat (-30, -37.5) lon (30, 15)]
PSMSL stations in this zone: 6
GISS stations in this zone: 32
WPS ports in this zone: 6
107) Zone A2.NE.NE [lat (-30, -37.5) lon (120, 105)]
PSMSL stations in this zone: 2
GISS stations in this zone: 41
WPS ports in this zone: 3
108) Zone A3.NW.NE [lat (-30, -37.5) lon (150, 135)]
PSMSL stations in this zone: 5
GISS stations in this zone: 166
WPS ports in this zone: 11
109) Zone A3.NE.NW [lat (-30, -37.5) lon (165, 150)]
PSMSL stations in this zone: 2
GISS stations in this zone: 47
WPS ports in this zone: 6
110) Zone A3.NE.NE [lat (-30, -37.5) lon (180, 165)]
PSMSL stations in this zone: 1
GISS stations in this zone: 6
WPS ports in this zone: 5
111) Zone A3.NE.SE [lat (-37.5, -45) lon (180, 165)]
PSMSL stations in this zone: 8
GISS stations in this zone: 8
WPS ports in this zone: 15
112) Zone A3.SE.NE [lat (-45, -52.5) lon (180, 165)]
PSMSL stations in this zone: 2
GISS stations in this zone: 4
WPS ports in this zone: 2
113) Zone A5.NE.NE [lat (-60, -67.5) lon (-60, -75)]
PSMSL stations in this zone: 1
GISS stations in this zone: 14
WPS ports in this zone: 4
Links:
PSMSL website
GISS website
WPS website
Total Zones qualifying: 113
Total PSMSL (tide gauge) stations: 546
Total GISS (weather) stations: 4,024
Total WPS seaports: 2,852
Now, I am working on generating graphs which integrate the various types of data.
meanwhile ...
113 Zones! Is a lot of effort Dredd! Any plans to make SLC a data feed on something like Earth.nullschool.net? Once people's shoes get wet or 'their' ocean recedes, they'll begin to pay attention, you betcha! great work!
ReplyDeleteThe 133 out of 576 sub-Quadrants qualified because they have at least one of all three relevant entities.
ReplyDeleteThat is, at least 1 PSMSL tide gauge station, as well as at least 1 GISS weather station, and also at least 1 WPS seaport.
I commonly call all of the 3 types of square areas "zones."
However, technically there are only 36 "Zones" (e.g. "AA"), 144 "Quadrants" (e.g. "AA.NW", "AA.NE", "AA.SW", "AA.SE"), and 576 "sub-Quadrants" (e.g. "AA.NW.SE").
That means each Zone has 4 Quadrants and 16 sub-Quadrants.
Totalling 756 square areas around the globe (squares within squares).
The sub-Quadrants vary from ~833 km. to ~1,107 km per side (833² = 693,889 km²) and (1107² = 1,225,449 km²).
Very small compared to the GLOBAL km² ... nevertheless, most of those "zones" (sub-Quadrants) are missing a tide gauge station or a weather station, or a seaport, so they were not included in the list of 133 in this post.