User Tools

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
geoscene3d:project_content:datasets:tabular_dataset [2020/02/12 16:05] – created rebecca130301_gmail.comgeoscene3d:project_content:datasets:tabular_dataset [2020/03/22 17:59] (current) – external edit 127.0.0.1
Line 5: Line 5:
 The dataset may contain any number of columns (fields), columns containing easting (X) and northing (Y) are always required. Although a column with elevation or depth (Z) is optional in the dataset it may be required in some objects. The dataset may contain any number of columns (fields), columns containing easting (X) and northing (Y) are always required. Although a column with elevation or depth (Z) is optional in the dataset it may be required in some objects.
  
-==== +==== Source Types ====
-Source Types   ====+
  
-[[Access Database Source|]] +[[:geoscene3d:project_content:sources:access_database_source|]] of any format\\ 
- of any format \\ +[[:geoscene3d:project_content:sources:csv_file_source|]]. Any CSV file containing at least easting (X) and northing (Y)\\ 
-[[CSV File Source|]]. Any CSV file containing at least easting (X) and northing (Y) \\ +[[:geoscene3d:project_content:sources:firebird_database_source|]] of any format\\ 
-[[Firebird Database Source|]] +[[:geoscene3d:project_content:sources:odbc_source|]]
- of any format \\ +
-[[ODBC Source|]]+
  
-==== +==== Configuration ====
-Configuration  ====+
  
 In most cases (see model database below) a tabular dataset is defined as a SQL query containing the three usual sections: SELECT, FROM, and WHERE. The configuration dialog reflects these three sections. In most cases (see model database below) a tabular dataset is defined as a SQL query containing the three usual sections: SELECT, FROM, and WHERE. The configuration dialog reflects these three sections.
  
-** +**SELECT ** \\ 
-SELECT  ** \\ +__X:__ Field or column name for X coordinates (required).\\ 
-__X:__ +__Y:__ Field or column name for Y coordinates (required).\\ 
-Field or column name for X coordinates (required). \\ +__Z:__ Field or column name for Z coordinates. Be sure to check the "Z = Elevation" and "Z = Depth" radio buttons. Note: If Z = Depth the Z values are converted to elevation using the designated scene terrain model surface. See [[:geoscene3d:application:project_settings|]].\\ 
-__Y:__ +__ID:__ Field or column name for ID.\\ 
-Field or column name for Y coordinates (required). \\ +__Additional fields (Optional):__ List the names of the fields that should be included in the resulting dataset. The default "*" means that all fields will be included. Warning: In joins including multiple tables this may result in a large number of fields. If this box is left blank all fields are included.
-__Z:__ +
-Field or column name for Z coordinates. Be sure to check the "Z = Elevation" and "Z = Depth" radio buttons. Note: If Z = Depth the Z values are converted to elevation using the designated scene terrain model surface. See  [[Project Settings|]]. \\ +
-__ID:__ +
-Field or column name for ID.  \\ +
-__Additional fields (Optional):__ +
-List the names of the fields that should be included in the resulting dataset. The default "*" means that all fields will be included. Warning: In joins including multiple tables this may result in a large number of fields. If this box is left blank all fields are included.+
  
-** +**FROM ** \\
-FROM ** \\+
 List the tables that contain the fields listed above in the SELECT box. Note: For CSV File Sources this is always the filename. List the tables that contain the fields listed above in the SELECT box. Note: For CSV File Sources this is always the filename.
  
-** +**WHERE ** \\ 
-WHERE ** \\ +__Fixed Extent:__ By default the dataset extent is identical to the current scene extent. However, this option makes it is possible to fix the extent to any area.
-__Fixed Extent:__ +
-By default the dataset extent is identical to the current scene extent. However, this option makes it is possible to fix the extent to any area.+
  
-__ +__Horizontal Extent:__ Defines a rectangular area where data are extracted from the source. Note that the values uses the fields for X and Y entered in the SELECT box.
-Horizontal Extent: __ +
-Defines a rectangular area where data are extracted from the source. Note that the values uses the fields for X and Y entered in the SELECT box.+
  
-__ +__Additional conditions (optional):__ The dataset may be refined further using SQL. This makes it possible to use regular SQL to query the source database or CSV file within the extent. This is an advanced option that can be used for users that has an in depth knowledge of the source format.
-Additional conditions (optional): __ +
-The dataset may be refined further using SQL. This makes it possible to use regular SQL to query the source database or CSV file within the extent. This is an advanced option that can be used for users that has an in depth knowledge of the source format.+
  
 Example: Join two tables (Table1 and Table2) in the dataset. Both tables has an ID Field.\\ Example: Join two tables (Table1 and Table2) in the dataset. Both tables has an ID Field.\\
 ''Table1.ID = Table2.ID '' ''Table1.ID = Table2.ID ''
  
-** +**Preview Buttons ** \\ 
-Preview Buttons ** \\ +__Preview SQL…:__ Shows a preview of the resulting query. Advanced users can use this option to analyze the resulting query.\\ 
-__Preview SQL...:__ +__Preview Data…:__ Shows a preview of the data resulting from the query using the [[:geoscene3d:application:data_management:dataset_viewer|]].
-Shows a preview of the resulting query. Advanced users can use this option to analyze the resulting query. \\ +
-__Preview Data...:__ +
-Shows a preview of the data resulting from the query using the  [[Dataset Viewer|]].+
  
-==== +==== Model Database Source ====
-Model Database Source  ====+
  
-When the source for the tabular dataset is an Access database and is specified to be in  [[Model Database format|]] +When the source for the tabular dataset is an Access database and is specified to be in [[:geoscene3d:project_content:dataformats:model_database_format|Model Database format]] then the configuration of the dataset is simpler. Simply select a model and a digimodel to import. If you want to extract other data from a model database as a tabular dataset simply specify the source database format as unspecified.
- then the configuration of the dataset is simpler.  Simply select a model and a digimodel to import. If you want to extract other data from a model database as a tabular dataset simply specify the source database format as unspecified.+
  
  

This website uses cookies. By using the website, you agree with storing cookies on your computer. Also, you acknowledge that you have read and understand our Privacy Policy. If you do not agree, please leave the website.

More information