| Name | threedi-schema JSON |
| Version |
0.300.9
JSON |
| download |
| home_page | None |
| Summary | The schema of 3Di schematization files |
| upload_time | 2025-02-18 18:58:34 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | >=3.9 |
| license | MIT |
| keywords |
|
| VCS |
 |
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
|
threedi-schema
==========================================
.. image:: https://img.shields.io/pypi/v/threedi-schema.svg
:target: https://pypi.org/project/threedi-schema/
.. image:: https://github.com/nens/threedi-schema/actions/workflows/test.yml/badge.svg
:alt: Github Actions status
:target: https://github.com/nens/threedi-schema/actions/workflows/test.yml
The schema of 3Di schematisation files.
This project exposes:
- A ``ThreediDatabase`` object to interact with schematisation files.
- A ``ModelSchema`` object (``ThreediDatabase().schema``) for adapting
schema versions (called "migration").
- The 3Di schema as SQLAlchemy models and python Enum classes.\*
\*This package exposes SQLAlchemy models of the
schematisation files directly. A minor release of this package may
change these models and will be backwards incompatible.
If the SQLAlchemy models are used, we strongly advise to fix the
minor version as follows: ``threedi-schema==0.214.*``. Otherwise, just
fixing the major version is sufficient.
Example
-------
The following code sample shows how you can upgrade a schematisation file::
from threedi_schema import ThreediDatabase
db = ThreediDatabase("<Path to your sqlite file>")
db.schema.upgrade()
The following code sample shows how you can list Channel objects::
from threedi_schema import models
# NB: Ensure that you pin the minor version of threedi-schema
# when using models (or constants).
channels = db.get_session().query(models.Channel).all()
Command-line interface
----------------------
Migrate to the latest schema version::
threedi_schema -s path/to/model.sqlite migrate
Ensure presence of spatial indexes::
threedi_schema -s path/to/model.sqlite index
Installation
------------
Install with::
$ pip install threedi-schema
Changelog of threedi-schema
===================================================
0.300.9 (2025-02-18)
--------------------
- Make schema.epsg_code work for all migration versions.
Raises threedi_schema.migrations.exceptions.InvalidSRIDException if the epsg_code is unusable or not set.
0.300.8 (2025-02-11)
--------------------
- Preserve ID column in non-geometry tables
0.300.7 (2025-02-11)
--------------------
- Add total discharge boundary types (TOTAL_DISCHARGE_2D, GROUNDWATER_TOTAL_DISCHARGE_2D)
0.300.6 (2025-01-31)
--------------------
- Add spatial_ref_sys view to geopackage so ST_Transform can be used
0.300.5 (2025-01-30)
--------------------
- Fix bug in upgrading logic that causes upgrading with gpkg to fail
0.300.4 (2025-01-30)
--------------------
- Fix migration starting from geopackage
- Set autoincrement for primary keys in models
0.300.3 (2025-01-28)
--------------------
- Fix setting surface_parameters_id
0.300.2 (2025-01-27)
--------------------
- Fix typo in warning handling on convert to geopackge
- Set default visualisation of connection_node to -1
- Fix geom for pump in migration 228
0.300.1 (2025-01-24)
--------------------
- Fix incorrect naming of table Tags as tag instead of tags in migration 223
0.300.0 (2025-01-24)
--------------------
- Convert spatialite to geopackage during upgrade
0.230.3 (2025-01-23)
--------------------
- Fix invalid setting of geometry types for lateral_2d and boundary_condition_2d
0.230.2 (2025-01-23)
--------------------
- Modify model names such that sqlite table names match to model names
0.230.1 (2025-01-21)
--------------------
- Fix invalid geometry types for measure_map, memory_control and table_control
0.230.0 (2025-01-16)
--------------------
- Reproject all geometries to the srid in model_settings.epsg_code
- Remove model_settings.epsg_code
0.229.2 (2025-01-16)
--------------------
- Rewrite geopackage conversion to use gdal.VectorTranslate instead of ogr2ogr
0.229.1 (2025-01-15)
--------------------
- Fix setting of geometry columns for revision 223 and 228
- Fix incorrect creation of geometry for dry weather flow and surface during migration
0.229.0 (2025-01-08)
--------------------
- Rename sqlite table "tags" to "tag"
- Remove indices referring to removed tables in previous migrations
- Make model_settings.use_2d_rain and model_settings.friction_averaging booleans
- Remove columns referencing v2 in geometry_column
- Ensure correct use_* values when matching tables have no data
- Use custom types for comma separated and table text fields to strip extra white space
- Correct direction of dwf and surface map
- Remove v2 related views from sqlite
0.228.4 (2025-01-10)
--------------------
- Fix incorrectly setting of geometry for pipe, weir and orifice in migration
- Fix issue where invalid geometries broke migration 228 for culverts
0.228.3 (2024-12-10)
--------------------
- Fix issue with incorrect types of migrated cross_section_width and height that broke the spatialite upgrade
0.228.2 (2024-12-04)
--------------------
- Significantly speed up migration to schema 228 for schematisations with many 1D components
- Remove support for python 3.8 and require python 3.9 as minimal version
- Add tags column to cross_section_location and windshielding_1d
0.228.1 (2024-11-26)
--------------------
- Add `progress_func` argument to schema.upgrade
0.228.0 (2024-11-25)
--------------------
- Implement changes for schema version 300 concerning 1D
- Remove v2 prefix from table names v2_channel, v2_windshielding, v2_cross_section_location, v2_pipe, v2_culvert` v2_orifice and v2_weir
- Move data from v2_cross_section_definition to linked tables (cross_section_location, pipe, culvert, orifice and weir)
- Move data from v2_manhole to connection_nodes and remove v2_manhole table
- Rename v2_pumpstation to pump and add table pump_map that maps the end nodes to pumps
- Remove tables v2_floodfill and v2_cross_section_definition
0.227.3 (2024-11-04)
--------------------
- Extend list of file paths that are replaced with the file name with the files in vegetation_drag_2d"
0.227.2 (2024-10-23)
--------------------
- Fix setting of model_settings.use_interception in migration to 0.222
0.227.1 (2024-10-21)
--------------------
- Propagate changes from 0.226.7
0.227.0 (2024-10-14)
--------------------
- Remove measure_variable column from tables memory_control and table_control
- Rename control_measure_map to measure_map and control_measure_location to measure_location
0.226.7 (2024-10-21)
--------------------
- Add several models that where missing in DECLARED_MODELS
0.226.6 (2024-10-03)
--------------------
- Copy id column when renaming tables.
0.226.5 (2024-09-30)
--------------------
- Prevent migrations 225 and 226 from failing when any of the new table names already exists
- Propagate changes from 0.225.6.
0.226.4 (2024-09-25)
--------------------
- Propagate fixes from 224.
0.226.3 (2024-09-24)
--------------------
- Propagate fixes from 224.5
0.226.2 (2024-09-23)
--------------------
- Release including fixes for 0.224.4 and 0.225.3
0.226.1 (2024-09-12)
--------------------
- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer (https://github.com/nens/threedi-schema/pull/90)
0.226.0 (2024-09-10)
--------------------
- Implement changes for schema version 300 concerning 2d and 1d2d
- Renamed v2_dem_average_area to dem_average_area, v2_exchange_line to echange_line,
v2_grid_refinement to grid_refinement_line, v2_grid_refinement_area to grid_refinement_area,
v2_obstacle to obstacle and v2_potential_breach to potential_breach
- Ensure that all these tables have a geom, code, display_name and tags column
- Ensure that all columns except for geom are nullable
- Rename refinement_level to grid_level in grid_refinement_line and grid_refinement_area
- Rename potential_breach.exchange_level to initial_exchange_level
- Remove potential_breach.maximum_breach_depth and set maximum_breach_depth.final_exchange_level to exchange_level - maximum_breach_depth
0.225.6 (2024-09-30)
--------------------
- Fix incorrect left join in migration 0.225.0
0.225.5 (2024-09-25)
--------------------
- Propagate fixes from 224.6
0.225.4 (2024-09-24)
--------------------
- Propagate fixes from 224.5
0.225.3 (2024-09-23)
--------------------
- Use unique name for temp tables in migrations
0.225.2 (2024-09-12)
--------------------
- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer (https://github.com/nens/threedi-schema/pull/90)
0.225.1 (2024-09-09)
--------------------
- Create enum for 1d_advection_type and use use that for PhysicalSettings.use_advection_1d
0.225.0 (2024-09-09)
--------------------
- Rename v2_1d_boundary_conditions and v2_2d_boundary_conditions to boundary_condition_1d and boundary_condition_2d.
- Rename v2_1d_laterals and v2_2d_laterals to lateral_1d and lateral_2d.
- Rename the_geom to geom in boundary_condition_2d and lateral_2d, and add geom columns to boundary_condition_1d and lateral_1d.
- Drop all constraints on boundary condition and lateral tables, except NOT NULL constrains on id and geom.
0.224.7 (2024-09-30)
--------------------
- Prevent migration 222 to 224 from failing when any of the new table names already exists
- Swap start and end of control_measure_map geometries
- Modify geometry of controls associated with pumpstation to the pumpstation start node
- Ensure control_measure_map.geom is a valid line
0.224.6 (2024-09-25)
--------------------
- Ensure dry_weather_flow_map.geom and surface_map.geom are valid lines
0.224.5 (2024-09-24)
--------------------
- Do not migrate controls that refer to non-existing nodes
0.224.4 (2024-09-23)
--------------------
- Use unique name for temp tables in migrations
0.224.3 (2024-09-12)
--------------------
- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer
0.224.2 (2024-09-05)
--------------------
- Change names of aggregation_settings.flow_variable to match threedigrid
- Make renaming raster paths more resilient
- Fix setting default values in dry_weather_flow and surface
- Actually set geom columns in dry_weather_flow_map and surface_map
0.224.1 (2024-09-02)
--------------------
- Fix creating control_measure_map.geom in 224 migration
- Handle created Null geometries when migrating surface / impervious_surface
- Revert removing on customized load_spatialite function
- Remove unused columns from several settings tables
- Rename groundwater.equilibrium_infiltration_rate_type to equilibrium_infiltration_rate_aggregation
- Rename control_measure_location.object_id to connection_node_id
- Replace paths to raster files with the file name
0.224.0 (2024-08-16)
--------------------
- Implement changes for schema version 300 concerning structure control.
- Simplify schema to four tables (`control_measure_location`, `control_measure_map`, `memory_control` and `table_control`) and removing tables `v2_control`, `v2_control_delta`, `v2_control_measure_group`, `v2_control_measure_map` and `v2_control_pid`.
- Removed time control and corresponding table (`v2_control_timed`).
- Add geometries to all four tables (with optional display name and tags).
- A full overview can be obtained from the migration code (`threedi_schema/migrations/versions/0224_db_upgrade_structure_control.py`)
0.223 (2024-08-01)
------------------
- Implement changes for schema version 300 concerning inflow
- Replace v2_surface and v2_impervious_surface (and maps) with surface and dry_weather_flow tables
- Redistribute data from v2_surface or v2_impervious_surface, depending on simulation_template_settings.use_0d_inflow, over suface and dry_weather_flow tables
- Populate surface_parameters and dry_weather_flow_distribution tables with default data
- A full overview can be obtained from the migration code (`threedi_schema/migrations/versions/0223_upgrade_db_inflow.py`)
0.222.2 (2024-06-13)
--------------------
- Skip testing convert to geopackage
0.222.1 (2024-06-13)
--------------------
- Disable `convert_to_geopackage` in `schema.upgrade` for schema version before 300
- Ensure `revision` format in `schema.upgrade` is correctly formatted
0.222.0 (2024-05-22)
--------------------
- Implement changes for schema version 300 concerning simulation settings
- Reduce all settings tables to a single row. Multiple settings per schematisation are no longer allowed.
- A full overview can most easily be obtained from the migration code (`threedi_schema/migrations/versions/0222_upgrade_db_settings.py`); to summarize:
- Rename settings tables from "v2_foo" to "foo"
- Rename several columns in settings tables
- Move settings to context specific tables instead of a single generic table
0.221 (2024-04-08)
------------------
- Remove column vegetation_drag_coeficients from v2_cross_section_location (sqlite only) that was added in migration 218
0.220 (2024-02-29)
------------------
- Add support for geopackage
- Remove `the_geom_linestring` from `v2_connection_nodes` because geopackage does not support multiple geometry objects in one table
0.219.3 (2024-04-16)
--------------------
- Fix not setting views when using upgrade with upgrade_spatialite_version=True on up to date spatialite
0.219.2 (2024-04-04)
--------------------
- Update v2_cross_section_location_view with vegetation columns
0.219.1 (2024-01-30)
--------------------
- Fix migration to nullable friction_value that resulted in string type for friction_value.
- Update action versions to use a new NodeJS.
- Make CrossSectionLocation.friction_value nullable
0.218.0 (2024-01-08)
--------------------
- Add parameters vegetation_stem_density, vegetation_stem_diameter, vegetation_height and vegetation_drag_coefficient to CrossSectionLocation
- Add parameters friction_values, vegetation_stem_densities, vegetation_stem_diameters, vegetation_heights and vegetation_drag_coefficients to CrossSectionDefinition
0.217.13 (2023-10-02)
---------------------
- Change set_gate_height to set_gate_level
0.217.12 (2023-10-02)
---------------------
- Add set_gate_height to control structure options.
- Set timed control column restrictions similar to table control.
0.217.11 (2023-09-19)
---------------------
- Fix conveyance values list.
0.217.10 (2023-09-19)
---------------------
- Unmark conveyance columns as beta.
- Move zest.releaser config to pyproject.toml.
0.217.9 (2023-08-16)
--------------------
- Fix incorrectly formatted beta_features.py.
0.217.8 (2023-08-15)
--------------------
- Mark friction types with conveyance as beta features.
0.217.7 (2023-07-28)
--------------------
- Don't set journal_mode to MEMORY since it causes the schema version
field to not be updated, making migrations crash.
0.217.6 (2023-07-13)
--------------------
- Extend FrictionType enum with Chézy friction with conveyance and
Manning friction with conveyance.
0.217.5 (2023-06-15)
--------------------
- Fixed set_views (spatialite metadata tables wwere not updated).
0.217.4 (2023-06-15)
--------------------
- Fix SQLAlchemy engine and connection usage.
- Do not pool connections (solving file permission denied issues on Windows).
0.217.3 (2023-06-12)
--------------------
- Added groundwater 1D2D columns to the views.
0.217.2 (2023-05-24)
--------------------
- Remove vegetation and groundwater settings from beta features, since they are going to be released.
0.217.1 (2023-05-17)
--------------------
- Rewrite release workflow to use a supported github action for github release.
- Build the threedi-schema release with the build package instead of setuptools.
0.217.0 (2023-05-08)
--------------------
- Rename vegetation columns to match raster options.
0.216.4 (2023-04-11)
--------------------
- Fixed libspatialite 4.3 incompatibility (introduced in 0.216.3).
0.216.3 (2023-04-04)
--------------------
- Fixed DROP TABLE in migration 214 (tables "v2_connected_pnt", "v2_calculation_point",
"v2_levee" remained present). The DROP TABLE is emitted again in migration 216.
0.216.2 (2023-03-24)
--------------------
- Remove groundwater columns from beta columns for 1d boundary conditions.
- Check on vegetation drag settings id in global settings instead of vegetation drag id for beta columns.
0.216.1 (2023-03-23)
--------------------
- Add beta_features.py to contain a list of spatialite columns and values for columns still in beta status.
0.216.0 (2023-03-15)
--------------------
- Add v2_vegation_drag table.
- Add 1D2D groundwater attributes to Pipes, Channels and Manholes
0.214.6 (2023-03-13)
--------------------
- Make timeseries non-nullable for BoundaryCondition1D and BoundaryConditions2D.
0.214.5 (2023-02-16)
--------------------
- Add SQLAlchemy 2.0 support and drop 1.3 support.
0.214.4 (2023-01-31)
--------------------
- Properly cleanup geo-tables in migration 214.
0.214.3 (2023-01-19)
--------------------
- Adapted versioning: prefix existing versions with 0.
- Fixed deprecation warnings of Geoalchemy2 0.13.0
0.214.2 (2023-01-17)
--------------------
- Fixed packaging (also include migrations).
0.214.1 (2023-01-17)
--------------------
- Fixed packaging.
0.214.0 (2023-01-17)
--------------------
- Initial project structure created with cookiecutter and
https://github.com/nens/cookiecutter-python-template
- Ported code from threedi-modelchecker, rearranged into
'domain', 'application', 'infrastructure', 'migrations'.
Raw data
{
"_id": null,
"home_page": null,
"name": "threedi-schema",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.9",
"maintainer_email": null,
"keywords": null,
"author": null,
"author_email": "Nelen & Schuurmans <info@nelen-schuurmans.nl>",
"download_url": "https://files.pythonhosted.org/packages/f8/41/95053ef55322c7ba8b6b35c22318becb2bf8af296ceed08b16dcf7f1aef4/threedi_schema-0.300.9.tar.gz",
"platform": null,
"description": "threedi-schema\n==========================================\n\n\n.. image:: https://img.shields.io/pypi/v/threedi-schema.svg\n :target: https://pypi.org/project/threedi-schema/\n\n.. image:: https://github.com/nens/threedi-schema/actions/workflows/test.yml/badge.svg\n\t:alt: Github Actions status\n\t:target: https://github.com/nens/threedi-schema/actions/workflows/test.yml\n\n\nThe schema of 3Di schematisation files.\n\nThis project exposes:\n\n- A ``ThreediDatabase`` object to interact with schematisation files.\n- A ``ModelSchema`` object (``ThreediDatabase().schema``) for adapting\n schema versions (called \"migration\").\n- The 3Di schema as SQLAlchemy models and python Enum classes.\\*\n\n\\*This package exposes SQLAlchemy models of the\nschematisation files directly. A minor release of this package may\nchange these models and will be backwards incompatible.\nIf the SQLAlchemy models are used, we strongly advise to fix the\nminor version as follows: ``threedi-schema==0.214.*``. Otherwise, just\nfixing the major version is sufficient.\n\nExample\n-------\n\nThe following code sample shows how you can upgrade a schematisation file::\n\n from threedi_schema import ThreediDatabase\n\n db = ThreediDatabase(\"<Path to your sqlite file>\")\n db.schema.upgrade()\n\n\nThe following code sample shows how you can list Channel objects::\n\n from threedi_schema import models\n # NB: Ensure that you pin the minor version of threedi-schema\n # when using models (or constants).\n\n channels = db.get_session().query(models.Channel).all()\n\n\nCommand-line interface\n----------------------\n\nMigrate to the latest schema version::\n\n threedi_schema -s path/to/model.sqlite migrate \n\n\nEnsure presence of spatial indexes::\n\n threedi_schema -s path/to/model.sqlite index \n\n\nInstallation\n------------\n\nInstall with::\n\n $ pip install threedi-schema\n\nChangelog of threedi-schema\n===================================================\n\n\n0.300.9 (2025-02-18)\n--------------------\n\n- Make schema.epsg_code work for all migration versions.\n Raises threedi_schema.migrations.exceptions.InvalidSRIDException if the epsg_code is unusable or not set.\n\n0.300.8 (2025-02-11)\n--------------------\n\n- Preserve ID column in non-geometry tables\n\n\n0.300.7 (2025-02-11)\n--------------------\n\n- Add total discharge boundary types (TOTAL_DISCHARGE_2D, GROUNDWATER_TOTAL_DISCHARGE_2D)\n\n\n0.300.6 (2025-01-31)\n--------------------\n\n- Add spatial_ref_sys view to geopackage so ST_Transform can be used\n\n\n0.300.5 (2025-01-30)\n--------------------\n\n- Fix bug in upgrading logic that causes upgrading with gpkg to fail\n\n\n0.300.4 (2025-01-30)\n--------------------\n\n- Fix migration starting from geopackage\n- Set autoincrement for primary keys in models\n\n\n0.300.3 (2025-01-28)\n--------------------\n\n- Fix setting surface_parameters_id\n\n\n0.300.2 (2025-01-27)\n--------------------\n\n- Fix typo in warning handling on convert to geopackge\n- Set default visualisation of connection_node to -1\n- Fix geom for pump in migration 228\n\n\n0.300.1 (2025-01-24)\n--------------------\n\n- Fix incorrect naming of table Tags as tag instead of tags in migration 223\n\n\n0.300.0 (2025-01-24)\n--------------------\n\n- Convert spatialite to geopackage during upgrade\n\n\n0.230.3 (2025-01-23)\n--------------------\n\n- Fix invalid setting of geometry types for lateral_2d and boundary_condition_2d\n\n\n0.230.2 (2025-01-23)\n--------------------\n\n- Modify model names such that sqlite table names match to model names\n\n\n0.230.1 (2025-01-21)\n--------------------\n\n- Fix invalid geometry types for measure_map, memory_control and table_control\n\n\n0.230.0 (2025-01-16)\n--------------------\n\n- Reproject all geometries to the srid in model_settings.epsg_code\n- Remove model_settings.epsg_code\n\n\n0.229.2 (2025-01-16)\n--------------------\n\n- Rewrite geopackage conversion to use gdal.VectorTranslate instead of ogr2ogr\n\n\n0.229.1 (2025-01-15)\n--------------------\n\n- Fix setting of geometry columns for revision 223 and 228\n- Fix incorrect creation of geometry for dry weather flow and surface during migration\n\n\n0.229.0 (2025-01-08)\n--------------------\n\n- Rename sqlite table \"tags\" to \"tag\"\n- Remove indices referring to removed tables in previous migrations\n- Make model_settings.use_2d_rain and model_settings.friction_averaging booleans\n- Remove columns referencing v2 in geometry_column\n- Ensure correct use_* values when matching tables have no data\n- Use custom types for comma separated and table text fields to strip extra white space\n- Correct direction of dwf and surface map\n- Remove v2 related views from sqlite\n\n\n0.228.4 (2025-01-10)\n--------------------\n\n- Fix incorrectly setting of geometry for pipe, weir and orifice in migration\n- Fix issue where invalid geometries broke migration 228 for culverts\n\n\n0.228.3 (2024-12-10)\n--------------------\n\n- Fix issue with incorrect types of migrated cross_section_width and height that broke the spatialite upgrade\n\n\n0.228.2 (2024-12-04)\n--------------------\n\n- Significantly speed up migration to schema 228 for schematisations with many 1D components\n- Remove support for python 3.8 and require python 3.9 as minimal version\n- Add tags column to cross_section_location and windshielding_1d\n\n\n0.228.1 (2024-11-26)\n--------------------\n\n- Add `progress_func` argument to schema.upgrade\n\n\n0.228.0 (2024-11-25)\n--------------------\n\n- Implement changes for schema version 300 concerning 1D\n- Remove v2 prefix from table names v2_channel, v2_windshielding, v2_cross_section_location, v2_pipe, v2_culvert` v2_orifice and v2_weir\n- Move data from v2_cross_section_definition to linked tables (cross_section_location, pipe, culvert, orifice and weir)\n- Move data from v2_manhole to connection_nodes and remove v2_manhole table\n- Rename v2_pumpstation to pump and add table pump_map that maps the end nodes to pumps\n- Remove tables v2_floodfill and v2_cross_section_definition\n\n\n0.227.3 (2024-11-04)\n--------------------\n\n- Extend list of file paths that are replaced with the file name with the files in vegetation_drag_2d\"\n\n\n0.227.2 (2024-10-23)\n--------------------\n\n- Fix setting of model_settings.use_interception in migration to 0.222\n\n\n0.227.1 (2024-10-21)\n--------------------\n\n- Propagate changes from 0.226.7\n\n\n0.227.0 (2024-10-14)\n--------------------\n\n- Remove measure_variable column from tables memory_control and table_control\n- Rename control_measure_map to measure_map and control_measure_location to measure_location\n\n\n0.226.7 (2024-10-21)\n--------------------\n\n- Add several models that where missing in DECLARED_MODELS\n\n\n0.226.6 (2024-10-03)\n--------------------\n\n- Copy id column when renaming tables.\n\n\n0.226.5 (2024-09-30)\n--------------------\n\n- Prevent migrations 225 and 226 from failing when any of the new table names already exists\n- Propagate changes from 0.225.6.\n\n\n0.226.4 (2024-09-25)\n--------------------\n\n- Propagate fixes from 224.\n\n\n0.226.3 (2024-09-24)\n--------------------\n\n- Propagate fixes from 224.5\n\n\n0.226.2 (2024-09-23)\n--------------------\n\n- Release including fixes for 0.224.4 and 0.225.3\n\n\n0.226.1 (2024-09-12)\n--------------------\n\n- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer (https://github.com/nens/threedi-schema/pull/90)\n\n\n0.226.0 (2024-09-10)\n--------------------\n\n- Implement changes for schema version 300 concerning 2d and 1d2d\n- Renamed v2_dem_average_area to dem_average_area, v2_exchange_line to echange_line,\n v2_grid_refinement to grid_refinement_line, v2_grid_refinement_area to grid_refinement_area,\n v2_obstacle to obstacle and v2_potential_breach to potential_breach\n- Ensure that all these tables have a geom, code, display_name and tags column\n- Ensure that all columns except for geom are nullable\n- Rename refinement_level to grid_level in grid_refinement_line and grid_refinement_area\n- Rename potential_breach.exchange_level to initial_exchange_level\n- Remove potential_breach.maximum_breach_depth and set maximum_breach_depth.final_exchange_level to exchange_level - maximum_breach_depth\n\n\n0.225.6 (2024-09-30)\n--------------------\n\n- Fix incorrect left join in migration 0.225.0\n\n\n0.225.5 (2024-09-25)\n--------------------\n\n- Propagate fixes from 224.6\n\n\n0.225.4 (2024-09-24)\n--------------------\n\n- Propagate fixes from 224.5\n\n\n0.225.3 (2024-09-23)\n--------------------\n\n- Use unique name for temp tables in migrations\n\n\n0.225.2 (2024-09-12)\n--------------------\n\n- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer (https://github.com/nens/threedi-schema/pull/90)\n\n\n0.225.1 (2024-09-09)\n--------------------\n\n- Create enum for 1d_advection_type and use use that for PhysicalSettings.use_advection_1d\n\n\n0.225.0 (2024-09-09)\n--------------------\n\n- Rename v2_1d_boundary_conditions and v2_2d_boundary_conditions to boundary_condition_1d and boundary_condition_2d.\n\n- Rename v2_1d_laterals and v2_2d_laterals to lateral_1d and lateral_2d.\n\n- Rename the_geom to geom in boundary_condition_2d and lateral_2d, and add geom columns to boundary_condition_1d and lateral_1d.\n\n- Drop all constraints on boundary condition and lateral tables, except NOT NULL constrains on id and geom.\n\n\n0.224.7 (2024-09-30)\n--------------------\n\n- Prevent migration 222 to 224 from failing when any of the new table names already exists\n- Swap start and end of control_measure_map geometries\n- Modify geometry of controls associated with pumpstation to the pumpstation start node\n- Ensure control_measure_map.geom is a valid line\n\n\n0.224.6 (2024-09-25)\n--------------------\n\n- Ensure dry_weather_flow_map.geom and surface_map.geom are valid lines\n\n\n0.224.5 (2024-09-24)\n--------------------\n\n- Do not migrate controls that refer to non-existing nodes\n\n\n0.224.4 (2024-09-23)\n--------------------\n\n- Use unique name for temp tables in migrations\n\n\n0.224.3 (2024-09-12)\n--------------------\n\n- Set type of dry_weather_flow.dry_weather_flow_distribution_id to integer\n\n\n0.224.2 (2024-09-05)\n--------------------\n\n- Change names of aggregation_settings.flow_variable to match threedigrid\n- Make renaming raster paths more resilient\n- Fix setting default values in dry_weather_flow and surface\n- Actually set geom columns in dry_weather_flow_map and surface_map\n\n\n0.224.1 (2024-09-02)\n--------------------\n\n- Fix creating control_measure_map.geom in 224 migration\n- Handle created Null geometries when migrating surface / impervious_surface\n- Revert removing on customized load_spatialite function\n- Remove unused columns from several settings tables\n- Rename groundwater.equilibrium_infiltration_rate_type to equilibrium_infiltration_rate_aggregation\n- Rename control_measure_location.object_id to connection_node_id\n- Replace paths to raster files with the file name\n\n\n0.224.0 (2024-08-16)\n--------------------\n\n- Implement changes for schema version 300 concerning structure control.\n- Simplify schema to four tables (`control_measure_location`, `control_measure_map`, `memory_control` and `table_control`) and removing tables `v2_control`, `v2_control_delta`, `v2_control_measure_group`, `v2_control_measure_map` and `v2_control_pid`.\n- Removed time control and corresponding table (`v2_control_timed`).\n- Add geometries to all four tables (with optional display name and tags).\n- A full overview can be obtained from the migration code (`threedi_schema/migrations/versions/0224_db_upgrade_structure_control.py`)\n\n\n0.223 (2024-08-01)\n------------------\n\n- Implement changes for schema version 300 concerning inflow\n- Replace v2_surface and v2_impervious_surface (and maps) with surface and dry_weather_flow tables\n- Redistribute data from v2_surface or v2_impervious_surface, depending on simulation_template_settings.use_0d_inflow, over suface and dry_weather_flow tables\n- Populate surface_parameters and dry_weather_flow_distribution tables with default data\n- A full overview can be obtained from the migration code (`threedi_schema/migrations/versions/0223_upgrade_db_inflow.py`)\n\n\n0.222.2 (2024-06-13)\n--------------------\n\n- Skip testing convert to geopackage\n\n\n0.222.1 (2024-06-13)\n--------------------\n\n- Disable `convert_to_geopackage` in `schema.upgrade` for schema version before 300\n- Ensure `revision` format in `schema.upgrade` is correctly formatted\n\n\n0.222.0 (2024-05-22)\n--------------------\n\n- Implement changes for schema version 300 concerning simulation settings\n- Reduce all settings tables to a single row. Multiple settings per schematisation are no longer allowed.\n- A full overview can most easily be obtained from the migration code (`threedi_schema/migrations/versions/0222_upgrade_db_settings.py`); to summarize:\n - Rename settings tables from \"v2_foo\" to \"foo\"\n - Rename several columns in settings tables\n - Move settings to context specific tables instead of a single generic table\n\n\n0.221 (2024-04-08)\n------------------\n\n- Remove column vegetation_drag_coeficients from v2_cross_section_location (sqlite only) that was added in migration 218\n\n0.220 (2024-02-29)\n------------------\n\n- Add support for geopackage\n- Remove `the_geom_linestring` from `v2_connection_nodes` because geopackage does not support multiple geometry objects in one table\n\n\n0.219.3 (2024-04-16)\n--------------------\n\n- Fix not setting views when using upgrade with upgrade_spatialite_version=True on up to date spatialite\n\n\n0.219.2 (2024-04-04)\n--------------------\n\n- Update v2_cross_section_location_view with vegetation columns\n\n\n0.219.1 (2024-01-30)\n--------------------\n\n- Fix migration to nullable friction_value that resulted in string type for friction_value.\n- Update action versions to use a new NodeJS.\n- Make CrossSectionLocation.friction_value nullable\n\n0.218.0 (2024-01-08)\n--------------------\n\n- Add parameters vegetation_stem_density, vegetation_stem_diameter, vegetation_height and vegetation_drag_coefficient to CrossSectionLocation\n- Add parameters friction_values, vegetation_stem_densities, vegetation_stem_diameters, vegetation_heights and vegetation_drag_coefficients to CrossSectionDefinition\n\n\n0.217.13 (2023-10-02)\n---------------------\n\n- Change set_gate_height to set_gate_level\n\n\n0.217.12 (2023-10-02)\n---------------------\n\n- Add set_gate_height to control structure options.\n\n- Set timed control column restrictions similar to table control.\n\n\n0.217.11 (2023-09-19)\n---------------------\n\n- Fix conveyance values list.\n\n\n0.217.10 (2023-09-19)\n---------------------\n\n- Unmark conveyance columns as beta.\n- Move zest.releaser config to pyproject.toml.\n\n\n0.217.9 (2023-08-16)\n--------------------\n\n- Fix incorrectly formatted beta_features.py.\n\n\n0.217.8 (2023-08-15)\n--------------------\n\n- Mark friction types with conveyance as beta features.\n\n\n0.217.7 (2023-07-28)\n--------------------\n\n- Don't set journal_mode to MEMORY since it causes the schema version\n field to not be updated, making migrations crash.\n\n\n0.217.6 (2023-07-13)\n--------------------\n\n- Extend FrictionType enum with Ch\u00e9zy friction with conveyance and\n Manning friction with conveyance.\n\n\n0.217.5 (2023-06-15)\n--------------------\n\n- Fixed set_views (spatialite metadata tables wwere not updated).\n\n\n0.217.4 (2023-06-15)\n--------------------\n\n- Fix SQLAlchemy engine and connection usage.\n\n- Do not pool connections (solving file permission denied issues on Windows).\n\n\n0.217.3 (2023-06-12)\n--------------------\n\n- Added groundwater 1D2D columns to the views.\n\n\n0.217.2 (2023-05-24)\n--------------------\n\n- Remove vegetation and groundwater settings from beta features, since they are going to be released.\n\n\n0.217.1 (2023-05-17)\n--------------------\n\n- Rewrite release workflow to use a supported github action for github release.\n- Build the threedi-schema release with the build package instead of setuptools.\n\n\n0.217.0 (2023-05-08)\n--------------------\n\n- Rename vegetation columns to match raster options.\n\n\n0.216.4 (2023-04-11)\n--------------------\n\n- Fixed libspatialite 4.3 incompatibility (introduced in 0.216.3).\n\n\n0.216.3 (2023-04-04)\n--------------------\n\n- Fixed DROP TABLE in migration 214 (tables \"v2_connected_pnt\", \"v2_calculation_point\",\n \"v2_levee\" remained present). The DROP TABLE is emitted again in migration 216.\n\n\n0.216.2 (2023-03-24)\n--------------------\n\n- Remove groundwater columns from beta columns for 1d boundary conditions.\n- Check on vegetation drag settings id in global settings instead of vegetation drag id for beta columns.\n\n\n0.216.1 (2023-03-23)\n--------------------\n\n- Add beta_features.py to contain a list of spatialite columns and values for columns still in beta status.\n\n\n0.216.0 (2023-03-15)\n--------------------\n\n- Add v2_vegation_drag table.\n- Add 1D2D groundwater attributes to Pipes, Channels and Manholes\n\n\n0.214.6 (2023-03-13)\n--------------------\n\n- Make timeseries non-nullable for BoundaryCondition1D and BoundaryConditions2D.\n\n\n0.214.5 (2023-02-16)\n--------------------\n\n- Add SQLAlchemy 2.0 support and drop 1.3 support.\n\n\n0.214.4 (2023-01-31)\n--------------------\n\n- Properly cleanup geo-tables in migration 214.\n\n\n0.214.3 (2023-01-19)\n--------------------\n\n- Adapted versioning: prefix existing versions with 0.\n\n- Fixed deprecation warnings of Geoalchemy2 0.13.0\n\n\n0.214.2 (2023-01-17)\n--------------------\n\n- Fixed packaging (also include migrations).\n\n\n0.214.1 (2023-01-17)\n--------------------\n\n- Fixed packaging.\n\n\n0.214.0 (2023-01-17)\n--------------------\n\n- Initial project structure created with cookiecutter and\n https://github.com/nens/cookiecutter-python-template\n\n- Ported code from threedi-modelchecker, rearranged into\n 'domain', 'application', 'infrastructure', 'migrations'.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "The schema of 3Di schematization files",
"version": "0.300.9",
"project_urls": {
"Repository": "https://github.com/nens/threedi-schema"
},
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "44a05ffed058b7d5bda806cb90f5bc75a051c6e1da7df146fddde9ed9199ef95",
"md5": "67b763df3247ad6b6a2dbdacc17071ab",
"sha256": "5a9d6044c8753f2ec33b37dc1cb750be919cffa9f51e9ec22d459fb8076311d8"
},
"downloads": -1,
"filename": "threedi_schema-0.300.9-py3-none-any.whl",
"has_sig": false,
"md5_digest": "67b763df3247ad6b6a2dbdacc17071ab",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.9",
"size": 101596,
"upload_time": "2025-02-18T18:58:32",
"upload_time_iso_8601": "2025-02-18T18:58:32.089805Z",
"url": "https://files.pythonhosted.org/packages/44/a0/5ffed058b7d5bda806cb90f5bc75a051c6e1da7df146fddde9ed9199ef95/threedi_schema-0.300.9-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "f84195053ef55322c7ba8b6b35c22318becb2bf8af296ceed08b16dcf7f1aef4",
"md5": "7dd2c16670da66ff51930281a41525f7",
"sha256": "9e1cf67a302f1e5ce77d95bbda1f926c822f9d0e3bcce14af99a8bb2f19ee411"
},
"downloads": -1,
"filename": "threedi_schema-0.300.9.tar.gz",
"has_sig": false,
"md5_digest": "7dd2c16670da66ff51930281a41525f7",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.9",
"size": 74748,
"upload_time": "2025-02-18T18:58:34",
"upload_time_iso_8601": "2025-02-18T18:58:34.944929Z",
"url": "https://files.pythonhosted.org/packages/f8/41/95053ef55322c7ba8b6b35c22318becb2bf8af296ceed08b16dcf7f1aef4/threedi_schema-0.300.9.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-02-18 18:58:34",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "nens",
"github_project": "threedi-schema",
"travis_ci": false,
"coveralls": true,
"github_actions": true,
"requirements": [],
"lcname": "threedi-schema"
}
