Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
3018 3018 128709 Permitted Site 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4x Columbus Ave 1 Median : Yard 3 Tree 1 Private 1     19 Width 9ft   6011726.08303 2117794.9108 37.795721488711294 -122.403429729102 (37.7957214887113, -122.403429729102)
25864 25864 211289 DPW Maintained 3 Pinus thunbergii :: Japanese Black Pine 306 100x Idora Ave 8 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995366.53481 2099407.6063200003 37.744307426259205 -122.45870456127399 (37.7443074262592, -122.458704561274)
26492 26492 242374 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006546.0037 2109148.1970900004 37.771689039651896 -122.42073962714899 (37.7716890396519, -122.420739627149)
27503 27503 208879 DPW Maintained 3 Malus :: Crab Apple 235 100x Idora Ave 19 Median : Yard 3 Tree 1 DPW 2     7 Width 9ft   5995727.40355 2099320.3409700003 37.74408855195821 -122.457450449475 (37.7440885519582, -122.457450449475)
28868 28868 208175 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1000x Lawton St 3 Median : Yard 3 Tree 1 DPW 2     1 Width 9ft   5991060.8036 2104516.28775 37.758086113802904 -122.473965364836 (37.7580861138029, -122.473965364836)
37375 37375 211161 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 17 Median : Yard 3 Tree 1 DPW 2     41 Width 9ft   5995684.4738300005 2099331.0800900003 37.7441155729727 -122.45759966680599 (37.7441155729727, -122.457599666806)
38489 38489 214330 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 12 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995527.4625 2099368.48178 37.7442092481691 -122.458145280077 (37.7442092481691, -122.458145280077)
44924 44924 217728 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 100x Lincoln Way 3 Median : Yard 3 Tree 1 DPW 2     10 Width 9ft   5995225.13962 2107407.04812 37.766263730121004 -122.45977279128901 (37.766263730121, -122.459772791289)
50547 50547 211162 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 21 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995762.15632 2099312.39681 37.744068735376295 -122.457329708294 (37.7440687353763, -122.457329708294)
51364 51364 214329 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 11 Median : Yard 3 Tree 1 DPW 2     11 Width 9ft   5995487.46893 2099377.84768 37.744232666505106 -122.45828424602301 (37.7442326665051, -122.458284246023)
57260 57260 242793 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2x Coso Ave 1 Median : Yard 3 Tree 1 DPW 2     30 Width 9ft   6007083.58829 2099965.0449 37.746504513177 -122.418228897148 (37.746504513177, -122.418228897148)
60126 60126 205301 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 100x Idora Ave 16 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   5995644.80929 2099340.4392 37.7441389922109 -122.45773749420799 (37.7441389922109, -122.457737494208)
65522 65522 205300 DPW Maintained 3 Cordyline australis :: Dracena Palm 141 100x Idora Ave 15 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   5995637.606269999 2099342.55805 37.7441443962476 -122.457762553794 (37.7441443962476, -122.457762553794)
67961 67961 206836 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 14 Median : Yard 3 Tree 1 DPW 2     66 Width 9ft   5995604.17085 2099350.4744700002 37.7441642119029 -122.45787873812799 (37.7441642119029, -122.457878738128)
73631 73631 211163 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Idora Ave 24 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   5995808.0564 2099301.9235400003 37.744042614569295 -122.45717023961001 (37.7440426145693, -122.45717023961)
115432 115432 210682 DPW Maintained 3 Olea europaea :: Olive Tree 41 100x Idora Ave 6 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   5995339.29404 2099412.4410200003 37.7443191354124 -122.4587991034 (37.7443191354124, -122.4587991034)
134715 134715 211077 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 100x Idora Ave 9 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995433.6180300005 2099390.76131 37.7442650295015 -122.45847138416799 (37.7442650295015, -122.458471384168)
136941 136941 211477 DPW Maintained 3 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 100x Idora Ave 10 Median : Yard 3 Tree 1 DPW 2     37 Width 9ft   5995466.33774 2099382.46662 37.7442441346666 -122.45835764690001 (37.7442441346666, -122.4583576469)
137327 137327 214332 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 18 Median : Yard 3 Tree 1 DPW 2     9 Width 9ft   5995718.21124 2099321.8453599997 37.7440921546362 -122.457482343055 (37.7440921546362, -122.457482343055)
146356 146356 199366 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 5 Median : Yard 3 Tree 1 DPW 2     28 Width 9ft   6009946.07759 2108167.65587 37.769187748042704 -122.40890931543801 (37.7691877480427, -122.408909315438)
146780 146780 214408 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 100x Idora Ave 20 Median : Yard 3 Tree 1 DPW 2     3 Width 9ft   5995751.653580001 2099314.25679 37.7440732391823 -122.457366158726 (37.7440732391823, -122.457366158726)
148511 148511 212576 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100x Idora Ave 7 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995353.74805 2099410.49817 37.74431463161879 -122.458748984199 (37.7443146316188, -122.458748984199)
160927 160927 242373 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 2x McCoppin St 1 Median : Yard 3 Tree 1 DPW 2     5 Width 9ft   6006573.34583 2109150.3275 37.771696430266 -122.420645200112 (37.771696430266, -122.420645200112)
166774 166774 242781 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 95x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006152.38517 2109124.27435 37.771601160584 -122.42209948031099 (37.771601160584, -122.422099480311)
167931 167931 124291 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 4401x Cornwall St 3 Median : Yard 3 Tree 1 DPW 2     16 Width 9ft   5993813.763719999 2114194.95027 37.7848202285685 -122.465147505193 (37.7848202285685, -122.465147505193)
174532 174532 214331 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 100x Idora Ave 13 Median : Yard 3 Tree 1 DPW 2     2 Width 9ft   5995540.56521 2099364.9270200003 37.7442002405496 -122.458099716827 (37.7442002405496, -122.458099716827)
185473 185473 242779 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x McCoppin St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 9ft   6006556.42632 2109149.52189 37.77169326466979 -122.420703668659 (37.7716932646698, -122.420703668659)
185898 185898 188406 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1300x De Haro St 6 Median : Yard 3 Tree 1 DPW 2     6 Width 9ft   6012288.20028 2102185.92507 37.75289415586 -122.400387777694 (37.75289415586, -122.400387777694)
187642 187642 206837 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 100x Idora Ave 25 Median : Yard 3 Tree 1 DPW 2     63 Width 9ft   5995840.17489 2099294.03492 37.7440227989188 -122.45705861128401 (37.7440227989188, -122.457058611284)
187703 187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
24519 24519 206820 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 2 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   5994214.91647 2101031.13143 37.7486989587999 -122.462804340247 (37.7486989587999, -122.462804340247)
25072 25072 126288 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2500x Van Ness Ave 7 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6005772.33142 2119211.18315 37.7992758747311 -122.424131583019 (37.7992758747311, -122.424131583019)
25236 25236 194362 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6016123.073030001 2114362.8388099996 37.786542411639 -122.38797559828899 (37.786542411639, -122.387975598289)
25391 25391 132190 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 44 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132)
25644 25644 126371 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 37 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046)
25946 25946 126425 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1306x Montgomery St 27 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6011438.821769999 2120037.4711599997 37.8018629670555 -122.40458165273701 (37.8018629670555, -122.404581652737)
25996 25996 194361 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
26925 26925 208266 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 4 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   5996189.57852 2098600.11131 37.7421375150253 -122.455800307749 (37.7421375150253, -122.455800307749)
26942 26942 129350 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 38 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
27329 27329 194334 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 10 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993)
27490 27490 129348 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 33 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
27523 27523 197764 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 9 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6015565.1078 2103547.1261299998 37.7568139175333 -122.389150557161 (37.7568139175333, -122.389150557161)
27830 27830 195766 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 2 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6014104.3852699995 2110532.00713 37.7759117775522 -122.394691443959 (37.7759117775522, -122.394691443959)
28285 28285 206831 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 38 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5994089.87141 2101545.69318 37.7501046117408 -122.463274075037 (37.7501046117408, -122.463274075037)
28399 28399 211132 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 39 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   5994073.5471 2101557.9336599996 37.750137280527 -122.463331413139 (37.750137280527, -122.463331413139)
29064 29064 194335 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 11 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015932.5598 2112347.87113 37.7809992081901 -122.38849403588999 (37.7809992081901, -122.38849403589)
29492 29492 194379 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015888.45756 2115624.95631 37.7899948982019 -122.388875463533 (37.7899948982019, -122.388875463533)
29552 29552 211129 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 35 Median : Yard 3 Tree 1 DPW 2     25 Width 8ft   5994111.36343 2101512.4621099997 37.7500146058056 -122.463197343983 (37.7500146058056, -122.463197343983)
29638 29638 197767 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 14 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6015569.446690001 2103464.9174599997 37.756588430534 -122.38912981161002 (37.756588430534, -122.38912981161)
29681 29681 211122 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 27 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   5994167.1459 2101393.52573 37.749691250071 -122.462995818511 (37.749691250071, -122.462995818511)
29957 29957 187712 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 51x Executive Park Blvd 3 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6013733.01886 2087017.8562099999 37.7113262093072 -122.39432937061301 (37.7113262093072, -122.394329370613)
30017 30017 187699 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 150x Executive Park Blvd 8 Median : Yard 3 Tree 1 DPW 2     24 Width 8ft   6014113.89856 2087000.13929 37.7112987269205 -122.393011704639 (37.7112987269205, -122.393011704639)
30288 30288 195777 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 18 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6013688.74919 2110125.02195 37.774771170975704 -122.396100718491 (37.7747711709757, -122.396100718491)
32164 32164 188743 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 11 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6014538.0462 2086963.8159 37.711222541749 -122.391543193559 (37.711222541749, -122.391543193559)
33038 33038 217725 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 150x Lincoln Way 2 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   5995229.4341400005 2107380.1669099997 37.766190168267 -122.45975599017099 (37.766190168267, -122.459755990171)
33192 33192 194377 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 14 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016027.16358 2115370.7776 37.789304668530896 -122.388377800289 (37.7893046685309, -122.388377800289)
34409 34409 211112 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 6 Median : Yard 3 Tree 1 DPW 2     44 Width 8ft   5994184.95875 2101126.7807299998 37.748959862029096 -122.46291487144501 (37.7489598620291, -122.462914871445)
35206 35206 195775 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 12 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6013821.82406 2110259.84157 37.7751487585315 -122.395649829891 (37.7751487585315, -122.395649829891)
35368 35368 194364 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6016200.86003 2114659.13107 37.78736027221179 -122.387727152497 (37.7873602722118, -122.387727152497)
35716 35716 194337 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 13 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6015953.29851 2112409.5704799998 37.781169770014294 -122.38842659752198 (37.7811697700143, -122.388426597522)
36397 36397 195772 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 9 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6013930.44742 2110363.9939599996 37.7754407791936 -122.395281372244 (37.7754407791936, -122.395281372244)
36478 36478 133192 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1306x Montgomery St 41 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011420.83782 2120184.50099 37.8022656699768 -122.404654242423 (37.8022656699768, -122.404654242423)
37068 37068 208271 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 9 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   5996099.48169 2098476.66946 37.7417934029459 -122.456102909823 (37.7417934029459, -122.456102909823)
37384 37384 211111 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 5 Median : Yard 3 Tree 1 DPW 2     21 Width 8ft   5994189.10111 2101103.38332 37.7488958572711 -122.462898850009 (37.7488958572711, -122.462898850009)
37578 37578 206829 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 21 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   5994178.99702 2101301.67665 37.749439738457 -122.46294817423599 (37.749439738457, -122.462948174236)
37820 37820 188744 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 250x Executive Park Blvd 12 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6014566.93251 2086961.4469700002 37.7112176404424 -122.391443188965 (37.7112176404424, -122.391443188965)
38094 38094 231477 DPW Maintained 3 Malus :: Crab Apple 235 600x San Jose Ave 1 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6005974.01132 2099648.68915 37.7455733533412 -122.422043227715 (37.7455733533412, -122.422043227715)
39141 39141 119936 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 6500x Geary Blvd 7 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   5986709.57611 2112539.19718 37.7798617820891 -122.489603541423 (37.7798617820891, -122.489603541423)
39298 39298 126628 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 350x Washington St 3 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6013814.15262 2118039.92484 37.7965106447043 -122.396221758237 (37.7965106447043, -122.396221758237)
39759 39759 126424 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1306x Montgomery St 26 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6011439.456040001 2120033.94187 37.801853311934096 -122.404579209268 (37.8018533119341, -122.404579209268)
39986 39986 211113 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 7 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   5994180.049769999 2101148.49465 37.7490192001903 -122.462933421744 (37.7490192001903, -122.462933421744)
40192 40192 246545 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 12 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6005664.26886 2109539.08097 37.7727125769595 -122.423817404855 (37.7727125769595, -122.423817404855)
41103 41103 195768 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6014054.2182599995 2110478.98946 37.775763413678 -122.394861271956 (37.775763413678, -122.394861271956)
42530 42530 194380 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015792.97899 2115653.31942 37.79006748427221 -122.38920779542102 (37.7900674842722, -122.389207795421)
42729 42729 194375 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6016059.60857 2115304.2736400003 37.7891238616108 -122.388260900137 (37.7891238616108, -122.388260900137)
43461 43461 194341 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     25 Width 8ft   6016036.61123 2112738.53497 37.7820776491035 -122.388161338867 (37.7820776491035, -122.388161338867)
43669 43669 246542 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 8 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6005675.49099 2109463.50167 37.772505687922 -122.42377321126001 (37.772505687922, -122.42377321126)
45853 45853 206826 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 15 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   5994179.978069999 2101226.44078 37.7492332163602 -122.462939324011 (37.7492332163602, -122.462939324011)
46468 46468 194330 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 6 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   6015863.586519999 2112149.96757 37.780451986896296 -122.38871883132 (37.7804519868963, -122.38871883132)
47222 47222 206821 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 9 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   5994174.99878 2101175.06788 37.7490918726007 -122.46295281564501 (37.7490918726007, -122.462952815645)
47369 47369 126370 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 31 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6011433.37611 2120083.33032 37.801988580770995 -122.40460372750601 (37.801988580771, -122.404603727506)
47847 47847 125865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 47 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011401.82838 2120281.49833 37.8025309385205 -122.404726857271 (37.8025309385205, -122.404726857271)
48046 48046 194385 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6015616.39603 2115848.18198 37.7905927414207 -122.38983237995701 (37.7905927414207, -122.389832379957)
48107 48107 132184 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 25 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6011444.3716 2120015.20461 37.8018021387065 -122.404560879294 (37.8018021387065, -122.404560879294)
48494 48494 195774 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 11 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6013840.56716 2110278.0449099997 37.7751997833822 -122.39558626849701 (37.7751997833822, -122.395586268497)
48962 48962 195770 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 6 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6014000.92339 2110427.4645700003 37.7756189744596 -122.395042023971 (37.7756189744596, -122.395042023971)
49204 49204 211120 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 25 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   5994172.8828300005 2101376.40838 37.7496445806313 -122.46297473838699 (37.7496445806313, -122.462974738387)
49253 49253 197768 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 15 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6015570.7208 2103442.3208 37.7565264555391 -122.389123827518 (37.7565264555391, -122.389123827518)
50390 50390 246538 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 1x Octavia St 4 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6005690.17012 2109380.36656 37.7722782475712 -122.423716522495 (37.7722782475712, -122.423716522495)
50688 50688 206828 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 335x Pacheco St 19 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5994181.13078 2101275.53768 37.749368090385104 -122.462938899523 (37.7493680903851, -122.462938899523)
51701 51701 208264 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 1 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   5996224.40551 2098673.0355 37.742339745598706 -122.45568515764299 (37.7423397455987, -122.455685157643)
51725 51725 194333 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 9 Median : Yard 3 Tree 1 DPW 2     31 Width 8ft   6015903.377169999 2112286.3418900003 37.78082864545979 -122.38859069771999 (37.7808286454598, -122.38859069772)
52412 52412 211125 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 31 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5994142.00989 2101462.2847 37.7498785968185 -122.463087727432 (37.7498785968185, -122.463087727432)
53093 53093 194359 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     33 Width 8ft   6016151.3585 2114078.17293 37.785762350501706 -122.38785786627199 (37.7857623505017, -122.387857866272)
55101 55101 194331 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 7 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   6015869.7392 2112229.4323400003 37.7806705203569 -122.388703094985 (37.7806705203569, -122.388703094985)
55150 55150 208267 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 950x Portola Dr 5 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5996171.153059999 2098570.8040400003 37.742055987003496 -122.455861898701 (37.7420559870035, -122.455861898701)
55186 55186 194332 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 88x King St 8 Median : Yard 3 Tree 1 DPW 2     33 Width 8ft   6015905.66871 2112206.70701 37.7806101129033 -122.38857720969601 (37.7806101129033, -122.388577209696)
55905 55905 195769 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 700x King St 5 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6014035.25222 2110463.93544 37.77572102415021 -122.394925826163 (37.7757210241502, -122.394925826163)
56070 56070 211118 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 23 Median : Yard 3 Tree 1 DPW 2     32 Width 8ft   5994177.42572 2101348.8746700003 37.74956924173021 -122.46295703165701 (37.7495692417302, -122.462957031657)
56308 56308 199365 DPW Maintained 3 Eucalyptus sideroxylon :: Red Ironbark 36 300x Division St 4 Median : Yard 3 Tree 1 DPW 2     36 Width 8ft   6009969.14716 2108168.58479 37.7691915908542 -122.408829584245 (37.7691915908542, -122.408829584245)

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