trees
8,659 rows where qSpecies_id = 11 sorted by PlantDate 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 159714 | 102174 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
| 194212 | 102173 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 10X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 3x3 | Permit Number 769766 | 6000586.1 | 2105578.9 | 37.7615509231117 | -122.441099128797 | (37.7615509231117, -122.441099128797) | 15 | 5 | 5 | 28862 | 3 | |
| 135759 | 22339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5236 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1997 12:00:00 AM | 3 | 3X3 | 6014418.1916 | 2093832.59155 | 37.7300761861762 | -122.392437577641 | (37.7300761861762, -122.392437577641) | 10 | 3 | 8 | 58 | 1 | ||
| 9835 | 30905 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2 Henry Adams St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/1997 12:00:00 AM | 16 | Permit Number 38599 | 6011349.16675 | 2108265.74604 | 37.7695355752349 | -122.404062984032 | (37.7695355752349, -122.404062984032) | 8 | 2 | 8 | 28853 | 20 | |
| 107587 | 24030 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 46 Westbrook Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1994 12:00:00 AM | 6 | 3X4 | 6017366.4256098 | 2095583.6858371 | 37.7350476254936 | -122.382366841972 | (37.7350476254936, -122.382366841972) | 10 | 3 | 8 | 58 | 1 | ||
| 130104 | 24041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Westbrook Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1994 12:00:00 AM | 12 | 3X4 | 6017284.9951248 | 2095593.5314005 | 37.7350701611901 | -122.382649063918 | (37.7350701611901, -122.382649063918) | 10 | 3 | 8 | 58 | 1 | ||
| 37777 | 1780 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
| 117140 | 1786 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 6 | 3X3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
| 136421 | 1781 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2001X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/30/1991 12:00:00 AM | 5 | 3x3 | 6012442.8362111 | 2088493.874497 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | 10 | 3 | 8 | 309 | 1 | ||
| 23724 | 15248 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007914.86722 | 2110337.26914 | 37.7750310067149 | -122.41608885424 | (37.7750310067149, -122.41608885424) | 8 | 2 | 9 | 28853 | 34 | |
| 158086 | 15247 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007902.55668 | 2110326.57547 | 37.7750009522643 | -122.416130681693 | (37.7750009522643, -122.416130681693) | 8 | 2 | 9 | 28853 | 34 | |
| 177182 | 15246 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770901 | 6007883.54199 | 2110310.54573 | 37.7749558692557 | -122.416195322271 | (37.7749558692557, -122.416195322271) | 8 | 2 | 9 | 28853 | 34 | |
| 182348 | 173697 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1401X Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 770901 | 6007975.5805432 | 2110395.7628537 | 37.775195030009 | -122.415882976003 | (37.775195030009, -122.415882976003) | 8 | 2 | 9 | 28853 | 34 | |
| 71051 | 16024 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 130 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 776129 | 6001188.36813 | 2094689.80455 | 37.7316863415452 | -122.438236031078 | (37.7316863415452, -122.438236031078) | 9 | 7 | 4 | 63 | 40 |
| 62389 | 35026 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 86381 | 35024 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 91352 | 35025 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 102751 | 35023 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 157900 | 35021 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 163093 | 35027 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 167359 | 35028 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 175690 | 35022 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 180 Clara St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38597 | 6011954.31093148 | 2111946.88214439 | 37.7796769245789 | -122.402228649986 | (37.7796769245789, -122.402228649986) | 6 | 2 | 9 | 28856 | 34 | |||
| 82046 | 23060 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013327 | (37.7546834499434, -122.42120013327) | 2 | 4 | 5 | 28859 | 19 | ||
| 94090 | 23057 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1125 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006400.53773 | 2103001.31347 | 37.7548029408293 | -122.420806336166 | (37.7548029408293, -122.420806336166) | 2 | 4 | 7 | 28859 | 19 | ||
| 103748 | 23061 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1132 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006335.66583 | 2102980.19171 | 37.754741288696 | -122.421029181876 | (37.754741288696, -122.421029181876) | 2 | 4 | 5 | 28859 | 19 | ||
| 134428 | 23096 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1387 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006465.03799 | 2101520.60096 | 37.7507408794773 | -122.420478177928 | (37.7507408794773, -122.420478177928) | 2 | 4 | 7 | 28859 | 19 | ||
| 160607 | 23129 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1551X Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1995 12:00:00 AM | 18 | 3x3 | 6006545.01503 | 2100384.82062 | 37.747626791978 | -122.420121013731 | (37.747626791978, -122.420121013731) | 2 | 7 | 7 | 28859 | 2 | ||
| 169792 | 23059 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1130X Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1995 12:00:00 AM | 20 | 3X3 | 6006285.82184 | 2102960.15037 | 37.7546834499434 | -122.42120013327 | (37.7546834499434, -122.42120013327) | 2 | 4 | 5 | 28859 | 19 | ||
| 54226 | 68887 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1894 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32859 | 6011847.92256627 | 2093351.64288569 | 37.7286125337957 | -122.40128958947 | (37.7286125337957, -122.40128958947) | 10 | 3 | 8 | 58 | 1 | ||
| 54967 | 68910 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 200 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32886 | 6001405.7823577 | 2104647.13418035 | 37.7590391758472 | -122.438197438228 | (37.7590391758472, -122.438197438228) | 2 | 4 | 5 | 28862 | 3 | ||
| 138072 | 68885 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 46 Crane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32857 | 6012290.21528756 | 2091102.09596203 | 37.7224604045951 | -122.399602670814 | (37.7224604045951, -122.399602670814) | 10 | 3 | 8 | 58 | 1 | ||
| 166180 | 68896 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4500 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32869 | 6001081.11572011 | 2105257.5083401 | 37.7606966436678 | -122.439364038141 | (37.7606966436678, -122.439364038141) | 15 | 4 | 5 | 28862 | 3 | ||
| 4409 | 60582 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1426 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/1982 12:00:00 AM | 10 | Permit Number 20198 | 6000937.5822 | 2111077.0426 | 37.7766674666338 | -122.440277805167 | (37.7766674666338, -122.440277805167) | 15 | 5 | 11 | 29492 | 41 | ||
| 117866 | 53600 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 20-22 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6529 | 6001984.14624772 | 2107766.37459255 | 37.7676367256187 | -122.436420433566 | (37.7676367256187, -122.436420433566) | 15 | 5 | 5 | 29492 | 3 | |||
| 22422 | 122907 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 66 Mint St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779214 | 6010498.83979 | 2112905.93981 | 37.7822289213752 | -122.40733140902 | (37.7822289213752, -122.40733140902) | 14 | 2 | 9 | 28853 | 34 | |
| 107772 | 115672 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 88 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 2x2 | Permit Number 777370 | 6015414.6168 | 2112340.15699 | 37.7809493110907 | -122.390285333422 | (37.7809493110907, -122.390285333422) | 6 | 2 | 9 | 28856 | 6 | |
| 146372 | 115671 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 88 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 2x2 | Permit Number 777370 | 6015432.00937 | 2112353.56516 | 37.7809870916294 | -122.390226100461 | (37.7809870916294, -122.390226100461) | 6 | 2 | 9 | 28856 | 6 | |
| 38679 | 96124 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 401 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 775982 | 6008080 | 2096981 | 37.7383670222757 | -122.414572277483 | (37.7383670222757, -122.414572277483) | 2 | 7 | 7 | 28859 | 2 | |
| 166302 | 83238 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 334 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 0 | 3x3 | Permit Number 769752 | 6002658.21914762 | 2091508.51420962 | 37.7230347248071 | -122.43292727134 | (37.7230347248071, -122.43292727134) | 9 | 7 | 6 | 28861 | 5 |
| 62394 | 39464 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 9 | Permit Number 40935 | 6013007.13144 | 2117612.41259 | 37.7952918600786 | -122.398984224639 | (37.7952918600786, -122.398984224639) | 3 | 1 | 10 | 28860 | 6 | ||
| 92175 | 39465 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40935 | 6012965.0763261 | 2117593.78216534 | 37.795238361813 | -122.399128434705 | (37.795238361813, -122.399128434705) | 3 | 1 | 10 | 28860 | 6 | |||
| 100283 | 39469 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40935 | 6012908.42245 | 2117597.38702 | 37.79524510254 | -122.399324720576 | (37.79524510254, -122.399324720576) | 3 | 1 | 10 | 28860 | 6 | ||
| 146734 | 39467 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40935 | 6012955.41105 | 2117606.591 | 37.7952729932044 | -122.399162777861 | (37.7952729932044, -122.399162777861) | 3 | 1 | 10 | 28860 | 6 | ||
| 163427 | 39471 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40935 | 6012991.21296 | 2117611.54082 | 37.7952885793608 | -122.39903924429 | (37.7952885793608, -122.39903924429) | 3 | 1 | 10 | 28860 | 6 | ||
| 163514 | 39466 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40935 | 6012975.27656 | 2117609.77297 | 37.7952828371959 | -122.399094263015 | (37.7952828371959, -122.399094263015) | 3 | 1 | 10 | 28860 | 6 | ||
| 169935 | 39470 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 7 | Permit Number 40935 | 6012929.85395 | 2117603.82328 | 37.7952639694077 | -122.399251015722 | (37.7952639694077, -122.399251015722) | 3 | 1 | 10 | 28860 | 6 | ||
| 190569 | 39468 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | 8 | Permit Number 40935 | 6012943.2025 | 2117604.70886 | 37.7952671449218 | -122.399204889495 | (37.7952671449218, -122.399204889495) | 3 | 1 | 10 | 28860 | 6 | ||
| 97173 | 68865 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 42 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32828 | 5999702.88857586 | 2093804.05614299 | 37.7291696833827 | -122.443308019081 | (37.7291696833827, -122.443308019081) | 9 | 7 | 4 | 63 | 40 | ||
| 112359 | 68861 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 143 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32824 | 5999130.68595665 | 2093466.79616195 | 37.7282110000736 | -122.445261925501 | (37.7282110000736, -122.445261925501) | 9 | 7 | 4 | 28861 | 40 | ||
| 149523 | 68851 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 263 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32814 | 5999012.22353146 | 2094056.24112648 | 37.7298227153032 | -122.445713825361 | (37.7298227153032, -122.445713825361) | 9 | 7 | 4 | 28861 | 40 | ||
| 163542 | 68853 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 271 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32816 | 5998961.69092536 | 2094057.16953567 | 37.7298223792061 | -122.445888588417 | (37.7298223792061, -122.445888588417) | 9 | 7 | 4 | 28861 | 40 | ||
| 55238 | 9323 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 118 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1992 12:00:00 AM | 12 | 3x3 | 6001258.58704 | 2098719.9184 | 37.742756088519 | -122.438281882105 | (37.742756088519, -122.438281882105) | 2 | 7 | 5 | 63 | 7 | ||
| 164790 | 16137 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 370 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/1989 12:00:00 AM | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | 9 | 7 | 4 | 63 | 40 | ||
| 20615 | 24355 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 131 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 50 | 2X2 | 6005829.72857 | 2108452.61754 | 37.7697387482687 | -122.423167819151 | (37.7697387482687, -122.423167819151) | 8 | 4 | 5 | 28853 | 19 | ||
| 100074 | 11337 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1279 Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 3 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | ||
| 124948 | 6021 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1777 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2007 12:00:00 AM | 12 | 3X3 | 6002103.41715 | 2112560.06808 | 37.7808057894901 | -122.436351009451 | (37.7808057894901, -122.436351009451) | 15 | 5 | 11 | 29490 | 41 | ||
| 180890 | 11253 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1145X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 3 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | 10 | 3 | 8 | 58 | 1 | ||
| 153708 | 52471 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1031 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2005 12:00:00 AM | 9 | Permit Number 48582 | 5992358.22012 | 2111334.85961 | 37.7768831601556 | -122.469974845809 | (37.7768831601556, -122.469974845809) | 11 | 6 | 2 | 54 | 11 | |
| 1017 | 46142 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 6231 | 46141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 9292 | 46150 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
| 9832 | 46143 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 13373 | 46149 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
| 13404 | 46147 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 183885 | 3803 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2000 12:00:00 AM | 6 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | ||
| 66892 | 12853 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 2430 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/26/2001 12:00:00 AM | 18 | 4X4 | 5987942.80456 | 2114670.37051 | 37.7857853007681 | -122.485493751784 | (37.7857853007681, -122.485493751784) | 11 | 6 | 1 | 55 | 33 | ||
| 77455 | 2333 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2321 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/26/1990 12:00:00 AM | 18 | 5X5 | 6009703.8951 | 2103811.21237 | 37.7572123783538 | -122.409439520633 | (37.7572123783538, -122.409439520633) | 2 | 4 | 7 | 28859 | 19 | ||
| 20312 | 21885 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2002 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/25/2005 12:00:00 AM | 3 | 3X3 | 6015662.81977 | 2106225.76236 | 37.7641742947359 | -122.388999643721 | (37.7641742947359, -122.388999643721) | 14 | 3 | 8 | 28856 | 29 | ||
| 145379 | 57692 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1715 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/25/2005 12:00:00 AM | Permit Number 17894 | 6003993.44986299 | 2098263.29936513 | 37.741657488587 | -122.428792959627 | (37.741657488587, -122.428792959627) | 2 | 7 | 5 | 63 | 7 | ||
| 194393 | 254878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3156 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:28:00 AM | 3 | 3x6 | 5995145 | 2086533 | 37.708944125162 | -122.458538785751 | (37.708944125162, -122.458538785751) | 9 | 8 | 6 | 28861 | 25 | ||
| 194385 | 115926 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:25:00 AM | 3 | 3x3 | 6014797.50176 | 2113407.35792 | 37.7838453529251 | -122.392494926324 | (37.7838453529251, -122.392494926324) | 6 | 2 | 9 | 28856 | 6 | ||
| 194386 | 73728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2020 11:22:00 AM | 3 | Permit Number 782600 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | 3 | 1 | 10 | 308 | 23 | |
| 193763 | 102139 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400 Beale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769373 | 6015359.41153 | 2114501.84584 | 37.7868817564363 | -122.390627418428 | (37.7868817564363, -122.390627418428) | 6 | 2 | 9 | 28855 | 6 | |
| 43569 | 3923 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 99X Castro St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2011 12:00:00 AM | 3 | 3x3 | 6002235.815722 | 2107669.5624773 | 37.7673852004846 | -122.435543015361 | (37.7673852004846, -122.435543015361) | 15 | 5 | 5 | 28862 | 3 | ||
| 134831 | 7742 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2009 12:00:00 AM | 3 | 3x3 | Permit Number 53119 | 6006346.51452 | 2111392.48149 | 37.7778400589047 | -122.421589097069 | (37.7778400589047, -122.421589097069) | 7 | 9 | 11 | 28852 | 10 | |
| 32601 | 80919 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 742-744 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50055 | 6007588.31058606 | 2095958.04998863 | 37.7355305902469 | -122.416199874599 | (37.7355305902469, -122.416199874599) | 2 | 7 | 7 | 28859 | 2 | |
| 32497 | 46108 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 798 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 151134 | 46112 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 798 Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | |||
| 194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194400 | 265055 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 32716 | 22076 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6016031.30099 | 2100825.01325 | 37.7493653996154 | -122.387348391317 | (37.7493653996154, -122.387348391317) | 10 | 3 | 8 | 58 | 1 | ||
| 41658 | 21966 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2576 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 3 | 3x3 | 6015804.31673 | 2103615.79665 | 37.7570157299033 | -122.388328069603 | (37.7570157299033, -122.388328069603) | 10 | 3 | 8 | 28856 | 29 | ||
| 85960 | 22074 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 3 | 3X3 | 6016035.87022 | 2100782.12177 | 37.7492478815921 | -122.387329599077 | (37.7492478815921, -122.387329599077) | 10 | 3 | 8 | 58 | 1 | ||
| 151294 | 13095 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1475 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2007 12:00:00 AM | 3 | 3x3 | 6005362.98532 | 2119868.49211 | 37.8010575563795 | -122.42559487047 | (37.8010575563795, -122.42559487047) | 13 | 9 | 1 | 57 | 17 | ||
| 1690 | 52430 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2536 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | 12 | Permit Number 48545 | 6002701.73302 | 2117006.28973 | 37.7930479607542 | -122.434599161948 | (37.7930479607542, -122.434599161948) | 13 | 9 | 1 | 29490 | 27 | |
| 42515 | 27687 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 450 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2000 12:00:00 AM | 6 | 3X3 | 6005508.13612 | 2106310.03189 | 37.7638375651828 | -122.424127803166 | (37.7638375651828, -122.424127803166) | 8 | 4 | 5 | 28859 | 19 | ||
| 110304 | 3897 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 64 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/2000 12:00:00 AM | 3 | 3X3 | 6002171.36046 | 2107903.60476 | 37.7680241620201 | -122.435782703929 | (37.7680241620201, -122.435782703929) | 15 | 5 | 5 | 29492 | 3 | ||
| 31715 | 39448 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495Bldg #11 Rose St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1998 12:00:00 AM | Permit Number 40933 | 6004232.67570269 | 2109577.47214005 | 37.7727370691634 | -122.428772180203 | (37.7727370691634, -122.428772180203) | 7 | 9 | 11 | 28852 | 10 | |||
| 127828 | 39447 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495Bldg #11 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1998 12:00:00 AM | Permit Number 40933 | 6004232.67570269 | 2109577.47214005 | 37.7727370691634 | -122.428772180203 | (37.7727370691634, -122.428772180203) | 7 | 9 | 11 | 28852 | 10 | |||
| 175142 | 39446 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 495Bldg #11 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1998 12:00:00 AM | Permit Number 40933 | 6004232.67570269 | 2109577.47214005 | 37.7727370691634 | -122.428772180203 | (37.7727370691634, -122.428772180203) | 7 | 9 | 11 | 28852 | 10 | |||
| 102383 | 34990 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1215 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/1997 12:00:00 AM | Permit Number 38569 | 6006546.24032736 | 2120061.72426346 | 37.8016549104441 | -122.421514023716 | (37.8016549104441, -122.421514023716) | 13 | 9 | 1 | 28858 | 32 | ||
| 47382 | 1997 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 181 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/22/1995 12:00:00 AM | 25 | 3X3 | 6007290.41049 | 2097980.50123 | 37.7410670394063 | -122.417373111286 | (37.7410670394063, -122.417373111286) | 2 | 7 | 7 | 28859 | 2 | ||
| 102282 | 28973 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 220 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2014 05:01:00 PM | 3 | 3x3 | 6008868.99911 | 2110140.79243 | 37.7745451281964 | -122.412774399244 | (37.7745451281964, -122.412774399244) | 8 | 2 | 9 | 28853 | 34 | ||
| 188010 | 28956 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 271 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2014 05:01:00 PM | 3 | 3x3 | 6009073.5459329 | 2110014.1811218 | 37.7742089619895 | -122.412057879657 | (37.7742089619895, -122.412057879657) | 8 | 2 | 9 | 28853 | 34 | ||
| 5589 | 39428 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 290 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | 3x3 | Permit Number 40930 | 6004202.2780492 | 2109746.86965534 | 37.7732004728874 | -122.428889408135 | (37.7732004728874, -122.428889408135) | 7 | 9 | 11 | 28852 | 10 | ||
| 10962 | 39426 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 395Bldg #9 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40929 | 6004623.83107143 | 2109808.7893301 | 37.7733943405421 | -122.42743561187 | (37.7733943405421, -122.42743561187) | 7 | 9 | 11 | 28852 | 10 | |||
| 24984 | 39429 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 350Bldg #15 Haight St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40931 | 6004450.98112316 | 2109482.57981657 | 37.772488871091 | -122.428010274079 | (37.772488871091, -122.428010274079) | 7 | 9 | 11 | 28852 | 10 |
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) );