trees
3,965 rows where qSpecies_id = 70 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );