Estelle Senna & Charlotte Aubrun
1/1/2014

Set of geocoding rules tested.
Remember to use Locator1939 as the best tool to locate addresses.

Christian Henriot
12/10/2022

The Geocoder 1939-1946 folder includes the following files
- Geocoder_1939: geocoded file for 1939
- Geocoder_1939_Ext: geocoded file for 1939 extra-settlement roads
- Geocoder_1946: geocoded file for 1946
- addresses: this is the file that contains all the recorded  street numbers in the Geocoder
- Loc_Address1939, Loc_SideStreets1939, Loc_Streets1939: this is a set of files that form our Locator file that serves to locate and place formatted addresses (see below) on the Geocoder.

The Geocoder was created on the basis of the street grid and street numbers in the following sources:

Shanghai shi hanghao lutu lu 上海市行號路圖錄. Vol. 1‑2. Shanghai 上海: Fuli wenhua shiye youxian gongsi 福利文化事業有限公司, 1939.

Shanghai shi hanghao lutu lu 上海市行號路圖錄. Vol. 1‑2. Shanghai 上海: Fuli wenhua shiye youxian gongsi 福利文化事業有限公司, 1947.


Formatting addresses (Shanghai):

To be recognised by the Locator, addresses need to be formatted in the following way:

1262 AVENUE ROAD Shanghai, CHINA
126 BOONE Shanghai, CHINA
242 BROADWAY ROAD Shanghai, CHINA
150 BUBBILNG WELL Shanghai, CHINA
25 RUE CONSULAT Shanghai, CHINA
53 ROUTE CORDIER Shanghai, CHINA
23 RUE CORNEILLE Shanghai, CHINA
2 RUE CORNEILLE Shanghai, CHINA
10 RUE COURBET Shanghai, CHINA

This is due to the fact that we used a Google maps-based rule. When recording the initial data, we recommend that the various elements be recorded in separate columns:

Street number	Type	Street name
23		RUE	CONSULAT
136		ROAD	CANTON

It is easy to concatenate the data in a single column to produce an address such as:

23 RUE CONSULAT
136 CANTON ROAD	

Prepare a City column like this:

Shanghai, CHINA

Then do a final concatenation of the complete string

23 RUE	CONSULAT Shanghai, CHINA
136 CANTON ROAD	Shanghai, CHINA