> 2016 produce survey - MediaWiki

2016 produce survey

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
 
Line 1: Line 1:
==Summary==
==Summary==
* As of: '''{{#tag:mysqlinline|SELECT `Date` FROM SSIAA.Questionares ORDER BY `Date` DESC LIMIT 1|database=EcoReality}}'''
* As of: '''{{#tag:mysqlinline|SELECT `Date` FROM SSIAA.Questionares ORDER BY `Date` DESC LIMIT 1|database=EcoReality}}'''
-
* Surveys complete: '''{{#tag:mysqlinline|SELECT COUNT(*) FROM SSIAA.Questionares WHERE NOT ISNULL(Is_commercial_grower)|database=EcoReality}}'''
+
* Surveys complete: '''{{#tag:mysqlinline|SELECT COUNT(*) FROM SSIAA.Questionares WHERE NOT Is_commercial_grower = 'Yes'|database=EcoReality}}'''
* Number of separate crops grown: '''{{#tag:mysqlinline|SELECT COUNT(*) FROM SSIAA.Per_Crop_Statistics|database=EcoReality}}.'''
* Number of separate crops grown: '''{{#tag:mysqlinline|SELECT COUNT(*) FROM SSIAA.Per_Crop_Statistics|database=EcoReality}}.'''
* Produce production: '''{{#tag:mysqlinline|SELECT FORMAT(SUM(Kilograms), 2) FROM SSIAA.Questionare_Crop|database=EcoReality}} kilograms'''
* Produce production: '''{{#tag:mysqlinline|SELECT FORMAT(SUM(Kilograms), 2) FROM SSIAA.Questionare_Crop|database=EcoReality}} kilograms'''

Latest revision as of 10:41, 13 March 2017

Summary

  • As of: 2017-03-27 19:13:34
  • Surveys complete: 15
  • Number of separate crops grown: 86 .
  • Produce production: 68,769.03 kilograms
  • Average per-crop production: 9.90 kilograms
  • Area in produce production: 138,574.86 square metres
  • Average per-crop area: 19.94 square metres
  • Gross areal productivity: 0.496 kilograms per square metre

Anomalies: a few fams reported area planted without reporting yield. Others reported yield without reporting area planted. This can result in crazy statistics like 86 kilograms of celery per square metre, for which one farm only reported area and another farm reported only yield. For final results, we should either exclude produce that lacks one or the other metric, or assign missing metrics based on island averages or industry standards.

Per-Crop Totals

Click on the triangles in column headers to sort by that column.

IDCropFarmsMetres2KilogramsAreal Productivity
1apples1030,540.7111,020.360.361
110arugula160.3938.180.632
30asparagus3229.0147.730.208
26basil5419.3042.330.101
79beans2497.59418.180.840
64beans, chick peas18.360.910.109
67beans, dry non-white283.6133.090.396
66beans, dry white10.0010.00
73beans, green4167.23182.641.092
20beans, string11.7012.817.520
13beets7637.041,211.821.902
17berries, blackberry14,046.8668.180.017
44berries, blueberries34,074.73477.270.117
27berries, goji10.934.434.768
104berries, Japanese silverberry10.932.993.224
105berries, Peruvian goldenberry10.702.874.119
50berries, raspberries3412.12122.730.298
51berries, strawberries5351.92566.361.609
106berries, sunberry10.702.683.842
76bok choi10.0096.00
31brassicas169.68136.361.957
89broccoli227.87118.184.240
111broccoli, purple sprouting192.900.000.000
78brussel sprouts2101.17122.091.207
32cabbage5612.601,613.642.634
74cabbage, Napa10.00490.91
25carrots8897.944,765.035.307
90cauliflower2101.17102.271.011
84celery21.67144.0086.111
21celery, leaf10.857.258.513
33chard429.03350.3612.068
46cherries221.092.850.135
34corn4631.651,227.911.944
114corn, sweet124,281.1415,272.730.629
8cucumbers6645.771,786.902.767
47currants118.580.000.000
107dill, weed10.371.233.310
91eggplant2405.06138.860.343
81fennel, bulb10.283.0110.800
63flax seed11.670.910.544
18garlic72,662.14681.820.256
101garlic, scapes113.949.740.699
49grapes, table13.720.000.000
48grapes, wine13.720.000.000
109ground cherries2134.71180.001.336
68hazelnuts19.290.450.049
14herbs21,034.9422.730.022
112hops10.00197.20
102jaltomato10.854.705.513
19kale6213.56805.043.770
103lavender florets11.113.933.530
35leeks4223.25374.451.677
98lettuce2809.37595.450.736
95melon210.9913.361.216
22melon, canteloupe1139.35159.091.142
3mixed vegetables10.0045.45
5mouse mellons12.0415.567.615
108nettle118.5822.101.189
57oats120,234.28909.090.045
36onions133.450.000.000
93onions, shallots10.0049.09
99parsley3244.5242.100.172
37parsnips1404.69136.360.337
7pears55,051.322,130.680.422
43pears, asian118.580.000.000
38peas5580.27324.090.559
86peppers3644.19170.450.265
10peppers, hot123.5055.972.381
29peppers, savory15.113.590.703
16plums3634.90180.000.284
9potatoes92,594.698,410.343.241
100pumpkins28,296.061,568.180.189
77radish3244.15466.361.910
52rhubarb2205.1327.270.133
2rutabega/turnip4627.93791.361.260
60rye, fall120,234.280.000.000
4salad crops5433.491,306.963.015
62soybeans15.574.550.815
94spinach3244.15253.181.037
87squash2328.471,163.643.543
39squash, winter3123.10681.825.539
12tomatillos10.8438.3545.872
6tomatoes101,644.484,450.062.706
69walnuts19.299.090.979
96wheat18.367.270.870
15zucchini551.411,314.0325.562

Share your opinion


blog comments powered by Disqus
Personal tools
Get our newsletter!
Name:
Email Address:

disturbance
entry points
help (off site)
Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro