trees
969 rows where qSpecies_id = 97 sorted by qCareAssistant descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant ▲ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
20637 | 50305 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1217@ ARMY Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/2003 12:00:00 AM | Permit Number 47015 | 6001375.35048187 | 2100228.68999583 | 37.7469054591013 | -122.437986196494 | (37.7469054591013, -122.437986196494) | 2 | 4 | 5 | 63 | 22 | ||
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 | ||
25933 | 60830 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 282 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | 22 | Permit Number 20603 | 6004748.95976393 | 2102035.39189802 | 37.7520575177016 | -122.426449179292 | (37.7520575177016, -122.426449179292) | 2 | 4 | 5 | 28862 | 22 | |
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 | ||
27423 | 121150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1918 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6004687.86766006 | 2107227.29036829 | 37.766309789845 | -122.427030199286 | (37.766309789845, -122.427030199286) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||
27714 | 66042 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 303 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/1990 12:00:00 AM | Permit Number 29081 | 6002303.92307718 | 2106443.08966771 | 37.7640214741501 | -122.435219706112 | (37.7640214741501, -122.435219706112) | 15 | 5 | 5 | 28862 | 3 | ||
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 | ||
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 | ||
29378 | 62357 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 172 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22501 | 6004773.71147679 | 2099613.16071739 | 37.745408029937 | -122.426191153847 | (37.745408029937, -122.426191153847) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||||
30050 | 104403 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 2 | 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 | |
31188 | 116841 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2344 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 24 | 6002015 | 2107091 | 37.7657840660528 | -122.436265375372 | (37.7657840660528, -122.436265375372) | 15 | 5 | 5 | 28862 | 3 | |||
32783 | 62137 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/31/1985 12:00:00 AM | Permit Number 22247 | 6001408.1074829 | 2092199.32717361 | 37.7248605551976 | -122.437298087712 | (37.7248605551976, -122.437298087712) | 9 | 7 | 6 | 28861 | 25 | ||
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 | ||
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 | ||
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 | ||
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 | ||
42082 | 62352 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 102 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22496 | 6005217.58297735 | 2099637.57957653 | 37.7455001571003 | -122.424658053081 | (37.7455001571003, -122.424658053081) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
44712 | 30926 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 230 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 13 | Permit Number 34739 | 5996065.71046 | 2091231.30039 | 37.7218974306099 | -122.455696079012 | (37.7218974306099, -122.455696079012) | 9 | 8 | 4 | 28861 | 24 | |
45208 | 60434 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 461 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/07/1987 12:00:00 AM | Permit Number 24099 | 6003594.47944671 | 2098910.74347696 | 37.7434126315981 | -122.430218644192 | (37.7434126315981, -122.430218644192) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
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 | ||
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 | ||
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 | ||
50861 | 60838 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 261 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20611 | 6004794.55991917 | 2102160.27475876 | 37.75240299462 | -122.426300377591 | (37.75240299462, -122.426300377591) | 2 | 4 | 5 | 28862 | 22 | ||
51427 | 65673 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 355 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28593 | 5997947.70792661 | 2098297.78452014 | 37.7414081426615 | -122.449699493918 | (37.7414081426615, -122.449699493918) | 9 | 7 | 4 | 59 | 40 | ||
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 | ||
53715 | 108962 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | ||
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 | ||
57362 | 65894 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 649 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1990 12:00:00 AM | Permit Number 28901 | 6009912.39060761 | 2119145.15114701 | 37.7993274494867 | -122.409800817555 | (37.7993274494867, -122.409800817555) | 3 | 1 | 10 | 308 | 4 | ||
58481 | 65402 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 760 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | 12 | 3x3 | Permit Number 28251 | 6008077 | 2114493 | 37.7864507606031 | -122.415822330961 | (37.7864507606031, -122.415822330961) | 13 | 1 | 9 | 28858 | 36 |
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 | ||
59240 | 60839 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 271 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20613 | 6004797.43728628 | 2102104.7326602 | 37.7522506515925 | -122.426286473113 | (37.7522506515925, -122.426286473113) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
60366 | 64334 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 18 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25162 | 6004243.25196821 | 2098226.95980835 | 37.7415718437352 | -122.427926638771 | (37.7415718437352, -122.427926638771) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
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 | ||
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 | ||
63739 | 60831 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 205 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20604 | 6004778.44666437 | 2102471.31049199 | 37.7532561154195 | -122.426378243722 | (37.7532561154195, -122.426378243722) | 2 | 4 | 5 | 28862 | 22 | ||
64691 | 60840 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 315 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20614 | 6004809.28697134 | 2101883.59513704 | 37.7516441291888 | -122.426229752639 | (37.7516441291888, -122.426229752639) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | ||
66258 | 56750 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 100 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/1985 12:00:00 AM | Permit Number 21307 | 6002862.2859563 | 2108898.25983772 | 37.7707944635274 | -122.433463958699 | (37.7707944635274, -122.433463958699) | 15 | 5 | 11 | 29492 | 9 | ||
66329 | 108965 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | ||
67426 | 63397 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4300 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30165 | 6001730.87094671 | 2104708.68623731 | 37.7592266666695 | -122.437077536949 | (37.7592266666695, -122.437077536949) | 2 | 4 | 5 | 28862 | 3 | ||
69005 | 62360 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 198 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/1985 12:00:00 AM | Permit Number 22505 | 6004608.84494602 | 2099604.09085689 | 37.7453738062021 | -122.426760590215 | (37.7453738062021, -122.426760590215) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
69132 | 60836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 253 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20609 | 6004792.25802571 | 2102204.70843345 | 37.7525248690267 | -122.426311501214 | (37.7525248690267, -122.426311501214) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | ||
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 | ||
74931 | 64702 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 110 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25683 | 6010200.02442425 | 2113768.63085544 | 37.7845809377612 | -122.408426051637 | (37.7845809377612, -122.408426051637) | 14 | 10 | 10 | 28852 | 36 | ||
75679 | 57103 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3743 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20509 | 6004792.79553424 | 2102485.90723803 | 37.7532970057744 | -122.426329661558 | (37.7532970057744, -122.426329661558) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
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 | ||
76206 | 63396 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/11/1987 12:00:00 AM | Permit Number 23978 | 6001653.34817436 | 2104704.40880226 | 37.759210515065 | -122.437345341266 | (37.759210515065, -122.437345341266) | 2 | 4 | 5 | 28862 | 3 | ||
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 | ||
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 | ||
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 | ||
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 | ||
78380 | 62435 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 297 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22596 | 5999684.09914601 | 2105294.09451438 | 37.7607174991734 | -122.444198303008 | (37.7607174991734, -122.444198303008) | 15 | 5 | 5 | 28862 | 3 | ||
79246 | 60832 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 210 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20605 | 6004728.24272246 | 2102435.29497545 | 37.7531543871846 | -122.426549294945 | (37.7531543871846, -122.426549294945) | 2 | 4 | 5 | 28862 | 22 | ||
80740 | 35236 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 10 | Permit Number 38733 | 6007268.58471 | 2119527.95161 | 37.8002300077587 | -122.418976495462 | (37.8002300077587, -122.418976495462) | 5 | 1 | 1 | 28858 | 32 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
90119 | 61733 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1352 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21738 | 6004486.387982 | 2101012.81721841 | 37.7492349189645 | -122.427284356874 | (37.7492349189645, -122.427284356874) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
91680 | 64024 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2356 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24781 | 6001973.19869493 | 2107076.19337817 | 37.7657410355678 | -122.436408897131 | (37.7657410355678, -122.436408897131) | 15 | 5 | 5 | 28862 | 3 |
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) );