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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25716 | 25716 | 135893 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6001843.597519999 | 2121830.48703 | 37.806245186226505 | -122.437914052191 | (37.8062451862265, -122.437914052191) | ||||
| 74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
| 159197 | 159197 | 44057 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | ||
| 154849 | 154849 | 135905 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6006460.32075 | 2121020.9303099997 | 37.804283800830795 | -122.42187952052099 | (37.8042838008308, -122.421879520521) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 179436 | 179436 | 135891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2398 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.802460509893606 | -122.44659245147301 | (37.8024605098936, -122.446592451473) | |||
| 52914 | 52914 | 143052 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 700 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008958.7736 | 2120458.7538 | 37.8028807881226 | -122.413193616152 | (37.8028807881226, -122.413193616152) | |||
| 171407 | 171407 | 143053 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 700 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008940.2059 | 2120454.0688 | 37.8028668818708 | -122.413257538683 | (37.8028668818708, -122.413257538683) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 123299 | 123299 | 143089 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 616 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009932.6738 | 2120241.3728 | 37.8023385404989 | -122.409808052185 | (37.8023385404989, -122.409808052185) | |||
| 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) | |||
| 80847 | 80847 | 51045 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47518 | 6009984.0 | 2120227.0 | 37.802301952574894 | -122.4096294226 | (37.8023019525749, -122.4096294226) | |
| 147146 | 147146 | 142758 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010864.8123 | 2120023.3634 | 37.80179213390711 | -122.406567008949 | (37.8017921339071, -122.406567008949) | |||
| 184779 | 184779 | 142759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010846.8046 | 2120020.1312 | 37.801782251607 | -122.406629096352 | (37.801782251607, -122.406629096352) | |||
| 149261 | 149261 | 142760 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | |||
| 170230 | 170230 | 142761 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010807.5572 | 2120014.5904 | 37.8017648420531 | -122.406764520508 | (37.8017648420531, -122.406764520508) | |||
| 185222 | 185222 | 142763 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | |||
| 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) | |||
| 176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
| 84774 | 84774 | 31652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2066 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1995 12:00:00 AM | Permit Number 35162 | 6001931.34452098 | 2119821.7914856 | 37.8007348293225 | -122.437466455186 | (37.8007348293225, -122.437466455186) | |||
| 41612 | 41612 | 143115 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1635 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6004533.1119 | 2119761.6458 | 37.8007172577851 | -122.42845896974801 | (37.8007172577851, -122.428458969748) | |||
| 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) | |||
| 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) | |
| 114531 | 114531 | 45712 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2276 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2001 12:00:00 AM | Permit Number 44382 | 6000967.59952761 | 2119687.6743116 | 37.8003117407877 | -122.440791778151 | (37.8003117407877, -122.440791778151) | |||
| 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) | |||
| 53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
| 183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
| 74598 | 74598 | 135903 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | ||||
| 118168 | 118168 | 135902 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | ||||
| 105465 | 105465 | 33331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1771 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | Permit Number 37471 | 6004431.94596599 | 2119422.40230613 | 37.7997800572789 | -122.428784847863 | (37.7997800572789, -122.428784847863) | ||
| 37561 | 37561 | 135901 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008342.534990001 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | ||||
| 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) | |||
| 145500 | 145500 | 52532 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | |
| 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) | |||
| 76848 | 76848 | 135910 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6011521.095380001 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | ||||
| 35260 | 35260 | 135914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | |||
| 131299 | 131299 | 135912 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.40432297534402 | (37.7991816185927, -122.404322975344) | ||||
| 47397 | 47397 | 135909 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.40419478595501 | (37.79918113116, -122.404194785955) | ||||
| 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) | ||||
| 146957 | 146957 | 135913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011476.8778099995 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | ||||
| 176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
| 182711 | 182711 | 91520 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | |
| 124420 | 124420 | 52535 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3148GREENWICH Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2006 12:00:00 AM | Permit Number 48634 | 6001945.28510554 | 2118977.8518821 | 37.79841838533729 | -122.437357750068 | (37.7984183853373, -122.437357750068) | |||
| 54410 | 54410 | 34473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | ||
| 70764 | 70764 | 143340 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1796 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004433.9519 | 2118779.1956 | 37.798014090515 | -122.42873202906 | (37.798014090515, -122.42873202906) | |||
| 92816 | 92816 | 48417 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2483 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | ||
| 98196 | 98196 | 48416 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2483 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | ||
| 75849 | 75849 | 135904 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1488 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006436.02999 | 2118364.9643599996 | 37.7969898223834 | -122.421774812465 | (37.7969898223834, -122.421774812465) | |||
| 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) |
| 123029 | 123029 | 116779 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650.0 | 2118281.0 | 37.796883878440795 | -122.41410797545099 | (37.7968838784408, -122.414107975451) | ||
| 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) | ||
| 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) | ||
| 105603 | 105603 | 44525 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1125 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2001 12:00:00 AM | Permit Number 43825 | 6008743.61210523 | 2117943.22188109 | 37.7959616805463 | -122.41376014990601 | (37.7959616805463, -122.413760149906) | ||
| 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) | |||
| 103110 | 103110 | 48786 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 113658 | 113658 | 48787 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1405 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | |||
| 176061 | 176061 | 52828 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48852 | 6011319.3348 | 2117592.1734 | 37.79514209381671 | -122.404822878731 | (37.7951420938167, -122.404822878731) | ||
| 57208 | 57208 | 52827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 750WASHINGTON Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 48852 | 6011323.0636 | 2117546.9613 | 37.7950181606921 | -122.40480679182501 | (37.7950181606921, -122.404806791825) | |
| 52553 | 52553 | 249684 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999742.6330699995 | 2117264.679 | 37.793589001891796 | -122.44485636243 | (37.7935890018918, -122.44485636243) | ||||
| 54903 | 54903 | 249683 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.44485371304701 | (37.7935581209611, -122.444853713047) | ||||
| 188711 | 188711 | 249682 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2400 Baker St | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999744.1267099995 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | ||||
| 47858 | 47858 | 142823 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | |||
| 49057 | 49057 | 142822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | |||
| 104672 | 104672 | 64402 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||
| 127063 | 127063 | 101446 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 143083 | 143083 | 101447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.792705858273294 | -122.407682697096 | (37.7927058582733, -122.407682697096) | ||||
| 118507 | 118507 | 73592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
| 128608 | 128608 | 73572 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
| 142619 | 142619 | 82029 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586.0 | 2116213.0 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | |
| 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) | |
| 99011 | 99011 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 3524 Jackson St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.790205252620794 | -122.452921449726 | (37.7902052526208, -122.452921449726) | ||||
| 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) | |
| 141940 | 141940 | 66596 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1166 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 2 | Permit Number 29789 | 6008318.17747093 | 2115921.39203862 | 37.79038633277379 | -122.415089057915 | (37.7903863327738, -122.415089057915) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 147223 | 147223 | 135894 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007011.71695 | 2115552.58868 | 37.7893001854156 | -122.419583155654 | (37.7893001854156, -122.419583155654) | |||
| 188263 | 188263 | 135895 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6007001.276269999 | 2115550.37651 | 37.7892935232365 | -122.419619122234 | (37.7892935232365, -122.419619122234) | |||
| 172215 | 172215 | 135896 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6006986.1238400005 | 2115548.09953 | 37.7892864176805 | -122.419671386337 | (37.7892864176805, -122.419671386337) | |||
| 169565 | 169565 | 135897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 4 Frank Norris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6006972.61492 | 2115546.75932 | 37.7892819768225 | -122.419718030565 | (37.7892819768225, -122.419718030565) | |||
| 56608 | 56608 | 135898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006854.3438099995 | 2115529.77615 | 37.7892286821026 | -122.420126029605 | (37.7892286821026, -122.420126029605) | |||
| 68414 | 68414 | 135899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006839.2179 | 2115528.7927900003 | 37.7892251297772 | -122.420178293706 | (37.7892251297772, -122.420178293706) | |||
| 52829 | 52829 | 135900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006826.338330001 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 164894 | 164894 | 137853 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1955 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003344.2833 | 2115489.023 | 37.788918389075704 | -122.432267493573 | (37.7889183890757, -122.432267493573) | |||
| 18883 | 18883 | 65715 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 735 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | Permit Number 28647 | 6009189.05467178 | 2115445.35577198 | 37.789128153830106 | -122.41204221421499 | (37.7891281538301, -122.412042214215) | ||
| 174807 | 174807 | 44212 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2009 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/2002 12:00:00 AM | 2 | Permit Number 43659 | 6003842.4279 | 2115438.8041 | 37.788808732867395 | -122.43054039659799 | (37.7888087328674, -122.430540396598) | |
| 114316 | 114316 | 49798 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 314AY REVISED Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2006 12:00:00 AM | Permit Number 46590 | 5997636.49453559 | 2115383.50122102 | 37.7883033693994 | -122.452007952375 | (37.7883033693994, -122.452007952375) | |||
| 143324 | 143324 | 49799 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 314AY REVISED Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2006 12:00:00 AM | Permit Number 46590 | 5997636.49453559 | 2115383.50122102 | 37.7883033693994 | -122.452007952375 | (37.7883033693994, -122.452007952375) | |||
| 44762 | 44762 | 48666 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.42714004151699 | (37.7886573555281, -122.427140041517) | |
| 154550 | 154550 | 137933 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 29 ORBEN PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003140.6181 | 2115311.4461 | 37.7884192581755 | -122.432959455149 | (37.7884192581755, -122.432959455149) |
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");