English · Bahasa Indonesia
Panduan Praktis SQL DuckDB di GeoLibre¶
Learn spatial SQL from scratch in plain language, practising in GeoLibre, which is free and open source. The book is written in Indonesian.
Rp85,000 · Ebook PDF + EPUB · 420 pages
A relaxed, Indonesian-language ebook that teaches vector data processing with DuckDB SQL inside GeoLibre: from installing GeoLibre and the SQL Workspace to case studies on clipping official land cover data, carbon stock in Mount Ciremai National Park, and biodiversity indices from GBIF and iNaturalist. All exercises use real data from Kuningan Regency and West Java, with sample data ready to download.
Downloading, installing and updating GeoLibre, and what its MIT licence means
A tour of GeoLibre’s menus, with their QGIS equivalents
Preparing data: converting the official RBI topographic data to GeoJSON and GeoParquet
SQL basics: SELECT, WHERE, GROUP BY, HAVING, CASE, JOIN, CTE, window functions
Spatial SQL: coordinate systems and UTM, area, length, distance, spatial join, buffer, clip, dissolve
Case studies: land cover in Kuningan, carbon stock in Mount Ciremai National Park, biodiversity from GBIF and iNaturalist
420 pages, 4 parts, 26 chapters
155 figures and screenshots of the latest GeoLibre
147 SQL examples with syntax highlighting
100 everyday SQL recipes and a linked DuckDB syntax dictionary
Exercises and checkpoints in every chapter
Digital PDF with a clickable table of contents
Print-ready PDF
EPUB for phones and e-readers
Google Drive link to the sample data (RBI Kuningan, land cover 2024 and 2025, TNGC boundary, West Java boundaries)
Questions¶
Do I need paid software?
No. GeoLibre and DuckDB are free and open source.
I have never written code. Can I follow it?
Yes. The book starts from zero, including what a query is.
Where does the data come from?
RBI from the Geospatial Information Agency (BIG), official land cover, the TNGC boundary and West Java boundaries, all prepared in a Google Drive folder.
Can I read it on my phone?
The EPUB reads well on a phone. For the exercises you still need a laptop.
Digital product, delivered automatically after payment. This is an independent guide, not officially affiliated with GeoLibre or DuckDB.
Free module: cloud remote sensing¶
A remote sensing module you can open and download for free from Google Drive.
The full library of books you can read on this site is on the Library page.