Crop plant growth potential forecasts / Tickets / #14 Import agricultural data into the Swedish database

#14 Import agricultural data into the Swedish database

Milestone: 1.0

Status: open

Owner: Michael Zaiets

Labels: None

Updated: 2020-11-22

Created: 2020-07-28

Creator: Thiemo Kellner

Private: No

length of required growing season, see also https://en.wikipedia.org/wiki/Growing_season
required growing degree days and its calculation algorithm, see also https://en.wikipedia.org/wiki/Growing_degree-day based on 5 °C
frost tolerance (temperature, duration, number of occurrence, season i.e. spring/autumn), see also https://en.wikipedia.org/wiki/Frost#Effect_on_plants
watering needs

Plant list

strawberry
raspberry
bramble
red currant
black currant
gooseberry
cloudberry
blueberry
kiwi
chokeberry
pumpkin
watermelon
muskmelon like piel de sapo
grape
banana
pineapple
French bean
climbing bean
bush bean
borlotti bean
kidney bean
tic bean
lentil
chickpea
cucumber
tomato
aubergine/eggplant
zucchini
radish
sweet potato
potato
wheat
einkorn wheat
spealt
rye
barley
oat
maize
chicory
lamb's lettuce
lettuce
rocket (Eruca sativa)
endive
watercress
spinach
lemon balm
mint
coriander
tarragon
dill
parsley
basil
savory
sage
rosemary
thyme
oregano
lovage
chives
ramson
leek
garlic
onion
hazel
sweet pepper
paprika/chilli
fennel
celeriac
celery
beetroot
carrot
sugar beet
May turnip
turnip cabbage/kohlrabi
white/green cabbage
red cabbage
broccoli
romanesco
cauliflower
Brussels sprout
colewort
Chinese cabbage
European beech tree
birch tree
oak tree
elm tree
ash tree
willow tree
spruce tree
silver fir tree
apple tree
pear tree
plum tree
greengage tree
mirabell tree
apricot tree
peach tree
nectarine tree
almond tree
citrus tree
olive tree
avocado tree
walnut tree
sweet chestnut tree

Discussion

Thiemo Kellner - 2020-07-31

https://sourceforge.net/p/cpgpf/code/HEAD/tree/trunk/common/agriculture/ sports code to create DB table and GDD calculation functions in PostgreSQL (via psql) and a starting point for data aquiry

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Thiemo Kellner - 2020-07-31

assigned_to: Michael Zaiets
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Description has changed:

Diff:

--- old
+++ new
@@ -1,5 +1,5 @@

 * length of required growing season, see also https://en.wikipedia.org/wiki/Growing_season
-* required growing degree days and its calculation algorithm, see also https://en.wikipedia.org/wiki/Growing_degree-day
+* required growing degree days and its calculation algorithm, see also https://en.wikipedia.org/wiki/Growing_degree-day based on 5 °C
 * frost tolerance (temperature, duration, number of occurrence, season i.e. spring/autumn), see also https://en.wikipedia.org/wiki/Frost#Effect_on_plants
 * watering needs

Import agricultural data into the Swedish database

Unite map data with climate and agricultural data

Milestone

Searches

Help

#14 Import agricultural data into the Swedish database

Discussion