Basic Computer Programming: An essential skill for GIS Analyst







Whether you want to uncover the secrets of the universe, or you just want to pursue a career in the 21st century, Basic Computer Programming is an essential skill to learn 
Stephen Hawking




This article is not about the life and achievements of Stephen Hawking, rather an inspiring and incredible quote of Stephen hawking is the only motive to write this article.
Stephen Hawking needs no introduction as the best known scientist on planet Earth not just on the field of cosmology but as a hugely successful science writer and beacon of inspiration for how the limitations of the body can be overcome by the power of the mind. He has asserted Basic Computer Programming as a vital and essential skill to learn if we want to pursue a career in the modern era.  
The intent of this article is to signify and justify the inevitability of basic programming skill for a GIS Analyst. The duties of a GIS Analyst are not limited to make pretty paper maps to impress the boss or manager rather; he should have some proficiency in remote sensing, CAD, programming and database management.
The primary duties of a GIS Analyst includes analyzing spatial data through mapping software and designing digital maps with geographic data and various other datasets. A GIS Analyst has to import the data from AutoCAD, Microstation, MS Excel and other file formats to use in basic GIS software environment. The major mapping software used in industry are ESRI ArcGIS and QGIS (free and open source GIS software). Both software support customization and automation using different programming languages and scripts. Nowadays, the majority of GIS analyst positions require programming skills and application development. Therefore it is essential to know at least Basic Computer Programming for a GIS Analyst to automate the repetitive tasks, import/export from different file formats, calculating the field attributes, appending and merging multiple datasets etc.

Unfortunately, basic programming skill is overlooked not only in academia but even GIS Analysts did not emphasize and realize the importance of programming in the field of GIS. The majority of GIS Analysts do not know about the basic programming using python or vbscript. They work on daily basis using ArcGIS and create attractive colorful maps but they are not aware about the powerful script engines present under their nose.




Most of the GIS Analysts (in Pakistan) working in industry have a Bachelor's or Master of Science degree in Geography, Geomatics, Space Science, GIS & Remote Sensing and other earth related sciences. These degree programs include programming course too as a subject. Now, the question arise that why most of the GIS Analysts are not proficient at Basic Computer Programming though they were taught during degree program?

The main reason is because it is presumed by GIS students that programming courses are tough and hard. Even the teachers used to say to students that programming is not everyone’s cup of tea. I personally don’t agree with it. Programming isn't hard, it just requires more time and practice than we might expect. The class lectures and course contents does not cover the techniques needed to write smart programs, so it’s no wonder students get frustrated and give up.
In short, programming cannot be learnt solely by listening lectures rather it requires practicing it. If someone wants to learn swimming, he needs to practice it. A lecture isn't going to make him a swimmer.
The basic programming can be started to learn using common software we use on daily basis such as MS Office. Visual Basic for Applications (VBA) can be a good start to learn relatively basic programming concepts.  
All Microsoft products (Excel, Word, Access, Power Point) comes with the default Visual Basic editor. It does not need to install any IDE (Integrated Development Environment)  or any compiler.  For more details, it can be started from this link.

Once become familiar with programming using VBA, the VB Script functions can be applied to calculate the field values in attribute table. This link illustrates several Calculate Field example codes.
ESRI no longer supports distribution of VBA since ArcGIS Desktop 10.2.2 release, but still VBScript is used for quick calculation of field attributes.

It will be easier to switch to code in Python language after learning basic programming using VBA. ArcGIS comes with Python IDLE and compiler. 





For a GIS Analyst, there will be repetitive kind of work such as copying the data, changing the format of data sets, spatial analysis etc. ArcGIS have all the GUI’s available in Python on command line to do batch processing and automation.
Explore  python language, create custom toolboxes/scripts to automate the GIS workflows and be the outstanding GIS Analyst.

Comments

Post a Comment

Popular posts from this blog

SpaTools: Import Lidar Point Cloud (LAS/LAZ) files into AutoCAD

Image
Point clouds are large data sets composed of 3D point data. These geographic point data is collected mostly by Laser scanners and drones equipped with LIDAR (Light Detection And Ranging) sensors. In addition to these directly collected LIDAR point cloud data, the aerial RGB images collected by drones are processed using Image Processing & Computer Vision Algorithm based software such as Pix4D, Agisoft Photoscan or DroneDeploy to produce RGB Point Clouds in LAS file format. Besides that, the well known image processing software such as ERDAS Imagine Leica Photogrammetry Suite (LPS), ENVI and PCI Geomatica produce output in LAS file format when stereo/tri-stereo satellite images (WorldView-2, WorldView-3, SOPT 5/6/7 & Pleiades) are processed.     LAS is an industry standard file format defined by the American Society of Photogrammetry and Remote Sensing (ASPRS) that includes a system of point classification. A processed LAS file may have points classified as bare earth,
Read more

How to Clip objects in AutoCAD

Image
There is a tool named as CLIP in ArcGIS which cut out a piece of one feature class using one or more of the features in another feature class as a cookie cutter. This is particularly useful for creating a new feature class as study area or area of interest (AOI) that contains a geographic subset of the features in another, larger feature class. It is often needed to CLIP all the objects contained completely inside a polygon to a new drawing. The type of the objects may vary from simple objects like polylines, lines, circles, text to complex objects like splines, arcs, hatches, blocks etc. Since the release of AutoCAD 2008, a new command EXPORTLAYOUT was introduced to export all the objects in all the viewports of the layout to a separate drawing. I am writing this article because most of the CAD users are not aware about the power of this magical command of Autocad and use TRIM command to trim all the objects one by one which are outside of the desired polygon. It is h
Read more

SpaTools: Extract Topographic Profile From Contours In AutoCAD

Image
A topographic map is simply the two dimensional representation of a portion of three dimensional surface of earth. Topographic maps provide the detailed information about the natural and man-made aspects of the terrain, but are best known for their series of contour lines that show elevation changes, and colors signifying varying land types and bodies of water. Contour lines are used to determine elevations and are lines on a map that are produced from connecting points of equal elevation (elevation refers to height in feet, or meters, above sea level). By reading contour lines, one can measure the steepness of a hill, the height of a mountain, and even the depth of a lake or Ocean . The contours can be generated by a DEM (Digital Elevation Model), TIN (Triangular Irregular Network) or a surface using different software such as ArcGIS.  Read the blog about How to generate contours from DEM and create a topographic map in Autocad. Most of the topographic maps used for plann
Read more

Creating Contour Maps in ArcGIS and Conversion to AutoCAD drawing

Image
A topographic map is simply the two dimensional representation of a portion of three dimensional surface of earth. Topographic maps provide the detailed information about the natural and man-made aspects of the terrain, but are best known for their series of contour lines that show elevation changes, and colors signifying varying land types and bodies of water. Contour lines are used to determine elevations and are lines on a map that are produced from connecting points of equal elevation (elevation refers to height in feet, or meters, above sea level). By reading contour lines, one can measure the steepness of a hill, the height of a mountain, and even the depth of a lake or ocean . These lines are evenly spaced apart. This spacing is called the contour interval. For example, if your map uses a 10-foot contour interval, you will see contour lines for every 10 feet (3 meters) of elevation -- lines at 0, 10, 20, 30, 40, and so on. Different maps use different intervals, dependin
Read more

Why GIS users should learn AutoCAD?

Image
My last recent posts are titled with prefix of SpaTools . SpaTools is a .NET DLL developed using AutoCAD .Net API, where scripts, routines, macros and programs written in VBA and Lisp by me are integrated into a single DLL file using C# Language. The major motives to develop such a DLL and share it with fellow professionals are its portability, scalability and integrity. Till now, tools for clipping objects, extracting topographic profiles from contours, Cut polygons, annotating an alignment with chainages, creating a convex hull, and some others of the simpler sort are included. SpaTools was tried, tested and appreciated in the CAD community. Feedbacks were received with requests for additional programs/tools to be included. On the contrary, the GIS community was silent. This was awkward since GIS (Geographic Information System) is a “ System to Collect, Store, Analyze and represent the Spatial Data ”. Following were some views from GIS professionals, upon inquiry: They
Read more

SpaTools: Toolbar with all tools

Image
Since January 2020, I started writing blogs about the custom tools developed for AutoCAD. All those blogs are entitled with the prefix of “SpaTools” . Currently, ten (10) different tools have been added to SpaTools.DLL . For each tool, I have published a blog with the explanation of its usability and some basic information. The readers not only appreciated it but also suggested to improve and extend it further by adding more tools such as Export CSV, KML, LAS, GPX, SHP etc and other cartographic tools. Besides that, it was suggested by some users to develop it as a Toolbar . In the response of that suggestion, I have developed it as a toolbar. The DLL file can be downloaded from the link  at the bottom of this page. Prior to loading in AutoCAD, unblock it. Right Click on the DLL file and check the unblock checkbox and apply. Load the DLL into AutoCAD using NETLOAD command.    The commands are categorized into three panels:  Import , Create Features and Cartography &
Read more