Questions tagged [pg-tileserv]
The pg-tileserv tag has no usage guidance.
7
questions
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 ...
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' )
...
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 ...
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 ...
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 ...
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, {
...
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://...