CREATE TABLE zones AS SELECT zone, LocationId, borough, ST_GeomFromWKB(wkb_geometry) AS geom
FROM st_read('./spatial/test/data/nyc_taxi/taxi_zones/taxi_zones.shx');
should be
CREATE TABLE zones AS SELECT *
FROM st_read('./spatial/test/data/nyc_taxi/taxi_zones/taxi_zones.shx');
Maxxen
commented
2 months ago
CREATE TABLE zones AS SELECT zone, LocationId, borough, ST_GeomFromWKB(wkb_geometry) AS geom FROM st_read('./spatial/test/data/nyc_taxi/taxi_zones/taxi_zones.shx'); should be CREATE TABLE zones AS SELECT * FROM st_read('./spatial/test/data/nyc_taxi/taxi_zones/taxi_zones.shx');