geosketch_data_analysis
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| geosketch_data_analysis [2022/12/14 23:00] – [lakes] 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 ==== | ||
| - | |||
| - | 21 feature classes: | ||
| - | basin | ||
| - | coast | ||
| - | continent | ||
| - | delta | ||
| - | depression | ||
| - | desert* | ||
| - | foothills* | ||
| - | geoarea | ||
| - | gorge | ||
| - | island | ||
| - | island group | ||
| - | isthmus | ||
| - | lowland | ||
| - | pen/cape | ||
| - | peninsula | ||
| - | plain* | ||
| - | plateau* | ||
| - | range/mtn* | ||
| - | tundra* | ||
| - | valley* | ||
| - | wetlands* | ||
| - | |||
| - | * classes used in the original plunder | ||
| - | |||
| - | ===== water ===== | ||
| - | |||
| - | loaded from Natural Earth Data, 50m set | ||
| - | |||
| - | * oceans | ||
| - | * seas | ||
| - | * lakes | ||
| - | * rivers | ||
| - | |||
| - | ==== rivers ==== | ||
| - | |||
| - | A. examine rivers | ||
| - | 1: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 < | ||
| - | |||
| - | ==== lakes ==== | ||
| - | select scalerank, count(*) from plunder.plunder \\ | ||
| - | where featureclass = ' | ||
| - | group by scalerank order by scalerank; | ||
| - | |||
| - | 0 | 220 | ||
| - | 1 | 58 | ||
| - | 2 | 2 | ||
| - | 3 | 5 | ||
| - | 4 | 2 | ||
| - | 5 | 7 | ||
| - | 6 | 26 | ||
| - | |||
| - | select scalerank, count(*) from plunder.plunder\\ | ||
| - | where featureclass = ' | ||
| - | group by scalerank order by scalerank; | ||
| - | |||
| - | 0 | 25 | ||
| - | 1 | 8 | ||
| - | 2 | 1 | ||
| - | 4 | 5 | ||
| - | 5 | 4 | ||
| - | 6 | 9 | ||
| - | |||
| - | |||
| - | ==== seas ==== | ||
| - | |||
| - | A table on this page includes names of the major seas. | ||
| - | https:// | ||
| - | |||
| - | |||
| - | Caspian Sea is currently missing. | ||
| - | |||
| - | Maybe needed for labeling or hit testing. | ||
| - | |||
| - | Examples | ||
| - | * Mediterranean | ||
| - | * Bay of Bengal | ||
| - | * Arabian Sea | ||
| - | * Carribean | ||
| - | |||
| - | ==== oceans ==== | ||
| - | |||
| - | Natural Earth' | ||
| - | |||
| - | 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. | ||
| - | |||
| - | 3 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 | ||
geosketch_data_analysis.1671076854.txt.gz · Last modified: 2022/12/14 23:00 by jhagstrand