Technical Articles
Recent posts from Medium where I share insights and tutorials about GIS technologies, database management, and software development.
Geographic Information Systems — PostgreSQL Data Transfer
A comprehensive guide on data transfer operations in PostgreSQL for GIS applications. Covers best practices, performance optimization, and common pitfalls.
Git — Self Signed Certificate Problem Solution
Solving self-signed certificate issues in Git when working with secure repositories. Step-by-step guide with multiple solutions.
Geographic Information Systems — Creating Your First Map
Step-by-step tutorial on creating your first map using GIS tools and technologies. Perfect for beginners in GIS.
Oracle Spatial — SDO_RELATE Usage Guide
Complete guide on using SDO_RELATE function for spatial relationships in Oracle databases. Practical examples and use cases.
Geographic Information Systems — GeoServer Configuration
Learn how to configure and use GeoServer for serving geographic data. Includes security, performance tuning, and deployment strategies.
Oracle Spatial Index Creation: Solving ORA-13203 Error
Troubleshooting and solving the ORA-13203 error when creating spatial indexes in Oracle. Root cause analysis and solutions.
Advanced GIS Techniques for Urban Planning
Implementing GIS solutions for urban planning projects. Case studies and real-world applications.
Spatial Database Performance Optimization
Techniques for optimizing spatial database queries and improving performance in PostgreSQL and Oracle.
Web Mapping with OpenLayers and GeoServer
Building interactive web maps using OpenLayers library with GeoServer as the backend service.