pt_spatiotemporal_statistics
pt_spatiotemporal_statistics( [tablename events] , [tablename reference geometry] , [ISO8601-duration] , [id name reference geometry] ) : TABLE( id , intervals , count )
Serving the analysis of the spatial and temporal distribution of an event type, this function calculates some basic statistics. More precise, it generates histogram intervals from the events' temporal bounding box and counts the containing events for each reference object, histogram-interval tuple. In some way you can imagine the functionality similar to a cross join between the reference geometry and the histogram intervals.
To use the function, you need one table with events, whose geometry is stored as Point with PostGIS's geometry type and temporal information as PostTIME, and another table, which is used as the reference geometry. To use the function, type in those tables' names with an temporal interval step size and the reference geometry's id-nam. The result will be a table, which contains the count of the events for each reference geometry and temporal interval step, respectively.
This examples are also shown in the readme.md, with the difference that here are the full results shown. We use data from nationalatlas.gov. The event dataset contains the establishment of airports within the USA and the static reference geometries are the U.S. states. After we have cast the temporal information into PostTIME, we can call the function:
SELECT * FROM pt_spatiotemporal_statistics('testdata_airports' , 'testdata_states' , 'P10Y', 'id' );
returns:
id | ptime | count
----+---------------------------------------------------------+-------
5 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 4
6 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 1
15 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 4
22 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 2
24 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 8
29 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 3
30 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 3
31 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 4
34 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 1
37 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 5
38 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 2
41 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 3
45 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 4
11 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 1
23 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 1
40 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 5
48 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 1
49 | CAL0011928-01-01T00:00:00.000Z/1938-01-01T00:00:00.000Z | 3
1 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7
2 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
3 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8
4 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11
5 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 4
6 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 40
7 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8
8 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
10 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 22
12 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8
13 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10
14 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
15 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6
17 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
18 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 29
20 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15
21 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15
22 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7
24 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 20
25 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
26 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7
28 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2
29 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
30 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11
31 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2
32 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 20
33 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15
34 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 1
36 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
37 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 12
38 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 3
39 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6
41 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 4
42 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 4
43 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7
44 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11
45 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2
47 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10
9 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
11 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6
16 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 1
23 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 1
27 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11
35 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10
40 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
48 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6
49 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
50 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
51 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5
52 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9
53 | CAL0011938-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 22
3 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
4 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
6 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
10 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 43
12 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
13 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
14 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
15 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 5
18 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
19 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
20 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
21 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
24 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
28 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
29 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
30 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
32 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
33 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
37 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
38 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
39 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 3
41 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
42 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
43 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
44 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
45 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
47 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 3
23 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
27 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
35 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 2
49 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
51 | CAL0011948-01-01T00:00:00.000Z/1958-01-01T00:00:00.000Z | 1
1 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
3 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
4 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
5 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
6 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5
7 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 4
10 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 39
17 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
18 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 4
24 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3
25 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
28 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
29 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
30 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2
37 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
38 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
41 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 4
43 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
47 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2
27 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
35 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
48 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
49 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
53 | CAL0011958-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1
3 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
5 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
6 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
7 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
10 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 31
12 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
15 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
18 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
24 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
25 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 2
28 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
29 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
30 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
31 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 2
34 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
37 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
41 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
47 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
9 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
11 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
35 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
48 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
49 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
52 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
53 | CAL0011968-01-01T00:00:00.000Z/1978-01-01T00:00:00.000Z | 1
1 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2
2 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
5 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
6 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
7 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
10 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 10
18 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
20 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
21 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
24 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2
25 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
39 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
47 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2
35 | CAL0011978-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1
10 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 15
24 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 1
36 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 1
44 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 1
47 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 2
11 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 2
35 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 1
49 | CAL0011988-01-01T00:00:00.000Z/1998-01-01T00:00:00.000Z | 1
10 | CAL0011998-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 10
47 | CAL0011998-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1
We can adjust the interval step size:
SELECT * FROM pt_spatiotemporal_statistics('testdata_airports' , 'testdata_states' , 'P1Y6M', 'id' );
please note that the result contains only id / ptime matches which have a count of at least 1:
id | ptime | count
----+---------------------------------------------------------+-------
6 | CAL0011928-04-01T00:00:00.000Z/1929-10-01T00:00:00.000Z | 1
41 | CAL0011929-10-01T00:00:00.000Z/1931-04-01T00:00:00.000Z | 1
41 | CAL0011931-04-01T00:00:00.000Z/1932-10-01T00:00:00.000Z | 1
5 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
12 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 1
15 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 5
22 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
24 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 9
26 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 1
29 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
30 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 9
31 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
34 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 1
37 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 7
38 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 3
39 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 2
41 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 2
42 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 2
45 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
11 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 1
23 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 1
40 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 5
48 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 2
49 | CAL0011937-04-01T00:00:00.000Z/1938-10-01T00:00:00.000Z | 4
7 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
12 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
15 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
22 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
24 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 3
26 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
30 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
32 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 5
37 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 6
38 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
42 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
45 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
11 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
23 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
40 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
48 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 2
52 | CAL0011938-10-01T00:00:00.000Z/1940-04-01T00:00:00.000Z | 1
1 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
2 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
3 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
4 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 7
6 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 22
7 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
13 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 6
14 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 2
17 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 8
18 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 19
20 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 12
21 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
24 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
25 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 3
29 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
30 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
32 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 6
33 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
36 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 6
41 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
43 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
44 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 3
47 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
9 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
11 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
27 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
35 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
49 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 3
50 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 5
51 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 1
52 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 4
53 | CAL0011940-04-01T00:00:00.000Z/1941-10-01T00:00:00.000Z | 17
1 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
2 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
3 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
4 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
5 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
6 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 8
7 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 5
10 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
12 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
13 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
17 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
18 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 4
20 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
21 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
22 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
24 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 3
25 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
26 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
30 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
31 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
32 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
33 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 5
34 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
37 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
39 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
44 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 3
47 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
9 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
11 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
40 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
48 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
49 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
50 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 1
51 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
52 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 2
53 | CAL0011941-10-01T00:00:00.000Z/1943-04-01T00:00:00.000Z | 3
2 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
4 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
5 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
6 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 6
8 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
12 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 4
13 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 3
14 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 3
15 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 3
18 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 6
20 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
21 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
24 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 10
26 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
29 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
30 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
32 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 4
33 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 5
37 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
41 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
43 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
44 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
47 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 3
16 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
27 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 5
35 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
40 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
48 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
49 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 4
50 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 2
51 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
52 | CAL0011943-04-01T00:00:00.000Z/1944-10-01T00:00:00.000Z | 1
2 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
3 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 2
4 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
6 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 2
8 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
21 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 3
22 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
24 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
26 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
29 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
36 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 2
37 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
44 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 2
27 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
40 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
48 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
51 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
52 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 1
53 | CAL0011944-10-01T00:00:00.000Z/1946-04-01T00:00:00.000Z | 2
3 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
6 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 2
8 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 3
10 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 21
15 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
21 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 3
24 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
26 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
28 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 2
29 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
30 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
32 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 3
36 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
39 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 3
42 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
44 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 2
47 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
11 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
27 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
35 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 3
50 | CAL0011946-04-01T00:00:00.000Z/1947-10-01T00:00:00.000Z | 1
3 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
4 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
6 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
10 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 7
12 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
13 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 2
15 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
18 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
19 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 2
28 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
29 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 2
30 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
32 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
37 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
41 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
47 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
35 | CAL0011947-10-01T00:00:00.000Z/1949-04-01T00:00:00.000Z | 1
6 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
10 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 20
12 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
14 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
15 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 2
21 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
32 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
33 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
37 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
38 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
39 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
45 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
23 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
35 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
49 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
51 | CAL0011949-04-01T00:00:00.000Z/1950-10-01T00:00:00.000Z | 1
10 | CAL0011950-10-01T00:00:00.000Z/1952-04-01T00:00:00.000Z | 7
20 | CAL0011950-10-01T00:00:00.000Z/1952-04-01T00:00:00.000Z | 1
21 | CAL0011950-10-01T00:00:00.000Z/1952-04-01T00:00:00.000Z | 1
39 | CAL0011950-10-01T00:00:00.000Z/1952-04-01T00:00:00.000Z | 1
4 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
10 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 5
15 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
28 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
39 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
42 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 2
44 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
27 | CAL0011952-04-01T00:00:00.000Z/1953-10-01T00:00:00.000Z | 1
10 | CAL0011953-10-01T00:00:00.000Z/1955-04-01T00:00:00.000Z | 4
15 | CAL0011953-10-01T00:00:00.000Z/1955-04-01T00:00:00.000Z | 1
24 | CAL0011953-10-01T00:00:00.000Z/1955-04-01T00:00:00.000Z | 1
43 | CAL0011955-04-01T00:00:00.000Z/1956-10-01T00:00:00.000Z | 1
47 | CAL0011955-04-01T00:00:00.000Z/1956-10-01T00:00:00.000Z | 1
24 | CAL0011956-10-01T00:00:00.000Z/1958-04-01T00:00:00.000Z | 1
47 | CAL0011956-10-01T00:00:00.000Z/1958-04-01T00:00:00.000Z | 1
6 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 1
7 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 1
10 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 10
30 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 1
41 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 1
47 | CAL0011958-04-01T00:00:00.000Z/1959-10-01T00:00:00.000Z | 1
6 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
7 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
10 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 5
24 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
30 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
27 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
35 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
49 | CAL0011959-10-01T00:00:00.000Z/1961-04-01T00:00:00.000Z | 1
3 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 1
4 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 1
6 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 1
10 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 3
18 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 2
47 | CAL0011961-04-01T00:00:00.000Z/1962-10-01T00:00:00.000Z | 1
5 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
6 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 2
10 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 10
24 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 2
25 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
28 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
37 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
38 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
41 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
48 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
53 | CAL0011962-10-01T00:00:00.000Z/1964-04-01T00:00:00.000Z | 1
1 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 1
10 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 5
18 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 1
29 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 1
41 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 2
43 | CAL0011964-04-01T00:00:00.000Z/1965-10-01T00:00:00.000Z | 1
7 | CAL0011965-10-01T00:00:00.000Z/1967-04-01T00:00:00.000Z | 1
10 | CAL0011965-10-01T00:00:00.000Z/1967-04-01T00:00:00.000Z | 6
17 | CAL0011965-10-01T00:00:00.000Z/1967-04-01T00:00:00.000Z | 1
7 | CAL0011967-04-01T00:00:00.000Z/1968-10-01T00:00:00.000Z | 1
10 | CAL0011967-04-01T00:00:00.000Z/1968-10-01T00:00:00.000Z | 1
18 | CAL0011967-04-01T00:00:00.000Z/1968-10-01T00:00:00.000Z | 1
28 | CAL0011967-04-01T00:00:00.000Z/1968-10-01T00:00:00.000Z | 1
35 | CAL0011967-04-01T00:00:00.000Z/1968-10-01T00:00:00.000Z | 1
10 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 2
18 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 1
29 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 1
31 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 1
9 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 1
53 | CAL0011968-10-01T00:00:00.000Z/1970-04-01T00:00:00.000Z | 1
3 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
10 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 6
15 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
25 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
34 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
37 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
11 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
49 | CAL0011970-04-01T00:00:00.000Z/1971-10-01T00:00:00.000Z | 1
6 | CAL0011971-10-01T00:00:00.000Z/1973-04-01T00:00:00.000Z | 1
12 | CAL0011971-10-01T00:00:00.000Z/1973-04-01T00:00:00.000Z | 1
47 | CAL0011971-10-01T00:00:00.000Z/1973-04-01T00:00:00.000Z | 1
48 | CAL0011971-10-01T00:00:00.000Z/1973-04-01T00:00:00.000Z | 1
5 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 1
10 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 11
24 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 1
25 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 1
41 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 1
52 | CAL0011973-04-01T00:00:00.000Z/1974-10-01T00:00:00.000Z | 1
7 | CAL0011974-10-01T00:00:00.000Z/1976-04-01T00:00:00.000Z | 1
10 | CAL0011974-10-01T00:00:00.000Z/1976-04-01T00:00:00.000Z | 3
31 | CAL0011974-10-01T00:00:00.000Z/1976-04-01T00:00:00.000Z | 1
10 | CAL0011976-04-01T00:00:00.000Z/1977-10-01T00:00:00.000Z | 8
1 | CAL0011977-10-01T00:00:00.000Z/1979-04-01T00:00:00.000Z | 1
10 | CAL0011977-10-01T00:00:00.000Z/1979-04-01T00:00:00.000Z | 1
30 | CAL0011977-10-01T00:00:00.000Z/1979-04-01T00:00:00.000Z | 1
7 | CAL0011979-04-01T00:00:00.000Z/1980-10-01T00:00:00.000Z | 1
10 | CAL0011979-04-01T00:00:00.000Z/1980-10-01T00:00:00.000Z | 3
20 | CAL0011979-04-01T00:00:00.000Z/1980-10-01T00:00:00.000Z | 1
24 | CAL0011979-04-01T00:00:00.000Z/1980-10-01T00:00:00.000Z | 1
2 | CAL0011980-10-01T00:00:00.000Z/1982-04-01T00:00:00.000Z | 1
10 | CAL0011980-10-01T00:00:00.000Z/1982-04-01T00:00:00.000Z | 1
24 | CAL0011980-10-01T00:00:00.000Z/1982-04-01T00:00:00.000Z | 1
25 | CAL0011980-10-01T00:00:00.000Z/1982-04-01T00:00:00.000Z | 1
10 | CAL0011982-04-01T00:00:00.000Z/1983-10-01T00:00:00.000Z | 1
18 | CAL0011982-04-01T00:00:00.000Z/1983-10-01T00:00:00.000Z | 1
10 | CAL0011983-10-01T00:00:00.000Z/1985-04-01T00:00:00.000Z | 1
5 | CAL0011985-04-01T00:00:00.000Z/1986-10-01T00:00:00.000Z | 1
10 | CAL0011985-04-01T00:00:00.000Z/1986-10-01T00:00:00.000Z | 1
21 | CAL0011985-04-01T00:00:00.000Z/1986-10-01T00:00:00.000Z | 1
47 | CAL0011985-04-01T00:00:00.000Z/1986-10-01T00:00:00.000Z | 1
35 | CAL0011985-04-01T00:00:00.000Z/1986-10-01T00:00:00.000Z | 1
1 | CAL0011986-10-01T00:00:00.000Z/1988-04-01T00:00:00.000Z | 1
6 | CAL0011986-10-01T00:00:00.000Z/1988-04-01T00:00:00.000Z | 1
10 | CAL0011986-10-01T00:00:00.000Z/1988-04-01T00:00:00.000Z | 5
39 | CAL0011986-10-01T00:00:00.000Z/1988-04-01T00:00:00.000Z | 1
47 | CAL0011986-10-01T00:00:00.000Z/1988-04-01T00:00:00.000Z | 1
10 | CAL0011988-04-01T00:00:00.000Z/1989-10-01T00:00:00.000Z | 3
47 | CAL0011988-04-01T00:00:00.000Z/1989-10-01T00:00:00.000Z | 1
10 | CAL0011989-10-01T00:00:00.000Z/1991-04-01T00:00:00.000Z | 1
24 | CAL0011989-10-01T00:00:00.000Z/1991-04-01T00:00:00.000Z | 1
11 | CAL0011989-10-01T00:00:00.000Z/1991-04-01T00:00:00.000Z | 1
10 | CAL0011991-04-01T00:00:00.000Z/1992-10-01T00:00:00.000Z | 1
11 | CAL0011991-04-01T00:00:00.000Z/1992-10-01T00:00:00.000Z | 1
10 | CAL0011992-10-01T00:00:00.000Z/1994-04-01T00:00:00.000Z | 1
44 | CAL0011992-10-01T00:00:00.000Z/1994-04-01T00:00:00.000Z | 1
47 | CAL0011992-10-01T00:00:00.000Z/1994-04-01T00:00:00.000Z | 1
35 | CAL0011992-10-01T00:00:00.000Z/1994-04-01T00:00:00.000Z | 1
49 | CAL0011992-10-01T00:00:00.000Z/1994-04-01T00:00:00.000Z | 1
10 | CAL0011994-04-01T00:00:00.000Z/1995-10-01T00:00:00.000Z | 4
10 | CAL0011997-04-01T00:00:00.000Z/1998-10-01T00:00:00.000Z | 2
36 | CAL0011997-04-01T00:00:00.000Z/1998-10-01T00:00:00.000Z | 1
10 | CAL0011998-10-01T00:00:00.000Z/2000-04-01T00:00:00.000Z | 4
47 | CAL0011998-10-01T00:00:00.000Z/2000-04-01T00:00:00.000Z | 1
10 | CAL0012000-04-01T00:00:00.000Z/2001-10-01T00:00:00.000Z | 1
10 | CAL0012001-10-01T00:00:00.000Z/2003-04-01T00:00:00.000Z | 3
10 | CAL0012003-04-01T00:00:00.000Z/2004-10-01T00:00:00.000Z | 2
The id can be used for a JOIN with the original reference geometry:
SELECT a.* , b.state
FROM pt_spatiotemporal_statistics('testdata_airports' , 'testdata_states' , 'P20Y', 'id' ) As a
JOIN testdata_states As b ON a.id = b.id;
id | ptime | count | state
----+---------------------------------------------------------+-------+---------------------
1 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | Alabama
2 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Indiana
3 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8 | Minnesota
4 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11 | Louisiana
5 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8 | South Carolina
6 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 41 | California
7 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8 | New Mexico
8 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | New Hampshire
10 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 22 | Alaska
12 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8 | Oklahoma
13 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10 | Idaho
14 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | Maryland
15 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10 | Ohio
17 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Maine
18 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 29 | Florida
20 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15 | Montana
21 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15 | Illinois
22 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Oregon
24 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 28 | Texas
25 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | Mississippi
26 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | New Jersey
28 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2 | Puerto Rico
29 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 8 | Wisconsin
30 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 14 | Pennsylvania
31 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6 | Tennessee
32 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 20 | New York
33 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 15 | Georgia
34 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2 | Vermont
36 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Arkansas
37 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 17 | Washington
38 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | North Dakota
39 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6 | Hawaii
41 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | Virginia
42 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 4 | West Virginia
43 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | Missouri
44 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11 | Iowa
45 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 6 | South Dakota
47 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10 | Arizona
9 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | Connecticut
11 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | Nevada
16 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 1 | Delaware
23 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 2 | Rhode Island
27 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 11 | Kansas
35 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10 | Colorado
40 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 10 | Wyoming
48 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 7 | Utah
49 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 12 | North Carolina
50 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Nebraska
51 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 5 | Kentucky
52 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 9 | Massachusetts
53 | CAL0011928-01-01T00:00:00.000Z/1948-01-01T00:00:00.000Z | 22 | Michigan
1 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Alabama
3 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Minnesota
4 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Louisiana
5 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | South Carolina
6 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 7 | California
7 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 4 | New Mexico
10 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 82 | Alaska
12 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Oklahoma
13 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Idaho
14 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Maryland
15 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5 | Ohio
17 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Maine
18 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5 | Florida
19 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | U.S. Virgin Islands
20 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Montana
21 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Illinois
24 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5 | Texas
25 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Mississippi
28 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Puerto Rico
29 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Wisconsin
30 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Pennsylvania
32 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | New York
33 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Georgia
37 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Washington
38 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | North Dakota
39 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Hawaii
41 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5 | Virginia
42 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | West Virginia
43 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Missouri
44 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Iowa
45 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | South Dakota
47 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 5 | Arizona
23 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Rhode Island
27 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | Kansas
35 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 3 | Colorado
48 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Utah
49 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 2 | North Carolina
51 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Kentucky
53 | CAL0011948-01-01T00:00:00.000Z/1968-01-01T00:00:00.000Z | 1 | Michigan
1 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | Alabama
2 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Indiana
3 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Minnesota
5 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | South Carolina
6 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | California
7 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | New Mexico
10 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 41 | Alaska
12 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Oklahoma
15 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Ohio
18 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | Florida
20 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Montana
21 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Illinois
24 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 3 | Texas
25 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 3 | Mississippi
28 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Puerto Rico
29 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Wisconsin
30 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Pennsylvania
31 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | Tennessee
34 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Vermont
37 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Washington
39 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Hawaii
41 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Virginia
47 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 3 | Arizona
9 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Connecticut
11 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Nevada
35 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 2 | Colorado
48 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Utah
49 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | North Carolina
52 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Massachusetts
53 | CAL0011968-01-01T00:00:00.000Z/1988-01-01T00:00:00.000Z | 1 | Michigan
10 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 25 | Alaska
24 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1 | Texas
36 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1 | Arkansas
44 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1 | Iowa
47 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 3 | Arizona
11 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 2 | Nevada
35 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1 | Colorado
49 | CAL0011988-01-01T00:00:00.000Z/2008-01-01T00:00:00.000Z | 1 | North Carolina
The table contains a lot of information, so it can be used as a basis for various analysis, e.g. let us extract only the maximum count:
SELECT a.* , b.state
FROM pt_spatiotemporal_statistics('testdata_airports' , 'testdata_states' , 'P5Y', 'id' ) As a
JOIN testdata_states As b ON a.id = b.id
ORDER BY count DESC LIMIT 1;
id | ptime | count | state
----+---------------------------------------------------------+-------+--------
10 | CAL0011948-01-01T00:00:00.000Z/1953-01-01T00:00:00.000Z | 37 | Alaska