284 lines
26 KiB
SQL
Executable File
284 lines
26 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- 32U MD 8800000 7500000 = lon, lat: 8.8210891905, 53.0244018451 (0.1539570500, 0.9254503961)
|
|
DELETE FROM asm.asm_training_area;
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (6, 'Bremen', 0.1539570500, 0.9254503961, 12800, 12800);
|
|
----------------------------
|
|
-- Qatar-Original-Areas
|
|
----------------------------
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 26,'Miqdam Camp',0.8958463408,0.4440574891,5000,5000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 27,'ABM Military College',0.89375701727,0.44043608822,15000,15000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 28,'aShamalia',0.89080784717,0.430350668225,12000,12000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 29,'Beach Area Zekreet',0.88660212727,0.4444554244,7500,5000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 31,'Emiri Guard Camp',0.89445274042041,0.44169593668276,6000,11000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 32,'Doha',0.89496611156659,0.43870032336781,31000,33000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 33,'Al Galail Shooting Range',0.88772538627,0.429970902033,25000,20000);
|
|
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 34,'Simaisma Islands',0.89793156559207,0.44468233465927,12000,13000);
|
|
|
|
----------------------------
|
|
-- Qatar-Fallback-Areas
|
|
----------------------------
|
|
-- 39R WJ 33000 14000 = 51.3282144 25.44262 (0.8958463408, 0.4440574891)
|
|
|
|
-- 39R WH 00001 65000 = 51.015015 25.003484 (0.89038, 0.4363931202697)
|
|
-- 39R WH 00001 00001 =
|
|
-- (VJ, WJ, VH,WH -> part of the MGRS-Coordinates)
|
|
|
|
-- Wahrscheinlich ist Qatar als Ganzes ausreichend, aber da die view Qatar X Y schon mal da sind:
|
|
-- Und die kleinen Fallback TrainingAreas sind zu bevorzugen, da dann positive Werte gen Gefechtsfeld/LogView gehen.
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 35,'Qatar North West (VJ)',0.87277857, 0.44179902, 100000, 100000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 36,'Qatar North East (WJ)',0.89011818, 0.44185745, 100000, 100000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 37,'Qatar South West (VH)',0.87290405, 0.42603886, 100000, 100000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 38,'Qatar South East (WH)',0.89011818, 0.42609494, 100000, 100000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 39,'Qatar', 0.88107900, 0.42647300, 225000, 225000);
|
|
----------------------------
|
|
-- ENDE Qatar-Fallback-Areas
|
|
----------------------------
|
|
|
|
----------------------------
|
|
-- Qatar-Areas Frm Planet 2021/2022
|
|
----------------------------
|
|
-- Barzan Camp -> NSA -> Miqdam Camp
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 40,'ABM Military College 2022',0.89368800000, 0.4405310000, 15500, 12000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 41,'Miqdam Camp 2022' ,0.89606100000, 0.4440200000, 5000, 5000);
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES ( 42,'Doha 2022' ,0.89655000000, 0.4386680000, 32500, 30000);
|
|
|
|
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 100;
|
|
|
|
|
|
|
|
-- default values for Technical areas
|
|
-- Barzan Camp: TODO: correct position_x, position_y, width, length
|
|
-- INSERT INTO asm.asm_technical_area (id, name, training_area_id, position_x, position_y, width, length, charge_type_id)
|
|
-- VALUES (1, 'Mout Area', 26, 0.914687, 0.419669, 725, 460, 421);
|
|
-- INSERT INTO asm.asm_technical_area (id, name, training_area_id, position_x, position_y, width, length, charge_type_id)
|
|
-- VALUES (2, 'Mout Area', 41, 0.914687, 0.419669, 725, 460, 421);
|
|
-- Bremen
|
|
-- INSERT INTO asm.asm_technical_area (id, name, training_area_id, position_x, position_y, width, length, charge_type_id)
|
|
-- VALUES (3, 'Mout Area', 6, 0.155279386360796, 0.92597355781270696, 91, 69, 421);
|
|
|
|
-- ALTER SEQUENCE asm.asm_technical_area_id_seq RESTART WITH 4;
|
|
|
|
|
|
-- 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;
|
|
-- 2D
|
|
----------------------------
|
|
-- Qatar-Originals
|
|
----------------------------
|
|
-- Barzan Camp -> NSA -> Miqdam Camp
|
|
-- TA,MD,MT,Or,
|
|
DELETE FROM asm.asm_map_description;
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 1,'Miqdam Camp Aerial', 'Miqdam Camp Aerial', 26, 1, 2, 0,'file:TilePackage/BarzanCamp/BarzanCamp_32639_Level8.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 2,'Miqdam Camp Aerial','Miqdam Camp Aerial', 26, 2, 2, 0,'file:TilePackage/BarzanCamp/BarzanCamp_WebMerc_Level19.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 3,'Military College','Military College', 27, 1, 2, 0,'file:TilePackage/Qatar/2020-01-29_Qatar_MilitaryCollage_0m50_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 4,'South Camp','South Camp', 28, 1, 2, 0,'file:TilePackage/Qatar/2020-04-21_QatarSouthCamp_aShamalia_aerial_0m50_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 5,'Beach Area Zekreet','Beach Area Zekreet', 29, 1, 2, 0,'file:TilePackage/Qatar/2020-02-19_Qatar_BeachAreaZekreet_0m50_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 8,'Emiri Guard Camp','Emiri Guard Camp', 31, 1, 2, 0,'file:TilePackage/Qatar/2020-11-18_Qatar_EmiriGuardCamp_1m_32639.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 9,'Emiri Guard Camp','Emiri Guard Camp', 31, 2, 2, 0,'file:TilePackage/Qatar/2020-11-18_Qatar_EmiriGuardCamp_1m_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 10,'Doha','Doha', 32, 1, 2, 0,'file:TilePackage/Qatar/2020-11-19_Qatar_Doha_1m_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 11,'Al Galail Shooting Range', 'Al Galail Shooting Range', 33, 1, 2, 0,'file:TilePackage/Qatar/2020-11-19_Qatar_SouthArea_10m_32639.tpk',-1,125);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 12,'Simaisma Islands', 'Simaisma Islands', 34, 1, 2, 0,'file:TilePackage/Qatar/2021-01-29_Qatar_Simaisma_Islands_1m_32639.tpk',-1,125);
|
|
|
|
----------------------------
|
|
-- Qatar-Fallback-Areas
|
|
----------------------------
|
|
-- 2D TA,MD,MT,Or,
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 21,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 35, 1, 2, 2,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 22,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 35, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 23,'Qatar OSM', 'Qatar OSM', 35, 1, 1, 0,'file:TilePackage/Qatar/2022-06-23_Qatar_OSM_32639.vtpk',-1,125);
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 24, 'Elevation', 'Elevation', 35, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 31,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 36, 1, 2, 2,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 32,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 36, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 33,'Qatar OSM', 'Qatar OSM', 36, 1, 1, 0,'file:TilePackage/Qatar/2022-06-23_Qatar_OSM_32639.vtpk',-1,125);
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 34, 'Elevation', 'Elevation', 36, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 41,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 37, 1, 2, 2,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 42,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 37, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 43,'Qatar OSM', 'Qatar OSM', 37, 1, 1, 0,'file:TilePackage/Qatar/2022-06-23_Qatar_OSM_32639.vtpk',-1,125);
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 44, 'Elevation', 'Elevation', 37, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 51,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 38, 1, 2, 2,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 52,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 38, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 53,'Qatar OSM', 'Qatar OSM', 38, 1, 1, 0,'file:TilePackage/Qatar/2022-06-23_Qatar_OSM_32639.vtpk',-1,125);
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 54, 'Elevation', 'Elevation', 38, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 55,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 39, 1, 2, 2,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 56,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 39, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 57,'Qatar OSM', 'Qatar OSM', 39, 1, 1, 0,'file:TilePackage/Qatar/2022-06-23_Qatar_OSM_32639.vtpk',-1,125);
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 58, 'Elevation', 'Elevation', 39, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
|
|
-- END Qatar-Fallback-Areas
|
|
----------------------------
|
|
|
|
|
|
-- 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,
|
|
-- ABM Military College
|
|
-- 2D
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 61,'ABM Military College Aerial 2022', 'ABM Military College Aerial 2022', 40, 1, 2, 3,'file:TilePackage/Qatar/2021-12-16_Qatar_ABMMC_Aerial_50cm_32639_Lvl8.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 62,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 40, 1, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 63,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 40, 1, 2, 1,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 64,'Qatar OSM', 'Qatar OSM' , 40, 1, 1, 0,'file:TilePackage/Qatar/2020-06-23_Qatar_osm_32639.vtpk',-1,125);
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 65,'ABM Military College Aerial 2022', 'ABM Military College Aerial 2022', 40, 2, 2, 3,'file:TilePackage/Qatar/2021-12-16_Qatar_ABMMC_Aerial_50cm_WebMerc_Lvl18.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 66,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 40, 2, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 67,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 40, 2, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 68,'Qatar OSM', 'Qatar OSM' , 40, 2, 1, 0,'file:TilePackage/Qatar/2022-07-12_Qatar_OSM_WebMercator_Raster_Lvl16.tpk',-1,125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 69, 'Elevation', 'Elevation', 40, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
|
|
|
|
-- NSA / BarzanCamp / NSA / MiqdamCamp
|
|
-- TA,MD,MT,Or,
|
|
-- 2D
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 71,'MiqdamCamp Aerial 2022', 'MiqdamCamp Aerial 2022' , 41, 1, 2, 3,'file:TilePackage/Qatar/2021-12-10_Qatar_NSA_BarzanCamp_Aerial_50cm_32639_Lvl8.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 72,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 41, 1, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 73,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 41, 1, 2, 1,'file:TilePackage/Qatar/2021-12-06_Qatar_Aerial_5m_32639_Lvl6.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 74,'Qatar OSM', 'Qatar OSM' , 41, 1, 1, 0,'file:TilePackage/Qatar/2020-06-23_Qatar_osm_32639.vtpk',-1,125);
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 75,'MiqdamCamp Aerial 2022', 'MiqdamCamp Aerial 2022' , 41, 2, 2, 3,'file:TilePackage/Qatar/2021-12-10_Qatar_NSA_BarzanCamp_Aerial_50cm_WebMerc_Lvl18.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 76,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 41, 2, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 77,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 41, 2, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 78,'Qatar OSM', 'Qatar OSM' , 41, 2, 1, 0,'file:TilePackage/Qatar/2022-07-12_Qatar_OSM_WebMercator_Raster_Lvl16.tpk',-1,125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 79, 'Elevation', 'Elevation', 41, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
-- Doha
|
|
-- 2D
|
|
-- TA,MD,MT,Or,
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 81,'Doha Aerial 2022', 'Doha Aerial 2022' , 42, 1, 2, 3,'file:TilePackage/Qatar/2021-12-09_Qatar_Doha_Aerial_50cm_32639_Lvl8.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 82,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 42, 1, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_32639',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 83,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 42, 1, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_32639.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 84,'Qatar OSM', 'Qatar OSM' , 42, 1, 1, 0,'file:TilePackage/Qatar/2020-06-23_Qatar_osm_32639.vtpk',-1,125);
|
|
-- 3D
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 85,'Doha Aerial 2022', 'Doha Aerial 2022' , 42, 2, 2, 3,'file:TilePackage/Qatar/2021-12-09_Qatar_Doha_Aerial_50cm_WebMerc_Lvl18.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 86,'Qatar Aerial Islands 2022', 'Qatar Aerial Islands 2022' , 42, 2, 2, 2,'file:TilePackage/Qatar/Qatar_Aerial_Islands_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 87,'Qatar Aerial 2022', 'Qatar Aerial 2022' , 42, 2, 2, 1,'file:TilePackage/Qatar/Qatar_Aerial_WebMerc.tpk',-1,125);
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 88,'Qatar OSM', 'Qatar OSM' , 42, 2, 1, 0,'file:TilePackage/Qatar/2022-07-12_Qatar_OSM_WebMercator_Raster_Lvl16.tpk',-1,125);
|
|
|
|
-- Elevation
|
|
INSERT INTO asm.asm_map_description (id, name, description, training_area_id, map_description_type_id, map_type_id, obj_order, url, min_scale, max_scale)
|
|
VALUES ( 89, 'Elevation', 'Elevation', 42, 3, 4, 0, 'file:2022-07-12_Qatar_DEM_float32.tif.tif', -1, -1);
|
|
|
|
|
|
ALTER SEQUENCE asm.asm_map_description_id_seq RESTART WITH 200;
|
|
|
|
|
|
INSERT INTO asm.asm_location(id, name, description) VALUES (1, 'Default', 'Default location');
|
|
ALTER SEQUENCE asm.asm_location_id_seq RESTART WITH 10;
|
|
|
|
-- Workstations
|
|
DELETE FROM asm.asm_asset;
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (1, 'EXCOWS01', 1, 1);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (2, 'EXCOWS02', 1, 1);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (3, 'EXCOWS03', 1, 1);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (4, 'EXCOWS04', 1, 1);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (5, 'EXCOWS05', 1, 1);
|
|
INSERT INTO asm.asm_asset(id, name, asset_type_id, location_id) VALUES (6, 'CTCAP09', 1, 1);
|
|
|
|
ALTER SEQUENCE asm.asm_asset_id_seq RESTART WITH 100;
|
|
|
|
-- EGCU Relay Infos Note: Don't insert unused relays!
|
|
DELETE FROM asm.asm_egcu_relay_info;
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (1, '{"Icons": {"1":"icon:heater_hot.svg", "0":"icon:heater_cold.svg"}}', 'Fog Heater Indoor', 0);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (2, '{"Icons": {"1":"icon:heater_hot.svg", "0":"icon:heater_cold.svg"}}', 'Fog Heater Outdoor', 2);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (3, '{"Icons": {"1":"icon:bulb_on.svg", "0":"icon:bulb_off.svg"}}', 'Lamp Floor 1', 4);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (4, '{"Icons": {"1":"icon:bulb_on.svg", "0":"icon:bulb_off.svg"}}', 'Lamp Floor 2', 6);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (5, '{"Icons": {"1":"icon:cloud_fog_on.svg", "0":"icon:cloud_fog_off.svg"}}', 'Fog Indoor', 8);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (6, '{"Icons": {"1":"icon:cloud_fog_on.svg", "0":"icon:cloud_fog_off.svg"}}', 'Fog Outdoor', 9);
|
|
INSERT INTO asm.asm_egcu_relay_info (id, properties, name, relay_id) VALUES (7, '{"allowPermanentOn":false, "showStatus":false, "Icons": {"1":"icon:audio-volume-high.svg", "0":"icon:audio-volume-muted.svg"}}', 'Sound', 99);
|
|
ALTER SEQUENCE asm.asm_egcu_relay_info_id_seq RESTART WITH 8;
|
|
|