1,098 rows where qCaretaker_id = 4 sorted by rowid descending

View and edit SQL

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)
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
194372 37826 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003896.37457 2090444.78719 37.7201841150858 -122.428571430748 (37.7201841150858, -122.428571430748) 9 7 6 28861 5
194156 47257 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/08/2009 12:00:00 AM 6 3x3 Permit Number 52469 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
194074 95493 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 600X 32nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986013.17376 2111397.5149 37.7766863664514 -122.491928594282 (37.7766863664514, -122.491928594282) 11 6 2 55 26
193722 77213 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 499X Hearst Ave 20 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
193697 43905 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 1050 York St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/26/2002 12:00:00 AM 6 3x3 Permit Number 43505 6009958.09497236 2103085.10649041 37.7552328939148 -122.408509176777 (37.7552328939148, -122.408509176777) 2 4 7 28859 19
193525 99685 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
192959 76112 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
192694 95270 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2245 Jones St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
192623 99547 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
192030 256356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
191936 100987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
191362 97733 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005736.8865 2120695.23683 37.8033487055393 -122.424359846228 (37.8033487055393, -122.424359846228) 5 9 1 28858 32
191330 42986 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 2X Yale St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 3 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
191220 95472 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986558.09049 2112203.93573 37.7789324044573 -122.490102922958 (37.7789324044573, -122.490102922958) 11 6 2 55 26
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
191029 95148 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14     5988724.77962 2113566.52719 37.7827999873072 -122.482707449869 (37.7827999873072, -122.482707449869) 11 6 2 55 26
191008 142543 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 Width 0ft   6009503.7886 2121178.1337 37.8048866083098 -122.411358426924 (37.8048866083098, -122.411358426924) 3 1 10 308 23
190932 253728 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
190901 92956 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
190377 32727 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.97569 2088634.0427 37.7147061970204 -122.459105637321 (37.7147061970204, -122.459105637321) 9 8 6 28861 24
190317 95259 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
190278 96494 DPW Maintained 1 Washingtonia filifera :: California Fan Palm 176 2500X Harrison St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     5x5   6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 9 7 6 28861 5
189654 95453 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986555.22372 2112267.25724 37.7791060998783 -122.490117499027 (37.7791060998783, -122.490117499027) 11 6 2 55 26
189611 76325 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
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
189404 96510 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323) 2 4 7 28859 19
189331 92957 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 300 Seneca Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
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
189005 75040 DPW Maintained 1 Tree(s) :: 17 499X Hearst Ave 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 18 6x20   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
188990 98560 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
188988 98791 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950 Clay St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484) 3 1 10 28857 4
188665 47198 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 8 4x4 Permit Number 45157 5986584.00139 2112756.95832 37.7804523599117 -122.490053975567 (37.7804523599117, -122.490053975567) 11 6 2 55 26
188448 113470 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 450 CHURCH ST 27 Sidewalk: Curb side : Cutout Tree SFUSD 4       6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
188415 99369 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 23 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x3   5986847.81361 2112672.32158 37.7802353734381 -122.489135113122 (37.7802353734381, -122.489135113122) 11 6 2 55 26
188359 95262 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
188131 97727 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3 Permit Number 50638 6005898.3389 2120719.31411 37.8034239311172 -122.423802846647 (37.8034239311172, -122.423802846647) 5 9 1 28858 32
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
187692 95457 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986582.95432 2111498.49198 37.776996908357 -122.489965010916 (37.776996908357, -122.489965010916) 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
187446 37835 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 21 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752 2090699 37.720873955994 -122.429088601305 (37.720873955994, -122.429088601305) 9 7 6 28861 5
187308 108788 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1100-1198X Schwerin St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.13658 2087632.54285 37.7127552255458 -122.410395595682 (37.7127552255458, -122.410395595682) 9 7 8 309 39
187263 96085 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
186894 96605 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186220 77209 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 5 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
185959 102026 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 6 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
185924 95496 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X 32nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5986002.12653 2111683.71465 37.7774715436696 -122.491987885766 (37.7774715436696, -122.491987885766) 11 6 2 55 26
185821 95518 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985992.05689 2111902.81718 37.7780725480885 -122.492038855286 (37.7780725480885, -122.492038855286) 11 6 2 55 26
185651 98627 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3500X Fillmore St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 6x6   6002279.94472 2120071.20683 37.801439470916 -122.43627801544 (37.801439470916, -122.43627801544) 13 9 1 57 17
185623 99257 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5995884.63149 2113369.41772 37.7826727350965 -122.457923263549 (37.7826727350965, -122.457923263549) 11 6 1 54 31
185618 98973 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
185294 98616 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005322.90286 2118744.78417 37.7979698765663 -122.425653549774 (37.7979698765663, -122.425653549774) 13 9 1 57 17
185247 108782 DPW Maintained 1 Crataegus phaenopyrum :: Washington Hawthorn 102 2055 Sunnydale Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005606.4158 2088034.4515 37.713662477117 -122.422489201534 (37.713662477117, -122.422489201534) 9 7 8 309 18
185078 113572 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 901 LOMBARD ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
184992 96603 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
184931 97734 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1150 Francisco St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3 Permit Number 50638 6005715.83773 2120693.51258 37.8033427825912 -122.424432563629 (37.8033427825912, -122.424432563629) 5 9 1 28858 32
184781 116053 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 650x Kansas St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   11 4x4   6011508.10962 2105241.51829 37.7612406063998 -122.403300427289 (37.7612406063998, -122.403300427289) 10 3 8 28856 29
184336 37815 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
184196 122755 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 693 Vermont St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14     6011274.22678 2105356.76628 37.7615439863765 -122.404117444276 (37.7615439863765, -122.404117444276) 10 3 8 28856 29
184091 92963 Permitted Site 7 Tree(s) :: 17 1515 Quintara St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53121 5988690.8 2100920.9 37.7480765758445 -122.481898390884 (37.7480765758445, -122.481898390884) 1 8 3 29491 35
184034 76675 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
183898 73288 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1999 12:00:00 AM 8 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
183831 102192 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 7 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
183752 95147 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   13     5988726.59645 2113538.2792 37.7827225319963 -122.482699093759 (37.7827225319963, -122.482699093759) 11 6 2 55 26
183530 95751 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:36:00 PM 3 3x3 Permit Number 767495 6003552.81378 2092420.08444 37.7255883948789 -122.429899830124 (37.7255883948789, -122.429899830124) 9 7 6 28861 5
183365 251680 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
183257 98751 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
183108 99680 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 165 Grattan St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
182607 100976 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   5   Permit Number 37341 6009558.1383 2120880.7372 37.8040730797801 -122.411149322876 (37.8040730797801, -122.411149322876) 3 1 10 308 23
182513 42356 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
182487 256357 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
182392 97247 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003399 2092092 37.7246788362927 -122.430408153397 (37.7246788362927, -122.430408153397) 9 7 6 28861 5
182167 99024 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 3351X 23rd St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006571 2102346.4 37.7530143054678 -122.420170352411 (37.7530143054678, -122.420170352411) 2 4 7 28859 19
181911 37840 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.54171 37.7203135455184 -122.429349222898 (37.7203135455184, -122.429349222898) 9 7 6 28861 5
181422 99357 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5986839.06552 2112970.96623 37.7810548559101 -122.489187339385 (37.7810548559101, -122.489187339385) 11 6 2 55 26
181086 253730 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 350 Girard St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x12   6010529 2093052 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175) 10 3 7 309 28
180726 77634 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2X Yale St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/26/1984 12:00:00 AM 14 4x4   6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
180710 42358 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 5 4x4 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
180684 116050 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650x Kansas St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 4x4   6011499.79329 2105331.08163 37.7614860628578 -122.403335490949 (37.7614860628578, -122.403335490949) 10 3 8 28856 29
180518 42642 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 5 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
180505 112060 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
180230 96584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
180121 92959 Permitted Site 7 Tree(s) :: 17 300 Seneca Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
180042 99682 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 165 Grattan St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
179937 98614 DPW Maintained 1 Vitex lucens :: Puriri tree 492 2501X Franklin St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6005316.85787 2118791.40908 37.7980975551137 -122.425677787418 (37.7980975551137, -122.425677787418) 13 9 1 57 17
179818 98748 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 540X Eureka St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6001522.2 2102674.7 37.7536299686816 -122.437653552201 (37.7536299686816, -122.437653552201) 2 4 5 28862 22
179485 98802 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x CLAY ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
178939 47202 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801X Clement St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/2002 12:00:00 AM 12 3x3 Permit Number 45157 5986698.68199 2113217.08014 37.7817224192006 -122.489691093913 (37.7817224192006, -122.489691093913) 11 6 2 55 26
178848 32728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.59612 2088615.91363 37.714656397048 -122.459105637326 (37.714656397048, -122.459105637326) 9 8 6 28861 24
178792 115969 DPW Maintained 1 Olea europaea :: Olive Tree 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
178733 115972 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986817.4474 2104547.1317 37.7579240985888 -122.488642781125 (37.7579240985888, -122.488642781125) 1 8 3 56 35
178370 112061 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1199 VISITACION AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     4x4   6009231 2087548 37.7125305915537 -122.409926954579 (37.7125305915537, -122.409926954579) 9 7 8 309 39
177916 113574 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
177702 76170 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 5 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
177484 98565 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
177368 102023 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 3 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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);