trees
200 rows where Zip Codes = 28853 and qSpecies_id = 53 sorted by DBH descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
2027 | 32641 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
24140 | 32644 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
24912 | 32645 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/1999 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
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 | ||
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 | |
66641 | 32646 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
72803 | 32647 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
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 | ||
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 | ||
177897 | 100470 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 5X Pearl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6005567.3 | 2108720.4 | 37.7704592014806 | -122.424094599295 | (37.7704592014806, -122.424094599295) | 8 | 2 | 5 | 28853 | 19 | |||
182282 | 32648 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 2 | 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 | |
182731 | 40355 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 9 | 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 | ||
24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
47908 | 101764 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 7 | 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 | |||
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 | |||
57879 | 101766 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 9 | 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 | |||
73524 | 101763 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 6 | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
28577 | 18320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010262.2750436 | 2107350.6845554 | 37.7669622387245 | -122.40775798639 | (37.7669622387245, -122.40775798639) | 8 | 4 | 8 | 28853 | 19 | |||
33185 | 18322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.407729067657 | (37.7667132034185, -122.407729067657) | 8 | 4 | 8 | 28853 | 19 | |||
72828 | 18316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
139216 | 18329 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | 8 | 4 | 8 | 28853 | 19 | |||
148347 | 18327 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X2 | 6010329.0895487 | 2107117.8320658 | 37.7663266190773 | -122.407510465965 | (37.7663266190773, -122.407510465965) | 8 | 4 | 8 | 28853 | 19 | |||
152094 | 18326 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010329.0895487 | 2107117.8320658 | 37.7663266190773 | -122.407510465965 | (37.7663266190773, -122.407510465965) | 8 | 4 | 8 | 28853 | 19 | |||
183113 | 18328 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | 8 | 4 | 8 | 28853 | 19 | |||
148177 | 100480 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 245 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007080 | 2107899 | 37.7682891227663 | -122.418803888241 | (37.7682891227663, -122.418803888241) | 8 | 4 | 7 | 28853 | 19 | |||
51739 | 19375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6011348.29286 | 2111104.97037 | 37.7773313845055 | -122.404265868127 | (37.7773313845055, -122.404265868127) | 14 | 2 | 9 | 28853 | 34 | |||
98753 | 18298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 35X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
170902 | 18297 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 35X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
51241 | 15259 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6007494.54134 | 2110025.11497 | 37.7741502637452 | -122.417520728591 | (37.7741502637452, -122.417520728591) | 8 | 2 | 9 | 28853 | 19 | |||
72411 | 15256 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007417.64852 | 2109947.83449 | 37.7739337430824 | -122.417781236147 | (37.7739337430824, -122.417781236147) | 8 | 2 | 9 | 28853 | 19 | |||
141499 | 18310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6010243.055587 | 2107664.3185897 | 37.7678223300533 | -122.407846582122 | (37.7678223300533, -122.407846582122) | 8 | 4 | 8 | 28853 | 19 | |||
146667 | 15335 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006691.81678 | 2108397.85831 | 37.7696370050813 | -122.420181988192 | (37.7696370050813, -122.420181988192) | 8 | 4 | 7 | 28853 | 19 | |||
173445 | 15262 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007448.14843 | 2109975.86864 | 37.774012434525 | -122.417677719037 | (37.774012434525, -122.417677719037) | 8 | 2 | 9 | 28853 | 19 | |||
190135 | 15260 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
40269 | 25702 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012081.78675 | 2110335.7627 | 37.7752602760543 | -122.401674380603 | (37.7752602760543, -122.401674380603) | 14 | 2 | 9 | 28853 | 34 | |||
42234 | 25701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6012066.85402 | 2110350.08491 | 37.7752987682674 | -122.40172704355 | (37.7752987682674, -122.40172704355) | 14 | 2 | 9 | 28853 | 34 | |||
83519 | 57298 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3120 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | 20 | 5x5 | Permit Number 16120 | 6006015.66145192 | 2106707.62529636 | 37.7649579052871 | -122.422400676647 | (37.7649579052871, -122.422400676647) | 8 | 4 | 5 | 28853 | 19 | |
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 | |||
19070 | 15154 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 8 | 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 | |||
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 | |||
27832 | 15155 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 9 | 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 | |||
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 | |||
34758 | 15261 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
54802 | 17309 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 2 | 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 | |||
58538 | 15152 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 6 | 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 | |||
61233 | 28383 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 286 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6006047.68288 | 2107930.23885 | 37.7683167183705 | -122.422376798825 | (37.7683167183705, -122.422376798825) | 8 | 4 | 5 | 28853 | 19 | ||||
66600 | 17310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 3 | 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 | |||
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 | |||
75232 | 18306 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
89426 | 65007 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1989 12:00:00 AM | 18 | 3x3 | Permit Number 26048 | 6008683.18209706 | 2107760.52572873 | 37.7679990416006 | -122.413248823154 | (37.7679990416006, -122.413248823154) | 8 | 4 | 7 | 28853 | 19 | |
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 | |||
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 | |||
101356 | 18317 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 199 POTRERO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010430 | 2107503 | 37.7673898501442 | -122.407188587519 | (37.7673898501442, -122.407188587519) | 8 | 4 | 8 | 28853 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
117580 | 100483 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
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 | |||
133574 | 100482 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
143541 | 28384 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 286 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6006047.68288 | 2107930.23885 | 37.7683167183705 | -122.422376798825 | (37.7683167183705, -122.422376798825) | 8 | 4 | 5 | 28853 | 19 | ||||
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 | |||
150296 | 100481 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 26048 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | ||
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 | |||
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 | |||
175687 | 17314 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
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 | ||
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 | |||
190383 | 17316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
180877 | 10578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x7 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
29857 | 57300 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3178 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | 14 | 3x3 | Permit Number 16122 | 6005671.4432239 | 2106688.52693537 | 37.7648860421109 | -122.423589884437 | (37.7648860421109, -122.423589884437) | 8 | 4 | 5 | 28853 | 19 | |
162257 | 97610 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 349 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6009106.7 | 2109348.6 | 37.7723832922197 | -122.411896150488 | (37.7723832922197, -122.411896150488) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |
8874 | 15149 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 3 | 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 | |||
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 | ||
24151 | 96336 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1851 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005204.9 | 2107156.8 | 37.7661454629436 | -122.42523686393 | (37.7661454629436, -122.42523686393) | 8 | 4 | 5 | 28853 | 19 | |||
27252 | 17296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007104.29527 | 2109558.64203 | 37.7728474744005 | -122.418837572 | (37.7728474744005, -122.418837572) | 8 | 2 | 9 | 28853 | 19 | |||
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 |
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) );