[Epic] - Prepare exposure-lib for the 25.01 release

To prepare exposure-lib for the 25.01 release, the following issues need to be addressed:

• Create an empty branch v25.01.
• Create empty files abstract.py, spatialite.py and postgis.py to split the codes formerly in database.py (#169 (closed))
• Exposure-lib should raise an exception if a SpatiaLite database is used with version < 3.45 (#177 (closed))
• District assets and entity assets should reference the same asset table (#226 (closed))
• Resolve differences between PostGISExposure implementation and SpatiaLiteExposure (#194 (closed), #197 (closed), #203 (closed)).
• Prepare exposure-lib for entity-initializer:
  • Implement the handling of schema/table names for SpatiaLiteExposure and PostGISExposure (#169 (closed)).
  • Implement function get_reference_features_in_geometry() (#171 (closed), #183 (closed)).
    • Fix a variable name in issue #193 (closed) for where_statement
  • Implement function get_tiles_from_geometry() (#182 (closed)).
  • Function get_district_built_area (#184 (closed))
  • Implement function get_tile_entity_id() (#206 (closed)).
  • Implement function get_sum_built_area_in_geometry() (#207 (closed)).
  • Implement function insert_tile() (#186 (closed), #228 (closed), #237 (closed)).
  • Implement function get_country_boundary_geometry() (#189 (closed)) (already implemented; just copy)
  • Implement function get_source_id() (#190 (closed)).
  • Implement function get_tiles_in_boundary()(#213 (closed))
  • Implement function get_building_ids_in_boundary()(#216 (closed))
  • Implement functions get_tile_id_attributes() and update_tile_attributes() (#241 (closed))
  • Retire the whole spatialite triggers (#241 (closed))
• Prepare exposure-lib for exposure-initializer:
  • Implement the create_tables() function for SpatiaLiteExposure (#170 (closed)).
  • Implement the functions to insert assets (#175 (closed), #200 (closed)).
  • Implement function to insert district built area (!182 (merged))
  • Implement Metadata functions (#210 (closed))
  • Implement taxonomy category properties (#204 (closed))
  • Implement retrieval of all boundary IDs of a country / territory (#215 (closed))
  • Implement insertion of Taxonomy dictionary instead of taxonomy object (#218 (closed))
  • Implement insertion of Tabula taxonomy in the district assets (#219 (closed))
  • Introduce constant factor applied for GHSL built up area to determine the tile completeness (#239 (closed))
• Prepare exposure-lib for exposure-finalizer:
  • Change the remove_exposure() function to only remove assets and call it delete_assets() (#172 to be joined with #175 (closed)).
  • Implement function get_tiles_in_country() (#222 (closed))
  • Implement function get_buildings_in_tile() (#223 (closed))
  • Implement constants for floor area calculation (#227 (closed))
  • Implement function to get all boundaries in one tile (#225 (closed))
  • Implement function to get all district assets in one country (#224 (closed))
  • Implement function to get the baseline assets of a country (#234 (closed))
  • Implement function to get the sum of baseline exposure attributes of a country (#233 (closed))
  • Implement function to delete assets (#232 (closed))
  • Introduce constants for floor area of buildings (#227 (closed))
  • Implement function to get the sum of asset values per asset and/or entity ID (#235 (closed))
  • Implement function to update asset attributes (#236 (closed))
  • Change function get_buildings_in_tile() to select net floor area instead of floorsapce (#242 (closed))
• Implement unit and acceptance tests:
  • Create an empty PostGIS database using GitLab-CI (#168 (closed)).
  • Support testing for shared functionality in SpatiaLite and PostGIS database usage (#176 (closed), #185 (closed), #198 (closed)).
  • Support re-usage of tests in the other packages (eg. exposure-initializer) (#178 (closed)).
  • Fix issue related to fixtures for exposurelib_tests (#201 (closed))
  • Fix issue related to the removal of exposure (#246 (closed))
  • Optimize entity-asset check (#247 (closed))

To start creating the 25.01 model:

• Create beta version #243 (closed)
• Implement necessary functions for creating spatialite exports (ExposureShare)
  • Implement function copy_from_database() to copy data from the PostGIS database onto a Spatialite one (#240 (closed))
  • Fix bug in function copy_from_database() which caused errors in exporting from databases without TABULA (#253 (closed))

\rfc @all