Since we can't guarantee that the consumers of this data will have PostGIS, we can't have a geometry column! However, since we have X and Y coordinates and we know the Spatial Reference ID (SRID) - EPSG:2913 - we can give the consumer enough information to do GIS operations simply by adding an integer column with the SRID! So that's what we did - new column is epsg_srid.
Since we can't guarantee that the consumers of this data will have PostGIS, we can't have a
geometrycolumn! However, since we have X and Y coordinates and we know the Spatial Reference ID (SRID) - EPSG:2913 - we can give the consumer enough information to do GIS operations simply by adding an integer column with the SRID! So that's what we did - new column isepsg_srid.