33 lines
681 B
Markdown
33 lines
681 B
Markdown
# 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
|
||
);
|
||
```
|
||
|
||
## Data
|
||
|
||
You can download the latest FANTOIR data over there: https://www.data.gouv.fr/fr/datasets/fichier-fantoir-des-voies-et-lieux-dits/
|