Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 91700 | 91700 | 95229 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 15 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | |||
| 104669 | 104669 | 95231 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 1@Carl Irving St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11/16/2010 12:00:00 AM | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256001 | (37.7645027364821, -122.45767767256) | ||||
| 55717 | 55717 | 98543 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 97300 | 97300 | 98544 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 81189 | 81189 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | |||||
| 106068 | 106068 | 100123 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 97641 | 97641 | 102753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 3x9 | 5992553.895830001 | 2111741.50306 | 37.778011002181 | -122.469327555756 | (37.778011002181, -122.469327555756) | |||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 122781 | 122781 | 104713 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.42237353578301 | (37.8034112154379, -122.422373535783) | |||||
| 107424 | 107424 | 104714 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1043 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6006311.1 | 2120706.2 | 37.8034112154379 | -122.42237353578301 | (37.8034112154379, -122.422373535783) | |||||
| 105643 | 105643 | 104976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 348 STRATFORD DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Permit Number 771068 | 5990941.2 | 2090341.4 | 37.7191585669518 | -122.473345157269 | (37.7191585669518, -122.473345157269) | |||
| 74119 | 74119 | 106241 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Permit Number 770844 | 6012039.11056 | 2105754.27928 | 37.7626781762725 | -122.401499947673 | (37.7626781762725, -122.401499947673) | |||
| 34140 | 34140 | 106242 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 De Haro St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6012041.04445 | 2105749.16688 | 37.7626642466674 | -122.401492899679 | (37.7626642466674, -122.401492899679) | |||
| 87647 | 87647 | 110867 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 107764 | 107764 | 110871 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 121836 | 121836 | 110880 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 102724 | 102724 | 110882 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 84623 | 84623 | 110884 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 79528 | 79528 | 110886 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 800 INDIANA ST | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 119956 | 119956 | 111044 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1635 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x10 | Permit Number 775721 | 5995557.0 | 2094802.0 | 37.731672507077896 | -122.457712790279 | (37.7316725070779, -122.457712790279) | |||
| 107871 | 107871 | 116087 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 103243 | 103243 | 116088 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 79584 | 79584 | 116089 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 131027 | 131027 | 118056 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 494 36th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 5984738.41738 | 2112623.7667900003 | 37.779978707908604 | -122.49642879091999 | (37.7799787079086, -122.49642879092) | |||
| 57277 | 57277 | 119514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 741 31st Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5986354.9828699995 | 2110811.50583 | 37.775097324761 | -122.49070306495399 | (37.775097324761, -122.490703064954) | ||||
| 179804 | 179804 | 120391 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 24th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5988455.47289 | 2110915.29878 | 37.775504786578004 | -122.483444705322 | (37.775504786578, -122.483444705322) | ||||
| 58213 | 58213 | 120394 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 24th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5988458.95627 | 2110817.6647900003 | 37.7752369136053 | -122.483425496649 | (37.7752369136053, -122.483425496649) | ||||
| 27629 | 27629 | 123096 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 615 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 5992508.96289 | 2111250.82612 | 37.776661139698206 | -122.469447267036 | (37.7766611396982, -122.469447267036) | |||
| 62146 | 62146 | 123111 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5992554.4864300005 | 2111759.84228 | 37.7780613908307 | -122.469326847882 | (37.7780613908307, -122.469326847882) | |||
| 182446 | 182446 | 123112 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992554.51535 | 2111751.4814400002 | 37.778038435904605 | -122.46932613911999 | (37.7780384359046, -122.46932613912) | |||
| 156064 | 156064 | 123113 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 542 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992555.85781 | 2111747.17119 | 37.7780266787051 | -122.469321181301 | (37.7780266787051, -122.469321181301) | |||
| 77266 | 77266 | 123114 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 546 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 3ft | 5992556.00301 | 2111715.15487 | 37.7779387789701 | -122.469318348039 | (37.7779387789701, -122.469318348039) | |||
| 173228 | 173228 | 123116 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 562 11th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 5992559.20376 | 2111633.72876 | 37.777715389925 | -122.469301347393 | (37.777715389925, -122.469301347393) | |||
| 53687 | 53687 | 123117 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 562 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 5992559.61492 | 2111614.3487400003 | 37.7776622014062 | -122.469298514108 | (37.7776622014062, -122.469298514108) | |||
| 53075 | 53075 | 123118 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 566 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 5992559.10446 | 2111590.0945099997 | 37.7775955763708 | -122.469298514128 | (37.7775955763708, -122.469298514128) | |||
| 189113 | 189113 | 123119 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 574 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 3ft | 5992561.79357 | 2111542.7313099997 | 37.7774656852602 | -122.469285763443 | (37.7774656852602, -122.469285763443) | |||
| 134305 | 134305 | 123120 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 578 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 3ft | 5992563.43594 | 2111513.74187 | 37.7773861830229 | -122.469277971458 | (37.7773861830229, -122.469277971458) | |||
| 180036 | 180036 | 123121 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 586 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5992562.41321 | 2111484.60446 | 37.7773061204935 | -122.469279388077 | (37.7773061204935, -122.469279388077) | |||
| 25578 | 25578 | 123143 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 582 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 5ft | 5992871.73325 | 2111517.5992400004 | 37.7774145847454 | -122.468211760136 | (37.7774145847454, -122.468211760136) | |||
| 172313 | 172313 | 123161 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 511 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5992793.37077 | 2111978.9319599997 | 37.7786767533022 | -122.46851641299 | (37.7786767533022, -122.46851641299) | ||||
| 132664 | 132664 | 123162 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 515 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5992793.9326599995 | 2111949.94686 | 37.7785972005356 | -122.468512359779 | (37.7785972005356, -122.468512359779) | ||||
| 37409 | 37409 | 123163 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 515 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5992793.60446 | 2111925.06409 | 37.7785288602389 | -122.468511684261 | (37.7785288602389, -122.468511684261) | ||||
| 132872 | 132872 | 123167 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 583 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 5992809.53331 | 2111512.68514 | 37.7773974994236 | -122.468426570673 | (37.7773974994236, -122.468426570673) | ||||
| 134485 | 134485 | 123185 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 591 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5993121.765430001 | 2111452.55215 | 37.7772504203411 | -122.46734209303001 | (37.7772504203411, -122.46734209303) | |||
| 27646 | 27646 | 123187 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 583 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5993119.00687 | 2111524.26387 | 37.777447162121796 | -122.46735685145599 | (37.7774471621218, -122.467356851456) | |||
| 148818 | 148818 | 123189 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 579 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5993119.32976 | 2111553.1452 | 37.77752648109811 | -122.467357835096 | (37.7775264810981, -122.467357835096) | |||
| 31464 | 31464 | 123190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 575 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 9ft | 5993120.96689 | 2111576.90099 | 37.7775918025948 | -122.46735389958401 | (37.7775918025948, -122.467353899584) | |||
| 43162 | 43162 | 123191 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 571 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 9ft | 5993121.2243 | 2111602.66813 | 37.777662567064205 | -122.467354883235 | (37.7776625670642, -122.467354883235) | |||
| 126327 | 126327 | 123192 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 567 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5993116.39439 | 2111629.9582599998 | 37.77773721956179 | -122.467373576298 | (37.7777372195618, -122.467373576298) | |||
| 153250 | 153250 | 123193 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 563 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5993115.20041 | 2111654.33982 | 37.7778040958117 | -122.46737948001001 | (37.7778040958117, -122.46737948001) | |||
| 60579 | 60579 | 124306 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 165 Jordan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 5ft | 5996204.49781 | 2113222.09495 | 37.782286597951 | -122.45680601086599 | (37.782286597951, -122.456806010866) | |||
| 74516 | 74516 | 124357 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 17 Palm Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5995831.628830001 | 2114355.0626 | 37.7853760070031 | -122.45817798803301 | (37.7853760070031, -122.458177988033) | |||
| 26568 | 26568 | 124644 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Arguello Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 9ft | 5995537.35644 | 2115745.75128 | 37.7891775496077 | -122.459296819974 | (37.7891775496077, -122.459296819974) | |||
| 168149 | 168149 | 124823 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 250 Cervantes Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6000834.31444 | 2121522.83872 | 37.805343021434496 | -122.441384750901 | (37.8053430214345, -122.441384750901) | |||
| 31937 | 31937 | 124973 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2815 Filbert St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5999464.00903 | 2118379.34034 | 37.796633661183 | -122.445900626411 | (37.796633661183, -122.445900626411) | |||
| 37450 | 37450 | 125128 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2545 Baker St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 5999632.1533699995 | 2117620.57677 | 37.7945598973812 | -122.44526423016 | (37.7945598973812, -122.44526423016) | |||
| 47418 | 47418 | 125164 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2667 Vallejo St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6000873.86204 | 2117537.36223 | 37.7944022120528 | -122.440961798859 | (37.7944022120528, -122.440961798859) | |||
| 23882 | 23882 | 125253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Reed St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008205.34429 | 2117069.05453 | 37.793531190756205 | -122.41556074355101 | (37.7935311907562, -122.415560743551) | ||||
| 135726 | 135726 | 125261 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 15 Marion Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 6008348.5682 | 2119344.93411 | 37.7997882418978 | -122.41522635583401 | (37.7997882418978, -122.415226355834) | ||||
| 169555 | 169555 | 125268 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2960 Van Ness Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 9ft | 6005626.14224 | 2120703.55494 | 37.8033652908254 | -122.42474367328 | (37.8033652908254, -122.42474367328) | |||
| 166684 | 166684 | 125282 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1151 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6006775.37415 | 2120099.5583599997 | 37.8017717101681 | -122.420723801756 | (37.8017717101681, -122.420723801756) | ||||
| 10123 | 10123 | 173857 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10125 | 10125 | 173858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10116 | 10116 | 173859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 182634 | 182634 | 174969 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 445 Wayland St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6010264.89767 | 2092223.3382299999 | 37.7254259988853 | -122.40668274244 | (37.7254259988853, -122.40668274244) | |||
| 164486 | 164486 | 175060 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 153 Gladstone Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 5ft | 6005789.97929 | 2093692.61819 | 37.729208933235796 | -122.42225649384899 | (37.7292089332358, -122.422256493849) | |||
| 40974 | 40974 | 181393 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984912.5728 | 2104566.45 | 37.757865799574496 | -122.49523196663799 | (37.7578657995745, -122.495231966638) | |||
| 46510 | 46510 | 181396 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1500 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984914.2437 | 2104590.3992 | 37.757931655251 | -122.495227954147 | (37.757931655251, -122.495227954147) | |||
| 67384 | 67384 | 181500 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984893.9566 | 2105458.3528 | 37.760313626354105 | -122.49536212461099 | (37.7603136263541, -122.495362124611) | |||
| 50308 | 50308 | 181501 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984882.2605 | 2105466.1502 | 37.7603343510083 | -122.495403150426 | (37.7603343510083, -122.495403150426) | |||
| 71882 | 71882 | 181558 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984865.8302 | 2106073.5142 | 37.762001040719 | -122.49550477107599 | (37.762001040719, -122.495504771076) | |||
| 28388 | 28388 | 181560 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.3745 | 2106086.3243 | 37.7620359527601 | -122.49552112623002 | (37.7620359527601, -122.49552112623) | |||
| 38719 | 38719 | 181561 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984871.9567 | 2106086.8812 | 37.7620381014978 | -122.49548456812 | (37.7620381014978, -122.49548456812) | |||
| 41724 | 41724 | 181562 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.0859 | 2106095.0617 | 37.7620599263149 | -122.495522768827 | (37.7620599263149, -122.495522768827) | |||
| 50149 | 50149 | 181563 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984874.1846 | 2106092.4508 | 37.762053524514606 | -122.495477273587 | (37.7620535245146, -122.495477273587) | |||
| 175771 | 175771 | 181565 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984872.5636 | 2106101.5491 | 37.7620784109817 | -122.495483550979 | (37.7620784109817, -122.495483550979) | |||
| 30490 | 30490 | 184072 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984928.5463 | 2103997.684 | 37.756305061112705 | -122.495134783659 | (37.7563050611127, -122.495134783659) | |||
| 51775 | 51775 | 184075 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600 Sunset Blvd | 76 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984932.9377 | 2104018.8187 | 37.756363348236604 | -122.49512115533199 | (37.7563633482366, -122.495121155332) | |||
| 33671 | 33671 | 184350 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 0ft | 5984674.1222 | 2106470.7267 | 37.7630804473372 | -122.496197112117 | (37.7630804473372, -122.496197112117) | |||
| 38326 | 38326 | 184352 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1251 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984691.969 | 2106499.9651 | 37.7631617731469 | -122.496137544283 | (37.7631617731469, -122.496137544283) | |||
| 62247 | 62247 | 184510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5983188.0663 | 2101709.4842 | 37.749920253660605 | -122.500984645445 | (37.7499202536606, -122.500984645445) | |||
| 48295 | 48295 | 184511 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5983188.0663 | 2101701.7005 | 37.749898881781895 | -122.50098406985501 | (37.7498988817819, -122.500984069855) | |||
| 49203 | 49203 | 184512 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5983188.7431 | 2101700.3468 | 37.7498952046369 | -122.50098162938299 | (37.7498952046369, -122.500981629383) | |||
| 44355 | 44355 | 184513 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5983187.3894 | 2101698.6547 | 37.7498904791156 | -122.50098618533801 | (37.7498904791156, -122.500986185338) | |||
| 174232 | 174232 | 184514 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1975 42nd Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5983188.0663 | 2101693.9168 | 37.749877509903 | -122.500983494265 | (37.749877509903, -122.500983494265) | |||
| 60878 | 60878 | 184773 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984703.3606 | 2105992.6601 | 37.7617695231787 | -122.496060716498 | (37.7617695231787, -122.496060716498) | |||
| 26399 | 26399 | 184774 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984678.2991 | 2105977.4713 | 37.7617263510589 | -122.496146272255 | (37.7617263510589, -122.496146272255) | |||
| 45936 | 45936 | 184776 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984696.9053 | 2105942.9168 | 37.7616325639121 | -122.49607937246901 | (37.7616325639121, -122.496079372469) | |||
| 38748 | 38748 | 184777 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984706.0186 | 2105944.056 | 37.7616362256202 | -122.496047937787 | (37.7616362256202, -122.496047937787) | |||
| 42608 | 42608 | 184797 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984676.0208 | 2105815.7109 | 37.761282068862 | -122.496142217022 | (37.761282068862, -122.496142217022) | |||
| 24548 | 24548 | 184805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984688.1718 | 2105711.6678 | 37.7609971073609 | -122.496092516316 | (37.7609971073609, -122.496092516316) | |||
| 168404 | 168404 | 184829 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984677.5396 | 2106895.0631 | 37.7642457559536 | -122.496216602354 | (37.7642457559536, -122.496216602354) | |||
| 59421 | 59421 | 184830 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984698.4242 | 2106894.3037 | 37.7642448941783 | -122.49614431351999 | (37.7642448941783, -122.49614431352) | |||
| 179837 | 179837 | 184835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984633.1125 | 2106875.3177 | 37.764188938163 | -122.496368803682 | (37.764188938163, -122.496368803682) | |||
| 172559 | 172559 | 184836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984671.8439 | 2106872.6597 | 37.7641839088875 | -122.496234648785 | (37.7641839088875, -122.496234648785) | |||
| 149798 | 149798 | 184837 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984687.4123 | 2106865.8247 | 37.764166053838395 | -122.496180298656 | (37.7641660538384, -122.496180298656) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");