Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
| 103749 | 103749 | 69409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.710084087104896 | -122.43649593455099 | (37.7100840871049, -122.436495934551) | ||
| 65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
| 65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
| 128591 | 128591 | 69392 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.71247138896779 | -122.435199299374 | (37.7124713889678, -122.435199299374) | ||
| 119086 | 119086 | 69400 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33504 | 6001338.55016435 | 2087735.88894959 | 37.7126010005012 | -122.437219100024 | (37.7126010005012, -122.437219100024) | ||
| 78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
| 119517 | 119517 | 69412 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 411 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33517 | 6002045.14092784 | 2087792.75766672 | 37.712797291006495 | -122.434780968582 | (37.7127972910065, -122.434780968582) | ||
| 157228 | 157228 | 39955 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.3721599998 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | |
| 97120 | 97120 | 31159 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | ||
| 92856 | 92856 | 35042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.45271020646099 | (37.7161337438742, -122.452710206461) | ||
| 158714 | 158714 | 35136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | |
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
| 105821 | 105821 | 36824 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49072 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
| 47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
| 59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
| 28339 | 28339 | 73442 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 8 | 6004223.020830001 | 2091452.87155 | 37.72297057362721 | -122.42751410409402 | (37.7229705736272, -122.427514104094) | ||
| 184861 | 184861 | 70592 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6004234.1327 | 2091472.6068400003 | 37.7230253908821 | -122.42747709790001 | (37.7230253908821, -122.4274770979) | ||
| 157725 | 157725 | 70621 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 6 | 6004140.669919999 | 2091658.5029099998 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | ||
| 91771 | 91771 | 65172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 332 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27153 | 6003474.08618593 | 2091790.3446491002 | 37.72385481082 | -122.430127080192 | (37.72385481082, -122.430127080192) | ||
| 107246 | 107246 | 38191 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 642 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42701 | 6011185.93624372 | 2091843.1881073 | 37.7244336742141 | -122.403472045096 | (37.7244336742141, -122.403472045096) | ||
| 47148 | 47148 | 72144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1985 12:00:00 AM | 5 | 6000049.527000001 | 2091859.62504 | 37.723850484693706 | -122.441970156497 | (37.7238504846937, -122.441970156497) | ||
| 41799 | 41799 | 46849 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.724327847540295 | -122.42848061451201 | (37.7243278475403, -122.428480614512) | |
| 47463 | 47463 | 70412 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | ||
| 66013 | 66013 | 36339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | ||
| 130064 | 130064 | 52155 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1431 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2005 12:00:00 AM | 8 | Permit Number 48347 | 6016125.1581 | 2093936.3843 | 37.7304558237734 | -122.386543560163 | (37.7304558237734, -122.386543560163) | |
| 60896 | 60896 | 50021 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 137@ FELTON Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 8 | Permit Number 46755 | 6010268.64963 | 2093971.7239700002 | 37.730226909139105 | -122.406792936365 | (37.7302269091391, -122.406792936365) | |
| 162145 | 162145 | 60407 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.38643801167801 | (37.7305914290757, -122.386438011678) | |
| 103247 | 103247 | 68832 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32783 | 5999773.2281789 | 2094096.14609893 | 37.7299757052964 | -122.443085818741 | (37.7299757052964, -122.443085818741) | ||
| 181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
| 174429 | 174429 | 35739 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474286999 | (37.7309887985962, -122.41246474287) | |
| 149171 | 149171 | 42714 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 11 | Permit Number 42727 | 6013037.066980001 | 2094313.85012 | 37.731320830081 | -122.39724606626301 | (37.731320830081, -122.397246066263) | |
| 129006 | 129006 | 68466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | ||
| 80568 | 80568 | 68465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 56 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32327 | 6002348.42397311 | 2094432.09629198 | 37.731044644088605 | -122.43420707357201 | (37.7310446440886, -122.434207073572) | ||
| 48741 | 48741 | 71411 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | ||
| 97041 | 97041 | 68464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 52 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32326 | 6002331.05144197 | 2094486.37219697 | 37.7311926873179 | -122.434271012127 | (37.7311926873179, -122.434271012127) | ||
| 66931 | 66931 | 38591 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | |
| 70015 | 70015 | 39981 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935121999 | (37.7325519363025, -122.39310935122) | |
| 96831 | 96831 | 94879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 83 Ledyard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767655 | 6011819.0 | 2094865.0 | 37.7327662839989 | -122.40149589318399 | (37.7327662839989, -122.401495893184) |
| 91340 | 91340 | 96161 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767793 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
| 64108 | 64108 | 83143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2006 12:00:00 AM | 1 | 6016637.512159999 | 2095504.68596 | 37.7347904181313 | -122.384881478104 | (37.7347904181313, -122.384881478104) | ||
| 138677 | 138677 | 94653 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 486 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53792 | 6003723.0 | 2095910.0 | 37.7351805553154 | -122.42956029154499 | (37.7351805553154, -122.429560291545) | |
| 18483 | 18483 | 66408 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | ||
| 78128 | 78128 | 61014 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.43353644788701 | (37.7354717570522, -122.433536447887) | ||
| 116153 | 116153 | 65359 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 552 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | 3x3 | Permit Number 28194 | 6003098.7701451 | 2096065.5433653998 | 37.7355722775705 | -122.431729581285 | (37.7355722775705, -122.431729581285) | |
| 99825 | 99825 | 60629 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 461 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20255 | 6003690.91133261 | 2096147.61954597 | 37.7358311876742 | -122.429688175872 | (37.7358311876742, -122.429688175872) | ||
| 81885 | 81885 | 61001 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20814 | 6002393.98738915 | 2096184.72110879 | 37.7358595366597 | -122.434174798209 | (37.7358595366597, -122.434174798209) | ||
| 123035 | 123035 | 60628 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 452 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20254 | 6003687.339794099 | 2096211.01990345 | 37.736005068405206 | -122.429705044581 | (37.7360050684052, -122.429705044581) | ||
| 86258 | 86258 | 60128 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19656 | 6003855.48725366 | 2096277.36434342 | 37.736196755139 | -122.429128420374 | (37.736196755139, -122.429128420374) | ||
| 92232 | 92232 | 67147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30578 | 6008211.14735723 | 2096290.50771504 | 37.7364784485579 | -122.414069997052 | (37.7364784485579, -122.414069997052) | ||
| 142894 | 142894 | 60126 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 357 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19654 | 6004078.30552924 | 2096452.47745436 | 37.7366901868966 | -122.42837052323799 | (37.7366901868966, -122.428370523238) | ||
| 172651 | 172651 | 71391 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 4 | 6015562.7322 | 2096452.7948 | 37.737334227876396 | -122.388663558077 | (37.7373342278764, -122.388663558077) | ||
| 105786 | 105786 | 60626 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 345 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20251 | 6004121.27237368 | 2096486.20510922 | 37.7367852266215 | -122.428224371215 | (37.7367852266215, -122.428224371215) | ||
| 100850 | 100850 | 94681 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53817 | 6001324.0 | 2096497.0 | 37.7366561951725 | -122.43789651967899 | (37.7366561951725, -122.437896519679) | |
| 118366 | 118366 | 67075 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 30469 | 6007674.59209912 | 2096541.81182002 | 37.7371383234242 | -122.41594289157601 | (37.7371383234242, -122.415942891576) | ||
| 115644 | 115644 | 66409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 498 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 29536 | 6008002.73389598 | 2096551.32437781 | 37.7371828859896 | -122.414809025919 | (37.7371828859896, -122.414809025919) | ||
| 145149 | 145149 | 60625 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 315 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20250 | 6004228.6895082 | 2096570.52426476 | 37.7370228251858 | -122.427858989442 | (37.7370228251858, -122.427858989442) | ||
| 140017 | 140017 | 60624 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 307 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20249 | 6004257.33407562 | 2096593.00937151 | 37.737086184606106 | -122.427761553914 | (37.7370861846061, -122.427761553914) | ||
| 117055 | 117055 | 67090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 479 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30492 | 6008241.27230504 | 2096616.84318853 | 37.7373761864963 | -122.41398892073099 | (37.7373761864963, -122.413988920731) | ||
| 121419 | 121419 | 60623 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 281 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20248 | 6004418.35203825 | 2096719.40356625 | 37.7374423416372 | -122.427213842425 | (37.7374423416372, -122.427213842425) | ||
| 90314 | 90314 | 67148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30579 | 6008250.85869537 | 2096720.89398869 | 37.7376624256589 | -122.413963134562 | (37.7376624256589, -122.413963134562) | ||
| 116291 | 116291 | 67149 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 454 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1992 12:00:00 AM | Permit Number 30580 | 6008199.07799535 | 2096725.66463919 | 37.737672616504796 | -122.414142503211 | (37.7376726165048, -122.414142503211) | ||
| 140614 | 140614 | 63840 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 457 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1987 12:00:00 AM | Permit Number 24531 | 6007893.82010237 | 2096744.85122317 | 37.737708147997 | -122.41519928687599 | (37.737708147997, -122.415199286876) | ||
| 103224 | 103224 | 67091 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 449 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30493 | 6008253.25529258 | 2096746.90668468 | 37.7377339854354 | -122.413956687989 | (37.7377339854354, -122.413956687989) | ||
| 100440 | 100440 | 60621 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20246 | 6004468.77441112 | 2096758.98359533 | 37.7375538708016 | -122.42704232686 | (37.7375538708016, -122.42704232686) | ||
| 118923 | 118923 | 67092 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 442 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30494 | 6008203.87118977 | 2096777.69003117 | 37.737815736076 | -122.414129610397 | (37.737815736076, -122.414129610397) | ||
| 95539 | 95539 | 67093 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 437 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30495 | 6008258.04848699 | 2096798.93207666 | 37.7378771049848 | -122.413943794807 | (37.7378771049848, -122.413943794807) | ||
| 116084 | 116084 | 88466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 955X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 118344 | 118344 | 67094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 425 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1992 12:00:00 AM | Permit Number 30496 | 6008262.84168291 | 2096850.95748485 | 37.738020224574 | -122.413930901572 | (37.738020224574, -122.413930901572) | ||
| 123180 | 123180 | 67166 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30606 | 6009175.78663264 | 2096920.50088171 | 37.738262406618 | -122.410779296402 | (37.738262406618, -122.410779296402) | ||
| 87043 | 87043 | 96121 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 113864 | 113864 | 96122 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 234 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767773 | 6007093.0 | 2096944.0 | 37.7382099281297 | -122.417982227017 | (37.7382099281297, -122.417982227017) | |
| 146304 | 146304 | 60120 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 231 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19647 | 6004727.57850512 | 2096979.14667455 | 37.7381730200844 | -122.426163187426 | (37.7381730200844, -122.426163187426) | ||
| 113396 | 113396 | 34399 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38146 | 6002515.39673717 | 2097007.28397261 | 37.7381249948755 | -122.43381381294701 | (37.7381249948755, -122.433813812947) | ||
| 145798 | 145798 | 60620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 221 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20245 | 6004788.53237408 | 2097060.23831103 | 37.7383991243874 | -122.425958210014 | (37.7383991243874, -122.425958210014) | ||
| 102521 | 102521 | 60618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 205 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20242 | 6004849.79426998 | 2097209.93187189 | 37.738813611097704 | -122.425757047896 | (37.7388136110977, -122.425757047896) | ||
| 106166 | 106166 | 57690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 149 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19644 | 6004901.85798659 | 2097408.79404605 | 37.7393625835838 | -122.425591185183 | (37.7393625835838, -122.425591185183) | ||
| 101901 | 101901 | 60615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 3x3 | Permit Number 20239 | 6004908.29901709 | 2097432.1661827 | 37.7394271221249 | -122.42557057789499 | (37.7394271221249, -122.425570577895) | |
| 71194 | 71194 | 60642 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | ||
| 85171 | 85171 | 60613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | ||
| 96753 | 96753 | 33599 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 250 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2000 12:00:00 AM | Permit Number 38023 | 6006702.31961164 | 2097757.35977095 | 37.740421237233704 | -122.419390693943 | (37.7404212372337, -122.419390693943) | ||
| 118948 | 118948 | 64315 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 73 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25132 | 6004320.83696842 | 2097772.93842025 | 37.74032959360579 | -122.42762603639099 | (37.7403295936058, -122.427626036391) | ||
| 102188 | 102188 | 60612 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 76 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | 7 | Permit Number 20236 | 6004870.59253737 | 2097774.41480617 | 37.7403647286117 | -122.42572530389201 | (37.7403647286117, -122.425725303892) | |
| 187404 | 187404 | 31226 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34913 | 5992091.73833 | 2097813.94877 | 37.7397428821404 | -122.469911998937 | (37.7397428821404, -122.469911998937) | |
| 69527 | 69527 | 31227 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34913 | 5992091.019830001 | 2097838.61761 | 37.7398105749846 | -122.46991627883301 | (37.7398105749846, -122.469916278833) | |
| 93128 | 93128 | 64332 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25160 | 6004309.77102344 | 2097969.94151847 | 37.740869893208604 | -122.427678330625 | (37.7408698932086, -122.427678330625) | ||
| 144104 | 144104 | 34354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38110 | 6004856.72316011 | 2098008.93815891 | 37.7410078927245 | -122.425789947549 | (37.7410078927245, -122.425789947549) | ||
| 127725 | 127725 | 59417 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.74097432516471 | -122.42786880394199 | (37.7409743251647, -122.427868803942) | ||
| 122051 | 122051 | 48865 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 149 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46856 | 5992881.93152757 | 2098112.87490304 | 37.74060930330371 | -122.46720159873001 | (37.7406093033037, -122.46720159873) | ||
| 83502 | 83502 | 48864 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 108781 | 108781 | 48863 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 90960 | 90960 | 48862 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 113962 | 113962 | 48861 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 135 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46853 | 5992938.7152954005 | 2098174.1666423 | 37.7407808726579 | -122.46700971886699 | (37.7407808726579, -122.467009718867) | ||
| 93793 | 93793 | 50131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46852 | 5992954.93923014 | 2098191.67856897 | 37.7408298924183 | -122.466954895883 | (37.7408298924183, -122.466954895883) | ||
| 87274 | 87274 | 102063 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 284 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769726 | 6006232.8 | 2098354.9 | 37.742035492788204 | -122.42105652774099 | (37.7420354927882, -122.421056527741) |
| 81623 | 81623 | 33440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 197 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37542 | 6006467.34357413 | 2098597.19964294 | 37.7427140119749 | -122.420262742218 | (37.7427140119749, -122.420262742218) | ||
| 123759 | 123759 | 38869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | ||
| 140468 | 140468 | 64257 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 187 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25058 | 6004735.81320328 | 2098680.88215868 | 37.74284606435771 | -122.42625583805099 | (37.7428460643577, -122.426255838051) | ||
| 105462 | 105462 | 43565 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 527 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 9 | 3x3 | Permit Number 43226 | 6003161.6606046 | 2098886.62601348 | 37.743321886148 | -122.431713499297 | (37.743321886148, -122.431713499297) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");