Views for vulnerabilities are required to provide the data abckend for vulnerabilities APIs.
vf_table, ff_table and dtl_table. These are the two leading tables. Each row represents a "vulnerability function" (vf_table) or a "fragility function" (ff_table) or a "damage to loos function" (dt_table).
Countires
Each element must be filtered by bbox according to the _countryiso field. Thus a relation to the geoms from the det_geonode_dev,explorationtool_administrativedivision table is required. Probably we should define a geom field for each element, keeping into account that each element can be related to multiple countries (see vf_table.id = 4 in the sample dataset).
Views for vulnerabilities are required to provide the data abckend for vulnerabilities APIs.
vf_table, ff_table and dtl_table. These are the two leading tables. Each row represents a "vulnerability function" (vf_table) or a "fragility function" (ff_table) or a "damage to loos function" (dt_table).
ER schema for vulnerabilities
Countires Each element must be filtered by bbox according to the _countryiso field. Thus a relation to the geoms from the det_geonode_dev,explorationtool_administrativedivision table is required. Probably we should define a geom field for each element, keeping into account that each element can be related to multiple countries (see vf_table.id = 4 in the sample dataset).
depends on #92