Skip to content

Instantly share code, notes, and snippets.

View clodio's full-sized avatar

Claude Seguret clodio

1 follower · 0 following
View GitHub Profile
@clodio
clodio / exemple_import_elasticsearch_kafka.gif
Last active January 3, 2023 11:06
demo projet dataengineer
exemple_import_elasticsearch_kafka.gif
@clodio
clodio / Explications.md
Created January 13, 2019 08:15
Explications
<title>Explications</title>
@clodio
clodio / Explications.md
Created January 13, 2019 08:11
Explications

Welcome to StackEdit!

testr

Files

StackEdit stores your files in your browser, which means all your files are automatically saved locally and are accessible offline!

Create files and folders

@clodio
clodio / apiqadr-swagger-V02.04.yml
Created January 19, 2018 09:59
Contrat de service swagger de l'api qualif adresse
swagger: "2.0"
info:
version: "1.0.0"
title: "API Qualification Adresse"
contact:
email: "ld-bscc-service-qualification-adresse@laposte.fr"
description: |
**Ce service permet de réaliser des traitements sur une ou plusieurs adresses et récupérer des informations associées:**
@clodio
clodio / ban-kibana.txt
Created December 14, 2017 17:40
GET _search
{
"query": {
"match_all": {}
}
}
DELETE /ban
PUT /ban
{
@clodio
clodio / apiqadr-swagger-v1.yml
Created December 4, 2017 09:27
Contrat de service swagger API Qualif Adresse V1
swagger: "2.0"
info:
version: "1.0.0"
title: "API Qualification Adresse"
contact:
email: "ld-bscc-service-qualification-adresse@laposte.fr"
description: |
**Ce service permet de réaliser des traitements sur une ou plusieurs adresses et récupérer des informations associées:**
@clodio
clodio / extraction-rzp-2017-09-19.sql
Created October 3, 2017 16:48
extraction-rzp-2017-09-19
This file has been truncated, but you can view the full file.
TRUNCATE TABLE `rzp_copy`;
INSERT INTO `rzp_copy` (`id_tech`, `address_id`, `distribution_site_code_roc`, `distribution_site_end_date`, `distribution_site_start_date`, `cabin_site_code_roc`, `cabin_site_start_date`, `cabin_site_end_date`, `collection_site_code_roc`, `collection_site_start_date`, `collection_site_end_date`, `parcel_site_code_roc`, `parcel_site_start_date`, `parcel_site_end_date`) VALUES
(1, '00001', 'A37845', '', '2015-04-02T09:11:37Z', 'A37845', '2015-04-02T09:11:37Z', '', 'A37845', '2015-04-02T09:11:37Z', '', 'A37845', '2015-04-02T09:11:37Z', ''),
(2, '00002', 'A16819', '', '2015-04-02T09:11:37Z', 'A16819', '2015-04-02T09:11:37Z', '', 'A16819', '2015-04-02T09:11:37Z', '', 'A16819', '2015-04-02T09:11:37Z', ''),
(3, '00003', 'A12599', '', '2015-04-02T09:11:37Z', 'A12599', '2015-04-02T09:11:37Z', '', 'A12599', '2015-04-02T09:11:37Z', '', 'A12599', '2015-04-02T09:11:37Z', ''),
(4, '00004', 'A21530', '', '2015-04-02T09:11:37Z', 'A21530', '2015-04-02T09:11:37Z', '', 'A21530', '201
@clodio
clodio / log-bcaa-extract-elk.json
Created September 22, 2017 11:15
log-bcaa-extract-elk.json
This file has been truncated, but you can view the full file.
{
"took": 907,
"timed_out": false,
"_shards": {
"total": 2060,
"successful": 2060,
"failed": 0
},
"hits": {
"total": 2463,
@clodio
clodio / convertojson.sh
Created July 15, 2017 06:28
ban-688-conversion jsontocsv fichier adressses non organisees
echo "insee;localité;cea;ligne 3;numéro;extension;voie;géométrie;srid;code géométrie" > ban-688-no.csv
cat ban-688-no.json | sed -e "s/{\"insee\":\"//g" | sed -e "s/\",\"localité\":\"/;/g" | sed -e "s/\",\"voie\":\"/;/g"| sed -e "s/\",\"géométrie\":\"/;/g" | sed -e "s/\",\"cea\":\"/;/g" | sed -e "s/,\"code géométrie\":/;/g" | sed -e "s/\",\"srid\":/;/g" |sed -e "s/}//g" | sed -e "s/\",\"ligne 3\":\"/;/g" | sed -e "s/\",\"numéro\":/;/g" | sed -e "s/,\"extension\":/;/g" | sed -e "s/,\"voie\":\"/;/g" | sed -e "s/;null;/;;/g" >>ban-688-no.csv
echo "insee;localité;cea;voie;géométrie;srid;code géométrie" > ban-688-voie.csv
cat ban-688-voie.json | sed -e "s/{\"insee\":\"//g" | sed -e "s/\",\"localité\":\"/;/g" | sed -e "s/\",\"voie\":\"/;/g"| sed -e "s/\",\"géométrie\":\"/;/g" | sed -e "s/\",\"cea\":\"/;/g" | sed -e "s/,\"code géométrie\":/;/g" | sed -e "s/\",\"srid\":/;/g" |sed -e "s/}//g" >> ban-688-voie.csv
@clodio
clodio / test.geojson
Last active June 19, 2017 23:43
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.