title: Get Distance in Meters instead of degrees in Spatialite
body: <p>I have the following query:</p>
  
  <pre><code>select distance(GeomFromText('POINT(8 49)',4326),GeomFromText('LINESTRING(8.329969 49.919323,8.330181 49.919468)',4326))
  </code></pre>
  
  <p>this gives me 0.97 degrees. But I need it in meters and do not know which SRID to transform to.</p>
  
  <p>Can somebody give me an example how to get the result in meters for spatialite?</p>
  
  <p>The positions are all in Europe. </p>