Difference between revisions of "Import Network Database From Shapefile"

From TMCWiki
Jump to: navigation, search
Line 19: Line 19:
  
 
'''From Node'''
 
'''From Node'''
:Optional and with no effect on linking; field with information on the nodes.
+
: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 select here the database
  
  
To Node: optional and has no effect on linking – field with information to node
 
From Segment: optional and has no effect on linking – field with information from Segment
 
To Segment: optional and has no effect on linking – field with information to Segment
 
Link Type: select field that contains information in Road Type. Often its named FRC
 
Link Type Filter: will show which road types are available in the shape file. You can select all types for
 
import or select only certain types. If you select 1, 2 and 3 you will be able to import
 
4 and 5 later
 
Connection Settings: If you want to import in existing database select here the database
 
 
Create Database: If you want to create a new database select here where to store. With Firebird local
 
Create Database: If you want to create a new database select here where to store. With Firebird local
 
it must be always on a local harddrive
 
it must be always on a local harddrive

Revision as of 14:48, 6 August 2012

Link Editor menuImport 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 select here the database


Create Database: If you want to create a new database select here where to store. With Firebird local it must be always on a local harddrive Delete existing data If you import in existing table you can chose if existing data in the database should be in network database: deleted. If you want to add FRC 5 and 6 after you already imported FRC 1-4 then this field should not have a flag 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.