All notable changes for the LINZ LDS BDE schema are documented in this file.
- Release for Ubuntu Focal
- Force pushing changes to origin remote
- Support for Ubuntu 20.04/LTS and Python3
- Quality improvements
- Minor schema changes
- Extended masking of title memorials
- Update of LDS Full Landonline Data Dictionary 2.6
- Use proper FK in crs_ttl_inst_protect query
- check crs_ttl_inst_protect table when launching FBDE maintenance
- Have changes in
crs_ttl_inst_protect
trigger FBDE maintenance (#244)
- Update schema documentation (#229)
- Foreign key use in encumbrancee name filtering (#240)
- Encoded dependency on linz-bde-schema-1.11+
- LOL-3.22b: add support for filtering encumbrancee name
- Do not hide errors from tableversion/dbpatch loaders (#209)
- Do not require
pg_config
from schema loader (#216) - Only ALTER table on upgrade if really needed (#218)
- Avoid TRUNCATE on empty tables (#206)
- Catch even more WACA adjustments (#174)
- Restore serial sequence ownership on upgrade (#196)
- Catch more WACA adjustments (#174)
- Schema loader does NOT load bde-uploader schema anymore (#192)
- Serial field sequences now owned by their respective columns
- Lost tables and permissions now recovered upon schema loading (#190)
- Switch --readonly to schema loader (#187)
- linz-lds-bde-schema-publish script (#176)
- Build support for python3 (#181)
- Survey Observation layer should not contain negative distances or bearings (#170)
- Reduce list of tables affecting simplified parcel layers (#165)
- Use a DO block to bless functions, avoiding empty-lines in psql output
- Deprecate
LDS_GetLandDistict
in favour ofLDS_GetLandDistrict
(#157)
- Use NOTICE for progress report, rather than INFO (#144)
- Do not mass-drop functions during upgades (#138)
- Standard output support for schema loader (#139)
- Allow forcing simplified layers population (#154)
- Presence of lines in the cadastral adjustment polygon layer (#146)
- Support for legal description in SRS typed title records (#150)
- Change
tmp_titles
table to usedesc
field instead ofchar_value
frombde
.crs_sys_code
. Affects alllds.title*
tables. (#125)
- Create no revision when versioning empty tables (#117)
- Use full table path for table used in
tmp_title_parcel_associations
table population (#129)
- New --revision switch to schema loader, to enable versioning (#109)
- Stop changing
search_path
in the session loading enabler scripts (#95) - Make schema loader less noisy
- Make schema loader use a single transaction
- Fix support for extension-less
table_version
usage (#102)
- Table comments (#57)
- Stop producing simplified electoral layers, dropping dependency on territorial admin boundary data (#4)
- Add
ttl_inst_cmplte
table inbde_ext
schema (#74) - Have loader install
unaccent
extension in public schema (#79)
- Remove pre-allocated titles from full Landonline title table (#15)
- New
linz-lds-bde-schema-load
script for easier install/upgrade
- Review immutable/stable/volatile flag on all defined functions
- Embed revision info in all functions
- Allow using more functions without
bde
insearch_path
- Create survey tables and columns for pending parcels release
- Ensure LDS BDE indexes are created in an idempotent way
- Fixed issue with old table differencing code
- Initial release of LDS BDE schema (now separated from
linz_bde_uploader
project)