﻿{"id":3033,"date":"2016-02-16T08:09:08","date_gmt":"2016-02-16T07:09:08","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?page_id=3033"},"modified":"2016-08-24T10:07:35","modified_gmt":"2016-08-24T09:07:35","slug":"tutoriel-postgresqlpostgis","status":"publish","type":"page","link":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/","title":{"rendered":"Tutoriel PostgreSQL\/Postgis"},"content":{"rendered":"<h2>Tutoriel D\u00e9buter avec Postgres\/Postgis<\/h2>\n<p><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/debuter-avec-postgrespostgis\">1- Installation et configuration de PostgreSQL et Postgis<\/a><\/p>\n<p><a href=\"http:\/\/wp.me\/p6XU0A-Mx\">2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape<\/a><\/p>\n<h2>Tutoriel Geoserver<\/h2>\n<p><a href=\"http:\/\/wp.me\/p6XU0A-N1\">D\u00e9buter avec Geoserver<\/a><\/p>\n<h2 class=\"entry-title\">D\u00e9velopper une application avec pgrouting sous Windows<\/h2>\n<p class=\"entry-title\"><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/developper-une-application-avec-pgrouting-sous-windows-1\/\">(1): pgrouting<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/developper-une-application-avec-pgrouting-sous-windows-2lalgorithme-a-star\/\">(2):l\u2019algorithme A-star<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/developper-une-application-avec-pgrouting-sous-windows-3lalgorithme-dijkstra\/\">(3):l\u2019algorithme Dijkstra<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/developper-une-application-avec-pgrouting-sous-windows-4zones-de-chalandise-et-isochrones\/\">(4):zones de chalandise et isochrones<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/www.sigterritoires.fr\/index.php\/developper-une-application-avec-pgrouting-sous-windows-5ecrire-un-wrapper\/\">(5):\u00e9crire un Wrapper<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/wp.me\/p6XU0A-RY\">(6):D\u00e9velopper une application avec pgrouting sous Windows :Configurer Geoserver<\/a><\/p>\n<p class=\"entry-title\"><a href=\"http:\/\/wp.me\/p6XU0A-Se\">(7):D\u00e9velopper une application avec pgrouting sous Windows :OpenLayers 3<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1555,"menu_order":30,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"sfsi_plus_gutenberg_text_before_share":"","sfsi_plus_gutenberg_show_text_before_share":"","sfsi_plus_gutenberg_icon_type":"","sfsi_plus_gutenberg_icon_alignemt":"","sfsi_plus_gutenburg_max_per_row":"","_monsterinsights_skip_tracking":false,"footnotes":""},"class_list":["post-3033","page","type-page","status-publish","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"google-site-verification\" content=\"ByXHZUbGNn7RNv-Xk5A-ysTZrM65VLIO2RxfSJ2nIEQ\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Blog SIG &amp; Territoires | le portail des professionnels du SIG\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Tutoriel PostgreSQL\/Postgis | Blog SIG &amp; Territoires\" \/>\n\t\t<meta property=\"og:description\" content=\"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2016-02-16T07:09:08+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2016-08-24T09:07:35+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/atilio.francois\/\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@SigTerritoires\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Tutoriel PostgreSQL\/Postgis | Blog SIG &amp; Territoires\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@SigTerritoires\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.sigterritoires.fr\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/#listItem\",\"name\":\"Tutoriels\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/#listItem\",\"position\":2,\"name\":\"Tutoriels\",\"item\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#listItem\",\"name\":\"Tutoriel PostgreSQL\\\/Postgis\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#listItem\",\"position\":3,\"name\":\"Tutoriel PostgreSQL\\\/Postgis\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/#listItem\",\"name\":\"Tutoriels\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\",\"name\":\"Atilio Francois\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Atilio Francois\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#webpage\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/\",\"name\":\"Tutoriel PostgreSQL\\\/Postgis | Blog SIG & Territoires\",\"description\":\"Tutoriel D\\u00e9buter avec Postgres\\\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \\u00e0 pgAdmin III et au chargeur de donn\\u00e9es shape Tutoriel Geoserver D\\u00e9buter avec Geoserver D\\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\\u2019algorithme A-star (3):l\\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\\u00e9crire un Wrapper (6):D\\u00e9velopper une application avec pgrouting sous Windows\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/tutoriels-2\\\/tutoriel-postgresqlpostgis\\\/#breadcrumblist\"},\"datePublished\":\"2016-02-16T08:09:08+01:00\",\"dateModified\":\"2016-08-24T10:07:35+02:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#website\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/\",\"name\":\"Blog SIG & Territoires\",\"description\":\"le portail des professionnels du SIG\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Tutoriel PostgreSQL\/Postgis | Blog SIG & Territoires","description":"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows","canonical_url":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"ByXHZUbGNn7RNv-Xk5A-ysTZrM65VLIO2RxfSJ2nIEQ","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr#listItem","position":1,"name":"Home","item":"https:\/\/www.sigterritoires.fr","nextItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/#listItem","name":"Tutoriels"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/#listItem","position":2,"name":"Tutoriels","item":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#listItem","name":"Tutoriel PostgreSQL\/Postgis"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#listItem","position":3,"name":"Tutoriel PostgreSQL\/Postgis","previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/#listItem","name":"Tutoriels"}}]},{"@type":"Person","@id":"https:\/\/www.sigterritoires.fr\/#person","name":"Atilio Francois","image":{"@type":"ImageObject","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/f76dc2a720162999bce81d6c99b6d7b9517d6600ad7ceb5ed5268f02cefaa0ee?s=96&d=mm&r=g","width":96,"height":96,"caption":"Atilio Francois"}},{"@type":"WebPage","@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#webpage","url":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/","name":"Tutoriel PostgreSQL\/Postgis | Blog SIG & Territoires","description":"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/www.sigterritoires.fr\/#website"},"breadcrumb":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/#breadcrumblist"},"datePublished":"2016-02-16T08:09:08+01:00","dateModified":"2016-08-24T10:07:35+02:00"},{"@type":"WebSite","@id":"https:\/\/www.sigterritoires.fr\/#website","url":"https:\/\/www.sigterritoires.fr\/","name":"Blog SIG & Territoires","description":"le portail des professionnels du SIG","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/www.sigterritoires.fr\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Blog SIG &amp; Territoires | le portail des professionnels du SIG","og:type":"article","og:title":"Tutoriel PostgreSQL\/Postgis | Blog SIG &amp; Territoires","og:description":"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows","og:url":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/","article:published_time":"2016-02-16T07:09:08+00:00","article:modified_time":"2016-08-24T09:07:35+00:00","article:publisher":"https:\/\/www.facebook.com\/atilio.francois\/","twitter:card":"summary","twitter:site":"@SigTerritoires","twitter:title":"Tutoriel PostgreSQL\/Postgis | Blog SIG &amp; Territoires","twitter:description":"Tutoriel D\u00e9buter avec Postgres\/Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Tutoriel Geoserver D\u00e9buter avec Geoserver D\u00e9velopper une application avec pgrouting sous Windows (1): pgrouting (2):l\u2019algorithme A-star (3):l\u2019algorithme Dijkstra (4):zones de chalandise et isochrones (5):\u00e9crire un Wrapper (6):D\u00e9velopper une application avec pgrouting sous Windows","twitter:creator":"@SigTerritoires"},"aioseo_meta_data":{"post_id":"3033","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"WebPage","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2020-12-21 13:56:47","updated":"2025-06-04 15:59:35","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.sigterritoires.fr\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/\" title=\"Tutoriels\">Tutoriels<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tTutoriel PostgreSQL\/Postgis\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.sigterritoires.fr"},{"label":"Tutoriels","link":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/"},{"label":"Tutoriel PostgreSQL\/Postgis","link":"https:\/\/www.sigterritoires.fr\/index.php\/tutoriels-2\/tutoriel-postgresqlpostgis\/"}],"jetpack_shortlink":"https:\/\/wp.me\/P6XU0A-MV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/3033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3033"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/3033\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/1555"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}