Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67569 | 67569 | 23590 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3251X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
| 78992 | 78992 | 23589 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3251X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
| 115523 | 115523 | 23591 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 3251X Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.42585514440701 | (37.8066799978444, -122.425855144407) | |||
| 43976 | 43976 | 125010 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3798 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002028.21188 | 2121824.07702 | 37.8062380824907 | -122.437274704375 | (37.8062380824907, -122.437274704375) | |||
| 54719 | 54719 | 125009 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3798 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002030.9344 | 2121803.5229 | 37.80618180110871 | -122.43726380998501 | (37.8061818011087, -122.437263809985) | |||
| 74660 | 74660 | 125008 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3790 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002036.5769 | 2121760.24067 | 37.8060632803659 | -122.437241182151 | (37.8060632803659, -122.437241182151) | |||
| 63641 | 63641 | 125007 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3776 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002040.0357099995 | 2121740.15377 | 37.8060083236955 | -122.437227773241 | (37.8060083236955, -122.437227773241) | |||
| 178658 | 178658 | 125006 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3776 Fillmore St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6002042.338930001 | 2121722.74316 | 37.805960649714706 | -122.43721855518999 | (37.8059606497147, -122.43721855519) | |||
| 38599 | 38599 | 124849 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001917.78024 | 2121717.54489 | 37.8059392953167 | -122.437649236947 | (37.8059392953167, -122.437649236947) | |||
| 74534 | 74534 | 30341 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 10 | Permit Number 27 | 6001954.75028 | 2121707.36831 | 37.8059134550954 | -122.437520567314 | (37.8059134550954, -122.437520567314) | ||
| 159417 | 159417 | 124848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001909.64403 | 2121706.81926 | 37.8059093829805 | -122.43767662489999 | (37.8059093829805, -122.4376766249) | |||
| 73151 | 73151 | 125005 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3768 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002044.39034 | 2121704.85565 | 37.805911651977894 | -122.43721017441001 | (37.8059116519779, -122.43721017441) | |||
| 42804 | 42804 | 124847 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 170 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001902.65662 | 2121695.37415 | 37.8058775604571 | -122.437699985677 | (37.8058775604571, -122.437699985677) | |||
| 40274 | 40274 | 30342 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 27 | 6001955.9140099995 | 2121688.85818 | 37.8058626973628 | -122.437515213673 | (37.8058626973628, -122.437515213673) | |||
| 135393 | 135393 | 125004 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3768 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002047.18275 | 2121687.67631 | 37.8058646408085 | -122.437199280038 | (37.8058646408085, -122.437199280038) | |||
| 109922 | 109922 | 98759 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 143 - 147 RETIRO WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6001834.3 | 2121687.2 | 37.805851229478996 | -122.43793595800699 | (37.805851229479, -122.437935958007) | |||||
| 49926 | 49926 | 30343 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 27 | 6001958.2216300005 | 2121669.55401 | 37.8058098244409 | -122.437505844543 | (37.8058098244409, -122.437505844543) | |||
| 120219 | 120219 | 98758 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 141 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768795 | 6001830.6 | 2121663.0 | 37.8057845723141 | -122.437947027917 | (37.8057845723141, -122.437947027917) | |||
| 82409 | 82409 | 112489 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2690x Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | |||
| 110704 | 110704 | 112490 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2690x Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 3x3 | Permit Number 774532 | 6007377.71104 | 2121658.59908 | 37.8060863706979 | -122.418750060411 | (37.8060863706979, -122.418750060411) | ||
| 92059 | 92059 | 114841 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2670 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007398.0 | 2121652.0 | 37.8060693936166 | -122.41867937869499 | (37.8060693936166, -122.418679378695) | ||||
| 126014 | 126014 | 114842 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2670 LEAVENWORTH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007398.0 | 2121652.0 | 37.8060693936166 | -122.41867937869499 | (37.8060693936166, -122.418679378695) | ||||
| 85969 | 85969 | 86887 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 56 Casa Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49816 | 6001536.6 | 2121651.4 | 37.8057359986938 | -122.43896362504499 | (37.8057359986938, -122.438963625045) | ||||
| 130208 | 130208 | 30344 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3789 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 27 | 6001962.41405 | 2121647.90005 | 37.8057506067757 | -122.43748978443199 | (37.8057506067757, -122.437489784432) | |||
| 40183 | 40183 | 98789 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 133 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001814.61015 | 2121625.3182099997 | 37.805680198848 | -122.437999662255 | (37.805680198848, -122.437999662255) | |||
| 30470 | 30470 | 124982 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3851 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000554.818390001 | 2121621.59531 | 37.80559825440629 | -122.44235907463002 | (37.8055982544063, -122.44235907463) | |||
| 184506 | 184506 | 125020 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1430 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002377.05102 | 2121615.30854 | 37.805684683751394 | -122.43605254010001 | (37.8056846837514, -122.4360525401) | |||
| 35748 | 35748 | 124820 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 290 Cervantes Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6000687.14631 | 2121612.80249 | 37.805581652937896 | -122.44190050493 | (37.8055816529379, -122.44190050493) | |||
| 180845 | 180845 | 125021 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1430 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002357.9608 | 2121612.45473 | 37.8056757633955 | -122.436118400137 | (37.8056757633955, -122.436118400137) | |||
| 164029 | 164029 | 125022 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1432 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002347.6113599995 | 2121611.58572 | 37.8056727893385 | -122.43615415359501 | (37.8056727893385, -122.436154153595) | |||
| 116505 | 116505 | 105787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 67- 69 CASA WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 9x3 | Permit Number 773990 | 6001454.5 | 2121609.5 | 37.8056162809509 | -122.439244738513 | (37.8056162809509, -122.439244738513) | ||
| 131585 | 131585 | 125023 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1436 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002327.23032 | 2121607.6758 | 37.805660895788606 | -122.436224405044 | (37.8056608957886, -122.436224405044) | |||
| 31520 | 31520 | 125024 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1436 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002311.60856 | 2121606.01355 | 37.8056554441143 | -122.436278347281 | (37.8056554441143, -122.436278347281) | |||
| 135355 | 135355 | 124850 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 127 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001799.83316 | 2121605.38559 | 37.8056246288293 | -122.43804937137699 | (37.8056246288293, -122.438049371377) | |||
| 27740 | 27740 | 125025 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002295.97534 | 2121603.81012 | 37.8056485058273 | -122.43633229041401 | (37.8056485058273, -122.436332290414) | |||
| 25759 | 25759 | 125026 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1448 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002274.88822 | 2121600.81722 | 37.8056390899449 | -122.436405050972 | (37.8056390899449, -122.436405050972) | |||
| 74377 | 74377 | 125027 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1448 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002258.73025 | 2121599.5273599997 | 37.8056346302032 | -122.43646087547899 | (37.8056346302032, -122.436460875479) | |||
| 149153 | 149153 | 124821 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 290 Cervantes Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6000708.003409999 | 2121598.0387 | 37.8055423039982 | -122.44182726592399 | (37.8055423039982, -122.441827265924) | |||
| 161155 | 161155 | 125028 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1454 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002238.36811 | 2121596.51915 | 37.8056252134011 | -122.436531126017 | (37.8056252134011, -122.436531126017) | |||
| 97670 | 97670 | 49320 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 103801 | 103801 | 49319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 138561 | 138561 | 49321 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 595 Marina Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2003 12:00:00 AM | Permit Number 46320 | 6000116.71946789 | 2121594.09727993 | 37.805497772658704 | -122.443873196152 | (37.8054977726587, -122.443873196152) | |||
| 68589 | 68589 | 125029 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002224.173140001 | 2121593.7445900002 | 37.8056167885575 | -122.43658005093799 | (37.8056167885575, -122.436580050938) | |||
| 55630 | 55630 | 125030 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002217.628409999 | 2121592.79721 | 37.805613815388206 | -122.436602632017 | (37.8056138153882, -122.436602632017) | |||
| 175365 | 175365 | 125031 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1460 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002203.82941 | 2121591.6390299997 | 37.8056098511681 | -122.43665030238701 | (37.8056098511681, -122.436650302387) | |||
| 72551 | 72551 | 125032 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1490 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002182.39111 | 2121589.19488 | 37.8056019218535 | -122.43672431747801 | (37.8056019218535, -122.436724317478) | |||
| 72937 | 72937 | 124846 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 120 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001825.64723 | 2121584.78063 | 37.8055695210879 | -122.437958561455 | (37.8055695210879, -122.437958561455) | |||
| 69843 | 69843 | 124853 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Casa Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6001524.844 | 2121579.60518 | 37.805538200384795 | -122.43899915981001 | (37.8055382003848, -122.43899915981) | |||
| 32662 | 32662 | 124983 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3851 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000562.868369999 | 2121578.96302 | 37.8054816564034 | -122.442328154142 | (37.8054816564034, -122.442328154142) | |||
| 38928 | 38928 | 124845 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 120 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001817.73408 | 2121573.58628 | 37.805538334382206 | -122.43798514362301 | (37.8055383343822, -122.437985143623) | |||
| 24378 | 24378 | 124854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Casa Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6001534.02589 | 2121572.74926 | 37.8055198982766 | -122.438966893034 | (37.8055198982766, -122.438966893034) | |||
| 135323 | 135323 | 125041 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1431 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002357.419509999 | 2121568.78695 | 37.8055558324875 | -122.436117146515 | (37.8055558324875, -122.436117146515) | |||
| 29227 | 29227 | 125040 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1431 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002342.1489 | 2121566.576 | 37.805548894227705 | -122.43616983419099 | (37.8055488942277, -122.436169834191) | |||
| 77040 | 77040 | 124991 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 299 Cervantes Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000675.70773 | 2121565.63023 | 37.805451478768504 | -122.441936701718 | (37.8054514787685, -122.441936701718) | |||
| 66885 | 66885 | 125017 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 159 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 2ft | 6002727.1155900005 | 2121565.16212 | 37.8055668761666 | -122.434837503846 | (37.8055668761666, -122.434837503846) | |||
| 174897 | 174897 | 124844 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001807.9499 | 2121561.96756 | 37.8055058760609 | -122.438018170296 | (37.8055058760609, -122.438018170296) | |||
| 76946 | 76946 | 124822 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 290 Cervantes Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6000755.219269999 | 2121561.6527400003 | 37.8054450881704 | -122.44166125645901 | (37.8054450881704, -122.441661256459) | |||
| 68586 | 68586 | 125039 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1449 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002279.25009 | 2121557.5893900003 | 37.805520645627205 | -122.43638686036002 | (37.8055206456272, -122.43638686036) | |||
| 123301 | 123301 | 125038 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1455 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002263.62804 | 2121555.92749 | 37.805515194822895 | -122.436440803513 | (37.8055151948229, -122.436440803513) | |||
| 133414 | 133414 | 125037 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1455 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6002241.99373 | 2121552.76546 | 37.805505283393394 | -122.436515445436 | (37.8055052833934, -122.436515445436) | |||
| 68600 | 68600 | 125003 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3763 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001976.7392 | 2121552.51271 | 37.80548951290329 | -122.43743337535 | (37.8054895129033, -122.43743337535) | |||
| 170752 | 170752 | 124843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001801.68917 | 2121551.89814 | 37.8054778720718 | -122.438039114634 | (37.8054778720718, -122.438039114634) | |||
| 42612 | 42612 | 124992 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 299 Cervantes Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000700.1379 | 2121549.14085 | 37.8054075954408 | -122.441850973845 | (37.8054075954408, -122.441850973845) | |||
| 149141 | 149141 | 125036 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1461 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6002218.170530001 | 2121548.9265400004 | 37.8054933889687 | -122.43659761379999 | (37.8054933889687, -122.4365976138) | |||
| 137149 | 137149 | 125015 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 675 Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5999793.58079 | 2121546.81135 | 37.8053495010477 | -122.44498805644899 | (37.8053495010477, -122.444988056449) | |||
| 75643 | 75643 | 125035 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1467 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002202.71085 | 2121546.35864 | 37.8054854596596 | -122.436650930122 | (37.8054854596596, -122.436650930122) | |||
| 23674 | 23674 | 125034 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1467 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002193.9847099995 | 2121545.09547 | 37.8054814954333 | -122.436681037594 | (37.8054814954333, -122.436681037594) | |||
| 155720 | 155720 | 125033 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1499 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002182.69611 | 2121542.62172 | 37.8054740616425 | -122.436719926078 | (37.8054740616425, -122.436719926078) | |||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 47506 | 47506 | 124842 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001792.104119999 | 2121538.6526900004 | 37.8054409584916 | -122.43807133554199 | (37.8054409584916, -122.438071335542) | |||
| 71948 | 71948 | 125014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 691 Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999712.95085 | 2121535.70639 | 37.8053144077071 | -122.44526628691601 | (37.8053144077071, -122.445266286916) | |||
| 41594 | 41594 | 125013 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 691 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999680.43429 | 2121532.52371 | 37.8053038127916 | -122.44537858525699 | (37.8053038127916, -122.445378585257) | |||
| 69904 | 69904 | 125274 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007531.27909 | 2121531.59091 | 37.8057462837276 | -122.418209601296 | (37.8057462837276, -122.418209601296) | |||
| 32912 | 32912 | 124993 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 259 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000738.672069999 | 2121522.9779 | 37.8053379546353 | -122.44171574280001 | (37.8053379546353, -122.4417157428) | |||
| 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) | |||
| 155406 | 155406 | 124841 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001779.40776 | 2121521.29923 | 37.805392588455895 | -122.438114029041 | (37.8053925884559, -122.438114029041) | |||
| 156671 | 156671 | 124851 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Casa Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6001720.86764 | 2121511.30588 | 37.8053618199485 | -122.438315898058 | (37.8053618199485, -122.438315898058) | |||
| 122594 | 122594 | 104809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 685 Marina Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 770974 | 5999736.8 | 2121509.8 | 37.8052446370698 | -122.445181890463 | (37.8052446370698, -122.445181890463) | ||||
| 184426 | 184426 | 50822 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 240 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | 14 | Permit Number 47343 | 6000834.361830001 | 2121507.8753 | 37.8053019385925 | -122.441383512537 | (37.8053019385925, -122.441383512537) | ||
| 157344 | 157344 | 124852 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2 Casa Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6001698.45973 | 2121506.59633 | 37.805347614252 | -122.438393105776 | (37.805347614252, -122.438393105776) | |||
| 104780 | 104780 | 95658 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 499@Cervantes Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 126539 | 126539 | 95659 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 499@Cervantes Marina Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 149733 | 149733 | 124840 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001764.3271 | 2121501.21341 | 37.805336580468996 | -122.43816477778999 | (37.805336580469, -122.43816477779) | |||
| 183150 | 183150 | 124994 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 251 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000770.740809999 | 2121498.43749 | 37.8052724003766 | -122.441603002893 | (37.8052724003766, -122.441603002893) | |||
| 162547 | 162547 | 124976 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999589.16481 | 2121495.98811 | 37.8051982854271 | -122.44569180475 | (37.8051982854271, -122.44569180475) | |||
| 162155 | 162155 | 124814 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3766 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999635.682030001 | 2121493.77888 | 37.8051948752069 | -122.44553066781499 | (37.8051948752069, -122.445530667815) | |||
| 48939 | 48939 | 124839 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001764.30069 | 2121488.69691 | 37.8053022119874 | -122.43816397199801 | (37.8053022119874, -122.438163971998) | |||
| 158420 | 158420 | 124824 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000864.5368099995 | 2121488.01218 | 37.805249118725 | -122.44127766236099 | (37.805249118725, -122.441277662361) | |||
| 65509 | 65509 | 124995 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 251 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000785.78079 | 2121487.92009 | 37.8052443792868 | -122.441550200077 | (37.8052443792868, -122.441550200077) | |||
| 72918 | 72918 | 125018 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 137 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 2ft | 6002823.9951 | 2121486.12437 | 37.8053553592351 | -122.43449658436899 | (37.8053553592351, -122.434496584369) | |||
| 96746 | 96746 | 27434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2015 12:00:00 AM | 70 | 3X3 | 6007539.61625 | 2121483.94928 | 37.8056159411906 | -122.41817736946899 | (37.8056159411906, -122.418177369469) | ||
| 111520 | 111520 | 27435 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2015 12:00:00 AM | 15 | 3X3 | 6007539.61625 | 2121483.94928 | 37.8056159411906 | -122.41817736946899 | (37.8056159411906, -122.418177369469) | ||
| 169164 | 169164 | 52614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 230@ AVILA Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 10 | Permit Number 48779 | 6000874.42374 | 2121481.75095 | 37.8052324902599 | -122.441242997973 | (37.8052324902599, -122.441242997973) | ||
| 76657 | 76657 | 124977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3751 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999590.283530001 | 2121474.4775799997 | 37.8051392872022 | -122.445686385433 | (37.8051392872022, -122.445686385433) | |||
| 44586 | 44586 | 125019 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 135 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6002839.24225 | 2121472.8453599997 | 37.8053197640715 | -122.43444286966499 | (37.8053197640715, -122.434442869665) | |||
| 158085 | 158085 | 125046 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3101 Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005409.570309999 | 2121471.02637 | 37.8054603352986 | -122.42554778230101 | (37.8054603352986, -122.425547782301) | |||
| 52518 | 52518 | 124815 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3766 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999638.74415 | 2121468.4947 | 37.8051256264981 | -122.44551825176 | (37.8051256264981, -122.44551825176) | |||
| 188772 | 188772 | 125012 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 799 Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999213.87978 | 2121467.47063 | 37.8050985506219 | -122.44698846615499 | (37.8050985506219, -122.446988466155) | |||
| 135254 | 135254 | 117640 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3839 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000083.60438 | 2121466.9257 | 37.8051467048289 | -122.443978652001 | (37.8051467048289, -122.443978652001) | |||
| 64981 | 64981 | 124838 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 80 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6001766.13786 | 2121465.01579 | 37.8052372944152 | -122.43815591678499 | (37.8052372944152, -122.438155916785) |
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");