Questions tagged [pg-tileserv]

Use this tag for questions about the pg_tileserv tile server for PostGIS (https://github.com/CrunchyData/pg_tileserv).

Filter by
Sorted by
Tagged with
1 vote
1 answer
43 views

Custom PostGIS function not visible in pg_tileserv layer list

I have created a new PostgreSQL function whose code is below CREATE OR REPLACE FUNCTION public."my_test"( layerid integer, z integer, x integer, y integer) RETURNS bytea ...
Asad Abbas's user avatar
  • 1,634
0 votes
0 answers
287 views

Slow performance of ST_AsMVT for huge PostGIS database

I am fetching MVT tiles from a PostGIS database in combination with pg_tileserve. When fetching tiles from a fairly small dataset (some 10000 features) this works quite performant. But when fetching ...
tile_consumer's user avatar
1 vote
0 answers
143 views

GeoJSON or VectorTiles for dynamic large dataset - when to use which one? [closed]

Assuming that the goal is to develop a web application with a static basemap (can be raster tiles) and multiple layers, which: are stored in a PostGIS database have a big amount of features include ...
Robbert's user avatar
  • 39
0 votes
1 answer
400 views

pg_tileserv Docker - How to access and modify the configuration file? [closed]

I set up pg_tileserv. Once using the binary file and once using Docker. Downloading the binary includes a config .toml file. How can I access this file when I set up pg_tileserv with Docker? There are ...
Robbert's user avatar
  • 39
1 vote
0 answers
332 views

pg_tileserv much slower than pg_featureserv?

I'm serving data where the geometry is very simple (a grid of squares, about 1500 of them total, no big deal) but the attribute data would be a json object, quite big (about 3000 characters). I'm ...
Jean Pommier's user avatar
3 votes
2 answers
214 views

Create a new table, sorted by st_area function in descending order

I have a very large table in postgis which has more than 10 million polygons and I wanted to create a function using this table for pg_tileserv but the problem is the size of table which takes too ...
DARK's user avatar
  • 41
1 vote
0 answers
254 views

Passing table name as an argument in PostGIS function [closed]

How can I pass my table name as an argument of a function? CREATE OR REPLACE FUNCTION public.countries_name1( z integer, x integer , y integer, name_prefix text default 'B' ) ...
DARK's user avatar
  • 41
1 vote
0 answers
362 views

How do I reference Source-Layer in a pg_tileserv service?

this is the first time i'm trying to style a vectortile-service so i might be thinking completely wrong, but .... I have set up a pg_tileserv that shows all geometries. when I then want to specify the ...
10gbrand's user avatar
3 votes
3 answers
2k views

Postgres/PG_Tileserv increase speed

I need to increase the drawing speed of the tables/functions served up by pg_tileserv for a leaflet map. I am running pg_tileserv on a digital ocean server with 2cpus, 4GB memory, 25 GB SSD and 4TB ...
ziggy's user avatar
  • 4,480
0 votes
0 answers
228 views

pg_tileserv SET DATABASE_URL return

I'm trying to set the SET DATABASE_URL for pg_tileserv in the cmd terminal using: DATABASE_URL=postgresql://postgres:[password]@127.0.0.1:60999/pgr which seems to be accepted. But when I start ...
Winni's user avatar
  • 1
1 vote
1 answer
1k views

Styling pg_tileserv pbf in leaflet

I am having a ton of trouble styling my pbf tile service rendered from pg_tileserv in a leaflet map. here is my code L.vectorGrid.protobuf(http://localhost:7800/data_oh.parcel/{z}/{x}/{y}.pbf, { ...
ziggy's user avatar
  • 4,480
2 votes
1 answer
238 views

pg_tileserv database connection string specify port

I am trying to connect a DB to pg_tileserv following these directions https://github.com/CrunchyData/pg_tileserv/blob/master/README.md it says after download for windows: SET DATABASE_URL=postgresql://...
ziggy's user avatar
  • 4,480