Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33343 | 33343 | 227094 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 35 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6009153.630890001 | 2095762.56962 | 37.7350817355269 | -122.410774146024 | (37.7350817355269, -122.410774146024) | ||||
| 47585 | 47585 | 176883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.63475 | 2088252.8219299999 | 37.7145675926038 | -122.40369417294501 | (37.7145675926038, -122.403694172945) | ||||
| 53294 | 53294 | 79640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | ||
| 56847 | 56847 | 71337 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 4 | 5982620.59121 | 2110750.54443 | 37.7747110919712 | -122.503616418137 | (37.7747110919712, -122.503616418137) | ||
| 68994 | 68994 | 83834 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | 7 | 6013045.53048 | 2096356.5558 | 37.736930148098295 | -122.397360003177 | (37.7369301480983, -122.397360003177) | ||
| 77242 | 77242 | 81630 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2005 12:00:00 AM | 7 | 5999996.8419 | 2093367.66723 | 37.7279882186648 | -122.44226048643 | (37.7279882186648, -122.44226048643) | ||
| 130069 | 130069 | 84554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | ||
| 147108 | 147108 | 79224 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3562 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2001 12:00:00 AM | 6 | 5997807.39537 | 2115154.90167 | 37.787685483256396 | -122.451400172276 | (37.7876854832564, -122.451400172276) | ||
| 148576 | 148576 | 83440 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | 6011076.92464 | 2105580.38381 | 37.76214696383371 | -122.404815578978 | (37.7621469638337, -122.404815578978) | ||
| 155267 | 155267 | 70408 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 3 | 6006531.16259 | 2092699.03842 | 37.7265225593592 | -122.419623688079 | (37.7265225593592, -122.419623688079) | ||
| 157408 | 157408 | 69788 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1526 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/27/2001 12:00:00 AM | 1 | 5982204.5216 | 2104686.309 | 37.758035976388896 | -122.50460626225299 | (37.7580359763889, -122.504606262253) | ||
| 160084 | 160084 | 191225 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2350 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011119.4005 | 2104649.28038 | 37.759592736331705 | -122.404603122242 | (37.7595927363317, -122.404603122242) | ||||
| 172938 | 172938 | 176884 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.40364648639601 | (37.7145850034576, -122.403646486396) | ||||
| 174137 | 174137 | 84659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.45447894833201 | (37.7781074773999, -122.454478948332) | |||
| 182506 | 182506 | 83202 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | |||
| 183647 | 183647 | 80237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.49385223473601 | (37.7558298048279, -122.493852234736) | |||
| 187240 | 187240 | 191224 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2350 20th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | ||||
| 50222 | 50222 | 113489 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | |||
| 1364 | 1364 | 251507 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1365 | 1365 | 251509 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1372 | 1372 | 251508 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1375 | 1375 | 251506 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 51 Commonwealth Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996476.0 | 2114178.0 | 37.784926844945396 | -122.45593586593901 | (37.7849268449454, -122.455935865939) | ||||
| 1835 | 1835 | 251742 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
| 1836 | 1836 | 251749 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 601 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002875.0 | 2087693.0 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | |||||
| 1848 | 1848 | 251743 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Cordova St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001773.0 | 2087479.0 | 37.7119203272299 | -122.43569914014999 | (37.7119203272299, -122.43569914015) | |||||
| 2122 | 2122 | 252898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 2676 | 2676 | 253162 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004481.0 | 2091226.0 | 37.7223622223708 | -122.42660617515699 | (37.7223622223708, -122.426606175157) | ||||
| 4270 | 4270 | 252889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:58:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4282 | 4282 | 251444 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545.0 | 2088436.0 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | ||
| 24713 | 24713 | 71549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.41462566084101 | (37.7875672592553, -122.414625660841) |
| 59456 | 59456 | 106431 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | |||
| 77937 | 77937 | 106193 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3040 TARAVAL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5983698.2 | 2098878.7 | 37.742177638003994 | -122.499011481047 | (37.742177638004, -122.499011481047) | ||||
| 83380 | 83380 | 101252 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290X 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992716.9 | 2106688.9 | 37.764147324412605 | -122.46839598557699 | (37.7641473244126, -122.468395985577) | ||||
| 98532 | 98532 | 115939 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 34TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777685 | 5985316.0 | 2111712.0 | 37.7775090776113 | -122.49436347548901 | (37.7775090776113, -122.494363475489) | |
| 103543 | 103543 | 105757 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | |
| 116120 | 116120 | 113418 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 598X BENTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6007207.0 | 2095355.0 | 37.7338532991757 | -122.417475487879 | (37.7338532991757, -122.417475487879) | |||
| 124146 | 124146 | 83176 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3301 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 6 | 3x3 | 5985317.61354 | 2111082.30707 | 37.77578021552279 | -122.494311467187 | (37.7757802155228, -122.494311467187) | |
| 143316 | 143316 | 102935 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 801X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
| 3971 | 3971 | 251681 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550.0 | 2089909.0 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | ||
| 4266 | 4266 | 181021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.6994199995 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | ||
| 3913 | 3913 | 253116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3915 | 3915 | 160069 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.7878900003 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | ||
| 3918 | 3918 | 253108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3922 | 3922 | 160059 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 10:50:00 AM | 3 | Width 0ft | 6000588.557440001 | 2091082.6412900002 | 37.7217477663201 | -122.440051133668 | (37.7217477663201, -122.440051133668) | ||
| 3928 | 3928 | 253114 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3934 | 3934 | 160071 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | ||
| 3935 | 3935 | 160073 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.999340001 | 2090399.7386 | 37.7198438772755 | -122.44174972458201 | (37.7198438772755, -122.441749724582) | ||
| 3937 | 3937 | 253112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3939 | 3939 | 160065 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:13:00 AM | 3 | Width 0ft | 6000417.53141 | 2090750.6791299998 | 37.7208265358932 | -122.440618525839 | (37.7208265358932, -122.440618525839) | ||
| 3946 | 3946 | 160063 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.9533099998 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | ||
| 3950 | 3950 | 162332 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.718864853708205 | -122.45402201441001 | (37.7188648537082, -122.45402201441) | ||
| 3960 | 3960 | 160061 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:02:00 AM | 3 | Width 0ft | 6000547.454419999 | 2091000.21878 | 37.7215191128017 | -122.440187308101 | (37.7215191128017, -122.440187308101) | ||
| 3968 | 3968 | 253118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3973 | 3973 | 253110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 3974 | 3974 | 162331 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.5104099999 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | ||
| 3982 | 3982 | 159338 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.44832801714199 | (37.7108995709325, -122.448328017142) | ||
| 3992 | 3992 | 159336 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | ||
| 4058 | 4058 | 159346 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.8062099998 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | ||
| 4070 | 4070 | 159339 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.4578599995 | 2087195.02696 | 37.710932799068104 | -122.44828212563 | (37.7109327990681, -122.44828212563) | ||
| 4072 | 4072 | 159348 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.3667799998 | 37.711430378688796 | -122.447651252104 | (37.7114303786888, -122.447651252104) | ||
| 4077 | 4077 | 159345 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | ||
| 4091 | 4091 | 159347 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.711367382076396 | -122.44773365338999 | (37.7113673820764, -122.44773365339) | ||
| 27198 | 27198 | 140780 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 5 Encanto Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000014.7367 | 2112198.3604 | 37.7796937331341 | -122.44355075738399 | (37.7796937331341, -122.443550757384) | |||
| 28351 | 28351 | 248531 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997658.267999999 | 2107761.8815 | 37.767377634072794 | -122.451382700243 | (37.7673776340728, -122.451382700243) | |||
| 28890 | 28890 | 182659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2252 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986985.3742 | 2102363.8158 | 37.7519391046129 | -122.487901613135 | (37.7519391046129, -122.487901613135) | |||
| 32349 | 32349 | 184697 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | |||
| 34972 | 34972 | 244513 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 500 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004128.882 | 2109777.8057 | 37.7732812611379 | -122.429145501014 | (37.7732812611379, -122.429145501014) | |||
| 35420 | 35420 | 182699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1659 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989088.7291 | 2103739.8915 | 37.755839910949895 | -122.480728726959 | (37.7558399109499, -122.480728726959) | |||
| 37433 | 37433 | 184723 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1635 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983115.9866 | 2103988.5253 | 37.7561736313112 | -122.501402462618 | (37.7561736313112, -122.501402462618) | |||
| 41737 | 41737 | 183303 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1286 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982766.9656 | 2106385.9546 | 37.7627357893861 | -122.502786935917 | (37.7627357893861, -122.502786935917) | |||
| 43034 | 43034 | 140758 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 42 TERRA VISTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000316.7782 | 2112875.0348 | 37.781568928755895 | -122.442554464995 | (37.7815689287559, -122.442554464995) | |||
| 48320 | 48320 | 140696 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | |||
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
| 60263 | 60263 | 247309 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002790.9139 | 2109368.8454 | 37.7720825259473 | -122.43374447503099 | (37.7720825259473, -122.433744475031) | |||
| 63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
| 63806 | 63806 | 181949 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | |||
| 66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
| 70054 | 70054 | 184494 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | |||
| 117673 | 117673 | 140302 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997780.8586 | 2110053.3207 | 37.773676357183 | -122.45112394331899 | (37.773676357183, -122.451123943319) | |||
| 130143 | 130143 | 182826 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1781 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986558.6884 | 2103101.4836 | 37.7539396409234 | -122.48943136928999 | (37.7539396409234, -122.48943136929) | |||
| 131222 | 131222 | 247385 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 355 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002203.8017 | 2109776.7723 | 37.7731692596784 | -122.435804531936 | (37.7731692596784, -122.435804531936) | |||
| 132639 | 132639 | 183523 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | |||
| 135392 | 135392 | 181684 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1347 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986459.3313 | 2106064.8642 | 37.7620704697574 | -122.48999290967501 | (37.7620704697574, -122.489992909675) | |||
| 150547 | 150547 | 200836 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.766265411985295 | -122.398001493496 | (37.7662654119853, -122.398001493496) | |||
| 153218 | 153218 | 182607 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1867 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986269.2088 | 2102542.1488 | 37.7523869566931 | -122.49039129916001 | (37.7523869566931, -122.49039129916) | |||
| 153529 | 153529 | 183672 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1254 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5984312.3195 | 2106638.1262 | 37.7635188796404 | -122.497460805156 | (37.7635188796404, -122.497460805156) | |||
| 154400 | 154400 | 141717 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2545 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998369.6346 | 2111707.5824 | 37.778252224784005 | -122.44920648801201 | (37.778252224784, -122.449206488012) | |||
| 160731 | 160731 | 140699 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 224 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998816.4363 | 2109919.7991 | 37.773368976906205 | -122.447532121663 | (37.7733689769062, -122.447532121663) | |||
| 161381 | 161381 | 245893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | |||
| 162586 | 162586 | 183640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1484 47th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981572.1323 | 2104991.2828 | 37.7588361283195 | -122.506815916291 | (37.7588361283195, -122.506815916291) | |||
| 167364 | 167364 | 182307 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1509 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987118.7965 | 2104973.5941 | 37.7591126281614 | -122.487631931758 | (37.7591126281614, -122.487631931758) | |||
| 171120 | 171120 | 184598 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.321 | 2103008.0087 | 37.7535198125919 | -122.499067143504 | (37.7535198125919, -122.499067143504) | |||
| 172020 | 172020 | 184126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.756498872957394 | -122.490675089245 | (37.7564988729574, -122.490675089245) | |||
| 173458 | 173458 | 184640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983160.9711 | 2103902.0944 | 37.7559389581009 | -122.501240500695 | (37.7559389581009, -122.501240500695) | |||
| 175623 | 175623 | 184549 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3501 Moraga St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983411.1343 | 2103548.3965 | 37.754982490057 | -122.50034921882099 | (37.754982490057, -122.500349218821) | |||
| 176471 | 176471 | 182700 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1651 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989102.9459 | 2103739.8915 | 37.7558407372502 | -122.48067956122401 | (37.7558407372502, -122.480679561224) | |||
| 178120 | 178120 | 181690 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1374 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982168.1662 | 2105754.9295 | 37.760967965591604 | -122.504811174863 | (37.7609679655916, -122.504811174863) | |||
| 179813 | 179813 | 137671 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 756 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000049.6788 | 2111547.4906 | 37.7779086039439 | -122.443383113797 | (37.7779086039439, -122.443383113797) | |||
| 185807 | 185807 | 182658 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2242 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987004.6631 | 2102364.6195 | 37.751942436508706 | -122.487834969288 | (37.7519424365087, -122.487834969288) |
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");