servicemap

Custom SQL query returning 4 rows (hide)

Query parameters

idorigin_idocd_idservice_point_idstartendmodified_attypeparentmunicipalityname_finame_svname
3900 431977071 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431977071   2020-08-01 2021-08-01 2020-09-16T22:30:48.009361+03:00 lower_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3919 431977071 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431977071   2020-08-01 2021-08-01 2020-09-16T22:30:55.445442+03:00 upper_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3952 431977071_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431977071_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.836950+03:00 lower_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue    
3971 431977071_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431977071_1   2021-08-01 2022-08-01 2020-09-16T22:30:57.263100+03:00 upper_comprehensive_school_district_fi 11 espoo Pohjois-Espoon oppilasalue