servicemap

Custom SQL query returning 4 rows (hide)

Query parameters

idorigin_idocd_idservice_point_idstartendmodified_attypeparentmunicipalityname_finame_svname
3897 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:47.999099+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3916 431976899 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu:431976899   2020-08-01 2021-08-01 2020-09-16T22:30:55.435631+03:00 upper_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3949 431976899_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_alakoulu_seuraava:431976899_1   2021-08-01 2022-08-01 2020-09-16T22:30:49.826244+03:00 lower_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue    
3968 431976899_1 ocd-division/country:fi/kunta:espoo/oppilaaksiottoalue_ylakoulu_seuraava:431976899_1   2021-08-01 2022-08-01 2020-09-16T22:30:57.252610+03:00 upper_comprehensive_school_district_fi 11 espoo Espoonlahden oppilasalue