Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189139 | 189139 | 246247 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 92 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999685.4059 | 2107775.5089 | 37.76753091894221 | -122.44437211474701 | (37.7675309189422, -122.444372114747) | |||
| 189062 | 189062 | 250894 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 250 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986839.6011 | 2114252.83409 | 37.784574529539796 | -122.489279763454 | (37.7845745295398, -122.489279763454) | |||
| 189015 | 189015 | 132607 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 300 Laurel St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5998069.1356 | 2115417.33363 | 37.7884210360372 | -122.450513532469 | (37.7884210360372, -122.450513532469) | |||
| 189001 | 189001 | 234324 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006201.08295 | 2102382.1354900002 | 37.753091576833796 | -122.421452136626 | (37.7530915768338, -122.421452136626) | |||
| 188972 | 188972 | 187326 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985094.7578 | 2099652.5203 | 37.7443841605942 | -122.494239713708 | (37.7443841605942, -122.494239713708) | |||
| 188964 | 188964 | 132579 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 115 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998468.5423099995 | 2116022.0814 | 37.790104365469105 | -122.44917523966998 | (37.7901043654691, -122.44917523967) | |||
| 188953 | 188953 | 133198 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 556 Pine St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 5ft | 6011234.26177 | 2116330.1506 | 37.7916721266196 | -122.40502834240101 | (37.7916721266196, -122.405028342401) | |||
| 188938 | 188938 | 104756 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 50 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5998478.129930001 | 2116269.10777 | 37.7907831827466 | -122.449159871157 | (37.7907831827466, -122.449159871157) | |||
| 188937 | 188937 | 234188 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 431 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003193.94569 | 2098602.90337 | 37.7425446794999 | -122.431581614504 | (37.7425446794999, -122.431581614504) | |||
| 188904 | 188904 | 211725 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) | ||||
| 188875 | 188875 | 30367 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 674 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 23 | Permit Number 55 | 6012983.3674 | 2103955.4994099997 | 37.7577917638944 | -122.398107878472 | (37.7577917638944, -122.398107878472) | ||
| 188858 | 188858 | 234104 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1100 San Jose Ave | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004777.73384 | 2096671.97117 | 37.7373324202616 | -122.425967914987 | (37.7373324202616, -122.425967914987) | ||||
| 188822 | 188822 | 194903 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 401 Mission Rock St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015232.09162 | 2109377.87139 | 37.7728054103818 | -122.390709711786 | (37.7728054103818, -122.390709711786) | |||
| 188807 | 188807 | 132780 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2801 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001295.02874 | 2115924.4292900003 | 37.7899974963245 | -122.439388843244 | (37.7899974963245, -122.439388843244) | |||
| 188723 | 188723 | 137610 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1201 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002289.4493 | 2112677.1753 | 37.7811379049339 | -122.43571581559799 | (37.7811379049339, -122.435715815598) | |||
| 188709 | 188709 | 234045 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006353.86938 | 2099988.42858 | 37.7465276176737 | -122.420753849026 | (37.7465276176737, -122.420753849026) | |||
| 188690 | 188690 | 120002 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 743 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5986916.79344 | 2110861.57501 | 37.7752676025083 | -122.48876334533001 | (37.7752676025083, -122.48876334533) | |||
| 188647 | 188647 | 234969 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 608 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002357.35419 | 2102104.62113 | 37.7521121179955 | -122.434724645244 | (37.7521121179955, -122.434724645244) | |||
| 188609 | 188609 | 132948 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2661 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6004413.104590001 | 2118325.1529 | 37.7967662257243 | -122.428771781702 | (37.7967662257243, -122.428771781702) | |||
| 188606 | 188606 | 121821 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 250 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5989959.99971 | 2113738.30068 | 37.7833434168373 | -122.47844671980499 | (37.7833434168373, -122.478446719805) | |||
| 188585 | 188585 | 133186 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6010537.33866 | 2121307.06763 | 37.80529854275579 | -122.40779079533199 | (37.8052985427558, -122.407790795332) | ||||
| 188577 | 188577 | 249695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2400 Baker St | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999678.04202 | 2117322.75965 | 37.7937447896309 | -122.445084029412 | (37.7937447896309, -122.445084029412) | ||||
| 188532 | 188532 | 234243 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 331 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006747.10138 | 2096063.6649900002 | 37.735773249427204 | -122.41911574918699 | (37.7357732494272, -122.419115749187) | |||
| 188509 | 188509 | 132606 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 301 Laurel St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 5998067.828869999 | 2115435.37525 | 37.7884704987534 | -122.450519354702 | (37.7884704987534, -122.450519354702) | |||
| 188489 | 188489 | 234236 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 360 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007028.336 | 2096000.5173799999 | 37.735615693604394 | -122.418138933487 | (37.7356156936044, -122.418138933487) | |||
| 188461 | 188461 | 132625 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3575 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997652.85081 | 2115739.62617 | 37.7892821306169 | -122.45197706581499 | (37.7892821306169, -122.451977065815) | |||
| 188459 | 188459 | 120613 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2 North Point St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010416.24668 | 2122047.4403 | 37.8073246424791 | -122.408262103012 | (37.8073246424791, -122.408262103012) | |||
| 188420 | 188420 | 194616 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 131 Shipley St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012083.18563 | 2112300.62114 | 37.7806554027536 | -122.401807685802 | (37.7806554027536, -122.401807685802) | |||
| 188374 | 188374 | 235046 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 450 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 2ft | 6002120.21323 | 2103238.69796 | 37.7552125559202 | -122.43562583967599 | (37.7552125559202, -122.435625839676) | |||
| 188371 | 188371 | 234995 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 445 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002249.2372 | 2098460.3363099997 | 37.742099631997796 | -122.43483794091298 | (37.7420996319978, -122.434837940913) | |||
| 188369 | 188369 | 211679 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 118 Ashton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994177.1078 | 2090720.2532400002 | 37.7203856540458 | -122.462187404445 | (37.7203856540458, -122.462187404445) | |||
| 188325 | 188325 | 53288 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2665 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1969 12:00:00 AM | 14 | Permit Number 6178 | 6005269.09098 | 2119170.43565 | 37.799135566117 | -122.425870068752 | (37.799135566117, -122.425870068752) | ||
| 188295 | 188295 | 178470 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 90 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6000590.50802 | 2092137.17164 | 37.724643377372296 | -122.44011997136101 | (37.7246433773723, -122.440119971361) | |||
| 188274 | 188274 | 194767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1150 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6014887.36343 | 2096387.9974 | 37.737118854647996 | -122.390994112483 | (37.737118854648, -122.390994112483) | |||
| 188203 | 188203 | 194806 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 503 Beale St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 6ft | 6015898.48961 | 2114031.9234599997 | 37.785621348501 | -122.38872949907801 | (37.785621348501, -122.388729499078) | |||
| 188185 | 188185 | 133189 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 165 Francisco St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010562.1879199995 | 2121314.22329 | 37.8053195814974 | -122.40770530575399 | (37.8053195814974, -122.407705305754) | ||||
| 188174 | 188174 | 194946 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 685 China Basin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6014834.86351 | 2109009.62252 | 37.771772234130104 | -122.392058023083 | (37.7717722341301, -122.392058023083) | |||
| 188080 | 188080 | 194935 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 701 China Basin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6014436.57311 | 2108990.5193 | 37.7716976596468 | -122.393434409389 | (37.7716976596468, -122.393434409389) | |||
| 188068 | 188068 | 55353 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 599 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 12 | Permit Number 11286 | 5993748.41208 | 2113470.19668 | 37.782826483510796 | -122.465320934842 | (37.7828264835108, -122.465320934842) | ||
| 187987 | 187987 | 67399 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 578 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 10 | Permit Number 30896 | 5990663.42796 | 2111452.2295 | 37.7771073100211 | -122.475846159065 | (37.7771073100211, -122.475846159065) | |
| 187976 | 187976 | 66133 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 64 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1990 12:00:00 AM | 13 | Permit Number 29195 | 6001738.9264 | 2120869.24898 | 37.8035999293564 | -122.438207379562 | (37.8035999293564, -122.438207379562) | ||
| 187958 | 187958 | 132961 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1772 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6005102.925009999 | 2118177.14968 | 37.7963988643655 | -122.426374299757 | (37.7963988643655, -122.426374299757) | |||
| 187933 | 187933 | 141037 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 168 JORDAN AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5996266.0384 | 2113205.8421 | 37.7822455054095 | -122.456591933359 | (37.7822455054095, -122.456591933359) | |||
| 187920 | 187920 | 234321 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 239 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006186.41038 | 2101778.27825 | 37.7514326963825 | -122.421459995791 | (37.7514326963825, -122.421459995791) | |||
| 187907 | 187907 | 132993 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006493.601430001 | 2112881.2099599997 | 37.7819360382714 | -122.421186010126 | (37.7819360382714, -122.421186010126) | |||
| 187894 | 187894 | 43883 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2721 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 6 | Permit Number 43581 | 5996517.80334 | 2111258.1735 | 37.7769121727044 | -122.455580124025 | (37.7769121727044, -122.455580124025) | ||
| 187848 | 187848 | 178457 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 327 Ordway St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6010945.35772 | 2090025.6456900002 | 37.7194296360547 | -122.40417583815099 | (37.7194296360547, -122.404175838151) | |||
| 187840 | 187840 | 206133 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 145 Irving St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995292.11797 | 2106675.93028 | 37.7642601215417 | -122.459488172067 | (37.7642601215417, -122.459488172067) | |||
| 187726 | 187726 | 98767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003313.437419999 | 2121061.12622 | 37.8042161969888 | -122.432772427524 | (37.8042161969888, -122.432772427524) | |||
| 187697 | 187697 | 235247 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 562 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003615.40812 | 2104973.33574 | 37.7600602704896 | -122.430578785883 | (37.7600602704896, -122.430578785883) | |||
| 187672 | 187672 | 133164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010207.81759 | 2122270.0679900004 | 37.8079242492629 | -122.40899913969999 | (37.8079242492629, -122.4089991397) | |||
| 187655 | 187655 | 132695 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 501 Webster St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6004047.336680001 | 2110514.9536 | 37.775300672009394 | -122.42948015697901 | (37.7753006720094, -122.429480156979) | |||
| 187641 | 187641 | 139963 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1675 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002406.0218 | 2112615.8952 | 37.7809762659962 | -122.43530814867701 | (37.7809762659962, -122.435308148677) | |||
| 187628 | 187628 | 211618 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2612 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991136.49506 | 2097646.4934900003 | 37.7392278286912 | -122.47320258234 | (37.7392278286912, -122.47320258234) | |||
| 187583 | 187583 | 132650 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3467 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997657.92722 | 2116074.74088 | 37.7902025570547 | -122.45198368930001 | (37.7902025570547, -122.4519836893) | |||
| 187526 | 187526 | 57964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 356 Hanover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1977 12:00:00 AM | 18 | Permit Number 16924 | 5999367.58813 | 2086445.59865 | 37.7089459151864 | -122.44393869062799 | (37.7089459151864, -122.443938690628) | ||
| 187477 | 187477 | 234036 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 143 Scott St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6002306.01138 | 2109052.49296 | 37.7711863734766 | -122.435399155653 | (37.7711863734766, -122.435399155653) | |||
| 187446 | 187446 | 132697 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2960 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001503.92124 | 2118640.82846 | 37.7974679064734 | -122.43886083685499 | (37.7974679064734, -122.438860836855) | |||
| 187439 | 187439 | 234956 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 474 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000649.05028 | 2101264.42753 | 37.7497080161155 | -122.44057194546001 | (37.7497080161155, -122.44057194546) | |||
| 187417 | 187417 | 218328 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 446 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5993017.38918 | 2099944.3564400002 | 37.7456459061356 | -122.46686635132099 | (37.7456459061356, -122.466866351321) | |||
| 187410 | 187410 | 234138 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 68 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6005205.301969999 | 2104604.60956 | 37.7591377755984 | -122.42505386476299 | (37.7591377755984, -122.425053864763) | |||
| 187384 | 187384 | 140892 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 150 PARKER AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5996921.222999999 | 2113410.5873 | 37.7828452763706 | -122.45434009391501 | (37.7828452763706, -122.454340093915) | |||
| 187371 | 187371 | 211675 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 140 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994473.3982 | 2090822.9981799999 | 37.7206848225258 | -122.461170675896 | (37.7206848225258, -122.461170675896) | |||
| 187370 | 187370 | 123397 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 651 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995003.18889 | 2111110.1633 | 37.776418744844605 | -122.460808871456 | (37.7764187448446, -122.460808871456) | |||
| 187307 | 187307 | 44187 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 248 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2002 12:00:00 AM | 3 | Permit Number 44776 | 5990894.1972 | 2113727.7318 | 37.783368588065706 | -122.47521402717399 | (37.7833685880657, -122.475214027174) | |
| 187294 | 187294 | 132733 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3235 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999312.90145 | 2119968.52445 | 37.800988505865504 | -122.446537882444 | (37.8009885058655, -122.446537882444) | |||
| 187280 | 187280 | 199736 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500 Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014608.9082 | 2092348.0239 | 37.7260104508514 | -122.391674484002 | (37.7260104508514, -122.391674484002) | |||
| 187156 | 187156 | 194955 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 157 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6011120.228069999 | 2112741.54677 | 37.7818122951412 | -122.40517009262301 | (37.7818122951412, -122.405170092623) | |||
| 187152 | 187152 | 142717 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1120 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008054.1886 | 2121138.8091 | 37.804697223470704 | -122.41637215183998 | (37.8046972234707, -122.41637215184) | |||
| 187120 | 187120 | 140607 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 849 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003687.3535 | 2111405.379 | 37.7777251719251 | -122.43078897865601 | (37.7777251719251, -122.430788978656) | |||
| 187107 | 187107 | 56630 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 85 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5994238.8037 | 2115029.2385299997 | 37.7871354579314 | -122.46373759128299 | (37.7871354579314, -122.463737591283) | ||||
| 187091 | 187091 | 178491 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 151 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6002740.81562 | 2092560.25993 | 37.7259272675047 | -122.432716846698 | (37.7259272675047, -122.432716846698) | |||
| 187029 | 187029 | 54041 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2855 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | 14 | Permit Number 9763 | 6001036.633830001 | 2118177.8048799997 | 37.7961699689158 | -122.440444544776 | (37.7961699689158, -122.440444544776) | ||
| 187003 | 187003 | 234207 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1529 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997860.318030001 | 2105396.7223400003 | 37.760895073376396 | -122.45051331216699 | (37.7608950733764, -122.450513312167) | |||
| 186996 | 186996 | 194629 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1120 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013883.62564 | 2106202.75616 | 37.764012342109396 | -122.395151797926 | (37.7640123421094, -122.395151797926) | |||
| 186985 | 186985 | 194785 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1733 McKinnon Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014577.08037 | 2096493.16973 | 37.73739041392879 | -122.392074263026 | (37.7373904139288, -122.392074263026) | |||
| 186953 | 186953 | 32087 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3964 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 9 | Permit Number 35460 | 6003256.89159 | 2104790.94057 | 37.759539140335995 | -122.43180569859899 | (37.759539140336, -122.431805698599) | |
| 186922 | 186922 | 132509 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2393 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6001581.15331 | 2118683.24457 | 37.7975887636713 | -122.438596634922 | (37.7975887636713, -122.438596634922) | |||
| 186819 | 186819 | 140537 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1234 MCALLISTER ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003064.878 | 2111712.7722 | 37.7785339099815 | -122.432964299887 | (37.7785339099815, -122.432964299887) | |||
| 186804 | 186804 | 201917 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 252 Elmira St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6011221.2192 | 2095233.3138 | 37.7337442232988 | -122.40358848733901 | (37.7337442232988, -122.403588487339) | |||
| 186799 | 186799 | 72306 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 3434 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997784.02089 | 2116132.98563 | 37.7903697032501 | -122.451551619911 | (37.7903697032501, -122.451551619911) | ||
| 186796 | 186796 | 137522 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1654 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6001667.7054 | 2111943.9781 | 37.7790893956053 | -122.43781420645901 | (37.7790893956053, -122.437814206459) | |||
| 186794 | 186794 | 31340 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 430 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45975 | 6005768.2475 | 2111055.2748 | 37.7768815477511 | -122.423565546393 | (37.7768815477511, -122.423565546393) |
| 186751 | 186751 | 140571 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 920 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003374.8012 | 2111414.8924 | 37.7777335802219 | -122.431870883072 | (37.7777335802219, -122.431870883072) | |||
| 186705 | 186705 | 132777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2899 Clay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6001023.570280001 | 2115882.69628 | 37.789867456172 | -122.440325069866 | (37.789867456172, -122.440325069866) | |||
| 186685 | 186685 | 234137 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 58 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005240.02172 | 2104603.39745 | 37.7591364086387 | -122.424933700938 | (37.7591364086387, -122.424933700938) | |||
| 186682 | 186682 | 139959 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1560 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002688.0152 | 2112361.0567 | 37.780292553668794 | -122.434314370537 | (37.7802925536688, -122.434314370537) | |||
| 186676 | 186676 | 217689 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 279 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5992479.7157 | 2097263.3882 | 37.7382536011824 | -122.4685305026 | (37.7382536011824, -122.4685305026) | |||
| 186666 | 186666 | 194732 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 314 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013450.1155199995 | 2105588.68858 | 37.76230213015889 | -122.396608142965 | (37.7623021301589, -122.396608142965) | |||
| 186640 | 186640 | 133002 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 100 Elm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007050.35685 | 2112775.93042 | 37.781678337512105 | -122.419252418291 | (37.7816783375121, -122.419252418291) | |||
| 186560 | 186560 | 43794 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 270 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43424 | 5989036.4193400005 | 2113527.4816400004 | 37.7827109054518 | -122.48162645948 | (37.7827109054518, -122.48162645948) | |
| 186530 | 186530 | 249397 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 350 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008279.412330001 | 2113135.60794 | 37.7827350670063 | -122.415025920327 | (37.7827350670063, -122.415025920327) | |||
| 186490 | 186490 | 122913 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 110 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5992129.18791 | 2114656.14711 | 37.7859892632225 | -122.471009142692 | (37.7859892632225, -122.471009142692) | |||
| 186478 | 186478 | 194954 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 157 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6011132.7935 | 2112728.51397 | 37.7817772125879 | -122.40512570388701 | (37.7817772125879, -122.405125703887) | |||
| 186473 | 186473 | 183880 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2130 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5988854.6643 | 2100842.9028 | 37.747871944579295 | -122.48132604988501 | (37.7478719445793, -122.481326049885) | |||
| 186468 | 186468 | 98537 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2337 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002393.46456 | 2117753.95892 | 37.7950833621582 | -122.435719303524 | (37.7950833621582, -122.435719303524) | |||
| 186443 | 186443 | 133199 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 556 Pine St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6011227.73162 | 2116330.45943 | 37.7916726095505 | -122.40505095854601 | (37.7916726095505, -122.405050958546) | |||
| 186431 | 186431 | 211852 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 714 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.44424166861602 | (37.7335800736498, -122.444241668616) | ||||
| 186428 | 186428 | 133201 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 641 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6013099.46425 | 2118841.94068 | 37.798672996215295 | -122.398751065503 | (37.7986729962153, -122.398751065503) | |||
| 186403 | 186403 | 211546 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 249 Granville Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994020.65434 | 2098855.6409299998 | 37.742714420228 | -122.463318248853 | (37.742714420228, -122.463318248853) |
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");