Street_Tree_List

Data source: data.sfgov.org

2,124 rows where qSpecies = 3 sorted by rowid descending

✎ View and edit SQL

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
189054 189054 233323 Undocumented 2 Pinus radiata :: Monterey Pine 3 51 Prentiss St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   6008877.2756900005 2098293.43084 37.7420154302758 -122.41190839527201 (37.7420154302758, -122.411908395272)
189042 189042 178219 Undocumented 2 Pinus radiata :: Monterey Pine 3 49 Santos St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44 Width 6ft   6006726.5178 2087416.33462 37.712028383779895 -122.41857390945499 (37.7120283837799, -122.418573909455)
188268 188268 211116 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 16 Median : Yard 3 Tree 1 DPW 2     30 Width 8ft   5994179.36475 2101243.69399 37.749280553969605 -122.46294269644501 (37.7492805539696, -122.462942696445)
188249 188249 211273 Undocumented 2 Pinus radiata :: Monterey Pine 3 419 Baden St 1 Front Yard : Yard 7 Tree 1 Private 1     10     6000744.76025 2095358.13165 37.733496172296796 -122.43981756802201 (37.7334961722968, -122.439817568022)
188222 188222 186148 Undocumented 2 Pinus radiata :: Monterey Pine 3 1700 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984958.7864 2103269.137 37.754306442824294 -122.494976486886 (37.7543064428243, -122.494976486886)
188096 188096 233295 Undocumented 2 Pinus radiata :: Monterey Pine 3 1300 San Jose Ave 18 Front Yard : Yard 7 Tree 1 Private 1     13     6003571.72573 2095651.64525 37.7344626053608 -122.430064877286 (37.7344626053608, -122.430064877286)
188074 188074 211219 Undocumented 2 Pinus radiata :: Monterey Pine 3 440 Dewey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     36 Width 3ft   5994968.20619 2100269.78375 37.7466518473211 -122.460144338116 (37.7466518473211, -122.460144338116)
187986 187986 194474 Undocumented 2 Pinus radiata :: Monterey Pine 3 601 Illinois St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6016019.39456 2106196.24921 37.7641130167339 -122.387764283717 (37.7641130167339, -122.387764283717)
187890 187890 233335 Undocumented 2 Pinus radiata :: Monterey Pine 3 601 30th St 1 Front Yard : Yard 7 Tree 1 Private 1     3     6002596.9990300005 2098294.71472 37.741664611941104 -122.433623657423 (37.7416646119411, -122.433623657423)
187806 187806 132199 Undocumented 2 Pinus radiata :: Monterey Pine 3 2836 Larkin St 14 Side Yard : Yard 17 Tree 1 Private 1     17     6006498.02761 2121046.57665 37.8043563455331 -122.42175085543998 (37.8043563455331, -122.42175085544)
187722 187722 186740 Undocumented 2 Pinus radiata :: Monterey Pine 3 1200 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984872.2705 2106626.6105 37.763520065232896 -122.495523292395 (37.7635200652329, -122.495523292395)
187681 187681 178232 Undocumented 2 Pinus radiata :: Monterey Pine 3 1617 Sunnydale Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 10ft   6007195.0497 2087434.8361799999 37.712105551909 -122.41695583486 (37.712105551909, -122.41695583486)
187651 187651 132200 Undocumented 2 Pinus radiata :: Monterey Pine 3 1151 Lombard St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35     6006710.22294 2120090.22803 37.801742419238 -122.42094859269899 (37.801742419238, -122.420948592699)
187558 187558 187227 Undocumented 2 Pinus radiata :: Monterey Pine 3 2401 Sunset Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     27 Width 0ft   5984952.7423 2098676.0543 37.741694737577205 -122.494658792138 (37.7416947375772, -122.494658792138)
187444 187444 178295 Undocumented 2 Pinus radiata :: Monterey Pine 3 654 Brotherhood Way 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5990056.81744 2088683.0468099997 37.7145538887276 -122.47628102917 (37.7145538887276, -122.47628102917)
187393 187393 132205 Undocumented 2 Pinus radiata :: Monterey Pine 3 12 Greenwich St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     6012257.5514 2120548.1369 37.8033108539845 -122.401784364564 (37.8033108539845, -122.401784364564)
187331 187331 178212 Undocumented 2 Pinus radiata :: Monterey Pine 3 21 Santos St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 6ft   6006711.0522 2087388.9913599999 37.711952434221296 -122.418625425333 (37.7119524342213, -122.418625425333)
187327 187327 233306 Undocumented 2 Pinus radiata :: Monterey Pine 3 174 Carnelian Way 1 : Yard 23 Tree 1 Private 1     26     6000631.47853 2100513.23992 37.7476444344533 -122.44057883696999 (37.7476444344533, -122.44057883697)
187254 187254 187321 Undocumented 2 Pinus radiata :: Monterey Pine 3 2200 Sunset Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5985076.1378 2099630.1762 37.7443217201145 -122.49430245017 (37.7443217201145, -122.49430245017)
187216 187216 186075 Undocumented 2 Pinus radiata :: Monterey Pine 3 1901 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984841.5431 2102025.7523 37.7508855867305 -122.49529024801501 (37.7508855867305, -122.495290248015)
187113 187113 186993 Undocumented 2 Pinus radiata :: Monterey Pine 3 2501 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5984972.6512 2098104.4212 37.7401263524114 -122.494547824222 (37.7401263524114, -122.494547824222)
186865 186865 178210 Undocumented 2 Pinus radiata :: Monterey Pine 3 21 Santos St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 6ft   6006691.01182 2087336.7797299998 37.711807943747104 -122.41869099041 (37.7118079437471, -122.41869099041)
186672 186672 186461 Undocumented 2 Pinus radiata :: Monterey Pine 3 1601 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984772.766 2103837.6209 37.7558564508623 -122.49566171185499 (37.7558564508623, -122.495661711855)
186629 186629 181499 Undocumented 2 Pinus radiata :: Monterey Pine 3 1400 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     45 Width 0ft   5984863.3239 2105454.4541 37.760301127976795 -122.495467779672 (37.7603011279768, -122.495467779672)
186498 186498 247062 Undocumented 2 Pinus radiata :: Monterey Pine 3 626 30th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41     6002537.3852 2098319.5101900003 37.741729311856105 -122.433831553686 (37.7417293118561, -122.433831553686)
186465 186465 247089 Undocumented 2 Pinus radiata :: Monterey Pine 3 2301 Castro St 7 Front Yard : Yard 7 Tree 1 Private 1     1     6002763.937390001 2098596.7389 37.7425033709224 -122.433068014888 (37.7425033709224, -122.433068014888)
186429 186429 211154 Undocumented 2 Pinus radiata :: Monterey Pine 3 553 Staples Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     42 Width 10ft   5996801.13739 2093830.3594099998 37.72907600803 -122.453341458757 (37.72907600803, -122.453341458757)
186406 186406 211123 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 335x Pacheco St 28 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   5994165.13571 2101402.3094200003 37.7497152520618 -122.46300340698099 (37.7497152520618, -122.463003406981)
186332 186332 184060 Undocumented 2 Pinus radiata :: Monterey Pine 3 1600 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984931.7298 2103926.1565 37.756108852785204 -122.49511849990101 (37.7561088527852, -122.495118499901)
186148 186148 185703 Undocumented 2 Pinus radiata :: Monterey Pine 3 2101 Sunset Blvd 35 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5984902.932 2100497.5253 37.7466930873456 -122.494965291434 (37.7466930873456, -122.494965291434)
185854 185854 178284 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Brotherhood Way 13 : 4 Tree 1 Private 1     25 Width 0ft   5988329.29529 2088738.596 37.7146060790912 -122.482256039396 (37.7146060790912, -122.482256039396)
185502 185502 122532 Undocumented 2 Pinus radiata :: Monterey Pine 3 1900X Castro St 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
185498 185498 233290 Undocumented 2 Pinus radiata :: Monterey Pine 3 200 Eugenia Ave 21 Front Yard : Yard 7 Tree 1 Private 1     28     6006619.00302 2098071.9660799997 37.741280382872894 -122.419701087332 (37.7412803828729, -122.419701087332)
185402 185402 250219 Undocumented 2 Pinus radiata :: Monterey Pine 3 310 Montgomery St 2 Front Yard : Yard 7 Tree 1 Private 1     23 Width 0ft   6011287.59722 2120080.15149 37.801971704085396 -122.40510797016 (37.8019717040854, -122.40510797016)
185401 185401 186131 Undocumented 2 Pinus radiata :: Monterey Pine 3 1700 Sunset Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 0ft   5984948.7464 2103120.9605 37.7538990032893 -122.495000281969 (37.7538990032893, -122.495000281969)
185389 185389 178268 Undocumented 2 Pinus radiata :: Monterey Pine 3 26 Ervine St 6 Front Yard : Yard 7 Tree 1 Private 1     7     6009638.638230001 2089257.8052599998 37.7172482036179 -122.40863856641899 (37.7172482036179, -122.408638566419)
185350 185350 187595 Undocumented 2 Pinus radiata :: Monterey Pine 3 745 University St 2 Front Yard : Yard 7 Tree 1 Private 1     15     6008748.723069999 2090677.61672 37.721096827151605 -122.41181486576099 (37.7210968271516, -122.411814865761)
185290 185290 185463 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 15 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985112.4406 2098384.9036 37.740904662190104 -122.494085163354 (37.7409046621901, -122.494085163354)
185237 185237 178226 Undocumented 2 Pinus radiata :: Monterey Pine 3 1950 Sunnydale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 10ft   6005749.81171 2088026.15425 37.7136477830976 -122.42199298350599 (37.7136477830976, -122.421992983506)
184966 184966 54835 Permitted Site 1 Pinus radiata :: Monterey Pine 3 117 Ashbury St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/1972 12:00:00 AM 15   Permit Number 10689 5998722.2979 2110262.8651 37.7743055679817 -122.447882461981 (37.7743055679817, -122.447882461981)
184891 184891 181407 Undocumented 2 Pinus radiata :: Monterey Pine 3 1500 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 0ft   5984912.8932 2104709.5212 37.758258652087 -122.495241409198 (37.758258652087, -122.495241409198)
184665 184665 211252 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 99x San Marcos Ave 11 Median : Cutout 11 Tree 1 DPW 2     28 Width 5ft   5993772.95985 2100263.65639 37.7465662021668 -122.464276899165 (37.7465662021668, -122.464276899165)
184305 184305 186707 Undocumented 2 Pinus radiata :: Monterey Pine 3 1401 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5984739.3728 2105071.9138 37.7592435204145 -122.49586824229401 (37.7592435204145, -122.495868242294)
184172 184172 178271 Undocumented 2 Pinus radiata :: Monterey Pine 3 35 Tomaso Ct 2 Side Yard : Yard 17 Tree 1 Private 1     17 Width 3ft   6009176.170940001 2086260.2904299998 37.7089917311415 -122.41002561149901 (37.7089917311415, -122.410025611499)
184049 184049 249789 Undocumented 2 Pinus radiata :: Monterey Pine 3 173 Chestnut St 3 Front Yard : Yard 7 Tree 1 Private 1     19 Width 0ft   6010910.8847900005 2121034.69861 37.804571589270296 -122.40647888049 (37.8045715892703, -122.40647888049)
184047 184047 201550 Undocumented 2 Pinus radiata :: Monterey Pine 3 200 Jerrold Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31     6020135.10106 2093474.49697 37.7294087400981 -122.372648486831 (37.7294087400981, -122.372648486831)
184001 184001 187218 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 2401 Sunset Blvd 1 Median : Cutout 11 Tree 1 DPW 2     27 Width 0ft   5984945.4705 2098810.8461 37.7420644138344 -122.494693870399 (37.7420644138344, -122.494693870399)
183957 183957 132207 Undocumented 2 Pinus radiata :: Monterey Pine 3 199 Union St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012049.27862 2119798.13006 37.8012398924644 -122.40245233511001 (37.8012398924644, -122.40245233511)
183943 183943 211213 Undocumented 2 Pinus radiata :: Monterey Pine 3 45 Dorantes Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34 Width 3ft   5994039.80885 2100040.7700900002 37.7459695901264 -122.46333799976802 (37.7459695901264, -122.463337999768)
183835 183835 233322 Undocumented 2 Pinus radiata :: Monterey Pine 3 51 Prentiss St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6008884.18383 2098343.8941900004 37.7421543791283 -122.41188807419901 (37.7421543791283, -122.411888074199)
183770 183770 185185 Undocumented 2 Pinus radiata :: Monterey Pine 3 2500 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5985131.3657 2097848.0278 37.739431652929895 -122.493980171096 (37.7394316529299, -122.493980171096)
183567 183567 178253 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 200x Mansell St 20 Median : Cutout 11 Tree 1 DPW 2     25 Width 0ft   6011075.03755 2090535.49996 37.7208368367282 -122.403763436926 (37.7208368367282, -122.403763436926)
183291 183291 184012 Undocumented 2 Pinus radiata :: Monterey Pine 3 1600 Sunset Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5984940.7086 2103743.0997 37.7556067551316 -122.49507395078699 (37.7556067551316, -122.495073950787)
183287 183287 249688 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Baker St 20 Front Yard : Yard 7 Tree 1 Private 1     2     5999721.2630900005 2117323.6721799998 37.793749761985396 -122.444934546805 (37.7937497619854, -122.444934546805)
183128 183128 233318 Undocumented 2 Pinus radiata :: Monterey Pine 3 5300 Diamond Heights Blvd 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     23 Width 8ft   6001505.99922 2098909.6493900004 37.7432911141078 -122.43743998627501 (37.7432911141078, -122.437439986275)
183109 183109 186548 Undocumented 2 Pinus radiata :: Monterey Pine 3 1501 Sunset Blvd 19 unknown : Yard 19 Tree 1 Private 1     11 Width 0ft   5984713.0979 2104804.2446 37.7585070365446 -122.49593936599 (37.7585070365446, -122.49593936599)
182857 182857 181357 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 12 unknown : Yard 19 Tree 1 Private 1     25 Width 0ft   5985137.6741 2098360.3342 37.740838677714294 -122.49399610623999 (37.7408386777143, -122.49399610624)
182806 182806 178197 Undocumented 2 Pinus radiata :: Monterey Pine 3 121 Blythdale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     52 Width 6ft   6006521.5193300005 2086937.9712099999 37.7107033550432 -122.419248532308 (37.7107033550432, -122.419248532308)
182657 182657 186479 Undocumented 2 Pinus radiata :: Monterey Pine 3 1601 Sunset Blvd 67 Sidewalk: Property side : Yard 9 Tree 1 Private 1     44 Width 0ft   5984775.6971 2103703.6293 37.7554887186956 -122.49564169253999 (37.7554887186956, -122.49564169254)
182618 182618 211149 Undocumented 2 Pinus radiata :: Monterey Pine 3 100 Terrace Dr 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41     5993545.6652 2096759.5462200001 37.7369316931402 -122.46480842636801 (37.7369316931402, -122.464808426368)
182598 182598 211247 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 255x San Marcos Ave 2 Median : Cutout 11 Tree 1 DPW 2     27 Width 5ft   5993181.00206 2100246.48569 37.7464849178553 -122.46632256094 (37.7464849178553, -122.46632256094)
182572 182572 178192 Undocumented 2 Pinus radiata :: Monterey Pine 3 144 Brookdale Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     34 Width 6ft   6005819.1035400005 2087500.6137299999 37.7122086681568 -122.421716180273 (37.7122086681568, -122.421716180273)
182538 182538 178287 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Brotherhood Way 16 : 4 Tree 1 Private 1     24 Width 0ft   5988507.20962 2088726.3385700001 37.7145827704448 -122.481640205227 (37.7145827704448, -122.481640205227)
182200 182200 186282 Undocumented 2 Pinus radiata :: Monterey Pine 3 1800 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     50 Width 0ft   5984990.9341 2102534.7003 37.752291763805104 -122.494811167736 (37.7522917638051, -122.494811167736)
182172 182172 185464 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 16 unknown : Yard 19 Tree 1 Private 1     46 Width 0ft   5985103.8081 2098378.9273 37.740887747752105 -122.494114570537 (37.7408877477521, -122.494114570537)
181979 181979 178299 Undocumented 2 Pinus radiata :: Monterey Pine 3 654 Brotherhood Way 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5989733.9009 2088725.61283 37.7146520326324 -122.477400256131 (37.7146520326324, -122.477400256131)
181916 181916 186441 Undocumented 2 Pinus radiata :: Monterey Pine 3 1601 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984740.1056 2103964.9129 37.7562040467419 -122.495784049741 (37.7562040467419, -122.495784049741)
181841 181841 211099 Undocumented 2 Pinus radiata :: Monterey Pine 3 501 Saint Francis Blvd 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     46 Width 10ft   5993137.63738 2096084.35497 37.7350542531473 -122.46617009617201 (37.7350542531473, -122.466170096172)
181676 181676 186658 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 1401 Sunset Blvd 15 Median : Yard 3 Tree 1 DPW 2     1 Width 0ft   5984710.2715 2105562.1346 37.7605878254343 -122.49600505239401 (37.7605878254343, -122.496005052394)
181525 181525 178319 Undocumented 2 Pinus radiata :: Monterey Pine 3 0 Serrano Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25     5988184.71166 2090359.2688799999 37.7190476283173 -122.48287447798799 (37.7190476283173, -122.482874477988)
181469 181469 184069 Undocumented 2 Pinus radiata :: Monterey Pine 3 1600 Sunset Blvd 70 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5984931.4699 2103987.4511 37.756277135565 -122.495123918436 (37.756277135565, -122.495123918436)
181403 181403 233326 Undocumented 2 Pinus radiata :: Monterey Pine 3 37 Seward St 1 Front Yard : Yard 7 Tree 1 Private 1     14 Width 3ft   6000943.20719 2104256.18118 37.757939394794505 -122.439769208804 (37.7579393947945, -122.439769208804)
181286 181286 247205 Undocumented 2 Pinus radiata :: Monterey Pine 3 800 Duboce Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   6001896.2182599995 2108288.07588 37.7690641919786 -122.43676191454901 (37.7690641919786, -122.436761914549)
181261 181261 233301 Undocumented 2 Pinus radiata :: Monterey Pine 3 5210 Diamond Heights Blvd 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   6001084.56345 2099244.52988 37.744186648194706 -122.438921192176 (37.7441866481947, -122.438921192176)
181208 181208 211140 Undocumented 2 Pinus radiata :: Monterey Pine 3 372 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 3ft   5994204.83079 2101353.3988099997 37.7495832423852 -122.46286259293001 (37.7495832423852, -122.46286259293)
181069 181069 248060 Undocumented 2 Pinus radiata :: Monterey Pine 3 18 Rutledge St 2 Side Yard : Yard 17 Tree 1 Private 1     25     6010688.173909999 2099371.0284599997 37.7450757107928 -122.40572274042201 (37.7450757107928, -122.405722740422)
180884 180884 178265 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 12x Canyon Dr 11 Median : Cutout 11 Tree 1 DPW 2     25 Width 0ft   6002756.140790001 2086182.07734 37.7084150543766 -122.43220856967501 (37.7084150543766, -122.432208569675)
180863 180863 218285 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 50x Junipero Serra Frontage West 0 Median : Yard 3 Tree 1 DPW 2     11     5991436.68421 2095414.89925 37.7331178131424 -122.47200206387 (37.7331178131424, -122.47200206387)
180817 180817 211199 Undocumented 2 Pinus radiata :: Monterey Pine 3 700 Junipero Serra Blvd 113 : 4 Tree 1 Private 1     19 Width 0ft   5991225.72765 2091869.87768 37.723371861005894 -122.472473035226 (37.7233718610059, -122.472473035226)
180540 180540 218360 Undocumented 2 Pinus radiata :: Monterey Pine 3 325 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     28 Width 0ft   5993688.114030001 2100069.11546 37.7460271512249 -122.464556161131 (37.7460271512249, -122.464556161131)
180431 180431 185459 Undocumented 2 Pinus radiata :: Monterey Pine 3 2400 Sunset Blvd 9 unknown : Yard 19 Tree 1 Private 1     28 Width 0ft   5985114.4327 2098335.7647 37.7407698565631 -122.494074654765 (37.7407698565631, -122.494074654765)
180357 180357 211093 Undocumented 2 Pinus radiata :: Monterey Pine 3 2088 15th Ave 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 6ft   5991644.9229 2101275.9651599997 37.749222851651 -122.471709112392 (37.749222851651, -122.471709112392)
180338 180338 211209 Undocumented 2 Pinus radiata :: Monterey Pine 3 900 Junipero Serra Blvd 108 : 4 Tree 1 Private 1     38 Width 0ft   5991125.77037 2090347.7107799998 37.719186580775705 -122.47270763415301 (37.7191865807757, -122.472707634153)
180324 180324 184024 Undocumented 2 Pinus radiata :: Monterey Pine 3 1600 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     51 Width 0ft   5984939.2873 2103786.5467 37.75572596536521 -122.495082069611 (37.7557259653652, -122.495082069611)
180287 180287 186426 Undocumented 2 Pinus radiata :: Monterey Pine 3 1601 Sunset Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984731.7311 2104081.3181 37.756523172675294 -122.495821597656 (37.7565231726753, -122.495821597656)
180165 180165 211272 Undocumented 2 Pinus radiata :: Monterey Pine 3 433 Baden St 1 Front Yard : Yard 7 Tree 1 Private 1     10     6000742.7962 2095390.8382700002 37.7335858652769 -122.439826702451 (37.7335858652769, -122.439826702451)
179933 179933 248234 Undocumented 2 Pinus radiata :: Monterey Pine 3 299 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     23     6006807.51712 2099039.75283 37.7439483260488 -122.419117901273 (37.7439483260488, -122.419117901273)
179456 179456 186955 Undocumented 2 Pinus radiata :: Monterey Pine 3 2800 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     32 Width 0ft   5985201.4594 2096098.6602 37.7346324579003 -122.493608953797 (37.7346324579003, -122.493608953797)
179254 179254 218424 Undocumented 2 Pinus radiata :: Monterey Pine 3 264 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 0ft   5994189.05775 2100412.10244 37.74699777243389 -122.46284885578699 (37.7469977724339, -122.462848855787)
179164 179164 211145 Undocumented 2 Pinus radiata :: Monterey Pine 3 100 Terrace Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     38     5993430.72958 2096831.91816 37.7371237811228 -122.46521106186701 (37.7371237811228, -122.465211061867)
179085 179085 186086 Undocumented 2 Pinus radiata :: Monterey Pine 3 1901 Sunset Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 0ft   5984856.3947 2101848.8436 37.7504007135297 -122.495225845953 (37.7504007135297, -122.495225845953)
178863 178863 178252 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 100x Mansell St 11 Median : Cutout 11 Tree 1 DPW 2     28 Width 0ft   6011405.602080001 2090646.90467 37.7211611925117 -122.402628599549 (37.7211611925117, -122.402628599549)
178652 178652 181553 Undocumented 2 Pinus radiata :: Monterey Pine 3 1300 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984843.5518 2106047.3371 37.761927861181704 -122.49557989141 (37.7619278611817, -122.49557989141)
178444 178444 211262 Undocumented 2 Pinus radiata :: Monterey Pine 3 515 Rockdale Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   5997949.74577 2097642.99461 37.7396103643276 -122.449645274827 (37.7396103643276, -122.449645274827)
178256 178256 186462 Undocumented 2 Pinus radiata :: Monterey Pine 3 1601 Sunset Blvd 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     71 Width 0ft   5984739.2681 2103826.734 37.755824596750706 -122.495776753709 (37.7558245967507, -122.495776753709)
178239 178239 181477 Undocumented 2 Pinus radiata :: Monterey Pine 3 1400 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984869.4504 2105294.0498 37.759861061253794 -122.495434760928 (37.7598610612538, -122.495434760928)
178221 178221 247571 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 350x Alemany Blvd 6 Median : Yard 3 Tree 1 DPW 2     19     6008108.27012 2094965.3059 37.732833953824205 -122.414331952177 (37.7328339538242, -122.414331952177)
178131 178131 201566 Undocumented 2 Pinus radiata :: Monterey Pine 3 799 Jerrold Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6019697.16467 2093717.76615 37.7300526357971 -122.374179337111 (37.7300526357971, -122.374179337111)
178075 178075 178250 Undocumented 2 Pinus radiata :: Monterey Pine 3 287 Hester Ave 1 Side Yard : Yard 17 Tree 1 Private 1     23     6012202.6988699995 2087794.30309 37.713372992543896 -122.39967306036199 (37.7133729925439, -122.399673060362)
178044 178044 233327 Undocumented 2 Pinus radiata :: Monterey Pine 3 37 Seward St 4 Front Yard : Yard 7 Tree 1 Private 1     14 Width 3ft   6000956.81964 2104246.73204 37.7579142245741 -122.439721453891 (37.7579142245741, -122.439721453891)

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