https://maps.wikimedia.org/?lang=ru#18/35.69170/139.94192
Some "ref" are not limited to the size of the shield in Japan
With numbers only in the ref tag, but not with others symbols. For example: E6 or 21;376

Hi everybody from Kartotherian / Wikipedia project,

Please read:
osm2vectortiles/osm2vectortiles#387

There may be implications for your vector tiles defined in this repository.

Hi,

we use the Postgres.app for OS X with PostGIS, PROJ4 and GDAL.

These are our steps to create the source project:

• create database
• create postgis extension
• import: psql -f postgis-vt-util.sql
• import OSM data via osm2pgsql
• import: psql -f admin.sql (execute with error)
• import: psql -f functions.sql
• shp2pgsql -g way water-polygons-split-3857/water_polygons.shp | psql -h localhost -p 5432 -U username -d databasename
• cat "$( dirname "${BASH_SOURCE[0]}" )"/../sql/water-indexes.sql | psql -h localhost -p 5432 -U username -d databasename

i get an error when i try to execute admin.sql. The 3rd function insert_admin_rows
produce an error.

ERROR: "therow.tags" is not a known variable
LINE 93: theRow.tags := theRow.tags || (CASE WHEN maritime THEN '"ma...

Do you have any advice for us?

Function:

-- Inserts 1 row per sub-geometry into the admin table

-- @param row admin: Row to insert
-- @param LineString|MultiLineString geom: Geometry to set for this row

-- @param bool maritime: Whether the border is maritime

CREATE OR REPLACE FUNCTION insert_admin_rows(theRow admin, geom geometry, maritime bool) RETURNS void AS
$$
DECLARE
i int;

BEGIN
theRow.tags := theRow.tags || (CASE WHEN maritime THEN '"maritime" => "1"' ELSE '"maritime" => "0"' END)::hstore;
IF GeometryType(geom) = 'LINESTRING' THEN -- Simple geometry
PERFORM insert_admin_row(theRow, geom);
ELSE
FOR i IN 1..ST_NumGeometries(geom) LOOP -- Composite geometry, insert one row per subgeometry
PERFORM insert_admin_row(theRow, ST_GeometryN(geom, i));
END LOOP;
END IF;
END
$$
LANGUAGE plpgsql;

The line
theRow.tags := theRow.tags || (CASE WHEN maritime THEN '"maritime" => "1"' ELSE '"maritime" => "0"' END)::hstore;

trows the error

ERROR:  "therow.tags" is not a known variable
LINE 7:  theRow.tags := theRow.tags || (CASE WHEN maritime THEN '"ma...

when I run

psql gis < admin.sql

$ psql -d gis -f sql/admin.sql

CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
psql:sql/admin.sql:93: ERROR:  "therow.tags" is not a known variable
LINE 7:  theRow.tags := theRow.tags || (CASE WHEN maritime THEN '"ma...
         ^
CREATE FUNCTION

PostgreSQL 9.4.4

MapBox Studio Classic crashed during export process. We only select zoom level 16 for export and a small map part of Berlin. The export process is still very slow. We use a local source.

The command in the readme.md's example:
osm2pgsql -d gis -E 900913 --hstore ~/path/to/data.osm.pbf

generates this error on both Ubuntu and macOS:
Couldn't read EPSG definition (do you have /usr/share/proj/epsg?)

Changing the command to this, fixed it:
osm2pgsql -d gis -E EPSG:900913 --hstore ~/path/to/data.osm.pbf

Hi,

I created a new postgis db and converted an osm.pbf dataset as outlined in
https://github.com/kartotherian/kartotherian/blob/master/README.md#in-depth-step-by-step

When I tried to open the .tm2source in MapBox Studio Classic I got an error about 'LabelGrid' arguments. The error was:
Postgis Plugin: ERROR: function labelgrid(geometry, integer, integer) does not exist
LINE 51: ORDER BY labelgrid(way, 64, 0), sort_order DESC
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
in executeQuery Full sql was: 'SELECT * FROM (

When looking at it closely, the function as defined in the .sql expects two arguments but in the .yml its called with three arguments

[https://github.com/mapbox/postgis-vt-util/blob/master/postgis-vt-util.sql#L122-124]

2 arguments are expected.

In
[https://github.com/kartotherian/osm-bright.tm2source/blob/master/data.yml#L471]

3 arguments are passed.

Are the two files (.sql and .yml) out of sync because I'm not using the right util .sql version ?

Thanks

noury

Hello,

Appears that none of the airports' names are shown, even though runways and buildings are shown. I suspect this has to do with the source file as the style file handles airport labels exactly the same way Mapbox's version does (which works fine). The landuse polygons for airports are also not being rendered though they exist in the PBF (and in mapbox sources).

This issue exists even in the online version of Kartotherian.

Is this a known issue? I saw that this was fixed in the brightmed style but any plans of porting the fix to this source? If not I'll be happy to send a PR if you can provide clues as to how to fix this.

In Ubuntu 16.04 with Postgres 9.5, I get a geometries with different SRIDs error while running

psql -d gis -c 'select populate_admin();'

Changing line 32 of sql/admin.sql from:
result := ST_Intersection(way, water);

To:
result := ST_Intersection(ST_Transform(way, 3857), ST_Transform(water,3857));

Appears to have fixed. If this is correct, I'll send a PR.

I've built the tile server described here: https://porter.io/github.com/kartotherian/kartotherian and everything went very well except for one issue. The rivers are not rendered normally, the only thing that gets shown is a very thin blue line (middle line of the river) (lakes won't get shown at all).
Did I miss to configure an image path ? Train stations and harbours render well... (there are some images present)

Thanks for the great work !

I trying to config kartotherian with a local database with a partial cartography. In having difficolties. Did anyone Tried yet?

Hi,

we're not able to upload the map source data to our MapBox account. The upload process had started
but the progress bar stucked at 0.1%. Zoom level is 16. We use the free plan of MapBox service.
Approximately 30 tiles/sec are rendered during upload or export process. Is that value ok?