select osm_id, st_intersection(geom,way) geom from 
arne.study_area a,
dorset_line d
where st_intersects(geom,way)

<html><head><link rel="stylesheet" type="text/css" href="lib/popup/popup.css"></head><body><div class="scrollableContainer"><table class="popup scrollable"><table id="popup"><tr class='coord'><td></td><td><b>Feature ID</b></td><td align='right'>1&emsp;</td></tr><tr class='alt'><td>1</td><td><b>id&emsp;</b></td><td align='right'>16&emsp;</td></tr><tr><td>2</td><td><b>site&emsp;</b></td><td align='right'>A&emsp;</td></tr><tr class='alt'><td>3</td><td><b>npines&emsp;</b></td><td align='right'>2&emsp;</td></tr><tr><td>4</td><td><b>pine_density&emsp;</b></td><td align='right'>0.636619772367581&emsp;</td></tr><tr class='alt'><td>5</td><td><b>aspect&emsp;</b></td><td align='right'>36.1440544128418&emsp;</td></tr><tr><td>6</td><td><b>sol&emsp;</b></td><td align='right'>1.58446788787842&emsp;</td></tr><tr class='alt'><td>7</td><td><b>slope&emsp;</b></td><td align='right'>3.6137216091156&emsp;</td></tr><tr><td>8</td><td><b>twi&emsp;</b></td><td align='right'>3.04634141921997&emsp;</td></tr><tr class='alt'><td>9</td><td><b>dtm&emsp;</b></td><td align='right'>5.84499979019165&emsp;</td></tr><tr><td>10</td><td><b>chm&emsp;</b></td><td align='right'>0.115000247955322&emsp;</td></tr><tr class='alt'><td>11</td><td><b>chm10&emsp;</b></td><td align='right'>0&emsp;</td></tr><tr><td>12</td><td><b>chm5b&emsp;</b></td><td align='right'>0.0224761735825312&emsp;</td></tr><tr class='alt'><td>13</td><td><b>geometry&emsp;</b></td><td align='right'>sfc_POINT&emsp;</td></tr><tr><td>14</td><td><b>min_dist&emsp;</b></td><td align='right'>20.9575769019373&emsp;</td></tr><tr class='alt'><td>15</td><td><b>n50m&emsp;</b></td><td align='right'>4&emsp;</td></tr><tr><td>16</td><td><b>n100m&emsp;</b></td><td align='right'>25&emsp;</td></tr><tr class='alt'><td>17</td><td><b>paths_dist&emsp;</b></td><td align='right'>22.4102817653831&emsp;</td></tr></table></body></html>

<html><head><link rel="stylesheet" type="text/css" href="lib/popup/popup.css"></head><body><div class="scrollableContainer"><table class="popup scrollable"><table id="popup"><tr class='coord'><td></td><td><b>Feature ID</b></td><td align='right'>2&emsp;</td></tr><tr class='alt'><td>1</td><td><b>id&emsp;</b></td><td align='right'>17&emsp;</td></tr><tr><td>2</td><td><b>site&emsp;</b></td><td align='right'>A&emsp;</td></tr><tr class='alt'><td>3</td><td><b>npines&emsp;</b></td><td align='right'>4&emsp;</td></tr><tr><td>4</td><td><b>pine_density&emsp;</b></td><td align='right'>1.27323954473516&emsp;</td></tr><tr class='alt'><td>5</td><td><b>aspect&emsp;</b></td><td align='right'>5.08344554901123&emsp;</td></tr><tr><td>6</td><td><b>sol&emsp;</b></td><td align='right'>1.63725078105927&emsp;</td></tr><tr class='alt'><td>7</td><td><b>slope&emsp;</b></td><td align='right'>2.34271788597107&emsp;</td></tr><tr><td>8</td><td><b>twi&emsp;</b></td><td align='right'>3.56851077079773&emsp;</td></tr><tr class='alt'><td>9</td><td><b>dtm&emsp;</b></td><td align='right'>4.16800022125244&emsp;</td></tr><tr><td>10</td><td><b>chm&emsp;</b></td><td align='right'>0.241999626159668&emsp;</td></tr><tr class='alt'><td>11</td><td><b>chm10&emsp;</b></td><td align='right'>0&emsp;</td></tr><tr><td>12</td><td><b>chm5b&emsp;</b></td><td align='right'>0.0935263131794177&emsp;</td></tr><tr class='alt'><td>13</td><td><b>geometry&emsp;</b></td><td align='right'>sfc_POINT&emsp;</td></tr><tr><td>14</td><td><b>min_dist&emsp;</b></td><td align='right'>10.9193663465203&emsp;</td></tr><tr class='alt'><td>15</td><td><b>n50m&emsp;</b></td><td align='right'>5&emsp;</td></tr><tr><td>16</td><td><b>n100m&emsp;</b></td><td align='right'>34&emsp;</td></tr><tr class='alt'><td>17</td><td><b>paths_dist&emsp;</b></td><td align='right'>13.0107407327472&emsp;</td></tr></table></body></html>