{"id":2550,"date":"2021-09-08T00:00:38","date_gmt":"2021-09-07T22:00:38","guid":{"rendered":"https:\/\/dumontmathieu.fr\/?p=2550"},"modified":"2021-09-11T22:41:34","modified_gmt":"2021-09-11T20:41:34","slug":"sgbd","status":"publish","type":"post","link":"https:\/\/dumontmathieu.fr\/?p=2550","title":{"rendered":"SGBD"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">Presque quinze ans maintenant que j&rsquo;utilise le duo <strong><a href=\"https:\/\/www.postgresql.org\" target=\"_blank\" rel=\"noopener\" data-type=\"URL\" data-id=\"https:\/\/www.postgresql.org\">PostgreSql<\/a> \/ <a href=\"https:\/\/postgis.net\/\" target=\"_blank\" rel=\"noreferrer noopener\" data-type=\"URL\" data-id=\"https:\/\/postgis.net\/\">Postgis<\/a><\/strong> dans le cadre professionnel. Cela peut \u00eatre \u00e0 travers des logiciels clients (SIG ou non), des applications web ou des scripts. J&rsquo;ai pu, au cours de toutes ces ann\u00e9es, approfondir mes connaissances en <strong>SQL<\/strong> ou en <strong>PL\/PGSQL<\/strong>, langage utilis\u00e9 pour \u00e9crire des proc\u00e9dures stock\u00e9es.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>Postgis<\/strong> est l&rsquo;extension spatiale de <strong>PostgreSql<\/strong>. Elle permet d&rsquo;exploiter les donn\u00e9es spatiales stock\u00e9es dans <strong>PostgreSql<\/strong>. Les fonctionnalit\u00e9s offertes par <strong>Postgis<\/strong> sont extr\u00eamement riches. Elles permettent de r\u00e9pondre \u00e0 des probl\u00e9matiques spatiales relativement facilement, au travers de requ\u00eates <strong>SQL<\/strong>.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">L&rsquo;autre extension indispensable de <strong>PostgreSql<\/strong> est <strong><a href=\"https:\/\/pgrouting.org\/\" target=\"_blank\" rel=\"noopener\" data-type=\"URL\" data-id=\"https:\/\/pgrouting.org\/\">PgRouting<\/a><\/strong>, apparu plus tardivement. Elle permet de r\u00e9aliser des <strong>requ\u00eates<\/strong> dont les r\u00e9sultats peuvent r\u00e9pondre \u00e0 des probl\u00e9matiques de <strong>r\u00e9seau topologique<\/strong> (calcul d\u2019itin\u00e9raires, isodistances, isochrones, optimisation de tourn\u00e9e\u2026). On y retrouve des algorithmes connus comme <strong>dijkstra<\/strong>.<\/p>\r\n\r\n\r\n\r\n         <div class='wpm_6310_loading'>\r\n            <img src='https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/plugins\/team-showcase-supreme\/assets\/images\/loading.gif' \/>\r\n         <\/div>\r\n         <div \r\n            class='wpm_main_template wpm_main_template_1'\r\n            wpm-6310-carousel-styleName='template-06'\r\n            wpm-6310-carousel-itemPerRow='4'\r\n            wpm-6310-carousel-itemPerRow-tablet='1'\r\n            wpm-6310-carousel-itemPerRow-mobile='1'\r\n            wpm-6310-carousel-id='1'\r\n            wpm-6310-carousel-active='0'\r\n            wpm-6310-carousel-autoPlay='4000'\r\n            wpm-6310-carousel-nav='true'\r\n            wpm-6310-carousel-dot='true'\r\n            wpm-6310-carousel-navText='fas fa-angle'\r\n            wpm-6310-category-active='0'\r\n            wpm-6310-search-active='0'\r\n            wpm-6310-item-margin='30'\r\n            wpm-6310-padding='8'\r\n            wpm_6310_progress_bar_animation='0'\r\n            wpm_6310_progress_bar_border_radius='10'\r\n   ><div class='wpm-6310-no-carousel'><div class='wpm-6310-row'>         <div class=\"wpm-6310-col-4\">\r\n            <div  class='wpm_6310_team_style_1 wpm_6310_team_member_info' link-id='0' team-id='8'>\r\n            <img decoding=\"async\" src=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_pgrouting_logo.png\" data-6310-hover-image=\"\" alt=\"PgRouting\" data-wpm-6310-image-attr=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_pgrouting_logo.png\">\r\n               <figcaption>\r\n                  <div class=\"wpm_6310_team_style_1_content\">\r\n                  <div class=\"wpm_6310_team_style_1_content_cell\">\r\n                     <div class=\"wpm_6310_team_style_1_title\">\r\n                        PgRouting                     <\/div>\r\n                     <div class=\"wpm_6310_team_style_1_designation\">\r\n                                             <\/div>\r\n                     \t<div class='wpm_6310_team_style_1_description'>Une autre extension de PostgreSql : PGrouting permettant de r\u00e9aliser des requ\u00eates dont les r\u00e9sultats peuvent r\u00e9pondre \u00e0 des probl\u00e9matiques de r\u00e9seau topologique (calcul d\u2019itin\u00e9raires, isodistances, isochrones, optimisation de tourn\u00e9e\u2026). On y retrouve des algorithmes connus comme dijkstra.<\/div>                  <\/div>\r\n                  <\/div>\r\n               <\/figcaption>\r\n         <\/div>\r\n         <\/div>\r\n         <div class=\"wpm-6310-col-4\">\r\n            <div  class='wpm_6310_team_style_1 wpm_6310_team_member_info' link-id='0' team-id='7'>\r\n            <img decoding=\"async\" src=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_postgis_logo.png\" data-6310-hover-image=\"\" alt=\"PostGis\" data-wpm-6310-image-attr=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_postgis_logo.png\">\r\n               <figcaption>\r\n                  <div class=\"wpm_6310_team_style_1_content\">\r\n                  <div class=\"wpm_6310_team_style_1_content_cell\">\r\n                     <div class=\"wpm_6310_team_style_1_title\">\r\n                        PostGis                     <\/div>\r\n                     <div class=\"wpm_6310_team_style_1_designation\">\r\n                                             <\/div>\r\n                     \t<div class='wpm_6310_team_style_1_description'>L&#039;extension spatiale PostGis de PostgreSql permet de stocker et de manipuler des donn\u00e9es spatiales servant \u00e0 alimenter les logiciels SIG ou les applications webmapping. Postgis offre tout un lot de fonctions SQL permettant d&#039;obtenir des informations spatiales sur les objets stock\u00e9s dans les tables d&#039;une base de donn\u00e9es en ex\u00e9cutant des requ\u00eates SQL.<\/div>                  <\/div>\r\n                  <\/div>\r\n               <\/figcaption>\r\n         <\/div>\r\n         <\/div>\r\n         <div class=\"wpm-6310-col-4\">\r\n            <div  class='wpm_6310_team_style_1 wpm_6310_team_member_info' link-id='0' team-id='6'>\r\n            <img decoding=\"async\" src=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_postgresql_logo.png\" data-6310-hover-image=\"\" alt=\"PostgreSql\" data-wpm-6310-image-attr=\"https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/uploads\/2021\/09\/md_postgresql_logo.png\">\r\n               <figcaption>\r\n                  <div class=\"wpm_6310_team_style_1_content\">\r\n                  <div class=\"wpm_6310_team_style_1_content_cell\">\r\n                     <div class=\"wpm_6310_team_style_1_title\">\r\n                        PostgreSql                     <\/div>\r\n                     <div class=\"wpm_6310_team_style_1_designation\">\r\n                                             <\/div>\r\n                     \t<div class='wpm_6310_team_style_1_description'>PostgreSql est un syst\u00e8me de base de donn\u00e9es relationnelles orient\u00e9 objet (SGBDRO). Il permet de stocker des donn\u00e9es dans des tables organis\u00e9es selon des relations clairement d\u00e9finies. Des cl\u00e9s et des contraintes permettent de respecter l\u2019organisation \u00e9tablie. On peut ensuite interroger les donn\u00e9es au travers de requ\u00eates SQL ou r\u00e9aliser des op\u00e9rations r\u00e9currentes sous forme de proc\u00e9dures stock\u00e9es (langage PLPGSQL).<\/div>                  <\/div>\r\n                  <\/div>\r\n               <\/figcaption>\r\n         <\/div>\r\n         <\/div>\r\n<\/div>\r\n<style type=\"text\/css\">\r\n.wpm_6310_modal_template_before, .wpm_6310_modal_template_after{\r\n  position: absolute;\r\n  cursor: pointer;\r\n  z-index: 99999999;\r\n  border-radius: 50%;\r\n}\r\n.wpm_6310_modal_template_before{\r\n  content: url('https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/plugins\/team-showcase-supreme\/assets\/images\/prev.png');\r\n  left: -50px;\r\n  top: calc(50% - 30px);\r\n}\r\n.wpm_6310_modal_template_after{\r\n  content: url('https:\/\/dumontmathieu.fr\/wordpress\/wp-content\/plugins\/team-showcase-supreme\/assets\/images\/next.png');\r\n  right: -50px;\r\n  top: calc(50% - 30px);\r\n}\r\n.wpm_6310_team_style_1{\r\n  height: 100%;\r\n}\r\n.wpm-6310-no-carousel {\r\n  width: calc(100% + 30px);\r\n  margin-left: -15px;\r\n}\r\n.wpm-6310-item-1{\r\n    width: 100% !important;\r\n}\r\n.wpm-6310-owl-stage{\r\n  display: -webkit-flex;\r\n    display: -ms-flexbox;\r\n    display: flex;\r\n    min-width: 10317px;\r\n    -webkit-flex-wrap: wrap;\r\n    -ms-flex-wrap: wrap;\r\n    flex-wrap: wrap;\r\n}\r\n.wpm-6310-owl-item{\r\n  display: -webkit-flex;\r\n    display: -ms-flexbox;\r\n    display: flex;\r\n    height: auto !important;\r\n}\r\n  .wpm-6310-tooltip:hover:after {\r\n  display: -webkit-flex;\r\n  display: flex;\r\n  -webkit-justify-content: center;\r\n  justify-content: center;\r\n  background: rgba(0, 119, 181, 1);\r\n  border-radius: 5px;\r\n  color: #fff;\r\n  content: attr(tooltip-href);\r\n  margin: -85px 5px 0;\r\n  font-size: 14px;\r\n  line-height: 25px;\r\n  padding: 8px 10px;\r\n  position: absolute;\r\n  z-index: 999;\r\n  min-width: 140px;\r\n}\r\n.wpm_main_template{\r\n  position: relative;\r\n  z-index: 0;\r\n}\r\n.wpm_main_template *, .wpm_6310_modal * {\r\n  box-sizing: border-box !important;\r\n  word-break: break-word !important; \r\n}\r\n.wpm-6310-row img, .wpm-6310-owl-item img{\r\n  float: left !important;\r\n  width: 100% !important;\r\n}\r\n.wpm_main_template, .wpm_main_template a{\r\n  box-shadow: none !important;\r\n}\r\n.wpm-6310-row{\r\n  width: 100%;\r\n  clear: both;\r\n  text-align: center;\r\n  font-size: 0;\r\n  display: flex;\r\n  flex-wrap: wrap;\r\n  justify-content: center;\r\n}\r\n.wpm-6310-img-responsive{\r\n  width: 100%;\r\n  height: auto;\r\n}\r\n.wpm_6310_team_style_1 figcaption{\r\n  padding: 0;\r\n  margin: 0;\r\n  border: none;\r\n}\r\n.wpm-6310-owl-carousel .wpm-6310-item-1{\r\n  padding: 5px 0;\r\n}\r\n.wpm_6310_team_member_info{\r\n  cursor: pointer;\r\n}\r\n.wpm-6310-col-1{\r\n  width: 100%;\r\n  margin-bottom: 30px !important;\r\n  float: left;\r\n  position: relative;\r\n}\r\n.wpm-6310-col-2, .wpm-6310-col-3, .wpm-6310-col-4, .wpm-6310-col-5, .wpm-6310-col-6{\r\n  margin-bottom: 30px !important;\r\n  display: inline-block;\r\n  margin-left: 15px;\r\n  margin-right: 15px;\r\n  vertical-align: top;\r\n  padding: 0  !important;\r\n}\r\n.wpm-6310-col-2{\r\n  width: calc(50% - 30px);\r\n}\r\n.wpm-6310-col-3{\r\n  width: calc(33.33% - 30px);\r\n}\r\n.wpm-6310-col-4{\r\n  width: calc(25% - 30px);\r\n}\r\n.wpm-6310-col-5{\r\n  width: calc(20% - 30px);\r\n}\r\n.wpm-6310-col-6{\r\n  width: calc(16.6667% - 30px);\r\n}\r\nul.wpm_6310_team_style_1_social li a{\r\n  line-height: 35px !important;\r\n  width: 37px !important;\r\n  height: 37px !important; \r\n}\r\nul.wpm_6310_team_style_1_social i[class*=\"fa-\"]{\r\n  line-height: 35px !important;\r\n  width: 35px !important;\r\n  height: 35px !important;;\r\n}\r\n@media screen and (max-width: 767px) {\r\n  .wpm-6310-col-2, .wpm-6310-col-3, .wpm-6310-col-4, .wpm-6310-col-5, .wpm-6310-col-6{\r\n    width: 100% !important;\r\n  }\r\n}\r\n<\/style>\r\n<style type=\"text\/css\">\r\n.wpm_6310_modal, .wpm_6310_loading {\r\n  display: none; \/* Hidden by default *\/\r\n  position: fixed; \/* Stay in place *\/\r\n  z-index: 99999999; \/* Sit on top *\/\r\n  padding-top: 50px; \/* Location of the box *\/\r\n  left: 0;\r\n  top: 0;\r\n  width: 100%; \/* Full width *\/\r\n  height: 100%; \/* Full height *\/\r\n  overflow: auto; \/* Enable scroll if needed *\/\r\n  background-color: rgba(0,0,0,0.8); \/* Black w\/ opacity *\/\r\n  font-family: sans-serif;\r\n}\r\n\/* wpm_6310_modal Content *\/\r\n.wpm_6310_modal-content {\r\n  position: relative;\r\n  background-color: transparent;\r\n  margin: auto;\r\n  padding: 0;\r\n  width: 75%;\r\n  border-radius: 5px;\r\n  -webkit-animation-duration: 0.4s;\r\n  animation-duration: 0.4s;\r\n  margin-bottom: 50px;\r\n}\r\n\/* Add Animation *\/\r\n@-webkit-keyframes wpm-animatetop {\r\n  from {top:-300px; opacity:0}\r\n  to {top:0; opacity:1}\r\n}\r\n@keyframes wpm-animatetop {\r\n  from {top:-300px; opacity:0}\r\n  to {top:0; opacity:1}\r\n}\r\n@keyframes wpm-animatebottom {\r\n  from {bottom:-300px; opacity:0}\r\n  to {bottom:0; opacity:1}\r\n}\r\n@-webkit-keyframes wpm-animatebottom {\r\n  from {bottom:-300px; opacity:0}\r\n  to {bottom:0; opacity:1}\r\n}\r\n@keyframes wpm-animateleft {\r\n  from {left:-300px; opacity:0}\r\n  to {left:0; opacity:1}\r\n}\r\n@-webkit-keyframes wpm-animateleft {\r\n  from {left:-300px; opacity:0}\r\n  to {left:0; opacity:1}\r\n}\r\n@keyframes wpm-animateright {\r\n  from {right:-300px; opacity:0}\r\n  to {right:0; opacity:1}\r\n}\r\n@-webkit-keyframes wpm-animateright {\r\n  from {right:-300px; opacity:0}\r\n  to {right:0; opacity:1}\r\n}\r\n\/* The Close Button *\/\r\n.wpm-6310-close {\r\n  color: #000;\r\n  float: right;\r\n  font-size: 18px;\r\n  font-weight: bold;\r\n  line-height: 0px;\r\n  padding: 0;\r\n  margin: 0;\r\n  position: absolute;\r\n  right: 20px;\r\n  top: 25px;\r\n  z-index: 999;\r\n}\r\n.wpm-6310-close:hover,\r\n.wpm-6310-close:focus {\r\n  color: #878787;\r\n  text-decoration: none;\r\n  cursor: pointer;\r\n}\r\n.wpm_6310_modal_body_picture {\r\n  float: left;\r\n  width: 300px;\r\n  padding-right: 15px;}\r\n  .wpm_6310_modal_body_content{\r\n    width: calc(100% - 315px);\r\n    float: left;\r\n  }\r\n  .wpm_6310_modal_body_picture img{\r\n    width: calc(100% - 12px) !important;\r\n    height: auto;\r\n    border: 1px solid #ccc;\r\n    padding: 5px;\r\n  }\r\n  #wpm_6310_modal_designation{\r\n    font-size: 14px;\r\n    text-transform: uppercase;\r\n    font-weight: 300;\r\n    color: #727272\r\n  }\r\n  #wpm_6310_modal_name{\r\n    text-transform: capitalize;\r\n    font-size: 22px;\r\n    line-height: 30px;\r\n    margin: 0 0 25px;\r\n    font-weight: 600;\r\n    color: #272727;\r\n  }\r\n  #wpm_6310_modal_details, #wpm_6310_modal_details p{\r\n    font-size: 14px;\r\n    line-height: 20px;\r\n    color: #272727;\r\n    padding: 0;\r\n    margin: 0 0 10px 0;\r\n  }\r\n  .wpm_6310_modal_social a{\r\n    width: 36px !important;\r\n    height: 36px !important;\r\n    line-height: 36px !important;\r\n    float:  left;\r\n    margin: 15px 10px 0 0 !important;\r\n    font-size: 18px !important;\r\n    border-radius: 3px !important;\r\n    text-align: center !important;\r\n    cursor: pointer;\r\n    -webkit-transition: all 0.3s ease 0s;\r\n    -moz-transition: all 0.3s ease 0s;\r\n    -ms-transition: all 0.3s ease 0s;\r\n    -o-transition: all 0.3s ease 0s;\r\n    transition: all 0.3s ease 0s;\r\n    padding: 0;\r\n    box-shadow: none;\r\n    text-decoration: none;\r\n  }\r\n  .wpm_6310_modal_social a i {\r\n    font-size: 18px !important;\r\n    line-height: 30px !important;\r\n  }\r\n  .wpm_6310_modal_social a:hover{\r\n    box-shadow: none;\r\n  }\r\n  .wpm_6310_modal .wpm_6310_modal_social{\r\n    float: left;\r\n    position: relative;\r\n    width: 100%\r\n  }\r\n  .wpm_6310_modal .wpm-6310-tooltip:hover:after{\r\n    margin-left: -60px !important;\r\n  }\r\n  .wpm_6310_modal-footer {\r\n    padding: 10px 15px;\r\n    color: white;\r\n  }\r\n  br.wpm_6310_clear{\r\n    clear: both;\r\n  }\r\n  .mywpm_6310_modal{\r\n    display: none;\r\n  }\r\n  .wpm_6310_loading{\r\n    width: 100% !important;\r\n    max-width: 100% !important;\r\n    padding-top: 170px; \/* Location of the box *\/\r\n    text-align: center;\r\n    background-color: rgba(0,0,0,0.5); \/* Black w\/ opacity *\/\r\n    display:none;\r\n  }\r\n  .wpm_6310_loading img{\r\n    border-radius: 50%;\r\n    width: 100px;\r\n    height: 100px;\r\n    position: absolute;\r\n    left: calc(50% - 50px);\r\n    top: calc(50% - 50px);\r\n  }\r\n  @media only screen and (max-width: 600px) {\r\n    .wpm_6310_modal-content{\r\n      width: 90% !important;\r\n    }\r\n    .wpm-6310-close {\r\n      top: -20px;\r\n      right: 0;\r\n      font-size: 30px;\r\n      font-weight: 100;\r\n      color: lightgray;\r\n    }\r\n    .wpm_6310_modal_body_content, .wpm_6310_modal_body_picture img{\r\n      width: 100% !important;\r\n    }\r\n    .wpm_6310_modal_body_picture{\r\n      width: 100% !important;\r\n      padding: 0 !important;\r\n    }\r\n    #wpm_6310_modal_designation{\r\n      margin-top: 15px;\r\n    }\r\n  }\r\n<\/style>\r\n<!-- #####################  Slider Section Start #################### -->\r\n<style>\r\n  .wpm_6310_mmt_1 .wpm_6310_modal_template_1 {\r\n      float: left;\r\n      width: 100%;\r\n      padding: 20px;\r\n      background: #fefefe;\r\n      border: 1px solid #888;\r\n      border-radius: 5px;\r\n      box-shadow: 0 4px 8px 0 rgba(0, 0, 0, 0.2), 0 6px 20px 0 rgba(0, 0, 0, 0.19);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_body_picture img {\r\n      border: 1px solid #ccc;\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_designation {\r\n      font-size: 14px;\r\n      line-height: 20px;\r\n      font-family: Arimo;\r\n      color: rgb(0, 0, 0);\r\n      text-transform: uppercase;\r\n      font-weight: 300;\r\n    }\r\n    @media only screen and (max-width: 767px){\r\n      .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_designation {\r\n        margin-top: 15px;\r\n      }\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_name {\r\n      font-size: 22px;\r\n      line-height: 27px;\r\n      font-family: Arimo;\r\n      color: rgb(17, 1, 0);\r\n      text-transform: capitalize;\r\n      margin-bottom: 25px;\r\n      line-height: 30px;\r\n      font-weight: 600;\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_details {\r\n      font-size: 14px;\r\n      line-height: 19px;\r\n      font-family: Arimo;\r\n      color: rgb(0, 0, 0);\r\n      line-height: calc(14px + 6px);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_modal_contact {\r\n      padding: 0;\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm-custom-fields-list-label {\r\n      font-size: 18px;\r\n      font-family: Amaranth;\r\n      color: rgb(0, 100, 0);\r\n      font-weight: 300;\r\n      line-height: calc(18px + 2px);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm-custom-fields-list:hover .wpm-custom-fields-list-label {\r\n      color: rgb(0, 0, 0);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm-custom-fields-list-content {\r\n      font-size: 14px;\r\n      font-family: Amaranth;\r\n      color: rgb(0, 0, 0);\r\n      font-weight: 300;\r\n      line-height: calc(14px + 6px);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm-custom-fields-list:hover .wpm-custom-fields-list-content {\r\n      color: rgb(0, 100, 0);\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_1 .wpm_6310_member_skills_wrapper .wpm_6310_skills_label_1 {\r\n      color: rgb(255, 255, 255) !important;\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_6 .wpm-custom-fields-list{\r\n      display: flex;\r\n    }\r\n    .wpm_6310_mmt_1 .wpm_6310_modal_template_4 .wpm_6310_member_skills_wrapper {\r\n        display: inline-block !important;\r\n        width: 80% !important;\r\n      }\r\n      .wpm_6310_mmt_1 .wpm_6310_modal_template_4 .wpm_6310_skills_prog_1 {\r\n        margin: auto !important;\r\n      }\r\n.wpm_6310_member_skills_wrapper_1, .wpm_6310_member_skills_wrapper {\r\n  margin: 0;\r\n  width: 100%;\r\n  float: left;\r\n  margin-top: 10px;\r\n  margin-bottom: 0px;\r\n}\r\n.wpm_6310_member_skills_wrapper_1 {\r\n  display: none;\r\n}\r\n.wpm_6310_modal .wpm_6310_member_skills_wrapper {\r\n  width: 50%;  \r\n}\r\n.wpm_6310_skills_label_1 {\r\n  font-size: 12px;\r\n  text-transform: capitalize;\r\n  color: rgb(67, 148, 67);\r\n  font-weight: 200;\r\n  font-family: Amaranth;\r\n  line-height: 16px;\r\n  margin-bottom: 2px;\r\n  text-align: left;\r\n  display: block;\r\n}\r\n.wpm_6310_team_style_1:hover .wpm_6310_member_skills_wrapper_1 .wpm_6310_skills_label_1 {\r\n  color: rgb(189, 8, 28);\r\n}\r\n.wpm_6310_skills_prog_1 {\r\n  flex: 1;\r\n  height: 6px;\r\n  margin-bottom: 6px;\r\n  border-radius: 10px;\r\n  -webkit-border-radius: 10px;\r\n  -moz-border-radius: 10px;\r\n  -o-border-radius: 10px;\r\n  border:  1px solid rgb(55, 110, 55);\r\n  background-color: rgb(204, 49, 90);\r\n  box-shadow: none;\r\n  -o-box-shadow: none;\r\n  -moz-box-shadow: none;\r\n  -webkit-box-shadow: none;\r\n  box-sizing: border-box;\r\n}\r\n  .wpm_6310_modal_template_4 .wpm_6310_skills_prog_1 {\r\n\t\tmargin: 0 5px;\r\n\t}\r\n  .wpm_6310_modal_template_6 .wpm_6310_skills_prog_1 {\r\n\t\tmargin: 0 5px;\r\n\t}\r\n\t.wpm_6310_modal_template_6 .wpm_6310_member_skills_section{\r\n\t\tjustify-content: center !important;\r\n\t}\r\n  .wpm_6310_modal_template_6 .wpm_6310_member_skills_wrapper{\r\n    align-items: center;\r\n  }\r\n  .wpm_6310_modal_template_6 .wpm_6310_skills_prog_1 .wpm-custom-fields-list{\r\n      display: flex;\r\n  }\r\n.wpm_6310_fill_1 {\r\n  float: left;\r\n  background-color: rgb(64, 152, 247);\r\n  height: 100%;\r\n  background-size: 20px 20px;\r\n  position: relative;\r\n} \r\n.wpm_6310_skills_prog_1 .wpm-6310-tooltip-percent{\r\n    position: absolute;\r\n    width: 34px;\r\n    background-color: rgb(64, 152, 247);\r\n    color: #fff;\r\n    height: 20px;\r\n    line-height: 20px;\r\n    text-align: center;\r\n    right: -17px;\r\n    top: -29px;\r\n    display: none;\r\n    border-radius: 5px;\r\n    font-weight: 400;\r\n    font-size: 11px;\r\n    border-radius: 2px;\r\n    transition: all .33s; \r\n    font-family: Amaranth;\r\n  }\t\t\r\n  .wpm_6310_skills_prog_1:hover .wpm-6310-tooltip-percent, \r\n  .wpm_6310_skills_prog_1 .wpm_6310_skills_prog:hover .wpm-6310-tooltip-percent{\r\n    display: block\r\n  }\r\n  .wpm_6310_skills_prog_1 .wpm-6310-tooltip-percent::after {\r\n    position: absolute;\r\n    content: '';\r\n    height: 0;\r\n    border-left: 7px solid transparent;\r\n    border-right: 7px solid transparent;\r\n    border-top: 7px solid rgb(64, 152, 247);\r\n    top: 20px;\r\n    right: 10px;\r\n    z-index: 1;\r\n  }\r\n  \/* ################### Description CSS #################### *\/\r\n  .wpm_6310_team_style_1_description{\r\n    float: left;\r\n    width: 100%;\r\n    display:  block;\r\n    font-size: 14px;\r\n    line-height: 18px;\r\n    color: rgb(240, 240, 240);\r\n    font-family: Amaranth !important;\r\n    font-weight: 100;\r\n    text-transform: none;\r\n    text-align: center;\r\n    margin-top: 0px;\r\n    margin-bottom: 15px;\r\n  }\r\n  .wpm_6310_team_style_1:hover .wpm_6310_team_style_1_description{\r\n    color: rgb(240, 240, 240);\r\n  }\r\n  .wpm-6310-p-l-r-10{\r\n    padding-left: 10px;\r\n    padding-right: 10px;\r\n  }\r\n  #wpm-6310-slider-1 .wpm-6310-owl-nav div.wpm-6310-owl-prev i[class*=\"fa-\"], #wpm-6310-slider-1 .wpm-6310-owl-nav div.wpm-6310-owl-next i[class*=\"fa-\"]{\r\n    line-height: 36px !important;\r\n  }\r\n  .wpm_6310_team_member_internal_link{\r\n   cursor: pointer;\r\n}\r\n<\/style>    <style type=\"text\/css\">\r\n    ul.wpm_6310_team_style_1_social{\r\n      padding: 0 !important;\r\n      list-style: none !important;\r\n    }\r\n    ul.wpm_6310_team_style_1_social li{\r\n      display: inline-block !important;\r\n      padding: 0 !important;\r\n    }\r\n    ul.wpm_6310_team_style_1_social li a{\r\n      display: inline-block !important;\r\n      box-shadow: none !important;\r\n      text-decoration: none !important;\r\n      padding: 0 !important;\r\n      margin: 0 !important;\r\n    }\r\n    ul.wpm_6310_team_style_1_social li a:hover{\r\n      box-shadow: none !important;\r\n      text-decoration: none !important;\r\n    }\r\n    <\/style>\r\n    <\/div><\/div>\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Pour r\u00e9pondre aux besoins du bureau d&rsquo;\u00e9tudes dans lequel j&rsquo;exerce, j&rsquo;ai con\u00e7u un syst\u00e8me permettant de g\u00e9n\u00e9rer rapidement un jeu de donn\u00e9es pour un territoire pr\u00e9cis, sur lequel on va s&rsquo;appuyer pour r\u00e9aliser une \u00e9tude. Les charg\u00e9s de projets vont pouvoir exploiter ces donn\u00e9es sans \u00ab\u00a0polluer\u00a0\u00bb celles utilis\u00e9es dans le cadre d&rsquo;un autre projet qui peut \u00e9ventuellement se trouver sur un m\u00eame territoire.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Ce syst\u00e8me repose avant tout sur un jeu de donn\u00e9es nationales (<strong>OpenStreetMap<\/strong>, <strong>IGN<\/strong>, <strong>INSEE<\/strong>, <strong>DGI<\/strong>, <strong>data.gouv.fr<\/strong>&#8230;) coupl\u00e9 \u00e0 une biblioth\u00e8que de fonctions \/ proc\u00e9dures stock\u00e9es en <strong>PLPGSQL<\/strong>. J&rsquo;y ai ajout\u00e9 il y a quelques ann\u00e9es une interface d\u00e9velopp\u00e9e en <strong>PHP<\/strong> et <strong>Javascript<\/strong> (<strong>JQuery<\/strong> et <strong>OpenLayers<\/strong>) pour plus de facilit\u00e9 d&rsquo;utilisation.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Presque quinze ans maintenant que j&rsquo;utilise le duo PostgreSql \/ Postgis dans le cadre professionnel. Cela peut \u00eatre \u00e0 travers des logiciels clients (SIG ou\u2026<\/p>\n","protected":false},"author":1,"featured_media":2784,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[160],"tags":[],"class_list":["post-2550","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sgbd"],"_links":{"self":[{"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/posts\/2550","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2550"}],"version-history":[{"count":38,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/posts\/2550\/revisions"}],"predecessor-version":[{"id":3050,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/posts\/2550\/revisions\/3050"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=\/wp\/v2\/media\/2784"}],"wp:attachment":[{"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2550"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2550"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dumontmathieu.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2550"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}