pg_tileserv

and ADD Web Mercator (yuck!)

will try to use the same executable, but with different config file & different startup script

    cd ~/openmaptiles/pg_tileserv/config
    vim merc_tileserv.toml

        HttpPort = 10491
        HttpsPort = 10491

        UrlBase = "http://merc.ilikecarrots.com/"

        [CoordinateSystem]
        SRID = 3857
        Xmin = -20037508.3427892
        Ymin = -20037508.3427892
        Xmax = 20037508.3427892
        zYmax = 20037508.3427892

and now to validate

start server:

    cd ~/openmaptiles/pg_tileserv
    ./serve_merc.sh

local test file at: gis/openmaptiles/pg_tileserv/examples/leaflet/merc-hrrr.html

hmm..., something seems mis-aligned

static merc-hrrr file retrieves: ?fcst=2021-10-09_12_03

Q: what if we just retrieve that date/phour/fhour from hrrr on rserver?

    psql
    \pset pager off
    \t
    \o hrrr_12_03.gjsn

select row_to_json(fc)
from ( select
        'FeatureCollection' as "type",
        array_to_json(array_agg(f)) as "features"
    from ( select
              'Feature' as "type",
              ST_AsGeoJSON(geom) :: json as "geometry"
           from hrrr
           where pdate = '2021-10-09' and phour = '12' and fhour = '03'
    ) as f
) as fc;

moderate in update ny: 2021-10-16
large cell over nd, line over ok..mo -13
moderate in central ky: 2021-10-15

merc versions of sql functions

edit as appropriate

compare

both are: date=2021_10_15, phour=12, fhour=03

direct from postgis:

ours: