Getting type error when loading data from postgis via geemap.gdf_to_ee()

[bormy]

Getting type error when loading data from postgis via geemap.gdf_to_ee()

[giswqs]

The error message already indicates that the issue is invalid field type. Did you look into that?

If you want others to help, make sure you provide complete source code and datasets that can reproduce the issue.

[bormy]

The error message already indicates that the issue is invalid field type. Did you look into that?

If you want others to help, make sure you provide complete source code and datasets that can reproduce the issue.

Invalid field type <class 'datetime.date'>

the above is the error message caught by the exception. I am not sure whether it is because of my data or the datetime.date datatype is not supported. Whilst, fetching data from database has no issue. I will look into the geemap source code

[bormy]

After my investigation, the error is because of the date format used in postgres and geopendas GeoDataFrame does expect 'dd-MM-YYYY' by default. Whilst the date returned from PostGIS is 'YYYY-MM-dd' *(it is the default format used in postgresSQL Date datetype).

the suggest solutions:

1. update default DateStyle in postgresSQL server
2. use to_char([date_field], 'dd-MM-YYYY') in select query