INSERT INTO parkings (id, source, source_id, data_provider, name, category, date_modified, address, location, area_served, total_spot_number, create_batch_id, created_at, created_by, update_batch_id, updated_at, updated_by, valid_from, valid_to, parking_type, zone_type, centroid) VALUES
('korid-20', 'korid', '20', 'www.korid.cz', 'Husova (u nemocnice)', 'park_and_ride', '2021-02-24T16:30:06.236Z', NULL, 'SRID=4326;POLYGON ((15.062502659291217 50.770489928646725, 15.062502659291217 50.770489928646725, 15.062514877513413 50.770475464787815, 15.062581794635213 50.77049826073106, 15.062649860572028 50.77051945225214, 15.062721314704385 50.77053616989129, 15.062866130284114 50.77056691550288, 15.062858059655783 50.77058240811945, 15.062712703761884 50.77055201164475, 15.062639428783918 50.77053457887742, 15.062570095936087 50.770512962386164, 15.062502659291217 50.770489928646725), (15.063333627169191 50.77068339655547, 15.06334151399964 50.77066874944876, 15.063552868836394 50.77071451523553, 15.063544982051344 50.77072916234581, 15.063333627169191 50.77068339655547), (15.06402203793059 50.77082695501542, 15.064028816089055 50.77081205354126, 15.064389053210448 50.77087794685548, 15.064382275155646 50.770892848349554, 15.06402203793059 50.77082695501542))'::geometry, NULL, 13, NULL, '2020-09-07 14:51:40.308', NULL, NULL, '2021-02-24 17:37:14.372', NULL, NULL, NULL,'on_street', NULL, 'SRID=4326;POINT (15.05929990174349 50.77035456801465)'::geometry),
('korid-21', 'korid', '21', 'www.korid.cz', 'Purkyňova ulice', 'park_and_ride', '2021-02-24T16:30:06.236Z', NULL, 'SRID=4326;POLYGON ((15.073535465794144 50.777867143328834, 15.074364650303988 50.77813579123175, 15.074351908646097 50.77815160179682, 15.073522723931404 50.77788295380698, 15.073535465794144 50.777867143328834), (15.074416914065177 50.77817503753822, 15.074429497702463 50.77815935612828, 15.074877094523854 50.77830375040025, 15.07486451099657 50.77831943185654, 15.074416914065177 50.77817503753822), (15.075650733190733 50.77868651870031, 15.075650733190733 50.77868651870031, 15.075564634987378 50.77861045467845, 15.07554201324507 50.77862087663137, 15.075499118355399 50.77858247914091, 15.075484187776214 50.77858944482163, 15.075439271486093 50.778550497382035, 15.075419840628033 50.77855937822567, 15.07537695602758 50.77852084116626, 15.075367120753475 50.778525311406675, 15.075303564462287 50.778468503035036, 15.075300595898385 50.77846615599911, 15.075300381548084 50.77846626713369, 15.075300234820142 50.77846634207723, 15.075281186802224 50.778474938792975, 15.075239435968914 50.77843771729444, 15.075290246614136 50.77841473660306, 15.075335124012991 50.778454153668214, 15.075354558422568 50.7784452488684, 15.075419494920078 50.77850296000166, 15.075429096512892 50.77849851290845, 15.075472261228347 50.778537033865646, 15.075491718741654 50.77852840732294, 15.075535754974565 50.77856669175267, 15.075550961185778 50.77856003875174, 15.075592711076746 50.778597264182665, 15.075594228650798 50.77859843531407, 15.075616936041953 50.77858819748631, 15.075701590126364 50.778663498184564, 15.075650733190733 50.77868651870031), (15.07560156777543 50.778786780162434, 15.075555472608372 50.77876012088723, 15.075653399037733 50.778692051930335, 15.075699494193103 50.77871871116814, 15.07560156777543 50.778786780162434))'::geometry, NULL, 36, NULL, '2020-09-07 14:51:40.308', NULL, NULL, '2021-02-24 17:37:14.372', NULL, NULL, NULL, 'on_street', NULL, 'SRID=4326;POINT (15.05929990174349 50.77035456801465)'::geometry),
('korid-22', 'korid', '22', 'www.korid.cz', '1. máje', 'park_and_ride', '2021-02-24T16:30:06.236Z', NULL, 'SRID=4326;POLYGON ((15.048722595067447 50.7628457146645, 15.048722595067447 50.7628457146645, 15.048716367962248 50.762775507841255, 15.048714333981806 50.76275172992911, 15.048708229671679 50.7627273495386, 15.048702773889246 50.76270523464775, 15.04868944177133 50.762682678960275, 15.04867244079242 50.76266133636074, 15.04865023927992 50.76264190854471, 15.048649402627722 50.76264118626388, 15.048623574726843 50.762625199920016, 15.048596683892479 50.76261077980552, 15.04859384730661 50.76260985825769, 15.048561836071121 50.76259896923075, 15.0485601909124 50.76259868552474, 15.048489675092718 50.76258643560388, 15.048453440099811 50.76258008299823, 15.048471025844593 50.76253882873844, 15.048578026434075 50.76255720127448, 15.048594207710732 50.76256107058631, 15.048625684902126 50.76257199494989, 15.04866886409942 50.76259326854139, 15.048696211394889 50.76260996068015, 15.048704793973265 50.76261659348581, 15.048726266686511 50.76263471221044, 15.048732389247313 50.76264098464028, 15.048748953217547 50.762661821774046, 15.048752747631736 50.762666098660354, 15.048767166826684 50.76268976425888, 15.048768226638888 50.762692496329485, 15.048782164668745 50.76274633176619, 15.048789999980308 50.76284334276083, 15.048722595067447 50.7628457146645), (15.049380440528726 50.76344758984489, 15.048898232808483 50.763099770866226, 15.048918567269727 50.763088430051425, 15.04940077503638 50.76343624894975, 15.049380440528726 50.76344758984489), (15.050030797711324 50.76391444180497, 15.049437157489526 50.76348812537081, 15.049457464142574 50.76347675036433, 15.050051104402723 50.76390306669833, 15.050030797711324 50.76391444180497), (15.049543289349549 50.76375586697499, 15.04895132968074 50.76333211903317, 15.048971598131555 50.76332072886077, 15.049563557837509 50.76374447670289, 15.049543289349549 50.76375586697499), (15.049969473187774 50.764062225545175, 15.049647751202544 50.76383206153527, 15.049668054031324 50.76382064542361, 15.049989776036675 50.76405080937923, 15.049969473187774 50.764062225545175), (15.051079857038813 50.76466958394885, 15.050704013715515 50.76440055939813, 15.050724440719415 50.76438907978244, 15.05110028407871 50.76465810427945, 15.051079857038813 50.76466958394885))'::geometry, NULL, 59, NULL, '2020-09-07 14:51:40.308', NULL, NULL, '2021-02-24 17:37:14.373', NULL, NULL, NULL, 'on_street', NULL, 'SRID=4326;POINT (15.05929990174349 50.77035456801465)'::geometry),
('korid-54', 'korid', '54', 'www.korid.cz', 'Masarykova ulice', 'park_paid_private', '2021-02-24T16:30:06.236Z', NULL, 'SRID=4326;POLYGON ((15.074568223409903 50.77590827454969, 15.074585370561389 50.77586811775529, 15.074947701396539 50.775930320848644, 15.07493055452721 50.7759704777025, 15.074568223409903 50.77590827454969))'::geometry, NULL, 10, NULL, '2020-09-07 14:51:40.308', NULL, NULL, '2021-02-24 17:37:14.383', NULL, NULL, NULL, 'on_street', NULL, 'SRID=4326;POINT (15.05929990174349 50.77035456801465)'::geometry),
('korid-66', 'korid', '66', 'www.korid.cz', 'Bedřichov Maliník', 'park_paid_private', '2021-02-24T16:30:06.236Z', NULL, 'SRID=4326;POLYGON ((15.12984438981548 50.79081757392241, 15.12984438981548 50.79081757392241, 15.13037179413462 50.790730250342165, 15.130753864365996 50.79092958629554, 15.130713357525435 50.791100395437105, 15.130553614214087 50.79105491924561, 15.13047129608269 50.791119029561514, 15.12984438981548 50.79081757392241))'::geometry, NULL, 150, NULL, '2020-09-07 14:51:40.309', NULL, NULL, '2021-02-24 17:37:14.383', NULL, NULL, NULL, 'on_street', NULL, 'SRID=4326;POINT (15.05929990174349 50.77035456801465)'::geometry),
('tsk-p10-0101', 'tsk', 'P10-0101', 'www.tsk-praha.cz/opendata.iprpraha.cz', 'Vršovická', 'zone_mixed', NULL, NULL, 'SRID=4326;MULTIPOLYGON(((14.442026998000074 50.06601274800005,14.442419875000041 50.06614420200003,14.442591187000062 50.06619752600005,14.442808352000043 50.066260947000046,14.442850540000052 50.06627157200006,14.442861204000053 50.06627366200007,14.442861340000036 50.06627368800008,14.442865644000051 50.06626524500007,14.442870553000034 50.06625561700008,14.442858070000057 50.066253062000044,14.442822584000055 50.06624306500004,14.442603739000049 50.06618012200005,14.442432840000038 50.06612731600006,14.442041462000077 50.06599543900006,14.442026998000074 50.06601274800005)),((14.442957874000058 50.066294001000074,14.443108320000022 50.066323381000075,14.443235403000074 50.06634590400006,14.44334182800003 50.06635943900005,14.44340083000003 50.066364219000036,14.443499923000047 50.06637041700003,14.44373672000006 50.06637909300008,14.443896228000028 50.06638351700008,14.443977411000049 50.066381679000074,14.444057027000042 50.066378514000064,14.444135120000055 50.06637377200008,14.444216630000028 50.066366954000046,14.444371433000072 50.06635020500005,14.444604102000028 50.066319399000065,14.444930623000062 50.06627467900006,14.445063594000032 50.066256371000065,14.445058759000062 50.06623613200003,14.444923410000058 50.06625482000004,14.444599407000055 50.06629989900006,14.44436481100007 50.06633101400007,14.444210644000066 50.06634829200004,14.44413343900004 50.06635573600005,14.444053998000072 50.06635986900005,14.44397478600007 50.066362842000046,14.443897136000032 50.06636379400004,14.443819198000028 50.06636258700007,14.443739550000032 50.06636073800007,14.443582152000033 50.06635507800007,14.44350187300006 50.06635103200006,14.443404135000037 50.066345424000076,14.443346720000022 50.06634007700006,14.443241561000036 50.06632760700006,14.443117486000062 50.06630487900003,14.442966530000035 50.066276162000065,14.442870437000067 50.06625616000008,14.442865644000051 50.06626524500007,14.442861204000053 50.06627366200007,14.442861064000056 50.066273928000044,14.442957874000058 50.066294001000074)),((14.442023651000056 50.06601310500008,14.442038317000026 50.06599511500008,14.441514275000031 50.06581806600008,14.441501448000054 50.06583139900005,14.442023651000056 50.06601310500008)))'::geometry, NULL, 49, NULL, '2022-05-26 22:32:48.384+00', NULL, NULL, '2022-05-26 22:32:48.384+00', NULL, '2020-06-26 20:47:07.213+00', '2999-12-31 22:59:59.999+00', 'on_street', 'zone_mixed', 'SRID=4326;POINT(14.443355698017905 50.066266757446506)'::geometry),
('tsk-p7-9080', 'tsk', 'P7-9080', 'www.tsk-praha.cz', NULL, 'zone_other', NULL, NULL, 'SRID=4326;POLYGON((14.4331297 50.0968683,14.4336875 50.0975736,14.4348569 50.0972503,14.4331297 50.0968683))'::geometry, NULL, 0, NULL, '2022-05-06 04:01:03.981+02', NULL, NULL, '2022-05-26 04:01:22.951+02', NULL, '2018-08-01 02:00:00+02', '2999-12-31 01:00:00+01', 'on_street', 'zone_other', 'SRID=4326;POINT(14.433891388888866 50.09723073333333)'::geometry),
('korid-888','korid','62992d91-6048-4c5e-b94f-be796056b88e','www.mrparkit.com','Brno - Centrum Vídeňská ',NULL,'2024-07-03 15:00:01.157+02','{"address_country":"Česko","address_formatted":"Strážní 639 00, Brno"}','SRID=4326;POINT (16.599509 49.1759116)',NULL,NULL,NULL,'2023-11-21 11:38:10.829+01',NULL,NULL,'2024-07-03 15:00:01.307+02',NULL,NULL,'2023-11-21 11:38:10.75+01','underground',NULL,'SRID=4326;POINT (16.599509 49.1759116)');

INSERT INTO parkings_location (id, source, source_id, data_provider, location, centroid, address, total_spot_number, create_batch_id, created_at, created_by, update_batch_id, updated_at, updated_by) VALUES
('16424', 'tsk', 'P10-0101', 'www.tsk-praha.cz/opendata.iprpraha.cz', 'SRID=4326;MULTIPOLYGON(((14.442026998000074 50.06601274800005,14.442419875000041 50.06614420200003,14.442591187000062 50.06619752600005,14.442808352000043 50.066260947000046,14.442850540000052 50.06627157200006,14.442861204000053 50.06627366200007,14.442861340000036 50.06627368800008,14.442865644000051 50.06626524500007,14.442870553000034 50.06625561700008,14.442858070000057 50.066253062000044,14.442822584000055 50.06624306500004,14.442603739000049 50.06618012200005,14.442432840000038 50.06612731600006,14.442041462000077 50.06599543900006,14.442026998000074 50.06601274800005)),((14.442957874000058 50.066294001000074,14.443108320000022 50.066323381000075,14.443235403000074 50.06634590400006,14.44334182800003 50.06635943900005,14.44340083000003 50.066364219000036,14.443499923000047 50.06637041700003,14.44373672000006 50.06637909300008,14.443896228000028 50.06638351700008,14.443977411000049 50.066381679000074,14.444057027000042 50.066378514000064,14.444135120000055 50.06637377200008,14.444216630000028 50.066366954000046,14.444371433000072 50.06635020500005,14.444604102000028 50.066319399000065,14.444930623000062 50.06627467900006,14.445063594000032 50.066256371000065,14.445058759000062 50.06623613200003,14.444923410000058 50.06625482000004,14.444599407000055 50.06629989900006,14.44436481100007 50.06633101400007,14.444210644000066 50.06634829200004,14.44413343900004 50.06635573600005,14.444053998000072 50.06635986900005,14.44397478600007 50.066362842000046,14.443897136000032 50.06636379400004,14.443819198000028 50.06636258700007,14.443739550000032 50.06636073800007,14.443582152000033 50.06635507800007,14.44350187300006 50.06635103200006,14.443404135000037 50.066345424000076,14.443346720000022 50.06634007700006,14.443241561000036 50.06632760700006,14.443117486000062 50.06630487900003,14.442966530000035 50.066276162000065,14.442870437000067 50.06625616000008,14.442865644000051 50.06626524500007,14.442861204000053 50.06627366200007,14.442861064000056 50.066273928000044,14.442957874000058 50.066294001000074)),((14.442023651000056 50.06601310500008,14.442038317000026 50.06599511500008,14.441514275000031 50.06581806600008,14.441501448000054 50.06583139900005,14.442023651000056 50.06601310500008)))'::geometry, 'SRID=4326;POINT(14.443355698017905 50.066266757446506)'::geometry, '{"address_country":"Česko","address_formatted":"Ctiradova, 14000 Hlavní město Praha Nusle, Česko","address_locality":"Hlavní město Praha","address_region":"Nusle","postal_code":"14000","street_address":"Ctiradova"}', 49, NULL, '2022-05-26 22:33:14.697+00', NULL, NULL, '2022-05-26 22:33:14.697+00', NULL),
('16425', 'tsk', 'P10-0101', 'www.tsk-praha.cz/opendata.iprpraha.cz', 'SRID=4326;POLYGON((14.441543061000061 50.06605791000004,14.442488516000026 50.066376425000044,14.442502339000043 50.06635842400004,14.441556896000066 50.066039911000075,14.441543061000061 50.06605791000004))'::geometry, 'SRID=4326;POINT(14.442022703000049 50.06620816750005)'::geometry, '{"address_country":"Česko","address_formatted":"Vršovická, 10100 Praha Vršovice, Česko","address_locality":"Praha","address_region":"Vršovice","postal_code":"10100","street_address":"Vršovická"}', 49, NULL, '2022-05-26 22:33:14.697+00', NULL, NULL, '2022-05-26 22:33:14.697+00', NULL),
('16538', 'tsk', 'P10-0101', 'www.tsk-praha.cz/opendata.iprpraha.cz', 'SRID=4326;POLYGON((14.443050203000041 50.066508577000036,14.443199064000055 50.06653251600005,14.443352251000022 50.066549122000026,14.44350632100003 50.06656165100003,14.443659835000062 50.06656820300003,14.443815381000036 50.06656958900004,14.443970110000066 50.06656614800005,14.444124294000062 50.06655673200004,14.444233001000043 50.06654859500003,14.44435628900004 50.066537021000045,14.444516614000065 50.06652043200006,14.444812564000074 50.066482077000046,14.444887301000051 50.06647329800006,14.444883945000072 50.066454597000075,14.444654832000026 50.06648227800008,14.444506268000055 50.06649992400003,14.44422693100006 50.06652965500007,14.443967888000049 50.06654752700007,14.443815760000064 50.06655062800007,14.443661376000023 50.06654815500008,14.44350773900004 50.06654219100005,14.443356392000055 50.06652990300006,14.443201378000026 50.066513136000026,14.443054997000047 50.06649060500007,14.443050203000041 50.066508577000036))'::geometry, 'SRID=4326;POINT(14.443930021333381 50.06652760888672)'::geometry, '{"address_country":"Česko","address_formatted":"Ctiradova, 14000 Hlavní město Praha Nusle, Česko","address_locality":"Hlavní město Praha","address_region":"Nusle","postal_code":"14000","street_address":"Ctiradova"}', 49, NULL, '2022-05-26 22:33:14.697+00', NULL, NULL, '2022-05-26 22:33:14.697+00', NULL),
('c770a9e3-d49e-597e-90db-cb3d23d06b3d', 'tsk', 'P7-9080', 'www.tsk-praha.cz', 'SRID=4326;POLYGON((14.4331297 50.0968683,14.4336875 50.0975736,14.4348569 50.0972503,14.4331297 50.0968683))'::geometry, 'SRID=4326;POINT(14.433891388888866 50.09723073333333)'::geometry, '{"address_country":"Česko","address_formatted":"nábřeží Kapitána Jaroše, 17000 Hlavní město Praha Holešovice, Česko","address_locality":"Hlavní město Praha","address_region":"Holešovice","postal_code":"17000","street_address":"nábřeží Kapitána Jaroše"}', 0, NULL, '2022-05-26 22:33:14.925+00', NULL, NULL, '2022-05-26 22:33:14.925+00', NULL),
('korid-888','korid','62992d91-6048-4c5e-b94f-be796056b88e','www.mrparkit.com','SRID=4326;POINT (16.599509 49.1759116)','SRID=4326;POINT (16.599509 49.1759116)','{"address_country":"Česko","address_formatted":"Strážní 639 00, Brno"}',NULL,NULL,'2023-11-20 12:09:54.153+01',NULL,NULL,'2024-07-04 13:00:00.875+02',NULL);

INSERT INTO parkings_measurements_part (source, source_id, available_spot_number, closed_spot_number, occupied_spot_number, total_spot_number, date_modified, create_batch_id, created_at, created_by, update_batch_id, updated_at, updated_by, parking_id) VALUES
('korid', '20', 5, 0, 8, 13, '2021-02-26T12:04:46.191Z', NULL, '2021-02-26 13:05:31.484', NULL, NULL, '2021-02-26 13:05:31.484', NULL, 'korid-20'),
('korid', '20', 5, 0, 8, 13, '2021-02-26T12:03:46.189Z', NULL, '2021-02-26 13:03:51.495', NULL, NULL, '2021-02-26 13:03:51.495', NULL, 'korid-20'),
('korid', '20', 5, 0, 8, 13, '2021-02-26T12:02:46.188Z', NULL, '2021-02-26 13:02:51.533', NULL, NULL, '2021-02-26 13:02:51.533', NULL, 'korid-20'),
('korid', '20', 4, 0, 9, 13, '2021-02-26T12:01:46.188Z', NULL, '2021-02-26 13:02:29.160', NULL, NULL, '2021-02-26 13:02:29.160', NULL, 'korid-20'),
('korid', '20', 5, 0, 8, 13, '2021-02-26T12:00:46.187Z', NULL, '2021-02-26 13:00:48.690', NULL, NULL, '2021-02-26 13:00:48.690', NULL, 'korid-20'),
('korid', '22', 5, 0, 8, 13, '2021-02-26T11:58:42.311Z', NULL, '2021-02-26 13:00:48.690', NULL, NULL, '2021-02-26 12:00:00.000', NULL, 'korid-20'),
('korid','888',1,0,0,1,'2023-11-20 12:15:04.966+01',NULL,'2023-11-20 12:15:04.971+01',NULL,NULL,'2023-11-20 12:15:04.971+01',NULL,'korid-888'),
('korid', '38', 14, 0, 18, 32, '2022-07-01T09:38:17.911Z', NULL, '2022-07-01 11:38:18.154+02', NULL, NULL, NOW() - INTERVAL '10 minutes', NULL, 'korid-38');

INSERT INTO parkings_measurements_actual ("source", source_id, available_spot_number, closed_spot_number, occupied_spot_number, total_spot_number, date_modified, create_batch_id, created_at, created_by, update_batch_id, updated_at, updated_by, parking_id) VALUES
('korid', '54', 4, 0, 9, 13, '2021-02-28T23:19:47.384Z', NULL, '2022-04-21 08:56:23.362', NULL, NULL, '2022-04-21 10:23:53.817', NULL, 'korid-54'),
('korid', '21', 6, 0, 12, 18, '2021-02-26T11:58:42.311Z', NULL, '2022-04-21 08:56:23.362', NULL, NULL, '2022-04-21 10:23:53.817', NULL, 'korid-21'),
('korid', '52', 20, 0, 82, 102, '2022-07-27T10:37:06.563Z', NULL, '2022-07-01 11:38:18.205+02',	NULL, NULL, NOW() - INTERVAL '10 minutes', NULL, 'korid-52');

INSERT INTO parkings_tariffs (tariff_id, source, last_updated, payment_mode, payment_additional_description, free_of_charge, url_link_address, charge_band_name, accepts_payment_card, accepts_cash, accepts_mobile_payment, charge_currency, charge, charge_type, charge_order_index, charge_interval, max_iterations_of_charge, min_iterations_of_charge, start_time_of_period, end_time_of_period, allowed_vehicle_type, allowed_fuel_type, create_batch_id, created_at, created_by, update_batch_id, updated_at, updated_by) VALUES
('b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'A', true, true, NULL, 'CZK', 20, 'minimum', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.355', NULL, NULL, '2021-03-08 18:31:37.355', NULL),
('b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'A', true, true, NULL, 'CZK', 20, NULL, 1, 1800, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.355', NULL, NULL, '2021-03-08 18:31:37.355', NULL),
('b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'A', true, true, NULL, 'CZK', 40, NULL, 2, 3600, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.355', NULL, NULL, '2021-03-08 18:31:37.355', NULL),
('b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'A', true, true, NULL, 'CZK', 50, NULL, 3, 3600, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.356', NULL, NULL, '2021-03-08 18:31:37.356', NULL),
('f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'B', true, true, NULL, 'CZK', 15, 'minimum', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.356', NULL, NULL, '2021-03-08 18:31:37.356', NULL),
('f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2020-10-12 15:19:21.000', '', 'Parkování Liberec', false, 'https://parking.liberec.cz/', 'B', true, true, NULL, 'CZK', 15, NULL, 1, 1800, 1, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.356', NULL, NULL, '2021-03-08 18:31:37.356', NULL),
('a5de46c9-4f7i-ad22-81a6-4ca56aa7cb66', 'dirok', '2020-10-12 15:19:21.000', '', 'Parkování Prerov', false, 'https://parking.prerov.cz/', 'C', true, true, NULL, 'CZK', 30, NULL, 0, 3600, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2021-03-08 18:31:37.356', NULL, NULL, '2021-03-08 18:31:37.356', NULL);

INSERT INTO parking_tariffs_relation ("parking_id", "tariff_id", "source", "updated_at", "created_at") VALUES
('korid-20', 'b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-22', 'f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('tsk-p10-0101', 'bfcfc515-369f-5093-b779-7091c520edd3', 'tsk', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('tsk-p7-9080', '87ca4ca0-efbf-55d7-9091-7e5e4c99ff8b', 'tsk', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01');

INSERT INTO parking_sources("source", open_data, api_v3_allowed, contact, legacy_api_allowed, datasource_parking, datasource_locations, datasource_payments, payment, reservation, datasource_entrances, datasource_prohibitions, "name", datasource_tariffs) VALUES
('isphk', true, true, '{"email": "zadosti@isphk.cz", "phone": "800 101 039", "web_url": "https://www.isphk.cz/", "term_of_use_url": null}'::jsonb, false, 'http://parking.example.com', 'http://parking_locations.example.com', NULL, NULL, '{"type": "not_possible", "ios_url": null, "web_url": null, "android_url": null, "discovery_url": null}'::jsonb, 'http://parking_entrances.example.com', NULL, 'Integrovaný systém parkování Hradec Králové', 'http://parking_tariffs.example.com'),
('pmdp', true, true, '{"email": "parking@pmdp.cz", "phone": "+420 378 035 420", "web_url": "https://www.parkingplzen.cz/", "term_of_use_url": null}'::jsonb, false, 'http://parking.example.com', 'http://parking_locations.example.com', NULL, NULL, '{"type": "not_possible", "ios_url": null, "web_url": null, "android_url": null, "discovery_url": null}'::jsonb, 'http://parking_entrances.example.com', NULL, NULL, NULL),
('test_cases', false, true, NULL, false, 'http://parking.example.com', 'http://parking_locations.example.com', NULL, NULL, NULL, 'http://parking_entrances.example.com', NULL, NULL, 'http://parking_tariffs.example.com'),
('ipr', false, false, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Institut plánování a rozvoje hlavního města Prahy', NULL),
('tsk', false, false, '{"email": "parking@tsk-praha.cz", "phone": "+420 257 015 257", "web_url": "https://parking.praha.eu/", "term_of_use_url": "https://parking.praha.eu/cs/moznosti-parkovani-v-praze/parkovani-v-zonach/"}'::jsonb, true, NULL, NULL, NULL, '{"ios_url": null, "web_url": "", "android_url": null, "discovery_url": null}'::jsonb, NULL, NULL, NULL, 'Technická správa komunikací hl. m. Prahy', NULL),
('manual', false, false, NULL, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('osm', false, true, NULL, false, NULL, NULL, 'http://parking_payments.example.com', NULL, NULL, NULL, NULL, NULL, NULL),
('korid', true, true, '{"email": "pomoc@parking.liberec.cz", "phone": "+420604295403", "web_url": "https://parking.liberec.cz/", "term_of_use_url": "https://www.liberec.cz/cz/prakticke-informace/doprava-udrzba-komunikaci/parkovaci-mista/parkovaci-mista.html"}'::jsonb, true, NULL, NULL, NULL, '{"ios_url": null, "web_url": "https://ke-utc.appspot.com/static/onstreet.html?shortname=LB{source_id}", "android_url": null, "discovery_url": null}'::jsonb, '{"type": "not_possible", "ios_url": null, "web_url": null, "android_url": null, "discovery_url": null}'::jsonb, NULL, NULL, NULL, NULL),
('mr_parkit', true, true, '{"email": "info@mrparkit.com", "phone": "+420 277 277 977", "web_url": "https://www.mrparkit.com/", "term_of_use_url": "https://www.mrparkit.com/cs/pravni-dokumenty"}'::jsonb, false, NULL, NULL, NULL, NULL, '{"type": "required", "ios_url": null, "web_url": "https://www.mrparkit.com/", "android_url": null, "discovery_url": null}'::jsonb, NULL, NULL, NULL, NULL),
('smart4city', true, true, '{"email": "info@smart4city.cz", "phone": "+420 602 467 614", "web_url": "https://www.smart4city.cz/", "term_of_use_url": ""}'::jsonb, false, NULL, NULL, NULL, '{"ios_url": "https://apps.apple.com/cz/app/smart4city-parkov%C3%A1n%C3%AD/id1173793287?l=cs?l=cs", "web_url": null, "android_url": "https://play.google.com/store/apps/details?id=com.spel.smart4city2", "discovery_url": null}'::jsonb, '{"type": "not_possible", "ios_url": null, "web_url": null, "android_url": null, "discovery_url": null}'::jsonb, NULL, NULL, NULL, NULL),
('tsk_v2', false, true, '{"email": "parking@tsk-praha.cz", "phone": "+420 257 015 257", "web_url": "https://parking.praha.eu/", "term_of_use_url": "https://parking.praha.eu/cs/moznosti-parkovani-v-praze/parkovani-v-zonach/"}'::jsonb, false, NULL, NULL, NULL, '{"ios_url": null, "web_url": "https://ke-utc.appspot.com/static/onstreet.html?shortname={name}", "android_url": null, "discovery_url": null}'::jsonb, '{"type": "not_possible", "ios_url": null, "web_url": null, "android_url": null, "discovery_url": null}'::jsonb, NULL, NULL, 'Technická správa komunikací hl. m. Prahy', NULL);

INSERT INTO parking_sources ("source",open_data,api_v3_allowed,contact,legacy_api_allowed,datasource_parking,datasource_locations,datasource_payments,payment,reservation,datasource_entrances,datasource_prohibitions,name,datasource_tariffs,datasource_parking_machines) VALUES	 
	 ('tsk-offstreet',false,true,NULL,false,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'http://parking_machines.example.com');
