OpenSeaMap-dev Diskussion:Downloadable Raster Charts - Versionsgeschichte

Kannix: inland waterways added

2015-06-22T13:01:10Z

inland waterways added

Kannix: /* tile server */ php script added

2015-02-16T17:08:24Z

‎tile server: php script added

Kannix: /* py script */ 'exit' added

2015-02-16T09:55:47Z

‎py script: 'exit' added

Kannix: /* tile server */

2015-02-14T09:36:31Z

‎tile server

Kannix: /* py script */ ready 4 reviews

2015-02-12T18:54:44Z

‎py script: ready 4 reviews

Kannix: /* py script */ update

2015-02-12T11:59:24Z

‎py script: update

Kannix: /* tile server */ py script added

2015-02-11T11:55:34Z

‎tile server: py script added

Kannix: /* tile server */ landez statt perl

2015-02-11T11:26:35Z

‎tile server: landez statt perl

Kannix: /* prerequisites */ changed from perl to python

2015-02-11T11:22:20Z

‎prerequisites: changed from perl to python

Kannix: /* tile server */ more details added

2015-02-08T11:06:19Z

‎tile server: more details added

@@ Zeile 1: / Zeile 1: @@
-== ideas ==
+== inland waterways (ideas) ==
 === web frontend ===
 * die INT-chart Grenzen (als Basis fuer ein download-tool) bekomme ich inzwischen auf den Schirm: http://kap.grade.de/int-chart-ol2.html , sicherlich verbesserungsbeduerftig

← Nächstältere Version		Version vom 16. Februar 2015, 17:08 Uhr
Zeile 305:		Zeile 305:
	pass		pass

		+
		+	</pre>
		+
		+
		+	==== php script ====
		+	<pre>
		+
		+	<?php
		+
		+	error_reporting(E_ALL);
		+
		+	show_array($_GET);
		+	show_array($_POST);
		+
		+	switch ($_POST['stage'])
		+	{
		+	case 'process':
		+	update();
		+	break;
		+	default :
		+	print_list();
		+	break;
		+	}
		+
		+	function print_form()
		+	{
		+	echo '<form action="'.$_SERVER['PHP_SELF'].'" method="post">';
		+	echo " <input type='submit' name='Text' value='Generate new Chart'/>";
		+	echo " <input type='hidden' name ='stage' value='process' />\n";
		+	echo " <input type='hidden' name ='Chart' value='" . $_GET['Chart'] . "' />\n";
		+	echo " <input type='hidden' name ='Name' value='" . $_GET['Name'] . "' />\n";
		+	echo " <input type='hidden' name ='HO' value='" . $_GET['HO'] . "' />\n";
		+	echo " <input type='hidden' name ='BottomGeoPre' value='" . $_GET['BottomGeoPre'] . "' />\n";
		+	echo " <input type='hidden' name ='TopGeoPre' value='" . $_GET['TopGeoPre'] . "' />\n";
		+	echo " <input type='hidden' name ='LeftGeoPre' value='" . $_GET['LeftGeoPre'] . "' />\n";
		+	echo " <input type='hidden' name ='RightGeoPre' value='" . $_GET['RightGeoPre'] . "' />\n";
		+	echo " <input type='hidden' name ='NumTiles16' value='" . $_GET['NumTiles16'] . "' />\n";
		+	echo "</form>\n";
		+	}
		+
		+
		+	function print_list()
		+	{
		+	if (is_array(glob("../INT-CHART/INT-".$_GET['Chart']."."))) {
		+	foreach (glob("../INT-CHART/INT-".$_GET['Chart'].".") as $filename) {
		+	$size = round(filesize($filename)/1024, 2);
		+	$modified = gmdate ( 'd M Y H:i:s', filectime($filename));
		+	echo "<a href='".$filename."'>" .$filename. "</a> - Size: " . $size . " kB - Modified: " . $modified . "</br>";
		+	}
		+	} else {
		+	print_form();
		+	}
		+	}
		+
		+	function update()
		+	{
		+	echo 'Received your request, processing will take some time. Please be patient and check back in an hour ...';
		+	$_POST['Name'] = utf8_encode( $_POST['Name'] );
		+	$db = new SQLite3('../temp/queue.sqlite');
		+	$db->exec("INSERT INTO jobs (
		+	Chart,
		+	Name,
		+	HO,
		+	BottomGeoPre,
		+	TopGeoPre,
		+	LeftGeoPre,
		+	RightGeoPre,
		+	NumTiles16,
		+	status
		+	) VALUES (
		+	'{$_POST['Chart']}',
		+	'{$_POST['Name']}',
		+	'{$_POST['HO']}',
		+	{$_POST['BottomGeoPre']},
		+	{$_POST['TopGeoPre']},
		+	{$_POST['LeftGeoPre']},
		+	{$_POST['RightGeoPre']},
		+	{$_POST['NumTiles16']},
		+	'open'
		+	)");
		+	}
		+
		+	// show content of PHP array, i.e. show_array($_POST)
		+	// this is handy to quickly test what data is in an array
		+	function show_array($x)
		+	{
		+	if (!is_array($x)) return;
		+	reset($x);
		+	echo "<br />";
		+	echo "<b>content of array</b>\n";
		+	if ($x)
		+	while ($i = each($x))
		+	echo "<br />", htmlentities($i[0]), " = ", htmlentities($i[1]), "\n";
		+	echo "<br /><br />\n";
		+	}
		+
		+	?>

	</pre>		</pre>

@@ Zeile 56: / Zeile 56: @@
 import os
 import sys
 logging.basicConfig(level=logging.DEBUG)
@@ Zeile 71: / Zeile 72: @@
      rows = cur.fetchall()
      for row in rows:
@@ Zeile 89: / Zeile 94: @@
 myZoom = 18
-while (myNumTiles > 4):
+while (myNumTiles > 700):
   myNumTiles = myNumTiles / 4
   myZoom = myZoom - 1
@@ Zeile 232: / Zeile 237: @@
 # write textfile
 txtPost = [
    'INT Chart Number= ' + sqChart,
    'INT Chart Name= ' + sqName,
@@ Zeile 260: / Zeile 267: @@
 t = "\n"
 txtPost = t.join(txtPost)
-logging.debug(" txtPost: " +  str(txtPost))
+logging.debug(" txtPost: " +  txtPost)
-with open(myTextFile, 'w') as f:
+with codecs.open(myTextFile, 'w', "utf-8") as f:
      f.write(txtPost)

@@ Zeile 32: / Zeile 32: @@
 * status=done, zoom-level, date, ... in queue-db setzen
 * temp-dir bereinigen und results in charts-dir kopieren
 ==== prerequisites ====

@@ Zeile 52: / Zeile 52: @@
 import math
 from landez import MBTilesBuilder, ImageExporter, TilesManager
 logging.basicConfig(level=logging.DEBUG)
@@ Zeile 57: / Zeile 60: @@
 # to be imported from sqlite-queue
-sqBottomGeoPre = 53.2
+con = sqlite3.connect('queue.sqlite')
-sqTopGeoPre = 54.216666666667
-sqLeftGeoPre = 4.2
+with con:
-sqRightGeoPre = 6.715
-sqNumTiles16 = 143170
+    con.row_factory = sqlite3.Row
-sqChart = "1417"
-sqName = "Friesland Junction and GW/EMS to Vlieland and Borkum"
+    cur = con.cursor()
-sqHO = "NL/GB"
+    cur.execute('SELECT * FROM jobs WHERE status="open" ORDER BY microtime DESC')
-sqMicrotime= 1234
 # to be calculated from numtiles16, numtiles < 700
@@ Zeile 73: / Zeile 88: @@
 myZoom = 18
-while (myNumTiles > 700):
+while (myNumTiles > 4):
   myNumTiles = myNumTiles / 4
   myZoom = myZoom - 1
@@ Zeile 84: / Zeile 99: @@
 if sqHO == "DE":
      myUrlHydro = "http://tiles.grade.de/tiles.py/NAUTHIS_SkinOfEarth/{z}/{x}/{y}.png"
 elif sqHO== "NL/GB":
      myUrlHydro = "http://tiles.grade.de/tiles.py/ncp_diepte14/{z}/{x}/{y}.png"
@@ Zeile 89: / Zeile 105: @@
      myUrlHydro = ""
-myFileName = sqChart
+myFileName = str(sqMicrotime)
 myMbtilesFile = myFileName + ".mbtiles"
 myImageFile = myFileName + ".jpg"
@@ Zeile 182: / Zeile 198: @@
 logging.debug(" top: " +  str(sqTopGeoPost))
 logging.debug(" bottom: " +  str(sqBottomGeoPost))
 # start imgkap to generate .kap file
@@ Zeile 188: / Zeile 228: @@
 print myImgkapCall
 subprocess.call(myImgkapCall, shell=True)

@@ Zeile 42: / Zeile 42: @@
 ** [https://github.com/makinacorpus/landez landez]
 * [http://www.dacust.com/inlandwaters/imgkap/ imgkap]
 == Reason for ChartBundler ==

@@ Zeile 24: / Zeile 24: @@
 * cronjob checkt queue-db alle x Minuten
 * waehlt aeltesten job aus queue-db mit status=open
-* sinnvolles zoom-level anhand bbox errechnen (max. 10MB/chart)
+* tiledownload ueber proxy mit landez
-* tiledownload ueber proxy mit downloadosmtiles.pl
+** sinnvolles zoom-level anhand bbox errechnen (max. 10MB/chart)
-** tiles mit imagemagick stitchen (siehe [http://www.openstreetmap.org/user/mkarau/diary/20256 Tile Stitching])
+** mbtiles erzeugen (siehe auch [https://github.com/mapbox/mbtiles-spec/wiki/Implementations mbtiles implementation])
-*** stitched.png in .kap wandeln mit imgkap
+** stitchen und .png/.jpg erzeugen
-** tiles in mbtiles file packen (siehe [https://github.com/mapbox/mbtiles-spec/wiki/Implementations mbtiles implementation])
+** .kap mit imgkap erstellen
 ** ...
 * status=done, zoom-level, date, ... in queue-db setzen

@@ Zeile 39: / Zeile 39: @@
 * nginx remote proxy
 * imagemagick
-* perl
+* python
-** libwww-perl
+** [https://github.com/makinacorpus/landez landez]
 * [http://www.dacust.com/inlandwaters/imgkap/ imgkap]