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
0 answers
31 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 ...
  • 47
0 votes
1 answer
169 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 ...
  • 47
1 vote
0 answers
232 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 ...
3 votes
2 answers
151 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 ...
  • 41
1 vote
0 answers
192 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' ) ...
  • 41
1 vote
0 answers
215 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 ...
3 votes
3 answers
1k 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 ...
  • 4,320
0 votes
0 answers
152 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 ...
  • 1
1 vote
1 answer
730 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, { ...
  • 4,320
2 votes
1 answer
158 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://...
  • 4,320