Questions tagged [pg-tileserv]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
2 answers
67 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 ...
user avatar
  • 41
1 vote
0 answers
50 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' ) ...
user avatar
  • 41
0 votes
0 answers
66 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 ...
user avatar
2 votes
3 answers
331 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 ...
user avatar
  • 4,065
0 votes
0 answers
90 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 ...
user avatar
  • 1
0 votes
1 answer
417 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, { ...
user avatar
  • 4,065
2 votes
1 answer
87 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://...
user avatar
  • 4,065