-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.html
1 lines (1 loc) · 24.5 KB
/
index.html
1
<!-- build time:Fri Mar 01 2024 13:21:07 GMT+0800 (China Standard Time) --><!DOCTYPE html><html lang="zh-CN"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width,initial-scale=1,maximum-scale=2"><meta name="theme-color" content="#FFF"><link rel="apple-touch-icon" sizes="180x180" href="/images/apple-touch-icon.png"><link rel="icon" type="image/ico" sizes="32x32" href="/images/favicon.ico"><meta http-equiv="Cache-Control" content="no-transform"><meta http-equiv="Cache-Control" content="no-siteapp"><link rel="alternate" type="application/rss+xml" href="https://coloraven.github.io/rss.xml"><link rel="alternate" type="application/atom+xml" href="https://coloraven.github.io/atom.xml"><link rel="alternate" type="application/json" href="https://coloraven.github.io/feed.json"><link rel="stylesheet" href="//fonts.googleapis.com/css?family=Mulish:300,300italic,400,400italic,700,700italic%7CFredericka%20the%20Great:300,300italic,400,400italic,700,700italic%7CNoto%20Serif%20JP:300,300italic,400,400italic,700,700italic%7CNoto%20Serif%20SC:300,300italic,400,400italic,700,700italic%7CMicrosoft%20YaHei:300,300italic,400,400italic,700,700italic&display=swap&subset=latin,latin-ext"><link rel="stylesheet" href="/css/app.css?v=0.2.5"><link rel="canonical" href="https://coloraven.github.io/"><title>Black Elk = = 潛龍勿用</title><meta name="generator" content="Hexo 5.4.0"></head><body itemscope itemtype="http://schema.org/WebPage"><div id="loading"><div class="cat"><div class="body"></div><div class="head"><div class="face"></div></div><div class="foot"><div class="tummy-end"></div><div class="bottom"></div><div class="legs left"></div><div class="legs right"></div></div><div class="paw"><div class="hands left"></div><div class="hands right"></div></div></div></div><div id="container"><header id="header" itemscope itemtype="http://schema.org/WPHeader"><div class="inner"><div id="brand"><div class="pjax"><a href="/" class="logo" rel="start"><p class="artboard">Black Elk</p><h1 itemprop="name headline" class="title"></h1></a><p class="meta" itemprop="description">= 潛龍勿用 =</p></div></div><nav id="nav"><div class="inner"><div class="toggle"><div class="lines" aria-label="切换导航栏"><span class="line"></span> <span class="line"></span> <span class="line"></span></div></div><ul class="menu"><li class="item title"><a href="/" rel="start">Black Elk</a></li></ul><ul class="right"><li class="item theme"><i class="ic i-sun"></i></li><li class="item search"><i class="ic i-search"></i></li></ul></div></nav></div><div id="imgs" class="pjax"><ul><li class="item" data-background-image="https://dd-static.jd.com/ddimg/jfs/t1/201870/14/8224/2150675/614f39a0E8b4d254c/449af85e750378ce.png"></li><li class="item" data-background-image="https://images.pexels.com/photos/977736/pexels-photo-977736.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940"></li><li class="item" data-background-image="https://dd-static.jd.com/ddimg/jfs/t1/205776/26/8123/5344729/614f3578E874d2fdf/0638c498546a1505.png"></li><li class="item" data-background-image="https://dd-static.jd.com/ddimg/jfs/t1/203529/24/8165/2658845/614f2ed9E174a4a7d/876213b85c1371c2.png"></li><li class="item" data-background-image="https://dd-static.jd.com/ddimg/jfs/t1/207268/4/2302/104737/614f3471E70137fc5/b0729314c0a7768d.png"></li><li class="item" data-background-image="https://dd-static.jd.com/ddimg/jfs/t1/139094/27/21037/5751113/614f3ccaEc22592d7/abe8043a8c6827cd.jpg"></li></ul></div></header><div id="waves"><svg class="waves" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" viewBox="0 24 150 28" preserveAspectRatio="none" shape-rendering="auto"><defs><path id="gentle-wave" d="M-160 44c30 0 58-18 88-18s 58 18 88 18 58-18 88-18 58 18 88 18 v44h-352z"/></defs><g class="parallax"><use xlink:href="#gentle-wave" x="48" y="0"/><use xlink:href="#gentle-wave" x="48" y="3"/><use xlink:href="#gentle-wave" x="48" y="5"/><use xlink:href="#gentle-wave" x="48" y="7"/></g></svg></div><main><div class="inner"><div id="main" class="pjax"><div class="index wrap"><h2 class="divider">文章列表</h2><div class="segments posts"><article class="item"><div class="cover"><a href="/2024/2/duckdb%E5%B9%B6%E5%8F%91%E5%86%99%E5%85%A5%E5%A4%9A%E8%A1%8C%E5%86%99%E5%85%A5/" itemprop="url" title="duckdb并发写入多行写入"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/199534/37/9941/127577/614f39d9E328e2709/b93d307754fc1dfc.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-02-24 00:14:01"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-02-24T00:14:01+08:00">2024-02-24</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>1.7k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>2 分钟</span></span></div><h3><a href="/2024/2/duckdb%E5%B9%B6%E5%8F%91%E5%86%99%E5%85%A5%E5%A4%9A%E8%A1%8C%E5%86%99%E5%85%A5/" itemprop="url" title="duckdb并发写入多行写入">duckdb并发写入多行写入</a></h3><div class="excerpt">package mainimport ( "database/sql" // ... _ "github.com/marcboeker/go-duckdb")func main() &#123; // Connect to DuckDB db, err := sql.Open("duckdb", "test.duckdb") if err != nil &#123; log.Fatal(err) &#125; defer db.Close() db.Exec("DROP...</div><div class="meta footer"><span><a href="/categories/%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="数据库"><i class="ic i-flag"></i>数据库</a></span></div><a href="/2024/2/duckdb%E5%B9%B6%E5%8F%91%E5%86%99%E5%85%A5%E5%A4%9A%E8%A1%8C%E5%86%99%E5%85%A5/" itemprop="url" title="duckdb并发写入多行写入" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/2/postgresql_docker_builder%E5%AE%B9%E5%99%A8%E7%9A%84%E4%BD%BF%E7%94%A8/" itemprop="url" title="postgresql_docker_builder容器的使用"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/199670/35/9910/975380/614f33e5E82620c19/edea9a361f11d866.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-02-16 01:33:08"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-02-16T01:33:08+08:00">2024-02-16</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>1.2k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>1 分钟</span></span></div><h3><a href="/2024/2/postgresql_docker_builder%E5%AE%B9%E5%99%A8%E7%9A%84%E4%BD%BF%E7%94%A8/" itemprop="url" title="postgresql_docker_builder容器的使用">postgresql_docker_builder容器的使用</a></h3><div class="excerpt"># 设置容器 # 启动容器 其中 1921 是 PG 的监听端口 docker run --platform linux/amd64 -dit -P --cap-add=SYS_PTRACE --cap-add SYS_ADMIN --privileged=true --name pg14 -p 1921:1921 -p 3000:3000 -p 8088:8080 -p 8112:80 -p 3301:3306 --shm-size=1g...</div><a href="/2024/2/postgresql_docker_builder%E5%AE%B9%E5%99%A8%E7%9A%84%E4%BD%BF%E7%94%A8/" itemprop="url" title="postgresql_docker_builder容器的使用" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/2/Echarts%E6%A0%91%E5%BD%A2%E5%85%B3%E7%B3%BB%E5%B1%95%E7%A4%BA/" itemprop="url" title="树形关系展示"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/198136/20/9971/641736/614f2bd6E2a11fe70/eb8d244ba7276e57.png"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-02-10 03:31:11"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-02-10T03:31:11+08:00">2024-02-10</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>2k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>2 分钟</span></span></div><h3><a href="/2024/2/Echarts%E6%A0%91%E5%BD%A2%E5%85%B3%E7%B3%BB%E5%B1%95%E7%A4%BA/" itemprop="url" title="树形关系展示">树形关系展示</a></h3><div class="excerpt"># 基本 Echarts 树关系展示 # 双向树 参考网友代码（不支持展开和收起） 修改后支持展开和收起的版本 option = &#123; tooltip: &#123; trigger: 'item', triggerOn: 'mousemove', formatter:'&#123;b0&#125;' &#125;, series:[ &#123; type: 'tree', data: [ &#123; "name":...</div><a href="/2024/2/Echarts%E6%A0%91%E5%BD%A2%E5%85%B3%E7%B3%BB%E5%B1%95%E7%A4%BA/" itemprop="url" title="树形关系展示" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/1/fyne%E5%AD%A6%E4%B9%A0%E7%AC%94%E8%AE%B0/" itemprop="url" title="fyne学习笔记"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/200293/9/9922/3859371/614f26caEd7377b49/ed45c4c8b8e839ba.png"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-01-19 15:50:28"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-01-19T15:50:28+08:00">2024-01-19</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>10k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>9 分钟</span></span></div><h3><a href="/2024/1/fyne%E5%AD%A6%E4%B9%A0%E7%AC%94%E8%AE%B0/" itemprop="url" title="fyne学习笔记">fyne学习笔记</a></h3><div class="excerpt"># 环境搭建 Install MSYS2 from msys2.org Once installed do not use the MSYS terminal that opens Open “MSYS2 MinGW 64-bit” from the start menu Proxy Setting(CN) export HTTP_PROXY="http://127.0.0.1:8889"export HTTPS_PROXY=$HTTP_PROXYexport http_proxy=$HTTP_PROXYexport...</div><div class="meta footer"><span><a href="/categories/Go/" itemprop="url" title="Go"><i class="ic i-flag"></i>Go</a></span></div><a href="/2024/1/fyne%E5%AD%A6%E4%B9%A0%E7%AC%94%E8%AE%B0/" itemprop="url" title="fyne学习笔记" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/1/Go%E8%AF%AD%E8%A8%80%E6%8F%92%E5%85%A5Sqlite3%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%80%E5%BF%AB%E7%9A%84%E6%96%B9%E6%B3%95/" itemprop="url" title="Go语言插入Sqlite3数据库最快的方法"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/110383/25/17197/293104/614f2192Efb2a391c/48ff03b879d159e6.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-01-09 13:27:46"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-01-09T13:27:46+08:00">2024-01-09</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>2.2k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>2 分钟</span></span></div><h3><a href="/2024/1/Go%E8%AF%AD%E8%A8%80%E6%8F%92%E5%85%A5Sqlite3%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%80%E5%BF%AB%E7%9A%84%E6%96%B9%E6%B3%95/" itemprop="url" title="Go语言插入Sqlite3数据库最快的方法">Go语言插入Sqlite3数据库最快的方法</a></h3><div class="excerpt"># 概述 Go 语言使用各库插入最快的方法和查询最快的方法见：https://github.com/cvilsmeier/go-sqlite-bench 按照此测评项目，最快的插入方法是使用 &quot;github.com/cvilsmeier/sqinn-go/sqinn&quot;，通过调用其提供的辅助程序 sqinn 来进行插入。 # 完整代码 package mainimport...</div><a href="/2024/1/Go%E8%AF%AD%E8%A8%80%E6%8F%92%E5%85%A5Sqlite3%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9C%80%E5%BF%AB%E7%9A%84%E6%96%B9%E6%B3%95/" itemprop="url" title="Go语言插入Sqlite3数据库最快的方法" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/1/%E6%90%9C%E7%8B%97%E7%BB%86%E8%83%9E%E8%AF%8D%E5%BA%93%E6%89%B9%E9%87%8F%E5%AE%89%E8%A3%85/" itemprop="url" title="搜狗细胞词库批量安装"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/204471/7/8178/497525/614f30bdE76a1e565/996401b6c0784056.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-01-05 06:52:32"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-01-05T06:52:32+08:00">2024-01-05</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>244</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>1 分钟</span></span></div><h3><a href="/2024/1/%E6%90%9C%E7%8B%97%E7%BB%86%E8%83%9E%E8%AF%8D%E5%BA%93%E6%89%B9%E9%87%8F%E5%AE%89%E8%A3%85/" itemprop="url" title="搜狗细胞词库批量安装">搜狗细胞词库批量安装</a></h3><div class="excerpt">批量下载的搜狗细胞词库，要批量导入到输入法中。 默认是双击细胞词库即可导入，但是量大的时候应该怎么办呢，经过使用火绒剑监测，此过程是调用 SGTool.exe ，并附加参数进行导入的，所以可以构建批处理自动导入： &quot;...\SGTool.exe&quot; -line 0 -border --appid=scdreg --list &quot;...\***.scel&quot; 目前缺点很明显，量大的时候使用批处理会导致内存不够用... 程序卡死，不知道有没有其他解决办法，欢迎在此提交 ISSUE</div><a href="/2024/1/%E6%90%9C%E7%8B%97%E7%BB%86%E8%83%9E%E8%AF%8D%E5%BA%93%E6%89%B9%E9%87%8F%E5%AE%89%E8%A3%85/" itemprop="url" title="搜狗细胞词库批量安装" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2024/1/GPKG%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="GPKG文件导入数据库"><img data-src="https://images.pexels.com/photos/2127969/pexels-photo-2127969.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2024-01-02 04:31:41"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2024-01-02T04:31:41+08:00">2024-01-02</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>1.2k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>1 分钟</span></span></div><h3><a href="/2024/1/GPKG%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="GPKG文件导入数据库">GPKG文件导入数据库</a></h3><div class="excerpt"># 概述 以全球城市数据的 GeoPackage（GeoPackage - SQLite-based format for geospatial data）文件为例，下载链接 https://geodata.ucdavis.edu/gadm/gadm4.1/gadm_410-gpkg.zip # 导入 PostGIS import geopandas as gpdfrom sqlalchemy import create_enginegdf = gpd.read_file("gadm_410.gpkg")# 创建数据库引擎db_string =...</div><div class="meta footer"><span><a href="/categories/CodeOfSpatial/" itemprop="url" title="CodeOfSpatial"><i class="ic i-flag"></i>CodeOfSpatial</a></span></div><a href="/2024/1/GPKG%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="GPKG文件导入数据库" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2023/12/GEOJSON%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E5%90%84%E5%A4%A7%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%96%B9%E5%BC%8F/" itemprop="url" title="GEOJSON文件导入各类数据库的方式"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/96327/25/18404/237329/614f26efE0af58513/c2f055c97bc2cb71.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2023-12-31 13:59:07"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2023-12-31T13:59:07+08:00">2023-12-31</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>2.5k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>2 分钟</span></span></div><h3><a href="/2023/12/GEOJSON%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E5%90%84%E5%A4%A7%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%96%B9%E5%BC%8F/" itemprop="url" title="GEOJSON文件导入各类数据库的方式">GEOJSON文件导入各类数据库的方式</a></h3><div class="excerpt"># duckdb INSTALL spatial;LOAD spatial;CREATE TABLE world AS SELECT * FROM ST_Read('C:\Users\......\Desktop\testspatialite\world.geojson');SELECT name_zh FROM world WHERE ST_Contains(geom,ST_Point(92.5976562500021, 42.58220940617247));┌────────────────┐│ name_zh ││ varchar...</div><div class="meta footer"><span><a href="/categories/CodeOfSpatial/" itemprop="url" title="CodeOfSpatial"><i class="ic i-flag"></i>CodeOfSpatial</a></span></div><a href="/2023/12/GEOJSON%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E5%90%84%E5%A4%A7%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E6%96%B9%E5%BC%8F/" itemprop="url" title="GEOJSON文件导入各类数据库的方式" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2023/12/Go%E6%93%8D%E4%BD%9Cduckdb/" itemprop="url" title="Go操作DuckDB及使用Spatial"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/120282/35/20196/347931/614f38baEb994cdf6/fb600ebd3a84efd8.png"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2023-12-26 00:10:40"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2023-12-26T00:10:40+08:00">2023-12-26</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>2.1k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>2 分钟</span></span></div><h3><a href="/2023/12/Go%E6%93%8D%E4%BD%9Cduckdb/" itemprop="url" title="Go操作DuckDB及使用Spatial">Go操作DuckDB及使用Spatial</a></h3><div class="excerpt"># duckdb cli 测试 spatial 的可行性和便利性 INSTALL spatial;LOAD spatial;CREATE TABLE world AS SELECT * FROM ST_Read('C:\Users\......\world.geojson');SELECT * FROM world LIMIT 3;┌─────────────────┬───────────┬───────────┬───┬──────────────────────┬──────────────────────┐│ featurecla │ scalerank │...</div><div class="meta footer"><span><a href="/categories/CodeOfSpatial/" itemprop="url" title="CodeOfSpatial"><i class="ic i-flag"></i>CodeOfSpatial</a></span></div><a href="/2023/12/Go%E6%93%8D%E4%BD%9Cduckdb/" itemprop="url" title="Go操作DuckDB及使用Spatial" class="btn">more...</a></div></article><article class="item"><div class="cover"><a href="/2023/12/geopandas%E8%AF%BB%E5%8F%96geojson%E6%96%87%E4%BB%B6%E5%B9%B6%E5%86%99%E5%85%A5Spatialite%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="geopandas读取geojson文件并写入Spatialite数据库"><img data-src="https://dd-static.jd.com/ddimg/jfs/t1/207526/14/2239/550085/614f3307Efbc7325d/596c22878debcc9d.jpg"></a></div><div class="info"><div class="meta"><span class="item" title="创建时间：2023-12-25 16:36:00"><span class="icon"><i class="ic i-calendar"></i> </span><time itemprop="dateCreated datePublished" datetime="2023-12-25T16:36:00+08:00">2023-12-25</time> </span><span class="item" title="本文字数"><span class="icon"><i class="ic i-pen"></i> </span><span>3.1k</span> <span class="text">字</span> </span><span class="item" title="阅读时长"><span class="icon"><i class="ic i-clock"></i> </span><span>3 分钟</span></span></div><h3><a href="/2023/12/geopandas%E8%AF%BB%E5%8F%96geojson%E6%96%87%E4%BB%B6%E5%B9%B6%E5%86%99%E5%85%A5Spatialite%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="geopandas读取geojson文件并写入Spatialite数据库">geopandas读取geojson文件并写入Spatialite数据库</a></h3><div class="excerpt"># 写入数据库 关于 geojson 文件的生成见：https://coloraven.github.io/2023/12/GEOJSON 文件的生成 部分参考：https://www.giacomodebidda.com/posts/export-a-geodataframe-to-spatialite/ import sqlite3import pandas as pdimport geopandas as gpdimport uuid# %%pd.options.display.max_rows = 10gdf =...</div><div class="meta footer"><span><a href="/categories/CodeOfSpatial/" itemprop="url" title="CodeOfSpatial"><i class="ic i-flag"></i>CodeOfSpatial</a></span></div><a href="/2023/12/geopandas%E8%AF%BB%E5%8F%96geojson%E6%96%87%E4%BB%B6%E5%B9%B6%E5%86%99%E5%85%A5Spatialite%E6%95%B0%E6%8D%AE%E5%BA%93/" itemprop="url" title="geopandas读取geojson文件并写入Spatialite数据库" class="btn">more...</a></div></article></div></div><nav class="pagination"><div class="inner"><span class="page-number current">1</span><a class="page-number" href="/page/2/">2</a><span class="space">…</span><a class="page-number" href="/page/23/">23</a><a class="extend next" rel="next" href="/page/2/"><i class="ic i-angle-right" aria-label="下一页"></i></a></div></nav></div><div id="sidebar"><div class="inner"><div class="panels"><div class="inner"><div class="contents panel pjax" data-title="文章目录"></div><div class="related panel pjax" data-title="系列文章"></div><div class="overview panel" data-title="站点概览"><div class="author" itemprop="author" itemscope itemtype="http://schema.org/Person"><img class="image" itemprop="image" alt="黑麋鹿" data-src="/images/avatar.jpg"><p class="name" itemprop="name">黑麋鹿</p><div class="description" itemprop="description">折腾之路</div></div><nav class="state"><div class="item posts"><a href="/archives/"><span class="count">227</span> <span class="name">文章</span></a></div><div class="item categories"><a href="/categories/"><span class="count">47</span> <span class="name">分类</span></a></div><div class="item tags"><a href="/tags/"><span class="count">142</span> <span class="name">标签</span></a></div></nav><div class="social"></div><ul class="menu"><li class="item"><a href="/" rel="section"><i class="ic i-home"></i>首页</a></li><li class="item"><a href="/archives/" rel="section"><i class="ic i-list-alt"></i>归档</a></li><li class="item"><a href="/categories/" rel="section"><i class="ic i-th"></i>分类</a></li><li class="item"><a href="/tags/" rel="section"><i class="ic i-tags"></i>标签</a></li></ul></div></div></div><ul id="quick"><li class="prev pjax"></li><li class="up"><i class="ic i-arrow-up"></i></li><li class="down"><i class="ic i-arrow-down"></i></li><li class="next pjax"><a href="/page/2/" rel="next" title="下一篇"><i class="ic i-chevron-right"></i></a></li><li class="percent"></li></ul></div></div><div class="dimmer"></div></div></main><footer id="footer"><div class="inner"><div class="widgets"></div><div class="status"><div class="count"><span class="post-meta-item-icon"><i class="ic i-chart-area"></i> </span><span title="站点总字数">918k 字</span> <span class="post-meta-divider">|</span> <span class="post-meta-item-icon"><i class="ic i-coffee"></i> </span><span title="站点阅读时长">13:55</span></div><div class="powered-by">基于 <a href="https://hexo.io/" rel="noopener" target="_blank">Hexo</a> & Theme.<a href="https://github.com/amehime/hexo-theme-shoka" rel="noopener" target="_blank">Shoka</a></div></div></div></footer></div><script data-config type="text/javascript">var LOCAL={path:"",favicon:{show:"BlackELK",hide:"看看再走吧"},search:{placeholder:"文章搜索",empty:"关于 「 ${query} 」，什么也没搜到",stats:"${time} ms 内找到 ${hits} 条结果"},valine:!0,fancybox:!0,copyright:'复制成功，转载请遵守 <i class="ic i-creative-commons"></i>BY-NC-SA 协议。',ignores:[function(e){return e.includes("#")},function(e){return new RegExp(LOCAL.path+"$").test(e)}]}</script><script src="https://cdn.polyfill.io/v2/polyfill.js"></script><script src="//cdn.jsdelivr.net/combine/npm/[email protected]/pace.min.js,npm/[email protected]/pjax.min.js,npm/[email protected]/dist/fetch.umd.min.js,npm/[email protected]/lib/anime.min.js,npm/algoliasearch@4/dist/algoliasearch-lite.umd.js,npm/instantsearch.js@4/dist/instantsearch.production.min.js,npm/lozad@1/dist/lozad.min.js,npm/quicklink@2/dist/quicklink.umd.js"></script><script src="/js/app.js?v=0.2.5"></script></body></html><!-- rebuild by hrmmi -->