Plans to build a block of council homes in Ripon, one of the UK's most sinkhole-prone cities, have been abandoned due to the geological risk.
Harrogate council said 17 proposed units at Allhallowgate could not progress.
The decision followed problems with ground stability at the site, it added.
Ripon sits above a layer of gypsum - a water-soluble rock which leads to the formation of large underground caves which can collapse.
A major sinkhole saw 12 properties in the city evacuated after a deep hole appeared in 2016.
Last year,a supermarket was closed when a hole opened up at the back of the store.