| 123456789101112131415161718192021 |
- #! /usr/bin/bash
- # Lae keskkonnamuutujad
- source env.sh
- # Testimise piirkond
- psql ${CONNECTION_NAME} -c "
- -- Valga halduspiirkonna järgi
- DROP TABLE IF EXISTS ${destination_schema}.test_links;
- CREATE TABLE ${destination_schema}.test_links AS
- SELECT h.eid,
- h.highway,
- h.surface,
- h.oneway,
- h.maxspeed,
- h.name,
- ST_Transform(h.geom, 3301) AS geom
- FROM ${destination_schema}.links h
- JOIN ${destination_schema}.administrative p
- ON ST_Intersects(h.geom, p.geom)
- WHERE p.name like 'Valga%' AND p.admin_level = '7';
- "
|
