trees
2,694 rows where qSpecies_id = 84 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12670 | 86450 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2362 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2006 12:00:00 AM | 3 | 3x3 | 5987982.1495 | 2099214.8079 | 37.7433508614418 | -122.4842237451 | (37.7433508614418, -122.4842237451) | 1 | 8 | 3 | 29491 | 35 | ||
| 12911 | 25471 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 237 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2005 12:00:00 AM | 3 | 3X3 | 5993297.6081 | 2088487.2193 | 37.7142036007288 | -122.465065423908 | (37.7142036007288, -122.465065423908) | 9 | 8 | 6 | 64 | 24 | ||
| 13210 | 244980 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 289 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005226.4402 | 2109722.7783 | 37.7731922392405 | -122.425344978098 | (37.7731922392405, -122.425344978098) | 7 | 9 | 11 | 28852 | 10 | |||
| 13229 | 21689 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1881 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003724.339 | 2114539.1952 | 37.7863319437467 | -122.43088473956 | (37.7863319437467, -122.43088473956) | 13 | 9 | 11 | 29490 | 13 | |||
| 13252 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511 | (37.7355642757438, -122.49142378511) | 1 | 8 | 3 | 29491 | 35 | ||
| 13724 | 85931 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1686 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988131.3934 | 2103830.0344 | 37.756031730146 | -122.484046073449 | (37.756031730146, -122.484046073449) | 1 | 8 | 3 | 56 | 35 | ||
| 14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
| 14237 | 240835 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1383 Vermont St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
| 14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
| 14311 | 71226 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2267 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987603.3648 | 2099853.8795 | 37.7450835205099 | -122.485580358953 | (37.7450835205099, -122.485580358953) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | ||||
| 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 | ||||||||||||||
| 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 | |||
| 16087 | 71214 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2131 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988191.5983 | 2100799.6289 | 37.7477145531771 | -122.483615701045 | (37.7477145531771, -122.483615701045) | 1 | 8 | 3 | 29491 | 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 | |||||
| 16541 | 73456 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6009946.95062 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | ||
| 17013 | 70667 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009828.97228 | 2111081.01172 | 37.7771805851524 | -122.409520022524 | (37.7771805851524, -122.409520022524) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||||||||||||||
| 17474 | 71170 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2127 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5987570.8389 | 2100801.7844 | 37.747684319575 | -122.485762384494 | (37.747684319575, -122.485762384494) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 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 | ||
| 18564 | 73527 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2119 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988189.2832 | 2100871.8604 | 37.747912746917 | -122.483629001347 | (37.747912746917, -122.483629001347) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 19155 | 80023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 632-632 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001104.7117 | 2110909.6213 | 37.7762172841329 | -122.439687650862 | (37.7762172841329, -122.439687650862) | 15 | 5 | 11 | 29492 | 10 | |||
| 19171 | 71227 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.485435173986 | (37.7450642803204, -122.485435173986) | 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 | |||
| 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 | ||
| 19543 | 70633 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 514 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6003062.45597 | 2090620.05211 | 37.720618125211 | -122.431466512079 | (37.720618125211, -122.431466512079) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 20224 | 98090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 26383 | 214390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 291 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992218.06134 | 2097396.8798 | 37.7386050175954 | -122.469444880296 | (37.7386050175954, -122.469444880296) | 1 | 8 | 4 | 59 | 40 |
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) );