README 1.56 KB
Newer Older
vincent.michel@logilab.fr's avatar
vincent.michel@logilab.fr committed
1
2
3
Summary
-------
Cube for data.gouv.fr accidents (http://www.data.gouv.fr/fr/dataset/base-de-donnees-accidents-corporels-de-la-circulation-sur-6-annees)
vincent.michel@logilab.fr's avatar
vincent.michel@logilab.fr committed
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65



Installation
------------

Create an instance:

cubicweb create accidents my_instance_accidents

Create the database:

cubicweb db-create my_instance_accidents

! Do not launch the db-init !

Insert postgis:

psql my_instance_accidents -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql

psql my_instance_accidents -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

Finish the db:

cubicweb db-init my_instance_accidents



Push the data:

Get the communes and departements on http://fr.dbpedia.org/sparql
in JSON, using the following request:


prefix db-owl: <http://dbpedia.org/ontology/>
 select ?ville ?code ?name ?lat ?long ?dep ?depcode ?depname where {
    ?ville db-owl:country <http://fr.dbpedia.org/resource/France> .
    ?ville dbpedia-owl:inseeCode ?code.
    ?ville foaf:name ?name.
    ?ville dbpedia-owl:department ?dep.
    ?dep dbpedia-owl:inseeCode ?depcode.
    ?dep foaf:name ?depname.
    ?ville geo:lat ?lat.
    ?ville geo:long ?long.
 }



Push the communes/departements using:

cubicweb-ctl shell my_instance_accidents /path/to/cubes/accidents/import_communes.py /path/to/json/files


Download both vehicules and accidents files on data.gouv.fr.
Push the data:

cubicweb-ctl shell my_instance_accidents /path/to/cubes/accidents/import_vehicules.py /path/to/vehicules.csv


cubicweb-ctl shell my_instance_accidents /path/to/cubes/accidents/import_accidents.py /path/to/accidents.csv