trees
230 rows where Fire Prevention Districts = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36200 | 207691 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172672 | (37.7431261613357, -122.46701172672) | 1 | 8 | 4 | 59 | 40 | |||
| 56204 | 207693 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.466987567326 | (37.7431879987389, -122.466987567326) | 1 | 8 | 4 | 59 | 40 | |||
| 59586 | 52350 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | 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 | |
| 34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | 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 | |
| 86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | 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 | |
| 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 | |
| 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 | |
| 8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
| 106925 | 38109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40277 | 5987050.95818325 | 2106810.63919781 | 37.7641526918478 | -122.488001527428 | (37.7641526918478, -122.488001527428) | 1 | 8 | 3 | 56 | 35 | |
| 60727 | 92277 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52726 | 5992357 | 2098417 | 37.7414140378166 | -122.469038721636 | (37.7414140378166, -122.469038721636) | 1 | 8 | 4 | 59 | 40 | ||
| 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 | |||
| 105897 | 38100 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.7638512322332 | -122.485835754297 | (37.7638512322332, -122.485835754297) | 1 | 8 | 3 | 56 | 35 | |
| 11695 | 32589 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.7631295295897 | -122.493148331917 | (37.7631295295897, -122.493148331917) | 1 | 8 | 3 | 56 | 35 | |
| 65154 | 47258 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||||
| 27076 | 69940 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1295 30th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | 1 | 8 | 3 | 56 | 35 | |
| 133392 | 38112 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1296 29th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.487755232649 | (37.763186144894, -122.487755232649) | 1 | 8 | 3 | 56 | 35 | ||
| 127209 | 207632 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1314 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994271.86788 | 2106534.82687 | 37.763813972349 | -122.463006662539 | (37.763813972349, -122.463006662539) | 1 | 5 | 11 | 56 | 12 | |||
| 42483 | 83354 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1322-24 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50904 | 5992731.01277957 | 2106452.183429 | 37.763498178334 | -122.468329951548 | (37.763498178334, -122.468329951548) | 1 | 8 | 11 | 56 | 12 | ||
| 139287 | 83969 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1322-24 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50904 | 5992731.01277957 | 2106452.183429 | 37.763498178334 | -122.468329951548 | (37.763498178334, -122.468329951548) | 1 | 8 | 11 | 56 | 12 | ||
| 108049 | 207559 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1324 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5992726.03942 | 2106443.21953 | 37.763473278578 | -122.468346500487 | (37.763473278578, -122.468346500487) | 1 | 8 | 11 | 56 | 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 | |||
| 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 | |||
| 24617 | 207548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993918.37336 | 2106436.18995 | 37.7635227727814 | -122.464222121451 | (37.7635227727814, -122.464222121451) | 1 | 5 | 11 | 56 | 12 | |||
| 122456 | 207547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993917.02159 | 2106451.10735 | 37.7635636541512 | -122.464227879808 | (37.7635636541512, -122.464227879808) | 1 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 13393 | 207553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993922.26035 | 2106313.56882 | 37.7631863112193 | -122.464199775125 | (37.7631863112193, -122.464199775125) | 1 | 5 | 11 | 56 | 12 | |||
| 86969 | 207552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993922.19207 | 2106326.17113 | 37.7632209099368 | -122.464200926233 | (37.7632209099368, -122.464200926233) | 1 | 5 | 11 | 56 | 12 | |||
| 105337 | 207555 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993925.10789 | 2106274.71202 | 37.7630797847136 | -122.464187105451 | (37.7630797847136, -122.464187105451) | 1 | 5 | 11 | 56 | 12 | |||
| 143799 | 207554 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993924.42937 | 2106289.97984 | 37.7631216670542 | -122.46419056067 | (37.7631216670542, -122.46419056067) | 1 | 5 | 11 | 56 | 12 | |||
| 151465 | 207550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.73068 | 2106351.7347 | 37.7632910165944 | -122.464207836628 | (37.7632910165944, -122.464207836628) | 1 | 5 | 11 | 56 | 12 | |||
| 159154 | 207551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1353 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993920.84097 | 2106341.12127 | 37.7632618812439 | -122.464206684615 | (37.7632618812439, -122.464206684615) | 1 | 5 | 11 | 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 |
| 84552 | 46904 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44960 | 5994548.84037989 | 2106162.48962063 | 37.7628075813013 | -122.462021703411 | (37.7628075813013, -122.462021703411) | 1 | 5 | 11 | 56 | 12 | ||
| 152784 | 207634 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1377 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994548.55797 | 2106167.4368 | 37.7628211487125 | -122.462023038935 | (37.7628211487125, -122.462023038935) | 1 | 5 | 11 | 56 | 12 | |||
| 116965 | 65907 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1385 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28916 | 5993931.02559851 | 2106089.21026455 | 37.7625707863634 | -122.464153170818 | (37.7625707863634, -122.464153170818) | 1 | 5 | 11 | 56 | 12 | ||
| 77340 | 254477 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778443 | 5993977.44675 | 2106077.77361 | 37.7625420596989 | -122.463991787904 | (37.7625420596989, -122.463991787904) | 1 | 5 | 11 | 56 | 12 | |
| 145555 | 207633 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1391 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994552.52419 | 2106074.9918 | 37.7625675470791 | -122.462002617128 | (37.7625675470791, -122.462002617128) | 1 | 5 | 11 | 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 | |||
| 144160 | 207569 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1421 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993941.19822 | 2105808.00041 | 37.7617992436728 | -122.464097572539 | (37.7617992436728, -122.464097572539) | 1 | 5 | 11 | 56 | 12 | |||
| 136562 | 46899 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1422 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44954 | 5991823.56760325 | 2105741.5278605 | 37.7614944523713 | -122.471416700261 | (37.7614944523713, -122.471416700261) | 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 | |||
| 30507 | 207570 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1425 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5993940.55788 | 2105777.49426 | 37.7617154448214 | -122.464097572554 | (37.7617154448214, -122.464097572554) | 1 | 5 | 11 | 56 | 12 | |||
| 106387 | 55390 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1430 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53915 | 5993375.48106326 | 2105742.52731258 | 37.7615868508254 | -122.466049388804 | (37.7615868508254, -122.466049388804) | 1 | 8 | 11 | 56 | 12 | |
| 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 | ||
| 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 | |||
| 104971 | 66338 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1447 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29459 | 5986477.48679656 | 2105401.18553313 | 37.7602492515012 | -122.489881304154 | (37.7602492515012, -122.489881304154) | 1 | 8 | 3 | 56 | 35 | ||
| 23976 | 207635 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 5994307.66331 | 2105637.8573 | 37.7613531889164 | -122.462817781532 | (37.7613531889164, -122.462817781532) | 1 | 5 | 11 | 56 | 12 | |||
| 93838 | 54774 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1450 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2015 12:00:00 AM | 3 | 4x7 | Permit Number 774786 | 5994308.33481958 | 2105643.99316865 | 37.7613700750969 | -122.462815904231 | (37.7613700750969, -122.462815904231) | 1 | 5 | 11 | 56 | 12 | |
| 81292 | 207563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | 1 | 8 | 4 | 56 | 12 | |||
| 59529 | 66339 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | 1 | 8 | 3 | 56 | 35 | ||
| 103024 | 207564 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1457 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993330.19725 | 2105578.31991 | 37.7611333676392 | -122.46619407211 | (37.7611333676392, -122.46619407211) | 1 | 8 | 4 | 56 | 12 | |||
| 48777 | 54276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/1972 12:00:00 AM | 5x6 | Permit Number 10029 | 5993329.78711521 | 2105558.33296163 | 37.761078465039 | -122.466194038055 | (37.761078465039, -122.466194038055) | 1 | 8 | 4 | 56 | 12 | ||
| 74169 | 207565 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5993329.70544 | 2105554.91485 | 37.7610690750853 | -122.466194072125 | (37.7610690750853, -122.466194072125) | 1 | 8 | 4 | 56 | 12 | |||
| 103574 | 207637 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1461 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994257.76347 | 2105584.20435 | 37.7612029976488 | -122.462986470052 | (37.7612029976488, -122.462986470052) | 1 | 5 | 11 | 56 | 12 | |||
| 128120 | 207566 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1465 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5993331.08215 | 2105529.08118 | 37.7609982220075 | -122.466187433302 | (37.7609982220075, -122.466187433302) | 1 | 8 | 4 | 56 | 12 | |||
| 61104 | 182266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986219.9712 | 2105233.6732 | 37.759774269018 | -122.490759591455 | (37.759774269018, -122.490759591455) | 1 | 8 | 3 | 56 | 35 | |||
| 61559 | 92240 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.490674680595 | (37.7597856659048, -122.490674680595) | 1 | 8 | 3 | 56 | 35 | |||
| 32358 | 207561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1471 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992400.09167 | 2105443.15658 | 37.7607085377924 | -122.469401040143 | (37.7607085377924, -122.469401040143) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |
| 116668 | 54371 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50890 | 5994261.74442721 | 2105485.85462575 | 37.760933184118 | -122.46296556602 | (37.760933184118, -122.46296556602) | 1 | 5 | 11 | 56 | 12 | ||
| 148797 | 207636 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994263.22804 | 2105474.62179 | 37.7609024271204 | -122.462959619907 | (37.7609024271204, -122.462959619907) | 1 | 5 | 11 | 56 | 12 | |||
| 19415 | 207567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1475 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993332.90632 | 2105478.86698 | 37.7608604521776 | -122.466177475135 | (37.7608604521776, -122.466177475135) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 98336 | 203684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1494 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 778446 | 5991831.94405 | 2105275.25669 | 37.7602146795817 | -122.471353755176 | (37.7602146795817, -122.471353755176) | 1 | 8 | 4 | 56 | 12 | |
| 47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
| 129939 | 207696 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994014.568 | 2105145.1879 | 37.7599835610189 | -122.463795707001 | (37.7599835610189, -122.463795707001) | 1 | 5 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | |
| 81776 | 207535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1531 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5990841.25621 | 2104949.97528 | 37.7592641852056 | -122.474756299665 | (37.7592641852056, -122.474756299665) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 97678 | 92546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1534 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52889 | 5985305.6485 | 2104749.3445 | 37.7583909829975 | -122.493886044317 | (37.7583909829975, -122.493886044317) | 1 | 8 | 3 | 56 | 35 | |
| 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 | |||
| 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 | |
| 17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | 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 | ||
| 25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | 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 | ||
| 30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | 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 | ||
| 59509 | 35073 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 12 | 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 | ||
| 74034 | 35084 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 14 | 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 | ||
| 75288 | 35080 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 5 | 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 | ||
| 84043 | 35075 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 13 | 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 | ||
| 93466 | 35076 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 11 | 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 | ||
| 127181 | 35074 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 7 | 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 | ||
| 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 | ||
| 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 | ||
| 12056 | 207640 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.90266 | 2104824.95669 | 37.7589974714712 | -122.47017288688 | (37.7589974714712, -122.47017288688) | 1 | 8 | 4 | 56 | 12 | |||
| 63304 | 207643 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992162.23499 | 2104876.45393 | 37.759138772946 | -122.470182404389 | (37.759138772946, -122.470182404389) | 1 | 8 | 4 | 56 | 12 | |||
| 139188 | 207642 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 Funston Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992163.37213 | 2104857.85489 | 37.7590877706116 | -122.470177117291 | (37.7590877706116, -122.470177117291) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 39889 | 38861 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.677 | 37.7587505988826 | -122.479941205975 | (37.7587505988826, -122.479941205975) | 1 | 8 | 3 | 56 | 35 | |
| 63633 | 51408 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 4 | Permit Number 47732 | 5989342.6539 | 2104753.8772 | 37.758638799348 | -122.479924781914 | (37.758638799348, -122.479924781914) | 1 | 8 | 3 | 56 | 35 |
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) );