Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92 | 92 | 98091 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007129.633230001 | 2115568.12393 | 37.789349482642606 | -122.41917628075599 | (37.7893494826426, -122.419176280756) | ||
| 343 | 343 | 244298 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005605.7628 | 2110511.5277 | 37.7753793775331 | -122.42408895277501 | (37.7753793775331, -122.424088952775) | |||
| 605 | 605 | 23903 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6 | 6003560.4697 | 2114360.5617 | 37.7858321751093 | -122.431438928251 | (37.7858321751093, -122.431438928251) | |||
| 1472 | 1472 | 244877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1349 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000105.0 | 2109153.0 | 37.7713370947812 | -122.443019734512 | (37.7713370947812, -122.443019734512) | |||
| 2489 | 2489 | 119760 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2492 | 2492 | 119762 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2501 | 2501 | 119761 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2508 | 2508 | 119759 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | |||||||||
| 2550 | 2550 | 138186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1865 Buchanan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 0ft | 6003941.622 | 2114719.9923 | 37.786840675810396 | -122.43014589889499 | (37.7868406758104, -122.430145898895) | |||
| 2613 | 2613 | 98090 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | ||
| 3194 | 3194 | 253362 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3199 | 3199 | 253365 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1745 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3209 | 3209 | 253364 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3215 | 3215 | 253360 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3221 | 3221 | 253361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1737 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3234 | 3234 | 253359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1723 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3238 | 3238 | 253363 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1741 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004027.1917 | 2114282.142 | 37.7856432950328 | -122.429818605296 | (37.7856432950328, -122.429818605296) | ||||
| 3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
| 3528 | 3528 | 13088 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008925.6016 | 2120449.3844 | 37.802853199751794 | -122.413307745784 | (37.8028531997518, -122.413307745784) | |||
| 3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
| 4145 | 4145 | 113403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.42164817262501 | (37.7957372487994, -122.421648172625) | |||
| 4166 | 4166 | 143128 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | |||
| 4309 | 4309 | 1910 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 47 Beideman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001514.9606 | 2113070.1349 | 37.782172849750296 | -122.43842331734601 | (37.7821728497503, -122.438423317346) | |||
| 4516 | 4516 | 28647 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003547.8453 | 2114380.4001 | 37.785885930849204 | -122.431484021877 | (37.7858859308492, -122.431484021877) | |||
| 4753 | 4753 | 98088 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.41900880992901 | (37.7893685797349, -122.419008809929) | ||
| 5333 | 5333 | 26937 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002019.9705 | 2111862.8998 | 37.7788867994939 | -122.436589775324 | (37.7788867994939, -122.436589775324) | |||
| 5350 | 5350 | 28646 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 6 | 6003557.7645 | 2114374.9896 | 37.7858716371659 | -122.431449317827 | (37.7858716371659, -122.431449317827) | |||
| 5957 | 5957 | 28643 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 20 | 6003700.2631 | 2113325.6745 | 37.7829985565916 | -122.43088139933201 | (37.7829985565916, -122.430881399332) | |||
| 5979 | 5979 | 98098 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006897.32558 | 2115510.94052 | 37.789179385771604 | -122.41997598040399 | (37.7891793857716, -122.419975980404) | |||
| 5993 | 5993 | 23902 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1600X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003560.0188 | 2114334.411 | 37.7857603463241 | -122.431438620741 | (37.7857603463241, -122.431438620741) | |||
| 6273 | 6273 | 106722 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2905 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5999550.4676 | 2114295.9601 | 37.7854267102234 | -122.44530771900499 | (37.7854267102234, -122.445307719005) | |||
| 6354 | 6354 | 98096 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006843.26628 | 2115504.44745 | 37.789158511592 | -122.420162558272 | (37.789158511592, -122.420162558272) | |||
| 6475 | 6475 | 23884 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1750X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6003258.4682 | 2113929.8349 | 37.7846323872704 | -122.432452992684 | (37.7846323872704, -122.432452992684) | |||
| 6496 | 6496 | 23490 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2500X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005777.87956 | 2119177.1307599996 | 37.799182688783496 | -122.424109961515 | (37.7991826887835, -122.424109961515) | |||
| 6792 | 6792 | 23871 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1499X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003600.3539 | 2113692.9201 | 37.784001259600295 | -122.43125326646499 | (37.7840012596003, -122.431253266465) | |||
| 6947 | 6947 | 26936 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1529 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6002004.7416 | 2111860.8692 | 37.7788803585551 | -122.436642312661 | (37.7788803585551, -122.436642312661) | |||
| 7067 | 7067 | 28641 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 20 | 6003709.2011 | 2113267.9212 | 37.7828404869024 | -122.43084635463 | (37.7828404869024, -122.43084635463) | |||
| 7387 | 7387 | 98089 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.789362361841505 | -122.41906838009899 | (37.7893623618415, -122.419068380099) | ||
| 7425 | 7425 | 8168 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1160 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6002214.9627 | 2111253.4218 | 37.7772244047313 | -122.435871600468 | (37.7772244047313, -122.435871600468) | |||
| 7927 | 7927 | 13089 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | |||
| 8518 | 8518 | 18226 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1675 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004172.0667 | 2114245.454 | 37.785550761919 | -122.42931476245899 | (37.785550761919, -122.429314762459) | |||
| 8560 | 8560 | 98097 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006875.6654 | 2115508.14993 | 37.789170503156704 | -122.420050723983 | (37.7891705031567, -122.420050723983) | |||
| 8638 | 8638 | 98095 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 81 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6006820.270769999 | 2115499.9051599996 | 37.789144743881295 | -122.420241797518 | (37.7891447438813, -122.420241797518) | |||
| 8790 | 8790 | 105143 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 432 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | DPW for City Agency 2 | 3 | 4x4 | 6005556.0703 | 2110851.1612 | 37.776309122873705 | -122.42428501193301 | (37.7763091228737, -122.424285011933) | ||
| 9626 | 9626 | 173611 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6005304.0 | 2101328.0 | 37.7501465436699 | -122.424479453971 | (37.7501465436699, -122.424479453971) | |||
| 10144 | 10144 | 173880 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1922 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998581.0 | 2110425.0 | 37.7747426714218 | -122.448382913575 | (37.7747426714218, -122.448382913575) | ||||
| 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) | |||
| 10400 | 10400 | 94994 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 82 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010574.5301 | 2087274.9346 | 37.7118560160688 | -122.405264057289 | (37.7118560160688, -122.405264057289) | |||
| 10403 | 10403 | 95015 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010521.9467 | 2087254.8816 | 37.711798014587295 | -122.40544438972 | (37.7117980145873, -122.40544438972) | ||||
| 10438 | 10438 | 95023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.711484695229295 | -122.404646681546 | (37.7114846952293, -122.404646681546) | |||
| 10565 | 10565 | 94985 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010907.8555 | 2087101.5876 | 37.7113986701374 | -122.40409979381799 | (37.7113986701374, -122.404099793818) | |||
| 10735 | 10735 | 95001 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 166 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010153.2106 | 2087493.0431 | 37.712431333442 | -122.40673562308099 | (37.712431333442, -122.406735623081) | |||
| 10780 | 10780 | 26783 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.711333837408205 | -122.40394559103301 | (37.7113338374082, -122.403945591033) | |||
| 10788 | 10788 | 94995 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.711892427555796 | -122.40535898167299 | (37.7118924275558, -122.405358981673) | |||
| 11078 | 11078 | 94996 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | |||
| 11134 | 11134 | 95007 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 185 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010037.7782 | 2087495.7404 | 37.712432280377705 | -122.40713478458 | (37.7124322803777, -122.40713478458) | |||
| 11165 | 11165 | 95019 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485001 | (37.7116804891797, -122.40514245485) | |||
| 11181 | 11181 | 95011 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | |||
| 11288 | 11288 | 95020 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.711648722790706 | -122.40506305817699 | (37.7116487227907, -122.405063058177) | |||
| 11451 | 11451 | 94993 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.711794905553106 | -122.405106866024 | (37.7117949055531, -122.405106866024) | |||
| 11522 | 11522 | 94986 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | |||
| 11559 | 11559 | 27104 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 637 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2X3 | 6005511.99058 | 2093568.16222 | 37.7288515201802 | -122.423208682549 | (37.7288515201802, -122.423208682549) | |||
| 11612 | 11612 | 95017 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.40530753468501 | (37.7117488165229, -122.405307534685) | |||
| 11741 | 11741 | 94992 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | |||
| 11754 | 11754 | 95026 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | |||
| 11772 | 11772 | 95029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | |||
| 11844 | 11844 | 95027 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | |||
| 11845 | 11845 | 95018 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.40521408790899 | (37.7117099327517, -122.405214087909) | |||
| 11853 | 11853 | 94988 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.711588047755605 | -122.40457614013901 | (37.7115880477556, -122.404576140139) | |||
| 11856 | 11856 | 95002 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.712462163614795 | -122.406812851088 | (37.7124621636148, -122.406812851088) | |||
| 12055 | 12055 | 95028 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | |||
| 12204 | 12204 | 95003 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | |||
| 12239 | 12239 | 95010 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010304.2603 | 2087368.7381 | 37.7120984674199 | -122.406204794273 | (37.7120984674199, -122.406204794273) | |||
| 12283 | 12283 | 95024 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | |||
| 12450 | 12450 | 26799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | |||
| 12621 | 12621 | 95008 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.712393072261705 | -122.40698585693501 | (37.7123930722617, -122.406985856935) | |||
| 12738 | 12738 | 95005 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 201X Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009777.312000001 | 2087590.4351 | 37.71267771272821 | -122.40804171326799 | (37.7126777127282, -122.408041713268) | ||||
| 12802 | 12802 | 26786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | |||
| 12814 | 12814 | 95025 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.40450209567699 | (37.7114343969477, -122.404502095677) | |||
| 12883 | 12883 | 26798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.71215348320929 | -122.406360290051 | (37.7121534832093, -122.406360290051) | |||
| 12999 | 12999 | 94997 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010302.5304 | 2087413.7951 | 37.7122220880479 | -122.40621394582399 | (37.7122220880479, -122.406213945824) | |||
| 13116 | 13116 | 26784 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665236999 | (37.7113704740421, -122.40402665237) | |||
| 13302 | 13302 | 187656 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1548 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003789.0 | 2099328.0 | 37.744569337434 | -122.42957579341999 | (37.744569337434, -122.42957579342) | ||||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
| 19557 | 19557 | 119842 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 350 Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005602.0 | 2110303.0 | 37.774806598562 | -122.42408713638201 | (37.774806598562, -122.424087136382) | ||||
| 19795 | 19795 | 9378 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 320 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001091.814301901 | 2097867.0769738997 | 37.740404899832896 | -122.438797433034 | (37.7404048998329, -122.438797433034) | |||
| 23661 | 23661 | 142764 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.801741456909596 | -122.40695573845899 | (37.8017414569096, -122.406955738459) | |||
| 23801 | 23801 | 183452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2519 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989212.0936 | 2098169.1351 | 37.7405512532287 | -122.479894458871 | (37.7405512532287, -122.479894458871) | |||
| 23893 | 23893 | 238011 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 170 Upper Ter | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999678.6983900005 | 2106620.27376 | 37.7643585496334 | -122.444312287003 | (37.7643585496334, -122.444312287003) | |||
| 23946 | 23946 | 113286 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1626 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6002122.0899 | 2114184.377 | 37.7852667906839 | -122.43640269829099 | (37.7852667906839, -122.436402698291) | |||
| 24060 | 24060 | 182205 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988079.8655 | 2104054.0379 | 37.756643783163206 | -122.484240699303 | (37.7566437831632, -122.484240699303) | |||
| 24062 | 24062 | 237974 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6005423.51837 | 2102260.48733 | 37.752713687090896 | -122.424132459851 | (37.7527136870909, -122.424132459851) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 24195 | 24195 | 244515 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 426 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003699.3803 | 2109847.5959 | 37.7734485650794 | -122.430636186348 | (37.7734485650794, -122.430636186348) | |||
| 24204 | 24204 | 238028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 251 Alma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997698.52987 | 2106146.63858 | 37.7629448927014 | -122.45112694477699 | (37.7629448927014, -122.451126944777) | |||
| 24350 | 24350 | 214468 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 623 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5997445.526980001 | 2095470.2100900002 | 37.7336155617911 | -122.451231980178 | (37.7336155617911, -122.451231980178) | |||
| 24369 | 24369 | 237998 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 338 Hoffman Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000611.91644 | 2101788.98208 | 37.7511462020375 | -122.440737977395 | (37.7511462020375, -122.440737977395) | |||
| 24617 | 24617 | 181947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | |||
| 24630 | 24630 | 184291 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1543 41st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5983404.3155 | 2104639.3384 | 37.7579775103532 | -122.50045345703501 | (37.7579775103532, -122.500453457035) |
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");