Street_Tree_List

Data source: data.sfgov.org

490 rows where qSpecies = 66 sorted by rowid descending

View and edit SQL

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

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
189037 206564 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2044 10th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993156.7665 2101574.66751 37.7501303674196 -122.46650288401399 (37.7501303674196, -122.466502884014)
188288 206675 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 300 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5995199.651459999 2095433.83543 37.733386838132 -122.458993938825 (37.733386838132, -122.458993938825)
188155 206686 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 629 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5996075.5527099995 2095969.20127 37.7349071348466 -122.456004412496 (37.7349071348466, -122.456004412496)
188058 206537 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 401 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994067.3294 2101503.80633 37.7499883024325 -122.46334898679 (37.7499883024325, -122.46334898679)
187736 206608 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2 Sola Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5994960.813709999 2100721.5804 37.7478919422595 -122.460202627649 (37.7478919422595, -122.460202627649)
187180 223054 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 701 Church St 15 Front Yard : Yard 7 Tree 1 Private 1     5 Width 3ft   6004339.171130001 2104460.25399 37.758692444824206 -122.42803907256099 (37.7586924448242, -122.428039072561)
186978 190925 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 651 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6011562.1933699995 2105343.91486 37.761524784975 -122.40312057635 (37.761524784975, -122.40312057635)
186945 206566 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2679 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991741.264830001 2097200.972 37.738039538296206 -122.471079130991 (37.7380395382962, -122.471079130991)
186544 63000 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1251 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/22/1986 12:00:00 AM 2   Permit Number 23408 5983028.2339 2106580.2336 37.763284575331795 -122.50189769196899 (37.7632845753318, -122.501897691969)
186378 206627 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 40 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994076.75455 2101874.6545700002 37.751007100296604 -122.463343302157 (37.7510071002966, -122.463343302157)
185968 206624 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 80 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5994298.51296 2101800.2527099997 37.7508155851791 -122.46257104893 (37.7508155851791, -122.46257104893)
185933 47492 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 657 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45386 6001676.19021 2093232.03842 37.7277113821718 -122.43644523806499 (37.7277113821718, -122.436445238065)
185534 176074 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 786 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001892.13578 2089268.05693 37.7168394482606 -122.435415271495 (37.7168394482606, -122.435415271495)
185359 206567 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2523 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5991381.7608900005 2098233.80223 37.74085462674589 -122.472397375252 (37.7408546267459, -122.472397375252)
185239 206500 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 245 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5993474.546519999 2104572.66216 37.7583804205467 -122.465621770525 (37.7583804205467, -122.465621770525)
184549 206626 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 40 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994084.99265 2101862.2244599997 37.750973444992205 -122.46331391231199 (37.7509734449922, -122.463313912312)
184245 50918 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2477 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM 3   Permit Number 47420 5989820.2795 2098517.5722 37.7415432867093 -122.477817075256 (37.7415432867093, -122.477817075256)
183187 206695 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 140 Hamerton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001321.914580001 2095363.51303 37.7335437842173 -122.437822570471 (37.7335437842173, -122.437822570471)
182763 206550 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 308 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5994328.73662 2100761.78102 37.7479659456765 -122.46239122047199 (37.7479659456765, -122.462391220472)
181904 206517 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5991060.290580001 2104484.56084 37.7579989703891 -122.473964824336 (37.7579989703891, -122.473964824336)
181807 206656 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994277.8238699995 2101540.85875 37.75010216378529 -122.46262377888 (37.7501021637853, -122.46262377888)
181759 206559 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 355 Yerba Buena Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5995306.63453 2095221.10602 37.7328088843117 -122.458608676455 (37.7328088843117, -122.458608676455)
180708 65972 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2090 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/1991 12:00:00 AM 2   Permit Number 28996 5989155.2561 2101119.0911 37.74864775647529 -122.480306841406 (37.7486477564753, -122.480306841406)
179932 206676 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 240 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5994971.50428 2095856.22795 37.7345335069973 -122.459813287749 (37.7345335069973, -122.459813287749)
179119 206587 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 348 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994044.71238 2099771.06427 37.745229328484704 -122.46330147648099 (37.7452293284847, -122.463301476481)
179097 30759 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1563 Thomas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/31/2005 12:00:00 AM 5   Permit Number 48354 6014932.9973 2093776.0212 37.7299494300904 -122.39065386327499 (37.7299494300904, -122.390653863275)
177940 206677 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 228 Yerba Buena Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5994904.4684 2095946.32835 37.7347770452256 -122.46005157662901 (37.7347770452256, -122.460051576629)
177824 249686 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2400 Baker St 18 Front Yard : Yard 7 Tree 1 Private 1     4     5999708.23219 2117360.34158 37.7938497027636 -122.444982272037 (37.7938497027636, -122.444982272037)
177772 206633 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994552.3071099995 2100925.23177 37.7484276117632 -122.461629977659 (37.7484276117632, -122.461629977659)
177415 223049 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Hartford St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002666.83309 2105626.92623 37.7618010890622 -122.433906166852 (37.7618010890622, -122.433906166852)
176558 38592 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1618 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/17/1998 12:00:00 AM 2   Permit Number 40547 6015152.7308 2094735.8699 37.7325971695789 -122.389961235194 (37.7325971695789, -122.389961235194)
176273 206546 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 265 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994442.894180001 2100449.8026 37.747115904674004 -122.46197385141399 (37.747115904674, -122.461973851414)
176247 206515 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5991033.61709 2104484.17502 37.7579963659675 -122.47405704351601 (37.7579963659675, -122.474057043516)
175387 126379 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1136 Havens St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6007507.74968 2119357.27743 37.7997748437807 -122.418136782297 (37.7997748437807, -122.418136782297)
175342 200074 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1500 Van Dyke Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)
175120 206659 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 41 Alton Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994198.61036 2101541.1054 37.750098278721 -122.462897719553 (37.750098278721, -122.462897719553)
175013 206619 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 181 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5994070.38957 2104649.5630900003 37.758625920162295 -122.463566678468 (37.7586259201623, -122.463566678468)
174659 206543 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 347 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994159.12368 2101087.0695700003 37.7488493371331 -122.463001327749 (37.7488493371331, -122.463001327749)
174439 206625 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 80 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994283.13326 2101793.571 37.7507963531822 -122.46262374828999 (37.7507963531822, -122.46262374829)
174299 126377 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 122 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6001345.97363 2121147.25207 37.8043408951819 -122.439587150049 (37.8043408951819, -122.439587150049)
174269 223032 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 281 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006256.18709 2096109.4549 37.735871320489395 -122.42081628443898 (37.7358713204894, -122.420816284439)
174016 65967 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2562 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/1990 12:00:00 AM 7   Permit Number 28991 5989886.449 2097917.9756 37.7399007896882 -122.477544471364 (37.7399007896882, -122.477544471364)
173694 95910 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1863 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2011 12:00:00 AM 2 3x3 Permit Number 767611 5986268.2408 2102571.6706 37.75246795898221 -122.49039681822201 (37.7524679589822, -122.490396818222)
173302 183679 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 3627 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5984438.7811 2106305.4338 37.7626128114068 -122.49699886391899 (37.7626128114068, -122.496998863919)
172567 206643 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 196 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994392.211730001 2100761.6142700003 37.74796914278121 -122.462171715751 (37.7479691427812, -122.462171715751)
171944 206514 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5991006.3222 2104484.4348 37.7579954981234 -122.47415145883801 (37.7579954981234, -122.474151458838)
171923 206534 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 665 Miramar Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5995362.10243 2093779.40423 37.7288535085691 -122.45831259717501 (37.7288535085691, -122.458312597175)
171736 206609 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 44 Sola Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994867.729069999 2100768.79557 37.7480162285692 -122.46052792862601 (37.7480162285692, -122.460527928626)
171652 206516 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5991047.261080001 2104483.88717 37.7579963659448 -122.474009836278 (37.7579963659448, -122.474009836278)
171384 206647 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 180 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994503.49405 2100867.53113 37.748266370491 -122.461794587759 (37.748266370491, -122.461794587759)
171063 206569 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2435 14th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992009.07535 2098867.5883299997 37.7426311295378 -122.47027451837099 (37.7426311295378, -122.470274518371)
170727 206597 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5995049.66416 2100868.50319 37.7483004655893 -122.459906030335 (37.7483004655893, -122.459906030335)
170709 206644 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 180 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994467.924 2100831.48615 37.748165352368105 -122.46191497372 (37.7481653523681, -122.46191497372)
170640 137632 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2175 TURK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5999619.2063 2111878.8056 37.7787937523144 -122.44489608677401 (37.7787937523144, -122.444896086774)
170563 206605 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Magellan Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995038.86988 2100730.57279 37.7479211225827 -122.459933366148 (37.7479211225827, -122.459933366148)
168564 206601 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5995052.26314 2100785.00395 37.7480713471357 -122.45989099549601 (37.7480713471357, -122.459890995496)
168083 32398 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 244 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/03/1996 12:00:00 AM 8   Permit Number 36939 6005971.23324 2096091.5920900002 37.7358062077876 -122.42180021560199 (37.7358062077876, -122.421800215602)
168058 223039 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 543 Moultrie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007708.387180001 2096815.6091900002 37.7378920108046 -122.41584542843201 (37.7378920108046, -122.415845428432)
167831 206678 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995925.9256 2096013.7330599998 37.7350208190394 -122.456524941888 (37.7350208190394, -122.456524941888)
167733 206503 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1957 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5993135.46016 2102179.05998 37.751788644440495 -122.46662048837 (37.7517886444405, -122.46662048837)
166442 206532 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 San Aleso Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993345.963169999 2094536.94274 37.730817459756 -122.46533747775 (37.730817459756, -122.46533747775)
165826 206688 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 629 Los Palmos Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5996101.05251 2095948.39142 37.7348514596286 -122.455914747394 (37.7348514596286, -122.455914747394)
165652 206674 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 300 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995208.64941 2095407.77696 37.7333158051714 -122.458960944512 (37.7333158051714, -122.458960944512)
165477 206591 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 101 Montalvo Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993709.625030001 2099698.37793 37.745010439781296 -122.464454865994 (37.7450104397813, -122.464454865994)
165454 206630 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 81 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994323.8061 2101846.4166200003 37.7509437961254 -122.46248693172701 (37.7509437961254, -122.462486931727)
165172 50986 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1120REVISED Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/06/2004 12:00:00 AM 6   Permit Number 47576 6007503.31376 2119893.93908 37.801248132044 -122.418190201138 (37.801248132044, -122.418190201138)
164832 71420 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 637 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/26/1995 12:00:00 AM 5     6009832.0273 2120182.0847 37.8021701092209 -122.410152151595 (37.8021701092209, -122.410152151595)
164769 206602 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 Magellan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5995047.859019999 2100763.4476 37.7480119055303 -122.45990466338101 (37.7480119055303, -122.459904663381)
164342 249691 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2400 Baker St 23 Front Yard : Yard 7 Tree 1 Private 1     1     5999714.93782 2117284.79533 37.793642655433004 -122.44495363669701 (37.793642655433, -122.444953636697)
164232 206634 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 145 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5994552.462069999 2100915.6770099998 37.748401385725 -122.461628749166 (37.748401385725, -122.461628749166)
163888 38590 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 1614 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/17/1998 12:00:00 AM 2   Permit Number 40545 6015168.4288 2094722.1342 37.732560324707705 -122.38990600380698 (37.7325603247077, -122.389906003807)
162977 223033 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 281 Richland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6006248.27078 2096110.4955099998 37.735873731571395 -122.420843728155 (37.7358737315714, -122.420843728155)
162481 206599 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 150 Magellan Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5995053.984619999 2100829.4455 37.748193471465704 -122.459888261529 (37.7481934714657, -122.459888261529)
162090 206642 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 196 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994408.53923 2100777.89876 37.7480147959636 -122.46211643714899 (37.7480147959636, -122.462116437149)
161837 206649 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 180 Castenada Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   5994518.46873 2100904.0082799997 37.7483673895631 -122.461745450587 (37.7483673895631, -122.461745450587)
161600 206530 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 175 Garcia Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   5994631.6545 2099433.40276 37.744335991408896 -122.46124747260099 (37.7443359914089, -122.461247472601)
161050 199671 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1905 Keith St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6015210.0019 2093419.3228 37.728985371993396 -122.389671313679 (37.7289853719934, -122.389671313679)
160923 206700 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 860 Teresita Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998900.2822900005 2095547.61505 37.7339112849776 -122.446208054284 (37.7339112849776, -122.446208054284)
160564 31753 Permitted Site 1 Crataegus laevigata :: English Hawthorn 66 2642 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM 6   Permit Number 35239 5989905.4007 2097364.9943 37.738383545459 -122.477438539611 (37.738383545459, -122.477438539611)
160435 206511 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5990966.24876 2104480.85465 37.757983346478795 -122.474289787164 (37.7579833464788, -122.474289787164)
160368 126382 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1001 Vallejo St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 4ft   6008670.39988 2118624.74661 37.7978288673746 -122.414061717575 (37.7978288673746, -122.414061717575)
160214 206681 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995960.60425 2096012.63655 37.735019799206 -122.45640496693399 (37.735019799206, -122.456404966934)
159806 249677 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2400 Baker St 9 Front Yard : Yard 7 Tree 1 Private 1     9     5999741.70445 2117184.6990900002 37.79336934518339 -122.444853823654 (37.7933693451834, -122.444853823654)
158851 223045 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 13 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6008341.10325 2099446.02772 37.745150110794896 -122.413843827126 (37.7451501107949, -122.413843827126)
158121 206588 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 348 Magellan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994058.29292 2099782.40477 37.7452612490171 -122.463255340382 (37.7452612490171, -122.463255340382)
158004 223037 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 203 Surrey St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002071.560219999 2096098.27883 37.7356038810064 -122.435283373351 (37.7356038810064, -122.435283373351)
157581 206499 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 245 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   5993488.07663 2104571.6485200003 37.7583784177465 -122.46557490416001 (37.7583784177465, -122.46557490416)
157297 206589 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 340 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5994086.716030001 2099812.2565200003 37.7453448518007 -122.463159224416 (37.7453448518007, -122.463159224416)
157129 206655 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Alton Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994255.40167 2101538.8525799997 37.7500953640099 -122.462701170033 (37.7500953640099, -122.462701170033)
157023 206694 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 125 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6001630.15209 2095380.35715 37.733607556928 -122.43675811218999 (37.733607556928, -122.43675811219)
156749 126384 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1120 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     4     6007500.24433 2119896.2377400002 37.8012542708165 -122.418200985801 (37.8012542708165, -122.418200985801)
156496 206639 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 175 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5994510.39425 2100823.8744099997 37.748146897381794 -122.461767562235 (37.7481468973818, -122.461767562235)
155632 206594 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 135 Magellan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5995087.43611 2100841.3404599996 37.7482280558 -122.459773449604 (37.7482280558, -122.459773449604)
155591 206679 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 657 Los Palmos Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5995939.36036 2096013.8239 37.7350218397738 -122.456478499997 (37.7350218397738, -122.456478499997)
155564 223055 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 42 Sussex St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6002598.631 2096412.43412 37.7364963969952 -122.433483533142 (37.7364963969952, -122.433483533142)
154984 206629 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 81 Ventura Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994298.95446 2101835.26425 37.7509117433916 -122.46257206157101 (37.7509117433916, -122.462572061571)
153873 206585 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 368 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993961.3420400005 2099692.54098 37.745008919941 -122.463584056983 (37.745008919941, -122.463584056983)
153437 206522 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2204 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991046.63721 2100321.91518 37.7465686447317 -122.47370838535801 (37.7465686447317, -122.473708385358)
153258 206575 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 120 Montalvo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5993692.18131 2099632.63233 37.744828913423 -122.464510409921 (37.744828913423, -122.464510409921)
153105 206509 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990938.9472 2104480.79856 37.75798161076639 -122.47438420248501 (37.7579816107664, -122.474384202485)

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