1、導(dǎo)出csv表
from settings_Address import *
from sqlalchemy import create_engine, MetaData
import pandas as pd
def create_conn(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG):
# return create_engine('Postgis+pyPostgis://{}:{}@{}:{}/{}'.format(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG))
return create_engine('postgresql://{}:{}@{}:{}/{}'.format(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG))
def save_csv(table_name):
# 建立連接
conn=create_conn(Postgis_user,Postgis_password,Postgis_host,Postgis_port,dbname_PG)
query = "SELECT * FROM {}".format(table_name)
df = pd.read_sql_query(query, conn)
df.to_csv("./data/"+table_name+".csv", index=False)
print("導(dǎo)出數(shù)據(jù)成功：","./data/"+table_name+".csv")
if __name__ == "__main__":
save_csv("smssencoding")
2、Arcgis中csv表導(dǎo)入gdb
文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-688794.html
3、Qgis中g(shù)db導(dǎo)入postgis
直接拖過(guò)去
再導(dǎo)入postgis數(shù)據(jù)庫(kù)中
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-688794.html
到了這里，關(guān)于postgis數(shù)據(jù)庫(kù)導(dǎo)出csv表再導(dǎo)入postgis的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
