There's a large number of invalid linestrings in the _USA.tsv file that only contain a single point or are self-referencing.
Only about 88% of the rows in the US file are valid line strings.
_USA.tsv = 54,484,737
Valid geometries = 48,067,790
Invalid geometries (or points): 6,416,947 (according to @turf/boolean-valid)
ST_IsValid returns false for an additional: 211,991 rows on top of that
Additionally, providing the file as a WKT representation per line would be easier for many folks to load into their database and is much smaller on disk.
jmealo
commented
2 months ago
Hello,
There's a large number of invalid linestrings in the
_USA.tsvfile that only contain a single point or are self-referencing.Only about 88% of the rows in the US file are valid line strings.
@turf/boolean-valid)ST_IsValidreturns false for an additional: 211,991 rows on top of thatAdditionally, providing the file as a
WKTrepresentation per line would be easier for many folks to load into their database and is much smaller on disk.Thanks, Jeff