Comments (6)
i did it like this update to Hebrew and if not success to English -
docker run \
-e DOWNLOAD_PBF=https://download.geofabrik.de/asia/israel-and-palestine-latest.osm.pbf \
-v /home/debian/gis:/data/database/ \
overv/openstreetmap-tile-server \
import
docker run \
-p 8080:80 \
-v /home/debian/gis:/data/database/ \
-d overv/openstreetmap-tile-server \
run
docker exec -it name bash
psql -h localhost -U renderer gis
the password is - "renderer"
save it to "/convert.sql"
BEGIN;
UPDATE planet_osm_point SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_line SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_polygon SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_roads SET name = COALESCE(tags->'name:he', tags->'name:en', name);
COMMIT;
\i /convert.sql
exit
docker restart name
from openstreetmap-tile-server.
No, there isn't an environment variable for it.
Also see #24
from openstreetmap-tile-server.
Well, then that would be something to add to the Docker code, so that an environment Variable could be used to force Latin names.
from openstreetmap-tile-server.
This will likely never happen, because we'd need to rewrite/adjust the SQL queries that are defined in the osm-carto repo for that. Doing that binds us harder to a specific version, which makes updating that dependency harder.
Maybe there is another style that already does this, that you can easily use instead?
from openstreetmap-tile-server.
BEGIN;
UPDATE planet_osm_point SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_line SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_polygon SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_roads SET name = COALESCE(tags->'name:he', tags->'name:en', name);
COMMIT;
I just want to point out that this would not work with automatic updates turned on (you don't have it enabled in your posted commands, so that's fine), because the updates would revert it for changed entries. You'd need to re-run these update queries regularly or need to add them to the update script to be persistent.
from openstreetmap-tile-server.
BEGIN;
UPDATE planet_osm_point SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_line SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_polygon SET name = COALESCE(tags->'name:he', tags->'name:en', name);
UPDATE planet_osm_roads SET name = COALESCE(tags->'name:he', tags->'name:en', name);
COMMIT;I just want to point out that this would not work with automatic updates turned on (you don't have it enabled in your posted commands, so that's fine), because the updates would revert it for changed entries. You'd need to re-run these update queries regularly or need to add them to the update script to be persistent.
My env is offline so its ok..
from openstreetmap-tile-server.
Related Issues (20)
- hangs on startup HOT 3
- Segmentation fault during import HOT 5
- Run container over proxy with UPDATES=ENABLED parameter
- running server If I run the server, does it automatically render for all the files?
- Import command fails for OSM data
- Data/Labels not shown up on maps HOT 1
- Postgis Plugin: ERROR: could not resize shared memory segment "/PostgreSQL.2682777122" to 50438144 bytes: No space left on device HOT 1
- To optimise the rendering HOT 1
- Import not completing HOT 7
- Search filed?
- Postgres in container not working HOT 2
- Tile fetching behind reverse proxy HOT 1
- Postgres says rendrer user already exsists
- Error downloading tile file : i/0 time out HOT 3
- til-server automatic update: how to do? HOT 2
- Running out of space when downloading the planet HOT 3
- postgresql error HOT 1
- Automatize tile rendering of big country HOT 2
- Can We Use an External PostgreSQL in Kubernetes
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from openstreetmap-tile-server.