
MSc Geomatics Student | GIS Specialist | Remote Sensing Analyst | Researcher | OpenStreetMap Contributor | Interested in #DataScience and #ClimateChange studies
8°43′N, 125°45′E
Joined March 2017
- Tweets785
- Following282
- Followers163
- Likes4.4K
Pinned Tweet
I'm so glad to be one of the contributors in mapping the building footprints of the areas affected (particularly in Baggao and Santa Ana, Cagayan) by Typhoon Ompong in OpenStreetMap.
#hotosm-project-5236 #OmpongPH #TyphoonOmpongDigitizeBuildings #youthmappers
Khen Bolz retweeted
Most researchers collect data first, then wonder why nobody reads their papers.
Start with the story.
The data comes after.
Khen Bolz retweeted
God is killing 3 big demons in your life tonight:
- Debt
- Disease
- Anxiety
Say Amen!✨
Khen Bolz retweeted
🚀 New Tutorial Alert!
I just published a step-by-step guide on building an interactive dashboard with Python and Leafmap. 🌍📊
Explore the Jupyter Notebook: leafmap.org/maplibre/dashboa…
Watch the full video tutorial: youtu.be/DEPdsJdTQN8
#leafmap #geospatial #python #dataviz
I'm happy to share that three of my papers received citations in July, which is the most in a single month thus far! Huge thanks to my co-authors and the researchers who valued our work.
#PublishedResearch #ScholarlyWork #ResearchCitations
24
Khen Bolz retweeted
The upcoming joint NASA-@isro #NISAR satellite will map farmlands from planting to harvest—detecting crop growth, soil moisture & plant health twice every ~12 days. 🛰️🌾🌽
Big boost for farming efficiency and food security! Learn more: nasa.gov/missions/nisar… #AgTech

ALT The above image was taken by the European Space Agency's Sentinel 1 satellite, another radar satellite similar to the upcoming NISAR mission. The image shows changes to croplands in the region southeast of Florida’s Lake Okeechobee. Colors in the fields indicate various crops in different parts of their growth and harvest cycles. NISAR will gather similar data in L- and S-band radar frequencies.
Khen Bolz retweeted
The environment is one of the most pressing concerns of our time & GIS provides a powerful lens to better understand, protect & restore it.
Let’s dive into these ideas & explore how GIS & environmental research can come together to tackle some of our most critical challenges.
I am happy to share that I have received my Certificate of Participation in the webinar "Data Science in Agriculture: Exploring Agro-Statistics with Python" organized by MathTech Thinking Foundation.
#datascience #DataAnalysis #agriculture #Statistics #pythonprogramming
1
105
Khen Bolz retweeted
Master Network Analysis in Python — Visualize & Analyze Graphs Easily
Tutorial link: youtu.be/G1t1Dz8Kjp4
#network #python
Khen Bolz retweeted
A GIS career can be highly rewarding.
But only if you take control of your growth.
Ask yourself;
- Is your GIS experience translating into career growth or just years passing by?
- Are you actively building a successful GIS career or just going with the flow?
- Do you have a GIS roadmap, or are you waiting for opportunities to find you?
- Have you mastered the business side of GIS or are you stuck in the technical weeds?
- Does your GIS job bring you peace and fulfilment or just stress?
- Have you invested in personal branding or are you invisible in the GIS space?
- Are you just making maps and apps or solving real-world problems?
- Have you built a strong network or are you navigating the GIS world alone?
- Will your current GIS skills still be relevant in 5 years?
- When was the last time you learned a GIS skill beyond your comfort zone?
- Can you communicate GIS insights to decision-makers who don’t understand maps?
Which question hit you the hardest?
Khen Bolz retweeted
SQL has levels to it:
- level 1
SELECT, FROM, WHERE, GROUP BY, HAVING, LIMIT
Master these basic keywords and you’ll be well on your way to mastering SQL.
- level 2
Mastering JOINs:
Most common JOINs: INNER and LEFT
Less common JOINs: FULL OUTER
Joins you should avoid almost always: RIGHT and CROSS JOIN
Mastering common table expressions (CTEs).
The WITH keyword defines a CTE which you can imagine as a “variable” that you can query later.
Using variables like this you can master algorithm techniques like recursion, breadth first search and more!
CTEs also make your SQL much more readable and make your coworkers hate you less compared to nested sub queries.
- level 3
Mastering window functions
Window functions have 3 pieces:
The function (i.e. SUM, RANK, AVG)
The over clause to start the window
The window definition which has 3 pieces:
- how to split the window up with PARTITION BY
- how to order the window with ORDER BY
- how to restrict the window size with ROWS clause (useful for rolling monthly averages)
Understand RANK vs DENSE_RANK vs ROW_NUMBER, I have been asked this in interviews a million times.
- level 4
You understand table scans, b-tree indexes, and partitioning schemes to increase performance.
Doing something like COUNT(CASE WHEN) is much better than doing multiple queries with a UNION ALL. UNION ALL is terrible for all sorts of reasons that I don’t want to get into in this post.
B-trees indexes allow for efficient scanning of data in the WHERE clause.
Use explain plans to understand if an index is actually being used or not!
Partitioning is similar to indexes except it’s a “poor mans” index. It just keeps data in specific folders and skips the folders that don’t include the data I question.
What else did I miss for mastering SQL?



































