Splunk App for Etalab DVF data
https://app.dvf.etalab.gouv.fr/
https://app.dvf.etalab.gouv.fr/faq.html
https://www.data.gouv.fr/fr/datasets/demandes-de-valeurs-foncieres/
https://www.data.gouv.fr/fr/datasets/demandes-de-valeurs-foncieres-geolocalisees/
https://files.data.gouv.fr/geo-dvf/latest/csv/
https://hub.docker.com/r/splunk/splunk/
https://github.com/splunk/docker-splunk/
https://github.com/splunk/splunk-ansible/
https://www.splunk.com/en_us/blog/cloud/announcing-splunk-on-docker.html
docker run -d -p 8000:8000 -e SPLUNK_START_ARGS=--accept-license -e SPLUNK_PASSWORD=torototo -e SPLUNK_APPS_URL=https://github.com/utano/splunk-maps-plus/raw/master/maps-for-splunk_315.tgz,https://github.com/utano/splunk-etalab-dvf/archive/master.tar.gz,https://github.com/utano/splunk-etalab-dvf-data/archive/master.tar.gz --name splunk splunk/splunk:7.3
# Download files first
curl -JLO https://github.com/utano/splunk-maps-plus/raw/master/maps-for-splunk_315.tgz
curl -JLO https://github.com/utano/splunk-etalab-dvf/archive/master.tar.gz
curl -JLO https://github.com/utano/splunk-etalab-dvf-data/archive/master.tar.gz
# Then, launch Docker container
docker run -d -p 8000:8000 -v $(pwd):/docker-mount -e SPLUNK_START_ARGS=--accept-license -e SPLUNK_PASSWORD=torototo -e SPLUNK_APPS_URL=/docker-mount/maps-for-splunk_315.tgz,/docker-mount/splunk-etalab-dvf-master.tar.gz,/docker-mount/splunk-etalab-dvf-data-master.tar.gz --name splunk splunk/splunk:7.3
docker exec -it splunk bash
ansible@971c580e3076:/opt/splunk$ sudo su - splunk
$ /bin/bash --init-file ${SPLUNK_HOME}/bin/setSplunkEnv
splunk@971c580e3076:~$
http://127.0.0.1:8000/en-US/app/splunk-etalab-dvf-master/splunketalabdvfdash
All CSV files are available here: https://cadastre.data.gouv.fr/data/etalab-dvf/latest/csv/
- Add Data
- Upload
- Select File: 2019-31.csv.gz
- Next
- Create a source type: csv-etalab
- Timestamp:
- Extraction: Advanced
- Timestamp format: %Y-%m-%d
- Timestamp fields: date_mutation
- Advanced:
- MAX_DAYS_AGO: 10000
- Timestamp:
- Next
- Index: csv-etalab
- Review
- Submit
Download Maps+ from https://github.com/sghaskell/maps-plus / https://splunkbase.splunk.com/app/3124/
Install Maps+ on Splunk
- Apps
- Install app from file
- Submit
index="csv-etalab-dvf" sourcetype="csv-etalab-dvf" longitude="*" latitude="*" code_postal IN (31700 31840 31820 31770 31880 31830 31170 31270)
| eval surface_eval = coalesce(surface_reelle_bati,surface_terrain)
| search surface_eval="*"
| eval prixm2_eval = valeur_fonciere/surface_eval
| eval description = "<b>".
coalesce(nature_mutation,"?")." ".
coalesce(type_local,nature_culture,"?").
"<br/>".
coalesce(adresse_numero,"")." ".
coalesce(adresse_nom_voie,"")." ".
coalesce(code_postal,"")." ".
coalesce(nom_commune,"").
"<br/>".
coalesce(tostring(surface_eval,"commas"),"?")." m2 - ".
coalesce(tostring(valeur_fonciere,"commas"),"?")." €".
"<br/>".
coalesce(tostring(prixm2_eval,"commas"),"?")." € / m2".
"<br/>".
coalesce(date_mutation,"?").
"</b>"
| table latitude longitude description