trees
1,985 rows where qSpecies_id = 83 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12199 | 30624 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | 8 | 2 | 9 | 28853 | 19 | |
12336 | 85628 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1470 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015957.8963 | 2094137.5833 | 37.7309990152261 | -122.387135841638 | (37.7309990152261, -122.387135841638) | 10 | 3 | 8 | 58 | 1 | ||
13015 | 61560 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2117 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 9 | Permit Number 21520 | 6012109.3133 | 2102790.69622 | 37.7545447481545 | -122.401048896306 | (37.7545447481545, -122.401048896306) | 10 | 3 | 8 | 28856 | 29 | |
13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
13315 | 34250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.422766446326 | (37.8043668775019, -122.422766446326) | 5 | 1 | 1 | 28858 | 32 | |
13381 | 238854 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 299x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007995.79542 | 2096561.34412 | 37.7372100081447 | -122.414833724393 | (37.7372100081447, -122.414833724393) | 2 | 7 | 7 | 28859 | 2 | |||
13481 | 261122 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 56 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6014135.16378 | 2094796.13766 | 37.7327061665323 | -122.393483454939 | (37.7327061665323, -122.393483454939) | 10 | 3 | 8 | 58 | 1 | ||
13494 | 83178 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 743 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2019 12:00:00 AM | 3 | 3x3 | Permit Number 51518 | 5990037.32656 | 2110290.06846 | 37.7738800155956 | -122.477927036337 | (37.7738800155956, -122.477927036337) | 11 | 6 | 2 | 55 | 26 | |
13512 | 259080 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1001 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
13606 | 264731 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014824 | 2093132 | 37.7281750296252 | -122.390985688648 | (37.7281750296252, -122.390985688648) | 10 | 3 | 8 | 58 | 1 | ||||
14166 | 197170 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1510X Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016200.17093 | 2097456.77974 | 37.740126273917 | -122.386529601766 | (37.740126273917, -122.386529601766) | 10 | 3 | 8 | 58 | 1 | |||
14546 | 63665 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.7475274359015 | -122.428684519984 | (37.7475274359015, -122.428684519984) | 2 | 4 | 5 | 63 | 22 | ||
14662 | 248025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 439 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6010001 | 2098476 | 37.7425797058833 | -122.408035769643 | (37.7425797058833, -122.408035769643) | 10 | 7 | 7 | 28859 | 2 | |||
14804 | 264658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 04:59:00 PM | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | |||
15005 | 261438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 384 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007303 | 2095696 | 37.7347950116026 | -122.417167741106 | (37.7347950116026, -122.417167741106) | 2 | 7 | 7 | 28859 | 2 | ||||
15188 | 180603 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6009034.51206 | 2093748.44623 | 37.7295447050207 | -122.411043765455 | (37.7295447050207, -122.411043765455) | 9 | 3 | 7 | 309 | 28 | ||
15192 | 65109 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 5 | Permit Number 27078 | 5988958.23473 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | 11 | 6 | 2 | 55 | 26 | |
15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
15478 | 252965 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 02:04:00 PM | 3 | |||||||||||||
15913 | 258136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 125 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 6011373.95167 | 2092087.62826 | 37.7251153564238 | -122.402839281337 | (37.7251153564238, -122.402839281337) | 10 | 3 | 7 | 309 | 28 | ||
16016 | 5120 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2016 10:06:00 AM | 3 | 5X5 | 6002461.05615 | 2096042.42458 | 37.7354726294434 | -122.433932747209 | (37.7354726294434, -122.433932747209) | 2 | 7 | 5 | 63 | 7 | ||
16300 | 248300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3175 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6006753.7624 | 2099865.7323 | 37.74621325229 | -122.419362356984 | (37.74621325229, -122.419362356984) | 2 | 7 | 7 | 28859 | 2 | |||
16463 | 106806 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 167 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5996526.1156 | 2113255.0824 | 37.7823956347772 | -122.455695748043 | (37.7823956347772, -122.455695748043) | 11 | 6 | 1 | 54 | 31 | ||||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
16573 | 33529 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.417175357737 | (37.7413321670111, -122.417175357737) | 2 | 7 | 7 | 28859 | 2 | |||
17139 | 261451 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 295 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006893 | 2095807 | 37.7350767190782 | -122.41859312449 | (37.7350767190782, -122.41859312449) | 2 | 7 | 7 | 28859 | 2 | ||||
17262 | 258984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 784344 | 6010137 | 2099925 | 37.7465659576292 | -122.407667663761 | (37.7465659576292, -122.407667663761) | 2 | 7 | 7 | 28859 | 2 | |||
17469 | 239268 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 43 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006498.06002 | 2108217.35728 | 37.769130472909 | -122.420839370946 | (37.769130472909, -122.420839370946) | 8 | 4 | 7 | 28853 | 19 | |||
17572 | 7280 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1805 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2020 02:03:00 PM | 3 | 4X4 | 6002990.933 | 2114560.8146 | 37.7863497234839 | -122.433423679579 | (37.7863497234839, -122.433423679579) | 13 | 9 | 11 | 29490 | 27 | ||
17844 | 239290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009903.27648 | 2104148.96892 | 37.7581509513321 | -122.408773807391 | (37.7581509513321, -122.408773807391) | 2 | 4 | 7 | 28859 | 19 | |||
18235 | 42453 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | 9 | 7 | 4 | 59 | 40 | ||
18577 | 147771 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 275 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5993980.24137 | 2113705.13134 | 37.7834849172426 | -122.464535973179 | (37.7834849172426, -122.464535973179) | 11 | 6 | 2 | 54 | 11 | |||
18843 | 65788 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) | 11 | 6 | 1 | 54 | 31 | ||
18871 | 108376 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
18976 | 44337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.02072 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | 10 | 3 | 8 | 58 | 1 | ||
19055 | 61576 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2019 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 7 | Permit Number 21538 | 6012377.33608 | 2102802.45934 | 37.754591994948 | -122.400122823023 | (37.754591994948, -122.400122823023) | 10 | 3 | 8 | 28856 | 29 | |
19096 | 73459 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6010582.51713 | 2106716.25151 | 37.7652381522352 | -122.406605601283 | (37.7652381522352, -122.406605601283) | 8 | 4 | 8 | 28853 | 19 | |||
19125 | 72279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | 11 | 6 | 2 | 55 | 26 | |||
19372 | 259083 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1029 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009458.60985 | 2087249.80978 | 37.7117245759679 | -122.409119233208 | (37.7117245759679, -122.409119233208) | 9 | 7 | 8 | 309 | 39 | |||
19440 | 262431 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 231 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6002625 | 2092333 | 37.7252966937933 | -122.433100982945 | (37.7252966937933, -122.433100982945) | 9 | 7 | 6 | 28861 | 5 | ||
19522 | 75060 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6010594.46043 | 2106517.2504 | 37.7646924085388 | -122.406550267789 | (37.7646924085388, -122.406550267789) | 8 | 4 | 8 | 28853 | 19 | |||
19617 | 78383 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | 10 | 3 | 8 | 58 | 1 | |||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19624 | 31313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34949 | 6004462.32974 | 2110985.15865 | 37.7766152272516 | -122.428078115713 | (37.7766152272516, -122.428078115713) | 7 | 9 | 11 | 28852 | 10 | |
19630 | 69390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | 9 | 7 | 6 | 28861 | 5 | ||
19667 | 7175 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 814 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1993 12:00:00 AM | 6 | 3X3 | 6003515.423 | 2111193.7442 | 37.7771343327183 | -122.431368633672 | (37.7771343327183, -122.431368633672) | 7 | 9 | 11 | 29492 | 10 | ||
19822 | 67477 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1543 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 8 | Permit Number 30999 | 6001755.4775 | 2111486.6649 | 37.7778387194393 | -122.437477810444 | (37.7778387194393, -122.437477810444) | 15 | 5 | 11 | 29492 | 41 | |
20110 | 56158 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 447 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 8 | Permit Number 12266 | 5990893.79558 | 2112339.92163 | 37.7795580220906 | -122.475114071606 | (37.7795580220906, -122.475114071606) | 11 | 6 | 2 | 54 | 26 | ||
20240 | 239310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005491.56971 | 2101034.94567 | 37.7493524745442 | -122.42380999086 | (37.7493524745442, -122.42380999086) | 2 | 4 | 5 | 28859 | 19 | |||
20652 | 239344 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 221 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010109.73807 | 2099963.72008 | 37.746670748365 | -122.407764662809 | (37.746670748365, -122.407764662809) | 2 | 7 | 7 | 28859 | 2 | |||
20758 | 38463 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.7275905904586 | -122.38112356357 | (37.7275905904586, -122.38112356357) | 10 | 3 | 8 | 58 | 1 | ||
20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
21171 | 197125 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | 10 | 3 | 8 | 58 | 1 | |||
21197 | 63882 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3533 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24589 | 6004803.22751205 | 2103657.20146126 | 37.7565136952268 | -122.426376975449 | (37.7565136952268, -122.426376975449) | 2 | 4 | 5 | 28862 | 22 | ||
21384 | 239247 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010310.37957 | 2101498.2335 | 37.7508954153113 | -122.407179012596 | (37.7508954153113, -122.407179012596) | 2 | 4 | 7 | 28859 | 19 | |||
21391 | 16673 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 244 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002873.2969 | 2106860.82122 | 37.7652007800214 | -122.433280262977 | (37.7652007800214, -122.433280262977) | 15 | 5 | 5 | 28862 | 3 | |||
21516 | 43755 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 264 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 3 | Permit Number 43391 | 5990896.10038 | 2113625.86147 | 37.783088990728 | -122.475200003572 | (37.783088990728, -122.475200003572) | 11 | 6 | 2 | 54 | 26 | |
21589 | 136245 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1723 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006515.15933 | 2116648.60219 | 37.7922815836866 | -122.421379054996 | (37.7922815836866, -122.421379054996) | 13 | 9 | 10 | 28858 | 21 | |||
21709 | 47740 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3583 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2002 12:00:00 AM | 5 | 3x3 | Permit Number 45523 | 6005444.07123 | 2097374.1868 | 37.7392981824927 | -122.423713989591 | (37.7392981824927, -122.423713989591) | 2 | 7 | 7 | 28859 | 2 | |
21724 | 239356 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.424877716331 | (37.7429522432585, -122.424877716331) | 2 | 7 | 5 | 63 | 22 | |||
21798 | 140393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1795 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6002743.2077 | 2113356.8165 | 37.7830297920416 | -122.434194640623 | (37.7830297920416, -122.434194640623) | 15 | 9 | 11 | 29490 | 41 | |||
21998 | 110495 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 230 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003598.79471 | 2092490.01573 | 37.7257830144685 | -122.429745863482 | (37.7257830144685, -122.429745863482) | 9 | 7 | 6 | 28861 | 5 | |||
22264 | 60143 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | 1 | 8 | 4 | 56 | 12 | ||
22287 | 1701 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 46 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2015 02:11:00 PM | 3 | 3X3 | 6017792.761567 | 2093643.6318374 | 37.7297441585391 | -122.380758013182 | (37.7297441585391, -122.380758013182) | 10 | 3 | 8 | 58 | 1 | ||
22297 | 123102 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 401 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992511.21682 | 2112680.96666 | 37.7805880471465 | -122.469543602377 | (37.7805880471465, -122.469543602377) | 11 | 6 | 2 | 54 | 11 | |||
22596 | 213938 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992850.99558 | 2098086.47375 | 37.7405350265634 | -122.467306643206 | (37.7405350265634, -122.467306643206) | 1 | 8 | 4 | 59 | 40 | |||
23046 | 136230 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | 13 | 9 | 1 | 57 | 17 | |||
23079 | 240160 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 4903 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997783.51169 | 2105613.08498 | 37.7614847543311 | -122.450794550851 | (37.7614847543311, -122.450794550851) | 15 | 5 | 11 | 29492 | 12 | |||
23197 | 95639 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
23216 | 136209 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3501 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997993.27095 | 2115789.6423 | 37.7894389544021 | -122.450802865961 | (37.7894389544021, -122.450802865961) | 11 | 6 | 1 | 54 | 31 | |||
23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
23672 | 247568 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 322 Alemany Blvd | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6008688.67784 | 2095404.14208 | 37.7340714901943 | -122.412356334971 | (37.7340714901943, -122.412356334971) | 10 | 7 | 7 | 28859 | 2 | |||
23859 | 55920 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2480 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2006 12:00:00 AM | 3x3 | Permit Number 50600 | 6006935.48968262 | 2103919.31295705 | 37.7573536936319 | -122.419021429077 | (37.7573536936319, -122.419021429077) | 2 | 4 | 7 | 28859 | 19 | ||
23910 | 69318 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1466 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1994 12:00:00 AM | 12 | Permit Number 33399 | 6004829.35126 | 2120222.0032 | 37.8019980398336 | -122.427466672957 | (37.8019980398336, -122.427466672957) | 13 | 9 | 1 | 57 | 17 | |
24416 | 81916 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52300 | 6013111.49661 | 2094334.18979 | 37.7313808220717 | -122.396990173153 | (37.7313808220717, -122.396990173153) | 10 | 3 | 8 | 58 | 1 | |
24907 | 136189 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002539.896 | 2118184.5507 | 37.7962739719132 | -122.435243443451 | (37.7962739719132, -122.435243443451) | 13 | 9 | 1 | 57 | 17 | |||
24941 | 239241 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1301 Potrero Ave | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6010653.63145 | 2101615.38344 | 37.7512362871225 | -122.406000261299 | (37.7512362871225, -122.406000261299) | 10 | 4 | 8 | 28859 | 19 | |||
25132 | 63326 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23899 | 6008102.76980253 | 2100057.0858479 | 37.746814552568 | -122.41471118136 | (37.746814552568, -122.41471118136) | 2 | 7 | 7 | 28859 | 2 | ||
25154 | 52631 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.24979 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | 13 | 9 | 10 | 28858 | 32 | ||
25528 | 239279 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006490.03164 | 2104559.30004 | 37.7590858550479 | -122.420607431291 | (37.7590858550479, -122.420607431291) | 2 | 4 | 7 | 28859 | 19 | |||
25796 | 95782 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487 | 2104873 | 37.7598906214089 | -122.424098704222 | (37.7598906214089, -122.424098704222) | 2 | 4 | 5 | 28859 | 19 | |
26281 | 213989 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2583 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992043.57751 | 2097881.5544 | 37.7399257259925 | -122.470083438513 | (37.7399257259925, -122.470083438513) | 1 | 8 | 4 | 59 | 40 | |||
26571 | 150167 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 333 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779492 | 6014367.55242 | 2105483.96934 | 37.7620656102492 | -122.393427719319 | (37.7620656102492, -122.393427719319) | 10 | 3 | 8 | 28856 | 29 | |
26708 | 240143 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.7630981164972 | -122.449494935145 | (37.7630981164972, -122.449494935145) | 15 | 5 | 11 | 29492 | 9 | |||
26875 | 240157 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 563 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998602.31996 | 2105951.33852 | 37.7624603514868 | -122.447986997796 | (37.7624603514868, -122.447986997796) | 15 | 5 | 11 | 29492 | 9 | |||
26993 | 34292 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2758 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46984 | 6010209.51678065 | 2102837.66319596 | 37.7545675469901 | -122.407622236094 | (37.7545675469901, -122.407622236094) | 2 | 4 | 7 | 28859 | 19 | ||
27068 | 240206 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 81 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003903.54766 | 2097252.33034 | 37.7388765103369 | -122.429031747817 | (37.7388765103369, -122.429031747817) | 2 | 7 | 5 | 63 | 7 | |||
27070 | 179328 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003082.18231 | 2091589.31338 | 37.7232806193946 | -122.431467482451 | (37.7232806193946, -122.431467482451) | 9 | 7 | 6 | 28861 | 5 | |||
27277 | 18635 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Reuel Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 0 | 3X3 | 6017095.3922155 | 2096110.4018038 | 37.736478907812 | -122.3833405631 | (37.736478907812, -122.3833405631) | 10 | 3 | 8 | 58 | 1 | ||
27479 | 136226 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | 13 | 9 | 1 | 57 | 17 | |||
27834 | 138037 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002982.5354 | 2114995.4141 | 37.7875425469434 | -122.433483802199 | (37.7875425469434, -122.433483802199) | 13 | 9 | 11 | 29490 | 27 | |||
27982 | 85620 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1344 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6016632.8917 | 2093635.0593 | 37.729656539473 | -122.384767252586 | (37.729656539473, -122.384767252586) | 10 | 3 | 8 | 58 | 1 | ||
28051 | 240145 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1209 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998178.05243 | 2106154.45126 | 37.7629937870534 | -122.449469012203 | (37.7629937870534, -122.449469012203) | 15 | 5 | 11 | 29492 | 9 | |||
28102 | 4618 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 354 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3x3 | 6010598.00994 | 2118821.58602 | 37.7984774173787 | -122.407405500457 | (37.7984774173787, -122.407405500457) | 3 | 1 | 10 | 308 | 23 | |||
28462 | 7316 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6002972.25432 | 2115230.97031 | 37.7881887410682 | -122.433536213059 | (37.7881887410682, -122.433536213059) | 13 | 9 | 1 | 29490 | 27 | |||
28482 | 142842 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1343 POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6006739.5174 | 2115575.1482 | 37.7893467921177 | -122.420526537815 | (37.7893467921177, -122.420526537815) | 13 | 9 | 10 | 28858 | 21 | |||
28541 | 51529 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.03413 | 2103130.63922 | 37.7555299221754 | -122.397860957035 | (37.7555299221754, -122.397860957035) | 10 | 3 | 8 | 28856 | 29 | ||
28575 | 54817 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1414 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49953 | 6015568.3491 | 2093032.3958 | 37.7279428116622 | -122.388405474303 | (37.7279428116622, -122.388405474303) | 10 | 3 | 8 | 58 | 1 | |
28692 | 48873 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/1993 12:00:00 AM | 12 | 3x3 | Permit Number 46081 | 6011769.28798 | 2120850.10657 | 37.8041127290715 | -122.40349528428 | (37.8041127290715, -122.40349528428) | 3 | 1 | 10 | 28860 | 6 |
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) );