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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 14606 | 14606 | 15049 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1999 12:00:00 AM | 25 | 8X15 | 6015485.0268 | 2096001.9904 | 37.7360921037992 | -122.388900760186 | (37.7360921037992, -122.388900760186) | ||
| 101182 | 101182 | 13415 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 430 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 5 | 5999619.6561933 | 2097087.2734828999 | 37.7381798806191 | -122.443831547884 | (37.7381798806191, -122.443831547884) | |||
| 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) | |||
| 143081 | 143081 | 13118 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1633 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6004565.4050748 | 2119750.0667864 | 37.800687292153896 | -122.428346396238 | (37.8006872921539, -122.428346396238) | |||
| 75002 | 75002 | 237978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 25 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5998568.181969999 | 2106878.54944 | 37.7650042880525 | -122.44817183545901 | (37.7650042880525, -122.448171835459) | |||
| 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) | |||
| 103494 | 103494 | 2455 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 18 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.786521075947796 | -122.430070036959 | (37.7865210759478, -122.430070036959) | ||
| 28974 | 28974 | 214439 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1569 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5996912.71569 | 2105759.04962 | 37.7618356500092 | -122.453816799006 | (37.7618356500092, -122.453816799006) | |||
| 129720 | 129720 | 214459 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001485.72244 | 2094910.79641 | 37.7323100420719 | -122.437223836928 | (37.7323100420719, -122.437223836928) | |||
| 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) | |||
| 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) | |||
| 63938 | 63938 | 64516 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 709 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 15 | Permit Number 25397 | 6000497.1651 | 2111433.2992 | 37.7776205716937 | -122.441826907997 | (37.7776205716937, -122.441826907997) | |
| 88614 | 88614 | 50860 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 199x SAN JOSE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 15 | 9x9 | Permit Number 47375 | 6006239.0 | 2102027.0 | 37.7521185942464 | -122.42129579482 | (37.7521185942464, -122.42129579482) | |
| 109796 | 109796 | 55120 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 112 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/1972 12:00:00 AM | 15 | Permit Number 11022 | 5997123.97183158 | 2105914.83996284 | 37.76227552033671 | -122.453097398278 | (37.7622755203367, -122.453097398278) | ||
| 136311 | 136311 | 142582 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2236 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6008972.9977 | 2120827.456 | 37.8038939507527 | -122.413170480356 | (37.8038939507527, -122.413170480356) | |||
| 166910 | 166910 | 214456 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001455.73616 | 2094912.80793 | 37.7323138605989 | -122.437327650168 | (37.7323138605989, -122.437327650168) | |||
| 74159 | 74159 | 135907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | |||
| 87028 | 87028 | 63812 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 368 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2015 12:00:00 AM | 14 | 2x3 | Permit Number 24499 | 6008776.39218233 | 2097093.59684155 | 37.7387152882662 | -122.412172440474 | (37.7387152882662, -122.412172440474) | |
| 38789 | 38789 | 214431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1417 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5994558.263669999 | 2105844.83617 | 37.7619359298261 | -122.461966075892 | (37.7619359298261, -122.461966075892) | |||
| 41728 | 41728 | 247994 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 270 Peralta Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6009740.549319999 | 2099529.50478 | 37.7454578138309 | -122.409010652834 | (37.7454578138309, -122.409010652834) | |||
| 49365 | 49365 | 142583 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2234 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008971.4462 | 2120841.4199 | 37.80393220502779 | -122.41317683745301 | (37.8039322050278, -122.413176837453) | |||
| 51623 | 51623 | 245057 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 38 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000389.8085 | 2109086.3569 | 37.7711703439937 | -122.44202978741501 | (37.7711703439937, -122.442029787415) | |||
| 63909 | 63909 | 238012 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 170 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5999727.58165 | 2106665.35693 | 37.7644851256196 | -122.444146453789 | (37.7644851256196, -122.444146453789) | |||
| 68326 | 68326 | 245221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 341 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005088.7556 | 2110037.9678 | 37.7740498933785 | -122.425843687227 | (37.7740498933785, -122.425843687227) | |||
| 74008 | 74008 | 70886 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2145 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 13 | 5997606.572000001 | 2109869.8792 | 37.77316269418171 | -122.45171358914699 | (37.7731626941817, -122.451713589147) | ||
| 129892 | 129892 | 214436 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1572 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993094.94001 | 2104790.93371 | 37.7589578347535 | -122.466950474797 | (37.7589578347535, -122.466950474797) | |||
| 155848 | 155848 | 178895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 240 Concord St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.44207374220801 | (37.7105103506437, -122.442073742208) | |||
| 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) | |||
| 6874 | 6874 | 13090 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | ||
| 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) | |||
| 18986 | 18986 | 10211 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1311 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1991 12:00:00 AM | 12 | 2X2 | 6005852.922730001 | 2101311.29856 | 37.7501316687427 | -122.422580057332 | (37.7501316687427, -122.422580057332) | ||
| 73827 | 73827 | 142480 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1656 POWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6009655.9931 | 2119387.8477 | 37.799979462358706 | -122.410705194848 | (37.7999794623587, -122.410705194848) | |||
| 76233 | 76233 | 108192 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 603 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007188.43841 | 2091737.3666 | 37.7239190175192 | -122.417283387741 | (37.7239190175192, -122.417283387741) | |||
| 89705 | 89705 | 109182 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998040.0 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | |||
| 99821 | 99821 | 34369 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 71 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 12 | 12x4. 5 | Permit Number 38124 | 6003708.03789498 | 2097975.15575924 | 37.740850154442896 | -122.42975927113899 | (37.7408501544429, -122.429759271139) |
| 114472 | 114472 | 65384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 49 Wilder St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1989 12:00:00 AM | 12 | Permit Number 28223 | 6002684.49028093 | 2095505.99557199 | 37.734012395369 | -122.433121936639 | (37.734012395369, -122.433121936639) | |
| 121025 | 121025 | 111845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1550 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6010144.81466304 | 2100398.61683821 | 37.7478668430794 | -122.407674029985 | (37.7478668430794, -122.407674029985) | ||
| 137794 | 137794 | 142584 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.803972458794796 | -122.41319130359699 | (37.8039724587948, -122.413191303597) | |||
| 141416 | 141416 | 11200 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 186 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995344.6608195 | 2099448.7962231003 | 37.74441926622529 | -122.45878317784799 | (37.7444192662253, -122.458783177848) | |||
| 150022 | 150022 | 238032 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3851 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002743.63234 | 2103545.30285 | 37.7560898095039 | -122.43349178442499 | (37.7560898095039, -122.433491784425) | |||
| 151841 | 151841 | 237989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005562.12851 | 2096385.4572 | 37.7365900164084 | -122.423235535394 | (37.7365900164084, -122.423235535394) | |||
| 182223 | 182223 | 214385 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993134.95065 | 2102190.16883 | 37.7518191170825 | -122.46662305770501 | (37.7518191170825, -122.466623057705) | |||
| 182343 | 182343 | 178937 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 250 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6004445.3973900005 | 2091822.37508 | 37.723997724407795 | -122.426771694853 | (37.7239977244078, -122.426771694853) | ||||
| 25980 | 25980 | 143091 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 620 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009899.7854 | 2120236.6745 | 37.802323796980296 | -122.409921530777 | (37.8023237969803, -122.409921530777) | |||
| 56421 | 56421 | 118423 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981811.815769999 | 2111640.57092 | 37.7771072596016 | -122.50648010623001 | (37.7771072596016, -122.50648010623) | |||
| 136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
| 147970 | 147970 | 73456 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 52 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 11 | 6009946.950619999 | 2110955.66255 | 37.776843015637 | -122.409103049163 | (37.776843015637, -122.409103049163) | ||
| 149931 | 149931 | 214390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 291 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992218.0613400005 | 2097396.8798 | 37.738605017595404 | -122.469444880296 | (37.7386050175954, -122.469444880296) | |||
| 157140 | 157140 | 214435 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 320 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993233.77766 | 2104623.70866 | 37.758506690737 | -122.46645815892201 | (37.758506690737, -122.466458158922) | |||
| 158371 | 158371 | 178951 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007220.074 | 2091773.1745900002 | 37.7240191183805 | -122.417176564472 | (37.7240191183805, -122.417176564472) | |||
| 160610 | 160610 | 67707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 31 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 11 | Permit Number 31318 | 6014113.9587900005 | 2113076.60421 | 37.7828991959845 | -122.39483657655 | (37.7828991959845, -122.39483657655) | |
| 175403 | 175403 | 178952 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1485 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007251.31205 | 2091779.98256 | 37.7240395689419 | -122.41706906129 | (37.7240395689419, -122.41706906129) | |||
| 177635 | 177635 | 118425 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5981790.15899 | 2111638.01027 | 37.7770989536906 | -122.506554832582 | (37.7770989536906, -122.506554832582) | |||
| 187343 | 187343 | 214392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 185 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5994371.91106 | 2098648.34768 | 37.7421654749467 | -122.46208868315 | (37.7421654749467, -122.46208868315) | |||
| 5618 | 5618 | 87403 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1300 Webster St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 10 | 3x3 | 6003687.1999 | 2113392.3659 | 37.7831809343135 | -122.430931353807 | (37.7831809343135, -122.430931353807) | ||
| 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) | |||
| 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) | |||
| 26502 | 26502 | 196418 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010052.79507 | 2110841.7577299997 | 37.7765361885308 | -122.408728861943 | (37.7765361885308, -122.408728861943) | |||
| 38829 | 38829 | 248392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 707 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997906.1336 | 2108119.2199 | 37.7683729841331 | -122.450551136272 | (37.7683729841331, -122.450551136272) | |||
| 45325 | 45325 | 142241 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 500 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004960.5581 | 2110752.4077 | 37.776004325764205 | -122.42633802213601 | (37.7760043257642, -122.426338022136) | |||
| 46066 | 46066 | 67709 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 87 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 10 | Permit Number 31320 | 6013781.91426 | 2112762.09602 | 37.7820171606904 | -122.395963274202 | (37.7820171606904, -122.395963274202) | ||
| 65666 | 65666 | 135911 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6011511.78534 | 2119057.5389799997 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | ||||
| 73742 | 73742 | 178960 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1323 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007600.028630001 | 2091890.26579 | 37.7243619938904 | -122.415871404438 | (37.7243619938904, -122.415871404438) | |||
| 77858 | 77858 | 40258 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3502 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 10 | Permit Number 41417 | 6006132.27744777 | 2102027.63127436 | 37.7521143101544 | -122.421664902947 | (37.7521143101544, -122.421664902947) | |
| 95101 | 95101 | 97822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 595X Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4x4 | 6002402.0 | 2104748.0 | 37.7593727378271 | -122.434759263601 | (37.7593727378271, -122.434759263601) | |||
| 103278 | 103278 | 42100 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 231 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 10 | 3x6 | Permit Number 42406 | 5998731.52646444 | 2093591.79431997 | 37.7285314229156 | -122.44665081973 | (37.7285314229156, -122.44665081973) | |
| 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) | |
| 135454 | 135454 | 178949 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1555 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006996.74886 | 2091707.17834 | 37.723825340541204 | -122.417943890293 | (37.7238253405412, -122.417943890293) | |||
| 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) | ||
| 151643 | 151643 | 31579 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1766 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 10 | Permit Number 35118 | 5989083.5648 | 2103328.988 | 37.7547113797178 | -122.480716506349 | (37.7547113797178, -122.480716506349) | |
| 156152 | 156152 | 237991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 158 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004819.13057 | 2095927.0509 | 37.7352893763874 | -122.425771780961 | (37.7352893763874, -122.425771780961) | |||
| 162852 | 162852 | 140802 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 JORDAN AVE | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5996233.7192 | 2113991.8267 | 37.7844017542187 | -122.45676060516199 | (37.7844017542187, -122.456760605162) | |||
| 177998 | 177998 | 63548 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 942 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 10 | Permit Number 24164 | 5999530.709 | 2111776.0946 | 37.7785066833069 | -122.445194846179 | (37.7785066833069, -122.445194846179) | |
| 179096 | 179096 | 31300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | |
| 183435 | 183435 | 245195 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 48 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000874.4772 | 2109202.1258 | 37.7715158240845 | -122.440361608185 | (37.7715158240845, -122.440361608185) | |||
| 185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
| 189051 | 189051 | 118424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5421 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5981802.00316 | 2111639.4369 | 37.7771035681701 | -122.50651396642 | (37.7771035681701, -122.50651396642) | |||
| 33576 | 33576 | 196395 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 260 Clara St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011460.59942 | 2111454.8789 | 37.7782984271806 | -122.40390199009501 | (37.7782984271806, -122.403901990095) | |||
| 46789 | 46789 | 244991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 213 Lily St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005531.8427 | 2110116.9147 | 37.7742916920696 | -122.424316587333 | (37.7742916920696, -122.424316587333) | |||
| 50185 | 50185 | 238001 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 591 27th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6002762.01889 | 2100032.1411900003 | 37.746444541887705 | -122.43317718719601 | (37.7464445418877, -122.433177187196) | ||||
| 60283 | 60283 | 244907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999911.6566 | 2109010.7372 | 37.7709354515424 | -122.443678294205 | (37.7709354515424, -122.443678294205) | |||
| 64163 | 64163 | 196408 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 22 Rausch St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009625.06025 | 2110948.02453 | 37.776804005729204 | -122.41021603036002 | (37.7768040057292, -122.41021603036) | |||
| 64779 | 64779 | 183767 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2287 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5987606.1386 | 2099727.1382 | 37.744735684193 | -122.48556146831001 | (37.744735684193, -122.48556146831) | |||
| 66227 | 66227 | 196412 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 18 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6009772.78472 | 2111137.69481 | 37.7773330751096 | -122.409718395893 | (37.7773330751096, -122.409718395893) | |||
| 70625 | 70625 | 178891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 579 Madrid St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002452.87445 | 2090566.89512 | 37.720437599790394 | -122.43356984466999 | (37.7204375997904, -122.43356984467) | |||
| 123837 | 123837 | 42457 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 571 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 9 | 3x3 | Permit Number 42600 | 5997658.92569742 | 2095237.95802388 | 37.732990069317296 | -122.45047746491899 | (37.7329900693173, -122.450477464919) |
| 133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
| 138095 | 138095 | 66214 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2233 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1990 12:00:00 AM | 9 | Permit Number 29304 | 5989765.2961 | 2100174.6084 | 37.7460898851299 | -122.47812830871 | (37.7460898851299, -122.47812830871) | ||
| 140323 | 140323 | 114422 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 30X OGDEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x9 | 6009444.0 | 2095952.0 | 37.735618147291795 | -122.40978359873999 | (37.7356181472918, -122.40978359874) | |||
| 153810 | 153810 | 102572 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 778 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x9 | 5997324.2834 | 2112596.006 | 37.7806317567919 | -122.452886865809 | (37.7806317567919, -122.452886865809) | |||
| 156261 | 156261 | 237977 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 155 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997765.756440001 | 2104874.4673200003 | 37.759455679665706 | -122.45080270049401 | (37.7594556796657, -122.450802700494) | |||
| 157232 | 157232 | 238013 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 77 Ashbury Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999618.479619999 | 2106729.8577400004 | 37.764656004003 | -122.44452844265899 | (37.764656004003, -122.444528442659) | |||
| 159092 | 159092 | 196393 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013990.372330001 | 2112956.91555 | 37.7825636859099 | -122.395255750564 | (37.7825636859099, -122.395255750564) | |||
| 159636 | 159636 | 40022 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1535 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 9 | Permit Number 41267 | 6015717.1223 | 2095636.9971 | 37.7351027679039 | -122.388072841786 | (37.7351027679039, -122.388072841786) | |
| 170362 | 170362 | 118429 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5981844.98436 | 2111695.06236 | 37.7772588298958 | -122.50636940951 | (37.7772588298958, -122.50636940951) | |||
| 171106 | 171106 | 196409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.41031662852801 | (37.7771240168943, -122.410316628528) |
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");