City-scale data marts are requested to help local policy makers to identify viable and efficient solutions. In this context, the Regional Federated Data warehousing Framework (RFDW), which has been introduced in our previous literatures, is extended and used to develop such city-scale data marts. Afterwards, a case study, namely GAINS-City China, will be presented as a city scale manifested data mart to approve our concepts.