"# Merge roofs with shading info and roofs with panelled area info"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
- "### Step 1: get roofs for training set\n",
- "By merging the roofs_w_panels and the area of the gva_shp, we get a dataframe that contains all rooftops who's footprint overlaps with the SITG roof information for which superstructure information is available (all roofs where area_with_SP == area_without_SP are excluded!!!). To complement the superstructure information, all roof surfaces smaller than 8m^2 in SITG were also categorized as superstructures."
+ "### Step 1: get roofs for training set (roofs with target information available)\n",
+ "The for training, all roofs which have a \"raw\" panelled area ratio (feature, computed from the full roofs) > 0 and which are represented in the target dataset (GVA canton) are considered."
]
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": 13,
"metadata": {},
- "outputs": [],
- "source": [
- "training_roofs = pd.merge(GVA_roofs_all, GVA_roof_corners, how = 'inner', on = 'DF_UID')"
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 6,
- "metadata": {
- "scrolled": false
- },
- "outputs": [
- {
- "data": {
- "text/html": [
- "<div>\n",
- "<style scoped>\n",
- " .dataframe tbody tr th:only-of-type {\n",
- " vertical-align: middle;\n",
- " }\n",
- "\n",
- " .dataframe tbody tr th {\n",
- " vertical-align: top;\n",
- " }\n",
- "\n",
- " .dataframe thead th {\n",
- " text-align: right;\n",
- " }\n",
- "</style>\n",
- "<table border=\"1\" class=\"dataframe\">\n",
- " <thead>\n",
- " <tr style=\"text-align: right;\">\n",
- " <th></th>\n",
- " <th>DF_UID</th>\n",
- " <th>FLAECHE</th>\n",
- " <th>NEIGUNG</th>\n",
- " <th>AUSRICHTUNG</th>\n",
- " <th>XCOORD</th>\n",
- " <th>YCOORD</th>\n",
- " <th>Shape_Length</th>\n",
- " <th>Shape_Area</th>\n",
- " <th>GWR_EGID</th>\n",
- " <th>GBAUP</th>\n",
- " <th>GKAT</th>\n",
- " <th>GAREA</th>\n",
- " <th>GASTW</th>\n",
- " <th>GKODX</th>\n",
- " <th>GKODY</th>\n",
- " <th>Shape_Ratio</th>\n",
- " <th>n_neighbors_100</th>\n",
- " <th>Estim_build_area</th>\n",
- " <th>n_corners</th>\n",
- " </tr>\n",
- " </thead>\n",
- " <tbody>\n",
- " <tr>\n",
- " <th>0</th>\n",
- " <td>4817410.0</td>\n",
- " <td>71.487047</td>\n",
- " <td>10.0</td>\n",
- " <td>127.0</td>\n",
- " <td>503491.325015</td>\n",
- " <td>134197.490397</td>\n",
- " <td>33.936595</td>\n",
- " <td>70.390620</td>\n",
- " <td>295070969.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>44.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503491.0</td>\n",
- " <td>134198.0</td>\n",
- " <td>0.474724</td>\n",
- " <td>3.0</td>\n",
- " <td>70.400998</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>1</th>\n",
- " <td>4817425.0</td>\n",
- " <td>36.859836</td>\n",
- " <td>37.0</td>\n",
- " <td>33.0</td>\n",
- " <td>503503.812619</td>\n",
- " <td>134131.833522</td>\n",
- " <td>28.208608</td>\n",
- " <td>29.339500</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>0.765294</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>2</th>\n",
- " <td>4817426.0</td>\n",
- " <td>51.333864</td>\n",
- " <td>31.0</td>\n",
- " <td>-57.0</td>\n",
- " <td>503509.783165</td>\n",
- " <td>134135.282805</td>\n",
- " <td>40.053428</td>\n",
- " <td>44.043504</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>0.780254</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>7</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>3</th>\n",
- " <td>4817427.0</td>\n",
- " <td>36.861447</td>\n",
- " <td>37.0</td>\n",
- " <td>-147.0</td>\n",
- " <td>503510.594159</td>\n",
- " <td>134142.188986</td>\n",
- " <td>28.210273</td>\n",
- " <td>29.341346</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>0.765306</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>4</th>\n",
- " <td>4817428.0</td>\n",
- " <td>81.256555</td>\n",
- " <td>28.0</td>\n",
- " <td>123.0</td>\n",
- " <td>503504.226918</td>\n",
- " <td>134138.960671</td>\n",
- " <td>37.840077</td>\n",
- " <td>71.574129</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>0.465686</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>5</th>\n",
- " <td>4817429.0</td>\n",
- " <td>11.397236</td>\n",
- " <td>27.0</td>\n",
- " <td>-144.0</td>\n",
- " <td>503512.070989</td>\n",
- " <td>134135.795686</td>\n",
- " <td>15.417311</td>\n",
- " <td>10.154872</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>1.352724</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>6</th>\n",
- " <td>4817430.0</td>\n",
- " <td>11.262413</td>\n",
- " <td>27.0</td>\n",
- " <td>31.0</td>\n",
- " <td>503510.350525</td>\n",
- " <td>134133.126967</td>\n",
- " <td>15.346288</td>\n",
- " <td>10.045172</td>\n",
- " <td>1004090.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>152.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503507.0</td>\n",
- " <td>134137.0</td>\n",
- " <td>1.362611</td>\n",
- " <td>3.0</td>\n",
- " <td>194.813319</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>7</th>\n",
- " <td>4817431.0</td>\n",
- " <td>174.501987</td>\n",
- " <td>31.0</td>\n",
- " <td>-147.0</td>\n",
- " <td>503503.978942</td>\n",
- " <td>134181.171146</td>\n",
- " <td>59.815925</td>\n",
- " <td>149.165008</td>\n",
- " <td>1004088.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>206.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503503.0</td>\n",
- " <td>134179.0</td>\n",
- " <td>0.342781</td>\n",
- " <td>3.0</td>\n",
- " <td>298.817334</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>8</th>\n",
- " <td>4817432.0</td>\n",
- " <td>174.108293</td>\n",
- " <td>31.0</td>\n",
- " <td>33.0</td>\n",
- " <td>503500.517066</td>\n",
- " <td>134175.889168</td>\n",
- " <td>59.775896</td>\n",
- " <td>148.702405</td>\n",
- " <td>1004088.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>206.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503503.0</td>\n",
- " <td>134179.0</td>\n",
- " <td>0.343326</td>\n",
- " <td>3.0</td>\n",
- " <td>298.817334</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>9</th>\n",
- " <td>4817433.0</td>\n",
- " <td>69.216255</td>\n",
- " <td>26.0</td>\n",
- " <td>33.0</td>\n",
- " <td>503510.917446</td>\n",
- " <td>134191.713704</td>\n",
- " <td>45.633223</td>\n",
- " <td>61.997846</td>\n",
- " <td>295084893.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>100.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503512.0</td>\n",
- " <td>134193.0</td>\n",
- " <td>0.659285</td>\n",
- " <td>3.0</td>\n",
- " <td>107.414054</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>10</th>\n",
- " <td>4817434.0</td>\n",
- " <td>26.716480</td>\n",
- " <td>31.0</td>\n",
- " <td>-147.0</td>\n",
- " <td>503517.020358</td>\n",
- " <td>134191.118711</td>\n",
- " <td>23.687927</td>\n",
- " <td>22.959133</td>\n",
- " <td>295084893.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>100.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503512.0</td>\n",
- " <td>134193.0</td>\n",
- " <td>0.886641</td>\n",
- " <td>3.0</td>\n",
- " <td>107.414054</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>11</th>\n",
- " <td>4817435.0</td>\n",
- " <td>26.018729</td>\n",
- " <td>31.0</td>\n",
- " <td>-147.0</td>\n",
- " <td>503507.806109</td>\n",
- " <td>134197.114437</td>\n",
- " <td>23.199036</td>\n",
- " <td>22.360589</td>\n",
- " <td>295084893.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>100.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503512.0</td>\n",
- " <td>134193.0</td>\n",
- " <td>0.891628</td>\n",
- " <td>3.0</td>\n",
- " <td>107.414054</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>12</th>\n",
- " <td>4817436.0</td>\n",
- " <td>13.309012</td>\n",
- " <td>33.0</td>\n",
- " <td>123.0</td>\n",
- " <td>503512.471353</td>\n",
- " <td>134196.622116</td>\n",
- " <td>15.096068</td>\n",
- " <td>11.164928</td>\n",
- " <td>295084893.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>100.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503512.0</td>\n",
- " <td>134193.0</td>\n",
- " <td>1.134274</td>\n",
- " <td>3.0</td>\n",
- " <td>22.613146</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>13</th>\n",
- " <td>4817437.0</td>\n",
- " <td>13.503089</td>\n",
- " <td>32.0</td>\n",
- " <td>-57.0</td>\n",
- " <td>503514.586126</td>\n",
- " <td>134195.245953</td>\n",
- " <td>15.198331</td>\n",
- " <td>11.396747</td>\n",
- " <td>295084893.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>100.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503512.0</td>\n",
- " <td>134193.0</td>\n",
- " <td>1.125545</td>\n",
- " <td>3.0</td>\n",
- " <td>22.613146</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>14</th>\n",
- " <td>4817438.0</td>\n",
- " <td>130.038144</td>\n",
- " <td>26.0</td>\n",
- " <td>-144.0</td>\n",
- " <td>503951.193324</td>\n",
- " <td>134195.306644</td>\n",
- " <td>64.584475</td>\n",
- " <td>117.365353</td>\n",
- " <td>295084994.0</td>\n",
- " <td>8014.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>213.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503949.0</td>\n",
- " <td>134194.0</td>\n",
- " <td>0.496658</td>\n",
- " <td>5.0</td>\n",
- " <td>230.552584</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>15</th>\n",
- " <td>4817439.0</td>\n",
- " <td>126.475108</td>\n",
- " <td>26.0</td>\n",
- " <td>36.0</td>\n",
- " <td>503948.788882</td>\n",
- " <td>134191.981218</td>\n",
- " <td>64.301850</td>\n",
- " <td>113.406403</td>\n",
- " <td>295084994.0</td>\n",
- " <td>8014.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>213.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503949.0</td>\n",
- " <td>134194.0</td>\n",
- " <td>0.508415</td>\n",
- " <td>5.0</td>\n",
- " <td>230.552584</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>16</th>\n",
- " <td>4817440.0</td>\n",
- " <td>47.540096</td>\n",
- " <td>37.0</td>\n",
- " <td>-144.0</td>\n",
- " <td>503996.949571</td>\n",
- " <td>134161.244934</td>\n",
- " <td>27.081498</td>\n",
- " <td>37.981483</td>\n",
- " <td>1004076.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>66.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504005.0</td>\n",
- " <td>134153.0</td>\n",
- " <td>0.569656</td>\n",
- " <td>7.0</td>\n",
- " <td>68.070576</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>17</th>\n",
- " <td>4817441.0</td>\n",
- " <td>35.497241</td>\n",
- " <td>32.0</td>\n",
- " <td>36.0</td>\n",
- " <td>503994.863047</td>\n",
- " <td>134158.375583</td>\n",
- " <td>25.402378</td>\n",
- " <td>29.945648</td>\n",
- " <td>1004076.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>66.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504005.0</td>\n",
- " <td>134153.0</td>\n",
- " <td>0.715616</td>\n",
- " <td>7.0</td>\n",
- " <td>68.070576</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>18</th>\n",
- " <td>4817442.0</td>\n",
- " <td>49.847956</td>\n",
- " <td>38.0</td>\n",
- " <td>36.0</td>\n",
- " <td>504003.468131</td>\n",
- " <td>134152.306087</td>\n",
- " <td>29.835723</td>\n",
- " <td>39.429900</td>\n",
- " <td>1004076.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>66.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504005.0</td>\n",
- " <td>134153.0</td>\n",
- " <td>0.598535</td>\n",
- " <td>7.0</td>\n",
- " <td>96.433564</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>19</th>\n",
- " <td>4817443.0</td>\n",
- " <td>74.607733</td>\n",
- " <td>40.0</td>\n",
- " <td>-144.0</td>\n",
- " <td>504005.947778</td>\n",
- " <td>134155.715627</td>\n",
- " <td>32.967494</td>\n",
- " <td>57.409186</td>\n",
- " <td>1004076.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>66.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504005.0</td>\n",
- " <td>134153.0</td>\n",
- " <td>0.441878</td>\n",
- " <td>7.0</td>\n",
- " <td>96.433564</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>20</th>\n",
- " <td>4817444.0</td>\n",
- " <td>12.607657</td>\n",
- " <td>0.0</td>\n",
- " <td>0.0</td>\n",
- " <td>503991.439805</td>\n",
- " <td>134163.317363</td>\n",
- " <td>17.745074</td>\n",
- " <td>12.607657</td>\n",
- " <td>1004076.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>66.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504005.0</td>\n",
- " <td>134153.0</td>\n",
- " <td>1.407484</td>\n",
- " <td>7.0</td>\n",
- " <td>12.607657</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>21</th>\n",
- " <td>4817445.0</td>\n",
- " <td>9.973655</td>\n",
- " <td>29.0</td>\n",
- " <td>-55.0</td>\n",
- " <td>503926.571766</td>\n",
- " <td>134212.338837</td>\n",
- " <td>14.288661</td>\n",
- " <td>8.760702</td>\n",
- " <td>1004089.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>57.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503922.0</td>\n",
- " <td>134215.0</td>\n",
- " <td>1.432640</td>\n",
- " <td>4.0</td>\n",
- " <td>78.634747</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>22</th>\n",
- " <td>4817446.0</td>\n",
- " <td>34.666521</td>\n",
- " <td>29.0</td>\n",
- " <td>35.0</td>\n",
- " <td>503921.018886</td>\n",
- " <td>134214.298798</td>\n",
- " <td>29.015856</td>\n",
- " <td>30.403885</td>\n",
- " <td>1004089.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>57.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503922.0</td>\n",
- " <td>134215.0</td>\n",
- " <td>0.836999</td>\n",
- " <td>4.0</td>\n",
- " <td>78.634747</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>23</th>\n",
- " <td>4817447.0</td>\n",
- " <td>9.971017</td>\n",
- " <td>29.0</td>\n",
- " <td>125.0</td>\n",
- " <td>503917.347567</td>\n",
- " <td>134218.902400</td>\n",
- " <td>14.287157</td>\n",
- " <td>8.757635</td>\n",
- " <td>1004089.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>57.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503922.0</td>\n",
- " <td>134215.0</td>\n",
- " <td>1.432869</td>\n",
- " <td>4.0</td>\n",
- " <td>78.634747</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>24</th>\n",
- " <td>4817448.0</td>\n",
- " <td>34.963254</td>\n",
- " <td>28.0</td>\n",
- " <td>-145.0</td>\n",
- " <td>503922.898105</td>\n",
- " <td>134216.939359</td>\n",
- " <td>29.062031</td>\n",
- " <td>30.741322</td>\n",
- " <td>1004089.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>57.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503922.0</td>\n",
- " <td>134215.0</td>\n",
- " <td>0.831216</td>\n",
- " <td>4.0</td>\n",
- " <td>78.634747</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>25</th>\n",
- " <td>4817449.0</td>\n",
- " <td>19.979434</td>\n",
- " <td>7.0</td>\n",
- " <td>35.0</td>\n",
- " <td>503916.075512</td>\n",
- " <td>134213.701005</td>\n",
- " <td>17.895750</td>\n",
- " <td>19.831984</td>\n",
- " <td>1004089.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>57.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503922.0</td>\n",
- " <td>134215.0</td>\n",
- " <td>0.895709</td>\n",
- " <td>4.0</td>\n",
- " <td>19.830510</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>26</th>\n",
- " <td>4817450.0</td>\n",
- " <td>21.119847</td>\n",
- " <td>18.0</td>\n",
- " <td>-144.0</td>\n",
- " <td>503936.461763</td>\n",
- " <td>134203.761986</td>\n",
- " <td>18.414721</td>\n",
- " <td>20.066844</td>\n",
- " <td>295084994.0</td>\n",
- " <td>8014.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>213.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503949.0</td>\n",
- " <td>134194.0</td>\n",
- " <td>0.871915</td>\n",
- " <td>5.0</td>\n",
- " <td>40.296071</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>27</th>\n",
- " <td>4817451.0</td>\n",
- " <td>21.374411</td>\n",
- " <td>19.0</td>\n",
- " <td>36.0</td>\n",
- " <td>503934.470464</td>\n",
- " <td>134200.829905</td>\n",
- " <td>19.727025</td>\n",
- " <td>20.261942</td>\n",
- " <td>295084994.0</td>\n",
- " <td>8014.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>213.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>503949.0</td>\n",
- " <td>134194.0</td>\n",
- " <td>0.922927</td>\n",
- " <td>5.0</td>\n",
- " <td>40.296071</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>28</th>\n",
- " <td>4817452.0</td>\n",
- " <td>68.854261</td>\n",
- " <td>35.0</td>\n",
- " <td>-140.0</td>\n",
- " <td>504222.101990</td>\n",
- " <td>134017.187739</td>\n",
- " <td>31.767443</td>\n",
- " <td>56.268749</td>\n",
- " <td>1004049.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>67.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504220.0</td>\n",
- " <td>134015.0</td>\n",
- " <td>0.461372</td>\n",
- " <td>25.0</td>\n",
- " <td>99.757951</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>29</th>\n",
- " <td>4817453.0</td>\n",
- " <td>52.296595</td>\n",
- " <td>34.0</td>\n",
- " <td>40.0</td>\n",
- " <td>504219.058562</td>\n",
- " <td>134013.574920</td>\n",
- " <td>29.327904</td>\n",
- " <td>43.406040</td>\n",
- " <td>1004049.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>67.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>504220.0</td>\n",
- " <td>134015.0</td>\n",
- " <td>0.560799</td>\n",
- " <td>25.0</td>\n",
- " <td>99.757951</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>...</th>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " <td>...</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206432</th>\n",
- " <td>5124497.0</td>\n",
- " <td>139.413591</td>\n",
- " <td>30.0</td>\n",
- " <td>-60.0</td>\n",
- " <td>512727.853591</td>\n",
- " <td>121799.313992</td>\n",
- " <td>54.005430</td>\n",
- " <td>120.493402</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>0.387376</td>\n",
- " <td>3.0</td>\n",
- " <td>239.840444</td>\n",
- " <td>9</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206433</th>\n",
- " <td>5124498.0</td>\n",
- " <td>137.530298</td>\n",
- " <td>30.0</td>\n",
- " <td>120.0</td>\n",
- " <td>512722.012941</td>\n",
- " <td>121802.781737</td>\n",
- " <td>53.905711</td>\n",
- " <td>119.641777</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>0.391955</td>\n",
- " <td>3.0</td>\n",
- " <td>239.840444</td>\n",
- " <td>9</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206434</th>\n",
- " <td>5124499.0</td>\n",
- " <td>92.630815</td>\n",
- " <td>7.0</td>\n",
- " <td>-150.0</td>\n",
- " <td>512731.300787</td>\n",
- " <td>121811.881398</td>\n",
- " <td>47.143675</td>\n",
- " <td>91.927158</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>0.508942</td>\n",
- " <td>3.0</td>\n",
- " <td>91.940359</td>\n",
- " <td>8</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206435</th>\n",
- " <td>5124500.0</td>\n",
- " <td>44.081253</td>\n",
- " <td>7.0</td>\n",
- " <td>-148.0</td>\n",
- " <td>512734.614676</td>\n",
- " <td>121817.612632</td>\n",
- " <td>28.618486</td>\n",
- " <td>43.718502</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>0.649221</td>\n",
- " <td>3.0</td>\n",
- " <td>43.752678</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206436</th>\n",
- " <td>5124501.0</td>\n",
- " <td>12.602429</td>\n",
- " <td>0.0</td>\n",
- " <td>0.0</td>\n",
- " <td>512727.537367</td>\n",
- " <td>121820.039977</td>\n",
- " <td>14.885065</td>\n",
- " <td>12.602429</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>1.181127</td>\n",
- " <td>3.0</td>\n",
- " <td>26.462734</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206437</th>\n",
- " <td>5124502.0</td>\n",
- " <td>14.119724</td>\n",
- " <td>11.0</td>\n",
- " <td>-147.0</td>\n",
- " <td>512729.165421</td>\n",
- " <td>121822.382400</td>\n",
- " <td>16.789635</td>\n",
- " <td>13.863595</td>\n",
- " <td>1018653.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>153.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512725.0</td>\n",
- " <td>121800.0</td>\n",
- " <td>1.189091</td>\n",
- " <td>3.0</td>\n",
- " <td>26.462734</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206438</th>\n",
- " <td>5124503.0</td>\n",
- " <td>36.753693</td>\n",
- " <td>21.0</td>\n",
- " <td>122.0</td>\n",
- " <td>512683.971180</td>\n",
- " <td>121769.079140</td>\n",
- " <td>23.556753</td>\n",
- " <td>34.231614</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.640936</td>\n",
- " <td>7.0</td>\n",
- " <td>68.582316</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206439</th>\n",
- " <td>5124504.0</td>\n",
- " <td>0.064896</td>\n",
- " <td>19.0</td>\n",
- " <td>-58.0</td>\n",
- " <td>512689.499215</td>\n",
- " <td>121759.357413</td>\n",
- " <td>8.350840</td>\n",
- " <td>0.061348</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>128.679441</td>\n",
- " <td>7.0</td>\n",
- " <td>68.582316</td>\n",
- " <td>3</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206440</th>\n",
- " <td>5124505.0</td>\n",
- " <td>36.179539</td>\n",
- " <td>19.0</td>\n",
- " <td>-58.0</td>\n",
- " <td>512689.565868</td>\n",
- " <td>121765.612262</td>\n",
- " <td>23.566963</td>\n",
- " <td>34.201265</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.651389</td>\n",
- " <td>7.0</td>\n",
- " <td>68.582316</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206441</th>\n",
- " <td>5124506.0</td>\n",
- " <td>57.609988</td>\n",
- " <td>17.0</td>\n",
- " <td>-57.0</td>\n",
- " <td>512685.874412</td>\n",
- " <td>121760.247993</td>\n",
- " <td>37.797327</td>\n",
- " <td>55.148314</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.656090</td>\n",
- " <td>7.0</td>\n",
- " <td>108.760020</td>\n",
- " <td>8</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206442</th>\n",
- " <td>5124507.0</td>\n",
- " <td>57.882063</td>\n",
- " <td>22.0</td>\n",
- " <td>122.0</td>\n",
- " <td>512679.975021</td>\n",
- " <td>121763.783138</td>\n",
- " <td>29.386703</td>\n",
- " <td>53.499302</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.507700</td>\n",
- " <td>7.0</td>\n",
- " <td>108.760020</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206443</th>\n",
- " <td>5124508.0</td>\n",
- " <td>35.898733</td>\n",
- " <td>22.0</td>\n",
- " <td>-153.0</td>\n",
- " <td>512676.571716</td>\n",
- " <td>121745.126015</td>\n",
- " <td>30.833490</td>\n",
- " <td>33.393443</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.858902</td>\n",
- " <td>7.0</td>\n",
- " <td>116.033907</td>\n",
- " <td>7</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206444</th>\n",
- " <td>5124509.0</td>\n",
- " <td>88.059840</td>\n",
- " <td>20.0</td>\n",
- " <td>27.0</td>\n",
- " <td>512674.020870</td>\n",
- " <td>121740.921893</td>\n",
- " <td>39.260540</td>\n",
- " <td>82.722458</td>\n",
- " <td>2040405.0</td>\n",
- " <td>8012.0</td>\n",
- " <td>1021.0</td>\n",
- " <td>129.000000</td>\n",
- " <td>3.0</td>\n",
- " <td>512678.0</td>\n",
- " <td>121753.0</td>\n",
- " <td>0.445839</td>\n",
- " <td>7.0</td>\n",
- " <td>116.033907</td>\n",
- " <td>8</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206445</th>\n",
- " <td>5124510.0</td>\n",
- " <td>234.137426</td>\n",
- " <td>15.0</td>\n",
- " <td>-139.0</td>\n",
- " <td>512576.260995</td>\n",
- " <td>121776.663075</td>\n",
- " <td>66.560300</td>\n",
- " <td>226.093454</td>\n",
- " <td>1018659.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>449.601882</td>\n",
- " <td>2.0</td>\n",
- " <td>512596.0</td>\n",
- " <td>121754.0</td>\n",
- " <td>0.284279</td>\n",
- " <td>7.0</td>\n",
- " <td>449.601882</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206446</th>\n",
- " <td>5124511.0</td>\n",
- " <td>232.447102</td>\n",
- " <td>16.0</td>\n",
- " <td>41.0</td>\n",
- " <td>512570.079754</td>\n",
- " <td>121769.520367</td>\n",
- " <td>66.292584</td>\n",
- " <td>222.913017</td>\n",
- " <td>1018659.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1030.0</td>\n",
- " <td>449.601882</td>\n",
- " <td>2.0</td>\n",
- " <td>512596.0</td>\n",
- " <td>121754.0</td>\n",
- " <td>0.285194</td>\n",
- " <td>7.0</td>\n",
- " <td>449.601882</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206447</th>\n",
- " <td>5124512.0</td>\n",
- " <td>131.925651</td>\n",
- " <td>29.0</td>\n",
- " <td>121.0</td>\n",
- " <td>512861.419320</td>\n",
- " <td>121844.774678</td>\n",
- " <td>55.702429</td>\n",
- " <td>114.847781</td>\n",
- " <td>1018654.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>304.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>512862.0</td>\n",
- " <td>121841.0</td>\n",
- " <td>0.422226</td>\n",
- " <td>2.0</td>\n",
- " <td>236.648087</td>\n",
- " <td>5</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206448</th>\n",
- " <td>5124513.0</td>\n",
- " <td>137.339196</td>\n",
- " <td>28.0</td>\n",
- " <td>-59.0</td>\n",
- " <td>512865.854189</td>\n",
- " <td>121842.120366</td>\n",
- " <td>56.243851</td>\n",
- " <td>121.027343</td>\n",
- " <td>1018654.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>304.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>512862.0</td>\n",
- " <td>121841.0</td>\n",
- " <td>0.409525</td>\n",
- " <td>2.0</td>\n",
- " <td>236.648087</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206449</th>\n",
- " <td>5124514.0</td>\n",
- " <td>21.008432</td>\n",
- " <td>23.0</td>\n",
- " <td>-150.0</td>\n",
- " <td>512862.686744</td>\n",
- " <td>121857.263294</td>\n",
- " <td>23.119281</td>\n",
- " <td>19.328343</td>\n",
- " <td>1018654.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>304.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>512862.0</td>\n",
- " <td>121841.0</td>\n",
- " <td>1.100476</td>\n",
- " <td>2.0</td>\n",
- " <td>39.706122</td>\n",
- " <td>6</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206450</th>\n",
- " <td>5124515.0</td>\n",
- " <td>21.541363</td>\n",
- " <td>19.0</td>\n",
- " <td>30.0</td>\n",
- " <td>512860.734800</td>\n",
- " <td>121855.152708</td>\n",
- " <td>19.585625</td>\n",
- " <td>20.336518</td>\n",
- " <td>1018654.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>304.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>512862.0</td>\n",
- " <td>121841.0</td>\n",
- " <td>0.909210</td>\n",
- " <td>2.0</td>\n",
- " <td>39.706122</td>\n",
- " <td>4</td>\n",
- " </tr>\n",
- " <tr>\n",
- " <th>206451</th>\n",
- " <td>5124516.0</td>\n",
- " <td>33.342276</td>\n",
- " <td>17.0</td>\n",
- " <td>-58.0</td>\n",
- " <td>512857.342542</td>\n",
- " <td>121829.041410</td>\n",
- " <td>24.377198</td>\n",
- " <td>31.954253</td>\n",
- " <td>1018654.0</td>\n",
- " <td>8011.0</td>\n",
- " <td>1025.0</td>\n",
- " <td>304.000000</td>\n",
- " <td>2.0</td>\n",
- " <td>512862.0</td>\n",
- " <td>121841.0</td>\n",
- " <td>0.731120</td>\n",
- " <td>2.0</td>\n",
- " <td>108.900435</td>\n",
- " <td>4</td>\n",
+ "outputs": [],
+ "source": [
+ "# merge panelled area ratio for training (GVA only, excluded superstrucutres)\n",
- "Add information of panelled area for Sonnendach roof polygons (ftr) and roof polygons with excluded superstructures (tgt). Note that CH_panels_ftr contains ALL rooftops and their panel_count information. For all roofs where panel_count == 0, we know already that there cannot be any panels fitted (due to geometry/size), neither vertically nor horizontally, so any calculation of available area for these rooftops is obsolete, i.e. the panels are excluded from further analysis."
- ]
- },
- {
- "cell_type": "code",
- "execution_count": 7,
- "metadata": {},
- "outputs": [],
- "source": [
- "# merge panelled area ratio for features (no superstructure excluded)\n",
- "### Step 3: Exclude roofs without superstructure data\n",
+ "### Step 2: Exclude roofs without superstructure data\n",
"The shapefiles of GVA / GVA_noSP can be use to check if the area was changed when superstructures were subtracted. In the cases where this was not the case, the respective roofs are removed from training - it is assumed that the dataset is incomplete and superstructures were not correctly registered rather than there are no superstructures that can be found on the roof. This may be a conservative estimate in some cases, which however is preferred to an overestimate. Uncertainty is to be quantified to assess the level of confidence"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [],
"source": [
"# extract area information from shapefiles\n",
"gva_all = gva_shp.loc[:,['DF_UID']]\n",
"gva_all['area_full'] = gva_shp.area\n",
"\n",
"gva_noSP = gva_shp_noSP.loc[:,['DF_UID']]\n",
"gva_noSP['area_noSP'] = gva_shp_noSP.area"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [],
"source": [
"# Merge information of areas wih and without superstructures; areas not found in gva_noSP are given area = 0\n",
"gva_data = gva_all.merge(gva_noSP, on = 'DF_UID', how = 'left')\n",
- "We notice that module efficiency, in the simplified model used here, is a linear function of the ambient temperature, and hence it is averaged across G_t\n",
- "At the same time, the inverter efficiency is *almost* a function of $G_t$, except for low temperatures. We create a weighted average for computing module efficiency as a function of $G_t$, using the histogram of ambient temperatures (see above) as weighting"
+ "/home/walch/miniconda3/envs/py3/lib/python3.6/site-packages/h5py/__init__.py:36: FutureWarning: Conversion of the second argument of issubdtype from `float` to `np.floating` is deprecated. In future, it will be treated as `np.float64 == np.dtype(float).type`.\n",
+ " from ._conv import register_converters as _register_converters\n"
+ "/home/walch/miniconda3/envs/py3/lib/python3.6/site-packages/numpy/lib/arraysetops.py:463: FutureWarning: elementwise comparison failed; returning scalar instead, but in the future will perform elementwise comparison\n",
"/home/walch/miniconda3/envs/py3/lib/python3.6/site-packages/h5py/__init__.py:36: FutureWarning: Conversion of the second argument of issubdtype from `float` to `np.floating` is deprecated. In future, it will be treated as `np.float64 == np.dtype(float).type`.\n",
" from ._conv import register_converters as _register_converters\n"
+ "/home/walch/miniconda3/envs/py3/lib/python3.6/site-packages/h5py/__init__.py:36: FutureWarning: Conversion of the second argument of issubdtype from `float` to `np.floating` is deprecated. In future, it will be treated as `np.float64 == np.dtype(float).type`.\n",
+ " from ._conv import register_converters as _register_converters\n"
"/home/walch/miniconda3/envs/py3/lib/python3.6/site-packages/numpy/lib/arraysetops.py:463: FutureWarning: elementwise comparison failed; returning scalar instead, but in the future will perform elementwise comparison\n",