Gdal 1.11.0 Add Postgresql 9.1 sqlite3 Support

OS Environment Ubuntu12.04 32bit

Because a company's function is to use the Gdal ogr2ogr command to convert SHP data, you need to be able to insert data into PostGIS and SQLite.

With the gdal1.11.0 source default installation, PostgreSQL and SQLite are not able to support

Later on the machine installed PostgreSQL 9.1 is not, and eventually found that a packet Libpq-dev (found to find out./configure's diary is very important)

PostgreSQL Support:yes
MySQL Support:no
Ingres Support:no

Today on the machine again installed Sqlite3, also failed to support the successful implementation of the following installation

sudo apt-get install Libsqlite3-dev Libgeos-dev

./configure--with-spatialite=yes--with-sqlite3=yes--with-pg=/usr/bin/pg_config

Show support is yes

SQLite Support:yes
PCRE Support:no
Spatialite Support:no

When SQLite is displayed as make install, there is no option to find SQLite

It's Spatialite Support:no's problem.

I found this bag on the internet, Libspatialite-dev .

Https://launchpad.net/ubuntu/+source/spatialite

Then execute the above configure statement, the status is Yes

SQLite Support:yes
PCRE Support:no
Spatialite Support:yes

Execute once make Clean,make,make install

There are postgresql,sqlite in the Format_name supported by Ogr2ogr--long-usage.

-F format_name:output file format name, possible values is:
-F "ESRI Shapefile"
-F "MapInfo File"
-F "TIGER"
-F "S57"
-F "DGN"
-F "Memory"
-F "BNA"
-F "CSV"
-F "GML"
-F "GPX"
-F "KML"
-F "GeoJSON"
-F "GMT"
-F "GPKG"
-F "SQLite"
-F "WAsP"
-F "PostgreSQL"
-F "Pcidsk"
-F "DXF"
-F "Geoconcept"
-F "GeoRSS"
-F "Gpstrackmaker"
-F "Pgdump"
-F "GPSBabel"
-F "PDF"

.... ing in

The article is written first, and then it's time to sort it out.

Resources

Http://lists.osgeo.org/pipermail/gdal-dev/2012-January/031546.html

http://askubuntu.com/questions/190604/how-to-install-spatialite-3-on-12-04

PostGIS Online Installation http://blog.csdn.net/wildghost/article/details/7746204

Again recommended a paste of prawns: http://www.cnblogs.com/yeahgis/archive/2012/04/13/2446305.html