mac下安装python，解析sqlite空间数据库

安装pip

(要下载whl，会比较慢，建议上梯子)

curl 'https://bootstrap.pypa.io/get-pip.py' > get-pip.py
sudo python get-pip.py
pip --version

安装gdal

pip install gdal -i https://pypi.tuna.tsinghua.edu.cn/simple

安装psycopg2

读postgresql库

pip install psycopg2-binary -i https://pypi.tuna.tsinghua.edu.cn/simple

python3 链接sqlite

import sqlite3 

conn2 = sqlite3.connect(dbfile)
conn2.enable_load_extension(True)
conn2.load_extension('/usr/local/lib/mod_spatialite')  # 启用空间扩展
c2 = conn2.cursor()
sql = "PRAGMA table_info(''table1);"
cursor_cols = c2.execute(sql)

python2 链接sqlite

import pyspatialite.dbapi2 as db

con = db.connect(dbfile)
cursor = con.execute('SELECT sqlite_version(), spatialite_version()')  # 测试版本
print cursor.fetchall()