37 lines
1.9 KiB
SQL
Executable File
37 lines
1.9 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- 32U MD 8800000 7500000 = 8.8210891905, 53.0244018451 ( 0.1539570500, 0.9254503961 )
|
|
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);
|
|
|
|
------------------------
|
|
-- 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!!!
|
|
|
|
-- 12 | Luxemburg_RC | 0.0989847311150414 | 0.861176622635424 | 99079 | 95059 |
|
|
INSERT INTO asm.asm_training_area(id, name, bottom_left_x, bottom_left_y, height, width) VALUES (8, 'Luxemburg', 0.0989847311150414, 0.861176622635424, 99079, 95059);
|
|
ALTER SEQUENCE asm.asm_training_area_id_seq RESTART WITH 100;
|
|
|
|
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 ('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
|
|
------------------------
|
|
|