Surviving Mars 火星生存 火星求生 20210315 Tito版本 地图坐标 突破科技 对应表 筛选

首先，https://survivingmaps.com/ 这个网站的数据因为版本更新而失效，所以需要新的数据以及自己实现这个网站的功能

地图坐标与突破科技对应表来自https://forum.paradoxplaza.com/forum/threads/surviving-mars-maps-find-your-perfect-landinglocation.1107750/page-2#post-25465232

我做了个备份

MapData Tito GP Mar 15 2021.7z 有Green Planet这个DLC的数据

链接: https://pan.baidu.com/s/1PevLmKNZ3X-cm2x85Myqlw 提取码: q9h7

MapData Tito Not GP Mar 15 2021.7z 没有Green Planet这个DLC的数据

链接: https://pan.baidu.com/s/16CxajdLSiQpx7rzgupw4vw 提取码: ja5f

其作者为ChoGGi (https://github.com/ChoGGi/SurvivingMars_CheatMods)，他的github里有一些mod和工具，例如View Colony Map就是地图和突破科技的预览Mod，其中ChoGGi's Library\Code\CommonFunctions.lua的RetMapBreakthroughs部分为突破科技的生成，如果将来这个数据作者不再更新，就需研究这部分来自己生成新的数据了。

SurvivingMars_CheatMods-16.6.zip

链接: https://pan.baidu.com/s/1fCm9acJiiFP_Ic89uya7tw 提取码: txja

更多关于View Colony Map和RetMapBreakthroughs部分有部分未开启的部分，可以再多生成3个突破科技用以模拟欧米伽望远镜的效果，可以通过修改mod实现

但是之前的数据表格里并没有这部分，无法进行筛选，只能作为筛选后的补充，而且通过这个mod可以知道这个数据表格的前4个突破科技是行星异象，第5个开始是地图扫描获得，并且是按顺序获得的，也就是如果地图上能扫描9个突破科技，那么会是第5至13个

其中，还包含了一个Map Images Pack，其中显示了对应的地图名字与地形

有了这些Mod和信息，还不能筛选想要的地图，所以需要一些别的工具和一点点SQL知识

我们需要的工具是DB Browser for SQLite，可以从 https://sqlitebrowser.org/dl/ 下载。这个是一个可以创建、编辑基于文件的关系数据库的工具，无需安装，解压即用。

首先打开DB Browser for SQLite，新建数据库。

关闭这个窗口

导入MapData Tito Breakthroughs GP.csv

首先，这个例子

SELECT *

FROM "MapData Tito Breakthroughs GP"

WHERE MapName = "BlankBig_01"

AND ( Breakthrough1 = "The Positronic Brain" OR Breakthrough2 = "The Positronic Brain" OR Breakthrough3 = "The Positronic Brain" OR Breakthrough4 = "The Positronic Brain" OR Breakthrough5 = "The Positronic Brain" OR Breakthrough6 = "The Positronic Brain" OR Breakthrough7 = "The Positronic Brain" OR Breakthrough8 = "The Positronic Brain" OR Breakthrough9 = "The Positronic Brain" OR Breakthrough10 = "The Positronic Brain" OR Breakthrough11 = "The Positronic Brain" OR Breakthrough12 = "The Positronic Brain" OR Breakthrough13 = "The Positronic Brain" OR Breakthrough14 = "The Positronic Brain" OR Breakthrough15 = "The Positronic Brain" OR Breakthrough16 = "The Positronic Brain" OR Breakthrough17 = "The Positronic Brain" )

AND ( Breakthrough1 = "Service Bots" OR Breakthrough2 = "Service Bots" OR Breakthrough3 = "Service Bots" OR Breakthrough4 = "Service Bots" OR Breakthrough5 = "Service Bots" OR Breakthrough6 = "Service Bots" OR Breakthrough7 = "Service Bots" OR Breakthrough8 = "Service Bots" OR Breakthrough9 = "Service Bots" OR Breakthrough10 = "Service Bots" OR Breakthrough11 = "Service Bots" OR Breakthrough12 = "Service Bots" OR Breakthrough13 = "Service Bots" OR Breakthrough14 = "Service Bots" OR Breakthrough15 = "Service Bots" OR Breakthrough16 = "Service Bots" OR Breakthrough17 = "Service Bots" )

AND ( Breakthrough1 = "Superconducting Computing" OR Breakthrough2 = "Superconducting Computing" OR Breakthrough3 = "Superconducting Computing" OR Breakthrough4 = "Superconducting Computing" OR Breakthrough5 = "Superconducting Computing" OR Breakthrough6 = "Superconducting Computing" OR Breakthrough7 = "Superconducting Computing" OR Breakthrough8 = "Superconducting Computing" OR Breakthrough9 = "Superconducting Computing" OR Breakthrough10 = "Superconducting Computing" OR Breakthrough11 = "Superconducting Computing" OR Breakthrough12 = "Superconducting Computing" OR Breakthrough13 = "Superconducting Computing" OR Breakthrough14 = "Superconducting Computing" OR Breakthrough15 = "Superconducting Computing" OR Breakthrough16 = "Superconducting Computing" OR Breakthrough17 = "Superconducting Computing" )

AND ( Breakthrough1 = "Nano Refinement" OR Breakthrough2 = "Nano Refinement" OR Breakthrough3 = "Nano Refinement" OR Breakthrough4 = "Nano Refinement" OR Breakthrough5 = "Nano Refinement" OR Breakthrough6 = "Nano Refinement" OR Breakthrough7 = "Nano Refinement" OR Breakthrough8 = "Nano Refinement" OR Breakthrough9 = "Nano Refinement" OR Breakthrough10 = "Nano Refinement" OR Breakthrough11 = "Nano Refinement" OR Breakthrough12 = "Nano Refinement" OR Breakthrough13 = "Nano Refinement" OR Breakthrough14 = "Nano Refinement" OR Breakthrough15 = "Nano Refinement" OR Breakthrough16 = "Nano Refinement" OR Breakthrough17 = "Nano Refinement" )

AND ( Breakthrough1 = "Eternal Fusion" OR Breakthrough2 = "Eternal Fusion" OR Breakthrough3 = "Eternal Fusion" OR Breakthrough4 = "Eternal Fusion" OR Breakthrough5 = "Eternal Fusion" OR Breakthrough6 = "Eternal Fusion" OR Breakthrough7 = "Eternal Fusion" OR Breakthrough8 = "Eternal Fusion" OR Breakthrough9 = "Eternal Fusion" OR Breakthrough10 = "Eternal Fusion" OR Breakthrough11 = "Eternal Fusion" OR Breakthrough12 = "Eternal Fusion" OR Breakthrough13 = "Eternal Fusion" OR Breakthrough14 = "Eternal Fusion" OR Breakthrough15 = "Eternal Fusion" OR Breakthrough16 = "Eternal Fusion" OR Breakthrough17 = "Eternal Fusion" )

希望地图是BlankBig_01，并且有“正子脑 The Positronic Brain”、“服务型机器人 Service Bots”、“超导计算 Superconducting Computing”、“纳米提纯 Nano Refinement”、“无限核融合 Eternal Fusion”

我们就得到了3个筛选结果

筛选地图是MapName = "BlankBig_01"，如果不需要筛选地图，那么就删除这些以及之后紧连的AND，如果需要筛选多种地图，那么就用括号括起来并在括号内用OR相连 ( MapName = "BlankBig_01" OR MapName = "BlankBig_02" )

( Breakthrough1 = "" OR Breakthrough2 = "" OR Breakthrough3 = "" OR Breakthrough4 = "" OR Breakthrough5 = "" OR Breakthrough6 = "" OR Breakthrough7 = "" OR Breakthrough8 = "" OR Breakthrough9 = "" OR Breakthrough10 = "" OR Breakthrough11 = "" OR Breakthrough12 = "" OR Breakthrough13 = "" OR Breakthrough14 = "" OR Breakthrough15 = "" OR Breakthrough16 = "" OR Breakthrough17 = "" )

这部分就是从表内筛选特定突破科技，因为某项突破科技可能出现于17列中的任何一列

我们已经知道行星异象位于1-4列，如果我们不想某个科技太晚出现，那么我们可以删除3、4列，我们还知道第5列开始就是地图扫描的部分，依次出现，如果我们希望某些科技尽早出现，那么就保留前第5列开始的6～9列，即5至10列～5至13列。

( Breakthrough1 = "" OR Breakthrough2 = "" OR Breakthrough5 = "" OR Breakthrough6 = "" OR Breakthrough7 = "" OR Breakthrough8 = "" OR Breakthrough9 = "" OR Breakthrough10 = "" OR Breakthrough11 = "" OR Breakthrough12 = "" OR Breakthrough13 = "" )

如果希望早早（第一个行星异象、前5个地图扫描）就有“挖掘站人工智能 Extractor AI”和“纳米提纯 Nano Refinement”以跳过建设开矿穹顶的过程并且不再依赖奇迹，然后希望在中期（前两个行星异象、前10个地图扫描）拥有“正子脑 The Positronic Brain”，也如挖矿一样一劳永逸地建立工厂穹顶，然后还希望之后（前三个行星异象、前10个地图扫描）拥有“无限核融合 Eternal Fusion”以支撑更大规模的扩张，就可以写下如下的SQL

SELECT *

FROM "MapData Tito Breakthroughs GP"

WHERE MapName = "BlankBig_01"

AND ( Breakthrough1 = "Extractor AI" OR Breakthrough5 = "Extractor AI" OR Breakthrough6 = "Extractor AI" OR Breakthrough7 = "Extractor AI" OR Breakthrough8 = "Extractor AI" OR Breakthrough9 = "Extractor AI" )

AND ( Breakthrough1 = "Nano Refinement" OR Breakthrough5 = "Nano Refinement" OR Breakthrough6 = "Nano Refinement" OR Breakthrough7 = "Nano Refinement" OR Breakthrough8 = "Nano Refinement" OR Breakthrough9 = "Nano Refinement" )

AND ( Breakthrough1 = "The Positronic Brain" OR Breakthrough2 = "The Positronic Brain" OR Breakthrough5 = "The Positronic Brain" OR Breakthrough6 = "The Positronic Brain" OR Breakthrough7 = "The Positronic Brain" OR Breakthrough8 = "The Positronic Brain" OR Breakthrough9 = "The Positronic Brain" OR Breakthrough10 = "The Positronic Brain" OR Breakthrough11 = "The Positronic Brain" OR Breakthrough12 = "The Positronic Brain" OR Breakthrough13 = "The Positronic Brain" OR Breakthrough14 = "The Positronic Brain" )

AND ( Breakthrough1 = "Eternal Fusion" OR Breakthrough2 = "Eternal Fusion" OR Breakthrough3 = "Eternal Fusion" OR Breakthrough5 = "Eternal Fusion" OR Breakthrough6 = "Eternal Fusion" OR Breakthrough7 = "Eternal Fusion" OR Breakthrough8 = "Eternal Fusion" OR Breakthrough9 = "Eternal Fusion" OR Breakthrough10 = "Eternal Fusion" OR Breakthrough11 = "Eternal Fusion" OR Breakthrough12 = "Eternal Fusion" OR Breakthrough13 = "Eternal Fusion" OR Breakthrough14 = "Eternal Fusion" )

我们可以得到结果

然后我们检查这俩结果的其他突破科技

最后选择自己最喜欢的地图！