The long island state plane columns are useful for spatial calculations, such as distance and intersection.
We use 2263 for long island state plane to standardize it with the existing zoning district and tax lot columns. However, the source data is technically 6539 which uses a 2011 adjustment to NAD83. Converting from 6539 source to 2263 target will be straightforward because both coordinate systems are already defined within PostGIS.
The mercator columns are useful for generating Mapbox vector tiles, which depend on the pseudo-mercator projection
Each project may have multipoint or multipolygon source spatial information. Talking with data engineering, these fields are not mutually exclusive in theory. In practice, there are no projects with both spatial shapes. However, about 62% of projects have no spatial information.
The mercator label field is used to place the label within the source data. It is pre-calculated and saved in its own column to save time processing power when requesting vector tiles.
Acceptance Criteria
[x] Spatial columns exist on the project schema and mirror the columns documented in the ERD/reference SQL table
[x] The database columns use snake_case and the javascript variables use camelCase
Note Do not add these spatial columns to the zod schema. They are not expected to be part of standard responses.
Description
Add long island state plane and mercator projection spatial fields to project table.
What is each field used for?
mercator label
field is used to place the label within the source data. It is pre-calculated and saved in its own column to save time processing power when requesting vector tiles.Acceptance Criteria
Note Do not add these spatial columns to the zod schema. They are not expected to be part of standard responses.
Related tickets
Blocked by #210