284 lines
20 KiB
SQL
Executable File
284 lines
20 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
INSERT INTO asm.asm_location(id, name, description) VALUES (9, 'Default', 'Default location');
|
|
ALTER SEQUENCE asm.asm_location_id_seq RESTART WITH 10;
|
|
|
|
-- Dev Workstations
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (301, 'CTCAP01', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (302, 'CTCAP02', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (303, 'CTCAP03', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (304, 'CTCAP04', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (305, 'CTCAP05', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (306, 'CTCAP06', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (307, 'CTCAP07', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (308, 'CTCAP08', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (309, 'CTCAP09', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (310, 'CTCAP10', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (311, 'CTCAP11', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (312, 'CTCAP12', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (313, 'CTCAP13', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (314, 'CTCAP14', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (315, 'CTCAP15', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (316, 'CTCAP16', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (317, 'CTCAP17', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (318, 'CTCAP18', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (319, 'CTCAP19', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (320, 'CTCAP20', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (321, 'CTCAP21', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (322, 'CTCAP22', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (323, 'CTCAP23', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (324, 'CTCAP24', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (325, 'CTCAP25', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (326, 'CTCAP26', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (327, 'CTCAP27', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (328, 'CTCAP28', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (329, 'CTCAP29', 1, 9);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (330, 'LTSSV01', 1, 9);
|
|
|
|
-- Adler SAA (IP for now, name of the server when known)
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id, properties) VALUES (331, '192.168.133.55', 6, 8, '{"Username": "rde", "Password" : "mout11de" }');
|
|
|
|
|
|
ALTER SEQUENCE asm.asm_asset_id_seq RESTART WITH 332;
|
|
|
|
|
|
-- map_description (available via TrainingArea)
|
|
-- map_desc_type_id: 1=2D ; 2=3D ; 3=Ele ;4=SceneObj
|
|
-- map_type_id: Topo=1 ; Aerial=2
|
|
-- TA,MD,MT,Or,
|
|
DELETE from asm.asm_map_description where training_area_id=6 ; -- 6==Bremen
|
|
-- 2D
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Norddeutschland OSM', 'Norddeutschland OSM', 6, 1, 1, 0, 'http://excgeo21.sl.defence-elec.de/arcgis/rest/services/Norddeutschland/Norddeutschland_32632/MapServer', -1, 125);
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Hemelingen Aerial GeoAmt', 'HemelingenAerialGeoAmt', 6, 1, 2, 1, 'http://excgeo21.sl.defence-elec.de/arcgis/rest/services/Bremen/BremenHemelingenAerialGeoAmt_32632/MapServer', -1, 125);
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Werk Aerial Drone', 'Werk Aerial Drone', 6, 1, 2, 2, 'http://excgeo21.sl.defence-elec.de/arcgis/rest/services/Bremen/BremenWerkAerialDrone_32632/MapServer', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Norddeutschland OSM', 'Norddeutschland OSM', 6, 1, 1, 0, 'file:TilePackage/Bremen/Norddeutschland_osm_32632.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Norddeutschland OSM', 'Norddeutschland OSM', 6, 2, 1, 0, 'http://excgeo21.sl.defence-elec.de/arcgis/rest/services/Norddeutschland/Norddeutschland_WebMerc/MapServer', -1, 125);
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Hemelingen Aerial GeoAmt', 'HemelingenAerialGeoAmt', 6, 2, 2, 1, 'http://excgeo21.sl.defence-elec.de/arcgis/rest/services/Bremen/Hemelingen_TIF_WebMerc/MapServer', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Norddeutschland OSM', 'Norddeutschland OSM', 6, 2, 1, 0, 'file:TilePackage/Bremen/Norddeutschland_osm_WebMerc17.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Elevation', 'Elevation', 6, 3, 4, 0, 'file:srtm_38_02.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Unterlüß START
|
|
------------------------
|
|
|
|
-- bottom_left: 32U ND 82000 53000 = lon, lat: 10.216853, 52.820529 (0.178317724042, 0.921892143693)
|
|
-- Unterlüß/Unterluess/Rheinmetall
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (7, 'Unterlüß', 0.178317724042, 0.921892143693, 19000, 9000);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 8;
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=7 ; -- 7==Unterlüß/Unterluess
|
|
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Unterlüß Topographic', 'Unterlüß Topographic', 7, 1, 1, 0, 'file:TilePackage/Unterluess/', -1, 125);
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Unterlüß Aerial', 'Unterlüß Aerial', 7, 1, 2, 1, 'file:TilePackage/Unterluess/2021-10-14_Unterluess_Aerial_32632.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Unterlüß Topographic', 'Unterlüß Topographic', 2, 2, 1, 0, 'file:TilePackage/Unterluess/', -1, 125);
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Unterlüß Aerial', 'Unterlüß Aerial', 7, 2, 2, 1, 'file:Topographic.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Elevation', 'Elevation', 7, 3, 4, 0, 'file:e010n52_TFRM.dt2', -1, -1);
|
|
------------------------
|
|
-- Unterlüß ENDE
|
|
------------------------
|
|
|
|
|
|
------------------------
|
|
-- Luxemburg START
|
|
------------------------
|
|
|
|
-- bottom_left: 31U FQ 96000 75500 = lon, lat: 5.701584, 49.400601 (0.099511413379028, 0.862203139914)
|
|
-- Luxemburg
|
|
-- ACHTUNG: autom. erzeugter MGRS-basepoint wird hier wahrscheinlich passen!!!
|
|
DELETE FROM asm.asm_training_area WHERE id = 8;
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (8, 'Luxemburg', 0.099511413379028, 0.862203139914, 60000, 75000);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 9;
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=8 ; -- 8==Luxemburg
|
|
|
|
--INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
-- VALUES ('Unterlüß Topographic', 'Unterlüß Topographic', 8, 1, 1, 0, 'file:TilePackage/Unterluess/', -1, 125);
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Luxemburg Aerial', 'Luxemburg Aerial', 8, 1, 2, 1, 'file:TilePackage/Luxemburg/2023-07-10_Luxemburg_Aerial_0m1_2169_Lvl_10.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Luxemburg Aerial', 'Luxemburg Aerial', 8, 2, 2, 1, 'file:Topographic.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Luxemburg Elevation', 'Luxemburg Elevation', 8, 3, 4, 0, 'file:2023-07-11_elevationLuxemburg.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Luxemburg ENDE
|
|
------------------------
|
|
|
|
|
|
-- Eckernfoerde 9
|
|
-- Algeria Hassi Bahbah 10
|
|
-- Algeria Zaafrane 11
|
|
|
|
------------------------
|
|
-- Litauen-Rukla START
|
|
------------------------
|
|
|
|
-- Litauen-Rukla
|
|
-- ACHTUNG: autom. erzeugter MGRS-basepoint wird hier wahrscheinlich passen!!!
|
|
DELETE FROM asm.asm_training_area WHERE id = 12;
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (12, 'Lithuania', 0.423547, 0.958963, 17000, 15000);
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=12 ; -- 12==Litauen-Rukla
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Lithuania Aerial', 'Lithuania Rukla Aerial', 12, 1, 2, 1, 'file:TilePackage/Lithuania_Rukla/2024-07-03-Lith_Rukla_aerial_0m5_32635.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Lithuania Aerial', 'Lithuania Rukla Aerial', 12, 2, 2, 1, 'file:TilePackage/Lithuania_Rukla/2024-07-03-Lith_Rukla_aerial_0m5_WebMerc.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Lithuania Elevation', 'Lithuania Rukla Elevation', 12, 3, 4, 0, 'file:2024-07-03_Lith_Rukla_elevation.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Litauen-Rukla ENDE
|
|
------------------------
|
|
|
|
|
|
------------------------
|
|
-- Hungary-Varpalota PREVIEW START
|
|
------------------------
|
|
|
|
-- Hungary-Varpalota
|
|
-- ACHTUNG: autom. erzeugter MGRS-basepoint wird hier wahrscheinlich passen!!!
|
|
DELETE FROM asm.asm_training_area WHERE id = 13;
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (13, 'Varpalota-Preview', 0.314161, 0.822488, 5000, 5000);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 14;
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=13 ; -- 12==Hungary-Varpalota PREVIEW
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Varpalota Preview Topographic', 'Hungary-Varpalota Preview Topographic', 13, 1, 1, 0, 'file:TilePackage/Hungary/2024-07-30_Hungary_Varpalota_topographic_32634.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Varpalota Preview Aerial', 'Hungary-Varpalota Preview Aerial', 13, 1, 2, 1, 'file:TilePackage/Hungary/2024-07-29_Hungary_Varpalota_aerial_32634.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Varpalota Preview Topographic', 'Hungary-Varpalota Preview Topographic', 13, 2, 1, 0, 'file:TilePackage/Hungary/2024-07-30_Hungary_Varpalota_topographic_WebMerc.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Varpalota Preview Aerial', 'Hungary-Varpalota Preview Aerial', 13, 2, 2, 1, 'file:TilePackage/Hungary/2024-07-29_Hungary_Varpalota_aerial_WebMerc.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Hungary-Varpalota Preview', 'Hungary-Varpalota Preview Elevation', 13, 3, 4, 0, 'file:2024-07-30_Hungary_Varpalota_DDM10_WGS84.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Hungary-Varpalota PREVIEW ENDE
|
|
------------------------
|
|
|
|
------------------------
|
|
-- Finland-Pohjankagas START
|
|
------------------------
|
|
|
|
-- Finland-Pohjankagas
|
|
-- ACHTUNG: autom. erzeugter MGRS-basepoint wird hier wahrscheinlich passen!!!
|
|
DELETE FROM asm.asm_training_area WHERE id = 14;
|
|
|
|
-- BottomLeft: 34 V EP 68500 55000
|
|
-- Lat: 61,821675 rad: 1,07899177785
|
|
-- Lon: 22,300288 rad: 0,389213449742
|
|
-- Breite: 19km Höhe: 27km
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (14, 'Pohjankagas-Preview', 0.389213449742, 1.07899177785, 27000, 19000);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 15;
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=14 ; -- 14==Finland-Pohjankagas PREVIEW
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankagas Topographic', 'Finland-Pohjankagas Topographic', 14, 1, 1, 0, 'file:TilePackage/Finland/2025-03-04_Finland_Pohjankagas_Topo_1m_32634.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankagas Aerial', 'Finland-Pohjankagas Aerial', 14, 1, 2, 1, 'file:TilePackage/Finland/2025-03-04_Finland_Pohjankagas_Aerial_0m5_32634.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankagas Aerial', 'Finland-Pohjankagas Topographic', 14, 2, 1, 0, 'file:TilePackage/Finland/2025-03-04_Finland_Pohjankagas_Topo_1m_WebMerc.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankagas Aerial', 'Finland-Pohjankagas Aerial', 14, 2, 2, 1, 'file:TilePackage/Finland/2025-03-04_Finland_Pohjankagas_Aerial_0m5_WebMerc.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Finland-Pohjankagas', 'Finland-Pohjankagas Elevation', 14, 3, 4, 0, 'file:2025-03-06_Finland-Pohjankagas_elevation.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Finland-Pohjankagas ENDE
|
|
------------------------
|
|
|
|
-- Anfang April 2025 wurden Finnland-Daten nachgeliefert.
|
|
-- Dabei ist eine fehlerhafte Benennung einer bereits zuvor an RME gelieferten Datei aufgefallen:
|
|
-- Pohjankagas vs.
|
|
-- Pohjankangas
|
|
-- Diesem wird nun in den Anzeigenamen angepasst:
|
|
|
|
------------------------
|
|
-- Finland-Pohjankagas _BW_ START
|
|
------------------------
|
|
|
|
-- Finland-Pohjankangas
|
|
-- ACHTUNG: autom. erzeugter MGRS-basepoint wird hier wahrscheinlich passen!!!
|
|
DELETE FROM asm.asm_training_area WHERE id = 15;
|
|
|
|
-- BottomLeft: 34 V EP 68500 55000
|
|
-- Lat: 61,821675 rad: 1,07899177785
|
|
-- Lon: 22,300288 rad: 0,389213449742
|
|
-- Breite: 19km Höhe: 27km
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (15, 'Pohjankangas-BW', 0.389213449742, 1.07899177785, 27000, 19000);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 16;
|
|
|
|
DELETE from asm.asm_map_description where training_area_id=15 ; -- 15==Finland-Pohjankangas PREVIEW
|
|
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Aerial overview', 'Finland-Pohjankangas Aerial overview', 15, 1, 2, 0, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_overview_BW_Aerial_2m_32634.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Topographic' , 'Finland-Pohjankangas Topographic', 15, 1, 1, 1, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_BW_Topo_1m_32634.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Aerial' , 'Finland-Pohjankangas Aerial', 15, 1, 2, 2, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_BW_Aerial_1m_32634.tpk', -1, 125);
|
|
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Aerial overview', 'Finland-Pohjankangas Aerial overview', 15, 2, 2, 0, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_overview_BW_Aerial_2m_WebMerc.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Topographic' , 'Finland-Pohjankangas Topographic', 15, 2, 1, 1, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_BW_Topo_1m_WebMerc.tpk', -1, 125);
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Pohjankangas Aerial' , 'Finland-Pohjankangas Aerial', 15, 2, 2, 2, 'file:TilePackage/Finland/2025-04-04_Finland_Pohjankagas_BW_Aerial_1m_WebMerc.tpk', -1, 125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ('Finland-Pohjankangas', 'Finland-Pohjankangas Elevation', 15, 3, 4, 0, 'file:2025-03-06_Finland-Pohjankagas_elevation.tif', -1, -1);
|
|
|
|
------------------------
|
|
-- Finland-Pohjankagas _BW_ ENDE
|
|
------------------------
|
|
|
|
|
|
--ALTER SEQUENCE asm.asm_map_description_id_seq RESTART WITH 7;
|