pixelcooker

 Seiring dengan semakin populernya penggunaan data spasial di berbagai institusi, baik pemerintah maupun swasta di Indonesia, banyak lembaga pemerintah telah mengembangkan Geoportal sebagai sarana berbagi pakai data geospasial resmi pemerintah. Berbagai macam peta dasar dan peta tematik dengan berbagai format telah dipublikasikan secara resmi oleh geoportal yang dikelola masing - masing instansi.  Berikut ini adalah daftar alamat web geoportal milik instansi pemerintah indonesia, baik kementerian, badan, lembaga, maupun pemerintah daerah yang telah dibangun dan diresmikan. Daftar ini akan diperbarui sewaktu - waktu apabila tercatat ada lembaga pemerintah yang telah membangun dan menerbitkan geoportal sebagai salah satu sarana berbagi pakai data dan informasi geospasial.  Kementerian / Lembaga / Pemerintah Daerah Pengelola Alamat URL Portal INA SDI https://tanahair.indonesia.go.id/portal-web/# Kementerian Kelautan dan Perikanan http://satupeta.kkp.go.id/ Kementerian Pertania

This post straight continuation from my previous post about Integration of Enterprise Geodatabase and PostGIS inside PostgreSQL Environment. The video tutorial can be viewed at the end of this post. In the video I demonstrate about how to configure PostGIS extension inside PostgreSQL enterprise geodatabase. The steps are little bit tricky so if you are not familiar with Enterprise Geodatabase and PostGIS, I suggest you to watch the Part 1 of the series. The configuration steps I show on the video must be done one by one following the order like I demonstrate on the video. On step missed will result in Geodatabase in not usable and PostGIS wont works like how it should.  I dont test these steps on other OS like Linux, but I guess it wont be much different. And please remember that you must see this trick as experimental because personally I also didnt evaluate its performance in actual production environment. 

As promised from my previous post, I have started to make series of video demonstration about how to extend Enterprise Geodatabase functionalities with PostGIS features inside PostgreSQL Database Management System. The first video below will show you about the PostgreSQL, PostGIS and Enterprise Geodatabase installation and initial configuration under Windows OS. I dont test it on Linux yet but I think it would be pretty much same. If you readers already familiar about PostgreSQL, PostGIS and Enterprise Geodatabase installation, guess you can skip this post and wait for my next post.  You can test the workflow from your local computer or remote online server, I have done both, so far there are no problem arised, but if you want to implement multi client editing (for example using ArcGIS and QGIS at same time) I suggest you to be careful because I found an ObjectID increment functions on both software are conflicting, but it is only happen if two or more clients perform commit data only

 Mungkin akan ada yang membutuhkan. Berikut ini daftar Kode BPS untuk provinsi di Indonesia. Aceh - Kode BPS: 11 Sumatera Utara - Kode BPS: 12 Sumatera Barat - Kode BPS: 13 Riau - Kode BPS: 14 Jambi - Kode BPS: 15 Sumatera Selatan - Kode BPS: 16 Bengkulu - Kode BPS: 17 Lampung - Kode BPS: 18 Kepulauan Bangka Belitung - Kode BPS: 19 Kepulauan Riau - Kode BPS: 21 Jakarta - Kode BPS: 31 Yogyakarta (DIY) - Kode BPS: 34 Jawa Barat - Kode BPS: 32 Jawa Tengah - Kode BPS: 33 Jawa Timur - Kode BPS: 35 Banten - Kode BPS: 36 Bali - Kode BPS: 51 Nusa Tenggara Timur - Kode BPS: 53  Nusa Tenggara Barat - Kode BPS: 52 Kalimantan Barat - Kode BPS: 61 Kalimantan Tengah - Kode BPS: 62 Kalimantan Selatan - Kode BPS: 63 Kalimantan Timur - Kode BPS: 64 Kalimantan Utara - Kode BPS: - Sulawesi Utara - Kode BPS: 71 Sulawesi Tengah - Kode BPS: 72 Sulawesi Selatan - Kode BPS: 73 Sulawesi Tenggara - Kode BPS: 74 Sulawesi Barat - Kode BPS: 76 Gorontalo - Kode BPS: 75 Maluku - Kode BPS: 81 Maluku Utara - Kode BPS:

 After few days crawling the GIS Stackexchange and many hours of reading ESRI ArcGIS Help Documents, finally I can manage to integrate ArcSDE Enterprise Geodatabase and PostGIS to be working together on a single PostgreSQL database. This configuration will enables you to use most of the cool features of Enterprise Geodatabase as well as PostGIS. For example, I can do Multiuser Editing Sessions using ArcGIS and QGIS at same time, I can enable Editor Tracking feature from Enterprise Geodatabase, perform versioning or archiving, but I also can connect my geospatial data to BI software like Tableau in Live Settings (not extracted). The latter is very important for me because up until this article writing, Tableau has not supported Enterprise Geodatabase Connection thru database connection. They only provide it thru API Services Connection (OGC WFS or ArcGIS Map Services).  Here are the steps that I compiled after many hours of trial and errors 1. copy st_geometry from.dll C:\Program Files

Many database engineers looking for workflow to reduce their job loads when it must dealing with database administrative tasks like backup, restore, delete, clone or renaming database. Spatial Database administrative tasks is no exception. Up until today, I still looking for a way to make my routine database administration more easier. For Enterprise Geodatabase, ArcGIS Desktop and ArcGIS pro have provided dozens of tools to do those administrative tasks inside the desktop software, so I dont have to leave the GIS software just for doing some database administrative tasks.  But similar condition is not seamlessly found in QGIS and PostGIS as its "native" DBMS. But finally today, with the release of a cool new plugin by Leandro Franca called LF Tools, I found that features like in ArcGIS can also be done in QGIS. Now my database administration routines can be done inside QGIS, I dont have to go to PgAdmin4 if I want to do certain database administration stuffs. I can do that i

A short tips and tricks presentation about How to select SAR satellite imagery stereo pair for proper Interferometry Processing. This summary is compiled from many sources.