I am running a local OSM server I made with osm2pgsql. I would like to remove the "Hudson Bay" label from the map. I understand I would have to re render the tiles but that is okay. Can it just be removed in the postgres database? Could you guys point me in the right direction?

Thanks! :)

asked 22 Oct, 15:09

LakesKeegan's gravatar image

LakesKeegan
46117
accept rate: 0%


If you are not updating the server automatically you can simply find the relevant object and null the name field.

Note that there seem to be multiple objects with the name and you will likely have to repeat this for all of them.

For the main multipolygon with id 9441240 you should be able to find entries in the planet_osm_polygon table, you will need to check for -9441240 too.

If you are updating your database, this can still be done, but you will need to add triggers to remove the name automatically if somebody edits the object (or you could simply do it manually if the name returns).

permanent link

answered 23 Oct, 10:03

SimonPoole's gravatar image

SimonPoole ♦
38.7k13287614
accept rate: 19%

I can't seem to find where the label is coming from, is it just the "Name" column in the database? Would the Hstore data make any difference?

(23 Oct, 15:15) LakesKeegan
1

It is very well possible as I said that there multiple objects with the name. I don't believe that osm-carto uses hstore at all for names. I'll run a quick check on my database and report back.

(23 Oct, 16:03) SimonPoole ♦

Thank you!

(23 Oct, 16:33) LakesKeegan
1

planet_osm_point 305640293 that doesn't seem to be rendered

planet_osm_ polygon -9441240 and maybe 518434801, 518425097 seems as there has just been some editing on the objects so YMMV

(23 Oct, 16:53) SimonPoole ♦

Am I able to just delete 305640293 or is that a bad idea?

(23 Oct, 16:57) LakesKeegan

I don't think anybody uses it for anything, and as said it isn't rendered anyway.

(23 Oct, 17:14) SimonPoole ♦

I set the polygon names to null and deleted the point, the label is still showing up. Do you have any other ideas? Thanks again for your help.

(23 Oct, 18:01) LakesKeegan

Are you sure that the tiles have been regenerated? the low zoom tiles typically are not dynamically rendered.

(23 Oct, 18:44) SimonPoole ♦
2

Turns out they didn't finish rendering, the label is removed. Thanks for your help!

(23 Oct, 21:41) LakesKeegan
showing 5 of 9 show 4 more comments
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×552
×213
×146
×49
×9

question asked: 22 Oct, 15:09

question was seen: 199 times

last updated: 23 Oct, 21:41

powered by OSQA