基于本地存储邮编过滤SPARQL查询结果并导出数据
邮编匹配与SPARQL查询优化需求
我需要将本地计算机存储的邮编,与从opendatacommunities.org和ordnancesurvey.co.uk数据库查询返回的邮编进行匹配。
本地存储的邮编遵循标准格式,示例如下(注:已通过移除最后三个字母完成匿名处理):
IP3 NR32 IP8 IP6 IP18 CB8 Ip13 IP31 IP3 IP11
基于一篇StackOverflow问题的思路,我编写了以下SPARQL查询语句:
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> SELECT ?lsoa_name ?area_name ?postcode ?period ?imd_dec WHERE { ?obs <http://opendatacommunities.org/def/ontology/communities/societal_wellbeing/imd/indices> <http://opendatacommunities.org/def/concept/general-concepts/imd/combineddeprivation>. ?obs <http://opendatacommunities.org/def/ontology/geography/refArea> ?areauri . ?obs <http://opendatacommunities.org/def/ontology/time/refPeriod> ?perioduri . ?obs <http://opendatacommunities.org/def/ontology/communities/societal_wellbeing/imd/decObs> ?imd_dec . ?postcodeUnit a <http://data.ordnancesurvey.co.uk/ontology/postcode/PostcodeUnit>; <http://opendatacommunities.org/def/geography#lsoa> ?lsoa . ?areauri <http://www.w3.org/2002/07/owl#sameAs> ?sg . ?lsoa <http://www.w3.org/2002/07/owl#sameAs> ?sg . ?areauri rdfs:label ?lsoa_name . ?perioduri rdfs:label ?period . ?lsoa rdfs:label ?area_name. ?postcodeUnit rdfs:label ?postcode. } LIMIT 10
这个查询会返回英格兰所有邮编对应的多重剥夺指数(IMD)、下层超级输出区(LSOA)等数据,但返回的结果数据量过大,无法直接下载存储。我只需要与本地存储邮编匹配的样本数据,因此希望通过邮编匹配过滤出相关数据,获取所需的样本。
内容的提问来源于stack exchange,提问作者gofraidh
相关产品推荐
相关产品推荐

