How to write from pandas Dataframe to PostgreSQL with a geometry type
![atimetobesmall](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar5.png)
atimetobesmall
Registered Posts: 4 ✭✭✭✭
Hello,
In my python receipt, I would like to write in my PostreSQL database (with PostGis extension) data with a geometry type. Therefore, I declared a schema and created my table with this specific schema
schema = [{"name": 'id', "type": 'int'}, {"name": 'value', "type": 'string'}, {"name": 'the_geom', "type": 'geometry'}]
test_schema = dataiku.Dataset("test_schema")
test_schema.write_schema(schema, dropAndCreate=True)
with test_schema.get_writer() as writer:
writer.write_dataframe(df_test)
However there's no way "Dataiku" recognizes any geometry type I tried. Is it possible to have the list of types that Dataiku can handle?
Tagged:
Answers
-
Hi,
At the moment, it's unfortunately not possible to directly write Postgis types directly from Python. What we would recommend is to write the WKT as a string column, and then use a SQL Script recipe to copy it into a geometry column.
Adding real support for Postgis is on our roadmap, but we do not yet have an ETA for this. -
Ok, thank you for your anwser
-
Hello Clément,
Have you any news on that topic? I have the same issue with visual recipes. Do we still have to add a SQL scripts to our Workflow?
Thanks in advance
Romain
-
Thanks Corey,
I don't need to look for another solution anymore. So it helps.