trees
969 rows where qSpecies_id = 97 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
38158 | 101288 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3355X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001810.5 | 2119614.7 | 37.8001593395999 | -122.437869785341 | (37.8001593395999, -122.437869785341) | 13 | 9 | 1 | 57 | 17 | ||||
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 | ||||
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 | ||||
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 | ||||
151439 | 108964 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||||
185991 | 64025 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2395x 15TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24782 | 6001858 | 2107008 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | 15 | 5 | 5 | 28862 | 3 | ||
46698 | 58912 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2308 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/1980 12:00:00 AM | 18 | Permit Number 776948 | 6001885.65083 | 2118771.72016 | 37.7978490112876 | -122.437549333047 | (37.7978490112876, -122.437549333047) | 13 | 9 | 1 | 57 | 17 | ||
115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
136038 | 64051 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1987 12:00:00 AM | 18 | 3x3 | Permit Number 24809 | 6001958.39518673 | 2107077.48794504 | 37.7657437489593 | -122.436460191864 | (37.7657437489593, -122.436460191864) | 15 | 5 | 5 | 28862 | 3 |
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 | ||
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 | |||
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 | |
100814 | 104423 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2362 15th St | 3 | 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 | |
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 | ||
138718 | 64019 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2321 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24776 | 6002140.06473103 | 2107033.66278157 | 37.7656337371655 | -122.435828700932 | (37.7656337371655, -122.435828700932) | 15 | 5 | 5 | 28862 | 3 | ||
153013 | 176419 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 638 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6002178.18938 | 2090229.77829 | 37.7194963630453 | -122.43449524976 | (37.7194963630453, -122.43449524976) | 9 | 7 | 6 | 28861 | 5 | |||
93546 | 55576 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2309 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24775 | 6002194.69587728 | 2107036.79090461 | 37.7656454293788 | -122.435639967902 | (37.7656454293788, -122.435639967902) | 15 | 5 | 5 | 28862 | 3 | ||
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 | ||
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 | |||
94009 | 65540 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2154 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1990 12:00:00 AM | 3x3 | Permit Number 28437 | 6002291.71421754 | 2114386.89695038 | 37.7858324957202 | -122.435830346192 | (37.7858324957202, -122.435830346192) | 13 | 6 | 1 | 29490 | 27 | |
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 | ||
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 | ||
189934 | 64807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 74 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25809 | 6002370.48571479 | 2099839.6903707 | 37.7458938988463 | -122.434517304917 | (37.7458938988463, -122.434517304917) | 2 | 7 | 5 | 63 | 22 | ||
79230 | 103152 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
95218 | 103153 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
181653 | 103151 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2190X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6002428.2 | 2119190 | 37.7990283301562 | -122.435701904836 | (37.7990283301562, -122.435701904836) | 13 | 9 | 1 | 57 | 17 | ||||
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 | ||
183317 | 5133 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2796 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002464.77756 | 2095726.89475 | 37.7346064681217 | -122.433897334607 | (37.7346064681217, -122.433897334607) | 2 | 7 | 5 | 63 | 7 | |||
84851 | 59876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2195X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1981 12:00:00 AM | 3x3 | Permit Number 768644 | 6002471.9091323 | 2118692.46196613 | 37.7976647031079 | -122.43551504484 | (37.7976647031079, -122.43551504484) | 13 | 9 | 1 | 57 | 17 | ||
136653 | 5127 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2764 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/18/1994 12:00:00 AM | 15 | 3X3 | 6002472.72131 | 2095943.62285 | 37.7352020045603 | -122.433885356532 | (37.7352020045603, -122.433885356532) | 2 | 7 | 5 | 63 | 7 | ||
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 | ||
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 | ||
104186 | 83711 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 3955 17TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/25/2005 12:00:00 AM | 12 | 3x3 | 6002562.7 | 2105843.1 | 37.7623887399353 | -122.434281776631 | (37.7623887399353, -122.434281776631) | 15 | 4 | 5 | 28862 | 3 | ||
135538 | 34978 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 135 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38559 | 6002699.25501919 | 2105112.74476166 | 37.7603911107583 | -122.433757281047 | (37.7603911107583, -122.433757281047) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
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 | ||
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 | ||
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 | ||
78518 | 66628 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 412 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 16 | Permit Number 29832 | 6002951.53686 | 2091458.2652 | 37.7229133848294 | -122.431909745644 | (37.7229133848294, -122.431909745644) | 9 | 7 | 6 | 28861 | 5 | ||
105579 | 58797 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 772 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/1979 12:00:00 AM | 24 | 3x3 | Permit Number 53459 | 6003043.36972634 | 2103781.55156302 | 37.7567554935309 | -122.432472066162 | (37.7567554935309, -122.432472066162) | 2 | 4 | 5 | 28862 | 3 | |
128778 | 65199 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 393 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1989 12:00:00 AM | Permit Number 27185 | 6003086.32595187 | 2091584.19795725 | 37.7232668084318 | -122.431452793676 | (37.7232668084318, -122.431452793676) | 9 | 7 | 6 | 28861 | 5 | ||
143284 | 32039 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3653 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1995 12:00:00 AM | Permit Number 35422 | 6003092.33534727 | 2120827.43015376 | 37.8035619867255 | -122.433520856524 | (37.8035619867255, -122.433520856524) | 13 | 9 | 1 | 57 | 17 | |||
182138 | 63877 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 849 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24582 | 6003121.89544563 | 2103305.24261692 | 37.7554521151946 | -122.432166481498 | (37.7554521151946, -122.432166481498) | 2 | 4 | 5 | 28862 | 22 | ||
164254 | 59572 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 893 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1991 12:00:00 AM | Permit Number 24583 | 6003136.10237421 | 2103049.36160406 | 37.7547503322276 | -122.432099077639 | (37.7547503322276, -122.432099077639) | 2 | 4 | 5 | 28862 | 22 | ||
168369 | 35391 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 23 Orben Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1998 12:00:00 AM | Permit Number 38846 | 6003139.07897357 | 2115258.4763002 | 37.7882737292741 | -122.432960994436 | (37.7882737292741, -122.432960994436) | 13 | 9 | 1 | 29490 | 27 | |||
179373 | 63876 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 493 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24580 | 6003154.01696483 | 2103272.14676469 | 37.7553630630052 | -122.432053032269 | (37.7553630630052, -122.432053032269) | 2 | 4 | 5 | 28862 | 22 | ||
184847 | 63772 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1134 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24451 | 6003162.44517655 | 2101626.56141002 | 37.7508451528322 | -122.431906388672 | (37.7508451528322, -122.431906388672) | 2 | 4 | 5 | 28862 | 22 | ||
81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
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 | ||
187559 | 51017 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 464 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/2004 12:00:00 AM | Permit Number 47495 | 6003323.42861905 | 2103333.57669245 | 37.75554133817 | -122.431471541095 | (37.75554133817, -122.431471541095) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
146150 | 61734 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 264 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21739 | 6003453.08659842 | 2101001.58454059 | 37.7491455850179 | -122.430856727417 | (37.7491455850179, -122.430856727417) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
36246 | 32868 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 456 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37214 | 6003519.04848512 | 2096396.05502281 | 37.736503601705 | -122.430300092251 | (37.736503601705, -122.430300092251) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||
105533 | 63872 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 426 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24575 | 6003557.23375757 | 2103346.48170692 | 37.7555900208672 | -122.430663891517 | (37.7555900208672, -122.430663891517) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
182814 | 61735 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 246 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21740 | 6003563.88991247 | 2101007.45012611 | 37.7491679679218 | -122.430473986745 | (37.7491679679218, -122.430473986745) | 2 | 4 | 5 | 28862 | 22 | ||
41908 | 35231 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 402 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38724 | 6003567.92997574 | 2105934.61117361 | 37.7626970125211 | -122.430811591359 | (37.7626970125211, -122.430811591359) | 15 | 4 | 5 | 28862 | 3 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
7782 | 101433 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
19967 | 101427 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
30771 | 101430 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
73416 | 101431 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
93479 | 101426 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
122240 | 101428 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
180413 | 101429 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
186379 | 101432 | Undocumented 4 | Ficus microcarpa :: Chinese Banyan 97 | 2501X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003643.1 | 2116935.1 | 37.7929058867978 | -122.431336896261 | (37.7929058867978, -122.431336896261) | 13 | 9 | 1 | 29490 | 27 | ||||
122779 | 61739 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 232 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21744 | 6003650.07025761 | 2101012.01224764 | 37.7491853759856 | -122.430176299432 | (37.7491853759856, -122.430176299432) | 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 | ||
107862 | 99964 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2439 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769385 | 6003671 | 2116729 | 37.7923415699538 | -122.431225642925 | (37.7923415699538, -122.431225642925) | 13 | 9 | 1 | 29490 | 27 | ||||
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 | ||
162342 | 60432 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 447 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31498 | 6003680.70369729 | 2098915.54804456 | 37.7434307072212 | -122.42992084535 | (37.7434307072212, -122.42992084535) | 2 | 7 | 5 | 63 | 22 | ||
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 | ||
182596 | 64939 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1904 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1989 12:00:00 AM | 14 | 4x9 | Permit Number 25968 | 6003770.59823 | 2119034.75591 | 37.798678227572 | -122.431045672521 | (37.798678227572, -122.431045672521) | 13 | 9 | 1 | 57 | 17 | |
97223 | 67815 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31469 | 6003802.17585758 | 2102641.49083741 | 37.7536681560563 | -122.429766523917 | (37.7536681560563, -122.429766523917) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
144984 | 61731 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1250 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21736 | 6003842.20340405 | 2100987.35465575 | 37.7491285523468 | -122.42951014206 | (37.7491285523468, -122.42951014206) | 2 | 4 | 5 | 28862 | 22 | ||
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 | |
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 | ||
171625 | 61732 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 184 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21737 | 6003971.9147598 | 2101029.52294751 | 37.7492516799815 | -122.429064604837 | (37.7492516799815, -122.429064604837) | 2 | 4 | 5 | 28862 | 22 | ||
127691 | 61741 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 175 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1984 12:00:00 AM | Permit Number 21746 | 6004036.62237664 | 2100981.15253515 | 37.7491225287463 | -122.428837396831 | (37.7491225287463, -122.428837396831) | 2 | 4 | 5 | 28862 | 22 | ||
180392 | 176418 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 216 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 1ft | 6004075.47639 | 2089186.2671 | 37.7167386279577 | -122.427862706522 | (37.7167386279577, -122.427862706522) | 9 | 7 | 6 | 28861 | 5 | |||
171200 | 93707 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1864 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53296 | 6004115 | 2118383 | 37.7969081825869 | -122.429807420143 | (37.7969081825869, -122.429807420143) | 13 | 9 | 1 | 57 | 17 | |||
118466 | 116773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||||
183423 | 63773 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 400 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24453 | 6004132.01414207 | 2101578.81224199 | 37.7507689616906 | -122.428550126724 | (37.7507689616906, -122.428550126724) | 2 | 4 | 5 | 28862 | 22 | ||
119041 | 63779 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 143 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24460 | 6004205.74848694 | 2101576.80650466 | 37.7507676268483 | -122.428295003883 | (37.7507676268483, -122.428295003883) | 2 | 4 | 5 | 28862 | 22 | ||
160997 | 64287 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 359 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25092 | 6004210.28159871 | 2098359.34465346 | 37.7419334769159 | -122.428050070914 | (37.7419334769159, -122.428050070914) | 2 | 7 | 5 | 63 | 7 | ||
186297 | 63778 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 140 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24459 | 6004215.48168844 | 2101629.42267968 | 37.7509126493248 | -122.428265095141 | (37.7509126493248, -122.428265095141) | 2 | 4 | 5 | 28862 | 22 |
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) );