Convert Two-dimensional Table to One-dimensional Table

The test data is 2D data:

Test data

To convert two-dimensional table to one-dimensional table in JavaScript:

Read More

Load External Geojson to Leaflet

Geojson benefits the geo-data visualzing. Here we introduce two methods of loading external geojson to Leaflet.

Read More

Install Geopandas

GeoPandas provides extension to pandas. It makes geo-data processing and geo-visualization much easier. geojson can be parsed and visualized easily.

Read More

Multiple Linear Regression in R

Math model

Y = a1*X1 + a2*X2 + a3*X3 + ... + an*Xn + b

Read More

Spatial polygon area calculation by another polygon layer

Topic description

I have two polygon layers in the same region: 1) data layer, the area of the polygons needs to be calculated, 2) reference layer, the polygons in this layer will be used as statistic units.

Read More

How to Draw Interactive Steamgraph in R

Streamgraph is a type of stacked area graph which is displaced around a central axis, resulting in a flowing, organic shape. Streamgraphs and their use were popularized by Lee Byron in a February 2008 New York Times article on movie box office revenues.

Read More

Extract Column from Tables

Problem description

I have some census data, which are 20 excel files for 20 year respectively (1980 - 1999). Each of the files contains county names and corresponding census data, e.g., GRDP, population, education.

Read More

Leaflet Overlay OnEachFeature

When you are displaying geojson with leaflet overlays, onEachFeature is a function will be applied on each feature, e.g. a point or a polygon in a features collection.

Read More

Control Leadlet Overlays

Adding several lays to leaflet and display the basic information of the layers on the map is very useful. Leaflet provaided lots handy APIs.

Read More

ArcGIS_admin Python Module is Online

When I was working in Esri Deutshcland in November and December 2017 as a working student, my job is scripting for ArcGIS Pro User Management.

Before I got the job, I was temporarily living in Frankfurt am Main. While Esri Deutshcland located in a small village close to Munich, it takes quite a while to go from Munich to there. Although the interview was scheduled at 1 pm, I needed to leave Munich at 8 am. The earliest ICE (German high speed train) from Frankfurt am Main to Munich would arrive in Munich at 9 am. The only option left was over-night bus.

Read More