Upload – Farm Pads & Evacuation Routes 05042015

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.wa.gov
Id 56tp-5t8v
Name Upload – Farm Pads & Evacuation Routes 05042015
Created 2015-04-29T17:42:58Z
Publication Date 2015-05-05T13:15:18Z

Columns

| Included | Schema Type    | Field Name                 | Name                           | Data Type | Render Type |
| ======== | ============== | ========================== | ============================== | ========= | =========== |
| No       | time           | :updated_at                | updated_at                     | meta_data | meta_data   |
| Yes      | series tag     | phase                      | Phase                          | text      | text        |
| Yes      | series tag     | landowner                  | Landowner                      | text      | text        |
| Yes      | numeric metric | total_value_2015           | Total Value Protected ($9.30M) | money     | money       |
| Yes      | numeric metric | ind_value_2015             | Ind. Value (2015)              | money     | money       |
| Yes      | numeric metric | total_livestock_value_2015 | Livestock Protected ($7.95M)   | money     | money       |
| Yes      | numeric metric | total_livestock            | Total Livestock #              | number    | number      |
| Yes      | numeric metric | ind_livestock_value_2015   | Ind. Livestock Value (2015)    | money     | money       |
| Yes      | series tag     | ind_livestock              | Ind. Livestock #               | text      | text        |
| Yes      | numeric metric | total_equip_value_2015     | Equipment Protected ($1.35M)   | money     | money       |
| Yes      | numeric metric | total_equip                | Total Equip. #                 | number    | number      |
| Yes      | numeric metric | ind_equip_value_2015       | Ind. Equip. Value (2015)       | money     | money       |
| Yes      | series tag     | ind_equip                  | Ind. Equip. #                  | text      | text        |
| Yes      | numeric metric | total_expended             | Total $$ Expended              | money     | money       |
| Yes      | numeric metric | ind_expended               | Ind. $$ Expended               | money     | money       |

Time Field

Value = updated_at
Format & Zone = seconds

Data Commands

series e:56tp-5t8v d:2015-05-05T05:28:30.000Z t:landowner="Balmelli-Powe, Julie" t:ind_equip=0 t:ind_livestock="20 cows - 20 calves" t:phase="Phase I -- Completed (K1129)" m:ind_livestock_value_2015=80000 m:total_expended=9302.16 m:ind_equip_value_2015=0 m:ind_value_2015=80000

series e:56tp-5t8v d:2015-05-05T05:28:30.000Z t:landowner="Brunoff, John" t:ind_equip=0 t:ind_livestock="200 cows" t:phase="Phase I -- Completed (K1129)" m:ind_livestock_value_2015=600000 m:total_expended=67240.14 m:ind_equip_value_2015=0 m:ind_value_2015=600000

series e:56tp-5t8v d:2015-05-05T05:28:30.000Z t:landowner="Dykstra, Pete" t:ind_equip=0 t:ind_livestock="60 cows - 20 heifers" t:phase="Phase I -- Completed (K1129)" m:ind_livestock_value_2015=220000 m:total_expended=52318.07 m:ind_equip_value_2015=0 m:ind_value_2015=220000

Meta Commands

metric m:total_value_2015 p:integer l:"Total Value Protected ($9.30M)" t:dataTypeName=money

metric m:ind_value_2015 p:double l:"Ind. Value (2015)" t:dataTypeName=money

metric m:total_livestock_value_2015 p:integer l:"Livestock Protected ($7.95M)" t:dataTypeName=money

metric m:total_livestock p:integer l:"Total Livestock #" t:dataTypeName=number

metric m:ind_livestock_value_2015 p:double l:"Ind. Livestock Value (2015)" t:dataTypeName=money

metric m:total_equip_value_2015 p:double l:"Equipment Protected ($1.35M)" t:dataTypeName=money

metric m:total_equip p:integer l:"Total Equip. #" t:dataTypeName=number

metric m:ind_equip_value_2015 p:double l:"Ind. Equip. Value (2015)" t:dataTypeName=money

metric m:total_expended p:double l:"Total $$ Expended" t:dataTypeName=money

metric m:ind_expended p:double l:"Ind. $$ Expended" t:dataTypeName=money

entity e:56tp-5t8v l:"Upload -- Farm Pads & Evacuation Routes 05042015" t:url=https://data.wa.gov/api/views/56tp-5t8v

property e:56tp-5t8v t:meta.view v:id=56tp-5t8v v:averageRating=0 v:name="Upload -- Farm Pads & Evacuation Routes 05042015"

property e:56tp-5t8v t:meta.view.owner v:id=ugen-sv2k v:screenName=Scott v:displayName=Scott

property e:56tp-5t8v t:meta.view.tableauthor v:id=ugen-sv2k v:screenName=Scott v:roleName=publisher v:displayName=Scott

Top Records

| :updated_at | phase                                            | landowner            | total_value_2015 | ind_value_2015 | total_livestock_value_2015 | total_livestock | ind_livestock_value_2015 | ind_livestock         | total_equip_value_2015 | total_equip | ind_equip_value_2015 | ind_equip             | total_expended | ind_expended | 
| =========== | ================================================ | ==================== | ================ | ============== | ========================== | =============== | ======================== | ===================== | ====================== | =========== | ==================== | ===================== | ============== | ============ | 
| 1430803710  | Phase I -- Completed (K1129)                     | Balmelli-Powe, Julie |                  | 80000          |                            |                 | 80000                    | 20 cows - 20 calves   |                        |             | 0.0                  | 0                     | 9302.16        |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Brunoff, John        |                  | 600000         |                            |                 | 600000                   | 200 cows              |                        |             | 0.0                  | 0                     | 67240.14       |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Dykstra, Pete        |                  | 220000         |                            |                 | 220000                   | 60 cows - 20 heifers  |                        |             | 0.0                  | 0                     | 52318.07       |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Gregory, Brad        |                  | 28875          |                            |                 | 28875                    | 105 sheep             |                        |             | 0.0                  | 0                     | 11455.48       |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Kesting, John        |                  | 1350000        |                            |                 | 1350000                  | 450 cows              |                        |             | 0.0                  | 0                     | 95028.32       |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Larson, Bob          |                  | 825000         |                            |                 | 825000                   | 225 cows - 75 heifers |                        |             | 0.0                  | 0                     | 130387.54      |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Lawton, Terry        |                  | 700000         |                            |                 | 700000                   | 350 heifers           |                        |             | 0.0                  | 0                     | 91894.24       |              | 
| 1430803710  | Phase I -- Completed (K1129)                     | Total-->             | 3803875          |                | 3803875                    | 1525            |                          |                       | 0.0                    | 0           |                      |                       |                |              | 
| 1430803710  | Phase II -- Completed/Underway (K1493 and K1494) | Balmelli, Joe        |                  | 1975000        |                            |                 | 1725000                  | 525 cows - 100 calves |                        |             | 250000               | 4 tractors - 5 pieces | 1579.51        |              | 
| 1430803710  | Phase II -- Completed/Underway (K1493 and K1494) | Dolowy, Cynthia      |                  | 0.0            |                            |                 | 0.0                      | 9 horses              |                        |             | 0.0                  | 0                     | 1416.4         |              |