trees
11,761 rows where qSpecies_id = 17 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92535 | 107891 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
| 102600 | 107890 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
| 188774 | 107889 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |
| 15426 | 262040 | DPW Maintained 1 | Tree(s) :: 17 | 740 Jamestown Ave | Back Yard : Yard | Tree | DPW 1 | Private | 6015231.58289 | 2088478.1596 | 37.7154191081975 | -122.38925181324 | (37.7154191081975, -122.38925181324) | 10 | 3 | 8 | 58 | 1 | |||||
| 37129 | 253672 | DPW Maintained 1 | Tree(s) :: 17 | 390 06th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 116514 | 100095 | Permitted Site 7 | Tree(s) :: 17 | 4372 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 07/03/2012 12:00:00 AM | 3x3 | Permit Number 769070 | 6001507 | 2100613.7 | 37.7479700909705 | -122.43755853273 | (37.7479700909705, -122.43755853273) | 2 | 4 | 5 | 28862 | 22 | |
| 129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
| 127049 | 107717 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 3 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Port | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789 | 2098909 | 37.7423832554664 | -122.491784477839 | (37.7423832554664, -122.491784477839) | 1 | 8 | 3 | 29491 | 35 |
| 171678 | 107716 | DPW Maintained 1 | Tree(s) :: 17 | 2400X 25th Ave | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | Port | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773973 | 5985789 | 2098909 | 37.7423832554664 | -122.491784477839 | (37.7423832554664, -122.491784477839) | 1 | 8 | 3 | 29491 | 35 |
| 168011 | 108643 | Undocumented 4 | Tree(s) :: 17 | 315X PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Housing Authority | 3x3 | 6012408.6 | 2118423 | 37.7974841688946 | -122.401112237555 | (37.7974841688946, -122.401112237555) | 3 | 1 | 10 | 28860 | 4 | |||
| 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 | |||
| 2295 | 193115 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014511.3912 | 2096886.32335 | 37.7384662854853 | -122.392328872775 | (37.7384662854853, -122.392328872775) | 10 | 3 | 8 | 58 | 1 | |
| 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 |
| 4356 | 262525 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |||
| 4984 | 154060 | Private 9 | Tree(s) :: 17 | 1796 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014554.77098 | 2096926.88452 | 37.7385800668269 | -122.392181721216 | (37.7385800668269, -122.392181721216) | 10 | 3 | 8 | 58 | 1 | |
| 5088 | 50858 | Permitted Site 7 | Tree(s) :: 17 | 201 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2007 12:00:00 AM | Permit No. 49272 | 6005487.62164601 | 2107821.09181059 | 37.7679854177449 | -122.424306235525 | (37.7679854177449, -122.424306235525) | 8 | 4 | 5 | 28853 | 19 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | |
| 8447 | 34424 | Permitted Site 7 | Tree(s) :: 17 | 245 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2015 12:00:00 AM | Permit Number 776476 | 6003617.84008567 | 2095979.02625995 | 37.7353641309188 | -122.429928789613 | (37.7353641309188, -122.429928789613) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | |||||
| 8651 | 68804 | Permitted Site 7 | Tree(s) :: 17 | 135 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | Permit Number 768601 | 6002050.94568257 | 2096520.57098303 | 37.736762227062 | -122.435384843894 | (37.736762227062, -122.435384843894) | 2 | 7 | 5 | 63 | 7 | ||
| 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 | |||
| 9260 | 262526 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 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 | |
| 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 | |
| 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 | |
| 10549 | 38556 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014562.13286 | 2096849.44481 | 37.7383678420956 | -122.39215085288 | (37.7383678420956, -122.39215085288) | 10 | 3 | 8 | 58 | 1 |
| 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 | ||
| 10683 | 111476 | Permitted Site 7 | Tree(s) :: 17 | 2x TRAINOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | |||
| 10846 | 61468 | Permitted Site 7 | Tree(s) :: 17 | 348 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2016 12:00:00 AM | 3 | Permit Number 777176 | 6004159.4203704 | 2106880.97501526 | 37.765328995236 | -122.428833307398 | (37.765328995236, -122.428833307398) | 8 | 4 | 5 | 28862 | 3 | |
| 11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
| 11804 | 261806 | DPW Maintained 1 | Tree(s) :: 17 | 2206 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 4x6 | 5986107 | 2100189 | 37.7459163725485 | -122.490779106515 | (37.7459163725485, -122.490779106515) | 1 | 8 | 3 | 29491 | 35 | |
| 11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
| 12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
| 12824 | 71999 | DPW Maintained 1 | Tree(s) :: 17 | 1919 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987523.8589 | 2102195.0257 | 37.7515070489426 | -122.486027091209 | (37.7515070489426, -122.486027091209) | 1 | 8 | 3 | 29491 | 35 | |||
| 13111 | 57916 | DPW Maintained 1 | Tree(s) :: 17 | 2226 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/1977 12:00:00 AM | 7 | Permit Number 16874 | 5981746.2224 | 2099923.5924 | 37.7449319286698 | -122.505838142048 | (37.7449319286698, -122.505838142048) | 1 | 8 | 3 | 29491 | 35 | |
| 13931 | 70381 | DPW Maintained 1 | Tree(s) :: 17 | 1454 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982184.823 | 2105192.1683 | 37.7594237635385 | -122.504711868385 | (37.7594237635385, -122.504711868385) | 1 | 8 | 3 | 56 | 35 | |||
| 14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
| 14844 | 65987 | Permitted Site 7 | Tree(s) :: 17 | 562 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1990 12:00:00 AM | Permit Number 29017 | 6011019.59487131 | 2116505.8764121 | 37.7921426252031 | -122.405783475493 | (37.7921426252031, -122.405783475493) | 5 | 1 | 10 | 28857 | 6 | ||
| 14848 | 260375 | Private 9 | Tree(s) :: 17 | 67 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784562 | 5999904.1409 | 2088281.96487 | 37.714018757491 | -122.442216028541 | (37.714018757491, -122.442216028541) | 9 | 7 | 6 | 28861 | 5 |
| 15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 | |||
| 15713 | 261808 | DPW Maintained 1 | Tree(s) :: 17 | 2355 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2020 12:00:00 AM | 3 | 5985742 | 2099196 | 37.743168533237 | -122.491968112718 | (37.743168533237, -122.491968112718) | 1 | 8 | 3 | 29491 | 35 | ||
| 15968 | 261219 | DPW Maintained 1 | Tree(s) :: 17 | 1901 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983159 | 2102154 | 37.7511390637365 | -122.501118029821 | (37.7511390637365, -122.501118029821) | 1 | 8 | 3 | 29491 | 35 | |
| 16275 | 260607 | DPW Maintained 1 | Tree(s) :: 17 | 1026 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014043.19207 | 2089971.98975 | 37.71945491674 | -122.393463933828 | (37.71945491674, -122.393463933828) | 10 | 3 | 8 | 58 | 1 | |||
| 16385 | 154062 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 4x3 | Permit Number 782693 | 6014575.41577 | 2096839.56035 | 37.7383414389075 | -122.392104235638 | (37.7383414389075, -122.392104235638) | 10 | 3 | 8 | 58 | 1 | |
| 17025 | 262527 | Undocumented 4 | Tree(s) :: 17 | 410 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4x6 | 6010538 | 2087515 | 37.7125131447181 | -122.405407212047 | (37.7125131447181, -122.405407212047) | 9 | 7 | 8 | 309 | 39 | |||
| 17077 | 70380 | DPW Maintained 1 | Tree(s) :: 17 | 1427 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5982136.0566 | 2105382.6181 | 37.7599438156219 | -122.5048946364 | (37.7599438156219, -122.5048946364) | 1 | 8 | 3 | 56 | 35 | |||
| 17248 | 260604 | DPW Maintained 1 | Tree(s) :: 17 | 1058 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013879.56666 | 2090093.96987 | 37.7197807571849 | -122.394038065566 | (37.7197807571849, -122.394038065566) | 10 | 3 | 8 | 58 | 1 | |||
| 17271 | 65800 | Permitted Site 7 | Tree(s) :: 17 | 2207 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/2016 12:00:00 AM | 3 | Permit Number 777549 | 5990993.94866564 | 2100373.41600695 | 37.7467070009861 | -122.473894331539 | (37.7467070009861, -122.473894331539) | 1 | 8 | 4 | 29491 | 40 | |
| 17341 | 260857 | DPW Maintained 1 | Tree(s) :: 17 | 726 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985712.15541 | 2110932.69313 | 37.7753924991275 | -122.492935643751 | (37.7753924991275, -122.492935643751) | 11 | 6 | 2 | 55 | 26 | |||
| 17564 | 38555 | Private 9 | Tree(s) :: 17 | 1791 La Salle Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | 4x3 | Permit Number 782693 | 6014548.4967 | 2096859.88077 | 37.7383957399564 | -122.392198730091 | (37.7383957399564, -122.392198730091) | 10 | 3 | 8 | 58 | 1 |
| 17589 | 251643 | DPW Maintained 1 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6007328 | 2121670 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | 5 | 1 | 1 | 28858 | 32 | |||
| 17810 | 61917 | Permitted Site 7 | Tree(s) :: 17 | 466 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2011 12:00:00 AM | Permit Number 56835 | 6005671.64086161 | 2107867.23893534 | 37.7681225159523 | -122.423673014099 | (37.7681225159523, -122.423673014099) | 8 | 4 | 5 | 28853 | 19 | ||
| 18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
| 19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 20035 | 35433 | Permitted Site 7 | Tree(s) :: 17 | 1510 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2012 12:00:00 AM | Permit Number 768569 | 6014204.83515634 | 2102021.42788268 | 37.7525491764345 | -122.393748131818 | (37.7525491764345, -122.393748131818) | 10 | 3 | 8 | 28856 | 29 | ||
| 20066 | 37539 | Permitted Site 7 | Tree(s) :: 17 | 628 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2016 12:00:00 AM | 3 | Permit Number 778105 | 6008253.13567923 | 2114173.25091992 | 37.7855827074661 | -122.415190301446 | (37.7855827074661, -122.415190301446) | 13 | 10 | 9 | 28858 | 36 | |
| 20835 | 63301 | Permitted Site 7 | Tree(s) :: 17 | 3261 Harrison St | 1 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | 18 | Permit Number 53402 | 6009046.03746796 | 2099701.90725396 | 37.7458922633049 | -122.411424351246 | (37.7458922633049, -122.411424351246) | 2 | 7 | 7 | 28859 | 2 | |
| 21063 | 63661 | Permitted Site 7 | Tree(s) :: 17 | 478 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779161 | 6003414.6876897 | 2100122.82585576 | 37.7467305432329 | -122.430926804147 | (37.7467305432329, -122.430926804147) | 2 | 7 | 5 | 63 | 22 | |
| 21461 | 43200 | Permitted Site 7 | Tree(s) :: 17 | 193X Boylston St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/06/2014 12:00:00 AM | Permit Number 771752 | 6009145.78478154 | 2094483.50079696 | 37.7315692472707 | -122.41071097272 | (37.7315692472707, -122.41071097272) | 10 | 3 | 7 | 309 | 28 | ||
| 22951 | 31794 | Permitted Site 7 | Tree(s) :: 17 | 135 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2015 12:00:00 AM | Permit Number 775857 | 6001317.37619782 | 2108550.87178 | 37.7697528504481 | -122.43878292419 | (37.7697528504481, -122.43878292419) | 15 | 5 | 5 | 29492 | 9 | ||
| 23548 | 101834 | Permitted Site 7 | Tree(s) :: 17 | 178 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2012 12:00:00 AM | 3x3 | Permit Number 769564 | 6007595.3 | 2100188.6 | 37.7471471355217 | -122.41647528229 | (37.7471471355217, -122.41647528229) | 2 | 7 | 7 | 28859 | 2 | |
| 23881 | 60172 | Permitted Site 7 | Tree(s) :: 17 | 28 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/1989 12:00:00 AM | Permit Number 28243 | 6005971.05209551 | 2105336.16051539 | 37.7611896696002 | -122.422457511855 | (37.7611896696002, -122.422457511855) | 2 | 4 | 5 | 28859 | 19 | ||
| 24608 | 36377 | Permitted Site 7 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | 9 | 7 | 4 | 28861 | 40 |
| 24876 | 61817 | Permitted Site 7 | Tree(s) :: 17 | 395X Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2014 12:00:00 AM | Permit Number 771213 | 6003829.57810709 | 2108926.55853344 | 37.7709269969198 | -122.430120095385 | (37.7709269969198, -122.430120095385) | 7 | 9 | 11 | 29492 | 10 | ||
| 25602 | 31834 | Permitted Site 7 | Tree(s) :: 17 | 237 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35291 | 6009638.9380413 | 2109067.0653134 | 37.7716401088856 | -122.41003520239 | (37.7716401088856, -122.41003520239) | 8 | 2 | 9 | 28853 | 34 | ||
| 27176 | 99217 | Permitted Site 7 | Tree(s) :: 17 | 4015 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6x12 | 6003750.3 | 2100656.7 | 37.7482154478391 | -122.429804363677 | (37.7482154478391, -122.429804363677) | 2 | 4 | 5 | 63 | 22 | |||
| 27300 | 64383 | DPW Maintained 1 | Tree(s) :: 17 | 1727 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773289 | 6010433.5649 | 2120449.6261 | 37.802938410361 | -122.4080894112 | (37.802938410361, -122.4080894112) | 3 | 1 | 10 | 308 | 23 |
| 27329 | 98505 | Undocumented 4 | Tree(s) :: 17 | 135 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/2012 12:00:00 AM | 3x3 | Permit Number 768601 | 6002042 | 2096528 | 37.7367821173785 | -122.435416304249 | (37.7367821173785, -122.435416304249) | 2 | 7 | 5 | 63 | 7 | |
| 28857 | 43558 | Permitted Site 7 | Tree(s) :: 17 | 556 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776806 | 6002301.81672253 | 2099470.8115862 | 37.7448771459543 | -122.434728379076 | (37.7448771459543, -122.434728379076) | 2 | 7 | 5 | 63 | 22 | ||
| 29935 | 64845 | Permitted Site 7 | Tree(s) :: 17 | 1257 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1990 12:00:00 AM | Permit Number 25859 | 5994522.1785322 | 2106937.48313307 | 37.7649339768343 | -122.462170124288 | (37.7649339768343, -122.462170124288) | 11 | 5 | 11 | 56 | 12 | ||
| 29984 | 45629 | DPW Maintained 1 | Tree(s) :: 17 | 1230 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2018 12:00:00 AM | 3 | 5x5 | Permit Number 780876 | 6012210.69909 | 2102647.6624 | 37.7541576637452 | -122.40068822769 | (37.7541576637452, -122.40068822769) | 10 | 3 | 8 | 28856 | 29 |
| 30936 | 70439 | DPW Maintained 1 | Tree(s) :: 17 | 2426 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773392 | 5983041.4986 | 2098597.8907 | 37.7413680695353 | -122.501261346997 | (37.7413680695353, -122.501261346997) | 1 | 8 | 3 | 29491 | 35 |
| 31498 | 45281 | Permitted Site 7 | Tree(s) :: 17 | 500X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2012 12:00:00 AM | Permit Number 769389 | 6008369.77310991 | 2096035.21194586 | 37.7357863701315 | -122.41350350867 | (37.7357863701315, -122.41350350867) | 10 | 7 | 7 | 28859 | 2 | ||
| 32910 | 61026 | Permitted Site 7 | Tree(s) :: 17 | 242 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/2015 12:00:00 AM | Permit Number 776588 | 6006559.80297081 | 2098270.33895449 | 37.7418217353347 | -122.419919854064 | (37.7418217353347, -122.419919854064) | 2 | 7 | 7 | 28859 | 2 | ||
| 33549 | 51720 | Permitted Site 7 | Tree(s) :: 17 | 437 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | 3 | 3x3 | Permit Number 47990 | 6003446.87940885 | 2103872.79689543 | 37.7570289047818 | -122.431083094664 | (37.7570289047818, -122.431083094664) | 2 | 4 | 5 | 28862 | 3 |
| 33848 | 48955 | Permitted Site 7 | Tree(s) :: 17 | 2710 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | Permit Number 46142 | 6008905.89648049 | 2102666.1035566 | 37.7540234236093 | -122.412118393253 | (37.7540234236093, -122.412118393253) | 2 | 4 | 7 | 28859 | 19 | ||
| 34634 | 106160 | Permitted Site 7 | Tree(s) :: 17 | 2212 18TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5990758.8 | 2100309.6 | 37.7465181557949 | -122.474702786724 | (37.7465181557949, -122.474702786724) | 1 | 8 | 4 | 29491 | 40 | |||
| 34966 | 111477 | Permitted Site 7 | Tree(s) :: 17 | 2x TRAINOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | |||
| 35528 | 45587 | DPW Maintained 1 | Tree(s) :: 17 | 1750 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/2014 12:00:00 AM | 4 | Permit Number 772727 | 5986287.001 | 2103325.5133 | 37.7545389011356 | -122.490387395213 | (37.7545389011356, -122.490387395213) | 1 | 8 | 3 | 56 | 35 | |
| 35646 | 35094 | Permitted Site 7 | Tree(s) :: 17 | 425 Amazon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/2007 12:00:00 AM | Permit No. 49231 | 6001489.13768192 | 2088967.27605861 | 37.7159906753259 | -122.4367867169 | (37.7159906753259, -122.4367867169) | 9 | 7 | 6 | 28861 | 5 | ||
| 36042 | 64033 | Permitted Site 7 | Tree(s) :: 17 | 487 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/09/2015 12:00:00 AM | Permit Number 776878 | 6008915.90971526 | 2096084.2199687 | 37.735951585969 | -122.411618755219 | (37.735951585969, -122.411618755219) | 10 | 7 | 7 | 28859 | 2 | ||
| 39110 | 36570 | Permitted Site 7 | Tree(s) :: 17 | 133 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2014 12:00:00 AM | Permit Number 773080 | 6006339.29055152 | 2097508.67729568 | 37.7397179573591 | -122.420628258991 | (37.7397179573591, -122.420628258991) | 2 | 7 | 7 | 28859 | 2 | ||
| 39332 | 31810 | Permitted Site 7 | Tree(s) :: 17 | 99 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.7689758778799 | -122.436695073767 | (37.7689758778799, -122.436695073767) | 15 | 5 | 5 | 29492 | 3 | ||
| 42010 | 63240 | Permitted Site 7 | Tree(s) :: 17 | 3630-3632 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/2013 12:00:00 AM | 12 | 3x3 | Permit Number 769849 | 6006088.29647773 | 2104364.06352525 | 37.7585271318828 | -122.421982955388 | (37.7585271318828, -122.421982955388) | 2 | 4 | 5 | 28859 | 19 |
| 42321 | 58866 | Permitted Site 7 | Tree(s) :: 17 | 27 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 18126 | 5998507.54065237 | 2107215.37491712 | 37.7659256589143 | -122.448405835927 | (37.7659256589143, -122.448405835927) | 15 | 5 | 11 | 29492 | 9 | ||
| 46625 | 69076 | Permitted Site 7 | Tree(s) :: 17 | 1425 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/2016 12:00:00 AM | 3 | Permit Number 777977 | 5990812.29366182 | 2105693.6463457 | 37.7613044295825 | -122.474910748597 | (37.7613044295825, -122.474910748597) | 1 | 8 | 4 | 56 | 12 | |
| 46678 | 46821 | Permitted Site 7 | Tree(s) :: 17 | 478 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2013 12:00:00 AM | 5 | 3x3 | Permit Number 770370 | 6003653.90242727 | 2090553.77488483 | 37.7204696462922 | -122.429417343863 | (37.7204696462922, -122.429417343863) | 9 | 7 | 6 | 28861 | 5 |
| 47811 | 46839 | Permitted Site 7 | Tree(s) :: 17 | 298 Munich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2016 12:00:00 AM | 3 | Permit Number 778889 | 6004393.42189905 | 2090714.06413365 | 37.7209516071377 | -122.426872471084 | (37.7209516071377, -122.426872471084) | 9 | 7 | 6 | 28861 | 5 | |
| 49119 | 94908 | Permitted Site 7 | Tree(s) :: 17 | 72 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2010 12:00:00 AM | 3x3 | Permit Number 53966 | 6007392 | 2098971 | 37.7437924437225 | -122.417092017531 | (37.7437924437225, -122.417092017531) | 2 | 7 | 7 | 28859 | 2 | |
| 49176 | 41217 | DPW Maintained 1 | Tree(s) :: 17 | 417 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2012 12:00:00 AM | 1 | Permit Number 56581 | 6000146.8802 | 2110487.8057 | 37.7750045214549 | -122.442970742166 | (37.7750045214549, -122.442970742166) | 15 | 5 | 11 | 29492 | 16 | |
| 49341 | 31812 | Permitted Site 7 | Tree(s) :: 17 | 99 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.7689758778799 | -122.436695073767 | (37.7689758778799, -122.436695073767) | 15 | 5 | 5 | 29492 | 3 | ||
| 52695 | 40532 | Permitted Site 7 | Tree(s) :: 17 | 169 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/1999 12:00:00 AM | Permit Number 776065 | 5993382.53676631 | 2094483.25805098 | 37.7306721640024 | -122.465207140084 | (37.7306721640024, -122.465207140084) | 9 | 8 | 4 | 59 | 40 | ||
| 52743 | 53085 | Permitted Site 7 | Tree(s) :: 17 | 191@ WHITNEY Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2006 12:00:00 AM | Permit Number 49052 | 6004418.2123833 | 2097211.38982763 | 37.7387932164166 | -122.427249360433 | (37.7387932164166, -122.427249360433) | 2 | 7 | 5 | 63 | 7 |
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) );