| -- Licensed under the Apache License, Version 2.0 (the License); you may not use this file except |
| -- in compliance with the License. You may obtain a copy of the License at |
| -- |
| -- http://www.apache.org/licenses/LICENSE-2.0 |
| -- |
| -- Unless required by applicable law or agreed to in writing, software distributed under the License |
| -- is distributed on an AS IS BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express |
| -- or implied. See the License for the specific language governing permissions and limitations under |
| -- the License. |
| CREATE MATERIALIZED VIEW osm_ocean AS |
| SELECT row_number() OVER () as id, '{"ocean":"water"}'::jsonb as tags, st_setsrid(geometry, 3857) AS geom FROM water_polygons_shp; |
| |
| CREATE MATERIALIZED VIEW osm_ocean_simplified AS |
| SELECT row_number() OVER () as id, '{"ocean":"water"}'::jsonb as tags, st_setsrid(geometry, 3857) AS geom FROM simplified_water_polygons_shp; |
