<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[SOPHIA16527的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/SOPHIA16527</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; SOPHIA16527]]></copyright><item><title><![CDATA[pycharm配置pyqt5]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/143877102</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/143877102</guid><author>SOPHIA16527</author><pubDate>Tue, 19 Nov 2024 11:24:20 +0800</pubDate><description><![CDATA[【代码】pycharm配置pyqt5。]]></description><category></category></item><item><title><![CDATA[切4326矢量瓦片]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764728</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764728</guid><author>SOPHIA16527</author><pubDate>Thu, 08 Sep 2022 14:58:51 +0800</pubDate><description><![CDATA[切4326矢量瓦片]]></description><category></category></item><item><title><![CDATA[gdal命令行融合面]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764486</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764486</guid><author>SOPHIA16527</author><pubDate>Thu, 08 Sep 2022 14:51:09 +0800</pubDate><description><![CDATA[gdal命令行融合面]]></description><category></category></item><item><title><![CDATA[mapbox pbf vt2geojson 解析pbf图层为geojson格式]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764275</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/126764275</guid><author>SOPHIA16527</author><pubDate>Thu, 08 Sep 2022 14:40:45 +0800</pubDate><description><![CDATA[解析pbf图层为geojson格式]]></description><category></category></item><item><title><![CDATA[gdal shp属性过滤并生成新文件]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/125989440</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/125989440</guid><author>SOPHIA16527</author><pubDate>Tue, 26 Jul 2022 10:25:52 +0800</pubDate><description><![CDATA[gdal shp属性过滤，并生成新文件]]></description><category></category></item><item><title><![CDATA[AssertionError: jinja2 must be installed to use Jinja2Templates]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/125330372</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/125330372</guid><author>SOPHIA16527</author><pubDate>Fri, 17 Jun 2022 11:23:28 +0800</pubDate><description><![CDATA[fastapi 依赖]]></description><category></category></item><item><title><![CDATA[合并两个sqlite数据库]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/123902878</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/123902878</guid><author>SOPHIA16527</author><pubDate>Fri, 01 Apr 2022 17:17:59 +0800</pubDate><description><![CDATA[参考：https://blog.youkuaiyun.com/zhanglianyu00/article/details/78436764
sqlite3 test2.sqlite 
attach "test1.sqlite" as AM;
insert into tiles(zoom_level,tile_column,tile_row,tile_data) select zoom_level,tile_column,tile_row,tile_data from AM.tiles;



]]></description><category></category></item><item><title><![CDATA[The Shapely GEOS version (3.9.1-CAPI-1.14.2) is incompatible with the GEOS version PyGEOS was compil]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/121968301</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/121968301</guid><author>SOPHIA16527</author><pubDate>Thu, 16 Dec 2021 10:09:26 +0800</pubDate><description><![CDATA[geopandas The Shapely GEOS version (3.9.1-CAPI-1.14.2) is incompatible with the GEOS version PyGEOS was compiled with (3.10.0-CAPI-1.16.0)
问题：
&gt;&gt;&gt; import geopandas
/lib/python3.8/site-packages/geopandas/_compat.py:84: UserWarning: The Shapely GEOS]]></description><category></category></item><item><title><![CDATA[python3安装FileGDB]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/121471027</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/121471027</guid><author>SOPHIA16527</author><pubDate>Mon, 22 Nov 2021 14:38:22 +0800</pubDate><description><![CDATA[python3安装FileGDB读写驱动
环境
系统：win10x64
python：3.6.5x64
安装步骤
安装gdal： GDAL‑2.4.1‑cp36‑cp36m‑win_amd64.whl
pip install GDAL-2.4.1-cp36-cp36m-win_amd64.whl

安装FileGDBAPI.dll：下载地址
拷贝FileGDBAPI.dll至C:\Program Files\Python36\Lib\site-packages\osgeo目录，安装目录与python安装目录]]></description><category></category></item><item><title><![CDATA[vue 运行前端代码]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120991204</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120991204</guid><author>SOPHIA16527</author><pubDate>Wed, 27 Oct 2021 13:57:46 +0800</pubDate><description><![CDATA[命令行启动vue命令如下：
C:\Users\admin&gt;vue ui
????  Starting GUI...
????  Ready on http://localhost:8000
Auto cleaned 1 projects (folder not found).

保持这个命令行界面一直运行，再执行以下步骤。
打开http://localhost:8000/

如果报缺少node_modules错误，可打开这个项目，用命令行运行npm insatll，即可生成。

serve运行一段时间]]></description><category></category></item><item><title><![CDATA[DataGrip连接容器中数据库]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120989853</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120989853</guid><author>SOPHIA16527</author><pubDate>Wed, 27 Oct 2021 11:57:26 +0800</pubDate><description><![CDATA[host填 linux ip
port填端口（docker映射出来的端口）
user填数据库用户名
database填数据库表名（docker-compose中数据库名）

docker-compose.yml中数据库对应部分如下：





]]></description><category></category></item><item><title><![CDATA[pycharm设置作者和时间]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120989718</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120989718</guid><author>SOPHIA16527</author><pubDate>Wed, 27 Oct 2021 11:32:04 +0800</pubDate><description><![CDATA[pycharm设置作者和时间，每次新建代码时，字段在代码开头新增这几行内容。

示例：
# -*- coding: utf-8 -*-
# @Author  : 作者名
# @Time    : ${DATE} ${TIME}


]]></description><category></category></item><item><title><![CDATA[pycharm windows代码同步到linux设置]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120988918</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/120988918</guid><author>SOPHIA16527</author><pubDate>Wed, 27 Oct 2021 11:25:32 +0800</pubDate><description><![CDATA[pycharm windows代码同步到linux设置









点击ok保存设置。修改代码自动同步到linux对应目录。
若同步失败，可手动上传


]]></description><category></category></item><item><title><![CDATA[python2安装gdal Dockerfile]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119545714</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119545714</guid><author>SOPHIA16527</author><pubDate>Mon, 09 Aug 2021 20:01:54 +0800</pubDate><description><![CDATA[python2安装gdal Dockerfile
FROM 基础镜像

RUN \
    yum -y install python27-tkinter tk-devel &amp;&amp; \
    pip install --no-cache-dir -i https://pypi.doubanio.com/simple --trusted-host=pypi.doubanio.com  matplotlib==2.2.5

# 先下载相关依赖到GDAL目录
RUN \
    yum remov]]></description><category></category></item><item><title><![CDATA[Cannot retrieve metalink for repository: epel/x86_64. Please verify its path and try again]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119545644</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119545644</guid><author>SOPHIA16527</author><pubDate>Mon, 09 Aug 2021 19:57:45 +0800</pubDate><description><![CDATA[yum 安装报错
Cannot retrieve metalink for repository: epel/x86_64. Please verify its path and try again

解决办法：
“直接备份删除/etc/yum.repo.d/路径下所有repo文件，然后从另一台正常运行的服务器上，拷贝CentOS-Base.repo内容到/etc/yum.repos.d/目录下，重命名（可忽略此步骤）文件为centos.repo，然后重新执行yum安装、更新命令，正常可用。”

...]]></description><category></category></item><item><title><![CDATA[gdal中文编码、中文字段、中文路径]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119025822</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/119025822</guid><author>SOPHIA16527</author><pubDate>Fri, 23 Jul 2021 10:35:20 +0800</pubDate><description><![CDATA[支持中文路径
gdal.SetConfigOption("GDAL_FILENAME_IS_UTF8", "YES")  

属性表支持中文字段
gdal.SetConfigOption('SHAPE_ENCODING', 'GBK')  

生成中文编码shp
gdal.SetConfigOption('SHAPE_ENCODING', 'GBK')  # 属性表支持中文字段
layer = ds.CreateLayer(layer_name, srs=srs, geom_type=ogr.wkbPoin]]></description><category></category></item><item><title><![CDATA[selenium获取动态网页]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118447118</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118447118</guid><author>SOPHIA16527</author><pubDate>Sun, 04 Jul 2021 00:18:23 +0800</pubDate><description><![CDATA[安装selenium
参考：https://blog.youkuaiyun.com/SOPHIA16527/article/details/118446491?spm=1001.2014.3001.5501
1、安装selenium:pip install selenium
2、查看chrom版本，浏览器输入：chrome://version/
3、下载驱动:
地址：http://npm.taobao.org/mirrors/chromedriver/
下载与浏览器对应的版本，例如：chromedriver_win32]]></description><category></category></item><item><title><![CDATA[selenium.common.exceptions.WebDriverException: Message: ‘chromedriver‘ executable needs to be in PAT]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118446491</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118446491</guid><author>SOPHIA16527</author><pubDate>Sat, 03 Jul 2021 23:22:14 +0800</pubDate><description><![CDATA[问题
安装selenium:
pip install selenium
生成Chrome对象，运行后报错
from selenium.webdriver import Chrome
brower = Chrome()

报错如下：

原因
selenium 未安装驱动
解决办法
1、查看chrome版本：chrome://version/

2、下载对应驱动
下载地址：http://npm.taobao.org/mirrors/chromedriver/

这里下载的是 chromedriver_win32]]></description><category></category></item><item><title><![CDATA[flask学习1]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118338389</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118338389</guid><author>SOPHIA16527</author><pubDate>Tue, 29 Jun 2021 16:35:10 +0800</pubDate><description><![CDATA[flask运行逻辑：

app.run运行一个web服务器
客户端：用户输入网址，浏览器发请求，给服务器
web服务器：把请求传给flask应用实例app，app用werkzeug(flask两个核心之一)来进行路由分发，发现是哪个路由找到对应视图函数，并调用视图函数，视图函数返回：字符串、模板（网页）

demo1.py
# coding:utf-8

# 导入拓展
from flask import Flask
# jinja2模板引擎
from flask import render_template]]></description><category></category></item><item><title><![CDATA[python3 json.dumps 中文乱码问题]]></title><link>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118293424</link><guid>https://blog.youkuaiyun.com/SOPHIA16527/article/details/118293424</guid><author>SOPHIA16527</author><pubDate>Mon, 28 Jun 2021 09:42:45 +0800</pubDate><description><![CDATA[json.dumps 使用的ascii编码。
输出中文需要指定ensure_ascii=False
test_dic = {'a': '测', 'b': 'abc'}

 print(test_dic)
# {'a': '测', 'b': 'abc'}

print(str(test_dic))
# {'a': '测', 'b': 'abc'}
print(str(test_dic).replace('测', '测试'))
# {'a': '测试', 'b': 'abc'}
# print(json.loa]]></description><category></category></item></channel></rss>