Questions tagged [pg-tileserv]
Use this tag for questions about the pg_tileserv tile server for PostGIS (https://github.com/CrunchyData/pg_tileserv).
10
questions
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 ...
- 11
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 ...
- 11
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