<commit_before><?php
 // dbloc.php
 //   Get a location from DB (better than allLoc?)
 //   <NAME> 6 Dec 2002

function dbloc($c, $sid){
  $sid = substr($sid, 0, 6);
  $q = "SELECT *, x(geom) as longitude, y(geom) as latitude from stations WHERE id = '".$sid."'";
  $rs = pg_exec($c, $q);
  pg_close($c);

  $row = @pg_fetch_array($rs,0);
  $row["lon"] = $row["longitude"];
  $row["lat"] = $row["latitude"];
  return $row;

} // End of dbloc()

//select Y(transform(geometryfromtext(ba, 4326), 26915)), X(transform(geometryfromtext(ba, 4326), 26915)) from (select 'POINT('||longitude||' '||latitude||')' as ba from stations WHERE id = 'AMW') as foo;

function dbloc26915($c,$sid){
  $sid = substr($sid, 0, 6);
  $q = "select Y(transform(geometryfromtext(ba, 4326), 26915)), X(transform(geometryfromtext(ba, 4326), 26915)) from (select 'POINT('||longitude||' '||latitude||')' as ba from stations WHERE id = '$sid') as foo";
  $rs = pg_exec($c, $q);
  pg_close($c);

  $row = @pg_fetch_array($rs,0);
  $r = Array();
  $r["x"] = $row["x"];
  $r["y"] = $row["y"];
  return $r;
<commit_msg>more fix<commit_after><?php
 // dbloc.php
 //   Get a location from DB (better than allLoc?)
 //   <NAME> 6 Dec 2002

function dbloc($c, $sid){
  $sid = substr($sid, 0, 6);
  $q = "SELECT *, x(geom) as longitude, y(geom) as latitude from stations WHERE id = '".$sid."'";
  $rs = pg_exec($c, $q);
  pg_close($c);

  $row = @pg_fetch_array($rs,0);
  $row["lon"] = $row["longitude"];
  $row["lat"] = $row["latitude"];
  return $row;

} // End of dbloc()

//select Y(transform(geometryfromtext(ba, 4326), 26915)), X(transform(geometryfromtext(ba, 4326), 26915)) from (select 'POINT('||longitude||' '||latitude||')' as ba from stations WHERE id = 'AMW') as foo;

function dbloc26915($c,$sid){
  $sid = substr($sid, 0, 6);
  $q = "select Y(transform(geometryfromtext(ba, 4326), 26915)), X(transform(geometryfromtext(ba, 4326), 26915)) from (select 'POINT('||x(geom)||' '||y(geom)||')' as ba from stations WHERE id = '$sid') as foo";
  $rs = pg_exec($c, $q);
  pg_close($c);

  $row = @pg_fetch_array($rs,0);
  $r = Array();
  $r["x"] = $row["x"];
  $r["y"] = $row["y"];
  return $r;

{'fraction_non_alphanumeric': 0.23496762257169287, 'fraction_numerical': 0.04810360777058279, 'mean_word_length': 4.603626943005182, 'pattern_counts': {'":': 0, '<': 7, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '718987', 'n_tokens_mistral': 944, 'n_tokens_neox': 855, 'n_words': 221}