Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128 | 128 | 212622 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 115 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991392.0 | 2089980.0 | 37.718192344870296 | -122.471760605115 | (37.7181923448703, -122.471760605115) | |||
| 303 | 303 | 196320 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 905 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 450 | 450 | 142159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 490X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 482 | 482 | 142326 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1652 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
| 924 | 924 | 214223 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999983.92895 | 2095213.9818900002 | 37.7330570333525 | -122.44243762501199 | (37.7330570333525, -122.442437625012) | |||
| 1087 | 1087 | 236728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002564.10416 | 2100703.66645 | 37.7482771632622 | -122.433909544687 | (37.7482771632622, -122.433909544687) | |||
| 1658 | 1658 | 245160 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000314.5004 | 2109304.1699 | 37.7717641118423 | -122.4423059193 | (37.7717641118423, -122.4423059193) | |||
| 1660 | 1660 | 245161 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000318.8213 | 2109280.9033 | 37.7717004738838 | -122.442289302515 | (37.7717004738838, -122.442289302515) | |||
| 1661 | 1661 | 245154 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000359.4788 | 2109307.5305 | 37.771775902629706 | -122.44215057779499 | (37.7717759026297, -122.442150577795) | |||
| 1663 | 1663 | 251645 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1669 | 1669 | 245155 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000354.8127 | 2109347.659 | 37.7718858194659 | -122.442169599164 | (37.7718858194659, -122.442169599164) | |||
| 1670 | 1670 | 251646 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1675 | 1675 | 245153 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 100 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000359.9454 | 2109295.8652 | 37.7717438992436 | -122.44214812628701 | (37.7717438992436, -122.442148126287) | |||
| 1677 | 1677 | 251644 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 132 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011949.0 | 2112390.0 | 37.7808933270361 | -122.40227818697599 | (37.7808933270361, -122.402278186976) | ||||
| 1681 | 1681 | 246983 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 779954 | 6004884.234759999 | 2101078.02552 | 37.7494364577399 | -122.42591323621201 | (37.7494364577399, -122.425913236212) | ||
| 1684 | 1684 | 236727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779934 | 6002562.04117 | 2100731.79845 | 37.7483542900352 | -122.43391868899201 | (37.7483542900352, -122.433918688992) | ||
| 1716 | 1716 | 236992 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 300x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007066.0 | 2096791.0 | 37.7377883043483 | -122.418064736265 | (37.7377883043483, -122.418064736265) | |||
| 1896 | 1896 | 236582 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | Permit Number 779645 | 6009292.7773400005 | 2105398.5203400003 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | ||
| 2113 | 2113 | 2684 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2100 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003399.8502 | 2114890.5748 | 37.787278352566105 | -122.432032487909 | (37.7872783525661, -122.432032487909) | |||
| 2174 | 2174 | 113405 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2120 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006435.39008 | 2118126.47056 | 37.796334942346 | -122.42176007795901 | (37.796334942346, -122.421760077959) | |||
| 2396 | 2396 | 135722 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 2420 | 2420 | 135721 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2498X Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | Permit Number 779691 | 6001734.0 | 2116823.0 | 37.7924897105997 | -122.437934432064 | (37.7924897105997, -122.437934432064) | ||
| 3039 | 3039 | 236868 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 101 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5998866.62555 | 2107543.5611799997 | 37.7668472992937 | -122.44718746183901 | (37.7668472992937, -122.447187461839) | |||
| 3446 | 3446 | 245003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1201 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000711.7175 | 2109261.453 | 37.771669453199294 | -122.440928858006 | (37.7716694531993, -122.440928858006) | |||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3541 | 3541 | 253472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3548 | 3548 | 253473 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3600 | 3600 | 246903 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997265.5984 | 2107392.9739200003 | 37.7663422157406 | -122.452714254467 | (37.7663422157406, -122.452714254467) | |||
| 3601 | 3601 | 246904 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 491 Frederick St | 2 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 6 | Width 3ft | 5997307.10356 | 2107397.6585 | 37.7663574565623 | -122.452571034738 | (37.7663574565623, -122.452571034738) | |||
| 3644 | 3644 | 196082 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 701 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6015721.57305 | 2103923.0720900004 | 37.7578548576382 | -122.388635680008 | (37.7578548576382, -122.388635680008) | |||
| 3675 | 3675 | 237732 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4059 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001898.0 | 2105817.0 | 37.7622793253591 | -122.436578855242 | (37.7622793253591, -122.436578855242) | |||
| 4158 | 4158 | 253614 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1959x Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006418.0 | 2117595.0 | 37.794874677003605 | -122.421782481899 | (37.7948746770036, -122.421782481899) | ||||
| 4486 | 4486 | 235699 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 301 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004133.22198 | 2109878.38027 | 37.773557659984895 | -122.42913766099 | (37.7735576599849, -122.42913766099) | |||
| 4731 | 4731 | 237544 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 7x8 | 6003442.2831 | 2105633.6495 | 37.76186352451221 | -122.43122467539801 | (37.7618635245122, -122.431224675398) | |||
| 5249 | 5249 | 243309 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 780 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 6007491.9091300005 | 2105126.68883 | 37.760700186689796 | -122.41718265916799 | (37.7607001866898, -122.417182659168) | |||
| 5717 | 5717 | 115706 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3055 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5999536.24333 | 2116655.51656 | 37.7919046220513 | -122.445526661347 | (37.7919046220513, -122.445526661347) | |||
| 6090 | 6090 | 105252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1875 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 770851 | 6004061.8803 | 2118683.0933 | 37.7977291534815 | -122.43001264475201 | (37.7977291534815, -122.430012644752) | ||||
| 7538 | 7538 | 2644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004293.9749 | 2114957.7562 | 37.787513465908496 | -122.42894379742201 | (37.7875134659085, -122.428943797422) | |||
| 7618 | 7618 | 2643 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1911 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6004268.353999999 | 2114955.8815 | 37.7875068682146 | -122.429032306872 | (37.7875068682146, -122.429032306872) | |||
| 7944 | 7944 | 114576 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3600 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x7 | 5997488.7199800005 | 2115765.45327 | 37.7893436424566 | -122.452546800688 | (37.7893436424566, -122.452546800688) | |||
| 8834 | 8834 | 113406 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2120 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6006433.268180001 | 2118140.51551 | 37.796373386588606 | -122.42176841830201 | (37.7963733865886, -122.421768418302) | |||
| 10122 | 10122 | 173861 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4618 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000547.0 | 2104681.0 | 37.7590832830794 | -122.441169935678 | (37.7590832830794, -122.441169935678) | ||||
| 11228 | 11228 | 27092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006103.20931 | 2093594.9436599999 | 37.728958403708894 | -122.42116669629699 | (37.7289584037089, -122.421166696297) | |||
| 11578 | 11578 | 27091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 717 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006120.2550800005 | 2093595.10299 | 37.7289598021321 | -122.42110777902398 | (37.7289598021321, -122.421107779024) | |||
| 12256 | 12256 | 26978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 532 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004762.815690001 | 2093485.8585299999 | 37.7285832245248 | -122.42579277741001 | (37.7285832245248, -122.42579277741) | |||
| 13533 | 13533 | 116188 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013460.33766 | 2092361.8798900002 | 37.725984673034795 | -122.395646018568 | (37.7259846730348, -122.395646018568) | |||
| 13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
| 14318 | 14318 | 17462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2022 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6012632.03621 | 2096963.3752099997 | 37.7385733165067 | -122.398832221241 | (37.7385733165067, -122.398832221241) | |||
| 14563 | 14563 | 116184 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013385.98536 | 2092427.1118400001 | 37.7261596505439 | -122.395907620544 | (37.7261596505439, -122.395907620544) | |||
| 14896 | 14896 | 100885 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013481.274680001 | 2111873.9835900003 | 37.779561876626296 | -122.396941070175 | (37.7795618766263, -122.396941070175) | |||
| 15470 | 15470 | 116187 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013439.38211 | 2092375.3069099998 | 37.7260203752154 | -122.395719401447 | (37.7260203752154, -122.395719401447) | |||
| 15502 | 15502 | 119264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1243 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013843.6616400005 | 2105220.96082 | 37.7613143247043 | -122.39522124448798 | (37.7613143247043, -122.395221244488) | |||
| 15547 | 15547 | 100883 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013382.01151 | 2111778.63358 | 37.779294541435796 | -122.397277778167 | (37.7792945414358, -122.397277778167) | |||
| 15827 | 15827 | 100893 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013651.46361 | 2112030.89517 | 37.7800021918959 | -122.396363310639 | (37.7800021918959, -122.396363310639) | |||
| 16101 | 16101 | 100887 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013527.06662 | 2111917.77164 | 37.7796846574549 | -122.39678572578899 | (37.7796846574549, -122.396785725789) | |||
| 16275 | 16275 | 116186 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013421.91014 | 2092392.0296900002 | 37.726065320631896 | -122.39578097261699 | (37.7260653206319, -122.395780972617) | |||
| 16551 | 16551 | 116185 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1751 Carroll Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013402.92261 | 2092407.9070599999 | 37.7261078603777 | -122.395847723887 | (37.7261078603777, -122.395847723887) | |||
| 16625 | 16625 | 100886 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | |||
| 17729 | 17729 | 10111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.758065870971706 | -122.423343289458 | (37.7580658709717, -122.423343289458) | |||
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 18974 | 18974 | 10193 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6005736.259869999 | 2102154.58599 | 37.752440559408896 | -122.42304341594699 | (37.7524405594089, -122.423043415947) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) | |||
| 19736 | 19736 | 121676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993867.0 | 2101351.0 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | ||||
| 19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 22284 | 22284 | 196235 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 474 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010444.82065 | 2112504.83625 | 37.781124561999995 | -122.407490004484 | (37.781124562, -122.407490004484) | |||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22815 | 22815 | 237464 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001532.2528099995 | 2101727.17835 | 37.7510288729044 | -122.437550937446 | (37.7510288729044, -122.437550937446) | |||
| 23375 | 23375 | 218050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 72 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991878.2117099995 | 2095609.0189900002 | 37.7336763568794 | -122.470489732417 | (37.7336763568794, -122.470489732417) | |||
| 23401 | 23401 | 202171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6013157.586080001 | 2093193.49557 | 37.7282512748665 | -122.39675089323799 | (37.7282512748665, -122.396750893238) | |||
| 23403 | 23403 | 236934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008695.69019 | 2096102.34104 | 37.735988986904104 | -122.412381425157 | (37.7359889869041, -122.412381425157) | |||
| 23405 | 23405 | 237701 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 59 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004493.49891 | 2107447.38395 | 37.7669031211042 | -122.427718167486 | (37.7669031211042, -122.427718167486) | |||
| 23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
| 23427 | 23427 | 217997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2626 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990831.30116 | 2097513.28208 | 37.738844388362295 | -122.47424807748301 | (37.7388443883623, -122.474248077483) | |||
| 23431 | 23431 | 213073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994467.524230001 | 2101712.07423 | 37.7505832012692 | -122.46198020334299 | (37.7505832012692, -122.461980203343) | |||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 23469 | 23469 | 217939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 931 Ortega St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991070.881569999 | 2102443.07073 | 37.7523941894478 | -122.47377926811001 | (37.7523941894478, -122.47377926811) | |||
| 23481 | 23481 | 218410 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994280.90702 | 2100599.38004 | 37.7475172792951 | -122.462544833698 | (37.7475172792951, -122.462544833698) | |||
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23591 | 23591 | 237541 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 351 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004042.14499 | 2103330.47017 | 37.755573516829 | -122.428985775399 | (37.755573516829, -122.428985775399) | |||
| 23616 | 23616 | 236591 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1087 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009469.71038 | 2102846.00835 | 37.754549020845204 | -122.41018128234501 | (37.7545490208452, -122.410181282345) | |||
| 23619 | 23619 | 248592 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 825 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997630.862000001 | 2107647.8664 | 37.7670630083716 | -122.45146926878701 | (37.7670630083716, -122.451469268787) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23696 | 23696 | 212999 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1639 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5993681.9391 | 2104325.0016900003 | 37.7577123690443 | -122.46488653520201 | (37.7577123690443, -122.464886535202) | |||
| 23712 | 23712 | 114789 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 30 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998464.24696 | 2116358.615 | 37.7910281517879 | -122.44921435656401 | (37.7910281517879, -122.449214356564) | |||
| 23723 | 23723 | 142204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000185.7051 | 2110200.5827 | 37.7742180933985 | -122.442815809613 | (37.7742180933985, -122.442815809613) | |||
| 23751 | 23751 | 196085 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 899 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6015519.48704 | 2104939.50859 | 37.760634573050794 | -122.389405564436 | (37.7606345730508, -122.389405564436) | |||
| 23853 | 23853 | 235939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 114 Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008703.15909 | 2099068.47895 | 37.744133771662895 | -122.41256521244101 | (37.7441337716629, -122.412565212441) | |||
| 23857 | 23857 | 235906 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3400 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005630.30801 | 2103749.3730099997 | 37.7568134948552 | -122.423523186264 | (37.7568134948552, -122.423523186264) | |||
| 23934 | 23934 | 248050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | ||||
| 23970 | 23970 | 212728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1287 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992976.77161 | 2106756.7423799997 | 37.764348608513 | -122.467502106342 | (37.764348608513, -122.467502106342) | |||
| 23993 | 23993 | 236308 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 480 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006778.703509999 | 2100983.33732 | 37.749283347246205 | -122.419355383451 | (37.7492833472462, -122.419355383451) | |||
| 24014 | 24014 | 236568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3305 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007699.57868 | 2100897.33121 | 37.7490990159066 | -122.416164880221 | (37.7490990159066, -122.416164880221) | |||
| 24057 | 24057 | 217901 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 276 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996581.0878099995 | 2105554.97883 | 37.7612563049516 | -122.454949015779 | (37.7612563049516, -122.454949015779) | |||
| 24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) |
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");