Six months into expanding the Urban.com.au Project Database to take on a national focus, from time to time we've been taking a step back and assessing the numbers.

Our Sydney data is not as mature as our Melbourne data but there have been many updates and changes since we last looked at some of the trends happening in the Emerald City.

Only one of the top 10 suburbs listed below is located within inner-city Sydney, all other suburbs in our ranked list of suburbs with the most dwellings in the development pipeline are further out - much further out in some cases.

While other inner Sydney suburbs are present on the Urban.com.au database - such as Mascot at #13, Zetland at #18, and postcode 2000 itself ranked outside the top 20 at #21 - the vast bulk of Sydney's pipeline of new apartments are in middle and outer reaches of the metropolitan area.

The correlation between new large-scale public transport investment and medium and higher density development pipeline is particularly strong among the top suburbs. Parramatta, the top Sydney suburb at this stage, for instance, will be the beneficiary of a new light rail line which already has a second stage planning underway.

It will likely also receive a station on the mooted Western Sydney Metro. Schofields and Rouse Hill are outer metropolitan areas that will see the first phase of the Sydney Metro Northwest open next year and Macquarie Park, while it has had a rail service for over 10 years, it will also see service improvements when the existing Epping-Chatswood line is converted for Sydney Metro's use.

The second phase of the Sydney Metro - the City and Southwest project - apart from building a new North Sydney, Harbour and CBD tunnel, will re-use the existing Bankstown line via Sydenham - all stations between those two points are presented on the Urban.com.au database but Bankstown is the only one to make the top 20 list at this stage.

Major rail stations or rail junctions feature in the top 20 quite prominently - apart from the #1 rank Parramatta, Liverpool, Lidcombe, Epping and Penrith are flying that flag and Wentworth Point, a former industrial peninsula adjacent to Sydney Olympic Park ranks at #4. Wentworth Point is likely to benefit from improved connectivity and stage 2 of the Parramatta Light Rail project.

The number of dwellings below are for all projects on the Urban.com.au project database across all four main statuses - Planning Assessment, Approved, Registration & Sales and Under Construction.

Click on a suburb name to view a summary of the development pipeline for each region.