Differences

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

--- geosketch_data_analysis [2022/12/16 20:48] – [featureclass] jhagstrand
+++ geosketch_data_analysis [2023/01/12 01:36] (current) – removed jhagstrand
@@ Line 1: / Line 1: @@
-====== Geosketch Data Analysis ======
-plunder database
-table georegions, originally 1048 records from osmtilemill shapefiles
-attributes featureclass and scalerank
-==== scalerank ====
-scale = the number of pixels in the radius of the globe, used for realtime map drawing
-scalerank = a number from 1 to 6, indicating the relative magnitude of the feature
-==== featureclass ====
-^           ^ featureclass     ^ count ^
-| water     | alkaline lake    |    40 |
-| water     | basin            |     9 |
-| water     | canal            |     4 |
-| water     | delta            |    12 |
-| water     | lake             |   320 |
-| water     | lake centerline  |   113 |
-| water     | reservoir*       |    52 |
-| water     | river*           |   361 |
-| land      | coast            |    36 |
-| land      | continent        |     7 |
-| land      | island           |   295 |
-| land      | island group     |   167 |
-| land      | isthmus          |     4 |
-| land      | geoarea          |    44 |
-| land      | pen/cape         |    55 |
-| land      | peninsula        |    11 |
-| terrain   | depression       |     2 |
-| terrain   | desert*          |    58 |
-| terrain   | foothills*       |     3 |
-| terrain   | gorge            |     3 |
-| terrain   | lowland          |     5 |
-| terrain   | plain*           |    30 |
-| terrain   | plateau*         |    71 |
-| terrain   | range/mtn*       |   222 |
-| terrain   | tundra*          |     4 |
-| terrain   | valley*          |     6 |
-| terrain   | wetlands*        |     3 |
-| political | drangons-be-here |     1 |
-| political | empire           |   427 |
-| political | treasure*        |    67 |
-* classes used in the original plunder
-==== scalerank ====
-^ scalerank ^ count ^
-|         0 |   283 |
-|         1 |   144 |
-|         2 |   118 |
-|         3 |   261 |
-|         4 |   266 |
-|         5 |   453 |
-|         6 |   361 |
-|         7 |    41 |
-|         9 |     2 |
-|        10 |     6 |
-|        12 |     2 |
-|       100 |     1 |
-|       500 |    15 |
-|       900 |     1 |
-|      1000 |   470 |
-|      2000 |     1 |
-|           |     7 |
-===== water =====
-loaded from Natural Earth Data, 50m set
-  * oceans
-  * seas
-  * lakes
-  * rivers
-==== rivers ====
-A. examine rivers
-:50m 460 rivers, scalerank 1 thru 6, 42 rows in our target geo
-#all rivers combined, almost 1 MB
-psql -t -d voyc -U jhagstrand <rivers.sql >../json/rivers.js
-==== lakes ====
-select scalerank, count(*) from plunder.plunder \\
-where featureclass = 'lake' \\
-group by scalerank order by scalerank;\\
-|   220
-|    58
-|     2
-|     5
-|     2
-|     7
-|    26
-select scalerank, count(*) from plunder.plunder\\
-where featureclass = 'reservoir
-group by scalerank order by scalerank;\\
-|    25
-|     8
-|     1
-|     5
-|     4
-|     9
-==== seas ====
-A table on this page includes names of the major seas.
-https://en.wikipedia.org/wiki/List_of_political_and_geographic_borders
-Caspian Sea is currently missing.
-Maybe needed for labeling or hit testing.
-Examples
-  * Mediterranean
-  * Bay of Bengal
-  * Arabian Sea
-  * Carribean
-==== oceans ====
-Natural Earth's Ocean file has only one polygon.
-We don't currently have an oceans data.
-We just paint the background blue, and start drawing on top of it.
-If we want to do labeling or hit testing by ocean name,
-then we will need a polygon
-for each named ocean.
-oceans: Pacific, Atlantic, Indian\\
-optional: Arctic, Southern\\
-optional: North Pacific, South Pacific, North Atlantic, South Atlantic
-arctic and southern oceans are each a circle, or just explicitly test for north of 80
-===== Political data ======
-pulled from database voyc, table fpd
-  * empire - polygon
-  * treasure - point