Street_Tree_List

Data source: data.sfgov.org

308 rows where DBH = 6 and qSpecies = 18 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize

DBH

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
188398 238218 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3917 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004401.25357 2101297.60902 37.7500120760091 -122.42759904058398 (37.7500120760091, -122.427599040584)
188032 72515 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 44 Almaden Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/12/1996 12:00:00 AM 6     5995895.10246 2112445.80394 37.7801373389306 -122.457820182784 (37.7801373389306, -122.457820182784)
187914 135943 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2056 Jefferson St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5999351.778519999 2121203.50658 37.8043816542415 -122.446492250814 (37.8043816542415, -122.446492250814)
187600 239480 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1301 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997758.32648 2106133.54952 37.7629123768383 -122.450919186079 (37.7629123768383, -122.450919186079)
187134 237166 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 309 Montcalm St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009651.505030001 2099579.8056400004 37.7455909404652 -122.409322104236 (37.7455909404652, -122.409322104236)
187122 238176 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4037 24th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002928.2338 2101801.18414 37.75131134544971 -122.4327287852 (37.7513113454497, -122.4327287852)
186438 213370 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1567 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992114.844269999 2104775.13643 37.758857841827606 -122.47033892420001 (37.7588578418276, -122.4703389242)
186222 56305 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 147 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/15/1973 12:00:00 AM 6   Permit Number 12437 5993019.12779 2114510.13973 37.785639797963704 -122.467919595671 (37.7856397979637, -122.467919595671)
185440 213504 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 435 Montecito Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995680.74302 2093936.8329099999 37.7293040752209 -122.457222425468 (37.7293040752209, -122.457222425468)
185145 214786 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 34 Fairfield Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5993908.89145 2093024.3192599998 37.7266966141529 -122.463281639244 (37.7266966141529, -122.463281639244)
184864 42977 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Oxford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 6   Permit Number 42862 6006537.3191599995 2092680.57085 37.7264721982142 -122.419601095323 (37.7264721982142, -122.419601095323)
183617 135967 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2831 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002534.88565 2117883.88227 37.7954481298799 -122.435239263394 (37.7954481298799, -122.435239263394)
183309 213302 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 663 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995432.632669999 2089892.10127 37.7181839562956 -122.457787596334 (37.7181839562956, -122.457787596334)
182960 213422 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Cecilia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991444.6705 2099648.88289 37.7447437161621 -122.47228298869499 (37.7447437161621, -122.472282988695)
181499 237353 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3178 Cesar Chavez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008596.84315 2100617.64099 37.7483814594487 -122.41304234593399 (37.7483814594487, -122.413042345934)
180995 250869 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986468.30668 2114640.25117 37.785616584774104 -122.490592812307 (37.7856165847741, -122.490592812307)
180844 214747 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 137 Eastwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995630.96112 2093598.65464 37.72837265995471 -122.45737006898999 (37.7283726599547, -122.45737006899)
180146 213631 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 40 Reposa Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997916.58908 2098002.97952 37.7405968990169 -122.44978585144301 (37.7405968990169, -122.449785851443)
179599 238121 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3338 17th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006507.99814 2106140.24033 37.7634277603026 -122.420657523527 (37.7634277603026, -122.420657523527)
178772 78229 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Colby St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/05/2000 12:00:00 AM 6 3x9   6008895.81383 2091285.82356 37.7227750861924 -122.411349358704 (37.7227750861924, -122.411349358704)
178580 213303 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 655 Lakeview Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995455.6031599995 2089891.9177400002 37.7181847719797 -122.457708184405 (37.7181847719797, -122.457708184405)
177753 111197 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2317 Washington St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6     6003620.633230001 2116569.07161 37.791899593028205 -122.43138849140499 (37.7918995930282, -122.431388491405)
177523 214588 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 99 Lurline St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5991798.55182 2105130.62844 37.7598156368994 -122.47145870337299 (37.7598156368994, -122.471458703373)
177356 238492 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 151 Oak St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6006395.8599 2110394.0176 37.7751013004086 -122.421347470809 (37.7751013004086, -122.421347470809)
177253 238506 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 46 Wilder St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002753.72188 2095533.8634 37.7340928410181 -122.432884572069 (37.7340928410181, -122.432884572069)
177125 238360 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 309 Cumberland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6003572.99732 2104467.05385 37.75866773863321 -122.43068933594499 (37.7586677386332, -122.430689335945)
174463 237392 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3153 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007699.44613 2106157.09808 37.7635411252512 -122.41653787225201 (37.7635411252512, -122.416537872252)
174015 213621 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 758 Foerster St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5998164.29493 2096098.97248 37.7353831217245 -122.44879227507 (37.7353831217245, -122.44879227507)
173960 179131 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 301 Somerset St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009936.14207 2093006.65558 37.7275584245623 -122.40787443765 (37.7275584245623, -122.40787443765)
172744 196477 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1499 Rankin St 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 3ft   6012648.615180001 2096647.7620400002 37.7377076327033 -122.39875275533501 (37.7377076327033, -122.398752755335)
172196 35478 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 524 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/1998 12:00:00 AM 6   Permit Number 38890 5986598.81458 2112347.1481 37.779328002919705 -122.489972580124 (37.7793280029197, -122.489972580124)
171241 213493 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 598 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995429.76267 2093267.5886900001 37.7274520743399 -122.45804166739401 (37.7274520743399, -122.458041667394)
171137 196466 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1101 Cesar Chavez St 7 : 4 Tree 1 Private 1     6 Width 3ft   6015450.2681 2101056.0343 37.7499675388841 -122.389373764399 (37.7499675388841, -122.389373764399)
170516 44260 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 320 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2001 12:00:00 AM 6   Permit Number 43692 6003282.08858 2092150.8754099999 37.72483387178 -122.430816500988 (37.72483387178, -122.430816500988)
170473 82703 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 67 Jennings Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/09/2009 12:00:00 AM 6 3x3 Permit Number 52500 6012950.17329 2089208.10371 37.71729664739521 -122.39718858698 (37.7172966473952, -122.39718858698)
170118 250758 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 214 32nd Ave 1 : 4 Tree 1 Private 1     6 Width 3ft   5985901.94322 2114466.62788 37.785106767213705 -122.49253944703699 (37.7851067672137, -122.492539447037)
169316 71443 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 924 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1995 12:00:00 AM 6     6012090.037819999 2119001.59006 37.7990550614973 -122.40225525407101 (37.7990550614973, -122.402255254071)
169146 214757 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 47 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995633.92023 2092945.0693400002 37.7265782417753 -122.45731257623301 (37.7265782417753, -122.457312576233)
168670 178978 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 190 Rae Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997625.81626 2087145.6195099999 37.7107685028255 -122.450008894089 (37.7107685028255, -122.450008894089)
168539 45578 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 325 Walnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/24/2001 12:00:00 AM 6   Permit Number 44318 5998557.11063 2115405.08726 37.788415328045204 -122.448824341269 (37.7884153280452, -122.448824341269)
168043 214737 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 142 Westwood Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995133.12046 2093665.44373 37.7285274395723 -122.459095949818 (37.7285274395723, -122.459095949818)
167410 178992 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Wanda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000617.16509 2091662.40232 37.7233412867464 -122.43999379469601 (37.7233412867464, -122.439993794696)
167280 196455 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1950 Cesar Chavez St 11 : 4 Tree 1 Private 1     6 Width 3ft   6012871.437030001 2101015.96129 37.7497141944763 -122.39828874203998 (37.7497141944763, -122.39828874204)
166651 250870 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 133 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5986470.3680300005 2114630.24299 37.7855892256034 -122.490584944137 (37.7855892256034, -122.490584944137)
166479 237441 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 678 Clipper St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000907.8682699995 2100906.1211599996 37.7487389273661 -122.43965126091601 (37.7487389273661, -122.439651260916)
165830 238120 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 3338 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006530.78324 2106145.4186299997 37.7634432628317 -122.42057908467899 (37.7634432628317, -122.420579084679)
165590 238410 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 207 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6000074.34306 2105633.90576 37.761672792697794 -122.442873030891 (37.7616727926978, -122.442873030891)
164635 214779 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1723 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5992800.25839 2095349.1682799999 37.7330161429665 -122.467283086348 (37.7330161429665, -122.467283086348)
164619 238184 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4185 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002633.056969999 2101204.44752 37.749656102757896 -122.43370689417101 (37.7496561027579, -122.433706894171)
164488 238305 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 83 Seward St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000704.12797 2104538.43627 37.7587007869337 -122.44061628831498 (37.7587007869337, -122.440616288315)
164460 213550 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 167 Valdez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5996175.013809999 2094553.95501 37.731026919034704 -122.455558283981 (37.7310269190347, -122.455558283981)
164404 40950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 543 21st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM 6   Permit Number 42451 5989371.25434 2111628.81002 37.777517147846204 -122.480329070335 (37.7775171478462, -122.480329070335)
164148 196432 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 588 Utah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010644.87433 2105605.27552 37.762191152023505 -122.406311637185 (37.7621911520235, -122.406311637185)
164134 179004 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 500 Paris St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001810.04061 2090659.99307 37.7206567312996 -122.435798567961 (37.7206567312996, -122.435798567961)
164109 237272 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 538 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007680.6262300005 2096843.5986400002 37.7379673029564 -122.415943393383 (37.7379673029564, -122.415943393383)
163597 213615 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 282 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995123.16436 2095604.38426 37.733850726423 -122.459270720479 (37.733850726423, -122.459270720479)
162967 237413 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 609 28th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001943.456730001 2099409.65107 37.744688862019 -122.43596314390498 (37.744688862019, -122.435963143905)
162550 179156 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1219 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001622.38743 2087558.0089200002 37.712128712138295 -122.436225349332 (37.7121287121383, -122.436225349332)
161672 237245 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 35 Carl St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5998451.09494 2107209.5961 37.7659065643726 -122.448600652915 (37.7659065643726, -122.448600652915)
161168 68950 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 734 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/1993 12:00:00 AM 6   Permit Number 32939 5988846.075 2110312.98983 37.7738737393837 -122.482049401575 (37.7738737393837, -122.482049401575)
161020 213320 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 238 Beverly St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   5991458.7746 2090762.7040099998 37.720345321258705 -122.47158680100901 (37.7203453212587, -122.471586801009)
160674 213538 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 350 Montecito Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995937.4596 2094121.86195 37.729826861018296 -122.456348312323 (37.7298268610183, -122.456348312323)
160653 237296 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 318 Banks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6008613.76154 2097186.10831 37.7389601778637 -122.41274128078899 (37.7389601778637, -122.412741280789)
160107 214516 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1203 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992147.44859 2106565.08379 37.76377444986029 -122.470356517645 (37.7637744498603, -122.470356517645)
159871 84412 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 569-571 03rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 6 3x3 Permit Number 51568 5994982.60822 2111689.36495 37.7780078944262 -122.460922053766 (37.7780078944262, -122.460922053766)
159738 237037 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 129 Octavia St 1 : 4 Tree 1 Private 1     6 Width 4ft   6005605.52362 2109755.39176 37.7733031977155 -122.42403599677601 (37.7733031977155, -122.424035996776)
158488 213529 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1301 Plymouth Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5995838.74514 2092736.52805 37.7260173993826 -122.45658943406201 (37.7260173993826, -122.456589434062)
158190 214659 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1843 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5990602.16808 2102840.10921 37.7534571944178 -122.475429125678 (37.7534571944178, -122.475429125678)
158021 237420 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 786 27th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6001431.26504 2100007.61032 37.7463016063345 -122.43777701799699 (37.7463016063345, -122.437777017997)
157642 237127 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 501 York St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6009827.96491 2105859.23915 37.7628427477209 -122.409154949944 (37.7628427477209, -122.409154949944)
157280 239430 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 161 Grand View Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000849.07941 2103428.1620400003 37.755660497437404 -122.440035369464 (37.7556604974374, -122.440035369464)
157218 55617 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 411 Laurel St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/13/1996 12:00:00 AM 6   Permit Number 20476 5998121.25588 2115028.99118 37.787357733409706 -122.45030520091998 (37.7873577334097, -122.45030520092)
156889 238085 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 651 Peralta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6009796.3574 2098347.03117 37.742214125595204 -122.408734270464 (37.7422141255952, -122.408734270464)
156165 237440 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 672 Clipper St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000969.29226 2100905.19941 37.7487398923386 -122.43943879157 (37.7487398923386, -122.43943879157)
154845 237185 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 78 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6004315.99922 2108931.71426 37.770968690784294 -122.428437919182 (37.7709686907843, -122.428437919182)
154532 238130 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 33 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005649.25678 2099318.91609 37.7446495499276 -122.42314274426201 (37.7446495499276, -122.423142744262)
153474 196471 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1 Middle Point Rd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6018269.46967 2096338.3756 37.7371696942217 -122.379297066815 (37.7371696942217, -122.379297066815)
153330 214830 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 16 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5996526.30071 2090008.918 37.718567477585204 -122.454015706561 (37.7185674775852, -122.454015706561)
152772 73662 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 828 Brannan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/11/1995 12:00:00 AM 6     6011416.18719 2109390.39573 37.7726273509159 -122.403910314231 (37.7726273509159, -122.403910314231)
152492 42978 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Oxford St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2000 12:00:00 AM 6   Permit Number 42862 6006544.924430001 2092660.29869 37.7264169636546 -122.41957336651699 (37.7264169636546, -122.419573366517)
152059 65922 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 22 South Park 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 6   Permit Number 28938 6014500.58115 2112811.20719 37.7821919655182 -122.393480434 (37.7821919655182, -122.393480434)
151641 237146 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 39 Linda St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6005833.50674 2105299.48759 37.7610812141382 -122.422930616648 (37.7610812141382, -122.422930616648)
150983 237317 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 51 Nebraska St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6009308.14908 2097734.72569 37.7405055117226 -122.41037912599701 (37.7405055117226, -122.410379125997)
150817 179141 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6011519.75007 2092135.2288799998 37.7252541978079 -122.402338614032 (37.7252541978079, -122.402338614032)
150517 238173 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 4055 24th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002831.86972 2101798.0482099997 37.7512972692768 -122.43306179878901 (37.7512972692768, -122.433061798789)
150500 214833 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 229 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5995622.68342 2091459.3417599997 37.7224981435639 -122.45724398941601 (37.7224981435639, -122.457243989416)
150273 179139 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 101 Woolsey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6011492.5608 2092126.86899 37.725229725463706 -122.40243201763799 (37.7252297254637, -122.402432017638)
150130 237132 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1298 York St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010041.12811 2101721.78657 37.7514941704216 -122.40812587822201 (37.7514941704216, -122.408125878222)
149886 237275 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 700 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007612.774619999 2096112.0363 37.7359547784861 -122.416126194979 (37.7359547784861, -122.416126194979)
149708 213331 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 151 Byxbee St 1 : 4 Tree 1 Private 1     6 Width 2ft   5991924.78555 2089552.6251599998 37.7170496899626 -122.469887910591 (37.7170496899626, -122.469887910591)
148807 239431 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 484 Romain St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6001158.98104 2103443.55676 37.75572040488029 -122.43896473732799 (37.7557204048803, -122.438964737328)
148057 214529 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 831 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993147.15611 2106598.8236599998 37.7639248407744 -122.466901317842 (37.7639248407744, -122.466901317842)
147947 238101 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 544 Capp St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6007241.27161 2104123.1464299997 37.7579305877392 -122.417978361313 (37.7579305877392, -122.417978361313)
147429 69497 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 55 Otsego Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/24/1994 12:00:00 AM 6   Permit Number 33620 6000865.527869999 2092792.12819 37.726457391768896 -122.439216186893 (37.7264573917689, -122.439216186893)
147327 214536 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 647 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993699.4039199995 2106621.4524 37.7640188316212 -122.464992916908 (37.7640188316212, -122.464992916908)
147280 135958 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2961 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   5999426.86428 2117337.28078 37.7937703214002 -122.44595416846701 (37.7937703214002, -122.445954168467)
147077 250761 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 228 32nd Ave 2 : 4 Tree 1 Private 1     6 Width 3ft   5985903.37202 2114379.41265 37.7848673829594 -122.49252807871001 (37.7848673829594, -122.49252807871)
146555 50298 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2909 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/28/2004 12:00:00 AM 6   Permit Number 47009 5989047.4642199995 2095832.2551400003 37.734125220204604 -122.48029267726999 (37.7341252202046, -122.48029267727)
145234 14624 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 14 Matthew Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/12/1998 12:00:00 AM 6 3X4   6018000.3078284 2094247.4364445 37.7314135402286 -122.38008243669701 (37.7314135402286, -122.380082436697)
141655 1576 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 605 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/16/1999 12:00:00 AM 6 3x3   5995596.544419999 2112077.2508400003 37.779108233448 -122.45882633362 (37.779108233448, -122.45882633362)

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