trees
3,965 rows where qSpecies_id = 70 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32061 | 49500 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
32225 | 121022 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
32460 | 46703 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 332(North) Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2002 12:00:00 AM | Permit Number 44834 | 6005821.63060952 | 2110714.77999165 | 37.7759496446584 | -122.423356666691 | (37.7759496446584, -122.423356666691) | 7 | 9 | 11 | 28852 | 10 | |||
32544 | 105274 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 232 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986553.3 | 2114252.8 | 37.784557719608 | -122.490270252434 | (37.784557719608, -122.490270252434) | 11 | 6 | 1 | 55 | 33 | |||||
32576 | 99657 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
32695 | 38515 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2735 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40502 | 5999957.99990299 | 2117760.48412278 | 37.7949626403238 | -122.444146821557 | (37.7949626403238, -122.444146821557) | 13 | 9 | 1 | 57 | 27 | |||
32776 | 252873 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1501 Broderick St | 7 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000422 | 2113928 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | 15 | 6 | 11 | 29490 | 13 | ||||
32815 | 253627 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 44 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 5991061 | 2093828 | 37.7287388406121 | -122.4731851996 | (37.7287388406121, -122.4731851996) | 9 | 8 | 4 | 64 | 40 | ||||
33143 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
33679 | 253604 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 267 Teresita Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5997729 | 2098564 | 37.7421265906625 | -122.450474893449 | (37.7421265906625, -122.450474893449) | 9 | 7 | 4 | 59 | 40 | ||||
33858 | 255597 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
34055 | 105417 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450X McAllister St | 3 | Front Yard : Yard | Tree | Private 2 | 6002220.78829 | 2111575.67932 | 37.7781095739995 | -122.435874511445 | (37.7781095739995, -122.435874511445) | 15 | 5 | 11 | 29492 | 41 | |||||
34078 | 106506 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3975 22nd St | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 773291 | 6002049 | 2102913 | 37.7543142223274 | -122.435848813122 | (37.7543142223274, -122.435848813122) | 2 | 4 | 5 | 28862 | 22 | ||||
35458 | 115141 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
35616 | 256221 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 159X Brewster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
35837 | 114606 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 CURTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000494 | 2088444 | 37.7144972695987 | -122.440188869703 | (37.7144972695987, -122.440188869703) | 9 | 7 | 6 | 28861 | 5 | ||||
35903 | 105966 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 290X Arkansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012903.22107 | 2105890.09903 | 37.7630992845925 | -122.398520809474 | (37.7630992845925, -122.398520809474) | 14 | 3 | 8 | 28856 | 29 | |||||
37336 | 84810 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 654 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | Permit No. 49280 | 5997579.9 | 2108309.3 | 37.7688762175244 | -122.451693255762 | (37.7688762175244, -122.451693255762) | 15 | 5 | 11 | 29492 | 9 | |||
37466 | 46533 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1526 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 44685 | 6001986.07565014 | 2099639.81164239 | 37.7453232498567 | -122.435832240904 | (37.7453232498567, -122.435832240904) | 2 | 7 | 5 | 63 | 22 | ||||
38057 | 102472 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 66 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x15 | 5993897.9 | 2101386.8 | 37.7496572701738 | -122.463926385697 | (37.7496572701738, -122.463926385697) | 1 | 8 | 4 | 29491 | 40 | ||||
38356 | 42959 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2616 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2000 12:00:00 AM | Permit Number 42848 | 6003634.5143762 | 2117314.3321902 | 37.7939466747915 | -122.431393686963 | (37.7939466747915, -122.431393686963) | 13 | 9 | 1 | 29490 | 27 | |||
38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
39243 | 110886 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
39452 | 38955 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.7688475919778 | -122.44492690983 | (37.7688475919778, -122.44492690983) | 15 | 5 | 11 | 29492 | 9 | |||
39912 | 88823 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 110 Clayton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51710 | 5998275 | 2110294 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | 15 | 5 | 11 | 29492 | 16 | ||||
40559 | 104272 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3675 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997210.1 | 2115656.5 | 37.7890285184352 | -122.453502918425 | (37.7890285184352, -122.453502918425) | 11 | 6 | 1 | 54 | 31 | ||||
42888 | 113973 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 11 Hiliritas Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 776381 | 6001589.6 | 2096875.9 | 37.7377116664791 | -122.437005345865 | (37.7377116664791, -122.437005345865) | 2 | 7 | 5 | 63 | 7 | ||||
43226 | 112951 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
43856 | 111715 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2390x MASON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
43872 | 112950 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
44421 | 113145 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 BROADMOOR DR | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990980 | 2092843 | 37.7260295867704 | -122.473393404688 | (37.7260295867704, -122.473393404688) | 9 | 8 | 4 | 64 | 40 | ||||
44638 | 173859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.7352888053199 | -122.42875656067 | (37.7352888053199, -122.42875656067) | 2 | 7 | 5 | 63 | 7 | ||||
45252 | 256859 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 356 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5991007 | 2092571 | 37.7252843060575 | -122.473280239218 | (37.7252843060575, -122.473280239218) | 9 | 8 | 4 | 64 | 40 | ||||
45400 | 117067 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 299X PRESIDIO AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998965 | 2115900 | 37.7897975450498 | -122.447448751983 | (37.7897975450498, -122.447448751983) | 13 | 6 | 1 | 54 | 31 | ||||
45633 | 115929 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3990 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995601 | 2114876 | 37.7867931062819 | -122.459013621631 | (37.7867931062819, -122.459013621631) | 11 | 6 | 1 | 54 | 31 | ||||
46279 | 254187 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 128 Stonecrest Dr | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990776 | 2093635 | 37.7281924051657 | -122.474156376051 | (37.7281924051657, -122.474156376051) | 9 | 8 | 4 | 64 | 40 | |||||
46736 | 47791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 415 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45915 | 5995369.31891331 | 2098249.44976906 | 37.741127575703 | -122.45861111062 | (37.741127575703, -122.45861111062) | 1 | 8 | 4 | 59 | 40 | ||
49681 | 116977 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x CARGO WAY | 117 | Front Yard : Yard | Tree | PUC 8 | DPW for City Agency | 6019010 | 2097405 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | 10 | 3 | 8 | 58 | 1 | ||||
49696 | 87086 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2298 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50031 | 6002046 | 2118096 | 37.7960027754164 | -122.436946080345 | (37.7960027754164, -122.436946080345) | 13 | 9 | 1 | 57 | 17 | |||
50374 | 87004 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 7070 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2007 12:00:00 AM | Permit Number 49944 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
50380 | 116076 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 482X 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002704 | 2099559 | 37.7451421155129 | -122.43334400597 | (37.7451421155129, -122.43334400597) | 2 | 7 | 5 | 63 | 22 | ||||
50841 | 103385 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 104 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999013 | 2116197 | 37.7906157715272 | -122.447304062173 | (37.7906157715272, -122.447304062173) | 13 | 6 | 1 | 29490 | 31 | ||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
52491 | 98830 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 333@Lopez Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994230.9 | 2100817.4 | 37.748113026994 | -122.462733567037 | (37.748113026994, -122.462733567037) | 1 | 8 | 4 | 29491 | 40 | |||||
52641 | 30419 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
52837 | 99659 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1325 Portola Dr | 3 | Front Yard : Yard | Tree | Private 2 | 5993615.2 | 2097760.6 | 37.7396843456359 | -122.464640684629 | (37.7396843456359, -122.464640684629) | 1 | 8 | 4 | 59 | 40 | |||||
53086 | 99902 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2001X Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768908 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | ||||
53341 | 255638 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 220 Masonic Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999023 | 2112089 | 37.7793368479896 | -122.446973720271 | (37.7793368479896, -122.446973720271) | 15 | 5 | 1 | 54 | 16 | |||||
53853 | 117551 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1696 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993456 | 2103978 | 37.7567465627 | -122.465642709543 | (37.7567465627, -122.465642709543) | 1 | 8 | 4 | 56 | 12 | ||||
53964 | 106787 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400 17TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5990900.3 | 2105751.3 | 37.7614678308385 | -122.474610582701 | (37.7614678308385, -122.474610582701) | 1 | 8 | 4 | 56 | 12 | |||||
54213 | 100653 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1594 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 5992503 | 2104630 | 37.7584817696578 | -122.468985951036 | (37.7584817696578, -122.468985951036) | 1 | 8 | 4 | 56 | 12 | ||||
54547 | 105345 | - 12 | Acacia melanoxylon :: Blackwood Acacia 70 | 466 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5989603.4 | 2089229.6 | 37.7160282834266 | -122.477888136934 | (37.7160282834266, -122.477888136934) | 1 | 8 | 4 | 64 | 14 | |||||
54660 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006422 | 2107919 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | 8 | 4 | 7 | 28853 | 19 | ||||
55998 | 99606 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | ||||
56112 | 112489 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2690x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 3x3 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | 5 | 1 | 1 | 308 | 32 | |||
56173 | 53099 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 370@HILL WAY Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | Permit Number 49061 | 5996124.75088045 | 2106531.46709728 | 37.7639113030063 | -122.456597900952 | (37.7639113030063, -122.456597900952) | 15 | 5 | 11 | 29492 | 12 | |||
56494 | 254186 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 120 Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990762 | 2093642 | 37.7282108143844 | -122.474205284655 | (37.7282108143844, -122.474205284655) | 9 | 8 | 4 | 64 | 40 | ||||
57232 | 100838 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 10X Tulane St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x9 | 6007491.7 | 2093814.7 | 37.7296399852574 | -122.416382127882 | (37.7296399852574, -122.416382127882) | 9 | 3 | 7 | 309 | 28 | ||||
57659 | 44175 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3898 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2000 12:00:00 AM | 3x3 | Permit Number 49758 | 5996140.20734213 | 2115579.73573661 | 37.7887563568945 | -122.457199029036 | (37.7887563568945, -122.457199029036) | 11 | 6 | 1 | 54 | 31 | ||
57849 | 111229 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 1113 SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001842 | 2112262 | 37.7799725127801 | -122.4372340286 | (37.7799725127801, -122.4372340286) | 15 | 5 | 11 | 29490 | 41 | ||||
58489 | 104690 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1435X La Salle Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770699 | 6016460.43075 | 2095036.98644 | 37.7334964128222 | -122.385461132957 | (37.7334964128222, -122.385461132957) | 10 | 3 | 8 | 58 | 1 | ||||
58924 | 120989 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | ||||
58946 | 30316 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.7926503347532 | -122.412449106972 | (37.7926503347532, -122.412449106972) | 3 | 1 | 10 | 28857 | 21 | |||
59675 | 110867 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
59777 | 113939 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3333 BUCHANAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003181 | 2119826 | 37.8008173514055 | -122.433142433403 | (37.8008173514055, -122.433142433403) | 13 | 9 | 1 | 57 | 17 | |||||
60143 | 44378 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2914 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2001 12:00:00 AM | Permit Number 43741 | 6000185.55647701 | 2116798.34873064 | 37.7923338489092 | -122.443290306111 | (37.7923338489092, -122.443290306111) | 13 | 6 | 1 | 29490 | 27 | |||
60308 | 99100 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 60 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993700.7 | 2097327 | 37.7384987171226 | -122.464313592449 | (37.7384987171226, -122.464313592449) | 1 | 8 | 4 | 59 | 40 | |||||
60364 | 113532 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2681 28TH AVE | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x6 | 5987701 | 2097026 | 37.7373245974808 | -122.485035321422 | (37.7373245974808, -122.485035321422) | 1 | 8 | 3 | 29491 | 35 | ||||
60574 | 34959 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 29 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 38552 | 5990777 | 2114840 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | 11 | 6 | 1 | 54 | 33 | |||
60688 | 41311 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 41 Garcia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2002 12:00:00 AM | Permit Number 41984 | 5995254.05842615 | 2099498.8895679 | 37.7445516019752 | -122.459100086565 | (37.7445516019752, -122.459100086565) | 1 | 8 | 4 | 59 | 40 | ||
62131 | 94648 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1811 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 53785 | 6001987.8 | 2114705.4 | 37.786689755292 | -122.436904612265 | (37.786689755292, -122.436904612265) | 13 | 6 | 11 | 29490 | 27 | ||||
62177 | 99097 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 99X Santa Monica Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5994003.8 | 2097131.6 | 37.7379796635799 | -122.463251452094 | (37.7379796635799, -122.463251452094) | 9 | 8 | 4 | 59 | 40 | |||||
62812 | 39261 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 6 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/1998 12:00:00 AM | Permit Number 40878 | 5995333.92231656 | 2100243.53450835 | 37.7466008020426 | -122.458877837799 | (37.7466008020426, -122.458877837799) | 1 | 8 | 4 | 59 | 40 | |||
63654 | 99198 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 726 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986369 | 2114825 | 37.786118050599 | -122.490949979792 | (37.786118050599, -122.490949979792) | 11 | 6 | 1 | 55 | 33 | |||||
63702 | 98819 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 62 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 768816 | 6000868 | 2109174 | 37.7714382288844 | -122.440381995657 | (37.7714382288844, -122.440381995657) | 15 | 5 | 11 | 29492 | 9 | ||||
63703 | 86887 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 56 Casa Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.438963625045 | (37.8057359986938, -122.438963625045) | 13 | 9 | 1 | 57 | 17 | ||||
64261 | 110884 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
65596 | 52661 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1596 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/2006 12:00:00 AM | 7x6 | Permit Number 48740 | 5993413.6797412 | 2104632.19014775 | 37.7585403580185 | -122.465836598218 | (37.7585403580185, -122.465836598218) | 1 | 8 | 4 | 56 | 12 | ||
65765 | 173753 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1140 Lawton St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990653 | 2104548 | 37.7581495573033 | -122.475378025252 | (37.7581495573033, -122.475378025252) | 1 | 8 | 4 | 56 | 12 | |||||
66013 | 46614 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.460036555222 | (37.7476978436736, -122.460036555222) | 1 | 8 | 4 | 29491 | 40 | |||
66217 | 87839 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 815 Buena Vista West Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2008 12:00:00 AM | 3x3 | Permit Number 50724 | 5999858 | 2108239 | 37.76881339508 | -122.443808439423 | (37.76881339508, -122.443808439423) | 15 | 5 | 11 | 29492 | 9 | ||
66241 | 96357 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3622 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5 x6 | 5999184 | 2121228 | 37.8044393220775 | -122.447074624063 | (37.8044393220775, -122.447074624063) | 13 | 9 | 1 | 57 | 17 | ||||
66510 | 51553 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 3800 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2005 12:00:00 AM | Permit Number 47852 | 5996586.74903344 | 2115641.8686237 | 37.7889525925387 | -122.455658560713 | (37.7889525925387, -122.455658560713) | 11 | 6 | 1 | 54 | 31 | |||
67303 | 109049 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2146 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774033 | 6000515.3 | 2120331 | 37.8020523729009 | -122.442403120222 | (37.8020523729009, -122.442403120222) | 13 | 9 | 1 | 57 | 17 | ||||
67682 | 99604 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
68481 | 30420 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 599 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/1956 12:00:00 AM | Permit Number 74 | 6011244.65303661 | 2117958.27162773 | 37.7961431366669 | -122.405107081517 | (37.7961431366669, -122.405107081517) | 3 | 1 | 10 | 28857 | 4 | |||
68601 | 40557 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1494 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2002 12:00:00 AM | Permit Number 46100 | 6003279.18698139 | 2099536.66435899 | 37.7451134017483 | -122.431353516201 | (37.7451134017483, -122.431353516201) | 2 | 7 | 5 | 63 | 22 | |||
68698 | 104451 | Private 9 | Acacia melanoxylon :: Blackwood Acacia 70 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
69214 | 101006 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||||
69659 | 99601 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 43709 | 6003513 | 2117956 | 37.7957016423098 | -122.431859976813 | (37.7957016423098, -122.431859976813) | 13 | 9 | 1 | 57 | 17 | |||
69908 | 51791 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 485 Colon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2005 12:00:00 AM | Permit Number 48040 | 5995434.95012874 | 2095496.4695716 | 37.733572339482 | -122.458184982463 | (37.733572339482, -122.458184982463) | 9 | 7 | 4 | 59 | 40 | |||
70337 | 256353 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Sunset Blvd | 119 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 5984828.6477 | 2106722.4547 | 37.7637806720109 | -122.495681237536 | (37.7637806720109, -122.495681237536) | 1 | 8 | 3 | 56 | 35 | ||||
70426 | 115147 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 EXECUTIVE PARK BLVD | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013586 | 2086931 | 37.7110795456085 | -122.394831429854 | (37.7110795456085, -122.394831429854) | 10 | 3 | 8 | 58 | 1 | ||||
70595 | 112952 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 300X VICENTE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992030 | 2097800 | 37.7397010133852 | -122.470124446456 | (37.7397010133852, -122.470124446456) | 1 | 8 | 4 | 59 | 40 | ||||
70861 | 89211 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1540 Pacheco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51845 | 5990117.7 | 2101817.3 | 37.7506207352004 | -122.47702976858 | (37.7506207352004, -122.47702976858) | 1 | 8 | 3 | 29491 | 35 | |||
71652 | 173717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004584 | 2110624 | 37.7756304570983 | -122.427631485331 | (37.7756304570983, -122.427631485331) | 7 | 9 | 11 | 28852 | 10 | ||||
71908 | 87252 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 20 Burr Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50276 | 6007848.5 | 2086602.7 | 37.7098574142528 | -122.414638464087 | (37.7098574142528, -122.414638464087) | 9 | 7 | 8 | 309 | 39 | |||
72037 | 100067 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 93 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | On property line with 99 Buena Vista Ter | 6001505.1 | 2107681.4 | 37.7673761743712 | -122.438071302911 | (37.7673761743712, -122.438071302911) | 15 | 5 | 5 | 29492 | 3 | |||
72727 | 48354 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 18 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45763 | 6001410.60770745 | 2108152.23015211 | 37.7686635831086 | -122.438431874653 | (37.7686635831086, -122.438431874653) | 15 | 5 | 5 | 29492 | 3 | |||
72979 | 258065 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 3233 Irving St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5985670 | 2106323 | 37.7627331150852 | -122.492741876307 | (37.7627331150852, -122.492741876307) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );