969 rows where qSpecies_id = 97 sorted by Fire Prevention Districts

View and edit SQL

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)
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                    
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
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
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
28762 218828 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 831 Rivera St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5990524.89237 2100389.62216 37.7467243191683 -122.475517447198 (37.7467243191683, -122.475517447198) 1 8 4 29491 40
34968 258294 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2498X 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991168 2098442 37.7414139101312 -122.473151653247 (37.7414139101312, -122.473151653247) 1 8 4 29491 40
37941 184315 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1557 39th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5984032.5928 2104430.6415 37.7574413473895 -122.498265228241 (37.7574413473895, -122.498265228241) 1 8 3 56 35
40301 218803 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2370 Funston Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5992349.88043 2099344.31841 37.7439598068059 -122.469130812732 (37.7439598068059, -122.469130812732) 1 8 4 29491 40
42835 218840 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 18 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992943.37066 2098991.78527 37.7430261153754 -122.467053051482 (37.7430261153754, -122.467053051482) 1 8 4 59 40
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
54947 63166 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1534 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23703 5992780.43210356 2105015.68842996 37.7595567946867 -122.468054529997 (37.7595567946867, -122.468054529997) 1 8 4 56 12
55197 60152 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1790 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19683 5990948.80079989 2103226.18449464 37.7545373426794 -122.474258577533 (37.7545373426794, -122.474258577533) 1 8 4 56 12
57590 218841 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1522 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5994017.40797 2105128.44374 37.7599377495509 -122.463784669644 (37.7599377495509, -122.463784669644) 1 5 4 56 12
73159 218834 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 Ulloa St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991139.93283 2098423.38649 37.7413611770786 -122.473247341618 (37.7413611770786, -122.473247341618) 1 8 4 29491 40
77132 184317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1557 39th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5984033.1876 2104377.9194 37.7572966221146 -122.498259277429 (37.7572966221146, -122.498259277429) 1 8 3 56 35
107613 258293 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2498X 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991168 2098442 37.7414139101312 -122.473151653247 (37.7414139101312, -122.473151653247) 1 8 4 29491 40
114822 97313 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 926 Taraval St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/19/1984 12:00:00 AM   3x3   5990372 2099065 37.7430783865792 -122.475949404311 (37.7430783865792, -122.475949404311) 1 8 3 29491 35
120941 218832 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 Ulloa St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991196.18997 2098425.25378 37.7413695614616 -122.473052962144 (37.7413695614616, -122.473052962144) 1 8 4 29491 40
129256 98025 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 1633 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988173 2098960 37.7426623364986 -122.483545164432 (37.7426623364986, -122.483545164432) 1 8 3 29491 35
133330 218838 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 723 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990942.64769 2099036.77615 37.74303396195 -122.473974219529 (37.74303396195, -122.473974219529) 1 8 4 29491 40
135076 218835 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991107.25372 2098449.01305 37.7414296487733 -122.473362202106 (37.7414296487733, -122.473362202106) 1 8 4 29491 40
135351 218830 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 833 Rivera St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5990479.90891 2100386.13678 37.7467121414596 -122.475672739417 (37.7467121414596, -122.475672739417) 1 8 4 29491 40
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
145876 218802 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2370 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5992350.84884 2099324.20257 37.7439046297971 -122.46912600049 (37.7439046297971, -122.46912600049) 1 8 4 29491 40
163838 218836 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991107.22907 2098459.95547 37.7414596924238 -122.473363085249 (37.7414596924238, -122.473363085249) 1 8 4 29491 40
182989 218837 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 725 Taraval St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5990923.73813 2099033.65671 37.7430243014348 -122.474039375442 (37.7430243014348, -122.474039375442) 1 8 4 29491 40
184346 218831 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1550 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991205.91202 2098425.81226 37.7413716577778 -122.473019387736 (37.7413716577778, -122.473019387736) 1 8 4 29491 40
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
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
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
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
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
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
23203 6798 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1375 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x9   6016915.23611 2097187.56543 37.7394266247399 -122.384038431137 (37.7394266247399, -122.384038431137) 10 3 8 58 1
25718 176421 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6013003.58559 2086544.76512 37.7099866196603 -122.396817348641 (37.7099866196603, -122.396817348641) 10 3 8 309 1
30016 199432 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1400 Newhall St 1 : Tree Private 2     7 Width 3ft   6014474.33722 2095838.07196 37.7355859449403 -122.39238369005 (37.7355859449403, -122.39238369005) 10 3 8 58 1
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
36749 122752 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18     6011278.80569 2105286.3398 37.7613508668666 -122.404096651066 (37.7613508668666, -122.404096651066) 10 3 8 28856 29
37053 176425 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011982.06755 2090001.33634 37.7194207606357 -122.400590586484 (37.7194207606357, -122.400590586484) 10 7 8 309 28
39200 111610 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 9x3   6011193.26322 2089621.79675 37.7183345981422 -122.403290521257 (37.7183345981422, -122.403290521257) 10 7 8 309 39
39941 6742 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1300X Fairfax Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 01:53:00 PM 3 3x3   6016901.50063 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585) 10 3 8 58 1
42609 67152 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 412 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1992 12:00:00 AM     Permit Number 30584 6009956.04429273 2098629.91177988 37.7429997970033 -122.408202066775 (37.7429997970033, -122.408202066775) 10 7 7 28859 2
46674 111609 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 301x Ward St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 15x3   6011168.56615 2089615.14952 37.7183149668287 -122.403375421742 (37.7183149668287, -122.403375421742) 10 7 8 309 39
50729 67095 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 432 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30500 6009952.08043631 2098577.67814271 37.7428561528472 -122.408212089588 (37.7428561528472, -122.408212089588) 10 7 7 28859 2
60993 61785 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1495 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/06/1987 12:00:00 AM     Permit Number 24636 6012051.50334521 2101403.29784414 37.7507320294913 -122.401151335946 (37.7507320294913, -122.401151335946) 10 3 8 28856 29
61919 43305 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/12/2000 12:00:00 AM 6   Permit Number 43072 6011285.67007 2105193.27319 37.7610957103087 -122.4040663601 (37.7610957103087, -122.4040663601) 10 3 8 28856 29
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
71033 62088 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 474 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1985 12:00:00 AM     Permit Number 22174 6013214.9408475 2104861.98073646 37.7602936588903 -122.397370564655 (37.7602936588903, -122.397370564655) 10 3 8 28856 29
71962 199434 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 2 : Tree Private 2     6 Width 3ft   6014431.27107 2095902.06527 37.7357592658851 -122.392537062245 (37.7357592658851, -122.392537062245) 10 3 8 58 1
75846 32047 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
78944 55568 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1132 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM 13 3x2 Permit Number 11537 6011293.45596 2089493.71978 37.7179885201224 -122.402935191909 (37.7179885201224, -122.402935191909) 10 7 8 309 39
84831 111317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1114 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011270.9057 2089563.62226 37.7181791988873 -122.403018052761 (37.7181791988873, -122.403018052761) 10 7 8 309 39
90644 61306 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1494 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21205 6011999.58311152 2101400.41872379 37.7507212274206 -122.401330679383 (37.7507212274206, -122.401330679383) 10 3 8 28856 29
99319 176423 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 538 Bacon St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009799.11271 2092612.10018 37.726467385945 -122.408320334118 (37.726467385945, -122.408320334118) 10 3 7 309 28
101216 199433 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1400 Newhall St 2 : Tree Private 2     9 Width 3ft   6014453.55095 2095806.16281 37.7354971746608 -122.392453325466 (37.7354971746608, -122.392453325466) 10 3 8 58 1
102221 28251 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3340 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011988.71606 2089960.7357 37.7193096502899 -122.400564754381 (37.7193096502899, -122.400564754381) 10 7 8 309 28
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
103250 111889 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 142 Wayland St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6011076.19973 2092521.56402 37.7262902239912 -122.403899105983 (37.7262902239912, -122.403899105983) 10 3 7 309 28
109268 200443 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 2535 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6015875.48388 2103755.07735 37.7574021083324 -122.388091663914 (37.7574021083324, -122.388091663914) 10 3 8 28856 29
115001 67594 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 308 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM     Permit Number 31161 6013452.45067872 2105638.02121278 37.7624377166869 -122.39660352483 (37.7624377166869, -122.39660352483) 10 3 8 28856 29
118175 26002 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6014429.78226 2095903.68978 37.7357636437757 -122.392542323281 (37.7357636437757, -122.392542323281) 10 3 8 58 1
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
120892 176426 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3338 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011984.529 2089984.5422 37.7193747846049 -122.400580899003 (37.7193747846049, -122.400580899003) 10 7 8 309 28
121851 61725 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 66 Williams Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1985 12:00:00 AM     Permit Number 21727 6013825.41276045 2093670.69143799 37.7295987054368 -122.394475571882 (37.7295987054368, -122.394475571882) 10 3 8 58 1
122926 122750 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   9     6011285.1392 2105241.40164 37.7612278306072 -122.404071583333 (37.7612278306072, -122.404071583333) 10 3 8 28856 29
124236 30843 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1375 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/14/1995 12:00:00 AM     Permit Number 34691 6011743.60320296 2101979.83639733 37.7522978969141 -122.40225661865 (37.7522978969141, -122.40225661865) 10 3 8 28856 29
129824 26001 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1711 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6014400.39468 2095925.25999 37.7358212390678 -122.392645436853 (37.7358212390678, -122.392645436853) 10 3 8 58 1
134941 61310 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2337 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21209 6011897.61971652 2101840.97458612 37.7519252086186 -122.4017142423 (37.7519252086186, -122.4017142423) 10 3 8 28856 29
139460 176420 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 526 Lathrop Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6012864.54988 2086589.64347 37.7101021070033 -122.397301031027 (37.7101021070033, -122.397301031027) 10 3 8 309 1
143067 122749 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 693 Vermont St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5     6011285.50671 2105214.92948 37.7611551645106 -122.404068449214 (37.7611551645106, -122.404068449214) 10 3 8 28856 29
150846 28252 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3342 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011993.05449 2089944.36853 37.7192649513087 -122.400548608856 (37.7192649513087, -122.400548608856) 10 7 8 309 28
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
155644 176424 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 538 Bacon St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009812.17284 2092615.83589 37.7264783747515 -122.408275448966 (37.7264783747515, -122.408275448966) 10 3 7 309 28
164535 67096 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 431 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30501 6010004.32773544 2098578.96669132 37.7428626163512 -122.408031523079 (37.7428626163512, -122.408031523079) 10 7 7 28859 2
164692 55317 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 1126 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1972 12:00:00 AM 4   Permit Number 11246 6011285.28669 2089520.65076 37.7180620109438 -122.402965322811 (37.7180620109438, -122.402965322811) 10 7 8 309 39
165378 61309 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2325 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/10/1984 12:00:00 AM     Permit Number 21208 6011929.28683038 2101842.72936764 37.7519317939639 -122.40160485559 (37.7519317939639, -122.40160485559) 10 3 8 28856 29
167803 41049 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1452 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1999 12:00:00 AM     Permit Number 41829 6011713.00642169 2101589.94219711 37.7512256245579 -122.402335016202 (37.7512256245579, -122.402335016202) 10 3 8 28856 29
173842 32046 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 501 Tunnel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1999 12:00:00 AM     Permit Number 35428 6012610 2086139 37.7088505533644 -122.398149216451 (37.7088505533644, -122.398149216451) 10 3 8 309 1
193808 67150 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 427 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1992 12:00:00 AM     Permit Number 30582 6010005.12050673 2098589.41341875 37.7428913451797 -122.40802951845 (37.7428913451797, -122.40802951845) 10 7 7 28859 2
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
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
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
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
27917 101249 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 734 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993518 2106670 37.764141669108 -122.465623861668 (37.764141669108, -122.465623861668) 11 8 11 56 12
30056 250762 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 231 32nd Ave 1 : Tree Private 2     9 Width 3ft   5985862.1127 2114339.73432 37.7847560253059 -122.492667897222 (37.7847560253059, -122.492667897222) 11 6 1 55 33
36191 251014 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3828 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5995959.01851 2115881.76769 37.7895752475348 -122.457847777179 (37.7895752475348, -122.457847777179) 11 6 1 54 31
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
39540 251008 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3878 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5995662.21487 2115838.76904 37.7894401289022 -122.458871565395 (37.7894401289022, -122.458871565395) 11 6 1 54 31
43482 101285 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1236 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 11316 5993350.8 2107040.7 37.7651498684815 -122.466229094974 (37.7651498684815, -122.466229094974) 11 8 11 56 12
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
58522 98530 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 701X 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991613.7 2110635.6 37.7749201175533 -122.472499350726 (37.7749201175533, -122.472499350726) 11 6 2 54 26
60273 60549 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 523 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1982 12:00:00 AM     Permit Number 20159 5985000.44766821 2112307.598992 37.7791259492381 -122.495498998876 (37.7791259492381, -122.495498998876) 11 6 2 55 26
64863 60554 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 562 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1982 12:00:00 AM     Permit Number 20164 5985061.1383554 2112041.58145553 37.7783990952425 -122.495269425078 (37.7783990952425, -122.495269425078) 11 6 2 55 26
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
72078 251012 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995905.52497 2115874.18508 37.7895513543625 -122.458032309042 (37.7895513543625, -122.458032309042) 11 6 1 54 31
76352 61525 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1341 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1989 12:00:00 AM     Permit Number 28272 5991348.55791434 2114747.92419088 37.7861960776153 -122.473716580773 (37.7861960776153, -122.473716580773) 11 6 2 54 26
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
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

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