Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 162377 | 162377 | 194033 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 9 | : Yard 23 | Tree 1 | Private 1 | 18 | 6017162.02159 | 2102667.2446 | 37.7544863425722 | -122.383566530788 | (37.7544863425722, -122.383566530788) | ||||
| 54380 | 54380 | 194099 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 6016735.93504 | 2095074.45923 | 37.733614544669706 | -122.384511236201 | (37.7336145446697, -122.384511236201) | ||||
| 62308 | 62308 | 194101 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6016735.28252 | 2095083.6486799999 | 37.733639740984394 | -122.384514132028 | (37.7336397409844, -122.384514132028) | ||||
| 54080 | 54080 | 194100 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6016729.78084 | 2095080.8399099999 | 37.7336317244204 | -122.384532957547 | (37.7336317244204, -122.384532957547) | ||||
| 91621 | 91621 | 110056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 490 Jamestown Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016119.9 | 2086810.2 | 37.7108884169699 | -122.38606516043899 | (37.7108884169699, -122.386065160439) | |||||
| 147673 | 147673 | 194031 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1101 25th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 9ft | 6015324.74216 | 2102030.33526 | 37.7526358040022 | -122.38987589096901 | (37.7526358040022, -122.389875890969) | |||
| 158947 | 158947 | 194032 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 25th St | 9 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015018.29801 | 2102168.6663599997 | 37.7529986327902 | -122.39094530450599 | (37.7529986327902, -122.390945304506) | ||||
| 82981 | 82981 | 110866 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 141460 | 141460 | 110877 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 31490 | 31490 | 199752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1555 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014842.8005 | 2092447.5888 | 37.7262968166738 | -122.39087288178601 | (37.7262968166738, -122.390872881786) | |||
| 131380 | 131380 | 194064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1640 Davidson Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 6ft | 6014536.55143 | 2099742.5606 | 37.7463103162609 | -122.3924416073 | (37.7463103162609, -122.3924416073) | |||
| 90890 | 90890 | 44755 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2001 12:00:00 AM | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | |||
| 140399 | 140399 | 44756 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 256 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | Permit Number 43869 | 6014282.34232981 | 2105939.88092695 | 37.7633127092766 | -122.39375434301 | (37.7633127092766, -122.39375434301) | ||
| 83540 | 83540 | 111656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 96677 | 96677 | 111660 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 106585 | 106585 | 111654 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 112222 | 112222 | 111655 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 122826 | 122826 | 111659 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 126012 | 126012 | 111657 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 127871 | 127871 | 111658 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1740 CESAR CHAVEZ ST | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | 6014066.0 | 2101066.0 | 37.749918058990104 | -122.394161367931 | (37.7499180589901, -122.394161367931) | |||
| 146495 | 146495 | 200214 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1159 Hollister Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6014019.4134 | 2090279.6631 | 37.720298405471794 | -122.39356765042601 | (37.7202984054718, -122.393567650426) | |||
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 56871 | 56871 | 194048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1242 19th St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013830.06416 | 2105268.62635 | 37.761444447624 | -122.395271611894 | (37.761444447624, -122.395271611894) | |||
| 61219 | 61219 | 194047 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2 Turner Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6013813.323419999 | 2103501.8132700003 | 37.7565922319503 | -122.39520574557301 | (37.7565922319503, -122.395205745573) | ||||
| 155753 | 155753 | 194045 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013807.05349 | 2105290.79153 | 37.7615040286026 | -122.395352749639 | (37.7615040286026, -122.395352749639) | |||
| 163421 | 163421 | 194046 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6013804.04007 | 2105323.21797 | 37.761592896918394 | -122.395365443572 | (37.7615928969184, -122.395365443572) | |||
| 30894 | 30894 | 200231 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 5 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 6013732.1076 | 2090145.865 | 37.719915054156296 | -122.39455141525299 | (37.7199150541563, -122.394551415253) | |||
| 138059 | 138059 | 200229 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1079 Ingerson Ave | 3 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 6013701.2545 | 2090170.6816 | 37.719981480300795 | -122.39465980145201 | (37.7199814803008, -122.394659801452) | |||
| 27103 | 27103 | 194036 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 198 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6013693.35133 | 2106219.8544799997 | 37.764048707105495 | -122.395811103495 | (37.7640487071055, -122.395811103495) | |||
| 171462 | 171462 | 194037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 198 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6013692.33686 | 2106246.4130599997 | 37.764121574684296 | -122.395816473379 | (37.7641215746843, -122.395816473379) | |||
| 168440 | 168440 | 75548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013526.462719999 | 2104188.60864 | 37.758462065501796 | -122.39624595358102 | (37.7584620655018, -122.396245953581) | ||
| 55465 | 55465 | 75612 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 618X Missouri St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013522.58771 | 2104188.6871599997 | 37.7584620654811 | -122.396259360694 | (37.7584620654811, -122.396259360694) | ||
| 79255 | 79255 | 57585 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 297 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | 3x3 | Permit Number 16453 | 6013500.41645948 | 2105713.4077908 | 37.762647381026504 | -122.39644291208 | (37.7626473810265, -122.39644291208) | ||
| 52622 | 52622 | 194098 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 389 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 7ft | 6013425.60382 | 2110329.05815 | 37.7753167635898 | -122.397025307881 | (37.7753167635898, -122.397025307881) | |||
| 58531 | 58531 | 194097 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 389 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6013417.2361 | 2110322.9726299997 | 37.775299588326995 | -122.39705382716998 | (37.775299588327, -122.39705382717) | |||
| 26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
| 90341 | 90341 | 52736 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 108150 | 108150 | 52738 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 114027 | 114027 | 52737 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 142181 | 142181 | 52735 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2006 12:00:00 AM | Permit Number 48788 | 6013076.05424861 | 2112001.40957779 | 37.7798891948269 | -122.39835185397301 | (37.7798891948269, -122.398351853973) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 96875 | 96875 | 113665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1435 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013045.0 | 2106578.0 | 37.7649960058226 | -122.39807870262501 | (37.7649960058226, -122.398078702625) | ||||
| 44191 | 44191 | 194043 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1700 22nd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6012940.14961 | 2103802.44192 | 37.7573690942271 | -122.398246606115 | (37.7573690942271, -122.398246606115) | ||||
| 24163 | 24163 | 194035 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6012914.68454 | 2106566.8968 | 37.7649582598465 | -122.398528655089 | (37.7649582598465, -122.398528655089) | |||
| 107390 | 107390 | 97994 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 185 Arkansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6012911.0 | 2106193.0 | 37.763931416938895 | -122.398515160469 | (37.7639314169389, -122.398515160469) | ||
| 109442 | 109442 | 97993 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 185 Arkansas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6012911.0 | 2106193.0 | 37.763931416938895 | -122.398515160469 | (37.7639314169389, -122.398515160469) | ||
| 110738 | 110738 | 97992 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 185 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6012911.0 | 2106193.0 | 37.763931416938895 | -122.398515160469 | (37.7639314169389, -122.398515160469) | ||
| 140565 | 140565 | 97991 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 185 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6012911.0 | 2106193.0 | 37.763931416938895 | -122.398515160469 | (37.7639314169389, -122.398515160469) | ||
| 109300 | 109300 | 97998 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1450 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012865.0 | 2106120.0 | 37.7637284123596 | -122.39866913856501 | (37.7637284123596, -122.398669138565) | ||||
| 112171 | 112171 | 97997 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1450 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6012865.0 | 2106120.0 | 37.7637284123596 | -122.39866913856501 | (37.7637284123596, -122.398669138565) | ||
| 33896 | 33896 | 96037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2024 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6012798.80107 | 2095988.64888 | 37.7359062123914 | -122.39818725804301 | (37.7359062123914, -122.398187258043) | |||
| 9880 | 9880 | 3771 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1100X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012538.0 | 2102781.0 | 37.75454202913279 | -122.39956569430599 | (37.7545420291328, -122.399565694306) | |||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 64729 | 64729 | 194038 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012502.8583 | 2102970.8089 | 37.7550612440971 | -122.39970055084 | (37.7550612440971, -122.39970055084) | ||||
| 14667 | 14667 | 3750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012463.2126 | 2103693.82662 | 37.7570442824941 | -122.39988842642401 | (37.7570442824941, -122.399888426424) | |||
| 117072 | 117072 | 1782 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2001X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | |||
| 9884 | 9884 | 173718 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 906 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 3x3 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 169470 | 169470 | 177813 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2059 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012293.6892 | 2088070.36863 | 37.714136085289795 | -122.39937793255899 | (37.7141360852898, -122.399377932559) | |||
| 91329 | 91329 | 25556 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
| 117689 | 117689 | 25566 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
| 144391 | 144391 | 25557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2000 12:00:00 AM | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | ||
| 122045 | 122045 | 94044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1354 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53453 | 6012181.6 | 2102103.5 | 37.752661889425 | -122.40075063354601 | (37.752661889425, -122.400750633546) | |||
| 124154 | 124154 | 94043 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1354 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2010 12:00:00 AM | 3x3 | Permit Number 53453 | 6012181.6 | 2102103.5 | 37.752661889425 | -122.40075063354601 | (37.752661889425, -122.400750633546) | ||
| 27862 | 27862 | 194050 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2246 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012135.46921 | 2099441.05415 | 37.7453488151107 | -122.400723136672 | (37.7453488151107, -122.400723136672) | |||
| 128629 | 128629 | 110378 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2176 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011973.0 | 2097506.0 | 37.7400265061348 | -122.40114898501801 | (37.7400265061348, -122.401148985018) | ||||
| 65296 | 65296 | 110379 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2194 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011949.0 | 2097537.0 | 37.7401102866319 | -122.401234145483 | (37.7401102866319, -122.401234145483) | ||||
| 124317 | 124317 | 110380 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2200 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011920.0 | 2097566.0 | 37.74018829652721 | -122.401336453712 | (37.7401882965272, -122.401336453712) | ||||
| 123490 | 123490 | 194051 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1598 Bay Shore Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 6011883.611959999 | 2091657.73213 | 37.7239633945918 | -122.401047236139 | (37.7239633945918, -122.401047236139) | |||
| 151152 | 151152 | 102632 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 611 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Permit Number 770009 | 6011832.65646 | 2105500.64155 | 37.7619702218631 | -122.402196169527 | (37.7619702218631, -122.402196169527) | |||
| 50586 | 50586 | 194041 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6011789.4196 | 2105194.80325 | 37.761128044544705 | -122.40232420509899 | (37.7611280445447, -122.402324205099) | |||
| 71938 | 71938 | 194042 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6011788.47963 | 2105178.47145 | 37.761083148586394 | -122.402326307728 | (37.7610831485864, -122.402326307728) | |||
| 177007 | 177007 | 194040 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 698 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6011787.18264 | 2105219.37542 | 37.7611953893822 | -122.402333669585 | (37.7611953893822, -122.402333669585) | |||
| 33053 | 33053 | 119258 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6011770.8518 | 2105153.5101900003 | 37.761013626490204 | -122.402385519974 | (37.7610136264902, -122.402385519974) | |||
| 166728 | 166728 | 119259 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6011759.15032 | 2105152.1523700003 | 37.7610092449941 | -122.402425895061 | (37.7610092449941, -122.402425895061) | |||
| 98436 | 98436 | 110381 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011689.0 | 2097713.0 | 37.740579036374 | -122.402145495204 | (37.740579036374, -122.402145495204) | ||||
| 171896 | 171896 | 194066 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011686.01076 | 2097941.04754 | 37.741205039484 | -122.40217185994 | (37.741205039484, -122.40217185994) | |||
| 162087 | 162087 | 194065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011662.94046 | 2097957.49597 | 37.7412489156133 | -122.40225278546002 | (37.7412489156133, -122.40225278546) | |||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 109421 | 109421 | 194074 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2235 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | 6011541.53422 | 2097819.64053 | 37.7408636163769 | -122.40266287538999 | (37.7408636163769, -122.40266287539) | ||||
| 93562 | 93562 | 110425 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011518.0 | 2097294.0 | 37.7394190054764 | -122.402707291584 | (37.7394190054764, -122.402707291584) | ||||
| 58582 | 58582 | 194070 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 41 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | 6011513.73296 | 2097374.29319 | 37.7396392352499 | -122.40272769043501 | (37.7396392352499, -122.402727690435) | ||||
| 15372 | 15372 | 116055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/30/2016 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.40328006754801 | (37.7611252557522, -122.403280067548) | |
| 168957 | 168957 | 116048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4x4 | 6011498.51602 | 2105372.79225 | 37.7616005195649 | -122.403342842915 | (37.7616005195649, -122.403342842915) | ||
| 29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
| 83514 | 83514 | 110421 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 39 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 96661 | 96661 | 110424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 110936 | 110936 | 110418 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 33 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011494.0 | 2097294.0 | 37.739417665451604 | -122.402790273501 | (37.7394176654516, -122.402790273501) | ||||
| 15432 | 15432 | 25962 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2X3 | 6011447.1772300005 | 2098118.06457 | 37.7416777564365 | -122.40301011353901 | (37.7416777564365, -122.403010113539) | ||
| 181266 | 181266 | 194071 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2260 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | 6011443.9729 | 2097950.47892 | 37.7412174231363 | -122.403009408459 | (37.7412174231363, -122.403009408459) | ||||
| 144939 | 144939 | 110382 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2275 PALOU AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011433.0 | 2097903.0 | 37.7410864434132 | -122.40304401028999 | (37.7410864434132, -122.40304401029) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");