trees
230 rows where Fire Prevention Districts = 1 and qSpecies_id = 8 sorted by qLegalStatus_id
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 | |||
3623 | 69046 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 3623 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 3 | Permit Number 33053 | 5984457.0554 | 2106305.4338 | 37.762613882253 | -122.496935660667 | (37.762613882253, -122.496935660667) | 1 | 8 | 3 | 56 | 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 | ||
9151 | 110107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 4130 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430 | 2103553 | 37.7548786426579 | -122.507200765499 | (37.7548786426579, -122.507200765499) | 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 | |
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 | |||
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 | |
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 | |||
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 | |
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 | |||
43469 | 64884 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2550 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/1989 12:00:00 AM | 8 | Permit Number 25910 | 5989263.5772 | 2097984.1265 | 37.7400462586589 | -122.479702916678 | (37.7400462586589, -122.479702916678) | 1 | 8 | 3 | 29491 | 35 | |
48236 | 61889 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1583 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/1985 12:00:00 AM | 10 | Permit Number 21932 | 5988683.0577 | 2104556.6784 | 37.7580590010432 | -122.482191490983 | (37.7580590010432, -122.482191490983) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
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 | ||
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 | |||
61267 | 254214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2566 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781239 | 5992084.25539 | 2097978.52044 | 37.7401943216292 | -122.46994985094 | (37.7401943216292, -122.46994985094) | 1 | 8 | 4 | 59 | 40 |
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 | |||
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 | |
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 | |||
83029 | 33172 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2311 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37388 | 5986066.5372792 | 2098877.4979138 | 37.7423129763845 | -122.490822533573 | (37.7423129763845, -122.490822533573) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
95064 | 31284 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2578 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 2 | Permit Number 34932 | 5991129.57041 | 2097871.41628 | 37.7398450082307 | -122.473242924144 | (37.7398450082307, -122.473242924144) | 1 | 8 | 4 | 29491 | 40 | |
96490 | 51407 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1554 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/2004 12:00:00 AM | 5 | Permit Number 47732 | 5989341.6825 | 2104766.5057 | 37.7586734173793 | -122.479929065557 | (37.7586734173793, -122.479929065557) | 1 | 8 | 3 | 56 | 35 | |
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 | |
98116 | 82192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1682 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49856 | 5989061.047 | 2103886.9798 | 37.7562421670239 | -122.480835227785 | (37.7562421670239, -122.480835227785) | 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 | |
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 | |||
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 | |||
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 | |
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 | |
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 | |||
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 | |||
119407 | 37231 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1815 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 5 | Permit Number 46003 | 5985330.0834 | 2102828.2693 | 37.7531176701023 | -122.493659982631 | (37.7531176701023, -122.493659982631) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
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 | |||
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 | |||
143733 | 81450 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1651 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49732 | 5988700.7716 | 2104076.8415 | 37.7567425285058 | -122.482095077474 | (37.7567425285058, -122.482095077474) | 1 | 8 | 3 | 56 | 35 | |
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 | |||
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 | |
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 | |||
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 | |
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 |
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) );