trees
229 rows where Police Districts = 5 and qSpecies_id = 8 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23536 | 108612 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 774590 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | 15 | 5 | 5 | 28862 | 3 | |
| 188515 | 111022 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1254 07TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993942 | 2106950 | 37.7649349225469 | -122.464177708405 | (37.7649349225469, -122.464177708405) | 11 | 5 | 11 | 56 | 12 | ||||
| 9259 | 112872 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 599x CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5999621 | 2110473 | 37.7749338721416 | -122.444788804756 | (37.7749338721416, -122.444788804756) | 15 | 5 | 11 | 29492 | 16 | |||
| 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 | |||
| 119910 | 115159 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 77440 | 115160 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 178149 | 115161 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 4399 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 777349 | 6000112.8 | 2105706.7 | 37.76187486009 | -122.442745251465 | (37.76187486009, -122.442745251465) | 15 | 5 | 5 | 28862 | 3 | |||
| 100097 | 117321 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1648 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778498 | 5999899 | 2110608.7 | 37.7753223306588 | -122.443836898167 | (37.7753223306588, -122.443836898167) | 15 | 5 | 11 | 29492 | 16 | |||
| 96689 | 137622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2055 TURK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000170.6646 | 2111954.7813 | 37.7790338187699 | -122.442993839351 | (37.7790338187699, -122.442993839351) | 15 | 5 | 11 | 29490 | 16 | |||
| 182321 | 140140 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 229 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998771.9778 | 2109907.5347 | 37.7733327611881 | -122.447685026158 | (37.7733327611881, -122.447685026158) | 15 | 5 | 11 | 29492 | 16 | |||
| 172629 | 140303 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 154 COLE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997832.4894 | 2110000.3166 | 37.7735337774986 | -122.450941522503 | (37.7735337774986, -122.450941522503) | 15 | 5 | 11 | 29492 | 16 | |||
| 180953 | 140730 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5998825.1945 | 2110385.2461 | 37.7746474756927 | -122.447535336227 | (37.7746474756927, -122.447535336227) | 15 | 5 | 11 | 29492 | 16 | |||
| 73797 | 141629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999005.9913 | 2110412.5019 | 37.7747326436678 | -122.446911888169 | (37.7747326436678, -122.446911888169) | 15 | 5 | 11 | 29492 | 16 | |||
| 176591 | 141631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1801 GROVE ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999039.9097 | 2110417.3474 | 37.7747478858622 | -122.446794906704 | (37.7747478858622, -122.446794906704) | 15 | 5 | 11 | 29492 | 16 | |||
| 171500 | 142318 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 551 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | Width 0ft | 5999657.1151 | 2110481.4792 | 37.7749592147956 | -122.444664484942 | (37.7749592147956, -122.444664484942) | 15 | 5 | 11 | 29492 | 16 | ||
| 145476 | 207539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995838.12242 | 2107108.03274 | 37.7654779429827 | -122.457630976687 | (37.7654779429827, -122.457630976687) | 15 | 5 | 11 | 29492 | 12 | |||
| 103613 | 207540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1225 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5994824.85404 | 2107195.02227 | 37.7656585349505 | -122.461141922776 | (37.7656585349505, -122.461141922776) | 15 | 5 | 11 | 56 | 12 | |||
| 67354 | 207541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1231 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994826.21474 | 2107149.24647 | 37.7655329248259 | -122.461133898112 | (37.7655329248259, -122.461133898112) | 15 | 5 | 11 | 56 | 12 | |||
| 151017 | 207542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994826.31079 | 2107131.68473 | 37.7654847103867 | -122.461132292833 | (37.7654847103867, -122.461132292833) | 15 | 5 | 11 | 56 | 12 | |||
| 101858 | 207543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994827.33443 | 2107114.10387 | 37.7654364968285 | -122.461127477873 | (37.7654364968285, -122.461127477873) | 15 | 5 | 11 | 56 | 12 | |||
| 60365 | 207544 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 340 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5994650.56709 | 2107039.97579 | 37.7652227864338 | -122.461733495911 | (37.7652227864338, -122.461733495911) | 15 | 5 | 11 | 56 | 12 | |||
| 131855 | 207545 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1243 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5994515.71143 | 2107079.97224 | 37.7653248424019 | -122.462202826907 | (37.7653248424019, -122.462202826907) | 11 | 5 | 11 | 56 | 12 | |||
| 164180 | 207546 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1249 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993899.6739 | 2106983.20983 | 37.7650236684223 | -122.46432651386 | (37.7650236684223, -122.46432651386) | 11 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 25721 | 207622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | 15 | 5 | 11 | 56 | 12 | |||
| 67124 | 207623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5995446.62936 | 2107316.27502 | 37.7660272254875 | -122.459000132464 | (37.7660272254875, -122.459000132464) | 15 | 5 | 11 | 56 | 12 | |||
| 52633 | 207624 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | 15 | 5 | 11 | 56 | 12 | |||
| 134259 | 207626 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1261 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5995452.06588 | 2106953.75297 | 37.7650321463401 | -122.45895507823 | (37.7650321463401, -122.45895507823) | 15 | 5 | 11 | 56 | 12 | |||
| 86898 | 207627 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 335 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5994699.18168 | 2107000.82647 | 37.7651180909611 | -122.461562512304 | (37.7651180909611, -122.461562512304) | 15 | 5 | 11 | 56 | 12 | |||
| 68309 | 207628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 445 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994326.43022 | 2106989.87938 | 37.7650665705984 | -122.462850964727 | (37.7650665705984, -122.462850964727) | 11 | 5 | 11 | 56 | 12 | |||
| 189731 | 207629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1256 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993954.61606 | 2106931.98149 | 37.7648861755735 | -122.464132764815 | (37.7648861755735, -122.464132764815) | 11 | 5 | 11 | 56 | 12 | |||
| 89327 | 207630 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1262 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993959.14351 | 2106898.71187 | 37.7647950868467 | -122.464114690252 | (37.7647950868467, -122.464114690252) | 11 | 5 | 11 | 56 | 12 | |||
| 71467 | 207631 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1253 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5993899.35074 | 2106950.14127 | 37.7649328521939 | -122.464325230527 | (37.7649328521939, -122.464325230527) | 11 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 58360 | 207655 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1321 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5994849.00569 | 2106528.59646 | 37.7638300927003 | -122.461010081256 | (37.7638300927003, -122.461010081256) | 15 | 5 | 11 | 56 | 12 | |||
| 165373 | 207656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1331 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 5994848.43771 | 2106461.01069 | 37.7636444870228 | -122.461007146788 | (37.7636444870228, -122.461007146788) | 15 | 5 | 11 | 56 | 12 | |||
| 66048 | 207657 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1343 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 5994851.17406 | 2106389.13082 | 37.7634472809955 | -122.460992472547 | (37.7634472809955, -122.460992472547) | 15 | 5 | 11 | 56 | 12 | |||
| 150485 | 207658 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1347 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 5994853.56719 | 2106361.61895 | 37.7633718782394 | -122.460982201389 | (37.7633718782394, -122.460982201389) | 15 | 5 | 11 | 56 | 12 | |||
| 189192 | 207659 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1340 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5994898.23943 | 2106428.28078 | 37.7635574848094 | -122.460832527225 | (37.7635574848094, -122.460832527225) | 15 | 5 | 11 | 56 | 12 | |||
| 61407 | 207660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996711.46943 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | 15 | 5 | 11 | 29492 | 12 | |||
| 58713 | 207661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1205 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996709.68526 | 2107252.63916 | 37.7659250229495 | -122.454626903816 | (37.7659250229495, -122.454626903816) | 15 | 5 | 11 | 29492 | 12 | |||
| 109851 | 207662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.454636030138 | (37.7659760765509, -122.454636030138) | 15 | 5 | 11 | 29492 | 12 | |||
| 78417 | 207663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5996706.11666 | 2107295.55996 | 37.7660426677731 | -122.454642347884 | (37.7660426677731, -122.454642347884) | 15 | 5 | 11 | 29492 | 12 | |||
| 29823 | 207664 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 428 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5996430.67292 | 2106975.20707 | 37.7651472586653 | -122.455571889857 | (37.7651472586653, -122.455571889857) | 15 | 5 | 11 | 29492 | 12 | |||
| 24919 | 207665 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 6ft | 5996615.28225 | 2106600.56008 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | 15 | 5 | 11 | 29492 | 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 | |||
| 133604 | 217739 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 695 Frederick St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5996222.62463 | 2107246.57774 | 37.7658804318647 | -122.456311097499 | (37.7658804318647, -122.456311097499) | 15 | 5 | 11 | 29492 | 12 | |||
| 60325 | 217746 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 631 Frederick St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 5996538.5455 | 2107286.52393 | 37.7660082444099 | -122.455221286434 | (37.7660082444099, -122.455221286434) | 15 | 5 | 11 | 29492 | 12 | |||
| 59849 | 223448 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | 15 | 5 | 11 | 29492 | 12 | |||
| 172558 | 223449 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 133 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997855.21004 | 2106781.676 | 37.7646975140134 | -122.45063083107 | (37.7646975140134, -122.45063083107) | 15 | 5 | 11 | 29492 | 9 | |||
| 178719 | 223450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 109 Alma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998091.45259 | 2106201.0539 | 37.7631167918352 | -122.449771888566 | (37.7631167918352, -122.449771888566) | 15 | 5 | 11 | 29492 | 9 | |||
| 98940 | 223451 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 109 Alma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998103.07896 | 2106202.61569 | 37.7631217452986 | -122.44973178961 | (37.7631217452986, -122.44973178961) | 15 | 5 | 11 | 29492 | 9 | |||
| 28703 | 223452 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998137.72031 | 2105984.6438 | 37.7625252312687 | -122.449596269873 | (37.7625252312687, -122.449596269873) | 15 | 5 | 11 | 29492 | 9 | |||
| 91067 | 223453 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 832 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998055.72491 | 2107364.91893 | 37.7663104264995 | -122.449979345083 | (37.7663104264995, -122.449979345083) | 15 | 5 | 11 | 29492 | 9 | |||
| 106681 | 223454 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 582 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5998651.90281 | 2105834.00743 | 37.7621410238197 | -122.447807062365 | (37.7621410238197, -122.447807062365) | 15 | 5 | 11 | 29492 | 9 | |||
| 177353 | 223455 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 574 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998649.42348 | 2105858.64067 | 37.7622085188156 | -122.447817410864 | (37.7622085188156, -122.447817410864) | 15 | 5 | 11 | 29492 | 9 | |||
| 29432 | 223456 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 508 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998596.25965 | 2106249.17699 | 37.7632777947483 | -122.448029403535 | (37.7632777947483, -122.448029403535) | 15 | 5 | 11 | 29492 | 9 | |||
| 127306 | 223457 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998436.79798 | 2105994.15168 | 37.7625684428081 | -122.448562558536 | (37.7625684428081, -122.448562558536) | 15 | 5 | 11 | 29492 | 9 | |||
| 85915 | 223458 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 557 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998600.4522 | 2105970.1234 | 37.7625118232919 | -122.44799481022 | (37.7625118232919, -122.44799481022) | 15 | 5 | 11 | 29492 | 9 | |||
| 153653 | 223459 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 565 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5998606.57278 | 2105920.50648 | 37.7623759375328 | -122.447970068967 | (37.7623759375328, -122.447970068967) | 15 | 5 | 11 | 29492 | 9 | |||
| 114259 | 223460 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 428 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998537.9355 | 2106688.96854 | 37.7644820175447 | -122.448262797404 | (37.7644820175447, -122.448262797404) | 15 | 5 | 11 | 29492 | 9 | |||
| 101539 | 223461 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 49 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5998343.32414 | 2106238.61167 | 37.7632343233256 | -122.448903459151 | (37.7632343233256, -122.448903459151) | 15 | 5 | 11 | 29492 | 9 | |||
| 90320 | 223462 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 801 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998613.88681 | 2107552.61 | 37.766857700856 | -122.448062291746 | (37.766857700856, -122.448062291746) | 15 | 5 | 11 | 29492 | 9 | |||
| 177660 | 223463 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998590.56714 | 2107229.15156 | 37.7659682326767 | -122.448119657713 | (37.7659682326767, -122.448119657713) | 15 | 5 | 11 | 29492 | 9 | |||
| 28205 | 223464 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998616.14306 | 2107232.00709 | 37.7659775352626 | -122.448031401823 | (37.7659775352626, -122.448031401823) | 15 | 5 | 11 | 29492 | 9 | |||
| 113628 | 223465 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 857 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998659.33443 | 2107218.6486 | 37.7659433250613 | -122.447881050474 | (37.7659433250613, -122.447881050474) | 15 | 5 | 11 | 29492 | 9 | |||
| 52643 | 223466 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 871 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5998671.83935 | 2107146.23742 | 37.7657452169834 | -122.447832585123 | (37.7657452169834, -122.447832585123) | 15 | 5 | 11 | 29492 | 9 | |||
| 133412 | 223467 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 812 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998670.80107 | 2107458.83461 | 37.7666034705969 | -122.447858683442 | (37.7666034705969, -122.447858683442) | 15 | 5 | 11 | 29492 | 9 | |||
| 68644 | 223468 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 61 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998354.91827 | 2106850.96431 | 37.7649163523355 | -122.448907471004 | (37.7649163523355, -122.448907471004) | 15 | 5 | 11 | 29492 | 9 | |||
| 40084 | 223469 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 945 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5998759.82917 | 2106683.9118 | 37.7644808160601 | -122.447494967025 | (37.7644808160601, -122.447494967025) | 15 | 5 | 11 | 29492 | 9 | |||
| 141755 | 223470 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 972 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5998837.19654 | 2106602.69587 | 37.7642622385282 | -122.447221529965 | (37.7642622385282, -122.447221529965) | 15 | 5 | 11 | 29492 | 9 | |||
| 131108 | 223471 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 956 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5998814.74018 | 2106663.16945 | 37.764427000625 | -122.447303552626 | (37.764427000625, -122.447303552626) | 15 | 5 | 11 | 29492 | 9 | |||
| 150359 | 223472 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 905 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999167.22172 | 2107046.81544 | 37.7655005312494 | -122.446112018354 | (37.7655005312494, -122.446112018354) | 15 | 5 | 11 | 29492 | 9 | |||
| 157791 | 223517 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 980 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999663.10864 | 2101754.10727 | 37.7509963650963 | -122.44401653863 | (37.7509963650963, -122.44401653863) | 2 | 5 | 5 | 63 | 38 | |||
| 125149 | 223518 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 988 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999648.8119 | 2101706.51559 | 37.7508648743372 | -122.444062558736 | (37.7508648743372, -122.444062558736) | 2 | 5 | 5 | 63 | 38 | |||
| 73755 | 223547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 577 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996845.23673 | 2107329.23539 | 37.7661431103528 | -122.454163594697 | (37.7661431103528, -122.454163594697) | 15 | 5 | 11 | 29492 | 12 | |||
| 80933 | 223548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 854 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5999175.87751 | 2107341.63153 | 37.7663105164475 | -122.446103287749 | (37.7663105164475, -122.446103287749) | 15 | 5 | 5 | 29492 | 9 | |||
| 91961 | 223549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 900 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5999208.96535 | 2107104.19665 | 37.7656604693858 | -122.445971764578 | (37.7656604693858, -122.445971764578) | 15 | 5 | 5 | 29492 | 9 | |||
| 52305 | 223550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1047 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5997652.48315 | 2106877.54396 | 37.7649491371199 | -122.451338921264 | (37.7649491371199, -122.451338921264) | 15 | 5 | 11 | 29492 | 9 | |||
| 188006 | 223551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.7640629073877 | -122.45115331019 | (37.7640629073877, -122.45115331019) | 15 | 5 | 11 | 29492 | 9 | |||
| 132659 | 223552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997724.56816 | 2106357.12566 | 37.7635243277135 | -122.451052067198 | (37.7635243277135, -122.451052067198) | 15 | 5 | 11 | 29492 | 9 | |||
| 32136 | 223553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1225 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997728.13175 | 2106337.92213 | 37.7634718037012 | -122.451038357055 | (37.7634718037012, -122.451038357055) | 15 | 5 | 11 | 29492 | 9 | |||
| 152194 | 224058 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002712.47217 | 2106530.01609 | 37.7642833447214 | -122.433812870289 | (37.7642833447214, -122.433812870289) | 15 | 5 | 5 | 28862 | 3 | |||
| 11873 | 224059 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002696.79261 | 2106527.84926 | 37.7642765053752 | -122.433866946505 | (37.7642765053752, -122.433866946505) | 15 | 5 | 5 | 28862 | 3 | |||
| 178104 | 224060 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 191 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001739.33994 | 2107707.04853 | 37.767459917457 | -122.437262937651 | (37.767459917457, -122.437262937651) | 15 | 5 | 5 | 29492 | 3 |
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) );