Modèle:Communes-infos : Différence entre versions

De geoLwiki - Guide géologique du Luxembourg
Ligne 1 : Ligne 1 :
 
{|class=prettytable
 
{|class=prettytable
−
|<small>Code|| {{#sql2wiki_f:select truncate(c_com,0) from communes where Nom_com_min="{{FULLPAGENAME}}";}}  </small>
+
|<small>Code|| {{#sql2wiki_f:select truncate(c_com,0) from communes where Nom_com="{{FULLPAGENAME}}";}}  </small>
 
|-
 
|-
−
|Aire (km<sup>2</sup>)&nbsp;&nbsp;&nbsp;||{{#sql2wiki_f:select truncate(area/1000000,1) from communes where Nom_com_min="{{FULLPAGENAME}}";}}
+
|Aire (km<sup>2</sup>)&nbsp;&nbsp;&nbsp;||{{#sql2wiki_f:select truncate(area/1000000,1) from communes where Nom_com="{{FULLPAGENAME}}";}}
 
|-
 
|-
−
|Canton||{{#sql2wiki_f:select nom_canton from communes where Nom_com_min="{{FULLPAGENAME}}";}}
+
|Canton||{{#sql2wiki_f:select nom_canton from communes where Nom_com="{{FULLPAGENAME}}";}}
 
|-
 
|-
−
|Localités||{{#sql2wiki_tinv:select Nom_lieu_min, Name, Numm,c_section from lieux where Nom_com_min="{{FULLPAGENAME}}" order by nom_lieu_min;}}
+
|Localités||{{#sql2wiki_tinv:select Nom_lieu_min, Name, Numm,c_section from lieux where Nom_com="{{FULLPAGENAME}}" order by nom_lieu_min;}}
 
|-
 
|-
−
|Sections||{{#sql2wiki_tinv:select c_section , Nom_section from sections where Nom_com_min="{{FULLPAGENAME}}" order by c_section;}}
+
|Sections||{{#sql2wiki_tinv:select c_section , Nom_section from sections where Nom_com="{{FULLPAGENAME}}" order by c_section;}}
 
|-
 
|-
−
|Chef-lieu||'''{{#sql2wiki_f:select nom_cheflieu from communes where Nom_com_min="{{FULLPAGENAME}}";}}'''
+
|Chef-lieu||'''{{#sql2wiki_f:select nom_cheflieu from communes where Nom_com="{{FULLPAGENAME}}";}}'''
 
|-
 
|-
−
|Carte ||{{#icon:World_small.gif|Carte||http://gis.pch.etat.lu/arcgis/rest/services/act/topocarto/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_min from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select est_max from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_max from communes where Nom_com_min="{{FULLPAGENAME}}";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com_min="{{FULLPAGENAME}}";}}}}
+
|Carte ||{{#icon:World_small.gif|Carte||http://gis.pch.etat.lu/arcgis/rest/services/act/topocarto/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_min from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select est_max from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_max from communes where Nom_com="{{FULLPAGENAME}}";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="{{FULLPAGENAME}}";}}}}
 
|-
 
|-
−
|Orthoimage||{{#icon:World_small.gif|Carte||http://gis.pch.etat.lu/arcgis/rest/services/act/ortho2007/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_min from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select est_max from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_max from communes where Nom_com_min="{{FULLPAGENAME}}";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com_min="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com_min="{{FULLPAGENAME}}";}}}}
+
|Orthoimage||{{#icon:World_small.gif|Carte||http://gis.pch.etat.lu/arcgis/rest/services/act/ortho2007/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_min from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select est_max from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select nord_max from communes where Nom_com="{{FULLPAGENAME}}";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="{{FULLPAGENAME}}";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="{{FULLPAGENAME}}";}}}}
 
|}
 
|}

Version du 30 décembre 2008 à 16:31

Code {{#sql2wiki_f:select truncate(c_com,0) from communes where Nom_com="Modèle:Communes-infos";}}
Aire (km2)    {{#sql2wiki_f:select truncate(area/1000000,1) from communes where Nom_com="Modèle:Communes-infos";}}
Canton {{#sql2wiki_f:select nom_canton from communes where Nom_com="Modèle:Communes-infos";}}
Localités {{#sql2wiki_tinv:select Nom_lieu_min, Name, Numm,c_section from lieux where Nom_com="Modèle:Communes-infos" order by nom_lieu_min;}}
Sections {{#sql2wiki_tinv:select c_section , Nom_section from sections where Nom_com="Modèle:Communes-infos" order by c_section;}}
Chef-lieu {{#sql2wiki_f:select nom_cheflieu from communes where Nom_com="Modèle:Communes-infos";}}
Carte Carte http://gis.pch.etat.lu/arcgis/rest/services/act/topocarto/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select nord_min from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select est_max from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select nord_max from communes where Nom_com="Modèle:Communes-infos";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="Modèle:Communes-infos";}}}}
Orthoimage Carte http://gis.pch.etat.lu/arcgis/rest/services/act/ortho2007/MapServer/export?bbox={{#sql2wiki_f:select est_min from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select nord_min from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select est_max from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select nord_max from communes where Nom_com="Modèle:Communes-infos";}}&format=jpeg=&f=image&size={{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="Modèle:Communes-infos";}},{{#sql2wiki_f:select round(extension_est*0.0922+207) from communes where Nom_com="Modèle:Communes-infos";}}}}
Récupérée de « https://www.geologie.lu/geolwiki/index.php?title=Modèle:Communes-infos&oldid=1389 »