1,098 rows where qCaretaker_id = 4 sorted by Police Districts

View and edit SQL

Zip Codes

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                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
39397 99695 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
39581 142525 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 301 FRANCISCO ST 15 Sidewalk: Curb side : Cutout Tree SFUSD 4     23 Width 0ft   6009759.5801 2121214.59 37.8050010513122 -122.410475804946 (37.8050010513122, -122.410475804946) 3 1 10 308 23
41372 95268 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
44945 99261 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3099X Polk St 1 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x6   6005936.6 2121383.7 37.8052503240173 -122.42371770971 (37.8052503240173, -122.42371770971) 5 1 1 28858 32
47784 98579 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 17 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
48126 108611 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2025x Taylor St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x3   6008581.83386 2119799.52206 37.8010495338737 -122.414451351572 (37.8010495338737, -122.414451351572) 5 1 10 308 32
49150 100970 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   9   Permit Number 37341 6009657.9659 2120896.9693 37.8041232469329 -122.410805008122 (37.8041232469329, -122.410805008122) 3 1 10 308 23
51293 100971 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   4   Permit Number 37341 6009642.5454 2120895.3461 37.8041179253888 -122.410858257388 (37.8041179253888, -122.410858257388) 3 1 10 308 23
55266 142521 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/04/2013 12:00:00 AM 0 Width 0ft   6009485.2617 2121177.5361 37.8048839283261 -122.411422499274 (37.8048839283261, -122.411422499274) 3 1 10 308 23
58468 100975 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   11   Permit Number 37341 6009580.8633 2120886.4184 37.8040899533369 -122.411071082632 (37.8040899533369, -122.411071082632) 3 1 10 308 23
58584 57790 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Clay St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 02/08/1977 12:00:00 AM 15 4x4 Permit Number 768771 6010215.62504 2117204.00661 37.7940145286904 -122.408614505968 (37.7940145286904, -122.408614505968) 3 1 10 28857 4
65057 142547 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
65323 110958 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   11 5x5   6008447.06762 2119689.6105 37.8007401724743 -122.414909918573 (37.8007401724743, -122.414909918573) 5 1 10 308 32
65532 100981 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
65536 100982 DPW Maintained 1 Prunus serrulata 'Royal Burgundy' :: Royal Burgundy Flowering Cherry Tree 468 2190 Powell St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW 05/03/2013 12:00:00 AM   3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257169 (37.8045319114054, -122.41088257169) 3 1 10 308 23
66131 99697 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1451 Jackson St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007296.6569 2117418.12417 37.794438530258 -122.418729647781 (37.794438530258, -122.418729647781) 5 1 10 28858 32
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
66275 142545 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
66578 100978 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   5   Permit Number 37341 6009524.0508 2120877.4907 37.8040622540071 -122.411267056058 (37.8040622540071, -122.411267056058) 3 1 10 308 23
66737 98559 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 2 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
69868 142549 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 11 Sidewalk: Curb side : Cutout Tree SFUSD 4     9 Width 0ft   6009666.9453 2121202.0395 37.8049613971858 -122.410795492578 (37.8049613971858, -122.410795492578) 3 1 10 308 23
70628 99696 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1451 Jackson St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x3   6007201.17567 2117403.71838 37.7943935992302 -122.419059002888 (37.7943935992302, -122.419059002888) 5 1 10 28858 32
71668 142546 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/26/2016 09:47:00 AM 23 Width 0ft   6009592.8375 2121191.8795 37.8049293448711 -122.411051233847 (37.8049293448711, -122.411051233847) 3 1 10 308 23
73345 98561 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2035X Stockton St 4 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
73387 113573 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
77066 99693 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   12 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
79131 97722 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1000X Bay St 1 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
79751 98566 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/04/2013 12:00:00 AM   3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
80723 142526 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 17 Sidewalk: Curb side : Cutout Tree SFUSD 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206) 3 1 10 308 23
81644 110960 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 5x5   6008419.49323 2119686.5094 37.8007301081687 -122.415005118088 (37.8007301081687, -122.415005118088) 5 1 10 308 32
83356 142550 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 16 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/26/2016 09:53:00 AM 22 Width 0ft   6009784.6811 2121219.3711 37.8050155861628 -122.410389277522 (37.8050155861628, -122.410389277522) 3 1 10 308 23
84271 98794 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950@Washington Clay St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
87864 110957 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9 5x5   6008462.00707 2119690.65519 37.8007438803772 -122.41485829569 (37.8007438803772, -122.41485829569) 5 1 10 308 32
90901 100974 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   15   Permit Number 37341 6009596.2838 2120888.8532 37.8040975034287 -122.411017890761 (37.8040975034287, -122.411017890761) 3 1 10 308 23
91578 97725 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1000X Bay St 4 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency     7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
92277 100973 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 450X Chestnut St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   0   Permit Number 37341 6009614 2121059.9 37.8045681487804 -122.410968670823 (37.8045681487804, -122.410968670823) 3 1 10 308 23
93557 98577 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301X Francisco St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     6x7   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
98442 142544 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/23/2016 02:55:00 PM 26 Width 0ft   6009534.8661 2121184.7078 37.8049064021217 -122.411251344133 (37.8049064021217, -122.411251344133) 3 1 10 308 23
99299 142522 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 12 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 Width 0ft   6009689.0581 2121206.8206 37.8049757647303 -122.410719306308 (37.8049757647303, -122.410719306308) 3 1 10 308 23
99627 107884 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
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
102614 127905 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 937 Lombard St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     16 Width 6ft   6007996.96181 2120271.7748 37.8023133475557 -122.416508736883 (37.8023133475557, -122.416508736883) 5 1 10 308 32
104016 110959 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 5x5   6008435.02538 2119688.12069 37.8007354051603 -122.414951484348 (37.8007354051603, -122.414951484348) 5 1 10 308 32
104120 131002 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 937 Lombard St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/09/2014 12:00:00 AM 2 Width 3ft   6007919.06293 2120264.13988 37.8022880028424 -122.416777764577 (37.8022880028424, -122.416777764577) 5 1 10 308 32
104181 98790 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950x CLAY ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
105400 110956 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 940 Filbert St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   7 5x5   6008474.06115 2119692.72385 37.8007502377013 -122.414816729923 (37.8007502377013, -122.414816729923) 5 1 10 308 32
106695 100983 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 4 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
114301 98806 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x CLAY ST 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
115066 113570 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 901 LOMBARD ST 1 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
115679 98564 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 2 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
117656 95263 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2245 Jones St 1 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
118273 99694 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1550X Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   10 3x3   6007274.7 2117123.2 37.7936275055362 -122.418784695641 (37.7936275055362, -122.418784695641) 5 1 10 28858 32
121110 98804 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 3 1 10 28857 4
121961 100979 DPW Maintained 1 Maytenus boaria :: Mayten 58 450X Chestnut St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   6   Permit Number 37341 6009507.0071 2120874.2443 37.8040523843138 -122.411325807727 (37.8040523843138, -122.411325807727) 3 1 10 308 23
122492 107885 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
124279 113571 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 901 LOMBARD ST 2 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
125465 142523 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 13 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009712.3662 2121206.8206 37.8049770715314 -122.410638645677 (37.8049770715314, -122.410638645677) 3 1 10 308 23
130969 116857 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950x Clay St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x3   6010080.35093 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 3 1 10 28857 4
132915 100984 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 2190 Powell St 5 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
134500 142542 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453) 3 1 10 308 23
137680 98571 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301X Francisco St 9 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
144374 95264 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2245 Jones St 2 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
145088 95267 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2245 Jones St 6 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
145225 98567 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 5 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
152258 98578 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/26/2016 09:53:00 AM 3 6x7   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
152503 98570 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/26/2016 09:47:00 AM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
153778 142519 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 Width 0ft   6009452.9889 2121171.5596 37.8048657081731 -122.411533760714 (37.8048657081731, -122.411533760714) 3 1 10 308 23
153795 98792 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950 Clay St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/16/2012 12:00:00 AM   5x4 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
155011 98574 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 12 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
156452 98568 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/23/2016 02:55:00 PM 3 3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
156639 95266 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 2245 Jones St 5 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
156959 42841 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 2245 Jones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185) 5 1 10 308 32
157895 98793 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950x CLAY ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x6 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
159114 98563 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 301X Francisco St 1 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
160459 98572 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 10 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
163523 107883 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
165062 142548 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301 FRANCISCO ST 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 Width 0ft   6009639.4537 2121197.2583 37.8049467277157 -122.410890292822 (37.8049467277157, -122.410890292822) 3 1 10 308 23
167189 97724 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1000X Bay St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency   14 7x82   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028) 5 1 1 28858 32
168362 95269 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2245 Jones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     6x6   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)
);