Berlin.NABU.de Projekte Stunde der Gartenvögel Ergebnisse
Ergebnisse mit Karte
Warning: pg_query() [function.pg-query]: Query failed: ERROR: could not write to hash-join temporary file: No space left on device in /home/FINAL_RELAUNCH/htdocs/modules/sdg/sqlite.php on line 245
Error in SELECT (SUM(cb.sichtungen) / CAST(720 AS float)) AS pro_garten, SUM(em.vogelfreunde) AS vogelfreunde, SUM(em.vogelfreunde) AS m_vogelfreunde, COUNT(cb.id) AS gaerten, CAST(SUM(cb.sichtungen) AS float4) AS anzahl, 720 AS gartensumme, COUNT(cb.sichtungen) AS gartencounter, 0 AS rangliste, 0 AS vorjahr, 0 AS pro_garten_vorjahr, cb.art FROM checkbirds AS cb LEFT OUTER JOIN melder AS em ON (em.id = cb.melder ) WHERE cb.jahr = 2011 AND cb.moderated = 0 AND cb.kreisid LIKE '11%' AND cb.sichtungen > 0 GROUP BY cb.art ORDER BY pro_garten DESC
ERROR: could not write to hash-join temporary file: No space left on device
array (
0 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/functions.php',
'line' => 469,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'SELECT (SUM(cb.sichtungen) / CAST(720 AS float)) AS pro_garten,
SUM(em.vogelfreunde) AS vogelfreunde,
SUM(em.vogelfreunde) AS m_vogelfreunde,
COUNT(cb.id) AS gaerten,
CAST(SUM(cb.sichtungen) AS float4) AS anzahl,
720 AS gartensumme,
COUNT(cb.sichtungen) AS gartencounter,
0 AS rangliste,
0 AS vorjahr,
0 AS pro_garten_vorjahr,
cb.art
FROM checkbirds AS cb
LEFT OUTER JOIN melder AS em
ON (em.id = cb.melder )
WHERE cb.jahr = 2011
AND cb.moderated = 0
AND cb.kreisid LIKE \'11%\'
AND cb.sichtungen > 0
GROUP BY cb.art
ORDER BY pro_garten DESC',
),
),
1 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/functions.php',
'line' => 474,
'function' => 'dataFunc',
'args' =>
array (
0 => 2011,
1 => '',
2 => '',
3 => 'pro_garten DESC',
),
),
2 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/index.php',
'line' => 111,
'function' => 'getCount',
'args' =>
array (
0 => 2011,
1 => '',
),
),
3 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/berlin.nabu.de/projekte/stundedergartenvoegel/ergebnisse/index.html',
'line' => 279,
'args' =>
array (
0 => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/index.php',
),
'function' => 'include',
),
)
SELECT (SUM(cb.sichtungen) / CAST(720 AS float)) AS pro_garten,
SUM(em.vogelfreunde) AS vogelfreunde,
SUM(em.vogelfreunde) AS m_vogelfreunde,
COUNT(cb.id) AS gaerten,
CAST(SUM(cb.sichtungen) AS float4) AS anzahl,
720 AS gartensumme,
COUNT(cb.sichtungen) AS gartencounter,
0 AS rangliste,
0 AS vorjahr,
0 AS pro_garten_vorjahr,
cb.art
FROM checkbirds AS cb
LEFT OUTER JOIN melder AS em
ON (em.id = cb.melder )
WHERE cb.jahr = 2011
AND cb.moderated = 0
AND cb.kreisid LIKE '11%'
AND cb.sichtungen > 0
GROUP BY cb.art
ORDER BY pro_garten DESC
Warning: pg_query() [function.pg-query]: Query failed: ERROR: could not write to hash-join temporary file: No space left on device in /home/FINAL_RELAUNCH/htdocs/modules/sdg/sqlite.php on line 245
Error in SELECT (SUM(cb.sichtungen) / CAST(683 AS float)) AS pro_garten, SUM(em.vogelfreunde) AS vogelfreunde, SUM(em.vogelfreunde) AS m_vogelfreunde, COUNT(cb.id) AS gaerten, CAST(SUM(cb.sichtungen) AS float4) AS anzahl, 683 AS gartensumme, COUNT(cb.sichtungen) AS gartencounter, 0 AS rangliste, 0 AS vorjahr, 0 AS pro_garten_vorjahr, cb.art FROM checkbirds AS cb LEFT OUTER JOIN melder AS em ON (em.id = cb.melder ) WHERE cb.jahr = 2010 AND cb.moderated = 0 AND cb.kreisid LIKE '11%' AND cb.sichtungen > 0 GROUP BY cb.art ORDER BY pro_garten DESC
ERROR: could not write to hash-join temporary file: No space left on device
array (
0 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/functions.php',
'line' => 469,
'function' => 'serendipity_db_query',
'args' =>
array (
0 => 'SELECT (SUM(cb.sichtungen) / CAST(683 AS float)) AS pro_garten,
SUM(em.vogelfreunde) AS vogelfreunde,
SUM(em.vogelfreunde) AS m_vogelfreunde,
COUNT(cb.id) AS gaerten,
CAST(SUM(cb.sichtungen) AS float4) AS anzahl,
683 AS gartensumme,
COUNT(cb.sichtungen) AS gartencounter,
0 AS rangliste,
0 AS vorjahr,
0 AS pro_garten_vorjahr,
cb.art
FROM checkbirds AS cb
LEFT OUTER JOIN melder AS em
ON (em.id = cb.melder )
WHERE cb.jahr = 2010
AND cb.moderated = 0
AND cb.kreisid LIKE \'11%\'
AND cb.sichtungen > 0
GROUP BY cb.art
ORDER BY pro_garten DESC',
),
),
1 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/functions.php',
'line' => 475,
'function' => 'dataFunc',
'args' =>
array (
0 => 2010,
1 => '',
2 => '',
3 => 'pro_garten DESC',
),
),
2 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/index.php',
'line' => 111,
'function' => 'getCount',
'args' =>
array (
0 => 2011,
1 => '',
),
),
3 =>
array (
'file' => '/home/FINAL_RELAUNCH/htdocs/berlin.nabu.de/projekte/stundedergartenvoegel/ergebnisse/index.html',
'line' => 279,
'args' =>
array (
0 => '/home/FINAL_RELAUNCH/htdocs/modules/sdg/index.php',
),
'function' => 'include',
),
)
SELECT (SUM(cb.sichtungen) / CAST(683 AS float)) AS pro_garten,
SUM(em.vogelfreunde) AS vogelfreunde,
SUM(em.vogelfreunde) AS m_vogelfreunde,
COUNT(cb.id) AS gaerten,
CAST(SUM(cb.sichtungen) AS float4) AS anzahl,
683 AS gartensumme,
COUNT(cb.sichtungen) AS gartencounter,
0 AS rangliste,
0 AS vorjahr,
0 AS pro_garten_vorjahr,
cb.art
FROM checkbirds AS cb
LEFT OUTER JOIN melder AS em
ON (em.id = cb.melder )
WHERE cb.jahr = 2010
AND cb.moderated = 0
AND cb.kreisid LIKE '11%'
AND cb.sichtungen > 0
GROUP BY cb.art
ORDER BY pro_garten DESC
Beobachtungen Rabenkrähe - Berlin 2011
In Bundesland Berlin wurden in 720 Gärten 76 Vögel gezählt.
Bitte auswählen:
Anzahl der Vögel pro Garten
In Bundesland Berlin wurden in 720 Gärten 76 Vögel gezählt. 1066 Vogelfreunde haben dort folgende Beobachtungen gemacht:
| Rang | Vogelart | ∅ Beobachtung (Anzahl der Vögel pro Garten) |
Anzahl der Vögel (gesamt) |
Vergleich zum Vorjahr (Anzahl der Vögel pro Garten) |
Trend |
|---|
Veranstaltungen Juni bis August
Das Veranstaltungsprogramm aus "Natur in Berlin" Heft 2/2013 zum Download. Mehr
Veranstaltungen März bis Mai
Das Veranstaltungsprogramm aus "Natur in Berlin" Heft 1/2013 zum Download. Mehr
Naturschutzjugend Berlin
Die NAJU hat super Angebote für junge Menschen, wie die AG Umweltpolitik, eine Jugendgruppe, Kindergruppen oder einen Naturerlebnisgarten. Mehr
Mitgliederservice
Für Fragen um Ihre Mitgliedschaft steht Ihnen der NABU-Mitglieder- service gerne zur Verfügung:
Service@NABU.de
Tel. 030.28 49 84-40 00
'NATURSCHUTZ AM HAUS'
Broschüre hier als PDF (1,8 MB) runterladen. Mehr