Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11145 | 11145 | 86328 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.9606 | 2100030.7626 | 37.7456230807951 | -122.482392807934 | (37.7456230807951, -122.482392807934) | ||
| 11155 | 11155 | 86207 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2443 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988885.2281 | 2098689.4081 | 37.7419607913912 | -122.481062705501 | (37.7419607913912, -122.481062705501) | ||
| 11157 | 11157 | 86388 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1543 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988055.0728 | 2104801.2215 | 37.7586939032987 | -122.48438123978599 | (37.7586939032987, -122.484381239786) | ||
| 11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
| 11171 | 11171 | 86212 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2475 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988890.6429 | 2098502.9376 | 37.741449106920705 | -122.48103033287902 | (37.7414491069207, -122.481030332879) | ||
| 11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
| 11216 | 11216 | 86260 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1730 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988456.9316 | 2103534.0331 | 37.755237937503296 | -122.482898574742 | (37.7552379375033, -122.482898574742) | ||
| 11235 | 11235 | 86215 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2611 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988923.4537 | 2097544.6896 | 37.7388199149273 | -122.480846746123 | (37.7388199149273, -122.480846746123) | ||
| 11238 | 11238 | 86381 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1449 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988033.2668 | 2105434.5266 | 37.760431517128296 | -122.48450310552299 | (37.7604315171283, -122.484503105523) | ||
| 11254 | 11254 | 93464 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1709 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987892.9754 | 2098932.7333 | 37.7425711665628 | -122.484511397018 | (37.7425711665628, -122.484511397018) | ||
| 11267 | 11267 | 85948 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1478 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2006 12:00:00 AM | 3 | 3x3 | 5988082.7523 | 2105259.0401 | 37.7599525605076 | -122.484319089498 | (37.7599525605076, -122.484319089498) | ||
| 11283 | 11283 | 86391 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1575 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988062.4738 | 2104583.9812 | 37.7580978513193 | -122.484339711268 | (37.7580978513193, -122.484339711268) | ||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 11307 | 11307 | 86072 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2135 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987571.2196 | 2100754.5787 | 37.747554727515 | -122.48575760396002 | (37.747554727515, -122.48575760396) | ||
| 11389 | 11389 | 86396 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1615 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988073.4245 | 2104292.3546 | 37.75729776131279 | -122.48428045190599 | (37.7572977613128, -122.484280451906) | ||
| 11391 | 11391 | 86258 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1746 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988459.1216 | 2103429.4574 | 37.754950928168995 | -122.48288333738 | (37.754950928169, -122.48288333738) | ||
| 11392 | 11392 | 85993 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1886 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.1996 | 2102449.1312 | 37.7522066972052 | -122.485930446138 | (37.7522066972052, -122.485930446138) | ||
| 11398 | 11398 | 86374 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988004.3613 | 2106238.9386 | 37.762638529629506 | -122.48466208303199 | (37.7626385296295, -122.484662083032) | ||
| 11411 | 11411 | 93457 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/2009 12:00:00 AM | 3 | 3x3 | 5987093.9615 | 2098905.6596 | 37.74245026783021 | -122.487272128606 | (37.7424502678302, -122.487272128606) | ||
| 11422 | 11422 | 26785 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.40431164223101 | (37.7114882765061, -122.404311642231) | ||
| 11438 | 11438 | 86379 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1375 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988016.2656 | 2105945.6605 | 37.7618339613784 | -122.484599397348 | (37.7618339613784, -122.484599397348) | ||
| 11444 | 11444 | 86329 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2247 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988529.8141 | 2100010.2791 | 37.7455668881622 | -122.48238835613998 | (37.7455668881622, -122.48238835614) | ||
| 11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
| 11498 | 11498 | 85995 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1876 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.1996 | 2102499.9054 | 37.7523461094806 | -122.485934172676 | (37.7523461094806, -122.485934172676) | ||
| 11499 | 11499 | 86104 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2586 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988961.2103 | 2097747.6421 | 37.73937936427271 | -122.48073105683399 | (37.7393793642727, -122.480731056834) | ||
| 11518 | 11518 | 86451 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2358 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987978.4269 | 2099245.2659 | 37.743434274314396 | -122.484238850005 | (37.7434342743144, -122.484238850005) | ||
| 11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
| 11545 | 11545 | 26790 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | ||
| 11547 | 11547 | 85938 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1590 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988108.9468 | 2104468.7646 | 37.7577842036766 | -122.484170540261 | (37.7577842036766, -122.484170540261) | ||
| 11559 | 11559 | 27104 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 637 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X3 | 6005511.99058 | 2093568.16222 | 37.7288515201802 | -122.423208682549 | (37.7288515201802, -122.423208682549) | |||
| 11573 | 11573 | 86006 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1766 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.8436 | 2103268.4464 | 37.7544548962014 | -122.48607480922199 | (37.7544548962014, -122.486074809222) | ||
| 11594 | 11594 | 86068 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1975 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.2192 | 2101849.8619 | 37.7505599257071 | -122.485965931252 | (37.7505599257071, -122.485965931252) | ||
| 11612 | 11612 | 95017 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.40530753468501 | (37.7117488165229, -122.405307534685) | |||
| 11620 | 11620 | 86115 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2490X 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988938.6988 | 2098392.9506 | 37.7411499047667 | -122.480856123487 | (37.7411499047667, -122.480856123487) | ||
| 11635 | 11635 | 93417 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1850 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2009 12:00:00 AM | 3 | 3x3 | 5987422.9075 | 2098985.1887 | 37.7426878104075 | -122.486140583017 | (37.7426878104075, -122.486140583017) | ||
| 11639 | 11639 | 86384 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1469 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988038.2569 | 2105288.5651 | 37.7600310371708 | -122.484475141227 | (37.7600310371708, -122.484475141227) | ||
| 11689 | 11689 | 86565 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2243 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987907.2026 | 2100032.4695 | 37.7455915795676 | -122.48454285152799 | (37.7455915795676, -122.484542851528) | ||
| 11712 | 11712 | 86567 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2307 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987921.2336 | 2099575.5655 | 37.744337859372294 | -122.484460828778 | (37.7443378593723, -122.484460828778) | ||
| 11720 | 11720 | 86062 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1885 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987513.2384 | 2102452.8984 | 37.7522144789944 | -122.486082745357 | (37.7522144789944, -122.486082745357) | ||
| 11725 | 11725 | 86063 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1907 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987519.4966 | 2102278.4539 | 37.7517358660999 | -122.48604829983401 | (37.7517358660999, -122.486048299834) | ||
| 11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
| 11751 | 11751 | 86389 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1547 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988054.2021 | 2104771.6176 | 37.7586125683242 | -122.484382079778 | (37.7586125683242, -122.484382079778) | ||
| 11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
| 11760 | 11760 | 86383 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1465 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988037.0094 | 2105333.0605 | 37.7601531367846 | -122.48448271934299 | (37.7601531367846, -122.484482719343) | ||
| 11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
| 11777 | 11777 | 86107 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2572 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988958.2563 | 2097845.6162 | 37.7396482039595 | -122.480748441073 | (37.7396482039595, -122.480748441073) | ||
| 11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
| 11792 | 11792 | 85933 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1638 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988122.0898 | 2104149.2214 | 37.7569075897464 | -122.484101654102 | (37.7569075897464, -122.484101654102) | ||
| 11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
| 11815 | 11815 | 85960 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1230 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988027.116 | 2106908.7855 | 37.764479070899 | -122.48463252131201 | (37.764479070899, -122.484632521312) | ||
| 11820 | 11820 | 86568 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2337 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987926.9868 | 2099392.4793 | 37.7438354881374 | -122.484427509802 | (37.7438354881374, -122.484427509802) | ||
| 11832 | 11832 | 85947 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1490 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988084.4157 | 2105183.7722 | 37.7597459921782 | -122.484307816387 | (37.7597459921782, -122.484307816387) | ||
| 11833 | 11833 | 86326 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2239 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988528.1071 | 2100079.4108 | 37.7457566062543 | -122.482399323004 | (37.7457566062543, -122.482399323004) | ||
| 11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
| 11845 | 11845 | 95018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.40521408790899 | (37.7117099327517, -122.405214087909) | |||
| 11846 | 11846 | 93412 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1634 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2009 12:00:00 AM | 3 | 3x3 | 5988062.1863 | 2099006.1709 | 37.7427826590933 | -122.48393170630399 | (37.7427826590933, -122.483931706304) | ||
| 11850 | 11850 | 85953 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1374 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988058.4716 | 2105953.2359 | 37.76185721916121 | -122.48445398099899 | (37.7618572191612, -122.484453980999) | ||
| 11851 | 11851 | 86118 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2466 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988934.9761 | 2098541.5177 | 37.7415576148348 | -122.48087986971201 | (37.7415576148348, -122.480879869712) | ||
| 11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) | |||
| 11856 | 11856 | 95002 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.712462163614795 | -122.406812851088 | (37.7124621636148, -122.406812851088) | |||
| 11859 | 11859 | 86570 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2375 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987937.4779 | 2099152.8767 | 37.743178213635105 | -122.48437366481501 | (37.7431782136351, -122.484373664815) | ||
| 11868 | 11868 | 85927 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988145.2074 | 2103551.0636 | 37.7552665558176 | -122.483977844866 | (37.7552665558176, -122.483977844866) | ||
| 11873 | 11873 | 86198 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2333 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988860.1945 | 2099419.6141 | 37.7439642903918 | -122.48120272055901 | (37.7439642903918, -122.481202720559) | ||
| 11874 | 11874 | 86324 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2223 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988525.1199 | 2100180.5478 | 37.746034127963796 | -122.482417061278 | (37.7460341279638, -122.482417061278) | ||
| 11904 | 11904 | 86331 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2259 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988531.521000001 | 2099947.9753 | 37.745395917668205 | -122.48237788986299 | (37.7453959176682, -122.482377889863) | ||
| 11906 | 11906 | 86094 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2662 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988979.4233 | 2097220.9939 | 37.7379343837052 | -122.480629541954 | (37.7379343837052, -122.480629541954) | ||
| 11927 | 11927 | 52333 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.40440027981701 | (37.7115198939825, -122.404400279817) | ||
| 11937 | 11937 | 86393 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1595 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988065.0859 | 2104499.9584 | 37.7578672995837 | -122.48432451533002 | (37.7578672995837, -122.48432451533) | ||
| 11953 | 11953 | 86463 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1866 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987865.2759 | 2102589.5992 | 37.7526103328382 | -122.48487538787501 | (37.7526103328382, -122.484875387875) | ||
| 11981 | 11981 | 86394 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1595 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988065.5212 | 2104481.6737 | 37.7578171200991 | -122.48432166889401 | (37.7578171200991, -122.484321668894) | ||
| 11982 | 11982 | 86584 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2591 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987986.2976 | 2097695.0377 | 37.7391782139584 | -122.484097976121 | (37.7391782139584, -122.484097976121) | ||
| 11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
| 11992 | 11992 | 85939 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1558 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988101.6611 | 2104690.7347 | 37.75839324920911 | -122.48421201536199 | (37.7583932492091, -122.484212015362) | ||
| 11993 | 11993 | 86199 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2371 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988864.9302 | 2099210.2254 | 37.7433896392864 | -122.481171016395 | (37.7433896392864, -122.481171016395) | ||
| 12005 | 12005 | 93421 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2014 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2009 12:00:00 AM | 3 | 3x3 | 5986933.5496 | 2098966.2371 | 37.7426072419271 | -122.487831227416 | (37.7426072419271, -122.487831227416) | ||
| 12012 | 12012 | 85885 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2594 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988342.102999999 | 2097683.778 | 37.7391680067391 | -122.482866951392 | (37.7391680067391, -122.482866951392) | ||
| 12024 | 12024 | 85950 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1426 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988070.6928 | 2105585.8941 | 37.760849310406705 | -122.484384769961 | (37.7608493104067, -122.484384769961) | ||
| 12029 | 12029 | 86454 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2326 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987972.3353 | 2099456.4411 | 37.744013750897295 | -122.48427539724199 | (37.7440137508973, -122.484275397242) | ||
| 12034 | 12034 | 86112 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2524 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988948.6558 | 2098119.1067 | 37.740398579611 | -122.480801652492 | (37.740398579611, -122.480801652492) | ||
| 12042 | 12042 | 85957 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1330 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988048.1907 | 2106230.8219999997 | 37.762618796080105 | -122.484509899399 | (37.7626187960801, -122.484509899399) | ||
| 12045 | 12045 | 86575 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2487 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987961.675 | 2098399.0421 | 37.7411097915164 | -122.484234725572 | (37.7411097915164, -122.484234725572) | ||
| 12048 | 12048 | 85994 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1886 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987557.5036 | 2102469.8058 | 37.7522634818033 | -122.485930912268 | (37.7522634818033, -122.485930912268) | ||
| 12054 | 12054 | 86582 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2555 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.0453 | 2097902.2006 | 37.73974660669621 | -122.484138239161 | (37.7397466066962, -122.484138239161) | ||
| 12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
| 12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
| 12090 | 12090 | 85962 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988020.9888 | 2107061.1992 | 37.7648972002579 | -122.484664894353 | (37.7648972002579, -122.484664894353) | ||
| 12099 | 12099 | 93471 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1409 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988822.3083 | 2098962.9504 | 37.7427082090524 | -122.48130028623699 | (37.7427082090524, -122.481300286237) | ||
| 12106 | 12106 | 93458 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1951 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987115.9589 | 2098905.998 | 37.7424524797237 | -122.487196094011 | (37.7424524797237, -122.487196094011) | ||
| 12110 | 12110 | 86263 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1706 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988453.0989 | 2103679.1251 | 37.7556360980974 | -122.48292246240901 | (37.7556360980974, -122.482922462409) | ||
| 12115 | 12115 | 85992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2206 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987631.9563 | 2100247.5457 | 37.746166089002706 | -122.48551037976499 | (37.7461660890027, -122.485510379765) | ||
| 12137 | 12137 | 86209 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2459 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988886.5818 | 2098605.141 | 37.741729494664796 | -122.48105185622299 | (37.7417294946648, -122.481051856223) | ||
| 12138 | 12138 | 86309 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1503 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988357.631 | 2105031.2185 | 37.7593430258366 | -122.483351727957 | (37.7593430258366, -122.483351727957) | ||
| 12149 | 12149 | 86210 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2463 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988886.9202 | 2098579.0825 | 37.7416579645084 | -122.48104877859 | (37.7416579645084, -122.48104877859) | ||
| 12156 | 12156 | 86038 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1261 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987366.2761 | 2106684.0781 | 37.7638235791025 | -122.486901653076 | (37.7638235791025, -122.486901653076) | ||
| 12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
| 12219 | 12219 | 86452 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2350 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987979.4422 | 2099298.3981 | 37.743580220411 | -122.48423923521099 | (37.743580220411, -122.484239235211) | ||
| 12236 | 12236 | 86103 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2590 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988963.1796 | 2097717.3637 | 37.7392963421237 | -122.48072203189501 | (37.7392963421237, -122.480722031895) | ||
| 12239 | 12239 | 95010 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010304.2603 | 2087368.7381 | 37.7120984674199 | -122.406204794273 | (37.7120984674199, -122.406204794273) | |||
| 12242 | 12242 | 86333 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2285 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.0686 | 2099797.3366 | 37.7449826262514 | -122.48234767234 | (37.7449826262514, -122.48234767234) | ||
| 12250 | 12250 | 86099 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2632 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988972.7801 | 2097406.2098 | 37.738442552384704 | -122.480666065628 | (37.7384425523847, -122.480666065628) |
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");