113 lines
2.0 KiB
Markdown
113 lines
2.0 KiB
Markdown
# CM93 Importer 冻结基线 v1
|
||
|
||
日期：2026-09-02
|
||
仓库：CM95
|
||
基线 commit：`9d56592cadf7e047fb059e5a8746188595a08b43`
|
||
基线 tag：`cm93-mysql-importer-baseline-v1`
|
||
|
||
## 结论
|
||
|
||
CM93JAPAN Dataset ID=1 的 CM93 → MySQL importer 已完成：
|
||
|
||
- Geometry normalization 全量验收；
|
||
- 非 Geometry 数据完整性全量验收；
|
||
- 原始 CM93 source file SHA-256 对账。
|
||
|
||
结果：
|
||
|
||
```text
|
||
Geometry Audit: OVERALL: PASS
|
||
Non-Geometry Audit: OVERALL: PASS
|
||
```
|
||
|
||
## 数据基线
|
||
|
||
| 项目 | 数量 / 结果 |
|
||
|---|---:|
|
||
| Cells | 784 |
|
||
| Features | 322465 |
|
||
| Attributes | 405153 |
|
||
| Soundings | 275700 |
|
||
| Coverages | 1156 |
|
||
| Area | 81080 |
|
||
| Area valid | 81080 |
|
||
| Coverage valid | 1156 |
|
||
| Feature repaired | 55 |
|
||
| Coverage repaired | 3 |
|
||
| Feature geometry issues | 0 |
|
||
| Coverage geometry issues | 0 |
|
||
| raw_geotype=16 | 4406 |
|
||
| raw_geotype=16 issues | 0 |
|
||
| Area bbox mismatch | 0 |
|
||
| Source files checked | 784 |
|
||
| Source files missing | 0 |
|
||
| Source size mismatch | 0 |
|
||
| Source SHA-256 mismatch | 0 |
|
||
|
||
## 冻结 Geometry 规则
|
||
|
||
Valid Area / Coverage：
|
||
|
||
```text
|
||
PASS-THROUGH
|
||
```
|
||
|
||
Invalid Area / Coverage：
|
||
|
||
```text
|
||
boundary noding
|
||
→ polygonize_full
|
||
→ odd-even face selection
|
||
→ union selected faces
|
||
→ GEOS normalize
|
||
→ valid Polygon / MultiPolygon
|
||
```
|
||
|
||
禁止生产写回策略：
|
||
|
||
```text
|
||
make_valid()
|
||
ST_MakeValid()
|
||
buffer(0)
|
||
```
|
||
|
||
`raw_geotype=16` 是正常 parent/no-geometry，不属于 geometry issue。
|
||
|
||
normalized Area 的 bbox 必须来自最终 geometry.bounds。
|
||
|
||
## Raw source
|
||
|
||
必须保留：
|
||
|
||
```text
|
||
raw_feature_blob
|
||
raw_attribute_blob
|
||
chart_raw_record
|
||
source_record_index
|
||
```
|
||
|
||
## 长期回归入口
|
||
|
||
```text
|
||
tools/cm93_mysql_final_geometry_audit.py
|
||
tools/cm93_mysql_non_geometry_final_audit.py
|
||
```
|
||
|
||
## 核心生产文件
|
||
|
||
```text
|
||
src/cm93db/geometry.py
|
||
src/cm93db/importer.py
|
||
sql/001_schema_mysql57.sql
|
||
```
|
||
|
||
本次文档收尾不修改上述生产逻辑。
|
||
|
||
## PBF
|
||
|
||
```text
|
||
OUT OF SCOPE / FROZEN
|
||
```
|
||
|
||
PBF 必须作为独立后续阶段明确启动。
|