trees
3,709 rows where qSpecies_id = 9 sorted by PlotSize
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67 | 99921 | Section 806 (d) 5 | Olea europaea :: Olive Tree 9 | 1740 Jones St | 1 | Front Yard : Yard | Tree | Private 2 | 06/01/2015 12:00:00 AM | 3 | Permit Number 774389 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | 5 | 1 | 10 | 308 | 21 | ||
| 304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 | ||||
| 357 | 232461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.429928614715 | (37.7346701778724, -122.429928614715) | 2 | 7 | 5 | 63 | 7 | ||||
| 580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
| 1005 | 39481 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 1196 | 41203 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41910 | 5993961.82877 | 2115413.43591 | 37.7881743948276 | -122.464723766289 | (37.7881743948276, -122.464723766289) | 11 | 6 | 1 | 54 | 11 | ||
| 1220 | 75333 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984432.92075 | 2112122.55763 | 37.7785846311766 | -122.497448611437 | (37.7785846311766, -122.497448611437) | 11 | 6 | 2 | 55 | 26 | |||
| 1262 | 47855 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1339 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45614 | 5982734.7831 | 2106002.3859 | 37.7616807275351 | -122.502869846098 | (37.7616807275351, -122.502869846098) | 1 | 8 | 3 | 56 | 35 | |
| 1281 | 78213 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 718 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011018.02822 | 2091413.5341 | 37.7232445529643 | -122.40402226092 | (37.7232445529643, -122.40402226092) | 10 | 3 | 7 | 309 | 28 | |||
| 1512 | 177963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5988967.05933 | 2088996.09626 | 37.7153501871281 | -122.480070526755 | (37.7153501871281, -122.480070526755) | 1 | 8 | 4 | 64 | 14 | ||||
| 1571 | 56051 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 49 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1973 12:00:00 AM | 36 | Permit Number 12140 | 6003182.54972715 | 2108023.57751638 | 37.7684109649411 | -122.43229368198 | (37.7684109649411, -122.43229368198) | 15 | 5 | 5 | 28862 | 3 | ||
| 1662 | 30844 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 9 | Permit Number 34692 | 5999056.13874 | 2115758.23439 | 37.7894135017764 | -122.447123215185 | (37.7894135017764, -122.447123215185) | 13 | 6 | 1 | 29490 | 31 | |
| 1732 | 74552 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986706.7381 | 2102298.6623 | 37.7517439532499 | -122.488860374683 | (37.7517439532499, -122.488860374683) | 1 | 8 | 3 | 29491 | 35 | |||
| 1910 | 78533 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 240 Wayland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6010784.93141 | 2092430.64312 | 37.7260242971617 | -122.404899612537 | (37.7260242971617, -122.404899612537) | 10 | 3 | 7 | 309 | 28 | |||
| 2003 | 56319 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 255 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 11 | Permit Number 12454 | 5993047.12459 | 2113743.61417 | 37.7835367452404 | -122.467766966515 | (37.7835367452404, -122.467766966515) | 11 | 6 | 2 | 54 | 11 | ||
| 2011 | 264734 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1364 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006427.83864 | 2119405.514 | 37.7998464469137 | -122.42187710854 | (37.7998464469137, -122.42187710854) | 13 | 9 | 1 | 28858 | 32 | |||||
| 2288 | 50724 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2004 12:00:00 AM | 2 | Permit Number 47275 | 6001439.94101 | 2119110.04202 | 37.798752603299 | -122.439115871123 | (37.798752603299, -122.439115871123) | 13 | 9 | 1 | 57 | 17 | |
| 2359 | 35980 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 349 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39134 | 6006399.96537133 | 2097866.62265006 | 37.740704214618 | -122.420443871581 | (37.740704214618, -122.420443871581) | 2 | 7 | 7 | 28859 | 2 | ||
| 2530 | 69848 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 731 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6001876.24877 | 2089667.33696 | 37.7179348800801 | -122.43549873219 | (37.7179348800801, -122.43549873219) | 9 | 7 | 6 | 28861 | 5 | |||
| 2557 | 63304 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 359 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 10 | Permit Number 23870 | 6006863.90683 | 2092790.57723 | 37.7267926428583 | -122.418479889853 | (37.7267926428583, -122.418479889853) | 9 | 3 | 7 | 309 | 5 | |
| 2601 | 71109 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004811.8428 | 2113348.9801 | 37.7831254666613 | -122.427037449556 | (37.7831254666613, -122.427037449556) | 7 | 9 | 11 | 28858 | 41 | |||
| 2693 | 72299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 790 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011682.79959 | 2109646.37516 | 37.7733451034182 | -122.403006076485 | (37.7733451034182, -122.403006076485) | 14 | 2 | 9 | 28853 | 34 | |||
| 2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
| 2818 | 38377 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3815 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 2 | Permit Number 40436 | 5982149.2806 | 2102814.4314 | 37.7528930799905 | -122.504658614747 | (37.7528930799905, -122.504658614747) | 1 | 8 | 3 | 56 | 35 | |
| 2873 | 73548 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1707 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000544.9075 | 2114594.6979 | 37.7863036820207 | -122.441888712315 | (37.7863036820207, -122.441888712315) | 13 | 6 | 1 | 29490 | 27 | |||
| 2927 | 35280 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 2947 | 35356 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 578 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38818 | 6011762.62224 | 2105687.97943 | 37.7624807004553 | -122.402451565313 | (37.7624807004553, -122.402451565313) | 8 | 3 | 8 | 28856 | 29 | |
| 2981 | 70375 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1590 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983148.8552 | 2104320.0131 | 37.757085733924 | -122.501313312685 | (37.757085733924, -122.501313312685) | 1 | 8 | 3 | 56 | 35 | |||
| 3001 | 80365 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 Campbell Ave | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 1 | 6010298.58269 | 2088549.93008 | 37.7153414628213 | -122.406307590233 | (37.7153414628213, -122.406307590233) | 9 | 7 | 8 | 309 | 39 | |||
| 3293 | 74706 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986691.3356 | 2102298.6623 | 37.7517430543366 | -122.488913637871 | (37.7517430543366, -122.488913637871) | 1 | 8 | 3 | 29491 | 35 | |||
| 3338 | 83763 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 361 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | Permit Number 776681 | 5993691.54318 | 2113064.28499 | 37.7817086802882 | -122.465488178701 | (37.7817086802882, -122.465488178701) | 11 | 6 | 2 | 54 | 11 | ||
| 3400 | 71791 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 470 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6011261.07929 | 2119033.68709 | 37.7990968853742 | -122.405126006053 | (37.7990968853742, -122.405126006053) | 3 | 1 | 10 | 308 | 23 | |||
| 3619 | 55603 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 655 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1973 12:00:00 AM | 2 | Permit Number 11578 | 5982556.76294 | 2111288.67841 | 37.7761848980348 | -122.503877074189 | (37.7761848980348, -122.503877074189) | 11 | 6 | 2 | 55 | 26 | ||
| 3657 | 78310 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.431766435094 | (37.7202236600817, -122.431766435094) | 9 | 7 | 6 | 28861 | 5 | |||
| 3791 | 84239 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 477 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988082.61952 | 2112758.69748 | 37.7805445336829 | -122.484869743283 | (37.7805445336829, -122.484869743283) | 11 | 6 | 2 | 55 | 26 | |||
| 4025 | 73557 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 734 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 5982628.31308 | 2110748.29603 | 37.7747053725117 | -122.503589540533 | (37.7747053725117, -122.503589540533) | 11 | 6 | 2 | 55 | 26 | |||
| 4203 | 72834 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015894.43243 | 2105382.09889 | 37.7618706120468 | -122.388139674229 | (37.7618706120468, -122.388139674229) | 10 | 3 | 8 | 28856 | 29 | |||
| 4405 | 78800 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000803.49845 | 2087336.82758 | 37.7114748366708 | -122.439039819944 | (37.7114748366708, -122.439039819944) | 9 | 7 | 6 | 28861 | 5 | |||
| 4553 | 74059 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6015912.53475 | 2105383.55959 | 37.7618756257676 | -122.388077166837 | (37.7618756257676, -122.388077166837) | 10 | 3 | 8 | 28856 | 29 | |||
| 4833 | 75711 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982781.2778 | 2105936.6274 | 37.7615029058487 | -122.502704174703 | (37.7615029058487, -122.502704174703) | 1 | 8 | 3 | 56 | 35 | |||
| 5112 | 71219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2287 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988225.9763 | 2099753.3826 | 37.7448438391255 | -122.483420138524 | (37.7448438391255, -122.483420138524) | 1 | 8 | 3 | 29491 | 35 | |||
| 5198 | 75651 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 594 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990000.19108 | 2111343.54291 | 37.7767704107746 | -122.47813253045 | (37.7767704107746, -122.47813253045) | 11 | 6 | 2 | 55 | 26 | |||
| 5300 | 194149 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 101 Pennsylvania Ave | 40 | Front Yard : Yard | Tree | Private 2 | 1 | 6014236.41284 | 2106693.24116 | 37.765378718967 | -122.393965939285 | (37.765378718967, -122.393965939285) | 14 | 3 | 8 | 28856 | 20 | ||||
| 5421 | 78924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2355 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988240.3654 | 2099300.0902 | 37.7436000553334 | -122.483337162026 | (37.7436000553334, -122.483337162026) | 1 | 8 | 3 | 29491 | 35 | |||
| 6115 | 39553 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 12 | Permit Number 40979 | 6013090.35036 | 2107006.086 | 37.7661739606766 | -122.397951878476 | (37.7661739606766, -122.397951878476) | 14 | 3 | 8 | 28856 | 20 | ||
| 6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
| 6307 | 83045 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018793.96585 | 2097631.53768 | 37.7407493718785 | -122.377573338964 | (37.7407493718785, -122.377573338964) | 10 | 3 | 8 | 58 | 1 | |||
| 6369 | 55285 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1255 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1972 12:00:00 AM | 9 | Permit Number 11211 | 5988297.4779 | 2106775.5193 | 37.7641288996273 | -122.483687653384 | (37.7641288996273, -122.483687653384) | 1 | 8 | 3 | 56 | 35 | ||
| 6676 | 70370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1462 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5983119.2114 | 2105188.9573 | 37.7594698688276 | -122.501480109549 | (37.7594698688276, -122.501480109549) | 1 | 8 | 3 | 56 | 35 | |||
| 6841 | 45453 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 191 Corona St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/2001 12:00:00 AM | Permit Number 44237 | 5993006.32104665 | 2092505.10355506 | 37.7252189362985 | -122.466364051503 | (37.7252189362985, -122.466364051503) | 9 | 8 | 4 | 59 | 40 | ||
| 6966 | 35281 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
| 7048 | 70747 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 775 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988472.81051 | 2110739.80778 | 37.7750239462768 | -122.483371863607 | (37.7750239462768, -122.483371863607) | 11 | 6 | 2 | 55 | 26 | |||
| 7416 | 52562 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1267 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2006 12:00:00 AM | 3 | Permit Number 48659 | 5983648.1273 | 2106539.2749 | 37.7632085093228 | -122.49975069135 | (37.7632085093228, -122.49975069135) | 1 | 8 | 3 | 56 | 35 | |
| 7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
| 7716 | 47426 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 573 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 3 | Permit Number 45337 | 5983462.70057 | 2111933.41652 | 37.7780083900123 | -122.50079093001 | (37.7780083900123, -122.50079093001) | 11 | 6 | 2 | 55 | 26 | |
| 8079 | 42144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 471 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | Permit Number 42439 | 5990590.8617 | 2112190.82997 | 37.7791310957428 | -122.476151146082 | (37.7791310957428, -122.476151146082) | 11 | 6 | 2 | 55 | 26 | |
| 8377 | 42837 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1258 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2000 12:00:00 AM | 14 | Permit Number 42769 | 6005846.59276 | 2120362.48981 | 37.8024412617221 | -122.423956527271 | (37.8024412617221, -122.423956527271) | 5 | 9 | 1 | 28858 | 32 | ||
| 8816 | 177939 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Garces Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989472.35628 | 2089125.29207 | 37.7157342731997 | -122.478333458321 | (37.7157342731997, -122.478333458321) | 1 | 8 | 4 | 64 | 14 | ||||
| 9131 | 75410 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5984433.26554 | 2112138.70931 | 37.7786289992279 | -122.497448611431 | (37.7786289992279, -122.497448611431) | 11 | 6 | 2 | 55 | 26 | |||
| 9238 | 177934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Bucareli Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988635.61259 | 2089280.10032 | 37.7161107276166 | -122.481236924063 | (37.7161107276166, -122.481236924063) | 1 | 8 | 4 | 64 | 14 | ||||
| 9251 | 64294 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 369 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | 11 | Permit Number 25100 | 6004186.81103281 | 2098943.74928531 | 37.7435367899994 | -122.428172863442 | (37.7435367899994, -122.428172863442) | 2 | 7 | 5 | 63 | 22 | |
| 9669 | 71248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1853 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009517.1243 | 2120069.0751 | 37.8018421572412 | -122.411233884286 | (37.8018421572412, -122.411233884286) | 3 | 1 | 10 | 308 | 23 | |||
| 9713 | 71215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2143 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988194.3764 | 2100717.2109 | 37.7474884169564 | -122.483600053104 | (37.7474884169564, -122.483600053104) | 1 | 8 | 3 | 29491 | 35 | |||
| 9743 | 34866 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 579 Miramar Ave | 1 | Median : Cutout | Tree | Private 2 | FUF | 12/29/2015 12:00:00 AM | Permit Number 775311 | 5995338.59696042 | 2093168.95782094 | 37.7271760192259 | -122.458349689476 | (37.7271760192259, -122.458349689476) | 9 | 7 | 4 | 28861 | 40 | ||
| 10318 | 78551 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2255 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982019.5732 | 2099750.385 | 37.7444724345971 | -122.504880128796 | (37.7444724345971, -122.504880128796) | 1 | 8 | 3 | 29491 | 35 | |||
| 10720 | 39483 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 0 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40941 | |||||||||||||
| 11031 | 194139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 770 Illinois St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6015990.60538 | 2105494.8516 | 37.7621855348578 | -122.387814914632 | (37.7621855348578, -122.387814914632) | 10 | 3 | 8 | 28856 | 29 | ||||
| 11049 | 74796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2338 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983322.3378 | 2099244.9576 | 37.7431612263111 | -122.500338147126 | (37.7431612263111, -122.500338147126) | 1 | 8 | 3 | 29491 | 35 | |||
| 11455 | 71633 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 666 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983841.90754 | 2111286.39703 | 37.7762541180901 | -122.499431311865 | (37.7762541180901, -122.499431311865) | 11 | 6 | 2 | 55 | 26 | |||
| 11500 | 80930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000799.22346 | 2087352.62937 | 37.7115179816306 | -122.439055727159 | (37.7115179816306, -122.439055727159) | 9 | 7 | 6 | 28861 | 5 | |||
| 11523 | 80597 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6014099.89803 | 2105040.34202 | 37.7608326316413 | -122.394322377476 | (37.7608326316413, -122.394322377476) | 10 | 3 | 8 | 28856 | 29 | |||
| 11711 | 38775 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 660 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1998 12:00:00 AM | 8 | Permit Number 40638 | 6014484.21875 | 2111755.81993 | 37.7792932023544 | -122.393463157999 | (37.7792932023544, -122.393463157999) | 6 | 2 | 9 | 28856 | 34 | |
| 11761 | 10268 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215X Haight St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6005053.18335 | 2109512.97249 | 37.7726063733294 | -122.425929359246 | (37.7726063733294, -122.425929359246) | 7 | 9 | 5 | 28852 | 10 | ||||
| 11782 | 75252 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984435.27406 | 2112051.02131 | 37.7783883510577 | -122.497435187925 | (37.7783883510577, -122.497435187925) | 11 | 6 | 2 | 55 | 26 | |||
| 11999 | 78469 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 620 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6007750.85494 | 2094230.07543 | 37.730795086422 | -122.415515595769 | (37.730795086422, -122.415515595769) | 9 | 3 | 7 | 309 | 28 | |||
| 12171 | 84266 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988141.50064 | 2111140.28908 | 37.7761042683076 | -122.484547303766 | (37.7761042683076, -122.484547303766) | 11 | 6 | 2 | 55 | 26 | |||
| 12429 | 71684 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 163 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994555.12862 | 2086427.38157 | 37.7086202032335 | -122.460569802865 | (37.7086202032335, -122.460569802865) | 9 | 8 | 6 | 28861 | 25 | |||
| 12517 | 83658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001863.16562 | 2089646.83142 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | 9 | 7 | 6 | 28861 | 5 | |||
| 12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
| 13401 | 35284 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 13589 | 74272 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6015960.78285 | 2105386.23771 | 37.7618856523157 | -122.387910481099 | (37.7618856523157, -122.387910481099) | 10 | 3 | 8 | 28856 | 29 | |||
| 13702 | 83044 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6018777.54715 | 2097643.31156 | 37.7407807960029 | -122.377630926146 | (37.7407807960029, -122.377630926146) | 10 | 3 | 8 | 58 | 1 | |||
| 13779 | 48583 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1172 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 6 | Permit Number 45898 | 6008021.61269 | 2118241.60717 | 37.7967404007911 | -122.416279558156 | (37.7967404007911, -122.416279558156) | 5 | 1 | 10 | 28858 | 21 | |
| 13867 | 38714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 815 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1998 12:00:00 AM | 6 | Permit Number 40617 | 6002461.8782 | 2111447.7725 | 37.7777720662768 | -122.435031345285 | (37.7777720662768, -122.435031345285) | 15 | 5 | 11 | 29492 | 41 | |
| 13889 | 75170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 550 37th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5984437.14625 | 2112031.30929 | 37.7783343372815 | -122.497427255785 | (37.7783343372815, -122.497427255785) | 11 | 6 | 2 | 55 | 26 | |||
| 14081 | 194133 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1301 Minnesota St | 47 | Front Yard : Yard | Tree | Private 2 | 4 | 6015360.93697 | 2102437.87419 | 37.7537568269303 | -122.389779185082 | (37.7537568269303, -122.389779185082) | 10 | 3 | 8 | 28856 | 29 | ||||
| 14327 | 70383 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1465 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982453.54 | 2105161.4635 | 37.759355260686 | -122.503780254641 | (37.759355260686, -122.503780254641) | 1 | 8 | 3 | 56 | 35 | |||
| 14355 | 35285 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 38758 | ||||||||||||||
| 14364 | 107684 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 330 Seacliff Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.07251 | 2115557.06448 | 37.7881509278055 | -122.489650845774 | (37.7881509278055, -122.489650845774) | 11 | 6 | 1 | 55 | 33 | ||
| 14671 | 74991 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2345 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986666.6916 | 2102296.6086 | 37.7517359771217 | -122.488998708008 | (37.7517359771217, -122.488998708008) | 1 | 8 | 3 | 29491 | 35 | |||
| 14918 | 56281 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 318 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 10 | Permit Number 12407 | 5992177.94818 | 2113286.20231 | 37.782230591981 | -122.470740624571 | (37.782230591981, -122.470740624571) | 11 | 6 | 2 | 54 | 11 | ||
| 14962 | 41296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41973 | 6006281.33179879 | 2109112.42754659 | 37.7715759040746 | -122.421652604165 | (37.7715759040746, -122.421652604165) | 8 | 2 | 9 | 28853 | 19 | ||
| 15140 | 83033 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | 10 | 3 | 8 | 58 | 1 | ||||
| 15184 | 32343 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2885 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | Permit Number 36904 | 5999249.30586492 | 2118007.60671846 | 37.7956007178544 | -122.446616785481 | (37.7956007178544, -122.446616785481) | 13 | 9 | 1 | 57 | 17 | |||
| 15274 | 74231 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2054 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6009468.6226 | 2120763.8774 | 37.8037471914209 | -122.411450838489 | (37.8037471914209, -122.411450838489) | 3 | 1 | 10 | 308 | 23 | |||
| 15372 | 38680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1619 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | 6 | Permit Number 40597 | 5999956.5013 | 2110885.8742 | 37.7760866601423 | -122.44365790473 | (37.7760866601423, -122.44365790473) | 15 | 5 | 11 | 29492 | 16 | |
| 15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
| 15933 | 75880 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1360 43rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982784.1317 | 2105860.9992 | 37.7612954200169 | -122.502688706201 | (37.7612954200169, -122.502688706201) | 1 | 8 | 3 | 56 | 35 | |||
| 16297 | 178005 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 214 Athens St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6004661.22391 | 2092172.31663 | 37.7249707872555 | -122.426050515939 | (37.7249707872555, -122.426050515939) | 9 | 7 | 6 | 28861 | 5 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );