trees
730 rows where qCareAssistant = "" and qSpecies_id = 97 sorted by PlotSize
This data as json, CSV (advanced)
These facets timed out: qCareAssistant
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1390 | 33763 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
| 3099 | 104652 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 953 Indiana St | 1 | Front Yard : Cutout | Tree | Private 2 | 6015057.1 | 2104275.7 | 37.7587862506702 | -122.390958369803 | (37.7587862506702, -122.390958369803) | 10 | 3 | 8 | 28856 | 29 | |||||
| 6180 | 33653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
| 6344 | 33663 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.8782552 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | 7 | 9 | 11 | 28852 | 10 | |||
| 11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
| 12949 | 59480 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3326 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | 13 | Permit Number 18850 | 5998315.87391 | 2116208.53382 | 37.7906075811119 | -122.449716899529 | (37.7906075811119, -122.449716899529) | 13 | 6 | 1 | 54 | 31 | ||
| 15539 | 37970 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 602 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/1998 12:00:00 AM | Permit Number 40200 | |||||||||||||
| 16046 | 99287 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
| 18380 | 65586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1779 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Permit Number 28486 | 6014089.25997 | 2096159.17746 | 37.7364462435881 | -122.393737527685 | (37.7364462435881, -122.393737527685) | 10 | 3 | 8 | 58 | 1 | ||
| 21188 | 34146 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 22488 | 98718 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1500@Polk Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||||
| 23053 | 48044 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 23581 | 31969 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 470 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1995 12:00:00 AM | Permit Number 35370 | 6009517.59351868 | 2092163.53246737 | 37.7252199449059 | -122.409261897755 | (37.7252199449059, -122.409261897755) | 9 | 3 | 7 | 309 | 28 | |||
| 26097 | 53744 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37696 | 6007052.84530249 | 2097996.95756942 | 37.7410988557538 | -122.41819569379 | (37.7410988557538, -122.41819569379) | 2 | 7 | 7 | 28859 | 2 | |||
| 26673 | 48040 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 26889 | 54520 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 836 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1972 12:00:00 AM | Permit Number 11498 | 5993201.36132572 | 2106658.05231245 | 37.7640905954535 | -122.466718145476 | (37.7640905954535, -122.466718145476) | 11 | 8 | 11 | 56 | 12 | |||
| 27124 | 33817 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
| 28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
| 30326 | 99286 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2839 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6000564.2 | 2116779 | 37.7923023065947 | -122.44197880494 | (37.7923023065947, -122.44197880494) | 13 | 6 | 1 | 29490 | 27 | |||||
| 30353 | 105684 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 1 | Front Yard : Pot | Tree | Private 2 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
| 31415 | 34159 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 33251 | 105685 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 2 | Front Yard : Pot | Tree | Private 2 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
| 36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
| 36236 | 48046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 36246 | 32868 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601705 | -122.430300092251 | (37.736503601705, -122.430300092251) | 2 | 7 | 5 | 63 | 7 | |||
| 36413 | 33765 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
| 36758 | 61440 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2660 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1984 12:00:00 AM | 14 | Permit Number 21375 | 6000247.84617 | 2118544.37503 | 37.7971315285518 | -122.443200241996 | (37.7971315285518, -122.443200241996) | 13 | 9 | 1 | 57 | 17 | ||
| 37424 | 48789 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 38079 | 53067 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | 13 | 6 | 11 | 29490 | 13 | |||
| 39551 | 39879 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 40283 | 30534 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
| 40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
| 41504 | 33816 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1201 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1997 12:00:00 AM | Permit Number 37831 | 6008598.80477101 | 2116262.85239853 | 37.7913396656633 | -122.414142270961 | (37.7913396656633, -122.414142270961) | 5 | 1 | 10 | 28858 | 21 | |||
| 41759 | 30892 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
| 41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
| 42809 | 33580 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 161 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37688 | 6007154.09999929 | 2098074.89925627 | 37.7413185651373 | -122.417851114389 | (37.7413185651373, -122.417851114389) | 2 | 7 | 7 | 28859 | 2 | |||
| 45618 | 30532 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
| 46698 | 58912 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.65083 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | 13 | 9 | 1 | 57 | 17 | ||
| 46822 | 34158 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 49127 | 34147 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 50226 | 48785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 53369 | 67032 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012868.03417039 | 2116855.7141363 | 37.7932063935721 | -122.399412377848 | (37.7932063935721, -122.399412377848) | 4 | 1 | 10 | 28860 | 6 | |||
| 57306 | 52859 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
| 58028 | 48791 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1405 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2002 12:00:00 AM | Permit Number 46040 | 6008874.44924411 | 2117680.29283989 | 37.7952470886304 | -122.413288823995 | (37.7952470886304, -122.413288823995) | 5 | 1 | 10 | 308 | 21 | |||
| 60189 | 34157 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 60674 | 30533 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1020 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | Permit Number 34535 | 6011195.92412392 | 2110919.1949505 | 37.77681277294 | -122.404779881684 | (37.77681277294, -122.404779881684) | 14 | 2 | 9 | 28853 | 34 | |||
| 64627 | 34152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 66528 | 115675 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 650 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5988846.1 | 2110886.2 | 37.7754476168018 | -122.482091316315 | (37.7754476168018, -122.482091316315) | 11 | 6 | 2 | 55 | 26 | |||||
| 68365 | 98237 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 3 | 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 | ||||
| 74295 | 97191 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
| 76052 | 48037 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 77928 | 55379 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1236 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/1972 12:00:00 AM | Permit Number 11316 | 5993330.37884563 | 2107053.53607455 | 37.7651839347095 | -122.466300659155 | (37.7651839347095, -122.466300659155) | 11 | 8 | 11 | 56 | 12 | |||
| 78518 | 66628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 412 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 16 | Permit Number 29832 | 6002951.53686 | 2091458.2652 | 37.7229133848294 | -122.431909745644 | (37.7229133848294, -122.431909745644) | 9 | 7 | 6 | 28861 | 5 | ||
| 78943 | 33764 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1580 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1996 12:00:00 AM | Permit Number 37815 | 6007223.30298499 | 2109757.94023834 | 37.7734013999863 | -122.418440043785 | (37.7734013999863, -122.418440043785) | 8 | 2 | 9 | 28853 | 19 | |||
| 81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
| 82252 | 48042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 83177 | 34155 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 83507 | 98238 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1299X 09th Ave | 4 | 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 | ||||
| 86785 | 47045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 111 Maiden Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45035 | 6011125.92683466 | 2115044.13243826 | 37.7881349707775 | -122.405312579096 | (37.7881349707775, -122.405312579096) | 5 | 1 | 10 | 28857 | 6 | |||
| 87294 | 99016 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1133 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 29980 | 6008997 | 2116859 | 37.7929988993441 | -122.41280668477 | (37.7929988993441, -122.41280668477) | 5 | 1 | 10 | 28857 | 21 | ||||
| 91045 | 58152 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 806 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17136 | 6001116.27875 | 2089048.95657 | 37.7161937539141 | -122.438081337797 | (37.7161937539141, -122.438081337797) | 9 | 7 | 6 | 28861 | 5 | ||
| 91227 | 40081 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 22 Rossi Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41303 | 5996321.69068784 | 2112123.86441597 | 37.7792778762225 | -122.456321143761 | (37.7792778762225, -122.456321143761) | 11 | 6 | 2 | 54 | 16 | ||||
| 91974 | 64063 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1421 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1988 12:00:00 AM | Permit Number 25296 | 6010151.38612308 | 2118964.80181049 | 37.7988456450066 | -122.408961074202 | (37.7988456450066, -122.408961074202) | 3 | 1 | 10 | 308 | 4 | |||
| 92219 | 33508 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37603 | 6006396.09682229 | 2098460.33665401 | 37.7423342020889 | -122.420499380726 | (37.7423342020889, -122.420499380726) | 2 | 7 | 7 | 28859 | 2 | |||
| 92709 | 97190 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
| 93302 | 97189 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 255 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | Permit Number 767841 | 6012839.6 | 2116825.7 | 37.7931223970079 | -122.399508654361 | (37.7931223970079, -122.399508654361) | 4 | 1 | 10 | 28860 | 6 | |||
| 94866 | 30886 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1440 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34718 | 6011020.35277298 | 2119822.53522602 | 37.8012494094877 | -122.406014607975 | (37.8012494094877, -122.406014607975) | 3 | 1 | 10 | 308 | 23 | ||||
| 95322 | 39878 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 301 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1999 12:00:00 AM | Permit Number 41173 | 6015620.67363669 | 2114221.43610992 | 37.786126305998 | -122.389703911477 | (37.786126305998, -122.389703911477) | 6 | 2 | 9 | 28855 | 6 | |||
| 97902 | 48043 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 98693 | 218808 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 379 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998237.66884 | 2094066.68072 | 37.7298071263007 | -122.448392288972 | (37.7298071263007, -122.448392288972) | 9 | 7 | 4 | 28861 | 40 | ||||
| 100913 | 58155 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 815 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 11 | Permit Number 17139 | 6001141.03185 | 2088999.49301 | 37.7160593457428 | -122.437992238373 | (37.7160593457428, -122.437992238373) | 9 | 7 | 6 | 28861 | 5 | ||
| 101840 | 34156 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 104901 | 104050 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 145X Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012363 | 2119165 | 37.7995189786281 | -122.401322196982 | (37.7995189786281, -122.401322196982) | 3 | 1 | 10 | 28860 | 6 | |||||
| 104976 | 36098 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 on 16th Street Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39198 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | 8 | 4 | 5 | 28859 | 19 | |||
| 107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
| 108948 | 30891 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
| 108990 | 34150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 115554 | 33588 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/1996 12:00:00 AM | Permit Number 37695 | 6007041.74280393 | 2097976.42291715 | 37.741041847234 | -122.418232626766 | (37.741041847234, -122.418232626766) | 2 | 7 | 7 | 28859 | 2 | |||
| 115580 | 36099 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 299 on 16th Dolores St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39198 | 6004891.74541508 | 2106619.46330166 | 37.7646523685012 | -122.426281744676 | (37.7646523685012, -122.426281744676) | 8 | 4 | 5 | 28859 | 19 | |||
| 118167 | 33695 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | 7 | 9 | 11 | 28852 | 10 | |||
| 123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
| 126375 | 48039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 126873 | 33585 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 220 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37693 | 6006929.36931778 | 2097797.05936052 | 37.7405430288873 | -122.418608458082 | (37.7405430288873, -122.418608458082) | 2 | 7 | 7 | 28859 | 2 | |||
| 127886 | 34148 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 129041 | 33581 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 159 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37689 | 6007159.65124857 | 2098085.1665824 | 37.7413470693377 | -122.417832647693 | (37.7413470693377, -122.417832647693) | 2 | 7 | 7 | 28859 | 2 | |||
| 129401 | 34154 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 131345 | 58153 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1978 12:00:00 AM | 2 | Permit Number 17137 | 6001098.08865 | 2089024.55935 | 37.7161257300936 | -122.438142464699 | (37.7161257300936, -122.438142464699) | 9 | 7 | 6 | 28861 | 5 | ||
| 131588 | 34153 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 30 Steuart St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | Permit Number 37992 | 6014341.06792841 | 2117132.86353937 | 37.7940493718531 | -122.394334961669 | (37.7940493718531, -122.394334961669) | 12 | 2 | 9 | 28855 | 6 | |||
| 132088 | 33651 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
| 133084 | 52857 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2260on VALLEJO Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2006 12:00:00 AM | Permit Number 48866 | 6005979.18116248 | 2118139.38977425 | 37.7963446783328 | -122.423339577445 | (37.7963446783328, -122.423339577445) | 13 | 9 | 10 | 28858 | 32 | |||
| 135538 | 34978 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.7603911107583 | -122.433757281047 | (37.7603911107583, -122.433757281047) | 2 | 4 | 5 | 28862 | 3 | |||
| 137498 | 62505 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1986 12:00:00 AM | 15 | Permit Number 22680 | 6000887.29767 | 2089194.58306 | 37.7165805865148 | -122.438883234479 | (37.7165805865148, -122.438883234479) | 9 | 7 | 6 | 28861 | 5 | ||
| 140651 | 48045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3350 Mission St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2002 12:00:00 AM | Permit Number 45759 | 6006080.4837518 | 2098740.43590211 | 37.7430854999808 | -122.42161056574 | (37.7430854999808, -122.42161056574) | 2 | 7 | 7 | 28859 | 2 | |||
| 141932 | 41283 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3948 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2000 12:00:00 AM | 0 | Permit Number 41961 | 5981803.95386186 | 2102184.90266006 | 37.7511442517842 | -122.505806132064 | (37.7511442517842, -122.505806132064) | 1 | 8 | 3 | 56 | 35 | ||
| 143284 | 32039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.8035619867255 | -122.433520856524 | (37.8035619867255, -122.433520856524) | 13 | 9 | 1 | 57 | 17 | |||
| 143659 | 33610 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
| 145638 | 105686 | Property Tree 8 | Ficus microcarpa :: Chinese Banyan 97 | 635 08TH ST | 3 | Front Yard : Pot | Tree | Private 2 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.403881727597 | (37.7718243537934, -122.403881727597) | 14 | 2 | 9 | 28853 | 34 | ||||
| 148185 | 33613 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.427225555933 | (37.7740225856392, -122.427225555933) | 7 | 9 | 11 | 28852 | 10 | |||
| 150139 | 31210 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2736 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34902 | 6001624.16755345 | 2117801.03750222 | 37.7951689006516 | -122.438384556872 | (37.7951689006516, -122.438384556872) | 13 | 9 | 1 | 57 | 27 | |||
| 150898 | 54789 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 271 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1972 12:00:00 AM | 21 | Permit Number 10638 | 6012677.12996 | 2087211.64652 | 37.7117995683772 | -122.39799240103 | (37.7117995683772, -122.39799240103) | 10 | 3 | 8 | 309 | 1 |
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) );