trees

264 rows where Police Districts = 2 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
77006 108328 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
78216 148688 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 15 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010825.81515 2110877.63025 37.7766779522549 -122.406057277416 (37.7766779522549, -122.406057277416) 14 2 9 28853 34
78580 114284 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
79332 124728 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
83229 51761 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2005 12:00:00 AM 8   Permit Number 48028 6011451.43524212 2112543.5849209 37.781287248696 -122.404010328515 (37.781287248696, -122.404010328515) 6 2 9 28853 34
83380 40353 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 13 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
84141 102599 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
85954 15110 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014281.21891 2116519.09631 37.7923607834286 -122.394499049528 (37.7923607834286, -122.394499049528) 12 2 9 28855 6
90420 124731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
91220 120660 Undocumented 4 Ficus nitida :: Laurel Fig 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
91800 19370 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06TH ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
92451 15169 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 23 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
93090 108326 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95808 48700 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
97139 15172 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 941 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010497.86985 2112769.44604 37.7818540873698 -122.40732513932 (37.7818540873698, -122.40732513932) 14 2 9 28853 34
97368 64484 Permitted Site 7 Ficus nitida :: Laurel Fig 53 436 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1988 12:00:00 AM     Permit Number 778749 6014198.52964849 2112913.46772182 37.782455962378 -122.39453256733 (37.782455962378, -122.39453256733) 6 2 9 28856 6
98499 102601 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
99112 101762 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
99255 111592 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
100078 102598 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100582 48699 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
100811 111598 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
103078 15168 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 22 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
104659 124727 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
104676 100260 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
105004 100707 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
105308 111809 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
105815 111210 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
107982 111590 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
108637 27712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
108812 101761 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
109074 115054 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
109251 17295 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007087.86369 2109540.24307 37.7727960300261 -122.418893105705 (37.7727960300261, -122.418893105705) 8 2 9 28853 19
109824 17315 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
110518 15161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 15 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
111958 15109 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014295.34515 2116528.26215 37.7923867359811 -122.3944508141 (37.7923867359811, -122.3944508141) 12 2 9 28855 6
112427 111796 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 13 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
112808 15167 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 21 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
113146 111793 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55X Sherman St 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     6 3x3   6010868.84129 2110834.34163 37.7765614981606 -122.405905386452 (37.7765614981606, -122.405905386452) 14 2 9 28853 34
113415 17294 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007138.45925 2109591.54151 37.7729397321212 -122.418721728138 (37.7729397321212, -122.418721728138) 8 2 9 28853 19
114688 49239 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
114816 120655 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
115493 15108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014309.51773 2116539.1619 37.7924174520023 -122.394402539761 (37.7924174520023, -122.394402539761) 12 2 9 28855 6
115831 15162 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 16 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
117139 49290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
118155 49258 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
119084 173642 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 657 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
119106 111799 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 16 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
120051 112410 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
121554 15163 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 17 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
122653 17306 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
123162 114285 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
124192 15106 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014335.21568 2116559.29701 37.7924741668095 -122.394315033873 (37.7924741668095, -122.394315033873) 12 2 9 28855 6
124317 91126 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
125521 49234 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 29 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
126346 148685 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 12 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010843.84821 2110857.5872 37.776623927287 -122.405993483135 (37.776623927287, -122.405993483135) 14 2 9 28853 34
126595 111798 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 15 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
128659 120663 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
128922 49236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 21 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
129369 94220 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 5 Sidewalk: Property side : Pot Tree Private 2         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
129463 49287 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
129993 49238 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
130193 112406 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
131089 111209 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X 09TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
131297 17307 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006961.49044 2109420.44821 37.772459985288 -122.419321746309 (37.772459985288, -122.419321746309) 8 2 9 28853 19
131840 100259 Undocumented 4 Ficus nitida :: Laurel Fig 53 30X Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 4x3   6015074.6 2113439.2 37.7839481682667 -122.391538488525 (37.7839481682667, -122.391538488525) 6 2 9 28856 6
132195 100706 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
132203 48698 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
134382 111810 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
135772 100261 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
135837 124730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
136842 49263 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 17 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
138208 95414 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Creating record for 3 ficus trees at this address on 2/28/2011. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
138240 108324 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
140527 15263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2008 12:00:00 AM 12 3x3 Permit Number 51766 6007587.5132074 2110099.4827033 37.7743596907053 -122.417204392502 (37.7743596907053, -122.417204392502) 8 2 9 28853 19
141769 15252 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007671.66057 2110183.15551 37.7745941699553 -122.416919239811 (37.7745941699553, -122.416919239811) 8 2 9 28853 34
143433 15157 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 11 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143636 15150 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 3x3   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
144032 49294 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
144365 111593 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
145539 48701 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
145639 112403 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
145766 101765 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
147048 47565 Permitted Site 7 Ficus nitida :: Laurel Fig 53 920 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/14/2002 12:00:00 AM     Permit Number 45425 6011901.71412119 2111593.71793264 37.7787042813354 -122.402385767126 (37.7787042813354, -122.402385767126) 14 2 9 28856 34
147296 49297 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
148003 95416 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created recoard for tree on 2/28/2011. Tree approx. 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
148523 15253 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007637.14046 2110148.71 37.7744976489686 -122.417036210851 (37.7744976489686, -122.417036210851) 8 2 9 28853 34
148648 101767 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
148917 19373 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     35 4X4   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
150160 148684 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 55 Sherman St 11 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 10ft   6010855.51157 2110848.16765 37.7765987157057 -122.405952472245 (37.7765987157057, -122.405952472245) 14 2 9 28853 34
150162 111596 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
150564 102603 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
151649 49289 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
152130 101760 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34

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