Search CityCAD Online Help CityCAD Online Help > Exchanging information > Importing files > Importing data

CityCAD Online Help

Importing data

Data Import is an advanced feature which allows you to import tabular data and map specific attributes on to blocks, routes, nodes and subdivisions in your CityCAD model.

You can import data from the following filetypes:

Importing Data - step by step

1. Check that your data file is in the correct format

Your data file needs to be in csv, xls or xlsx format. Some or all elements (block, route, subdivision etc) in your CityCAD model should be listed on a new row in the data file, identified by name or ID.

Including column headers eg. 'Block Name' will make the task easier.

For example, a simple data file to be imported might look like this:

Tip: Export your CityCAD model as a data file first, then use this as a base for any edits or additional data.

If you have exported a data file from CityCAD, then this will generally be in the correct format.

  • If you want to change attributes such as number of storeys, then edit the relevant column directly and re-import the data file.
  • If you want to add custom parameters to elements in your model, then add a column and enter a column header with the name of the new custom parameter you want to add.

Need to import data for floors and subdivisions?

If you want to import data for floors or subdivisions, then you will almost always need to start by exporting the model as a data file, so that the IDs are correct and the elements and subdivisions are in the correct order, before then adding or editing data. (It is normally essential to map floors and subdivisions by ID as many names are usually the same eg. 'Subdivision 1').

2. Open the Data Import window

You can open the Data Import Window in three ways:

The data import window will appear. It is divided into three parts which are explained in more detail below.

3. Map Data into CityCAD

If you dragged a data file into the CityCAD window, then this will already be set. If you have imported a data file previously, then this file will be set.

If no file is selected or if you want to import a different file click 'Browse' to select the data file you wish to import.

If you are importing an Excel file with several worksheets, you can select which worksheet to use by the drop down menu. Please note you cannot import data from more than one worksheet at a time.

4. Map Data

This panel allows you to match up elements in your CityCAD model with rows in your imported data file.

You can use either 'Name' or 'ID' to do this. If you are using 'Name', then make sure that each element in your model has a unique name. Be aware that you may well have duplicate names - for example if you have cut a block in two by drawing a route, then each part will inherit the same name from the original block.

By default, the program will try to match names with names of elements in your model and will make a suggestion. Please check this - if necessary you can adjust each mapping manually by clicking on an entry and selecting from the drop-down menu. For example, a row in the data file may not correspond with any element, or you may wish to map the same row on to several elements in the CityCAD model.

Please let us know if you would also find it useful to map data by position of the elements using x,y coordinates. This is a feature that is under consideration for future versions.

5. Map Attributes

Here, you can set which columns in the data file should be added to the elements chosen in the 'Map Data' panel above.

Note there are different kinds of information that can be mapped:

In the screenshot above, in the 'Map Attributes' panel, three mappings have been created - number of storeys (a CityCAD property), Interest (a new text custom parameter) and 'A Quantity' (a numerical custom value).

When 'Proceed' is clicked, the data will be imported and applied to the relevant elements in the CityCAD model.

The number of storeys of each block will be adjusted to the values in the data file, for the blocks which were mapped in the 'Map Data' panel.

New custom parameters 'Interest' and 'A Quantity' will be created, and assigned to the blocks as mapped in the 'Map Data' panel. You can quickly visualize this data by going to View Menu: Shading: Custom Parameters and select as required.

Note that if you import the data as a numerical value, then the shading will take the form of a gradient between the highest and lowest values.

Advanced Settings and Tips

Importing Number Custom Parameters

This is an advanced setting at the bottom of the data import window. It is relevant when importing numerical data which is to be used to create a new custom parameter or to update an existing custom parameter.

There are two options:

Importing unknown land uses

When importing and mapping land uses on to floors or subdivisions, the data file may contain land uses which are not present in the Land Use Manager.

There are two options of dealing with this:

Creating new custom land uses

When this feature is used, please remember that custom land uses also have a 'Type', which can be 'Residential', 'Office', 'Retail' or 'Other'.

This affects certain outputs in CityCAD, for example the number of units contained in instances of 'Residential'-type land uses are counted as dwellings, and count towards net residential density values.

When you import and create a new custom land use, CityCAD will make a guess as to what type it is, based on a search for a few key words. For example, if you import a land use called '2-bed apartments', the word 'apartments' will be detected and the new land use will be set to a 'Residential' type. However, this system is not infallible - for example a shop called 'home' will be interpreted as a residential land use - and so please double check that newly created land uses have the correct type.

Copyright © 2008-2018. All Rights Reserved.