trees
261 rows where qSpecies_id = 177 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||
| 2233 | 256484 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 2 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
| 5671 | 13046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.410413314112 | (37.8032072253646, -122.410413314112) | 3 | 1 | 10 | 308 | 23 | |||
| 5804 | 253280 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2335 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007032 | 2120361 | 37.8025040230696 | -122.419854317954 | (37.8025040230696, -122.419854317954) | 5 | 1 | 1 | 28858 | 32 | ||||
| 8763 | 13089 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 11709 | 13039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||||
| 16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
| 18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 22838 | 143258 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.411677153186 | (37.8029290843214, -122.411677153186) | 3 | 1 | 10 | 308 | 23 | |||
| 30042 | 258516 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 30538 | 258520 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 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 | ||||
| 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 | ||||
| 42853 | 113802 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 SHOTWELL ST | 4 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 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 | ||||
| 49933 | 258519 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 55911 | 100649 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003141 | 2108015 | 37.7683850571797 | -122.432436785894 | (37.7683850571797, -122.432436785894) | 15 | 5 | 5 | 28862 | 3 | ||||
| 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 | ||||
| 61488 | 254585 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1236 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995818 | 2107128 | 37.7655316119834 | -122.457702020035 | (37.7655316119834, -122.457702020035) | 15 | 5 | 11 | 29492 | 12 | ||||
| 66864 | 117270 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 481 JERSEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6002050 | 2101440 | 37.7502697725383 | -122.435739974128 | (37.7502697725383, -122.435739974128) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 69900 | 254752 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||||
| 88367 | 95578 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501@ 6th Ave Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994244 | 2106639 | 37.7640983993107 | -122.463110607355 | (37.7640983993107, -122.463110607355) | 1 | 5 | 11 | 56 | 12 | |||||
| 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 | ||||
| 91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||||
| 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 | ||||
| 94001 | 143039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 520 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6009841.4502 | 2120571.1962 | 37.8032390411539 | -122.410147031042 | (37.8032390411539, -122.410147031042) | 3 | 1 | 10 | 308 | 23 | |||
| 94231 | 258514 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 102904 | 258517 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 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 | ||||
| 107470 | 112520 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
| 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 | ||||
| 115031 | 122520 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 250 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | 2 | 7 | 5 | 63 | 7 | ||||
| 116521 | 143019 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||||
| 120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||||
| 128647 | 255530 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 301 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | ||||
| 135717 | 112521 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
| 137970 | 121488 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 750 Parnassus Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5994725.72352 | 2106063.15709 | 37.7625450220518 | -122.461402729778 | (37.7625450220518, -122.461402729778) | 15 | 5 | 11 | 56 | 12 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 159702 | 258515 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 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 | ||||
| 163779 | 116372 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5993057 | 2106542 | 37.7637636140689 | -122.467209006309 | (37.7637636140689, -122.467209006309) | 1 | 8 | 11 | 56 | 12 | ||||
| 164090 | 18540 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 2x2 | Permit Number 778371 | 5999060.6585186 | 2099832.0947892 | 37.7456846005578 | -122.445961639207 | (37.7456846005578, -122.445961639207) | 2 | 7 | 5 | 63 | 22 | ||
| 167419 | 254751 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 167508 | 256485 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 3 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 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 | |||
| 128671 | 13042 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | 3 | 1 | 10 | 308 | 23 | ||
| 58253 | 13040 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:26:00 AM | 3 | 3X3 | 6009890.5899 | 2120540.3695 | 37.8031571528751 | -122.409974803368 | (37.8031571528751, -122.409974803368) | 3 | 1 | 10 | 308 | 23 | ||
| 175454 | 29909 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:29:00 AM | 3 | 3x3 | 6009867.8709 | 2120537.6157 | 37.8031483182934 | -122.410053228903 | (37.8031483182934, -122.410053228903) | 3 | 1 | 10 | 308 | 23 | ||
| 74050 | 103596 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 5 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 7066 | 115194 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.7578461817613 | -122.433743471638 | (37.7578461817613, -122.433743471638) | 2 | 4 | 5 | 28862 | 3 | |||
| 16281 | 13043 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.8032293051326 | -122.410248727784 | (37.8032293051326, -122.410248727784) | 3 | 1 | 10 | 308 | 23 | ||
| 45994 | 56898 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018 | 37.7519372972974 | -122.492346587933 | (37.7519372972974, -122.492346587933) | 1 | 8 | 3 | 56 | 35 | |||
| 166626 | 115253 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 20 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | 9 | 8 | 6 | 28861 | 24 | |||
| 6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
| 83725 | 13075 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/22/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774508 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | |
| 20330 | 115297 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||
| 44103 | 115287 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.7596251212978 | -122.469064003389 | (37.7596251212978, -122.469064003389) | 1 | 8 | 4 | 56 | 12 | |||
| 77781 | 115289 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.7613911460485 | -122.47167612106 | (37.7613911460485, -122.47167612106) | 1 | 8 | 4 | 56 | 12 | |||
| 116618 | 43627 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.492966865959 | (37.7454355618475, -122.492966865959) | 1 | 8 | 3 | 29491 | 35 |
| 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 | ||
| 114910 | 102005 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 168854 | 102006 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 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 | ||
| 19019 | 13004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | 3 | 1 | 10 | 308 | 23 | ||
| 17402 | 12986 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.406869163124 | (37.8036540726688, -122.406869163124) | 3 | 1 | 10 | 308 | 23 | ||
| 53358 | 12988 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.8036421292086 | -122.407016292062 | (37.8036421292086, -122.407016292062) | 3 | 1 | 10 | 308 | 23 |
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) );