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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186859 | 236267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 775137 | 6007694.337 | 2107447.14933 | 37.7670830178903 | -122.41664693662 | (37.7670830178903, -122.41664693662) | 8 | 4 | 7 | 28853 | 19 | |
| 186728 | 189259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011864.29034 | 2098174.02921 | 37.7418547070232 | -122.401571799894 | (37.7418547070232, -122.401571799894) | 10 | 3 | 8 | 58 | 1 | |||
| 186715 | 90190 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1844 Balboa St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.55594 | 37.7766347733354 | -122.478851145848 | (37.7766347733354, -122.478851145848) | 11 | 6 | 2 | 55 | 26 | |||
| 186659 | 54213 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9951 | 5993547.73398631 | 2106617.88649247 | 37.7640002940645 | -122.465517235123 | (37.7640002940645, -122.465517235123) | 1 | 8 | 11 | 56 | 12 | |||
| 186562 | 26117 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015648.6011 | 2094991.9741 | 37.7333278683102 | -122.38826474357 | (37.7333278683102, -122.38826474357) | 10 | 3 | 8 | 58 | 1 | ||
| 186436 | 90544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 700 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5993430.86154 | 2110749.39946 | 37.7753375909806 | -122.466221726766 | (37.7753375909806, -122.466221726766) | 11 | 6 | 2 | 54 | 11 | ||
| 186411 | 207641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.3894 | 2104844.15149 | 37.7590501456751 | -122.470176059699 | (37.7590501456751, -122.470176059699) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | ||
| 186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
| 186399 | 58476 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 772 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/1978 12:00:00 AM | 15 | 8x7 | Permit Number 17633 | 5998628.49862087 | 2107799.74145876 | 37.7675370965506 | -122.448029547496 | (37.7675370965506, -122.448029547496) | 15 | 5 | 11 | 29492 | 9 | |
| 186285 | 90322 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989457.99472 | 2111233.88007 | 37.7764378199226 | -122.480000100994 | (37.7764378199226, -122.480000100994) | 11 | 6 | 2 | 55 | 26 | ||
| 186256 | 176231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001253.10056 | 2089784.48632 | 37.7182211342895 | -122.437661063033 | (37.7182211342895, -122.437661063033) | 9 | 7 | 6 | 28861 | 5 | |||
| 185944 | 123751 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5995599.55133 | 2110826.05638 | 37.7756729573693 | -122.458725326168 | (37.7756729573693, -122.458725326168) | 11 | 6 | 2 | 54 | 11 | ||
| 185690 | 123088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 681 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992531.98412 | 2110836.60467 | 37.77552513003 | -122.469337473167 | (37.77552513003, -122.469337473167) | 11 | 6 | 2 | 54 | 11 | |||
| 185618 | 98973 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.7548994960031 | -122.414464835105 | (37.7548994960031, -122.414464835105) | 2 | 4 | 7 | 28859 | 19 | ||
| 185617 | 223639 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200X Bartlett St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006697.50598 | 2102457.70308 | 37.7533270454234 | -122.419740766324 | (37.7533270454234, -122.419740766324) | 2 | 4 | 7 | 28859 | 19 | |||
| 185481 | 36988 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 800 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39609 | 5993070.986847 | 2113501.00043119 | 37.7828719719487 | -122.467666762888 | (37.7828719719487, -122.467666762888) | 11 | 6 | 2 | 54 | 11 | ||
| 185311 | 58274 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 679 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | 11 | Permit Number 28518 | 6002069.69674 | 2089980.14992 | 37.7188047799052 | -122.434852426303 | (37.7188047799052, -122.434852426303) | 9 | 7 | 6 | 28861 | 5 | |
| 185006 | 90538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993999.75681 | 2110771.22635 | 37.7754303285192 | -122.464255386494 | (37.7754303285192, -122.464255386494) | 11 | 6 | 2 | 54 | 11 | ||
| 184595 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 100x OGDEN AVE | 4 | Back Yard : Yard | Tree | Private 2 | 6007659 | 2096105 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | 2 | 7 | 7 | 28859 | 2 | |||||
| 184438 | 62674 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 391 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31517 | 6003426.2105163 | 2098608.75328602 | 37.7425739041197 | -122.430778928831 | (37.7425739041197, -122.430778928831) | 2 | 7 | 5 | 63 | 22 | ||
| 184359 | 49493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 8 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 184301 | 4333 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 5X Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001761.4698131 | 2095822.8308427 | 37.7348299498779 | -122.436335765698 | (37.7348299498779, -122.436335765698) | 2 | 7 | 5 | 63 | 7 | |||
| 184289 | 207549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993919.81303 | 2106419.06836 | 37.7634758443473 | -122.464215899053 | (37.7634758443473, -122.464215899053) | 1 | 5 | 11 | 56 | 12 | |||
| 184145 | 45300 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
| 184071 | 141025 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998165.4308 | 2112645.9232 | 37.7808169824501 | -122.449980546707 | (37.7808169824501, -122.449980546707) | 15 | 6 | 2 | 54 | 16 | |||
| 183973 | 223509 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006634.2551 | 2102596.18969 | 37.7537037345613 | -122.419969328122 | (37.7537037345613, -122.419969328122) | 2 | 4 | 7 | 28859 | 19 | |||
| 183924 | 191075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 352 12th St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6008288.60526 | 2108804.28402 | 37.7708427973966 | -122.414687499122 | (37.7708427973966, -122.414687499122) | 8 | 2 | 9 | 28853 | 19 | |||
| 183880 | 207638 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1538 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993396.48962 | 2104999.12354 | 37.7595468700202 | -122.465922710668 | (37.7595468700202, -122.465922710668) | 1 | 8 | 4 | 56 | 12 | |||
| 183879 | 51750 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | 6 | Permit Number 48020 | 5989629.76736 | 2112987.41168 | 37.7812625086441 | -122.4795342239 | (37.7812625086441, -122.4795342239) | 11 | 6 | 2 | 55 | 26 | ||
| 183853 | 191678 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 194 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007565.31413 | 2109155.0801 | 37.7717653363258 | -122.417214247857 | (37.7717653363258, -122.417214247857) | 8 | 2 | 9 | 28853 | 19 | |||
| 183774 | 115293 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644 | 37.7474306230823 | -122.475067792345 | (37.7474306230823, -122.475067792345) | 1 | 8 | 4 | 29491 | 40 | |||
| 183766 | 46113 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 798 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2001 12:00:00 AM | 3xe | Permit Number 44472 | 5997167.07493712 | 2107760.6930909 | 37.767346232554 | -122.453081574039 | (37.767346232554, -122.453081574039) | 15 | 5 | 11 | 29492 | 9 | ||
| 183743 | 223377 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2801 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010298.33819 | 2101037.92652 | 37.7496308398979 | -122.407188209083 | (37.7496308398979, -122.407188209083) | 2 | 4 | 7 | 28859 | 19 | |||
| 183650 | 47558 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 206 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45420 | 6004100.72419306 | 2102141.4355601 | 37.7523120229359 | -122.428698432782 | (37.7523120229359, -122.428698432782) | 2 | 4 | 5 | 28862 | 22 | ||
| 183538 | 21343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 183343 | 52128 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 600 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | |||
| 183330 | 25956 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2695X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.76868 | 37.7419520589748 | -122.403153994092 | (37.7419520589748, -122.403153994092) | 10 | 3 | 8 | 58 | 1 | ||
| 183152 | 33018 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3638 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37306 | 6005540.00148664 | 2101997.41979374 | 37.7519979406206 | -122.423710937024 | (37.7519979406206, -122.423710937024) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | |
| 183033 | 117303 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1075 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778518 | 6009488.7 | 2102920.1 | 37.754753524299 | -122.410120841459 | (37.754753524299, -122.410120841459) | 2 | 4 | 7 | 28859 | 19 | ||
| 182996 | 31016 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 182782 | 56166 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 623 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12274 | 5990937.74428 | 2111139.59084 | 37.7762647906594 | -122.474874396612 | (37.7762647906594, -122.474874396612) | 11 | 6 | 2 | 54 | 26 | ||
| 182780 | 90908 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 743 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993344.60696 | 2110686.93317 | 37.7751610983623 | -122.466515557611 | (37.7751610983623, -122.466515557611) | 11 | 6 | 2 | 54 | 11 | ||
| 182774 | 255792 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2018 12:00:00 AM | 3 | 3x3 | 6007843 | 2092137 | 37.7250531301082 | -122.415048939995 | (37.7250531301082, -122.415048939995) | 9 | 3 | 7 | 309 | 28 | ||
| 182736 | 118075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 426 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 5985334.53877 | 2112983.7129 | 37.7810019204378 | -122.494393110571 | (37.7810019204378, -122.494393110571) | 11 | 6 | 2 | 55 | 26 | |||
| 182626 | 96953 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2302 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782304 | 5988418.13148 | 2110571.74898 | 37.7745593211999 | -122.483548684419 | (37.7745593211999, -122.483548684419) | 11 | 6 | 2 | 55 | 26 | ||
| 182321 | 140140 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 229 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998771.9778 | 2109907.5347 | 37.7733327611881 | -122.447685026158 | (37.7733327611881, -122.447685026158) | 15 | 5 | 11 | 29492 | 16 | |||
| 182238 | 223534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1710 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002582.13398 | 2100486.07812 | 37.7476807400708 | -122.433831648132 | (37.7476807400708, -122.433831648132) | 2 | 4 | 5 | 63 | 22 | |||
| 182167 | 99024 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351X 23rd St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 6006571 | 2102346.4 | 37.7530143054678 | -122.420170352411 | (37.7530143054678, -122.420170352411) | 2 | 4 | 7 | 28859 | 19 | ||
| 181932 | 223612 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 263 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006747.68104 | 2102305.49378 | 37.752911939936 | -122.419556452085 | (37.752911939936, -122.419556452085) | 2 | 4 | 7 | 28859 | 19 | |||
| 181867 | 191069 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 396 12th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008685.67935 | 2108575.69988 | 37.770237460112 | -122.413297838836 | (37.770237460112, -122.413297838836) | 8 | 2 | 9 | 28853 | 19 | |||
| 181745 | 49495 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2X ORDWAY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 9 | 3x3 | Permit Number 46411 | 6011821 | 2090323 | 37.720294999502 | -122.401169931587 | (37.720294999502, -122.401169931587) | 10 | 7 | 8 | 309 | 28 | |
| 181705 | 90323 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1949 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989481.72771 | 2111237.09883 | 37.7764480366161 | -122.479918238394 | (37.7764480366161, -122.479918238394) | 11 | 6 | 2 | 55 | 26 | ||
| 181661 | 123098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 575 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992506.57833 | 2111546.13645 | 37.777471844019 | -122.469477017446 | (37.777471844019, -122.469477017446) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||
| 181544 | 43598 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2320 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 3 | Permit Number 43256 | 5986732.527 | 2099427.1676 | 37.7438611062736 | -122.488560165713 | (37.7438611062736, -122.488560165713) | 1 | 8 | 3 | 29491 | 35 | |
| 181431 | 95766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767501 | 6004737 | 2091251 | 37.7224453364084 | -122.425723020763 | (37.7224453364084, -122.425723020763) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 181338 | 33036 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 494 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37315 | 6006779.65662971 | 2100908.40918731 | 37.7490776652966 | -122.41934677281 | (37.7490776652966, -122.41934677281) | 2 | 4 | 7 | 28859 | 19 | |||
| 181248 | 207645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992161.38152 | 2104923.06164 | 37.759266696124 | -122.470188750009 | (37.759266696124, -122.470188750009) | 1 | 8 | 4 | 56 | 12 | |||
| 181103 | 83378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 586 Athens St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52310 | 6003277.11077 | 2089949.83191 | 37.7187900121188 | -122.430676716663 | (37.7187900121188, -122.430676716663) | 9 | 7 | 6 | 28861 | 5 | |
| 181101 | 223510 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3351 23rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006653.24947 | 2102596.28503 | 37.7537050664578 | -122.419903647955 | (37.7537050664578, -122.419903647955) | 2 | 4 | 7 | 28859 | 19 | |||
| 181047 | 253628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
| 181009 | 216746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 935 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 08:04:00 AM | 3 | Width 3ft | 5995893.72973 | 2090148.9347 | 37.7189156393246 | -122.456212350117 | (37.7189156393246, -122.456212350117) | 9 | 8 | 6 | 28861 | 24 | ||
| 180956 | 191112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012137.40992 | 2102323.82129 | 37.7532643788521 | -122.400918929861 | (37.7532643788521, -122.400918929861) | 10 | 3 | 8 | 28856 | 29 | |||
| 180953 | 140730 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998825.1945 | 2110385.2461 | 37.7746474756927 | -122.447535336227 | (37.7746474756927, -122.447535336227) | 15 | 5 | 11 | 29492 | 16 | |||
| 180915 | 45298 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44138 | 6007485.11382992 | 2096559.26498899 | 37.7371755914125 | -122.416599241748 | (37.7371755914125, -122.416599241748) | 2 | 7 | 7 | 28859 | 2 | ||
| 180819 | 207683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2430 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990785.45213 | 2098828.98971 | 37.7424543273065 | -122.474502592844 | (37.7424543273065, -122.474502592844) | 1 | 8 | 4 | 29491 | 40 | |||
| 180588 | 87454 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2516 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50378 | 6000865 | 2118972 | 37.7983408450274 | -122.441095438221 | (37.7983408450274, -122.441095438221) | 13 | 9 | 1 | 57 | 17 | |||
| 180570 | 254755 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | ||
| 180320 | 191668 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 535 Brannan St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013300.95519 | 2111099.53181 | 37.7774253698298 | -122.397510546978 | (37.7774253698298, -122.397510546978) | 6 | 2 | 9 | 28856 | 34 | |||
| 180300 | 223665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3821 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002927.69572 | 2103554.21162 | 37.7561247121999 | -122.432855868402 | (37.7561247121999, -122.432855868402) | 2 | 4 | 5 | 28862 | 22 | |||
| 180290 | 57672 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 258 Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 16574 | 6002046.95980661 | 2104357.19731056 | 37.758279524896 | -122.435959200471 | (37.758279524896, -122.435959200471) | 2 | 4 | 5 | 28862 | 3 | ||
| 180269 | 90907 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 825 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993039.18023 | 2110679.45973 | 37.7751229489473 | -122.46757154432 | (37.7751229489473, -122.46757154432) | 11 | 6 | 2 | 54 | 11 | ||
| 180135 | 47097 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 108 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45078 | 5996526.30490934 | 2112305.63939243 | 37.7797887262832 | -122.455626444814 | (37.7797887262832, -122.455626444814) | 15 | 6 | 2 | 54 | 16 | ||
| 180100 | 223574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007417.99776 | 2097972.40072 | 37.7410519748757 | -122.416931385896 | (37.7410519748757, -122.416931385896) | 2 | 7 | 7 | 28859 | 2 | |||
| 180091 | 248581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 368 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5998189.1274 | 2107567.4653 | 37.7668741998102 | -122.44953252918 | (37.7668741998102, -122.44953252918) | 15 | 5 | 11 | 29492 | 9 | |||
| 180088 | 51547 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2005 12:00:00 AM | Permit Number 47846 | 5990746.48796302 | 2098560.51512066 | 37.7417149076087 | -122.474617728253 | (37.7417149076087, -122.474617728253) | 1 | 8 | 4 | 29491 | 40 | ||
| 179878 | 63368 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 404 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/1987 12:00:00 AM | Permit Number 23946 | 6007413.89798524 | 2095700.92669416 | 37.7348147774413 | -122.416784676409 | (37.7348147774413, -122.416784676409) | 2 | 7 | 7 | 28859 | 2 | ||
| 179872 | 64120 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | 12 | Permit Number 24891 | 6003817.65498965 | 2099560.57193818 | 37.745209548627 | -122.42949329292 | (37.745209548627, -122.42949329292) | 2 | 7 | 5 | 63 | 22 | |
| 179767 | 224078 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 37 Mars St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 3ft | 5999600.02239 | 2105581.97574 | 37.7615031526571 | -122.444509776331 | (37.7615031526571, -122.444509776331) | 15 | 5 | 5 | 28862 | 3 | |||
| 179534 | 63374 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23954 | 6007173.36790377 | 2095773.19407167 | 37.7349996759488 | -122.417621394563 | (37.7349996759488, -122.417621394563) | 2 | 7 | 7 | 28859 | 2 | ||
| 179470 | 207589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Hearst Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998517.2369 | 2094367.8013 | 37.7306499124478 | -122.447447460328 | (37.7306499124478, -122.447447460328) | 9 | 7 | 4 | 28861 | 40 | |||
| 179426 | 122167 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 701 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991287.4219 | 2110535.49053 | 37.7746263536906 | -122.473620700628 | (37.7746263536906, -122.473620700628) | 11 | 6 | 2 | 54 | 26 | |||
| 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 | |||
| 179323 | 159293 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 486 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:16:00 AM | 3 | Width 0ft | 5998231.36405 | 2087340.7209 | 37.7113388384862 | -122.447930029355 | (37.7113388384862, -122.447930029355) | 9 | 7 | 6 | 28861 | 25 | ||
| 179303 | 69059 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33067 | 5992351.52630546 | 2106953.75460707 | 37.7648534341248 | -122.46967897894 | (37.7648534341248, -122.46967897894) | 11 | 8 | 11 | 56 | 12 | ||
| 179288 | 180663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 355 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 01:48:00 PM | 3 | Width 6ft | 6002383.84355 | 2086445.14687 | 37.7091162701556 | -122.433514058849 | (37.7091162701556, -122.433514058849) | 9 | 7 | 6 | 28861 | 5 | ||
| 179278 | 224080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Potomac St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003118.91153 | 2108722.42334 | 37.7703262160109 | -122.432563724544 | (37.7703262160109, -122.432563724544) | 15 | 5 | 5 | 29492 | 9 | |||
| 179244 | 90177 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990761.33941 | 2111332.28389 | 37.7767836486138 | -122.475498696085 | (37.7767836486138, -122.475498696085) | 11 | 6 | 2 | 54 | 26 | ||
| 179067 | 246576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Laguna St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6005228.37861 | 2109333.02061 | 37.7721221684335 | -122.42531053216 | (37.7721221684335, -122.42531053216) | 7 | 9 | 11 | 28852 | 10 | |||
| 178959 | 137812 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | 13 | 9 | 1 | 28858 | 27 | |||
| 178873 | 63344 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 420 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1987 12:00:00 AM | Permit Number 23918 | 6009445.61532171 | 2100209.13086816 | 37.7473073913184 | -122.410078463277 | (37.7473073913184, -122.410078463277) | 2 | 7 | 7 | 28859 | 2 | ||
| 178849 | 252855 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 926 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001578 | 2088750 | 37.7153991335272 | -122.43646402536 | (37.7153991335272, -122.43646402536) | 9 | 7 | 6 | 28861 | 5 | ||||
| 178775 | 42945 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 54 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42840 | 6007765.38854271 | 2106161.17113141 | 37.7635560172004 | -122.416310086241 | (37.7635560172004, -122.416310086241) | 8 | 4 | 7 | 28859 | 19 | ||
| 178719 | 223450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 109 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998091.45259 | 2106201.0539 | 37.7631167918352 | -122.449771888566 | (37.7631167918352, -122.449771888566) | 15 | 5 | 11 | 29492 | 9 | |||
| 178710 | 223621 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 451 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006809.92038 | 2101192.85775 | 37.7498604008551 | -122.419262295528 | (37.7498604008551, -122.419262295528) | 2 | 4 | 7 | 28859 | 19 | |||
| 178699 | 191105 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2031 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6012471.08809 | 2101442.49761 | 37.7508630621826 | -122.39970311841 | (37.7508630621826, -122.39970311841) | 10 | 3 | 8 | 28856 | 1 | |||
| 178635 | 207676 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5991619.02228 | 2100784.58126 | 37.7478721400825 | -122.471762870272 | (37.7478721400825, -122.471762870272) | 1 | 8 | 4 | 29491 | 40 |
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) );