trees
251 rows where DBH = 3 and qCaretaker_id = 4 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
19099 | 113032 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5993973.41927 | 2113841.38508 | 37.7838586397785 | -122.464569471656 | (37.7838586397785, -122.464569471656) | 11 | 6 | 2 | 54 | 11 | |||
34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
66912 | 95490 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.65609 | 2111463.21002 | 37.7768664240251 | -122.491952519112 | (37.7768664240251, -122.491952519112) | 11 | 6 | 2 | 55 | 26 | |||
67077 | 113468 | Undocumented 4 | Ficus retusa nitida :: Banyan Fig 54 | 450 CHURCH ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 06/21/2016 02:14:00 PM | 3 | 6x7 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
81910 | 225512 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 01/08/2019 12:00:00 AM | 3 | 6x6 | 6004203.25115 | 2106055.40872 | 37.7630646689183 | -122.428622853063 | (37.7630646689183, -122.428622853063) | 8 | 4 | 5 | 28862 | 3 | ||
85468 | 95510 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:35:00 PM | 3 | 3x3 | 5985969.9 | 2112493.2 | 37.7796922752829 | -122.492158984519 | (37.7796922752829, -122.492158984519) | 11 | 6 | 2 | 55 | 26 | ||
90011 | 256555 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 4 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:48:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
102329 | 91788 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 830X Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012494.965717 | 2112152.388469 | 37.7802713613915 | -122.400372717325 | (37.7802713613915, -122.400372717325) | 6 | 2 | 9 | 28856 | 34 | ||
102454 | 131001 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 937 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6007906.15602 | 2120261.72441 | 37.8022806446072 | -122.416822257668 | (37.8022806446072, -122.416822257668) | 5 | 1 | 10 | 308 | 32 | |||
104893 | 95486 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986007.39345 | 2111549.75354 | 37.7771040325177 | -122.491959800837 | (37.7771040325177, -122.491959800837) | 11 | 6 | 2 | 55 | 26 | |||
113363 | 95502 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500X 32nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985980.32699 | 2112340.5385 | 37.7792737200362 | -122.492111670045 | (37.7792737200362, -122.492111670045) | 11 | 6 | 2 | 55 | 26 | |||
118940 | 95491 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986009.30138 | 2111441.61533 | 37.7768072273274 | -122.491945237383 | (37.7768072273274, -122.491945237383) | 11 | 6 | 2 | 55 | 26 | |||
123758 | 95505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X 32nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.87909 | 2112248.55872 | 37.7790213190615 | -122.492096067193 | (37.7790213190615, -122.492096067193) | 11 | 6 | 2 | 55 | 26 | |||
127080 | 112029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
152325 | 95504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500X 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5985982.4173 | 2112269.22924 | 37.7790780474023 | -122.492099187045 | (37.7790780474023, -122.492099187045) | 11 | 6 | 2 | 55 | 26 | |||
160497 | 95509 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:37:00 PM | 3 | 3x3 | 5985988.58257 | 2112092.73248 | 37.7785937981587 | -122.492064860632 | (37.7785937981587, -122.492064860632) | 11 | 6 | 2 | 55 | 26 | ||
166601 | 95494 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986000.13497 | 2111717.29406 | 37.7775636267397 | -122.491997248036 | (37.7775636267397, -122.491997248036) | 11 | 6 | 2 | 55 | 26 | |||
174726 | 112028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101x 22nd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 9x9 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
177073 | 95511 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:32:00 PM | 3 | 3x3 | 5985988.37339 | 2112068.78219 | 37.7785280252799 | -122.492063820389 | (37.7785280252799, -122.492063820389) | 11 | 6 | 2 | 55 | 26 | ||
187598 | 112025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
191041 | 95487 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5986008.46306 | 2111529.36899 | 37.7770481248733 | -122.491954599624 | (37.7770481248733, -122.491954599624) | 11 | 6 | 2 | 55 | 26 | |||
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
14472 | 100972 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | |
17603 | 75990 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.402853834756 | (37.7984395708796, -122.402853834756) | 3 | 1 | 10 | 308 | 23 | ||
66219 | 100977 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | Permit Number 37341 | 6009542.7178 | 2120879.1139 | 37.8040677578058 | -122.411202572075 | (37.8040677578058, -122.411202572075) | 3 | 1 | 10 | 308 | 23 | ||
101825 | 97903 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 375X Precita Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
109710 | 97896 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
126964 | 97897 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 | |
154088 | 95241 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
155740 | 95235 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1220 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6002897.4 | 2101092.2 | 37.7493628934568 | -122.432784769514 | (37.7493628934568, -122.432784769514) | 2 | 4 | 5 | 28862 | 22 | ||
169010 | 102195 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
188027 | 100980 | DPW Maintained 1 | Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 | 2190 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 05/03/2013 12:00:00 AM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
189482 | 97895 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
6745 | 74583 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995884.6031 | 2113341.96396 | 37.7825973527613 | -122.457921374418 | (37.7825973527613, -122.457921374418) | 11 | 6 | 1 | 54 | 31 | |
7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
7428 | 78326 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.393623269718 | (37.7312919429706, -122.393623269718) | 10 | 3 | 8 | 58 | 1 | ||
7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
7953 | 97241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464 | 2092306.9 | 37.7252725856131 | -122.430198780788 | (37.7252725856131, -122.430198780788) | 9 | 7 | 6 | 28861 | 5 |
8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
8452 | 116055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2020 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.403280067548 | (37.7611252557522, -122.403280067548) | 10 | 3 | 8 | 28856 | 29 | |
11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
11450 | 93122 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995895.24901 | 2113041.91566 | 37.7817741116959 | -122.457862824896 | (37.7817741116959, -122.457862824896) | 11 | 6 | 1 | 54 | 31 | |
11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
12599 | 93632 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995882.07932 | 2113403.99303 | 37.7827675230466 | -122.457934595796 | (37.7827675230466, -122.457934595796) | 11 | 6 | 1 | 54 | 31 |
12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
14250 | 116051 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011500.28754 | 2105307.13541 | 37.7614203394907 | -122.403332096897 | (37.7614203394907, -122.403332096897) | 10 | 3 | 8 | 28856 | 29 | ||
14678 | 96770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | 10 | 3 | 8 | 58 | 1 | |
14886 | 51359 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.7316638818713 | -122.393534297068 | (37.7316638818713, -122.393534297068) | 10 | 3 | 8 | 58 | 1 |
15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
15783 | 78330 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556205 | (37.7314628339206, -122.39358556205) | 10 | 3 | 8 | 58 | 1 | ||
15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 | |
18431 | 51369 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889599 | (37.7324395857978, -122.39335889599) | 10 | 3 | 8 | 58 | 1 |
19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
20224 | 98090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | 13 | 9 | 10 | 28858 | 21 | ||
20458 | 42640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.425830717123 | (37.7982497015198, -122.425830717123) | 13 | 9 | 1 | 57 | 17 |
20806 | 102022 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
23641 | 43313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.7261197629015 | -122.431680307904 | (37.7261197629015, -122.431680307904) | 9 | 7 | 6 | 28861 | 5 |
24545 | 70470 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
27765 | 37839 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.01474 | 2090473.5929 | 37.7202497170415 | -122.42939741397 | (37.7202497170415, -122.42939741397) | 9 | 7 | 6 | 28861 | 5 |
30203 | 95755 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.90146 | 2092257.04406 | 37.7251349504027 | -122.430240505894 | (37.7251349504027, -122.430240505894) | 9 | 7 | 6 | 28861 | 5 |
30221 | 95757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:33:00 PM | 3 | 3x3 | Permit Number 767495 | 6003435.4103 | 2092233.16774 | 37.7250685138993 | -122.430292354528 | (37.7250685138993, -122.430292354528) | 9 | 7 | 6 | 28861 | 5 |
30823 | 96774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | |
32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
33305 | 102189 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 11 | 6 | 2 | 55 | 26 | ||
34474 | 95271 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:36:00 PM | 3 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
34835 | 71106 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
35858 | 102033 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 |
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) );