trees
2,421 rows where qSpecies_id = 8 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1511 | 260421 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
3265 | 255205 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
3729 | 260419 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
4341 | 255207 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
4693 | 255208 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
7451 | 255209 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
8207 | 47474 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
9047 | 47479 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2002 12:00:00 AM | Permit Number 45375 | ||||||||||||||
12861 | 253706 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
14527 | 255214 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
16949 | 255206 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 320 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
17633 | 255212 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
18139 | 260420 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 200x Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
18342 | 253705 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 98X Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2017 12:00:00 AM | 3 | 3x4 | Permit Number 775137 | |||||||||||
18784 | 255213 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 400 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
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 | |
4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
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 | |||
14053 | 62766 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 318 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1988 12:00:00 AM | Permit Number 25290 | 5993348.39587904 | 2103942.72221653 | 37.7566434919089 | -122.466012277578 | (37.7566434919089, -122.466012277578) | 1 | 8 | 4 | 56 | 12 | ||
14205 | 79589 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1746 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53534 | 5993448.84463132 | 2103598.20779392 | 37.7557033388246 | -122.465639863764 | (37.7557033388246, -122.465639863764) | 1 | 8 | 4 | 56 | 12 | ||
17913 | 35078 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
24551 | 62760 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 409 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23114 | 5993046.38592213 | 2104560.1415905 | 37.7583213372073 | -122.467101616449 | (37.7583213372073, -122.467101616449) | 1 | 8 | 4 | 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 | |||
25797 | 35077 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
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 | |
28303 | 56711 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1659 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2015 12:00:00 AM | Permit Number 774226 | 5983116.27836009 | 2103843.81660781 | 37.7557763190096 | -122.501390749613 | (37.7557763190096, -122.501390749613) | 1 | 8 | 3 | 56 | 35 | |||
30235 | 35086 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
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 | |||
34300 | 92278 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 515 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52728 | 5991376 | 2097700 | 37.7393886087034 | -122.472378389349 | (37.7393886087034, -122.472378389349) | 1 | 8 | 4 | 29491 | 40 | ||
34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
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 | |||
36832 | 64890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25916 | 5990747.37657328 | 2098534.47311176 | 37.7416434544453 | -122.474612755594 | (37.7416434544453, -122.474612755594) | 1 | 8 | 4 | 29491 | 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 | |
42483 | 83354 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1322-24 11th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50904 | 5992731.01277957 | 2106452.183429 | 37.763498178334 | -122.468329951548 | (37.763498178334, -122.468329951548) | 1 | 8 | 11 | 56 | 12 | ||
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 | |
46775 | 44051 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1714 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43580 | 5993441.9028453 | 2103807.69125105 | 37.7562781258297 | -122.465679089291 | (37.7562781258297, -122.465679089291) | 1 | 8 | 4 | 56 | 12 | |||
47336 | 114900 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 775911 | 5994035.5 | 2105147.2 | 37.7599902919139 | -122.463723459922 | (37.7599902919139, -122.463723459922) | 1 | 5 | 4 | 56 | 12 | |||
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 | |||
48777 | 54276 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1459 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/1972 12:00:00 AM | 5x6 | Permit Number 10029 | 5993329.78711521 | 2105558.33296163 | 37.761078465039 | -122.466194038055 | (37.761078465039, -122.466194038055) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
53137 | 64881 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/1989 12:00:00 AM | 10 | 3X3 | Permit Number 25903 | 5990675.59164589 | 2098407.0770941 | 37.7412894981021 | -122.474851664533 | (37.7412894981021, -122.474851664533) | 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 | ||
53966 | 37491 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.475545577058 | (37.7635596145943, -122.475545577058) | 1 | 8 | 3 | 56 | 12 | ||
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 | |||
59509 | 35073 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
59529 | 66339 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1455 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | Permit Number 29460 | 5986479.28524168 | 2105348.90942055 | 37.7601058207136 | -122.489871239473 | (37.7601058207136, -122.489871239473) | 1 | 8 | 3 | 56 | 35 | ||
59586 | 52350 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 10 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2005 12:00:00 AM | Permit Number 48491 | 5992970.80290968 | 2099088.07445215 | 37.7432920844492 | -122.46696519775 | (37.7432920844492, -122.46696519775) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
60727 | 92277 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2009 12:00:00 AM | 3x3 | Permit Number 52726 | 5992357 | 2098417 | 37.7414140378166 | -122.469038721636 | (37.7414140378166, -122.469038721636) | 1 | 8 | 4 | 59 | 40 | ||
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 |
61559 | 92240 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1470 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 3x3 | Permit Number 52686 | 5986244.6 | 2105237.3 | 37.7597856659048 | -122.490674680595 | (37.7597856659048, -122.490674680595) | 1 | 8 | 3 | 56 | 35 | |||
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 | |
64249 | 252820 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 2339 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2017 12:00:00 AM | 3 | 3x3 | 5983590.30233 | 2099230.68636 | 37.743137766616 | -122.499410557243 | (37.743137766616, -122.499410557243) | 1 | 8 | 3 | 29491 | 35 | ||
65154 | 47258 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944 | 2106611 | 37.763772878654 | -122.477980844758 | (37.763772878654, -122.477980844758) | 1 | 8 | 3 | 56 | 35 | ||
67962 | 33202 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51141 | 5994405.76875734 | 2099294.92155065 | 37.743942754277 | -122.462018491778 | (37.743942754277, -122.462018491778) | 1 | 8 | 4 | 59 | 40 | ||
68593 | 50890 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2242 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2004 12:00:00 AM | Permit Number 47400 | 5991328.18651744 | 2100148.47255099 | 37.7461087183508 | -122.472722183475 | (37.7461087183508, -122.472722183475) | 1 | 8 | 4 | 29491 | 40 | ||
72996 | 47143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2179 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2016 12:00:00 AM | 3 | Permit Number 777489 | 5991297.44493317 | 2100594.37185861 | 37.7473312629118 | -122.472860991281 | (37.7473312629118, -122.472860991281) | 1 | 8 | 4 | 29491 | 40 | |
74034 | 35084 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
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 | |||
75288 | 35080 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/2001 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 | ||
77340 | 254477 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1386 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778443 | 5993977.44675 | 2106077.77361 | 37.7625420596989 | -122.463991787904 | (37.7625420596989, -122.463991787904) | 1 | 5 | 11 | 56 | 12 | |
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 | |||
78686 | 83962 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 626 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767447 | 5992636.32789452 | 2105971.3213845 | 37.7621723886495 | -122.46862244319 | (37.7621723886495, -122.46862244319) | 1 | 8 | 11 | 56 | 12 | |
79788 | 82191 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1995 21st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49854 | 5989705.78063845 | 2101796.33096673 | 37.7505392542177 | -122.478452670316 | (37.7505392542177, -122.478452670316) | 1 | 8 | 3 | 29491 | 35 | ||
80598 | 37489 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39958 | 5990687.69704484 | 2106519.91830078 | 37.7635659299099 | -122.475402000804 | (37.7635659299099, -122.475402000804) | 1 | 8 | 3 | 56 | 12 | ||
81292 | 207563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
82445 | 254665 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778441 | 5989948 | 2103325 | 37.7547506343258 | -122.477726795598 | (37.7547506343258, -122.477726795598) | 1 | 8 | 3 | 56 | 35 | |
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 | |
84043 | 35075 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1541 12th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.7593944056925 | -122.46929829243 | (37.7593944056925, -122.46929829243) | 1 | 8 | 4 | 56 | 12 |
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) );