geopandas-postgis | custom accessor to GeoPandas that provides enhanced PostGIS | Reflection library
kandi X-RAY | geopandas-postgis Summary
kandi X-RAY | geopandas-postgis Summary
Adds a custom accessor to GeoPandas that provides enhanced PostGIS interaction
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Get long description .
geopandas-postgis Key Features
geopandas-postgis Examples and Code Snippets
Community Discussions
Trending Discussions on geopandas-postgis
QUESTION
I want to pass in parameters to a sql query when using GeoPandas from_postgis functionality with SQLAlchemy.
classmethod GeoDataFrame.from_postgis(sql, con, geom_col='geom', crs=None, index_col=None, coerce_float=True, params=None)
I have looked at a previous similar question and also here which suggests to use SQLAlchemy's textual SQL option. However, this requires access to con.execute which isn't included in the GeoDataFrame from_postgis option.
Could you suggest the best way to pass the parameters to SQL? If not directly in from_postgis, then how best to construct the full SQL string separately and passing it in as the first sql argument to from_postgis.
...ANSWER
Answered 2017-Jul-18 at 17:43From the linked similar question:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install geopandas-postgis
You can use geopandas-postgis like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page