qt5-legatus-legacy/Lts/Tests/DatabaseInitialisation/qatar_ism_values_ips.sql

-- # $Id$
-- # $HeadURL$
-- # $Author$

--Create insert-Statement for ips-assets


--Indoor-IPS A3
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (500, 'IPS-IN_2001',  6, '{"opticalCode":2001}', 0, 'BC_IPS_2001');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (501, 'IPS-IN_2002',  6, '{"opticalCode":2002}', 0, 'BC_IPS_2002');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (502, 'IPS-IN_2003',  6, '{"opticalCode":2003}', 0, 'BC_IPS_2003');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (503, 'IPS-IN_2004',  6, '{"opticalCode":2004}', 0, 'BC_IPS_2004');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (504, 'IPS-IN_2005',  6, '{"opticalCode":2005}', 0, 'BC_IPS_2005');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (505, 'IPS-IN_2006',  6, '{"opticalCode":2006}', 0, 'BC_IPS_2006');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (506, 'IPS-IN_2007',  6, '{"opticalCode":2007}', 0, 'BC_IPS_2007');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (507, 'IPS-IN_2008',  6, '{"opticalCode":2008}', 0, 'BC_IPS_2008');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (508, 'IPS-IN_2009',  6, '{"opticalCode":2009}', 0, 'BC_IPS_2009');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (509, 'IPS-IN_2010',  6, '{"opticalCode":2010}', 0, 'BC_IPS_2010');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (510, 'IPS-IN_2011',  6, '{"opticalCode":2011}', 0, 'BC_IPS_2011');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (511, 'IPS-IN_2012',  6, '{"opticalCode":2012}', 0, 'BC_IPS_2012');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (512, 'IPS-IN_2013',  6, '{"opticalCode":2013}', 0, 'BC_IPS_2013');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (513, 'IPS-IN_2014',  6, '{"opticalCode":2014}', 0, 'BC_IPS_2014');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (514, 'IPS-IN_2015',  6, '{"opticalCode":2015}', 0, 'BC_IPS_2015');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (515, 'IPS-IN_2016',  6, '{"opticalCode":2016}', 0, 'BC_IPS_2016');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (516, 'IPS-IN_2017',  6, '{"opticalCode":2017}', 0, 'BC_IPS_2017');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (517, 'IPS-IN_2018',  6, '{"opticalCode":2018}', 0, 'BC_IPS_2018');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (518, 'IPS-IN_2019',  6, '{"opticalCode":2019}', 0, 'BC_IPS_2019');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (519, 'IPS-IN_2020',  6, '{"opticalCode":2020}', 0, 'BC_IPS_2020');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (520, 'IPS-IN_2021',  6, '{"opticalCode":2021}', 0, 'BC_IPS_2021');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (521, 'IPS-IN_2022',  6, '{"opticalCode":2022}', 0, 'BC_IPS_2022');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (522, 'IPS-IN_2023',  6, '{"opticalCode":2023}', 0, 'BC_IPS_2023');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (523, 'IPS-IN_2024',  6, '{"opticalCode":2024}', 0, 'BC_IPS_2024');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (524, 'IPS-IN_2025',  6, '{"opticalCode":2025}', 0, 'BC_IPS_2025');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (525, 'IPS-IN_2026',  6, '{"opticalCode":2026}', 0, 'BC_IPS_2026');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (526, 'IPS-IN_2027',  6, '{"opticalCode":2027}', 0, 'BC_IPS_2027');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (527, 'IPS-IN_2028',  6, '{"opticalCode":2028}', 0, 'BC_IPS_2028');
--Outdoor-IPS A3
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (528, 'IPS-OUT_1001',  5, '{"opticalCode":1001}', 0, 'BC_IPS_1001');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (529, 'IPS-OUT_1002',  5, '{"opticalCode":1002}', 0, 'BC_IPS_1002');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (530, 'IPS-OUT_1003',  5, '{"opticalCode":1003}', 0, 'BC_IPS_1003');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (531, 'IPS-OUT_1004',  5, '{"opticalCode":1004}', 0, 'BC_IPS_1004');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (532, 'IPS-OUT_1005',  5, '{"opticalCode":1005}', 0, 'BC_IPS_1005');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (533, 'IPS-OUT_1006',  5, '{"opticalCode":1006}', 0, 'BC_IPS_1006');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (534, 'IPS-OUT_1007',  5, '{"opticalCode":1007}', 0, 'BC_IPS_1007');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (535, 'IPS-OUT_1008',  5, '{"opticalCode":1008}', 0, 'BC_IPS_1008');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (536, 'IPS-OUT_1009',  5, '{"opticalCode":1009}', 0, 'BC_IPS_1009');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (537, 'IPS-OUT_1010',  5, '{"opticalCode":1010}', 0, 'BC_IPS_1010');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (538, 'IPS-OUT_1011',  5, '{"opticalCode":1011}', 0, 'BC_IPS_1011');
--Roof-IPS A3
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (539, 'IPS-IN_3001',  6, '{"opticalCode":3001}', 0, 'BC_IPS_3001');
--Indoor-IPS A4
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (540, 'IPS-IN_2051',  6, '{"opticalCode":2051}', 0, 'BC_IPS_2051');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (541, 'IPS-IN_2052',  6, '{"opticalCode":2052}', 0, 'BC_IPS_2052');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (542, 'IPS-IN_2053',  6, '{"opticalCode":2053}', 0, 'BC_IPS_2053');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (543, 'IPS-IN_2054',  6, '{"opticalCode":2054}', 0, 'BC_IPS_2054');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (544, 'IPS-IN_2055',  6, '{"opticalCode":2055}', 0, 'BC_IPS_2055');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (545, 'IPS-IN_2056',  6, '{"opticalCode":2056}', 0, 'BC_IPS_2056');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (546, 'IPS-IN_2057',  6, '{"opticalCode":2057}', 0, 'BC_IPS_2057');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (547, 'IPS-IN_2058',  6, '{"opticalCode":2058}', 0, 'BC_IPS_2058');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (548, 'IPS-IN_2059',  6, '{"opticalCode":2059}', 0, 'BC_IPS_2059');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (549, 'IPS-IN_2060',  6, '{"opticalCode":2060}', 0, 'BC_IPS_2060');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (550, 'IPS-IN_2061',  6, '{"opticalCode":2061}', 0, 'BC_IPS_2061');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (551, 'IPS-IN_2062',  6, '{"opticalCode":2062}', 0, 'BC_IPS_2062');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (552, 'IPS-IN_2063',  6, '{"opticalCode":2063}', 0, 'BC_IPS_2063');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (553, 'IPS-IN_2064',  6, '{"opticalCode":2064}', 0, 'BC_IPS_2064');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (554, 'IPS-IN_2065',  6, '{"opticalCode":2065}', 0, 'BC_IPS_2065');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (555, 'IPS-IN_2066',  6, '{"opticalCode":2066}', 0, 'BC_IPS_2066');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (556, 'IPS-IN_2067',  6, '{"opticalCode":2067}', 0, 'BC_IPS_2067');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (557, 'IPS-IN_2068',  6, '{"opticalCode":2068}', 0, 'BC_IPS_2068');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (558, 'IPS-IN_2069',  6, '{"opticalCode":2069}', 0, 'BC_IPS_2069');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (559, 'IPS-IN_2070',  6, '{"opticalCode":2070}', 0, 'BC_IPS_2070');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (560, 'IPS-IN_2071',  6, '{"opticalCode":2071}', 0, 'BC_IPS_2071');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (561, 'IPS-IN_2072',  6, '{"opticalCode":2072}', 0, 'BC_IPS_2072');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (562, 'IPS-IN_2073',  6, '{"opticalCode":2073}', 0, 'BC_IPS_2073');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (563, 'IPS-IN_2074',  6, '{"opticalCode":2074}', 0, 'BC_IPS_2074');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (564, 'IPS-IN_2075',  6, '{"opticalCode":2075}', 0, 'BC_IPS_2075');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (565, 'IPS-IN_2076',  6, '{"opticalCode":2076}', 0, 'BC_IPS_2076');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (566, 'IPS-IN_2077',  6, '{"opticalCode":2077}', 0, 'BC_IPS_2077');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (567, 'IPS-IN_2078',  6, '{"opticalCode":2078}', 0, 'BC_IPS_2078');
--Outdoor-IPS A4
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (568, 'IPS-OUT_1051',  5, '{"opticalCode":1051}', 0, 'BC_IPS_1051');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (569, 'IPS-OUT_1052',  5, '{"opticalCode":1052}', 0, 'BC_IPS_1052');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (570, 'IPS-OUT_1053',  5, '{"opticalCode":1053}', 0, 'BC_IPS_1053');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (571, 'IPS-OUT_1054',  5, '{"opticalCode":1054}', 0, 'BC_IPS_1054');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (572, 'IPS-OUT_1055',  5, '{"opticalCode":1055}', 0, 'BC_IPS_1055');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (573, 'IPS-OUT_1056',  5, '{"opticalCode":1056}', 0, 'BC_IPS_1056');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (574, 'IPS-OUT_1057',  5, '{"opticalCode":1057}', 0, 'BC_IPS_1057');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (575, 'IPS-OUT_1058',  5, '{"opticalCode":1058}', 0, 'BC_IPS_1058');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (576, 'IPS-OUT_1059',  5, '{"opticalCode":1059}', 0, 'BC_IPS_1059');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (577, 'IPS-OUT_1060',  5, '{"opticalCode":1060}', 0, 'BC_IPS_1060');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (578, 'IPS-OUT_1061',  5, '{"opticalCode":1061}', 0, 'BC_IPS_1061');
--Roof-IPS A4
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (579, 'IPS-IN_3006',  6, '{"opticalCode":3006}', 0, 'BC_IPS_3006');
--Indoor-IPS A5
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (580, 'IPS-IN_2101',  6, '{"opticalCode":2101}', 0, 'BC_IPS_2101');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (581, 'IPS-IN_2102',  6, '{"opticalCode":2102}', 0, 'BC_IPS_2102');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (582, 'IPS-IN_2103',  6, '{"opticalCode":2103}', 0, 'BC_IPS_2103');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (583, 'IPS-IN_2104',  6, '{"opticalCode":2104}', 0, 'BC_IPS_2104');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (584, 'IPS-IN_2105',  6, '{"opticalCode":2105}', 0, 'BC_IPS_2105');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (585, 'IPS-IN_2106',  6, '{"opticalCode":2106}', 0, 'BC_IPS_2106');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (586, 'IPS-IN_2107',  6, '{"opticalCode":2107}', 0, 'BC_IPS_2107');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (587, 'IPS-IN_2108',  6, '{"opticalCode":2108}', 0, 'BC_IPS_2108');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (588, 'IPS-IN_2109',  6, '{"opticalCode":2109}', 0, 'BC_IPS_2109');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (589, 'IPS-IN_2110',  6, '{"opticalCode":2110}', 0, 'BC_IPS_2110');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (590, 'IPS-IN_2111',  6, '{"opticalCode":2111}', 0, 'BC_IPS_2111');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (591, 'IPS-IN_2112',  6, '{"opticalCode":2112}', 0, 'BC_IPS_2112');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (592, 'IPS-IN_2113',  6, '{"opticalCode":2113}', 0, 'BC_IPS_2113');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (593, 'IPS-IN_2114',  6, '{"opticalCode":2114}', 0, 'BC_IPS_2114');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (594, 'IPS-IN_2115',  6, '{"opticalCode":2115}', 0, 'BC_IPS_2115');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (595, 'IPS-IN_2116',  6, '{"opticalCode":2116}', 0, 'BC_IPS_2116');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (596, 'IPS-IN_2117',  6, '{"opticalCode":2117}', 0, 'BC_IPS_2117');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (597, 'IPS-IN_2118',  6, '{"opticalCode":2118}', 0, 'BC_IPS_2118');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (598, 'IPS-IN_2119',  6, '{"opticalCode":2119}', 0, 'BC_IPS_2119');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (599, 'IPS-IN_2120',  6, '{"opticalCode":2120}', 0, 'BC_IPS_2120');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (600, 'IPS-IN_2121',  6, '{"opticalCode":2121}', 0, 'BC_IPS_2121');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (601, 'IPS-IN_2122',  6, '{"opticalCode":2122}', 0, 'BC_IPS_2122');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (602, 'IPS-IN_2123',  6, '{"opticalCode":2123}', 0, 'BC_IPS_2123');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (603, 'IPS-IN_2124',  6, '{"opticalCode":2124}', 0, 'BC_IPS_2124');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (604, 'IPS-IN_2125',  6, '{"opticalCode":2125}', 0, 'BC_IPS_2125');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (605, 'IPS-IN_2126',  6, '{"opticalCode":2126}', 0, 'BC_IPS_2126');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (606, 'IPS-IN_2127',  6, '{"opticalCode":2127}', 0, 'BC_IPS_2127');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (607, 'IPS-IN_2128',  6, '{"opticalCode":2128}', 0, 'BC_IPS_2128');
--Outdoor-IPS A5
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (608, 'IPS-OUT_1101',  5, '{"opticalCode":1101}', 0, 'BC_IPS_1101');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (609, 'IPS-OUT_1102',  5, '{"opticalCode":1102}', 0, 'BC_IPS_1102');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (610, 'IPS-OUT_1103',  5, '{"opticalCode":1103}', 0, 'BC_IPS_1103');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (611, 'IPS-OUT_1104',  5, '{"opticalCode":1104}', 0, 'BC_IPS_1104');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (612, 'IPS-OUT_1105',  5, '{"opticalCode":1105}', 0, 'BC_IPS_1105');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (613, 'IPS-OUT_1106',  5, '{"opticalCode":1106}', 0, 'BC_IPS_1106');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (614, 'IPS-OUT_1107',  5, '{"opticalCode":1107}', 0, 'BC_IPS_1107');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (615, 'IPS-OUT_1108',  5, '{"opticalCode":1108}', 0, 'BC_IPS_1108');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (616, 'IPS-OUT_1109',  5, '{"opticalCode":1109}', 0, 'BC_IPS_1109');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (617, 'IPS-OUT_1110',  5, '{"opticalCode":1110}', 0, 'BC_IPS_1110');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (618, 'IPS-OUT_1111',  5, '{"opticalCode":1111}', 0, 'BC_IPS_1111');
--Roof-IPS A5
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (619, 'IPS-IN_3011',  6, '{"opticalCode":3011}', 0, 'BC_IPS_3011');
--Indoor-IPS A6
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (620, 'IPS-IN_2150',  6, '{"opticalCode":2150}', 0, 'BC_IPS_2150');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (621, 'IPS-IN_2151',  6, '{"opticalCode":2151}', 0, 'BC_IPS_2151');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (622, 'IPS-IN_2152',  6, '{"opticalCode":2152}', 0, 'BC_IPS_2152');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (623, 'IPS-IN_2153',  6, '{"opticalCode":2153}', 0, 'BC_IPS_2153');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (624, 'IPS-IN_2154',  6, '{"opticalCode":2154}', 0, 'BC_IPS_2154');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (625, 'IPS-IN_2155',  6, '{"opticalCode":2155}', 0, 'BC_IPS_2155');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (626, 'IPS-IN_2156',  6, '{"opticalCode":2156}', 0, 'BC_IPS_2156');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (627, 'IPS-IN_2157',  6, '{"opticalCode":2157}', 0, 'BC_IPS_2157');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (628, 'IPS-IN_2158',  6, '{"opticalCode":2158}', 0, 'BC_IPS_2158');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (629, 'IPS-IN_2159',  6, '{"opticalCode":2159}', 0, 'BC_IPS_2159');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (630, 'IPS-IN_2160',  6, '{"opticalCode":2160}', 0, 'BC_IPS_2160');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (631, 'IPS-IN_2161',  6, '{"opticalCode":2161}', 0, 'BC_IPS_2161');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (632, 'IPS-IN_2162',  6, '{"opticalCode":2162}', 0, 'BC_IPS_2162');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (633, 'IPS-IN_2163',  6, '{"opticalCode":2163}', 0, 'BC_IPS_2163');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (634, 'IPS-IN_2164',  6, '{"opticalCode":2164}', 0, 'BC_IPS_2164');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (635, 'IPS-IN_2165',  6, '{"opticalCode":2165}', 0, 'BC_IPS_2165');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (636, 'IPS-IN_2166',  6, '{"opticalCode":2166}', 0, 'BC_IPS_2166');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (637, 'IPS-IN_2167',  6, '{"opticalCode":2167}', 0, 'BC_IPS_2167');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (638, 'IPS-IN_2168',  6, '{"opticalCode":2168}', 0, 'BC_IPS_2168');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (639, 'IPS-IN_2169',  6, '{"opticalCode":2169}', 0, 'BC_IPS_2169');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (640, 'IPS-IN_2170',  6, '{"opticalCode":2170}', 0, 'BC_IPS_2170');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (641, 'IPS-IN_2171',  6, '{"opticalCode":2171}', 0, 'BC_IPS_2171');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (642, 'IPS-IN_2172',  6, '{"opticalCode":2172}', 0, 'BC_IPS_2172');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (643, 'IPS-IN_2173',  6, '{"opticalCode":2173}', 0, 'BC_IPS_2173');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (644, 'IPS-IN_2174',  6, '{"opticalCode":2174}', 0, 'BC_IPS_2174');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (645, 'IPS-IN_2175',  6, '{"opticalCode":2175}', 0, 'BC_IPS_2175');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (646, 'IPS-IN_2176',  6, '{"opticalCode":2176}', 0, 'BC_IPS_2176');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (647, 'IPS-IN_2177',  6, '{"opticalCode":2177}', 0, 'BC_IPS_2177');
--Outdoor-IPS A6
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (648, 'IPS-OUT_1151',  5, '{"opticalCode":1151}', 0, 'BC_IPS_1151');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (649, 'IPS-OUT_1152',  5, '{"opticalCode":1152}', 0, 'BC_IPS_1152');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (650, 'IPS-OUT_1153',  5, '{"opticalCode":1153}', 0, 'BC_IPS_1153');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (651, 'IPS-OUT_1154',  5, '{"opticalCode":1154}', 0, 'BC_IPS_1154');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (652, 'IPS-OUT_1155',  5, '{"opticalCode":1155}', 0, 'BC_IPS_1155');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (653, 'IPS-OUT_1156',  5, '{"opticalCode":1156}', 0, 'BC_IPS_1156');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (654, 'IPS-OUT_1157',  5, '{"opticalCode":1157}', 0, 'BC_IPS_1157');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (655, 'IPS-OUT_1158',  5, '{"opticalCode":1158}', 0, 'BC_IPS_1158');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (656, 'IPS-OUT_1159',  5, '{"opticalCode":1159}', 0, 'BC_IPS_1159');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (657, 'IPS-OUT_1160',  5, '{"opticalCode":1160}', 0, 'BC_IPS_1160');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (658, 'IPS-OUT_1161',  5, '{"opticalCode":1161}', 0, 'BC_IPS_1161');
--Roof-IPS A6
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (659, 'IPS-IN_3016',  6, '{"opticalCode":3016}', 0, 'BC_IPS_3016');
--Indoor-IPS A7
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (660, 'IPS-IN_2201',  6, '{"opticalCode":2201}', 0, 'BC_IPS_2201');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (661, 'IPS-IN_2202',  6, '{"opticalCode":2202}', 0, 'BC_IPS_2202');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (662, 'IPS-IN_2203',  6, '{"opticalCode":2203}', 0, 'BC_IPS_2203');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (663, 'IPS-IN_2204',  6, '{"opticalCode":2204}', 0, 'BC_IPS_2204');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (664, 'IPS-IN_2205',  6, '{"opticalCode":2205}', 0, 'BC_IPS_2205');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (665, 'IPS-IN_2206',  6, '{"opticalCode":2206}', 0, 'BC_IPS_2206');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (666, 'IPS-IN_2207',  6, '{"opticalCode":2207}', 0, 'BC_IPS_2207');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (667, 'IPS-IN_2208',  6, '{"opticalCode":2208}', 0, 'BC_IPS_2208');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (668, 'IPS-IN_2209',  6, '{"opticalCode":2209}', 0, 'BC_IPS_2209');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (669, 'IPS-IN_2210',  6, '{"opticalCode":2210}', 0, 'BC_IPS_2210');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (670, 'IPS-IN_2211',  6, '{"opticalCode":2211}', 0, 'BC_IPS_2211');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (671, 'IPS-IN_2212',  6, '{"opticalCode":2212}', 0, 'BC_IPS_2212');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (672, 'IPS-IN_2213',  6, '{"opticalCode":2213}', 0, 'BC_IPS_2213');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (673, 'IPS-IN_2214',  6, '{"opticalCode":2214}', 0, 'BC_IPS_2214');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (674, 'IPS-IN_2215',  6, '{"opticalCode":2215}', 0, 'BC_IPS_2215');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (675, 'IPS-IN_2216',  6, '{"opticalCode":2216}', 0, 'BC_IPS_2216');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (676, 'IPS-IN_2217',  6, '{"opticalCode":2217}', 0, 'BC_IPS_2217');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (677, 'IPS-IN_2218',  6, '{"opticalCode":2218}', 0, 'BC_IPS_2218');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (678, 'IPS-IN_2219',  6, '{"opticalCode":2219}', 0, 'BC_IPS_2219');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (679, 'IPS-IN_2220',  6, '{"opticalCode":2220}', 0, 'BC_IPS_2220');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (680, 'IPS-IN_2221',  6, '{"opticalCode":2221}', 0, 'BC_IPS_2221');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (681, 'IPS-IN_2222',  6, '{"opticalCode":2222}', 0, 'BC_IPS_2222');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (682, 'IPS-IN_2223',  6, '{"opticalCode":2223}', 0, 'BC_IPS_2223');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (683, 'IPS-IN_2224',  6, '{"opticalCode":2224}', 0, 'BC_IPS_2224');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (684, 'IPS-IN_2225',  6, '{"opticalCode":2225}', 0, 'BC_IPS_2225');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (685, 'IPS-IN_2226',  6, '{"opticalCode":2226}', 0, 'BC_IPS_2226');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (686, 'IPS-IN_2227',  6, '{"opticalCode":2227}', 0, 'BC_IPS_2227');
--Outdoor-IPS A7
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (687, 'IPS-OUT_1201',  5, '{"opticalCode":1201}', 0, 'BC_IPS_1201');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (688, 'IPS-OUT_1202',  5, '{"opticalCode":1202}', 0, 'BC_IPS_1202');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (689, 'IPS-OUT_1203',  5, '{"opticalCode":1203}', 0, 'BC_IPS_1203');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (690, 'IPS-OUT_1204',  5, '{"opticalCode":1204}', 0, 'BC_IPS_1204');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (691, 'IPS-OUT_1205',  5, '{"opticalCode":1205}', 0, 'BC_IPS_1205');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (692, 'IPS-OUT_1206',  5, '{"opticalCode":1206}', 0, 'BC_IPS_1206');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (693, 'IPS-OUT_1207',  5, '{"opticalCode":1207}', 0, 'BC_IPS_1207');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (694, 'IPS-OUT_1208',  5, '{"opticalCode":1208}', 0, 'BC_IPS_1208');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (695, 'IPS-OUT_1209',  5, '{"opticalCode":1209}', 0, 'BC_IPS_1209');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (696, 'IPS-OUT_1210',  5, '{"opticalCode":1210}', 0, 'BC_IPS_1210');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (697, 'IPS-OUT_1211',  5, '{"opticalCode":1211}', 0, 'BC_IPS_1211');
--Indoor-IPS A7
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (698, 'IPS-IN_2228',  6, '{"opticalCode":2228}', 0, 'BC_IPS_2228');
--Roof-IPS A7
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (699, 'IPS-IN_3021',  6, '{"opticalCode":3021}', 0, 'BC_IPS_3021');
--Indoor-IPS A8
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (700, 'IPS-IN_2251',  6, '{"opticalCode":2251}', 0, 'BC_IPS_2251');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (701, 'IPS-IN_2252',  6, '{"opticalCode":2252}', 0, 'BC_IPS_2252');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (702, 'IPS-IN_2253',  6, '{"opticalCode":2253}', 0, 'BC_IPS_2253');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (703, 'IPS-IN_2254',  6, '{"opticalCode":2254}', 0, 'BC_IPS_2254');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (704, 'IPS-IN_2255',  6, '{"opticalCode":2255}', 0, 'BC_IPS_2255');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (705, 'IPS-IN_2256',  6, '{"opticalCode":2256}', 0, 'BC_IPS_2256');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (706, 'IPS-IN_2257',  6, '{"opticalCode":2257}', 0, 'BC_IPS_2257');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (707, 'IPS-IN_2258',  6, '{"opticalCode":2258}', 0, 'BC_IPS_2258');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (708, 'IPS-IN_2259',  6, '{"opticalCode":2259}', 0, 'BC_IPS_2259');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (709, 'IPS-IN_2260',  6, '{"opticalCode":2260}', 0, 'BC_IPS_2260');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (710, 'IPS-IN_2261',  6, '{"opticalCode":2261}', 0, 'BC_IPS_2261');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (711, 'IPS-IN_2262',  6, '{"opticalCode":2262}', 0, 'BC_IPS_2262');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (712, 'IPS-IN_2263',  6, '{"opticalCode":2263}', 0, 'BC_IPS_2263');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (713, 'IPS-IN_2264',  6, '{"opticalCode":2264}', 0, 'BC_IPS_2264');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (714, 'IPS-IN_2265',  6, '{"opticalCode":2265}', 0, 'BC_IPS_2265');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (715, 'IPS-IN_2266',  6, '{"opticalCode":2266}', 0, 'BC_IPS_2266');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (716, 'IPS-IN_2267',  6, '{"opticalCode":2267}', 0, 'BC_IPS_2267');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (717, 'IPS-IN_2268',  6, '{"opticalCode":2268}', 0, 'BC_IPS_2268');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (718, 'IPS-IN_2269',  6, '{"opticalCode":2269}', 0, 'BC_IPS_2269');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (719, 'IPS-IN_2270',  6, '{"opticalCode":2270}', 0, 'BC_IPS_2270');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (720, 'IPS-IN_2271',  6, '{"opticalCode":2271}', 0, 'BC_IPS_2271');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (721, 'IPS-IN_2272',  6, '{"opticalCode":2272}', 0, 'BC_IPS_2272');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (722, 'IPS-IN_2273',  6, '{"opticalCode":2273}', 0, 'BC_IPS_2273');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (723, 'IPS-IN_2274',  6, '{"opticalCode":2274}', 0, 'BC_IPS_2274');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (724, 'IPS-IN_2275',  6, '{"opticalCode":2275}', 0, 'BC_IPS_2275');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (725, 'IPS-IN_2276',  6, '{"opticalCode":2276}', 0, 'BC_IPS_2276');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (726, 'IPS-IN_2277',  6, '{"opticalCode":2277}', 0, 'BC_IPS_2277');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (727, 'IPS-IN_2278',  6, '{"opticalCode":2278}', 0, 'BC_IPS_2278');
--Outdoor-IPS A8
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (728, 'IPS-OUT_1251',  5, '{"opticalCode":1251}', 0, 'BC_IPS_1251');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (729, 'IPS-OUT_1252',  5, '{"opticalCode":1252}', 0, 'BC_IPS_1252');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (730, 'IPS-OUT_1253',  5, '{"opticalCode":1253}', 0, 'BC_IPS_1253');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (731, 'IPS-OUT_1254',  5, '{"opticalCode":1254}', 0, 'BC_IPS_1254');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (732, 'IPS-OUT_1255',  5, '{"opticalCode":1255}', 0, 'BC_IPS_1255');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (733, 'IPS-OUT_1256',  5, '{"opticalCode":1256}', 0, 'BC_IPS_1256');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (734, 'IPS-OUT_1257',  5, '{"opticalCode":1257}', 0, 'BC_IPS_1257');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (735, 'IPS-OUT_1258',  5, '{"opticalCode":1258}', 0, 'BC_IPS_1258');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (736, 'IPS-OUT_1259',  5, '{"opticalCode":1259}', 0, 'BC_IPS_1259');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (737, 'IPS-OUT_1260',  5, '{"opticalCode":1260}', 0, 'BC_IPS_1260');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (738, 'IPS-OUT_1261',  5, '{"opticalCode":1261}', 0, 'BC_IPS_1261');
--Roof-IPS A8
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (739, 'IPS-IN_3026',  6, '{"opticalCode":3026}', 0, 'BC_IPS_3026');
--Indoor-IPS A9
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (740, 'IPS-IN_2301',  6, '{"opticalCode":2301}', 0, 'BC_IPS_2301');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (741, 'IPS-IN_2302',  6, '{"opticalCode":2302}', 0, 'BC_IPS_2302');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (742, 'IPS-IN_2303',  6, '{"opticalCode":2303}', 0, 'BC_IPS_2303');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (743, 'IPS-IN_2304',  6, '{"opticalCode":2304}', 0, 'BC_IPS_2304');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (744, 'IPS-IN_2305',  6, '{"opticalCode":2305}', 0, 'BC_IPS_2305');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (745, 'IPS-IN_2306',  6, '{"opticalCode":2306}', 0, 'BC_IPS_2306');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (746, 'IPS-IN_2307',  6, '{"opticalCode":2307}', 0, 'BC_IPS_2307');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (747, 'IPS-IN_2308',  6, '{"opticalCode":2308}', 0, 'BC_IPS_2308');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (748, 'IPS-IN_2309',  6, '{"opticalCode":2309}', 0, 'BC_IPS_2309');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (749, 'IPS-IN_2310',  6, '{"opticalCode":2310}', 0, 'BC_IPS_2310');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (750, 'IPS-IN_2311',  6, '{"opticalCode":2311}', 0, 'BC_IPS_2311');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (751, 'IPS-IN_2312',  6, '{"opticalCode":2312}', 0, 'BC_IPS_2312');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (752, 'IPS-IN_2313',  6, '{"opticalCode":2313}', 0, 'BC_IPS_2313');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (753, 'IPS-IN_2314',  6, '{"opticalCode":2314}', 0, 'BC_IPS_2314');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (754, 'IPS-IN_2315',  6, '{"opticalCode":2315}', 0, 'BC_IPS_2315');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (755, 'IPS-IN_2316',  6, '{"opticalCode":2316}', 0, 'BC_IPS_2316');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (756, 'IPS-IN_2317',  6, '{"opticalCode":2317}', 0, 'BC_IPS_2317');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (757, 'IPS-IN_2318',  6, '{"opticalCode":2318}', 0, 'BC_IPS_2318');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (758, 'IPS-IN_2319',  6, '{"opticalCode":2319}', 0, 'BC_IPS_2319');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (759, 'IPS-IN_2320',  6, '{"opticalCode":2320}', 0, 'BC_IPS_2320');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (760, 'IPS-IN_2321',  6, '{"opticalCode":2321}', 0, 'BC_IPS_2321');
--Outdoor-IPS A9
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (761, 'IPS-OUT_1301',  5, '{"opticalCode":1301}', 0, 'BC_IPS_1301');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (762, 'IPS-OUT_1302',  5, '{"opticalCode":1302}', 0, 'BC_IPS_1302');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (763, 'IPS-OUT_1303',  5, '{"opticalCode":1303}', 0, 'BC_IPS_1303');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (764, 'IPS-OUT_1304',  5, '{"opticalCode":1304}', 0, 'BC_IPS_1304');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (765, 'IPS-OUT_1305',  5, '{"opticalCode":1305}', 0, 'BC_IPS_1305');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (766, 'IPS-OUT_1306',  5, '{"opticalCode":1306}', 0, 'BC_IPS_1306');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (767, 'IPS-OUT_1307',  5, '{"opticalCode":1307}', 0, 'BC_IPS_1307');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (768, 'IPS-OUT_1308',  5, '{"opticalCode":1308}', 0, 'BC_IPS_1308');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (769, 'IPS-OUT_1309',  5, '{"opticalCode":1309}', 0, 'BC_IPS_1309');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (770, 'IPS-OUT_1310',  5, '{"opticalCode":1310}', 0, 'BC_IPS_1310');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (771, 'IPS-OUT_1311',  5, '{"opticalCode":1311}', 0, 'BC_IPS_1311');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (772, 'IPS-OUT_1312',  5, '{"opticalCode":1312}', 0, 'BC_IPS_1312');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (773, 'IPS-OUT_1313',  5, '{"opticalCode":1313}', 0, 'BC_IPS_1313');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (774, 'IPS-OUT_1314',  5, '{"opticalCode":1314}', 0, 'BC_IPS_1314');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (775, 'IPS-OUT_1315',  5, '{"opticalCode":1315}', 0, 'BC_IPS_1315');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (776, 'IPS-OUT_1316',  5, '{"opticalCode":1316}', 0, 'BC_IPS_1316');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (777, 'IPS-OUT_1317',  5, '{"opticalCode":1317}', 0, 'BC_IPS_1317');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (778, 'IPS-OUT_1318',  5, '{"opticalCode":1318}', 0, 'BC_IPS_1318');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (779, 'IPS-OUT_1319',  5, '{"opticalCode":1319}', 0, 'BC_IPS_1319');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (780, 'IPS-OUT_1320',  5, '{"opticalCode":1320}', 0, 'BC_IPS_1320');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (781, 'IPS-OUT_1321',  5, '{"opticalCode":1321}', 0, 'BC_IPS_1321');
--Roof-IPS A9
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (782, 'IPS-IN_3031',  6, '{"opticalCode":3031}', 0, 'BC_IPS_3031');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (783, 'IPS-IN_3032',  6, '{"opticalCode":3032}', 0, 'BC_IPS_3032');
--Indoor-IPS A10
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (784, 'IPS-IN_2351',  6, '{"opticalCode":2351}', 0, 'BC_IPS_2351');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (785, 'IPS-IN_2352',  6, '{"opticalCode":2352}', 0, 'BC_IPS_2352');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (786, 'IPS-IN_2353',  6, '{"opticalCode":2353}', 0, 'BC_IPS_2353');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (787, 'IPS-IN_2354',  6, '{"opticalCode":2354}', 0, 'BC_IPS_2354');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (788, 'IPS-IN_2355',  6, '{"opticalCode":2355}', 0, 'BC_IPS_2355');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (789, 'IPS-IN_2356',  6, '{"opticalCode":2356}', 0, 'BC_IPS_2356');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (790, 'IPS-IN_2357',  6, '{"opticalCode":2357}', 0, 'BC_IPS_2357');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (791, 'IPS-IN_2358',  6, '{"opticalCode":2358}', 0, 'BC_IPS_2358');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (792, 'IPS-IN_2359',  6, '{"opticalCode":2359}', 0, 'BC_IPS_2359');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (793, 'IPS-IN_2360',  6, '{"opticalCode":2360}', 0, 'BC_IPS_2360');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (794, 'IPS-IN_2361',  6, '{"opticalCode":2361}', 0, 'BC_IPS_2361');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (795, 'IPS-IN_2362',  6, '{"opticalCode":2362}', 0, 'BC_IPS_2362');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (796, 'IPS-IN_2363',  6, '{"opticalCode":2363}', 0, 'BC_IPS_2363');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (797, 'IPS-IN_2364',  6, '{"opticalCode":2364}', 0, 'BC_IPS_2364');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (798, 'IPS-IN_2365',  6, '{"opticalCode":2365}', 0, 'BC_IPS_2365');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (799, 'IPS-IN_2366',  6, '{"opticalCode":2366}', 0, 'BC_IPS_2366');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (800, 'IPS-IN_2367',  6, '{"opticalCode":2367}', 0, 'BC_IPS_2367');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (801, 'IPS-IN_2368',  6, '{"opticalCode":2368}', 0, 'BC_IPS_2368');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (802, 'IPS-IN_2369',  6, '{"opticalCode":2369}', 0, 'BC_IPS_2369');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (803, 'IPS-IN_2370',  6, '{"opticalCode":2370}', 0, 'BC_IPS_2370');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (804, 'IPS-IN_2371',  6, '{"opticalCode":2371}', 0, 'BC_IPS_2371');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (805, 'IPS-IN_2372',  6, '{"opticalCode":2372}', 0, 'BC_IPS_2372');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (806, 'IPS-IN_2373',  6, '{"opticalCode":2373}', 0, 'BC_IPS_2373');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (807, 'IPS-IN_2374',  6, '{"opticalCode":2374}', 0, 'BC_IPS_2374');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (808, 'IPS-IN_2375',  6, '{"opticalCode":2375}', 0, 'BC_IPS_2375');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (809, 'IPS-IN_2376',  6, '{"opticalCode":2376}', 0, 'BC_IPS_2376');
--Outdoor-IPS A10
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (810, 'IPS-OUT_1351',  5, '{"opticalCode":1351}', 0, 'BC_IPS_1351');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (811, 'IPS-OUT_1352',  5, '{"opticalCode":1352}', 0, 'BC_IPS_1352');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (812, 'IPS-OUT_1353',  5, '{"opticalCode":1353}', 0, 'BC_IPS_1353');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (813, 'IPS-OUT_1354',  5, '{"opticalCode":1354}', 0, 'BC_IPS_1354');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (814, 'IPS-OUT_1355',  5, '{"opticalCode":1355}', 0, 'BC_IPS_1355');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (815, 'IPS-OUT_1356',  5, '{"opticalCode":1356}', 0, 'BC_IPS_1356');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (816, 'IPS-OUT_1357',  5, '{"opticalCode":1357}', 0, 'BC_IPS_1357');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (817, 'IPS-OUT_1358',  5, '{"opticalCode":1358}', 0, 'BC_IPS_1358');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (818, 'IPS-OUT_1359',  5, '{"opticalCode":1359}', 0, 'BC_IPS_1359');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (819, 'IPS-OUT_1360',  5, '{"opticalCode":1360}', 0, 'BC_IPS_1360');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (820, 'IPS-OUT_1361',  5, '{"opticalCode":1361}', 0, 'BC_IPS_1361');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (821, 'IPS-OUT_1362',  5, '{"opticalCode":1362}', 0, 'BC_IPS_1362');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (822, 'IPS-OUT_1363',  5, '{"opticalCode":1363}', 0, 'BC_IPS_1363');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (823, 'IPS-OUT_1364',  5, '{"opticalCode":1364}', 0, 'BC_IPS_1364');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (824, 'IPS-OUT_1365',  5, '{"opticalCode":1365}', 0, 'BC_IPS_1365');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (825, 'IPS-OUT_1366',  5, '{"opticalCode":1366}', 0, 'BC_IPS_1366');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (826, 'IPS-OUT_1367',  5, '{"opticalCode":1367}', 0, 'BC_IPS_1367');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (827, 'IPS-OUT_1368',  5, '{"opticalCode":1368}', 0, 'BC_IPS_1368');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (828, 'IPS-OUT_1369',  5, '{"opticalCode":1369}', 0, 'BC_IPS_1369');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (829, 'IPS-OUT_1370',  5, '{"opticalCode":1370}', 0, 'BC_IPS_1370');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (830, 'IPS-OUT_1371',  5, '{"opticalCode":1371}', 0, 'BC_IPS_1371');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (831, 'IPS-OUT_1372',  5, '{"opticalCode":1372}', 0, 'BC_IPS_1372');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (832, 'IPS-OUT_1373',  5, '{"opticalCode":1373}', 0, 'BC_IPS_1373');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (833, 'IPS-OUT_1374',  5, '{"opticalCode":1374}', 0, 'BC_IPS_1374');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (834, 'IPS-OUT_1375',  5, '{"opticalCode":1375}', 0, 'BC_IPS_1375');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (835, 'IPS-OUT_1376',  5, '{"opticalCode":1376}', 0, 'BC_IPS_1376');
--Roof-IPS A10
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (836, 'IPS-IN_3036',  6, '{"opticalCode":3036}', 0, 'BC_IPS_3036');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (837, 'IPS-IN_3037',  6, '{"opticalCode":3037}', 0, 'BC_IPS_3037');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (838, 'IPS-IN_3038',  6, '{"opticalCode":3038}', 0, 'BC_IPS_3038');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (839, 'IPS-IN_3039',  6, '{"opticalCode":3039}', 0, 'BC_IPS_3039');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (840, 'IPS-IN_3040',  6, '{"opticalCode":3040}', 0, 'BC_IPS_3040');
--Indoor-IPS A11
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (841, 'IPS-IN_2401',  6, '{"opticalCode":2401}', 0, 'BC_IPS_2401');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (842, 'IPS-IN_2402',  6, '{"opticalCode":2402}', 0, 'BC_IPS_2402');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (843, 'IPS-IN_2403',  6, '{"opticalCode":2403}', 0, 'BC_IPS_2403');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (844, 'IPS-IN_2404',  6, '{"opticalCode":2404}', 0, 'BC_IPS_2404');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (845, 'IPS-IN_2405',  6, '{"opticalCode":2405}', 0, 'BC_IPS_2405');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (846, 'IPS-IN_2406',  6, '{"opticalCode":2406}', 0, 'BC_IPS_2406');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (847, 'IPS-IN_2407',  6, '{"opticalCode":2407}', 0, 'BC_IPS_2407');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (848, 'IPS-IN_2408',  6, '{"opticalCode":2408}', 0, 'BC_IPS_2408');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (849, 'IPS-IN_2409',  6, '{"opticalCode":2409}', 0, 'BC_IPS_2409');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (850, 'IPS-IN_2410',  6, '{"opticalCode":2410}', 0, 'BC_IPS_2410');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (851, 'IPS-IN_2411',  6, '{"opticalCode":2411}', 0, 'BC_IPS_2411');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (852, 'IPS-IN_2412',  6, '{"opticalCode":2412}', 0, 'BC_IPS_2412');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (853, 'IPS-IN_2413',  6, '{"opticalCode":2413}', 0, 'BC_IPS_2413');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (854, 'IPS-IN_2414',  6, '{"opticalCode":2414}', 0, 'BC_IPS_2414');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (855, 'IPS-IN_2415',  6, '{"opticalCode":2415}', 0, 'BC_IPS_2415');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (856, 'IPS-IN_2416',  6, '{"opticalCode":2416}', 0, 'BC_IPS_2416');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (857, 'IPS-IN_2417',  6, '{"opticalCode":2417}', 0, 'BC_IPS_2417');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (858, 'IPS-IN_2418',  6, '{"opticalCode":2418}', 0, 'BC_IPS_2418');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (859, 'IPS-IN_2419',  6, '{"opticalCode":2419}', 0, 'BC_IPS_2419');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (860, 'IPS-IN_2420',  6, '{"opticalCode":2420}', 0, 'BC_IPS_2420');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (861, 'IPS-IN_2421',  6, '{"opticalCode":2421}', 0, 'BC_IPS_2421');
--Outdoor-IPS A11
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (862, 'IPS-OUT_1401',  5, '{"opticalCode":1401}', 0, 'BC_IPS_1401');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (863, 'IPS-OUT_1402',  5, '{"opticalCode":1402}', 0, 'BC_IPS_1402');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (864, 'IPS-OUT_1403',  5, '{"opticalCode":1403}', 0, 'BC_IPS_1403');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (865, 'IPS-OUT_1404',  5, '{"opticalCode":1404}', 0, 'BC_IPS_1404');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (866, 'IPS-OUT_1405',  5, '{"opticalCode":1405}', 0, 'BC_IPS_1405');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (867, 'IPS-OUT_1406',  5, '{"opticalCode":1406}', 0, 'BC_IPS_1406');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (868, 'IPS-OUT_1407',  5, '{"opticalCode":1407}', 0, 'BC_IPS_1407');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (869, 'IPS-OUT_1408',  5, '{"opticalCode":1408}', 0, 'BC_IPS_1408');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (870, 'IPS-OUT_1409',  5, '{"opticalCode":1409}', 0, 'BC_IPS_1409');
--Outdoor-IPS A11
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (871, 'IPS-OUT_1410',  5, '{"opticalCode":1410}', 0, 'BC_IPS_1410');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (872, 'IPS-OUT_1411',  5, '{"opticalCode":1411}', 0, 'BC_IPS_1411');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (873, 'IPS-OUT_1412',  5, '{"opticalCode":1412}', 0, 'BC_IPS_1412');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (874, 'IPS-OUT_1413',  5, '{"opticalCode":1413}', 0, 'BC_IPS_1413');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (875, 'IPS-OUT_1414',  5, '{"opticalCode":1414}', 0, 'BC_IPS_1414');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (876, 'IPS-OUT_1415',  5, '{"opticalCode":1415}', 0, 'BC_IPS_1415');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (877, 'IPS-OUT_1416',  5, '{"opticalCode":1416}', 0, 'BC_IPS_1416');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (878, 'IPS-OUT_1417',  5, '{"opticalCode":1417}', 0, 'BC_IPS_1417');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (879, 'IPS-OUT_1418',  5, '{"opticalCode":1418}', 0, 'BC_IPS_1418');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (880, 'IPS-OUT_1419',  5, '{"opticalCode":1419}', 0, 'BC_IPS_1419');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (881, 'IPS-OUT_1420',  5, '{"opticalCode":1420}', 0, 'BC_IPS_1420');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (882, 'IPS-OUT_1421',  5, '{"opticalCode":1421}', 0, 'BC_IPS_1421');
--Roof-IPS A11
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (883, 'IPS-IN_3041',  6, '{"opticalCode":3041}', 0, 'BC_IPS_3041');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (884, 'IPS-IN_3042',  6, '{"opticalCode":3042}', 0, 'BC_IPS_3042');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (885, 'IPS-IN_3043',  6, '{"opticalCode":3043}', 0, 'BC_IPS_3043');
--Indoor-IPS A12
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (886, 'IPS-IN_2451',  6, '{"opticalCode":2451}', 0, 'BC_IPS_2451');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (887, 'IPS-IN_2452',  6, '{"opticalCode":2452}', 0, 'BC_IPS_2452');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (888, 'IPS-IN_2453',  6, '{"opticalCode":2453}', 0, 'BC_IPS_2453');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (889, 'IPS-IN_2454',  6, '{"opticalCode":2454}', 0, 'BC_IPS_2454');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (890, 'IPS-IN_2455',  6, '{"opticalCode":2455}', 0, 'BC_IPS_2455');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (891, 'IPS-IN_2456',  6, '{"opticalCode":2456}', 0, 'BC_IPS_2456');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (892, 'IPS-IN_2457',  6, '{"opticalCode":2457}', 0, 'BC_IPS_2457');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (893, 'IPS-IN_2458',  6, '{"opticalCode":2458}', 0, 'BC_IPS_2458');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (894, 'IPS-IN_2459',  6, '{"opticalCode":2459}', 0, 'BC_IPS_2459');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (895, 'IPS-IN_2460',  6, '{"opticalCode":2460}', 0, 'BC_IPS_2460');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (896, 'IPS-IN_2461',  6, '{"opticalCode":2461}', 0, 'BC_IPS_2461');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (897, 'IPS-IN_2462',  6, '{"opticalCode":2462}', 0, 'BC_IPS_2462');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (898, 'IPS-IN_2463',  6, '{"opticalCode":2463}', 0, 'BC_IPS_2463');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (899, 'IPS-IN_2464',  6, '{"opticalCode":2464}', 0, 'BC_IPS_2464');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (900, 'IPS-IN_2465',  6, '{"opticalCode":2465}', 0, 'BC_IPS_2465');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (901, 'IPS-IN_2466',  6, '{"opticalCode":2466}', 0, 'BC_IPS_2466');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (902, 'IPS-IN_2467',  6, '{"opticalCode":2467}', 0, 'BC_IPS_2467');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (903, 'IPS-IN_2468',  6, '{"opticalCode":2468}', 0, 'BC_IPS_2468');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (904, 'IPS-IN_2469',  6, '{"opticalCode":2469}', 0, 'BC_IPS_2469');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (905, 'IPS-IN_2470',  6, '{"opticalCode":2470}', 0, 'BC_IPS_2470');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (906, 'IPS-IN_2471',  6, '{"opticalCode":2471}', 0, 'BC_IPS_2471');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (907, 'IPS-IN_2472',  6, '{"opticalCode":2472}', 0, 'BC_IPS_2472');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (908, 'IPS-IN_2473',  6, '{"opticalCode":2473}', 0, 'BC_IPS_2473');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (909, 'IPS-IN_2474',  6, '{"opticalCode":2474}', 0, 'BC_IPS_2474');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (910, 'IPS-IN_2475',  6, '{"opticalCode":2475}', 0, 'BC_IPS_2475');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (911, 'IPS-IN_2476',  6, '{"opticalCode":2476}', 0, 'BC_IPS_2476');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (912, 'IPS-IN_2477',  6, '{"opticalCode":2477}', 0, 'BC_IPS_2477');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (913, 'IPS-IN_2478',  6, '{"opticalCode":2478}', 0, 'BC_IPS_2478');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (914, 'IPS-IN_2479',  6, '{"opticalCode":2479}', 0, 'BC_IPS_2479');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (915, 'IPS-IN_2480',  6, '{"opticalCode":2480}', 0, 'BC_IPS_2480');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (916, 'IPS-IN_2481',  6, '{"opticalCode":2481}', 0, 'BC_IPS_2481');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (917, 'IPS-IN_2482',  6, '{"opticalCode":2482}', 0, 'BC_IPS_2482');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (918, 'IPS-IN_2483',  6, '{"opticalCode":2483}', 0, 'BC_IPS_2483');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (919, 'IPS-IN_2484',  6, '{"opticalCode":2484}', 0, 'BC_IPS_2484');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (920, 'IPS-IN_2485',  6, '{"opticalCode":2485}', 0, 'BC_IPS_2485');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (921, 'IPS-IN_2486',  6, '{"opticalCode":2486}', 0, 'BC_IPS_2486');
--Outdoor-IPS A12
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (922, 'IPS-IN_1451',  5, '{"opticalCode":1451}', 0, 'BC_IPS_1451');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (923, 'IPS-IN_1452',  5, '{"opticalCode":1452}', 0, 'BC_IPS_1452');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (924, 'IPS-IN_1453',  5, '{"opticalCode":1453}', 0, 'BC_IPS_1453');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (925, 'IPS-IN_1454',  5, '{"opticalCode":1454}', 0, 'BC_IPS_1454');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (926, 'IPS-IN_1455',  5, '{"opticalCode":1455}', 0, 'BC_IPS_1455');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (927, 'IPS-IN_1456',  5, '{"opticalCode":1456}', 0, 'BC_IPS_1456');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (928, 'IPS-IN_1457',  5, '{"opticalCode":1457}', 0, 'BC_IPS_1457');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (929, 'IPS-IN_1458',  5, '{"opticalCode":1458}', 0, 'BC_IPS_1458');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (930, 'IPS-IN_1459',  5, '{"opticalCode":1459}', 0, 'BC_IPS_1459');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (931, 'IPS-IN_1460',  5, '{"opticalCode":1460}', 0, 'BC_IPS_1460');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (932, 'IPS-IN_1461',  5, '{"opticalCode":1461}', 0, 'BC_IPS_1461');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (933, 'IPS-IN_1462',  5, '{"opticalCode":1462}', 0, 'BC_IPS_1462');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (934, 'IPS-IN_1463',  5, '{"opticalCode":1463}', 0, 'BC_IPS_1463');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (935, 'IPS-IN_1464',  5, '{"opticalCode":1464}', 0, 'BC_IPS_1464');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (936, 'IPS-IN_1465',  5, '{"opticalCode":1465}', 0, 'BC_IPS_1465');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (937, 'IPS-IN_1466',  5, '{"opticalCode":1466}', 0, 'BC_IPS_1466');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (938, 'IPS-IN_1467',  5, '{"opticalCode":1467}', 0, 'BC_IPS_1467');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (939, 'IPS-IN_1468',  5, '{"opticalCode":1468}', 0, 'BC_IPS_1468');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (940, 'IPS-IN_1469',  5, '{"opticalCode":1469}', 0, 'BC_IPS_1469');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (941, 'IPS-IN_1470',  5, '{"opticalCode":1470}', 0, 'BC_IPS_1470');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (942, 'IPS-IN_1471',  5, '{"opticalCode":1471}', 0, 'BC_IPS_1471');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (943, 'IPS-IN_1472',  5, '{"opticalCode":1472}', 0, 'BC_IPS_1472');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (944, 'IPS-IN_1473',  5, '{"opticalCode":1473}', 0, 'BC_IPS_1473');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (945, 'IPS-IN_1474',  5, '{"opticalCode":1474}', 0, 'BC_IPS_1474');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (946, 'IPS-IN_1475',  5, '{"opticalCode":1475}', 0, 'BC_IPS_1475');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (947, 'IPS-IN_1476',  5, '{"opticalCode":1476}', 0, 'BC_IPS_1476');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (948, 'IPS-IN_1477',  5, '{"opticalCode":1477}', 0, 'BC_IPS_1477');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (949, 'IPS-IN_1478',  5, '{"opticalCode":1478}', 0, 'BC_IPS_1478');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (950, 'IPS-IN_1479',  5, '{"opticalCode":1479}', 0, 'BC_IPS_1479');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (951, 'IPS-IN_1480',  5, '{"opticalCode":1480}', 0, 'BC_IPS_1480');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (952, 'IPS-IN_1481',  5, '{"opticalCode":1481}', 0, 'BC_IPS_1481');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (953, 'IPS-IN_1482',  5, '{"opticalCode":1482}', 0, 'BC_IPS_1482');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (954, 'IPS-IN_1483',  5, '{"opticalCode":1483}', 0, 'BC_IPS_1483');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (955, 'IPS-IN_1484',  5, '{"opticalCode":1484}', 0, 'BC_IPS_1484');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (956, 'IPS-IN_1485',  5, '{"opticalCode":1485}', 0, 'BC_IPS_1485');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (957, 'IPS-IN_1486',  5, '{"opticalCode":1486}', 0, 'BC_IPS_1486');
--Roof-IPS A12
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (958, 'IPS-IN_3046',  6, '{"opticalCode":3046}', 0, 'BC_IPS_3046');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (959, 'IPS-IN_3047',  6, '{"opticalCode":3047}', 0, 'BC_IPS_3047');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (960, 'IPS-IN_3048',  6, '{"opticalCode":3048}', 0, 'BC_IPS_3048');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (961, 'IPS-IN_3049',  6, '{"opticalCode":3049}', 0, 'BC_IPS_3049');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (962, 'IPS-IN_3050',  6, '{"opticalCode":3050}', 0, 'BC_IPS_3050');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (963, 'IPS-IN_3051',  6, '{"opticalCode":3051}', 0, 'BC_IPS_3051');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (964, 'IPS-IN_3052',  6, '{"opticalCode":3052}', 0, 'BC_IPS_3052');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (965, 'IPS-IN_3053',  6, '{"opticalCode":3053}', 0, 'BC_IPS_3053');
--Indoor-IPS A13
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (966, 'IPS-IN_2501',  6, '{"opticalCode":2501}', 0, 'BC_IPS_2501');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (967, 'IPS-IN_2502',  6, '{"opticalCode":2502}', 0, 'BC_IPS_2502');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (968, 'IPS-IN_2503',  6, '{"opticalCode":2503}', 0, 'BC_IPS_2503');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (969, 'IPS-IN_2504',  6, '{"opticalCode":2504}', 0, 'BC_IPS_2504');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (970, 'IPS-IN_2505',  6, '{"opticalCode":2505}', 0, 'BC_IPS_2505');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (971, 'IPS-IN_2506',  6, '{"opticalCode":2506}', 0, 'BC_IPS_2506');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (972, 'IPS-IN_2507',  6, '{"opticalCode":2507}', 0, 'BC_IPS_2507');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (973, 'IPS-IN_2508',  6, '{"opticalCode":2508}', 0, 'BC_IPS_2508');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (974, 'IPS-IN_2509',  6, '{"opticalCode":2509}', 0, 'BC_IPS_2509');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (975, 'IPS-IN_2510',  6, '{"opticalCode":2510}', 0, 'BC_IPS_2510');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (976, 'IPS-IN_2511',  6, '{"opticalCode":2511}', 0, 'BC_IPS_2511');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (977, 'IPS-IN_2512',  6, '{"opticalCode":2512}', 0, 'BC_IPS_2512');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (978, 'IPS-IN_2513',  6, '{"opticalCode":2513}', 0, 'BC_IPS_2513');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (979, 'IPS-IN_2514',  6, '{"opticalCode":2514}', 0, 'BC_IPS_2514');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (980, 'IPS-IN_2515',  6, '{"opticalCode":2515}', 0, 'BC_IPS_2515');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (981, 'IPS-IN_2516',  6, '{"opticalCode":2516}', 0, 'BC_IPS_2516');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (982, 'IPS-IN_2517',  6, '{"opticalCode":2517}', 0, 'BC_IPS_2517');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (983, 'IPS-IN_2518',  6, '{"opticalCode":2518}', 0, 'BC_IPS_2518');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (984, 'IPS-IN_2519',  6, '{"opticalCode":2519}', 0, 'BC_IPS_2519');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (985, 'IPS-IN_2520',  6, '{"opticalCode":2520}', 0, 'BC_IPS_2520');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (986, 'IPS-IN_2521',  6, '{"opticalCode":2521}', 0, 'BC_IPS_2521');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (987, 'IPS-IN_2522',  6, '{"opticalCode":2522}', 0, 'BC_IPS_2522');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (988, 'IPS-IN_2523',  6, '{"opticalCode":2523}', 0, 'BC_IPS_2523');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (989, 'IPS-IN_2524',  6, '{"opticalCode":2524}', 0, 'BC_IPS_2524');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (990, 'IPS-IN_2525',  6, '{"opticalCode":2525}', 0, 'BC_IPS_2525');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (991, 'IPS-IN_2526',  6, '{"opticalCode":2526}', 0, 'BC_IPS_2526');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (992, 'IPS-IN_2527',  6, '{"opticalCode":2527}', 0, 'BC_IPS_2527');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (993, 'IPS-IN_2528',  6, '{"opticalCode":2528}', 0, 'BC_IPS_2528');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (994, 'IPS-IN_2529',  6, '{"opticalCode":2529}', 0, 'BC_IPS_2529');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (995, 'IPS-IN_2530',  6, '{"opticalCode":2530}', 0, 'BC_IPS_2530');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (996, 'IPS-IN_2531',  6, '{"opticalCode":2531}', 0, 'BC_IPS_2531');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (997, 'IPS-IN_2532',  6, '{"opticalCode":2532}', 0, 'BC_IPS_2532');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (998, 'IPS-IN_2533',  6, '{"opticalCode":2533}', 0, 'BC_IPS_2533');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (999, 'IPS-IN_2534',  6, '{"opticalCode":2534}', 0, 'BC_IPS_2534');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1000, 'IPS-IN_2535',  6, '{"opticalCode":2535}', 0, 'BC_IPS_2535');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1001, 'IPS-IN_2536',  6, '{"opticalCode":2536}', 0, 'BC_IPS_2536');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1002, 'IPS-IN_2537',  6, '{"opticalCode":2537}', 0, 'BC_IPS_2537');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1003, 'IPS-IN_2538',  6, '{"opticalCode":2538}', 0, 'BC_IPS_2538');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1004, 'IPS-IN_2539',  6, '{"opticalCode":2539}', 0, 'BC_IPS_2539');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1005, 'IPS-IN_2540',  6, '{"opticalCode":2540}', 0, 'BC_IPS_2540');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1006, 'IPS-IN_2541',  6, '{"opticalCode":2541}', 0, 'BC_IPS_2541');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1007, 'IPS-IN_2542',  6, '{"opticalCode":2542}', 0, 'BC_IPS_2542');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1008, 'IPS-IN_2543',  6, '{"opticalCode":2543}', 0, 'BC_IPS_2543');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1009, 'IPS-IN_2544',  6, '{"opticalCode":2544}', 0, 'BC_IPS_2544');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1010, 'IPS-IN_2545',  6, '{"opticalCode":2545}', 0, 'BC_IPS_2545');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1011, 'IPS-IN_2546',  6, '{"opticalCode":2546}', 0, 'BC_IPS_2546');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1012, 'IPS-IN_2547',  6, '{"opticalCode":2547}', 0, 'BC_IPS_2547');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1013, 'IPS-IN_2548',  6, '{"opticalCode":2548}', 0, 'BC_IPS_2548');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1014, 'IPS-IN_2549',  6, '{"opticalCode":2549}', 0, 'BC_IPS_2549');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1015, 'IPS-IN_2550',  6, '{"opticalCode":2550}', 0, 'BC_IPS_2550');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1016, 'IPS-IN_2551',  6, '{"opticalCode":2551}', 0, 'BC_IPS_2551');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1017, 'IPS-IN_2552',  6, '{"opticalCode":2552}', 0, 'BC_IPS_2552');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1018, 'IPS-IN_2553',  6, '{"opticalCode":2553}', 0, 'BC_IPS_2553');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1019, 'IPS-IN_2554',  6, '{"opticalCode":2554}', 0, 'BC_IPS_2554');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1020, 'IPS-IN_2555',  6, '{"opticalCode":2555}', 0, 'BC_IPS_2555');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1021, 'IPS-IN_2556',  6, '{"opticalCode":2556}', 0, 'BC_IPS_2556');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1022, 'IPS-IN_2557',  6, '{"opticalCode":2557}', 0, 'BC_IPS_2557');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1023, 'IPS-IN_2558',  6, '{"opticalCode":2558}', 0, 'BC_IPS_2558');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1024, 'IPS-IN_2559',  6, '{"opticalCode":2559}', 0, 'BC_IPS_2559');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1025, 'IPS-IN_2560',  6, '{"opticalCode":2560}', 0, 'BC_IPS_2560');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1026, 'IPS-IN_2561',  6, '{"opticalCode":2561}', 0, 'BC_IPS_2561');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1027, 'IPS-IN_2562',  6, '{"opticalCode":2562}', 0, 'BC_IPS_2562');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1028, 'IPS-IN_2563',  6, '{"opticalCode":2563}', 0, 'BC_IPS_2563');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1029, 'IPS-IN_2564',  6, '{"opticalCode":2564}', 0, 'BC_IPS_2564');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1030, 'IPS-IN_2565',  6, '{"opticalCode":2565}', 0, 'BC_IPS_2565');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1031, 'IPS-IN_2566',  6, '{"opticalCode":2566}', 0, 'BC_IPS_2566');
--Outdoor-IPS A13
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1032, 'IPS-IN_1501',  5, '{"opticalCode":1501}', 0, 'BC_IPS_1501');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1033, 'IPS-IN_1502',  5, '{"opticalCode":1502}', 0, 'BC_IPS_1502');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1034, 'IPS-IN_1503',  5, '{"opticalCode":1503}', 0, 'BC_IPS_1503');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1035, 'IPS-IN_1504',  5, '{"opticalCode":1504}', 0, 'BC_IPS_1504');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1036, 'IPS-IN_1505',  5, '{"opticalCode":1505}', 0, 'BC_IPS_1505');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1037, 'IPS-IN_1506',  5, '{"opticalCode":1506}', 0, 'BC_IPS_1506');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1038, 'IPS-IN_1507',  5, '{"opticalCode":1507}', 0, 'BC_IPS_1507');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1039, 'IPS-IN_1508',  5, '{"opticalCode":1508}', 0, 'BC_IPS_1508');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1040, 'IPS-IN_1509',  5, '{"opticalCode":1509}', 0, 'BC_IPS_1509');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1041, 'IPS-IN_1510',  5, '{"opticalCode":1510}', 0, 'BC_IPS_1510');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1042, 'IPS-IN_1511',  5, '{"opticalCode":1511}', 0, 'BC_IPS_1511');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1043, 'IPS-IN_1512',  5, '{"opticalCode":1512}', 0, 'BC_IPS_1512');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1044, 'IPS-IN_1513',  5, '{"opticalCode":1513}', 0, 'BC_IPS_1513');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1045, 'IPS-IN_1514',  5, '{"opticalCode":1514}', 0, 'BC_IPS_1514');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1046, 'IPS-IN_1515',  5, '{"opticalCode":1515}', 0, 'BC_IPS_1515');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1047, 'IPS-IN_1516',  5, '{"opticalCode":1516}', 0, 'BC_IPS_1516');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1048, 'IPS-IN_1517',  5, '{"opticalCode":1517}', 0, 'BC_IPS_1517');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1049, 'IPS-IN_1518',  5, '{"opticalCode":1518}', 0, 'BC_IPS_1518');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1050, 'IPS-IN_1519',  5, '{"opticalCode":1519}', 0, 'BC_IPS_1519');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1051, 'IPS-IN_1520',  5, '{"opticalCode":1520}', 0, 'BC_IPS_1520');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1052, 'IPS-IN_1521',  5, '{"opticalCode":1521}', 0, 'BC_IPS_1521');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1053, 'IPS-IN_1522',  5, '{"opticalCode":1522}', 0, 'BC_IPS_1522');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1054, 'IPS-IN_1523',  5, '{"opticalCode":1523}', 0, 'BC_IPS_1523');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1055, 'IPS-IN_1524',  5, '{"opticalCode":1524}', 0, 'BC_IPS_1524');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1056, 'IPS-IN_1525',  5, '{"opticalCode":1525}', 0, 'BC_IPS_1525');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1057, 'IPS-IN_1526',  5, '{"opticalCode":1526}', 0, 'BC_IPS_1526');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1058, 'IPS-IN_1527',  5, '{"opticalCode":1527}', 0, 'BC_IPS_1527');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1059, 'IPS-IN_1528',  5, '{"opticalCode":1528}', 0, 'BC_IPS_1528');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1060, 'IPS-IN_1529',  5, '{"opticalCode":1529}', 0, 'BC_IPS_1529');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1061, 'IPS-IN_1530',  5, '{"opticalCode":1530}', 0, 'BC_IPS_1530');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1062, 'IPS-IN_1531',  5, '{"opticalCode":1531}', 0, 'BC_IPS_1531');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1063, 'IPS-IN_1532',  5, '{"opticalCode":1532}', 0, 'BC_IPS_1532');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1064, 'IPS-IN_1533',  5, '{"opticalCode":1533}', 0, 'BC_IPS_1533');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1065, 'IPS-IN_1534',  5, '{"opticalCode":1534}', 0, 'BC_IPS_1534');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1066, 'IPS-IN_1535',  5, '{"opticalCode":1535}', 0, 'BC_IPS_1535');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1067, 'IPS-IN_1536',  5, '{"opticalCode":1536}', 0, 'BC_IPS_1536');
--Roof-IPS A13
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1068, 'IPS-IN_3056',  6, '{"opticalCode":3056}', 0, 'BC_IPS_3056');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1069, 'IPS-IN_3057',  6, '{"opticalCode":3057}', 0, 'BC_IPS_3057');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1070, 'IPS-IN_3058',  6, '{"opticalCode":3058}', 0, 'BC_IPS_3058');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1071, 'IPS-IN_3059',  6, '{"opticalCode":3059}', 0, 'BC_IPS_3059');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1072, 'IPS-IN_3060',  6, '{"opticalCode":3060}', 0, 'BC_IPS_3060');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1073, 'IPS-IN_3061',  6, '{"opticalCode":3061}', 0, 'BC_IPS_3061');
--Indoor-IPS Tunnel
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1074, 'IPS-IN_2601',  6, '{"opticalCode":2601}', 0, 'BC_IPS_2601');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1075, 'IPS-IN_2602',  6, '{"opticalCode":2602}', 0, 'BC_IPS_2602');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1076, 'IPS-IN_2603',  6, '{"opticalCode":2603}', 0, 'BC_IPS_2603');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1077, 'IPS-IN_2604',  6, '{"opticalCode":2604}', 0, 'BC_IPS_2604');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1078, 'IPS-IN_2605',  6, '{"opticalCode":2605}', 0, 'BC_IPS_2605');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1079, 'IPS-IN_2606',  6, '{"opticalCode":2606}', 0, 'BC_IPS_2606');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1080, 'IPS-IN_2607',  6, '{"opticalCode":2607}', 0, 'BC_IPS_2607');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1081, 'IPS-IN_2608',  6, '{"opticalCode":2608}', 0, 'BC_IPS_2608');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1082, 'IPS-IN_2609',  6, '{"opticalCode":2609}', 0, 'BC_IPS_2609');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1083, 'IPS-IN_2610',  6, '{"opticalCode":2610}', 0, 'BC_IPS_2610');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1084, 'IPS-IN_2611',  6, '{"opticalCode":2611}', 0, 'BC_IPS_2611');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1085, 'IPS-IN_2612',  6, '{"opticalCode":2612}', 0, 'BC_IPS_2612');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1086, 'IPS-IN_2613',  6, '{"opticalCode":2613}', 0, 'BC_IPS_2613');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1087, 'IPS-IN_2614',  6, '{"opticalCode":2614}', 0, 'BC_IPS_2614');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1088, 'IPS-IN_2615',  6, '{"opticalCode":2615}', 0, 'BC_IPS_2615');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1089, 'IPS-IN_2616',  6, '{"opticalCode":2616}', 0, 'BC_IPS_2616');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1090, 'IPS-IN_2617',  6, '{"opticalCode":2617}', 0, 'BC_IPS_2617');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1091, 'IPS-IN_2618',  6, '{"opticalCode":2618}', 0, 'BC_IPS_2618');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1092, 'IPS-IN_2619',  6, '{"opticalCode":2619}', 0, 'BC_IPS_2619');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1093, 'IPS-IN_2620',  6, '{"opticalCode":2620}', 0, 'BC_IPS_2620');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1094, 'IPS-IN_2621',  6, '{"opticalCode":2621}', 0, 'BC_IPS_2621');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1095, 'IPS-IN_2622',  6, '{"opticalCode":2622}', 0, 'BC_IPS_2622');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1096, 'IPS-IN_2623',  6, '{"opticalCode":2623}', 0, 'BC_IPS_2623');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1097, 'IPS-IN_2624',  6, '{"opticalCode":2624}', 0, 'BC_IPS_2624');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1098, 'IPS-IN_2625',  6, '{"opticalCode":2625}', 0, 'BC_IPS_2625');
INSERT INTO ism.ism_asset (id, name, mounting_point_type_id, properties, asset_state_id, barcode) VALUES (1099, 'IPS-IN_2626',  6, '{"opticalCode":2626}', 0, 'BC_IPS_2626');