{"id":517,"date":"2016-05-30T19:33:27","date_gmt":"2016-05-30T11:33:27","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=517"},"modified":"2016-05-30T19:33:27","modified_gmt":"2016-05-30T11:33:27","slug":"import-geometry-data-esri-shapefile-sql-server-using-gdalogr","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html","title":{"rendered":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR"},"content":{"rendered":"

Dalam mengerjakan project GIS sering saya mendapatkan file ESRI Shapefile yang harus di import ke dalam SQL Server. untuk dapat melakukan hal tersebut salah satu caranya adalah dengan menggunakan GDAL\/OGR component.<\/p>\n

The Geospatial Data Abstraction Library (GDAL) adalah open source library and set of tools untuk melakukan\u00a0converting and manipulasi\u00a0spatial data. Namun dalam menggunakan tool ini tidak mudah, kita harus banyak bermain dengan command yang di eksekusi mengguakan OGR2OGR command line.<\/p>\n

untuk itu saya mencoba untuk mencontohkan cara menggunakan tool ini. sebelumnya kita persiapkan dulu component-component yang diperlukan yaitu :<\/p>\n

    \n
  1. install and configure GDAL\/OGR windows binaries is by downloading dengan cara mendownload OSGeo4W package disini\u00a0http:\/\/trac.osgeo.org\/osgeo4w\/<\/a><\/li>\n
  2. Lakukan\u00a0set a system environment variable, GDAL_DATA, dimana didalam folder gdal_data ini terdapat\u00a0GDAL support files gcs.csv and pcs.csv yang mengatur mengenai referensi EPSG code yang digunakan.<\/li>\n<\/ol>\n

    sebelumnya saya sudah siapkan ESRI shapefile contoh yang akan digunakan yang rekan-rekan dapat download disini\u00a0https:\/\/www.dropbox.com\/s\/2juvjdzk0ld0lan\/AdmKabMagelang.zip?dl=0<\/a><\/p>\n

    dan juga sudah saya siapkan 1 buah database bernama : LATIHAN di dalam SQL Server. disini saya menggunakan SQL Server 2012 Developer.<\/p>\n

    setelah langkah 1 dan 2 diatas dilakukan dan database juga sudah tersedia, kita dapat memulai melakukan import data SHP nya ke SQL Server<\/p>\n

    pertama jalankan OSGeo4W Shell sehingga muncul tampilan berikut :<\/p>\n

    \"osgeo4w\"<\/a><\/p>\n

    lakukan ketikkan command berikut :<\/p>\n

    ogr2ogr
    \n-f “MSSQLSpatial”
    \n“MSSQL:server=localhost;database=LATIHAN;trusted_connection=yes”
    \n“F:\\DEMO\\SHP\\AdmKabMagelang.shp”
    \n-a_srs “EPSG:4326”<\/p>\n

    maka hasilnya akan seperti ini :<\/p>\n

    \"ogr2ogr2\"<\/a><\/p>\n

    jika tidak ada pesan error \u00a0apapun berarti kita telah sukses memindahkan ESRI Shapefile diatas ke dalam sql Server. dan ini bisa kita cek ke dalam SQL Server :<\/p>\n

    \"ogr2ogr\"<\/a><\/p>\n

     <\/p>\n

    Sampai disini kita berhasil melakukan import ESRI Shapefile ke dalam SQL Server. Demikian semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Dalam mengerjakan project GIS sering saya mendapatkan file ESRI Shapefile yang harus di import ke dalam SQL Server. untuk dapat melakukan hal tersebut salah satu caranya adalah dengan menggunakan GDAL\/OGR component.<\/p>\n

    Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":518,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[111,42,110,88,87,17],"class_list":["post-517","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spatial","tag-gdal","tag-gis","tag-ogr2ogr","tag-spatial","tag-sql-server","tag-tutorial"],"yoast_head":"\nImport geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Dalam mengerjakan project GIS sering saya mendapatkan file ESRI Shapefile yang harus di import ke dalam SQL Server. untuk dapat melakukan hal tersebut salah satu caranya adalah dengan menggunakan GDAL\/OGR component. Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-30T11:33:27+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png\" \/>\n\t<meta property=\"og:image:width\" content=\"663\" \/>\n\t<meta property=\"og:image:height\" content=\"336\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR\",\"datePublished\":\"2016-05-30T11:33:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\"},\"wordCount\":305,\"commentCount\":1,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png\",\"keywords\":[\"GDAL\",\"GIS\",\"OGR2OGR\",\"Spatial\",\"SQL Server\",\"Tutorial\"],\"articleSection\":[\"Spatial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\",\"url\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\",\"name\":\"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png\",\"datePublished\":\"2016-05-30T11:33:27+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png\",\"width\":663,\"height\":336},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html","og_locale":"en_US","og_type":"article","og_title":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog","og_description":"Dalam mengerjakan project GIS sering saya mendapatkan file ESRI Shapefile yang harus di import ke dalam SQL Server. untuk dapat melakukan hal tersebut salah satu caranya adalah dengan menggunakan GDAL\/OGR component. Continue reading","og_url":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2016-05-30T11:33:27+00:00","og_image":[{"width":663,"height":336,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR","datePublished":"2016-05-30T11:33:27+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html"},"wordCount":305,"commentCount":1,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png","keywords":["GDAL","GIS","OGR2OGR","Spatial","SQL Server","Tutorial"],"articleSection":["Spatial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html","url":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html","name":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png","datePublished":"2016-05-30T11:33:27+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/05\/osgeo4w.png","width":663,"height":336},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-gdalogr.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Import geometry data from ESRI Shapefile to SQL Server using GDAL\/OGR"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=517"}],"version-history":[{"count":1,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/517\/revisions"}],"predecessor-version":[{"id":521,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/517\/revisions\/521"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/518"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=517"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}