Remove shape column from DataCommon csv download

[theryankelly]

Describe the bug
Also listed in Zoning Atlas Issue #43. The shape column is causing issues for csv export is opened in Excel. Need to remove form that export.

Steps to reproduce
Thread on how to address

Expected behavior
csv should not have the shape file included. It's expect that removing that column we will not have the line breaks and shifted rows because shape column was breaking excel character limit

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Temp fix has been to change download link on Zoning Atlas to shapefile rather than DataCommon where intended. When fixed need to update zoning atlas links and about page text on where to find data.

[mzagaja]

Guy suggested using a function to get all the column names and remove the shape column from the CSV export. However trying this query in the code base:

-c "\\copy \(SELECT 'SELECT ' || STRING_AGG('t.' || column_name, ', ') || ' FROM #{table_name} AS t' FROM information_schema.columns WHERE table_name = '#{table_name}' AND table_schema = 'mapc' AND column_name NOT IN ('shape'))

Does not work. This is potentially due to the fact that the \copy function does not support variable interpolation:

If this is important for users then the workaround would be to load a version of the dataset into the DataCommon with a slightly different name in the tabular schema that sufficiently indicates to the user that dataset might be more useful for tabular purposes if they are an excel user. A more robust (and longer to write) version of the feature would allow the dual uploads and then add logic to all the templates to pick the appropriate tabular v. spatial sources based on which are available. Note that if we do this then going forward the data administrator will need to remember to and update both the tabular and geospatial datasets when there are changes.

[atomtay]

I'm a bit confused about the second proposed solution; don't we already have dual uploads (tabular CSV and spatial SHP)?