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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||
| 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) | |||
| 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) | |||
| 62614 | 62614 | 178399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 339 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6004188.88481 | 2091298.12563 | 37.7225437445683 | -122.42762108566002 | (37.7225437445683, -122.42762108566) | |||
| 185912 | 185912 | 178400 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 802 Excelsior Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6004451.61665 | 2091406.41613 | 37.7228559442383 | -122.426720588195 | (37.7228559442383, -122.426720588195) | |||
| 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) | ||
| 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) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 54754 | 54754 | 178398 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 300 Gaven St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6008862.12496 | 2094845.7594299999 | 37.732548023354504 | -122.41171723086501 | (37.7325480233545, -122.411717230865) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 166409 | 166409 | 187083 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2600 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985170.5104 | 2097012.8962 | 37.7371408955553 | -122.49378330233499 | (37.7371408955553, -122.493783302335) | |||
| 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) | |||
| 54276 | 54276 | 194583 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015441.64874 | 2098018.63828 | 37.7416270022859 | -122.38919150780899 | (37.7416270022859, -122.389191507809) | |||
| 155644 | 155644 | 194584 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6015435.57046 | 2098024.5169599997 | 37.7416428069711 | -122.389212935026 | (37.7416428069711, -122.389212935026) | |||
| 57415 | 57415 | 194585 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015429.91647 | 2098027.47569 | 37.741650617592 | -122.389232691343 | (37.741650617592, -122.389232691343) | |||
| 183631 | 183631 | 194586 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015412.99907 | 2098039.7697 | 37.7416834365362 | -122.38929204481701 | (37.7416834365362, -122.389292044817) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 64248 | 64248 | 211436 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 220x Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 34 | Width 6ft | 5994537.09641 | 2099112.75591 | 37.7434501331166 | -122.461551189851 | (37.7434501331166, -122.461551189851) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||||
| 69150 | 69150 | 194582 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 618 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013519.11255 | 2104217.1828099997 | 37.7585401149596 | -122.39627337661001 | (37.7585401149596, -122.39627337661) | |||
| 47775 | 47775 | 194581 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 608 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6013516.07962 | 2104276.2000599997 | 37.758701994708204 | -122.396288002304 | (37.7587019947082, -122.396288002304) | |||
| 23754 | 23754 | 194580 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.758837617875294 | -122.39630140851001 | (37.7588376178753, -122.39630140851) | |||
| 65406 | 65406 | 194579 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 588 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013514.83137 | 2104327.6362099997 | 37.7588431577105 | -122.396295924418 | (37.7588431577105, -122.396295924418) | |||
| 48737 | 48737 | 194578 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 586 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013510.77458 | 2104373.03233 | 37.7589675798212 | -122.39631313654499 | (37.7589675798212, -122.396313136545) | |||
| 168962 | 168962 | 194577 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 580 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6013511.640380001 | 2104375.7087 | 37.7589749767275 | -122.396310329764 | (37.7589749767275, -122.396310329764) | |||
| 25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
| 134493 | 134493 | 194575 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 568 Missouri St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013510.83994 | 2104426.47875 | 37.759114335674894 | -122.396316656512 | (37.7591143356749, -122.396316656512) | |||
| 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) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 180543 | 180543 | 194589 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 11 Bridgeview Way | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6016121.54622 | 2108188.95403 | 37.7695902108346 | -122.387549998659 | (37.7695902108346, -122.387549998659) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 64368 | 64368 | 249601 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2200 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5998898.09787 | 2111497.4092 | 37.777705355751294 | -122.447363215433 | (37.7777053557513, -122.447363215433) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 133226 | 133226 | 122244 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990784.64686 | 2114787.2699700003 | 37.7862714344765 | -122.475670418927 | (37.7862714344765, -122.475670418927) | |||
| 70254 | 70254 | 122245 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5990779.800559999 | 2114787.3723 | 37.7862714344884 | -122.47568719317199 | (37.7862714344884, -122.475687193172) | |||
| 178667 | 178667 | 123936 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 08th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 5993306.8177 | 2114889.70076 | 37.786698577308705 | -122.466951883723 | (37.7866985773087, -122.466951883723) | |||
| 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) | |||
| 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) |
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");