230 rows where qCareAssistant = "FUF" and qSpecies_id = 97 sorted by Neighborhoods (old)

View and edit SQL

qCareAssistant

  • FUF · 230
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) ▼
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
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
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
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
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
27367 62428 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 223 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22976 6003655.90381046 2109145.69391809 37.7715188511616 -122.430736479427 (37.7715188511616, -122.430736479427) 15 9 11 29492 10
38338 62653 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 250 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22975 6003520.74083492 2109179.36788903 37.7716036530228 -122.431206419247 (37.7716036530228, -122.431206419247) 15 9 11 29492 10
49673 66438 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 650X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1991 12:00:00 AM     Permit Number 29582 6003603.61647971 2110556.18401653 37.7753887478808 -122.431018029936 (37.7753887478808, -122.431018029936) 7 9 11 29492 10
58779 63899 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 719 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1987 12:00:00 AM     Permit Number 24609 6002042.34774334 2110925.77664223 37.7763149662139 -122.436445273797 (37.7763149662139, -122.436445273797) 15 5 11 29492 10
66522 66379 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 625 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29504 6003563.84234841 2110464.21135378 37.7751339598215 -122.431149051781 (37.7751339598215, -122.431149051781) 15 9 11 29492 10
73528 59961 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 444 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM     Permit Number 19440 6005671.77527769 2111387.84010103 37.7777892453109 -122.4239229277 (37.7777892453109, -122.4239229277) 7 9 11 28852 10
77743 31350 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 843 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34960 6003828.78534548 2110731.50789971 37.7758829003399 -122.430251629227 (37.7758829003399, -122.430251629227) 7 9 11 29492 10
78099 66375 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 612 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29499 6003620.76837837 2110432.17499844 37.7750492215662 -122.430949845165 (37.7750492215662, -122.430949845165) 7 9 11 29492 10
83608 59954 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 559 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM     Permit Number 19431 6005185.88290556 2110921.14903305 37.7764803824816 -122.42557057591 (37.7764803824816, -122.42557057591) 7 9 11 28852 10
86490 66119 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 223 Lily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29179 6005470.38749546 2110092.46405208 37.7742210861409 -122.424527432779 (37.7742210861409, -122.424527432779) 7 9 11 28852 10
92545 66374 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 600 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29498 6003626.18476729 2110393.01425684 37.7749420027203 -122.430928313262 (37.7749420027203, -122.430928313262) 7 9 11 29492 10
99811 62669 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 299 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/1992 12:00:00 AM     Permit Number 23001 6003308.50596463 2109097.30161721 37.7713662897526 -122.431934690531 (37.7713662897526, -122.431934690531) 15 9 11 29492 10
104098 56884 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 219 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1986 12:00:00 AM     Permit Number 14122 6003674.18790761 2109148.24088129 37.771526880372 -122.430673415548 (37.771526880372, -122.430673415548) 15 9 11 29492 10
106089 56883 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 229 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1986 12:00:00 AM     Permit Number 14121 6003628.47766901 2109141.87347388 37.7715068072846 -122.430831075204 (37.7715068072846, -122.430831075204) 15 9 11 29492 10
123454 59623 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 445 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/1988 12:00:00 AM     Permit Number 19030 6001158.23229918 2110194.44132426 37.7742566261049 -122.439451230631 (37.7742566261049, -122.439451230631) 15 5 11 29492 10
142226 62668 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 275 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1986 12:00:00 AM     Permit Number 23000 6003418.21056461 2109112.58339882 37.7714144683632 -122.43155630855 (37.7714144683632, -122.43155630855) 15 9 11 29492 10
146415 56882 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 228 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1986 12:00:00 AM     Permit Number 22996 6003621.30337351 2109193.37618724 37.7716478146462 -122.430859567614 (37.7716478146462, -122.430859567614) 15 9 11 29492 10
154487 56880 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 260 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/21/1986 12:00:00 AM     Permit Number 22991 6003475.03058778 2109173.00048042 37.7715835792192 -122.431364078952 (37.7715835792192, -122.431364078952) 15 9 11 29492 10
160352 66469 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 430 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1991 12:00:00 AM     Permit Number 29620 6002231.09425836 2109952.33731326 37.7736528678468 -122.435722686817 (37.7736528678468, -122.435722686817) 15 5 11 29492 10
175928 60193 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 236 Laussat St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1986 12:00:00 AM     Permit Number 22999 6003584.73517067 2109188.28225965 37.771631755989 -122.430985695552 (37.771631755989, -122.430985695552) 15 9 11 29492 10
179128 66115 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 817 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29170 6003947.68857827 2110748.1234611 37.7759352566539 -122.429841497852 (37.7759352566539, -122.429841497852) 7 9 11 29492 10
185038 111900 DPW Maintained 1 Ficus microcarpa :: Chinese Banyan 97 650X Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2016 12:00:00 AM 3     6003603.61647971 2110556.18401653 37.7753887478808 -122.431018029936 (37.7753887478808, -122.431018029936) 7 9 11 29492 10
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
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
77511 54514 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1221 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1983 12:00:00 AM     Permit Number 20683 5995443.00414725 2107246.09430383 37.7658343190377 -122.459007589279 (37.7658343190377, -122.459007589279) 15 5 11 56 12
122820 65917 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1322 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28932 5994588.71634117 2106515.79856518 37.7637799716089 -122.461909408356 (37.7637799716089, -122.461909408356) 15 5 11 56 12
181277 68371 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1233 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32193 5998967.61980979 2105592.97843293 37.7614972584923 -122.446697779287 (37.7614972584923, -122.446697779287) 15 5 11 29492 12
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
29118 61140 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2132 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/1983 12:00:00 AM     Permit Number 20992 5997609.15376905 2110265.51143343 37.7742491458885 -122.451733203729 (37.7742491458885, -122.451733203729) 15 5 2 29492 16
98278 66836 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2920 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1993 12:00:00 AM     Permit Number 30137 5997039.99678003 2111588.58372334 37.777849344501 -122.453797573256 (37.777849344501, -122.453797573256) 15 6 2 54 16
114874 61139 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2128 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/01/1983 12:00:00 AM     Permit Number 20991 5997627.50212199 2110268.03572246 37.7742571277486 -122.451669915896 (37.7742571277486, -122.451669915896) 15 5 2 29492 16
192915 66937 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2350 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/1992 12:00:00 AM     Permit Number 30262 5998853.41639727 2111835.46191539 37.7786310079222 -122.447542123222 (37.7786310079222, -122.447542123222) 15 6 2 54 16
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
29430 114806 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2811 Gough St 2 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
63143 65844 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2 Richardson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/07/1990 12:00:00 AM     Permit Number 28834 5999811.44226859 2119196.23574668 37.798896470812 -122.444757181443 (37.798896470812, -122.444757181443) 13 9 1 57 17
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
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
27707 66488 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1043 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/21/1991 12:00:00 AM     Permit Number 29647 6007587.84875499 2109703.11754078 37.7732713850209 -122.417175139527 (37.7732713850209, -122.417175139527) 8 2 9 28853 19
36047 69485 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 560 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/1994 12:00:00 AM     Permit Number 33606 6008946.01217425 2105621.19939594 37.7621396967865 -122.412188502645 (37.7621396967865, -122.412188502645) 8 4 7 28859 19
39537 61715 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 281 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21715 6004926.94134289 2108179.4823523 37.7689377963385 -122.42627108706 (37.7689377963385, -122.42627108706) 8 4 5 28853 19
40421 61705 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 57 Rosemont Pl 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21704 6005150.34156307 2107947.67774505 37.7683139415326 -122.42548186082 (37.7683139415326, -122.42548186082) 8 4 5 28853 19
50241 61716 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 271 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21716 6004986.55656035 2108182.89626107 37.7689505396343 -122.426065124893 (37.7689505396343, -122.426065124893) 8 4 5 28853 19
51538 66220 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1 Dolores Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29312 6005304.82019082 2105877.54249684 37.7626385702507 -122.424800241819 (37.7626385702507, -122.424800241819) 8 4 5 28859 19
56192 61710 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1975 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21709 6004910.69371619 2108330.79575039 37.7693523480889 -122.426338061309 (37.7693523480889, -122.426338061309) 8 4 5 28862 19
56378 34142 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1997 12:00:00 AM     Permit Number 37990 6008524.65557539 2106230.12436926 37.7637880127631 -122.413688890617 (37.7637880127631, -122.413688890617) 8 4 7 28859 19
62313 61708 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 580 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21707 6004928.75046121 2107826.22237424 37.767967931643 -122.426239675726 (37.767967931643, -122.426239675726) 8 4 5 28853 19
65684 65243 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1086 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28037 6009165.76758609 2102839.33295033 37.7545136503205 -122.411231929366 (37.7545136503205, -122.411231929366) 2 4 7 28859 19
65803 66224 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 32 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29318 6005343.90687 2105779.62004334 37.7623719059493 -122.424658088706 (37.7623719059493, -122.424658088706) 8 4 5 28859 19
69007 64894 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1450 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/1989 12:00:00 AM     Permit Number 25920 6005836.52150612 2100535.66309095 37.7480010261231 -122.422581663865 (37.7480010261231, -122.422581663865) 2 4 5 28859 19
72854 61763 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 390 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1984 12:00:00 AM     Permit Number 21777 6005479.130443 2106713.50276565 37.7649437627207 -122.424256822517 (37.7649437627207, -122.424256822517) 8 4 5 28853 19
80884 60279 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 890 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19841 6007951.11915857 2102749.5563076 37.7541989479338 -122.415426159541 (37.7541989479338, -122.415426159541) 2 4 7 28859 19
80902 64591 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3375 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1988 12:00:00 AM     Permit Number 25492 6005853.76544152 2103715.18666196 37.7567322373374 -122.422747957423 (37.7567322373374, -122.422747957423) 2 4 5 28859 19
88565 36252 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 243 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1998 12:00:00 AM     Permit Number 39269 6005153.47922718 2108192.45520893 37.7689862189606 -122.42548843025 (37.7689862189606, -122.42548843025) 8 4 5 28853 19
98843 64576 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1988 12:00:00 AM     Permit Number 25474 6006109.43020381 2104951.42696267 37.760141086622 -122.421951589354 (37.760141086622, -122.421951589354) 2 4 5 28859 19
107780 66216 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 438 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29307 6008473.34152559 2106010.06053059 37.7631808865324 -122.413850803115 (37.7631808865324, -122.413850803115) 8 4 7 28859 19
109279 68204 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM 16 3x3 Permit Number 32363 6009978.53990017 2102725.22931804 37.7542458964916 -122.408413088762 (37.7542458964916, -122.408413088762) 2 4 7 28859 19
111937 61712 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 239 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21712 6005177.32533199 2108193.82077345 37.768991315779 -122.425406045223 (37.768991315779, -122.425406045223) 8 4 5 28853 19
116320 64674 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3672 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/07/1988 12:00:00 AM     Permit Number 25610 6005829.7777873 2104349.72005691 37.7584731646091 -122.422876010971 (37.7584731646091, -122.422876010971) 2 4 5 28859 19
125961 63244 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3686 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/1987 12:00:00 AM 14 4x4 Permit Number 23795 6005743.604902 2104344.93890143 37.7584551740166 -122.423173695837 (37.7584551740166, -122.423173695837) 2 4 5 28859 19
128740 61713 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 269 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21713 6004998.47961276 2108183.57904333 37.7689530882522 -122.42602393242 (37.7689530882522, -122.42602393242) 8 4 5 28853 19
129506 66222 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 48 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29314 6005242.33190892 2105774.60229973 37.7623523912444 -122.425009042016 (37.7623523912444, -122.425009042016) 8 4 5 28859 19
129773 66218 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 81 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1990 12:00:00 AM     Permit Number 29310 6005039.41557773 2105712.51494257 37.7621704498093 -122.425706435205 (37.7621704498093, -122.425706435205) 8 4 5 28859 19
131070 61754 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3208 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1984 12:00:00 AM     Permit Number 21766 6005459.89972761 2106676.78980679 37.7648418717739 -122.424320725398 (37.7648418717739, -122.424320725398) 8 4 5 28853 19
135237 61717 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 126 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21717 6005390.65318574 2108294.55770451 37.7692799656993 -122.424675324148 (37.7692799656993, -122.424675324148) 8 4 5 28853 19
135891 61714 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 236 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1984 12:00:00 AM     Permit Number 21714 6005186.275415 2108246.41850013 37.7691362421663 -122.425378830956 (37.7691362421663, -122.425378830956) 8 4 5 28853 19
138825 60292 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2902 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19857 6009437.54414231 2102795.33502096 37.7544080802013 -122.410288944543 (37.7544080802013, -122.410288944543) 2 4 7 28859 19
146840 64693 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 110 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/13/1988 12:00:00 AM     Permit Number 25636 6005573.37725141 2104043.9306623 37.7576190678174 -122.423741017308 (37.7576190678174, -122.423741017308) 2 4 5 28859 19
152129 35055 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 570 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/1998 12:00:00 AM     Permit Number 38614 6008948.51314843 2105576.68374234 37.7620176073252 -122.41217670641 (37.7620176073252, -122.41217670641) 8 4 7 28859 19
152493 61711 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 232 Clinton Park 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/1991 12:00:00 AM     Permit Number 29947 6005210.12151982 2108247.78406465 37.7691413389079 -122.425296445755 (37.7691413389079, -122.425296445755) 8 4 5 28853 19
152804 60714 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 21 Oakwood St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/1989 12:00:00 AM     Permit Number 20367 6005264.975818 2105333.47768938 37.7611424464321 -122.424899339668 (37.7611424464321, -122.424899339668) 2 4 5 28859 19
165757 64580 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3540 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1988 12:00:00 AM     Permit Number 25479 6006657.88465402 2104395.66614284 37.7586460128066 -122.420015302359 (37.7586460128066, -122.420015302359) 2 4 7 28859 19
171142 61751 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1839 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1984 12:00:00 AM     Permit Number 21762 6005280.05550322 2107208.06692616 37.7662904752312 -122.424980563467 (37.7662904752312, -122.424980563467) 8 4 5 28853 19
171938 60290 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 2915 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19854 6009379.15115854 2102740.05515277 37.7542530206621 -122.41048698011 (37.7542530206621, -122.41048698011) 2 4 7 28859 19
172270 63515 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3379 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/08/1987 12:00:00 AM     Permit Number 24124 6007714.38800344 2104402.20456648 37.758723433411 -122.416361886265 (37.758723433411, -122.416361886265) 2 4 7 28859 19
179560 66225 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 36 Dorland St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29319 6005318.51312392 2105778.36560715 37.76236702737 -122.424745827071 (37.76236702737, -122.424745827071) 8 4 5 28859 19
181331 34143 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 400 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/1997 12:00:00 AM     Permit Number 37990 6008524.65557539 2106230.12436926 37.7637880127631 -122.413688890617 (37.7637880127631, -122.413688890617) 8 4 7 28859 19
188830 61704 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 560 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1984 12:00:00 AM     Permit Number 21703 6005065.62335195 2107833.77826085 37.7679964138535 -122.42576678516 (37.7679964138535, -122.42576678516) 8 4 5 28853 19
20642 62333 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 54 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/1985 12:00:00 AM     Permit Number 22475 6005123.90294191 2096395.98906268 37.7365941933288 -122.424751419367 (37.7365941933288, -122.424751419367) 2 7 5 28859 2
24474 62335 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 88 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/1985 12:00:00 AM     Permit Number 22477 6005278.45102522 2096412.38253023 37.7366479337699 -122.424218245392 (37.7366479337699, -122.424218245392) 2 7 7 28859 2
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
45268 59350 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 97 Mirabel Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/1987 12:00:00 AM     Permit Number 23892 6007961.12301785 2099994.21526918 37.7466339645312 -122.415196534166 (37.7466339645312, -122.415196534166) 2 7 7 28859 2
46673 63412 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 832 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 23995 6007544.46590294 2095494.67209225 37.7342557904854 -122.416318652779 (37.7342557904854, -122.416318652779) 2 7 7 28859 2
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
75866 62334 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 66 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/1985 12:00:00 AM     Permit Number 22476 6005174.05627534 2096389.57268342 37.7365794079222 -122.424577561345 (37.7365794079222, -122.424577561345) 2 7 5 28859 2
91862 58807 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 40 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23661 6007506.51736783 2099215.13200372 37.744469217231 -122.416713333977 (37.744469217231, -122.416713333977) 2 7 7 28859 2
93830 63410 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 834 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1987 12:00:00 AM     Permit Number 23993 6007543.2306715 2095481.74721631 37.7342202321398 -122.416322008236 (37.7342202321398, -122.416322008236) 2 7 7 28859 2
109507 48038 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 3350 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2005 12:00:00 AM     Permit Number 45759 6006080.4837518 2098740.43590211 37.7430854999808 -122.42161056574 (37.7430854999808, -122.42161056574) 2 7 7 28859 2
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
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
28593 66848 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 919 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1991 12:00:00 AM     Permit Number 30152 6008182.6560056 2115155.17049763 37.7882748588768 -122.415503684404 (37.7882748588768, -122.415503684404) 13 1 10 28858 21
41084 48790 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1405 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/21/2006 12:00:00 AM     Permit Number 46040 6008874.44924411 2117680.29283989 37.7952470886304 -122.413288823995 (37.7952470886304, -122.413288823995) 5 1 10 308 21
76403 66852 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 805 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/1991 12:00:00 AM     Permit Number 30158 6008246.52380896 2115214.16051417 37.7884404207738 -122.415286889274 (37.7884404207738, -122.415286889274) 13 1 10 28858 21
83298 65478 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 601 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/1989 12:00:00 AM     Permit Number 28359 6010541.36110634 2116214.27782437 37.7913152098094 -122.407417612453 (37.7913152098094, -122.407417612453) 5 1 10 28857 21
84852 65486 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 801 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/15/1989 12:00:00 AM     Permit Number 28370 6009649.36997858 2115707.80146662 37.7898745823318 -122.410468114048 (37.7898745823318, -122.410468114048) 5 1 10 28857 21

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