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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 32419 | 32419 | 89550 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 5539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981409.7822199995 | 2111623.31383 | 37.7770361978186 | -122.50786956100401 | (37.7770361978186, -122.507869561004) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13001 | 13001 | 93459 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1901X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987294.6457 | 2098913.1049 | 37.742482411351396 | -122.486578778111 | (37.7424824113514, -122.486578778111) | ||
| 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) | ||
| 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) | ||
| 10775 | 10775 | 93460 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987430.6912 | 2098918.5196 | 37.7425052083655 | -122.486108776631 | (37.7425052083655, -122.486108776631) | ||
| 13104 | 13104 | 93461 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1855X Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5987454.3807 | 2098917.8428 | 37.7425047306499 | -122.48602681673599 | (37.7425047306499, -122.486026816736) | ||
| 12811 | 12811 | 86059 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1821 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987499.4352 | 2102865.9001 | 37.7533476658044 | -122.486160793796 | (37.7533476658044, -122.486160793796) | ||
| 12806 | 12806 | 86011 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1662 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987503.8484 | 2103979.9523 | 37.7564068087083 | -122.486227310645 | (37.7564068087083, -122.486227310645) | ||
| 10767 | 10767 | 86061 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1877 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987508.8564 | 2102515.9989 | 37.752387480581206 | -122.48610253041201 | (37.7523874805812, -122.486102530412) | ||
| 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) | ||
| 13087 | 13087 | 86010 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987520.2506 | 2103632.0177 | 37.7554524306337 | -122.486145046236 | (37.7554524306337, -122.486145046236) | ||
| 10502 | 10502 | 86009 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1722 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987523.9067 | 2103537.3673 | 37.755192759360106 | -122.486125454711 | (37.7551927593601, -122.486125454711) | ||
| 10467 | 10467 | 86008 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1726 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987525.9378 | 2103513.8062 | 37.7551281853344 | -122.48611670118099 | (37.7551281853344, -122.486116701181) | ||
| 12471 | 12471 | 86064 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1931 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987527.1305 | 2102126.3201 | 37.7513185925094 | -122.486010735012 | (37.7513185925094, -122.486010735012) | ||
| 10754 | 10754 | 86066 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1959 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.0381 | 2101952.375 | 37.7508412720312 | -122.48598099746 | (37.7508412720312, -122.48598099746) | ||
| 12356 | 12356 | 86067 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1963 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987532.5834 | 2101927.292 | 37.7507724326317 | -122.485977270831 | (37.7507724326317, -122.485977270831) | ||
| 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) | ||
| 11141 | 11141 | 86005 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1770 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987533.6561 | 2103240.4169 | 37.754377982127295 | -122.486069942013 | (37.7543779821273, -122.486069942013) | ||
| 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) | ||
| 10619 | 10619 | 86004 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1774 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.4685 | 2103215.2309 | 37.7543088755282 | -122.486065283877 | (37.7543088755282, -122.486065283877) | ||
| 12786 | 12786 | 86003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1786 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987537.7183 | 2103137.642 | 37.7540960267794 | -122.486048350317 | (37.7540960267794, -122.486048350317) | ||
| 10736 | 10736 | 86002 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1824 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987543.255 | 2102835.2262 | 37.7532659973414 | -122.486007006329 | (37.7532659973414, -122.486007006329) | ||
| 11053 | 11053 | 86001 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1828 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987544.5696 | 2102809.3725 | 37.753195086669294 | -122.486000562627 | (37.7531950866693, -122.486000562627) | ||
| 12321 | 12321 | 86000 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1832 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987545.0078 | 2102782.6424 | 37.7531217185644 | -122.485997085337 | (37.7531217185644, -122.485997085337) | ||
| 13043 | 13043 | 85999 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1844 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987550.0547 | 2102710.7553 | 37.7529246300957 | -122.485974356105 | (37.7529246300957, -122.485974356105) | ||
| 10825 | 10825 | 85998 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1848 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987552.182999999 | 2102681.5677 | 37.752844612846395 | -122.485964853879 | (37.7528446128464, -122.485964853879) | ||
| 10948 | 10948 | 85997 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1852 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987552.7911 | 2102660.2851 | 37.7527862120032 | -122.485961188927 | (37.7527862120032, -122.485961188927) | ||
| 11122 | 11122 | 85996 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1872 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987556.1355 | 2102525.9006 | 37.7524174232854 | -122.48593976036699 | (37.7524174232854, -122.485939760367) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12824 | 12824 | 86069 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2111 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987567.2055 | 2100898.1204 | 37.7479486207706 | -122.48578201797301 | (37.7479486207706, -122.485782017973) | ||
| 12837 | 12837 | 86071 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2123 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987569.1258 | 2100830.1459 | 37.7477620928546 | -122.485770389498 | (37.7477620928546, -122.485770389498) | ||
| 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) | ||
| 13192 | 13192 | 86073 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2139 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987572.3617 | 2100731.7372 | 37.747492077405795 | -122.48575197852101 | (37.7474920774058, -122.485751978521) | ||
| 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) | ||
| 10374 | 10374 | 85990 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2234 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987638.7841 | 2100062.768 | 37.7456591364178 | -122.485473213008 | (37.7456591364178, -122.485473213008) | ||
| 13012 | 13012 | 85989 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2250 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.6248 | 2099959.0705 | 37.7453746344244 | -122.48545232432 | (37.7453746344244, -122.48545232432) | ||
| 10407 | 10407 | 85987 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2286 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987649.8793 | 2099748.6884 | 37.744797403731106 | -122.485411804387 | (37.7447974037311, -122.485411804387) | ||
| 11068 | 11068 | 86516 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1303 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2006 12:00:00 AM | 3 | 3x3 | 5987691.5588 | 2106373.6447 | 37.762990173852 | -122.48575382789801 | (37.762990173852, -122.485753827898) | ||
| 13091 | 13091 | 86495 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1534 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5987787.3318 | 2104833.8728 | 37.7587679608906 | -122.485309594748 | (37.7587679608906, -122.485309594748) | ||
| 10379 | 10379 | 86560 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1887 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 6 | 3x3 | 5987821.2541 | 2102469.8936 | 37.7522790893532 | -122.48501883929899 | (37.7522790893532, -122.485018839299) | ||
| 12591 | 12591 | 86475 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1770 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987843.9387 | 2103258.2798 | 37.7544451068579 | -122.48499822919202 | (37.7544451068579, -122.484998229192) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 12963 | 12963 | 86569 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2345 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987929.3557 | 2099339.0087 | 37.7436888099546 | -122.484415397808 | (37.7436888099546, -122.484415397808) | ||
| 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) | ||
| 10469 | 10469 | 86571 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2401X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098914.797 | 37.7425250909553 | -122.484321687901 | (37.7425250909553, -122.484321687901) | ||
| 10713 | 10713 | 86573 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2423 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098798.3799 | 37.742205440307295 | -122.48431315163401 | (37.7422054403073, -122.484313151634) | ||
| 13154 | 13154 | 86572 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2419 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987948.1382 | 2098840.0058 | 37.7423197734648 | -122.48431386335399 | (37.7423197734648, -122.484313863354) | ||
| 10462 | 10462 | 86574 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2435 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987950.8455 | 2098721.8965 | 37.74199563410829 | -122.484295842204 | (37.7419956341083, -122.484295842204) | ||
| 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) | ||
| 12343 | 12343 | 86576 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2501 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987968.6399 | 2098226.6612 | 37.740636884435396 | -122.48419800493 | (37.7406368844354, -122.48419800493) | ||
| 10350 | 10350 | 86577 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2519 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987971.7931 | 2098127.9672 | 37.740366080244 | -122.484179866453 | (37.740366080244, -122.484179866453) | ||
| 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) | ||
| 12502 | 12502 | 86578 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2523 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987972.739 | 2098103.6878 | 37.7402994704648 | -122.48417481583799 | (37.7402994704648, -122.484174815838) | ||
| 10961 | 10961 | 86453 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2330 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987973.3506 | 2099428.6905 | 37.74393761420671 | -122.48426985180201 | (37.7439376142067, -122.484269851802) | ||
| 12953 | 12953 | 86579 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2535 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987974.3156 | 2098044.7236 | 37.7401376620565 | -122.48416504156201 | (37.7401376620565, -122.484165041562) | ||
| 10332 | 10332 | 86580 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2539 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987975.8922 | 2098002.1559 | 37.740020874126394 | -122.484156469463 | (37.7400208741264, -122.484156469463) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 10610 | 10610 | 86583 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2567 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987981.2526 | 2097846.7049 | 37.7395943585814 | -122.48412653866998 | (37.7395943585814, -122.48412653867) | ||
| 12481 | 12481 | 86449 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2370 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987981.4727 | 2099180.2889 | 37.743256041979606 | -122.48422355425699 | (37.7432560419796, -122.484223554257) | ||
| 10702 | 10702 | 86368 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1235 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987981.927999999 | 2106870.8736 | 37.764372343527704 | -122.48478603091999 | (37.7643723435277, -122.48478603092) | ||
| 10410 | 10410 | 86450 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | ||
| 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) | ||
| 10293 | 10293 | 86369 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1281 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5987992.2676 | 2106611.2343 | 37.7636600473858 | -122.484731221945 | (37.7636600473858, -122.484731221945) | ||
| 10928 | 10928 | 86448 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2410 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987993.1483 | 2098903.2906 | 37.7424961575573 | -122.484162874059 | (37.7424961575573, -122.484162874059) | ||
| 10519 | 10519 | 86446 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2426 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987996.8709 | 2098757.0924 | 37.742094952584296 | -122.484139283552 | (37.7420949525843, -122.484139283552) | ||
| 11018 | 11018 | 86445 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2434 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987997.5477 | 2098724.6039 | 37.7420057871296 | -122.484134561433 | (37.7420057871296, -122.484134561433) | ||
| 12281 | 12281 | 86371 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.0325 | 2106399.6463 | 37.7630795369037 | -122.48468884389999 | (37.7630795369037, -122.4846888439) | ||
| 12746 | 12746 | 86444 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2438 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988000.2551 | 2098696.1765 | 37.7419278906096 | -122.48412311600401 | (37.7419278906096, -122.484123116004) | ||
| 10787 | 10787 | 86372 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988000.5736 | 2106373.6733 | 37.7630082536672 | -122.48468506709101 | (37.7630082536672, -122.484685067091) | ||
| 11039 | 11039 | 86373 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1309 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988001.1147 | 2106356.358 | 37.7629607421046 | -122.484681925407 | (37.7629607421046, -122.484681925407) | ||
| 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) | ||
| 12534 | 12534 | 86442 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2470 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988005.6699 | 2098496.5076 | 37.7413799676446 | -122.484089754678 | (37.7413799676446, -122.484089754678) | ||
| 13165 | 13165 | 86375 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1335 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988007.6079 | 2106189.1571 | 37.7625020323163 | -122.48464720252399 | (37.7625020323163, -122.484647202524) | ||
| 13167 | 13167 | 86441 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2498 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988007.7004 | 2098406.8258 | 37.7411338432365 | -122.484076158984 | (37.7411338432365, -122.484076158984) | ||
| 12273 | 12273 | 86377 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1347 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2007 12:00:00 AM | 3 | 3x3 | 5988009.7723 | 2106116.6492 | 37.7623030714917 | -122.484634397827 | (37.7623030714917, -122.484634397827) | ||
| 12667 | 12667 | 86440 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2506 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988014.3608 | 2098206.7963 | 37.7405850025908 | -122.484038465173 | (37.7405850025908, -122.484038465173) | ||
| 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) | ||
| 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) | ||
| 12727 | 12727 | 85961 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1200 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2006 12:00:00 AM | 3 | 3x3 | 5988024.0524 | 2107011.4158 | 37.7647606871244 | -122.484650646191 | (37.7647606871244, -122.484650646191) | ||
| 13118 | 13118 | 86439 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2550 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988024.4509 | 2097942.8764 | 37.7398609352841 | -122.48398422975 | (37.7398609352841, -122.48398422975) | ||
| 12490 | 12490 | 86438 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2558 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988026.0275 | 2097893.3718 | 37.7397251004281 | -122.483975149426 | (37.7397251004281, -122.483975149426) | ||
| 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) | ||
| 12670 | 12670 | 86437 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2566 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5988027.6041 | 2097846.7049 | 37.7395970571481 | -122.483966277165 | (37.7395970571481, -122.483966277165) | ||
| 12361 | 12361 | 86380 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1435 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/2006 12:00:00 AM | 3 | 3x3 | 5988029.9401 | 2105512.7054 | 37.7606459810936 | -122.48452034532801 | (37.7606459810936, -122.484520345328) |
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");