2021-11-17 21:41:21 +01:00
|
|
|
|
# Fast Fantoir
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
time ./scripts/gen-fantoir.sh FANTOIR0721
|
|
|
|
|
Generating fantoir CSV
|
|
|
|
|
Finished release [optimized] target(s) in 0.00s
|
|
|
|
|
Running `target/release/fast-fantoir FANTOIR0721`
|
|
|
|
|
Generating fantoir SQLite DB
|
|
|
|
|
DB generated at /home/ninjatrappeur/code-root/git.alternativebit.fr/fast-fantoir/fantoir.sqlite
|
|
|
|
|
|
|
|
|
|
real 0m13,319s
|
|
|
|
|
user 0m9,804s
|
|
|
|
|
sys 0m3,458s
|
|
|
|
|
```
|
|
|
|
|
|
|
|
|
|
DB Schema:
|
|
|
|
|
|
|
|
|
|
```
|
|
|
|
|
sqlite> .tables
|
|
|
|
|
fantoir
|
|
|
|
|
|
|
|
|
|
sqlite> .schema fantoir
|
|
|
|
|
CREATE TABLE IF NOT EXISTS "fantoir"(
|
|
|
|
|
"full_insee" TEXT,
|
|
|
|
|
"rivoli_with_key" TEXT,
|
|
|
|
|
"libelle" TEXT
|
|
|
|
|
);
|
|
|
|
|
```
|
2022-02-11 11:07:17 +01:00
|
|
|
|
|
|
|
|
|
## Data
|
|
|
|
|
|
|
|
|
|
You can download the latest FANTOIR data over there: https://www.data.gouv.fr/fr/datasets/fichier-fantoir-des-voies-et-lieux-dits/
|