trees
264 rows where Police Districts = 2 and qSpecies_id = 53 sorted by SiteOrder
This data as json, CSV (advanced)
These facets timed out: 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
15941 | 85313 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 610 Brannan St | 1 | unknown : Cutout | Tree | Private 2 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.399555358584 | (37.7766267904106, -122.399555358584) | 14 | 2 | 9 | 28856 | 34 | ||||
27040 | 120661 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 299X Main 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 | |||
32017 | 116771 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 590X NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009883 | 2111689 | 37.7788530052944 | -122.409376039999 | (37.7788530052944, -122.409376039999) | 14 | 2 | 9 | 28853 | 34 | |||
36280 | 110558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | 8 | 2 | 9 | 28853 | 19 | |||
38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
45235 | 15147 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 1 | 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 | |||
52966 | 66275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | 8 | 2 | 9 | 28853 | 19 | ||
54470 | 101758 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 1 | 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 | |||
59324 | 94216 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||
60538 | 32649 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | 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 | ||
69985 | 49269 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 1 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
156641 | 15249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007741.56076 | 2110251.13936 | 37.7747847690696 | -122.416682257719 | (37.7747847690696, -122.416682257719) | 8 | 2 | 9 | 28853 | 34 | |||
157267 | 17313 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
159363 | 58908 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 353 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.411881715065 | (37.7721958858688, -122.411881715065) | 8 | 2 | 9 | 28853 | 34 | |
167163 | 17304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 1 | 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 | |||
170466 | 114281 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 200X STEUART ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015060 | 2116254 | 37.7916761533754 | -122.391785881413 | (37.7916761533754, -122.391785881413) | 6 | 2 | 9 | 28855 | 6 | ||||
175879 | 15105 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 110 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014344.93761 | 2116565.97781 | 37.7924930511311 | -122.394281863407 | (37.7924930511311, -122.394281863407) | 12 | 2 | 9 | 28855 | 6 | |||
176043 | 111207 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 601X 09TH 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 | ||||
181935 | 17311 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 77 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006769.4589066 | 2109244.8738273 | 37.7719670827617 | -122.419973541884 | (37.7719670827617, -122.419973541884) | 8 | 2 | 9 | 28853 | 19 | |||
182181 | 111804 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
186566 | 15267 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1531 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6007476.41024 | 2109891.28194 | 37.7737817698767 | -122.417573960108 | (37.7737817698767, -122.417573960108) | 8 | 2 | 9 | 28853 | 19 | |||
187641 | 17308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
153427 | 40357 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 10 | 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 | ||
168885 | 48703 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 10 | 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 | |||
371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
58892 | 40350 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 Tehama St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011468.97735143 | 2112560.39183232 | 37.7813343766323 | -122.403950824176 | (37.7813343766323, -122.403950824176) | 6 | 2 | 9 | 28853 | 34 | ||
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 | |||
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 | |||
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 | |||
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 | |||
152554 | 111794 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
170953 | 101768 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 11 | 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 | |||
177980 | 27711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | 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 | |||
1212 | 40354 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 12 | 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 | ||
26375 | 111795 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
67792 | 15158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 12 | 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 | |||
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 | |||
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 | |||
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 | |||
172014 | 101769 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 12 | 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 | |||
177069 | 49259 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 12 | 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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
185169 | 15159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | Private | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | ||
188426 | 148686 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55 Sherman St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 10ft | 6010834.41502 | 2110868.71034 | 37.7766539412504 | -122.406026899245 | (37.7766539412504, -122.406026899245) | 14 | 2 | 9 | 28853 | 34 | |||
31550 | 15160 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 14 | 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 | |||
32372 | 111797 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
40156 | 49286 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 14 | 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 | |||
70254 | 48702 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 405 Howard St | 14 | 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 | |||
165464 | 148687 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55 Sherman St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 10ft | 6010830.11496 | 2110873.17046 | 37.7766659471997 | -122.406042088772 | (37.7766659471997, -122.406042088772) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
154414 | 148689 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 55 Sherman St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 10ft | 6010821.9718 | 2110882.95558 | 37.7766923594104 | -122.406070948019 | (37.7766923594104, -122.406070948019) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
39622 | 15164 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 18 | 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 | |||
156149 | 49237 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 500 Howard St | 18 | 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 | |||
172671 | 49251 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 18 | 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 | |||
3993 | 49288 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2X Spear St | 19 | 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 | |||
68900 | 15165 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 19 | 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 | |||
16987 | 17305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 2 | 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 | |||
17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
19705 | 95415 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 49X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. | 6007102.30356 | 2110018.85993 | 37.7741110108752 | -122.418877107651 | (37.7741110108752, -122.418877107651) | 8 | 2 | 9 | 28853 | 19 | ||
20552 | 15171 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010472.08374 | 2112774.72891 | 37.7818671496492 | -122.407414720255 | (37.7818671496492, -122.407414720255) | 14 | 2 | 9 | 28853 | 34 | |||
26933 | 120656 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 160 Folsom St | 2 | 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 | |||
28163 | 10573 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 4x4 | 6011301.87316 | 2111047.97507 | 37.7771722946398 | -122.404422436991 | (37.7771722946398, -122.404422436991) | 14 | 2 | 9 | 28853 | 34 | |||
34792 | 15148 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 2 | 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 | |||
36076 | 111627 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
38782 | 101759 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 2 | 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 | |||
43589 | 15250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007716.15968 | 2110227.06056 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | 8 | 2 | 9 | 28853 | 34 | |||
43596 | 112404 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );