trees
230 rows where qCareAssistant = "FUF" and qSpecies_id = 97 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5392 | 60144 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1614 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19674 | 5990908.81036863 | 2104400.55481137 | 37.7577595366377 | -122.474482571431 | (37.7577595366377, -122.474482571431) | 1 | 8 | 4 | 56 | 12 | ||
54947 | 63166 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1534 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23703 | 5992780.43210356 | 2105015.68842996 | 37.7595567946867 | -122.468054529997 | (37.7595567946867, -122.468054529997) | 1 | 8 | 4 | 56 | 12 | ||
55197 | 60152 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1790 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19683 | 5990948.80079989 | 2103226.18449464 | 37.7545373426794 | -122.474258577533 | (37.7545373426794, -122.474258577533) | 1 | 8 | 4 | 56 | 12 | ||
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 | ||
50729 | 67095 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 432 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30500 | 6009952.08043631 | 2098577.67814271 | 37.7428561528472 | -122.408212089588 | (37.7428561528472, -122.408212089588) | 10 | 7 | 7 | 28859 | 2 | ||
60993 | 61785 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1495 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1987 12:00:00 AM | Permit Number 24636 | 6012051.50334521 | 2101403.29784414 | 37.7507320294913 | -122.401151335946 | (37.7507320294913, -122.401151335946) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | ||
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 | ||
115001 | 67594 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 308 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | Permit Number 31161 | 6013452.45067872 | 2105638.02121278 | 37.7624377166869 | -122.39660352483 | (37.7624377166869, -122.39660352483) | 10 | 3 | 8 | 28856 | 29 | ||
121851 | 61725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 66 Williams Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21727 | 6013825.41276045 | 2093670.69143799 | 37.7295987054368 | -122.394475571882 | (37.7295987054368, -122.394475571882) | 10 | 3 | 8 | 58 | 1 | ||
124236 | 30843 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1375 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/1995 12:00:00 AM | Permit Number 34691 | 6011743.60320296 | 2101979.83639733 | 37.7522978969141 | -122.40225661865 | (37.7522978969141, -122.40225661865) | 10 | 3 | 8 | 28856 | 29 | ||
134941 | 61310 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2337 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21209 | 6011897.61971652 | 2101840.97458612 | 37.7519252086186 | -122.4017142423 | (37.7519252086186, -122.4017142423) | 10 | 3 | 8 | 28856 | 29 | ||
164535 | 67096 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 431 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1992 12:00:00 AM | Permit Number 30501 | 6010004.32773544 | 2098578.96669132 | 37.7428626163512 | -122.408031523079 | (37.7428626163512, -122.408031523079) | 10 | 7 | 7 | 28859 | 2 | ||
165378 | 61309 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2325 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1984 12:00:00 AM | Permit Number 21208 | 6011929.28683038 | 2101842.72936764 | 37.7519317939639 | -122.40160485559 | (37.7519317939639, -122.40160485559) | 10 | 3 | 8 | 28856 | 29 | ||
167803 | 41049 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1452 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1999 12:00:00 AM | Permit Number 41829 | 6011713.00642169 | 2101589.94219711 | 37.7512256245579 | -122.402335016202 | (37.7512256245579, -122.402335016202) | 10 | 3 | 8 | 28856 | 29 | ||
173842 | 32046 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 501 Tunnel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1999 12:00:00 AM | Permit Number 35428 | 6012610 | 2086139 | 37.7088505533644 | -122.398149216451 | (37.7088505533644, -122.398149216451) | 10 | 3 | 8 | 309 | 1 | ||
193808 | 67150 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 427 Franconia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1992 12:00:00 AM | Permit Number 30582 | 6010005.12050673 | 2098589.41341875 | 37.7428913451797 | -122.40802951845 | (37.7428913451797, -122.40802951845) | 10 | 7 | 7 | 28859 | 2 | ||
60273 | 60549 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 523 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20159 | 5985000.44766821 | 2112307.598992 | 37.7791259492381 | -122.495498998876 | (37.7791259492381, -122.495498998876) | 11 | 6 | 2 | 55 | 26 | ||
64863 | 60554 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 562 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20164 | 5985061.1383554 | 2112041.58145553 | 37.7783990952425 | -122.495269425078 | (37.7783990952425, -122.495269425078) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
94509 | 63203 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23745 | 5984685.41505479 | 2112889.29978003 | 37.7807046794697 | -122.496631747831 | (37.7807046794697, -122.496631747831) | 11 | 6 | 2 | 55 | 26 | ||
98172 | 61524 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 5301 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21481 | 5991172.88177213 | 2114060.20768973 | 37.7842976232811 | -122.474274166868 | (37.7842976232811, -122.474274166868) | 11 | 6 | 2 | 54 | 26 | ||
124631 | 67263 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 552 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30730 | 5981340.11898895 | 2111976.56286736 | 37.7780020106611 | -122.508136768544 | (37.7780020106611, -122.508136768544) | 11 | 6 | 2 | 55 | 26 | ||
169413 | 62604 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 796 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 22912 | 5984497.70797117 | 2110431.26743747 | 37.7739446322992 | -122.497099617838 | (37.7739446322992, -122.497099617838) | 11 | 6 | 2 | 55 | 26 | ||
172351 | 48492 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 789(REVISED) 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1986 12:00:00 AM | Permit Number 45835 | 5984443.84017034 | 2110481.58351844 | 37.7740796289032 | -122.49728966782 | (37.7740796289032, -122.49728966782) | 11 | 6 | 2 | 55 | 26 | ||
176171 | 60542 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 615 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20152 | 5985331.57099648 | 2111677.45152223 | 37.7774151286277 | -122.494307063797 | (37.7774151286277, -122.494307063797) | 11 | 6 | 2 | 55 | 26 | ||
178899 | 61526 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 1335 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1984 12:00:00 AM | Permit Number 21483 | 5991367.33157346 | 2114748.57792616 | 37.7861989598694 | -122.47365167719 | (37.7861989598694, -122.47365167719) | 11 | 6 | 2 | 54 | 26 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||||
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 |
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 | ||
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 | ||
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 | |
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 | |
143730 | 114807 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2811 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004778.36642477 | 2119194.00734605 | 37.7991725438245 | -122.427569823594 | (37.7991725438245, -122.427569823594) | 13 | 9 | 1 | 57 | 17 | ||||
183193 | 65401 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 747 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1989 12:00:00 AM | Permit Number 28250 | 6008150.2130763 | 2114455.0011203 | 37.7863505404889 | -122.415566339973 | (37.7863505404889, -122.415566339973) | 13 | 1 | 9 | 28858 | 36 | ||
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 | ||
98731 | 64717 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 35 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25671 | 6010371.58706878 | 2113906.86566108 | 37.7849701038252 | -122.407842251054 | (37.7849701038252, -122.407842251054) | 14 | 10 | 10 | 28852 | 36 | ||
111103 | 64725 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 174 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25680 | 6010012.44318345 | 2114072.97215331 | 37.7854060800363 | -122.409096504402 | (37.7854060800363, -122.409096504402) | 14 | 10 | 9 | 28852 | 36 | ||
144563 | 64727 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 166 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25682 | 6009623.89289745 | 2113671.39889681 | 37.7842816815144 | -122.410412412425 | (37.7842816815144, -122.410412412425) | 14 | 10 | 9 | 28852 | 36 | ||
186261 | 64726 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 127 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1988 12:00:00 AM | Permit Number 25681 | 6010217.12887008 | 2114048.91615067 | 37.7853514923776 | -122.40838665256 | (37.7853514923776, -122.40838665256) | 14 | 10 | 10 | 28852 | 36 | ||
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 | ||
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 | ||||
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 | ||
17568 | 60045 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 235 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22998 | 6003601.05151902 | 2109138.05302848 | 37.7714947633279 | -122.430925670981 | (37.7714947633279, -122.430925670981) | 15 | 9 | 11 | 29492 | 10 | ||
27367 | 62428 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 223 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1986 12:00:00 AM | Permit Number 22976 | 6003655.90381046 | 2109145.69391809 | 37.7715188511616 | -122.430736479427 | (37.7715188511616, -122.430736479427) | 15 | 9 | 11 | 29492 | 10 | ||
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 | ||
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 | ||
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 | |||
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 | ||
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 | ||||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
98278 | 66836 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2920 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1993 12:00:00 AM | Permit Number 30137 | 5997039.99678003 | 2111588.58372334 | 37.777849344501 | -122.453797573256 | (37.777849344501, -122.453797573256) | 15 | 6 | 2 | 54 | 16 | ||
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 | ||
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 | |
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 | ||
114874 | 61139 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2128 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/1983 12:00:00 AM | Permit Number 20991 | 5997627.50212199 | 2110268.03572246 | 37.7742571277486 | -122.451669915896 | (37.7742571277486, -122.451669915896) | 15 | 5 | 2 | 29492 | 16 | ||
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 | ||
128171 | 62436 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 227 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | 14 | 3x3 | Permit Number 772864 | 5999948.2266718 | 2105562.60505464 | 37.7614698277306 | -122.443304093705 | (37.7614698277306, -122.443304093705) | 15 | 5 | 5 | 28862 | 3 |
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 |
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 | ||
142226 | 62668 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 275 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 23000 | 6003418.21056461 | 2109112.58339882 | 37.7714144683632 | -122.43155630855 | (37.7714144683632, -122.43155630855) | 15 | 9 | 11 | 29492 | 10 | ||
146415 | 56882 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 228 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1986 12:00:00 AM | Permit Number 22996 | 6003621.30337351 | 2109193.37618724 | 37.7716478146462 | -122.430859567614 | (37.7716478146462, -122.430859567614) | 15 | 9 | 11 | 29492 | 10 | ||
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 | ||||
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 | ||
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 | ||
161649 | 62442 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 3090 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22605 | 5999929.32075843 | 2105305.0040382 | 37.7607614409418 | -122.443350977814 | (37.7607614409418, -122.443350977814) | 15 | 5 | 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 | ||
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 | ||
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 | ||
192915 | 66937 | Permitted Site 7 | Ficus microcarpa :: Chinese Banyan 97 | 2350 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/1992 12:00:00 AM | Permit Number 30262 | 5998853.41639727 | 2111835.46191539 | 37.7786310079222 | -122.447542123222 | (37.7786310079222, -122.447542123222) | 15 | 6 | 2 | 54 | 16 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 |
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) );