trees
230 rows where Fire Prevention Districts = 1 and qSpecies_id = 8 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 908 | 207538 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993510.99578 | 2106611.92865 | 37.7639818164203 | -122.465643867796 | (37.7639818164203, -122.465643867796) | 1 | 8 | 11 | 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 | |||
| 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 | |||
| 18581 | 207557 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 438 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5993090.30731 | 2105981.36839 | 37.7622261896015 | -122.467053045158 | (37.7622261896015, -122.467053045158) | 1 | 8 | 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 | |||
| 20143 | 207679 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5990677.2269 | 2100653.21825 | 37.7474569149997 | -122.475009933665 | (37.7474569149997, -122.475009933665) | 1 | 8 | 4 | 29491 | 40 | |||
| 22702 | 207672 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 542 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993147.42915 | 2105300.29395 | 37.76035943445 | -122.466805971728 | (37.76035943445, -122.466805971728) | 1 | 8 | 4 | 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 | |||
| 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 | |||
| 24820 | 207648 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992116.65286 | 2104730.33527 | 37.7587349341825 | -122.470329406704 | (37.7587349341825, -122.470329406704) | 1 | 8 | 4 | 56 | 12 | |||
| 25131 | 185158 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.493801554637 | (37.7388527871834, -122.493801554637) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 31204 | 207694 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991855.32533 | 2096348.4574 | 37.7357053452243 | -122.470622695389 | (37.7357053452243, -122.470622695389) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 32991 | 207674 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993300.45868 | 2105307.6542 | 37.7603884744706 | -122.466277253113 | (37.7603884744706, -122.466277253113) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 43141 | 207571 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5993664.12129 | 2104858.25974 | 37.7591755300323 | -122.464986884242 | (37.7591755300323, -122.464986884242) | 1 | 8 | 4 | 56 | 12 | |||
| 48490 | 207572 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1640 09th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 1 | Width 6ft | 5993421.18819 | 2104299.1531 | 37.7576263578793 | -122.465786433692 | (37.7576263578793, -122.465786433692) | 1 | 8 | 4 | 56 | 12 | |||
| 49306 | 112862 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5990594 | 2098423 | 37.7413284897401 | -122.475134938873 | (37.7413284897401, -122.475134938873) | 1 | 8 | 4 | 29491 | 40 | |||
| 50311 | 207583 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 71 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992880.01049 | 2098709.31276 | 37.7422468600076 | -122.467251597511 | (37.7422468600076, -122.467251597511) | 1 | 8 | 4 | 59 | 40 | |||
| 50502 | 207670 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990672.18333 | 2102133.32849 | 37.7515206186011 | -122.475135407975 | (37.7515206186011, -122.475135407975) | 1 | 8 | 4 | 29491 | 12 | |||
| 51578 | 207689 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2686 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990843.09068 | 2097123.05577 | 37.7377736096576 | -122.474178849468 | (37.7377736096576, -122.474178849468) | 1 | 8 | 4 | 29491 | 40 | |||
| 53297 | 99646 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 768958 | 5985627.2622 | 2103048.7649 | 37.7537404715173 | -122.492648532329 | (37.7537404715173, -122.492648532329) | 1 | 8 | 3 | 56 | 35 | ||
| 54968 | 117333 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 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 | |||
| 56479 | 207688 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.475126663888 | (37.7412797470716, -122.475126663888) | 1 | 8 | 4 | 29491 | 40 | |||
| 57254 | 207697 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993442.50262 | 2102313.15594 | 37.7521745516283 | -122.465568443448 | (37.7521745516283, -122.465568443448) | 1 | 8 | 4 | 29491 | 12 | |||
| 59665 | 207585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991309.0934 | 2097696.30904 | 37.7393746016694 | -122.472609451563 | (37.7393746016694, -122.472609451563) | 1 | 8 | 4 | 29491 | 40 | |||
| 60174 | 207532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990908.40478 | 2104231.60064 | 37.757295609713 | -122.474471644475 | (37.757295609713, -122.474471644475) | 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 | |||
| 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 | |||
| 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 | |||
| 78086 | 207586 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1917 08th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993746.75792 | 2102455.06491 | 37.7525817412531 | -122.464526593251 | (37.7525817412531, -122.464526593251) | 1 | 8 | 4 | 29491 | 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 | |||
| 81670 | 207681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991411.6864 | 2097337.95206 | 37.738396582641 | -122.472228618364 | (37.738396582641, -122.472228618364) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 81965 | 207682 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5990792.7433 | 2098630.33856 | 37.7419093048628 | -122.474462888654 | (37.7419093048628, -122.474462888654) | 1 | 8 | 4 | 29491 | 40 | |||
| 82782 | 207684 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990737.5825 | 2098918.54589 | 37.7426974518186 | -122.474674644836 | (37.7426974518186, -122.474674644836) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 87643 | 207669 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1767 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993090.08288 | 2103453.39463 | 37.7552850196943 | -122.466870038526 | (37.7552850196943, -122.466870038526) | 1 | 8 | 4 | 56 | 12 | |||
| 89620 | 207671 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1734 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990626.77188 | 2103577.88918 | 37.7554843697179 | -122.475397903889 | (37.7554843697179, -122.475397903889) | 1 | 8 | 4 | 56 | 12 | |||
| 98479 | 207639 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993046.37719 | 2104789.3186 | 37.7589505970219 | -122.467118308968 | (37.7589505970219, -122.467118308968) | 1 | 8 | 4 | 56 | 12 | |||
| 99589 | 207584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5994383.58117 | 2099287.47444 | 37.7439210289412 | -122.462094670844 | (37.7439210289412, -122.462094670844) | 1 | 8 | 4 | 59 | 40 | |||
| 100690 | 21338 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 102665 | 117316 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | 1 | 8 | 4 | 29491 | 12 | |||
| 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 | |||
| 103351 | 207537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993487.77014 | 2106611.56006 | 37.7639794646992 | -122.465724170953 | (37.7639794646992, -122.465724170953) | 1 | 8 | 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 | |||
| 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 | |||
| 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 | |||
| 108110 | 207678 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3137 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990981.20237 | 2100859.62837 | 37.7480412755876 | -122.473973874217 | (37.7480412755876, -122.473973874217) | 1 | 8 | 4 | 29491 | 40 | |||
| 109418 | 181738 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 2803 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5986967.0668 | 2107072.067 | 37.7648656060734 | -122.488310893002 | (37.7648656060734, -122.488310893002) | 1 | 8 | 3 | 56 | 35 | |||
| 109443 | 117334 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 111369 | 182485 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1563 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985266.5327 | 2104584.1284 | 37.7579350567147 | -122.494009145875 | (37.7579350567147, -122.494009145875) | 1 | 8 | 3 | 56 | 35 | |||
| 113891 | 99647 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985628.3746 | 2103030.4107 | 37.7536901409617 | -122.492643333781 | (37.7536901409617, -122.492643333781) | 1 | 8 | 3 | 56 | 35 | ||
| 114689 | 207579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991315.21064 | 2100156.8914 | 37.7461310831881 | -122.472767665701 | (37.7461310831881, -122.472767665701) | 1 | 8 | 4 | 29491 | 40 | |||
| 115355 | 99644 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 768958 | 5985623.9251 | 2103105.496 | 37.7538960444293 | -122.492664250547 | (37.7538960444293, -122.492664250547) | 1 | 8 | 3 | 56 | 35 | ||
| 118485 | 207577 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990606.99166 | 2102703.3769 | 37.7530820431036 | -122.475402462551 | (37.7530820431036, -122.475402462551) | 1 | 8 | 4 | 56 | 12 | |||
| 120687 | 207582 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 75 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992870.128 | 2098681.7297 | 37.7421705534178 | -122.467283762661 | (37.7421705534178, -122.467283762661) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 122742 | 110457 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 501 TARAVAL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775373 | 5991635.3 | 2099042.5 | 37.7430897750827 | -122.471579655796 | (37.7430897750827, -122.471579655796) | 1 | 8 | 4 | 29491 | 40 | |||
| 123328 | 207680 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2475 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991693.59154 | 2098601.29032 | 37.7418816983798 | -122.471345960741 | (37.7418816983798, -122.471345960741) | 1 | 8 | 4 | 29491 | 40 | |||
| 124224 | 207580 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2638 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991779.82441 | 2097449.35591 | 37.7387237676844 | -122.470963901766 | (37.7387237676844, -122.470963901766) | 1 | 8 | 4 | 29491 | 40 | |||
| 124290 | 207673 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 500 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993279.54162 | 2105307.7731 | 37.7603875940426 | -122.466349603556 | (37.7603875940426, -122.466349603556) | 1 | 8 | 4 | 56 | 12 | |||
| 126151 | 117332 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.472286093711 | (37.7384265182794, -122.472286093711) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 130162 | 207578 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 433 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5993489.67948 | 2105251.0502 | 37.7602439704969 | -122.46561871914 | (37.7602439704969, -122.46561871914) | 1 | 8 | 4 | 56 | 12 | |||
| 130799 | 182614 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1866 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5989725.7736 | 2102651.2747 | 37.7528878642991 | -122.478446043912 | (37.7528878642991, -122.478446043912) | 1 | 8 | 3 | 56 | 35 | |||
| 132333 | 207690 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 642 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991148.86446 | 2099110.57767 | 37.7432485446942 | -122.473266566413 | (37.7432485446942, -122.473266566413) | 1 | 8 | 4 | 29491 | 40 | |||
| 133077 | 207573 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5992999.52261 | 2104555.29136 | 37.7583053145698 | -122.467263336346 | (37.7583053145698, -122.467263336346) | 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 | |||
| 142232 | 207560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 626 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992571.33033 | 2105963.74624 | 37.7621478343785 | -122.468846691741 | (37.7621478343785, -122.468846691741) | 1 | 8 | 11 | 56 | 12 | |||
| 142733 | 218237 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 345 Wawona St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 5992002.51219 | 2097168.37657 | 37.7379651463641 | -122.470173504717 | (37.7379651463641, -122.470173504717) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 148862 | 21341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | 1 | 8 | 3 | 29491 | 35 | |||
| 150648 | 181341 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2500 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5985179.8406 | 2097655.4564 | 37.7389057397188 | -122.493798381455 | (37.7389057397188, -122.493798381455) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 165102 | 207667 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 5993246.28637 | 2103941.58644 | 37.7566344820998 | -122.466365323703 | (37.7566344820998, -122.466365323703) | 1 | 8 | 4 | 56 | 12 | |||
| 165129 | 207675 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1759 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992467.39253 | 2103575.28695 | 37.7555837456991 | -122.469032338792 | (37.7555837456991, -122.469032338792) | 1 | 8 | 4 | 56 | 12 | |||
| 166322 | 207685 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5990740.98987 | 2098842.82853 | 37.7424897489131 | -122.474657338285 | (37.7424897489131, -122.474657338285) | 1 | 8 | 4 | 29491 | 40 | |||
| 169053 | 181735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2801X Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5986996.5941 | 2107070.8859 | 37.7648640858106 | -122.488208680173 | (37.7648640858106, -122.488208680173) | 1 | 8 | 3 | 56 | 35 | |||
| 169516 | 207666 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 5993287.90775 | 2103943.61016 | 37.7566424402051 | -122.466221530195 | (37.7566424402051, -122.466221530195) | 1 | 8 | 4 | 56 | 12 | |||
| 169630 | 99645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1795 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 768958 | 5985624.4813 | 2103086.5856 | 37.7538441541808 | -122.492660934457 | (37.7538441541808, -122.492660934457) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | |||
| 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 | |||
| 174081 | 101247 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 725 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 9951 | 5993550 | 2106615 | 37.7639924992069 | -122.465509188009 | (37.7639924992069, -122.465509188009) | 1 | 8 | 11 | 56 | 12 | ||||
| 174274 | 207533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990908.41918 | 2104245.94994 | 37.7573350099278 | -122.474472641826 | (37.7573350099278, -122.474472641826) | 1 | 8 | 4 | 56 | 12 |
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) );