Street_Tree_List

Data source: data.sfgov.org

331 rows where qSpecies = 83

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
451 192346 Planning Code 138.1 required 4 Fraxinus spp :: Ash Spp 83 118 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/2014 12:00:00 AM 1 Width 3ft Permit Number 770901 6007994.19176 2110350.5452799997 37.7750719195804 -122.41581539288201 (37.7750719195804, -122.415815392882)
1810 251708 Permitted Site 1 Fraxinus spp :: Ash Spp 83 239 10th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM   3x3 Permit Number 776109 6008639.31193 2109768.7769299997 37.7735107666471 -122.413542618094 (37.7735107666471, -122.413542618094)
2265 252991 Undocumented 2 Fraxinus spp :: Ash Spp 83 65 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005528.0 2099293.0 37.7445715466522 -122.423560184697 (37.7445715466522, -122.423560184697)
4450 225795 Undocumented 2 Fraxinus spp :: Ash Spp 83 3000X 21st St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008004.64414 2103879.4657900003 37.7573044302625 -122.415321039155 (37.7573044302625, -122.415321039155)
4515 225797 Undocumented 2 Fraxinus spp :: Ash Spp 83 3000X 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008067.53952 2103885.7722400003 37.75732528104621 -122.41510396797301 (37.7573252810462, -122.415103967973)
4518 225796 Undocumented 2 Fraxinus spp :: Ash Spp 83 3000X 21st St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008035.828509999 2103884.08468 37.7573188652869 -122.415213517995 (37.7573188652869, -122.415213517995)
4521 225798 Undocumented 2 Fraxinus spp :: Ash Spp 83 3000X 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008119.80842 2103888.79141 37.757336508198705 -122.414923414683 (37.7573365081987, -122.414923414683)
7259 23270 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 843X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2     24 3X3   6006591.05831 2113351.86982 37.783233848997 -122.42088227939101 (37.783233848997, -122.420882279391)
7849 23269 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 843X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     24 3X3   6006584.636609999 2113380.90993 37.7833132240722 -122.42090655840201 (37.7833132240722, -122.420906558402)
8020 2680 Permitted Site 1 Fraxinus spp :: Ash Spp 83 2085 Bush St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/17/2015 12:00:00 AM 19 3X3   6003616.3325 2114868.6836 37.7872305155325 -122.43128194219 (37.7872305155325, -122.43128194219)
8049 23281 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 843X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2     25 3X3   6006558.1517199995 2113495.8441 37.7836273122865 -122.42100634895901 (37.7836273122865, -122.421006348959)
13842 25983 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 1901 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x2   6013395.85675 2096673.78587 37.7378206945684 -122.396170987024 (37.7378206945684, -122.396170987024)
14010 29020 Permitted Site 1 Fraxinus spp :: Ash Spp 83 154 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008187.55893 2110147.28508 37.774524683913896 -122.41513210056401 (37.7745246839139, -122.415132100564)
14020 28999 Permitted Site 1 Fraxinus spp :: Ash Spp 83 241 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 3 3x3   6008639.31193 2109768.7769299997 37.7735107666471 -122.413542618094 (37.7735107666471, -122.413542618094)
14043 29025 Permitted Site 1 Fraxinus spp :: Ash Spp 83 250 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008614.8600699995 2109695.18627 37.77330733098729 -122.413621994964 (37.7733073309873, -122.413621994964)
14366 29008 Permitted Site 1 Fraxinus spp :: Ash Spp 83 123 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008118.46736 2110307.2661 37.774960070880496 -122.415382430453 (37.7749600708805, -122.415382430453)
14443 25984 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 1901 Oakdale Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2x2   6013408.21183 2096665.5323700001 37.7377987196205 -122.396127690947 (37.7377987196205, -122.396127690947)
14507 29010 Permitted Site 1 Fraxinus spp :: Ash Spp 83 113 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008095.190140001 2110335.0874799998 37.7750351534761 -122.415464921674 (37.7750351534761, -122.415464921674)
14608 29018 Permitted Site 1 Fraxinus spp :: Ash Spp 83 128 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008069.48566 2110276.86185 37.774873834897 -122.41554971607 (37.774873834897, -122.41554971607)
14816 29032 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 330 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/19/2015 02:58:00 PM 3 3x3   6008959.5053199995 2109339.54752 37.7723501771487 -122.412404672648 (37.7723501771487, -122.412404672648)
15152 29034 Permitted Site 1 Fraxinus spp :: Ash Spp 83 358 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6009078.53506 2109215.83285 37.7720171644901 -122.411984191933 (37.7720171644901, -122.411984191933)
15223 29006 Permitted Site 1 Fraxinus spp :: Ash Spp 83 135 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008170.1889 2110256.9147 37.774824724723395 -122.415199949027 (37.7748247247234, -122.415199949027)
15761 29004 Permitted Site 1 Fraxinus spp :: Ash Spp 83 151 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6008239.15145 2110183.90276 37.7746281266267 -122.41495622374399 (37.7746281266267, -122.414956223744)
16199 29033 Permitted Site 1 Fraxinus spp :: Ash Spp 83 340 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/27/2005 12:00:00 AM 6 3x3   6009042.97746 2109247.69972 37.772102668444 -122.412109441391 (37.772102668444, -122.412109441391)
18965 16628 Permitted Site 1 Fraxinus spp :: Ash Spp 83 147 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2006 12:00:00 AM 12 3X3   6002889.82891 2107449.635 37.766818457119896 -122.433265159761 (37.7668184571199, -122.433265159761)
19707 16635 Permitted Site 1 Fraxinus spp :: Ash Spp 83 153 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6002890.76164 2107366.51768 37.766590290141394 -122.43325599389 (37.7665902901414, -122.43325599389)
19824 16637 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 159 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3X3   6002887.79495 2107329.82108 37.7664893619256 -122.433263632733 (37.7664893619256, -122.433263632733)
21141 16624 DPW Maintained 3 Fraxinus spp :: Ash Spp 83 143 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 5x5   6002878.48419 2107471.6414099997 37.7668782377669 -122.43330597190001 (37.7668782377669, -122.4333059719)
23787 192299 Undocumented 2 Fraxinus spp :: Ash Spp 83 2250 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6011852.1113599995 2102354.12957 37.7533316805221 -122.401907686797 (37.7533316805221, -122.401907686797)
23985 192353 Undocumented 2 Fraxinus spp :: Ash Spp 83 1500 Minnesota St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 2ft   6015367.9403099995 2101545.1725 37.7513060448498 -122.38969261993 (37.7513060448498, -122.38969261993)
24702 192280 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009110.344190001 2108839.3922200003 37.7709853309346 -122.411847556143 (37.7709853309346, -122.411847556143)
25212 192295 Undocumented 2 Fraxinus spp :: Ash Spp 83 551 Utah St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6010700.612380001 2105651.26498 37.7623205464704 -122.406122099663 (37.7623205464704, -122.406122099663)
25322 192237 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009520.068659999 2108454.52562 37.7699515539505 -122.410403121719 (37.7699515539505, -122.410403121719)
25338 225387 Undocumented 2 Fraxinus spp :: Ash Spp 83 300 Chattanooga St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6004770.30193 2101839.2583 37.7515201869079 -122.426361411567 (37.7515201869079, -122.426361411567)
25376 192340 Undocumented 2 Fraxinus spp :: Ash Spp 83 10 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6007835.1568599995 2110517.0734099997 37.7755202244095 -122.416377328869 (37.7755202244095, -122.416377328869)
25993 192209 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009355.45651 2108925.4652 37.7712354153226 -122.41100578260401 (37.7712354153226, -122.411005782604)
26010 59099 Permitted Site 1 Fraxinus spp :: Ash Spp 83 488 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 13   Permit Number 18401 5993459.272919999 2112191.2837799997 37.7792982564624 -122.46622825483101 (37.7792982564624, -122.466228254831)
27042 128824 Undocumented 2 Fraxinus spp :: Ash Spp 83 600 Market St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6011998.07084 2115236.9646099997 37.7887131646294 -122.40230865672301 (37.7887131646294, -122.402308656723)
27145 192211 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6009388.568940001 2108888.9656700003 37.7711370528685 -122.410888666597 (37.7711370528685, -122.410888666597)
28167 192309 Undocumented 2 Fraxinus spp :: Ash Spp 83 100 De Haro St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 4ft   6011943.7523300005 2107376.90821 37.767128230416105 -122.401943831469 (37.7671282304161, -122.401943831469)
28457 192322 Undocumented 2 Fraxinus spp :: Ash Spp 83 193 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6011704.5689199995 2107781.11389 37.7682247360183 -122.40279956606301 (37.7682247360183, -122.402799566063)
28861 192349 Undocumented 2 Fraxinus spp :: Ash Spp 83 262 10th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008725.32275 2109583.20667 37.773006063508504 -122.413231967974 (37.7730060635085, -122.413231967974)
28875 109474 Undocumented 2 Fraxinus spp :: Ash Spp 83 300 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6012029.14391 2118799.20085 37.7984959502925 -122.402451729872 (37.7984959502925, -122.402451729872)
29899 192224 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 22 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009548.42342 2108726.25306 37.770699244008895 -122.410324231382 (37.7706992440089, -122.410324231382)
30042 192221 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009500.9778 2108774.7519400003 37.7708297509354 -122.41049177239599 (37.7708297509354, -122.410491772396)
30174 225388 Undocumented 2 Fraxinus spp :: Ash Spp 83 306 Chattanooga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   6004766.979119999 2101818.89406 37.751464083609996 -122.426371452475 (37.75146408361, -122.426371452475)
30684 192318 Undocumented 2 Fraxinus spp :: Ash Spp 83 195 Rhode Island St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6011708.94846 2107685.56864 37.7679626349073 -122.402777697245 (37.7679626349073, -122.402777697245)
32277 218975 Undocumented 2 Fraxinus spp :: Ash Spp 83 25 Lakewood Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5993599.79076 2092994.2198700001 37.726596156286504 -122.464347997761 (37.7265961562865, -122.464347997761)
32326 225783 Undocumented 2 Fraxinus spp :: Ash Spp 83 3251 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6007765.10393 2105579.72042 37.7619594722828 -122.416269885947 (37.7619594722828, -122.416269885947)
32509 192275 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009036.05094 2108770.66843 37.7707924632209 -122.412099681957 (37.7707924632209, -122.412099681957)
33085 109480 Undocumented 2 Fraxinus spp :: Ash Spp 83 300 Broadway 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6011947.44314 2118785.89715 37.7984548602505 -122.402733505447 (37.7984548602505, -122.402733505447)
33435 192252 Undocumented 2 Fraxinus spp :: Ash Spp 83 450 11th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009308.54371 2108355.35398 37.7696673915621 -122.411127779219 (37.7696673915621, -122.411127779219)
33563 192305 Undocumented 2 Fraxinus spp :: Ash Spp 83 2599 Mariposa St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009925.06485 2105936.96188 37.763061595931894 -122.40882459747 (37.7630615959319, -122.40882459747)
33903 225779 Undocumented 2 Fraxinus spp :: Ash Spp 83 1559 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5999770.51083 2107118.5981099997 37.765732061717294 -122.44403054288901 (37.7657320617173, -122.444030542889)
34034 128825 Undocumented 2 Fraxinus spp :: Ash Spp 83 600 Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6011989.53481 2115248.11567 37.7887433063148 -122.40233897468399 (37.7887433063148, -122.402338974684)
34313 192355 Undocumented 2 Fraxinus spp :: Ash Spp 83 1400 Quint St 2 : 4 Tree 1 Private 1     13 Width 1ft   6013376.06433 2096591.73652 37.7375943028269 -122.39623367064199 (37.7375943028269, -122.396233670642)
34317 192232 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009598.466630001 2108528.5531599997 37.7701592110077 -122.41013717060899 (37.7701592110077, -122.410137170609)
34513 192213 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009411.17621 2108867.66587 37.7710798361979 -122.410808962379 (37.7710798361979, -122.410808962379)
35877 192283 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009158.56943 2108886.63938 37.7711177659971 -122.411684081879 (37.7711177659971, -122.411684081879)
36050 120307 Undocumented 2 Fraxinus spp :: Ash Spp 83 100 23rd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   5988691.32321 2114547.3374400004 37.785491068319395 -122.482895098939 (37.7854910683194, -122.482895098939)
36159 192290 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009249.88348 2108971.40543 37.771355635782704 -122.411374211455 (37.7713556357827, -122.411374211455)
36227 225787 Undocumented 2 Fraxinus spp :: Ash Spp 83 46 Bosworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6004400.603180001 2095343.96322 37.7336646890731 -122.42717726484 (37.7336646890731, -122.42717726484)
37040 248584 Undocumented 2 Fraxinus spp :: Ash Spp 83 784 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5998013.4865 2107655.5885 37.7671061143032 -122.450146392184 (37.7671061143032, -122.450146392184)
37426 192216 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009448.92717 2108828.0279599996 37.7709731163511 -122.410675580336 (37.7709731163511, -122.410675580336)
38564 192200 Undocumented 2 Fraxinus spp :: Ash Spp 83 326 10th St 0 : 4 Tree 1 Private 1     7 Width 3ft   6008879.18119 2109418.2333 37.7725617219648 -122.41268808588998 (37.7725617219648, -122.41268808589)
38913 192279 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009094.0417599995 2108824.03792 37.7709422570085 -122.411902861747 (37.7709422570085, -122.411902861747)
40032 45645 Permitted Site 1 Fraxinus spp :: Ash Spp 83 1020 Kearny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/14/2001 12:00:00 AM 10   Permit Number 44346 6011201.4795699995 2118401.58307 37.7973579490636 -122.40528770508999 (37.7973579490636, -122.40528770509)
40148 225812 Undocumented 2 Fraxinus spp :: Ash Spp 83 197 Noe St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     29 Width 3ft   6002912.30789 2107203.01713 37.7661425797454 -122.43316978576999 (37.7661425797454, -122.43316978577)
40346 128822 Undocumented 2 Fraxinus spp :: Ash Spp 83 250 Broadway 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6012208.0631 2118824.10156 37.798574308201204 -122.401834361485 (37.7985743082012, -122.401834361485)
40518 192261 Undocumented 2 Fraxinus spp :: Ash Spp 83 450 11th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009200.74359 2108465.0274400003 37.769962483400796 -122.41150840741001 (37.7699624834008, -122.41150840741)
40753 192274 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009024.55442 2108760.36704 37.770763532946795 -122.412138720645 (37.7707635329468, -122.412138720645)
40849 225810 Undocumented 2 Fraxinus spp :: Ash Spp 83 197 Noe St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     27 Width 3ft   6002901.372830001 2107162.40051 37.766030436082794 -122.433204705528 (37.7660304360828, -122.433204705528)
41323 192218 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009470.84858 2108807.6783 37.770918469946295 -122.410598315981 (37.7709184699463, -122.410598315981)
42094 192240 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009484.38016 2108422.4744 37.7698615480128 -122.41052430446001 (37.7698615480128, -122.41052430446)
42728 192205 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009311.714459999 2108971.0789 37.7713582069357 -122.411160311315 (37.7713582069357, -122.411160311315)
42776 225811 Undocumented 2 Fraxinus spp :: Ash Spp 83 197 Noe St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 3ft   6002903.222130001 2107175.55757 37.766066667072 -122.43319924936701 (37.766066667072, -122.433199249367)
42948 128819 Undocumented 2 Fraxinus spp :: Ash Spp 83 99 Leavenworth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 4ft   6008597.39864 2112731.9069 37.7816444645714 -122.41389725225001 (37.7816444645714, -122.41389725225)
43494 192247 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 19 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6009385.61181 2108329.66334 37.76960117269039 -122.410859387372 (37.7696011726904, -122.410859387372)
43682 225786 Undocumented 2 Fraxinus spp :: Ash Spp 83 94 Hill St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005786.7967300005 2103464.50998 37.7560401588409 -122.422961744009 (37.7560401588409, -122.422961744009)
44739 192244 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009411.93836 2108352.3057 37.7696648195127 -122.410769923705 (37.7696648195127, -122.410769923705)
45431 192262 Undocumented 2 Fraxinus spp :: Ash Spp 83 450 11th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009184.592680001 2108480.10836 37.770002986167604 -122.41156533898999 (37.7700029861676, -122.41156533899)
45528 59144 Permitted Site 1 Fraxinus spp :: Ash Spp 83 690 12th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/23/1980 12:00:00 AM 10   Permit Number 18451 5992269.28731 2110774.7292400002 37.775340052701104 -122.470241689466 (37.7753400527011, -122.470241689466)
45941 120305 Undocumented 2 Fraxinus spp :: Ash Spp 83 100 23rd Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 6ft   5988689.97406 2114597.66035 37.7856291622608 -122.48290345597601 (37.7856291622608, -122.482903455976)
46017 192334 Undocumented 2 Fraxinus spp :: Ash Spp 83 65 10th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6007885.81479 2110555.97346 37.775629883255796 -122.416204846094 (37.7756298832558, -122.416204846094)
46347 192248 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 20 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009375.77946 2108320.2642200002 37.7695748135605 -122.410892733326 (37.7695748135605, -122.410892733326)
46407 192330 Undocumented 2 Fraxinus spp :: Ash Spp 83 113 10th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6008064.12185 2110370.6241900004 37.775130982543004 -122.41557491054701 (37.775130982543, -122.415574910547)
46622 248136 Undocumented 2 Fraxinus spp :: Ash Spp 83 226 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6010037.88024 2099520.31318 37.745449227116204 -122.407981876971 (37.7454492271162, -122.407981876971)
47218 192303 Undocumented 2 Fraxinus spp :: Ash Spp 83 2250 24th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6011758.176530001 2102347.8311400004 37.753309143502605 -122.402232092032 (37.7533091435026, -122.402232092032)
47641 75888 Undocumented 2 Fraxinus spp :: Ash Spp 83 350 Broadway 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1995 12:00:00 AM 13     6011802.87578 2118766.0417 37.7983922692391 -122.40323235850501 (37.7983922692391, -122.403232358505)
48659 75815 Undocumented 2 Fraxinus spp :: Ash Spp 83 350 Broadway 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1995 12:00:00 AM 7     6011743.63854 2118757.50225 37.7983655135139 -122.403436737532 (37.7983655135139, -122.403436737532)
49533 192344 Undocumented 2 Fraxinus spp :: Ash Spp 83 10 10th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6007890.6883 2110458.72798 37.7753631443241 -122.41618109859199 (37.7753631443241, -122.416181098592)
49592 11636 Permitted Site 1 Fraxinus spp :: Ash Spp 83 499X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     12 3   5991474.53212 2093889.5616418 37.7289318087747 -122.471760091134 (37.7289318087747, -122.471760091134)
49946 192325 Undocumented 2 Fraxinus spp :: Ash Spp 83 193 Rhode Island St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6011700.9501 2107853.89642 37.768424378313206 -122.40281720266199 (37.7684243783132, -122.402817202662)
50297 192239 Undocumented 2 Fraxinus spp :: Ash Spp 83 1192 Bryant St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009494.20262 2108431.40539 37.769886621106295 -122.410490959396 (37.7698866211063, -122.410490959396)
50532 225778 Undocumented 2 Fraxinus spp :: Ash Spp 83 924 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5998777.438569999 2106776.2154 37.7647352648411 -122.447440705541 (37.7647352648411, -122.447440705541)
50544 192292 Undocumented 2 Fraxinus spp :: Ash Spp 83 1490 Harrison St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009264.77057 2108986.5542200003 37.7713980657949 -122.41132378646499 (37.7713980657949, -122.411323786465)
51334 192264 Undocumented 2 Fraxinus spp :: Ash Spp 83 450 11th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6009152.13248 2108514.01976 37.7700942781534 -122.41168001514299 (37.7700942781534, -122.411680015143)
52799 192306 Undocumented 2 Fraxinus spp :: Ash Spp 83 3600 03rd St 4 : 4 Tree 1 Private 1     21 Width 5ft   6015896.02327 2098855.55467 37.74395018136929 -122.38767879773701 (37.7439501813693, -122.387678797737)
52957 192223 Undocumented 2 Fraxinus spp :: Ash Spp 83 340 10th St 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009532.03276 2108741.1041599996 37.77073910287 -122.410381975954 (37.77073910287, -122.410381975954)
53357 128808 Undocumented 2 Fraxinus spp :: Ash Spp 83 2501 Jackson St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6001383.33039 2116587.25055 37.7918224564007 -122.439130852904 (37.7918224564007, -122.439130852904)

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 82.152ms · Data source: data.sfgov.org