Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Geometry guessed as double by GDAL #2106

Closed
iriberri opened this issue Feb 6, 2015 · 1 comment
Closed

Geometry guessed as double by GDAL #2106

iriberri opened this issue Feb 6, 2015 · 1 comment

Comments

@iriberri
Copy link
Contributor

iriberri commented Feb 6, 2015

Creating the following table:
image

Exporting as CSV (the rest of formats work as expected) and reimporting causes the following error:

2015-02-06 10:37:07 UTC: Georeferencing...
2015-02-06 10:37:07 UTC: Disabling autovacuum for "cdb_importer"."importer_187fa0f6adec11e49337040120e0c101"
2015-02-06 10:37:07 UTC: Creating the_geom from the_geom column
2015-02-06 10:37:07 UTC: replace empty strings by nulls?
2015-02-06 10:37:07 UTC: no string column found, nothing replaced
2015-02-06 10:37:07 UTC: geometrifying
2015-02-06 10:37:07 UTC: Error creating the_geom: PG::Error: ERROR:  invalid input syntax for type double precision: ""
LINE 4:           AND the_geom != ''

Exported CSV available here in RAW version.

In this specific case for coordinates (2,2), the WKB geom only contains a letter, so it seems that it's not recognized as a geometry.

0101000020E610000000000000000008400000000000000840

PS: I changed the coordinates to "force" the recognition as geom, and detected that the column wkb_geometry was in the table when imported:

image

I've seen this column in the tables lately a couple of times, in production too. I moved this to: #2107

cc @juanignaciosl @rafatower @javisantana

@juanignaciosl juanignaciosl added this to the Guarrate milestone Feb 6, 2015
@juanignaciosl juanignaciosl self-assigned this Feb 6, 2015
@juanignaciosl juanignaciosl modified the milestones: ElSoto, Guarrate, Baeza Mar 2, 2015
@juanignaciosl juanignaciosl removed this from the Baeza milestone Mar 24, 2015
@juanignaciosl juanignaciosl removed their assignment Apr 6, 2015
@iriberri
Copy link
Contributor Author

iriberri commented Sep 8, 2016

The dataset I attached is working without issues. We had lots of changes in CartoDBfication and ogr2ogr since this was opened.

Not reproducible, closing.

@iriberri iriberri closed this as completed Sep 8, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants