AKSW / transform-bvl-pages-to-csv-file

Repository contains files to extract and enrich data from closed database of the Online-Stadtführer maintained by Behindertenverband Leipzig e.V (in German). Besides that, further files like a R2RML mapping, are maintained.
https://behindertenverband-leipzig.de/projekte/stadtfuehrer/
GNU General Public License v3.0
1 stars 2 forks source link

Avoid publication of multiple places with the same title (and therefore URI) as RDF #3

Closed k00ni closed 8 years ago

k00ni commented 8 years ago

Because each place may have different properties / values. We will use the first one and ignore the others. Some places share the same name but are located at different locations. So we have to use the address inside the URI to make them distinguishable.

k00ni commented 8 years ago

The following places existing multiple times:

PREFIX leoplace: http://le-online.de/ontology/place/ns# PREFIX geo: http://www.w3.org/2003/01/geo/wgs84_pos# select ?a from http://le-online.de/Test/ where { ?a geo:latitude ?lat . } GROUP by ?a HAVING( count(?lat)>1)

http://le-online.de/place/voelkerschlachtdenkmal 2 http://le-online.de/place/polizeidirektion-leipzig 4 http://le-online.de/place/park-krankenhaus-leipzig-suedost-gmbh 2 http://le-online.de/place/komm-haus 2 http://le-online.de/place/sozialstation-gruenau 3 http://le-online.de/place/staedtisches-bestattungswesen---eigenbetrieb 3 http://le-online.de/place/first-reisebuero 3 http://le-online.de/place/auslaenderbehoerde 2 http://le-online.de/place/der-paritaetische-sachsen-e.v. 2 http://le-online.de/place/servicestelle-fuer-rehabilitation 2 http://le-online.de/place/sozialstation-holzhausen 2 http://le-online.de/place/wolf---das-sanitaetshaus 4 http://le-online.de/place/lesti---sanitaetshaus---orthopaedie--und-rehatechnik 2 http://le-online.de/place/merkurpromenade 2 http://le-online.de/place/awo-werkstaetten-sachsen-west-wfb 2 http://le-online.de/place/hauptbahnhof 2 http://le-online.de/place/augustusplatz 2 http://le-online.de/place/stadtwerke-leipzig 2

(thx @hg-graebe for the info)