Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 149853 | 149853 | 53802 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1758 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1972 12:00:00 AM | 1 | Permit Number 9494 | 5983498.0607 | 2103182.1267 | 37.7539819174643 | -122.500021533616 | (37.7539819174643, -122.500021533616) | ||
| 4409 | 4409 | 114730 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.790686613557504 | -122.43491236523899 | (37.7906866135575, -122.434912365239) | |
| 1998 | 1998 | 135937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.45407860247299 | (37.7901125223289, -122.454078602473) | |
| 1012 | 1012 | 246499 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 311 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779776 | 6004393.833380001 | 2099835.13521 | 37.7459960419019 | -122.427520522551 | (37.7459960419019, -122.427520522551) | |
| 1259 | 1259 | 238460 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 10200 | 10200 | 122374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
| 9949 | 9949 | 63390 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 725 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2017 12:00:00 AM | 3 | Permit Number 779370 | 6007403.5343153 | 2095452.62499742 | 37.734132412410396 | -122.416802921773 | (37.7341324124104, -122.416802921773) | |
| 84406 | 84406 | 122604 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.3193700002 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | ||
| 104713 | 104713 | 121604 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211.0 | 2096230.0 | 37.735973474651296 | -122.43481069394899 | (37.7359734746513, -122.434810693949) | |
| 143623 | 143623 | 122603 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779127 | 6002205.30607 | 2096205.3193700002 | 37.7359053840536 | -122.434828615692 | (37.7359053840536, -122.434828615692) | ||||
| 116861 | 116861 | 39163 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 301x Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 5 | Permit Number 778831 | 6003629.0 | 2104450.0 | 37.758624085440104 | -122.43049443639099 | (37.7586240854401, -122.430494436391) | |
| 112696 | 112696 | 55637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 258 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2016 12:00:00 AM | 3 | 6x6 | Permit Number 778639 | 6002688.12514343 | 2104391.86827459 | 37.758411125870104 | -122.43374425038999 | (37.7584111258701, -122.43374425039) | |
| 96754 | 96754 | 64918 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2316 Cecelia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 778540 | 5991489.18329901 | 2099681.66120699 | 37.744836293038 | -122.472131462255 | (37.744836293038, -122.472131462255) | ||
| 86979 | 86979 | 16604 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 101 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2016 12:00:00 AM | 3 | 3X3 | Permit Number 778401 | 6002878.7558281 | 2107677.2386141997 | 37.7674427729111 | -122.433319725194 | (37.7674427729111, -122.433319725194) | |
| 95986 | 95986 | 112235 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 210 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778169 | 6004073.8 | 2107506.8 | 37.7670425133064 | -122.429174075483 | (37.7670425133064, -122.429174075483) | |
| 116364 | 116364 | 61460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 212 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2016 12:00:00 AM | 3 | Permit Number 778169 | 6004120.40486409 | 2107599.50179922 | 37.7672996882221 | -122.429019486595 | (37.7672996882221, -122.429019486595) | |
| 90918 | 90918 | 117588 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 261 Ripley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/27/2016 12:00:00 AM | 3 | Permit Number 778127 | 6009622.3 | 2099176.0 | 37.744480542407395 | -122.409394598776 | (37.7444805424074, -122.409394598776) | ||
| 13040 | 13040 | 86402 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1715 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/19/2006 12:00:00 AM | 3 | 3x3 | Permit Number 775346 | 5988092.6268 | 2103602.7043 | 37.7554052860025 | -122.484163468892 | (37.7554052860025, -122.484163468892) | |
| 140477 | 140477 | 70518 | Section 143 8 | Prunus serrulata :: Ornamental Cherry 35 | 27 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1994 12:00:00 AM | 3x3 | Permit Number 775094 | 6004529.42153392 | 2093371.60291271 | 37.728256311969396 | -122.426591501924 | (37.7282563119694, -122.426591501924) | ||
| 102102 | 102102 | 108939 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Public Library 14 | Private 3 | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.42901988134199 | (37.7968282226561, -122.429019881342) |
| 83949 | 83949 | 68828 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 331 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1993 12:00:00 AM | 7.5x10.5 | Permit Number 774473 | 5998736.29521219 | 2093886.16964896 | 37.7293399809502 | -122.44665550544701 | (37.7293399809502, -122.446655505447) | ||
| 10766 | 10766 | 109710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 274 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774419 | 6005156.44986 | 2094314.59165 | 37.730880978857 | -122.42449088466101 | (37.730880978857, -122.424490884661) |
| 78260 | 78260 | 108099 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2390X Green St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | ||
| 105175 | 105175 | 106857 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2800 PIERCE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001545.0 | 2118180.0 | 37.7962049292866 | -122.43868565610902 | (37.7962049292866, -122.438685656109) | ||
| 12916 | 12916 | 72155 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2014 12:00:00 AM | 3 | Permit Number 774096 | 6000883.4658699995 | 2093545.19578 | 37.7285261634496 | -122.43920812806499 | (37.7285261634496, -122.439208128065) | |
| 97909 | 97909 | 89641 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3339 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773999 | 5988231.7629 | 2111867.7398599996 | 37.7781069002134 | -122.48428842998399 | (37.7781069002134, -122.484288429984) | |
| 12065 | 12065 | 108545 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773707 | 6003013.00279 | 2094373.5586 | 37.7309216102277 | -122.431905334488 | (37.7309216102277, -122.431905334488) |
| 94456 | 94456 | 83199 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 59 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2014 12:00:00 AM | 3x3 | Permit Number 773472 | 6002034.69265259 | 2105509.66164268 | 37.7614432158421 | -122.436084093766 | (37.7614432158421, -122.436084093766) | ||
| 105920 | 105920 | 107752 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 400X Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x3 | Permit Number 772924 | 6004484.08045 | 2109981.44374 | 37.773860502373 | -122.427931334456 | (37.773860502373, -122.427931334456) | |||
| 10668 | 10668 | 108896 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) |
| 114503 | 114503 | 45133 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2014 12:00:00 AM | Permit Number 772552 | 6001042.61306002 | 2109303.63872684 | 37.771804125001395 | -122.439787297823 | (37.7718041250014, -122.439787297823) | |||
| 19124 | 19124 | 59121 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 572 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2013 12:00:00 AM | Permit Number 770918 | 5992864.66737091 | 2111571.53492594 | 37.7775622694604 | -122.46824012776001 | (37.7775622694604, -122.46824012776) | |||
| 150756 | 150756 | 104961 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2013 12:00:00 AM | 10 | Permit Number 770811 | 5996496.5 | 2113597.6 | 37.7833343975689 | -122.455822972198 | (37.7833343975689, -122.455822972198) | ||
| 145044 | 145044 | 104036 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 149 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 770678 | 6005538.0 | 2099025.0 | 37.743836244033496 | -122.423506557165 | (37.7438362440335, -122.423506557165) | ||
| 49418 | 49418 | 104126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | ||
| 163426 | 163426 | 104125 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 9x6 | Permit Number 770527 | 6001480.2051 | 2110460.0547 | 37.775004252315604 | -122.438356503743 | (37.7750042523156, -122.438356503743) | ||
| 87606 | 87606 | 103649 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005304.8 | 2110365.7 | 37.7749619731115 | -122.42511967591601 | (37.7749619731115, -122.425119675916) | |
| 89675 | 89675 | 103650 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |
| 117113 | 117113 | 103651 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 307X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |
| 111304 | 111304 | 43319 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 275 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2013 12:00:00 AM | 3x3 | Permit Number 770290 | 6003728.19858152 | 2092097.28955871 | 37.7247120025434 | -122.429270532313 | (37.7247120025434, -122.429270532313) | |
| 128771 | 128771 | 102810 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 490 33rd Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770137 | 5985656.77163 | 2112663.0068900003 | 37.780140206640205 | -122.493254729507 | (37.7801402066402, -122.493254729507) | |
| 127195 | 127195 | 38189 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 541 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/2013 12:00:00 AM | Permit Number 770070 | 6011097.98403945 | 2092306.25144746 | 37.7257002373273 | -122.403808654284 | (37.7257002373273, -122.403808654284) | ||
| 25373 | 25373 | 60884 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | |
| 2000 | 2000 | 237999 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4302 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 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) | |
| 68046 | 68046 | 71314 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 530 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/26/2012 12:00:00 AM | 2 | Permit Number 769252 | 6003477.6405 | 2090266.5364299999 | 37.7196709718096 | -122.43000614527399 | (37.7196709718096, -122.430006145274) | |
| 80073 | 80073 | 99924 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 125 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2012 12:00:00 AM | Permit Number 769009 | 5992063.9 | 2092889.6 | 37.7262202448731 | -122.469649855245 | (37.7262202448731, -122.469649855245) | |||
| 41743 | 41743 | 99624 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | |
| 135279 | 135279 | 41123 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2012 12:00:00 AM | 3 | Permit Number 768786 | 5998522.6402 | 2110343.8816 | 37.77451660437121 | -122.448578947735 | (37.7745166043712, -122.448578947735) | |
| 44756 | 44756 | 97495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988364.44571 | 2111930.92454 | 37.778288112362 | -122.483834071993 | (37.778288112362, -122.483834071993) | |
| 48718 | 48718 | 97494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.778288112363796 | -122.483770678777 | (37.7782881123638, -122.483770678777) | |
| 146395 | 146395 | 67954 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2011 12:00:00 AM | 1 | Permit Number 768251 | 5988399.92289 | 2111930.46202 | 37.778288907581 | -122.483711310905 | (37.778288907581, -122.483711310905) | |
| 36062 | 36062 | 96607 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1655 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768135 | 5988818.1686 | 2103045.0516 | 37.7539163374898 | -122.48161351303601 | (37.7539163374898, -122.481613513036) | |
| 88538 | 88538 | 96241 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2766 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2011 12:00:00 AM | 3x3 | Permit Number 767721 | 6009604.0 | 2103381.0 | 37.7560255142642 | -122.40975463196101 | (37.7560255142642, -122.409754631961) | ||
| 107708 | 107708 | 60689 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2766 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2011 12:00:00 AM | Permit Number 767721 | 6009601.84910347 | 2103390.02442851 | 37.7560501727818 | -122.40976270748199 | (37.7560501727818, -122.409762707482) | ||
| 70066 | 70066 | 96023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767664 | 6007549.8611 | 2113603.1249 | 37.783977731681496 | -122.417583010796 | (37.7839777316815, -122.417583010796) |
| 168740 | 168740 | 96022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 625 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767663 | 6007522.2203 | 2113467.103 | 37.7836026932034 | -122.417668993855 | (37.7836026932034, -122.417668993855) |
| 95593 | 95593 | 96005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3448 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2011 12:00:00 AM | 3x3 | Permit Number 767659 | 5984913.0 | 2111119.0 | 37.775857277323105 | -122.495713813843 | (37.7758572773231, -122.495713813843) | ||
| 179405 | 179405 | 95827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 144A Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767562 | 6010353.30698 | 2110532.02613 | 37.7757025646591 | -122.407667456007 | (37.7757025646591, -122.407667456007) |
| 58289 | 58289 | 95775 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 674 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767509 | 6002729.6643199995 | 2089587.30224 | 37.7177635556125 | -122.432543138167 | (37.7177635556125, -122.432543138167) |
| 27021 | 27021 | 95729 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 247 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767475 | 6004014.48263 | 2088996.54653 | 37.7162142458739 | -122.428060019581 | (37.7162142458739, -122.428060019581) |
| 37315 | 37315 | 68135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.44156790404699 | (37.7855794974585, -122.441567904047) | ||
| 156668 | 156668 | 70126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 518 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 4 | 3x3 | Permit Number 767414 | 6003049.75959 | 2090601.9090200001 | 37.720567588703105 | -122.43150910488701 | (37.7205675887031, -122.431509104887) |
| 167611 | 167611 | 95528 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767319 | 5989620.9197 | 2099732.2391 | 37.7448668732681 | -122.478595193308 | (37.7448668732681, -122.478595193308) |
| 135959 | 135959 | 95525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986606.408 | 2107060.1496 | 37.764811835149295 | -122.489557426261 | (37.7648118351493, -122.489557426261) |
| 186001 | 186001 | 95591 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2925 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767317 | 5986627.6602 | 2107061.3303 | 37.7648163177268 | -122.48948400821001 | (37.7648163177268, -122.48948400821) |
| 50354 | 50354 | 95524 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767316 | 5987892.7113 | 2105115.9895 | 37.75954871508429 | -122.484965845966 | (37.7595487150843, -122.484965845966) |
| 46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
| 74407 | 74407 | 95447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.745788542103206 | -122.49194041962099 | (37.7457885421032, -122.491940419621) |
| 151451 | 151451 | 95446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2205 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767308 | 5985726.3556 | 2100168.8125 | 37.7458386996409 | -122.49209381774901 | (37.7458386996409, -122.492093817749) |
| 136915 | 136915 | 95445 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2201 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) |
| 172408 | 172408 | 95443 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1634 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767305 | 5985639.2643 | 2104071.5459 | 37.7565494487406 | -122.49268234984 | (37.7565494487406, -122.49268234984) |
| 29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
| 79787 | 79787 | 96460 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 83825 | 83825 | 96459 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 90531 | 90531 | 96463 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 98303 | 98303 | 96462 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 110626 | 110626 | 96461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2001 Market St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/20/2011 12:00:00 AM | Permit Number 767173 | 6004662.9 | 2108069.9 | 37.7686219813575 | -122.42717658242701 | (37.7686219813575, -122.427176582427) | ||||
| 58689 | 58689 | 53262 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 2 | Permit Number 6152 | 5987525.5316 | 2103414.2811 | 37.7548548926849 | -122.486110800407 | (37.7548548926849, -122.486110800407) | ||
| 157212 | 157212 | 93809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 460 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2010 12:00:00 AM | 3 | Permit Number 57622 | 6003467.08848 | 2090756.16475 | 37.7210147855714 | -122.43007752986999 | (37.7210147855714, -122.43007752987) | ||
| 58060 | 58060 | 46783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 89 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 4 | 3x3 | Permit Number 54062 | 6002335.14709 | 2093516.37756 | 37.7285295350115 | -122.43418753503 | (37.7285295350115, -122.43418753503) |
| 174170 | 174170 | 95122 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 75 Lyell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54049 | 6003110.14823 | 2094598.2490700001 | 37.731544066089 | -122.43158552205401 | (37.731544066089, -122.431585522054) |
| 59501 | 59501 | 95117 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54044 | 6002203.8888 | 2093301.19707 | 37.7279312475122 | -122.43462592124399 | (37.7279312475122, -122.434625921244) |
| 42720 | 42720 | 94722 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 172 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53857 | 5998128.6274 | 2113392.2279 | 37.7828640340497 | -122.450161675731 | (37.7828640340497, -122.450161675731) |
| 9027 | 9027 | 21627 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1615 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 10/14/2010 12:00:00 AM | 6 | 4X4 | Permit Number 53778 | 6004639.3671 | 2114660.2794 | 37.7867162131248 | -122.42772760613701 | (37.7867162131248, -122.427727606137) |
| 139237 | 139237 | 94138 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 63 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2010 12:00:00 AM | 3x3 | Permit Number 53518 | 6003081.0 | 2108785.0 | 37.7704958861772 | -122.43269933113001 | (37.7704958861772, -122.43269933113) | ||
| 30680 | 30680 | 46074 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 126 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2010 12:00:00 AM | 4 | Permit Number 53303 | 5996573.1562 | 2113506.5298 | 37.783088742065296 | -122.455551189088 | (37.7830887420653, -122.455551189088) | ||
| 99516 | 99516 | 93223 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1509 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2010 12:00:00 AM | 3x3 | Permit Number 53214 | 5997839.0 | 2105577.0 | 37.761388850272 | -122.450600038983 | (37.761388850272, -122.450600038983) | ||
| 118553 | 118553 | 58453 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53199 | 5998815.14010882 | 2107825.71866386 | 37.767619090536705 | -122.44738585168501 | (37.7676190905367, -122.447385851685) | |
| 82029 | 82029 | 93176 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 89105 | 89105 | 93178 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 89962 | 89962 | 93177 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 93317 | 93317 | 93179 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 290 Maple St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/2010 12:00:00 AM | 3x3 | Permit Number 53191 | 5996651.0 | 2115280.0 | 37.7879626851967 | -122.455410098396 | (37.7879626851967, -122.455410098396) | ||
| 141762 | 141762 | 92879 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 370 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2009 12:00:00 AM | 3x3 | Permit Number 53093 | 5992717.2 | 2094212.3 | 37.729889789948295 | -122.467487595124 | (37.7298897899483, -122.467487595124) | ||
| 46496 | 46496 | 92773 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 135 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52993 | 5997556.9484 | 2112845.9305 | 37.7813313140415 | -122.452100007845 | (37.7813313140415, -122.452100007845) | |
| 50603 | 50603 | 43244 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 148 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52907 | 6010526.7074 | 2094001.3390799998 | 37.7303226617554 | -122.405902877341 | (37.7303226617554, -122.405902877341) | |
| 181207 | 181207 | 92543 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 137 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52887 | 6010552.68366 | 2094065.4210599998 | 37.7305000701252 | -122.40581758561001 | (37.7305000701252, -122.40581758561) | |
| 34554 | 34554 | 92542 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52886 | 6010542.11041 | 2094099.98718 | 37.730594390103505 | -122.40585657301901 | (37.7305943901035, -122.405856573019) | |
| 146393 | 146393 | 81679 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1942 Vicente St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52863 | 5986874.2463 | 2097598.6809 | 37.738848836056 | -122.487935819213 | (37.738848836056, -122.487935819213) |
| 60519 | 60519 | 92488 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2432 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52859 | 5988420.575 | 2098331.0194 | 37.740949727843706 | -122.482643050711 | (37.7409497278437, -122.482643050711) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");