GeoExt, ExtJS, OpenLayers and GeoJSON

GeoExt, ExtJS, OpenLayers and GeoJSON

GeoExt, Highlight, OpenLayers, Programming, Slider, Web-GIS
Hello guys, some time ago I did a sample application on GeoExt, ExtJS, OpenLayers and GeoJSON to manage data from a number of weather stations in the country. This is a front-end application with data being in GeoJSON format. A video about the application uploaded on YouTube : The application can be accessed at Weather Station Portal For more GIS tutorial videos, Subscribe to my channel on YouTube
Read More
Important Python Libraries for Geospatial

Important Python Libraries for Geospatial

Highlight, Libraries, Programming
Today, I take a look at the Python Libraries useful when dealing with Geospatial Data. The most popular GIS; QGIS and ArcGIS are developed on Python thus giving us the power to extend their tools to suit our needs in the organization. For Instance, QGIS offers the “Plugin Builder” tool that is focused on personal tool creation by individuals or organization to do specific tasks as required. To do this, there are some Python Libraries that are required. Anyone who has worked with scripts in either QGIS, ArcGIS,Jupyter or GeoDjango for geospatial data analysis must have interacted with some, if not all, of these libraries. My experience with most applications more so QGIS, Jupyter and GeoDjango, has enabled me draft this post as most of these libraries seem confusing to…
Read More

Adding data into ExtJS grid from PostgreSQL with PHP-The JSON format

GIS
Data loading from a database into an application is useful more so if there will be frequent changes on the data stored in the databases. The data is loaded from the database when the application is loading. Any changes on the data are reflected into the grid carrying our data in the application. I will demonstrate using PHP and ExtJS on how to query a database and return the data into a JSON format that will be used in our JavaScript application. First, we write a script that will query our database in PHP (data.php)  //data.php $db = pg_connect("host=somehost port=someport dbname=**** user=**** password=****") or die('could not connect:'.pg_last_error()); $result = pg_query($db, "SELECT *,ST_AsGeoJSON(geom) FROM Africa") or die("Data load failed:".pg_last_error()); $rows = array(          'type'      => 'FeatureCollection',         'features'  => array()  …
Read More