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,"security",max_vehicle_dimensions,covered,contact,parking_policy) VALUES
('korid-14','korid','14','www.korid.cz','Malé náměstí',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město"}','SRID=4326;POLYGON ((15.053439170357379 50.77104482114524, 15.053379667585952 50.77094623213365, 15.053425805276998 50.770935033554004, 15.05348530812957 50.771033622542525, 15.053439170357379 50.77104482114524), (15.053544680707958 50.77086078148896, 15.053562355367628 50.770888897718194, 15.05346832918751 50.77091266837908, 15.053450654574307 50.77088455213589, 15.053544680707958 50.77086078148896), (15.0536401473132 50.77100219978372, 15.053588490767279 50.77091559114939, 15.053633139601354 50.77090488154687, 15.053684796216542 50.77099149016182, 15.0536401473132 50.77100219978372))',NULL,12,NULL,'2022-07-01 11:38:18.299+02',NULL,NULL,'2024-05-15 11:53:14.32+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.053525212090472 50.77094339764494)',NULL,NULL,NULL,NULL,NULL),
('korid-13','korid','13','www.korid.cz','Vavřincův vrch',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Frýdlantská, 46001 Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město","postal_code":"46001","street_address":"Frýdlantská"}','SRID=4326;POLYGON ((15.05642058405908 50.77131768219866, 15.05637870344338 50.77130080948661, 15.056563308905925 50.77111654103068, 15.056605189437999 50.77113341368007, 15.05642058405908 50.77131768219866), (15.05650235221235 50.77134661958896, 15.056628805510625 50.77122114814301, 15.056671534504963 50.77123846560502, 15.056545081274015 50.77136393709557, 15.05650235221235 50.77134661958896), (15.05655709045048 50.77137042511884, 15.05668354366678 50.7712449536158, 15.056726272700448 50.77126227106664, 15.056599819539224 50.77138774260418, 15.05655709045048 50.77137042511884))',NULL,24,NULL,'2022-07-01 11:38:18.299+02',NULL,NULL,'2024-05-15 11:53:14.316+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.056573523808773 50.77127533410283)',NULL,NULL,NULL,NULL,NULL),
('korid-12','korid','12','www.korid.cz','Tržní náměstí',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město"}','SRID=4326;POLYGON ((15.060614001012526 50.774037111853104, 15.06064608401181 50.773998960319304, 15.060777723275763 50.77404347169889, 15.060745640366582 50.77408162326862, 15.060614001012526 50.774037111853104), (15.060825093720137 50.77410910379276, 15.060856883694626 50.77407084931751, 15.061287830257728 50.774214845230944, 15.061256040535147 50.77425309981896, 15.060825093720137 50.77410910379276), (15.061491025510193 50.77357988894232, 15.061491025510193 50.77357988894232, 15.061532940744167 50.7736139336781, 15.061275723810827 50.773742595050884, 15.061219065681994 50.77377114809984, 15.061191904132578 50.77378708959841, 15.061166451617256 50.77380382369288, 15.061143955967603 50.77382215012455, 15.06112382406758 50.77384162645634, 15.06110630666643 50.77386190573617, 15.061091518748531 50.77388167545503, 15.061079926265844 50.77390143940596, 15.061071477300931 50.77392141332186, 15.061067420760494 50.773941044836256, 15.061072656500885 50.77396126465787, 15.061084567855493 50.77398118185215, 15.061101714957717 50.77400054872549, 15.06111786028717 50.7740169664764, 15.061143796242181 50.774034901892044, 15.061170104584733 50.77404922171951, 15.061195961878152 50.77405987731509, 15.061555662921755 50.77417888211165, 15.061524813186015 50.774217343309765, 15.061201537670943 50.77411078783505, 15.061163132404937 50.77409801676134, 15.061134001945414 50.77408634375971, 15.061095258440563 50.77406593760653, 15.06106941570551 50.77404872363064, 15.061046189569947 50.774027630590425, 15.06102478734465 50.774003614091214, 15.061008826608123 50.77397800901882, 15.060998525597414 50.77394326661424, 15.061001267452813 50.773919014436196, 15.061013043591844 50.77389090309221, 15.06102717175527 50.77386706771602, 15.06104346011586 50.773843554863795, 15.06106455183295 50.773819594377, 15.061086990134262 50.77379785818935, 15.061114861656241 50.77377518839987, 15.061143526080029 50.7737564153157, 15.061171051323626 50.77374041017785, 15.061491025510193 50.77357988894232), (15.06115277049626 50.773620588090346, 15.061357200644345 50.77351776061964, 15.061399424669252 50.77355151542847, 15.061194994468618 50.773654342970964, 15.06115277049626 50.773620588090346))',NULL,63,NULL,'2022-07-01 11:38:18.298+02',NULL,NULL,'2024-05-15 11:53:14.2+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.061123414935514 50.77391463057144)',NULL,NULL,NULL,NULL,NULL),
('korid-10','korid','10','www.korid.cz','Na Perštýně',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Na Perštýně, 46001 Liberec Perštýn, Česko","address_locality":"Liberec","address_region":"Perštýn","postal_code":"46001","street_address":"Na Perštýně"}','SRID=4326;POLYGON ((15.058477079866359 50.764621453945274, 15.058514693959768 50.76462152563487, 15.058554180179613 50.764621900783574, 15.058626283309321 50.7646226347964, 15.058701346853194 50.76462159520064, 15.058776737298384 50.764618026799006, 15.058812775811438 50.76461469133624, 15.058822912718657 50.76465695203623, 15.058783838664894 50.76466082677318, 15.058743117269795 50.76466323629539, 15.058704375227238 50.76466458542137, 15.05866541610514 50.76466515003736, 15.058626559240858 50.76466567766573, 15.058587617997263 50.76466539596825, 15.058513079923348 50.764664631419066, 15.05847584612631 50.76466436351429, 15.058477079866359 50.764621453945274, 15.058477079866359 50.764621453945274))',NULL,9,NULL,'2022-07-01 11:38:18.298+02',NULL,NULL,'2024-05-15 11:53:14.203+02',NULL,NULL,NULL,'on_street',NULL,'SRID=4326;POINT (15.058638996495171 50.76464318244542)',NULL,NULL,NULL,NULL,NULL),
('korid-11','korid','11','www.korid.cz','Barvířská ulice',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Barvířská, 46007 Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město","postal_code":"46007","street_address":"Barvířská"}','SRID=4326;POLYGON ((15.052827174737011 50.76818395182747, 15.052813548512615 50.7681706290976, 15.053127496504548 50.768041481511716, 15.05314112278105 50.768054804197, 15.052827174737011 50.76818395182747), (15.0528545879386 50.768076271285096, 15.05284110025192 50.76806319783926, 15.0531566938284 50.767932242359606, 15.053170181564045 50.767945315769964, 15.0528545879386 50.768076271285096), (15.053360720512773 50.767780974705744, 15.053495511267823 50.76773862181574, 15.053527002654162 50.76777893267549, 15.05339221181179 50.76782128560994, 15.053360720512773 50.767780974705744), (15.053538273230366 50.76772611117662, 15.053679212198562 50.767682341076366, 15.053710454119498 50.76772280290865, 15.053569515060877 50.76776657304574, 15.053538273230366 50.76772611117662), (15.053691489914229 50.76767948261975, 15.054097311586956 50.767554098834076, 15.054109826586958 50.76757039102556, 15.053704004809042 50.767695774853735, 15.053691489914229 50.76767948261975))',NULL,23,NULL,'2022-07-01 11:38:18.298+02',NULL,NULL,'2024-05-15 11:53:14.189+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.053390371993563 50.76784926421176)',NULL,NULL,NULL,NULL,NULL),
('korid-1','korid','1','www.korid.cz','nám. Dr.E.Beneše (Pošta)',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"nám. Dr. E. Beneše, 46001 Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město","postal_code":"46001","street_address":"nám. Dr. E. Beneše"}','SRID=4326;POLYGON ((15.059402713027369 50.77050569727233, 15.059152281669425 50.7702191902531, 15.059197090359975 50.770203438803286, 15.059447521917193 50.77048994572991, 15.059402713027369 50.77050569727233))',NULL,24,NULL,'2022-07-01 11:38:18.298+02',NULL,NULL,'2024-05-15 11:53:13.958+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.05929990174349 50.77035456801465)',NULL,NULL,NULL,NULL,NULL),
('korid-16','korid','16','www.korid.cz','Papírová ulice',NULL,'2024-05-15 11:53:12.43+02','{"address_country":"Česko","address_formatted":"Bednářská, 46001 Liberec Staré Město, Česko","address_locality":"Liberec","address_region":"Staré Město","postal_code":"46001","street_address":"Bednářská"}','SRID=4326;POLYGON ((15.05460215639034 50.76831686455292, 15.054778108824609 50.76827621498907, 15.054801398283878 50.768316760767966, 15.054625445734311 50.76835741036742, 15.05460215639034 50.76831686455292), (15.055025205881027 50.76835711307601, 15.055043081062772 50.768315347731786, 15.055440674880355 50.768383784379935, 15.055422800008474 50.76842554978086, 15.055025205881027 50.76835711307601), (15.055117032704732 50.76832417306977, 15.05513472865224 50.768282712238154, 15.05542327292743 50.768332241817845, 15.055405577211578 50.76837370269995, 15.055117032704732 50.76832417306977), (15.055507634795866 50.76830051924529, 15.055481502312903 50.768305122089195, 15.055417122627883 50.76815810840171, 15.055443255052502 50.76815350556426, 15.055507634795866 50.76830051924529), (15.054674623382972 50.76844698607595, 15.054674028292549 50.76840389729273, 15.054823104498281 50.76840306806651, 15.054823699723547 50.76844615684853, 15.054674623382972 50.76844698607595), (15.054751339591144 50.768526052273614, 15.054750531240463 50.768455517998724, 15.054818095506002 50.768455206076496, 15.05481890395854 50.76852574034169, 15.054751339591144 50.768526052273614), (15.054758929648006 50.76885589943716, 15.054755161765824 50.76856948287865, 15.054826914058388 50.76856910270115, 15.054830682370188 50.768855519264875, 15.054758929648006 50.76885589943716))',NULL,31,NULL,'2022-07-01 11:38:18.299+02',NULL,NULL,'2024-05-15 11:53:14.312+02',NULL,NULL,NULL,'other',NULL,'SRID=4326;POINT (15.05499910754953 50.76841042000099)',NULL,NULL,NULL,NULL,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
('korid-14','korid','14','www.korid.cz','SRID=4326;POLYGON ((15.053439170357379 50.77104482114524, 15.053379667585952 50.77094623213365, 15.053425805276998 50.770935033554004, 15.05348530812957 50.771033622542525, 15.053439170357379 50.77104482114524), (15.053544680707958 50.77086078148896, 15.053562355367628 50.770888897718194, 15.05346832918751 50.77091266837908, 15.053450654574307 50.77088455213589, 15.053544680707958 50.77086078148896), (15.0536401473132 50.77100219978372, 15.053588490767279 50.77091559114939, 15.053633139601354 50.77090488154687, 15.053684796216542 50.77099149016182, 15.0536401473132 50.77100219978372))','SRID=4326;POINT (15.053525212090472 50.77094339764494)',NULL,12,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-13','korid','13','www.korid.cz','SRID=4326;POLYGON ((15.05642058405908 50.77131768219866, 15.05637870344338 50.77130080948661, 15.056563308905925 50.77111654103068, 15.056605189437999 50.77113341368007, 15.05642058405908 50.77131768219866), (15.05650235221235 50.77134661958896, 15.056628805510625 50.77122114814301, 15.056671534504963 50.77123846560502, 15.056545081274015 50.77136393709557, 15.05650235221235 50.77134661958896), (15.05655709045048 50.77137042511884, 15.05668354366678 50.7712449536158, 15.056726272700448 50.77126227106664, 15.056599819539224 50.77138774260418, 15.05655709045048 50.77137042511884))','SRID=4326;POINT (15.056573523808773 50.77127533410283)',NULL,24,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-12','korid','12','www.korid.cz','SRID=4326;POLYGON ((15.060614001012526 50.774037111853104, 15.06064608401181 50.773998960319304, 15.060777723275763 50.77404347169889, 15.060745640366582 50.77408162326862, 15.060614001012526 50.774037111853104), (15.060825093720137 50.77410910379276, 15.060856883694626 50.77407084931751, 15.061287830257728 50.774214845230944, 15.061256040535147 50.77425309981896, 15.060825093720137 50.77410910379276), (15.061491025510193 50.77357988894232, 15.061491025510193 50.77357988894232, 15.061532940744167 50.7736139336781, 15.061275723810827 50.773742595050884, 15.061219065681994 50.77377114809984, 15.061191904132578 50.77378708959841, 15.061166451617256 50.77380382369288, 15.061143955967603 50.77382215012455, 15.06112382406758 50.77384162645634, 15.06110630666643 50.77386190573617, 15.061091518748531 50.77388167545503, 15.061079926265844 50.77390143940596, 15.061071477300931 50.77392141332186, 15.061067420760494 50.773941044836256, 15.061072656500885 50.77396126465787, 15.061084567855493 50.77398118185215, 15.061101714957717 50.77400054872549, 15.06111786028717 50.7740169664764, 15.061143796242181 50.774034901892044, 15.061170104584733 50.77404922171951, 15.061195961878152 50.77405987731509, 15.061555662921755 50.77417888211165, 15.061524813186015 50.774217343309765, 15.061201537670943 50.77411078783505, 15.061163132404937 50.77409801676134, 15.061134001945414 50.77408634375971, 15.061095258440563 50.77406593760653, 15.06106941570551 50.77404872363064, 15.061046189569947 50.774027630590425, 15.06102478734465 50.774003614091214, 15.061008826608123 50.77397800901882, 15.060998525597414 50.77394326661424, 15.061001267452813 50.773919014436196, 15.061013043591844 50.77389090309221, 15.06102717175527 50.77386706771602, 15.06104346011586 50.773843554863795, 15.06106455183295 50.773819594377, 15.061086990134262 50.77379785818935, 15.061114861656241 50.77377518839987, 15.061143526080029 50.7737564153157, 15.061171051323626 50.77374041017785, 15.061491025510193 50.77357988894232), (15.06115277049626 50.773620588090346, 15.061357200644345 50.77351776061964, 15.061399424669252 50.77355151542847, 15.061194994468618 50.773654342970964, 15.06115277049626 50.773620588090346))','SRID=4326;POINT (15.061123414935514 50.77391463057144)',NULL,63,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-10','korid','10','www.korid.cz','SRID=4326;POLYGON ((15.058477079866359 50.764621453945274, 15.058514693959768 50.76462152563487, 15.058554180179613 50.764621900783574, 15.058626283309321 50.7646226347964, 15.058701346853194 50.76462159520064, 15.058776737298384 50.764618026799006, 15.058812775811438 50.76461469133624, 15.058822912718657 50.76465695203623, 15.058783838664894 50.76466082677318, 15.058743117269795 50.76466323629539, 15.058704375227238 50.76466458542137, 15.05866541610514 50.76466515003736, 15.058626559240858 50.76466567766573, 15.058587617997263 50.76466539596825, 15.058513079923348 50.764664631419066, 15.05847584612631 50.76466436351429, 15.058477079866359 50.764621453945274, 15.058477079866359 50.764621453945274))','SRID=4326;POINT (15.058638996495171 50.76464318244542)',NULL,9,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-11','korid','11','www.korid.cz','SRID=4326;POLYGON ((15.052827174737011 50.76818395182747, 15.052813548512615 50.7681706290976, 15.053127496504548 50.768041481511716, 15.05314112278105 50.768054804197, 15.052827174737011 50.76818395182747), (15.0528545879386 50.768076271285096, 15.05284110025192 50.76806319783926, 15.0531566938284 50.767932242359606, 15.053170181564045 50.767945315769964, 15.0528545879386 50.768076271285096), (15.053360720512773 50.767780974705744, 15.053495511267823 50.76773862181574, 15.053527002654162 50.76777893267549, 15.05339221181179 50.76782128560994, 15.053360720512773 50.767780974705744), (15.053538273230366 50.76772611117662, 15.053679212198562 50.767682341076366, 15.053710454119498 50.76772280290865, 15.053569515060877 50.76776657304574, 15.053538273230366 50.76772611117662), (15.053691489914229 50.76767948261975, 15.054097311586956 50.767554098834076, 15.054109826586958 50.76757039102556, 15.053704004809042 50.767695774853735, 15.053691489914229 50.76767948261975))','SRID=4326;POINT (15.053390371993563 50.76784926421176)',NULL,23,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-1','korid','1','www.korid.cz','SRID=4326;POLYGON ((15.059402713027369 50.77050569727233, 15.059152281669425 50.7702191902531, 15.059197090359975 50.770203438803286, 15.059447521917193 50.77048994572991, 15.059402713027369 50.77050569727233))','SRID=4326;POINT (15.05929990174349 50.77035456801465)',NULL,24,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL),
('korid-16','korid','16','www.korid.cz','SRID=4326;POLYGON ((15.05460215639034 50.76831686455292, 15.054778108824609 50.76827621498907, 15.054801398283878 50.768316760767966, 15.054625445734311 50.76835741036742, 15.05460215639034 50.76831686455292), (15.055025205881027 50.76835711307601, 15.055043081062772 50.768315347731786, 15.055440674880355 50.768383784379935, 15.055422800008474 50.76842554978086, 15.055025205881027 50.76835711307601), (15.055117032704732 50.76832417306977, 15.05513472865224 50.768282712238154, 15.05542327292743 50.768332241817845, 15.055405577211578 50.76837370269995, 15.055117032704732 50.76832417306977), (15.055507634795866 50.76830051924529, 15.055481502312903 50.768305122089195, 15.055417122627883 50.76815810840171, 15.055443255052502 50.76815350556426, 15.055507634795866 50.76830051924529), (15.054674623382972 50.76844698607595, 15.054674028292549 50.76840389729273, 15.054823104498281 50.76840306806651, 15.054823699723547 50.76844615684853, 15.054674623382972 50.76844698607595), (15.054751339591144 50.768526052273614, 15.054750531240463 50.768455517998724, 15.054818095506002 50.768455206076496, 15.05481890395854 50.76852574034169, 15.054751339591144 50.768526052273614), (15.054758929648006 50.76885589943716, 15.054755161765824 50.76856948287865, 15.054826914058388 50.76856910270115, 15.054830682370188 50.768855519264875, 15.054758929648006 50.76885589943716))','SRID=4326;POINT (15.05499910754953 50.76841042000099)',NULL,31,NULL,'2023-11-23 10:53:15.699+01',NULL,NULL,'2024-05-16 16:00:17.52+02',NULL,NULL);

INSERT INTO parking_tariffs_relation ("parking_id", "tariff_id", "source", "updated_at", "created_at") VALUES
('korid-14', 'f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-13', 'f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-12', '841e6854-8905-55c4-8611-a5a13fd6ef2e', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-10', 'b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-11', 'b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-1', 'b184865e-5a5e-5465-abc1-4fab6bc56a77', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01'),
('korid-16', 'f4de50d9-1f5f-5d76-81a6-e5e8a2aa6d44', 'korid', '2025-03-28 11:00:00.000+01', '2025-03-28 11:00:00.000+01');
