trees
2,694 rows where qSpecies_id = 84 sorted by rowid 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
194222 | 119595 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 431 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005470 | 2110737 | 37.7759908035691 | -122.42457463067 | (37.7759908035691, -122.42457463067) | 7 | 9 | 11 | 28852 | 10 | ||||
194169 | 89654 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3021 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989260.15494 | 2111906.26324 | 37.7782725005109 | -122.480733712855 | (37.7782725005109, -122.480733712855) | 11 | 6 | 2 | 55 | 26 | ||
194142 | 183559 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1616 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987905.5766 | 2097633.8663 | 37.7390055533414 | -122.484372584152 | (37.7390055533414, -122.484372584152) | 1 | 8 | 3 | 29491 | 35 | |||
194112 | 117182 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6000152.35367 | 2086600.71374 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) | 9 | 7 | 6 | 28861 | 5 | |||
194026 | 36583 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1378 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39444 | 6009261.20468059 | 2101135.34094494 | 37.7498402210045 | -122.410781546504 | (37.7498402210045, -122.410781546504) | 2 | 4 | 7 | 28859 | 19 | ||
194014 | 36433 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 435 Montecito Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39339 | 5995738.77288151 | 2093964.11788292 | 37.7293823258224 | -122.457023785093 | (37.7293823258224, -122.457023785093) | 9 | 7 | 4 | 28861 | 40 | ||
193888 | 31050 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.19583 | 2087448.13614 | 37.7118958587859 | -122.432025692555 | (37.7118958587859, -122.432025692555) | 9 | 7 | 6 | 28861 | 5 | |
193778 | 45139 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/2001 12:00:00 AM | Permit Number 43996 | 6000511.08946601 | 2109229.61979704 | 37.7715706185616 | -122.44162055585 | (37.7715706185616, -122.44162055585) | 15 | 5 | 11 | 29492 | 9 | ||
193738 | 95027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | 9 | 7 | 8 | 309 | 39 | |||
193729 | 119871 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
193697 | 43905 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1050 York St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/26/2002 12:00:00 AM | 6 | 3x3 | Permit Number 43505 | 6009958.09497236 | 2103085.10649041 | 37.7552328939148 | -122.408509176777 | (37.7552328939148, -122.408509176777) | 2 | 4 | 7 | 28859 | 19 |
193667 | 50546 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
193655 | 178919 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5993793.90715 | 2086767.20458 | 37.7095094537686 | -122.463225303004 | (37.7095094537686, -122.463225303004) | 9 | 8 | 6 | 28861 | 25 | ||||
193599 | 36395 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 799 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39328 | 5994869.9 | 2093286.2 | 37.7274709926994 | -122.459978448904 | (37.7274709926994, -122.459978448904) | 9 | 8 | 4 | 28861 | 40 | ||
193581 | 43004 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 205X Rose St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42873 | 6005609.30796774 | 2109736.9244771 | 37.7732527046739 | -122.424021592666 | (37.7732527046739, -122.424021592666) | 7 | 9 | 11 | 28852 | 10 | |||
193554 | 86441 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | 1 | 8 | 3 | 29491 | 35 | ||
193453 | 45252 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 568 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44099 | 6009813.67282905 | 2098883.83763279 | 37.7436890489958 | -122.408712260487 | (37.7436890489958, -122.408712260487) | 2 | 7 | 7 | 28859 | 2 | ||
193418 | 37877 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 591 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/2002 12:00:00 AM | Permit Number 40158 | 5996748.50508252 | 2094082.2355122 | 37.7297645826714 | -122.453541590937 | (37.7297645826714, -122.453541590937) | 9 | 7 | 4 | 28861 | 40 | ||
193399 | 32175 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.494335637657 | (37.7296472241819, -122.494335637657) | 1 | 8 | 4 | 64 | 35 | ||
193327 | 107756 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
193129 | 62859 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 215 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23227 | 6008661.7100891 | 2097596.64616316 | 37.7400901161593 | -122.412604509779 | (37.7400901161593, -122.412604509779) | 10 | 7 | 7 | 28859 | 2 | ||
193098 | 13090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | 3 | 1 | 10 | 308 | 23 | ||
193034 | 35304 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3459 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | Permit Number 38773 | 6005812.46547868 | 2106053.59345559 | 37.763150623964 | -122.423056990755 | (37.763150623964, -122.423056990755) | 8 | 4 | 5 | 28859 | 19 | ||
192833 | 101729 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 90 Rotteck St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003352.20109 | 2094564.64642 | 37.731465517513 | -122.430746301695 | (37.731465517513, -122.430746301695) | 9 | 7 | 5 | 28861 | 25 | |||
192826 | 32137 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 618 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.427699936535 | (37.7756480927458, -122.427699936535) | 7 | 9 | 11 | 28852 | 10 | |||
192818 | 66440 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 260 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29585 | 6006101.64636516 | 2096073.98831183 | 37.7357652252977 | -122.421348075821 | (37.7357652252977, -122.421348075821) | 2 | 7 | 7 | 28859 | 2 | ||
192813 | 60884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | 3 | 1 | 10 | 308 | 32 | |
192588 | 50427 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 575 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | Permit Number 47080 | 5996062.43497228 | 2089871.90840865 | 37.718164673097 | -122.455609193168 | (37.718164673097, -122.455609193168) | 9 | 8 | 6 | 28861 | 24 | ||
192462 | 249684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 16 | Front Yard : Yard | Tree | Private 2 | 5 | 5999742.63307 | 2117264.679 | 37.7935890018918 | -122.44485636243 | (37.7935890018918, -122.44485636243) | 13 | 9 | 1 | 57 | 27 | ||||
192459 | 37266 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 910 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39808 | 6004347.42466294 | 2103632.04316278 | 37.7564188405554 | -122.427951511444 | (37.7564188405554, -122.427951511444) | 2 | 4 | 5 | 28862 | 22 | ||
192258 | 104036 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 149 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 770678 | 6005538 | 2099025 | 37.7438362440335 | -122.423506557165 | (37.7438362440335, -122.423506557165) | 2 | 7 | 5 | 28859 | 22 | ||
192187 | 62945 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 119 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | Permit Number 23327 | 6007203.62024712 | 2097035.47638332 | 37.7384673272843 | -122.417606237796 | (37.7384673272843, -122.417606237796) | 2 | 7 | 7 | 28859 | 2 | ||
192186 | 184291 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.500453457035 | (37.7579775103532, -122.500453457035) | 1 | 8 | 3 | 56 | 35 | |||
192185 | 48941 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1343 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46128 | 6011661.44049501 | 2091503.35733972 | 37.7235271168325 | -122.401804405977 | (37.7235271168325, -122.401804405977) | 10 | 3 | 7 | 309 | 28 | ||
192158 | 52163 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2807 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | Permit Number 48356 | 6009994.23902274 | 2102188.41779998 | 37.7527728106966 | -122.408320936624 | (37.7527728106966, -122.408320936624) | 2 | 4 | 7 | 28859 | 19 | ||
192041 | 51766 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3638 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2005 12:00:00 AM | 1 | Permit Number 48032 | 5982963.9827 | 2104265.9264 | 37.7569263685127 | -122.501948660048 | (37.7569263685127, -122.501948660048) | 1 | 8 | 3 | 56 | 35 | ||
191901 | 86073 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2139 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987572.3617 | 2100731.7372 | 37.7474920774058 | -122.485751978521 | (37.7474920774058, -122.485751978521) | 1 | 8 | 3 | 29491 | 35 | ||
191890 | 178878 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001997.79635 | 2089434.88388 | 37.7173035182202 | -122.435061980046 | (37.7173035182202, -122.435061980046) | 9 | 7 | 6 | 28861 | 5 | |||
191796 | 182162 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1626 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988119.2271 | 2104209.3374 | 37.7570724853531 | -122.48411596268 | (37.7570724853531, -122.48411596268) | 1 | 8 | 3 | 56 | 35 | |||
191780 | 31304 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | 7 | 9 | 11 | 28852 | 10 | |
191732 | 93809 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 460 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2010 12:00:00 AM | 3 | Permit Number 57622 | 6003467.08848 | 2090756.16475 | 37.7210147855714 | -122.43007752987 | (37.7210147855714, -122.43007752987) | 9 | 7 | 6 | 28861 | 5 | ||
191637 | 68951 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 738 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32940 | 5988848.01258948 | 2110286.79093664 | 37.7738019171776 | -122.482040779575 | (37.7738019171776, -122.482040779575) | 11 | 6 | 2 | 55 | 26 | ||
191625 | 178917 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | 9 | 8 | 6 | 28861 | 25 | ||||
191079 | 40461 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 327 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41546 | 6007757.73635157 | 2097585.89785669 | 37.7400098280367 | -122.415729329739 | (37.7400098280367, -122.415729329739) | 2 | 7 | 7 | 28859 | 2 | ||
191066 | 45277 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 530 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44120 | 6007988.96647408 | 2096402.04290031 | 37.736772218146 | -122.414846064185 | (37.736772218146, -122.414846064185) | 2 | 7 | 7 | 28859 | 2 | ||
190934 | 214401 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 306 San Benito Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992866.37257 | 2094814.05906 | 37.731550682422 | -122.467015624375 | (37.731550682422, -122.467015624375) | 9 | 8 | 4 | 59 | 40 | |||
190864 | 88647 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 66 Carmelita St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51627 | 6002622 | 2108750 | 37.7703737429248 | -122.434284510625 | (37.7703737429248, -122.434284510625) | 15 | 5 | 5 | 29492 | 9 | ||
190738 | 50537 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
190721 | 108896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) | 9 | 7 | 6 | 28861 | 5 |
190677 | 244969 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 215 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005489.603 | 2109760.4598 | 37.7733105679298 | -122.424437343055 | (37.7733105679298, -122.424437343055) | 7 | 9 | 11 | 28852 | 10 | |||
190654 | 40948 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 88 Hoff St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2006 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.7635776994032 | -122.420541432191 | (37.7635776994032, -122.420541432191) | 8 | 4 | 7 | 28859 | 19 | ||
190616 | 32149 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 131 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35500 | 6006458.85096741 | 2110609.91009121 | 37.7756976404314 | -122.421144903557 | (37.7756976404314, -122.421144903557) | 7 | 9 | 11 | 28852 | 10 | ||
190602 | 33705 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 156 Germania St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/1996 12:00:00 AM | Permit Number 37773 | 6003507.92359647 | 2108831.35817354 | 37.7706473771769 | -122.431225909902 | (37.7706473771769, -122.431225909902) | 15 | 9 | 11 | 29492 | 10 | |||
190507 | 141251 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 42 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996544.3904 | 2114296.4063 | 37.7852558820777 | -122.455707820412 | (37.7852558820777, -122.455707820412) | 11 | 6 | 1 | 54 | 31 | |||
190450 | 52532 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | 3 | 1 | 10 | 308 | 4 | |
190195 | 214464 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000254.92383 | 2094969.53305 | 37.732401276487 | -122.441483191608 | (37.732401276487, -122.441483191608) | 9 | 7 | 5 | 63 | 40 | |||
190086 | 119844 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 350 Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6005602 | 2110303 | 37.774806598562 | -122.424087136382 | (37.774806598562, -122.424087136382) | 7 | 9 | 11 | 28852 | 10 | ||||
189992 | 247371 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 485 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002156.5991 | 2110137.258 | 37.7741563822913 | -122.435993611299 | (37.7741563822913, -122.435993611299) | 15 | 5 | 11 | 29492 | 10 | |||
189941 | 31922 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2296 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.471361438247 | (37.7451690123809, -122.471361438247) | 1 | 8 | 4 | 29491 | 40 | ||
189938 | 21627 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1615 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/14/2010 12:00:00 AM | 6 | 4X4 | Permit Number 53778 | 6004639.3671 | 2114660.2794 | 37.7867162131248 | -122.427727606137 | (37.7867162131248, -122.427727606137) | 13 | 9 | 11 | 28858 | 13 |
189902 | 45359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 438 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44767 | 5993275.62106747 | 2090094.58069454 | 37.71861576102 | -122.465258102457 | (37.71861576102, -122.465258102457) | 9 | 8 | 6 | 64 | 24 | ||
189836 | 34397 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 140 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38144 | 6002549.58677603 | 2096969.20024046 | 37.7380223658164 | -122.433692879918 | (37.7380223658164, -122.433692879918) | 2 | 7 | 5 | 63 | 7 | ||
189834 | 115103 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 98X HEMLOCK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6006944 | 2114961 | 37.7876720140792 | -122.419775454842 | (37.7876720140792, -122.419775454842) | 13 | 9 | 10 | 28858 | 21 | |||
189468 | 178873 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003894.97731 | 2089471.28937 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | 9 | 7 | 6 | 28861 | 5 | |||
189446 | 181947 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | 1 | 8 | 3 | 29491 | 35 | |||
189435 | 178958 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1343 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007547.64809 | 2091871.91329 | 37.7243086569025 | -122.41605117804 | (37.7243086569025, -122.41605117804) | 9 | 3 | 7 | 309 | 28 | |||
189426 | 11200 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 186 Idora Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
189364 | 86327 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2243 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.1071 | 2100050.8193 | 37.7456781015473 | -122.482397228469 | (37.7456781015473, -122.482397228469) | 1 | 8 | 3 | 29491 | 35 | ||
189280 | 183377 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2651 22nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5989551.7412 | 2097288.806 | 37.7381538243682 | -122.478655737727 | (37.7381538243682, -122.478655737727) | 1 | 8 | 3 | 29491 | 35 | |||
189263 | 40945 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 88209 Hoff St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.7635776994032 | -122.420541432191 | (37.7635776994032, -122.420541432191) | 8 | 4 | 7 | 28859 | 19 | |||
189226 | 50492 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 482 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47128 | 6002953.58784191 | 2090964.55788787 | 37.7215578906721 | -122.43186742077 | (37.7215578906721, -122.43186742077) | 9 | 7 | 6 | 28861 | 5 | ||
189122 | 67748 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1335 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31372 | 5994848.87035119 | 2106474.80190224 | 37.7636823790106 | -122.461006650075 | (37.7636823790106, -122.461006650075) | 15 | 5 | 11 | 56 | 12 | ||
189093 | 62635 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1324 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1986 12:00:00 AM | Permit Number 22949 | 5996806.80477756 | 2106915.30020618 | 37.7650043464959 | -122.454266620813 | (37.7650043464959, -122.454266620813) | 15 | 5 | 11 | 29492 | 12 | ||
189039 | 82029 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
188821 | 182184 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1608 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5988115.6488 | 2104343.8826 | 37.757441701729 | -122.484138204224 | (37.757441701729, -122.484138204224) | 1 | 8 | 3 | 56 | 35 | |||
188668 | 58241 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 4076 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/1993 12:00:00 AM | Permit Number 30095 | 6002509.96042506 | 2104751.71629184 | 37.7593890705536 | -122.434386149845 | (37.7593890705536, -122.434386149845) | 2 | 4 | 5 | 28862 | 3 | ||
188652 | 41710 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 76 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42158 | 6002439.09088109 | 2096621.84793492 | 37.7370623461114 | -122.434050095507 | (37.7370623461114, -122.434050095507) | 2 | 7 | 5 | 63 | 7 | ||
188503 | 196412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | 8 | 2 | 9 | 28853 | 34 | |||
188486 | 86201 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2395X 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988867.9747 | 2099129.0407 | 37.7431669043821 | -122.481154545962 | (37.7431669043821, -122.481154545962) | 1 | 8 | 3 | 29491 | 35 | ||
188445 | 53024 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 120@ DEWEY Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2006 12:00:00 AM | Permit Number 49003 | 5994552.8833077 | 2099973.38897946 | 37.7458141244153 | -122.461558986184 | (37.7458141244153, -122.461558986184) | 1 | 8 | 4 | 29491 | 40 | |||
188339 | 42760 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 415 Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42742 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.427511197042 | (37.7737647507648, -122.427511197042) | 7 | 9 | 11 | 28852 | 10 | |||
188252 | 62482 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 78 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1986 12:00:00 AM | Permit Number 22653 | 6000523.38358106 | 2092909.95134628 | 37.7267614316362 | -122.440407408467 | (37.7267614316362, -122.440407408467) | 9 | 7 | 6 | 28861 | 25 | ||
188240 | 36379 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 163 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39324 | 5995635.21078628 | 2093789.09624801 | 37.7288958108223 | -122.457369149688 | (37.7288958108223, -122.457369149688) | 9 | 7 | 4 | 28861 | 40 | ||
188210 | 135898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 12 Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006854.34381 | 2115529.77615 | 37.7892286821026 | -122.420126029605 | (37.7892286821026, -122.420126029605) | 13 | 9 | 10 | 28858 | 21 | |||
188202 | 4029 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2150 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6012617.9559004 | 2100994.1740901 | 37.7496402484926 | -122.399163766262 | (37.7496402484926, -122.399163766262) | 10 | 3 | 8 | 58 | 1 | ||
188108 | 86202 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2395X 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.6808 | 2099096.9051 | 37.7430788257671 | -122.481142836501 | (37.7430788257671, -122.481142836501) | 1 | 8 | 3 | 29491 | 35 | ||
187525 | 86375 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1335 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988007.6079 | 2106189.1571 | 37.7625020323163 | -122.484647202524 | (37.7625020323163, -122.484647202524) | 1 | 8 | 3 | 56 | 35 | ||
187391 | 62657 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 57 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22981 | 6002581.77855395 | 2108714.97321017 | 37.7702752849631 | -122.434421131765 | (37.7702752849631, -122.434421131765) | 15 | 5 | 5 | 29492 | 9 | ||
187384 | 42788 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 426 -28 - 30 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42755 | 6004546 | 2110000 | 37.7739149561089 | -122.427718466962 | (37.7739149561089, -122.427718466962) | 7 | 9 | 11 | 28852 | 10 | ||
187354 | 36353 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 115 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39312 | 5995603.96545011 | 2093439.4482819 | 37.7279339670328 | -122.457451880091 | (37.7279339670328, -122.457451880091) | 9 | 7 | 4 | 28861 | 40 | ||
187352 | 86197 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2329 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988857.8266 | 2099447.6905 | 37.7440412431524 | -122.481212963642 | (37.7440412431524, -122.481212963642) | 1 | 8 | 3 | 29491 | 35 | ||
187351 | 183343 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | 1 | 8 | 3 | 56 | 35 | |||
187319 | 245934 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 83 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998834.6076 | 2107782.3225 | 37.7675010480684 | -122.447315392636 | (37.7675010480684, -122.447315392636) | 15 | 5 | 11 | 29492 | 9 | |||
187293 | 185736 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5987568.4406 | 2100856.1259 | 37.7478333870661 | -122.485774665371 | (37.7478333870661, -122.485774665371) | 1 | 8 | 3 | 29491 | 35 | |||
187262 | 67735 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1339 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31354 | 5992372.79097163 | 2106335.64523608 | 37.7631574984922 | -122.46956043118 | (37.7631574984922, -122.46956043118) | 1 | 8 | 11 | 56 | 12 | ||
187173 | 28648 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1600X Webster St | 10 | Median : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 6 | 6003548.747 | 2114394.8281 | 37.7859255976047 | -122.431481932616 | (37.7859255976047, -122.431481932616) | 13 | 9 | 11 | 29490 | 13 | ||
187102 | 67710 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.69743 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | 6 | 2 | 9 | 28856 | 6 | |
186944 | 26795 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.7123203019902 | -122.406792924435 | (37.7123203019902, -122.406792924435) | 9 | 7 | 8 | 309 | 39 | ||
186875 | 40946 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 88209 Hoff St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | Permit Number 41805 | 6006542.66951499 | 2106194.13608518 | 37.7635776994032 | -122.420541432191 | (37.7635776994032, -122.420541432191) | 8 | 4 | 7 | 28859 | 19 |
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) );