Build up Webmapping Environment on Windows

This blog is about how to do web mapping with local database and server.


  • Java
  • Apache Tomcat

Read More

Start a Local Server with Python3

Python3 changed the SimpleHTTPServer. To use it, see as followed:

  1. Open cmd on the folder you would like to start a server

Read More

How to automatically vectorize raster images with Arcgis

Tool: ArcGIS Pro Desktop 2.1
Original data: 9 grayscale images in Shanghai area

Read More

Pandas DataFrame Row Slicing by Value from another Table

There are field_1 in both tables, we want to get rows field_3 from table_2 if the field_1 shows in Table_1.

Read More

Python Nested Class

What I want to do, is to have a hierarchically organized Python Class. I wanted to pass the outer class instance vatible to inner class. Like:

Read More

GIS Object Has No Attribute 'admin'

ArcGIS Python API

The ArcGIS API for Python is a powerful, modern and easy to use Pythonic library to perform GIS visualization and analysis, spatial data management and GIS system administration tasks that can run both in an interactive fashion, as well as using scripts.

Read More

Python Logging to Console and External File


Logging to multiple destinations with different levels.

Read More

Some Useful Packages in Latex

  • Color control


Read More

Extract Hour Field from Text under Database(PostgreSQL)

What to Extract?

We have a text file, which including texts, numbers and time. We want to extract some time information, for instance hour field from the whole data.

Read More

Including Chinese Charaters in Latex

Building System

Using xelatex instead of pdf to build the document. Adding below codes at the first line to change build system.

Read More