{"id":522,"date":"2016-06-03T11:31:52","date_gmt":"2016-06-03T03:31:52","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=522"},"modified":"2016-06-03T11:31:52","modified_gmt":"2016-06-03T03:31:52","slug":"import-geometry-data-esri-shapefile-sql-server-using-shape2sql","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html","title":{"rendered":"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL"},"content":{"rendered":"

Beberapa waktu yang lalu saya sudah menulis tutorial mengenai bagaimana meng import data ESRI Shapefile ke SQL Server menggunakan GDAL\/OGR<\/a>. Beberapa orang mungkin tidak terlalu menyukai cara ini karena harus menggunakan Command line kemudian menuliskan kode-kode. cara lain utk melakukan import ESRI Shapefile ini ke sql server ini adalah dengan menggunakan tool Shape2SQL.<\/p>\n

untuk melakukan demo cara ini, kita persiapkan terlebih dahulu beberapa hal yaitu :<\/p>\n

    \n
  1. Data ESRI Shapefile yang akan di import, anda dapat menggunakan data yang sudah saya siapkan disini\u00a0<\/a><\/li>\n
  2. Download dan Install SQL Server 2008 Express atau yang lebih baru<\/li>\n
  3. Download dan install tool Shape2SQL disini<\/a><\/li>\n<\/ol>\n

    jika ketiga hal tersebut sudah disiapkan, selanjutnya kita mulai proses import ini. langkah pertama adalah membuka aplikasi Shape2SQL yang sudah di install dengan membuka file shape2sql.exe<\/p>\n

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

    setelah itu lakukan beberapa penyesuaian terhadap data-data yang diminta oleh aplikasi Shape2SQL.<\/p>\n

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

    langkah pertama adalah me load ESRI Shapefile kedalam tool Shape2SQL<\/p>\n

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

    Langkah kedua adalah melakukan configurasi koneksi ke SQL Server<\/p>\n

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

    Langkah Ketiga adalah melakukan konfigurasi properties Geometries nya<\/p>\n

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

    Setelah itu lakukan upload ke database .<\/p>\n

    Setelah proses upload selesai, kita dapat check hasil upload nya ke dalam tabel di SQL Server, sesuai konfigurasi diatas data ESRI Shapefile tersebut di upload ke database GIS dengan tabel bernama AdmKabMagelang2<\/p>\n

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

    Tampak bahwa proses Import ESRI Shapefile ke SQL Server telah berhasil dengan menggunakan tool Shape2SQL<\/p>\n

    Demikian semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Beberapa waktu yang lalu saya sudah menulis tutorial mengenai bagaimana meng import data ESRI Shapefile ke SQL Server menggunakan GDAL\/OGR. Beberapa orang mungkin tidak terlalu menyukai cara ini karena harus menggunakan Command line kemudian menuliskan kode-kode. cara lain utk melakukan import ESRI Shapefile ini ke sql server ini adalah dengan \u2026<\/p>\n

    Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[47,88,87,17],"class_list":["post-522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spatial","tag-shape2sql","tag-spatial","tag-sql-server","tag-tutorial"],"yoast_head":"\nImport geometry data from ESRI Shapefile to SQL Server using Shape2SQL - 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-shape2sql.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 Shape2SQL - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Beberapa waktu yang lalu saya sudah menulis tutorial mengenai bagaimana meng import data ESRI Shapefile ke SQL Server menggunakan GDAL\/OGR. Beberapa orang mungkin tidak terlalu menyukai cara ini karena harus menggunakan Command line kemudian menuliskan kode-kode. cara lain utk melakukan import ESRI Shapefile ini ke sql server ini adalah dengan \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.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-06-03T03:31:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"439\" \/>\n\t<meta property=\"og:image:height\" content=\"394\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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-shape2sql.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL\",\"datePublished\":\"2016-06-03T03:31:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html\"},\"wordCount\":239,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg\",\"keywords\":[\"Shape2SQL\",\"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-shape2sql.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html\",\"url\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html\",\"name\":\"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg\",\"datePublished\":\"2016-06-03T03:31:52+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg\",\"width\":439,\"height\":394},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.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 Shape2SQL\"}]},{\"@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 Shape2SQL - 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-shape2sql.html","og_locale":"en_US","og_type":"article","og_title":"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL - Suherman Blog","og_description":"Beberapa waktu yang lalu saya sudah menulis tutorial mengenai bagaimana meng import data ESRI Shapefile ke SQL Server menggunakan GDAL\/OGR. Beberapa orang mungkin tidak terlalu menyukai cara ini karena harus menggunakan Command line kemudian menuliskan kode-kode. cara lain utk melakukan import ESRI Shapefile ini ke sql server ini adalah dengan \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2016-06-03T03:31:52+00:00","og_image":[{"width":439,"height":394,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg","type":"image\/jpeg"}],"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-shape2sql.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL","datePublished":"2016-06-03T03:31:52+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html"},"wordCount":239,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg","keywords":["Shape2SQL","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-shape2sql.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html","url":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html","name":"Import geometry data from ESRI Shapefile to SQL Server using Shape2SQL - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg","datePublished":"2016-06-03T03:31:52+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2016\/06\/shp2sql1.jpg","width":439,"height":394},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/import-geometry-data-esri-shapefile-sql-server-using-shape2sql.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 Shape2SQL"}]},{"@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\/522","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=522"}],"version-history":[{"count":2,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/522\/revisions"}],"predecessor-version":[{"id":534,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/522\/revisions\/534"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/530"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=522"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}