mysql空间数据库

shp==>mysql

ogr2ogr -f MySQL MySQL:geo,host=localhost,user=root /Users/fangjian/p4/project/jskjg/resource/kjg-map/objects.shp -nln geo -update -overwrite -lco engine=MYISAM

如果缺mysql driver，要重装

brew uninstall gdal 
brew install gdal --with-mysql

引擎要用MyIsam,否则不支持空间索引 http://blog.csdn.net/historyasamirror/article/details/6528527

教程 http://howto-use-mysql-spatial-ext.blogspot.com/

最后发现，mysql不能直接转geojson http://stackoverflow.com/questions/10868025/change-mysql-spatial-into-geojson-by-using-php

所以还是用postgis吧