Introduction To Spatial Database

What is a DBMS (database management system)?

A database management system (DBMS) serves as an interface between users and their database

What is a Spatial Database?

If you include location with data your database will be spatial data.

Why location: Geography plays a key role in effective decision making, importance of location with your data can be explained by the fact that all big giants of IT industry like google are now focusing on Geospatial technology.

Advantages of Spatial DBMS:-

- Spatial database enable you to perform spatial queries, store locational data.

- Organizations can leverage Return on Investment using SDBMS

- Effective Decision making

- Accurate research

- No extra skills with small training one can leverage ROI.

Spatial Query: - Query means to fetch data with certain conditions from your side; it is a sort of question

Example of Simple Query: - Students with grade greater than 70 is a simple query.

Example of Spatial Query: - Students with grade greater than 70 and live in city A.

Performing Simple Query: - Use a simple DBMS like Oracle or other.

Performing Spatial Query: - Use spatial data base such as Postgis

Spatial Database in Real Estate: - Real Estate searches can be made more innovative using Spatial Queries.

Example of Spatial Query in Real Estate: - How many houses are available within 10 meters of park.

Output: - A Map with all selected houses within 10 meters of park.

Comments

GDAL & OGR (Importance & Installation)

GDAL & OGR libraries allow you to perform various GIS operations like, Flow Direction or working with DEM few raster & vector analysis outside GIS environment. Image by Gerd Altmann from Pixabay What Knowledge one should have : Basic Programming, Python What software you need : Python IDLE or command line, GDAL libraries files (explained later) Installation : 1- Once you have Python installed. 2- Start python IDLE to check which version of python you are using available at top as shown Python IDLE 3- Install two files available at link below based on your version of python. Download Link : http://www.gisinternals.com/query.html?content=filelist&file=release-1500-gdal-2-1-2-mapserver-7-0-2.zip Install first : gdal-201-1500-core.msi and then: GDAL-2.1.2.win32-py2.7.msi * Note specify the path C:\Python27\ArcGIS10.3\Lib\site-packages\ for GDAL-2.1.2.win32-py3.2....

Working With Raster Calculator In ArcMap

Raster Calculator extracts information from a Raster Image, based on user requirements. Image by James Osborne from Pixabay Working with Raster Calculator To explore the highest elevation areas in your DEM raster e.g. select Spatial Analyst Tools à Map Algebra Raster Calculator Tool Raster Calculator Double click on the layer e.g. in my case it is DEM_Layer or any raster of your choice, to enter this into the ‘ search ’ window. Click on the “ > ” symbol e.g. and select a number less than the maximum elevation . Query can change based on your criterion. This arithmetic raster operation will select all cells with values above the defined threshold. In the example below a threshold of 500m was used. A new layer appears on your map. The majority of the map has a 0 value representing false (values below the threshold), and the colored region has a value of ...

“Rule Based Classification” using eCognition

Availability of high resolution satellite imagery leads to a growing number of change detection techniques and algorithms, research is done using remote sensing and GIS. In this tutorial, we build on the classification category feature set by introducing neighborhood relationships and topological functions. Secondly, we use relative elevation values and fuzzy rules for the classification systems. This study demonstrates that the rule-based classifier is a significantly better approach than the classical per-pixel classifiers & object based NN method . Image Source: NASA Methodology 1. Open the eCognition software. 2. Click on “create new project” option. 3. Import the “Study area image” from the workspace. 4. Assign weights to NIR band 5. Click on the layers and rename each layer. Layer 1 as blue, layer 2 as green, and 3rd as red and 4th NIR. 6. Go to “Process” option on t...

Learning Object Based Classification Using eCognition

Object Based Classification Using eCognition tutorials by GIS HIVE . ImageSource:PixaBay Lab 01 Performing Image Classification On High Resolution Data on Erdas Imagine Lab 02 Introduction to eCognition Basics Lab 03 Image Segmentation using eCognition Lab 04 Object Based Classification Using Standard NN eCognition Lab 05 Rule Based Classification using eCognition GIS HIVE intends to promote Geo Spatial Sciences awareness, for that purpose GIS HIVE has launched Youtube Channel . Here you can explore various Geospatial tutorials.

What is Radiometric Resolution Of Satellite Image

Radiometric Resolution is defined as magnitude of EM ( Electromagnetic Energy ) recorded by a sensor Units : Measured in Bits Formula: Each bit records an exponent Power of 2. 1 Bit= 2 2 Bit=4 4 Bit =16 8 Bit=255 digital values Note: 0 represents Black tone and maximum like 255 represents highest tone. image source www.satimagingcorp.com 1 Bit will be Black & white 16 Bit will be colored 32 Bit will be more colored and will carry greater energy levels Higher Radiometric Resolution much variation in colors reflected. Image to left is of higher radiometric resolution than that of Landsat below. image source: geoinfo.amu.edu.pl

GeoDa Free GIS Software

What is GeoDa : GeoDa provides analysis of various data formats like shapefile, GeoJSON, KML, SQLite and table format (CSV, XLS and DBF). Image by Pexels from Pixabay How it is related to GIS: It provides Geo-visualization, user can perform certain spatial analysis. Good things about GeoDa: GeoDa is an Open Source software, Along with Spatial analysis, simpler & complex statistical data analysis performed in excel (charting, graphing ) can be performed in GeoDa. Most suited for: It is most suitable for Students, Researchers. Downloadable link : http://geoda.software.informer.com/1.8/ imagesource: GitHub

Generating Contours From DEM In ArcMap

Contours are a useful way to visualize topography and to create a map that can be printed in black and white, or that mimics the standard USGS topo maps. Image by TheAndrasBarta from Pixabay What you need: DEM data of your Area. Extract your area from online freely available DEM and select Spatial Analyst Tools -> Surface -> Contour. Select the inputs as follows, with a 100m or 50m contour interval: since 10 m might take time. and click OK. Contour tool in ArcMap Output may be some thing like depending on color scheme. Go to properties and label elevation values for a good visualization. Image source: en.wikipedia.org

Climate Change Not Myth But Reality

Northern Areas of Pakistan are blessed with beauty, we often hear people quoting these beautiful areas as “Switzerland of Pakistan”, “Heaven on Earth”, but these words proved there reality when for the first time I visited Northern Pakistan. It is worth mentioning that Pakistan is dependent on frozen hydrological resources. Many rivers such as River Swat, Chitral, Gilgit, Hunza, Shigar, Shyok, Indus, Shingo, Astor, and Jhelum are fed by runoff generated by melting of SC of Northern areas. Image by Aqsa kamran from Pixabay Image by Abdullah Shakoor2 from Pixabay This runoff supports agriculture . Agriculture of Pakistan is largely dependent on the snow melting phenomenon. Anomalies witnessed in glaciers and their melting patterns will have massive impact on hydrological resources because the country’s 70% of fresh water depends upon these frozen hydrological resources in the high mountains of Himalaya and Hindu Ku...

OBJECT-BASED BUILDINGS DETECTION & CHANGE ANALYSIS USING MULTI TEMPORAL HIGH RESOLUTION REMOTE SENSING DATA

With urbanization and urban sprawl, land-use and land-cover change studies became an area of keen interest for researchers. Cause of rapid urbanization is peoples’ responses to economic opportunities, and government policies. New housing societies and business model adopted overall globe has provided opportunities for new land uses . Image by piviso from Pixabay “Image Classification is the process of sorting pixels into a finite number of individual classes, categories of data based on their DN (Digital Number) values”. With advent of modern high resolution era of satellite images, PIXEL based, Object based and many other machine learning algorithms have been developed. Currently the prospects of a new classification concept, Object-Based Classification , are being investigated. Recent studies have proven the accuracy of object-based classification over traditional classifiers. The object-based classification approach relies on basic...

Introductory Training On ArcGIS

What is ArcMap? ArcMap is the primary mapping component of ArcGIS Desktop software from ESRI . ArcMap is where you display and explore GIS datasets for your study area, where you assign symbols, and where you create map layouts for printing or publication. ArcMap is also the application you use to create and edit datasets. ArcMap represents geographic information as a collection of layers and other elements in a map. Common map elements include the data frame containing map layers for a given extent plus a scale bar, north arrow, title, descriptive text, a symbol legend, and so on. ArcGIS is, the world's most popular Desktop GIS software. Image by Sasin Tipchai from Pixabay Training Contents Launching ArcMap Adding Data in ArcMap Using Basic Tools in ArcMap Data Views in ArcMap Changing Symbology in ArcMap ...

GeoSpatial Knowledge Hive

Search This Blog