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,contact) VALUES
	 ('tsk2-P1-0586','tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','www.tsk-praha.cz','P1-0586','blue','2023-10-13 06:47:17.196','{"address_country":"Česko","address_formatted":"Na Poříčí, 11000 Praha Nové Město, Česko","address_locality":"Praha","address_region":"Nové Město","postal_code":"11000","street_address":"Na Poříčí"}','SRID=4326;MULTIPOLYGON (((14.435146686704691 50.09031935764648, 14.435158778421304 50.090037674196914, 14.436496591004804 50.090271939573704, 14.436891101497103 50.09057582442722, 14.436584596966501 50.090700574765144, 14.436361060659229 50.09071081877421, 14.435146686704691 50.09031935764648)), ((14.432518050883488 50.08963880488788, 14.432849963583294 50.08974602637074, 14.433520760939317 50.08983654654372, 14.434026273297146 50.08989232808531, 14.433980344589223 50.0900468365997, 14.433568068617168 50.09014494638063, 14.4326828562706 50.08990536564012, 14.432518050883488 50.08963880488788)), ((14.43054520416443 50.089075595822536, 14.431267236152568 50.08895539557057, 14.431701029418882 50.089166218961886, 14.432130432442564 50.089421387255, 14.432518050883488 50.08963880488788, 14.43220935744498 50.089735597324186, 14.432069970660601 50.08973394311176, 14.431747143504648 50.08969881144357, 14.4308507378023 50.08944361428869, 14.43054520416443 50.089075595822536)))',NULL,42,NULL,'2023-10-04 22:05:34.589',NULL,NULL,'2023-10-13 06:47:28.150',NULL,'2023-06-12 02:03:43.000',NULL,'on_street','zone','SRID=4326;POINT (14.433520760939317 50.08983654654372)','{"email":"test@golemio.cz","phone":null,"website":null}');

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,special_access) VALUES
     ('tsk2-P1-0587-002','tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','www.tsk-praha.cz','SRID=4326;POLYGON ((14.430752009766316 50.08911821177594, 14.430769229998441 50.08910172868469, 14.430963092041813 50.089173302203854, 14.431121142940848 50.089229729083705, 14.431288241809778 50.089282708701234, 14.431380867359115 50.089311873860034, 14.4314096437366 50.08932032789265, 14.431440597404489 50.089328628720935, 14.431480187766274 50.0893393542484, 14.431531156892785 50.08935234952796, 14.432034928912303 50.08948101755296, 14.432024626323633 50.08950011783093, 14.431408883289269 50.08933960160983, 14.431288556785107 50.08930381070842, 14.43119927473038 50.089275437868416, 14.430947745128789 50.08918874462976, 14.430752009766316 50.08911821177594))','SRID=4326;POINT (14.431380867359115 50.089311873860034)','{"address_country":"Česko","address_formatted":"Na Poříčí, 11000 Praha Nové Město, Česko","address_locality":"Praha","address_region":"Nové Město","postal_code":"11000","street_address":"Na Poříčí"}',17,NULL,'2023-10-04 09:38:30.821',NULL,NULL,'2023-10-04 09:38:30.821',NULL,NULL),
	 ('tsk2-P1-0586-001','tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','www.tsk-praha.cz','SRID=4326;POLYGON ((14.430752009766316 50.08911821177594, 14.430769229998441 50.08910172868469, 14.430963092041813 50.089173302203854, 14.431121142940848 50.089229729083705, 14.431288241809778 50.089282708701234, 14.431380867359115 50.089311873860034, 14.4314096437366 50.08932032789265, 14.431440597404489 50.089328628720935, 14.431480187766274 50.0893393542484, 14.431531156892785 50.08935234952796, 14.432034928912303 50.08948101755296, 14.432024626323633 50.08950011783093, 14.431408883289269 50.08933960160983, 14.431288556785107 50.08930381070842, 14.43119927473038 50.089275437868416, 14.430947745128789 50.08918874462976, 14.430752009766316 50.08911821177594))','SRID=4326;POINT (14.431380867359115 50.089311873860034)','{"address_country":"Česko","address_formatted":"Na Poříčí, 11000 Praha Nové Město, Česko","address_locality":"Praha","address_region":"Nové Město","postal_code":"11000","street_address":"Na Poříčí"}',16,NULL,'2023-10-04 09:38:30.821',NULL,NULL,'2023-10-04 09:38:30.821',NULL,'{"disabled","designated"}');


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,accepts_litacka,valid_from,valid_to,maximum_duration_seconds,periods_of_time) VALUES
	 ('0639c53f-c555-49ac-b5e0-bb3d50acf588','tsk_v2','2023-10-04 22:09:18.720','pre_paid',NULL,false,NULL,'PO-NE 00-06+08-24',NULL,NULL,true,'czk',1.3333333333333333,'other',0,60,1440,1,NULL,NULL,NULL,NULL,NULL,'2023-10-04 22:09:19.749',NULL,NULL,'2023-10-04 22:09:19.749',NULL,true,'2022-06-21 10:11:00.000','2999-12-31 00:00:00.000',3600,'[{"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Mo"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Tu"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "We"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Th"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Fr"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Sa"}, {"ph": "PH_off", "end": "05:59:00", "start": "00:00:00", "day_in_week": "Su"}]'),
	 ('0639c53f-c555-49ac-b5e0-bb3d50acf588','tsk_v2','2023-10-04 22:09:18.720','pre_paid',NULL,false,NULL,'PO-NE 00-06+08-24',NULL,NULL,true,'czk',1.3333333333333333,'other',1,60,1440,1,NULL,NULL,NULL,NULL,NULL,'2023-10-04 22:09:19.750',NULL,NULL,'2023-10-04 22:09:19.750',NULL,true,'2022-06-21 10:11:15.000','2999-12-31 00:00:00.000',3600,'[{"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Mo"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Tu"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "We"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Th"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Fr"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Sa"}, {"ph": "PH_off", "end": "23:59:00", "start": "08:00:00", "day_in_week": "Su"}]');

INSERT INTO parkings_measurements_part ("source",source_id,parking_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) VALUES
	 ('tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','tsk2-P1-0586',38,NULL,66,104,'2024-01-23 10:02:00.000',NULL,'2023-01-23 10:00:01.951',NULL,NULL,'2023-01-23 10:00:01.951',NULL),
	 ('tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','tsk2-P1-0586',39,NULL,65,104,'2024-01-23 10:03:00.000',NULL,'2023-01-23 09:55:00.760',NULL,NULL,'2023-01-23 09:55:00.760',NULL),
	 ('tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','tsk2-P1-0586',40,NULL,64,104,'2024-01-23 10:04:00.000',NULL,'2023-01-23 09:50:07.824',NULL,NULL,'2023-01-23 09:50:07.824',NULL),
	 ('tsk_v2','c66bb668-eab6-49da-bc84-002263e1dce0','tsk2-P1-0586',40,NULL,64,104,'2024-01-23 11:04:00.000',NULL,'2023-01-23 11:50:07.824',NULL,NULL,'2023-01-23 11:50:07.824',NULL);

INSERT INTO parking_tariffs_relation ("parking_id", "tariff_id", "source", "updated_at", "created_at") VALUES
('tsk2-P1-0586', '0639c53f-c555-49ac-b5e0-bb3d50acf588', 'tsk_v2', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01');
