1,098 rows where qCaretaker_id = 4 sorted by qLegalStatus_id

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)
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
14697 76382 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351) 1 8 3 56 35
14855 75049 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6003005.92399 2092563.39586 37.7259509097926 -122.431800609333 (37.7259509097926, -122.431800609333) 9 7 6 28861 5
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
15357 98942 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
15390 60892 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/11/1983 12:00:00 AM 16 5x5 Permit Number 20677 6008514.66964 2119698.45237 37.8007682484075 -122.414676612845 (37.8007682484075, -122.414676612845) 5 1 10 308 32
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
16064 235284 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 4235 19th St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.436539154285 (37.7591334867264, -122.436539154285) 2 4 5 28862 3
16157 263597 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private 03/07/2007 12:00:00 AM   3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
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
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
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
17099 96505 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 7 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
17218 77646 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006863.07514 2093156.65739 37.7277977728371 -122.418508712231 (37.7277977728371, -122.418508712231) 9 3 7 309 5
17259 77657 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006712.15653 2093290.62233 37.7281571140509 -122.41903993995 (37.7281571140509, -122.41903993995) 9 3 7 309 5
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
17590 73937 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/07/1990 12:00:00 AM 10 3x3   6001944.69626247 2104668.40530987 37.7591282168027 -122.436335144342 (37.7591282168027, -122.436335144342) 2 4 5 28862 3
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
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
18051 77661 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6006687.82384 2093371.12447 37.7283767851556 -122.419129766951 (37.7283767851556, -122.419129766951) 9 3 7 309 5
18070 99372 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 499X 29th Ave 26 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x3   5986859.5 2112566.5 37.7799454996166 -122.489086903101 (37.7799454996166, -122.489086903101) 11 6 2 55 26
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
18275 110955 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9 5x5   6008486.88199 2119694.39066 37.8007555347125 -122.414772482377 (37.8007555347125, -122.414772482377) 5 1 10 308 32
18291 263593 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
18361 173682 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450x Raymond Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6008515 2088365 37.7147337500707 -122.412459395375 (37.7147337500707, -122.412459395375) 9 7 8 309 18
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
18509 76705 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6003030.53484 2092605.75448 37.7260686121528 -122.431718554264 (37.7260686121528, -122.431718554264) 9 7 6 28861 5
18625 113033 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 251 06th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993974.82941 2113822.74411 37.7838075380241 -122.464563239136 (37.7838075380241, -122.464563239136) 11 6 2 54 11
18687 104158 DPW Maintained 1 :: 45 525X Church St 6 Sidewalk: Curb side : Cutout Landscaping SFUSD 4 DPW     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
18929 76784 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1501X 42nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.501509810878 (37.7577472058325, -122.501509810878) 1 8 3 56 35
18970 97073 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
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
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
21058 98632 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x4   6002258.48202 2120196.40471 37.801782011886 -122.436361251288 (37.801782011886, -122.436361251288) 13 9 1 57 17
21099 76027 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x4   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
21524 96504 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 5 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
21542 98642 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 21 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002233.86885 2120387.28696 37.8023047257379 -122.436460093962 (37.8023047257379, -122.436460093962) 13 9 1 57 17
22092 30745 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 486X Page St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004274.8073 2109806.6859 37.773368818647 -122.42864278458 (37.773368818647, -122.42864278458) 7 9 11 28852 10
22336 98569 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 7 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
23043 95519 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     5 3x3   5985993.74648 2111883.31804 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445) 11 6 2 55 26
23321 95480 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   8 3x3   5986567.36684 2111939.07455 37.7782057127303 -122.490051346189 (37.7782057127303, -122.490051346189) 11 6 2 55 26
23426 99331 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986581.6367 2112796.91447 37.7805619300043 -122.490065095801 (37.7805619300043, -122.490065095801) 11 6 2 55 26
23432 95461 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   10 3x3   5986588.1418 2111391.86812 37.7767044523908 -122.489939222082 (37.7767044523908, -122.489939222082) 11 6 2 55 26
23498 76685 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/08/1992 12:00:00 AM 10 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
23622 99684 DPW Maintained 1 Tree(s) :: 17 165 Grattan St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/04/2013 12:00:00 AM 8 3x3 Permit Number 770537 5997880.8 2106478.8 37.7638673579207 -122.450520485859 (37.7638673579207, -122.450520485859) 15 5 11 29492 9
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
23669 42343 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 2 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
23905 96578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 8 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
23915 96577 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 401x Otsego Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM 2 3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
24124 142520 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009467.3323 2121175.1455 37.8048763586912 -122.411484377145 (37.8048763586912, -122.411484377145) 3 1 10 308 23
24143 99344 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 450 30th Ave 22 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5986571.83486 2113111.88593 37.7814261792312 -122.490122179259 (37.7814261792312, -122.490122179259) 11 6 2 55 26
24208 76687 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 163X London St 6 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
24349 97071 DPW Maintained 1 Tree(s) :: 17 1551 Newcomb Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 4x4   6015475.3 2095481.7 37.7346629526589 -122.388898077079 (37.7346629526589, -122.388898077079) 10 3 8 58 1
24577 99676 DPW Maintained 1 Tree(s) :: 17 1250X Shrader St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
24846 99691 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
24959 98573 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 11 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
25070 98562 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 5 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
25180 30744 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 380 Webster St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004178.56485 2109886.01831 37.7735811988523 -122.428981357915 (37.7735811988523, -122.428981357915) 7 9 11 28852 10
25347 98970 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
25637 76093 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 3x3   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
25949 30741 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 490X Page St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 6 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
26191 99549 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 200X Henry St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
26495 42983 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 2X Yale St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/16/2000 12:00:00 AM 4 4x4 Permit Number 42867 6006665.25419982 2093600.88939651 37.7290063985797 -122.419224083243 (37.7290063985797, -122.419224083243) 9 3 7 309 5
27553 97723 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1000X Bay St 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
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
27818 98647 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   12 5x5   6002751.94545 2119240.19821 37.7991845449763 -122.434585229619 (37.7991845449763, -122.434585229619) 13 9 1 57 17
28466 98940 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
28985 95477 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   8 3x3   5986565.00775 2112026.27031 37.7784449897253 -122.490065922262 (37.7784449897253, -122.490065922262) 11 6 2 55 26
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
30370 98969 DPW Maintained 1 Arbutus unedo :: Strawberry Tree 106 825 Shotwell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
30715 73286 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1600X GREEN ST 9 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
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
31112 96772 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 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
31577 104151 DPW Maintained 1 :: 45 525X Church St 1 Sidewalk: Property side : Cutout Landscaping SFUSD 4 DPW     2x58   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895) 8 4 5 28862 3
32232 99335 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 450 30th Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   30 3.5x3.5   5986578.25407 2112899.8451 37.780844350584 -122.490084370963 (37.780844350584, -122.490084370963) 11 6 2 55 26
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
33247 99356 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986838.12863 2112989.55693 37.781105845983 -122.489191947731 (37.781105845983, -122.489191947731) 11 6 2 55 26
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
33876 115549 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015281.58054 2104112.34112 37.7583501556473 -122.390170593412 (37.7583501556473, -122.390170593412) 10 3 8 28856 29
34106 31711 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 1250X Shrader St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/19/1995 12:00:00 AM 6 3x3 Permit Number 35211 5997882.313818 2106467.94501531 37.7638376395234 -122.450514467435 (37.7638376395234, -122.450514467435) 15 5 11 29492 9
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
34496 99371 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 451X 29th Ave 25 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5986853.20034 2112633.29686 37.7801285370834 -122.489113608336 (37.7801285370834, -122.489113608336) 11 6 2 55 26
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
35366 116063 DPW Maintained 1 Brachychiton discolor :: 437 2100x 19th St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   19 3x3   6011332.66531 2105125.78364 37.7609130247313 -122.403899073603 (37.7609130247313, -122.403899073603) 10 3 8 28856 29
35455 47256 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1035 Gilman Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/09/2002 12:00:00 AM 6 3x3 Permit Number 45198 6015368.10493708 2089617.80548286 37.7185559218928 -122.388859444456 (37.7185559218928, -122.388859444456) 10 3 8 58 1
35960 99029 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 200X Bartlett St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
35970 122754 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 693 Vermont St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16     6011277.36342 2105334.1858 37.7614821606899 -122.404105006665 (37.7614821606899, -122.404105006665) 10 3 8 28856 29
36069 99326 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 450 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5986588.88353 2112653.99552 37.7801699385412 -122.490029510836 (37.7801699385412, -122.490029510836) 11 6 2 55 26
36159 37832 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 19 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048) 9 7 6 28861 5
36285 95758 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003422.17585 2092210.81209 37.7250063806226 -122.430336510319 (37.7250063806226, -122.430336510319) 9 7 6 28861 5
36405 98645 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 2110 Greenwich St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9 5x5   6002788.88101 2119245.38589 37.7992008856766 -122.434457791187 (37.7992008856766, -122.434457791187) 13 9 1 57 17
36749 122752 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
36927 95272 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2245 Jones St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/08/2011 12:00:00 AM 3 3x3   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32

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