Night lights along the PL-DE border 1992-2012

The datasets and software code (in the form of STATA dofiles) relate to the publication in Applied Economics entitled: "Lights along the frontier: convergence of economic activity in the proximity of the Polish-German border, 1992-2012". The analysis dataset in STATA format is created by combining data coming from: 1) NOAA Version 4 DMSP-OLS Nighttime Lights Time Series (https://ngdc.noaa.gov/eog/dmsp/downloadV4composites.html); 2) Map data copyrighted OpenStreetMap (OSM) contributors and available from https://www.openstreetmap.org; 3) Administrative division of Poland, municipality level Shapefiles for 2018, PRG (http://www.gugik.gov.pl/pzgik/dane-bez-oplat/dane-z-panstwowego-rejestru-granic-i-powierzchni-jednostek-podzialow-terytorialnych-kraju-prg); 4) Map of the municipalities and districts of Germany as of 31.12.2013, VG250 and VG250-EW, © GeoBasis-DE / BKG 2013 (https://gdz.bkg.bund.de/); Geographical data (nighttime lights, municipality borders for Poland and Germany and OpenStreetMap data) have been imported into PostgreSQL database using PostGIS plugin using batch processing in Python. Nighttime intensities for municipalities were created by intersecting vector municipality borders and raster lights data for each avaliable year and satelite. Light totals and averages were calculated using calibrated pixel values using 2nd deg. polynominal intercalibration parameters from Elvidge et al., National Trends in Satellite Observed Lighting: 1992-2009. Bridge crossings were identified using contemporary map data and OSM. OSM data were used to calculate road travel times and distances using pgRouting in PostgreSQL. Data were exported into CSV using Python and imported and merged in Stata, creating the initial dataset.本数据集及配套代码（以STATA do文件形式呈现）与发表于《应用经济学（Applied Economics）》期刊的论文《边境沿线之光：1992-2012年波德边境附近经济活动的趋同》（英文原标题："Lights along the frontier: convergence of economic activity in the proximity of the Polish-German border, 1992-2012"）相关。 本STATA格式分析数据集通过整合以下四类数据构建而成：1）美国国家海洋和大气管理局（NOAA）第4版DMSP-OLS夜间灯光时间序列数据（获取地址：https://ngdc.noaa.gov/eog/dmsp/downloadV4composites.html）；2）由开放街道地图（OpenStreetMap, OSM）贡献者创作并发布的地图数据，获取地址为https://www.openstreetmap.org；3）2018年波兰市级行政区划矢量形状文件（PRG，即波兰国家边界与领土划分单位登记数据，来源：http://www.gugik.gov.pl/pzgik/dane-bez-oplat/dane-z-panstwowego-rejestru-granic-i-powierzchni-jednostek-podzialow-terytorialnych-kraju-prg）；4）2013年12月31日版德国市县行政区划地图（VG250及VG250-EW），© GeoBasis-DE / 德国联邦测量与大地测量办公室（BKG）2013，获取地址：https://gdz.bkg.bund.de/。 地理数据（含夜间灯光数据、波德两国市级行政边界数据及开放街道地图数据）已通过Python批量处理结合PostGIS插件导入PostgreSQL数据库。通过对各可用年份及传感器对应的矢量市级边界与栅格灯光数据进行空间相交处理，得到各市级单元的夜间灯光强度数据；基于Elvidge等人在《1992-2009年卫星观测灯光的全国趋势》研究中提出的二阶多项式校准参数对像素值进行校准，随后计算各单元的灯光总量与平均值。过境桥梁通过现代地图数据及开放街道地图数据识别得到。利用PostgreSQL中的pgRouting工具，基于开放街道地图数据计算道路通行时长与距离。最终通过Python将数据导出为CSV格式，再在STATA中完成数据导入与合并，生成初始分析数据集。