Place names for basemap

[makella]

@ivanmalagon @rjimenezda @StevePIsaac if we can get the place name list that you think would be helpful to include on the map, it would be good to get that sooner rather than later so we can include it in the mbtiles file that they'll put up for us.

Just in case, attaching that file here.

There are the following categories:

locations_and_labels.geojson.zip

[makella]

Actually just thinking I can probably write a condition in MBStudio on the larger places dataset that is a list of the place names to include...

[StevePIsaac]

Hey @makella not sure what format you need this, but I have listed the ids and place names that i think we should include from that file at the bottom of this comment. It is 79 in total, i eliminated places that even I hadn't heard of, and with 79, there should be enough to make it hard. The file you send also doesn't have IDs and info for the following locations on our trivia list:

• Cave of the Three Eyed Raven
• Fist of the First Men
• Hardhome
  -Casterly Rock
  -Tarth

and The Water Gardens and The Tower of Joy have "The" in their names in the trivia json file, but not in the locations file for the below list. Let me know if you want me to share this info in some other format! Thanks!

1, King’s Landing
8, High Heart
9, Duskendale
10, Antlers
11, Stokeworth
15, Harrenhal
18, Stoney sept
21, Acorn Hall
23, Mummer’s Ford
32, Riverrun
34, Darry
36, BWB Hideout (rename: Brothers Without Banners Hideout
38, Crossroads Inn (rename: Inn at the Crossroads)
39, Saltpans
42, Maidenpool
46, Dragonstone
52, Storm’s End
53, Griffin’s Roost
61, Summerhall
65, Wyl
66, Ghaston Grey
67, Yronwood
72, Highgarden
73, Horn Hill
77, Oldtown
83, High Hermitage
84, Starfall
85, Sandstone
88, Tower of Joy
96, Sunspear
97, Planky Town
98, Water Gardens
100, Tall Trees Town
106, Crakehall
109, Clegane Hall
111, Lannisport
114, Oxcross
120, Castamere
131, The Bloody Gate
132, The Eyrie
135, Redfort
139, Gulltown
142, Baelish Keep
145, The Twins
147, Greywater Watch
148, Moat Cailin
151, White Harbor
153, Widow’s Watch
156, The Dreadfort
159, Winterfell
162, Deepwood Motte
163, Last Hearth
164, Karhold
166, Castle Black
167, Mole’s Town
168, Shadow Tower
175, Nightfort
185, Eastwatch-by-the-sea
187, Craster’s Keep
188, First of the First Men
191, Lys
192, Tyrosh
193, Myr
194, Pentos
196, Norvos
199, Braavos
200, Lorath
201, Qohor
209, Volantis
212, Mantarys
220, Astapor
221, Yunkai
222, Meereen
223, Lhazarene Village
224, Vaes Dothrak
232, Torrhen’s Square
234, Pyke
242, Valyria
246, Qarth

[makella]

@StevePIsaac awesome, thanks so much. So these are all places you want labeled on the map? Yes, would probably be good to talk about the details since I'm not too familiar with the show.

[StevePIsaac]

@makella I suppose we want to have all of those show up, unless you think that from a design standpoint, that is too many. I can easily remove more!

I know in the slack channel @ivanmalagon and I were discussing whether for a "hard mode" or the last three questions or something that labels could be turned off, so folks would have to know both the trivia and the general location of the answer. Not sure if that is something we'd want to do!

[makella]

@StevePIsaac let me see what the density looks like... also, if there is some hierarchy within the schema we have that we can use (for example, I'd assume cities should be labeled first and then as you zoom in, town, ruin, castle...) that could be a way to introduce them through zoom so they aren't overwhelming.

I think they will be creating the tiles soon, so I probably should do this soon so we have this selected list for the labeling layer

[makella]

query:

SELECT * FROM mamataakella.locations where name IN ('King''s Landing',
'High Heart',
'Duskendale',
'Antlers',
'Stokeworth',
'Harrenhal',
'Stoney sept',
'Acorn Hall',
'Mummer''s Ford',
'Riverrun',
'Darry',
'BWB hideout',
'Crossroads Inn',
'Saltpans',
'Maidenpool',
'Dragonstone',
'Storm''s End',
'Griffin''s Roost',
'Summerhall',
'Wyl',
'Ghaston Grey',
'Yronwood',
'Highgarden',
'Horn Hill',
'Oldtown',
'High Hermitage',
'Starfall',
'Sandstone',
'Tower of Joy',
'Sunspear',
'Planky Town',
'Water Gardens',
'Tall Trees Town',
'Crakehall',
'Clegane Hall',
'Lannisport',
'Oxcross',
'Castamere',
'The Bloody Gate',
'The Eyrie',
'Redfort',
'Gulltown',
'Baelish Keep',
'The Twins',
'Greywater Watch',
'Moat Cailin',
'White Harbor',
'Widow''s Watch',
'The Dreadfort',
'Winterfell',
'Deepwood Motte',
'Last Hearth',
'Karhold',
'Castle Black',
'Mole''s Town',
'Shadow Tower',
'Nightfort',
'Eastwatch-by-the-sea',
'Craster’s Keep',
'First of the First Men',
'Lys',
'Tyrosh',
'Myr',
'Pentos',
'Norvos',
'Braavos',
'Lorath',
'Qohor',
'Volantis',
'Mantarys',
'Astapor',
'Yunkai',
'Meereen',
'Lhazarene Village',
'Vaes Dothrak',
'Torrhen''s Square',
'Pyke',
'Valyria',
'Qarth')

update mamataakella.selected_places_got set name = 'Inn at the Crossroads' where name = 'Crossroads Inn'
update mamataakella.selected_places_got set name = 'Brothers Without Banners Hideout' where name = 'BWB hideout'

[StevePIsaac]

@makella for the hierarchy, I would maybe change to city, castle, town, ruin, other. Thanks!

[makella]

ok, I made a dataset of those place names and created a new mbtiles file. I'll post that to this issue.

I can't really test today, so hopefully it is all ok. Will see if I can get to it later in the week.