trees
969 rows where qSpecies_id = 97 sorted by qSiteInfo 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1151 | 199431 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.46319 | 2103845.54885 | 37.7574933220764 | -122.397885411405 | (37.7574933220764, -122.397885411405) | 10 | 3 | 8 | 28856 | 29 | ||
| 10390 | 199430 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10/16/2019 12:00:00 AM | 3 | Width 10ft | 6013045.24345 | 2103834.71473 | 37.7574635617095 | -122.397885411392 | (37.7574635617095, -122.397885411392) | 10 | 3 | 8 | 28856 | 29 | ||
| 18655 | 124424 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 7ft | 5996110.10232 | 2115455.34422 | 37.7884130822591 | -122.457294185036 | (37.7884130822591, -122.457294185036) | 11 | 6 | 1 | 54 | 31 | |||
| 24672 | 218819 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991410.90841 | 2090573.24495 | 37.7198223438984 | -122.471738457278 | (37.7198223438984, -122.471738457278) | 9 | 8 | 6 | 64 | 24 | |||
| 44755 | 124423 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 207 Cherry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5996107.97218 | 2115471.34233 | 37.78845688642 | -122.457302712744 | (37.78845688642, -122.457302712744) | 11 | 6 | 1 | 54 | 31 | |||
| 50071 | 218822 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 210 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992480.53035 | 2089289.94219 | 37.7163605349795 | -122.467947888583 | (37.7163605349795, -122.467947888583) | 9 | 8 | 6 | 64 | 24 | |||
| 71226 | 218821 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 278 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5991714.63996 | 2090365.57714 | 37.719269707816 | -122.470673455841 | (37.719269707816, -122.470673455841) | 9 | 8 | 6 | 64 | 24 | |||
| 98687 | 218805 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 67 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 5995289.12081 | 2097585.29615 | 37.73929936437 | -122.458840331911 | (37.73929936437, -122.458840331911) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | ||||
| 113933 | 218843 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 661 Rockdale Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997657.5738 | 2098142.02161 | 37.7409638520942 | -122.450691444481 | (37.7409638520942, -122.450691444481) | 9 | 7 | 4 | 59 | 40 | |||
| 149904 | 218823 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 122 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992474.68721 | 2088695.04537 | 37.7147267546141 | -122.467924839857 | (37.7147267546141, -122.467924839857) | 9 | 8 | 6 | 64 | 24 | |||
| 161624 | 218820 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 205 Beverly St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5991411.7286 | 2090565.37313 | 37.7198007772708 | -122.471735048829 | (37.7198007772708, -122.471735048829) | 9 | 8 | 6 | 64 | 24 | |||
| 184895 | 218827 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 15 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5991236.4555 | 2094303.51433 | 37.7300546412872 | -122.472613299773 | (37.7300546412872, -122.472613299773) | 9 | 8 | 4 | 64 | 40 | |||
| 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 | |||||
| 27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 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 | |||||
| 61828 | 251398 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
| 79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 91578 | 97725 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | |||
| 126290 | 251396 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
| 149080 | 251397 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 311 Townsend St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6013957 | 2110872 | 37.776837125863 | -122.395225113019 | (37.776837125863, -122.395225113019) | 6 | 2 | 9 | 28856 | 20 | ||||
| 167189 | 97724 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 8038 | 250803 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5986183.75415 | 2114029.47113 | 37.7839229338472 | -122.491532293599 | (37.7839229338472, -122.491532293599) | 11 | 6 | 1 | 55 | 33 | |||
| 32503 | 176413 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 816 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001088.39895 | 2089005.35886 | 37.7160724587542 | -122.4381745822 | (37.7160724587542, -122.4381745822) | 9 | 7 | 6 | 28861 | 5 | |||
| 37346 | 250802 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 283 31st Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5986182.86321 | 2114039.35976 | 37.7839500331106 | -122.491536104007 | (37.7839500331106, -122.491536104007) | 11 | 6 | 1 | 55 | 33 | |||
| 48982 | 176417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 825 Lisbon St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6001125.80716 | 2088973.54213 | 37.7159872246076 | -122.438043004189 | (37.7159872246076, -122.438043004189) | 9 | 7 | 6 | 28861 | 5 | |||
| 74599 | 224486 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 12 Lundys Ln | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 2ft | 6007182.48369 | 2099609.18315 | 37.7455329629926 | -122.417861705765 | (37.7455329629926, -122.417861705765) | 2 | 7 | 7 | 28859 | 2 | |||
| 117760 | 176435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 275 De Long St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 5993714.58235 | 2086792.86785 | 37.7095753489021 | -122.463501322023 | (37.7095753489021, -122.463501322023) | 9 | 8 | 6 | 28861 | 25 | |||
| 141514 | 250901 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | 11 | 6 | 1 | 55 | 33 | |||
| 165235 | 224627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5999834.58358 | 2107589.10397 | 37.7670276079639 | -122.443842736578 | (37.7670276079639, -122.443842736578) | 15 | 5 | 5 | 29492 | 9 | |||
| 181335 | 224625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50 Piedmont St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5999457.54578 | 2107020.99028 | 37.7654461969099 | -122.445105999866 | (37.7654461969099, -122.445105999866) | 15 | 5 | 5 | 29492 | 9 | |||
| 182226 | 224626 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 601 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999843.00884 | 2107568.58853 | 37.7669717582745 | -122.443812120926 | (37.7669717582745, -122.443812120926) | 15 | 5 | 5 | 29492 | 9 | |||
| 189517 | 176433 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 118 Chester Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991720.02905 | 2088438.70148 | 37.7139792884876 | -122.470514566313 | (37.7139792884876, -122.470514566313) | 9 | 8 | 6 | 64 | 24 | |||
| 10858 | 128369 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 843 California St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 4ft | 6010471.73552 | 2116514.30785 | 37.7921351227858 | -122.4076796805 | (37.7921351227858, -122.4076796805) | 5 | 1 | 10 | 28857 | 21 | |||
| 67440 | 218816 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 170 Margaret Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 4ft | 5996666.01962 | 2089250.86092 | 37.7164940402408 | -122.453478054989 | (37.7164940402408, -122.453478054989) | 9 | 8 | 6 | 28861 | 24 | |||
| 86489 | 126619 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996924.84901 | 2116015.00596 | 37.789996524161 | -122.454515752993 | (37.789996524161, -122.454515752993) | 11 | 6 | 1 | 54 | 31 | |||
| 132084 | 126621 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3616 Jackson St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5996947.82538 | 2116018.92975 | 37.7900086155661 | -122.454436540723 | (37.7900086155661, -122.454436540723) | 11 | 6 | 1 | 54 | 31 | |||
| 169776 | 218825 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 295 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 5993731.49381 | 2089150.28883 | 37.7160492409447 | -122.463613852416 | (37.7160492409447, -122.463613852416) | 9 | 8 | 6 | 64 | 24 | |||
| 374 | 5332 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6x7 | 6004849.91389 | 2107615.96816 | 37.7673861676625 | -122.426497389946 | (37.7673861676625, -122.426497389946) | 8 | 4 | 5 | 28862 | 19 | |||
| 443 | 107383 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 73 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6005896.4 | 2103362 | 37.7557648742481 | -122.422575414787 | (37.7557648742481, -122.422575414787) | 2 | 4 | 5 | 28859 | 19 | ||||
| 625 | 245416 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010170.0429 | 2102204.1541 | 37.7528258621349 | -122.407714081565 | (37.7528258621349, -122.407714081565) | 2 | 4 | 7 | 28859 | 19 | |
| 1108 | 627 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3166 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6007870.94281 | 2102116.96374 | 37.7524574855488 | -122.415658642859 | (37.7524574855488, -122.415658642859) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 1525 | 224536 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 3ft | 6007118.3907 | 2102031.54495 | 37.7521806130667 | -122.418255044036 | (37.7521806130667, -122.418255044036) | 2 | 4 | 7 | 28859 | 19 | |||
| 1590 | 130502 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999816.57477 | 2121214.69005 | 37.8044388979007 | -122.444884593948 | (37.8044388979007, -122.444884593948) | 13 | 9 | 1 | 57 | 17 | |||
| 1692 | 61474 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1960 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1984 12:00:00 AM | Permit Number 21417 | 6004396.86379546 | 2107211.14447839 | 37.7662489975602 | -122.428035576337 | (37.7662489975602, -122.428035576337) | 8 | 4 | 5 | 28862 | 3 | ||
| 2261 | 101055 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 | |||
| 2420 | 260860 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 695 Arkansas St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | 3x3 | 6013106 | 2103855 | 37.7575226440732 | -122.397676712285 | (37.7575226440732, -122.397676712285) | 10 | 3 | 8 | 28856 | 29 | ||
| 3331 | 250313 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3832 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | Permit Number 772728 | 5995868.43222 | 2115867.93469 | 37.7895320612144 | -122.458160192637 | (37.7895320612144, -122.458160192637) | 11 | 6 | 1 | 54 | 31 | ||
| 3343 | 23100 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6006427.47457 | 2101357.75439 | 37.7502916230775 | -122.420596517121 | (37.7502916230775, -122.420596517121) | 2 | 4 | 5 | 28859 | 19 | |||
| 3598 | 224504 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 995x Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007856.89018 | 2097735.38644 | 37.7404258641556 | -122.41539707591 | (37.7404258641556, -122.41539707591) | 2 | 7 | 7 | 28859 | 2 | |||
| 3882 | 224548 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3381 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007664.7835 | 2104406.99539 | 37.7587337983464 | -122.416533781209 | (37.7587337983464, -122.416533781209) | 2 | 4 | 7 | 28859 | 19 | |||
| 3917 | 224706 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007512.60917 | 2102684.32552 | 37.753995182337 | -122.416938018377 | (37.753995182337, -122.416938018377) | 2 | 4 | 7 | 28859 | 19 | |||
| 3962 | 224532 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 3ft | 6008098.46786 | 2102085.91434 | 37.7523850181574 | -122.414869623533 | (37.7523850181574, -122.414869623533) | 2 | 4 | 7 | 28859 | 19 | |||
| 4209 | 62680 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 654 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23014 | 6002561.35247931 | 2108872.24257196 | 37.7707059484007 | -122.434503031919 | (37.7707059484007, -122.434503031919) | 15 | 5 | 11 | 29492 | 9 | ||
| 4293 | 641 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007604.52296 | 2102099.47851 | 37.7523944952114 | -122.41657873113 | (37.7523944952114, -122.41657873113) | 2 | 4 | 7 | 28859 | 19 | |||
| 4358 | 224705 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3282X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | Width 3ft | 6007157.84145 | 2102080.74215 | 37.7523179179397 | -122.418122104462 | (37.7523179179397, -122.418122104462) | 2 | 4 | 7 | 28859 | 19 | |||
| 4606 | 224510 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6007627.97792 | 2102718.14058 | 37.7540945196695 | -122.416541439837 | (37.7540945196695, -122.416541439837) | 2 | 4 | 7 | 28859 | 19 | |||
| 5103 | 55566 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1120 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11535 | 6011279.28081 | 2089546.81423 | 37.7181335151377 | -122.402987921868 | (37.7181335151377, -122.402987921868) | 10 | 7 | 8 | 309 | 39 | |
| 5380 | 640 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3200 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6007574.72227 | 2102100.08892 | 37.7523944952223 | -122.416681830316 | (37.7523944952223, -122.416681830316) | 2 | 4 | 7 | 28859 | 19 | |||
| 5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 | ||
| 5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
| 5619 | 60093 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3340 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 15 | Permit Number 19594 | 5998249.44913 | 2116202.11644 | 37.7905861601801 | -122.449946261722 | (37.7905861601801, -122.449946261722) | 13 | 6 | 1 | 54 | 31 | |
| 5652 | 657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3262 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007285.35691 | 2102087.12511 | 37.7523426205157 | -122.417681586846 | (37.7523426205157, -122.417681586846) | 2 | 4 | 7 | 28859 | 19 | |||
| 5744 | 26220 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 765X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005701.2867 | 2098677.11468 | 37.7428902448864 | -122.422917229343 | (37.7428902448864, -122.422917229343) | 2 | 7 | 7 | 28859 | 2 | |||
| 5761 | 224699 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 3ft | 6007526.74961 | 2102095.67359 | 37.7523796734842 | -122.416847415286 | (37.7523796734842, -122.416847415286) | 2 | 4 | 7 | 28859 | 19 | |||
| 5816 | 130501 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1971 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999805.39025 | 2121212.90425 | 37.8044333562689 | -122.444923170372 | (37.8044333562689, -122.444923170372) | 13 | 9 | 1 | 57 | 17 | |||
| 5854 | 224657 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 900X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007803.71411 | 2097712.06394 | 37.7403588367925 | -122.415579287554 | (37.7403588367925, -122.415579287554) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 6491 | 224533 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3143 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6008085.98241 | 2102084.65077 | 37.7523808471161 | -122.41491271097 | (37.7523808471161, -122.41491271097) | 2 | 4 | 7 | 28859 | 19 | |||
| 6718 | 226469 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3001 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | |||
| 6967 | 224529 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3035 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 3ft | 6008772.64154 | 2102127.57906 | 37.7525372787939 | -122.412541157349 | (37.7525372787939, -122.412541157349) | 2 | 4 | 7 | 28859 | 19 | |||
| 7021 | 5742 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1755 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005373.18109 | 2098196.81653 | 37.741552935912 | -122.424017580443 | (37.741552935912, -122.424017580443) | 2 | 7 | 5 | 28859 | 7 | |||
| 7315 | 108963 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
| 7424 | 61750 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3235 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1984 12:00:00 AM | Permit Number 21761 | 6005283.427251 | 2106614.91851966 | 37.7646620214784 | -122.424926696656 | (37.7646620214784, -122.424926696656) | 8 | 4 | 5 | 28859 | 19 | ||
| 7426 | 218839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | 2 | Width 3ft | Permit Number 54033 | 5990579.44919 | 2099089.86589 | 37.7431586880264 | -122.475233923312 | (37.7431586880264, -122.475233923312) | 1 | 8 | 4 | 29491 | 40 | |
| 7593 | 224702 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3236 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | Width 3ft | 6007468.55757 | 2102099.56491 | 37.7523870848126 | -122.417048929078 | (37.7523870848126, -122.417048929078) | 2 | 4 | 7 | 28859 | 19 | |||
| 7669 | 101056 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 746 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008144 | 2114503 | 37.7864819845184 | -122.415591235338 | (37.7864819845184, -122.415591235338) | 13 | 1 | 9 | 28858 | 36 | |||
| 7782 | 101433 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
| 7928 | 5672 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1422 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6005185.06241 | 2100046.61651 | 37.7466214421279 | -122.424799598532 | (37.7466214421279, -122.424799598532) | 2 | 7 | 5 | 63 | 22 | |||
| 8245 | 259048 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
| 8296 | 94021 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 67 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2010 12:00:00 AM | 3x3 | Permit Number 53440 | 6007432 | 2099002 | 37.7438798129267 | -122.416955902584 | (37.7438798129267, -122.416955902584) | 2 | 7 | 7 | 28859 | 2 | ||
| 8711 | 224685 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006366.00015 | 2101408.94489 | 37.7504287157262 | -122.420812733918 | (37.7504287157262, -122.420812733918) | 2 | 4 | 5 | 28859 | 19 | |||
| 8924 | 224586 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2757 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008370.39736 | 2106782.63343 | 37.7652964112246 | -122.414261518161 | (37.7652964112246, -122.414261518161) | 8 | 4 | 7 | 28859 | 19 | |||
| 9284 | 259046 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
| 9437 | 224500 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 39 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6007142.18582 | 2099226.02061 | 37.7444786166914 | -122.417973892579 | (37.7444786166914, -122.417973892579) | 2 | 7 | 7 | 28859 | 2 | |||
| 9506 | 26517 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2883 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009010.68122 | 2101716.60139 | 37.7514221824079 | -122.411688936397 | (37.7514221824079, -122.411688936397) | 2 | 4 | 7 | 28859 | 19 | |||
| 9589 | 243519 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3283 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6007186.6119 | 2102035.21074 | 37.7521945183717 | -122.418019383909 | (37.7521945183717, -122.418019383909) | 2 | 4 | 7 | 28859 | 19 | |||
| 9655 | 587 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3045 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6008724.79045 | 2102125.26547 | 37.7525282406021 | -122.412706471622 | (37.7525282406021, -122.412706471622) | 2 | 4 | 7 | 28859 | 19 | |||
| 10092 | 224526 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 173 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006718.37785 | 2102818.25251 | 37.7543182071448 | -122.419694167076 | (37.7543182071448, -122.419694167076) | 2 | 4 | 7 | 28859 | 19 | |||
| 10134 | 224679 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 904 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6007366.73942 | 2101988.35955 | 37.7520760119996 | -122.417393153575 | (37.7520760119996, -122.417393153575) | 2 | 4 | 7 | 28859 | 19 | |||
| 10424 | 259047 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1x Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007165 | 2109609 | 37.7729891632586 | -122.418631158564 | (37.7729891632586, -122.418631158564) | 8 | 2 | 9 | 28853 | 19 | ||||
| 10493 | 59647 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1987 12:00:00 AM | 6x9 | Permit Number 24228 | 6003848.70238053 | 2108788.55742661 | 37.7705491626589 | -122.43004409806 | (37.7705491626589, -122.43004409806) | 7 | 9 | 11 | 29492 | 10 | |
| 11115 | 580 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3013 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 782763 | 6008848.9981 | 2102129.16474 | 37.7525459176681 | -122.412277214445 | (37.7525459176681, -122.412277214445) | 2 | 4 | 7 | 28859 | 19 | ||
| 11332 | 55316 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1125 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1972 12:00:00 AM | 14 | 3x3 | Permit Number 11245 | 6011314.64048 | 2089535.2445 | 37.7181037214869 | -122.402864884726 | (37.7181037214869, -122.402864884726) | 10 | 7 | 8 | 309 | 39 | |
| 11351 | 78716 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 412 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6008662.0794 | 2088043.12802 | 37.7138582091656 | -122.411928294567 | (37.7138582091656, -122.411928294567) | 9 | 7 | 8 | 309 | 39 | |||
| 11585 | 224534 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3175 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6007849.05039 | 2102074.8141 | 37.752340521521 | -122.415731366506 | (37.752340521521, -122.415731366506) | 2 | 4 | 7 | 28859 | 19 | |||
| 11588 | 224634 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 248 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6006846.03495 | 2097621.06949 | 37.740055107862 | -122.418884118001 | (37.740055107862, -122.418884118001) | 2 | 7 | 7 | 28859 | 2 | |||
| 11640 | 245417 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2761 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010192.4103 | 2102204.1541 | 37.7528271142349 | -122.407636730621 | (37.7528271142349, -122.407636730621) | 2 | 4 | 7 | 28859 | 19 |
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) );