This article is a very short tutorial for installing PostgreSQL 12/ PostGIS on the Ubuntu system. It is a production note which I initially wrote for myself to install PostgreSQL on several machines. The explanation is kept very short and straight to the result.
$ sudo apt update
$ sudo apt install postgresql-12 postgresql-client-12
$ systemctl status postgresql.service
This short article shows step-by-step on how to add Mapbox based-map to the CesiumJS web application. Let’s begin!
You can get the Mapbox API key by registering an account and get your access token from https://account.mapbox.com/access-tokens/
As some of you might face an issue cannot updating Sypder and other python modules to the latest. Sometimes, your anaconda navigator shows the outdated environment. In this article, I will show you an easy way to update your Spyder to the latest version.
Prerequisite: Conda or Miniconda or Anaconda installed. 🐍
1.) Open Terminal or Anaconda Prompt with the administrator right.
2.) Update your conda/anaconda to the latest version with the following commands:
// update conda
$ conda update conda
// Optionally, also update anaconda
$ conda update anaconda
3.) Update Spyder (or other Python environments)
// Update Spyder…
In data science projects, you may have a data table that contains country data like country name, country code, etc. But, different data sets usually provide data in different country data formats or attributes; for example, “Germany” can be recorded as “GER”, “Germany”, “DE”, “Federal Republic of Germany”, country code — 276, etc.). This would cause you some difficulties to join tables, data aggregation, data analysis, or data visualization.
This article introduces PyCountry, a Python library for completing the country data from the country database to ready your dataset to be matched or aggregated to others.
Let’s get started~
This short article will guide you how you can convert the .docx word document to the simple web page document (.html) or Markdown document (.md) in an easy way with some help of Python-based CLI — Mammoth.
According to the statistic from Statista survey (Jan 6, 2020), the Microsoft Office Suite is the most popular office software. You can easily take a quick note, short report, tutorial document, etc. with the Microsoft Word. And, you might want to share the document content with some of your friends, colleagues, clients as a web document (.html)) or Markdown document (.md). In the…
The recent technology of virtual globe-based 3D visualization is a unique opportunity to facilitate advanced analysis and visualization tasks in a variety of application domains such as urban planning, indoor/outdoor pedestrian navigation, environmental simulations, cultural heritage, or facility management. One core data which make this concept come true is the development of the CityGML models by Open Geospatial Consortium (OGC — https://www.ogc.org/). CityGML is the global data model schema for describing 3D geo-spatially-enabled urban models. There are more and more cities that provide open-source CityGML models publicly.
In Geospatial Data Science, the 3D data models recently play an important role in the research and visualization projects. QGIS is one of the most popular free and open-source cross-platform desktop GIS application software that every GIS geek knows. Since version 3.0 of the QGIS, a separate interface is responsible for 3D data visualization of the Point cloud and Digital Elevation Models. It’s called the 3D map view and is accessed from the View context menu.
However, the usual way the building- or city models had been visualized in the 3D GIS projects is by extruding the building footprints. This…
*Updated in Jan 2021
In the recent Geo Data Science projects, there are more and more uses of the semantical 3D city models or advanced analysis and visualization tasks in a variety of application domains such as urban planning, indoor/outdoor pedestrian navigation, environmental simulations, cultural heritage, or facility management .
One of the most popular data schemas is an OGC CityGML. The CityGML is the global data model schema for describing 3D geo-spatially-enabled urban models; developed by the OGC (open geospatial consortium). CityGML describes urban objects like buildings, roads, bridges, trees, etc. in 3D geographical space. CityGML urban object data…
In Data Science Project, UML Diagram is very essential to illustrate a conceptual model of your problem domains with the component- or class diagrams; or to show how your machine and algorithm works with the sequence- or activity diagrams. Some of you might draw this regularly on paper or using some software such as PWP or Adobe AI which causes you a headache sometimes if you not an expert.
Many online tools such as https://www.diagrams.net/ also allow you to draw the diagram but sometimes cause you much time to create a complex diagram. So, instead of drawing manually, this short…
In Data Science, after you are done with the data analysis you probably need to explore or show the result with some nice interactive data visualization tools. Of course, one of these tools would include the interactive map where you can hold your mouse of the area and explore the data value. But, this process consumes so much time to learn and do.
This article will show you an alternative way for you to do create an interactive map from your dataset using Google Sheets in 1 minute. …