On Mon, Jul 8, 2019, at 4:45 AM, Mauro Mussin wrote:
> I have a postgres-postgis dB with a geometry:point field: if I insert the
> values directly
> INSERT INTO points(coordinates) VALUES (ST_GeomFromText('POINT(10.809003
> 54.097834)',4326));
>
> no issue, but if I use this sequence (Python)
> *->import data in a dataframe: data contains lat and long columns;*
> *-> trasform the lon,lat column in a shapely.geometry.point;*
> *->create a geodataframe (gdf)*
> *->connect to dB with psycopg2 and sqlalchemy*
> **
> gdf.to_sql('<mytable>, conn,if_exists='append',index=False,schema=<myschema>)
>
>
> I got this error:
Is this with geoalchemy? Otherwise I don't know where you are getting the Point
class from. I'm not familiar with "gdf" however if it creates SQLAlchemy
expressions, it needs to ensure that an insert construct refers to Table
metadata that includes a Point-handling datatype, such as
https://geoalchemy-2.readthedocs.io/en/latest/types.html#geoalchemy2.types.Geometry,
which will produce the proper coercions from a "Point" object to the
appropriate string/object representation for psycopg2 to accept.
Alternatively, psycopg2 also allows for native data handlers, again since I
don't know what "gdf" is (googling was inconclusive), they might have
recommendations to do it this way, not sure. "gdf" is where you need to get
assistance.
>
> --------------------------------------------------------------------------
> ProgrammingError Traceback (most recent call last)
> /opt/conda/lib/python3.7/site-packages/sqlalchemy/engine/base.py in
> _execute_context(self, dialect, constructor, statement, parameters, *args)
> * 1223* self.dialect.do_executemany(
> -> 1224 cursor, statement, parameters, context
> * 1225* )
> /opt/conda/lib/python3.7/site-packages/sqlalchemy/dialects/postgresql/psycopg2.py
> in do_executemany(self, cursor, statement, parameters, context)
> * 751* else:
> --> 752 cursor.executemany(statement, parameters)
> * 753*
> ProgrammingError: can't adapt type 'Point'
>
>
> Any hints?
>
>
> --
> SQLAlchemy -
> The Python SQL Toolkit and Object Relational Mapper
>
> http://www.sqlalchemy.org/
>
> To post example code, please provide an MCVE: Minimal, Complete, and
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full
> description.
> ---
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/sqlalchemy.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/sqlalchemy/0a501873-7f27-45d1-93ec-c08aa0922a30%40googlegroups.com
>
> <https://groups.google.com/d/msgid/sqlalchemy/0a501873-7f27-45d1-93ec-c08aa0922a30%40googlegroups.com?utm_medium=email&utm_source=footer>.
> For more options, visit https://groups.google.com/d/optout.
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/dc75ba95-bc33-4204-9342-5ec9cbf7928a%40www.fastmail.com.
For more options, visit https://groups.google.com/d/optout.
