datasette-workshop/schema.sql at main · meetup-python-grenoble/datasette-workshop · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
CREATE TABLE IF NOT EXISTS [dvf] (
    [id_mutation] TEXT,
    [date_mutation] DATE,
    [numero_disposition] TEXT,
    [nature_mutation] TEXT,
    [valeur_fonciere] INTEGER,
    [adresse_numero] INTEGER,
    [adresse_suffixe] TEXT,
    [adresse_nom_voie] TEXT,
    [adresse_code_voie] TEXT,
    [code_postal] TEXT,
    [code_commune] TEXT,
    [nom_commune] TEXT,
    [code_departement] TEXT,
    [ancien_code_commune] TEXT,
    [ancien_nom_commune] TEXT,
    [id_parcelle] TEXT,
    [ancien_id_parcelle] TEXT,
    [numero_volume] INTEGER,
    [lot1_numero] INTEGER,
    [lot1_surface_carrez] REAL,
    [lot2_numero] INTEGER,
    [lot2_surface_carrez] REAL,
    [lot3_numero] INTEGER,
    [lot3_surface_carrez] REAL,
    [lot4_numero] INTEGER,
    [lot4_surface_carrez] REAL,
    [lot5_numero] INTEGER,
    [lot5_surface_carrez] REAL,
    [nombre_lots] INTEGER,
    [code_type_local] TEXT,
    [type_local] TEXT,
    [surface_reelle_bati] INTEGER,
    [nombre_pieces_principales] INTEGER,
    [code_nature_culture] TEXT,
    [nature_culture] TEXT,
    [code_nature_culture_speciale] TEXT,
    [nature_culture_speciale] TEXT,
    [surface_terrain] INTEGER,
    [longitude] REAL,
    [latitude] REAL
);

CREATE TABLE IF NOT EXISTS [communes] (
    [code] TEXT,
    [nom] TEXT,
    [geojson] TEXT
);