trees
2,694 rows where qSpecies_id = 84 sorted by qCareAssistant
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14432 | 178904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10x Mansell St | 4 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6011792.88406 | 2090769.73397 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | 10 | 3 | 8 | 309 | 28 | |||
| 14515 | 214414 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 659 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5997734.91386 | 2094962.25156 | 37.7322373939404 | -122.450194889199 | (37.7322373939404, -122.450194889199) | 9 | 7 | 4 | 59 | 40 | ||||
| 14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 15189 | 89400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1908 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992787.397851 | 2112077.494993 | 37.77894703563 | -122.468544248635 | (37.77894703563, -122.468544248635) | 11 | 6 | 2 | 54 | 11 | ||
| 15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
| 15294 | 178876 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2005 12:00:00 AM | 1 | Width 2ft | Permit Number 48053 | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | 9 | 7 | 6 | 28861 | 5 | |
| 15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
| 15546 | 86251 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2230 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988566.0868 | 2100132.7531 | 37.7459052793749 | -122.482271903737 | (37.7459052793749, -122.482271903737) | 1 | 8 | 3 | 29491 | 35 | ||
| 15646 | 182066 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.484576606624 | (37.761541526107, -122.484576606624) | 1 | 8 | 3 | 56 | 35 | |||
| 15690 | 214433 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993395.62301 | 2105048.89443 | 37.7596834779287 | -122.465929324277 | (37.7596834779287, -122.465929324277) | 1 | 8 | 4 | 56 | 12 | |||
| 15899 | 184179 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1607 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981558.7987 | 2104123.9871 | 37.7564539963073 | -122.506797700314 | (37.7564539963073, -122.506797700314) | 1 | 8 | 3 | 56 | 35 | |||
| 16091 | 261396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010229.17248 | 2118537.87531 | 37.7976777662505 | -122.408661772909 | (37.7976777662505, -122.408661772909) | 3 | 1 | 10 | 308 | 4 | |||||
| 16606 | 118027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 51 Shore View Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5984327.56097 | 2112791.45591 | 37.7804150560022 | -122.497862491352 | (37.7804150560022, -122.497862491352) | 11 | 6 | 2 | 55 | 26 | |||
| 16758 | 86256 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1754 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988460.2167 | 2103365.3979 | 37.7547751017133 | -122.482874855725 | (37.7547751017133, -122.482874855725) | 1 | 8 | 3 | 56 | 35 | ||
| 16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 17072 | 259381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
| 17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 17467 | 50541 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
| 17485 | 64739 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 139 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51671 | 6002793.57505281 | 2109015.34015791 | 37.7711120386945 | -122.433710000051 | (37.7711120386945, -122.433710000051) | 15 | 5 | 11 | 29492 | 9 | ||
| 17563 | 85987 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2286 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987649.8793 | 2099748.6884 | 37.7447974037311 | -122.485411804387 | (37.7447974037311, -122.485411804387) | 1 | 8 | 3 | 29491 | 35 | ||
| 17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
| 17707 | 196376 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012181.96532 | 2112407.5214 | 37.7809544381487 | -122.40147347254 | (37.7809544381487, -122.40147347254) | 6 | 2 | 9 | 28856 | 34 | |||
| 18085 | 138485 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1700 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2003 12:00:00 AM | 2 | Width 0ft | Permit Number 47204 | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | 13 | 9 | 11 | 29490 | 13 | |
| 18166 | 88091 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1619 39th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2008 12:00:00 AM | 3x3 | Permit Number 51095 | 5984024.3 | 2104125.3 | 37.756602478656 | -122.498271356488 | (37.756602478656, -122.498271356488) | 1 | 8 | 3 | 56 | 35 | |||
| 18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 18391 | 214451 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | 1 | 8 | 4 | 29491 | 40 | |||
| 18417 | 4023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/2015 02:44:00 PM | 3 | 3X3 | 6013444.0079121 | 2101040.051797 | 37.7498122193832 | -122.396310443681 | (37.7498122193832, -122.396310443681) | 10 | 3 | 8 | 28856 | 1 | ||
| 18664 | 183374 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2725 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985535.6187 | 2096728.138 | 37.736380379394 | -122.492500010635 | (37.736380379394, -122.492500010635) | 1 | 8 | 3 | 29491 | 35 | |||
| 19264 | 259569 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
| 19300 | 214438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1237 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993585.37565 | 2107057.08841 | 37.7652083981778 | -122.465418951844 | (37.7652083981778, -122.465418951844) | 11 | 8 | 11 | 56 | 12 | |||
| 19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
| 19438 | 244904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 151 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999860.3433 | 2109070.0361 | 37.7710953445719 | -122.443860048791 | (37.7710953445719, -122.443860048791) | 15 | 5 | 11 | 29492 | 9 | |||
| 19528 | 244063 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1670 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | Width 0ft | 5998595.6913 | 2109011.0161 | 37.7708610734694 | -122.448230254318 | (37.7708610734694, -122.448230254318) | 15 | 5 | 11 | 29492 | 9 | ||
| 19566 | 178881 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | 9 | 7 | 6 | 28861 | 5 | |||
| 19743 | 237974 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.7527136870909 | -122.424132459851 | (37.7527136870909, -122.424132459851) | 2 | 4 | 5 | 28859 | 19 | |||
| 19918 | 182711 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1707 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988401.4839 | 2103680.4418 | 37.7556367099705 | -122.483101057669 | (37.7556367099705, -122.483101057669) | 1 | 8 | 3 | 56 | 35 | |||
| 20120 | 85951 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1390 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988061.1772 | 2105842.3097 | 37.7615528036389 | -122.484436487246 | (37.7615528036389, -122.484436487246) | 1 | 8 | 3 | 56 | 35 | ||
| 20137 | 86308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1503 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988358.1168 | 2105058.904 | 37.7594190709864 | -122.483352077356 | (37.7594190709864, -122.483352077356) | 1 | 8 | 3 | 56 | 35 | ||
| 20346 | 141250 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 42 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5996544.0519 | 2114280.1621 | 37.7852112604093 | -122.455707816901 | (37.7852112604093, -122.455707816901) | 11 | 6 | 1 | 54 | 31 | |||
| 20362 | 237988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 114 Park St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005544.33972 | 2096386.43433 | 37.7365916954539 | -122.42329710838 | (37.7365916954539, -122.42329710838) | 2 | 7 | 7 | 28859 | 2 | |||
| 20375 | 27754 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1299 Cesar Chavez St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X3 | 6015153.848397 | 2101092.2403929 | 37.7500505146893 | -122.390401336874 | (37.7500505146893, -122.390401336874) | 10 | 3 | 8 | 58 | 1 | ||
| 20580 | 86119 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2462 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988932.9456 | 2098582.1283 | 37.7416690029042 | -122.480889862999 | (37.7416690029042, -122.480889862999) | 1 | 8 | 3 | 29491 | 35 | ||
| 20696 | 84041 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1514 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52690 | 5986231.2266 | 2104899.676 | 37.7588578622757 | -122.490696090341 | (37.7588578622757, -122.490696090341) | 1 | 8 | 3 | 56 | 35 | |
| 20713 | 107753 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | ||||
| 20865 | 196378 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012410.67338 | 2112360.21924 | 37.7808373158188 | -122.400678929615 | (37.7808373158188, -122.400678929615) | 6 | 2 | 9 | 28856 | 34 | |||
| 21018 | 110553 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 2x LILY ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6006369 | 2110405 | 37.7751299410446 | -122.421441165405 | (37.7751299410446, -122.421441165405) | 7 | 9 | 11 | 28852 | 10 | ||||
| 21027 | 196418 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010052.79507 | 2110841.75773 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | 8 | 2 | 9 | 28853 | 34 | |||
| 21032 | 121651 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 306 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993098 | 2103247 | 37.7547187703987 | -122.466827655897 | (37.7547187703987, -122.466827655897) | 1 | 8 | 4 | 56 | 12 | ||||
| 21090 | 214399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 280 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5993979.94578 | 2098920.29255 | 37.7428895919817 | -122.463463697088 | (37.7428895919817, -122.463463697088) | 1 | 8 | 4 | 59 | 40 | |||
| 21111 | 86574 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2435 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987950.8455 | 2098721.8965 | 37.7419956341083 | -122.484295842204 | (37.7419956341083, -122.484295842204) | 1 | 8 | 3 | 29491 | 35 | ||
| 21241 | 26936 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1529 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6002004.7416 | 2111860.8692 | 37.7788803585551 | -122.436642312661 | (37.7788803585551, -122.436642312661) | 15 | 5 | 11 | 29490 | 41 | |||
| 21318 | 86004 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1774 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987534.4685 | 2103215.2309 | 37.7543088755282 | -122.486065283877 | (37.7543088755282, -122.486065283877) | 1 | 8 | 3 | 56 | 35 | ||
| 21529 | 86204 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2427 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988880.8286 | 2098804.4715 | 37.7422764696275 | -122.481086340605 | (37.7422764696275, -122.481086340605) | 1 | 8 | 3 | 29491 | 35 | ||
| 21898 | 214404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 66 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993883.93649 | 2101380.33833 | 37.7496387233569 | -122.463974202658 | (37.7496387233569, -122.463974202658) | 1 | 8 | 4 | 29491 | 40 | |||
| 22074 | 86106 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2576 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988959.241 | 2097817.061 | 37.7395698560466 | -122.480742946483 | (37.7395698560466, -122.480742946483) | 1 | 8 | 3 | 29491 | 35 | ||
| 22237 | 214456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | 9 | 7 | 4 | 63 | 40 | |||
| 22364 | 114870 | Planning Code 138.1 required 2 | Prunus serrulata :: Ornamental Cherry 84 | 2326 Cecelia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3 | 3x4 | 5991484.88147917 | 2099641.61135178 | 37.744726077495 | -122.472143418263 | (37.744726077495, -122.472143418263) | 1 | 8 | 4 | 29491 | 40 | ||
| 22463 | 196415 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.7765984252192 | -122.408805329496 | (37.7765984252192, -122.408805329496) | 8 | 2 | 9 | 28853 | 34 | |||
| 22687 | 245213 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001001.539 | 2109303.6237 | 37.7718017456892 | -122.439929374343 | (37.7718017456892, -122.439929374343) | 15 | 5 | 11 | 29492 | 9 | |||
| 22816 | 142584 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.8039724587948 | -122.413191303597 | (37.8039724587948, -122.413191303597) | 3 | 1 | 10 | 308 | 23 | |||
| 22876 | 86247 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2290 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2006 12:00:00 AM | 3 | 3x3 | 5988579.3157 | 2099752.9558 | 37.7448632256871 | -122.482198340398 | (37.7448632256871, -122.482198340398) | 1 | 8 | 3 | 29491 | 35 | ||
| 22896 | 86008 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1726 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987525.9378 | 2103513.8062 | 37.7551281853344 | -122.486116701181 | (37.7551281853344, -122.486116701181) | 1 | 8 | 3 | 56 | 35 | ||
| 22903 | 40229 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 South Park | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1999 12:00:00 AM | Permit Number 41410 | 6014331.14035058 | 2112607.2540326 | 37.7816225406641 | -122.394052345281 | (37.7816225406641, -122.394052345281) | 6 | 2 | 9 | 28856 | 6 | |||
| 22982 | 34096 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.6434081 | 2093328.34737639 | 37.7276180343437 | -122.458098329779 | (37.7276180343437, -122.458098329779) | 9 | 7 | 4 | 28861 | 40 | |||
| 22987 | 88225 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2084 Hayes St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51221 | 5997896.9 | 2109991 | 37.7735118836843 | -122.450718045928 | (37.7735118836843, -122.450718045928) | 15 | 5 | 11 | 29492 | 16 | |||
| 23223 | 63267 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2679 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1986 12:00:00 AM | 4 | Permit Number 23823 | 5988937.7362 | 2097128.8354 | 37.7376789174614 | -122.480766928043 | (37.7376789174614, -122.480766928043) | 1 | 8 | 3 | 29491 | 35 | ||
| 23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
| 23329 | 178962 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 217 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007226.63785 | 2092632.02114 | 37.7263776956646 | -122.417214704709 | (37.7263776956646, -122.417214704709) | 9 | 3 | 7 | 309 | 28 | |||
| 23534 | 86573 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2423 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987947.4613 | 2098798.3799 | 37.7422054403073 | -122.484313151634 | (37.7422054403073, -122.484313151634) | 1 | 8 | 3 | 29491 | 35 | ||
| 23610 | 135902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | 5 | 1 | 10 | 308 | 32 | ||||
| 23692 | 214476 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 270 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 5998285.21453 | 2093571.32939 | 37.7284497264529 | -122.448192264458 | (37.7284497264529, -122.448192264458) | 9 | 7 | 4 | 28861 | 40 | ||||
| 23813 | 181705 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | 1 | 8 | 3 | 56 | 35 | |||
| 23943 | 91342 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 829 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100 | 2112601 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | 6 | 2 | 9 | 28856 | 34 | ||
| 23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
| 23975 | 142257 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 541 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004803.1693 | 2110709.0411 | 37.7758763538472 | -122.426879382419 | (37.7758763538472, -122.426879382419) | 7 | 9 | 11 | 28852 | 10 | |||
| 24064 | 178910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | 9 | 8 | 6 | 28861 | 25 | ||||
| 24348 | 41338 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2000 12:00:00 AM | 9 | Permit Number 41991 | 5996265.0232 | 2113139.8498 | 37.7820642497954 | -122.456590671642 | (37.7820642497954, -122.456590671642) | 11 | 6 | 1 | 54 | 31 | ||
| 24423 | 86261 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1726 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988455.289 | 2103558.6714 | 37.7553054920736 | -122.482906060899 | (37.7553054920736, -122.482906060899) | 1 | 8 | 3 | 56 | 35 | ||
| 24499 | 86262 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1722 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2006 12:00:00 AM | 3 | 3x3 | 5988454.7415 | 2103581.1196 | 37.7553670969368 | -122.482909599425 | (37.7553670969368, -122.482909599425) | 1 | 8 | 3 | 56 | 35 | ||
| 24530 | 183612 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2043 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5990030.8699 | 2101452.3062 | 37.7496135205134 | -122.477303359393 | (37.7496135205134, -122.477303359393) | 1 | 8 | 3 | 29491 | 35 | |||
| 24568 | 89655 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3003 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989317.85585 | 2111907.93007 | 37.7782804306874 | -122.480534228481 | (37.7782804306874, -122.480534228481) | 11 | 6 | 2 | 55 | 26 | ||
| 24662 | 245027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1255 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000554.2196 | 2109238.2078 | 37.7715966562859 | -122.441471983052 | (37.7715966562859, -122.441471983052) | 15 | 5 | 11 | 29492 | 9 | |||
| 24845 | 237978 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5998568.18197 | 2106878.54944 | 37.7650042880525 | -122.448171835459 | (37.7650042880525, -122.448171835459) | 15 | 5 | 11 | 29492 | 9 | |||
| 24908 | 50538 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 199 Tiffany Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006096 | 2099195 | 37.7443345051857 | -122.421589192303 | (37.7443345051857, -122.421589192303) | 2 | 7 | 7 | 28859 | 2 | |||
| 25273 | 86253 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2206 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2006 12:00:00 AM | 3 | 3x3 | 5988562.6729 | 2100280.8313 | 37.7463116644044 | -122.482294555654 | (37.7463116644044, -122.482294555654) | 1 | 8 | 3 | 29491 | 35 | ||
| 25314 | 139145 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1500 GEARY BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004390.5718 | 2114066.8594 | 37.7850727536973 | -122.428546063814 | (37.7850727536973, -122.428546063814) | 13 | 9 | 11 | 29490 | 13 | |||
| 25443 | 140309 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 155 COLE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997789.9214 | 2109997.5703 | 37.7735237998425 | -122.451088572707 | (37.7735237998425, -122.451088572707) | 15 | 5 | 11 | 29492 | 16 | |||
| 25516 | 70314 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 209 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51137 | 5997808.9346 | 2109832.5111 | 37.7730716783726 | -122.451010898748 | (37.7730716783726, -122.451010898748) | 15 | 5 | 11 | 29492 | 16 | |
| 25564 | 178956 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1393 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007451.98675 | 2091842.90418 | 37.724223625092 | -122.416379812775 | (37.724223625092, -122.416379812775) | 9 | 3 | 7 | 309 | 28 | |||
| 25589 | 182690 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1725 24th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988713.9908 | 2103546.8998 | 37.7552882198487 | -122.482010540938 | (37.7552882198487, -122.482010540938) | 1 | 8 | 3 | 56 | 35 | |||
| 25617 | 135906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007265.47268 | 2119876.05587 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | 5 | 1 | 1 | 28858 | 32 | |||
| 25645 | 182379 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1539 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989606.4529 | 2104860.602 | 37.7589471598267 | -122.479020261674 | (37.7589471598267, -122.479020261674) | 1 | 8 | 3 | 56 | 35 | |||
| 25667 | 85944 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1530 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988094.8611 | 2104879.1908 | 37.7589103025977 | -122.484249353508 | (37.7589103025977, -122.484249353508) | 1 | 8 | 3 | 56 | 35 | ||
| 25804 | 196403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 140 Langton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6010340.69149 | 2110544.62696 | 37.7757364574022 | -122.407711985019 | (37.7757364574022, -122.407711985019) | 8 | 2 | 9 | 28853 | 34 | |||
| 25815 | 27759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1099X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/25/2005 12:00:00 AM | 4 | 3x3 | 6015711.8179102 | 2101113.2850563 | 37.750139234821 | -122.388473299437 | (37.750139234821, -122.388473299437) | 10 | 3 | 8 | 58 | 1 | ||
| 26082 | 50547 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 60 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47175 | 6006180 | 2099188 | 37.7443200209268 | -122.421298240567 | (37.7443200209268, -122.421298240567) | 2 | 7 | 7 | 28859 | 2 | |||
| 26182 | 26785 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.404311642231 | (37.7114882765061, -122.404311642231) | 9 | 7 | 8 | 309 | 39 | ||
| 26245 | 140310 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 155 COLE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997792.3931 | 2109979.17 | 37.7734734188761 | -122.451078695615 | (37.7734734188761, -122.451078695615) | 15 | 5 | 11 | 29492 | 16 | |||
| 26284 | 86002 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1824 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987543.255 | 2102835.2262 | 37.7532659973414 | -122.486007006329 | (37.7532659973414, -122.486007006329) | 1 | 8 | 3 | 56 | 35 | ||
| 26363 | 141139 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1915 Geary Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002239.2415 | 2113631.2046 | 37.7837545758984 | -122.43595779441 | (37.7837545758984, -122.43595779441) | 13 | 5 | 11 | 29490 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );