1,098 rows where qCaretaker_id = 4 sorted by qLegalStatus_id

View and edit SQL

qCareAssistant

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)
80 260998 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree SFUSD 4       10x10                      
167 99668 DPW Maintained 1 Tree(s) :: 17 150X Alma St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
297 113036 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
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
1119 113031 DPW Maintained 1 Quercus suber :: Cork Oak 78 251 06th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665) 11 6 2 54 11
1121 77643 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x4   6006923.44086 2093174.37286 37.7278498138936 -122.418301281799 (37.7278498138936, -122.418301281799) 9 3 7 309 5
1341 76159 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 10 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
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
1406 75132 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 148X Paris St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002992.10347 2092540.72564 37.7258878789975 -122.431846767938 (37.7258878789975, -122.431846767938) 9 7 6 28861 5
1502 77647 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1300X Silliman St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6006841.82551 2093150.82877 37.7277805724005 -122.418581759638 (37.7277805724005, -122.418581759638) 9 3 7 309 5
2028 76748 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631) 1 8 3 56 35
2079 263595 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
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
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
3327 99692 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 2x2   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
3404 74737 DPW Maintained 1 Taxus baccata :: Irish Yew 86 151X Palm Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5995889.08215 2113282.06845 37.7824331529909 -122.457901543211 (37.7824331529909, -122.457901543211) 11 6 1 54 31
3604 77660 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006693.80957 2093349.88561 37.7283188049508 -122.419107568078 (37.7283188049508, -122.419107568078) 9 3 7 309 5
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
3789 77644 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6006907.53511 2093169.55905 37.7278357008551 -122.41835592728 (37.7278357008551, -122.41835592728) 9 3 7 309 5
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
3976 75213 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002883.60734 2092451.48886 37.7256367037627 -122.43221546119 (37.7256367037627, -122.43221546119) 9 7 6 28861 5
4032 263594 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
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
4867 76353 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006742.79477 2093189.9157 37.7278823207912 -122.418926882581 (37.7278823207912, -122.418926882581) 9 3 7 309 5
4900 263589 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 800 Harrison St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012532 2112188 37.7803712075622 -122.400247099708 (37.7803712075622, -122.400247099708) 6 2 9 28856 34
4935 263596 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
5047 37814 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003977.37565 2090552.2455 37.720483755714 -122.428299091747 (37.720483755714, -122.428299091747) 9 7 6 28861 5
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
5378 76652 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 148X Paris St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6002965.38435 2092499.73249 37.7257738062998 -122.43193620819 (37.7257738062998, -122.43193620819) 9 7 6 28861 5
5484 71815 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151X Palm Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   5995888.68435 2113315.23973 37.7825242096287 -122.45790532062 (37.7825242096287, -122.45790532062) 11 6 1 54 31
5500 77664 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006642.94243 2093520.00504 37.728783051183 -122.419295481395 (37.728783051183, -122.419295481395) 9 3 7 309 5
5610 46958 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
5633 76756 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
5695 77663 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 3x3   6006674.08558 2093407.54115 37.7284760037541 -122.419179842976 (37.7284760037541, -122.419179842976) 9 3 7 309 5
5845 96500 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2360X Harrison St 1 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
5947 76372 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006736.19364 2093210.27498 37.7279378512454 -122.418951146283 (37.7279378512454, -122.418951146283) 9 3 7 309 5
6227 77210 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 17 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
6245 75019 DPW Maintained 1 Taxus baccata :: Irish Yew 86 151X Palm Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5995892.05475 2113163.21783 37.782106991639 -122.457882656117 (37.782106991639, -122.457882656117) 11 6 1 54 31
6638 77652 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006723.02825 2093252.77715 37.7280538116191 -122.41899967279 (37.7280538116191, -122.41899967279) 9 3 7 309 5
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
6926 96580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 5 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
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
7380 75048 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6003019.45241 2092585.35122 37.7260119611657 -122.431755409402 (37.7260119611657, -122.431755409402) 9 7 6 28861 5
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
7643 263592 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
7682 76663 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 148X Paris St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002979.0601 2092519.08061 37.725827707182 -122.431890313086 (37.725827707182, -122.431890313086) 9 7 6 28861 5
7708 76081 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 7 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
7775 77645 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x4   6006883.85072 2093162.97754 37.7278162961767 -122.418437338432 (37.7278162961767, -122.418437338432) 9 3 7 309 5
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
7851 220311 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     18 Width 3ft   6001938.02984 2104676.35813 37.7591496745354 -122.436358769151 (37.7591496745354, -122.436358769151) 2 4 5 28862 3
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
8020 95515 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 600X 32nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5985992.57608 2111969.58011 37.7782558903759 -122.492041976045 (37.7782558903759, -122.492041976045) 11 6 2 55 26
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
8399 95483 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 601X 30th Ave 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   5986569.82886 2111856.71768 37.7779797279503 -122.490036770148 (37.7779797279503, -122.490036770148) 11 6 2 55 26
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
8515 76311 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 299X Cambridge St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   4 0   6006754.26056 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584) 9 3 7 309 5
8555 77658 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6006705.39704 2093310.53877 37.7282114196192 -122.419064719886 (37.7282114196192, -122.419064719886) 9 3 7 309 5
8590 142524 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/23/2016 02:52:00 PM 20 Width 0ft   6009733.2838 2121208.6135 37.8049831671154 -122.410566384357 (37.8049831671154, -122.410566384357) 3 1 10 308 23
8962 116061 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2100x 19th St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   16 3x3   6011385.89017 2105128.48272 37.7609234092204 -122.403715181115 (37.7609234092204, -122.403715181115) 10 3 8 28856 29
9059 77640 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   13 0   6006980.92428 2093193.11147 37.7279045016753 -122.418103887786 (37.7279045016753, -122.418103887786) 9 3 7 309 5
9148 76641 DPW Maintained 1 Olea europaea :: Olive Tree 9 148X Paris St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6002952.72216 2092480.76402 37.7257210052939 -122.43197862653 (37.7257210052939, -122.43197862653) 9 7 6 28861 5
9319 77642 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 4x4   6006942.10409 2093179.93326 37.7278661320969 -122.418237156514 (37.7278661320969, -122.418237156514) 9 3 7 309 5
9619 75308 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 125 Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 4x5   6002852.68268 2092471.30856 37.7256893707662 -122.43232378004 (37.7256893707662, -122.43232378004) 9 7 6 28861 5
9627 228661 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943) 2 4 5 28862 3
9739 77653 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006717.25868 2093269.99639 37.7281007670162 -122.41902083924 (37.7281007670162, -122.41902083924) 9 3 7 309 5
9740 75309 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 125 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276) 9 7 6 28861 5
10051 263590 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 830x Harrison St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 Private     3x3   6012495 2112152 37.7802702966571 -122.40037257143 (37.7802702966571, -122.40037257143) 6 2 9 28856 34
10546 77641 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 57 1300X Silliman St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 4x4   6006964.98892 2093186.85252 37.7278864190206 -122.418158533295 (37.7278864190206, -122.418158533295) 9 3 7 309 5
10649 76037 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2999X Polk St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/16/1996 12:00:00 AM 6 4x6   6005804.42794414 2120704.37010887 37.8033775968655 -122.42412676624 (37.8033775968655, -122.42412676624) 5 9 1 28858 32
10723 113037 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
10992 98625 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3500X Fillmore St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002285.2374 2120040.843 37.8013564005351 -122.43625752619 (37.8013564005351, -122.43625752619) 13 9 1 57 17
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
11170 76785 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x12   5983097.8243 2104541.5546 37.75769102754 -122.501506182606 (37.75769102754, -122.501506182606) 1 8 3 56 35
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
11226 33101 DPW Maintained 1 Quercus virginiana :: Southern Live Oak 300 450X Chestnut St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 11/05/1996 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754367 -122.410721035819 (37.804135754367, -122.410721035819) 3 1 10 308 23
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
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
11807 70932 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14     5988727.46903 2113517.26751 37.7826648905872 -122.482694534783 (37.7826648905872, -122.482694534783) 11 6 2 55 26
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
12179 220312 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 4235 19th St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     15 Width 3ft   6002007.42492 2104678.29116 37.7591589249724 -122.436118906483 (37.7591589249724, -122.436118906483) 2 4 5 28862 3
12386 73495 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 250 23rd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10     5988730.14838 2113498.62278 37.7826138532986 -122.482683898749 (37.7826138532986, -122.482683898749) 11 6 2 55 26
12520 228662 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 4235 19th St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 3ft   6001863.4982 2104671.44362 37.7591319452903 -122.436616182999 (37.7591319452903, -122.436616182999) 2 4 5 28862 3
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
12999 38424 DPW Maintained 1 Morus alba :: White Mulberry 246 1451 Jackson St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/24/2005 12:00:00 AM 12 3x3 Permit Number 48015 6007280.79709 2117415.82487 37.7944313239892 -122.418784361633 (37.7944313239892, -122.418784361633) 5 1 10 28858 32
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
13778 77659 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   8 3x3   6006700.09662 2093328.78928 37.7282612330662 -122.419084337666 (37.7282612330662, -122.419084337666) 9 3 7 309 5
14144 75133 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 125 Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.432160858845 (37.7256104849218, -122.432160858845) 9 7 6 28861 5
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
14433 76390 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 299X Cambridge St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6006730.14725 2093235.82763 37.7280076727975 -122.418973860459 (37.7280076727975, -122.418973860459) 9 3 7 309 5
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

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