trees
2,694 rows where qSpecies_id = 84 sorted by Location descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129376 | 135893 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6001843.59752 | 2121830.48703 | 37.8062451862265 | -122.437914052191 | (37.8062451862265, -122.437914052191) | 13 | 9 | 1 | 57 | 17 | ||||
| 69267 | 135892 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6001823.0897 | 2121828.59544 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | 13 | 9 | 1 | 57 | 17 | |||
| 78657 | 44057 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | 5 | 1 | 1 | 28858 | 32 | ||
| 73938 | 135905 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2843 Larkin St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006460.32075 | 2121020.93031 | 37.8042838008308 | -122.421879520521 | (37.8042838008308, -122.421879520521) | 5 | 9 | 1 | 28858 | 32 | |||
| 22816 | 142584 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2232 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6008967.5673 | 2120856.1596 | 37.8039724587948 | -122.413191303597 | (37.8039724587948, -122.413191303597) | 3 | 1 | 10 | 308 | 23 | |||
| 47793 | 142583 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2234 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6008971.4462 | 2120841.4199 | 37.8039322050278 | -122.413176837453 | (37.8039322050278, -122.413176837453) | 3 | 1 | 10 | 308 | 23 | |||
| 47408 | 142582 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2236 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6008972.9977 | 2120827.456 | 37.8038939507527 | -122.413170480356 | (37.8038939507527, -122.413170480356) | 3 | 1 | 10 | 308 | 23 | |||
| 111122 | 143052 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008958.7736 | 2120458.7538 | 37.8028807881226 | -122.413193616152 | (37.8028807881226, -122.413193616152) | 3 | 1 | 10 | 308 | 23 | |||
| 42153 | 143053 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6008940.2059 | 2120454.0688 | 37.8028668818708 | -122.413257538683 | (37.8028668818708, -122.413257538683) | 3 | 1 | 10 | 308 | 23 | |||
| 193098 | 13090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 724 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2004 12:00:00 AM | 12 | 3X3 | 6008885.9219 | 2120447.4555 | 37.8028456756355 | -122.413444921903 | (37.8028456756355, -122.413444921903) | 3 | 1 | 10 | 308 | 23 | ||
| 122246 | 135891 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2398 North Point St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 5999308.28669 | 2120504.72693 | 37.8024605098936 | -122.446592451473 | (37.8024605098936, -122.446592451473) | 13 | 9 | 1 | 57 | 17 | |||
| 105171 | 143089 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 616 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009932.6738 | 2120241.3728 | 37.8023385404989 | -122.409808052185 | (37.8023385404989, -122.409808052185) | 3 | 1 | 10 | 308 | 23 | |||
| 131346 | 143091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 620 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6009899.7854 | 2120236.6745 | 37.8023237969803 | -122.409921530777 | (37.8023237969803, -122.409921530777) | 3 | 1 | 10 | 308 | 23 | |||
| 51219 | 51045 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 8 | 3x3 | Permit Number 47518 | 6009984 | 2120227 | 37.8023019525749 | -122.4096294226 | (37.8023019525749, -122.4096294226) | 3 | 1 | 10 | 308 | 23 | |
| 139388 | 142758 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6010864.8123 | 2120023.3634 | 37.8017921339071 | -122.406567008949 | (37.8017921339071, -122.406567008949) | 3 | 1 | 10 | 308 | 23 | |||
| 85441 | 142759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010846.8046 | 2120020.1312 | 37.801782251607 | -122.406629096352 | (37.801782251607, -122.406629096352) | 3 | 1 | 10 | 308 | 23 | |||
| 36608 | 142760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6010826.0266 | 2120017.8226 | 37.8017747502564 | -122.406700835434 | (37.8017747502564, -122.406700835434) | 3 | 1 | 10 | 308 | 23 | |||
| 76787 | 142761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010807.5572 | 2120014.5904 | 37.8017648420531 | -122.406764520508 | (37.8017648420531, -122.406764520508) | 3 | 1 | 10 | 308 | 23 | |||
| 177460 | 142763 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010767.3863 | 2120009.5113 | 37.8017486483835 | -122.406903172911 | (37.8017486483835, -122.406903172911) | 3 | 1 | 10 | 308 | 23 | |||
| 67178 | 142764 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 FILBERT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010752.149 | 2120007.2027 | 37.8017414569096 | -122.406955738459 | (37.8017414569096, -122.406955738459) | 3 | 1 | 10 | 308 | 23 | |||
| 25617 | 135906 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6007265.47268 | 2119876.05587 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | 5 | 1 | 1 | 28858 | 32 | |||
| 192813 | 60884 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 811 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2013 12:00:00 AM | 4 | Permit Number 769979 | 6009011.35018 | 2119721.10568 | 37.8008583416072 | -122.412959487805 | (37.8008583416072, -122.412959487805) | 3 | 1 | 10 | 308 | 32 | |
| 65795 | 31652 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2066 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1995 12:00:00 AM | Permit Number 35162 | 6001931.34452098 | 2119821.7914856 | 37.8007348293225 | -122.437466455186 | (37.8007348293225, -122.437466455186) | 13 | 9 | 1 | 57 | 17 | |||
| 41827 | 143115 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1635 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6004533.1119 | 2119761.6458 | 37.8007172577851 | -122.428458969748 | (37.8007172577851, -122.428458969748) | 13 | 9 | 1 | 57 | 17 | |||
| 182032 | 13118 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1633 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004565.4050748 | 2119750.0667864 | 37.8006872921539 | -122.428346396238 | (37.8006872921539, -122.428346396238) | 13 | 9 | 1 | 57 | 17 | |||
| 41559 | 135907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | 5 | 1 | 1 | 308 | 32 | |||
| 115492 | 256141 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1560 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/16/1972 12:00:00 AM | Permit Number 11222 | 6005424.25713 | 2119606.92915 | 37.8003428333403 | -122.425364219431 | (37.8003428333403, -122.425364219431) | 13 | 9 | 1 | 57 | 17 | ||
| 145606 | 45712 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2276 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2001 12:00:00 AM | Permit Number 44382 | 6000967.59952761 | 2119687.6743116 | 37.8003117407877 | -122.440791778151 | (37.8003117407877, -122.440791778151) | 13 | 9 | 1 | 57 | 17 | |||
| 4516 | 259272 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1705 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/25/2019 12:00:00 AM | 3 | 6009597.7323 | 2119503.87292 | 37.8002947722719 | -122.410914999374 | (37.8002947722719, -122.410914999374) | 3 | 1 | 10 | 308 | 4 | |||
| 88001 | 250309 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 12 Redfield Aly | 1 | Side Yard : Yard | Tree | Private 2 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | 5 | 1 | 10 | 308 | 32 | |||
| 78261 | 250308 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 10 Redfield Aly | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.414769923808 | (37.8002391853351, -122.414769923808) | 5 | 1 | 10 | 308 | 32 | |||
| 138401 | 135903 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | 5 | 1 | 10 | 308 | 32 | ||||
| 23610 | 135902 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6008341.98532 | 2119430.34352 | 37.8000223848775 | -122.415255184482 | (37.8000223848775, -122.415255184482) | 5 | 1 | 10 | 308 | 32 | ||||
| 158039 | 135901 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 8 Marion Pl | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6008342.53499 | 2119419.33537 | 37.7999921901354 | -122.415252502723 | (37.7999921901354, -122.415252502723) | 5 | 1 | 10 | 308 | 32 | ||||
| 116508 | 142480 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1656 POWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009655.9931 | 2119387.8477 | 37.7999794623587 | -122.410705194848 | (37.7999794623587, -122.410705194848) | 3 | 1 | 10 | 308 | 4 | |||
| 123823 | 33331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1771 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2005 12:00:00 AM | Permit Number 37471 | 6004431.94596599 | 2119422.40230613 | 37.7997800572789 | -122.428784847863 | (37.7997800572789, -122.428784847863) | 13 | 9 | 1 | 57 | 17 | ||
| 190450 | 52532 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1636@ UNION Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 5x5 | Permit Number 48631 | 6009676.39438666 | 2119273.10665206 | 37.7996655555567 | -122.410626491106 | (37.7996655555567, -122.410626491106) | 3 | 1 | 10 | 308 | 4 | |
| 80951 | 135910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011521.09538 | 2119068.1217 | 37.799205966851 | -122.404228682307 | (37.799205966851, -122.404228682307) | 3 | 1 | 10 | 308 | 23 | ||||
| 172388 | 135914 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 414 Vallejo St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6011471.49553 | 2119063.8107 | 37.7991913582649 | -122.404400012157 | (37.7991913582649, -122.404400012157) | 3 | 1 | 10 | 308 | 23 | |||
| 112566 | 23490 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2500X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6005777.87956 | 2119177.13076 | 37.7991826887835 | -122.424109961515 | (37.7991826887835, -122.424109961515) | 13 | 9 | 1 | 28858 | 32 | |||
| 94594 | 135912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011493.6768 | 2119059.8121 | 37.7991816185927 | -122.404322975344 | (37.7991816185927, -122.404322975344) | 3 | 1 | 10 | 308 | 23 | ||||
| 53299 | 135909 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6011530.70294 | 2119058.88107 | 37.79918113116 | -122.404194785955 | (37.79918113116, -122.404194785955) | 3 | 1 | 10 | 308 | 23 | ||||
| 94021 | 135911 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 400 Vallejo St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6011511.78534 | 2119057.53898 | 37.7991763890443 | -122.404260153176 | (37.7991763890443, -122.404260153176) | 3 | 1 | 10 | 308 | 23 | ||||
| 99785 | 135913 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011476.87781 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | 3 | 1 | 10 | 308 | 23 | ||||
| 87841 | 135908 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | 3 | 1 | 10 | 308 | 23 | |||
| 79248 | 91520 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 520 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52125 | 6011001.0511 | 2118999.3767 | 37.7989881374692 | -122.406023377789 | (37.7989881374692, -122.406023377789) | 3 | 1 | 10 | 308 | 23 | |
| 111704 | 34473 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1725 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38203 | 6008692.20922 | 2118946.49843 | 37.7987135430497 | -122.414009024508 | (37.7987135430497, -122.414009024508) | 5 | 1 | 10 | 308 | 21 | ||
| 31260 | 52535 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3148GREENWICH Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2006 12:00:00 AM | Permit Number 48634 | 6001945.28510554 | 2118977.8518821 | 37.7984183853373 | -122.437357750068 | (37.7984183853373, -122.437357750068) | 13 | 9 | 1 | 57 | 17 | |||
| 152721 | 143340 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1796 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004433.9519 | 2118779.1956 | 37.798014090515 | -122.42873202906 | (37.798014090515, -122.42873202906) | 13 | 9 | 1 | 57 | 17 | |||
| 7392 | 261325 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 644 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010473 | 2118597 | 37.79785376133 | -122.407822230627 | (37.79785376133, -122.407822230627) | 3 | 1 | 10 | 308 | 4 | ||||
| 9928 | 261390 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 638 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010519.78547 | 2118576.37921 | 37.7977997607314 | -122.407658884309 | (37.7977997607314, -122.407658884309) | 3 | 1 | 10 | 308 | 4 | |||||
| 11993 | 261391 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 660 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010421.78403 | 2118563.41089 | 37.7977586664904 | -122.407997083107 | (37.7977586664904, -122.407997083107) | 3 | 1 | 10 | 308 | 4 | |||||
| 11519 | 261392 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 670 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010377.23792 | 2118557.51621 | 37.7977399869991 | -122.408150809713 | (37.7977399869991, -122.408150809713) | 3 | 1 | 10 | 308 | 4 | |||||
| 16091 | 261396 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 700 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010229.17248 | 2118537.87531 | 37.7976777662505 | -122.408661772909 | (37.7976777662505, -122.408661772909) | 3 | 1 | 10 | 308 | 4 | |||||
| 14300 | 261393 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 661 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010427.0314 | 2118523.75657 | 37.7976500791874 | -122.407976127788 | (37.7976500791874, -122.407976127788) | 3 | 1 | 10 | 308 | 4 | |||||
| 10250 | 261397 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 720 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010143.42503 | 2118526.09105 | 37.7976406066987 | -122.408957651874 | (37.7976406066987, -122.408957651874) | 3 | 1 | 10 | 308 | 4 | |||||
| 5710 | 261400 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 730 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010100.55131 | 2118520.19892 | 37.7976220266446 | -122.409105591228 | (37.7976220266446, -122.409105591228) | 3 | 1 | 10 | 308 | 4 | |||||
| 3665 | 261403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 746 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010031.95335 | 2118510.77151 | 37.797592298166 | -122.409342294069 | (37.797592298166, -122.409342294069) | 3 | 1 | 10 | 308 | 4 | |||||
| 7700 | 261404 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 754 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009997.65437 | 2118506.05781 | 37.7975774337622 | -122.409460645418 | (37.7975774337622, -122.409460645418) | 3 | 1 | 10 | 308 | 4 | |||||
| 17648 | 261398 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 711 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010187.59569 | 2118491.78545 | 37.7975488860672 | -122.408802387211 | (37.7975488860672, -122.408802387211) | 3 | 1 | 10 | 308 | 4 | |||||
| 8968 | 261399 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 715 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010168.78657 | 2118489.20051 | 37.7975407349103 | -122.408867289597 | (37.7975407349103, -122.408867289597) | 3 | 1 | 10 | 308 | 4 | |||||
| 4562 | 261421 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
| 12502 | 261420 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 780 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009867.40288 | 2118488.04976 | 37.7975206891225 | -122.409910080478 | (37.7975206891225, -122.409910080478) | 3 | 1 | 10 | 308 | 4 | |||||
| 161443 | 256195 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 858X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009435 | 2118466 | 37.7974359028634 | -122.411404756359 | (37.7974359028634, -122.411404756359) | 3 | 1 | 10 | 308 | 4 | |||||
| 156989 | 113745 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | 3 | 1 | 10 | 308 | 4 | ||||
| 172565 | 113746 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009590.33174 | 2118455.97825 | 37.7974170965836 | -122.410866557642 | (37.7974170965836, -122.410866557642) | 3 | 1 | 10 | 308 | 4 | ||||
| 28356 | 113747 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.83114 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | 3 | 1 | 10 | 308 | 4 | |||
| 10978 | 261419 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 781 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009855.16282 | 2118445.96033 | 37.7974044358704 | -122.409949461749 | (37.7974044358704, -122.409949461749) | 3 | 1 | 10 | 308 | 4 | |||||
| 23950 | 113748 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | ||||
| 110623 | 256194 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 840X Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009543.77791 | 2118449.16091 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | 3 | 1 | 10 | 308 | 4 | |||||
| 87497 | 48417 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2483 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | 13 | 9 | 1 | 57 | 17 | ||
| 103229 | 48416 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2483 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | Permit Number 45795 | 6001088.95867007 | 2118610.64400879 | 37.7973614105806 | -122.440294547032 | (37.7973614105806, -122.440294547032) | 13 | 9 | 1 | 57 | 17 | ||
| 127385 | 135904 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1488 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006436.02999 | 2118364.96436 | 37.7969898223834 | -122.421774812465 | (37.7969898223834, -122.421774812465) | 13 | 9 | 10 | 28858 | 32 | |||
| 152362 | 116779 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650 | 2118281 | 37.7968838784408 | -122.414107975451 | (37.7968838784408, -122.414107975451) | 5 | 1 | 10 | 308 | 21 | ||
| 101029 | 108939 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Public Library 12 | Private | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774694 | 6004341.9 | 2118349.2 | 37.7968282226561 | -122.429019881342 | (37.7968282226561, -122.429019881342) | 13 | 9 | 1 | 57 | 17 |
| 119264 | 106857 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2800 PIERCE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001545 | 2118180 | 37.7962049292866 | -122.438685656109 | (37.7962049292866, -122.438685656109) | 13 | 9 | 1 | 57 | 17 | ||
| 124134 | 44525 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1125 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2001 12:00:00 AM | Permit Number 43825 | 6008743.61210523 | 2117943.22188109 | 37.7959616805463 | -122.413760149906 | (37.7959616805463, -122.413760149906) | 5 | 1 | 10 | 308 | 21 | ||
| 54636 | 108099 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2390X Green St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 774210 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | ||
| 79075 | 113403 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2052 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006463.2485 | 2117908.2188 | 37.7957372487994 | -122.421648172625 | (37.7957372487994, -122.421648172625) | 13 | 9 | 10 | 28858 | 32 | |||
| 34895 | 143128 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2052 POLK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6006467.2287 | 2117887.8753 | 37.795681615093 | -122.421632954779 | (37.795681615093, -122.421632954779) | 13 | 9 | 10 | 28858 | 32 | |||
| 106176 | 48786 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 137443 | 48787 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1405 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 153658 | 52828 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 750WASHINGTON Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | 2 | Permit Number 48852 | 6011319.3348 | 2117592.1734 | 37.7951420938167 | -122.404822878731 | (37.7951420938167, -122.404822878731) | 3 | 1 | 10 | 28857 | 4 | ||
| 131585 | 52827 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 750WASHINGTON Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 48852 | 6011323.0636 | 2117546.9613 | 37.7950181606921 | -122.404806791825 | (37.7950181606921, -122.404806791825) | 3 | 1 | 10 | 28857 | 4 | |
| 192462 | 249684 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 16 | Front Yard : Yard | Tree | Private 2 | 5 | 5999742.63307 | 2117264.679 | 37.7935890018918 | -122.44485636243 | (37.7935890018918, -122.44485636243) | 13 | 9 | 1 | 57 | 27 | ||||
| 112489 | 249683 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 15 | Front Yard : Yard | Tree | Private 2 | 5 | 5999743.16478 | 2117253.42108 | 37.7935581209611 | -122.444853713047 | (37.7935581209611, -122.444853713047) | 13 | 9 | 1 | 57 | 27 | ||||
| 155555 | 249682 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2400 Baker St | 14 | Front Yard : Yard | Tree | Private 2 | 5 | 5999744.12671 | 2117244.44172 | 37.7935335209065 | -122.444849738942 | (37.7935335209065, -122.444849738942) | 13 | 9 | 1 | 57 | 27 | ||||
| 160949 | 142823 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | 13 | 9 | 10 | 28858 | 32 | |||
| 65240 | 142822 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | 13 | 9 | 10 | 28858 | 32 | |||
| 23229 | 101446 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
| 129210 | 64402 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | FUF | 05/14/1988 12:00:00 AM | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||
| 181217 | 101447 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 777 Stockton St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | Permit Number 25247 | 6010475.1 | 2116722.1 | 37.7927058582733 | -122.407682697096 | (37.7927058582733, -122.407682697096) | 3 | 1 | 10 | 28857 | 4 | ||||
| 37145 | 73572 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
| 160756 | 73592 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
| 189039 | 82029 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 600X Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52275 | 6010586 | 2116213 | 37.7913141995862 | -122.407263072094 | (37.7913141995862, -122.407263072094) | 5 | 1 | 10 | 28857 | 6 | |
| 118423 | 114730 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2536 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780830 | 6002593.47602 | 2116148.5251 | 37.7906866135575 | -122.434912365239 | (37.7906866135575, -122.434912365239) | 13 | 9 | 1 | 29490 | 27 | |
| 178146 | 66596 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1166 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | 2 | Permit Number 29789 | 6008318.17747093 | 2115921.39203862 | 37.7903863327738 | -122.415089057915 | (37.7903863327738, -122.415089057915) | 5 | 1 | 10 | 28858 | 21 | |
| 104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
| 184830 | 135937 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 98 Spruce St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780098 | 5997052.02369 | 2116054.59656 | 37.7901125223289 | -122.454078602473 | (37.7901125223289, -122.454078602473) | 11 | 6 | 1 | 54 | 31 | |
| 38733 | 98088 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.419008809929 | (37.7893685797349, -122.419008809929) | 13 | 9 | 10 | 28858 | 21 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );