GHCN v2.temperature.inv with GPW3 population density
Gridded population density data (pop/km^2) is available at http://sedac.ciesin.columbia.edu/gpw
Center for International Earth Science Information Network (CIESIN), Columbia University; and Centro Internacional de Agricultura Tropical (CIAT). 2005. Gridded Population of the World Version 3 (GPWv3): Population Density Grids. Palisades, NY: Socioeconomic Data and Applications Center (SEDAC), Columbia University.
GHCN station metatdata is available in the v2.temperature.inv file available from the GHCN ftp server: ftp://ftp.ncdc.noaa.gov/pub/data/ghcn/v2/
Here I have taken the station id, station name, latitude, longitude, and altitude from the GHCN metadata file and added a new column for population density from the GPW data. I used the adjusted data sets for the year 2000. The GPW coordinates are based on geographic coordinates of decimal degrees based on the World Geodetic System spheroid of 1984 (WGS84). I have not yet investigated the GHCN coordinate system.
There were 7280 unique records in the v2.temperature.inv file.
The initial run against the 2.5′ gridded data was able to match 6946 stations.
The remaining 334 were then run against the 15′ gridded data. 145 stations were matched at this resolution.
The remaining 189 stations were then run against the 60′ gridded data. This provided an additional 100 matches.
Of the remaining 89 stations, 14 are identified as ships. A significant number of the others are island locations.
The merged file is available here in semi-colon delimited format.
Column names are not included: id, name, lat, long, alt, popdensity
The intermediate files here:
Most dense population? Bombay / Cola at 50607.97 people / km ^2
20743057000 BOMBAY / COLA 18.90 72.82 11 1U 5971FLxxCO 1x-9WATER C
This also shows the affect of gridding
For the coordinates 18.90 72.82 at 2.5′ resolution: 50607.97 people / km ^2
For the coordinates 18.90 72.82 at 15′ resolution: 22378.56 people / km ^2
For the coordinates 18.90 72.82 at 60′ resolution: 4773.45 people / km ^2