575 rows where qSpecies_id = 123 sorted by rowid descending

View and edit SQL

rowid ▲ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
193922 179281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010435.48171 2094947.68687 37.7329160304499 -122.406284910247 (37.7329160304499, -122.406284910247) 10 3 7 309 28
193907 196992 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 5 : Tree Private 2     7 Width 4ft   6013942.24849 2100140.56785 37.7473701394162 -122.394524516312 (37.7473701394162, -122.394524516312) 10 3 8 58 1
193578 241299 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007561.10393 2105083.16851 37.7605845824436 -122.416940261287 (37.7605845824436, -122.416940261287) 2 4 7 28859 19
193505 91666 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007551.894714 2105056.665982 37.7605112945984 -122.416970234051 (37.7605112945984, -122.416970234051) 2 4 7 28859 19
193442 101629 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
193441 179277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 716 Peru Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6005276.23831 2092458.42558 37.7257911200544 -122.423944813618 (37.7257911200544, -122.423944813618) 9 7 6 309 5
191980 123105 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 498 11th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992529.16869 2112181.64232 37.7792180760249 -122.469445141648 (37.7792180760249, -122.469445141648) 11 6 2 54 11
191286 90883 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1827 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5989887.73623 2110565.21832 37.7746268180643 -122.478464612476 (37.7746268180643, -122.478464612476) 11 6 2 55 26
191217 22252 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4544 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1993 12:00:00 AM 6 3x3   6015060.7997 2096239.5516 37.7367208751663 -122.390384090827 (37.7367208751663, -122.390384090827) 10 3 8 58 1
190579 241272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 67 Webster St 1 : Tree Private 2     13 Width 4ft   6004275.92505 2108860.93687 37.7707720854826 -122.428571490982 (37.7707720854826, -122.428571490982) 7 9 11 29492 10
190505 85250 - 12 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1335 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
190395 91010 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2134 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/17/2008 12:00:00 AM 3 3x3   5988937.91177 2110588.16813 37.7746346435588 -122.481751886766 (37.7746346435588, -122.481751886766) 11 6 2 55 26
190029 241343 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2170 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009555.07772 2104672.73912 37.7595695967776 -122.410015009398 (37.7595695967776, -122.410015009398) 2 4 7 28859 19
188806 90577 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2050X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989223.999 2110597.65544 37.7746773254621 -122.480762960202 (37.7746773254621, -122.480762960202) 11 6 2 55 26
188771 91621 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1358 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007694.688201 2101746.136705 37.7514293691601 -122.416241900686 (37.7514293691601, -122.416241900686) 2 4 7 28859 19
188061 90880 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1901X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5989653.27368 2110557.04805 37.7745907701264 -122.479275058131 (37.7745907701264, -122.479275058131) 11 6 2 55 26
187830 91683 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 395 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007421.389304 2107392.96146 37.7669188758381 -122.41758718246 (37.7669188758381, -122.41758718246) 8 4 7 28853 19
187496 241285 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011473.17853 2101977.48291 37.75227633599 -122.403191629999 (37.75227633599, -122.403191629999) 10 4 8 28859 19
186656 241344 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009557.96176 2104644.45965 37.7594921093986 -122.410003038507 (37.7594921093986, -122.410003038507) 2 4 7 28859 19
186419 100315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1683 Galvez Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6015443.91077 2097940.33755 37.7414121299803 -122.389178220304 (37.7414121299803, -122.389178220304) 10 3 8 58 1
185524 91700 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 143 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007354.401692 2109023.98005 37.7713934987847 -122.417934514554 (37.7713934987847, -122.417934514554) 8 2 9 28853 19
184445 196996 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 10 : Tree Private 2     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335) 10 3 8 58 1
184282 25586 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150X Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1997 12:00:00 AM 30 3X3   6008754.8829591 2097365.1323636 37.7394596586207 -122.412265995986 (37.7394596586207, -122.412265995986) 10 7 7 28859 2
184093 197003 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 503 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6015964.6605 2113962.87673 37.7854354289412 -122.38849574371 (37.7854354289412, -122.38849574371) 6 2 9 28856 6
183387 22238 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4420 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/1993 12:00:00 AM 6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
182299 87977 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1372 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51013 6001285 2110422 37.7748886587191 -122.43902903105 (37.7748886587191, -122.43902903105) 15 5 11 29492 10
182007 90886 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1715 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5990248.62617 2110577.36646 37.7746811185578 -122.477217123809 (37.7746811185578, -122.477217123809) 11 6 2 55 26
182003 39270 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1998 12:00:00 AM 3   Permit Number 40882 6010056.25648 2116573.77784 37.7922751463304 -122.409121448409 (37.7922751463304, -122.409121448409) 3 1 10 28857 4
181888 241310 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007485.43036 2106430.0255 37.7642784820932 -122.417297428844 (37.7642784820932, -122.417297428844) 8 4 7 28859 19
181100 90574 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1950 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989503.12005 2110610.6462 37.7747292138807 -122.479798386077 (37.7747292138807, -122.479798386077) 11 6 2 55 26
180939 136175 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3103 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001391.85411 2119087.81282 37.7986888314695 -122.439280672761 (37.7986888314695, -122.439280672761) 13 9 1 57 17
180744 87970 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
180734 241381 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008153.50864 2105811.23118 37.7626169800981 -122.414942928177 (37.7626169800981, -122.414942928177) 8 4 7 28859 19
180230 96584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
180009 88506 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51444 5994359.2 2093914.2 37.7291659423967 -122.461789444316 (37.7291659423967, -122.461789444316) 9 8 4 59 40
179949 91585 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007359.06414 2107782.395856 37.7679846640127 -122.417830363455 (37.7679846640127, -122.417830363455) 8 4 7 28853 19
178993 179276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 716 Peru Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6005258.78381 2092467.95462 37.7258162992748 -122.424005829932 (37.7258162992748, -122.424005829932) 9 7 6 309 5
177703 91647 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1271 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007705.648787 2102264.402582 37.7528530260896 -122.416240700263 (37.7528530260896, -122.416240700263) 2 4 7 28859 19
177434 91643 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1367 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007737.207562 2101703.625981 37.7513150351075 -122.416091852961 (37.7513150351075, -122.416091852961) 2 4 7 28859 19
177426 241314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 722 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.75646 2105385.74126 37.7614106322283 -122.417253423206 (37.7614106322283, -122.417253423206) 2 4 7 28859 19
177404 91685 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 383 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 3 3x3   6007417.550959 2107460.112945 37.7671030420828 -122.417605218645 (37.7671030420828, -122.417605218645) 8 4 7 28853 19
177005 91676 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 629 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007499.688693 2105999.37525 37.7630968189144 -122.417217594449 (37.7630968189144, -122.417217594449) 8 4 7 28859 19
176816 91702 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
176735 241332 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 263 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007398.28361 2108137.64954 37.7689623140896 -122.417719890785 (37.7689623140896, -122.417719890785) 8 4 7 28853 19
176637 241338 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2709 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009715.56008 2105456.2423 37.7617299122363 -122.409515276828 (37.7617299122363, -122.409515276828) 2 4 8 28859 19
176344 88191 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 355 Tehama St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51196 6011553 2112651 37.7815878594503 -122.403666522452 (37.7815878594503, -122.403666522452) 6 2 9 28853 34
176314 196982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
176270 91644 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1343 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007729.450223 2101838.070556 37.7516837533185 -122.416128199355 (37.7516837533185, -122.416128199355) 2 4 7 28859 19
176194 241296 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007156.61283 2107616.82741 37.7675186566968 -122.41851887996 (37.7675186566968, -122.41851887996) 8 4 7 28853 19
175714 241337 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2711 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009686.38177 2105455.07073 37.761725060389 -122.409616110618 (37.761725060389, -122.409616110618) 2 4 8 28859 19
175176 84150 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3324-3330 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50579 6007386.65215888 2105022.29149516 37.7604076136969 -122.417539297454 (37.7604076136969, -122.417539297454) 2 4 7 28859 19
174823 88016 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51043 6008723.4 2112463.6 37.780914833514 -122.413442364822 (37.780914833514, -122.413442364822) 7 10 9 28852 36
174631 91637 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1459 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007767.503009 2101164.985993 37.749837754658 -122.415948947877 (37.749837754658, -122.415948947877) 2 4 7 28859 19
174039 22279 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 3 Sidewalk: Curb side : Cutout Tree Arts Commission 19     6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
173753 87969 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
173251 86867 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1386 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/18/2007 12:00:00 AM   3x3 Permit Number 49799 6007535 2117833.1 37.7955913672303 -122.417934380535 (37.7955913672303, -122.417934380535) 5 1 10 28858 32
172942 84198 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
172506 88317 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 670 Edinburg St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51308 6002238.5 2089937.8 37.7186980790536 -122.434265915388 (37.7186980790536, -122.434265915388) 9 7 6 28861 5
172028 96582 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
171747 91681 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
171562 88315 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 157 Edinburg St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51306 6004192.4 2092727.9 37.7264697879052 -122.427710754996 (37.7264697879052, -122.427710754996) 9 7 6 28861 5
171522 91648 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007697.947405 2102409.42617 37.7532507948704 -122.416277603857 (37.7532507948704, -122.416277603857) 2 4 7 28859 19
170905 196976 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 209 Mississippi St 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014043.63491 2106091.78418 37.7637165344031 -122.39459059759 (37.7637165344031, -122.39459059759) 14 3 8 28856 29
170751 90866 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2151X Cabrillo St 5 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2008 12:00:00 AM 3 3x3   5988924.29434 2110530.35666 37.7744751174123 -122.481794756145 (37.7744751174123, -122.481794756145) 11 6 2 55 26
170652 179279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Pioche St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6006275.12702 2093408.77207 37.7284569075468 -122.420559152977 (37.7284569075468, -122.420559152977) 9 7 7 309 5
170208 91664 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 815 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007560.040875 2104909.5668 37.7601078524477 -122.4169316378 (37.7601078524477, -122.4169316378) 2 4 7 28859 19
170158 196985 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
170027 22282 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 6 Sidewalk: Curb side : Cutout Tree Arts Commission 19     4 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
169587 83336 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1800-1804 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 4 3x3 Permit Number 52336 6004282.92403 2119104.69719 37.7988992854406 -122.429277851819 (37.7988992854406, -122.429277851819) 13 9 1 57 17
169285 32320 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3337 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1996 12:00:00 AM 4   Permit Number 36887 6009057.01923 2099240.26466 37.7446253105111 -122.411353770753 (37.7446253105111, -122.411353770753) 2 7 7 28859 2
168607 196986 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
168558 241302 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007545.5728 2105350.70249 37.7613182952255 -122.417012932805 (37.7613182952255, -122.417012932805) 2 4 7 28859 19
167044 241320 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007347.08663 2107747.30956 37.7678876512341 -122.417869305024 (37.7678876512341, -122.417869305024) 8 4 7 28853 19
166189 96581 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
165115 241383 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6008148.21617 2105873.00555 37.7627863008585 -122.414965605482 (37.7627863008585, -122.414965605482) 8 4 7 28859 19
164866 91649 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007697.947405 2102409.42617 37.7532507948704 -122.416277603857 (37.7532507948704, -122.416277603857) 2 4 7 28859 19
164484 241331 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 315 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007407.0994 2107837.87856 37.7681397096173 -122.417668147376 (37.7681397096173, -122.417668147376) 8 4 7 28853 19
164480 84201 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
163999 94082 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1355 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM 3 3x3 Permit Number 53468 6007647.44648 2117801.56463 37.7955111067173 -122.41754305889 (37.7955111067173, -122.41754305889) 5 1 10 28858 32
163714 90587 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2200X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5988720.72128 2110579.96701 37.7745994931186 -122.482502581896 (37.7745994931186, -122.482502581896) 11 6 2 55 26
163539 95622 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 201 Capp St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767388 6007162.9 2106147.3 37.7634840327412 -122.418392924595 (37.7634840327412, -122.418392924595) 8 4 7 28859 19
163314 22266 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
163157 85249 - 12 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1335 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
163045 91611 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1086 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007607.027989 2103338.253155 37.7557960290434 -122.416657816418 (37.7557960290434, -122.416657816418) 2 4 7 28859 19
162699 22272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4720 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/1995 12:00:00 AM 6 3x3   6014914.77079 2095774.79236 37.7354366396256 -122.390856509346 (37.7354366396256, -122.390856509346) 10 3 8 58 1
162673 241334 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007405.72375 2108268.9659 37.7693232965496 -122.417703464652 (37.7693232965496, -122.417703464652) 8 4 7 28853 19
162540 87971 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
161656 88185 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 493 Clementina St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51192 6010910.3 2111721.3 37.7789991980081 -122.405824460674 (37.7789991980081, -122.405824460674) 14 2 9 28853 34
161394 91673 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007532.676036 2105403.706321 37.7614631059869 -122.417061293148 (37.7614631059869, -122.417061293148) 2 4 7 28859 19
161073 84202 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
161059 90582 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2100X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989019.95807 2110588.86895 37.7746413386268 -122.481468126933 (37.7746413386268, -122.481468126933) 11 6 2 55 26
160938 241304 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007541.98711 2105410.71397 37.7614828711499 -122.417029586455 (37.7614828711499, -122.417029586455) 2 4 7 28859 19
160886 196978 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1551 20th St 1 : Tree Private 2     6 Width 4ft   6013296.03231 2104723.49575 37.7599179239891 -122.397080394946 (37.7599179239891, -122.397080394946) 10 3 8 28856 29
160670 241349 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009630.95541 2105923.95007 37.7630093903014 -122.409840907855 (37.7630093903014, -122.409840907855) 8 4 8 28859 19
160657 37985 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 570 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 11   Permit Number 40207 6013793.63158 2104435.25023 37.7591541522658 -122.395339235527 (37.7591541522658, -122.395339235527) 10 3 8 28856 29
160517 241330 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 335 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007413.91501 2107730.15032 37.7678442967163 -122.417636936423 (37.7678442967163, -122.417636936423) 8 4 7 28853 19
159489 241280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1334 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010312.03054 2101467.09279 37.7508100021879 -122.40717110848 (37.7508100021879, -122.40717110848) 2 4 7 28859 19
158272 91620 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1290 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007671.629207 2102150.724826 37.7525389797951 -122.41635029552 (37.7525389797951, -122.41635029552) 2 4 7 28859 19
157957 88525 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 626x Funston Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51466 5991969.3 2111151 37.7763558419216 -122.471306826694 (37.7763558419216, -122.471306826694) 11 6 2 54 11
157891 241292 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1223 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011155.71596 2102482.72814 37.7536458937577 -122.404325030294 (37.7536458937577, -122.404325030294) 10 4 8 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);