water-fountains / proximap

a responsive Angular 6 web app for finding nearby fountains

https://beta.water-fountains.org

Other

16 stars 10 forks source link

Add fountains of Rome #133

Open ralfhauser opened 5 years ago

ralfhauser commented 5 years ago

another swiss language and an amazing city

ralfhauser commented 5 years ago

see item #134

mmmatthew commented 5 years ago

What boundaries should be used for the city limits?

ralfhauser commented 5 years ago

Fontana Trevi exists twice:

ralfhauser commented 5 years ago

as per https://overpass-turbo.eu/s/Hxb - some has ~40% more fountains than Zürich!

ralfhauser commented 5 years ago

There is also https://en.wikipedia.org/wiki/List_of_fountains_in_Rome

mmmatthew commented 5 years ago

@ralfhauser what code makes sense? it-roma?

ralfhauser commented 5 years ago

As per https://en.wikipedia.org/wiki/Vehicle_registration_plates_of_Italy#Province_codes_1927_to_present_day

yes, please take "roma" beause "ro" apparently is reserved for https://en.wikipedia.org/wiki/Province_of_Rovigo

ralfhauser commented 4 years ago

44 in wikidata

SELECT ?place ?placeLabel ?location ?date WHERE {

Enter coordinates

SERVICE wikibase:box { ?place wdt:P625 ?location .

Bottom left - upper right

bd:serviceParam wikibase:cornerWest "Point(12.3706 41.7928)"^^geo:wktLiteral.
bd:serviceParam wikibase:cornerEast "Point(12.6096 41.9922)"^^geo:wktLiteral.

} .

Is a water well or fountain or subclass of fountain

FILTER (EXISTS { ?place wdt:P31/wdt:P279 wd:Q43483 } || EXISTS { ?place wdt:P31/wdt:P279 wd:Q483453 }). SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de" . } }

https://www.wikidata.org/wiki/Q74574057 "Nasone via Tuscolana" is not in there because it does not have coordinates

ralfhauser commented 4 years ago

https://twitter.com/OpenDataZurich/status/1197183340404707333?s=20