trees
11,761 rows where qSpecies_id = 17 sorted by PlotSize 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
75685 | 217989 | DPW Maintained 1 | Tree(s) :: 17 | 2643 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780707 | 5990789.38852 | 2097396.88042 | 37.7385223510164 | -122.474384498352 | (37.7385223510164, -122.474384498352) | 1 | 8 | 4 | 29491 | 40 | |
82154 | 221274 | DPW Maintained 1 | Tree(s) :: 17 | 2070 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | Permit Number 782345 | 6008056.7197 | 2106416.85712 | 37.7642744495176 | -122.415320562492 | (37.7642744495176, -122.415320562492) | 8 | 4 | 7 | 28859 | 19 | ||
88008 | 234426 | DPW Maintained 1 | Tree(s) :: 17 | 268 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | Permit Number 779364 | 6008847.91368 | 2107264.66937 | 37.7666467819604 | -122.412643975046 | (37.7666467819604, -122.412643975046) | 8 | 4 | 7 | 28853 | 19 | ||
93980 | 204163 | DPW Maintained 1 | Tree(s) :: 17 | 44 Southwood Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 781011 | 5995611.13254 | 2092478.8947 | 37.7252969291056 | -122.45735764125 | (37.7252969291056, -122.45735764125) | 9 | 7 | 4 | 28861 | 40 | |
97544 | 214193 | DPW Maintained 1 | Tree(s) :: 17 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782215 | 5992820.46391 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | 9 | 8 | 4 | 59 | 40 | |
99462 | 209188 | DPW Maintained 1 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.81863 | 2098534.27999 | 37.7418782818471 | -122.460517875106 | (37.7418782818471, -122.460517875106) | 1 | 8 | 4 | 59 | 40 | |
102693 | 213570 | DPW Maintained 1 | Tree(s) :: 17 | 10 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778534 | 5995304.50078 | 2100206.29449 | 37.7464968590373 | -122.458976877776 | (37.7464968590373, -122.458976877776) | 1 | 8 | 4 | 59 | 40 | |
106821 | 180595 | DPW Maintained 1 | Tree(s) :: 17 | 438 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009775.03095 | 2092351.37985 | 37.7257501541327 | -122.408385202211 | (37.7257501541327, -122.408385202211) | 10 | 3 | 7 | 309 | 28 | |||
116512 | 208981 | DPW Maintained 1 | Tree(s) :: 17 | 310 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/18/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 780136 | 5993092.40274 | 2095921.0497 | 37.7346032476459 | -122.466314622626 | (37.7346032476459, -122.466314622626) | 9 | 8 | 4 | 59 | 40 | |
118634 | 117678 | DPW Maintained 1 | Tree(s) :: 17 | 7800 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2016 12:00:00 AM | 3 | Width 3ft | 5982735.28291 | 2112441.21655 | 37.7793599262476 | -122.503344894252 | (37.7793599262476, -122.503344894252) | 11 | 6 | 2 | 55 | 26 | ||
128915 | 253696 | DPW Maintained 1 | Tree(s) :: 17 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003605 | 2109124 | 37.7714564008742 | -122.430911009882 | (37.7714564008742, -122.430911009882) | 15 | 9 | 11 | 29492 | 10 | ||||
132153 | 234427 | DPW Maintained 1 | Tree(s) :: 17 | 268 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 779364 | 6008861.7546 | 2107017.31377 | 37.7659683774771 | -122.412578614117 | (37.7659683774771, -122.412578614117) | 8 | 4 | 7 | 28853 | 19 | ||
160623 | 164022 | DPW Maintained 1 | Tree(s) :: 17 | 101X Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779959 | 5998844 | 2107514 | 37.7667648389525 | -122.447263591802 | (37.7667648389525, -122.447263591802) | 15 | 5 | 11 | 29492 | 9 | |
171635 | 222345 | DPW Maintained 1 | Tree(s) :: 17 | 4066 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 782241 | 6002770.32987 | 2101838.82375 | 37.751405738306 | -122.433277523647 | (37.751405738306, -122.433277523647) | 2 | 4 | 5 | 28862 | 22 | ||
183332 | 203966 | DPW Maintained 1 | Tree(s) :: 17 | 200 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 779992 | 5992562.81206 | 2097843.65033 | 37.7398516542433 | -122.468285400559 | (37.7398516542433, -122.468285400559) | 1 | 8 | 4 | 59 | 40 | ||
4751 | 239123 | DPW Maintained 1 | Tree(s) :: 17 | 165 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | Width 2ft | Permit Number 784437 | 6007412.87903 | 2096768.69258 | 37.7377465706408 | -122.41686382431 | (37.7377465706408, -122.41686382431) | 2 | 7 | 7 | 28859 | 2 | |
10800 | 239121 | DPW Maintained 1 | Tree(s) :: 17 | 165 Newman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | Width 2ft | Permit Number 784437 | 6007448.88866 | 2096763.10456 | 37.7377332525917 | -122.416738925554 | (37.7377332525917, -122.416738925554) | 2 | 7 | 7 | 28859 | 2 | |
15716 | 222847 | DPW Maintained 1 | Tree(s) :: 17 | 2070 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | Permit Number 782345 | 6008053.38749 | 2106472.7188 | 37.7644276454548 | -122.415336042541 | (37.7644276454548, -122.415336042541) | 8 | 4 | 7 | 28859 | 19 | ||
15967 | 206142 | DPW Maintained 1 | Tree(s) :: 17 | 1377 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5993310.45546 | 2106106.93767 | 37.7625836746174 | -122.466300768565 | (37.7625836746174, -122.466300768565) | 1 | 8 | 11 | 56 | 12 | |||
16024 | 239122 | DPW Maintained 1 | Tree(s) :: 17 | 165 Newman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2019 12:00:00 AM | 3 | Width 2ft | Permit Number 784437 | 6007432.27899 | 2096764.65731 | 37.7377365818786 | -122.416796463312 | (37.7377365818786, -122.416796463312) | 2 | 7 | 7 | 28859 | 2 | |
17888 | 129632 | DPW Maintained 1 | Tree(s) :: 17 | 1224 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2020 11:48:00 PM | 3 | Width 2ft | 6007668.52522 | 2118543.16915 | 37.7975485540748 | -122.417522708125 | (37.7975485540748, -122.417522708125) | 5 | 1 | 10 | 28858 | 32 | ||
64808 | 222619 | DPW Maintained 1 | Tree(s) :: 17 | 2070 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | Permit Number 782345 | 6008053.49701 | 2106456.27126 | 37.7643824904803 | -122.415334499301 | (37.7643824904803, -122.415334499301) | 8 | 4 | 7 | 28859 | 19 | ||
104369 | 242819 | DPW Maintained 1 | Tree(s) :: 17 | 173 Addison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002620.3556 | 2097408.25534 | 37.7392319251012 | -122.433479564443 | (37.7392319251012, -122.433479564443) | 2 | 7 | 5 | 63 | 7 | |||
146863 | 213016 | DPW Maintained 1 | Tree(s) :: 17 | 120 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779661 | 5993626.83548 | 2102594.23274 | 37.7529569465285 | -122.4649514087 | (37.7529569465285, -122.4649514087) | 1 | 8 | 4 | 56 | 12 | |
151096 | 242820 | DPW Maintained 1 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard | Tree | Private 2 | 17 | Width 2ft | 6002456.61791 | 2096763.39514 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | 2 | 7 | 5 | 63 | 7 | |||
184278 | 134809 | DPW Maintained 1 | Tree(s) :: 17 | 2430 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | Permit Number 778843 | 6007053.11654 | 2120656.70313 | 37.8033171384475 | -122.419802238604 | (37.8033171384475, -122.419802238604) | 5 | 1 | 1 | 28858 | 32 | ||
2565 | 208921 | DPW Maintained 1 | Tree(s) :: 17 | 135 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/20/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782931 | 5992336.36345 | 2096045.4635 | 37.7349012047205 | -122.46893753225 | (37.7349012047205, -122.46893753225) | 1 | 8 | 4 | 59 | 40 | |
8002 | 212121 | DPW Maintained 1 | Tree(s) :: 17 | 2101x Monterey Blvd | 3 | Median : Yard | Tree | DPW 1 | 11/27/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784468 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | |
17395 | 208939 | DPW Maintained 1 | Tree(s) :: 17 | 100 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 784719 | 5992155.70572 | 2095974.23732 | 37.7346951961161 | -122.469556940308 | (37.7346951961161, -122.469556940308) | 9 | 8 | 4 | 59 | 40 | |
90679 | 207786 | DPW Maintained 1 | Tree(s) :: 17 | 290 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/30/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782644 | 5993081.96122 | 2096160.8531 | 37.7352610855327 | -122.46636814487 | (37.7352610855327, -122.46636814487) | 1 | 8 | 4 | 59 | 40 | |
98778 | 207801 | DPW Maintained 1 | Tree(s) :: 17 | 75 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | Width 10ft | Permit Number 780133 | 5993316.85986 | 2097021.89165 | 37.7376388336638 | -122.465618555459 | (37.7376388336638, -122.465618555459) | 1 | 8 | 4 | 59 | 40 | |
150204 | 207774 | DPW Maintained 1 | Tree(s) :: 17 | 98 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782995 | 5993269.03182 | 2097018.73215 | 37.7376273996789 | -122.465783688974 | (37.7376273996789, -122.465783688974) | 1 | 8 | 4 | 59 | 40 | |
169440 | 207798 | DPW Maintained 1 | Tree(s) :: 17 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/30/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782629 | 5993265.61107 | 2096796.17632 | 37.7370161196856 | -122.465779350629 | (37.7370161196856, -122.465779350629) | 1 | 8 | 4 | 59 | 40 | |
171731 | 207785 | DPW Maintained 1 | Tree(s) :: 17 | 290 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/30/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782644 | 5993081.87997 | 2096205.80567 | 37.7353845093885 | -122.466371691803 | (37.7353845093885, -122.466371691803) | 1 | 8 | 4 | 59 | 40 | |
176290 | 207768 | DPW Maintained 1 | Tree(s) :: 17 | 20 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/25/2018 12:00:00 AM | 3 | Width 10ft | Permit Number 781879 | 5993209.58572 | 2097384.67012 | 37.7386287444209 | -122.466015804002 | (37.7386287444209, -122.466015804002) | 1 | 8 | 4 | 59 | 40 | |
1185 | 183249 | DPW Maintained 1 | Tree(s) :: 17 | 2100 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782167 | 5984206.7159 | 2100608.9365 | 37.7469582109652 | -122.4973809226 | (37.7469582109652, -122.4973809226) | 1 | 8 | 3 | 29491 | 35 | |
3495 | 181336 | DPW Maintained 1 | Tree(s) :: 17 | 1260 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5986177.8228 | 2106650.4552 | 37.7636618977311 | -122.49100962005 | (37.7636618977311, -122.49100962005) | 1 | 8 | 3 | 56 | 35 | |||
3951 | 183335 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
5102 | 183834 | DPW Maintained 1 | Tree(s) :: 17 | 2210 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986396.7617 | 2100164.5451 | 37.7458661487434 | -122.489775365895 | (37.7458661487434, -122.489775365895) | 1 | 8 | 3 | 29491 | 35 | |||
5582 | 183333 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
5994 | 183334 | DPW Maintained 1 | Tree(s) :: 17 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5982688 | 2106849 | 37.7640025388616 | -122.503094328734 | (37.7640025388616, -122.503094328734) | 1 | 8 | 3 | 56 | 35 | |||
6074 | 184628 | DPW Maintained 1 | Tree(s) :: 17 | 1796 38th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5984434.1354 | 2102998.0252 | 37.7535313177823 | -122.496770827925 | (37.7535313177823, -122.496770827925) | 1 | 8 | 3 | 56 | 35 | |||
6147 | 181792 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | ||
6284 | 181791 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
7974 | 261809 | DPW Maintained 1 | Tree(s) :: 17 | 2359 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | Width 0ft | 5985743 | 2099172 | 37.7431026941426 | -122.491962888437 | (37.7431026941426, -122.491962888437) | 1 | 8 | 3 | 29491 | 35 | ||
10059 | 261650 | DPW Maintained 1 | Tree(s) :: 17 | 545 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5993997 | 2090147 | 37.7188012663705 | -122.462768408851 | (37.7188012663705, -122.462768408851) | 9 | 8 | 6 | 64 | 24 | ||
11728 | 248542 | DPW Maintained 1 | Tree(s) :: 17 | 258 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998812.5011 | 2107653.6201 | 37.7671464005807 | -122.44738259118 | (37.7671464005807, -122.44738259118) | 15 | 5 | 11 | 29492 | 9 | |||
12879 | 261642 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||||
13070 | 181793 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
13206 | 181790 | DPW Maintained 1 | Tree(s) :: 17 | 3199X Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986175 | 2098173 | 37.7403849489204 | -122.490395692367 | (37.7403849489204, -122.490395692367) | 1 | 8 | 3 | 29491 | 35 | |||
14550 | 261641 | DPW Maintained 1 | Tree(s) :: 17 | 689 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | Width 0ft | 5995176 | 2089914 | 37.7182293382848 | -122.45867624436 | (37.7182293382848, -122.45867624436) | 9 | 8 | 6 | 28861 | 24 | ||
14665 | 256768 | DPW Maintained 1 | Tree(s) :: 17 | 900 Brotherhood Way | 7 | Front Yard : Yard | Tree | DPW 1 | 09/25/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782397 | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | |
15318 | 244196 | DPW Maintained 1 | Tree(s) :: 17 | 508 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998471.7891 | 2108892.6681 | 37.7705290359785 | -122.448650307908 | (37.7705290359785, -122.448650307908) | 15 | 5 | 11 | 29492 | 9 | |||
19059 | 244214 | DPW Maintained 1 | Tree(s) :: 17 | 342 Scott St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779666 | 6002262.2202 | 2109717.5413 | 37.7730099442883 | -122.435598216745 | (37.7730099442883, -122.435598216745) | 15 | 5 | 11 | 29492 | 9 | |
19304 | 181896 | DPW Maintained 1 | Tree(s) :: 17 | 2343 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986379.7223 | 2099305.8434 | 37.7435073893325 | -122.489771144773 | (37.7435073893325, -122.489771144773) | 1 | 8 | 3 | 29491 | 35 | |||
19534 | 162670 | DPW Maintained 1 | Tree(s) :: 17 | 30 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 5996650.10566 | 2090561.91182 | 37.7200929670042 | -122.453627674296 | (37.7200929670042, -122.453627674296) | 9 | 8 | 6 | 28861 | 24 | ||
20760 | 184403 | DPW Maintained 1 | Tree(s) :: 17 | 2082 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981400.5223 | 2100912.6701 | 37.7476273056723 | -122.507106847904 | (37.7476273056723, -122.507106847904) | 1 | 8 | 3 | 29491 | 35 | |||
22208 | 182566 | DPW Maintained 1 | Tree(s) :: 17 | 2483 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988890.9813 | 2098452.8512 | 37.7413116024246 | -122.481025496381 | (37.7413116024246, -122.481025496381) | 1 | 8 | 3 | 29491 | 35 | |||
24298 | 142112 | Undocumented 4 | Tree(s) :: 17 | 33 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998605.4598 | 2110962.5015 | 37.7762199106651 | -122.44833701705 | (37.7762199106651, -122.44833701705) | 15 | 6 | 2 | 29492 | 16 | |||
26848 | 248464 | DPW Maintained 1 | Tree(s) :: 17 | 780 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997153.452 | 2107886.4957 | 37.7676908735162 | -122.453137776205 | (37.7676908735162, -122.453137776205) | 15 | 5 | 11 | 29492 | 9 | |||
28413 | 245110 | DPW Maintained 1 | Tree(s) :: 17 | 135 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 6000770.1938 | 2109453.5749 | 37.7722003020292 | -122.44074036886 | (37.7722003020292, -122.44074036886) | 15 | 5 | 11 | 29492 | 9 | |||
28967 | 246065 | DPW Maintained 1 | Tree(s) :: 17 | 30 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5998222.7414 | 2108415.9924 | 37.7692059622877 | -122.449477410381 | (37.7692059622877, -122.449477410381) | 15 | 5 | 11 | 29492 | 9 | |||
30251 | 183155 | DPW Maintained 1 | Tree(s) :: 17 | 2322 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981458.7309 | 2099250.8498 | 37.7430678392852 | -122.506782328683 | (37.7430678392852, -122.506782328683) | 1 | 8 | 3 | 29491 | 35 | |||
31328 | 217558 | DPW Maintained 1 | Tree(s) :: 17 | 111 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5995801.8375 | 2088036.5277 | 37.7131101902365 | -122.456377320317 | (37.7131101902365, -122.456377320317) | 9 | 8 | 6 | 28861 | 24 | |||
35226 | 185189 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985143.9825 | 2097859.9805 | 37.7394652100499 | -122.493937429023 | (37.7394652100499, -122.493937429023) | 1 | 8 | 3 | 29491 | 35 | |||
37680 | 244204 | DPW Maintained 1 | Tree(s) :: 17 | 610 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003538.4887 | 2109697.3737 | 37.7730269756515 | -122.431182008691 | (37.7730269756515, -122.431182008691) | 15 | 9 | 11 | 29492 | 10 | |||
40529 | 182373 | DPW Maintained 1 | Tree(s) :: 17 | 1534 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781637 | 5984996.2741 | 2104755.1988 | 37.7583889515074 | -122.494956413868 | (37.7583889515074, -122.494956413868) | 1 | 8 | 3 | 56 | 35 | |
42021 | 138938 | DPW Maintained 1 | Tree(s) :: 17 | 632 HAYES ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779650 | 6004797.9634 | 2110922.1515 | 37.7764612085261 | -122.426912572117 | (37.7764612085261, -122.426912572117) | 7 | 9 | 11 | 28852 | 10 | |
42912 | 248425 | DPW Maintained 1 | Tree(s) :: 17 | 731 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998544.0431 | 2108064.7106 | 37.7682598065536 | -122.448340749888 | (37.7682598065536, -122.448340749888) | 15 | 5 | 11 | 29492 | 9 | |||
45376 | 187257 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984951.1083 | 2098437.5001 | 37.7410396364594 | -122.494646859045 | (37.7410396364594, -122.494646859045) | 1 | 8 | 3 | 29491 | 35 | |||
45484 | 199801 | DPW Maintained 1 | Tree(s) :: 17 | 2655 Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015165.6626 | 2091129.8953 | 37.7226966006025 | -122.389664762532 | (37.7226966006025, -122.389664762532) | 10 | 3 | 8 | 58 | 1 | |||
46679 | 246166 | DPW Maintained 1 | Tree(s) :: 17 | 699 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997552.2779 | 2108203.1035 | 37.7685830471749 | -122.451781136302 | (37.7685830471749, -122.451781136302) | 15 | 5 | 11 | 29492 | 9 | |||
47889 | 138282 | DPW Maintained 1 | Tree(s) :: 17 | 1202 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6003789.8642 | 2112168.8213 | 37.7798272025121 | -122.430488845982 | (37.7798272025121, -122.430488845982) | 15 | 9 | 11 | 29490 | 41 | |||
50618 | 138375 | DPW Maintained 1 | Tree(s) :: 17 | 1751 SUTTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004245.4413 | 2114603.0947 | 37.7865369073051 | -122.429086416774 | (37.7865369073051, -122.429086416774) | 13 | 9 | 11 | 29490 | 13 | |||
51551 | 186812 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.7642834011007 | -122.495707883417 | (37.7642834011007, -122.495707883417) | 1 | 8 | 3 | 56 | 35 | |||
52119 | 141479 | DPW Maintained 1 | Tree(s) :: 17 | 2202 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998955.348 | 2111499.0776 | 37.7777132080241 | -122.447165288542 | (37.7777132080241, -122.447165288542) | 15 | 6 | 2 | 54 | 16 | |||
53375 | 141567 | DPW Maintained 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.441457680745 | (37.7756308363396, -122.441457680745) | 15 | 5 | 11 | 29492 | 16 | |
53755 | 137784 | DPW Maintained 1 | Tree(s) :: 17 | 2160 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999172.8862 | 2111524.455 | 37.7777953149516 | -122.446414578416 | (37.7777953149516, -122.446414578416) | 15 | 5 | 11 | 54 | 16 | |||
55579 | 181810 | DPW Maintained 1 | Tree(s) :: 17 | 2311 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5987920.8952 | 2099549.8455 | 37.7442672193564 | -122.484460112778 | (37.7442672193564, -122.484460112778) | 1 | 8 | 3 | 29491 | 35 | |||
58918 | 183211 | DPW Maintained 1 | Tree(s) :: 17 | 2201 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5982626.7574 | 2100094.3318 | 37.7454525198404 | -122.502806100507 | (37.7454525198404, -122.502806100507) | 1 | 8 | 3 | 29491 | 35 | |||
59013 | 183179 | DPW Maintained 1 | Tree(s) :: 17 | 2400 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984268.9269 | 2098791.9181 | 37.7419728200296 | -122.49703171134 | (37.7419728200296, -122.49703171134) | 1 | 8 | 3 | 29491 | 35 | |||
60681 | 183443 | DPW Maintained 1 | Tree(s) :: 17 | 2444 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989551.5745 | 2098710.5787 | 37.7420576339149 | -122.478760267562 | (37.7420576339149, -122.478760267562) | 1 | 8 | 3 | 29491 | 35 | |||
62735 | 143025 | DPW Maintained 1 | Tree(s) :: 17 | 2147 MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2008 12:00:00 AM | 4 | Width 0ft | Permit Number 51763 | 6008956.6469 | 2120652.8991 | 37.8034137432208 | -122.413214712493 | (37.8034137432208, -122.413214712493) | 3 | 1 | 10 | 308 | 23 | |
62949 | 244211 | DPW Maintained 1 | Tree(s) :: 17 | 787 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002859.2926 | 2109561.26 | 37.7726147287694 | -122.43352170101 | (37.7726147287694, -122.43352170101) | 15 | 5 | 11 | 29492 | 9 | |||
63586 | 186954 | DPW Maintained 1 | Tree(s) :: 17 | 2800 Sunset Blvd | 28 | Median : Yard | Tree | DPW 1 | 2 | Width 0ft | 5985211.8854 | 2096092.27 | 37.7346155220289 | -122.493572437422 | (37.7346155220289, -122.493572437422) | 1 | 8 | 3 | 29491 | 35 | |||
63783 | 248375 | DPW Maintained 1 | Tree(s) :: 17 | 1605 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997870.7026 | 2108171.6093 | 37.7685148040368 | -122.450677465892 | (37.7685148040368, -122.450677465892) | 15 | 5 | 11 | 29492 | 9 | |||
63974 | 182999 | DPW Maintained 1 | Tree(s) :: 17 | 2309 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988850.1732 | 2098290.3442 | 37.7408630283555 | -122.481154698143 | (37.7408630283555, -122.481154698143) | 1 | 8 | 3 | 29491 | 35 | |||
64651 | 183001 | DPW Maintained 1 | Tree(s) :: 17 | 2309 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5988878.4254 | 2098290.3442 | 37.7408646707501 | -122.481057013702 | (37.7408646707501, -122.481057013702) | 1 | 8 | 3 | 29491 | 35 | |||
65267 | 246139 | DPW Maintained 1 | Tree(s) :: 17 | 636 Shrader St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5997577.8669 | 2108330.4431 | 37.7689341546251 | -122.45170181346 | (37.7689341546251, -122.45170181346) | 15 | 5 | 11 | 29492 | 9 | |||
68295 | 140148 | DPW Maintained 1 | Tree(s) :: 17 | 1819 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999094.2378 | 2110075.0205 | 37.7738110471204 | -122.446582340893 | (37.7738110471204, -122.446582340893) | 15 | 5 | 11 | 29492 | 16 | |||
69052 | 137942 | DPW Maintained 1 | Tree(s) :: 17 | 2211 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003314.7712 | 2115171.6201 | 37.7880452079439 | -122.432346923095 | (37.7880452079439, -122.432346923095) | 13 | 9 | 11 | 29490 | 27 | |||
69410 | 245890 | DPW Maintained 1 | Tree(s) :: 17 | 1003 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001676.2626 | 2109393.2478 | 37.7720862166392 | -122.437601883986 | (37.7720862166392, -122.437601883986) | 15 | 5 | 11 | 29492 | 9 | |||
73887 | 187219 | DPW Maintained 1 | Tree(s) :: 17 | 2401 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984931.5011 | 2098800.6417 | 37.7420355776419 | -122.494741419283 | (37.7420355776419, -122.494741419283) | 1 | 8 | 3 | 29491 | 35 | |||
74831 | 181347 | DPW Maintained 1 | Tree(s) :: 17 | 2500 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Landscaping | Private 2 | 6 | Width 0ft | 5985144.6465 | 2098114.9716 | 37.7401653859663 | -122.493953920474 | (37.7401653859663, -122.493953920474) | 1 | 8 | 3 | 29491 | 35 | |||
75345 | 183137 | DPW Maintained 1 | Tree(s) :: 17 | 3515 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981958.3374 | 2099418.2679 | 37.7435569304689 | -122.505067258282 | (37.7435569304689, -122.505067258282) | 1 | 8 | 3 | 29491 | 35 | |||
75482 | 245449 | DPW Maintained 1 | Tree(s) :: 17 | 2798 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008185.849 | 2106828.0579 | 37.7654107681137 | -122.414903044666 | (37.7654107681137, -122.414903044666) | 8 | 4 | 7 | 28853 | 19 | |||
79811 | 245381 | DPW Maintained 1 | Tree(s) :: 17 | 3450 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005782.5786 | 2098187.8175 | 37.741551332022 | -122.422601382003 | (37.741551332022, -122.422601382003) | 2 | 7 | 7 | 28859 | 2 | |||
82221 | 182927 | DPW Maintained 1 | Tree(s) :: 17 | 2639 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5982723.7516 | 2097156.0189 | 37.7373904194317 | -122.502253307981 | (37.7373904194317, -122.502253307981) | 1 | 8 | 3 | 29491 | 35 | |||
84729 | 200840 | DPW Maintained 1 | Tree(s) :: 17 | 1499 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6012156.0588 | 2106988.3119 | 37.7660730788441 | -122.401182181582 | (37.7660730788441, -122.401182181582) | 14 | 3 | 8 | 28853 | 20 | |||
86024 | 183306 | DPW Maintained 1 | Tree(s) :: 17 | 1270 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982451.8657 | 2106477.3273 | 37.7629681495099 | -122.503883504136 | (37.7629681495099, -122.503883504136) | 1 | 8 | 3 | 56 | 35 |
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) );