{"library":"geoalchemy2","type":"library","category":null,"description":"GeoAlchemy 2 is a Python library that extends SQLAlchemy to facilitate working with spatial databases. It primarily focuses on PostGIS, offering robust support for geometry, geography, and raster types, while also providing support for SpatiaLite, MySQL, MariaDB, and GeoPackage. It seamlessly integrates with both SQLAlchemy's Object Relational Mapper (ORM) and its SQL Expression Language, enabling users to define spatial columns, leverage spatial functions, and perform spatial operations. The library is actively maintained, with its current version being 0.18.4, and exhibits a regular release cadence.","language":"python","status":"active","version":"0.18.4","tags":["SQLAlchemy","GIS","geospatial","PostGIS","database","ORM","spatial","geometry"],"last_verified":"Wed May 20","install":[{"cmd":"pip install geoalchemy2","imports":["from geoalchemy2 import Geometry","from geoalchemy2 import WKTElement","from sqlalchemy import func","from geoalchemy2.functions import ST_AsText","from geoalchemy2.shape import to_shape"]},{"cmd":"pip install geoalchemy2[shapely]","imports":[]}],"homepage":"https://geoalchemy-2.readthedocs.io/en/stable/","github":"https://github.com/geoalchemy/geoalchemy2","docs":null,"changelog":null,"pypi":"https://pypi.org/project/geoalchemy2/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":95,"avg_install_s":4.6,"avg_import_s":1.19,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/geoalchemy2/compatibility"}}