trees
2,694 rows where qSpecies_id = 84 sorted by PermitNotes descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180880 | 53802 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | 1 | 8 | 3 | 56 | 35 | ||
| 4437 | 244983 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 299 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005200.9141 | 2109719.1317 | 37.7731807843789 | -122.425433016756 | (37.7731807843789, -122.425433016756) | 7 | 9 | 11 | 28852 | 10 | |
| 118423 | 114730 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.7906866135575 | -122.434912365239 | (37.7906866135575, -122.434912365239) | 13 | 9 | 1 | 29490 | 27 | |
| 85559 | 214612 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1333 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | Permit Number 780527 | 5993302.74893 | 2106373.33223 | 37.7633146795475 | -122.466346784179 | (37.7633146795475, -122.466346784179) | 1 | 8 | 11 | 56 | 12 | ||
| 184830 | 135937 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.454078602473 | (37.7901125223289, -122.454078602473) | 11 | 6 | 1 | 54 | 31 | |
| 32514 | 246499 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.83338 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | 2 | 7 | 5 | 63 | 22 | |
| 149849 | 238460 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779768 | 6002902.99046 | 2108581.89909 | 37.7699281239255 | -122.433300551682 | (37.7699281239255, -122.433300551682) | 15 | 5 | 5 | 29492 | 9 | |
| 93121 | 122374 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 126941 | 34361 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.426846444043 | (37.7411467825752, -122.426846444043) | 2 | 7 | 5 | 63 | 7 | |
| 12075 | 63390 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.7341324124104 | -122.416802921773 | (37.7341324124104, -122.416802921773) | 2 | 7 | 7 | 28859 | 2 | |
| 39770 | 122604 | - 12 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.31937 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | 2 | 7 | 5 | 63 | 7 | |
| 115656 | 121604 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211 | 2096230 | 37.7359734746513 | -122.434810693949 | (37.7359734746513, -122.434810693949) | 2 | 7 | 5 | 63 | 7 | |
| 175182 | 122603 | - 12 | Prunus serrulata :: Ornamental Cherry 84 | 132 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.31937 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | 2 | 7 | 5 | 63 | 7 | |||
| 166945 | 39163 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 301x Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 5 | Permit Number 778831 | 6003629 | 2104450 | 37.7586240854401 | -122.430494436391 | (37.7586240854401, -122.430494436391) | 2 | 4 | 5 | 28862 | 3 | |
| 140107 | 55637 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 258 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778639 | 6002688.12514343 | 2104391.86827459 | 37.7584111258701 | -122.43374425039 | (37.7584111258701, -122.43374425039) | 2 | 4 | 5 | 28862 | 3 | |
| 95021 | 64918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2316 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/24/1989 12:00:00 AM | Permit Number 778540 | 5991489.18329901 | 2099681.66120699 | 37.744836293038 | -122.472131462255 | (37.744836293038, -122.472131462255) | 1 | 8 | 4 | 29491 | 40 | ||
| 72693 | 16604 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 101 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002878.7558281 | 2107677.2386142 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | 15 | 5 | 5 | 28862 | 3 | |
| 136979 | 61460 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 212 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2016 12:00:00 AM | 3 | Permit Number 778169 | 6004120.40486409 | 2107599.50179922 | 37.7672996882221 | -122.429019486595 | (37.7672996882221, -122.429019486595) | 8 | 4 | 5 | 28862 | 3 | |
| 138486 | 112235 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 210 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778169 | 6004073.8 | 2107506.8 | 37.7670425133064 | -122.429174075483 | (37.7670425133064, -122.429174075483) | 8 | 4 | 5 | 28862 | 3 | |
| 59436 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 261 Ripley St | 1 | Front Yard : Yard | Tree | Private 2 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176 | 37.7444805424074 | -122.409394598776 | (37.7444805424074, -122.409394598776) | 2 | 7 | 7 | 28859 | 2 | ||
| 179537 | 86402 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | 1 | 8 | 3 | 56 | 35 | |
| 183384 | 70518 | Section 143 10 | Prunus serrulata :: Ornamental Cherry 84 | 27 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 3x3 | Permit Number 775094 | 6004529.42153392 | 2093371.60291271 | 37.7282563119694 | -122.426591501924 | (37.7282563119694, -122.426591501924) | 9 | 7 | 6 | 28861 | 5 | ||
| 101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
| 42679 | 68828 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 331 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 7.5x10.5 | Permit Number 774473 | 5998736.29521219 | 2093886.16964896 | 37.7293399809502 | -122.446655505447 | (37.7293399809502, -122.446655505447) | 9 | 7 | 4 | 28861 | 40 | ||
| 82547 | 109710 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 274 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774419 | 6005156.44986 | 2094314.59165 | 37.730880978857 | -122.424490884661 | (37.730880978857, -122.424490884661) | 9 | 7 | 6 | 28861 | 5 |
| 54636 | 108099 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2390X Green St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | ||
| 119264 | 106857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2800 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001545 | 2118180 | 37.7962049292866 | -122.438685656109 | (37.7962049292866, -122.438685656109) | 13 | 9 | 1 | 57 | 17 | ||
| 116480 | 72155 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.46587 | 2093545.19578 | 37.7285261634496 | -122.439208128065 | (37.7285261634496, -122.439208128065) | 9 | 7 | 6 | 28861 | 25 | |
| 105609 | 89641 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3339 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773999 | 5988231.7629 | 2111867.73986 | 37.7781069002134 | -122.484288429984 | (37.7781069002134, -122.484288429984) | 11 | 6 | 2 | 55 | 26 | |
| 114875 | 108545 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) | 9 | 7 | 5 | 28861 | 25 |
| 80499 | 83199 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 59 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2014 12:00:00 AM | 3x3 | Permit Number 773472 | 6002034.69265259 | 2105509.66164268 | 37.7614432158421 | -122.436084093766 | (37.7614432158421, -122.436084093766) | 15 | 4 | 5 | 28862 | 3 | ||
| 29717 | 107752 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x3 | Permit Number 772924 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | 7 | 9 | 11 | 28852 | 10 | |||
| 190721 | 108896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) | 9 | 7 | 6 | 28861 | 5 |
| 134315 | 45133 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/2014 12:00:00 AM | Permit Number 772552 | 6001042.61306002 | 2109303.63872684 | 37.7718041250014 | -122.439787297823 | (37.7718041250014, -122.439787297823) | 15 | 5 | 11 | 29492 | 9 | |||
| 3995 | 59121 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776 | (37.7775622694604, -122.46824012776) | 11 | 6 | 2 | 54 | 11 | |||
| 60519 | 104961 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 125 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2013 12:00:00 AM | 10 | Permit Number 770811 | 5996496.5 | 2113597.6 | 37.7833343975689 | -122.455822972198 | (37.7833343975689, -122.455822972198) | 11 | 6 | 1 | 54 | 31 | ||
| 192258 | 104036 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 149 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 770678 | 6005538 | 2099025 | 37.7438362440335 | -122.423506557165 | (37.7438362440335, -122.423506557165) | 2 | 7 | 5 | 28859 | 22 | ||
| 74205 | 104126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | 15 | 5 | 11 | 29492 | 10 | ||
| 147994 | 104125 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1330 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 9x6 | Permit Number 770527 | 6001480.2051 | 2110460.0547 | 37.7750042523156 | -122.438356503743 | (37.7750042523156, -122.438356503743) | 15 | 5 | 11 | 29492 | 10 | ||
| 44178 | 103651 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |
| 119743 | 103650 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |
| 161498 | 103649 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 307X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005304.8 | 2110365.7 | 37.7749619731115 | -122.425119675916 | (37.7749619731115, -122.425119675916) | 7 | 9 | 11 | 28852 | 10 | |
| 141236 | 43319 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 275 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2013 12:00:00 AM | 3x3 | Permit Number 770290 | 6003728.19858152 | 2092097.28955871 | 37.7247120025434 | -122.429270532313 | (37.7247120025434, -122.429270532313) | 9 | 7 | 6 | 28861 | 5 | |
| 186593 | 102810 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.00689 | 37.7801402066402 | -122.493254729507 | (37.7801402066402, -122.493254729507) | 11 | 6 | 2 | 55 | 26 | |
| 37006 | 38189 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | 10 | 3 | 7 | 309 | 28 | ||
| 192813 | 60884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | 3 | 1 | 10 | 308 | 32 | |
| 89128 | 237999 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2012 12:00:00 AM | 2 | Width 4ft | Permit Number 769743 | 6001218.46057 | 2101752.36044 | 37.7510801711245 | -122.438637864349 | (37.7510801711245, -122.438637864349) | 2 | 4 | 5 | 28862 | 22 | |
| 118310 | 71314 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.53643 | 37.7196709718096 | -122.430006145274 | (37.7196709718096, -122.430006145274) | 9 | 7 | 6 | 28861 | 5 | |
| 50016 | 99924 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | 9 | 8 | 4 | 59 | 40 | |||
| 42413 | 99624 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | 15 | 5 | 11 | 29492 | 16 | |
| 107445 | 41123 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1941 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/23/2012 12:00:00 AM | 3 | Permit Number 768786 | 5998522.6402 | 2110343.8816 | 37.7745166043712 | -122.448578947735 | (37.7745166043712, -122.448578947735) | 15 | 5 | 11 | 29492 | 16 | |
| 89663 | 97494 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.7782881123638 | -122.483770678777 | (37.7782881123638, -122.483770678777) | 11 | 6 | 2 | 55 | 26 | |
| 94404 | 67954 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3300@ Anza Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2011 12:00:00 AM | 1 | Permit Number 768251 | 5988399.92289 | 2111930.46202 | 37.778288907581 | -122.483711310905 | (37.778288907581, -122.483711310905) | 11 | 6 | 2 | 55 | 26 | |
| 176975 | 97495 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 3300@ Anza Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988364.44571 | 2111930.92454 | 37.778288112362 | -122.483834071993 | (37.778288112362, -122.483834071993) | 11 | 6 | 2 | 55 | 26 | |
| 42187 | 96607 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1655 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768135 | 5988818.1686 | 2103045.0516 | 37.7539163374898 | -122.481613513036 | (37.7539163374898, -122.481613513036) | 1 | 8 | 3 | 56 | 35 | |
| 61069 | 96241 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2766 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2011 12:00:00 AM | 3x3 | Permit Number 767721 | 6009604 | 2103381 | 37.7560255142642 | -122.409754631961 | (37.7560255142642, -122.409754631961) | 2 | 4 | 7 | 28859 | 19 | ||
| 114746 | 60689 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2766 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/19/2011 12:00:00 AM | Permit Number 767721 | 6009601.84910347 | 2103390.02442851 | 37.7560501727818 | -122.409762707482 | (37.7560501727818, -122.409762707482) | 2 | 4 | 7 | 28859 | 19 | ||
| 136191 | 96023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767664 | 6007549.8611 | 2113603.1249 | 37.7839777316815 | -122.417583010796 | (37.7839777316815, -122.417583010796) | 7 | 9 | 9 | 28858 | 36 |
| 100393 | 96022 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 625 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767663 | 6007522.2203 | 2113467.103 | 37.7836026932034 | -122.417668993855 | (37.7836026932034, -122.417668993855) | 7 | 9 | 9 | 28858 | 36 |
| 77841 | 96005 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3448 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2011 12:00:00 AM | 3x3 | Permit Number 767659 | 5984913 | 2111119 | 37.7758572773231 | -122.495713813843 | (37.7758572773231, -122.495713813843) | 11 | 6 | 2 | 55 | 26 | ||
| 134551 | 95827 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) | 8 | 2 | 9 | 28853 | 34 |
| 172306 | 95775 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.66432 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) | 9 | 7 | 6 | 28861 | 5 |
| 139887 | 95729 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) | 9 | 7 | 6 | 28861 | 5 |
| 26690 | 68135 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.441567904047 | (37.7855794974585, -122.441567904047) | 15 | 6 | 1 | 29490 | 27 | ||
| 19600 | 70126 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.90902 | 37.7205675887031 | -122.431509104887 | (37.7205675887031, -122.431509104887) | 9 | 7 | 6 | 28861 | 5 | |
| 36812 | 95528 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) | 1 | 8 | 3 | 29491 | 35 |
| 23538 | 95525 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2925 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986606.408 | 2107060.1496 | 37.7648118351493 | -122.489557426261 | (37.7648118351493, -122.489557426261) | 1 | 8 | 3 | 56 | 35 |
| 53073 | 95591 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821 | (37.7648163177268, -122.48948400821) | 1 | 8 | 3 | 56 | 35 |
| 36137 | 95524 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2232 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767316 | 5987892.7113 | 2105115.9895 | 37.7595487150843 | -122.484965845966 | (37.7595487150843, -122.484965845966) | 1 | 8 | 3 | 56 | 35 |
| 18112 | 95447 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3 | 4x6 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.7457885421032 | -122.491940419621 | (37.7457885421032, -122.491940419621) | 1 | 8 | 3 | 29491 | 35 |
| 157203 | 95592 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) | 1 | 8 | 3 | 29491 | 35 |
| 162349 | 95443 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1634 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767305 | 5985639.2643 | 2104071.5459 | 37.7565494487406 | -122.49268234984 | (37.7565494487406, -122.49268234984) | 1 | 8 | 3 | 56 | 35 |
| 184297 | 95438 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.7464785511245 | -122.488746318336 | (37.7464785511245, -122.488746318336) | 1 | 8 | 3 | 29491 | 35 |
| 39053 | 96460 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
| 40777 | 96459 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
| 74566 | 96463 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
| 97873 | 96462 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
| 133113 | 96461 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2001 Market St | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.427176582427 | (37.7686219813575, -122.427176582427) | 8 | 4 | 5 | 28862 | 3 | ||||
| 127517 | 53262 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | 1 | 8 | 3 | 56 | 35 | ||
| 191732 | 93809 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 460 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2010 12:00:00 AM | 3 | Permit Number 57622 | 6003467.08848 | 2090756.16475 | 37.7210147855714 | -122.43007752987 | (37.7210147855714, -122.43007752987) | 9 | 7 | 6 | 28861 | 5 | ||
| 136710 | 46783 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) | 9 | 7 | 6 | 28861 | 25 |
| 142187 | 95122 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 75 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54049 | 6003110.14823 | 2094598.24907 | 37.731544066089 | -122.431585522054 | (37.731544066089, -122.431585522054) | 9 | 7 | 5 | 28861 | 25 |
| 102298 | 95117 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 83 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54044 | 6002203.8888 | 2093301.19707 | 37.7279312475122 | -122.434625921244 | (37.7279312475122, -122.434625921244) | 9 | 7 | 6 | 28861 | 25 |
| 136417 | 94722 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 172 Collins St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53857 | 5998128.6274 | 2113392.2279 | 37.7828640340497 | -122.450161675731 | (37.7828640340497, -122.450161675731) | 15 | 6 | 1 | 54 | 31 |
| 189938 | 21627 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1615 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/14/2010 12:00:00 AM | 6 | 4X4 | Permit Number 53778 | 6004639.3671 | 2114660.2794 | 37.7867162131248 | -122.427727606137 | (37.7867162131248, -122.427727606137) | 13 | 9 | 11 | 28858 | 13 |
| 177925 | 94138 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 63 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2010 12:00:00 AM | 3x3 | Permit Number 53518 | 6003081 | 2108785 | 37.7704958861772 | -122.43269933113 | (37.7704958861772, -122.43269933113) | 15 | 5 | 5 | 29492 | 9 | ||
| 138983 | 46074 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 126 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2010 12:00:00 AM | 4 | Permit Number 53303 | 5996573.1562 | 2113506.5298 | 37.7830887420653 | -122.455551189088 | (37.7830887420653, -122.455551189088) | 11 | 6 | 1 | 54 | 31 | ||
| 100015 | 93223 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1509 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2010 12:00:00 AM | 3x3 | Permit Number 53214 | 5997839 | 2105577 | 37.761388850272 | -122.450600038983 | (37.761388850272, -122.450600038983) | 15 | 5 | 11 | 29492 | 12 | ||
| 170632 | 58453 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 73 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53199 | 5998815.14010882 | 2107825.71866386 | 37.7676190905367 | -122.447385851685 | (37.7676190905367, -122.447385851685) | 15 | 5 | 11 | 29492 | 9 | |
| 40316 | 93176 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
| 58157 | 93178 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
| 69522 | 93177 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
| 80447 | 93179 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651 | 2115280 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | 11 | 6 | 1 | 54 | 31 | ||
| 171508 | 92879 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 370 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2009 12:00:00 AM | 3x3 | Permit Number 53093 | 5992717.2 | 2094212.3 | 37.7298897899483 | -122.467487595124 | (37.7298897899483, -122.467487595124) | 9 | 8 | 4 | 59 | 40 | ||
| 185743 | 92773 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 135 Cook St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52993 | 5997556.9484 | 2112845.9305 | 37.7813313140415 | -122.452100007845 | (37.7813313140415, -122.452100007845) | 15 | 6 | 2 | 54 | 16 | |
| 78144 | 43244 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 148 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52907 | 6010526.7074 | 2094001.33908 | 37.7303226617554 | -122.405902877341 | (37.7303226617554, -122.405902877341) | 10 | 3 | 7 | 309 | 28 | |
| 56978 | 92543 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 137 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52887 | 6010552.68366 | 2094065.42106 | 37.7305000701252 | -122.40581758561 | (37.7305000701252, -122.40581758561) | 10 | 3 | 7 | 309 | 28 | |
| 63349 | 92542 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 129 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52886 | 6010542.11041 | 2094099.98718 | 37.7305943901035 | -122.405856573019 | (37.7305943901035, -122.405856573019) | 10 | 3 | 7 | 309 | 28 | |
| 72162 | 81679 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) | 1 | 8 | 3 | 29491 | 35 |
| 42350 | 92488 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2432 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52859 | 5988420.575 | 2098331.0194 | 37.7409497278437 | -122.482643050711 | (37.7409497278437, -122.482643050711) | 1 | 8 | 3 | 29491 | 35 |
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) );