trees
371 rows where Fire Prevention Districts = 10 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 | |||
| 23922 | 58026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 680 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1987 12:00:00 AM | Permit Number 16994 | 6008648.68681502 | 2095709.61951023 | 37.7349080209093 | -122.412516183192 | (37.7349080209093, -122.412516183192) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 53101 | 34891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
| 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 | ||
| 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 | |||
| 71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 106857 | 111194 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 127843 | 64026 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 907 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/1987 12:00:00 AM | Permit Number 24783 | 6008326.13361224 | 2095676.92812978 | 37.7348001501968 | -122.413629054856 | (37.7348001501968, -122.413629054856) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 147933 | 68475 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 898x HAMPSHIRE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32344 | 6010178 | 2104272 | 37.7585041507506 | -122.407832365849 | (37.7585041507506, -122.407832365849) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 160868 | 66455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29605 | 6009024.9615405 | 2097864.85103927 | 37.7408469284457 | -122.411367472491 | (37.7408469284457, -122.411367472491) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 165045 | 114647 | Private 9 | Eriobotrya deflexa :: Bronze Loquat 8 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 181410 | 34892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 95 Ward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1997 12:00:00 AM | Permit Number 38498 | 6011846.48740204 | 2089823.39477464 | 37.7189246067483 | -122.401046743519 | (37.7189246067483, -122.401046743519) | 10 | 7 | 8 | 309 | 39 | |||
| 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 | ||
| 186402 | 66454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29604 | 6009026.99951004 | 2097886.74358701 | 37.7409071549012 | -122.411361972152 | (37.7409071549012, -122.411361972152) | 10 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 192566 | 64406 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2427 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/1988 12:00:00 AM | Permit Number 25251 | 6011317.18902428 | 2102741.84827953 | 37.7543664024991 | -122.403784849219 | (37.7543664024991, -122.403784849219) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 70626 | 223482 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4044 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6008350.87212 | 2096284.49377 | 37.7364697824441 | -122.413586482552 | (37.7364697824441, -122.413586482552) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 109380 | 111193 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 890x JARBOE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774267 | 6009115 | 2096842 | 37.7380434517433 | -122.410983924329 | (37.7380434517433, -122.410983924329) | 10 | 7 | 7 | 28859 | 2 | |
| 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 |
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) );