﻿{"id":4450,"date":"2017-12-27T06:35:41","date_gmt":"2017-12-27T05:35:41","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?page_id=4450"},"modified":"2017-12-27T06:35:41","modified_gmt":"2017-12-27T05:35:41","slug":"postgresql-postgis-tutorial","status":"publish","type":"page","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/","title":{"rendered":"PostgreSQL\/Postgis tutorial"},"content":{"rendered":"<h2>Tutorial Getting Started with 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>Geoserver tutorial<\/h2>\n<p><a href=\"http:\/\/wp.me\/p6XU0A-N1\">D\u00e9buter avec Geoserver<\/a><\/p>\n<h2 class=\"entry-title\"><span id=\"result_box\" class=\"short_text\" lang=\"en\"><span class=\"\">Develop an application with pgrouting on Windows<\/span><\/span><\/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>Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":4436,"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,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-4450","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=\"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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\" \/>\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\/en\/tutorials\/postgresql-postgis-tutorial\/\" \/>\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=\"PostgreSQL\/Postgis tutorial | Blog SIG &amp; Territoires\" \/>\n\t\t<meta property=\"og:description\" content=\"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2017-12-27T05:35:41+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2017-12-27T05:35:41+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=\"PostgreSQL\/Postgis tutorial | Blog SIG &amp; Territoires\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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\" \/>\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\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#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\\\/en\\\/tutorials\\\/#listItem\",\"name\":\"Tutorials\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/#listItem\",\"position\":2,\"name\":\"Tutorials\",\"item\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#listItem\",\"name\":\"PostgreSQL\\\/Postgis tutorial\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#listItem\",\"position\":3,\"name\":\"PostgreSQL\\\/Postgis tutorial\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/#listItem\",\"name\":\"Tutorials\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#person\",\"name\":\"Atilio Francois\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#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\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#webpage\",\"url\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/\",\"name\":\"PostgreSQL\\\/Postgis tutorial | Blog SIG & Territoires\",\"description\":\"Tutorial Getting Started with Postgres \\\/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \\u00e0 pgAdmin III et au chargeur de donn\\u00e9es shape Geoserver tutorial D\\u00e9buter avec Geoserver Develop an application with pgrouting on 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\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.sigterritoires.fr\\\/index.php\\\/en\\\/tutorials\\\/postgresql-postgis-tutorial\\\/#breadcrumblist\"},\"datePublished\":\"2017-12-27T06:35:41+01:00\",\"dateModified\":\"2017-12-27T06:35:41+01: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":"PostgreSQL\/Postgis tutorial | Blog SIG & Territoires","description":"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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","canonical_url":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/","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\/en\/tutorials\/postgresql-postgis-tutorial\/#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\/en\/tutorials\/#listItem","name":"Tutorials"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/#listItem","position":2,"name":"Tutorials","item":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/#listItem","name":"PostgreSQL\/Postgis tutorial"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/#listItem","position":3,"name":"PostgreSQL\/Postgis tutorial","previousItem":{"@type":"ListItem","@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/#listItem","name":"Tutorials"}}]},{"@type":"Person","@id":"https:\/\/www.sigterritoires.fr\/#person","name":"Atilio Francois","image":{"@type":"ImageObject","@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/#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\/en\/tutorials\/postgresql-postgis-tutorial\/#webpage","url":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/","name":"PostgreSQL\/Postgis tutorial | Blog SIG & Territoires","description":"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/www.sigterritoires.fr\/#website"},"breadcrumb":{"@id":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/#breadcrumblist"},"datePublished":"2017-12-27T06:35:41+01:00","dateModified":"2017-12-27T06:35:41+01: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":"PostgreSQL\/Postgis tutorial | Blog SIG &amp; Territoires","og:description":"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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","og:url":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/","article:published_time":"2017-12-27T05:35:41+00:00","article:modified_time":"2017-12-27T05:35:41+00:00","article:publisher":"https:\/\/www.facebook.com\/atilio.francois\/","twitter:card":"summary","twitter:site":"@SigTerritoires","twitter:title":"PostgreSQL\/Postgis tutorial | Blog SIG &amp; Territoires","twitter:description":"Tutorial Getting Started with Postgres \/ Postgis 1- Installation et configuration de PostgreSQL et Postgis 2-Introduction \u00e0 pgAdmin III et au chargeur de donn\u00e9es shape Geoserver tutorial D\u00e9buter avec Geoserver Develop an application with pgrouting on 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","twitter:creator":"@SigTerritoires"},"aioseo_meta_data":{"post_id":"4450","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:57:24","updated":"2025-06-04 16:01:34","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\/en\/tutorials\/\" title=\"Tutorials\">Tutorials<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tPostgreSQL\/Postgis tutorial\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.sigterritoires.fr"},{"label":"Tutorials","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/"},{"label":"PostgreSQL\/Postgis tutorial","link":"https:\/\/www.sigterritoires.fr\/index.php\/en\/tutorials\/postgresql-postgis-tutorial\/"}],"jetpack_shortlink":"https:\/\/wp.me\/P6XU0A-19M","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/4450","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=4450"}],"version-history":[{"count":0,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/4450\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/pages\/4436"}],"wp:attachment":[{"href":"https:\/\/www.sigterritoires.fr\/index.php\/wp-json\/wp\/v2\/media?parent=4450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}