Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1188 | 1188 | 251477 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1590 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999686.0 | 2114300.0 | 37.785445538345996 | -122.444839109459 | (37.785445538346, -122.444839109459) | ||||
| 3410 | 3410 | 55823 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 9 | Permit Number 11871 | 5992391.10091 | 2114722.33212 | 37.7861861336889 | -122.470107824331 | (37.7861861336889, -122.470107824331) | ||
| 3467 | 3467 | 123897 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992391.187940001 | 2114716.46428 | 37.7861700272505 | -122.47010709580299 | (37.7861700272505, -122.470107095803) | |||
| 7914 | 7914 | 20395 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 262X Sunset Blvd | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10558 | 10558 | 919 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 1249 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 10:57:00 AM | 3 | 3X3 | 6002980.09082 | 2094114.94313 | 37.730209644839896 | -122.432000656304 | (37.7302096448399, -122.432000656304) | ||
| 13893 | 13893 | 26015 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1638 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1997 12:00:00 AM | 3 | 3X3 | 6014725.62148 | 2095748.6278099997 | 37.7353543002582 | -122.391508646128 | (37.7353543002582, -122.391508646128) | ||
| 21025 | 21025 | 28135 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 412 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X4 | 6006927.15214 | 2097902.80661 | 37.740833262445996 | -122.418623621291 | (37.740833262446, -122.418623621291) | |||
| 25008 | 25008 | 233964 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998642.1251 | 2106932.6031299997 | 37.7651569326801 | -122.44791997764798 | (37.7651569326801, -122.447919977648) | |||
| 26376 | 26376 | 233965 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998630.023569999 | 2106931.63106 | 37.765153571896896 | -122.44796176374099 | (37.7651535718969, -122.447961763741) | |||
| 27575 | 27575 | 52011 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 427 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 48229 | 5984051.86025 | 2112939.27176 | 37.7808047486161 | -122.498827177749 | (37.7808047486161, -122.498827177749) | |||
| 31835 | 31835 | 120792 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 547 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5989370.9651 | 2111615.14329 | 37.777479605996795 | -122.48032907033001 | (37.7774796059968, -122.48032907033) | |||
| 32365 | 32365 | 233960 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 329 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009458.35232 | 2099567.9895200003 | 37.7455476723052 | -122.409989165578 | (37.7455476723052, -122.409989165578) | |||
| 33012 | 33012 | 211434 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 910 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5992028.493840001 | 2105269.75757 | 37.760210948307794 | -122.47067358802299 | (37.7602109483078, -122.470673588023) | |||
| 44513 | 44513 | 233959 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 101 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005908.695780001 | 2106579.49211 | 37.7646000472828 | -122.422761537821 | (37.7646000472828, -122.422761537821) | |||
| 48017 | 48017 | 178395 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 61 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003678.4559 | 2093041.21797 | 37.727301003537505 | -122.429509772582 | (37.7273010035375, -122.429509772582) | |||
| 48727 | 48727 | 30819 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 4 | Permit Number 34679 | 6001850.40599 | 2095237.97524 | 37.733229124016496 | -122.435986447137 | (37.7332291240165, -122.435986447137) | ||
| 57273 | 57273 | 233963 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5998658.62775 | 2106938.30224 | 37.7651735242683 | -122.447863309551 | (37.7651735242683, -122.447863309551) | |||
| 57438 | 57438 | 62163 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 80 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 11 | Permit Number 22278 | 6000618.37391 | 2092117.41472 | 37.724590715777396 | -122.440022226756 | (37.7245907157774, -122.440022226756) | |
| 62454 | 62454 | 233971 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 175 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999325.700119999 | 2106527.04149 | 37.7640824109973 | -122.44552650036002 | (37.7640824109973, -122.44552650036) | |||
| 66180 | 66180 | 211450 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 186 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994246.46565 | 2099200.24413 | 37.7436736209515 | -122.462562455004 | (37.7436736209515, -122.462562455004) | |||
| 66218 | 66218 | 233975 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3786 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001886.12679 | 2106432.54375 | 37.76396878345871 | -122.43666398285299 | (37.7639687834587, -122.436663982853) | |||
| 72992 | 72992 | 233966 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998617.81903 | 2106930.99425 | 37.765151125749995 | -122.448003930257 | (37.76515112575, -122.448003930257) | |||
| 77181 | 77181 | 132389 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005789.48501 | 2119659.27806 | 37.8005071977157 | -122.42410410961901 | (37.8005071977157, -122.424104109619) | |||
| 77572 | 77572 | 81877 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1380 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773644 | 5992433.71699481 | 2106077.08224854 | 37.7624510738005 | -122.46933088918699 | (37.7624510738005, -122.469330889187) |
| 94154 | 94154 | 9335 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 179 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000859.3677258 | 2098666.8406913998 | 37.742587635250004 | -122.439658461234 | (37.74258763525, -122.439658461234) | |||
| 98282 | 98282 | 2776 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 5994564.223130001 | 2110735.25562 | 37.775364081338 | -122.462300169147 | (37.775364081338, -122.462300169147) | |||
| 100796 | 100796 | 64213 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1625 Carroll Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1988 12:00:00 AM | 5 | Permit Number 25004 | 6013920.481000001 | 2092092.5018 | 37.7252706002708 | -122.39403647132099 | (37.7252706002708, -122.394036471321) | ||
| 130991 | 130991 | 211451 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001863.37782 | 2095280.7937599998 | 37.7333474307441 | -122.435944662819 | (37.7333474307441, -122.435944662819) | |||
| 135796 | 135796 | 233974 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002049.59534 | 2107034.31873 | 37.7656303987394 | -122.436141661111 | (37.7656303987394, -122.436141661111) | |||
| 136421 | 136421 | 211445 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000197.7982 | 2096452.6133 | 37.736470213222 | -122.441787089628 | (37.736470213222, -122.441787089628) | |||
| 138989 | 138989 | 211449 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1554 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993091.38036 | 2104901.42473 | 37.759261008817 | -122.466970818352 | (37.759261008817, -122.466970818352) | |||
| 147932 | 147932 | 233969 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998431.96444 | 2106860.6202700003 | 37.7649472710115 | -122.448641684483 | (37.7649472710115, -122.448641684483) | |||
| 147937 | 147937 | 30820 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 7 | Permit Number 34679 | 6001842.2487 | 2095205.8891900002 | 37.7331405596841 | -122.43601235390601 | (37.7331405596841, -122.436012353906) | ||
| 154786 | 154786 | 211435 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 29 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992967.24158 | 2098952.48262 | 37.742919578079096 | -122.466967656341 | (37.7429195780791, -122.466967656341) | |||
| 160987 | 160987 | 132361 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3455 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998256.938519999 | 2115827.3267200002 | 37.7895575156245 | -122.449893326728 | (37.7895575156245, -122.449893326728) | |||
| 167782 | 167782 | 233962 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 341 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003741.086630001 | 2098630.21283 | 37.7426506619089 | -122.429691709917 | (37.7426506619089, -122.429691709917) | |||
| 170091 | 170091 | 200714 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1494 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015811.8614 | 2095290.2381 | 37.7341558860556 | -122.38772110560801 | (37.7341558860556, -122.387721105608) | |||
| 170256 | 170256 | 211446 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000201.81389 | 2096459.5971 | 37.736489617908504 | -122.441773706798 | (37.7364896179085, -122.441773706798) | |||
| 170663 | 170663 | 178394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 25 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001248.99944 | 2093921.6644099997 | 37.7295806536223 | -122.437971416359 | (37.7295806536223, -122.437971416359) | |||
| 174727 | 174727 | 120791 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 539 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989368.66682 | 2111666.19394 | 37.7776196433358 | -122.48034075829901 | (37.7776196433358, -122.480340758299) | |||
| 176305 | 176305 | 123898 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992390.460969999 | 2114751.88478 | 37.786267240143204 | -122.47011219103901 | (37.7862672401432, -122.470112191039) | |||
| 177634 | 177634 | 132387 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005806.0966 | 2119662.42569 | 37.8005167781868 | -122.424046850703 | (37.8005167781868, -122.424046850703) | |||
| 177814 | 177814 | 233970 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998449.53316 | 2106863.1940099997 | 37.7649553424266 | -122.448581104347 | (37.7649553424266, -122.448581104347) | |||
| 179351 | 179351 | 211452 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001868.44075 | 2095314.06759 | 37.7334390806456 | -122.435929538915 | (37.7334390806456, -122.435929538915) | |||
| 179438 | 179438 | 123101 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 507 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992491.93935 | 2111979.1338299997 | 37.7786598912114 | -122.469559186337 | (37.7786598912114, -122.469559186337) | |||
| 179658 | 179658 | 211444 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 230 Terrace Walk | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993933.81499 | 2096496.4597200002 | 37.7362316941337 | -122.46344734382299 | (37.7362316941337, -122.463447343823) | |||
| 180280 | 180280 | 132362 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3455 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998243.11414 | 2115825.0285900002 | 37.7895504145686 | -122.449940991703 | (37.7895504145686, -122.449940991703) | |||
| 182363 | 182363 | 178396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 55 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003704.97004 | 2093083.05909 | 37.7274173910959 | -122.42942109582899 | (37.7274173910959, -122.429421095829) | |||
| 182684 | 182684 | 233967 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 26 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5998528.05079 | 2106918.36073 | 37.765111305559294 | -122.448313505688 | (37.7651113055593, -122.448313505688) | |||
| 183127 | 183127 | 132384 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6005841.24215 | 2119667.51872 | 37.80053274655629 | -122.4239255951 | (37.8005327465563, -122.4239255951) | |||
| 185008 | 185008 | 233968 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998414.25263 | 2106859.15364 | 37.7649422312277 | -122.448702839263 | (37.7649422312277, -122.448702839263) | |||
| 26572 | 26572 | 132381 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6008727.871259999 | 2118754.69526 | 37.7981889019448 | -122.413872046978 | (37.7981889019448, -122.413872046978) | |||
| 30813 | 30813 | 233972 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 242 Upper Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5999499.278059999 | 2106191.4803400002 | 37.7631709516944 | -122.444902023732 | (37.7631709516944, -122.444902023732) | |||
| 45134 | 45134 | 132383 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008731.67478 | 2118716.1773200002 | 37.7980833548266 | -122.41385615953301 | (37.7980833548266, -122.413856159533) | |||
| 55400 | 55400 | 247548 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 815 Buena Vista Ave West | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 6000113.779519999 | 2108396.7627 | 37.7692611579062 | -122.44293504992399 | (37.7692611579062, -122.442935049924) | |||
| 56246 | 56246 | 123354 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 706 04th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5994755.71822 | 2110691.45516 | 37.7752548415612 | -122.46163457142099 | (37.7752548415612, -122.461634571421) | |||
| 115488 | 115488 | 233973 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 242 Upper Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5999494.677630001 | 2106185.26835 | 37.7631536325665 | -122.44491748844901 | (37.7631536325665, -122.444917488449) | |||
| 132382 | 132382 | 132365 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Dicha Aly | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5998327.23711 | 2113735.99188 | 37.7838192833694 | -122.449499349909 | (37.7838192833694, -122.449499349909) | |||
| 157645 | 157645 | 233961 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 Valley St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6005126.403519999 | 2099291.88165 | 37.744545799654006 | -122.424948746605 | (37.744545799654, -122.424948746605) | |||
| 159996 | 159996 | 194590 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 13 Bridgeview Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6016094.38858 | 2108337.40723 | 37.7699963267064 | -122.387654295729 | (37.7699963267064, -122.387654295729) | |||
| 162959 | 162959 | 132382 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.798142406100396 | -122.413870282493 | (37.7981424061004, -122.413870282493) | |||
| 172452 | 172452 | 132380 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1680 Taylor St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6008764.121730001 | 2118820.69014 | 37.7983721433051 | -122.4137512797 | (37.7983721433051, -122.4137512797) | |||
| 176993 | 176993 | 132379 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1680 Taylor St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6008770.01559 | 2118776.57909 | 37.7982513562644 | -122.41372776333401 | (37.7982513562644, -122.413727763334) | |||
| 184440 | 184440 | 247639 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 360 Bradford St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6009456.29127 | 2096556.43991 | 37.7372784977969 | -122.409783755028 | (37.7372784977969, -122.409783755028) | |||
| 48906 | 48906 | 211441 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993812.00301 | 2096546.48985 | 37.7363620454614 | -122.463872125093 | (37.7363620454614, -122.463872125093) | ||||
| 74152 | 74152 | 211439 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5993818.11195 | 2096542.33136 | 37.7363509793232 | -122.46385070234699 | (37.7363509793232, -122.463850702347) | ||||
| 74625 | 74625 | 211440 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5993816.62133 | 2096536.73465 | 37.736335526247295 | -122.463855449888 | (37.7363355262473, -122.463855449888) | ||||
| 137876 | 137876 | 211442 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5993811.3668 | 2096539.9849900003 | 37.736344148068106 | -122.463873852703 | (37.7363441480681, -122.463873852703) | ||||
| 151839 | 151839 | 211443 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993804.85557 | 2096543.20667 | 37.7363526187711 | -122.46389659834601 | (37.7363526187711, -122.463896598346) | ||||
| 162232 | 162232 | 211438 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993827.4148 | 2096523.2728799998 | 37.736299185562004 | -122.463817155848 | (37.736299185562, -122.463817155848) | ||||
| 164737 | 164737 | 211437 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993819.380340001 | 2096502.3277900002 | 37.736241212547796 | -122.463843414267 | (37.7362412125478, -122.463843414267) | ||||
| 31489 | 31489 | 194588 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1998 Revere Ave | 9 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6013005.4518800005 | 2095968.5066900002 | 37.7358624145277 | -122.397471367135 | (37.7358624145277, -122.397471367135) | |||
| 44666 | 44666 | 211448 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 4140 19th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992076.26551 | 2088333.24605 | 37.7137103255345 | -122.46927561890101 | (37.7137103255345, -122.469275618901) | |||
| 160795 | 160795 | 211447 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 4140 19th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5992076.98829 | 2088316.96105 | 37.7136656526261 | -122.46927193614599 | (37.7136656526261, -122.469271936146) | |||
| 740 | 740 | 26411 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996554.84409 | 2116119.62648 | 37.7902625562289 | -122.45580349675699 | (37.7902625562289, -122.455803496757) | |||
| 4530 | 4530 | 26410 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996557.377619999 | 2116117.2149400003 | 37.790256080189295 | -122.455794556583 | (37.7902560801893, -122.455794556583) | |||
| 7571 | 7571 | 26412 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996536.01908 | 2116115.1957 | 37.7902493101054 | -122.455868309095 | (37.7902493101054, -122.455868309095) | |||
| 8270 | 8270 | 26409 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 34 Maple St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996561.54746 | 2116120.98746 | 37.790266677821 | -122.45578040214599 | (37.790266677821, -122.455780402146) | |||
| 1686 | 1686 | 251474 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
| 1694 | 1694 | 251475 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
| 1712 | 1712 | 251473 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
| 33032 | 33032 | 247630 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009492.89578 | 2096949.07994 | 37.738358653736206 | -122.409684901541 | (37.7383586537362, -122.409684901541) | ||||
| 40834 | 40834 | 247628 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6009493.85882 | 2096962.27736 | 37.738394944962394 | -122.409682503062 | (37.7383949449624, -122.409682503062) | ||||
| 41441 | 41441 | 247627 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6009494.8200900005 | 2096968.4162599999 | 37.7384118549208 | -122.40967961262699 | (37.7384118549208, -122.409679612627) | ||||
| 52897 | 52897 | 132364 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Maple St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5996506.6886 | 2116107.7681400003 | 37.7902272326358 | -122.455969252601 | (37.7902272326358, -122.455969252601) | ||||
| 57300 | 57300 | 132363 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Maple St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 5996514.49254 | 2116105.13934 | 37.7902204625654 | -122.455942061589 | (37.7902204625654, -122.455942061589) | ||||
| 74523 | 74523 | 194587 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 37 Maddux Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 9ft | 6012781.54528 | 2095521.68187 | 37.7346230570026 | -122.398214166653 | (37.7346230570026, -122.398214166653) | |||
| 97714 | 97714 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 110 | 273 Magellan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 155600 | 155600 | 247629 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6009493.3855 | 2096955.4623099999 | 37.738376205786096 | -122.409683658684 | (37.7383762057861, -122.409683658684) | ||||
| 174774 | 174774 | 247626 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6009494.96271 | 2096975.4044400002 | 37.7384310509429 | -122.40967961262501 | (37.7384310509429, -122.409679612625) | ||||
| 30321 | 30321 | 132368 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999060.82328 | 2119520.3698400003 | 37.7997435923452 | -122.44737790226999 | (37.7997435923452, -122.44737790227) | |||
| 31583 | 31583 | 132369 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999059.80174 | 2119527.5303700003 | 37.7997631948618 | -122.44738195283199 | (37.7997631948618, -122.447381952832) | |||
| 32833 | 32833 | 132402 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 93 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6008127.0764 | 2119094.13477 | 37.7990871592098 | -122.41597503153 | (37.7990871592098, -122.41597503153) | ||||
| 33137 | 33137 | 132366 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3100 Lyon St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999060.873319999 | 2119508.71315 | 37.7997115890667 | -122.44737688965 | (37.7997115890667, -122.44737688965) | |||
| 36060 | 36060 | 132385 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005829.912880001 | 2119675.1182 | 37.8005529731893 | -122.423965339721 | (37.8005529731893, -122.423965339721) | |||
| 37209 | 37209 | 178397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 127 Athens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6004928.6124599995 | 2092474.3613599997 | 37.7258152443728 | -122.42514766493 | (37.7258152443728, -122.42514766493) | ||||
| 41431 | 41431 | 132390 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005781.1261599995 | 2119669.33652 | 37.8005343437344 | -122.42413375038099 | (37.8005343437344, -122.424133750381) | |||
| 46330 | 46330 | 178393 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 73 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6001400.33163 | 2093764.0907400001 | 37.729156597198795 | -122.437436967259 | (37.7291565971988, -122.437436967259) | ||||
| 46631 | 46631 | 132401 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2745 Larkin St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6006539.0247599995 | 2120646.9147799998 | 37.8032612878284 | -122.421580578682 | (37.8032612878284, -122.421580578682) | ||||
| 46960 | 46960 | 132377 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008207.47508 | 2117062.00893 | 37.793511965045205 | -122.415552871766 | (37.7935119650452, -122.415552871766) |
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");