trees

203 rows where qCaretaker_id = 14 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts ▼ Supervisor Districts Zip Codes Neighborhoods (old)
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4934 103659 Significant Tree 6 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6834 103660 Significant Tree 6 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7411 103658 Significant Tree 6 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8509 103668 Significant Tree 6 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
9915 173655 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100 Lawton St 1 Median : Cutout Tree DPW for City Agency 14                              
14456 103661 Significant Tree 6 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18988 103657 Significant Tree 6 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
35002 98799 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
56512 251807 DPW Maintained 1 Crateagus spp :: Hawthorn 130 2 Hangah St 1 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
73001 98796 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 950@Washington Clay St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 3 3x3 Permit Number 768771 6010177.18626 2117200.01626 37.7940014192822 -122.408747227007 (37.7940014192822, -122.408747227007) 3 1 10 28857 4
78186 98801 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010237.16405 2117207.30409 37.79402478906 -122.408540211182 (37.79402478906, -122.408540211182) 3 1 10 28857 4
95513 98800 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010265.98354 2117209.83013 37.7940333389111 -122.408440670611 (37.7940333389111, -122.408440670611) 3 1 10 28857 4
127023 251811 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 4 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
128875 251813 DPW Maintained 1 Crateagus spp :: Hawthorn 130 2 Hangah St 6 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
141721 98795 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 950@Washington Clay St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
144228 251810 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 3 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
149776 98798 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 950@Washington Clay St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 22 3x3 Permit Number 768771 6010098.56978 2117188.54171 37.7939655093431 -122.409018439172 (37.7939655093431, -122.409018439172) 3 1 10 28857 4
168582 251809 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2 Hangah St 2 Unaccepted Street : Cutout Tree DPW for City Agency 14 Rec/Park     3x3   6010544 2117119 37.7937995065594 -122.407472293877 (37.7937995065594, -122.407472293877) 3 1 10 28857 4
187706 98797 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 950@Washington Clay St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010116.35805 2117191.91562 37.7939757697248 -122.408957127878 (37.7939757697248, -122.408957127878) 3 1 10 28857 4
128716 108973 Property Tree 8 Pinus radiata :: Monterey Pine 15 3485X SAN BRUNO AVE 1 Median : Yard Tree DPW for City Agency 14           6011510 2091910 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066) 10 3 7 309 28
8033 242084 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4185 25th St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/16/2016 06:05:00 AM 1 Width 3ft   6002781.49194 2101209.46423 37.7496782989261 -122.433193959528 (37.7496782989261, -122.433193959528) 2 4 5 28862 22
12041 242082 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4185 25th St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     1 Width 3ft   6002677.73551 2101204.84944 37.7496597414097 -122.433552423029 (37.7496597414097, -122.433552423029) 2 4 5 28862 22
14883 242086 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4185 25th St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/16/2016 05:57:00 AM 2 Width 3ft   6002948.22198 2101215.85126 37.7497052929799 -122.432617857444 (37.7497052929799, -122.432617857444) 2 4 5 28862 22
15773 242083 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4185 25th St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14     1 Width 3ft   6002726.52973 2101207.22034 37.7496690197098 -122.433383860397 (37.7496690197098, -122.433383860397) 2 4 5 28862 22
19884 109998 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 501X Shotwell St 15 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
22315 113814 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:05:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
23754 113821 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 4101x 25TH ST 14 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
27383 109993 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
29374 109992 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
33609 98909 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
38877 101808 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3149 26th St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   02/03/2015 12:00:00 AM 3 3x3   6008718.2 2100791.7 37.7488661984732 -122.412634998086 (37.7488661984732, -122.412634998086) 2 4 7 28859 19
47883 109990 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
57725 109996 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 13 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
63694 109991 Undocumented 4 Quercus spp :: Oak 254 501X Shotwell St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
72030 109988 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
73737 113813 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
83447 109986 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
83791 98908 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
87336 113817 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 06:00:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
87682 113810 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 4101x 25TH ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
88456 113809 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 06/15/2016 07:36:00 AM 3 5x5   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
89248 109987 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
90434 113818 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 4101x 25TH ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 02/16/2016 05:57:00 AM 3 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
101614 113808 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4101x 25TH ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
113343 113820 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 4101x 25TH ST 13 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
116486 109999 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 501X Shotwell St 16 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW         6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
117136 109995 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
120864 113819 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4101x 25TH ST 12 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
124997 113812 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 4101x 25TH ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   1 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
152463 109989 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
154938 113811 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   5 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
177165 109994 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 501X Shotwell St 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
177608 113816 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 4101x 25TH ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
177877 113822 Undocumented 4 Melaleuca spp :: Melaleuca spp 117 4101x 25TH ST 15 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
179503 113815 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 4101x 25TH ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   8 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
12201 140276 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998008.2541 2109969.0086 37.7734578744037 -122.450331271992 (37.7734578744037, -122.450331271992) 15 5 11 29492 16
21624 140275 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998028.0276 2109971.4803 37.773465792675 -122.450263051124 (37.773465792675, -122.450263051124) 15 5 11 29492 16
26910 111776 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
30910 110537 Undocumented 4 Tree(s) :: 17 100X ASHBURY ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
31418 110533 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 100X ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
36748 246841 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 3 : Tree DPW for City Agency 14     14 Width 3ft   6001195.01805 2109899.62825 37.7734492368388 -122.439302846449 (37.7734492368388, -122.439302846449) 15 5 11 29492 10
39489 111135 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   2 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
41067 113874 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 11 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
45020 111128 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   7 5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
54557 246846 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 8 : Tree DPW for City Agency 14     14 Width 3ft   6001207.38463 2109809.38993 37.7732021687661 -122.439253599591 (37.7732021687661, -122.439253599591) 15 5 11 29492 10
55624 246843 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 5 : Tree DPW for City Agency 14     9 Width 3ft   6001198.91277 2109877.26909 37.7733880658265 -122.439287771129 (37.7733880658265, -122.439287771129) 15 5 11 29492 10
65235 113871 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
74558 111133 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
75284 113868 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
78158 113866 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
100634 110538 Undocumented 4 Tree(s) :: 17 100X ASHBURY ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
111013 113867 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
112619 140272 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998087.0735 2109979.7192 37.7734917934815 -122.450059397698 (37.7734917934815, -122.450059397698) 15 5 11 29492 16
117870 113873 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 10 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
127072 246842 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 4 : Tree DPW for City Agency 14     15 Width 4ft   6001208.43411 2109888.06605 37.7734182533891 -122.439255609578 (37.7734182533891, -122.439255609578) 15 5 11 29492 10
128478 111134 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
132168 140273 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998068.9478 2109976.9729 37.773483215641 -122.450121898862 (37.773483215641, -122.450121898862) 15 5 11 29492 16
139078 246847 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 9 : Tree DPW for City Agency 14     9 Width 3ft   6001212.96216 2109784.10249 37.7731330531814 -122.439232493392 (37.7731330531814, -122.439232493392) 15 5 11 29492 10
140109 246844 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 6 : Tree DPW for City Agency 14     17 Width 3ft   6001203.63374 2109838.69012 37.7732824062979 -122.439268674924 (37.7732824062979, -122.439268674924) 15 5 11 29492 10
147322 113872 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 9 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
152081 111131 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
153582 246840 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 2 : Tree DPW for City Agency 14     19 Width 3ft   6001188.51269 2109936.21842 37.7735493340682 -122.43932797262 (37.7735493340682, -122.43932797262) 15 5 11 29492 10
153711 140270 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998125.7967 2109984.6626 37.7735075825336 -122.44992580546 (37.7735075825336, -122.44992580546) 15 5 11 29492 16
158133 246849 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 11 : Tree DPW for City Agency 14     9 Width 3ft   6001216.86576 2109748.14467 37.7730345441487 -122.439216412614 (37.7730345441487, -122.439216412614) 15 5 11 29492 10
158369 113869 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
158827 140274 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   08/11/2017 12:00:00 AM 3 Width 0ft   5998046.1533 2109973.9519 37.7734736163349 -122.450200530187 (37.7734736163349, -122.450200530187) 15 5 11 29492 16
167224 110540 Undocumented 4 Maytenus boaria :: Mayten 58 100X ASHBURY ST 8 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
171772 140269 DPW Maintained 1 Liquidambar styraciflua :: American Sweet Gum 37 2040 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD 08/11/2017 12:00:00 AM 3 Width 0ft   5998144.7463 2109987.1343 37.7735154534297 -122.449860434482 (37.7735154534297, -122.449860434482) 15 5 11 29492 16
175403 111129 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
175720 113865 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001207 2109749 37.7730363312645 -122.439250600749 (37.7730363312645, -122.439250600749) 15 5 11 29492 10
181717 246848 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 10 : Tree DPW for City Agency 14     14 Width 3ft   6001221.88417 2109765.97896 37.7730837982073 -122.439200331843 (37.7730837982073, -122.439200331843) 15 5 11 29492 10
185385 111132 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 2030x HAYES ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     5x5.5   5998060 2109954 37.7734196259383 -122.450151194281 (37.7734196259383, -122.450151194281) 15 5 11 29492 16
192954 110534 Undocumented 4 Maytenus boaria :: Mayten 58 100X ASHBURY ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 City College     3x3   5998750 2110223 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196) 15 5 11 29492 16
25373 110420 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 419X 18TH AVE 18 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA     3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26

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