trees
2,421 rows where qSpecies_id = 8 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194475 | 207568 | Prune Opt Out 3 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | Permit Number 788015 | 5993375.17513 | 2105731.36286 | 37.7615561785078 | -122.466049635587 | (37.7615561785078, -122.466049635587) | 1 | 8 | 11 | 56 | 12 | ||
194416 | 179075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
194407 | 265071 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 430 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000887 | 2092304 | 37.7251183251209 | -122.439106989741 | (37.7251183251209, -122.439106989741) | 9 | 7 | 6 | 28861 | 25 | ||||
194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
194197 | 32843 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 838 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1996 12:00:00 AM | Permit Number 37197 | 6001875.52927375 | 2101649.48990957 | 37.7508350700837 | -122.43635829546 | (37.7508350700837, -122.43635829546) | 2 | 4 | 5 | 28862 | 22 | ||
194176 | 126553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 247 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012114.08056 | 2119104.08763 | 37.7993378371204 | -122.402179267671 | (37.7993378371204, -122.402179267671) | 3 | 1 | 10 | 28860 | 6 | |||
194167 | 224071 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000023.07731 | 2105733.76605 | 37.7619440614764 | -122.443057509717 | (37.7619440614764, -122.443057509717) | 15 | 5 | 5 | 28862 | 3 | |||
194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 | |||
194004 | 85541 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007564 | 2109156 | 37.7717677882225 | -122.417218858728 | (37.7717677882225, -122.417218858728) | 8 | 2 | 9 | 28853 | 19 | |||
193774 | 223500 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 269 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006752.00707 | 2102225.69278 | 37.7526930683357 | -122.419535830631 | (37.7526930683357, -122.419535830631) | 2 | 4 | 7 | 28859 | 19 | |||
193756 | 61982 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3150 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/1989 12:00:00 AM | Permit Number 22049 | 6004241.15992791 | 2119938.65131172 | 37.8011867438319 | -122.429481874601 | (37.8011867438319, -122.429481874601) | 13 | 9 | 1 | 57 | 17 | ||
193613 | 191676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 288 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008127.34613 | 2108835.28118 | 37.7709188467549 | -122.415247494384 | (37.7709188467549, -122.415247494384) | 8 | 2 | 9 | 28853 | 19 | |||
193351 | 90346 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1351X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991366.65333 | 2111298.67818 | 37.7767264470425 | -122.473402303093 | (37.7767264470425, -122.473402303093) | 11 | 6 | 2 | 54 | 26 | ||
193193 | 83529 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 801X Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3x3 | Permit Number 50887 | 5998610 | 2107600 | 37.7669875996224 | -122.448079148071 | (37.7669875996224, -122.448079148071) | 15 | 5 | 11 | 29492 | 9 | ||
192873 | 45557 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 399 Duncan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2001 12:00:00 AM | Permit Number 44428 | 6003953.11185898 | 2099806.69128577 | 37.7458930039208 | -122.429042450873 | (37.7458930039208, -122.429042450873) | 2 | 7 | 5 | 63 | 22 | |||
192858 | 176227 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 883 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001457.22396 | 2089001.68524 | 37.7160833414588 | -122.436899487435 | (37.7160833414588, -122.436899487435) | 9 | 7 | 6 | 28861 | 5 | |||
192708 | 15051 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | 10 | 3 | 8 | 58 | 1 | ||
192643 | 64883 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | Permit Number 25908 | 5990736.71325553 | 2098846.97706037 | 37.7425008919022 | -122.474672428109 | (37.7425008919022, -122.474672428109) | 1 | 8 | 4 | 29491 | 40 | ||
192617 | 223653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 360 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003566.55526 | 2095262.2275 | 37.7333930596415 | -122.430054982967 | (37.7333930596415, -122.430054982967) | 2 | 7 | 5 | 28861 | 25 | |||
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 | |||
192563 | 52642 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1382@ CENTRAL Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50986 | 5999953.27694394 | 2109203.69693502 | 37.7714676440206 | -122.443548192199 | (37.7714676440206, -122.443548192199) | 15 | 5 | 11 | 29492 | 9 | ||
192545 | 126515 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3616 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997525.9275 | 2115116.25328 | 37.7875632438067 | -122.452371201775 | (37.7875632438067, -122.452371201775) | 11 | 6 | 1 | 54 | 31 | |||
192513 | 85040 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 946 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49388 | 5995963.8 | 2090215.2 | 37.7191016102225 | -122.455974934213 | (37.7191016102225, -122.455974934213) | 9 | 8 | 6 | 28861 | 24 | |||
192495 | 7679 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2008 12:00:00 AM | 18 | 3x3 | 5994818.31491 | 2110743.00765 | 37.7753999939995 | -122.461421774878 | (37.7753999939995, -122.461421774878) | 11 | 6 | 2 | 54 | 11 | ||
192449 | 207534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990839.12843 | 2104968.89337 | 37.7593160059549 | -122.474765039286 | (37.7593160059549, -122.474765039286) | 1 | 8 | 4 | 56 | 12 | |||
192414 | 60717 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 41 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | Permit Number 20370 | 6005271.64346124 | 2105221.71929321 | 37.7608359608708 | -122.424868327925 | (37.7608359608708, -122.424868327925) | 2 | 4 | 5 | 28859 | 19 | |||
192290 | 255522 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 513 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782014 | 6004052.85891 | 2110487.65333 | 37.7752260248335 | -122.429459106998 | (37.7752260248335, -122.429459106998) | 7 | 9 | 11 | 29492 | 10 |
192280 | 207668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5993218.37994 | 2103939.27456 | 37.756626524017 | -122.466461665387 | (37.756626524017, -122.466461665387) | 1 | 8 | 4 | 56 | 12 | |||
191996 | 52434 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1807 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2005 12:00:00 AM | Permit Number 48548 | 6004817.68850791 | 2115436.94951127 | 37.7888588401734 | -122.427165998542 | (37.7888588401734, -122.427165998542) | 13 | 9 | 11 | 28858 | 27 | ||
191923 | 62765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23119 | 5993354.34924416 | 2103942.93195158 | 37.7566444112368 | -122.465991704098 | (37.7566444112368, -122.465991704098) | 1 | 8 | 4 | 56 | 12 | ||
191832 | 5105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.71459 | 37.7367149871144 | -122.434605539024 | (37.7367149871144, -122.434605539024) | 2 | 7 | 5 | 63 | 7 | ||
191771 | 207536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1422 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991820.20399 | 2105720.01268 | 37.7614351827994 | -122.471426765747 | (37.7614351827994, -122.471426765747) | 1 | 8 | 4 | 56 | 12 | |||
191695 | 223392 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 35 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005261.50146 | 2105224.90356 | 37.7608441312586 | -122.424903631195 | (37.7608441312586, -122.424903631195) | 2 | 4 | 5 | 28859 | 19 | |||
191582 | 87901 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50919 | 6007188 | 2097721 | 37.7403487442124 | -122.417708821494 | (37.7403487442124, -122.417708821494) | 2 | 7 | 7 | 28859 | 2 | ||
191545 | 248575 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 185 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5998282.3988 | 2107687.3856 | 37.7672088058363 | -122.449218560454 | (37.7672088058363, -122.449218560454) | 15 | 5 | 11 | 29492 | 9 | |||
191421 | 223375 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | 8 | 4 | 7 | 28859 | 19 | |||
191324 | 30936 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1093 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/2016 12:00:00 AM | 1 | Permit Number 775227 | 5995909.99468 | 2091121.8923 | 37.7215880844914 | -122.456226438915 | (37.7215880844914, -122.456226438915) | 9 | 8 | 6 | 28861 | 24 | |
191267 | 64261 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25063 | 6009942.27368722 | 2100102.27070153 | 37.7470418016369 | -122.408353511002 | (37.7470418016369, -122.408353511002) | 2 | 7 | 7 | 28859 | 2 | ||
190955 | 123735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 398 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5994515.79324 | 2110787.16748 | 37.7755038287288 | -122.462471464384 | (37.7755038287288, -122.462471464384) | 11 | 6 | 2 | 54 | 11 | |||
190937 | 189272 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | 10 | 3 | 8 | 58 | 1 | |||
190922 | 69233 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 539 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33289 | 6005277.10094302 | 2110933.89585771 | 37.77652053588 | -122.42525593371 | (37.77652053588, -122.42525593371) | 7 | 9 | 11 | 28852 | 10 | ||
190833 | 90349 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992315.42608 | 2111334.89456 | 37.7768807822567 | -122.470122884589 | (37.7768807822567, -122.470122884589) | 11 | 6 | 2 | 54 | 11 | ||
190526 | 62432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4411 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50975 | 5999996.18953726 | 2105731.90313751 | 37.7619374132884 | -122.443150369901 | (37.7619374132884, -122.443150369901) | 15 | 5 | 5 | 28862 | 3 | ||
190274 | 223601 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280x Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007724 | 2106220 | 37.7637152201621 | -122.416457403809 | (37.7637152201621, -122.416457403809) | 8 | 4 | 7 | 28859 | 19 | |||
190272 | 207677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2179 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991297.81767 | 2100622.90222 | 37.7474096214735 | -122.472861782445 | (37.7474096214735, -122.472861782445) | 1 | 8 | 4 | 29491 | 40 | |||
190222 | 52804 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013685.88605 | 2104111.17484 | 37.758258318682 | -122.395689167119 | (37.758258318682, -122.395689167119) | 10 | 3 | 8 | 28856 | 29 | ||
190107 | 161124 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781528 | 6003266.33968 | 2090358.66738 | 37.7199119739285 | -122.430743107307 | (37.7199119739285, -122.430743107307) | 9 | 7 | 6 | 28861 | 5 | |
190056 | 49867 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Bosworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | 3x3 | Permit Number 46634 | 6003577.84688999 | 2095267.92973361 | 37.7334093561858 | -122.430016351279 | (37.7334093561858, -122.430016351279) | 2 | 7 | 5 | 28861 | 25 | ||
189927 | 58574 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 131 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1992 12:00:00 AM | Permit Number 30452 | 5997850.5042079 | 2106776.22062192 | 37.7646822655699 | -122.450646713878 | (37.7646822655699, -122.450646713878) | 15 | 5 | 11 | 29492 | 9 | ||
189880 | 137795 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2001 CALIFORNIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004791.6159 | 2115599.7237 | 37.7893043027615 | -122.427267805749 | (37.7893043027615, -122.427267805749) | 13 | 9 | 11 | 28858 | 27 | |||
189860 | 124355 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | 11 | 6 | 2 | 54 | 11 | |||
189816 | 123739 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5994624.79373 | 2110737.82643 | 37.7753746276433 | -122.462090829336 | (37.7753746276433, -122.462090829336) | 11 | 6 | 2 | 54 | 11 | |||
189798 | 62105 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 421 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/28/1985 12:00:00 AM | Permit Number 22198 | 6006808.65111019 | 2101325.06027725 | 37.7502233274314 | -122.419276061715 | (37.7502233274314, -122.419276061715) | 2 | 4 | 7 | 28859 | 19 | ||
189731 | 207629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1256 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993954.61606 | 2106931.98149 | 37.7648861755735 | -122.464132764815 | (37.7648861755735, -122.464132764815) | 11 | 5 | 11 | 56 | 12 | |||
189658 | 224100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2x Gough St | 4 | Median : Yard | Tree | DPW 1 | 2 | Width 10ft | 6006621.45587 | 2109260.75005 | 37.7720023355618 | -122.420486623569 | (37.7720023355618, -122.420486623569) | 8 | 2 | 9 | 28853 | 19 | |||
189626 | 223630 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006717.14854 | 2102234.28269 | 37.7527146907313 | -122.419656987287 | (37.7527146907313, -122.419656987287) | 2 | 4 | 7 | 28859 | 19 | |||
189577 | 35081 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
189516 | 189262 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011918.91443 | 2098133.46059 | 37.7417463620964 | -122.401380076136 | (37.7417463620964, -122.401380076136) | 10 | 3 | 8 | 58 | 1 | |||
189514 | 43646 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 620 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/2000 12:00:00 AM | 4.5x4.5 | Permit Number 43293 | 5998690.88618203 | 2105622.06186628 | 37.7615613024153 | -122.447656976488 | (37.7615613024153, -122.447656976488) | 15 | 5 | 11 | 29492 | 12 | |
189482 | 97895 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 375X Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008901.5 | 2100225.6 | 37.7473220995732 | -122.411961145064 | (37.7473220995732, -122.411961145064) | 2 | 7 | 7 | 28859 | 2 | ||
189274 | 46110 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3x3 | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
189244 | 189253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 3 | : | Tree | Private 2 | 1 | Width 4ft | 6010832.24307 | 2097967.49844 | 37.7412299758817 | -122.405125761461 | (37.7412299758817, -122.405125761461) | 10 | 3 | 8 | 58 | 1 | |||
189239 | 63459 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/17/1987 12:00:00 AM | Permit Number 24050 | 6006045.33301804 | 2095867.39473231 | 37.7351947901182 | -122.421528105477 | (37.7351947901182, -122.421528105477) | 2 | 7 | 7 | 28859 | 2 | ||
189192 | 207659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1340 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994898.23943 | 2106428.28078 | 37.7635574848094 | -122.460832527225 | (37.7635574848094, -122.460832527225) | 15 | 5 | 11 | 56 | 12 | |||
189133 | 189265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536 | (37.7416407727111, -122.40119276536) | 10 | 3 | 8 | 58 | 1 | |||
189088 | 90545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993401.41379 | 2110748.94947 | 37.7753346563587 | -122.466323559806 | (37.7753346563587, -122.466323559806) | 11 | 6 | 2 | 54 | 11 | ||
188987 | 216737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.50939 | 37.7184704425356 | -122.454167365558 | (37.7184704425356, -122.454167365558) | 9 | 8 | 6 | 28861 | 24 | ||
188947 | 207687 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990748.39034 | 2098537.74279 | 37.7416524908805 | -122.474609488939 | (37.7416524908805, -122.474609488939) | 1 | 8 | 4 | 29491 | 40 | |||
188777 | 67134 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1319 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 30557 | 5994845.70633792 | 2106566.77166106 | 37.7639347220406 | -122.461024259768 | (37.7639347220406, -122.461024259768) | 15 | 5 | 11 | 56 | 12 | ||
188702 | 65262 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28063 | 6009506.97444582 | 2102339.79830216 | 37.7531611699928 | -122.410016678829 | (37.7531611699928, -122.410016678829) | 2 | 4 | 7 | 28859 | 19 | ||
188581 | 50218 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2536 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/2003 12:00:00 AM | 2 | Permit Number 46925 | 5987649.93004 | 2111223.20837 | 37.7763033030168 | -122.486253845001 | (37.7763033030168, -122.486253845001) | 11 | 6 | 2 | 55 | 26 | |
188571 | 114248 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 2 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
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 | |
188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
188491 | 207646 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992160.47929 | 2104938.30605 | 37.7593085011052 | -122.47019298042 | (37.7593085011052, -122.47019298042) | 1 | 8 | 4 | 56 | 12 | |||
188433 | 47821 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 649 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772575 | 5981934.18686 | 2111319.10123 | 37.7762318023646 | -122.506032952708 | (37.7762318023646, -122.506032952708) | 11 | 6 | 2 | 55 | 26 |
188422 | 224093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 353 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004017.83242 | 2109024.56898 | 37.7712067701103 | -122.429475909489 | (37.7712067701103, -122.429475909489) | 7 | 9 | 11 | 29492 | 10 | |||
188405 | 90344 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1431 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5991109.30378 | 2111288.54899 | 37.7766837293707 | -122.474291803216 | (37.7766837293707, -122.474291803216) | 11 | 6 | 2 | 54 | 26 | ||
188358 | 64226 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | Permit Number 32010 | 5991523.10149866 | 2113391.31438149 | 37.7824813099729 | -122.473013746659 | (37.7824813099729, -122.473013746659) | 11 | 6 | 2 | 54 | 26 | ||
188285 | 91001 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2501 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2008 12:00:00 AM | 3 | 3x3 | 5987771.13659 | 2111168.45411 | 37.7761600268515 | -122.485830543565 | (37.7761600268515, -122.485830543565) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
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 | ||
188006 | 223551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.7640629073877 | -122.45115331019 | (37.7640629073877, -122.45115331019) | 15 | 5 | 11 | 29492 | 9 | |||
187938 | 52127 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | Permit Number 48312 | 6003680.41407753 | 2109722.31110522 | 37.7731034892906 | -122.430692851209 | (37.7731034892906, -122.430692851209) | 15 | 9 | 11 | 29492 | 10 | ||
187921 | 62758 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1602 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23109 | 5992796.63106595 | 2104544.17081443 | 37.7582630660405 | -122.46796420941 | (37.7582630660405, -122.46796420941) | 1 | 8 | 4 | 56 | 12 | ||
187900 | 88589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 874 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.483083792767 | (37.7731428326728, -122.483083792767) | 11 | 6 | 2 | 55 | 26 | ||
187842 | 61998 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3337 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1985 12:00:00 AM | 10 | Permit Number 22065 | 6004092.37742 | 2120634.4827 | 37.8030888913932 | -122.430046392648 | (37.8030888913932, -122.430046392648) | 13 | 9 | 1 | 57 | 17 | |
187784 | 176245 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011861.55971 | 2090354.44953 | 37.7203836161938 | -122.401031937775 | (37.7203836161938, -122.401031937775) | 10 | 7 | 8 | 309 | 28 | |||
187764 | 108579 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1655X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 6008581 | 2118626 | 37.7978272872591 | -122.414371155882 | (37.7978272872591, -122.414371155882) | 5 | 1 | 10 | 308 | 21 | ||||
187749 | 90338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990591.656258 | 2111279.589406 | 37.7766291263166 | -122.47608182516 | (37.7766291263166, -122.47608182516) | 11 | 6 | 2 | 55 | 26 | ||
187727 | 85557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6008653.68072 | 2108532.35146 | 37.7701166389055 | -122.413405456202 | (37.7701166389055, -122.413405456202) | 8 | 2 | 9 | 28853 | 19 | |||
187709 | 28242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2001 12:00:00 AM | 3 | 3X3 | 6003956.63253 | 2110750.38303 | 37.7759419673559 | -122.42981071961 | (37.7759419673559, -122.42981071961) | 7 | 9 | 11 | 29492 | 10 | ||
187662 | 223397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3560 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005876.75311 | 2104933.14392 | 37.7600777604998 | -122.422755010534 | (37.7600777604998, -122.422755010534) | 2 | 4 | 5 | 28859 | 19 | |||
187626 | 126512 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 251 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000962.49695 | 2119994.9542 | 37.8011551592542 | -122.440831489795 | (37.8011551592542, -122.440831489795) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
187425 | 126520 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 250 Alhambra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000968.94208 | 2120040.14536 | 37.8012796092356 | -122.440812430464 | (37.8012796092356, -122.440812430464) | 13 | 9 | 1 | 57 | 17 | |||
187188 | 64891 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25917 | 5990795.79188789 | 2098640.41442028 | 37.741937147211 | -122.474453082867 | (37.741937147211, -122.474453082867) | 1 | 8 | 4 | 29491 | 40 | ||
187177 | 244451 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003597.7695 | 2109704.6031 | 37.7730501849709 | -122.430977465184 | (37.7730501849709, -122.430977465184) | 15 | 9 | 11 | 29492 | 10 | |||
187096 | 123740 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 301 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994649.40915 | 2110738.31442 | 37.7753773847387 | -122.462005714867 | (37.7753773847387, -122.462005714867) | 11 | 6 | 2 | 54 | 11 | |||
187067 | 88204 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 225 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51209 | 5998766 | 2109964 | 37.7734874588052 | -122.447709769744 | (37.7734874588052, -122.447709769744) | 15 | 5 | 11 | 29492 | 16 |
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) );