trees
1,985 rows where qSpecies_id = 83 sorted by Fire Prevention Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
1502 | 77647 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | 9 | 3 | 7 | 309 | 5 | ||
1920 | 213973 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995027.24606 | 2091045.40909 | 37.7213273674346 | -122.459272306869 | (37.7213273674346, -122.459272306869) | 9 | 8 | 6 | 28861 | 24 | |||
3341 | 71320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004289.26563 | 2090538.00218 | 37.7204622897839 | -122.427219973626 | (37.7204622897839, -122.427219973626) | 9 | 7 | 6 | 28861 | 5 | |||
3545 | 70593 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | 9 | 7 | 6 | 28861 | 5 | |||
3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | ||
3969 | 73442 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004223.02083 | 2091452.87155 | 37.7229705736272 | -122.427514104094 | (37.7229705736272, -122.427514104094) | 9 | 7 | 6 | 28861 | 5 | |||
4805 | 74096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001902.78384 | 2087667.72771 | 37.7124459030227 | -122.435264062185 | (37.7124459030227, -122.435264062185) | 9 | 7 | 6 | 28861 | 5 | |||
5177 | 179302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | 9 | 7 | 6 | 28861 | 5 | |||
5553 | 70621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004140.66992 | 2091658.50291 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | 9 | 7 | 6 | 28861 | 5 | |||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
7088 | 70592 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004234.1327 | 2091472.60684 | 37.7230253908821 | -122.4274770979 | (37.7230253908821, -122.4274770979) | 9 | 7 | 6 | 28861 | 5 | |||
10024 | 35136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | 9 | 7 | 6 | 28861 | 5 | |
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
11605 | 213995 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 6 | Width 3ft | Permit Number 32783 | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.443073900754 | (37.729960150431, -122.443073900754) | 9 | 7 | 4 | 63 | 40 | |
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
12053 | 72144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000049.527 | 2091859.62504 | 37.7238504846937 | -122.441970156497 | (37.7238504846937, -122.441970156497) | 9 | 7 | 6 | 28861 | 25 | |||
14031 | 213996 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999758.63525 | 2094089.70358 | 37.7299571835696 | -122.443135805584 | (37.7299571835696, -122.443135805584) | 9 | 7 | 4 | 63 | 40 | |||
14032 | 49886 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
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 | |||
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 | ||
18559 | 70412 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1817 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6005464.04095 | 2092680.05814 | 37.7264102753879 | -122.423311341054 | (37.7264102753879, -122.423311341054) | 9 | 7 | 7 | 309 | 5 | |||
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 | ||
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 | ||
20112 | 213955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | 9 | 8 | 6 | 28861 | 24 | |||
21845 | 179297 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004358.25207 | 2093034.47753 | 37.7273209621682 | -122.427159238819 | (37.7273209621682, -122.427159238819) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
23953 | 213964 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994850.90322 | 2091215.19212 | 37.7217834109648 | -122.459894162891 | (37.7217834109648, -122.459894162891) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
30981 | 69392 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.7124713889678 | -122.435199299374 | (37.7124713889678, -122.435199299374) | 9 | 7 | 6 | 28861 | 5 | ||
31543 | 159341 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 40 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 01:44:00 PM | 3 | Width 0ft | 5998211.29778 | 2087238.08175 | 37.7110558677139 | -122.447991998028 | (37.7110558677139, -122.447991998028) | 9 | 7 | 6 | 28861 | 25 | ||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
32346 | 179313 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006918.39852 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | 9 | 3 | 7 | 309 | 5 | |||
32765 | 213953 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994770.43192 | 2090973.10157 | 37.7211140599462 | -122.460154799032 | (37.7211140599462, -122.460154799032) | 9 | 8 | 6 | 28861 | 24 | |||
32777 | 68466 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | 9 | 7 | 5 | 28861 | 25 | ||
33517 | 179311 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | 9 | 3 | 7 | 309 | 28 | |||
36052 | 179295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 103 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004297.98606 | 2093012.31391 | 37.7272566975202 | -122.42736600014 | (37.7272566975202, -122.42736600014) | 9 | 7 | 6 | 28861 | 5 | |||
37197 | 179291 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 65 Badger St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002393.53271 | 2094418.30005 | 37.731009322903 | -122.434050139316 | (37.731009322903, -122.434050139316) | 9 | 7 | 5 | 28861 | 25 | |||
37749 | 179298 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004373.55102 | 2093025.79015 | 37.7272979737044 | -122.427105731855 | (37.7272979737044, -122.427105731855) | 9 | 7 | 6 | 28861 | 5 | |||
38096 | 179333 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.7103709449371 | -122.436816206603 | (37.7103709449371, -122.436816206603) | 9 | 7 | 6 | 28861 | 5 | |||
38701 | 258325 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997933 | 2087452 | 37.7116273264288 | -122.448969257639 | (37.7116273264288, -122.448969257639) | 9 | 7 | 6 | 28861 | 25 | ||||
39384 | 213968 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995026.49617 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | 9 | 8 | 6 | 28861 | 24 | |||
40402 | 213992 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 20 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6001188.39506 | 2095218.69175 | 37.7331385451977 | -122.438273813388 | (37.7331385451977, -122.438273813388) | 9 | 7 | 5 | 63 | 40 | |||
43165 | 179305 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 226 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003843.99427 | 2092374.03152 | 37.7254784293655 | -122.428889961619 | (37.7254784293655, -122.428889961619) | 9 | 7 | 6 | 28861 | 5 | |||
43778 | 213947 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 300 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995892.36071 | 2091233.57233 | 37.7218937190991 | -122.456295465473 | (37.7218937190991, -122.456295465473) | 9 | 8 | 4 | 28861 | 24 | |||
46622 | 159220 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 372 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998655.59562 | 2087744.29121 | 37.7124711910608 | -122.446492798529 | (37.7124711910608, -122.446492798529) | 9 | 7 | 6 | 28861 | 25 | |||
47052 | 35739 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474287 | (37.7309887985962, -122.41246474287) | 9 | 3 | 7 | 309 | 28 | |
47390 | 179303 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 204 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003684.6928 | 2092628.55261 | 37.726168269631 | -122.429458795389 | (37.726168269631, -122.429458795389) | 9 | 7 | 6 | 28861 | 5 | |||
49154 | 87400 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
49398 | 68465 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 56 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32327 | 6002348.42397311 | 2094432.09629198 | 37.7310446440886 | -122.434207073572 | (37.7310446440886, -122.434207073572) | 9 | 7 | 5 | 28861 | 25 | ||
50534 | 179299 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004388.44448 | 2093015.96904 | 37.7272718493156 | -122.427053545987 | (37.7272718493156, -122.427053545987) | 9 | 7 | 6 | 28861 | 5 | |||
51007 | 27085 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 747 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X3 | 6006317.37103 | 2093607.15152 | 37.729003994832 | -122.420427188268 | (37.729003994832, -122.420427188268) | 9 | 7 | 7 | 309 | 5 | |||
51805 | 179306 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 272 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003680.49546 | 2092115.04602 | 37.7247580571263 | -122.429436701757 | (37.7247580571263, -122.429436701757) | 9 | 7 | 6 | 28861 | 5 | |||
51808 | 111862 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
56476 | 213969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995027.18674 | 2091165.82123 | 37.7216579869959 | -122.459281227274 | (37.7216579869959, -122.459281227274) | 9 | 8 | 6 | 28861 | 24 | |||
59889 | 213985 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 431 Capitol Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995022.34889 | 2088455.31671 | 37.714215306566 | -122.459101782823 | (37.714215306566, -122.459101782823) | 9 | 8 | 6 | 28861 | 24 | |||
60010 | 49885 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
60043 | 111861 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 201x LOBOS ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5994528 | 2088713 | 37.7148944123502 | -122.460829096166 | (37.7148944123502, -122.460829096166) | 9 | 8 | 6 | 28861 | 24 | ||||
60897 | 179327 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 332 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003477.0395 | 2091792.3955 | 37.7238606092698 | -122.430117017306 | (37.7238606092698, -122.430117017306) | 9 | 7 | 6 | 28861 | 5 | |||
61565 | 213950 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995061.44128 | 2090626.04133 | 37.7201778494978 | -122.459123753274 | (37.7201778494978, -122.459123753274) | 9 | 8 | 6 | 28861 | 24 | |||
64826 | 179314 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009038.30764 | 2093734.45696 | 37.7295065063148 | -122.411029655989 | (37.7295065063148, -122.411029655989) | 9 | 3 | 7 | 309 | 28 | |||
66270 | 39955 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.37216 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | 9 | 7 | 8 | 309 | 39 | |
68242 | 46849 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 273 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 5 | Permit Number 44917 | 6003953.72556 | 2091952.73307 | 37.7243278475403 | -122.428480614512 | (37.7243278475403, -122.428480614512) | 9 | 7 | 6 | 28861 | 5 | |
68931 | 39937 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.37071 | 2088298.86848 | 37.7145992918994 | -122.409550050915 | (37.7145992918994, -122.409550050915) | 9 | 7 | 8 | 309 | 39 | |
68952 | 213951 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 319 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994724.048 | 2090709.90077 | 37.7203887054465 | -122.460296073498 | (37.7203887054465, -122.460296073498) | 9 | 8 | 6 | 28861 | 24 | |||
69735 | 213957 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5994771.7805 | 2091087.85201 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | 9 | 8 | 6 | 28861 | 24 | |||
73627 | 213942 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15 Westgate Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993008.95688 | 2093342.09181 | 37.7275172527173 | -122.466415744194 | (37.7275172527173, -122.466415744194) | 9 | 8 | 4 | 59 | 40 | |||
73942 | 213970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995027.09423 | 2091143.79671 | 37.721597507608 | -122.459279952927 | (37.721597507608, -122.459279952927) | 9 | 8 | 6 | 28861 | 24 | |||
76064 | 4354 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 15X Burnside Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2008 12:00:00 AM | 3 | 3X3 | 6001141.00413 | 2095696.99513 | 37.7344491599181 | -122.438471913289 | (37.7344491599181, -122.438471913289) | 9 | 7 | 5 | 63 | 7 | ||
76177 | 213976 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995023.46765 | 2090970.59824 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | 9 | 8 | 6 | 28861 | 24 | |||
79546 | 179334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1119 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6001947.96661 | 2087712.00011 | 37.7125700310481 | -122.435111061438 | (37.7125700310481, -122.435111061438) | 9 | 7 | 6 | 28861 | 5 | |||
80513 | 179296 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004346.75764 | 2093042.32572 | 37.7273418615316 | -122.42719953384 | (37.7273418615316, -122.42719953384) | 9 | 7 | 6 | 28861 | 5 | |||
81774 | 65172 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 332 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27153 | 6003474.08618593 | 2091790.3446491 | 37.72385481082 | -122.430127080192 | (37.72385481082, -122.430127080192) | 9 | 7 | 6 | 28861 | 5 | ||
82678 | 68464 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 52 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32326 | 6002331.05144197 | 2094486.37219697 | 37.7311926873179 | -122.434271012127 | (37.7311926873179, -122.434271012127) | 9 | 7 | 5 | 28861 | 25 | ||
83545 | 179300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 318 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003594.26211 | 2092734.45611 | 37.7264539365874 | -122.429778959455 | (37.7264539365874, -122.429778959455) | 9 | 7 | 6 | 28861 | 5 | |||
83858 | 179336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 225 Naylor St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6002643.14283 | 2086748.99011 | 37.7099652661681 | -122.43263957156 | (37.7099652661681, -122.43263957156) | 9 | 7 | 6 | 28861 | 5 | |||
84593 | 35042 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 158 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/1998 12:00:00 AM | Permit Number 38609 | 5996885.33354798 | 2089115.06440217 | 37.7161337438742 | -122.452710206461 | (37.7161337438742, -122.452710206461) | 9 | 8 | 6 | 28861 | 24 | ||
85785 | 213967 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.459614919817 | (37.72178341096, -122.459614919817) | 9 | 8 | 6 | 28861 | 24 | |||
87195 | 213966 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 621 Holloway Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994898.75092 | 2091213.04066 | 37.7217802552317 | -122.459728611213 | (37.7217802552317, -122.459728611213) | 9 | 8 | 6 | 28861 | 24 | |||
87242 | 85246 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 121 Italy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49547 | 6001091.3 | 2089693.7 | 37.7179626543102 | -122.438213837389 | (37.7179626543102, -122.438213837389) | 9 | 7 | 6 | 28861 | 5 | |||
87382 | 16010 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 100X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 2 | 4 | 6001411.9312264 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | 9 | 7 | 4 | 63 | 40 | |||
87766 | 179326 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 327 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003741.70772 | 2091620.88811 | 37.7234046745582 | -122.429189879225 | (37.7234046745582, -122.429189879225) | 9 | 7 | 6 | 28861 | 5 | |||
88049 | 87399 | - 12 | Pyrus kawakamii :: Evergreen Pear 83 | 400X Monterey Blvd | 9 | Median : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5999413.960874 | 2094696.855647 | 37.7316046219852 | -122.44437099815 | (37.7316046219852, -122.44437099815) | 9 | 7 | 4 | 59 | 40 | ||
88464 | 179292 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 180 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004024.15435 | 2092667.65473 | 37.7262948492128 | -122.428288081343 | (37.7262948492128, -122.428288081343) | 9 | 7 | 6 | 28861 | 5 | |||
88487 | 213958 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 360 Faxon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994774.32905 | 2091126.87145 | 37.7215364993901 | -122.460152462564 | (37.7215364993901, -122.460152462564) | 9 | 8 | 6 | 28861 | 24 | |||
88905 | 258327 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 109 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998030 | 2087350 | 37.7113528047065 | -122.448626659544 | (37.7113528047065, -122.448626659544) | 9 | 7 | 6 | 28861 | 25 | ||||
89213 | 179329 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 381 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003114.67783 | 2091636.05117 | 37.7234107926576 | -122.431358486426 | (37.7234107926576, -122.431358486426) | 9 | 7 | 6 | 28861 | 5 | |||
89744 | 179307 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 263 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6003768.55013 | 2092162.80496 | 37.724894177618 | -122.429135711245 | (37.724894177618, -122.429135711245) | 9 | 7 | 6 | 28861 | 5 | |||
91043 | 213979 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.7192047992523 | -122.46014259432 | (37.7192047992523, -122.46014259432) | 9 | 8 | 6 | 28861 | 24 | |||
91148 | 258326 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 111 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997997 | 2087369 | 37.7114030873569 | -122.448742083083 | (37.7114030873569, -122.448742083083) | 9 | 7 | 6 | 28861 | 25 | ||||
92858 | 179287 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002285.23223 | 2094449.03286 | 37.7310875612396 | -122.434426748408 | (37.7310875612396, -122.434426748408) | 9 | 7 | 5 | 28861 | 25 | |||
93807 | 31159 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 159 Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34861 | 5992168.57477518 | 2088923.19870563 | 37.7153355266741 | -122.46899947505 | (37.7153355266741, -122.46899947505) | 9 | 8 | 6 | 64 | 24 | ||
94237 | 179310 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 433 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006956.66212 | 2092492.35946 | 37.7259790226133 | -122.418138103411 | (37.7259790226133, -122.418138103411) | 9 | 3 | 7 | 309 | 28 | |||
94497 | 213943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995156.25779 | 2093258.26131 | 37.727410745106 | -122.458986493338 | (37.727410745106, -122.458986493338) | 9 | 7 | 4 | 28861 | 40 | |||
95671 | 179330 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 21 Drake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001459.59412 | 2086865.71976 | 37.7102185880902 | -122.43673848452 | (37.7102185880902, -122.43673848452) | 9 | 7 | 6 | 28861 | 5 | |||
95813 | 213949 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 223 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994439.27208 | 2091407.20179 | 37.7222869413827 | -122.461330966572 | (37.7222869413827, -122.461330966572) | 9 | 8 | 4 | 28861 | 24 | |||
96641 | 83904 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50528 | 6000071.45882216 | 2091861.79510204 | 37.7238576929528 | -122.441894497682 | (37.7238576929528, -122.441894497682) | 9 | 7 | 6 | 28861 | 25 |
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) );