trees
261 rows where qSpecies_id = 177 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
95489 | 103593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
161101 | 113398 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 603 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998367 | 2108846 | 37.7703949048055 | -122.449009410311 | (37.7703949048055, -122.449009410311) | 15 | 5 | 11 | 29492 | 9 | ||||
177950 | 113397 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 603 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998367 | 2108846 | 37.7703949048055 | -122.449009410311 | (37.7703949048055, -122.449009410311) | 15 | 5 | 11 | 29492 | 9 | ||||
153151 | 103584 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
173794 | 103586 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
185917 | 103585 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
1199 | 116255 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
12604 | 116259 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
123771 | 116260 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
172681 | 116256 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
185678 | 116258 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
188472 | 116257 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
20378 | 116241 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
42496 | 116243 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
56227 | 116244 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
59182 | 116252 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
113350 | 116238 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
114926 | 116249 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120038 | 116245 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120178 | 116251 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
148384 | 116242 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
150109 | 116239 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
170457 | 116247 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
175524 | 103085 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
177248 | 103086 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
88961 | 252853 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
102218 | 252854 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
144072 | 252852 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
17835 | 146870 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 747 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:07:00 PM | 0 | Width 3ft | 5983198.23429 | 2110712.37785 | 37.7746402422966 | -122.501615441996 | (37.7746402422966, -122.501615441996) | 11 | 6 | 2 | 55 | 26 | ||
100244 | 115008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 743 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 774445 | 5985969.5 | 2110831.9 | 37.7751307960032 | -122.492038018346 | (37.7751307960032, -122.492038018346) | 11 | 6 | 2 | 55 | 26 | |||
72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
101932 | 116717 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 690X 03RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 5 | 3x3 | 6014548 | 2111604 | 37.7788798826953 | -122.393231883862 | (37.7788798826953, -122.393231883862) | 6 | 2 | 9 | 28856 | 34 | ||
90969 | 115004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1050 MCALLISTER ST | 5 | Front Yard : Cutout | Tree | Office of Mayor 9 | DPW | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148 | 2111858 | 37.7789940453007 | -122.429227726914 | (37.7789940453007, -122.429227726914) | 7 | 9 | 11 | 29490 | 41 | |
13736 | 90469 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.484556541536 | (37.778596339842, -122.484556541536) | 11 | 6 | 2 | 55 | 26 | |
109870 | 112779 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
178780 | 112777 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
110398 | 90511 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.726692 | 2112113.510215 | 37.7787749594642 | -122.484707869401 | (37.7787749594642, -122.484707869401) | 11 | 6 | 2 | 55 | 26 | |
185404 | 107849 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994625 | 2112199 | 37.7793866324847 | -122.462196108999 | (37.7793866324847, -122.462196108999) | 11 | 6 | 2 | 54 | 11 | |||
99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
160746 | 105053 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
153634 | 90471 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.7794095060794 | -122.484614370085 | (37.7794095060794, -122.484614370085) | 11 | 6 | 2 | 55 | 26 | |
170987 | 9125 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.7800850757133 | -122.481800911494 | (37.7800850757133, -122.481800911494) | 11 | 6 | 2 | 55 | 26 | ||
131941 | 9116 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.481186169595 | (37.7801152084298, -122.481186169595) | 11 | 6 | 2 | 55 | 26 | ||
159293 | 9031 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5990365.52035 | 2112599.40799 | 37.7802398682569 | -122.476960548186 | (37.7802398682569, -122.476960548186) | 11 | 6 | 2 | 55 | 26 | ||
68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
148366 | 30786 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 477 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2011 12:00:00 AM | Permit Number 768077 | 6013986.79222779 | 2112639.44439925 | 37.781691783585 | -122.395245890478 | (37.781691783585, -122.395245890478) | 6 | 2 | 9 | 28856 | 6 | ||
178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
134325 | 60027 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 41 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/2013 12:00:00 AM | Permit Number 769856 | 6014655.81368733 | 2112837.99803451 | 37.7822741509003 | -122.392945269869 | (37.7822741509003, -122.392945269869) | 6 | 2 | 9 | 28856 | 6 | ||
62962 | 97446 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997060.8 | 2112843.2 | 37.7812953839865 | -122.453816232036 | (37.7812953839865, -122.453816232036) | 11 | 6 | 2 | 54 | 16 | ||
76277 | 24659 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3299X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772930 | 5997061.39714 | 2112911.45264 | 37.7814828219847 | -122.453819096525 | (37.7814828219847, -122.453819096525) | 11 | 6 | 2 | 54 | 16 | |
104430 | 53808 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 200X Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3x3 | Permit Number 772930 | 5997126.8655565 | 2112925.05365722 | 37.7815239200353 | -122.453593590958 | (37.7815239200353, -122.453593590958) | 11 | 6 | 2 | 54 | 16 | ||
54561 | 16816 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 3 | 4x4 | 6001234.7809998 | 2113147.0836075 | 37.7823681904894 | -122.439398128028 | (37.7823681904894, -122.439398128028) | 15 | 5 | 11 | 29490 | 41 | ||
177143 | 140885 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781739 | 5996566.0494 | 2113683.186 | 37.7835733852629 | -122.455588548359 | (37.7835733852629, -122.455588548359) | 11 | 6 | 1 | 54 | 31 | |
154970 | 139362 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.444470219362 | (37.7855412639984, -122.444470219362) | 15 | 6 | 1 | 29490 | 31 | |||
13429 | 105011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
25056 | 105010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
57341 | 105009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 7 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
45539 | 683 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | 11 | 6 | 1 | 55 | 33 | |
124462 | 17911 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.483 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | 13 | 9 | 11 | 29490 | 27 | ||
124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
191012 | 137900 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2191 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2013 12:00:00 AM | 11 | Width 0ft | 6003458.0512 | 2115193.5788 | 37.7881136242314 | -122.431852768372 | (37.7881136242314, -122.431852768372) | 13 | 9 | 11 | 29490 | 27 | ||
77164 | 17862 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.430996333749 | (37.7882072868246, -122.430996333749) | 13 | 9 | 11 | 29490 | 27 | ||
125035 | 255253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2178 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6003537 | 2115267 | 37.7883196953611 | -122.43158486312 | (37.7883196953611, -122.43158486312) | 13 | 9 | 1 | 29490 | 27 | ||
42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
170762 | 256228 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||||
181198 | 118312 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002301 | 2116562 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | 13 | 9 | 1 | 29490 | 27 | ||||
94466 | 255395 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
128713 | 255394 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
120674 | 124797 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.7957629573367 | -122.446414930702 | (37.7957629573367, -122.446414930702) | 13 | 9 | 1 | 57 | 17 | |
91107 | 102914 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | 13 | 9 | 1 | 57 | 17 | ||
93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
172881 | 121042 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2101 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
11136 | 131782 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | 13 | 9 | 1 | 57 | 17 | ||
16011 | 131781 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 5999580.2108 | 2118368.89391 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | 13 | 9 | 1 | 57 | 17 | ||
36912 | 46881 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | |||
114150 | 104604 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
125406 | 104605 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
162511 | 104603 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
189069 | 104606 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007173 | 2118980 | 37.7987200876771 | -122.419268364856 | (37.7987200876771, -122.419268364856) | 5 | 1 | 10 | 28858 | 32 | ||
74355 | 115438 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | 5 | 9 | 1 | 28858 | 32 | ||
12471 | 76775 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
46430 | 76789 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
51070 | 76761 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
53958 | 76804 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
85994 | 76813 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
91598 | 76793 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
106404 | 76809 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 |
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) );