add-scale-to-wmts-layers.sql - This adds one scale (id 15) …

/content-resources/src/main/resources/sql/upgrade/1.20/add-scale-to-wmts-layers.sql

https://github.com/nls-oskari/oskari-server · SQL · 366 lines · 365 code · 0 blank · 1 comment · 0 complexity · 524687ffc7a395d31bab1bf5a50ed4dd MD5 · raw file

-- This adds one scale (id 15) to all WMTS layers of National land survey of Finland;
UPDATE oskari_maplayer SET tile_matrix_set_data='{
    "operationsMetadata": {
        "GetCapabilities": {
            "dcp": {
                "http": {
                    "get": [
                        {
                            "url": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts?",
                            "constraints": {
                                "GetEncoding": {
                                    "allowedValues": {
                                        "KVP": true
                                    }
                                }
                            }
                        }
                    ]
                }
            }
        },
        "GetTile": {
            "dcp": {
                "http": {
                    "get": [
                        {
                            "url": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts?",
                            "constraints": {
                                "GetEncoding": {
                                    "allowedValues": {
                                        "KVP": true
                                    }
                                }
                            }
                        }
                    ]
                }
            }
        },
        "GetFeatureInfo": {
            "dcp": {
                "http": {
                    "get": [
                        {
                            "url": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts?",
                            "constraints": {
                                "GetEncoding": {
                                    "allowedValues": {
                                        "KVP": true
                                    }
                                }
                            }
                        }
                    ]
                }
            }
        }
    },
    "contents": {
        "layers": [
            {
                "styles": [
                    {
                        "isDefault": true,
                        "identifier": "default"
                    }
                ],
                "formats": ["image/png"],
                "dimensions": [],
                "tileMatrixSetLinks": [
                    {
                        "tileMatrixSet": "ETRS-TM35FIN"
                    }
                ],
                "layers": [],
                "title": "Taustakartta",
                "identifier": "taustakartta",
                "resourceUrl": {
                    "tile": {
                        "format": "image/png",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/taustakartta/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.png",
                        "resourceType": "tile"
                    }
                },
                "resourceUrls": [
                    {
                        "format": "image/png",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/taustakartta/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.png",
                        "resourceType": "tile"
                    }
                ]
            }, {
                "styles": [
                    {
                        "isDefault": true,
                        "identifier": "default"
                    }
                ],
                "formats": ["image/jpeg"],
                "dimensions": [],
                "tileMatrixSetLinks": [
                    {
                        "tileMatrixSet": "ETRS-TM35FIN"
                    }
                ],
                "layers": [],
                "title": "Ortokuva",
                "identifier": "ortokuva",
                "resourceUrl": {
                    "tile": {
                        "format": "image/jpeg",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/ortokuva/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.jpg",
                        "resourceType": "tile"
                    }
                },
                "resourceUrls": [
                    {
                        "format": "image/jpeg",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/ortokuva/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.jpg",
                        "resourceType": "tile"
                    }
                ]
            }, {
                "styles": [
                    {
                        "isDefault": true,
                        "identifier": "default"
                    }
                ],
                "formats": ["image/png"],
                "dimensions": [],
                "tileMatrixSetLinks": [
                    {
                        "tileMatrixSet": "ETRS-TM35FIN"
                    }
                ],
                "layers": [],
                "title": "Maastokartta",
                "identifier": "maastokartta",
                "resourceUrl": {
                    "tile": {
                        "format": "image/png",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/maastokartta/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.png",
                        "resourceType": "tile"
                    }
                },
                "resourceUrls": [
                    {
                        "format": "image/png",
                        "template": "http://karttamoottori.maanmittauslaitos.fi/maasto/wmts/1.0.0/maastokartta/default/{TileMatrixSet}/{TileMatrix}/{TileRow}/{TileCol}.png",
                        "resourceType": "tile"
                    }
                ]
            }
        ],
        "tileMatrixSets": {
            "ETRS-TM35FIN": {
                "matrixIds": [
                    {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "0",
                        "scaleDenominator": 29257142.85714286,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 1,
                        "matrixHeight": 1
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "1",
                        "scaleDenominator": 14628571.42857143,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 2,
                        "matrixHeight": 2
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "2",
                        "scaleDenominator": 7314285.714285715,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 4,
                        "matrixHeight": 4
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "3",
                        "scaleDenominator": 3657142.8571428573,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 8,
                        "matrixHeight": 8
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "4",
                        "scaleDenominator": 1828571.4285714286,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 16,
                        "matrixHeight": 16
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "5",
                        "scaleDenominator": 914285.7142857143,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 32,
                        "matrixHeight": 32
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "6",
                        "scaleDenominator": 457142.85714285716,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 64,
                        "matrixHeight": 64
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "7",
                        "scaleDenominator": 228571.42857142858,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 128,
                        "matrixHeight": 128
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "8",
                        "scaleDenominator": 114285.71428571429,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 256,
                        "matrixHeight": 256
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "9",
                        "scaleDenominator": 57142.857142857145,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 512,
                        "matrixHeight": 512
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "10",
                        "scaleDenominator": 28571.428571428572,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 1024,
                        "matrixHeight": 1024
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "11",
                        "scaleDenominator": 14285.714285714286,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 2048,
                        "matrixHeight": 2048
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "12",
                        "scaleDenominator": 7142.857142857143,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 4096,
                        "matrixHeight": 4096
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "13",
                        "scaleDenominator": 3571.4285714285716,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 8192,
                        "matrixHeight": 8192
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "14",
                        "scaleDenominator": 1785.7142857142858,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 16384,
                        "matrixHeight": 16384
                    }, {
                        "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067",
                        "identifier": "15",
                        "scaleDenominator": 892.85714285714288962481,
                        "topLeftCorner": {
                            "lon": -548576,
                            "lat": 8388608
                        },
                        "tileWidth": 256,
                        "tileHeight": 256,
                        "matrixWidth": 32768,
                        "matrixHeight": 32768
                    }
                ],
                "identifier": "ETRS-TM35FIN",
                "projection": "urn:ogc:def:crs:EPSG:6.3:3067",
                "bounds": {
                    "left": -548576,
                    "bottom": 6291456,
                    "right": 1548576,
                    "top": 8388608
                },
                "supportedCRS": "urn:ogc:def:crs:EPSG:6.3:3067"
            }
        }
    },
    "version": "1.0.0"
}' WHERE url='http://karttamoottori.maanmittauslaitos.fi/maasto/wmts';