trees
11,761 rows where qSpecies_id = 17 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
129 | 107934 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 3 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
139 | 106382 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 9 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
167 | 99668 | DPW Maintained 1 | Tree(s) :: 17 | 150X Alma St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
169 | 258020 | DPW Maintained 1 | Tree(s) :: 17 | 1001X San Jose Ave | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
207 | 251656 | DPW Maintained 1 | Tree(s) :: 17 | 31x Malta Dr | 1 | unknown : Yard | Tree | Private 2 | 3x3 | 5999423 | 2096089 | 37.7354276387403 | -122.44443976141 | (37.7354276387403, -122.44443976141) | 9 | 7 | 4 | 63 | 40 | ||||
271 | 107116 | DPW Maintained 1 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout | Tree | DPW 1 | 12 | 6004270.1 | 2103982.4 | 37.7573764628527 | -122.428243896062 | (37.7573764628527, -122.428243896062) | 2 | 4 | 5 | 28862 | 3 | ||||
297 | 113036 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
338 | 212500 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
383 | 94356 | DPW Maintained 1 | Tree(s) :: 17 | 455 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5999581.42646 | 2091332.3229 | 37.7223759483442 | -122.443550437353 | (37.7223759483442, -122.443550437353) | 9 | 7 | 6 | 28861 | 25 | ||||
387 | 106394 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 21 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
477 | 113497 | DPW Maintained 1 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | ||||
486 | 251556 | DPW Maintained 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004847 | 2108161 | 37.7688825293039 | -122.426546282794 | (37.7688825293039, -122.426546282794) | 8 | 4 | 5 | 28862 | 19 | ||||
583 | 206275 | DPW Maintained 1 | Tree(s) :: 17 | 531 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 8ft | Permit Number 781881 | 5993329.29471 | 2096110.62255 | 37.7351374332273 | -122.465509381364 | (37.7351374332273, -122.465509381364) | 1 | 8 | 4 | 59 | 40 | |
660 | 261647 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2020 12:00:00 AM | 3 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||
727 | 208976 | DPW Maintained 1 | Tree(s) :: 17 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 6ft | Permit Number 784904 | 5994151.01662 | 2096664.66272 | 37.7367060496466 | -122.462708592139 | (37.7367060496466, -122.462708592139) | 9 | 8 | 4 | 59 | 40 | |
833 | 106379 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
1072 | 227637 | DPW Maintained 1 | Tree(s) :: 17 | 326 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | Width 5ft | Permit Number 785527 | 6006174.20556 | 2101172.48753 | 37.7497686457084 | -122.421459183712 | (37.7497686457084, -122.421459183712) | 2 | 4 | 5 | 28859 | 19 | |
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 | |
1249 | 107933 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 1 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
1292 | 102259 | DPW Maintained 1 | Tree(s) :: 17 | 904 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 9 | 3x3 | Permit Number 769677 | 6003013.4 | 2111448.1 | 37.7778042661218 | -122.433123466086 | (37.7778042661218, -122.433123466086) | 15 | 9 | 11 | 29492 | 41 | |
1324 | 109608 | DPW Maintained 1 | Tree(s) :: 17 | 30 Curtis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781648 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | 9 | 7 | 6 | 28861 | 5 | |
1349 | 208257 | DPW Maintained 1 | Tree(s) :: 17 | 15 San Lorenzo Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/14/2020 12:00:00 AM | 3 | Width 6ft | Permit Number 785533 | 5993769.83021 | 2097726.79063 | 37.7396004268184 | -122.464103589926 | (37.7396004268184, -122.464103589926) | 1 | 8 | 4 | 59 | 40 | |
1527 | 155727 | DPW Maintained 1 | Tree(s) :: 17 | 251 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787672 | 5993647.1889 | 2094105.14579 | 37.7296492188193 | -122.464264763718 | (37.7296492188193, -122.464264763718) | 9 | 8 | 4 | 59 | 40 | |
1630 | 208995 | DPW Maintained 1 | Tree(s) :: 17 | 21 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5993486.0432 | 2097190.73028 | 37.7381121792369 | -122.465045871672 | (37.7381121792369, -122.465045871672) | 1 | 8 | 4 | 59 | 40 | |
1701 | 54592 | DPW Maintained 1 | Tree(s) :: 17 | 329 Mississippi St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/26/2020 12:00:00 AM | 3 | 3x4 | Permit Number 785178 | 6014074.3359 | 2105511.64681 | 37.7621253108683 | -122.394443787777 | (37.7621253108683, -122.394443787777) | 10 | 3 | 8 | 28856 | 29 | |
1752 | 865 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
1766 | 208988 | DPW Maintained 1 | Tree(s) :: 17 | 90 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5993940 | 2096795 | 37.7370517679821 | -122.463447618301 | (37.7370517679821, -122.463447618301) | 1 | 8 | 4 | 59 | 40 | |
1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
1970 | 260506 | DPW Maintained 1 | Tree(s) :: 17 | 289 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6009625.74334 | 2110365.68554 | 37.7752050776892 | -122.41017254363 | (37.7752050776892, -122.41017254363) | 8 | 2 | 9 | 28853 | 34 | ||||
2010 | 260603 | DPW Maintained 1 | Tree(s) :: 17 | 1162 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013406.09782 | 2090446.93369 | 37.7207235989971 | -122.395699409803 | (37.7207235989971, -122.395699409803) | 10 | 3 | 8 | 58 | 1 | |||
2090 | 260628 | DPW Maintained 1 | Tree(s) :: 17 | 1251 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016934.60308 | 2092996.85523 | 37.7279208386687 | -122.383679778477 | (37.7279208386687, -122.383679778477) | 10 | 3 | 8 | 58 | 1 | |||
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 | |
2764 | 262058 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 9 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
2857 | 99536 | DPW Maintained 1 | Tree(s) :: 17 | 188 Spear St | 4 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5x9 | 6014774.7 | 2116168.9 | 37.7914266467329 | -122.392767069159 | (37.7914266467329, -122.392767069159) | 12 | 2 | 9 | 28855 | 6 | ||||
3456 | 212503 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
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 | |||
3519 | 261713 | DPW Maintained 1 | Tree(s) :: 17 | 2363 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5987606 | 2099209 | 37.7433130060865 | -122.485523930836 | (37.7433130060865, -122.485523930836) | 1 | 8 | 3 | 29491 | 35 | ||
3587 | 52670 | DPW Maintained 1 | Tree(s) :: 17 | 2755@ 29th AVE Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2006 12:00:00 AM | 6 | Permit Number 48751 | 5987508.99051253 | 2098245.12269605 | 37.7406608014631 | -122.48578863082 | (37.7406608014631, -122.48578863082) | 1 | 8 | 3 | 29491 | 35 | ||
3640 | 173712 | DPW Maintained 1 | Tree(s) :: 17 | 699x 29th St | 1 | Front Yard : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089 | 2098776 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | 2 | 7 | 5 | 63 | 7 | |
3740 | 102276 | DPW Maintained 1 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard | Landscaping | Private 2 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.438398959733 | (37.7402178594385, -122.438398959733) | 2 | 7 | 5 | 63 | 7 | ||||||
3885 | 113314 | DPW Maintained 1 | Tree(s) :: 17 | 69-71 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993857 | 2115083.3 | 37.7872618877682 | -122.46506246599 | (37.7872618877682, -122.46506246599) | 11 | 6 | 1 | 54 | 11 | |||||
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 | |||
4249 | 98418 | DPW Maintained 1 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
4302 | 43229 | DPW Maintained 1 | Tree(s) :: 17 | 1367 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773263 | 5989870.53533028 | 2106067.55897718 | 37.7622764718857 | -122.478195197482 | (37.7622764718857, -122.478195197482) | 1 | 8 | 3 | 56 | 35 |
4399 | 260599 | DPW Maintained 1 | Tree(s) :: 17 | 1114 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014272.04969 | 2090150.96276 | 37.7199590543715 | -122.392685364492 | (37.7199590543715, -122.392685364492) | 10 | 3 | 8 | 58 | 1 | |||
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 | |
4896 | 225339 | DPW Maintained 1 | Tree(s) :: 17 | 3033 Castro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 784772 | 6002890.27268 | 2096019.33334 | 37.7354335745923 | -122.43244713645 | (37.7354335745923, -122.43244713645) | 2 | 7 | 5 | 63 | 7 | |
5027 | 261648 | DPW Maintained 1 | Tree(s) :: 17 | 605 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 5995910 | 2089162 | 37.7162066827324 | -122.456084795666 | (37.7162066827324, -122.456084795666) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | |||
5280 | 253596 | DPW Maintained 1 | Tree(s) :: 17 | 198X Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780230 | |||||||||||
5388 | 182315 | DPW Maintained 1 | Tree(s) :: 17 | 2700X Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 3x3 | Permit Number 43905 | 5986474 | 2105095 | 37.7594083467555 | -122.489870843925 | (37.7594083467555, -122.489870843925) | 1 | 8 | 3 | 56 | 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 | |||
5607 | 260608 | DPW Maintained 1 | Tree(s) :: 17 | 1010 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014125.00477 | 2089910.99969 | 37.7192919954616 | -122.393176869863 | (37.7192919954616, -122.393176869863) | 10 | 3 | 8 | 58 | 1 | |||
5837 | 87442 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
6001 | 262052 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 3 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
6183 | 261798 | DPW Maintained 1 | Tree(s) :: 17 | 2211 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986332 | 2100174 | 37.7458883278603 | -122.489999995029 | (37.7458883278603, -122.489999995029) | 1 | 8 | 3 | 29491 | 35 | ||
6214 | 188143 | DPW Maintained 1 | Tree(s) :: 17 | 1050 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 781453 | 6015462.26121 | 2109813.47257 | 37.7740142422074 | -122.389943956153 | (37.7740142422074, -122.389943956153) | 14 | 3 | 9 | 310 | 20 | |
6241 | 261939 | DPW Maintained 1 | Tree(s) :: 17 | 1 Verna St | 4 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
6510 | 261804 | DPW Maintained 1 | Tree(s) :: 17 | 2363 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986366 | 2099167 | 37.7431253612957 | -122.489808383417 | (37.7431253612957, -122.489808383417) | 1 | 8 | 3 | 29491 | 35 | ||
6646 | 261235 | DPW Maintained 1 | Tree(s) :: 17 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/07/2020 12:00:00 AM | 3 | 3x10 | Permit Number 784981 | 5996559 | 2104265 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | 15 | 5 | 4 | 63 | 12 | |
6662 | 261811 | DPW Maintained 1 | Tree(s) :: 17 | 2371 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5985746 | 2099098 | 37.7428996853912 | -122.491947068435 | (37.7428996853912, -122.491947068435) | 1 | 8 | 3 | 29491 | 35 | ||||
6714 | 261812 | DPW Maintained 1 | Tree(s) :: 17 | 2375 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985747 | 2099073 | 37.7428311005617 | -122.491941770585 | (37.7428311005617, -122.491941770585) | 1 | 8 | 3 | 29491 | 35 | ||
6878 | 232398 | DPW Maintained 1 | Tree(s) :: 17 | 141 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 784757 | 6001393.83562 | 2106197.31009 | 37.763294900763 | -122.438349814208 | (37.763294900763, -122.438349814208) | 15 | 5 | 5 | 28862 | 3 | ||
6994 | 261813 | DPW Maintained 1 | Tree(s) :: 17 | 2395 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5985739 | 2098982 | 37.7425807714008 | -122.491962733637 | (37.7425807714008, -122.491962733637) | 1 | 8 | 3 | 29491 | 35 | ||
7116 | 261799 | DPW Maintained 1 | Tree(s) :: 17 | 2263 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986343 | 2099848 | 37.7449938617898 | -122.489937986338 | (37.7449938617898, -122.489937986338) | 1 | 8 | 3 | 29491 | 35 | ||
7272 | 208990 | DPW Maintained 1 | Tree(s) :: 17 | 51 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784904 | 5993670.13129 | 2097058.8329 | 37.7377606351295 | -122.464399818499 | (37.7377606351295, -122.464399818499) | 1 | 8 | 4 | 59 | 40 | |
7347 | 262056 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 7 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
7797 | 30672 | DPW Maintained 1 | Tree(s) :: 17 | 39 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 0 | Permit Number 34597 | 6006376.8548 | 2109111.02835 | 37.7715774481695 | -122.421322084747 | (37.7715774481695, -122.421322084747) | 8 | 2 | 9 | 28853 | 19 | |
7837 | 96135 | DPW Maintained 1 | Tree(s) :: 17 | 1444X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016335.2 | 2096661 | 37.7379486980737 | -122.386007263552 | (37.7379486980737, -122.386007263552) | 10 | 3 | 8 | 58 | 1 | ||||
7919 | 73237 | DPW Maintained 1 | Tree(s) :: 17 | 2609 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6000014.0127 | 2114014.6742 | 37.7846808214882 | -122.443683781718 | (37.7846808214882, -122.443683781718) | 15 | 6 | 11 | 29490 | 31 | |||
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 | ||
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 | |
8161 | 262050 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
8193 | 79990 | DPW Maintained 1 | Tree(s) :: 17 | 3655 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981694.1032 | 2096684.9357 | 37.7360364047838 | -122.505778307285 | (37.7360364047838, -122.505778307285) | 1 | 8 | 3 | 29491 | 35 | |||
8286 | 48977 | DPW Maintained 1 | Tree(s) :: 17 | 1569 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/2002 12:00:00 AM | 5 | Permit Number 46164 | 5982169.5351 | 2104414.8195 | 37.7572884851745 | -122.504707142738 | (37.7572884851745, -122.504707142738) | 1 | 8 | 3 | 56 | 35 | |
8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
8860 | 260613 | DPW Maintained 1 | Tree(s) :: 17 | 1271 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016832.40592 | 2093073.03805 | 37.7281243722496 | -122.384038382899 | (37.7281243722496, -122.384038382899) | 10 | 3 | 8 | 58 | 1 | |||
9265 | 261652 | DPW Maintained 1 | Tree(s) :: 17 | 191 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 5995473 | 2088701 | 37.7149157919268 | -122.45756193275 | (37.7149157919268, -122.45756193275) | 9 | 8 | 6 | 28861 | 24 | ||||
9426 | 107555 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
9439 | 187697 | DPW Maintained 1 | Tree(s) :: 17 | 1256 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/2020 12:00:00 AM | 3 | Permit Number 785444 | 6008667.10840058 | 2101226.16540452 | 37.7500562758063 | -122.412842385916 | (37.7500562758063, -122.412842385916) | 2 | 4 | 7 | 28859 | 19 | |
9527 | 184625 | DPW Maintained 1 | Tree(s) :: 17 | 1762 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2017 12:00:00 AM | 3 | 4x4 | Permit Number 778834 | 5981059.357 | 2103059.0208 | 37.7535004788576 | -122.508445862177 | (37.7535004788576, -122.508445862177) | 1 | 8 | 3 | 56 | 35 | |
9599 | 212504 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
9845 | 68131 | DPW Maintained 1 | Tree(s) :: 17 | 1512 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2014 12:00:00 AM | 3 | Permit Number 773861 | 6000696.77 | 2113847.7478 | 37.7842614019342 | -122.441309693767 | (37.7842614019342, -122.441309693767) | 15 | 6 | 11 | 29490 | 13 | |
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 | ||
10146 | 78362 | DPW Maintained 1 | Tree(s) :: 17 | 207 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 3x3 | Permit Number 781699 | 6000993.78153 | 2089200.02562 | 37.7166015883641 | -122.438515563747 | (37.7166015883641, -122.438515563747) | 9 | 7 | 6 | 28861 | 5 | |
10202 | 261492 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
10421 | 258022 | DPW Maintained 1 | Tree(s) :: 17 | 157 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 2x3 | Permit Number 782791 | 5991571 | 2092608 | 37.7254185405379 | -122.471333259188 | (37.7254185405379, -122.471333259188) | 9 | 8 | 4 | 59 | 40 | |
10527 | 261801 | DPW Maintained 1 | Tree(s) :: 17 | 2311 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5986355 | 2099480 | 37.7439841331992 | -122.489869433077 | (37.7439841331992, -122.489869433077) | 1 | 8 | 3 | 29491 | 35 | ||
10583 | 209084 | DPW Maintained 1 | Tree(s) :: 17 | 65 San Benito Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/20/2019 12:00:00 AM | 3 | Width 8ft | Permit Number 783015 | 5992862.39854 | 2096311.52421 | 37.7356621193076 | -122.46713819837 | (37.7356621193076, -122.46713819837) | 1 | 8 | 4 | 59 | 40 | |
10614 | 260597 | DPW Maintained 1 | Tree(s) :: 17 | 1289 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013389.69367 | 2090749.59472 | 37.7215537330103 | -122.395777310596 | (37.7215537330103, -122.395777310596) | 10 | 3 | 8 | 58 | 1 | ||
10723 | 113037 | DPW Maintained 1 | Tree(s) :: 17 | 242X 07TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 5993686 | 2113852 | 37.7838712122002 | -122.46556459896 | (37.7838712122002, -122.46556459896) | 11 | 6 | 2 | 54 | 11 | ||||
10729 | 262053 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 4 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | |
11034 | 208967 | DPW Maintained 1 | Tree(s) :: 17 | 44 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 09/28/2020 12:00:00 AM | 3 | Width 6ft | Permit Number 784904 | 5993630.48894 | 2097044.90067 | 37.7377200955087 | -122.46453586883 | (37.7377200955087, -122.46453586883) | 1 | 8 | 4 | 59 | 40 | |
11038 | 262060 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 11 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
11169 | 112778 | DPW Maintained 1 | Tree(s) :: 17 | 1899X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 |
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) );