trees
76 rows where SiteOrder = 3 and qSpecies_id = 97 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
143730 | 114807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
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 | ||||
23930 | 15770 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 4770 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3X3 | 6001421.7162 | 2091049.3752 | 37.7217038208164 | -122.437168746584 | (37.7217038208164, -122.437168746584) | 9 | 7 | 6 | 28861 | 25 | ||
107274 | 24448 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1156 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006348.61536 | 2102840.94797 | 37.7543596874688 | -122.420974512988 | (37.7543596874688, -122.420974512988) | 2 | 4 | 5 | 28859 | 19 | |||
120742 | 26003 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6014451.27252 | 2095887.995 | 37.7357217425631 | -122.39246692502 | (37.7357217425631, -122.39246692502) | 10 | 3 | 8 | 58 | 1 | |||
126791 | 23101 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1406 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6006426.26721 | 2101342.93585 | 37.7502508667074 | -122.420599640465 | (37.7502508667074, -122.420599640465) | 2 | 4 | 5 | 28859 | 19 | |||
147724 | 5576 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1040 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005062.54747 | 2102282.8606 | 37.7527547312707 | -122.425382354736 | (37.7527547312707, -122.425382354736) | 2 | 4 | 5 | 28862 | 22 | |||
178512 | 115027 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1009 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x10 | 6011058 | 2110680 | 37.7761482889947 | -122.405240157274 | (37.7761482889947, -122.405240157274) | 14 | 2 | 9 | 28853 | 34 | ||||
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 | ||
23293 | 101516 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 610 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 28301 | 6008387 | 2114552 | 37.7866301828456 | -122.414753982265 | (37.7866301828456, -122.414753982265) | 5 | 1 | 10 | 28858 | 36 | ||
39671 | 97123 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3305 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 24053 | 6008171 | 2104436 | 37.7588418942892 | -122.414785099498 | (37.7588418942892, -122.414785099498) | 2 | 4 | 7 | 28859 | 19 | ||
49450 | 111387 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 469 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014036 | 2112699 | 37.7818580461792 | -122.395079826315 | (37.7818580461792, -122.395079826315) | 6 | 2 | 9 | 28856 | 6 | ||||
56711 | 100477 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 340 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 781547 | 6009834.90147 | 2114634.4517 | 37.7869378210564 | -122.409750394691 | (37.7869378210564, -122.409750394691) | 5 | 10 | 10 | 28852 | 36 | ||
57245 | 99116 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 1200x KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011163 | 2119066 | 37.7991801253013 | -122.405467672307 | (37.7991801253013, -122.405467672307) | 3 | 1 | 10 | 308 | 23 | ||||
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 | ||||
62588 | 114016 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 800x ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009320 | 2104474 | 37.7590107259363 | -122.410813992367 | (37.7590107259363, -122.410813992367) | 2 | 4 | 7 | 28859 | 19 | ||||
100814 | 104423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 3x3 | Permit Number 24809 | 6002031 | 2107070 | 37.7657273142687 | -122.436208531898 | (37.7657273142687, -122.436208531898) | 15 | 5 | 5 | 28862 | 3 | |
104186 | 83711 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | 15 | 4 | 5 | 28862 | 3 | ||
122240 | 101428 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 3 | 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 | ||||
124391 | 116390 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2701 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008575.9 | 2106772.6 | 37.7652804030783 | -122.413550020856 | (37.7652804030783, -122.413550020856) | 8 | 4 | 7 | 28859 | 19 | ||||
154697 | 113877 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
170940 | 98987 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 847 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009438.4 | 2115684 | 37.7897973999496 | -122.411196371815 | (37.7897973999496, -122.411196371815) | 5 | 1 | 10 | 28857 | 21 | ||||
80081 | 655 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3255X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 06/02/1992 12:00:00 AM | 12 | 3x4 | 6007319.73993 | 2102042.10408 | 37.7522209377659 | -122.417559493969 | (37.7522209377659, -122.417559493969) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |
164240 | 96965 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3686 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x4 | Permit Number 23795 | 6005734 | 2104335 | 37.758427342075 | -122.423206207432 | (37.758427342075, -122.423206207432) | 2 | 4 | 5 | 28859 | 19 | ||
182596 | 64939 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.59823 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | 13 | 9 | 1 | 57 | 17 | |
95218 | 103153 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
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 | ||
69802 | 111611 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 301x Ward St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 9x3 | 6011211.14629 | 2089627.82993 | 37.7183521627878 | -122.403229130826 | (37.7183521627878, -122.403229130826) | 10 | 7 | 8 | 309 | 39 | |||
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 | |||
41384 | 176403 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 332 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998770.03746 | 2087851.68696 | 37.7127726114513 | -122.446104973962 | (37.7127726114513, -122.446104973962) | 9 | 7 | 6 | 28861 | 25 | |||
76333 | 224613 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 525 Burnett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999489.63243 | 2102445.23523 | 37.7528841365055 | -122.44466610455 | (37.7528841365055, -122.44466610455) | 2 | 5 | 5 | 63 | 38 | |||
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 | |||
17320 | 226492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2300 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008774.11165 | 2104928.66815 | 37.7602285174483 | -122.412734081726 | (37.7602285174483, -122.412734081726) | 2 | 4 | 7 | 28859 | 19 | |||
24232 | 218833 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1550 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991183.94041 | 2098426.02106 | 37.7413709589947 | -122.473095372371 | (37.7413709589947, -122.473095372371) | 1 | 8 | 4 | 29491 | 40 | |||
31557 | 199435 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1711 Oakdale Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6014455.52547 | 2095885.24717 | 37.735714433762 | -122.392452028664 | (37.735714433762, -122.392452028664) | 10 | 3 | 8 | 58 | 1 | |||
37042 | 224690 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3514 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006361.82473 | 2101451.21677 | 37.750544549297 | -122.420830173598 | (37.750544549297, -122.420830173598) | 2 | 4 | 5 | 28859 | 19 | |||
42243 | 226471 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3101 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008696.07449 | 2105092.67763 | 37.760674469666 | -122.413015573106 | (37.760674469666, -122.413015573106) | 2 | 4 | 7 | 28859 | 19 | |||
43800 | 218814 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 317 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995878.65108 | 2088143.05914 | 37.7134071101336 | -122.456119525718 | (37.7134071101336, -122.456119525718) | 9 | 8 | 6 | 28861 | 24 | |||
62941 | 224711 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3287 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006422.59039 | 2103751.13112 | 37.7568630097384 | -122.420783300913 | (37.7568630097384, -122.420783300913) | 2 | 4 | 7 | 28859 | 19 | |||
71622 | 224643 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 7 Heyman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6006383.19422 | 2098395.08711 | 37.742154314365 | -122.420539363423 | (37.742154314365, -122.420539363423) | 2 | 7 | 7 | 28859 | 2 | |||
77806 | 224686 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3513 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006380.82201 | 2101410.31464 | 37.7504333121586 | -122.420761575992 | (37.7504333121586, -122.420761575992) | 2 | 4 | 5 | 28859 | 19 | |||
80807 | 224710 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3278 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006579.99639 | 2103217.61904 | 37.755406979455 | -122.420201068142 | (37.755406979455, -122.420201068142) | 2 | 4 | 7 | 28859 | 19 | |||
95838 | 226485 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3120 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6008502.54321 | 2105665.76145 | 37.7622371604259 | -122.41372544939 | (37.7622371604259, -122.41372544939) | 8 | 4 | 7 | 28859 | 19 | |||
95847 | 251013 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3828 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995926.37639 | 2115877.04966 | 37.78956041774 | -122.457960373191 | (37.78956041774, -122.457960373191) | 11 | 6 | 1 | 54 | 31 | |||
97958 | 224539 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2925 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008666.00775 | 2103876.41315 | 37.7573331968792 | -122.413033560461 | (37.7573331968792, -122.413033560461) | 2 | 4 | 7 | 28859 | 19 | |||
102851 | 176422 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 538 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009782.31983 | 2092607.20943 | 37.7264530165924 | -122.408378041837 | (37.7264530165924, -122.408378041837) | 10 | 3 | 7 | 309 | 28 | |||
137273 | 249546 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 3 | : | Tree | Private 2 | 17 | Width 3ft | 6006094.99565 | 2114034.77585 | 37.7850809674618 | -122.422647004665 | (37.7850809674618, -122.422647004665) | 13 | 9 | 11 | 28858 | 41 | |||
138926 | 224670 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 800 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009345.18768 | 2104440.47189 | 37.758920077605 | -122.410724513327 | (37.758920077605, -122.410724513327) | 2 | 4 | 7 | 28859 | 19 | |||
144639 | 224515 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 439 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007854.81877 | 2105216.20423 | 37.7609663850986 | -122.415933853387 | (37.7609663850986, -122.415933853387) | 2 | 4 | 7 | 28859 | 19 | |||
153563 | 224567 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007896.19994 | 2105583.80933 | 37.7619780702545 | -122.415816764337 | (37.7619780702545, -122.415816764337) | 2 | 4 | 7 | 28859 | 19 | |||
159096 | 224524 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 145 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006710.95301 | 2102956.09091 | 37.754696261449 | -122.419729623734 | (37.754696261449, -122.419729623734) | 2 | 4 | 7 | 28859 | 19 | |||
167771 | 226488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2498 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6008832.88031 | 2103985.45214 | 37.7576419593387 | -122.41246415471 | (37.7576419593387, -122.41246415471) | 2 | 4 | 7 | 28859 | 19 | |||
177687 | 224701 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3230 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 3ft | 6007503.74003 | 2102097.04469 | 37.7523821439458 | -122.416927083514 | (37.7523821439458, -122.416927083514) | 2 | 4 | 7 | 28859 | 19 | |||
194356 | 224589 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008256.05874 | 2106775.28704 | 37.7652698164603 | -122.414656469826 | (37.7652698164603, -122.414656469826) | 8 | 4 | 7 | 28859 | 19 | |||
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 | |||
35053 | 224682 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1390 Valencia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006417.42588 | 2101484.35178 | 37.7506386642487 | -122.420640252069 | (37.7506386642487, -122.420640252069) | 2 | 4 | 5 | 28859 | 19 | |||
51462 | 218829 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 833 Rivera St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5990502.9727 | 2100388.60646 | 37.746720259628 | -122.475593168284 | (37.746720259628, -122.475593168284) | 1 | 8 | 4 | 29491 | 40 | |||
92825 | 224507 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2225 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008190.11914 | 2105143.75528 | 37.760786302162 | -122.414769064951 | (37.760786302162, -122.414769064951) | 2 | 4 | 7 | 28859 | 19 | |||
58923 | 226481 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 3235 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007993.23947 | 2105048.90017 | 37.7605147878543 | -122.415443270504 | (37.7605147878543, -122.415443270504) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
57949 | 126628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 50x Washington St | 3 | Median : Yard | Tree | DPW 1 | 15 | Width 8ft | 6013814.15262 | 2118039.92484 | 37.7965106447043 | -122.396221758237 | (37.7965106447043, -122.396221758237) | 3 | 1 | 10 | 28860 | 6 |
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) );