trees
340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
5548 | 64543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | 10 | 3 | 8 | 58 | 1 | ||
11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
29812 | 99390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
30232 | 99397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
32256 | 99396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
37859 | 46993 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
38088 | 99382 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
41732 | 114444 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
42729 | 64533 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1423 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25415 | 6015974.60065069 | 2094744.26862441 | 37.732665776815 | -122.387120391311 | (37.732665776815, -122.387120391311) | 10 | 3 | 8 | 58 | 1 | ||
47946 | 46990 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
52892 | 64551 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1315 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25434 | 6016281.43381852 | 2094844.2486814 | 37.7329572884599 | -122.386066550856 | (37.7329572884599, -122.386066550856) | 10 | 3 | 8 | 58 | 1 | ||
52958 | 64541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1513 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25424 | 6015494.68772587 | 2095105.29398738 | 37.7336304924024 | -122.388804777662 | (37.7336304924024, -122.388804777662) | 10 | 3 | 8 | 58 | 1 | ||
53959 | 64549 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1414 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25432 | 6015539.44017214 | 2095047.54254922 | 37.7334743989165 | -122.388646024077 | (37.7334743989165, -122.388646024077) | 10 | 3 | 8 | 58 | 1 | ||
54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
55786 | 95669 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
56655 | 99384 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
64054 | 52809 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
64253 | 114443 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
68640 | 52808 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
69871 | 95668 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
73029 | 46994 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
74544 | 99389 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
74862 | 95670 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
75361 | 46996 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
75967 | 82925 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 733 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52380 | 6012148.34936451 | 2104990.04920575 | 37.7605858648735 | -122.401068426273 | (37.7605858648735, -122.401068426273) | 10 | 3 | 8 | 28856 | 29 | ||
76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
79507 | 94172 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
86145 | 46992 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
89001 | 102356 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
91138 | 114442 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
93543 | 46988 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
95979 | 99388 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
99511 | 114445 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
102488 | 94173 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
106707 | 46991 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
107441 | 64546 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25429 | 6015168.9161816 | 2095349.91748359 | 37.7342841175888 | -122.389948156264 | (37.7342841175888, -122.389948156264) | 10 | 3 | 8 | 58 | 1 | ||
112415 | 46997 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
112448 | 57789 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/1988 12:00:00 AM | Permit Number 16716 | 6015407.18997447 | 2095895.9761965 | 37.7357966956695 | -122.389162475837 | (37.7357966956695, -122.389162475837) | 10 | 3 | 8 | 58 | 1 | ||
115638 | 61795 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2124 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | Permit Number 21818 | 6012164.19544903 | 2102373.44678404 | 37.7534021337144 | -122.400829785677 | (37.7534021337144, -122.400829785677) | 10 | 3 | 8 | 28856 | 29 | ||
118101 | 64526 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25408 | 6015994.96935812 | 2094728.94048025 | 37.7326248167159 | -122.387048902328 | (37.7326248167159, -122.387048902328) | 10 | 3 | 8 | 58 | 1 | ||
121083 | 64539 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25422 | 6015648.7013223 | 2094989.51893827 | 37.7333211324836 | -122.38826422578 | (37.7333211324836, -122.38826422578) | 10 | 3 | 8 | 58 | 1 | ||
133236 | 35731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
140580 | 94897 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1375 Keith St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 53955 | 6016208.4 | 2094705 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | 10 | 3 | 8 | 58 | 1 | |||
146226 | 52806 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
147450 | 64542 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1535 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25425 | 6015382.7037495 | 2095189.38332023 | 37.7338551773356 | -122.389197811817 | (37.7338551773356, -122.389197811817) | 10 | 3 | 8 | 58 | 1 | ||
147844 | 99392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
148788 | 46995 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
148937 | 114446 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
151895 | 35732 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
156342 | 64545 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25428 | 6015138.37508416 | 2095372.85094775 | 37.734345394408 | -122.390055349092 | (37.734345394408, -122.390055349092) | 10 | 3 | 8 | 58 | 1 | ||
156725 | 35729 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Dunsmuir St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39008 | 6008063.83773317 | 2094291.11517944 | 37.7309802758886 | -122.414437878529 | (37.7309802758886, -122.414437878529) | 9 | 3 | 7 | 309 | 28 | ||
159416 | 103923 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
161205 | 84784 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Charter Oak Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | Permit No. 49320 | 6010961.8 | 2095107.4 | 37.7333839962575 | -122.40447652098 | (37.7333839962575, -122.40447652098) | 10 | 3 | 8 | 58 | 1 | |||
164893 | 67391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1992 12:00:00 AM | Permit Number 30888 | 6012577.17209413 | 2106598.24360902 | 37.7650255224957 | -122.399698234444 | (37.7650255224957, -122.399698234444) | 14 | 3 | 8 | 28856 | 20 | ||
165704 | 99383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
169572 | 94174 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
170486 | 95807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10993 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767551 | 6014326.8 | 2102083.7 | 37.752726939242 | -122.393330710599 | (37.752726939242, -122.393330710599) | 10 | 3 | 8 | 28856 | 29 | |
172911 | 114448 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
176741 | 43028 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2131 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | Permit Number 42891 | 6012232.74483127 | 2101350.9845752 | 37.7505984979091 | -122.400520909002 | (37.7505984979091, -122.400520909002) | 10 | 3 | 8 | 28856 | 1 | |||
179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
181547 | 99391 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
187500 | 103915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
188152 | 64547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25430 | 6015240.17870423 | 2095296.4060958 | 37.7341411380387 | -122.389698040486 | (37.7341411380387, -122.389698040486) | 10 | 3 | 8 | 58 | 1 | ||
188224 | 46989 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
188535 | 95671 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Colby St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767425 | 6009110 | 2090446 | 37.7204811172617 | -122.41054968459 | (37.7204811172617, -122.41054968459) | 9 | 3 | 7 | 309 | 28 | |
51453 | 64531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1410 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | 0 | Permit Number 25413 | 6016066.97411905 | 2094739.83359707 | 37.7326587139482 | -122.386800721401 | (37.7326587139482, -122.386800721401) | 10 | 3 | 8 | 58 | 1 | |
65385 | 26833 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.05347 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | 10 | 3 | 8 | 58 | 1 | ||
183141 | 64538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1486 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 0 | Permit Number 25421 | 6015679.96866361 | 2095031.06834702 | 37.7334369512525 | -122.388159023613 | (37.7334369512525, -122.388159023613) | 10 | 3 | 8 | 58 | 1 | |
806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
3646 | 189251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | 10 | 3 | 8 | 58 | 1 | |||
4551 | 189261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011901.66973 | 2098145.68488 | 37.7417789652237 | -122.401440561855 | (37.7417789652237, -122.401440561855) | 10 | 3 | 8 | 58 | 1 | |||
20316 | 200101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015012.674 | 2092395.4762 | 37.7261631500088 | -122.39028199338 | (37.7261631500088, -122.39028199338) | 10 | 3 | 8 | 58 | 1 | |||
22344 | 189270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 59 Robblee Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | 10 | 3 | 8 | 58 | 1 | |||
24039 | 189257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | 10 | 3 | 8 | 58 | 1 | |||
31365 | 189263 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2211 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011935.60653 | 2098120.24236 | 37.7417109989595 | -122.401321431357 | (37.7417109989595, -122.401321431357) | 10 | 3 | 8 | 58 | 1 | |||
31692 | 189252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6010838.98568 | 2097984.08803 | 37.7412759042668 | -122.40510361565 | (37.7412759042668, -122.40510361565) | 10 | 3 | 8 | 58 | 1 | |||
44374 | 191081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015467.86658 | 2102506.20441 | 37.7539503763268 | -122.389414166444 | (37.7539503763268, -122.389414166444) | 10 | 3 | 8 | 28856 | 29 | |||
48395 | 99378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
57053 | 200107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1538 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014865.1345 | 2092505.1157 | 37.726456013252 | -122.390799692144 | (37.726456013252, -122.390799692144) | 10 | 3 | 8 | 58 | 1 | |||
57195 | 200096 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015074.2617 | 2092350.8083 | 37.7260439168499 | -122.390065967336 | (37.7260439168499, -122.390065967336) | 10 | 3 | 8 | 58 | 1 | |||
60769 | 52801 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 1 | Permit Number 48835 | 6013622.04592 | 2104108.35581 | 37.7582470267928 | -122.395909758227 | (37.7582470267928, -122.395909758227) | 10 | 3 | 8 | 28856 | 29 | ||
63346 | 189260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2223 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011881.3428 | 2098161.01193 | 37.7418199158556 | -122.401511923044 | (37.7418199158556, -122.401511923044) | 10 | 3 | 8 | 58 | 1 | |||
78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
80616 | 200100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015024.8562 | 2092385.3244 | 37.7261359509126 | -122.390239170909 | (37.7261359509126, -122.390239170909) | 10 | 3 | 8 | 58 | 1 | |||
81467 | 176242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009078.67243 | 2090418.23511 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | 9 | 3 | 7 | 309 | 28 | |||
82640 | 189254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 4 | : | Tree | Private 2 | 1 | Width 4ft | 6010822.29341 | 2097942.01462 | 37.7411594465586 | -122.405158369988 | (37.7411594465586, -122.405158369988) | 10 | 3 | 8 | 58 | 1 | |||
89263 | 6737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | ||
90719 | 200102 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014998.4615 | 2092408.3352 | 37.7261976699 | -122.390332023639 | (37.7261976699, -122.390332023639) | 10 | 3 | 8 | 58 | 1 | |||
102516 | 37990 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 1 | Permit Number 44744 | 6013820.84604 | 2104031.24845 | 37.758046364659 | -122.395216814417 | (37.758046364659, -122.395216814417) | 10 | 3 | 8 | 28856 | 29 | |
107872 | 189264 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2207 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011951.89121 | 2098108.45094 | 37.7416795307793 | -122.401264295606 | (37.7416795307793, -122.401264295606) | 10 | 3 | 8 | 58 | 1 | |||
108786 | 191082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015413.33991 | 2102503.20842 | 37.7539391266996 | -122.389602524941 | (37.7539391266996, -122.389602524941) | 10 | 3 | 8 | 28856 | 29 | |||
110041 | 200106 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1536 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014892.206 | 2092484.8121 | 37.726401765616 | -122.390704688118 | (37.726401765616, -122.390704688118) | 10 | 3 | 8 | 58 | 1 | |||
112916 | 200109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014832.6487 | 2092528.8033 | 37.7265192521755 | -122.390913649883 | (37.7265192521755, -122.390913649883) | 10 | 3 | 8 | 58 | 1 | |||
114813 | 191095 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012592.46534 | 2102823.04083 | 37.7546604998905 | -122.399380288765 | (37.7546604998905, -122.399380288765) | 10 | 3 | 8 | 28856 | 29 | |||
132797 | 200114 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1566 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014762.2628 | 2092586.3302 | 37.7266733037648 | -122.39116099243 | (37.7266733037648, -122.39116099243) | 10 | 3 | 8 | 58 | 1 | |||
149422 | 114447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6010564.67556 | 2098126.12029 | 37.7416505555295 | -122.406062091517 | (37.7416505555295, -122.406062091517) | 10 | 3 | 8 | 58 | 1 |
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) );