3,965 rows where qSpecies_id = 70 sorted by TreeID

View and edit SQL

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)
21465 104273 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3675 Washington St 2 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
29060 10429 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1428 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 3x3   5999246.24636 2108817.05532 37.7703656761027 -122.445966024888 (37.7703656761027, -122.445966024888) 15 5 11 29492 9
3857 104292 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2245 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999485.4 2120797.2 37.8032736772553 -122.446000602494 (37.8032736772553, -122.446000602494) 13 9 1 57 17
9481 10434 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1457 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   5999128.9575 2108690.2041 37.7700106766776 -122.44636259864 (37.7700106766776, -122.44636259864) 15 5 11 29492 9
27095 104422 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2362 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 3x3   5999509.01294 2120174.0716 37.8015640827681 -122.445874046945 (37.8015640827681, -122.445874046945) 13 9 1 57 17
97745 104425 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 101x WHITNEY YOUNG CIR 2 Sidewalk: Curb side : Cutout Tree DPW 1     23 3x3   6016394 2096049 37.7362715234519 -122.385761317359 (37.7362715234519, -122.385761317359) 10 3 8 58 1
91676 104449 Private 9 Acacia melanoxylon :: Blackwood Acacia 70 2490X Folsom St 4 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
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
146462 10450 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1535 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     65 3X3   5998775.5559 2108640.5401 37.7698541215464 -122.447581428516 (37.7698541215464, -122.447581428516) 15 5 11 29492 9
101676 10451 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1552 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2006 12:00:00 AM 18 3x3   5998701.9695 2108681.2867 37.7699617956519 -122.447838894996 (37.7699617956519, -122.447838894996) 15 5 11 29492 9
174034 10452 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1543 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     35 4X4   5998725.8919 2108633.2722 37.7698313273448 -122.447752691123 (37.7698313273448, -122.447752691123) 15 5 11 29492 9
163575 10454 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1552 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5998706.96692 2108696.47387 37.7700037813949 -122.44782270261 (37.7700037813949, -122.44782270261) 15 5 11 29492 9
131261 104547 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 MADRONE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2015 12:00:00 AM 3 3x6 Permit Number 774728 5992588 2098182 37.7407821316344 -122.468222919411 (37.7407821316344, -122.468222919411) 1 8 4 59 40
166824 104548 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 MADRONE AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     20 3x10 Permit Number 774728 5992588 2098182 37.7407821316344 -122.468222919411 (37.7407821316344, -122.468222919411) 1 8 4 59 40
116029 104640 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 112 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2.5x2.5   6009509.89326 2111697.52669 37.7788555059216 -122.410667371323 (37.7788555059216, -122.410667371323) 8 2 9 28853 34
175626 104641 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 112 07th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 2.5x2.5   6009525.15876 2111682.07782 37.7788139428406 -122.410613470452 (37.7788139428406, -122.410613470452) 8 2 9 28853 34
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
184527 104697 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6011289.75094 2118992.82516 37.7989862912418 -122.405023913231 (37.7989862912418, -122.405023913231) 3 1 10 308 23
54385 104698 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011319.97304 2118997.10943 37.7989997441925 -122.404919635939 (37.7989997441925, -122.404919635939) 3 1 10 308 23
165756 104699 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6011357.95285 2118999.80647 37.7990092725121 -122.404788402388 (37.7990092725121, -122.404788402388) 3 1 10 308 23
124622 104700 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6011383.62949 2119002.34589 37.7990176802704 -122.404699731018 (37.7990176802704, -122.404699731018) 3 1 10 308 23
161844 104713 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1043 Francisco St 1 Sidewalk: Property side : Yard Tree Private 2           6006311.1 2120706.2 37.8034112154379 -122.422373535783 (37.8034112154379, -122.422373535783) 5 9 1 28858 32
119367 104714 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1043 Francisco St 2 Sidewalk: Property side : Yard Tree Private 2           6006311.1 2120706.2 37.8034112154379 -122.422373535783 (37.8034112154379, -122.422373535783) 5 9 1 28858 32
87061 104723 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 133X Juan Bautista Cir 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770293 5989605.82194 2089746.43988 37.7174475379801 -122.477917527277 (37.7174475379801, -122.477917527277) 1 8 4 64 14
76421 10473 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1632 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   5998321.0771 2108628.9487 37.7697963108216 -122.449152617838 (37.7697963108216, -122.449152617838) 15 5 11 29492 9
148762 104745 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 845 25TH AVE   Sidewalk: Curb side : Cutout Tree Private 2     20 4x4   5988152.6 2110221.5 37.7735821764225 -122.484441503692 (37.7735821764225, -122.484441503692) 11 6 2 55 26
115084 104751 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 13X JUAN BAUTISTA CIR 2 Front Yard : Yard Tree Private 2           5989494 2090180 37.7186314952818 -122.47833572412 (37.7186314952818, -122.47833572412) 1 8 4 64 14
31746 104753 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2328 12TH AVE   Front Yard : Cutout Tree Private 2     22   Permit Number 770921 5992676.8 2099585.2 37.7446400909628 -122.468017927356 (37.7446400909628, -122.468017927356) 1 8 4 29491 40
153430 104809 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 685 Marina Blvd   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 770974 5999736.8 2121509.8 37.8052446370698 -122.445181890463 (37.8052446370698, -122.445181890463) 13 9 1 57 17
145206 10481 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1659 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   5998097.85003 2108526.02441 37.7695009368857 -122.449917332032 (37.7695009368857, -122.449917332032) 15 5 11 29492 9
139397 10483 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1667 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   5998066.9359 2108543.6348 37.7695475216255 -122.450025531708 (37.7695475216255, -122.450025531708) 15 5 11 29492 9
57420 10484 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1668 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   5998167.2674 2108607.159 37.7697276834376 -122.449683068712 (37.7697276834376, -122.449683068712) 15 5 11 29492 9
90247 10486 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1672 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/1992 12:00:00 AM 14 3X3   5998110.8706 2108597.7596 37.7696986484007 -122.44987746519 (37.7696986484007, -122.44987746519) 15 5 11 29492 9
134561 10487 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1672 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   5998120.16888 2108653.82599 37.7698531243998 -122.449849344019 (37.7698531243998, -122.449849344019) 15 5 11 29492 9
184296 104943 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 830X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
117611 104976 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 348 STRATFORD DR 1 Sidewalk: Property side : Yard Tree Private 2     14   Permit Number 771068 5990941.2 2090341.4 37.7191585669518 -122.473345157269 (37.7191585669518, -122.473345157269) 9 8 4 64 40
167509 104990 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1931 21ST AVE   Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5989677.9 2102204.3 37.7516578107149 -122.478578913714 (37.7516578107149, -122.478578913714) 1 8 3 29491 35
164017 10501 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1738 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 3x3   5997829.7408 2108561.4434 37.7695828440479 -122.450847260907 (37.7695828440479, -122.450847260907) 15 5 11 29492 9
152281 105092 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3150 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 4X4   5999125.32302 2116324.31891 37.7909717732653 -122.446924598103 (37.7909717732653, -122.446924598103) 13 6 1 29490 31
166796 105142 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 90X Hillway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           5996094.58438 2106700.45244 37.7643735613122 -122.456714459214 (37.7643735613122, -122.456714459214) 15 5 11 29492 12
128374 105220 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1443 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5987410.3461 2105455.8349 37.7604537297774 -122.486659037253 (37.7604537297774, -122.486659037253) 1 8 3 56 35
84707 105273 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 232 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           5986553.3 2114252.8 37.784557719608 -122.490270252434 (37.784557719608, -122.490270252434) 11 6 1 55 33
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
110544 105309 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 455 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x6   5990588.11952 2112283.72283 37.7793859948619 -122.476167419045 (37.7793859948619, -122.476167419045) 11 6 2 55 26
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
56945 105384 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2853 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4x3   5999429.08796 2117689.01477 37.7947362166568 -122.445971784396 (37.7947362166568, -122.445971784396) 13 9 1 57 27
102398 105415 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 1 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 41
114223 105416 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1450X McAllister St 2 Front Yard : Yard Tree Private 2           6002220.78829 2111575.67932 37.7781095739995 -122.435874511445 (37.7781095739995, -122.435874511445) 15 5 11 29492 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
151782 105713 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 40X 18TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   5990254.2 2114862 37.7864458560817 -122.477511071909 (37.7864458560817, -122.477511071909) 11 6 1 55 33
37428 105715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 40X 18TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   5990254.2 2114862 37.7864458560817 -122.477511071909 (37.7864458560817, -122.477511071909) 11 6 1 55 33
61209 105786 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3230 LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     36 6x4   5999056.8 2119897.7 37.8007794095396 -122.447418998501 (37.8007794095396, -122.447418998501) 13 9 1 57 17
164247 105787 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 67- 69 CASA WAY 1 Sidewalk: Curb side : Cutout Tree Private 2     12 9x3 Permit Number 773990 6001454.5 2121609.5 37.8056162809509 -122.439244738513 (37.8056162809509, -122.439244738513) 13 9 1 57 17
124470 105858 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1580 Valencia St 18 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
159232 105859 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1580 Valencia St 18 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
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
165495 105909 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1864X 14TH AVE 1 Median : Yard Tree Rec/Park 5     14     5991829 2102804 37.7534290869332 -122.47118388852 (37.7534290869332, -122.47118388852) 1 8 4 56 12
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
162022 106010 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3198X JACKSON ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   5998962 2116380 37.7911153268207 -122.447493696602 (37.7911153268207, -122.447493696602) 13 6 1 29490 31
185562 106101 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2499X 17TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5991076 2098735 37.7422130856631 -122.473491120869 (37.7422130856631, -122.473491120869) 1 8 4 29491 40
109603 106122 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 163 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13     5987700.63122 2114917.78588 37.7864505202379 -122.486349763522 (37.7864505202379, -122.486349763522) 11 6 1 55 33
67163 106123 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 163 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17     5987700.35927 2114904.97497 37.7864153292934 -122.486349763511 (37.7864153292934, -122.486349763511) 11 6 1 55 33
31991 106187 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1353 ULLOA ST 2 Sidewalk: Curb side : Yard Tree Private 2     12 4x15   5991777 2098367.4 37.7412443198206 -122.471040528993 (37.7412443198206, -122.471040528993) 1 8 4 59 40
192863 106188 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1353 ULLOA ST 1 Sidewalk: Curb side : Yard Tree Private 2     12 4x15   5991777 2098367.4 37.7412443198206 -122.471040528993 (37.7412443198206, -122.471040528993) 1 8 4 59 40
163150 106241 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 4 Sidewalk: Property side : Yard Tree Private 2     10   Permit Number 770844 6012039.11056 2105754.27928 37.7626781762725 -122.401499947673 (37.7626781762725, -122.401499947673) 8 3 8 28856 29
32089 106242 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 5 Sidewalk: Property side : Yard Tree Private 2     6   Permit Number 770844 6012041.04445 2105749.16688 37.7626642466674 -122.401492899679 (37.7626642466674, -122.401492899679) 8 3 8 28856 29
157924 106248 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 9 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 770844 6012033.91664 2105711.77198 37.7625611708892 -122.401514924078 (37.7625611708892, -122.401514924078) 8 3 8 28856 29
70795 106249 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 10 Sidewalk: Curb side : Cutout Tree Private 2     12   Permit Number 770844 6012059.45728 2105702.6288 37.7625374908356 -122.401425945147 (37.7625374908356, -122.401425945147) 8 3 8 28856 29
166203 106317 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1133 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     32 4x4   6012240.80146 2103138.9754 37.7555083807236 -122.400618637234 (37.7555083807236, -122.400618637234) 10 3 8 28856 29
6793 106402 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 163 25TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 18 3x3   5987994.2 2114906.9 37.7864377375077 -122.485333302781 (37.7864377375077, -122.485333302781) 11 6 1 55 33
24319 106459 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 125 HANCOCK ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003462.6 2105028.1 37.7602019821643 -122.431111184527 (37.7602019821643, -122.431111184527) 2 4 5 28862 3
112586 106503 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
130598 106504 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3974 22nd St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 773286 6002049 2102947 37.754407578182 -122.435851245675 (37.754407578182, -122.435851245675) 2 4 5 28862 22
131481 106505 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3975 22nd St 1 Unaccepted Street : Yard Tree Private 2         Permit Number 773291 6002049 2102913 37.7543142223274 -122.435848813122 (37.7543142223274, -122.435848813122) 2 4 5 28862 22
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
140630 106511 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 700 QUINTARA ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5991239 2101167.1 37.7489004421526 -122.473104848416 (37.7489004421526, -122.473104848416) 1 8 4 29491 12
115866 106512 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 700 QUINTARA ST 2 Sidewalk: Curb side : Cutout Tree Private 2           5991239 2101167.1 37.7489004421526 -122.473104848416 (37.7489004421526, -122.473104848416) 1 8 4 29491 12
133901 106598 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1001X SAN JOSE AVE 11 Median : Yard Tree DPW 1     21     6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
151168 106648 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1293 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17     5987685.171 2106501.0088 37.7633395085014 -122.485785269283 (37.7633395085014, -122.485785269283) 1 8 3 56 35
103713 106683 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 125 Maple St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 6x300   5996555.44655 2115800.39633 37.7893860706607 -122.455778326522 (37.7893860706607, -122.455778326522) 11 6 1 54 31
143670 106684 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 199X MAPLE ST 6 Sidewalk: Curb side : Cutout Tree Private 2     30     5996587 2115635 37.7889337475437 -122.455657195728 (37.7889337475437, -122.455657195728) 11 6 1 54 31
132427 106774 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 155X Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   5990905.03002 2094685.30674 37.7310837571916 -122.473786909188 (37.7310837571916, -122.473786909188) 1 8 4 64 40
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
34135 106832 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 138 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 774880 5997571.74884 2115814.60363 37.7894833530272 -122.452263079899 (37.7894833530272, -122.452263079899) 11 6 1 54 31
51401 107045 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1622X MCKINNON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6015259 2096017 37.7361207862805 -122.389683281146 (37.7361207862805, -122.389683281146) 10 3 8 58 1
106101 107308 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 190 EUCALYPTUS DR 3 Front Yard : Yard Tree Private 2     14     5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
145350 107354 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 34 Princeton St   Sidewalk: Curb side : Cutout Tree Private 2   08/25/2014 12:00:00 AM     Permit Number 773911 6007504.47131 2093847.45075 37.7297306299075 -122.41634029479 (37.7297306299075, -122.41634029479) 9 3 7 309 28
119229 107589 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2760 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6000110.02976 2118059.62225 37.7957926664564 -122.443642277677 (37.7957926664564, -122.443642277677) 13 9 1 57 17
72737 107590 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2760 Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6000109.34681 2118076.29285 37.7958384005634 -122.443645838983 (37.7958384005634, -122.443645838983) 13 9 1 57 17
54202 107622 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 191 HAIGHT ST 2 Sidewalk: Curb side : Pot Tree Private 2     2     6005238.1 2109520.1 37.7726363924224 -122.425290219951 (37.7726363924224, -122.425290219951) 7 9 11 28852 10
39521 107816 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 222 28TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     18 5x20   5987167.1 2114462.1 37.7851682253333 -122.488162125765 (37.7851682253333, -122.488162125765) 11 6 1 55 33
153060 107823 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 398X 28th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           5987151.97458 2113602.02096 37.7828058118879 -122.488151230918 (37.7828058118879, -122.488151230918) 11 6 2 55 26
189858 108154 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 350 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6004022.3 2103383.2 37.7557171771691 -122.42905816498 (37.7557171771691, -122.42905816498) 2 4 5 28862 22
146795 108341 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 390x JERSEY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002599 2101610 37.7507677214535 -122.433853648065 (37.7507677214535, -122.433853648065) 2 4 5 28862 22
190560 108342 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 390x JERSEY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002599 2101610 37.7507677214535 -122.433853648065 (37.7507677214535, -122.433853648065) 2 4 5 28862 22
18924 108959 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 447 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5990585.11051 2112333.61073 37.7795227987613 -122.476181473209 (37.7795227987613, -122.476181473209) 11 6 2 55 26
119649 109048 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 2146 Bay St 2 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
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
180863 109131 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 156 Madrone Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2015 12:00:00 AM 3 3x3 Permit Number 774728 5992631.8 2098170.8 37.740753908855 -122.468070662321 (37.740753908855, -122.468070662321) 1 8 4 59 40
167234 109176 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 335 COLON AVE 1 Sidewalk: Property side : Cutout Tree Private 2     26     5995818.3 2094822.2 37.7317429788493 -122.456810889994 (37.7317429788493, -122.456810889994) 9 7 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);