Download RodasRivera2014_PartII

Juan Luis Rodas Rivera
Technical Report
Check constraints are included for the following attributes:
•
The quadrat_size, eps, and time_units attributes, to only allow values greater than
zero.
•
The min_accuracy attribute, to only allow values between 1 and 16.
•
The min_pts attribute, to only allow values greater than one.
•
The time_unit attribute, to only allow intervals greater than one day.
•
The timeframe_from and updated attributes, to only allow values greater or equal
than January 1st, 2000.
•
The timeframe_to attribute, to only allow values greater than the timeframe_from
attribute.
•
6.1.8
The calculated attribute, to only allow either 0 or 1 (Boolean).
Table cluster
The table cluster stores the clusters found by the DBSCAN algorithm for each study
area. It has the structure shown on Table 8.
Table 8: Structure of table cluster
Attribute
Data type
Allow nulls
Description
id
serial
No
Unique identifier
study_area_id
integer
No
Identifier of the study area on which
the cluster was found
seq
integer
No
Sequential number of the time unit on
which the cluster was found
geom
geometry
(POLYGON,
No
Spatial extent of the cluster (area of
influence of the core points)
3857)
The id attribute is the primary key of the table and is auto-incremental.
The study_area_id attribute is a foreign key to the table study_area and is configured to
perform cascaded deletes.
The geom attribute is spatially indexed to improve query performance.
19