What are the cheats in simcity

An abandoned building will eventually be reacquired if its problems are resolved. You can see why the building was abandoned by clicking on it to bring up information that building.

In many instances this will be a reason like the building having no water or power, there not being enough jobs within commute distance, pollution or backed up sewage, or the building being damaged by fire.

Abandoned buildings will have a negative effect on the land value of nearby buildings, and have an increased chance of catching fire. Keeping abandoned buildings around over the long term will drive down land value for the surrounding area and it is usually recommended that once the building goes 'dark' (visibly darker than the surrounding buildings - like the one in your screenshot) that it has begun to decay and will soon reach a point that it is better to bulldoze that building to prevent it from causing damage to the value of the surrounding buildings.

When you activate the bulldozer tool, all abandoned buildings of any zone type will begin flashing with an orange symbol with a line through it to make them easier to locate.

To answer this I'm going to need to establish some criteria for "ideal". I'm going to assume that most people are interested in the most efficient use of a given space for high density buildings allowing you to stuff as much population/commerce/jobs into your city as possible.

Luckily the game itself provides an excellent tool to help you with this. Turning on the "gridlines" feature when plopping a road tile will display gridlines for the last two road tiles you mouse over. The gridline displayed for a given road depends on what road you moused over and what road type you currently have selected.

Mouse over avenue with road selected: The first gridline will provide enough room for two high density buildings back to back making for maximum use of the space given the two road types you want to use.

Mouse over avenue with avenue selected: Same as above

Mouse over road with avenue selected: Same as above

Mouse over road with road selected: The first gridline will provide just enough space for a single high density building to exist between the roads. The second gridline will provide enough space for two high density buildings back to back and a gap inbetween that could fit a road (or is potentially useful for narrow parks).