|[ < ]||[ > ]||[ << ]||[ Up ]||[ >> ]||[Top]||[Contents]||[Index]||[ ? ]|
The input data for a local geodetic network adjustment (program
gama-local) can be strored in SQLite 3 database file.
The general information about SQLite can be found at
Input data (points, observations and other related information) are stored in SQLite database file. Native SQLite C/C++ API is used for reading SQLite database file. It is described at
Please note if you compile GNU Gama as described in Install and SQLite library is not installed on your system, GNU Gama would be compiled without SQLite support.
SQL schema (
CREATE statements) is in
which is part of GNU Gama distribution and is in the
All tables for
gama-local are prefixed with
In the documentation table names are referred without this prefix.
For example table
gnu_gama_local_points is referred as
Database scheme used for SQLite database is also valid in other SQL database systems. Almost every column has some constraint to ensure correctness.
You can convert existing XML input file to SQL commands with
gama-local-xml2sql, for example
$ gama-local-xml2sql geodet-pc geodet-pc-123.gkf geodet-pc.sql
|3.1 Working with SQLite database|
|3.2 Units in SQL tables||Units of values in SQL tables|
|3.3 Network SQL definition|| Tables |
|3.4 Table |
|3.5 Table |
|3.6 Table |
|3.7 Table |
|3.8 Table |
|3.9 Table |
|3.10 Example of local geodetic network in SQL||Obtaining example of local geodetic network in SQL|
|[ < ]||[ > ]||[ << ]||[ Up ]||[ >> ]|
This document was generated by Ales Cepek on September 16, 2017 using texi2html 1.82.