trees
3,247 rows where qSpecies_id = 22 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | ||
| 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 | ||||
| 18848 | 54010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1537 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/1972 12:00:00 AM | 5 | Permit Number 9729 | 6012988.89964 | 2105636.75215 | 37.7624084228186 | -122.398206698706 | (37.7624084228186, -122.398206698706) | 10 | 3 | 8 | 28856 | 29 | |
| 64086 | 53935 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 151 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1972 12:00:00 AM | 6 | Permit Number 9649 | 5993018.55454 | 2114471.48736 | 37.7855336360542 | -122.467918766535 | (37.7855336360542, -122.467918766535) | 11 | 6 | 2 | 54 | 11 | ||
| 194438 | 225616 | Prune Opt Out 3 | Ginkgo biloba :: Maidenhair Tree 22 | 15 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 787984 | 6001852.25626 | 2097023.92467 | 37.7381330336073 | -122.436107807923 | (37.7381330336073, -122.436107807923) | 2 | 7 | 5 | 63 | 7 | ||
| 194274 | 176549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 65 Ocean Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Permit Number 785586 | 6001075.93443 | 2091730.69509 | 37.7235549090091 | -122.438412809004 | (37.7235549090091, -122.438412809004) | 9 | 7 | 6 | 28861 | 25 | |||
| 9701 | 50525 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 278 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2020 12:00:00 AM | 3 | Permit Number 785437 | 6013437.34066 | 2105807.45901 | 37.7629021146671 | -122.396667663687 | (37.7629021146671, -122.396667663687) | 14 | 3 | 8 | 28856 | 29 | ||
| 82005 | 69296 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 839 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2019 12:00:00 AM | 3 | Permit Number 783181 | 6000971.5398 | 2111598.7615 | 37.7781019079344 | -122.440197757934 | (37.7781019079344, -122.440197757934) | 15 | 5 | 11 | 29490 | 41 | |
| 76420 | 33316 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004409.7027 | 2120463.36257 | 37.8026370063559 | -122.42893607346 | (37.8026370063559, -122.42893607346) | 13 | 9 | 1 | 57 | 17 | |
| 80947 | 33317 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1443-1443X Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2019 12:00:00 AM | 3 | Permit Number 782769 | 6004424.04227 | 2120465.37019 | 37.8026433303993 | -122.428886594537 | (37.8026433303993, -122.428886594537) | 13 | 9 | 1 | 57 | 17 | |
| 112795 | 5502 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 769 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6x10 | Permit Number 782663 | 6005055.62871 | 2103865.722 | 37.7571005081006 | -122.42551892127 | (37.7571005081006, -122.42551892127) | 2 | 4 | 5 | 28859 | 19 | ||
| 124846 | 258137 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 460 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782442 | 6002949.79782 | 2105560.87431 | 37.7616357801338 | -122.432922786357 | (37.7616357801338, -122.432922786357) | 15 | 4 | 5 | 28862 | 3 | |
| 16653 | 156578 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 327 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 782340 | 6006945.39069 | 2096312.28481 | 37.7364670691931 | -122.41844780742 | (37.7364670691931, -122.41844780742) | 2 | 7 | 7 | 28859 | 2 | |
| 82483 | 240000 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3861 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 6x6 | Permit Number 782241 | 6004016.32481 | 2101862.01887 | 37.7515400331665 | -122.428970379877 | (37.7515400331665, -122.428970379877) | 2 | 4 | 5 | 28862 | 22 | |
| 143589 | 240001 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3861 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 6x6 | Permit Number 782241 | 6004050.96962 | 2101863.58561 | 37.7515462960277 | -122.428850685506 | (37.7515462960277, -122.428850685506) | 2 | 4 | 5 | 28862 | 22 | |
| 96451 | 225775 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002401.77617 | 2104846.28665 | 37.75964259654 | -122.43476706624 | (37.75964259654, -122.43476706624) | 2 | 4 | 5 | 28862 | 3 | ||
| 141915 | 225774 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002400.68275 | 2104833.82508 | 37.7596083179996 | -122.434769956692 | (37.7596083179996, -122.434769956692) | 2 | 4 | 5 | 28862 | 3 | ||
| 194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 4261 | 224651 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 5x9 | Permit Number 781922 | 6006794.80583 | 2098578.82638 | 37.7426820095795 | -122.419129166176 | (37.7426820095795, -122.419129166176) | 2 | 7 | 7 | 28859 | 2 | |
| 38 | 167409 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 4 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6001979.94285 | 2107686.90453 | 37.7674182815445 | -122.436429284105 | (37.7674182815445, -122.436429284105) | 15 | 5 | 5 | 29492 | 3 | |
| 56 | 124 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2020 12:00:00 AM | 3 | 3X3 | Permit Number 781788 | 6002037.12702 | 2107659.05322 | 37.7673450578674 | -122.436229498819 | (37.7673450578674, -122.436229498819) | 15 | 5 | 5 | 29492 | 3 | |
| 3762 | 159863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 31 Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781524 | 6001585.86798 | 2091604.37779 | 37.7232370625303 | -122.436641024974 | (37.7232370625303, -122.436641024974) | 9 | 7 | 6 | 28861 | 25 | |
| 67457 | 176538 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 351 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781440 | 6011090.57956 | 2089007.63237 | 37.7166424922212 | -122.403602269453 | (37.7166424922212, -122.403602269453) | 9 | 7 | 8 | 309 | 39 | |
| 154320 | 176537 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 353 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781440 | 6011077.16933 | 2089015.56342 | 37.7166635201745 | -122.403649179893 | (37.7166635201745, -122.403649179893) | 9 | 7 | 8 | 309 | 39 | |
| 7494 | 243413 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998151.68157 | 2104894.95588 | 37.7595340204918 | -122.449469463666 | (37.7595340204918, -122.449469463666) | 15 | 5 | 11 | 28862 | 12 | |
| 16371 | 260999 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 77 Belgrave Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 | |
| 157324 | 32045 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2979 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | Permit Number 781325 | 5999951.23823 | 2116389.65594 | 37.7911983214916 | -122.444071670681 | (37.7911983214916, -122.444071670681) | 13 | 6 | 1 | 29490 | 27 | ||
| 72017 | 242841 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 3820 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781070 | 6005022.59932 | 2100499.88784 | 37.7478568435312 | -122.425393630421 | (37.7478568435312, -122.425393630421) | 2 | 4 | 5 | 63 | 22 | |
| 17073 | 177097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:08:00 PM | 3 | 3x3 | Permit Number 780184 | 6000986.95239 | 2093579.83618 | 37.7286271663089 | -122.438852851774 | (37.7286271663089, -122.438852851774) | 9 | 7 | 6 | 28861 | 25 | |
| 144645 | 237042 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2627 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2017 12:00:00 AM | 3 | 4x4 | Permit Number 779999 | 6010308.84654 | 2103966.51965 | 37.7576726945459 | -122.407358302349 | (37.7576726945459, -122.407358302349) | 10 | 4 | 7 | 28859 | 19 | |
| 87493 | 132224 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3720 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779917 | 5997037.00688 | 2115048.93067 | 37.7873503715741 | -122.454057896478 | (37.7873503715741, -122.454057896478) | 11 | 6 | 1 | 54 | 31 | |
| 71383 | 46477 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 195 Erie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | 8 | 4 | 7 | 28853 | 19 | ||
| 182112 | 46478 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 195 Erie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 779295 | 6006760.77877473 | 2108157.52189336 | 37.7689809837181 | -122.419926393368 | (37.7689809837181, -122.419926393368) | 8 | 4 | 7 | 28853 | 19 | ||
| 156678 | 255580 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 384 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778885 | 6003411.13256 | 2099532.22132 | 37.7451086791398 | -122.430896954644 | (37.7451086791398, -122.430896954644) | 2 | 7 | 5 | 63 | 22 | |
| 164875 | 30510 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | 13 | 9 | 1 | 57 | 17 | |
| 118546 | 123760 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 201 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778327 | 5994952.60534 | 2110751.23907 | 37.7754303235309 | -122.460957832773 | (37.7754303235309, -122.460957832773) | 11 | 6 | 2 | 54 | 11 | |
| 137507 | 10090 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 2X2 | Permit Number 777732 | 6005659.80497 | 2104809.7574 | 37.7597267272239 | -122.423496559112 | (37.7597267272239, -122.423496559112) | 2 | 4 | 5 | 28859 | 19 | |
| 1811 | 258532 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1565 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777683 | 6006695.00356 | 2117330.6469 | 37.7941644464503 | -122.420805231935 | (37.7941644464503, -122.420805231935) | 13 | 9 | 10 | 28858 | 32 | |
| 5543 | 121277 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 32980 | 147589 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990252.11416 | 2112971.56981 | 37.7812551417606 | -122.477380075345 | (37.7812551417606, -122.477380075345) | 11 | 6 | 2 | 55 | 26 | |
| 36998 | 121281 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 62537 | 121276 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 77980 | 121283 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 80724 | 121284 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 93654 | 121280 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 116306 | 147588 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990252.64201 | 2112933.29364 | 37.7811500766647 | -122.477375451022 | (37.7811500766647, -122.477375451022) | 11 | 6 | 2 | 55 | 26 | |
| 128498 | 121278 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 134962 | 147590 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990251.14725 | 2113004.86394 | 37.7813465020817 | -122.477385854376 | (37.7813465020817, -122.477385854376) | 11 | 6 | 2 | 55 | 26 | |
| 149736 | 121282 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 152002 | 121279 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4.5x15 | Permit Number 777516 | 5990184 | 2112906 | 37.781071152831 | -122.477610920079 | (37.781071152831, -122.477610920079) | 11 | 6 | 2 | 55 | 26 | ||
| 164491 | 251061 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 5418 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 777516 | 5990182.6788 | 2112719.9143 | 37.7805601365444 | -122.477601885097 | (37.7805601365444, -122.477601885097) | 11 | 6 | 2 | 55 | 26 | ||
| 193648 | 147591 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 369 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 777516 | 5990250.17652 | 2113053.797 | 37.7814808023322 | -122.477392789959 | (37.7814808023322, -122.477392789959) | 11 | 6 | 2 | 55 | 26 | |
| 128688 | 67025 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1272 SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777352 | 6007671 | 2102251 | 37.7528142772775 | -122.416359573292 | (37.7528142772775, -122.416359573292) | 2 | 4 | 7 | 28859 | 19 | |
| 123647 | 117561 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 61 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777259 | 6001017 | 2101343.8 | 37.7499468995644 | -122.439305252484 | (37.7499468995644, -122.439305252484) | 2 | 4 | 5 | 28862 | 22 | |
| 123834 | 117562 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 61 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777259 | 6001017 | 2101343.8 | 37.7499468995644 | -122.439305252484 | (37.7499468995644, -122.439305252484) | 2 | 4 | 5 | 28862 | 22 | |
| 168205 | 157655 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 4171 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777107 | 6002113.71434 | 2101756.88931 | 37.7511434941804 | -122.435542313334 | (37.7511434941804, -122.435542313334) | 2 | 4 | 5 | 28862 | 22 | |
| 133722 | 114549 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015846.45477 | 2106262.10927 | 37.7642842728198 | -122.388367034517 | (37.7642842728198, -122.388367034517) | 14 | 3 | 8 | 28856 | 29 | ||
| 158146 | 114548 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015820.59236 | 2106259.92484 | 37.7642768417202 | -122.38845633359 | (37.7642768417202, -122.38845633359) | 14 | 3 | 8 | 28856 | 29 | ||
| 167912 | 114550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 455 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777068 | 6015870.34934 | 2106264.23944 | 37.764291445828 | -122.388284537902 | (37.764291445828, -122.388284537902) | 14 | 3 | 8 | 28856 | 29 | ||
| 121723 | 116843 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2571 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987034.8 | 2097780.1 | 37.7393563293641 | -122.487394029182 | (37.7393563293641, -122.487394029182) | 1 | 8 | 3 | 29491 | 35 | |
| 170568 | 57807 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2571 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 5x5 | Permit Number 776632 | 5987052.3077 | 2097770.09 | 37.7393298655452 | -122.487332761031 | (37.7393298655452, -122.487332761031) | 1 | 8 | 3 | 29491 | 35 | |
| 64566 | 572 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2980X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2015 12:00:00 AM | 24 | 3x3 | Permit Number 776380 | 6009061.0945003 | 2102187.7119023 | 37.75271857431 | -122.411547882163 | (37.75271857431, -122.411547882163) | 2 | 4 | 7 | 28859 | 19 | |
| 126043 | 70418 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 219 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 1 | 3x3 | Permit Number 776244 | 6006518.6259 | 2092893.7902 | 37.7270565992609 | -122.419680839118 | (37.7270565992609, -122.419680839118) | 9 | 7 | 7 | 309 | 5 | |
| 4508 | 260546 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
| 6679 | 152982 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006311.85744 | 2102620.48455 | 37.7537522736602 | -122.421085978553 | (37.7537522736602, -122.421085978553) | 2 | 4 | 5 | 28859 | 19 | |
| 7127 | 260547 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
| 13165 | 152981 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 3400 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776221 | 6006333.00148 | 2102621.91378 | 37.753757389911 | -122.421012959005 | (37.753757389911, -122.421012959005) | 2 | 4 | 5 | 28859 | 19 | |
| 15866 | 87230 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
| 99391 | 87231 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2575X JUDAH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 3x3 | Permit Number 776165 | 5986584.2 | 2105636.2 | 37.7609007669433 | -122.489529520217 | (37.7609007669433, -122.489529520217) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |
| 141736 | 35983 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775550 | 6006098.67347386 | 2097638.59230128 | 37.7400611109811 | -122.421469435714 | (37.7400611109811, -122.421469435714) | 2 | 7 | 7 | 28859 | 2 | |
| 158418 | 67597 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 340 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2013 12:00:00 AM | 1 | 8x9 | Permit Number 775356 | 6013458.09816 | 2105466.18562 | 37.7619662082009 | -122.396571946142 | (37.7619662082009, -122.396571946142) | 10 | 3 | 8 | 28856 | 29 | |
| 37837 | 110158 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.414560246865 | (37.7968116091339, -122.414560246865) | 5 | 1 | 10 | 308 | 21 | ||
| 142053 | 110157 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045-1059 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 775264 | 6008554.60995 | 2118262.34224 | 37.7968272906045 | -122.414436727676 | (37.7968272906045, -122.414436727676) | 5 | 1 | 10 | 308 | 21 | ||
| 71488 | 190612 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008236.46776 | 2110619.04505 | 37.7758227734432 | -122.414996312823 | (37.7758227734432, -122.414996312823) | 8 | 2 | 9 | 28853 | 34 | |
| 176904 | 190611 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 9 Washburn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 775218 | 6008250.0486 | 2110605.54207 | 37.7757864606069 | -122.41494837717 | (37.7757864606069, -122.41494837717) | 8 | 2 | 9 | 28853 | 34 | |
| 160778 | 215785 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 16 Agua Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 775074 | 5997502.62133 | 2098608.67839 | 37.7422363073547 | -122.451260857411 | (37.7422363073547, -122.451260857411) | 9 | 7 | 4 | 59 | 40 | |
| 94974 | 110194 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2123 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774924 | 6001844.69538 | 2115843.7088 | 37.7898071242475 | -122.437481264255 | (37.7898071242475, -122.437481264255) | 13 | 6 | 1 | 29490 | 27 | |
| 104375 | 113266 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | 1 | Permit Number 774770 | 6012949.27071 | 2090610.02044 | 37.7211459795788 | -122.397289961272 | (37.7211459795788, -122.397289961272) | 10 | 3 | 8 | 58 | 1 | ||
| 8046 | 261018 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
| 11989 | 261017 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 79 Cragmont Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774761 | 5992858 | 2101375 | 37.749564886931 | -122.467521508976 | (37.749564886931, -122.467521508976) | 1 | 8 | 4 | 29491 | 12 | |
| 147257 | 114690 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 173 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774716 | 6010597.60785 | 2093917.85298 | 37.7300973914745 | -122.405651885519 | (37.7300973914745, -122.405651885519) | 10 | 3 | 7 | 309 | 28 | ||
| 162442 | 255923 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 539 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2018 12:00:00 AM | 3 | Permit Number 774708 | 5984698.21016 | 2112191.31166 | 37.7787889555839 | -122.496535962511 | (37.7787889555839, -122.496535962511) | 11 | 6 | 2 | 55 | 26 | ||
| 110382 | 108170 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | 2 | 7 | 7 | 28859 | 2 | |
| 42871 | 108698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2922 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774622 | 5999117.98057 | 2118844.23155 | 37.7978903639015 | -122.447131431372 | (37.7978903639015, -122.447131431372) | 13 | 9 | 1 | 57 | 17 |
| 142427 | 114668 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 176X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774564 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | 2 | 7 | 7 | 28859 | 2 | |||
| 54776 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | |
| 144153 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | 4 | 2 | 10 | 28860 | 6 | ||
| 157808 | 108607 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1511 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774497 | 5999638.2 | 2107266.4 | 37.7661303401087 | -122.44449879944 | (37.7661303401087, -122.44449879944) | 15 | 5 | 5 | 29492 | 9 | |
| 165889 | 65944 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 1051 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774496 | 6007126.88528 | 2114657.80083 | 37.7868498044193 | -122.419121190999 | (37.7868498044193, -122.419121190999) | 13 | 9 | 9 | 28858 | 36 | |
| 100975 | 167561 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 435 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2018 12:00:00 AM | 3 | 4x4 | Permit Number 774490 | 6003882.17352 | 2108345.65445 | 37.7693349544628 | -122.429896723864 | (37.7693349544628, -122.429896723864) | 7 | 9 | 5 | 28862 | 3 | |
| 29415 | 108948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774439 | 6002672.3 | 2089874.6 | 37.7185491584783 | -122.432761932836 | (37.7185491584783, -122.432761932836) | 9 | 7 | 6 | 28861 | 5 |
| 181958 | 31840 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1175 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774358 | 6009887.2147 | 2110463.0079 | 37.7754869546364 | -122.40927492061 | (37.7754869546364, -122.40927492061) | 8 | 2 | 9 | 28853 | 34 | |
| 88390 | 112784 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 671 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774332 | 5992812.5 | 2110899.4 | 37.7757137554499 | -122.468371679237 | (37.7757137554499, -122.468371679237) | 11 | 6 | 2 | 54 | 11 | |||
| 168588 | 108147 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3322 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2014 12:00:00 AM | 3 | Permit Number 774253 | 6003296.86852 | 2119720.45859 | 37.800534134189 | -122.432733936524 | (37.800534134189, -122.432733936524) | 13 | 9 | 1 | 57 | 17 | ||
| 116754 | 107580 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992406.39157 | 2086830.73395 | 37.7096038592127 | -122.468025367885 | (37.7096038592127, -122.468025367885) | 9 | 8 | 4 | 64 | 24 | ||
| 153512 | 107579 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992416.91174 | 2086830.03613 | 37.7096025506984 | -122.467988957943 | (37.7096025506984, -122.467988957943) | 9 | 8 | 4 | 64 | 24 | ||
| 175627 | 107582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774090 | 5992337.55751 | 2086836.47342 | 37.7096156430274 | -122.46826368552 | (37.7096156430274, -122.46826368552) | 9 | 8 | 4 | 64 | 24 |
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) );