Template:Info for goat number

From MediaWiki

(Difference between revisions)
Jump to: navigation, search
(`Sex` —> `Gender`)
Line 46: Line 46:
</div>
</div>
|}
|}
-
=Statistics for goat #{{{1}}}, {{#tag:mysqlinline|SELECT CONCAT(Breed, ' ', Sex, ': ', name) FROM s_animals WHERE ID={{{1}}}|database=EcoReality|}}=
+
=Statistics for goat #{{{1}}}, {{#tag:mysqlinline|SELECT CONCAT(Breed, ' ', Gender, ': ', name) FROM s_animals WHERE ID={{{1}}}|database=EcoReality|}}=
{{#tag:mysqlinline|SELECT Description FROM s_animals WHERE ID={{{1}}}|database=EcoReality|}}
{{#tag:mysqlinline|SELECT Description FROM s_animals WHERE ID={{{1}}}|database=EcoReality|}}

Revision as of 05:54, 12 June 2019

Usage

This template is used to display various information for a goat.

It is typically placed on pages named like "Dairy production/5", in the following manner: {{info for goat number|{{SUBPAGENAME}}}}.

Parameters

  1. the ID number of the goat information to be displayed.

Example

as entered
{{info for goat number|15}}
as displayed

Statistics for goat #15, Nubian female: Taara

Dark brown with white star on forehead

Photo

Provenance

BreedBirth dateBirth weightDispositionDisposition dateDescriptionSireDam
Nubian2011-05-16 16:00:003.100owned0000-00-00Dark brown with white star on foreheadLincoln (Nubian)Shakti (Sable)

Kids

KidGenderBirth dateBirth weightSireDamDispositionDisposition dateDescription
(unnamed) (Nubian)male2013-04-25 09:30:003.400Zuciana (Sable)Taara (Nubian)sold2013-06-30black back with white and brown, white star, brown socks
(unnamed) (Nubian)male2013-04-25 09:30:003.200Zuciana (Sable)Taara (Nubian)sold2013-06-22black with white belly extending up and back
(unnamed) (Nubian)male2014-08-15 14:30:002.890Murkha (Nubian)Taara (Nubian)sold2014-11-26Grizzled black with white band.
Odie (Nubian)female2014-08-15 14:30:002.860Murkha (Nubian)Taara (Nubian)sold2015-03-16White head, tan socks, white belly.
(unnamed) (Lamancha)female2015-05-22 20:07:002.510Titan (Lamancha)Taara (Nubian)died2015-05-24brown with white and black points
[Taara-Titan] (Lamancha)neutered2016-04-23 13:20:003.410Titan (Lamancha)Taara (Nubian)sold2017-01-20Deer coloured
Stubby (Lamancha)female2016-04-23 13:25:003.330Titan (Lamancha)Taara (Nubian)owned0000-00-00Deer coloured, lighter than brother, with white on face
[Taara-Bucky] (Nubian)male2017-04-02 08:00:002.800Bucky (Nubian)Taara (Nubian)sold2018-02-27Brown/black with white star
[Taara-Bucky] (Nubian)male2017-04-02 08:00:002.400Bucky (Nubian)Taara (Nubian)sold2018-02-27Brown/black
Shy (Nubian)female2017-04-02 08:00:002.300Bucky (Nubian)Taara (Nubian)owned0000-00-00Brown with a bit of white
[Taara-Bucky] (Nubian)female2018-01-24 10:30:002.610Bucky (Nubian)Taara (Nubian)sold2018-04-22Nubian ears, chocolate with black socks, slash on left rear leg
[Taara-Bucky 2] (Nubian)doe2019-03-17 16:00:003.060Bucky (Nubian)Taara (Nubian)owned0000-00-00dark brown with black points, Nubian ears
[Taara-Bucky] (Nubian)doe2019-03-17 16:05:002.880Bucky (Nubian)Taara (Nubian)owned0000-00-00medium brown with grey spots, Nubian ears

Production

by year

2007200820092010201120122013201420152016201720182019TotalUnits
217.50111.95164.82376.72361.99379.28109.711,721.96kilograms

by month

Month2007200820092010201120122013201420152016201720182019TotalUnits
January20.289.9227.716.6564.57kilograms
February20.800.4623.2044.46kilograms
March3.5131.9735.49kilograms
April5.1138.4910.7954.38kilograms
May7.4046.8226.9144.840.99126.96kilograms
June19.4722.8837.4330.7341.3919.73171.63kilograms
July48.6010.5751.8845.3445.7636.45238.61kilograms
August43.630.1431.1862.9970.6843.6126.12278.36kilograms
September36.218.5537.2862.1559.4635.9715.63255.25kilograms
October26.8011.2424.6248.3342.0536.78189.82kilograms
November20.8919.7218.7632.9531.5224.25148.08kilograms
December21.8827.712.2229.0627.136.37114.37kilograms

First/Last by Year

YearFirstLastDayskgPer DayHarvestsPer Harvest
2013Jun 10Dec 31205217.4991.0613990.545
2014Jan 1Dec 31365111.9480.3072950.379
2015Jan 1Dec 10344164.8180.4793340.493
2016Apr 26Dec 31250376.7181.5074220.893
2017Jan 1Dec 31365361.9880.9924790.756
2018Jan 1Dec 12346379.2831.0966610.574
2019Apr 16Sep 16154109.7080.7121950.563

Milker by year

IDHarvester2007200820092010201120122013201420152016201720182019TotalUnits
2Steinman, Jan159.6579.67120.68223.91243.31257.1188.981,173.30kilograms
3Rowe, Cleome0.1113.388.3721.86kilograms
212Corno, Ben0.570.270.84kilograms
216Raginsky, Sofya0.080.360.44kilograms
231Morrow, Geo6.536.53kilograms
359Ada, Ronald16.4016.40kilograms
364Ross, Mindy40.2940.29kilograms
367Adams, Landis0.400.40kilograms
370Todd, Sylvain7.047.04kilograms
374Goodsir, Clover0.860.86liters
393Christensen, Camilla1.241.24kilograms
394Valleé, Steven23.3723.37kilograms
403Kyomugisha-Perry, Grace0.330.33kilograms
405Hamilton, Kelvin1.060.891.94kilograms
423Al-Zeer, Bader0.560.56kilograms
424Fontana, Andrea1.021.02kilograms
425Solow, Neel4.444.44kilograms
426Reesor, Natasha11.8211.82kilograms
431Re, Kate5.715.71kilograms
435Peters, Jon0.800.80kilograms
436Canabe, Barbara6.776.77kilograms
437Canabe, Danny5.285.28kilograms
438Vargas, Elisabeth1.861.86kilograms
446Smith, Joel5.555.55kilograms
459Kats, Anton4.264.26kilograms
471Phipps, Joan1.391.39kilograms
473Strong, Christopher146.11146.11kilograms
500Stephenson, Kate14.741.8016.54kilograms
504Hyatt, Vienna29.9929.99kilograms
508Cox, John4.314.31kilograms
509Lloyd, Alexander7.527.52kilograms
510Bevilacqua, Gaia3.053.05kilograms
515Klein, Philipp33.019.3142.33kilograms
518Dekens, Leonard18.6539.822.2760.74liters
520Medina, Sergio2.692.69liters
522Harel, Xavier0.610.61liters
523Gasulla, Maties1.231.23liters
529Chisholm, Lauren30.2530.25liters
539Rass, Lena12.6712.67liters
540Bourasseau, Ann-Sophie2.172.17liters
543, James1.561.56kilograms
544Röttgers, Bruce3.913.91kilograms
548Pitkethly, Andrea0.700.70kilograms
549Pitkethly, Jase1.201.20kilograms
573Mittendorf, Greta8.718.71kilograms
574Gillard, Matthiew1.391.39kilograms
TOTAL:Gillard, Matthiew217.50111.95164.82376.72361.99379.28109.711,721.96kilograms

Records

1 to 11 of 55 [1] 2 3 4 5 6
datetypenote
2019-09-13experimentAdded about 5cc diotomaceous earth to feed to help ward off intestinal parasites. Given to all seven current milkers: Shy, Right, Taara, Friendly, Stubby, Whitey, and Sazmaz.
2019-09-01wormedscouring; wormwood in feed
2019-08-31wormedscouring; 3ml fenbenzidole drench, 12.5ml eprinomectin transdermally, wormwood, black oil sunflower seeds
2019-07-19trim hooves
2019-06-25trim hooves
2019-04-28wormed7cc moxidectin transdermally
2019-04-22trim hooves
2019-04-20wormed20cc Eprinomectin transdermally
2018-12-03trim hooves
2018-10-15heatbred to Bucky
1 to 11 of 55 [1] 2 3 4 5 6

EXPERIMENTAL STUFF

The extension MySQL needs to be turned into a parser function first, so that gender-specific statistics can be presented in a reasonable way. (We don't really want to know how much milk we got out of a buck, for example.)

Sex of this animal is: {{#mysqlinline:SELECT Sex FROM s_animals WHERE ID=15|database=EcoReality}} .

The sex of this animal is not defined.

The sex of this animal is undefined.

See also

See Also

Template

Share your opinion


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

disturbance
entry points
help (off site)
Environmental jobs, green volunteering, good work! 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