Template:SubdivisionName: Difference between revisions

Latest revision as of 13:53, 13 February 2026

This is the "SubdivisionName" template. It should be called in the following format:

{{SubdivisionName:
 | Country=
 | M49=
 | SubdivisionCategory=
 | Code31662=
 | SubdivisionName=
}}

This template defines the table "SubdivisionNames". View table.

@@ Line 7: / Line 7: @@
   | M49=
   | SubdivisionCategory=
-  | Code3166_2=
+  | Code31662=
   | SubdivisionName=
 }}
@@ Line 17: / Line 17: @@
   | M49=String
   | SubdivisionCategory=String
-  | Code3166-2=String
+  | Code31662=String
   | SubdivisionName=List (,) of Page
 }}
@@ Line 25: / Line 25: @@
 * SubdivisionCategory: {{{SubdivisionCategory}}}
 * M49: {{{M49}}}
-* Code3166-2: {{{Code3166-2}}}
+* Code31662: {{{Code31662}}}
+=Recorded floods for {{{SubdivisionName}}}=
+Total number of flood events: {{#cargo_query:
+tables=FloodReports
+|fields = COUNT(_pageName)
+|where=SubdivisionName HOLDS '{{PAGENAME}}'
+| format = plain
+}}'''
+{{#cargo_query:
+tables=FloodReports
+|fields=
+    CONCAT_WS('','[[',_pageName, '|', ReportNumber, ']]')=﹟,
+    GlideNumber=Glide ﹟,
+    BeginDate=Start Date,
+    EndDate=End Date,
+    Country=Country,
+    SubdivisionName=State,
+    FORMAT(Area,0)=Area (km²),
+    Source=Source,
+    MainCause=Main Cause,
+    NumberOfFatalities=Fatalities,
+    NumberOfDisplaced=Displaced,
+    Severity=Severity,
+    FORMAT(FloodImpactIndex,1)=Flood impact index
+|where=SubdivisionName HOLDS '{{PAGENAME}}'
+|hidden fields=Glide ﹟,Country,Source
+|order by=Start Date DESC
+|limit=6000
+|rows per page=25
+|link=ReportNumber
+|format=dynamic table
+|default=No flood reports found for this state.
+}}
@@ Line 34: / Line 68: @@
   | M49={{{M49|}}}
   | SubdivisionCategory={{{SubdivisionCategory|}}}
+ | Code31662={{{Code31662|}}}
   | SubdivisionName={{{SubdivisionName|}}}
 }}
 </includeonly>