Differences

This shows you the differences between two versions of the page.

--- projects:voyc:data_origin [2023/01/12 03:11] – jhagstrand
+++ projects:voyc:data_origin [2023/03/13 12:45] (current) – jhagstrand
@@ Line 2: / Line 2: @@
 ====== Data Origin ======
+cd ~/webprod/geosketch/geosketch/datasource/osmtilemill
+wget https://github.com/polpols/OSM-Tilemill/archive/master.zip
+unzip -j master */10m_geography_regions_polys.*
+shp2pgsql -c -W LATIN1 10m_geography_regions_polys plunder.georegions >load.georegions.sql
+psql -d voyccom_plunder -U voyccom_jhagstrand <load.georegions.sql
+====== Previous Data Origin ======
 dec 2022 re-create plunder database in a2hosting
@@ Line 216: / Line 227: @@
 ==== Cities ====
+[[projects:voyc:cities]]
 from: simplemaps.com, 42,000 cities, downloaded as a csv file
@@ Line 227: / Line 240: @@
   unzip ne_110m_admin_0_countries.zip
   shp2pgsql -c -W LATIN1 ne_110m_admin_0_countries plunder.ne110_admin0_countries >load.countries.sql
+===== Raster Data =====
+from Natural Earth
+:50m Natural Earth II, shaded relief, water (oceans), colorized ground cover\\
+x 5400 pixels\\
+NE2_50M_SR_W.tif
+:10m Natural Earth II, same plus drainage (rivers, lakes) (5x resolution?)\\
+x 10800 pixels,  (2x resolution?) \\
+NE2_HR_LC_SR_W_DR.tif
+cut the tif images into tiles\\
+tilesize pixels: 300 x 300, or 600 x 600\\
+tilesize degrees: 10 x 10\\
+columns * 18 rows = 648 tiles
+  * document hires
+    * file locations
+    * ln -s /home/voyccom/media/data/natural_earth_data/raster/NE2_50M_SR_W.png 50mtex.png
+    * to test local, start browser from the command line
+<code>
+brave-browser --allow-file-access-from-files
+</code>