http://solab.eu/solab/index.php?action=history&feed=atom&title=Tst
Tst - Revision history
2026-05-10T21:49:17Z
Revision history for this page on the wiki
MediaWiki 1.44.2
http://solab.eu/solab/index.php?title=Tst&diff=74516&oldid=prev
Gio at 18:30, 7 May 2024
2024-05-07T18:30:56Z
<p></p>
<p><b>New page</b></p><div>{{#gioext: mssql |mssql| dummy | <br />
SELECT TOP (100) <br />
-- concat ('Power::', electrical_capacity, ' MW') Power<br />
electrical_capacity<br />
,production<br />
--,concat ('Energy::', production, ' MWh') Energy<br />
--,[energy_source_level_1] Cat<br />
,[energy_source_level_2] Cat<br />
--,[energy_source_level_3]<br />
,[technology]<br />
--,[data_source]<br />
--,[nuts_1_region]<br />
--,[nuts_2_region]<br />
--,[nuts_3_region]<br />
,concat( '', [lat] ,',', [lon] ) has_coordinates<br />
<br />
-- ,concat( 'has_coordinates::', [lat] ,',', [lon] ) has_coordinates<br />
--,[municipality]<br />
-- ,[municipality_code]<br />
-- ,[postcode]<br />
--,[address]<br />
,[canton]<br />
--,[commissioning_date]<br />
--,[contract_period_end]<br />
,[company]<br />
--,[tariff]<br />
,[project_name]<br />
FROM [Solab].[IMPORT].[renewable_power_plants_CH]<br />
|all<br />
}}</div>
Gio