search

NYCPlanning / db-cpdb

Capital Projects Database
https://nycplanning.github.io/db-cpdb
0 stars 0 forks source link

Error converting lines to polygons #108

Closed SashaWeinstein closed 1 year ago

SashaWeinstein commented 2 years ago

The attributes_geomclean.sql file is responsible for converting line geometries to polygons. These polygons are created with the postGIS ST_Buffer function which creates a polygon comprised of all points within 15 units of a given geography (in this case the original line). This step fails in github actions with the error message of psql:sql/attributes_geomclean.sql:4: ERROR: GEOSBuffer: TopologyException: No forward edges found in buffer subgraph. An example can be found in line 11775 of the 02 Build Attribute step of this action.

This error doesn't occur on local builds from my machine or Max's. This leads us to believe it's a memory issue that could be resolved by breaking the task up into smaller pieces. Amanda found a good stack overflow post (attach here or in additional comment?)

mbh329 commented 1 year ago

@SashaWeinstein @AmandaDoyle @td928 Flagging this as we just built CPDB, I don't quite remember much about this issue and didn't see an associated PR

SashaWeinstein commented 1 year ago

Just mentioned this issue in PR that addressed it, can close