1.3. SQLite installation

1.3.1. Install SQLite on Windows ¶

Please visit SQLite 下载页面 To download precompiled binaries from the Windows area

You need to download sqlite-tools-win32- .zip 和 sqlite-dll-win32- .zip compressed file.

Create the folder C:sqlite, and extract the above two compressed files under this folder, and you will get sqlite3.def, sqlite3.dll, and sqlite3.exe files.

Add C:sqlite to the PATH environment variable, and finally, at the command prompt, use the sqlite3 command to display the following results.

C:\>sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

1.3.2. Install SQLite on Linux ¶

Currently, almost all versions of the Linux operating system come with SQLite. So, just use the following command to check if SQLite is installed on your machine.

$ sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

If you don’t see the above results, it means that SQLite is not installed on the Linux machine. So, let’s install SQLite by following these steps:

Please visit SQLite 下载页面 Download from the source code area sqlite-autoconf-*.tar.gz .

The steps are as follows:

$ tar xvzf sqlite-autoconf-3071502.tar.gz $ cd sqlite-autoconf-3071502 $ ./configure --prefix=/usr/local $ make $ make install

The above steps will install SQLite on the Linux machine, which you can verify as explained above.

1.3.3. Install SQLite on Mac OS X ¶

The latest version of Mac OS X pre-installs SQLite, but if no installation is available, just follow these steps:

Please visit SQLite 下载页面 Download from the source code area sqlite-autoconf-*.tar.gz .

The steps are as follows:

$ tar xvzf sqlite-autoconf-3071502.tar.gz $ cd sqlite-autoconf-3071502 $ ./configure --prefix=/usr/local $ make $ make install

The above steps will install SQLite on the Mac OS X machine, which you can verify using the following command:

$ sqlite3 SQLite version 3.7.15.2 2013-01-09 11:53:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite>

Finally, at the SQLite command prompt, use the SQLite command to do the exercise.

最近几年来，地理信息系统无论是在理论上还是应用上都处在一个飞速发展的阶段。 GIS被应用于多个领域的建模和决策支持，如城市管理、区划、环境整治等等，地理信息成为信息时代重要的组成部分之一； “数字地球”概念的提出，更进一步推动了作为其技术支撑的GIS的发展。与此同时，一些学者致力于相关的理论研究，如空间感知、空间数据误差、空间关系的形式化等等。这恰好说明了地理信息系统作为应用技术和学科的两个方面，并且这两个方面构成了相互促进的发展过程。