An Easy Way to Draw Study Area

There are many ways to draw a map.

  • ArcGIS, QGIS
    With ArcGIS and QGIS, firstly we need a shapefile of target area.

Read More

Text Comparision with Sublime

Sublimerge is a sublime tool used for text comparision.

Installation

    Read More

    Table Deduplication with Postgresql

    ctid

    Every table has several system columns that are implicitly defined by the system.
    ctid, the physical location of the row version within its table. Note that although the ctid can be used to locate the row version very quickly, a row’s ctid will change each time it is updated or moved by VACUUM FULL. Therefore ctid is useless as a long-term row identifier. The OID, or even better a user-defined serial number, should be used to identify logical rows.

    Read More

    Using Regular Expression to Filter Chinese

    Regular expression is used for pattern matching. It’s a powerful and handy tool for text filteration.

    Read More

    Python Encoding System

    When dealing with Chinese characters, decoding disorder might be a normal problem, espatially, with cross platform development.

    Some error like:

    Read More

    How to Make Slides with CSS

    impress.js is a presentation framework based on the power of CSS3 transforms and transitions in modern browsers and inspired by the idea behind prezi.com.

    Read More

    How to Use Raphaël to Create Responsive SVG

    Raphaël is a small JavaScript library that should simplify your work with vector graphics on the web.
    It uses SVG for creating graphics.

    Read More

    Postgres Load Data and Query

    Load data

    pgcsv is used for load csv data into Postgres.

    Read More

    Hot Keys for Vim

    Hot keys

    Just some Vim essential notes for learning use. :)


    Read More

    Convert Datetime To Timestamp in Python

    What is Timestamp

    The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC.

    Read More