trees
312 rows where Police Districts = 8 and 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 178147 | 207617 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 385 Victoria St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5993228.76427 | 2089783.48491 | 37.7177588647558 | -122.46539747963 | (37.7177588647558, -122.46539747963) | 9 | 8 | 6 | 64 | 24 | |||
| 178036 | 117440 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||||
| 177663 | 207653 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1259 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5992353.42647 | 2106870.06919 | 37.7646237659879 | -122.469666314052 | (37.7646237659879, -122.469666314052) | 11 | 8 | 11 | 56 | 12 | |||
| 177300 | 60455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 60 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20041 | 5997245.01433776 | 2089631.74975866 | 37.7175730452663 | -122.451504230583 | (37.7175730452663, -122.451504230583) | 9 | 8 | 6 | 28861 | 24 | ||
| 177260 | 117317 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | ||
| 177087 | 207531 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5990492.61494 | 2106135.12336 | 37.7624980762427 | -122.476048615548 | (37.7624980762427, -122.476048615548) | 1 | 8 | 3 | 56 | 12 | |||
| 176884 | 39667 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 724 Head St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41056 | 5993542.5872035 | 2090669.62247691 | 37.7202100790578 | -122.464377044443 | (37.7202100790578, -122.464377044443) | 9 | 8 | 6 | 64 | 24 | ||
| 176082 | 207574 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 447 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5992827.2239 | 2104547.60821 | 37.7582742708466 | -122.467858656946 | (37.7582742708466, -122.467858656946) | 1 | 8 | 4 | 56 | 12 | |||
| 176058 | 81911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | 9 | 8 | 6 | 28861 | 24 | ||
| 175392 | 60458 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 64 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | 8 | 3x3 | Permit Number 20044 | 5997231.4874629 | 2089612.30707346 | 37.717518885545 | -122.451549584962 | (37.717518885545, -122.451549584962) | 9 | 8 | 6 | 28861 | 24 |
| 174573 | 207686 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990741.80661 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | 1 | 8 | 4 | 29491 | 40 | |||
| 174274 | 207533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990908.41918 | 2104245.94994 | 37.7573350099278 | -122.474472641826 | (37.7573350099278, -122.474472641826) | 1 | 8 | 4 | 56 | 12 | |||
| 174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
| 173914 | 254375 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1238 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778703 | 5993632.74679 | 2107063.55913 | 37.7652288969897 | -122.465255577799 | (37.7652288969897, -122.465255577799) | 11 | 8 | 11 | 56 | 12 |
| 173568 | 62767 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 330 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23121 | 5993312.675705 | 2103941.46380685 | 37.7566379758683 | -122.466135718391 | (37.7566379758683, -122.466135718391) | 1 | 8 | 4 | 56 | 12 | ||
| 173274 | 67306 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 252 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 773656 | 5997299.10481202 | 2090605.17719866 | 37.7202489476622 | -122.451387434099 | (37.7202489476622, -122.451387434099) | 9 | 8 | 6 | 28861 | 24 | ||
| 172645 | 207581 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992198.24643 | 2098404.03839 | 37.7413692745846 | -122.469586688073 | (37.7413692745846, -122.469586688073) | 1 | 8 | 4 | 59 | 40 | |||
| 171970 | 64849 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2427 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25864 | 5990735.82464568 | 2098873.0190571 | 37.7425723450195 | -122.474677400881 | (37.7425723450195, -122.474677400881) | 1 | 8 | 4 | 29491 | 40 | ||
| 170788 | 109075 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773945 | 5993143.3 | 2105315.7 | 37.7604014971278 | -122.466821372375 | (37.7604014971278, -122.466821372375) | 1 | 8 | 4 | 56 | 12 |
| 170651 | 207644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992160.10563 | 2104906.0361 | 37.7592198747043 | -122.470191922822 | (37.7592198747043, -122.470191922822) | 1 | 8 | 4 | 56 | 12 | |||
| 170647 | 64892 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25918 | 5990741.15630477 | 2098716.76707671 | 37.7421436262999 | -122.474647564393 | (37.7421436262999, -122.474647564393) | 1 | 8 | 4 | 29491 | 40 | ||
| 170509 | 207602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996198.32663 | 2090727.04827 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | 9 | 8 | 6 | 28861 | 24 | |||
| 169814 | 50895 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173879 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | 1 | 8 | 4 | 56 | 12 | ||
| 169630 | 99645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.492660934457 | (37.7538441541808, -122.492660934457) | 1 | 8 | 3 | 56 | 35 | ||
| 169516 | 207666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 5993287.90775 | 2103943.61016 | 37.7566424402051 | -122.466221530195 | (37.7566424402051, -122.466221530195) | 1 | 8 | 4 | 56 | 12 | |||
| 169314 | 113391 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2151 15TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | FUF | 12/10/2015 12:00:00 AM | 1 | Permit Number 776062 | 5991602 | 2100781 | 37.7478613219593 | -122.471821470999 | (37.7478613219593, -122.471821470999) | 1 | 8 | 4 | 29491 | 40 | |
| 169053 | 181735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2801X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986996.5941 | 2107070.8859 | 37.7648640858106 | -122.488208680173 | (37.7648640858106, -122.488208680173) | 1 | 8 | 3 | 56 | 35 | |||
| 167817 | 37241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2839 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39798 | 5985223.35119541 | 2102931.47415001 | 37.7533947976733 | -122.494036683936 | (37.7533947976733, -122.494036683936) | 1 | 8 | 3 | 56 | 35 | |
| 166499 | 35079 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
| 166322 | 207685 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990740.98987 | 2098842.82853 | 37.7424897489131 | -122.474657338285 | (37.7424897489131, -122.474657338285) | 1 | 8 | 4 | 29491 | 40 | |||
| 165701 | 207607 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Sadowa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994570.62843 | 2087741.51431 | 37.7122293948458 | -122.460611398307 | (37.7122293948458, -122.460611398307) | 9 | 8 | 6 | 28861 | 24 | |||
| 165563 | 52351 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 165129 | 207675 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1759 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992467.39253 | 2103575.28695 | 37.7555837456991 | -122.469032338792 | (37.7555837456991, -122.469032338792) | 1 | 8 | 4 | 56 | 12 | |||
| 165102 | 207667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5993246.28637 | 2103941.58644 | 37.7566344820998 | -122.466365323703 | (37.7566344820998, -122.466365323703) | 1 | 8 | 4 | 56 | 12 | |||
| 164864 | 216659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1022 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 07:44:00 AM | 3 | Width 4ft | 5995946.33237 | 2090713.9624 | 37.7204700913979 | -122.456071352615 | (37.7204700913979, -122.456071352615) | 9 | 8 | 6 | 28861 | 24 | ||
| 163323 | 207556 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1333 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5993304.33349 | 2106388.43984 | 37.7633562525083 | -122.46634240179 | (37.7633562525083, -122.46634240179) | 1 | 8 | 11 | 56 | 12 | |||
| 163147 | 54271 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1247 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1972 12:00:00 AM | Permit Number 10024 | 5993280.22580381 | 2106998.95550637 | 37.7650311769521 | -122.466470157661 | (37.7650311769521, -122.466470157661) | 11 | 8 | 11 | 56 | 12 | |||
| 163041 | 92283 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 345 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52731 | 5991916 | 2097076 | 37.7377065018101 | -122.470465891371 | (37.7377065018101, -122.470465891371) | 1 | 8 | 4 | 59 | 40 | ||
| 162000 | 38859 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1543 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40686 | 5989291.28049712 | 2104842.48405606 | 37.7588791051043 | -122.480108937189 | (37.7588791051043, -122.480108937189) | 1 | 8 | 3 | 56 | 35 | |
| 160738 | 207562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1441 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992705.62394 | 2105635.27158 | 37.7612536870231 | -122.4683583275 | (37.7612536870231, -122.4683583275) | 1 | 8 | 4 | 56 | 12 | |||
| 160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 160195 | 207558 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992727.49382 | 2106432.28501 | 37.7634433392744 | -122.468340674684 | (37.7634433392744, -122.468340674684) | 1 | 8 | 11 | 56 | 12 | |||
| 159603 | 38858 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.7589506522356 | -122.480113948201 | (37.7589506522356, -122.480113948201) | 1 | 8 | 3 | 56 | 35 | |
| 159143 | 94155 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53541 | 5990589.8 | 2102714 | 37.7531102147949 | -122.475462689636 | (37.7531102147949, -122.475462689636) | 1 | 8 | 4 | 56 | 12 | ||
| 158823 | 52349 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
| 158740 | 94125 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1478 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2010 12:00:00 AM | 3x3 | Permit Number 53485 | 5986246.3 | 2105188 | 37.7596504010073 | -122.490665173884 | (37.7596504010073, -122.490665173884) | 1 | 8 | 3 | 56 | 35 | |||
| 158089 | 84476 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 71 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52718 | 5992866.3330519 | 2098645.80444652 | 37.7420716926906 | -122.467294272683 | (37.7420716926906, -122.467294272683) | 1 | 8 | 4 | 59 | 40 | |
| 157918 | 67731 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774581 | 5992402.99511967 | 2105448.3839166 | 37.7607230584725 | -122.46939137901 | (37.7607230584725, -122.46939137901) | 1 | 8 | 4 | 56 | 12 | |
| 154557 | 214493 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1359 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781360 | 5991433.81997 | 2106159.32578 | 37.7626190602323 | -122.47279512831 | (37.7626190602323, -122.47279512831) | 1 | 8 | 11 | 56 | 12 |
| 153698 | 207603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | 9 | 8 | 6 | 28861 | 24 | |||
| 153388 | 207692 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992959.6562 | 2099040.51355 | 37.7431608508894 | -122.467000282841 | (37.7431608508894, -122.467000282841) | 1 | 8 | 4 | 59 | 40 | |||
| 152043 | 69057 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33065 | 5992349.25716829 | 2107019.71250197 | 37.7650344058537 | -122.469691629397 | (37.7650344058537, -122.469691629397) | 11 | 8 | 11 | 56 | 12 | ||
| 150648 | 181341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.7389057397188 | -122.493798381455 | (37.7389057397188, -122.493798381455) | 1 | 8 | 3 | 29491 | 35 | |||
| 149935 | 207613 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 171 Caine Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5997069.50028 | 2088848.50877 | 37.7154123950516 | -122.45205442099 | (37.7154123950516, -122.45205442099) | 9 | 8 | 6 | 28861 | 24 | |||
| 148862 | 21341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 5 | 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 | |||
| 148596 | 38856 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 3 | Permit Number 40683 | 5989340.55843436 | 2104922.50162386 | 37.7591016749524 | -122.479944368724 | (37.7591016749524, -122.479944368724) | 1 | 8 | 3 | 56 | 35 | |
| 148040 | 50894 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173879 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | 1 | 8 | 4 | 56 | 12 | ||
| 147599 | 35066 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38621 | 5993091.79613018 | 2103456.13602806 | 37.7552926457444 | -122.466864312925 | (37.7552926457444, -122.466864312925) | 1 | 8 | 4 | 56 | 12 | ||
| 147442 | 182142 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1418 25th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5988379.3786 | 2105646.146 | 37.7610327154794 | -122.483321592218 | (37.7610327154794, -122.483321592218) | 1 | 8 | 3 | 56 | 35 | |||
| 146682 | 207647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1520 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992154.93945 | 2105081.8462 | 37.7597023043237 | -122.470222592396 | (37.7597023043237, -122.470222592396) | 1 | 8 | 4 | 56 | 12 | |||
| 146588 | 95613 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52567 | 5993573 | 2105260 | 37.7602733497891 | -122.46533120514 | (37.7602733497891, -122.46533120514) | 1 | 8 | 4 | 56 | 12 | |
| 146520 | 81459 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443 | (37.7428525058761, -122.47827872443) | 1 | 8 | 3 | 29491 | 35 | |
| 145999 | 53552 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 124 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20052 | 5997008.15708783 | 2089291.43789618 | 37.7166250615868 | -122.452298391323 | (37.7166250615868, -122.452298391323) | 9 | 8 | 6 | 28861 | 24 | ||
| 145695 | 65471 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 50 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28352 | 5995649.70460039 | 2090232.90843382 | 37.7191322005073 | -122.457061914585 | (37.7191322005073, -122.457061914585) | 9 | 8 | 6 | 28861 | 24 | ||
| 145458 | 207609 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Tara St | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5997727.90986 | 2090186.78446 | 37.7191246831501 | -122.449875066876 | (37.7191246831501, -122.449875066876) | 9 | 8 | 6 | 28861 | 24 | |||
| 145092 | 110714 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 484 FAXON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994812 | 2091798 | 37.7233814241751 | -122.460070840792 | (37.7233814241751, -122.460070840792) | 9 | 8 | 4 | 28861 | 24 | ||||
| 145091 | 207698 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 86 San Jacinto Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993860.0419 | 2095158.09444 | 37.7325526233881 | -122.463605302557 | (37.7325526233881, -122.463605302557) | 9 | 8 | 4 | 59 | 40 | |||
| 143733 | 81450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49732 | 5988700.7716 | 2104076.8415 | 37.7567425285058 | -122.482095077474 | (37.7567425285058, -122.482095077474) | 1 | 8 | 3 | 56 | 35 | |
| 142819 | 64850 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1989 12:00:00 AM | Permit Number 25865 | 5990734.04742599 | 2098925.10305057 | 37.7427152512508 | -122.474687346453 | (37.7427152512508, -122.474687346453) | 1 | 8 | 4 | 29491 | 40 | ||
| 142733 | 218237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 345 Wawona St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 5992002.51219 | 2097168.37657 | 37.7379651463641 | -122.470173504717 | (37.7379651463641, -122.470173504717) | 1 | 8 | 4 | 59 | 40 | |||
| 142232 | 207560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 626 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992571.33033 | 2105963.74624 | 37.7621478343785 | -122.468846691741 | (37.7621478343785, -122.468846691741) | 1 | 8 | 11 | 56 | 12 |
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) );