geoalchemy2

What's Changed

• CI: Fix triggers after default branch was renamed main by @adrien-berchet in #593
• Accept leading '+' in WKT coords and fix Comparator >> docstring by @adrien-berchet in #594
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #595
• CI: Fix Too many connections errors in MySQL and MariaDB by @adrien-berchet in #597
• Fix: Ensure _GISType.column_expression is compatible with TypeDecorator by @adrien-berchet in #598
• Release: 0.19.0 by @adrien-berchet in #599

Full Changelog: 0.18.4...0.19.0

What's Changed

• Fix: fix shapely import by @pjonsson in #588
• Fix: fix setuptools deprecation warning by @pjonsson in #589
• CI: Make Coveralls optional since the service is down at the moment by @adrien-berchet in #590
• CI: try the official Coveralls action by @pjonsson in #592
• Release: 0.18.4 by @adrien-berchet in #591

Full Changelog: 0.18.3...0.18.4

What's Changed

• Fix: Fix Shapely import by @adrien-berchet in #584
• Release: 0.18.3 by @adrien-berchet in #587

Full Changelog: 0.18.2...0.18.3

What's Changed

• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #575
• Build: Upgrade packaging and formatting tools by @adrien-berchet in #576
• Build(deps): Bump actions/setup-python from 5 to 6 by @dependabot[bot] in #577
• Build(deps): Bump actions/checkout from 4 to 6 by @dependabot[bot] in #578
• Chore: Add more type hints in from_shape module by @adrien-berchet in #580
• Build: Fix package discovery by @adrien-berchet in #581
• Release: 0.18.2 by @adrien-berchet in #582

Full Changelog: 0.18.1...0.18.2

What's Changed

• Fix (mysql): Fix failing test for MySQL dialect by @google-labs-jules[bot] in #567
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #570
• Fix: Allow scientific notation within WKT string by @autermann in #573
• Release: 0.18.1 by @adrien-berchet in #574

New Contributors

• @google-labs-jules[bot] made their first contribution in #567
• @autermann made their first contribution in #573

Full Changelog: 0.18.0...0.18.1

What's Changed

• Build: Deprecate Py<3.10 by @adrien-berchet in #538
• Feat: Add more return types for spatial functions and update some typehints by @adrien-berchet in #540
• Compile literal binds by @adrien-berchet in #543
• Feat: Improve Geometry initializer to make the dimension optional by @adrien-berchet in #544
• Chore (mariadb): Stop converting WKB to WKT by @adrien-berchet in #545
• Docs: Update doc to run the tests inside docker containers by @adrien-berchet in #546
• Test: Add benchmark tests by @adrien-berchet in #547
• Test: Add more benchmarks by @adrien-berchet in #553
• Chore: Create FUNDING.yml by @adrien-berchet in #554
• Test: Improve readbility of benchmark results by @adrien-berchet in #556
• Perf: Define slots in element classes to reduce memory usage of elements by @adrien-berchet in #555
• Feat: Handle computed columns by @adrien-berchet in #557
• Fix: Remove warning message from MySQL/MariaDB reflection by @adrien-berchet in #560
• Chore: Move reflection type registering by @adrien-berchet in #561
• Docs: correct doc strings by @pjonsson in #562
• Feat: Add support of spatial indexes for Raster type for PostgreSQL by @adrien-berchet in #564
• Release: 0.18.0 by @adrien-berchet in #565

New Contributors

• @pjonsson made their first contribution in #562

Full Changelog: 0.17.1...0.18.0

What's Changed

• Chore: Fix stubs for TableRowElement by @adrien-berchet in #534
• Fix: Pass through keyword args for create_geospatial_table(). Fixes: #532 by @jurgispods in #533
• Release: 0.17.1 by @adrien-berchet in #535

New Contributors

• @jurgispods made their first contribution in #533

Full Changelog: 0.17.0...0.17.1

What's Changed

• CI: Fix Pypy job by @adrien-berchet in #528
• Perf: Enable cache, fix value casting for MySQL and MariaDB and add plugin for Engine creation by @adrien-berchet @calebj in #529
• Release/0.17.0 by @adrien-berchet in #531

Full Changelog: 0.16.0...0.17.0

What's Changed

• Improve MariaDB support by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/524
• Add option to ensure all dialects are properly tested in CI by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/526
• Test: Add test in test_functional.py for custom Geometry that uses WKT elements by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/525
• Release: 0.16.0 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/527

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.15.2...0.16.0

What's Changed

• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci in https://github.com/geoalchemy/geoalchemy2/pull/514
• Fix: Can handle negative coordinates with Spatialite by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/517
• Release: 0.15.2 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/518

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.15.1...0.15.2

What's Changed

• Test: Dispose of the connection pools of the test engines by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/511
• Fix: Default SRID is bypassed when using floating point coordinates. by @aballet in https://github.com/geoalchemy/geoalchemy2/pull/509
• Release: 0.15.1 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/512

New Contributors

• @aballet made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/509

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.15.0...0.15.1

What's Changed

• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci in https://github.com/geoalchemy/geoalchemy2/pull/503
• Specific process for geometries with Z or M coordinate with SpatiaLite dialect by @sdp5 in https://github.com/geoalchemy/geoalchemy2/pull/506
• Chore: Fix type hints on stubs by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/504
• Release: 0.15.0 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/507

New Contributors

• @pre-commit-ci made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/503
• @sdp5 made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/506

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.7...0.15.0

What's Changed

• Docs: Add Zenodo badge on the main page by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/498
• CI: Fix Py312 job in tox by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/501
• Allow geometry_type to be None at the type level to match documentation by @logankaser in https://github.com/geoalchemy/geoalchemy2/pull/500
• Release: 0.14.7 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/502

New Contributors

• @logankaser made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/500

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.6...0.14.7

What's Changed

• Fix: Fix specific compilation rules for MariaDB by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/495
• Release: 0.14.6 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/496

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.5...0.14.6

What's Changed

• CI: Setup pre-commit.ci by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/492
• Feat: Add experimental support for MariaDB by @tebrown in https://github.com/geoalchemy/geoalchemy2/pull/491
• Release: 0.14.5 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/493

New Contributors

• @tebrown made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/491

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.4...0.14.5

What's Changed

• Build: Add Py312 support by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/487
• Type: Fix Modified check_ctor_args to pass default SRS_ID value in case of null by @satyamsoni2211 in https://github.com/geoalchemy/geoalchemy2/pull/488
• Release: 0.14.4 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/489

New Contributors

• @satyamsoni2211 made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/488

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.3...0.14.4

What's Changed

• Test: Check for max width and height in raster insertion example by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/482
• Bump actions/setup-python from 4 to 5 by @dependabot in https://github.com/geoalchemy/geoalchemy2/pull/483
• Fix: Handle empty doctrings in optimized mode by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/484
• Release 0.14.3 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/485

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.2...0.14.3

What's Changed

• Bump actions/checkout from 3 to 4 by @dependabot in https://github.com/geoalchemy/geoalchemy2/pull/472
• Docs: Add new mapping style example in the gallery by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/473
• Chore: Add templates for issues and pull requests by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/475
• Feat: Added type stub generation for dynamic functions by @mbway in https://github.com/geoalchemy/geoalchemy2/pull/478
• Test: Add a container to run the tests by @mbway in https://github.com/geoalchemy/geoalchemy2/pull/479
• Fix: geoalchemy2.functions type stubs by @mbway in https://github.com/geoalchemy/geoalchemy2/pull/481
• Release 0.14.2 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/480

New Contributors

• @mbway made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/478

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.1...0.14.2

What's Changed

• Docs: Fix badges and link to docs by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/460
• Docs: Add util to replace keywords in docstrings by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/461
• Tests: Minor improvements by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/465
• Add type annotations by @shuttle1987 in https://github.com/geoalchemy/geoalchemy2/pull/464
• Release 0.14.1 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/468

New Contributors

• @shuttle1987 made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/464

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.14.0...0.14.1

What's Changed

• Add MySQL support by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/330
• Reorganize dialects by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/432
• Reorganize tests and fix nullable propagation and some other bugs by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/433
• setup.py needs to know about geoalchemy2.dialects by @EdwardBetts in https://github.com/geoalchemy/geoalchemy2/pull/434
• Add auto extended feature and methods for WKT/WKB conversion from/to extended elements by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/435
• Fix CI by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/439
• Fix: Shapely remains optional requirement by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/441
• fix: handle mysql schemas in column reflection by @EtienneDG in https://github.com/geoalchemy/geoalchemy2/pull/443
• Add an example to insert raster entries in gallery by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/438
• Add Py311 support by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/446
• Fix compatibility with Alembic>1.11 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/447
• Fix ReadTheDocs generation by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/452
• Fix codespell config and typo 'prodived' -> 'provided' by @djm93dev in https://github.com/geoalchemy/geoalchemy2/pull/454
• CI: Use new action to setup Mamba by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/455
• Add GeoPackage support by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/456
• Remove the management parameter by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/415
• Split load_spatialite into load_spatialite_driver and init_spatialite by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/459

New Contributors

• @EtienneDG made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/443
• @djm93dev made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/454

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.13.2...0.14.0

What's Changed

• Fix compatibility with Alembic>1.11 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/449

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.13.2...0.13.3

What's Changed

• Fix compatibility with SQLAlchemy>=2 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/424
• Improve monkeypatch robustness and related tests by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/425
• Remove schema from the engine used in tests for SQLite dialect by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/426
• Move SQLite functions to the relevant module by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/427
• Install Python and Pypy using Micromamba by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/428

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.13.1...0.13.2

What's Changed

• Fix: Use empty event for unsupported dialects by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/421
• Release 0.13.1 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/422

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.13.0...0.13.1

What's Changed

• Use build package in publish job and remove useless wheel config by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/407
• Add dependabot config by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/411
• Bump actions/setup-python from 3 to 4 by @dependabot in https://github.com/geoalchemy/geoalchemy2/pull/412
• Bump actions/checkout from 2 to 3 by @dependabot in https://github.com/geoalchemy/geoalchemy2/pull/413
• Refactor: Reorganize functions into dialect-specific functions by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/414
• Add precommit and format the code by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/416
• Remove some irrelevant warnings for Raster type by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/418
• Release 0.13.0 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/419

New Contributors

• @dependabot made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/412

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.5...0.13.0

What's Changed

• Fix: Pass the schema in alembic_helpers.create_geospatial_table() by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/404

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.4...0.12.5

What's Changed

• Improve coverage by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/394
• Fix create_geo_table() in alembic helpers to handle foreign keys by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/398

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.3...0.12.4

What's Changed

• Add a test for reflection of a view with spatial columns by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/391
• Replace pkg_resources usage with packaging + importlib.metadata by @jacob-indigo in https://github.com/geoalchemy/geoalchemy2/pull/392

New Contributors

• @jacob-indigo made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/392

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.2...0.12.3

What's Changed

• Fix doc for Alembic helpers by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/386
• Change doc font and increase page width by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/389
• Provide alembic_helpers.include_object again by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/388

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.1...0.12.2

What's Changed

• Fix semicolon in index query for postgresql by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/383

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.12.0...0.12.1

What's Changed

• Improve the gallery example for TypeDecorator by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/373
• Functions returning Box types now return None types instead of Geometry types by @EdwardBetts in https://github.com/geoalchemy/geoalchemy2/pull/375
• Improve reflection mechanism and alembic interactions by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/374
• Improve documentation for functions applied to types other than Geometry by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/380
• Release 0.12.0 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/381

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.11.1...0.12.0

What's Changed

• Improve doc formatting by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/369

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.11.0...0.11.1

What's Changed

• Fix spatial index declaration by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/344
• Use RecoverGeometryColumn instead of AddGeometryColumn with SQLite by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/354
• Remove metaclass as in SQLAlchemy, rework the tests and some reformatting by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/357
• Example of specific compilation for sided buffer with SQLite dialect by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/361
• Add a simple API to register custom mapping for SQLite function names by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/360
• Add GitHub URL for PyPi by @andriyor in https://github.com/geoalchemy/geoalchemy2/pull/364
• Add Alembic helpers for Add/Drop columns with SQLite by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/362

New Contributors

• @andriyor made their first contribution in https://github.com/geoalchemy/geoalchemy2/pull/364

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.10.2...0.11.0

What's Changed

• Use 'load_dialect_impl()' instead of 'impl' to get the type of the TypeDecorator objects by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/346

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.10.1...0.10.2

What's Changed

• Fix creation of columns using a TypeDecorator by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/343

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.10.0...0.10.1

What's Changed

• Add SummaryStats type for the ST_SummaryStatsAgg function by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/334
• Change KeyError into AttributeError in the comparator_factory of CompositeType by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/335
• Drop support for Python < 3.6 by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/337
• Fix cache warnings by @adrien-berchet in https://github.com/geoalchemy/geoalchemy2/pull/338

Full Changelog: https://github.com/geoalchemy/geoalchemy2/compare/0.9.4...0.10.0

• Fix warnings in preparation for SQLAlchemy v2.0 @robintw (#331)

• Add support for not nullable column for SQLite @adrien-berchet (#327)

• Add support for N-D intersects '&&&' operator @dlbrittain (#324)

• Fix quotes in index creation @adrien-berchet (#321)

• Add many missing functions @adrien-berchet (#298)
• Add support for N-D index creation @dlbrittain (#316)

• Add dosctrings to remove sphinx warnings @adrien-berchet (#300)
• Update setup.py to point to new home page location @EdwardBetts (#296)
• Add an internal function registry @adrien-berchet (#293)
• Update CI and tests @adrien-berchet (#286, #287, #303, #307)
• Add doc for functions that are defined for both Geometry and Raster @adrien-berchet (#285)
• Add new examples in the gallery @adrien-berchet (#282, #283, #299)

• Fix ST_AsGeoJSON function @adrien-berchet (#279)
• Add many missing functions @adrien-berchet (#276)

• Use setuptools_scm to manage versions @adrien-berchet (#271)
• Fix insert/update for RasterElement @adrien-berchet (#270)

• Fix eq() method in _SpatialElement so it can work with any type @adrien-berchet (#265)

• Fix Shapely requirements for Pypy @adrien-berchet (#262)
• Add a gallery with tests and doc based on examples given in #219, #244 and #251 @adrien-berchet (#260)
• Add support of the feature version of St_AsGeoJson() @adrien-berchet @zzzeek (#258)
• Add eq to WKBElement and make shape.from_shape() able to create extended elements @adrien-berchet @matthew-emw (#247)
• Extract all SQL concepts from Elements and refactor Raster type @adrien-berchet @elemoine @zzzeek (#256)

• Update test matrix removing Python 3.4 and adding 3.6, 3.7, 3.8 @cjmayo (#253)
• Add reflection example in doc @adrien-berchet (#252)
• Fix tests with PostGIS 3 @elemoine (#250)
• Add default compilation rules to elements and functions which are required for SQLAlchemy < 1.1 @adrien-berchet (#242)
• Raise an AttributeError when a function does not starts with ST_* @adrien-berchet @elemoine (#240)
• Replace ST_Distance_Sphere by ST_DistanceSphere @borisuvarov (#237)
• Make shape.to_shape() work for extended WKTElement objects @adrien-berchet (#236)

• Add some missing functions @adrien-berchet (#224)
• Do not register functions.GenericFunction for sqlalchemy>=1.3.4 @adrien-berchet (#226)
• Redefine the geometry_type/dimension consistency checks @elemoine (#228)
• Correct a spelling mistake @EdwardBetts (#229)
• Do not assume the "public" schema @elemoine (#231)
• Add all geometry constructors @adrien-berchet (#232)

• Support WKBElement objects as bind values @elemoine (#221)
• Document the use of spatial functions in primaryjoin conditions @elemoine (#222)

• Change WKBElement to read SRID from the EWKB string @SergeBouchut (#209)
• Change WKTElement to read SRID from the EWKT string @adrien-berchet @elemoine (#211)

• Add support for function ST_Azimuth @simlmx (#175)
• Remove Python 3.3 from the test matrix @elemoine (#179)
• Correct spelling mistakes @EdwardBetts @elemoine (#180)
• Make WKTElement and WKBElement pickable @elemoine (#182)
• Add SpatiaLite support @elemoine (#181)
• Fix to_shape with SpatiaLite @elemoine (#185)

• Fix ST_LineLocatePoint return type @fredj (#170)

• Fix docstring for overlaps_or_above @dcere (#166)
• Add a WKTElement extended example @movermeyer (#164)
• Add checks to _GISType constructor @elemoine (#162)
• Support geometry column with no typmod @elemoine (#161)
• Add ST_AsTWKB function. @JacobHayes (#146)
• Create MANIFEST.in. @pmlandwher (#147)
• Fix build_sphinx maximum recursion depth. @ifedapoolarewaju (#148)
• Fix typo in elements code. @elemoine (#153)

• Adapt links for "Read the Docs". @adamchainz (#134)
• Simplify and fix tests. @elemoine (#138)
• Set result_type when using operators. @elemoine (#140)
• Add use_typmod option for AddGeometryColumn. @tsauerwein (#141)

• Read geometries with ST_AsEWKB. @loicgasser, @fredj, @elemoine (#122)
• Fix SpatialElement.str on Python 3 @b11z, @elemoine (#130)
• Fix flake8 in tests @loicgrasser (#125)

• Distribute GeoAlchemy as wheels (#114)

• PyPy Support (#79)
• Wrap column name in double-quotes (#83)
• Add ST_Z, ST_AsEWKB and ST_AsEWKT functions (#91)
• Python 3 Support (#99)
• Travis config changes (#100, #102)

• SQLAlchemy 0.9.4 compatibility. @quiqua (#75 and #76)