trees
3,709 rows where qSpecies_id = 9 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3750 | 90460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 786 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 9358 | 252934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091229 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | 9 | 8 | 6 | 28861 | 24 | |||||
| 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 | |||
| 25147 | 87468 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 147 Laidley St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2008 12:00:00 AM | 3x3 | Permit Number 50383 | 6003836 | 2097532 | 37.7396405954937 | -122.429285233348 | (37.7396405954937, -122.429285233348) | 2 | 7 | 5 | 63 | 7 | |||
| 27253 | 108790 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 964 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.77889 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | 9 | 7 | 6 | 309 | 5 | |
| 47072 | 88395 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 150 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51374 | 5988059.13984 | 2114984.30463 | 37.7866540515097 | -122.48511431139 | (37.7866540515097, -122.48511431139) | 11 | 6 | 1 | 55 | 33 | ||
| 58062 | 86773 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4259 22nd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49745 | 6000836 | 2102862 | 37.7541052091019 | -122.44004000726 | (37.7541052091019, -122.44004000726) | 2 | 4 | 5 | 28862 | 22 | |||
| 61160 | 106800 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 443 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6011195 | 2112052 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | 14 | 2 | 9 | 28853 | 34 | |||||
| 103220 | 88183 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 459 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51190 | 6011089 | 2111952 | 37.7796426384682 | -122.405222512117 | (37.7796426384682, -122.405222512117) | 14 | 2 | 9 | 28853 | 34 | |||
| 103830 | 88573 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 488 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51513 | 5990365.1 | 2112073.9 | 37.7787969444241 | -122.476923593538 | (37.7787969444241, -122.476923593538) | 11 | 6 | 2 | 55 | 26 | |||
| 110498 | 109291 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 286 Cumberland St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774872 | 6003752.6 | 2104537.4 | 37.7588710659743 | -122.4300732064 | (37.7588710659743, -122.4300732064) | 2 | 4 | 5 | 28862 | 3 | |
| 122828 | 89207 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 865 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51841 | 5988167.9 | 2110089.1 | 37.7732195338157 | -122.484378866757 | (37.7732195338157, -122.484378866757) | 11 | 6 | 2 | 55 | 26 | |||
| 141211 | 90459 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 798X 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988218.04709 | 2110585.29029 | 37.7745848539829 | -122.484241800238 | (37.7745848539829, -122.484241800238) | 11 | 6 | 2 | 55 | 26 | |||
| 146289 | 90462 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 776 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.55131 | 2110700.55151 | 37.774901067359 | -122.484265806793 | (37.774901067359, -122.484265806793) | 11 | 6 | 2 | 55 | 26 | |||
| 146482 | 88389 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 238 22nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51367 | 5989030.6035 | 2113722.23927 | 37.7832453168995 | -122.481660848787 | (37.7832453168995, -122.481660848787) | 11 | 6 | 2 | 55 | 26 | ||
| 151076 | 88521 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 162 Southwood Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51453 | 5994999 | 2092590 | 37.7255668196252 | -122.459481752836 | (37.7255668196252, -122.459481752836) | 9 | 7 | 4 | 28861 | 40 | |||
| 168479 | 88702 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 225 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51652 | 6005143 | 2109639 | 37.7729574898546 | -122.425627645138 | (37.7729574898546, -122.425627645138) | 7 | 9 | 11 | 28852 | 10 | |||
| 172811 | 88386 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 226 19th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51364 | 5989957.47723 | 2113852.00088 | 37.7836554593348 | -122.478463763539 | (37.7836554593348, -122.478463763539) | 11 | 6 | 2 | 55 | 26 | ||
| 176799 | 88075 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 931 Elizabeth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2008 12:00:00 AM | Permit Number 51070 | 6000446 | 2101962 | 37.7516118173154 | -122.441324145572 | (37.7516118173154, -122.441324145572) | 2 | 4 | 5 | 28862 | 22 | ||||
| 180362 | 88553 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 734 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51498 | 5991338.26851 | 2110389.97452 | 37.7742297509054 | -122.4734341978 | (37.7742297509054, -122.4734341978) | 11 | 6 | 2 | 54 | 26 | ||
| 183134 | 90461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 780 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5988213.85738 | 2110673.16421 | 37.774825887299 | -122.484262739051 | (37.774825887299, -122.484262739051) | 11 | 6 | 2 | 55 | 26 | |||
| 186622 | 252932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 66 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091179 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | 9 | 8 | 6 | 28861 | 24 | |||||
| 188930 | 252933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 72 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091205 | 37.7218868659906 | -122.451977199572 | (37.7218868659906, -122.451977199572) | 9 | 8 | 6 | 28861 | 24 | |||||
| 12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
| 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 | ||
| 291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||||
| 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 | |
| 593 | 1419 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5X5PL | 5995462.58605 | 2115703.10829 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | 11 | 6 | 1 | 54 | 11 | |||
| 765 | 9065 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 5537 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5989786.9858 | 2112602.3503 | 37.7802143684845 | -122.478962158407 | (37.7802143684845, -122.478962158407) | 11 | 6 | 2 | 55 | 26 | |||
| 941 | 233728 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 4570 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000770.37011 | 2104674.3409 | 37.7590777197736 | -122.440396940071 | (37.7590777197736, -122.440396940071) | 2 | 4 | 5 | 28862 | 3 | |||
| 998 | 233796 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 35 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6004294.34985 | 2098061.60809 | 37.74112071635 | -122.427738180998 | (37.74112071635, -122.427738180998) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||||||||||||
| 1088 | 20259 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 500X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:41:00 AM | 3 | 3X3 | 6009947.7744 | 2120592.07204 | 37.8033023200197 | -122.40978056566 | (37.8033023200197, -122.40978056566) | 3 | 1 | 10 | 308 | 23 | ||
| 1155 | 117421 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 29 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5996647.4398 | 2112726.9752 | 37.7809525538521 | -122.455237845507 | (37.7809525538521, -122.455237845507) | 11 | 6 | 2 | 54 | 16 | |||
| 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 | ||
| 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 | |||
| 1401 | 123788 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994626 | 2112195 | 37.7793757071335 | -122.46219235943 | (37.7793757071335, -122.46219235943) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |
| 1714 | 216680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 430 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 07:33:00 AM | 3 | Width 3ft | 5995444.86919 | 2090582.23732 | 37.7200796093562 | -122.457795211804 | (37.7200796093562, -122.457795211804) | 9 | 8 | 6 | 28861 | 24 | ||
| 1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
| 1896 | 17856 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | 13 | 9 | 11 | 29490 | 27 | ||
| 1912 | 261449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 306 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006931 | 2095728 | 37.7348619417662 | -122.418456144702 | (37.7348619417662, -122.418456144702) | 2 | 7 | 7 | 28859 | 2 | ||||
| 1958 | 244068 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.7711220225463 | -122.448773795857 | (37.7711220225463, -122.448773795857) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | ||
| 2218 | 210632 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1695 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5993073.70749 | 2104007.38642 | 37.7568051923228 | -122.46696694227 | (37.7568051923228, -122.46696694227) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |
| 2357 | 210723 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 221 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994792.87709 | 2087738.88584 | 37.7122349616579 | -122.459843056229 | (37.7122349616579, -122.459843056229) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 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 | |
| 2976 | 138679 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1719 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000526.15 | 2114747.8117 | 37.7867230240237 | -122.441964602207 | (37.7867230240237, -122.441964602207) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
| 3298 | 210771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 115 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994196.30129 | 2105955.3306 | 37.7622184734172 | -122.463225970324 | (37.7622184734172, -122.463225970324) | 1 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 3566 | 246019 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 609 Clayton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 5998477.1179 | 2108551.0541 | 37.7695913556898 | -122.448607268219 | (37.7695913556898, -122.448607268219) | 15 | 5 | 11 | 29492 | 9 | |||
| 3596 | 264801 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011023 | 2089107 | 37.7169115603385 | -122.403842847789 | (37.7169115603385, -122.403842847789) | 10 | 7 | 8 | 309 | 39 | ||||
| 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 | |||
| 3784 | 233206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 103 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007392.99224 | 2097693.10233 | 37.7402836768503 | -122.416998061628 | (37.7402836768503, -122.416998061628) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 3990 | 60261 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.412268813453 | (37.7575442102667, -122.412268813453) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | |||
| 4050 | 173690 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 690X 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | |||
| 4117 | 17881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | 13 | 9 | 11 | 29490 | 27 | |||
| 4124 | 177990 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 287 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003882.75599 | 2091839.3373 | 37.7240124714806 | -122.428717866434 | (37.7240124714806, -122.428717866434) | 9 | 7 | 6 | 28861 | 5 | |||
| 4236 | 233222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 300x Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
| 4530 | 232895 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1621 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010456.86654 | 2100207.03244 | 37.7473582575881 | -122.406581465278 | (37.7473582575881, -122.406581465278) | 2 | 7 | 7 | 28859 | 2 | |||
| 4573 | 232883 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2800 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009514.50062 | 2105024.85439 | 37.7605341511365 | -122.410180205851 | (37.7605341511365, -122.410180205851) | 2 | 4 | 7 | 28859 | 19 | |||
| 4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
| 4903 | 88595 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 399 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52536 | 6004228 | 2109402 | 37.7722550008378 | -122.428775842479 | (37.7722550008378, -122.428775842479) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | |||
| 5173 | 169519 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 1753 Noe St | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 8x8 | Permit Number 779099 | 6003417.91334 | 2098032.77345 | 37.7409919262491 | -122.430766523865 | (37.7409919262491, -122.430766523865) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | |||
| 5468 | 19026 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.7883609073807 | -122.44506178917 | (37.7883609073807, -122.44506178917) | 13 | 6 | 1 | 29490 | 27 | |||
| 5653 | 215048 | Private 9 | Olea europaea :: Olive Tree 9 | 1719 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782897 | 5990885.18116 | 2103671.34742 | 37.7557559568771 | -122.474511074324 | (37.7557559568771, -122.474511074324) | 1 | 8 | 4 | 56 | 12 | |
| 5987 | 262213 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 66 Clarendon Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997837 | 2104660 | 37.7588708842054 | -122.450540844653 | (37.7588708842054, -122.450540844653) | 15 | 5 | 11 | 28862 | 12 | ||||
| 6043 | 235756 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 79 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2019 12:00:00 AM | 3 | 6x3 | 6005437.91175 | 2099305.91889 | 37.7446019335453 | -122.423872610632 | (37.7446019335453, -122.423872610632) | 2 | 7 | 5 | 28859 | 22 | ||
| 6161 | 103626 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2729 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770186 | 5999911.184 | 2118103.33782 | 37.79590135493 | -122.444333461525 | (37.79590135493, -122.444333461525) | 13 | 9 | 1 | 57 | 17 | |
| 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 | ||
| 6324 | 233656 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 579 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 6x6 | 6001434.06247 | 2101426.15638 | 37.7501967553975 | -122.437868930507 | (37.7501967553975, -122.437868930507) | 2 | 4 | 5 | 28862 | 22 | |||
| 6339 | 202874 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 560 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011757.6465 | 2105763.90852 | 37.7626889070017 | -122.402474114009 | (37.7626889070017, -122.402474114009) | 8 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 6418 | 194172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 664 Wisconsin St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6012676.7573 | 2104370.99604 | 37.7589155441312 | -122.399197435936 | (37.7589155441312, -122.399197435936) | 10 | 3 | 8 | 28856 | 29 | |||
| 6532 | 119947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 326 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5986858.05985 | 2113733.39411 | 37.783149373707 | -122.489177700438 | (37.783149373707, -122.489177700438) | 11 | 6 | 2 | 55 | 26 | |||
| 6614 | 233670 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 803 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002469.64412 | 2103508.89631 | 37.7559742970036 | -122.434436723671 | (37.7559742970036, -122.434436723671) | 2 | 4 | 5 | 28862 | 22 | |||
| 6647 | 233181 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1088 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998975.05646 | 2106207.82472 | 37.7631858975236 | -122.446716299819 | (37.7631858975236, -122.446716299819) | 15 | 5 | 5 | 29492 | 9 |
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) );