Not able to convert geojson files when the schema is not inferrable

[clembou]

Hi,

I am experiencing this issue with gpq:

gpq: error: failed to create schema after reading 39 features

Based on https://github.com/planetlabs/gpq/issues/142 the answer is clear: there are no non null values in any of the features for one of the columns. Indeed, if I edit the file and add just one everything works fine.

The problem is that unlike in the linked issue it is not possible for me to increase the amount of rows scanned because all the rows have nulls, and this is a case that is pretty common with the files I am dealing with.

While this strict behaviour is understandableby default, is is preventing me from adopting the tool. The ogr2ogr behaviour is maybe questionable (in my case the incriminating column is being added as a string instead of an int), it at least produces an output that is usable.

So perhaps an option to --drop-non-inferrable-columns, or --import-ambiguous-columns-as-strings would be a useful escape hatch for gpq users. (pre-processing json is of course an option too but more invovled)