trees
467 rows where Police Districts = 7 and qSpecies_id = 8 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15086 | 207588 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001743.96601 | 2095815.79538 | 37.7348096375426 | -122.436395778947 | (37.7348096375426, -122.436395778947) | 2 | 7 | 5 | 63 | 7 | |||
| 17045 | 176247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011833.80931 | 2090345.75054 | 37.7203581824627 | -122.401127251532 | (37.7203581824627, -122.401127251532) | 10 | 7 | 8 | 309 | 28 | |||
| 26465 | 176246 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011847.19322 | 2090350.44098 | 37.7203718080967 | -122.401081316846 | (37.7203718080967, -122.401081316846) | 10 | 7 | 8 | 309 | 28 | |||
| 43410 | 176244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011881.09111 | 2090360.91966 | 37.7204024713802 | -122.400964878027 | (37.7204024713802, -122.400964878027) | 10 | 7 | 8 | 309 | 28 | |||
| 116544 | 176243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Ordway St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011901.96297 | 2090368.71329 | 37.7204250353617 | -122.400893277618 | (37.7204250353617, -122.400893277618) | 10 | 7 | 8 | 309 | 28 | |||
| 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 | |||
| 3936 | 172254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1007 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6004516.89039 | 2090643.22078 | 37.7207640671979 | -122.426440635537 | (37.7207640671979, -122.426440635537) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||||
| 27726 | 254276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 102 Bache St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778482 | 6007158.62699 | 2095375.94585 | 37.7339080899914 | -122.417644212443 | (37.7339080899914, -122.417644212443) | 2 | 7 | 7 | 28859 | 2 | |
| 85918 | 84126 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1045 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50691 | 6011772.83718 | 2090087.8836 | 37.7196467305931 | -122.401319901612 | (37.7196467305931, -122.401319901612) | 10 | 7 | 8 | 309 | 28 | |
| 4986 | 51031 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 6 | Permit Number 47506 | 6011820.57141 | 2089923.66488 | 37.7191984823926 | -122.401143367398 | (37.7191984823926, -122.401143367398) | 10 | 7 | 8 | 309 | 28 | ||
| 30817 | 51030 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1085 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | 5 | Permit Number 47506 | 6011828.2745 | 2089900.62278 | 37.7191356431884 | -122.401115122362 | (37.7191356431884, -122.401115122362) | 10 | 7 | 8 | 309 | 28 | ||
| 8681 | 223586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
| 15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 87729 | 248098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.7462972904853 | -122.40650360018 | (37.7462972904853, -122.40650360018) | 2 | 7 | 7 | 28859 | 2 | |||
| 172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 7 | 8 | 309 | 39 | |||
| 154681 | 170290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.31058 | 37.7283429067858 | -122.44467875894 | (37.7283429067858, -122.44467875894) | 9 | 7 | 4 | 28861 | 40 | ||
| 82391 | 248256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 116 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006785.81091 | 2098870.27842 | 37.743481764973 | -122.419180937446 | (37.743481764973, -122.419180937446) | 2 | 7 | 7 | 28859 | 2 | |||
| 96633 | 223519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003743.87449 | 2095119.74297 | 37.7330118702979 | -122.429431783351 | (37.7330118702979, -122.429431783351) | 9 | 7 | 5 | 28861 | 25 | |||
| 114847 | 253246 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173 | 2087586 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | 9 | 7 | 6 | 28861 | 5 | |
| 23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
| 76601 | 181054 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.7116950572566 | -122.439510213951 | (37.7116950572566, -122.439510213951) | 9 | 7 | 6 | 28861 | 5 | ||
| 19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
| 138025 | 31017 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 4 | 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 | |||
| 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 | |||
| 141049 | 180766 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | 9 | 7 | 6 | 28861 | 5 | ||
| 178064 | 251779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136 | 2087356 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | 9 | 7 | 6 | 28861 | 5 | ||
| 53756 | 251780 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001110 | 2087312 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | 9 | 7 | 6 | 28861 | 5 | ||||
| 50524 | 207695 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.7244713658451 | -122.456366191771 | (37.7244713658451, -122.456366191771) | 9 | 7 | 4 | 28861 | 40 | |||
| 29548 | 251781 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070 | 2087245 | 37.7112378586553 | -122.438112149268 | (37.7112378586553, -122.438112149268) | 9 | 7 | 6 | 28861 | 5 | ||
| 71396 | 66453 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29603 | 6009081.83261092 | 2097914.76259057 | 37.7409871642392 | -122.411174357607 | (37.7409871642392, -122.411174357607) | 10 | 7 | 7 | 28859 | 2 | ||
| 84067 | 223485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 125 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6009074.65326 | 2097933.54072 | 37.7410383222477 | -122.411200507415 | (37.7410383222477, -122.411200507415) | 10 | 7 | 7 | 28859 | 2 | |||
| 161598 | 63432 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 127 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1987 12:00:00 AM | 9 | Permit Number 24018 | 6005906.17265772 | 2095879.01582361 | 37.7352188514571 | -122.422010059455 | (37.7352188514571, -122.422010059455) | 2 | 7 | 7 | 28859 | 2 | ||
| 111171 | 176256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000782.55302 | 2093188.1019 | 37.7275399228115 | -122.439531400151 | (37.7275399228115, -122.439531400151) | 9 | 7 | 6 | 28861 | 25 | |||
| 138935 | 176257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 13 Santa Ysabel Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6000825.3698 | 2093157.80225 | 37.7274591636907 | -122.439381211582 | (37.7274591636907, -122.439381211582) | 9 | 7 | 6 | 28861 | 25 | |||
| 42001 | 223564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 130 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 6009029.83515 | 2097858.62477 | 37.7408301058168 | -122.411350181559 | (37.7408301058168, -122.411350181559) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 13251 | 262414 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6003118 | 2094425 | 37.7310688083977 | -122.431546013106 | (37.7310688083977, -122.431546013106) | 9 | 7 | 5 | 28861 | 25 | |
| 104269 | 223565 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6009029.93492 | 2097846.57394 | 37.7407970224666 | -122.411348985471 | (37.7407970224666, -122.411348985471) | 10 | 7 | 7 | 28859 | 2 | |||
| 160868 | 66455 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | Permit Number 29605 | 6009024.9615405 | 2097864.85103927 | 37.7408469284457 | -122.411367472491 | (37.7408469284457, -122.411367472491) | 10 | 7 | 7 | 28859 | 2 | ||
| 91937 | 108615 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774598 | 6007320.4947 | 2100127.53408 | 37.7469640041817 | -122.417421212351 | (37.7469640041817, -122.417421212351) | 2 | 7 | 7 | 28859 | 2 | |
| 140358 | 223591 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 136 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007357.07726 | 2100145.00086 | 37.747014022273 | -122.417295950359 | (37.747014022273, -122.417295950359) | 2 | 7 | 7 | 28859 | 2 | |||
| 14625 | 161993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 138 Guttenberg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5999425.42548 | 2087282.88829 | 37.7112482236968 | -122.443798910798 | (37.7112482236968, -122.443798910798) | 9 | 7 | 6 | 28861 | 5 | |||
| 1037 | 63388 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 139 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | Permit Number 23969 | 6005989.66886949 | 2095872.0431692 | 37.7352044148911 | -122.421720887046 | (37.7352044148911, -122.421720887046) | 2 | 7 | 7 | 28859 | 2 | ||
| 136341 | 113703 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
| 64743 | 223374 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 14 Lundys Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007165.43911 | 2099578.09983 | 37.7454466559323 | -122.417918440397 | (37.7454466559323, -122.417918440397) | 2 | 7 | 7 | 28859 | 2 | |||
| 172015 | 223566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 144 Nevada St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 6009026.08799 | 2097793.63743 | 37.7406514546128 | -122.411358547973 | (37.7406514546128, -122.411358547973) | 10 | 7 | 7 | 28859 | 2 | |||
| 28283 | 223478 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 147 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006034.33786 | 2095867.87013 | 37.7351954754822 | -122.42156615355 | (37.7351954754822, -122.42156615355) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 18382 | 223425 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010157.18753 | 2100400.68055 | 37.7478732021894 | -122.407631390476 | (37.7478732021894, -122.407631390476) | 2 | 7 | 7 | 28859 | 2 | |||
| 152919 | 96071 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1514 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767695 | 6010091 | 2100531 | 37.7482273255229 | -122.407869453177 | (37.7482273255229, -122.407869453177) | 2 | 7 | 7 | 28859 | 2 | |
| 20990 | 4475 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.91057 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | 2 | 7 | 5 | 63 | 22 | ||
| 48911 | 32226 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1524 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | 10 | Permit Number 35545 | 6008720.30382 | 2099880.58736 | 37.7463646038601 | -122.412563325657 | (37.7463646038601, -122.412563325657) | 2 | 7 | 7 | 28859 | 2 | |
| 149177 | 121570 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1530 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779159 | 6010119 | 2100471 | 37.7480641462346 | -122.40776839944 | (37.7480641462346, -122.40776839944) | 2 | 7 | 7 | 28859 | 2 | |
| 4370 | 38420 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 90393 | 38422 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 159901 | 38421 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1542 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42357 | 6004548.16357043 | 2099910.23270392 | 37.7462109701995 | -122.426992216906 | (37.7462109701995, -122.426992216906) | 2 | 7 | 5 | 63 | 22 | ||
| 148006 | 60514 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1551 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/08/1982 12:00:00 AM | Permit Number 20115 | 6004602.91474331 | 2099861.26634292 | 37.7460796156332 | -122.426799407471 | (37.7460796156332, -122.426799407471) | 2 | 7 | 5 | 63 | 22 | ||
| 1653 | 159947 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 157 Bertita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 0ft | 6000525.42449 | 2090002.91659 | 37.7187794927682 | -122.440191978283 | (37.7187794927682, -122.440191978283) | 9 | 7 | 6 | 28861 | 25 | ||
| 73815 | 117002 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778235 | 6001002.4 | 2094897.4 | 37.7322457718664 | -122.438893830128 | (37.7322457718664, -122.438893830128) | 9 | 7 | 4 | 63 | 40 | |
| 172061 | 207703 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 161 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6000991.68804 | 2094917.78379 | 37.7323011315777 | -122.438932323977 | (37.7323011315777, -122.438932323977) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | ||
| 3971 | 172343 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 164 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6001347.87441 | 2087361.61872 | 37.7115738673031 | -122.437160092082 | (37.7115738673031, -122.437160092082) | 9 | 7 | 6 | 28861 | 5 | |||
| 43621 | 223578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006732.92847 | 2098549.7578 | 37.7425987089604 | -122.419341059038 | (37.7425987089604, -122.419341059038) | 2 | 7 | 7 | 28859 | 2 | |||
| 46051 | 207593 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998975.03938 | 2093802.03245 | 37.7291225947148 | -122.445824099527 | (37.7291225947148, -122.445824099527) | 9 | 7 | 4 | 28861 | 40 | |||
| 148740 | 42130 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2011 12:00:00 AM | Permit Number 767992 | 5998983.29782445 | 2093814.78501268 | 37.7291580818069 | -122.445796466287 | (37.7291580818069, -122.445796466287) | 9 | 7 | 4 | 28861 | 40 | |||
| 72623 | 223539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6003387.19904 | 2098534.72149 | 37.7423684195723 | -122.430908536723 | (37.7423684195723, -122.430908536723) | 2 | 7 | 5 | 63 | 22 | |||
| 103871 | 223538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003388.52326 | 2098515.37807 | 37.74231538204 | -122.430902577793 | (37.74231538204, -122.430902577793) | 2 | 7 | 5 | 63 | 22 | |||
| 136200 | 223540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1661 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6003385.20059 | 2098555.09449 | 37.7424242458904 | -122.430916900407 | (37.7424242458904, -122.430916900407) | 2 | 7 | 5 | 63 | 22 | |||
| 149441 | 64269 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1663 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1988 12:00:00 AM | Permit Number 25072 | 6009753.58464886 | 2100137.8418766 | 37.7471289041039 | -122.409008493901 | (37.7471289041039, -122.409008493901) | 2 | 7 | 7 | 28859 | 2 | ||
| 45695 | 64260 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25062 | 6009914.7515977 | 2100087.93471467 | 37.7470008969248 | -122.408447669408 | (37.7470008969248, -122.408447669408) | 2 | 7 | 7 | 28859 | 2 | ||
| 149056 | 223426 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 170 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6009923.95337 | 2100088.63423 | 37.7470033329491 | -122.408415899671 | (37.7470033329491, -122.408415899671) | 2 | 7 | 7 | 28859 | 2 | |||
| 53500 | 223412 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009299.39544 | 2099281.89074 | 37.7447531977014 | -122.410518617161 | (37.7447531977014, -122.410518617161) | 2 | 7 | 7 | 28859 | 2 | |||
| 107540 | 42062 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1726 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42373 | 6009298.2802895 | 2099318.00641811 | 37.7448523008957 | -122.410525022946 | (37.7448523008957, -122.410525022946) | 2 | 7 | 7 | 28859 | 2 | ||
| 74874 | 223579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 175 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006727.49198 | 2098540.80298 | 37.7425738148408 | -122.419359221751 | (37.7425738148408, -122.419359221751) | 2 | 7 | 7 | 28859 | 2 | |||
| 45743 | 161753 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 175x Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001022 | 2087749 | 37.7126190008501 | -122.43831413288 | (37.7126190008501, -122.43831413288) | 9 | 7 | 6 | 28861 | 5 | |
| 151753 | 223576 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007174.02692 | 2097594.37425 | 37.7400002716996 | -122.417748161849 | (37.7400002716996, -122.417748161849) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 76386 | 180625 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002816.84046 | 2087215.85653 | 37.7112570289525 | -122.432072557104 | (37.7112570289525, -122.432072557104) | 9 | 7 | 6 | 28861 | 5 | |||
| 168353 | 180626 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 18 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6002802.39914 | 2087193.02957 | 37.7111935323316 | -122.432120840807 | (37.7111935323316, -122.432120840807) | 9 | 7 | 6 | 28861 | 5 | |||
| 62521 | 223577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 180 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6007069.07199 | 2097998.10728 | 37.7411029259504 | -122.418139669131 | (37.7411029259504, -122.418139669131) | 2 | 7 | 7 | 28859 | 2 | |||
| 59464 | 223477 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006251.94836 | 2095849.23921 | 37.7351565869995 | -122.420812471312 | (37.7351565869995, -122.420812471312) | 2 | 7 | 7 | 28859 | 2 | |||
| 103281 | 63387 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 181 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1987 12:00:00 AM | 14 | Permit Number 23968 | 6006281.90561253 | 2095847.6388786 | 37.735153881321 | -122.420708784491 | (37.735153881321, -122.420708784491) | 2 | 7 | 7 | 28859 | 2 | |
| 105828 | 207702 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 182 Stillings Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999557.67926 | 2095791.1114 | 37.7346173903777 | -122.44395272994 | (37.7346173903777, -122.44395272994) | 9 | 7 | 4 | 63 | 40 | |||
| 103840 | 176261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 188 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004431.12132 | 2092306.16061 | 37.7253252856153 | -122.426855482904 | (37.7253252856153, -122.426855482904) | 9 | 7 | 6 | 28861 | 5 | |||
| 8973 | 170735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1895 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 2ft | 6000284.32157 | 2093024.69966 | 37.7270628891409 | -122.441242066294 | (37.7270628891409, -122.441242066294) | 9 | 7 | 6 | 28861 | 25 | ||
| 78250 | 176236 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001058.00654 | 2087498.50838 | 37.711933254377 | -122.438171750223 | (37.711933254377, -122.438171750223) | 9 | 7 | 6 | 28861 | 5 | |||
| 176065 | 176235 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 19 Brunswick St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6001042.78255 | 2087493.58621 | 37.7119188733302 | -122.438224016125 | (37.7119188733302, -122.438224016125) | 9 | 7 | 6 | 28861 | 5 | |||
| 36614 | 40677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 195 Maynard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2015 12:00:00 AM | 1 | Permit Number 774326 | 6004652.68968 | 2093800.00562 | 37.7294395787702 | -122.426195845473 | (37.7294395787702, -122.426195845473) | 9 | 7 | 6 | 28861 | 5 | |
| 100541 | 176259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004478.9263 | 2093384.65246 | 37.7282892883003 | -122.426766995027 | (37.7282892883003, -122.426766995027) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 38592 | 45299 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Tompkins Ave | 2 | 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 | ||
| 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 | ||
| 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 | ||
| 33032 | 95765 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 200 Munich St | 1 | 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 | |
| 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 | |
| 129567 | 1769 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474917 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | 10 | 7 | 8 | 309 | 39 | ||
| 166764 | 96201 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2000X Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
| 131630 | 176237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2014 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6012237.04254 | 2088170.85532 | 37.7144088442801 | -122.399580777334 | (37.7144088442801, -122.399580777334) | 10 | 7 | 8 | 309 | 39 |
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) );