Difference between revisions of "Import Network Database From Shapefile"
| Line 43: | Line 43: | ||
'''Connection Settings''' | '''Connection Settings''' | ||
| − | :If you want to import the data to an existing database | + | :If you want to import the data to an existing database press this button and enter the database connection details in the appearing window. |
| − | Create Database: If you want to | + | '''Create Database''' |
| − | + | :If you want to load the data into a new database instead, click this button, browse for the directory you wish the new database to be stored into and enter a database name. Note that with the database type '''Firebird local''', the storage location always needs to on a local harddrive. | |
| − | Delete existing data If you import | + | |
| − | + | ||
| − | + | '''Delete existing data in network database''' | |
| + | :If you import into an existing database, choose this option only if you want all exisiting data to be deleted prior to the import process. | ||
| + | :Do '''not''' flag this option, if you want to add the '''Road Types''' (FRC) 5 and 6 in a second run after already having imported FRC 1 till 4! | ||
| + | |||
| + | |||
| + | |||
| + | {{Warning}} | ||
| + | |||
Depending on number of Segements that will be imported this task can take several hours. An approximate | Depending on number of Segements that will be imported this task can take several hours. An approximate | ||
estimation will be shown in the Import Screen, it will also show how many segments have been already | estimation will be shown in the Import Screen, it will also show how many segments have been already | ||
Revision as of 15:42, 6 August 2012
Link Editor menu → Import Network Database From Shapefile
In this window you specify all necessary information to import a network shapefile to your tmcStudio database.
Shapefile
- Click on the folder button
and select the shapefile containing the network data you wish to import to your database.
Link ID
- Select the field of your shapefile that contains the ID for the segment. It is mandatory that your network table contains a unique ID for each segment.
Link Name
- Select the field that contains the street or road names; optional but recommended.
From Node
- Optional and with no effect on linking; field with information on the from nodes.
To Node
- Optional and with no effect on linking; field with information on the to nodes.
From Segment
- Optional and without effect on linking; field with information on the from segments.
To Segment
- Optional and with no effect on linking; field with information on the to segments.
Link Type
- Select the field in your shapefile that contains information on the road type. Often it is named FRC.
Link Type Filter
- As soon as a Link Type has been specified, this field will display the road types available in the shapefile. Select the road types you wish to import by flagging them. Note that if you select 1, 2 and 3 for instance, you will be able to import 4 and 5 later.
Connection Settings
- If you want to import the data to an existing database press this button and enter the database connection details in the appearing window.
Create Database
- If you want to load the data into a new database instead, click this button, browse for the directory you wish the new database to be stored into and enter a database name. Note that with the database type Firebird local, the storage location always needs to on a local harddrive.
Delete existing data in network database
- If you import into an existing database, choose this option only if you want all exisiting data to be deleted prior to the import process.
- Do not flag this option, if you want to add the Road Types (FRC) 5 and 6 in a second run after already having imported FRC 1 till 4!
Important Advice
Depending on number of Segements that will be imported this task can take several hours. An approximate estimation will be shown in the Import Screen, it will also show how many segments have been already processed.
