969 rows where qSpecies_id = 97

View and edit SQL

Suggested facets: SiteOrder, qCareAssistant, Fire Prevention Districts, Supervisor Districts

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)
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
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
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
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
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
5167 126631 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50x Washington St 7 Median : Yard Tree DPW 1     15 Width 8ft   6013670.6132 2118002.84349 37.796400840179 -122.39671583859 (37.796400840179, -122.39671583859) 3 1 10 28860 6
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
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
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
10260 261386 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 31 Abbey St 1 Front Yard : Yard Tree Private 2       3x3   6004642 2106187 37.7634508076606 -122.427114742536 (37.7634508076606, -122.427114742536) 8 4 5 28862 3
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
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
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
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
11707 224712 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3560 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6006570.05679 2104384.71114 37.7586109842303 -122.420318274095 (37.7586109842303, -122.420318274095) 2 4 7 28859 19
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
12747 65465 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 618 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28343 5994991.49008264 2091257.73775868 37.7219083154277 -122.459411273619 (37.7219083154277, -122.459411273619) 9 8 4 28861 24
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
13271 551 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2900 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009445.64374 2102206.22318 37.7527909649347 -122.41021934346 (37.7527909649347, -122.41021934346) 2 4 7 28859 19
13355 62304 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2504 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/1985 12:00:00 AM     Permit Number 22442 5997225.79467532 2110840.29768365 37.7758053966105 -122.453100806219 (37.7758053966105, -122.453100806219) 15 6 2 54 16
13405 245415 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2761 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 4x4 Permit Number 780031 6010145.3814 2102202.4336 37.752819757444 -122.407799244655 (37.752819757444, -122.407799244655) 2 4 7 28859 19
13648 224656 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 998X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6007860.71313 2097707.80133 37.7403503364023 -122.415381905247 (37.7403503364023, -122.415381905247) 2 7 7 28859 2
13764 224696 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3166 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6007892.65304 2102118.31873 37.7524624264182 -122.415583660969 (37.7524624264182, -122.415583660969) 2 4 7 28859 19
15344 65541 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2146 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/20/1990 12:00:00 AM     Permit Number 28438 6002328.18536025 2114391.9672646 37.78584848917 -122.435704529297 (37.78584848917, -122.435704529297) 13 6 1 29490 27
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                    
15629 66830 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 393 Douglass St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1991 12:00:00 AM     Permit Number 30127 6001175.80343985 2104102.01378806 37.7575293253254 -122.438953746382 (37.7575293253254, -122.438953746382) 2 4 5 28862 3
15856 224535 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3195 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6007823.33257 2102073.06201 37.7523342649139 -122.415820179079 (37.7523342649139, -122.415820179079) 2 4 7 28859 19
15993 226468 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3001 20th St 2 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
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
16341 224695 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3034 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     22 Width 3ft   6008772.76102 2102170.48787 37.7526551034509 -122.412543777077 (37.7526551034509, -122.412543777077) 2 4 7 28859 19
16426 224652 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 50 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6007400.92537 2098998.39155 37.7438681568958 -122.417063096086 (37.7438681568958, -122.417063096086) 2 7 7 28859 2
16785 224704 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3282 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6007185.41243 2102081.52674 37.7523216240474 -122.418026814981 (37.7523216240474, -122.418026814981) 2 4 7 28859 19
17311 61740 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 219 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1984 12:00:00 AM     Permit Number 21745 6003738.99947337 2100964.64707663 37.7490603587459 -122.429865402911 (37.7490603587459, -122.429865402911) 2 4 5 28862 22
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
17568 60045 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 235 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1986 12:00:00 AM     Permit Number 22998 6003601.05151902 2109138.05302848 37.7714947633279 -122.430925670981 (37.7714947633279, -122.430925670981) 15 9 11 29492 10
17586 224621 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1321 Clayton St 1 : Tree Private 2     13 Width 3ft   5999027.25079 2105080.82131 37.7600944087555 -122.446454694245 (37.7600944087555, -122.446454694245) 15 5 5 28862 12
17850 60829 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 82 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/1983 12:00:00 AM     Permit Number 20508 6004586.81845905 2101649.91280729 37.7509899147675 -122.426982435992 (37.7509899147675, -122.426982435992) 2 4 5 28862 22
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
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
18680 262301 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 2117 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000330 2116040 37.7902598573453 -122.44273605224 (37.7902598573453, -122.44273605224) 13 6 1 29490 27
18694 255585 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 141 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2105290 37.7611036239675 -122.419957321446 (37.7611036239675, -122.419957321446) 2 4 7 28859 19
19051 224694 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3024 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 3ft   6008827.83828 2102168.91217 37.7526538678042 -122.412353198162 (37.7526538678042, -122.412353198162) 2 4 7 28859 19
19308 64963 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1701 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1989 12:00:00 AM     Permit Number 25998 6004752.02742796 2119466.94279483 37.7999204646826 -122.427680422256 (37.7999204646826, -122.427680422256) 13 9 1 57 17
19765 224602 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3344 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6006035.96544 2103769.71631 37.756892241295 -122.422121716065 (37.756892241295, -122.422121716065) 2 4 5 28859 19
19928 176429 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 246 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009787.6259 2087905.19547 37.7135425579218 -122.4080282487 (37.7135425579218, -122.4080282487) 9 7 8 309 39

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);