trees
79 rows where Supervisor Districts = 11 and qSpecies_id = 97
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
5550 | 207625 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.458992007973 | (37.7657947273793, -122.458992007973) | 15 | 5 | 11 | 56 | 12 | |||
6180 | 33653 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
6344 | 33663 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 424 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37751 | 6005309.8782552 | 2111164.52643651 | 37.7771556428857 | -122.425158961888 | (37.7771556428857, -122.425158961888) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |
11946 | 33634 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 416 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37730 | 6005394.17412308 | 2110828.6660173 | 37.7762382136369 | -122.424843455434 | (37.7762382136369, -122.424843455434) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
26145 | 258009 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 380 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005531 | 2111189 | 37.7772353303506 | -122.424395772149 | (37.7772353303506, -122.424395772149) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
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 | ||
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 | ||||
28013 | 33609 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
32878 | 12244 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005028.53136 | 2110211.81183 | 37.7745238232573 | -122.426064391571 | (37.7745238232573, -122.426064391571) | 7 | 9 | 11 | 28852 | 10 | |||
36000 | 104437 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 534 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005464 | 2111103 | 37.7769954116482 | -122.424621427703 | (37.7769954116482, -122.424621427703) | 7 | 9 | 11 | 28852 | 10 | |||||
38079 | 53067 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2161 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2006 12:00:00 AM | Permit Number 49038 | 6002271.52116096 | 2114331.58955378 | 37.7856794886217 | -122.435896249645 | (37.7856794886217, -122.435896249645) | 13 | 6 | 11 | 29490 | 13 | |||
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 | ||
40736 | 33615 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
41759 | 30892 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
42094 | 107775 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 311 PARNASSUS AVE | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996666.6 | 2106591.7 | 37.7641077820156 | -122.454728170136 | (37.7641077820156, -122.454728170136) | 15 | 5 | 11 | 29492 | 12 | |||||
42896 | 249545 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6006121.63422 | 2114038.60368 | 37.7850929805917 | -122.422555115551 | (37.7850929805917, -122.422555115551) | 13 | 9 | 11 | 28858 | 41 | |||
43225 | 249547 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 4 | : | Tree | Private 2 | 15 | Width 3ft | 6006068.98024 | 2114032.12876 | 37.7850722314402 | -122.422736821748 | (37.7850722314402, -122.422736821748) | 13 | 9 | 11 | 28858 | 41 | |||
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 | |||
47523 | 75088 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 574 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1985 12:00:00 AM | 18 | 5x5 | 6002936 | 2108949 | 37.7709379654477 | -122.433212606655 | (37.7709379654477, -122.433212606655) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
69321 | 16914 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 483 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004697.20239 | 2110157.08412 | 37.7743548226588 | -122.427206624104 | (37.7743548226588, -122.427206624104) | 7 | 9 | 11 | 28852 | 10 | |||
70716 | 224492 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5998346.42262 | 2106894.64873 | 37.7650358128629 | -122.448940002185 | (37.7650358128629, -122.448940002185) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||
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 | |||
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 | ||
78159 | 244052 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||||
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 | ||
94326 | 62670 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1328 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1986 12:00:00 AM | Permit Number 23002 | 6002790.04269178 | 2111680.73625558 | 37.7784303546549 | -122.433912768351 | (37.7784303546549, -122.433912768351) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
104931 | 61431 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 682 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1985 12:00:00 AM | Permit Number 22021 | 6002437.42157042 | 2108855.24055446 | 37.7706522292485 | -122.434930494274 | (37.7706522292485, -122.434930494274) | 15 | 5 | 11 | 29492 | 9 | ||
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 | ||
108720 | 224490 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 4630 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998778.21735 | 2105711.32788 | 37.7618113953113 | -122.447361360161 | (37.7618113953113, -122.447361360161) | 15 | 5 | 11 | 29492 | 9 | |||
108948 | 30891 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
116135 | 224491 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 60 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998359.17902 | 2106895.28933 | 37.7650383013108 | -122.4488959273 | (37.7650383013108, -122.4488959273) | 15 | 5 | 11 | 29492 | 9 | |||
117344 | 66495 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2476 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/21/1991 12:00:00 AM | 14 | Permit Number 772310 | 6001690.938 | 2114651.3348 | 37.7865244291853 | -122.437927807736 | (37.7865244291853, -122.437927807736) | 13 | 6 | 11 | 29490 | 27 | |
118167 | 33695 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 415 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37766 | 6005362.72010447 | 2111119.40531281 | 37.7770347362587 | -122.42497295397 | (37.7770347362587, -122.42497295397) | 7 | 9 | 11 | 28852 | 10 | |||
118592 | 63854 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1437 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24553 | 6002713.14606438 | 2111964.58520586 | 37.779205368769 | -122.434199079816 | (37.779205368769, -122.434199079816) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
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 | ||
123850 | 33611 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
129070 | 224489 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998519.39636 | 2106289.88206 | 37.7633851666273 | -122.448298178534 | (37.7633851666273, -122.448298178534) | 15 | 5 | 11 | 29492 | 9 | |||
131474 | 16900 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 409 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005007.3916 | 2110203.70331 | 37.7745003644325 | -122.426136940772 | (37.7745003644325, -122.426136940772) | 7 | 9 | 11 | 28852 | 10 | |||
132088 | 33651 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 284 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37742 | 6006036.93235026 | 2110918.36759919 | 37.776520795938 | -122.422626351394 | (37.776520795938, -122.422626351394) | 7 | 9 | 11 | 28852 | 10 | |||
137273 | 249546 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 298 Myrtle St | 3 | : | Tree | Private 2 | 17 | Width 3ft | 6006094.99565 | 2114034.77585 | 37.7850809674618 | -122.422647004665 | (37.7850809674618, -122.422647004665) | 13 | 9 | 11 | 28858 | 41 | |||
140738 | 244051 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 401 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997898.1905 | 2109198.4158 | 37.7713357252186 | -122.450656427551 | (37.7713357252186, -122.450656427551) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
143659 | 33610 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37721 | 6005048.76551317 | 2110086.28535746 | 37.7741803016618 | -122.425985460117 | (37.7741803016618, -122.425985460117) | 7 | 9 | 11 | 28852 | 10 | |||
145528 | 224488 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 24 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998533.31147 | 2106291.41144 | 37.7633901614449 | -122.448250161025 | (37.7633901614449, -122.448250161025) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
148185 | 33613 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 386 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37723 | 6004689.24070975 | 2110036.24790961 | 37.7740225856392 | -122.427225555933 | (37.7740225856392, -122.427225555933) | 7 | 9 | 11 | 28852 | 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 | ||
154697 | 113877 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 101 HUGO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995437 | 2107003 | 37.7651664998927 | -122.4590107531 | (37.7651664998927, -122.4590107531) | 15 | 5 | 11 | 56 | 12 | ||||
154840 | 63853 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1482 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24552 | 6002495.53817147 | 2111986.73822711 | 37.7792538422906 | -122.43495345894 | (37.7792538422906, -122.43495345894) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
179236 | 30890 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 412 Hayes St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | Permit Number 34719 | 6005865.19335847 | 2111068.58127823 | 37.7769235557198 | -122.423231126893 | (37.7769235557198, -122.423231126893) | 7 | 9 | 11 | 28852 | 10 | |||
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 | ||
184502 | 33607 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 314 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37719 | 6005021.10976005 | 2110082.43632314 | 37.7741681701238 | -122.426080852286 | (37.7741681701238, -122.426080852286) | 7 | 9 | 11 | 28852 | 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 | ||
185167 | 33614 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 312 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37724 | 6005030.32834442 | 2110083.71933458 | 37.7741722139784 | -122.4260490549 | (37.7741722139784, -122.4260490549) | 7 | 9 | 11 | 28852 | 10 | |||
186372 | 59298 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 734 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1980 12:00:00 AM | Permit Number 18636 | 5993516.37713931 | 2106668.84289355 | 37.7641383983924 | -122.465629390558 | (37.7641383983924, -122.465629390558) | 11 | 8 | 11 | 56 | 12 | |||
186946 | 33612 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37722 | 6005039.5469288 | 2110085.00234602 | 37.7741762578244 | -122.42601725751 | (37.7741762578244, -122.42601725751) | 7 | 9 | 11 | 28852 | 10 | |||
188441 | 224628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1053 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997656.24362 | 2106853.17472 | 37.7648824406996 | -122.45132415711 | (37.7648824406996, -122.45132415711) | 15 | 5 | 11 | 29492 | 9 | |||
190656 | 30538 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 614 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 34538 | 6003619.86564688 | 2110438.7017887 | 37.7750670913733 | -122.430953433821 | (37.7750670913733, -122.430953433821) | 7 | 9 | 11 | 29492 | 10 |
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) );