The Geocoder 1939-1946 files includes the following elements:
- Geocoder_1939: geocoded shape file for 1939
- Geocoder_1939_Ext: geocoded shape file for the 1939 extra-settlement roads
- Geocoder_1946: geocoded shape 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 from our Locator file that serves to locate and place formatted addresses (see below) on the Geocoder. We used it only with ArcGIS. QGIS users may encounter problems using it.
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.
The shape files labeled Geocoder represent the street network of Shanghai, section by section, in 1939 (including a special file for the extra-settlement roads) and in 1946. They can be used separately . They constitute the basis for the reconstruction of the historical geocoding system of the city. Each section is numbered from the first door number to the last door number on the given section for each side of the street.
The names of the street are labelled as in the source in Chinese (source name and current name), English (International Settlement), and French (French Concession).
The attribute table contains the following fields:
| Field |
Definition |
| OBJECTID |
Identifier of the digital object |
| ID_ROW |
Identifier of the table row |
| FromLeft |
Horizontal street : First number of the section on the left side of the street (with the Bund or the next vertical street) as the point of departure; Vertical street : First number of the section on the left side of the street (with the Bund or the next vertical street) going north |
| ToLeft |
Last number of the section, going left from th ebeginning of the street |
| FromRight |
First number of the section, going from th ebeginning of the street |
| ToRight |
Last number of the section, going left from th ebeginning of the street |
| SH_NAME |
Name in English or French as in the source |
| TYPE_ST |
Type of thoroughfare as in the sources (street, avenue, rue, place, etc.) |
| FULL_NAME |
Full name of the thoroughfare (proper name and type) |
| CURRENT_NA |
Current name in pinyin |
| OLD_PINYIN |
Name in pinyin based on the Chinese name in the source |
| OCN |
Name in Chinese as in the source |
| NCN |
Current name in Chinese |
| REFNUM |
Year |
| REFNAME |
Year of the source |
| Shape_Leng |
Length of the section (meter) |
| City |
Name of the city |
| State |
Name of the country |
| Copyright |
Name of the copyright holder |
| Cartograph |
Name of the cartographer |
| License |
Legal definition of the license under which the shape file is made available |
Formatting addresses (Shanghai):
To be recognised by the Locator, addresses need to be formatted in the following way (examples):
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
This work is licensed under a Creative Commons Attribution 4.0 International License
| 
