#encoding: utf-8__author__ = ' Administrator ' #import pymongofrom Pymongo Import mongoclient,geo2dimport sqlite3import sysimport psycopg2import ppygisimport cx_oracleimport datetimereload (sys ) #中文错误sys. setdefaultencoding ("Utf-8") #mongoclient = Mongoclient ("192.98.12.245", 30007) db = client[' tiledb ']tiles = db[' tiles ']poi = db[' poi '] #assert isinstance (Tiles, object) print (Tiles.find_one ()) #拉框查询函数def dowithinquery (): Print ( Poi.find ({"loc": {"$within": {"$box": [[75.23,20.32],[152.23,60]]}}}). Count ()) for p in Poi.find ({"loc": {"$within": {" $box ": [[[[75.23,20.32],[152.23,60]]}}): Print p[' address ']def readsqlite2mongondb (): #删除以前记录 poi.remove () sql_t XT = Sqlite3.connect ("C://poi.tdb") Cusor = Sql_txt.cursor () cusor.execute ("SELECT * from POI") row = Cusor.fetchone (); For _row in Cusor.fetchall (): print _row _p = {"name": _row[1], "address": _row[2], "loc": [_row[9],_row[10]]} poi. Insert (_p) print ("Insert Complete ...")