trees
3,587 rows where qSpecies_id = 28 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80686 | 13301 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 1 | Median : Cutout | Tree | DPW 1 | 18 | 6 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 152150 | 13304 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 4 | Median : Cutout | Tree | DPW 1 | 12 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 178562 | 13303 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 3 | Median : Cutout | Tree | DPW 1 | 18 | 15 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 183101 | 13302 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 9X Lyell St | 2 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 6003085.6859492 | 2094681.4720202 | 37.7317711908882 | -122.431676032431 | (37.7317711908882, -122.431676032431) | 9 | 7 | 5 | 28861 | 25 | |||
| 44052 | 114240 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | |||||
| 126287 | 114225 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x FONT BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 48 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
| 176353 | 206418 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x Castenada Ave | 16 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | 1 | 8 | 4 | 29491 | 40 | |||
| 137179 | 111064 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99x CAPP ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6007219 | 2106804 | 37.7652903353746 | -122.418245454749 | (37.7652903353746, -122.418245454749) | 8 | 4 | 7 | 28853 | 19 | |||
| 52000 | 106170 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99X THOR AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 4x4 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 | |||
| 17286 | 24406 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 6 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 29397 | 24458 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 03/17/2001 12:00:00 AM | 6 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 48230 | 11762 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
| 99349 | 11760 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 24 | 3x3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | |||
| 170020 | 24405 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 999X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 01/28/2000 12:00:00 AM | 12 | 3X3 | 5991260.9047733 | 2090529.2081036 | 37.7196927494004 | -122.472253753748 | (37.7196927494004, -122.472253753748) | 9 | 8 | 6 | 64 | 24 | ||
| 97951 | 110542 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 996 SOUTH VAN NESS AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6007549 | 2103894 | 37.7573187187357 | -122.41689786927 | (37.7573187187357, -122.41689786927) | 2 | 4 | 7 | 28859 | 19 | |||||
| 144116 | 212074 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 99 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 6ft | 5994256.6309 | 2097391.56694 | 37.738708030453 | -122.462396147864 | (37.738708030453, -122.462396147864) | 9 | 8 | 4 | 59 | 40 | |||
| 138880 | 248711 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007008.13109 | 2098978.79964 | 37.7437922577052 | -122.418419901463 | (37.7437922577052, -122.418419901463) | 2 | 7 | 7 | 28859 | 2 | |||
| 95858 | 256023 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 99 Heron St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010037 | 2109967 | 37.7741334231767 | -122.408721775232 | (37.7741334231767, -122.408721775232) | 8 | 2 | 9 | 28853 | 34 | ||||
| 135545 | 111284 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 98X THOR AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 4.5 x9 | 6002346 | 2095994 | 37.7353331366469 | -122.434327078202 | (37.7353331366469, -122.434327078202) | 2 | 7 | 5 | 63 | 7 | |||
| 150334 | 19170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 98 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003469.0377609 | 2107737.5290241 | 37.7676417853534 | -122.431282325215 | (37.7676417853534, -122.431282325215) | 15 | 9 | 5 | 28862 | 3 | |||
| 184917 | 78 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 97X Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | 15 | 5 | 5 | 28862 | 3 | |||
| 74347 | 212073 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 6ft | 5994261.11238 | 2097463.04726 | 37.7389045557057 | -122.46238583625 | (37.7389045557057, -122.46238583625) | 9 | 8 | 4 | 59 | 40 | |||
| 47322 | 248672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004845.3119 | 2108840.52494 | 37.7707482453776 | -122.426600516098 | (37.7707482453776, -122.426600516098) | 7 | 9 | 5 | 28852 | 10 | |||
| 135627 | 248676 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6004877.40051 | 2108844.08516 | 37.7707598349224 | -122.426489774494 | (37.7707598349224, -122.426489774494) | 7 | 9 | 5 | 28852 | 10 | |||
| 153858 | 248675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6004907.9602 | 2108848.83767 | 37.7707746116773 | -122.426384406326 | (37.7707746116773, -122.426384406326) | 7 | 9 | 5 | 28852 | 10 | |||
| 138641 | 16568 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95X Nido Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 5999200.4791331 | 2112280.3747819 | 37.7798724518028 | -122.446373519186 | (37.7798724518028, -122.446373519186) | 15 | 5 | 1 | 54 | 16 | ||
| 180657 | 16569 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95X Nido Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2000 12:00:00 AM | 3 | 3X3 | 5999200.4791331 | 2112280.3747819 | 37.7798724518028 | -122.446373519186 | (37.7798724518028, -122.446373519186) | 15 | 5 | 1 | 54 | 16 | ||
| 177472 | 175996 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 959 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 6ft | 6001537.92258 | 2088610.33751 | 37.7150133739397 | -122.436592559601 | (37.7150133739397, -122.436592559601) | 9 | 7 | 6 | 28861 | 5 | |||
| 30445 | 248753 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 955 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007616.90844 | 2104099.62454 | 37.7578871360994 | -122.416677581009 | (37.7578871360994, -122.416677581009) | 2 | 4 | 7 | 28859 | 19 | |||
| 119385 | 107299 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 955 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 7x6 | 6007636.8 | 2104105.7 | 37.7579049366557 | -122.416609217837 | (37.7579049366557, -122.416609217837) | 2 | 4 | 7 | 28859 | 19 | |||
| 72553 | 103455 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 953 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x9 | 6001548 | 2088631 | 37.7150706812167 | -122.436559205883 | (37.7150706812167, -122.436559205883) | 9 | 7 | 6 | 28861 | 5 | ||||
| 31250 | 212259 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991274.76967 | 2090780.48576 | 37.7203834983807 | -122.472224135259 | (37.7203834983807, -122.472224135259) | 9 | 8 | 6 | 64 | 24 | |||
| 51153 | 212263 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5991290.45934 | 2091078.6284 | 37.7212030325641 | -122.472191622967 | (37.7212030325641, -122.472191622967) | 9 | 8 | 6 | 64 | 24 | |||
| 78705 | 212256 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5991256.60801 | 2090543.58608 | 37.7197319791141 | -122.472269653524 | (37.7197319791141, -122.472269653524) | 9 | 8 | 6 | 64 | 24 | |||
| 87400 | 212258 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5991271.42052 | 2090740.59287 | 37.720273768507 | -122.4722328056 | (37.720273768507, -122.4722328056) | 9 | 8 | 6 | 64 | 24 | |||
| 152972 | 212261 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991287.20633 | 2090983.7854 | 37.7209424288218 | -122.472195957673 | (37.7209424288218, -122.472195957673) | 9 | 8 | 6 | 64 | 24 | |||
| 159268 | 212257 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 4ft | 5991265.70439 | 2090677.64642 | 37.7201006022469 | -122.472247978075 | (37.7201006022469, -122.472247978075) | 9 | 8 | 6 | 64 | 24 | |||
| 184304 | 212260 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5991277.37814 | 2090844.74627 | 37.7205600928662 | -122.472219800499 | (37.7205600928662, -122.472219800499) | 9 | 8 | 6 | 64 | 24 | |||
| 187080 | 212264 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991294.251 | 2091109.76949 | 37.7212887577439 | -122.472180785219 | (37.7212887577439, -122.472180785219) | 9 | 8 | 6 | 64 | 24 | |||
| 188250 | 212262 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 951 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5991291.08137 | 2091048.64317 | 37.7211207365178 | -122.472187288206 | (37.7211207365178, -122.472187288206) | 9 | 8 | 6 | 64 | 24 | |||
| 77824 | 16690 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Noriega St | 1 | Median : Cutout | Tree | DPW 1 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | 1 | 8 | 4 | 56 | 12 | ||
| 192579 | 16692 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Noriega St | 3 | Median : Cutout | Tree | DPW 1 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.78631 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | 1 | 8 | 4 | 56 | 12 | ||
| 28235 | 122331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
| 182284 | 122330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996124 | 2112291 | 37.7797254357482 | -122.45701712634 | (37.7797254357482, -122.45701712634) | 11 | 6 | 2 | 54 | 16 | ||||
| 34653 | 124151 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996109.01256 | 2112263.63214 | 37.7796494301654 | -122.457066993925 | (37.7796494301654, -122.457066993925) | 11 | 6 | 2 | 54 | 16 | |||
| 150717 | 124152 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 950 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5996091.59731 | 2112260.8127 | 37.7796406885971 | -122.45712703643 | (37.7796406885971, -122.45712703643) | 11 | 6 | 2 | 54 | 16 | |||
| 31439 | 212058 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 6ft | 5993986.52339 | 2097235.52478 | 37.7382640198529 | -122.463318724595 | (37.7382640198529, -122.463318724595) | 1 | 8 | 4 | 59 | 40 | |||
| 109132 | 222938 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003520.45561 | 2107781.71115 | 37.7677660125137 | -122.43110763132 | (37.7677660125137, -122.43110763132) | 7 | 9 | 5 | 28862 | 3 | |||
| 186040 | 19167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.431116222266 | (37.767718716857, -122.431116222266) | 7 | 9 | 5 | 28862 | 3 | |||
| 55548 | 248673 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6005207.14412 | 2108888.77574 | 37.7709011795763 | -122.425352365033 | (37.7709011795763, -122.425352365033) | 7 | 9 | 5 | 28852 | 10 | |||
| 113425 | 248674 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005037.30148 | 2108867.21091 | 37.7708323706535 | -122.425938320109 | (37.7708323706535, -122.425938320109) | 7 | 9 | 5 | 28852 | 10 | |||
| 80998 | 122498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 949 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x6 | 5999128 | 2113764 | 37.7839419619379 | -122.446731035836 | (37.7839419619379, -122.446731035836) | 15 | 6 | 1 | 54 | 31 | |||
| 70427 | 2089 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 943 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001413.27766 | 2095566.23245 | 37.7341055996942 | -122.437521214854 | (37.7341055996942, -122.437521214854) | 9 | 7 | 5 | 63 | 40 | |||
| 80742 | 2092 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 943 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6001450.63808 | 2095555.96116 | 37.7340795211485 | -122.437391313181 | (37.7340795211485, -122.437391313181) | 9 | 7 | 5 | 63 | 40 | |||
| 86815 | 12647 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 937 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4PL | 5992498.72996 | 2114784.19766 | 37.7863622208719 | -122.4697399651 | (37.7863622208719, -122.4697399651) | 11 | 6 | 2 | 54 | 11 | |||
| 141231 | 212231 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 931 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6001483.11723 | 2095547.23015 | 37.7340573942257 | -122.437278397885 | (37.7340573942257, -122.437278397885) | 9 | 7 | 5 | 63 | 40 | |||
| 156096 | 2086 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 931 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 12 | 2X2 | 6001457.30881 | 2095546.90958 | 37.7340550468362 | -122.437367602498 | (37.7340550468362, -122.437367602498) | 9 | 7 | 5 | 63 | 40 | ||
| 159318 | 212230 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 931 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 2ft | 6001470.48299 | 2095551.23311 | 37.7340676671955 | -122.437322364832 | (37.7340676671955, -122.437322364832) | 9 | 7 | 5 | 63 | 40 | |||
| 163702 | 2087 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 931 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6001485.24516 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | 9 | 7 | 5 | 63 | 40 | |||
| 93713 | 19166 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 93 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003516.9621827 | 2107776.3737946 | 37.7677511594735 | -122.431119333657 | (37.7677511594735, -122.431119333657) | 7 | 9 | 5 | 28862 | 3 | |||
| 101386 | 212072 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 93 San Pablo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 5994265.10077 | 2097482.56478 | 37.73895837563 | -122.462373461579 | (37.73895837563, -122.462373461579) | 9 | 8 | 4 | 59 | 40 | |||
| 187676 | 246776 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 926 Esmeralda Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6009551.14862 | 2098756.05448 | 37.7433234771118 | -122.40961099258 | (37.7433234771118, -122.40961099258) | 2 | 7 | 7 | 28859 | 2 | |||
| 49976 | 4349 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001343.36929 | 2095994.07461 | 37.7352763802888 | -122.437793542132 | (37.7352763802888, -122.437793542132) | 2 | 7 | 5 | 63 | 7 | |||
| 84726 | 4350 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6001342.21657 | 2095863.76561 | 37.7349185164407 | -122.437788197517 | (37.7349185164407, -122.437788197517) | 2 | 7 | 5 | 63 | 7 | |||
| 115129 | 212171 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001568.1946 | 2095894.69722 | 37.7350162945642 | -122.437009127368 | (37.7350162945642, -122.437009127368) | 2 | 7 | 5 | 63 | 7 | |||
| 130402 | 4352 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001454.12602 | 2095943.23299 | 37.7351430782743 | -122.437406976652 | (37.7351430782743, -122.437406976652) | 2 | 7 | 5 | 63 | 7 | |||
| 131575 | 212170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 3ft | 6001544.08486 | 2095904.31771 | 37.735041339786 | -122.437093171723 | (37.735041339786, -122.437093171723) | 2 | 7 | 5 | 63 | 7 | |||
| 156217 | 4353 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001342.21657 | 2095863.76561 | 37.7349185164407 | -122.437788197517 | (37.7349185164407, -122.437788197517) | 2 | 7 | 5 | 63 | 7 | |||
| 180961 | 4351 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 925 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1992 12:00:00 AM | 28 | 3X3 | 6001420.13833 | 2095958.45484 | 37.735182941645 | -122.437525573868 | (37.735182941645, -122.437525573868) | 2 | 7 | 5 | 63 | 7 | ||
| 52484 | 4348 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 924 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001433.25109 | 2095991.10142 | 37.7352733271028 | -122.43748257547 | (37.7352733271028, -122.43748257547) | 2 | 7 | 5 | 63 | 7 | |||
| 85903 | 2085 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 921 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001545.78168 | 2095530.67878 | 37.7340155101049 | -122.437060563206 | (37.7340155101049, -122.437060563206) | 9 | 7 | 5 | 63 | 40 | |||
| 26634 | 212204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6001555.51112 | 2095599.51711 | 37.7342050772889 | -122.437031852331 | (37.7342050772889, -122.437031852331) | 9 | 7 | 5 | 63 | 7 | |||
| 33512 | 212209 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6001437.10561 | 2095636.37062 | 37.7342995375914 | -122.437443855175 | (37.7342995375914, -122.437443855175) | 9 | 7 | 5 | 63 | 7 | ||||
| 45308 | 212203 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 16 | 6001598.82808 | 2095593.88337 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | 2 | 7 | 5 | 63 | 7 | ||||
| 71506 | 212210 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6001335.34031 | 2095664.21523 | 37.7343702063207 | -122.437797683519 | (37.7343702063207, -122.437797683519) | 9 | 7 | 5 | 63 | 7 | ||||
| 116037 | 212206 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6001486.61652 | 2095618.44955 | 37.734253145164 | -122.437271397564 | (37.734253145164, -122.437271397564) | 9 | 7 | 5 | 63 | 7 | |||
| 121204 | 212212 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6001287.33853 | 2095677.45112 | 37.7344038193788 | -122.437964588704 | (37.7344038193788, -122.437964588704) | 9 | 7 | 5 | 63 | 7 | ||||
| 125911 | 212211 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6001309.95525 | 2095671.6217 | 37.7343890992751 | -122.43788597807 | (37.7343890992751, -122.43788597807) | 9 | 7 | 5 | 63 | 7 | ||||
| 147847 | 212207 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 11 | 6001467.5944 | 2095628.72955 | 37.7342802902926 | -122.43733789885 | (37.7342802902926, -122.43733789885) | 9 | 7 | 5 | 63 | 7 | ||||
| 152113 | 212205 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6001520.45314 | 2095614.45375 | 37.7342440970832 | -122.437154127763 | (37.7342440970832, -122.437154127763) | 9 | 7 | 5 | 63 | 7 | ||||
| 154788 | 212214 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6001218.32955 | 2095696.70858 | 37.7344527712804 | -122.438204553905 | (37.7344527712804, -122.438204553905) | 9 | 7 | 5 | 63 | 7 | ||||
| 170029 | 212213 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001230.14104 | 2095687.81352 | 37.7344290192751 | -122.438163080788 | (37.7344290192751, -122.438163080788) | 9 | 7 | 5 | 63 | 7 | |||
| 182262 | 212208 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 920 Bosworth St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001453.89018 | 2095626.12972 | 37.7342723726763 | -122.437385092546 | (37.7342723726763, -122.437385092546) | 9 | 7 | 5 | 63 | 7 | |||
| 124755 | 17603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6003916.62917 | 2090182.06037 | 37.7194638711075 | -122.428482700528 | (37.7194638711075, -122.428482700528) | 9 | 7 | 6 | 28861 | 5 | |||
| 140919 | 175997 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 918 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6003927.76143 | 2090183.89548 | 37.719469539881 | -122.428444351129 | (37.719469539881, -122.428444351129) | 9 | 7 | 6 | 28861 | 5 | |||
| 600 | 35359 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.7581511177091 | -122.40184581615 | (37.7581511177091, -122.40184581615) | 10 | 3 | 8 | 28856 | 29 |
| 53682 | 248787 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Elizabeth St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 25 | Width 4ft | 6000502.53313 | 2101961.51161 | 37.7516136966213 | -122.441128612294 | (37.7516136966213, -122.441128612294) | 2 | 4 | 5 | 28862 | 22 | |||
| 24910 | 50685 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.7654709832109 | -122.446105453704 | (37.7654709832109, -122.446105453704) | 15 | 5 | 11 | 29492 | 9 | ||||
| 35454 | 29603 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152467 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | 9 | 8 | 4 | 64 | 40 | ||
| 59681 | 29605 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910X Junipero Serra Blvd | 14 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152467 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | 9 | 8 | 4 | 64 | 40 | ||
| 149794 | 29604 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910X Junipero Serra Blvd | 13 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991188.7321263 | 2091104.0152467 | 37.7212668508959 | -122.472545111236 | (37.7212668508959, -122.472545111236) | 9 | 8 | 4 | 64 | 40 | ||
| 59161 | 222952 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002449.75588 | 2102930.69662 | 37.7543855699625 | -122.434464164711 | (37.7543855699625, -122.434464164711) | 2 | 4 | 5 | 28862 | 22 | |||
| 182407 | 222953 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 910 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002449.55702 | 2102903.83172 | 37.7543117940721 | -122.434462931727 | (37.7543117940721, -122.434462931727) | 2 | 4 | 5 | 28862 | 22 | |||
| 55825 | 19161 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 91 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6003505.74356 | 2107783.3498 | 37.7677696781622 | -122.431158635477 | (37.7677696781622, -122.431158635477) | 7 | 9 | 5 | 28862 | 3 | |||
| 6611 | 262204 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001442 | 2095927 | 37.735097816857 | -122.437447738546 | (37.735097816857, -122.437447738546) | 2 | 7 | 5 | 63 | 7 | ||||
| 134853 | 4338 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2016 12:00:00 AM | 3 | 3x3 | 6001440.66779 | 2095942.14934 | 37.7351393376957 | -122.437453428952 | (37.7351393376957, -122.437453428952) | 2 | 7 | 5 | 63 | 7 | ||
| 50300 | 212232 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001561.31088 | 2095526.9035 | 37.7340060267426 | -122.43700660387 | (37.7340060267426, -122.43700660387) | 9 | 7 | 5 | 63 | 40 | |||
| 52391 | 2083 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001485.24516 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | 9 | 7 | 5 | 63 | 40 | |||
| 64079 | 212233 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001573.66222 | 2095523.19402 | 37.7339965434037 | -122.436963636078 | (37.7339965434037, -122.436963636078) | 9 | 7 | 5 | 63 | 40 | |||
| 126954 | 2082 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 907 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6001485.24516 | 2095489.86478 | 37.73390000314 | -122.437266934857 | (37.73390000314, -122.437266934857) | 9 | 7 | 5 | 63 | 40 |
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) );