User talk:Wolfgang Fahl: Difference between revisions

From FactGrid
Jump to navigation Jump to search
(Created page with "== SPARQL Suche == * [https://database.factgrid.de/query/index.html#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ995329%20.%0A%20%20%3Fq%20wdt%3AP1198%20%3FUmsiedler%20.%0A%20%20%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP95%20%3Fwoher%20.%0A%20%20%3Fwoher%20wdt%3AP48%20%3Fcoord1%20.%0A%20%20%3Fwoher%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenod...")
 
(→‎claude AI: new section)
Line 2: Line 2:


* [https://database.factgrid.de/query/index.html#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ995329%20.%0A%20%20%3Fq%20wdt%3AP1198%20%3FUmsiedler%20.%0A%20%20%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP95%20%3Fwoher%20.%0A%20%20%3Fwoher%20wdt%3AP48%20%3Fcoord1%20.%0A%20%20%3Fwoher%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP216%20%3Finterniert%20.%0A%20%20%3Finterniert%20wdt%3AP48%20%3Fcoord2%20.%0A%20%20%3Finterniert%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3Fcoord3%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode3.%20%3Fvaluenode3%20wikibase%3AgeoLatitude%20%3Flat3%20.%20%3Fvaluenode3%20wikibase%3AgeoLongitude%20%3Flon3.%0A%20%20BIND%28geof%3Adistance%28%3Fcoord1%2C%20%3Fcoord2%29%20AS%20%3Fdist%29.%0A%20%20BIND%28geof%3Adistance%28%3Fcoord2%2C%20%3FcoordD%29%20AS%20%3Fdist2%29.%0A%20%20BIND%28floor%28%3Fdist%2F10%29%20AS%20%3Flayer%29.%0A%20%20BIND%28floor%28%3Fdist2%2F10%29%20AS%20%3Flayer%29.%0A%20%20BIND%28CONCAT%28%27LINESTRING%20%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%2C%27%2C%20STR%28%3Flon3%29%2C%20%27%20%27%2C%20STR%28%3Flat3%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%0A%7D Personen, die von der VoMi umgesiedelt werden]
* [https://database.factgrid.de/query/index.html#%23defaultView%3AMap%7B%22hide%22%3A%5B%22%3Fline%22%5D%7D%0ASELECT%20%2a%20WHERE%20%7B%0A%20%20%3Fq%20wdt%3AP2%20wd%3AQ995329%20.%0A%20%20%3Fq%20wdt%3AP1198%20%3FUmsiedler%20.%0A%20%20%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP95%20%3Fwoher%20.%0A%20%20%3Fwoher%20wdt%3AP48%20%3Fcoord1%20.%0A%20%20%3Fwoher%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode1.%20%3Fvaluenode1%20wikibase%3AgeoLatitude%20%3Flat1%20.%20%3Fvaluenode1%20wikibase%3AgeoLongitude%20%3Flon1.%0A%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP216%20%3Finterniert%20.%0A%20%20%3Finterniert%20wdt%3AP48%20%3Fcoord2%20.%0A%20%20%3Finterniert%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode2.%20%3Fvaluenode2%20wikibase%3AgeoLatitude%20%3Flat2%20.%20%3Fvaluenode2%20wikibase%3AgeoLongitude%20%3Flon2.%0A%20%20%0A%20%20%3Fq%20p%3AP1198%2Fpq%3AP29%20%3Fdest%20.%0A%20%20%3Fdest%20wdt%3AP48%20%3Fcoord3%20.%0A%20%20%3Fdest%20p%3AP48%2Fpsv%3AP48%20%3Fvaluenode3.%20%3Fvaluenode3%20wikibase%3AgeoLatitude%20%3Flat3%20.%20%3Fvaluenode3%20wikibase%3AgeoLongitude%20%3Flon3.%0A%20%20BIND%28geof%3Adistance%28%3Fcoord1%2C%20%3Fcoord2%29%20AS%20%3Fdist%29.%0A%20%20BIND%28geof%3Adistance%28%3Fcoord2%2C%20%3FcoordD%29%20AS%20%3Fdist2%29.%0A%20%20BIND%28floor%28%3Fdist%2F10%29%20AS%20%3Flayer%29.%0A%20%20BIND%28floor%28%3Fdist2%2F10%29%20AS%20%3Flayer%29.%0A%20%20BIND%28CONCAT%28%27LINESTRING%20%28%27%2C%20STR%28%3Flon1%29%2C%20%27%20%27%2C%20STR%28%3Flat1%29%2C%20%27%2C%27%2C%20STR%28%3Flon2%29%2C%20%27%20%27%2C%20STR%28%3Flat2%29%2C%20%27%2C%27%2C%20STR%28%3Flon3%29%2C%20%27%20%27%2C%20STR%28%3Flat3%29%2C%20%27%29%27%29%20AS%20%3Fstr%29%20.%0A%20%20BIND%28STRDT%28%3Fstr%2C%20geo%3AwktLiteral%29%20AS%20%3Fline%29%0A%7D Personen, die von der VoMi umgesiedelt werden]
== claude AI ==
<source lang='sparql'>
#defaultView:Map{"hide":["?line"]}
SELECT * WHERE {
  # Select entities related to a specific item (Q995329)
  ?q wdt:P2 wd:Q995329 .
 
  # Get the number of displaced persons for each entity
  ?q wdt:P1198 ?Umsiedler .
 
  # Get the origin location of the displaced persons
  ?q p:P1198/pq:P95 ?woher .
  ?woher wdt:P48 ?coord1 .
  # Extract latitude and longitude for the origin
  ?woher p:P48/psv:P48 ?valuenode1.
  ?valuenode1 wikibase:geoLatitude ?lat1 .
  ?valuenode1 wikibase:geoLongitude ?lon1.
 
  # Get the internment location
  ?q p:P1198/pq:P216 ?interniert .
  ?interniert wdt:P48 ?coord2 .
  # Extract latitude and longitude for the internment location
  ?interniert p:P48/psv:P48 ?valuenode2.
  ?valuenode2 wikibase:geoLatitude ?lat2 .
  ?valuenode2 wikibase:geoLongitude ?lon2.
 
  # Get the destination location
  ?q p:P1198/pq:P29 ?dest .
  ?dest wdt:P48 ?coord3 .
  # Extract latitude and longitude for the destination
  ?dest p:P48/psv:P48 ?valuenode3.
  ?valuenode3 wikibase:geoLatitude ?lat3 .
  ?valuenode3 wikibase:geoLongitude ?lon3.
 
  # Calculate distances between points
  BIND(geof:distance(?coord1, ?coord2) AS ?dist).
  BIND(geof:distance(?coord2, ?coordD) AS ?dist2).
 
  # Create layer values based on distances (possibly for visualization)
  BIND(floor(?dist/10) AS ?layer).
  BIND(floor(?dist2/10) AS ?layer).
 
  # Create a LINESTRING connecting all three points
  BIND(CONCAT('LINESTRING (', STR(?lon1), ' ', STR(?lat1), ',', STR(?lon2), ' ', STR(?lat2), ',', STR(?lon3), ' ', STR(?lat3), ')') AS ?str) .
  BIND(STRDT(?str, geo:wktLiteral) AS ?line)
}
</source>

Revision as of 14:13, 18 September 2024

SPARQL Suche

claude AI

<source lang='sparql'>

  1. defaultView:Map{"hide":["?line"]}

SELECT * WHERE { 

 # Select entities related to a specific item (Q995329)
 ?q wdt:P2 wd:Q995329 .
 
 # Get the number of displaced persons for each entity
 ?q wdt:P1198 ?Umsiedler .
 
 # Get the origin location of the displaced persons
 ?q p:P1198/pq:P95 ?woher .
 ?woher wdt:P48 ?coord1 .
 # Extract latitude and longitude for the origin
 ?woher p:P48/psv:P48 ?valuenode1. 
 ?valuenode1 wikibase:geoLatitude ?lat1 . 
 ?valuenode1 wikibase:geoLongitude ?lon1.
 
 # Get the internment location
 ?q p:P1198/pq:P216 ?interniert .
 ?interniert wdt:P48 ?coord2 .
 # Extract latitude and longitude for the internment location
 ?interniert p:P48/psv:P48 ?valuenode2. 
 ?valuenode2 wikibase:geoLatitude ?lat2 . 
 ?valuenode2 wikibase:geoLongitude ?lon2.
 
 # Get the destination location
 ?q p:P1198/pq:P29 ?dest .
 ?dest wdt:P48 ?coord3 .
 # Extract latitude and longitude for the destination
 ?dest p:P48/psv:P48 ?valuenode3. 
 ?valuenode3 wikibase:geoLatitude ?lat3 . 
 ?valuenode3 wikibase:geoLongitude ?lon3.
 
 # Calculate distances between points
 BIND(geof:distance(?coord1, ?coord2) AS ?dist).
 BIND(geof:distance(?coord2, ?coordD) AS ?dist2).
 
 # Create layer values based on distances (possibly for visualization)
 BIND(floor(?dist/10) AS ?layer).
 BIND(floor(?dist2/10) AS ?layer).
 
 # Create a LINESTRING connecting all three points
 BIND(CONCAT('LINESTRING (', STR(?lon1), ' ', STR(?lat1), ',', STR(?lon2), ' ', STR(?lat2), ',', STR(?lon3), ' ', STR(?lat3), ')') AS ?str) .
 BIND(STRDT(?str, geo:wktLiteral) AS ?line)

} </source>

Retrieved from "https://database.factgrid.de/w/index.php?title=User_talk:Wolfgang_Fahl&oldid=9166311"