+// get value of key or default value if key does not exist
+// gets coordinates and returns an array of lon/lat coordinate pairs, e.g.
+// 47.12 N 11.87 E
+// 47.13 N 11.70 E
+// ->
+// array(array(11.87, 47.12), array(11.70, 47.13))
+function geo_to_coordinates($input) {
+ $matches = array();
+ $num_matches = preg_match_all('/(\d+\.?\d*)\s*N?\s+(\d+\.?\d*)\s*E?\s*/', $input, $matches);
+ $result = array();
+ for ($i=0; $i!=$num_matches; ++$i) {
+ $result[] = array(floatval($matches[2][$i]), floatval($matches[1][$i]));
+ }
+ return $result;
+}
+
+
+// convert sledruns to geojson (http://www.geojson.org/geojson-spec.html)
+// Returns an array of features
+function sledruns_to_json_features() {
+ $json_features = array(); // result
+ $dbr = wfGetDB(DB_SLAVE);
+ $res = $dbr->select(array('wrsledruncache', 'wrreportcache'), array('wrsledruncache.page_title', 'position_latitude', 'position_longitude', 'date_report', '`condition`'), array('show_in_overview', 'not under_construction'), __METHOD__, array(), array('wrreportcache' => array('left outer join', 'wrsledruncache.page_id=wrreportcache.page_id')));
+ while ($sledrun = $dbr->fetchRow($res)) {
+ $lat = $sledrun['position_latitude'];
+ $lon = $sledrun['position_longitude'];
+ if (is_null($lat) || is_null($lon)) continue;
+ $lat = floatval($lat);
+ $lon = floatval($lon);
+ $title = Title::newFromText($sledrun['page_title']);
+ $properties = array('type' => 'sledrun', 'name' => $title->getText(), 'wiki' => $title->getLocalUrl());
+ if (!is_null($sledrun['date_report'])) $properties[] = $sledrun['date_report'];
+ if (!is_null($sledrun['condition'])) $properties[] = intval($sledrun['condition']);
+ $json_feature = array(
+ 'type' => 'feature',
+ 'geometry' => array(
+ 'type' => 'Point',
+ 'coordinates' => array($lon, $lat)
+ ),
+ 'properties' => $properties
+ );
+ $json_features[] = $json_feature;
+ }
+ $dbr->freeResult($res);
+ return $json_features;
+}
+
+
+// convert XML to geojson (http://www.geojson.org/geojson-spec.html)
+// Returns an array of features
+// TODO: Error reporting
+function xml_to_json_features($input) {
+ libxml_use_internal_errors(true); // without that, we get PHP Warnings if the $input is not well-formed
+ $xml = new SimpleXMLElement($input); // input
+ $json_features = array(); // output
+ $point_type = array('gasthaus' => 'inn', 'haltestelle' => 'busstop', 'parkplatz' => 'carpark', 'achtung' => 'attention', 'punkt' => 'point');
+ $line_type = array('rodelbahn' => 'sledrun', 'gehweg' => 'walk', 'alternative' => 'alternative', 'lift' => 'lift', 'linie' => 'line');
+ foreach ($xml as $feature) {
+ // point
+ if (in_array($feature->getName(), array_keys($point_type))) {
+ $properties = array('type' => $point_type[$feature->getName()]);
+ if (isset($feature['wiki'])) $properties['wiki'] = (string) $feature['wiki'];
+ if (isset($feature['name'])) $properties['name'] = (string) $feature['name'];
+ $json_feature = array(
+ 'type' => 'feature',
+ 'geometry' => array(
+ 'type' => 'Point',
+ 'coordinates' => geo_to_coordinates($feature)[0]
+ ),
+ 'properties' => $properties
+ );
+ $json_features[] = $json_feature;
+ }
+ // line
+ if (in_array($feature->getName(), array_keys($line_type))) {
+ $properties = array('type' => $line_type[$feature->getName()]);
+ if (isset($feature['farbe'])) $properties['strokeColor'] = (string) $feature['farbe'];
+ if (isset($feature['dicke'])) $properties['strokeWidth'] = (string) $feature['dicke'];
+ $json_feature = array(
+ 'type' => 'feature',
+ 'geometry' => array(
+ 'type' => 'LineString',
+ 'coordinates' => geo_to_coordinates($feature)
+ ),
+ 'properties' => $properties
+ );
+ $json_features[] = $json_feature;
+ }
+ }
+ return $json_features;
+}
+
+
+