To load MapPLUTO into carto, the best approach is to upload the five borough shapefiles together, then
UNION ALL them together.
- Upload all five zipped borough shapefiles from Bytes of the Big Apple. Be sure to uncheck 'Allow Carto to guess column types" when uploading, or you'll get column type mismatches
UNION ALLthe tables together with the following query. We can't just
SELECT *because we'd have duplicate
cartodb_ids in the result set, and saving as a new table would fail.