User Tools

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
geoscene3d:project_content:datasets:tabular_dataset [2020/02/12 16:06] – rebecca130301_gmail.comgeoscene3d:project_content:datasets:tabular_dataset [2020/03/22 17:59] (current) – external edit 127.0.0.1
Line 7: Line 7:
 ==== Source Types ==== ==== Source Types ====
  
-[[:geoscene3d:project_content:datasets:access_database_source|Access Database Source]] of any format\\ +[[:geoscene3d:project_content:sources:access_database_source|]] of any format\\ 
-[[:geoscene3d:project_content:datasets:csv_file_source|CSV File Source]]. Any CSV file containing at least easting (X) and northing (Y)\\ +[[:geoscene3d:project_content:sources:csv_file_source|]]. Any CSV file containing at least easting (X) and northing (Y)\\ 
-[[:geoscene3d:project_content:datasets:firebird_database_source|Firebird Database Source]] of any format\\ +[[:geoscene3d:project_content:sources:firebird_database_source|]] of any format\\ 
-[[:geoscene3d:project_content:datasets:odbc_source|ODBC Source]]+[[:geoscene3d:project_content:sources:odbc_source|]]
  
 ==== Configuration ==== ==== Configuration ====
Line 19: Line 19:
 __X:__ Field or column name for X coordinates (required).\\ __X:__ Field or column name for X coordinates (required).\\
 __Y:__ Field or column name for Y coordinates (required).\\ __Y:__ Field or column name for Y 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:project_content:datasets:project_settings|Project Settings]].\\+__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|]].\\
 __ID:__ Field or column name for ID.\\ __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. __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.
Line 29: Line 29:
 __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.\\
Line 38: Line 38:
 **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…:__ 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 [[:geoscene3d:project_content:datasets:dataset_viewer|Dataset Viewer]].+__Preview Data…:__ Shows a preview of the data resulting from the query using the [[:geoscene3d:application:data_management: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 [[:geoscene3d:project_content:datasets: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.+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.
  
  

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