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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 12276 | 12276 | 85945 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1506 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988089.5183 | 2105016.1614 | 37.759286075581 | -122.48427787656401 | (37.759286075581, -122.484277876564) | ||
| 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) | ||
| 12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
| 12289 | 12289 | 86330 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2255 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988530.6675 | 2099974.0064 | 37.7454673425482 | -122.482382748037 | (37.7454673425482, -122.482382748037) | ||
| 12313 | 12313 | 86401 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1675 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988084.1595 | 2103923.071 | 37.756284433472295 | -122.484216244796 | (37.7562844334723, -122.484216244796) | ||
| 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) | ||
| 12328 | 12328 | 26789 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.40545390649599 | (37.7119288389604, -122.405453906496) | ||
| 12341 | 12341 | 86203 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988878.7981 | 2098855.9116 | 37.7424175926379 | -122.48109712708299 | (37.7424175926379, -122.481097127083) | ||
| 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) | ||
| 12352 | 12352 | 86120 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2430 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988925.5003 | 2098783.1509 | 37.74222052562529 | -122.48093032071199 | (37.7422205256253, -122.480930320712) | ||
| 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) | ||
| 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) | ||
| 12366 | 12366 | 86334 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2289 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988537.4954 | 2099766.6115 | 37.7448982880571 | -122.482343945808 | (37.7448982880571, -122.482343945808) | ||
| 12379 | 12379 | 85936 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1618 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988118.5115 | 2104260.1496 | 37.7572119602441 | -122.484122163635 | (37.7572119602441, -122.484122163635) | ||
| 12387 | 12387 | 85955 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1346 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988066.5882 | 2106122.0602 | 37.7623212372231 | -122.48443829226002 | (37.7623212372231, -122.48443829226) | ||
| 12408 | 12408 | 85941 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1546 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988098.2611 | 2104771.8486 | 37.758615768012795 | -122.48422972260799 | (37.7586157680128, -122.484229722608) | ||
| 12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 12452 | 12452 | 93469 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1501X Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2009 12:00:00 AM | 3 | 3x3 | 5988527.5163 | 2098956.0844 | 37.742672213494394 | -122.482319077312 | (37.7426722134944, -122.482319077312) | ||
| 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) | ||
| 12479 | 12479 | 86114 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2492X 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988940.7293 | 2098375.0142 | 37.741100774119396 | -122.48084778996599 | (37.7411007741194, -122.480847789966) | ||
| 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) | ||
| 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) | ||
| 12494 | 12494 | 86117 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2478 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988937.0067 | 2098483.986 | 37.741399765847504 | -122.480868637542 | (37.7413997658475, -122.480868637542) | ||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 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) | ||
| 12511 | 12511 | 86248 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2286 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988579.7425 | 2099773.866 | 37.7449206644087 | -122.482198396273 | (37.7449206644087, -122.482198396273) | ||
| 12514 | 12514 | 86211 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2467 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988889.6276 | 2098553.7009 | 37.7415884306548 | -122.48103755941001 | (37.7415884306548, -122.48103755941) | ||
| 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) | ||
| 12546 | 12546 | 86221 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2667 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988934.7468 | 2097197.923 | 37.7378684403296 | -122.480782320208 | (37.7378684403296, -122.480782320208) | ||
| 12586 | 12586 | 86323 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1747 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988408.9241 | 2103416.7251 | 37.7549130478095 | -122.483055999276 | (37.7549130478095, -122.483055999276) | ||
| 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) | ||
| 12592 | 12592 | 93411 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1532 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2009 12:00:00 AM | 3 | 3x3 | 5988415.4987 | 2099015.9851 | 37.7428301684871 | -122.482710785873 | (37.7428301684871, -122.482710785873) | ||
| 12594 | 12594 | 86108 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2568 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988957.0255 | 2097873.1868 | 37.73972383411171 | -122.48075471450899 | (37.7397238341117, -122.480754714509) | ||
| 12619 | 12619 | 86205 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2431 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988881.5055 | 2098779.7667 | 37.7422086760624 | -122.481082191599 | (37.7422086760624, -122.481082191599) | ||
| 12621 | 12621 | 95008 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.712393072261705 | -122.40698585693501 | (37.7123930722617, -122.406985856935) | |||
| 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) |
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");