trees

203 rows where qCaretaker_id = 14 sorted by qLegalStatus_id descending

✎ 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)
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
157876 111096 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 SAINT CHARLES AVE 31 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW   15     5992079 2088073 37.7129959107362 -122.469247237289 (37.7129959107362, -122.469247237289) 9 8 6 64 24
175730 254646 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 67 Saint Charles Ave 31 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 Private     3x3   5992096 2088072 37.7129941473192 -122.469188407447 (37.7129941473192, -122.469188407447) 9 8 6 64 24
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
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                    
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                    
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                    
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                    
28942 110737 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
29114 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
67675 110738 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
108684 103655 Significant Tree 6 Tree(s) :: 17 307X Octavia St 4 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
109449 103656 Significant Tree 6 Tree(s) :: 17 307X Octavia St 5 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
124026 110739 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 6 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
152489 103652 Significant Tree 6 Tree(s) :: 17 307X Octavia St 1 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
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                    
4148 111380 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
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                    
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
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                    
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
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                    
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
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
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
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
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
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
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
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
50286 113709 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
52668 113708 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
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
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
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
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
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
95680 110403 Undocumented 4 Ficus laurel :: 247 419X 18TH AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 MTA   22 3x3   5990240 2112557 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869) 11 6 2 55 26
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
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
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
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
114523 110402 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 3 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
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
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
119304 111381 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 3 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
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
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
130117 113705 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
139329 110406 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 7 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
143725 113706 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 2 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
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
148472 113707 Undocumented 4 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2801x CLEMENT ST 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD     4x4   5986698 2113245 37.7817990393362 -122.4896955071 (37.7817990393362, -122.4896955071) 11 6 2 55 26
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
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
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
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
168033 111379 Undocumented 4 Pinus radiata :: Monterey Pine 15 301x OCEAN AVE 1 Sidewalk: Property side : Cutout Tree DPW for City Agency 14 MTA   24 3x3   5999454 2091552 37.7229718629586 -122.44400669589 (37.7229718629586, -122.44400669589) 9 7 6 28861 25
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
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
180245 110414 Undocumented 4 Juniperus chinensis :: Juniper 113 419X 18TH AVE 15 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
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
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
9915 173655 DPW Maintained 1 Quercus ilex :: Holly Oak 305 100 Lawton St 1 Median : Cutout Tree DPW for City Agency 14                              
10068 49666 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 3630 Divisadero St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14   04/18/2011 12:00:00 AM 6   Permit Number 46510 6000245.17413 2120665.11682 37.8029543681198 -122.443361894237 (37.8029543681198, -122.443361894237) 13 9 1 57 17
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
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
15243 98997 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2190X North Point St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6000277.5 2120626.8 37.8028510037355 -122.443247276641 (37.8028510037355, -122.443247276641) 13 9 1 57 17
16686 99005 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 2099X Beach St 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14         Permit Number 46510 6000381.4 2120794.3 37.8033168379221 -122.442899765771 (37.8033168379221, -122.442899765771) 13 9 1 57 17
21486 114737 DPW Maintained 1 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 455x LILY ST 1 Sidewalk: Curb side : Pot Tree DPW for City Agency 14 DPW         6004484 2109981 37.77385927942 -122.427931581119 (37.77385927942, -122.427931581119) 7 9 11 28852 10

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