Dynamic vector tiles not working?

[stevage]

Hi, I'm not sure if I'm doing something wrong, but all of my vector sources are returning 404s. I installed PGRestAPI and pointed it to my PostGIS instance, and also dropped a shapefile into the data/shapefiles directory.

PGRestAPI finds these data sources ok and creates endpoints for them (LGAvic is my shapefile):

Created vector tile service: /services/shapefile/Ken_CountyWithWater/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/shapefile/LGAvic/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/shapefile/kenya_coverage/vector-tiles/:z/:x/:y.*
SpatialServer listening on port 3001
Executing query: select * from geometry_columns where f_table_catalog = $1, gis
Created PBF .mbtiles service: /services/vector-tiles/KenyaCounties/:z/:x/:y.pbf
Executing query: select * from geometry_columns where f_table_catalog = $1, gis
Created vector tile service: /services/postgis/j/wkb_geometry/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/planet_osm_point/way/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/planet_osm_roads/way/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/planet_osm_polygon/way/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/planet_osm_line/way/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/j2/wkb_geometry/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/footprints/wkb_geometry/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/lga06gen0_05/wkb_geometry/vector-tiles/:z/:x/:y.*
Created vector tile service: /services/postgis/buildingfootprints/wkb_geometry/vector-tiles/:z/:x/:y.*
Created single tile service (postgis): /services/postgis/j/wkb_geometry/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/planet_osm_point/way/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/planet_osm_roads/way/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/planet_osm_polygon/way/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/planet_osm_line/way/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/j2/wkb_geometry/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/footprints/wkb_geometry/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/lga06gen0_05/wkb_geometry/dynamicSingleMap/*
Created single tile service (postgis): /services/postgis/buildingfootprints/wkb_geometry/dynamicSingleMap/*
Created multi tile service (postgis): /services/postgis/j/wkb_geometry/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/planet_osm_roads/way/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/planet_osm_point/way/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/planet_osm_polygon/way/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/planet_osm_line/way/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/j2/wkb_geometry/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/footprints/wkb_geometry/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/lga06gen0_05/wkb_geometry/dynamicMap/:z/:x/:y.*
Created multi tile service (postgis): /services/postgis/buildingfootprints/wkb_geometry/dynamicMap/:z/:x/:y.*
<?xml version="1.0" encoding="utf-8"?>

They are listed in the "Table Listing" page, and the preview under "Dynamic Map Service" (raster tiles) works correctly.

However, vector tiles don't seem to get generated. The endpoint provided seems sensible: .../services/postgis/j2/wkb_geometry/vector-tiles/{z}/{x}/{y}.pbf; but all the vector tiles return 404. For example, .../services/postgis/j2/wkb_geometry/vector-tiles/12/3696/2514.pbf.

On the server side, there's not much output:

<?xml version="1.0" encoding="utf-8"?>
<Map srs="+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs +over" buffer-size="10">
    <Layer name="j2_wkb_geometry" srs="+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs">
        <StyleName>j2</StyleName>
        <StyleName>default</StyleName>
        <Datasource>
            <Parameter name="dbname">gis</Parameter>
            <Parameter name="estimate_extent">false</Parameter>
            <Parameter name="geometry_field">wkb_geometry</Parameter>
            <Parameter name="geometry_type">MULTIPOLYGON</Parameter>
            <Parameter name="host">127.0.0.1</Parameter>
            <Parameter name="layerName">default</Parameter>
            <Parameter name="password">ubuntu</Parameter>
            <Parameter name="port">5432</Parameter>
            <Parameter name="srid">3857</Parameter>
            <Parameter name="table">(SELECT wkb_geometry from &quot;j2&quot;) as &quot;j2&quot;</Parameter>
            <Parameter name="type">postgis</Parameter>
            <Parameter name="user">ubuntu</Parameter>
        </Datasource>
    </Layer>
</Map>

No cached response for: /services/postgis/j2/wkb_geometry/vector-tiles/12/3696/2514.pbf.  Generating.
GET /services/postgis/j2/wkb_geometry/vector-tiles/12/3696/2514.pbf 404 221ms

Meanwhile, the shapefiles don't seem to appear anywhere in the web interface. Perhaps that part isn't implemented, judging from the readme. For instance, I can't see the included "kenya_coverage" or "Ken_CountyWithWater" shapefiles either.

The shapefile endpoints seem to return 404 (/services/shapefile/kenya_coverage/vector-tiles/7/76/64.pbf ), but perhaps I'm just requesting the wrong thing.

[apollolm]

I see where the problem lies. I'm not properly asking for the SRID in the vector tiles route - I'm assuming 4326. I'll update this to use either 4326 or 3857 (those are the only options for the moment) and push shortly.

[stevage]

Awesome, that worked!