plunder database

table georegions, originally 1048 records from osmtilemill shapefiles

attributes featureclass and 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

* classes used in the original plunder

loaded from Natural Earth Data, 50m set

• oceans
• seas
• lakes
• 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 <rivers.sql >../json/rivers.js

select scalerank, count(*) from plunder.plunder
where featureclass = 'lake'
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 = 'reservoir group by scalerank order by scalerank;

       0 |    25
       1 |     8
       2 |     1
       4 |     5
       5 |     4
       6 |     9

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

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.

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

pulled from database voyc, table fpd

• empire - polygon
• treasure - point