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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1500 | 1500 | 251574 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 191 Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999731.0 | 2100707.0 | 37.748125134697 | -122.443706547761 | (37.748125134697, -122.443706547761) | ||||
| 3903 | 3903 | 220233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.764381073148705 | -122.44607010996201 | (37.7643810731487, -122.446070109962) | |
| 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) | |||
| 26833 | 26833 | 203845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 535 Castenada Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5992715.17465 | 2100010.79955 | 37.7458108948644 | -122.46791618659901 | (37.7458108948644, -122.467916186599) | |||
| 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) | |||
| 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) | |||
| 30922 | 30922 | 203824 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 270 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5996325.39401 | 2095129.7454900001 | 37.732616529229 | -122.455079988546 | (37.732616529229, -122.455079988546) | ||||
| 31408 | 31408 | 203263 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 555 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5998982.59425 | 2097232.94199 | 37.7385434931839 | -122.44604465732999 | (37.7385434931839, -122.44604465733) | |||
| 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) | |||
| 33643 | 33643 | 203257 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 160 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5995507.02716 | 2095606.7609400002 | 37.733879314068 | -122.45794377168801 | (37.733879314068, -122.457943771688) | |||
| 33947 | 33947 | 203279 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 59 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999700.96572 | 2095477.61898 | 37.7337647863229 | -122.44343483107001 | (37.7337647863229, -122.44343483107) | |||
| 35594 | 35594 | 203246 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 401 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995758.26971 | 2095116.97612 | 37.73254891550229 | -122.45703973988998 | (37.7325489155023, -122.45703973989) | |||
| 36188 | 36188 | 201372 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 57 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6018490.42115 | 2095382.8253 | 37.734558123266204 | -122.378466804612 | (37.7345581232662, -122.378466804612) | ||||
| 36444 | 36444 | 203260 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 31 Sequoia Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5998240.18934 | 2097553.89046 | 37.7393823178446 | -122.448634634681 | (37.7393823178446, -122.448634634681) | |||
| 38353 | 38353 | 203250 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 300 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 3ft | 5996036.57677 | 2095207.69208 | 37.732813978082596 | -122.456084127481 | (37.7328139780826, -122.456084127481) | |||
| 40838 | 40838 | 203283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 436 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 7ft | 5999191.65926 | 2095001.09495 | 37.7324273055688 | -122.445161400772 | (37.7324273055688, -122.445161400772) | |||
| 41085 | 41085 | 203835 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5995906.667880001 | 2095303.7074 | 37.733070155351896 | -122.456540193489 | (37.7330701553519, -122.456540193489) | |||
| 41625 | 41625 | 203836 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 386 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5995958.60933 | 2095699.73792 | 37.7341605410715 | -122.456389245893 | (37.7341605410715, -122.456389245893) | |||
| 42911 | 42911 | 203833 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 470 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 10ft | 5995548.29749 | 2095369.378 | 37.7332298893389 | -122.457783917193 | (37.7332298893389, -122.457783917193) | |||
| 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) | |||
| 43833 | 43833 | 203890 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 175 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5991011.74416 | 2094657.21816 | 37.7310128131914 | -122.473415935702 | (37.7310128131914, -122.473415935702) | |||
| 47185 | 47185 | 203258 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 80 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996117.24825 | 2095689.22308 | 37.7341407757719 | -122.45584002452 | (37.7341407757719, -122.45584002452) | |||
| 49471 | 49471 | 201375 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Fairfax Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6018327.36542 | 2095666.8943900003 | 37.7353291318294 | -122.379050271262 | (37.7353291318294, -122.379050271262) | ||||
| 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) | |||
| 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) | |||
| 54451 | 54451 | 203994 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 30 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 3ft | 5995717.02889 | 2094139.1158599998 | 37.7298615793487 | -122.457111609219 | (37.7298615793487, -122.457111609219) | |||
| 56931 | 56931 | 188677 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Evans Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6018476.48235 | 2096364.95743 | 37.7372540964924 | -122.37858316699499 | (37.7372540964924, -122.378583166995) | |||
| 57772 | 57772 | 203779 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 788 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 10ft | 5994915.16771 | 2093240.5378299998 | 37.7273482188287 | -122.459818653129 | (37.7273482188287, -122.459818653129) | |||
| 59373 | 59373 | 203886 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 179 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 2ft | 5990904.52602 | 2094659.81663 | 37.7310137385845 | -122.473786792727 | (37.7310137385845, -122.473786792727) | |||
| 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) | |||
| 60749 | 60749 | 203244 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1648 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5995594.77464 | 2094937.0957099998 | 37.7320456171101 | -122.457591967706 | (37.7320456171101, -122.457591967706) | |||
| 61405 | 61405 | 203902 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5002 19th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5990623.0724599995 | 2093226.54081 | 37.7270620185855 | -122.474655248248 | (37.7270620185855, -122.474655248248) | |||
| 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) | |||
| 63033 | 63033 | 203822 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 210 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5996371.78556 | 2094806.57712 | 37.731731848127 | -122.454896260653 | (37.731731848127, -122.454896260653) | ||||
| 63519 | 63519 | 187749 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1020 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | 6018386.6897599995 | 2093315.1959 | 37.7288750976933 | -122.378681918831 | (37.7288750976933, -122.378681918831) | ||||
| 65584 | 65584 | 203255 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 174 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5995391.75074 | 2095632.23775 | 37.7339426434291 | -122.458344157955 | (37.7339426434291, -122.458344157955) | |||
| 65888 | 65888 | 203254 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 355 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5996025.0602 | 2095489.12153 | 37.7335860541429 | -122.45614428315399 | (37.7335860541429, -122.456144283154) | |||
| 68310 | 68310 | 188608 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2370 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 6011669.87256 | 2099790.80879 | 37.7462831864145 | -122.402357690473 | (37.7462831864145, -122.402357690473) | |||
| 68992 | 68992 | 203874 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 200 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 5993391.13026 | 2089210.0639099998 | 37.716193751229895 | -122.464794638879 | (37.7161937512299, -122.464794638879) | |||
| 70829 | 70829 | 187762 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Reardon Rd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6018971.39793 | 2093438.5075400001 | 37.72924590436129 | -122.37666906882099 | (37.7292459043613, -122.376669068821) | ||||
| 71168 | 71168 | 203834 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 480 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5995517.77051 | 2095412.33774 | 37.7333460925362 | -122.457892564287 | (37.7333460925362, -122.457892564287) | |||
| 71240 | 71240 | 203888 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 177 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5990956.3868 | 2094658.3857 | 37.7310128131833 | -122.47360739868401 | (37.7310128131833, -122.473607398684) | |||
| 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) | |||
| 94139 | 94139 | 203245 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1616 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5995624.1934 | 2094726.8398099998 | 37.7314699952415 | -122.45747505495599 | (37.7314699952415, -122.457475054956) | |||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | ||||
| 119112 | 119112 | 203252 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 341 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5996075.27063 | 2095441.53755 | 37.733458282063495 | -122.455967253399 | (37.7334582820635, -122.455967253399) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 137370 | 137370 | 203832 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1625 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 5995572.09683 | 2094748.54485 | 37.731526599451 | -122.45765673147498 | (37.731526599451, -122.457656731475) | |||
| 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) | |||
| 150308 | 150308 | 203780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Northwood Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 5995711.8389800005 | 2094094.29693 | 37.72973821932529 | -122.457126310455 | (37.7297382193253, -122.457126310455) | |||
| 150624 | 150624 | 203821 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 280 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5996076.68769 | 2095086.62042 | 37.732483846838704 | -122.455936705234 | (37.7324838468387, -122.455936705234) | ||||
| 152819 | 152819 | 203248 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 489 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 5995426.51291 | 2095536.7894 | 37.7336825630925 | -122.45821706938801 | (37.7336825630925, -122.458217069388) | |||
| 153047 | 153047 | 204001 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 478 Warren Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5994224.85636 | 2104697.7009400004 | 37.758766993212205 | -122.46303595885901 | (37.7587669932122, -122.463035958859) | |||
| 153194 | 153194 | 203819 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 224 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5996114.34243 | 2094848.95185 | 37.731833427466505 | -122.455789350407 | (37.7318334274665, -122.455789350407) | ||||
| 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) | |||
| 156300 | 156300 | 203883 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 181 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 5990856.8356099995 | 2094661.5261900001 | 37.7310156703238 | -122.47395178956499 | (37.7310156703238, -122.473951789565) | |||
| 161915 | 161915 | 186927 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2800 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985227.187999999 | 2095919.2321 | 37.7341413011385 | -122.49350678654801 | (37.7341413011385, -122.493506786548) | |||
| 163176 | 163176 | 188599 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012848.11967 | 2102532.63168 | 37.753877345082 | -122.398475784828 | (37.753877345082, -122.398475784828) | ||||
| 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) | |||
| 164954 | 164954 | 203259 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 76 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996134.27449 | 2095680.6301099998 | 37.7341181587163 | -122.45578053885299 | (37.7341181587163, -122.455780538853) | |||
| 165938 | 165938 | 203256 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 166 Brentwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995465.02335 | 2095623.45541 | 37.733922739644704 | -122.45809019842599 | (37.7339227396447, -122.458090198426) | |||
| 166553 | 166553 | 203820 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 270 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5996086.90151 | 2095051.7062799998 | 37.7323885672656 | -122.455898870764 | (37.7323885672656, -122.455898870764) | ||||
| 167201 | 167201 | 203823 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 830 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996652.151769999 | 2095040.8837700002 | 37.7323912769404 | -122.453943898404 | (37.7323912769404, -122.453943898404) | ||||
| 167330 | 167330 | 203251 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 325 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5996145.80279 | 2095391.0534400002 | 37.7333237129166 | -122.45571975726101 | (37.7333237129166, -122.455719757261) | |||
| 167981 | 167981 | 203241 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1670 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995502.95933 | 2095101.70032 | 37.7324923067699 | -122.45792129854999 | (37.7324923067699, -122.45792129855) | |||
| 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) | |||
| 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) | |||
| 170654 | 170654 | 203891 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 173 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 5991044.7899 | 2094655.1338099998 | 37.7310090036421 | -122.473301540158 | (37.7310090036421, -122.473301540158) | |||
| 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) | ||||
| 172574 | 172574 | 203242 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1660 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995530.96911 | 2095074.5537299998 | 37.7324193780388 | -122.457822499013 | (37.7324193780388, -122.457822499013) | |||
| 174713 | 174713 | 203261 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 506 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5997991.23111 | 2097614.06115 | 37.7395332933219 | -122.44949975281 | (37.7395332933219, -122.44949975281) | |||
| 175520 | 175520 | 203853 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 366 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5997667.53367 | 2093836.2933 | 37.729141923854705 | -122.450346700167 | (37.7291419238547, -122.450346700167) | ||||
| 175550 | 175550 | 203249 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 380 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5995787.9894199995 | 2095468.33628 | 37.7335153719345 | -122.456962397309 | (37.7335153719345, -122.456962397309) | |||
| 177089 | 177089 | 203247 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 435 Colon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 3ft | 5995610.12397 | 2095259.68006 | 37.732932237139 | -122.457562233408 | (37.732932237139, -122.457562233408) | |||
| 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) | |||
| 181079 | 181079 | 220260 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 429 Grand View Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6000142.26026 | 2102104.10765 | 37.7519847029517 | -122.442384714309 | (37.7519847029517, -122.442384714309) | ||||
| 182232 | 182232 | 203262 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 512 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5997988.38195 | 2097644.1119 | 37.7396156424485 | -122.449511768663 | (37.7396156424485, -122.449511768663) | |||
| 182589 | 182589 | 203277 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 49 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6000409.79101 | 2095470.0707200002 | 37.7337844580708 | -122.440983676666 | (37.7337844580708, -122.440983676666) | ||||
| 182873 | 182873 | 203282 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 710 Congo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 6000203.28211 | 2096042.4957700002 | 37.735344439181105 | -122.44173870518499 | (37.7353444391811, -122.441738705185) | |||
| 183085 | 183085 | 203851 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 451 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 10ft | 5998148.5387 | 2094357.8892299999 | 37.7306016197611 | -122.448721386881 | (37.7306016197611, -122.448721386881) | |||
| 187675 | 187675 | 203253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 345 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996049.39925 | 2095464.3554200002 | 37.7335194494626 | -122.45605834663401 | (37.7335194494626, -122.456058346634) | |||
| 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) | |||
| 24500 | 24500 | 203904 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 5000 19th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 5990628.04185 | 2093305.0064 | 37.7272777533559 | -122.47464379357001 | (37.7272777533559, -122.47464379357) | |||
| 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) | |||
| 26973 | 26973 | 188567 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 500 24th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6016949.54535 | 2102644.83882 | 37.7544130748234 | -122.384299775913 | (37.7544130748234, -122.384299775913) | ||||
| 29742 | 29742 | 203269 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 61 Burnside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001195.67234 | 2095721.17604 | 37.7345186646045 | -122.438284639447 | (37.7345186646045, -122.438284639447) | ||||
| 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) | |||
| 33152 | 33152 | 187750 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1000 Oakdale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6018189.80767 | 2093163.42935 | 37.728447520437705 | -122.379352023493 | (37.7284475204377, -122.379352023493) | ||||
| 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) | ||||
| 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) |
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");