Street_Tree_List

Data source: data.sfgov.org

3,645 rows where qSpecies = 41

View and edit SQL

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
113 183695 Permitted Site 1 Olea europaea :: Olive Tree 41 1341 42nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983048.7244 2105854.1384 37.7612921278024 -122.50177309900499 (37.7612921278024, -122.501773099005)
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 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)
261 141359 Undocumented 2 Olea europaea :: Olive Tree 41 1499X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
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 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 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 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)
557 194124 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 3 Sidewalk: Curb side : Hanging Pot 15 Tree 1 Private 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
569 194126 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
572 194125 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
573 194127 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
574 194128 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
575 194123 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
587 233050 Undocumented 2 Olea europaea :: Olive Tree 41 3181 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2011 12:00:00 AM 3 Width 3ft   6007759.16475 2102654.84325 37.7539280965303 -122.416083280221 (37.7539280965303, -122.416083280221)
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 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 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 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 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 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)
1301 245837 Permitted Site 1 Olea europaea :: Olive Tree 41 451 Fell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/24/1995 12:00:00 AM 3 Width 0ft   6005362.4532 2110596.2894 37.775598372260106 -122.424936650191 (37.7755983722601, -122.424936650191)
1374 97285 Permitted Site 1 Olea europaea :: Olive Tree 41 2321 Webster St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773461 6003155.0 2116788.0 37.7924743139296 -122.433015230869 (37.7924743139296, -122.433015230869)
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)
1557 251590 Undocumented 2 Olea europaea :: Olive Tree 41 340x Vicente St 3 Front Yard : Yard 7 Tree 1 Private 1       3x3   5991910.0 2097743.0 37.739537567792894 -122.47053520105601 (37.7395375677929, -122.470535201056)
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 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 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)
1693 251659 Significant Tree 6 Olea europaea :: Olive Tree 41 1050 North Point St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1702 251658 Significant Tree 6 Olea europaea :: Olive Tree 41 1050 North Point St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
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 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)
1745 17972 DPW Maintained 3 Olea europaea :: Olive Tree 41 2515 Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6001748.1253 2114954.2725 37.7873594702652 -122.437751658759 (37.7873594702652, -122.437751658759)
1778 17971 DPW Maintained 3 Olea europaea :: Olive Tree 41 2515 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3x3   6001715.6676 2114951.5677 37.7873501979521 -122.437863761621 (37.7873501979521, -122.437863761621)
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 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)
1980 11144 Permitted Site 1 Olea europaea :: Olive Tree 41 2553X Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     36 3X3   6006934.8566 2121129.59308 37.8046089111446 -122.42024506476801 (37.8046089111446, -122.420245064768)
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)
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 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 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)
2237 17958 DPW Maintained 3 Olea europaea :: Olive Tree 41 2500 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1992 12:00:00 AM 6 3x3   6001912.0842 2115029.0126 37.7875740088989 -122.437189749529 (37.7875740088989, -122.437189749529)
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)
2596 253141 Undocumented 2 Olea europaea :: Olive Tree 41 40 Brady St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2597 253140 Undocumented 2 Olea europaea :: Olive Tree 41 40 Brady St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
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)
2602 253139 Undocumented 2 Olea europaea :: Olive Tree 41 40 Brady St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2604 253137 Undocumented 2 Olea europaea :: Olive Tree 41 40 Brady St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
2605 253138 Undocumented 2 Olea europaea :: Olive Tree 41 40 Brady St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 2ft   6006614.59932 2109591.90022 37.7729112084036 -122.42053385147 (37.7729112084036, -122.42053385147)
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)
2684 233816 Undocumented 2 Olea europaea :: Olive Tree 41 41 Brady St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6006595.43726 2109656.08938 37.7730863765667 -122.420604692871 (37.7730863765667, -122.420604692871)
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 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 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)
2894 17961 Permitted Site 1 Olea europaea :: Olive Tree 41 2501 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6001809.5629 2114963.9325 37.7873894873509 -122.437539789894 (37.7873894873509, -122.437539789894)
2931 93638 Permitted Site 1 Olea europaea :: Olive Tree 41 1603 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 2x2   6000053.4052 2110559.6245 37.7751963877973 -122.44329925092501 (37.7751963877973, -122.443299250925)
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 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)
3162 11135 DPW Maintained 3 Olea europaea :: Olive Tree 41 2454 Hyde St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     45 3X3   6007038.94291 2120769.9344599997 37.8036272444521 -122.41985932665199 (37.8036272444521, -122.419859326652)
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 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 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 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)
3486 39483 Permitted Site 1 Olea europaea :: Olive Tree 41 0 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/1998 12:00:00 AM     Permit Number 40941          
3589 11167 Permitted Site 1 Olea europaea :: Olive Tree 41 2655 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3X3   6006899.01173 2121433.76541 37.805442070952 -122.42039071266501 (37.805442070952, -122.420390712665)
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 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)
3680 9726 DPW Maintained 3 Olea europaea :: Olive Tree 41 621 Gough St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4x4   6005799.3606 2111864.1645 37.779104318085295 -122.42351543791099 (37.7791043180853, -122.423515437911)
3750 253551 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 19 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:40:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3758 253548 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 16 Back Yard : Yard 13 Tree 1 DPW 2   09/22/2017 04:31:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3837 253550 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 18 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:43:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3840 253546 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 14 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:50:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3841 253549 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 17 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3842 253547 DPW Maintained 3 Olea europaea :: Olive Tree 41 1000 Cayuga Ave 15 Back Yard : Yard 13 Tree 1 DPW 2   09/27/2017 11:40:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
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 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 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)
4698 253662 Undocumented 2 Olea europaea :: Olive Tree 41 715 Buena Vista Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4701 253665 Undocumented 2 Olea europaea :: Olive Tree 41 715 Buena Vista Ave 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
4707 253664 Undocumented 2 Olea europaea :: Olive Tree 41 715 Buena Vista Ave 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5999814.0 2107879.0 37.767822415683796 -122.443934762725 (37.7678224156838, -122.443934762725)
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 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 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 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 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)
4914 6236 DPW Maintained 3 Olea europaea :: Olive Tree 41 1250 Ellis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/12/1995 12:00:00 AM 12 3X3   6004877.1927 2113359.8717 37.78315906739 -122.42681214119499 (37.78315906739, -122.426812141195)
4949 83043 Private 5 Olea europaea :: Olive Tree 41 100X Cargo Way 9 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/18/2017 02:49:00 PM 3     6018760.2720099995 2097656.0724299997 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139)
4990 3550 DPW Maintained 3 Olea europaea :: Olive Tree 41 201X Cargo Way 60 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/1990 12:00:00 AM 6 3X3   6018708.52549 2097590.55589 37.7406321362531 -122.377865918974 (37.7406321362531, -122.377865918974)
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 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 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 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)
5329 19019 Permitted Site 1 Olea europaea :: Olive Tree 41 3150 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Public Library 14     18 3X3   5999711.09845 2115422.68298 37.788529565338 -122.444833006162 (37.788529565338, -122.444833006162)
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 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 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)
5480 87732 DPW Maintained 3 Olea europaea :: Olive Tree 41 3200X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2   05/10/2008 12:00:00 AM 3 4x4   6005468.85489 2121438.02655 37.8053730758726 -122.425340270033 (37.8053730758726, -122.425340270033)
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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1607.966ms · Data source: data.sfgov.org