Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2198 | 2198 | 252932 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 66 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091179.0 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | |||||
| 2199 | 2199 | 252934 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 78 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091229.0 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | |||||
| 2201 | 2201 | 252933 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 72 Edgar Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997141.0 | 2091205.0 | 37.7218868659906 | -122.45197719957199 | (37.7218868659906, -122.451977199572) | |||||
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 77051 | 77051 | 88389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51367 | 5989030.6035 | 2113722.2392700003 | 37.7832453168995 | -122.481660848787 | (37.7832453168995, -122.481660848787) | ||
| 86823 | 86823 | 86773 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4259 22nd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2007 12:00:00 AM | 3x3 | Permit Number 49745 | 6000836.0 | 2102862.0 | 37.754105209101894 | -122.44004000726002 | (37.7541052091019, -122.44004000726) | |||
| 88272 | 88272 | 106800 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 443 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6011195.0 | 2112052.0 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | |||||
| 101292 | 101292 | 109291 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 286 Cumberland St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774872 | 6003752.6 | 2104537.4 | 37.7588710659743 | -122.4300732064 | (37.7588710659743, -122.4300732064) | |
| 102099 | 102099 | 88183 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 459 Clementina St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51190 | 6011089.0 | 2111952.0 | 37.779642638468204 | -122.405222512117 | (37.7796426384682, -122.405222512117) | |||
| 103102 | 103102 | 88573 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 488 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51513 | 5990365.1 | 2112073.9 | 37.7787969444241 | -122.476923593538 | (37.7787969444241, -122.476923593538) | |||
| 108417 | 108417 | 89207 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 865 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51841 | 5988167.9 | 2110089.1 | 37.773219533815706 | -122.484378866757 | (37.7732195338157, -122.484378866757) | |||
| 112732 | 112732 | 88521 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 162 Southwood Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51453 | 5994999.0 | 2092590.0 | 37.7255668196252 | -122.459481752836 | (37.7255668196252, -122.459481752836) | |||
| 114360 | 114360 | 90462 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 776 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.55131 | 2110700.5515099997 | 37.774901067358996 | -122.484265806793 | (37.774901067359, -122.484265806793) | |||
| 116453 | 116453 | 90459 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 798X 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988218.0470900005 | 2110585.2902900004 | 37.774584853982894 | -122.484241800238 | (37.7745848539829, -122.484241800238) | |||
| 118864 | 118864 | 88702 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 225 Laguna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 51652 | 6005143.0 | 2109639.0 | 37.772957489854605 | -122.425627645138 | (37.7729574898546, -122.425627645138) | |||
| 122357 | 122357 | 90461 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 780 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.85738 | 2110673.16421 | 37.774825887299 | -122.484262739051 | (37.774825887299, -122.484262739051) | |||
| 123835 | 123835 | 90460 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 786 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | |||
| 126500 | 126500 | 108790 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 964 Avalon Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774648 | 6005260.71538 | 2092108.7788900002 | 37.7248301904685 | -122.423973622591 | (37.7248301904685, -122.423973622591) | |
| 128656 | 128656 | 87468 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 147 Laidley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2008 12:00:00 AM | 3x3 | Permit Number 50383 | 6003836.0 | 2097532.0 | 37.739640595493704 | -122.42928523334801 | (37.7396405954937, -122.429285233348) | |||
| 135556 | 135556 | 88395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 150 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51374 | 5988059.13984 | 2114984.30463 | 37.78665405150971 | -122.48511431139 | (37.7866540515097, -122.48511431139) | ||
| 143332 | 143332 | 88075 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 931 Elizabeth St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/2008 12:00:00 AM | Permit Number 51070 | 6000446.0 | 2101962.0 | 37.7516118173154 | -122.441324145572 | (37.7516118173154, -122.441324145572) | ||||
| 180049 | 180049 | 88386 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 226 19th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51364 | 5989957.47723 | 2113852.0008799997 | 37.783655459334796 | -122.47846376353901 | (37.7836554593348, -122.478463763539) | ||
| 183716 | 183716 | 88553 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 734 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51498 | 5991338.26851 | 2110389.97452 | 37.7742297509054 | -122.4734341978 | (37.7742297509054, -122.4734341978) | ||
| 123 | 123 | 18916 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | |||
| 175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
| 399 | 399 | 17856 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | ||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 552 | 552 | 194122 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 606 | 606 | 233049 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3181 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2011 12:00:00 AM | 3 | Width 3ft | 6007718.49924 | 2102654.70617 | 37.753925433618704 | -122.416223901805 | (37.7539254336187, -122.416223901805) | ||
| 923 | 923 | 210740 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992981.0390099995 | 2088189.5314 | 37.7133679617255 | -122.46613798048901 | (37.7133679617255, -122.466137980489) | |||
| 949 | 949 | 13070 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.803032589908106 | -122.4119030734 | (37.8030325899081, -122.4119030734) | |||
| 1058 | 1058 | 19026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.78836090738071 | -122.44506178917 | (37.7883609073807, -122.44506178917) | |||
| 1289 | 1289 | 131895 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3274 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 4ft | 5999203.0 | 2115426.0 | 37.7885096634197 | -122.446591180632 | (37.7885096634197, -122.446591180632) | |||
| 1294 | 1294 | 6921 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | ||
| 1539 | 1539 | 167009 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3865 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 768818 | 6003858.30002 | 2105358.64848 | 37.7611320042552 | -122.42976622233 | (37.7611320042552, -122.42976622233) | |
| 1560 | 1560 | 210622 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2017 12:00:00 AM | 3 | Width 2ft | 5993364.80541 | 2106063.8087299997 | 37.762468389619606 | -122.46610965904699 | (37.7624683896196, -122.466109659047) | ||
| 1571 | 1571 | 19004 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3080X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000063.0 | 2115465.0 | 37.7886658330885 | -122.44361852594999 | (37.7886658330885, -122.44361852595) | |||
| 1656 | 1656 | 9731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.42359898745899 | (37.7794635560295, -122.423598987459) | |||
| 1711 | 1711 | 233792 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 628 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780007 | 6002673.122880001 | 2108886.30409 | 37.7707509019602 | -122.434117422087 | (37.7707509019602, -122.434117422087) | |
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1854 | 1854 | 58389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1364 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2016 12:00:00 AM | 3 | Permit Number 776620 | 6006427.83864 | 2119405.514 | 37.799846446913705 | -122.42187710853999 | (37.7998464469137, -122.42187710854) | ||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 2001 | 2001 | 141165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 1 | Width 0ft | 6002136.302999999 | 2113271.8343 | 37.7827619879541 | -122.436288194942 | (37.7827619879541, -122.436288194942) | ||
| 2576 | 2576 | 247475 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | 11 | Width 0ft | Permit Number 38697 | 6002266.1755 | 2109683.5253 | 37.7729167694499 | -122.435582100921 | (37.7729167694499, -122.435582100921) | |
| 2601 | 2601 | 8737 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997009.0435 | 2113012.7724 | 37.781758017625705 | -122.454007533534 | (37.7817580176257, -122.454007533534) | |||
| 2619 | 2619 | 139012 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2569 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000213.2565 | 2114045.1151 | 37.7847757661737 | -122.442996653485 | (37.7847757661737, -122.442996653485) | |||
| 2706 | 2706 | 233690 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3920 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/1987 12:00:00 AM | 7 | Width 3ft | Permit Number 24467 | 6004362.33659 | 2101340.9487400004 | 37.7501288754449 | -122.427736705194 | (37.7501288754449, -122.427736705194) | |
| 2762 | 2762 | 210764 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1499 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1987 12:00:00 AM | 15 | Width 3ft | Permit Number 24541 | 5994579.33292 | 2105376.6403099997 | 37.7606515981079 | -122.46185925530001 | (37.7606515981079, -122.4618592553) | |
| 2792 | 2792 | 17890 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2237 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003209.8546 | 2115154.5824 | 37.7879924771756 | -122.432708698198 | (37.7879924771756, -122.432708698198) | |||
| 2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
| 3109 | 3109 | 19037 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3235 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999309.28069 | 2115314.23141 | 37.788208846394895 | -122.446215424205 | (37.7882088463949, -122.446215424205) | |||
| 3402 | 3402 | 253446 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1339 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1992 12:00:00 AM | 3x3 | 6002186.0 | 2113207.0 | 37.7825867929513 | -122.43611162356399 | (37.7825867929513, -122.436111623564) | |||
| 3422 | 3422 | 17740 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1347 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Health Dept 8 | 12/04/1982 12:00:00 AM | 6 | 3X3 | 6002203.7996 | 2113272.0173 | 37.7827663252153 | -122.436054698673 | (37.7827663252153, -122.436054698673) | ||
| 3427 | 3427 | 11134 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.41985060413299 | (37.8035840176492, -122.419850604133) | |||
| 3468 | 3468 | 18831 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2001 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005118.6821099995 | 2116122.7244599997 | 37.79075882281 | -122.426173443361 | (37.79075882281, -122.426173443361) | |||
| 3623 | 3623 | 101130 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1477 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x3 | Permit Number 769344 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||
| 3640 | 3640 | 9732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | ||
| 3887 | 3887 | 233176 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 10 | Width 3ft | Permit Number 14045 | 5999260.53687 | 2106690.2118599997 | 37.7645267156554 | -122.445763615616 | (37.7645267156554, -122.445763615616) | |
| 4341 | 4341 | 13314 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3179X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999566.13783 | 2115354.5120599996 | 37.7883341120707 | -122.445329642351 | (37.7883341120707, -122.445329642351) | |||
| 4559 | 4559 | 132044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2002 12:00:00 AM | 7 | Width 4ft | 6012372.27446 | 2117831.7295 | 37.795858655114 | -122.401196364438 | (37.795858655114, -122.401196364438) | ||
| 4708 | 4708 | 253663 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4710 | 4710 | 253661 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 715 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999814.0 | 2107879.0 | 37.767822415683796 | -122.443934762725 | (37.7678224156838, -122.443934762725) | ||||
| 4781 | 4781 | 244068 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 414 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998440.5999 | 2109109.2833 | 37.771122022546294 | -122.448773795857 | (37.7711220225463, -122.448773795857) | |||
| 4790 | 4790 | 158406 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | |
| 4877 | 4877 | 55287 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1262 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1972 12:00:00 AM | 8 | 3x3 | Permit Number 11213 | 5988342.6659 | 2106727.2678 | 37.76399904444129 | -122.483527825437 | (37.7639990444413, -122.483527825437) | |
| 4996 | 4996 | 7951 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1740 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 12 | 3X3 | 6005752.06301 | 2116078.7697900003 | 37.790673913324795 | -122.42397884754801 | (37.7906739133248, -122.423978847548) | ||
| 5042 | 5042 | 13051 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 548 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:01:00 PM | 3 | 3x3 | 6009711.5863 | 2120552.0553 | 37.803179205163005 | -122.410595078527 | (37.803179205163, -122.410595078527) | ||
| 5264 | 5264 | 17885 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2214 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003222.3202 | 2115211.247 | 37.788148770729705 | -122.43266961876499 | (37.7881487707297, -122.432669618765) | |||
| 5320 | 5320 | 19014 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3122 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999831.14019 | 2115437.85116 | 37.788578063082106 | -122.44441877212401 | (37.7885780630821, -122.444418772124) | |||
| 5347 | 5347 | 18998 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3009 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6000320.39642 | 2115456.92187 | 37.788658329372396 | -122.442727394678 | (37.7886583293724, -122.442727394678) | ||
| 5357 | 5357 | 18911 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2608 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002198.68531 | 2115767.74163 | 37.7896186569185 | -122.436251055535 | (37.7896186569185, -122.436251055535) | |||
| 5418 | 5418 | 19000 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3042 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000225.4751699995 | 2115493.68766 | 37.7887538670327 | -122.44305844861401 | (37.7887538670327, -122.443058448614) | |||
| 5487 | 5487 | 17190 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1804X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4X4 | 6004839.2103 | 2115093.1205 | 37.7879159889562 | -122.427067036821 | (37.7879159889562, -122.427067036821) | |||
| 5539 | 5539 | 17884 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2210 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003260.8806 | 2115214.139 | 37.7881588981801 | -122.43253641314399 | (37.7881588981801, -122.432536413144) | |||
| 5572 | 5572 | 19043 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3277 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999143.513780001 | 2115295.23483 | 37.788147218565996 | -122.44678758008499 | (37.788147218566, -122.446787580085) | |||
| 5647 | 5647 | 19035 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3227 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999339.77887 | 2115319.94044 | 37.7882262635735 | -122.446110316852 | (37.7882262635735, -122.446110316852) | |||
| 5831 | 5831 | 18814 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1921 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005353.8734800005 | 2116157.5446599997 | 37.7908677208195 | -122.42536217123501 | (37.7908677208195, -122.425362171235) | |||
| 5862 | 5862 | 9730 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 637 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6005783.8123 | 2111973.7899 | 37.779404445065396 | -122.42357702198099 | (37.7794044450654, -122.423577021981) | |||
| 5864 | 5864 | 17800 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1855 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6005059.342 | 2115410.1523 | 37.788798924352996 | -122.42632800170901 | (37.788798924353, -122.426328001709) | |||
| 5875 | 5875 | 19016 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3147 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999737.62232 | 2115377.53995 | 37.7884071280271 | -122.444737991858 | (37.7884071280271, -122.444737991858) | |||
| 5888 | 5888 | 11169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | |||
| 5914 | 5914 | 18827 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1911 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005492.837780001 | 2116179.1366 | 37.7909348570073 | -122.424882897351 | (37.7909348570073, -122.424882897351) | |||
| 5961 | 5961 | 18819 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1850 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005893.34484 | 2116280.69836 | 37.7912363340264 | -122.423504381436 | (37.7912363340264, -122.423504381436) | |||
| 6026 | 6026 | 13056 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 567 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 07:33:00 AM | 3 | 3X3 | 6009638.2249 | 2120505.3867 | 37.8030469515764 | -122.410845650802 | (37.8030469515764, -122.410845650802) | ||
| 6083 | 6083 | 108032 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 145X Capra Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774212 | 6001036.4090599995 | 2120513.75887 | 37.802583868119896 | -122.440612955426 | (37.8025838681199, -122.440612955426) | ||
| 6132 | 6132 | 11153 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | |||
| 6218 | 6218 | 19042 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3257 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5999209.87226 | 2115305.32061 | 37.7881787020404 | -122.44655871793002 | (37.7881787020404, -122.44655871793) | |||
| 6241 | 6241 | 19036 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3238 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5999312.475430001 | 2115365.10303 | 37.7883487089688 | -122.44620803177 | (37.7883487089688, -122.44620803177) | |||
| 6289 | 6289 | 11171 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.805969514352604 | -122.420334179488 | (37.8059695143526, -122.420334179488) | |||
| 6318 | 6318 | 18908 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2604 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002262.241669999 | 2115774.64436 | 37.7896412209083 | -122.436031651553 | (37.7896412209083, -122.436031651553) | |||
| 6319 | 6319 | 18822 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1865 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005869.22375 | 2116234.13797 | 37.791107129344 | -122.423584528107 | (37.791107129344, -122.423584528107) | |||
| 6388 | 6388 | 17794 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1844 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005100.3317 | 2115473.1057 | 37.7889740955094 | -122.426190666694 | (37.7889740955094, -122.426190666694) | |||
| 6441 | 6441 | 26640 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2616 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1998 12:00:00 AM | 6 | 3X3 | 6002091.06438 | 2115751.37049 | 37.789567590709794 | -122.436622239943 | (37.7895675907098, -122.436622239943) | ||
| 6521 | 6521 | 9725 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005796.9989 | 2111889.3567 | 37.779173356417 | -122.42352539952 | (37.779173356417, -122.42352539952) | |||
| 6564 | 6564 | 17913 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2329 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002782.7895 | 2115098.9315 | 37.7878154446212 | -122.43418228549801 | (37.7878154446212, -122.434182285498) | |||
| 6602 | 6602 | 19040 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3249 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5999255.64905 | 2115310.27739 | 37.7881949266879 | -122.446400695359 | (37.7881949266879, -122.446400695359) | |||
| 6694 | 6694 | 18851 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2195 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004377.36753 | 2116024.81596 | 37.7904480629835 | -122.428731372449 | (37.7904480629835, -122.428731372449) | |||
| 6807 | 6807 | 18828 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1930 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6005538.83813 | 2116230.7825700003 | 37.791079262040604 | -122.424727413533 | (37.7910792620406, -122.424727413533) | |||
| 6828 | 6828 | 11159 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) |
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");