235 lines
29 KiB
SQL
Executable File
235 lines
29 KiB
SQL
Executable File
-- # $Id$
|
|
-- # $HeadURL$
|
|
-- # $Author$
|
|
|
|
-- GUEZ data for ISM
|
|
|
|
-- Meteo Data Units
|
|
-- coordinates need to be verified
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (1, 'Meteo Data Unit 01', '{"description": "Meteo Data Unit 01"}', 0.2026096878, 0.9154268856, 0.00, 0.00, 0, 0, '{}'), -- Stenneckenberg
|
|
(2, 'Meteo Data Unit 02', '{"description": "Meteo Data Unit 02"}', 0.2008528742, 0.9162459686, 0.00, 0.00, 0, 0, '{}'), -- Stahrenberg
|
|
(3, 'Meteo Data Unit 03', '{"description": "Meteo Data Unit 03"}', 0.2014071559, 0.9142424353, 0.00, 0.00, 0, 0, '{}'), -- Rabenberge
|
|
(4, 'Meteo Data Unit 04', '{"description": "Meteo Data Unit 04"}', 0.2010974298, 0.9133381279, 0.00, 0.00, 0, 0, '{}'); -- Höhenschwelle Süd
|
|
|
|
-- Radio Stations
|
|
-- coordinates need to be verified
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (12, 'Stenneckenberg', '{"description": "Stenneckenberg"}', 0.2026096878, 0.9154268856, 0.00, 0.00, 0, 0, '{"stationId": 2, "hostname":"CEF02IFR21", "maxReceiver": 1}'),
|
|
(13, 'Stahrenberg', '{"description": "Stahrenberg"}', 0.2008528742, 0.9162459686, 0.00, 0.00, 0, 0, '{"stationId": 3, "hostname":"CEF03IFR31", "maxReceiver": 1}'),
|
|
(15, 'Liegenschaft GÜZ', '{"description": "Liegenschaft GÜZ"}', 0.2015421048, 0.9152687413, 0.00, 0.00, 0, 0, '{"stationId": 5, "hostname":"CEF05IFR51", "maxReceiver": 1}'),
|
|
(16, 'Mitte Norden', '{"description": "Mitte Norden"}', 0.2021616792, 0.9158371601, 0.00, 0.00, 0, 0, '{"stationId": 6, "hostname":"CEF06IFR61", "maxReceiver": 1}'),
|
|
(17, 'Rabenberge', '{"description": "Rabenberge"}', 0.2014071559, 0.9142424353, 0.00, 0.00, 0, 0, '{"stationId": 7, "hostname":"CEF07IFR71", "maxReceiver": 1}'),
|
|
(18, 'Höhenschwelle Süd', '{"description": "Höhenschwelle Süd"}', 0.2010974298, 0.9133381279, 0.00, 0.00, 0, 0, '{"stationId": 8, "hostname":"CEF08IFR81", "maxReceiver": 1}'),
|
|
(19, 'Hillersleben Hügel', '{"description": "Hillersleben Hügel"}', 0.2005550164, 0.9126910296, 0.00, 0.00, 0, 0, '{"stationId": 9, "hostname":"CEF09IFR91", "maxReceiver": 1}'); -- coordinates still missing
|
|
|
|
-- Approaching Points
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (20, 'IP-N', '{"description": "IP-N"}', 0.2022269894, 0.9188408194, 0.00 , 0.00, 0, 0, '{}'),
|
|
(21, 'IP-E', '{"description": "IP-E"}', 0.2065811845, 0.9143462999, 0.00 , 0.00, 0, 0, '{}'),
|
|
(22, 'IP-S', '{"description": "IP-S"}', 0.2004685004, 0.9105602095, 0.00 , 0.00, 0, 0, '{}'),
|
|
(23, 'IP-W' , '{"description": "IP-W"}', 0.1965958591, 0.9147187881, 0.00 , 0.00, 0, 0, '{}'),
|
|
(24, 'IP-NE', '{"description": "IP-NE"}', 0.2057246816, 0.9170349622, 0.00 , 0.00, 0, 0, '{}'),
|
|
(25, 'IP-SE', '{"description": "IP-SE"}', 0.2056845041, 0.9123271634, 0.00 , 0.00, 0, 0, '{}'),
|
|
(26, 'IP-SW', '{"description": "IP-SW"}', 0.1964678741, 0.9122101391, 0.00 , 0.00, 0, 0, '{}'),
|
|
(27, 'IP-NW', '{"description": "IP-NW"}', 0.1982934013, 0.9176674695, 0.00 , 0.00, 0, 0, '{}'),
|
|
(28, 'HA-N', '{"description": "HA-N"}', 0.2022269894, 0.9188408194, 0.00 , 0.00, 0, 0, '{}'),
|
|
(29, 'HA-E', '{"description": "HA-E"}', 0.2065811845, 0.9143462999, 0.00 , 0.00, 0, 0, '{}'),
|
|
(30, 'HA-S', '{"description": "HA-S"}', 0.1979350677, 0.9109259607, 0.00 , 0.00, 0, 0, '{}'),
|
|
(31, 'HA-W', '{"description": "HA-W"}', 0.1960434973, 0.9139445775, 0.00 , 0.00, 0, 0, '{}');
|
|
|
|
ALTER SEQUENCE ism.ism_main_structure_element_id_seq RESTART WITH 301;
|
|
|
|
|
|
-- =============================================================================
|
|
|
|
|
|
-- Dummy Structure Elements for Meteo Data Units
|
|
-- relative coordinates need to be verified
|
|
INSERT INTO ism.ism_structure_element (id, name, display_name, main_structure_element_id, structure_element_type_id, path, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, properties, barcode)
|
|
VALUES (1, 'Meteo Data Unit 01', 'Meteo Data Unit 01', 1, 9, '{1}', 90500.00, 83500.00, 0.00, 0, '{}', NULL), -- Stenneckenberg
|
|
(2, 'Meteo Data Unit 02', 'Meteo Data Unit 02', 2, 9, '{2}', 96500.00, 83500.00, 0.00, 0, '{}', NULL), -- Stahrenberg
|
|
(3, 'Meteo Data Unit 03', 'Meteo Data Unit 03', 3, 9, '{3}', 97500.00, 77500.00, 0.00, 0, '{}', NULL), -- Rabenberge
|
|
(4, 'Meteo Data Unit 04', 'Meteo Data Unit 04', 4, 9, '{4}', 92500.00, 77500.00, 0.00, 0, '{}', NULL); -- Höhenschwelle Süd
|
|
|
|
-- Mounting Points for Meteo Data Units
|
|
INSERT INTO ism.ism_structure_element (id, name, display_name, main_structure_element_id, structure_element_type_id, path, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, properties, barcode)
|
|
VALUES (5, 'MP_MDU01', 'MP_MDU01', 1, 6, '{1, 5}', 0.00, 0.00, 0.00, 7, '{}', 'MDU01'), -- Stenneckenberg
|
|
(6, 'MP_MDU02', 'MP_MDU02', 2, 6, '{2, 6}', 0.00, 0.00, 0.00, 7, '{}', 'MDU02'), -- Stahrenberg
|
|
(7, 'MP_MDU03', 'MP_MDU03', 3, 6, '{3, 7}', 0.00, 0.00, 0.00, 7, '{}', 'MDU03'), -- Rabenberge
|
|
(8, 'MP_MDU04', 'MP_MDU04', 4, 6, '{4, 8}', 0.00, 0.00, 0.00, 7, '{}', 'MDU04'); -- Höhenschwelle Süd
|
|
|
|
-- Dummy Structure Elements for Radio Stations
|
|
INSERT INTO ism.ism_structure_element (id, name, display_name, main_structure_element_id, structure_element_type_id, path, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, properties, barcode)
|
|
VALUES (12, 'Stenneckenberg', 'Stenneckenberg', 12, 8, '{12}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(13, 'Stahrenberg', 'Stahrenberg', 13, 8, '{13}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(15, 'Liegenschaft GÜZ', 'Liegenschaft GÜZ', 15, 8, '{15}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(16, 'Mitte Norden', 'Mitte Norden', 16, 8, '{16}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(17, 'Rabenberge', 'Rabenberge', 17, 8, '{17}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(18, 'Höhenschwelle Süd', 'Höhenschwelle Süd', 18, 8, '{18}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(19, 'Hillersleben Hügel', 'Hillersleben Hügel', 19, 8, '{19}', 0.00, 0.00, 0.00, 0, '{}', NULL);
|
|
|
|
-- Dummy Structure Elements for Approaching Points
|
|
INSERT INTO ism.ism_structure_element (id, name, display_name, main_structure_element_id, structure_element_type_id, path, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, properties, barcode)
|
|
VALUES (20, 'IP-N', 'IP-N', 20, 7, '{20}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(21, 'IP-E', 'IP-E', 21, 7, '{21}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(22, 'IP-S', 'IP-S', 22, 7, '{22}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(23, 'IP-W' , 'IP-W' , 23, 7, '{23}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(24, 'IP-NE', 'IP-NE', 24, 7, '{24}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(25, 'IP-SE', 'IP-SE', 25, 7, '{25}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(26, 'IP-SW', 'IP-SW', 26, 7, '{26}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(27, 'IP-NW', 'IP-NW', 27, 7, '{27}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(28, 'HA-N', 'HA-N', 28, 7, '{28}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(29, 'HA-E', 'HA-E', 29, 7, '{29}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(30, 'HA-S', 'HA-S', 30, 7, '{30}', 0.00, 0.00, 0.00, 0, '{}', NULL),
|
|
(31, 'HA-W', 'HA-W', 31, 7, '{31}', 0.00, 0.00, 0.00, 0, '{}', NULL);
|
|
|
|
ALTER SEQUENCE ism.ism_structure_element_id_seq RESTART WITH 32;
|
|
|
|
-- =============================================================================
|
|
|
|
|
|
-- Meteo Data Units, mounted
|
|
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, hostname, properties, asset_state_id, barcode)
|
|
VALUES (1, 'Stenneckenberg', 7, 'BTF02WST01', '{"climatePort": 100, "windPort": 101}', 1, NULL),
|
|
(2, 'Stahrenberg', 7, 'BTF03WST01', '{"climatePort": 100, "windPort": 101}', 1, NULL),
|
|
(3, 'Rabenberge', 7, 'BTF07WST01', '{"climatePort": 100, "windPort": 101}', 1, NULL),
|
|
(4, 'Höhenschwelle Süd', 7, 'BTF08WST01', '{"climatePort": 100, "windPort": 101}', 1, NULL);
|
|
|
|
|
|
ALTER SEQUENCE ism.ism_asset_id_seq RESTART WITH 100;
|
|
|
|
|
|
-- =============================================================================
|
|
|
|
|
|
-- Mounts for Meteo Data Units
|
|
INSERT INTO ism.ism_mounting_point_asset (id, asset_id, structure_element_id)
|
|
VALUES (1, 1, 5),
|
|
(2, 2, 6),
|
|
(3, 3, 7),
|
|
(4, 4, 8);
|
|
|
|
|
|
ALTER SEQUENCE ism.ism_mounting_point_asset_id_seq RESTART WITH 20;
|
|
|
|
|
|
-- ======================================================================
|
|
-- BRIDGE PROXY: 201 - 206
|
|
-- Main structure element
|
|
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (201, 'Brücke_1', 'Brücke', 0.20244350, 0.91600840, 89, 75, 1000, 0, '{"bridgeStatus": 1}');
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (202, 'Brücke_2', 'Brücke', 0.20249532, 0.91604629, 89, 48, 1000, 0, '{"bridgeStatus": 1}');
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (203, 'Brücke_3', 'Brücke', 0.20254068, 0.91606124, 92, 59, 1000, 0, '{"bridgeStatus": 1}');
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (204, 'Brücke_4', 'Brücke', 0.20259702, 0.91609599, 93, 72, 1000, 0, '{"bridgeStatus": 1}');
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (205, 'Brücke_5', 'Brücke', 0.20261578, 0.91610101, 92, 19, 1000, 0, '{"bridgeStatus": 1}');
|
|
INSERT INTO ism.ism_main_structure_element (id, name, description, geo_position_x, geo_position_y, geo_position_z, angle, model_id, external_wls_id, properties)
|
|
VALUES (206, 'Brücke_6', 'Brücke', 0.20263897, 0.91610447, 91, 340, 1000, 0, '{"bridgeStatus": 1}');
|
|
|
|
-- Structure elements with ids >= 32
|
|
-- not sure we need a mounting point
|
|
-- 11 -> Bridge
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (32, 'BridgeProxy 1', 201, 11, '{32}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 1');
|
|
--INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (33, 'BridgeProxy', 201, 6, '{32,33}', 0, '', 0, 0, 0, 2, 0, 0, 0, '{}', 'BridgeProxy');
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (34, 'BridgeProxy 2', 202, 11, '{34}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 2');
|
|
--INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (35, 'BridgeProxy', 202, 6, '{34,35}', 0, '', 0, 0, 0, 2, 0, 0, 0, '{}', 'BridgeProxy');
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (36, 'BridgeProxy 3', 203, 11, '{36}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 3');
|
|
--INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (37, 'BridgeProxy', 203, 6, '{36,37}', 0, '', 0, 0, 0, 2, 0, 0, 0, '{}', 'BridgeProxy');
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (38, 'BridgeProxy 4', 204, 11, '{38}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 4');
|
|
--INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (39, 'BridgeProxy', 204, 6, '{38,39}', 0, '', 0, 0, 0, 2, 0, 0, 0, '{}', 'BridgeProxy');
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (40, 'BridgeProxy 5', 205, 11, '{40}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 5');
|
|
--INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (41, 'BridgeProxy', 205, 6, '{40,41}', 0, '', 0, 0, 0, 2, 0, 0, 0, '{}', 'BridgeProxy');
|
|
INSERT INTO ism.ism_structure_element (id, name, main_structure_element_id, structure_element_type_id, path, mounting_point_id, barcode, rel_position_x, rel_position_y, rel_position_z, mounting_point_type_id, orientation_x, orientation_y, orientation_z, properties, display_name) VALUES (42, 'BridgeProxy 6', 206, 11, '{42}', 0, '', 0, 0, 0, 0, 0, 0, 0, '{}', 'Brücke 6');
|
|
|
|
ALTER SEQUENCE ism.ism_structure_element_id_seq RESTART WITH 44;
|
|
|
|
-- Footprint
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (32, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (32, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (32, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (32, 3, 5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (34, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (34, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (34, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (34, 3, 5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (36, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (36, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (36, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (36, 3, 5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (38, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (38, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (38, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (38, 3, 5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (40, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (40, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (40, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (40, 3, 5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (42, 0, -5, -10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (42, 1, -5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (42, 2, 5, 10, 0);
|
|
INSERT INTO ism.ism_structure_element_footprint (structure_element_id, index_no, rel_position_x, rel_position_y, rel_position_z) VALUES (42, 3, 5, -10, 0);
|
|
|
|
|
|
-- GV
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020001_80206045020001_020001', 14, 'GV__80206045020001_80206045020001_020001','UEPOGV-0001', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020002_80206045020002_020002', 14, 'GV__80206045020002_80206045020002_020002','UEPOGV-0002', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020003_80206045020003_020003', 14, 'GV__80206045020003_80206045020003_020003','UEPOGV-0003', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020004_80206045020004_020004', 14, 'GV__80206045020004_80206045020004_020004','UEPOGV-0004', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020005_80206045020005_020005', 14, 'GV__80206045020005_80206045020005_020005','UEPOGV-0005', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045020006_80206045020006_020006', 14, 'GV__80206045020006_80206045020006_020006','UEPOGV-0006', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030007_80206045030007_030007', 14, 'GV__80206045030007_80206045030007_030007','UEPOGV-0007', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030008_80206045030008_030008', 14, 'GV__80206045030008_80206045030008_030008','UEPOGV-0008', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030009_80206045030009_030009', 14, 'GV__80206045030009_80206045030009_030009','UEPOGV-0009', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030010_80206045030010_030010', 14, 'GV__80206045030010_80206045030010_030010','UEPOGV-0010', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030011_80206045030011_030011', 14, 'GV__80206045030011_80206045030011_030011','UEPOGV-0011', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030012_80206045030012_030012', 14, 'GV__80206045030012_80206045030012_030012','UEPOGV-0012', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030013_80206045030013_030013', 14, 'GV__80206045030013_80206045030013_030013','UEPOGV-0013', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030014_80206045030014_030014', 14, 'GV__80206045030014_80206045030014_030014','UEPOGV-0014', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030015_80206045030015_030015', 14, 'GV__80206045030015_80206045030015_030015','UEPOGV-0015', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030016_80206045030016_030016', 14, 'GV__80206045030016_80206045030016_030016','UEPOGV-0016', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030017_80206045030017_030017', 14, 'GV__80206045030017_80206045030017_030017','UEPOGV-0017', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030018_80206045030018_030018', 14, 'GV__80206045030018_80206045030018_030018','UEPOGV-0018', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030019_80206045030019_030019', 14, 'GV__80206045030019_80206045030019_030019','UEPOGV-0019', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030020_80206045030020_030020', 14, 'GV__80206045030020_80206045030020_030020','UEPOGV-0020', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030021_80206045030021_030021', 14, 'GV__80206045030021_80206045030021_030021','UEPOGV-0021', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030022_80206045030022_030022', 14, 'GV__80206045030022_80206045030022_030022','UEPOGV-0022', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030023_80206045030023_030023', 14, 'GV__80206045030023_80206045030023_030023','UEPOGV-0023', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030024_80206045030024_030024', 14, 'GV__80206045030024_80206045030024_030024','UEPOGV-0024', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030025_80206045030025_030025', 14, 'GV__80206045030025_80206045030025_030025','UEPOGV-0025', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030026_80206045030026_030026', 14, 'GV__80206045030026_80206045030026_030026','UEPOGV-0026', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030027_80206045030027_030027', 14, 'GV__80206045030027_80206045030027_030027','UEPOGV-0027', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030028_80206045030028_030028', 14, 'GV__80206045030028_80206045030028_030028','UEPOGV-0028', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030029_80206045030029_030029', 14, 'GV__80206045030029_80206045030029_030029','UEPOGV-0029', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030030_80206045030030_030030', 14, 'GV__80206045030030_80206045030030_030030','UEPOGV-0030', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030031_80206045030031_030031', 14, 'GV__80206045030031_80206045030031_030031','UEPOGV-0031', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030032_80206045030032_030032', 14, 'GV__80206045030032_80206045030032_030032','UEPOGV-0032', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030033_80206045030033_030033', 14, 'GV__80206045030033_80206045030033_030033','UEPOGV-0033', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030034_80206045030034_030034', 14, 'GV__80206045030034_80206045030034_030034','UEPOGV-0034', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030035_80206045030035_030035', 14, 'GV__80206045030035_80206045030035_030035','UEPOGV-0035', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030036_80206045030036_030036', 14, 'GV__80206045030036_80206045030036_030036','UEPOGV-0036', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030037_80206045030037_030037', 14, 'GV__80206045030037_80206045030037_030037','UEPOGV-0037', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030038_80206045030038_030038', 14, 'GV__80206045030038_80206045030038_030038','UEPOGV-0038', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030039_80206045030039_030039', 14, 'GV__80206045030039_80206045030039_030039','UEPOGV-0039', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030040_80206045030040_030040', 14, 'GV__80206045030040_80206045030040_030040','UEPOGV-0040', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030041_80206045030041_030041', 14, 'GV__80206045030041_80206045030041_030041','UEPOGV-0041', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030042_80206045030042_030042', 14, 'GV__80206045030042_80206045030042_030042','UEPOGV-0042', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030043_80206045030043_030043', 14, 'GV__80206045030043_80206045030043_030043','UEPOGV-0043', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030044_80206045030044_030044', 14, 'GV__80206045030044_80206045030044_030044','UEPOGV-0044', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030045_80206045030045_030045', 14, 'GV__80206045030045_80206045030045_030045','UEPOGV-0045', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030046_80206045030046_030046', 14, 'GV__80206045030046_80206045030046_030046','UEPOGV-0046', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030047_80206045030047_030047', 14, 'GV__80206045030047_80206045030047_030047','UEPOGV-0047', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030048_80206045030048_030048', 14, 'GV__80206045030048_80206045030048_030048','UEPOGV-0048', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030049_80206045030049_030049', 14, 'GV__80206045030049_80206045030049_030049','UEPOGV-0049', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030050_80206045030050_030050', 14, 'GV__80206045030050_80206045030050_030050','UEPOGV-0050', 0);
|
|
INSERT INTO ism.ism_asset (name, mounting_point_type_id, barcode, hostname, asset_state_id) VALUES ('GV__80206045030051_80206045030051_030051', 14, 'GV__80206045030051_80206045030051_030051','UEPOGV-0051', 0);
|
|
|
|
-- ISM special areas
|
|
--INSERT INTO ism_special_area (name, special_type, polygon)
|
|
-- VALUES ('Special Area Bremen 1', 2, '{"polygon": [{"lat": 0.15401403293561025, "lon": 0.9262516599759301}, {"lat": 0.15521123194737144, "lon": 0.9262607697394275}, {"lat": 0.15520600446201568, "lon": 0.9258487622646644}, {"lat": 0.15397777595084897, "lon": 0.9258204619096445}]}');
|
|
|