Bruker:Joakimsk

1. Experiments

Used for testing various extensions.

https://maps.extension.wiki/wiki/Leaflet_SMW_queries

V-5706 Ostmark
Kanonen på bakken
Tekniske data
Type		Hvalbåt/Forpostbåt
Lengde (m)		110 fot
Tonnasje		204 br.tonn
Karriere
Bygget		1925 ved Akers Mek.
Flaggstat		Norge
Døpt		Treff
Andre navn		Treff
Dato forlis		16.06. 1941
Dykket
Nivå		Nivå 3
Tilgjengelighet		Med båt
Dykkedybde		35-45 meter
Plassering på bunn		På kjøl
Generell tilstand		God
Posisjon		64.01795 N, 9.965167 E
Laster kart... {"format":"leaflet","minzoom":false,"maxzoom":false,"limit":50,"offset":0,"link":"all","sort":[""],"order":[],"headers":"show","mainlabel":"","intro":"","outro":"","searchlabel":"\u2026 flere resultater","default":"","import-annotation":false,"width":"100%","height":"300px","centre":false,"title":"","label":"","icon":"","lines":[],"polygons":[],"circles":[],"rectangles":[],"copycoords":true,"static":false,"zoom":false,"defzoom":14,"layers":["topo"],"image layers":[],"overlays":[],"resizable":true,"fullscreen":true,"scrollwheelzoom":true,"cluster":false,"clustermaxzoom":20,"clusterzoomonclick":true,"clustermaxradius":80,"clusterspiderfy":true,"geojson":"","clicktarget":"","showtitle":true,"hidenamespace":true,"template":"","userparam":"","activeicon":"","pagelabel":false,"ajaxcoordproperty":"","ajaxquery":"","locations":[{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bruker:Joakimsk\" title=\"Bruker:Joakimsk\"\u003EJoakimsk\u003C/a\u003E\u003C/b\u003E","title":"Joakimsk","link":"","lat":64.01795,"lon":9.9651666667,"icon":""}],"imageLayers":[]} Karthjelpen: Når pekeren din er over kartet, vil scrolling endre zoom-nivå. Full-skjerm med symbol i øvre høyre hjørnet. Dobbelklikk på et område på kartet og du zoomer inn på det. For de kart med flere kartlag, kan du velge i øvre høyre hjørnet hvilket du vil se. Mer om hvordan opprette kart her.

1. 1. Semantic Wiki Queries

#ask ask is used to build queries. SMW ask

#show show is used to get single value from a page. SMW show

HER

64.01795 N, 9.965167 E

Og som kart kanskje

HER

1. 1. Maps

Laster kart...

{"minzoom":false,"maxzoom":false,"mappingservice":"leaflet","width":"30%","height":"200px","centre":false,"title":"","label":"","icon":"","lines":[],"polygons":[],"circles":[],"rectangles":[],"copycoords":true,"static":false,"zoom":6,"defzoom":14,"layers":["OpenStreetMap"],"image layers":[],"overlays":[],"resizable":false,"fullscreen":false,"scrollwheelzoom":true,"cluster":false,"clustermaxzoom":20,"clusterzoomonclick":true,"clustermaxradius":80,"clusterspiderfy":true,"geojson":"","clicktarget":"","imageLayers":[],"locations":[{"text":"","title":"","link":"","lat":64.01795,"lon":9.965167,"icon":""}],"imageoverlays":null}

Alle vrak

Debug output SQLStore

ASK Query

[[Kategori:Vrak]]

SQL Query

SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_fpt_inst` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.o_id=528)
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  0

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t1	ref	s_id, o_id, s_id_2, o_id_2	o_id_2	5	const	478		Using index; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY, smw_id, smw_iw, smw_iw_2	PRIMARY	4	dykkepedia_wiki.t1.s_id	1		Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

Laster kart...

{"format":"leaflet","minzoom":false,"maxzoom":false,"limit":50,"offset":0,"link":"all","sort":[""],"order":[],"headers":"show","mainlabel":"","intro":"","outro":"","searchlabel":"\u2026 flere resultater","default":"","import-annotation":false,"width":"500px","height":"350px","centre":false,"title":"","label":"","icon":"","lines":[],"polygons":[],"circles":[],"rectangles":[],"copycoords":false,"static":false,"zoom":false,"defzoom":14,"layers":["OpenStreetMap"],"image layers":[],"overlays":[],"resizable":false,"fullscreen":false,"scrollwheelzoom":true,"cluster":false,"clustermaxzoom":20,"clusterzoomonclick":true,"clustermaxradius":80,"clusterspiderfy":true,"geojson":"","clicktarget":"","showtitle":true,"hidenamespace":true,"template":"","userparam":"","activeicon":"","pagelabel":false,"ajaxcoordproperty":"","ajaxquery":"","locations":[{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Aardal\" title=\"Aardal\"\u003EAardal\u003C/a\u003E\u003C/b\u003E","title":"Aardal","link":"","lat":61.304293,"lon":7.771575,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Achilles\" title=\"Achilles\"\u003EAchilles\u003C/a\u003E\u003C/b\u003E","title":"Achilles","link":"","lat":58.29275,"lon":6.655333,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Afrika\" title=\"Afrika\"\u003EAfrika\u003C/a\u003E\u003C/b\u003E","title":"Afrika","link":"","lat":60.567417,"lon":6.92505,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Agnes\" title=\"Agnes\"\u003EAgnes\u003C/a\u003E\u003C/b\u003E","title":"Agnes","link":"","lat":59.4,"lon":5.283333,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Akerendam\" title=\"Akerendam\"\u003EAkerendam\u003C/a\u003E\u003C/b\u003E","title":"Akerendam","link":"","lat":62.413697,"lon":5.589251,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Albatros\" title=\"Albatros\"\u003EAlbatros\u003C/a\u003E\u003C/b\u003E","title":"Albatros","link":"","lat":59.09421,"lon":10.79175,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Albert_Janus\" title=\"Albert Janus\"\u003EAlbert Janus\u003C/a\u003E\u003C/b\u003E","title":"Albert Janus","link":"","lat":62.1927,"lon":6.11345,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Alstein\" title=\"Alstein\"\u003EAlstein\u003C/a\u003E\u003C/b\u003E","title":"Alstein","link":"","lat":59.4403,"lon":10.65632,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Altair\" title=\"Altair\"\u003EAltair\u003C/a\u003E\u003C/b\u003E","title":"Altair","link":"","lat":63.019389,"lon":7.205143,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Anhalt\" title=\"Anhalt\"\u003EAnhalt\u003C/a\u003E\u003C/b\u003E","title":"Anhalt","link":"","lat":61.488401,"lon":5.016968,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Anna_Sofie\" title=\"Anna Sofie\"\u003EAnna Sofie\u003C/a\u003E\u003C/b\u003E","title":"Anna Sofie","link":"","lat":59.416667,"lon":5.233333,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Annie_Butler\" title=\"Annie Butler\"\u003EAnnie Butler\u003C/a\u003E\u003C/b\u003E","title":"Annie Butler","link":"","lat":59.918,"lon":5.522833,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Anton_Schmitt\" title=\"Anton Schmitt\"\u003EAnton Schmitt\u003C/a\u003E\u003C/b\u003E","title":"Anton Schmitt","link":"","lat":68.43438,"lon":17.37774,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Aquila\" title=\"Aquila\"\u003EAquila\u003C/a\u003E\u003C/b\u003E","title":"Aquila","link":"","lat":61.732583,"lon":5.19255,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Arado_AR_196\" title=\"Arado AR 196\"\u003EArado AR 196\u003C/a\u003E\u003C/b\u003E","title":"Arado AR 196","link":"","lat":63.450439,"lon":10.747236,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Argentina\" title=\"Argentina\"\u003EArgentina\u003C/a\u003E\u003C/b\u003E","title":"Argentina","link":"","lat":58.3955,"lon":5.9925,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Argus\" title=\"Argus\"\u003EArgus\u003C/a\u003E\u003C/b\u003E","title":"Argus","link":"","lat":70.09315,"lon":25.0771,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Arisan\" title=\"Arisan\"\u003EArisan\u003C/a\u003E\u003C/b\u003E","title":"Arisan","link":"","lat":62.398333,"lon":5.525,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Astri\" title=\"Astri\"\u003EAstri\u003C/a\u003E\u003C/b\u003E","title":"Astri","link":"","lat":59.49015,"lon":10.38115,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Aud\" title=\"Aud\"\u003EAud\u003C/a\u003E\u003C/b\u003E","title":"Aud","link":"","lat":63.083891,"lon":7.488116,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/August_Bolten\" title=\"August Bolten\"\u003EAugust Bolten\u003C/a\u003E\u003C/b\u003E","title":"August Bolten","link":"","lat":60.150253,"lon":5.308886,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Auken\" title=\"Auken\"\u003EAuken\u003C/a\u003E\u003C/b\u003E","title":"Auken","link":"","lat":62.888422,"lon":6.962628,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Austri\" title=\"Austri\"\u003EAustri\u003C/a\u003E\u003C/b\u003E","title":"Austri","link":"","lat":60.916667,"lon":4.783333,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Baltic\" title=\"Baltic\"\u003EBaltic\u003C/a\u003E\u003C/b\u003E","title":"Baltic","link":"","lat":60.60565,"lon":4.86453,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bandak\" title=\"Bandak\"\u003EBandak\u003C/a\u003E\u003C/b\u003E","title":"Bandak","link":"","lat":61.042625,"lon":4.870312,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Barcelona\" title=\"Barcelona\"\u003EBarcelona\u003C/a\u003E\u003C/b\u003E","title":"Barcelona","link":"","lat":62.479934,"lon":6.15509,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Barsk\" title=\"Barsk\"\u003EBarsk\u003C/a\u003E\u003C/b\u003E","title":"Barsk","link":"","lat":58.462385,"lon":8.782764,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Beaconsfield\" title=\"Beaconsfield\"\u003EBeaconsfield\u003C/a\u003E\u003C/b\u003E","title":"Beaconsfield","link":"","lat":63.041583,"lon":7.355117,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Begonia\" title=\"Begonia\"\u003EBegonia\u003C/a\u003E\u003C/b\u003E","title":"Begonia","link":"","lat":60.86893,"lon":7.12321,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Belgica\" title=\"Belgica\"\u003EBelgica\u003C/a\u003E\u003C/b\u003E","title":"Belgica","link":"","lat":68.79593651211,"lon":16.593278569967,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bergevika\" title=\"Bergevika\"\u003EBergevika\u003C/a\u003E\u003C/b\u003E","title":"Bergevika","link":"","lat":60.74804,"lon":11.01632,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bessheim\" title=\"Bessheim\"\u003EBessheim\u003C/a\u003E\u003C/b\u003E","title":"Bessheim","link":"","lat":70.634939,"lon":23.578033,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bev%C3%B8ykollen\" title=\"Bev\u00f8ykollen\"\u003EBev\u00f8ykollen\u003C/a\u003E\u003C/b\u003E","title":"Bev\u00f8ykollen","link":"","lat":59.52804,"lon":10.62313,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bjarke\" title=\"Bjarke\"\u003EBjarke\u003C/a\u003E\u003C/b\u003E","title":"Bjarke","link":"","lat":58.078833,"lon":8.0895,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bjergfin\" title=\"Bjergfin\"\u003EBjergfin\u003C/a\u003E\u003C/b\u003E","title":"Bjergfin","link":"","lat":61.381283,"lon":5.105433,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bj%C3%B8nn\" title=\"Bj\u00f8nn\"\u003EBj\u00f8nn\u003C/a\u003E\u003C/b\u003E","title":"Bj\u00f8nn","link":"","lat":62.98147,"lon":6.98664,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Blaafjeld\" title=\"Blaafjeld\"\u003EBlaafjeld\u003C/a\u003E\u003C/b\u003E","title":"Blaafjeld","link":"","lat":64.866917,"lon":11.71175,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Black_Watch\" title=\"Black Watch\"\u003EBlack Watch\u003C/a\u003E\u003C/b\u003E","title":"Black Watch","link":"","lat":68.719818,"lon":16.569099,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Blohm_%26_Voss_BV_138\" title=\"Blohm \u0026amp; Voss BV 138\"\u003EBlohm \u0026amp; Voss BV 138\u003C/a\u003E\u003C/b\u003E","title":"Blohm \u0026 Voss BV 138","link":"","lat":70.53245,"lon":25.169334,"icon":""},{"text":"\u003Cb\u003E\u003Ca href=\"/wiki/Bl%C3%BCcher\" title=\"Bl\u00fccher\"\u003EBl\u00fccher\u003C/a\u003E\u003C/b\u003E","title":"Bl\u00fccher","link":"","lat":59.7005,"lon":10.59694,"icon":""}],"imageLayers":[]}

1. 1. DynamicPageListing Queries