Importing data

To load basic data, open the corresponding NET Design project. You can find out how to do this here.

Switch to the “NET Design” tab. You will find the “Import” button on the far left of the panels.

mceclip0.png

Start the import by clicking the “Import” button

 mceclip0.png

Import demand points

The import from Excel is demonstrated using the example of the import of demand points. The georeferenced addresses are imported into the feature class “Demand Point”.

The destination document is predefined.

Select the appropriate import format.

mceclip4.png

Start the data selection and select the appropriate source.

mceclip5.png

Select the target feature class. In the example here, this is the “Demand Point.” Data in the feature class “Demand Point” is default data for the optimizer and is not modified by it.

The number of records found is displayed.

mceclip1.png

Note

When importing data from Excel, if the source data and the coordinate system of the project are not identical, then you must manually assign the source coordinate system. In this case, the geometry data will then be transformed.

Please note that for coordinates in ETRS89_UTM, the Easting must have 6 digits and the Northing must have 7 digits.

Define the assignment of attributes.

The attributes of the Target are displayed under “Attribute Caption”. You can assign the corresponding attribute from the source data under “Data column”. Under “Source”, you can choose between importing from the source data or filling with a constant value. 

mceclip4.png

User-defined attributes

If your source data contains attributes that you cannot assign to a target attribute, you have the option of importing them as Custom attributes.

Click on the “Add item” button to add attributes; the “Delete item” button removes attribute assignments.

mceclip6.png

Select the attribute from the source data. The attribute designation is set automatically and can be changed by you. Make sure that you do not use any umlauts and special characters. 

Filter conditions

You have the option of defining filter conditions for the import. Click on the “Add Item” button to add filters; the “Delete Item” button removes set filters.

mceclip7.png

You can set both attributive and spatial filters.

mceclip9.png

Spatial filter

mceclip10.png

The setting of filter conditions is supported by selection fields. Select the appropriate operator, the filter condition, and the object that maps the geometric filter. The geometries for the spatial filter are polygon objects and must already exist in the project.

Attribute filter

mceclip11.png

When setting attribute filters, select the attribute to which the filter is to be applied. Select the appropriate operator and set the filter condition.

Saving settings

Settings that have been used once can be saved under “Importer Settings” and loaded for further imports.

mceclip12.png

Perform import

The “Import” button starts the process. 

mceclip13.png

You have to close the import dialog before you can see the imported data in the project. 

In the graphic, run the “Zoom to Extents” command to load the graphic at the location of the imported data.

Importing from shape

For the shape import, the .CPG and .PRJ files must be available. These files contain the character encoding and the coordinate system. If the CPG file is missing, umlauts will not be converted correctly.

Result

After loading demand points and street center lines, the project may look like this. The display depends on the individual display model. The background data can also supplement the view of the planning.

mceclip4.png