trees
3,247 rows where qSpecies_id = 22 sorted by TreeID 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 163505 | 99898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 768908 | 6004438.52556 | 2116689.23299 | 37.7922758451055 | -122.428567149951 | (37.7922758451055, -122.428567149951) | 13 | 9 | 1 | 28858 | 27 | |||
| 72946 | 99896 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 768908 | 6004371.30251 | 2116674.47154 | 37.7922315094359 | -122.428798690309 | (37.7922315094359, -122.428798690309) | 13 | 9 | 1 | 28858 | 27 | |||
| 25519 | 99895 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101X Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | Permit Number 768908 | 6004333.92311 | 2116670.59896 | 37.7922187606381 | -122.428927747522 | (37.7922187606381, -122.428927747522) | 13 | 9 | 1 | 28858 | 27 | ||
| 35642 | 98967 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 78990 | 98966 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 36427 | 98965 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 130291 | 98964 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 29173 | 98963 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 159842 | 98962 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 10044 | 98961 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | ||||
| 109740 | 98818 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1940 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768679 | 5998464.9351 | 2110381.7451 | 37.7746172681371 | -122.448781287782 | (37.7746172681371, -122.448781287782) | 15 | 5 | 11 | 29492 | 16 | |
| 114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 169090 | 98805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010143.10639 | 2117195.10642 | 37.793986029186 | -122.408864800763 | (37.793986029186, -122.408864800763) | 3 | 1 | 10 | 28857 | 4 |
| 121110 | 98804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010297.35863 | 2117215.00262 | 37.7940492982967 | -122.408332474088 | (37.7940492982967, -122.408332474088) | 3 | 1 | 10 | 28857 | 4 |
| 170083 | 98803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
| 179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
| 78186 | 98801 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010237.16405 | 2117207.30409 | 37.79402478906 | -122.408540211182 | (37.79402478906, -122.408540211182) | 3 | 1 | 10 | 28857 | 4 | |
| 95513 | 98800 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768771 | 6010265.98354 | 2117209.83013 | 37.7940333389111 | -122.408440670611 | (37.7940333389111, -122.408440670611) | 3 | 1 | 10 | 28857 | 4 | |
| 35002 | 98799 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
| 187706 | 98797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010116.35805 | 2117191.91562 | 37.7939757697248 | -122.408957127878 | (37.7939757697248, -122.408957127878) | 3 | 1 | 10 | 28857 | 4 | |
| 188988 | 98791 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 1 | 3x6 | Permit Number 768771 | 6010164.1906 | 2117196.54488 | 37.7939911598214 | -122.408791948484 | (37.7939911598214, -122.408791948484) | 3 | 1 | 10 | 28857 | 4 | |
| 158540 | 98435 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
| 98712 | 98434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
| 166192 | 98432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
| 52190 | 98423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
| 161077 | 98422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1501X Steiner St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | ||
| 135121 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1499@Newhall Evans Ave | 2 | Front Yard : | Tree | Private 2 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.27381 | 37.7417009175609 | -122.386401389915 | (37.7417009175609, -122.386401389915) | 10 | 3 | 8 | 58 | 1 | ||
| 8996 | 98282 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008179.30272 | 2110863.50432 | 37.7764907880679 | -122.415211370411 | (37.7764907880679, -122.415211370411) | 8 | 2 | 9 | 28853 | 34 | ||
| 14850 | 98281 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 3 | Permit Number 58649 | 6008165.69574 | 2110879.12634 | 37.7765329177037 | -122.415259547114 | (37.7765329177037, -122.415259547114) | 8 | 2 | 9 | 28853 | 34 | ||
| 5830 | 98280 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 66 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2012 12:00:00 AM | 2 | Permit Number 58649 | 6008148.55904 | 2110896.00071 | 37.776578287595 | -122.415320022909 | (37.776578287595, -122.415320022909) | 8 | 2 | 9 | 28853 | 34 | ||
| 177145 | 98236 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1299X 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 32025 | 5993314 | 2106663 | 37.7641106803471 | -122.466328924005 | (37.7641106803471, -122.466328924005) | 11 | 8 | 11 | 56 | 12 | ||||
| 148746 | 98225 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 3649 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006003 | 2101393 | 37.7503644677962 | -122.422066884002 | (37.7503644677962, -122.422066884002) | 2 | 4 | 5 | 28859 | 19 | ||||
| 36448 | 97661 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1909 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2011 12:00:00 AM | 3 | 5x6 | Permit Number 768299 | 5999925.2115 | 2115581.43122 | 37.7889776633441 | -122.444103621799 | (37.7889776633441, -122.444103621799) | 13 | 6 | 1 | 29490 | 27 | |
| 44371 | 97578 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 628 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001649.0325 | 2110638.8637 | 37.7755048182394 | -122.437785303726 | (37.7755048182394, -122.437785303726) | 15 | 5 | 11 | 29492 | 10 | |||
| 21252 | 97555 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 245 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2011 12:00:00 AM | 3x3 | Permit Number 768266 | 6004805.6 | 2102240.4 | 37.7526236239085 | -122.42626790325 | (37.7526236239085, -122.42626790325) | 2 | 4 | 5 | 28862 | 22 | ||
| 154665 | 97542 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32171 | 97541 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
| 90855 | 97540 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6011760.24824 | 2105105.05265 | 37.7608799809367 | -122.40241878592 | (37.7608799809367, -122.40241878592) | 10 | 3 | 8 | 28856 | 29 | |||
| 139653 | 97539 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011781.1 | 2105070.6 | 37.760786545641 | -122.402344245968 | (37.760786545641, -122.402344245968) | 10 | 3 | 8 | 28856 | 29 | ||||
| 153845 | 97538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2001 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 58907 | 6011736.89369 | 2105103.82401 | 37.7608753035814 | -122.402499473075 | (37.7608753035814, -122.402499473075) | 10 | 3 | 8 | 28856 | 29 | |
| 121980 | 97204 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Jordan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2011 12:00:00 AM | 1 | Permit Number 768071 | 5996213.20813 | 2113152.77904 | 37.7820967750245 | -122.456770862489 | (37.7820967750245, -122.456770862489) | 11 | 6 | 1 | 54 | 31 | ||
| 174717 | 96088 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2120 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | 3 | Permit Number 767147 | 6004491.55029 | 2116740.24376 | 37.7924189083474 | -122.428387320643 | (37.7924189083474, -122.428387320643) | 13 | 9 | 1 | 28858 | 27 | ||
| 163870 | 96087 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2120 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | 3 | Permit Number 767147 | 6004505.56982 | 2116741.81195 | 37.7924240074998 | -122.428338924495 | (37.7924240074998, -122.428338924495) | 13 | 9 | 1 | 28858 | 27 | ||
| 190503 | 96003 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1440 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015764.7456 | 2093584.4946 | 37.7294696462115 | -122.387765025927 | (37.7294696462115, -122.387765025927) | 10 | 3 | 8 | 58 | 1 |
| 121676 | 96002 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1440 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767657 | 6015789.5338 | 2093564.664 | 37.7294165684422 | -122.387677946908 | (37.7294165684422, -122.387677946908) | 10 | 3 | 8 | 58 | 1 |
| 53157 | 95927 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 593 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767624 | 5987807.15035 | 2111962.63313 | 37.7783427176202 | -122.48576426585 | (37.7783427176202, -122.48576426585) | 11 | 6 | 2 | 55 | 26 |
| 21196 | 95772 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767507 | 6002653.48548 | 2089890.5721 | 37.7185919472416 | -122.432828107254 | (37.7185919472416, -122.432828107254) | 9 | 7 | 6 | 28861 | 5 |
| 103865 | 95014 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 95 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010465.4 | 2087260.9 | 37.7118113779993 | -122.405640255324 | (37.7118113779993, -122.405640255324) | 9 | 7 | 8 | 309 | 39 | ||||
| 11687 | 95013 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 93 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010463.1246 | 2087285.1839 | 37.7118779294401 | -122.405649829104 | (37.7118779294401, -122.405649829104) | 9 | 7 | 8 | 309 | 39 | ||||
| 61024 | 94991 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 2 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.404748673867 | (37.7116964188451, -122.404748673867) | 9 | 7 | 8 | 309 | 39 | ||||
| 23797 | 94990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 48 Leland Ave | 1 | Sidewalk: Curb side : | Tree | Private 2 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.404779818423 | (37.7116594240627, -122.404779818423) | 9 | 7 | 8 | 309 | 39 | ||||
| 126180 | 94898 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1320- 1322 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 53959 | 6012229.73839 | 2102194.83033 | 37.7529153474666 | -122.40059057662 | (37.7529153474666, -122.40059057662) | 10 | 3 | 8 | 28856 | 29 | |||
| 72512 | 94675 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 595 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53811 | 6002917 | 2095871 | 37.735027800708 | -122.432344139463 | (37.735027800708, -122.432344139463) | 2 | 7 | 5 | 63 | 7 | |
| 177604 | 94292 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 21146 | 94291 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 83876 | 94290 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 35251 | 94289 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 53861 | 94288 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 188920 | 94287 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 901 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2009 12:00:00 AM | 3x3 | Permit Number 52965 | 6009147 | 2103917 | 37.7574716284078 | -122.411372960691 | (37.7574716284078, -122.411372960691) | 2 | 4 | 7 | 28859 | 19 | ||
| 46926 | 94212 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 465 Missouri St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53589 | 6013546.40465 | 2104937.59452 | 37.7605197269372 | -122.39622947801 | (37.7605197269372, -122.39622947801) | 10 | 3 | 8 | 28856 | 29 | |
| 146554 | 94210 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 465 Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53589 | 6013546.9816 | 2104895.24811 | 37.7604034850574 | -122.396224514648 | (37.7604034850574, -122.396224514648) | 10 | 3 | 8 | 28856 | 29 | |
| 157560 | 94206 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 465 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53589 | 6013552.54008 | 2104815.4674 | 37.7601847339515 | -122.396199698778 | (37.7601847339515, -122.396199698778) | 10 | 3 | 8 | 28856 | 29 | |
| 96832 | 94118 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 145779 | 94117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 57016 | 94116 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 64861 | 94115 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 16377 | 94114 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 200X Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006339.5 | 2111012.4 | 37.7767960515681 | -122.421586361388 | (37.7767960515681, -122.421586361388) | 7 | 9 | 11 | 28852 | 10 | |
| 73554 | 94110 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006363.6521 | 2111083.4813 | 37.7769925854655 | -122.421507861308 | (37.7769925854655, -122.421507861308) | 7 | 9 | 11 | 28852 | 10 | |
| 16691 | 94109 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.421562636328 | (37.7769909819764, -122.421562636328) | 7 | 9 | 11 | 28852 | 10 | |
| 91702 | 94108 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006327.23567 | 2111080.72521 | 37.7769829645232 | -122.421633641398 | (37.7769829645232, -122.421633641398) | 7 | 9 | 11 | 28852 | 10 | |
| 138038 | 94107 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006285.41191 | 2111071.65635 | 37.7769557051769 | -122.4217776786 | (37.7769557051769, -122.4217776786) | 7 | 9 | 11 | 28852 | 10 | |
| 85832 | 94006 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1623 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53609 | 5993044.5 | 2104412.1 | 37.7579147446993 | -122.46709737549 | (37.7579147446993, -122.46709737549) | 1 | 8 | 4 | 56 | 12 | |
| 40744 | 93957 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012892.58363 | 2114155.98675 | 37.7857949437324 | -122.399137844145 | (37.7857949437324, -122.399137844145) | 6 | 2 | 9 | 28855 | 6 | |
| 49329 | 93956 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53397 | 6012912.43006 | 2114137.6628 | 37.7857457364097 | -122.399067893988 | (37.7857457364097, -122.399067893988) | 6 | 2 | 9 | 28855 | 6 | |
| 72195 | 93955 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012923.46043 | 2114122.83633 | 37.7857056410428 | -122.399028690747 | (37.7857056410428, -122.399028690747) | 6 | 2 | 9 | 28855 | 6 | |
| 3597 | 93954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012934.64989 | 2114104.90951 | 37.7856570416874 | -122.398988719454 | (37.7856570416874, -122.398988719454) | 6 | 2 | 9 | 28855 | 6 | |
| 64206 | 93953 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012948.58524 | 2114090.90941 | 37.7856193771856 | -122.398939523867 | (37.7856193771856, -122.398939523867) | 6 | 2 | 9 | 28855 | 6 | |
| 188638 | 93952 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53397 | 6012964.97703 | 2114077.52304 | 37.7855835346973 | -122.398881872795 | (37.7855835346973, -122.398881872795) | 6 | 2 | 9 | 28855 | 6 | |
| 115432 | 93951 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53397 | 6012976.25628 | 2114064.01935 | 37.7855470851813 | -122.398841901552 | (37.7855470851813, -122.398841901552) | 6 | 2 | 9 | 28855 | 6 | |
| 40150 | 93868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 4045 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53365 | 6002857 | 2102387 | 37.7529158168882 | -122.433016969095 | (37.7529158168882, -122.433016969095) | 2 | 4 | 5 | 28862 | 22 | ||
| 161927 | 92973 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 1 on Market St. | 6001664 | 2105786 | 37.7621809066996 | -122.437385951828 | (37.7621809066996, -122.437385951828) | 15 | 5 | 5 | 28862 | 3 | ||||
| 127997 | 92908 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 802 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Jackson St. | 6011726 | 2118056 | 37.7964383722538 | -122.403448393826 | (37.7964383722538, -122.403448393826) | 3 | 1 | 10 | 28860 | 4 | ||
| 100039 | 92890 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | 3 | 1 | 10 | 308 | 4 | ||
| 106349 | 92889 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53104 Tree no. 1 on Montgomery St | 6011723.54732 | 2118091.83637 | 37.7965366333102 | -122.403459403146 | (37.7965366333102, -122.403459403146) | 3 | 1 | 10 | 308 | 4 | |
| 173563 | 92862 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 105 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1994 12:00:00 AM | 3x3 | Permit Number 53078 | 6005612.9 | 2104005.1 | 37.7575146788763 | -122.423601570684 | (37.7575146788763, -122.423601570684) | 2 | 4 | 5 | 28859 | 19 | |
| 162523 | 92855 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1101 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2009 12:00:00 AM | Permit Number 53074 | 6001966 | 2100891 | 37.7487575771252 | -122.435991171851 | (37.7487575771252, -122.435991171851) | 2 | 4 | 5 | 28862 | 22 | |||
| 29390 | 92527 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 1649 | 92526 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 109291 | 92525 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 76795 | 92524 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 275 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6008743 | 2109634 | 37.7731465224788 | -122.413174412357 | (37.7731465224788, -122.413174412357) | 8 | 2 | 9 | 28853 | 34 | ||
| 3516 | 92206 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 443 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775730 | 6002885.09645 | 2091274.76844 | 37.7224057768794 | -122.432126318576 | (37.7224057768794, -122.432126318576) | 9 | 7 | 6 | 28861 | 5 | |
| 24663 | 92015 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 249 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2009 12:00:00 AM | 3x3 | Permit Number 52164 | 5998485.7 | 2104379.6 | 37.7581380835524 | -122.448277156413 | (37.7581380835524, -122.448277156413) | 15 | 5 | 5 | 28862 | 12 | ||
| 123838 | 91523 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2009 12:00:00 AM | 3x3 | Permit Number 52127 | 6004144 | 2097575 | 37.739776095658 | -122.428223365233 | (37.739776095658, -122.428223365233) | 2 | 7 | 5 | 63 | 7 | ||
| 102419 | 91459 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 35704 | 91458 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 133806 | 91457 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 188877 | 91456 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 106482 | 91454 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 35371 | 91453 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680 WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 |
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) );