575 rows where qSpecies_id = 123

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, qCaretaker_id, qCareAssistant, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Neighborhoods (old)

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)
599 78256 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6002680.72455 2088998.08405 37.7161429170478 -122.432670234864 (37.7161429170478, -122.432670234864) 9 7 6 28861 5
925 34964 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2019 12:00:00 AM 3   Permit Number 38553 6014444.74274 2102850.73033 37.7548395926778 -122.392976501569 (37.7548395926778, -122.392976501569) 10 3 8 28856 29
1297 241324 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 Width 3ft   6007395.81182 2106861.74234 37.765458833278 -122.417637995807 (37.765458833278, -122.417637995807) 8 4 7 28853 19
1298 91659 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1015 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007624.666917 2103742.941155 37.7569082017019 -122.4166254819 (37.7569082017019, -122.4166254819) 2 4 7 28859 19
2223 241387 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 43 Whitney St 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 Width 3ft   6004298.90777 2098020.68858 37.7410086185538 -122.42771950655 (37.7410086185538, -122.42771950655) 2 7 5 63 7
2485 59880 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2139 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/1981 12:00:00 AM 10   Permit Number 19345 6002701.87127 2118840.74506 37.7980849079605 -122.434729923369 (37.7980849079605, -122.434729923369) 13 9 1 57 17
3710 70389 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1942 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     5989540.17856 2110611.69098 37.7747342353889 -122.479670271059 (37.7747342353889, -122.479670271059) 11 6 2 55 26
4053 196973 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2019 12:00:00 AM 3 Width 4ft   6014457.83967 2102608.37301 37.7541748588033 -122.392914253189 (37.7541748588033, -122.392914253189) 10 3 8 28856 29
4479 83223 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1446-48 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2016 12:00:00 AM 3 3x3 Permit Number 50888 5993687.91761966 2105648.90031529 37.7613477954461 -122.464962006978 (37.7613477954461, -122.464962006978) 1 8 11 56 12
4592 196983 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
4814 72022 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 550 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6010599.26481 2116134.30998 37.7910988780658 -122.407211626534 (37.7910988780658, -122.407211626534) 5 1 10 28857 6
4885 71351 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 118 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2008 12:00:00 AM   3x3 Permit Number 50915 5999898.11886666 2105092.21291824 37.7601753897516 -122.44344360556 (37.7601753897516, -122.44344360556) 2 4 5 28862 3
5120 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 16 : Tree Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
5657 41933 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42292 5994729.71498 2111330.05881 37.7770067806052 -122.461770835952 (37.7770067806052, -122.461770835952) 11 6 2 54 11
5764 241323 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 Width 3ft   6007394.41265 2106888.07859 37.7655310677289 -122.417644702035 (37.7655310677289, -122.417644702035) 8 4 7 28853 19
6080 19758 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY15 16 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
6340 33134 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3107 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 10   Permit Number 37364 6001390.00916 2119109.09622 37.7987471650933 -122.439288583214 (37.7987471650933, -122.439288583214) 13 9 1 57 17
6410 91640 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1427 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007757.588641 2101343.923892 37.7503285203588 -122.415995902486 (37.7503285203588, -122.415995902486) 2 4 7 28859 19
6926 96580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 5 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
7828 196969 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015866.24342 2105844.60301 37.763138987107 -122.388269449981 (37.763138987107, -122.388269449981) 14 3 8 28856 29
7907 91707 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 6 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
8545 241289 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 9ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
9715 196963 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015947.26389 2105849.11258 37.7631558583726 -122.387989539601 (37.7631558583726, -122.387989539601) 14 3 8 28856 29
9813 201661 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 149 Dore St 1 : Tree Private 2     3 Width 2ft   6009207.44548 2109499.94346 37.7728044975557 -122.411558355748 (37.7728044975557, -122.411558355748) 8 2 9 28853 34
9823 19923 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
10563 220139 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
11064 196994 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 7 : Tree Private 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.394724774624 (37.7473596740254, -122.394724774624) 10 3 8 58 1
11610 241384 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008146.34247 2105906.05304 37.7628769363446 -122.414974425147 (37.7628769363446, -122.414974425147) 8 4 7 28859 19
13557 220140 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
13645 70110 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 79 Stoneyford Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6006114.15907 2093862.38939 37.7296933683514 -122.421147824905 (37.7296933683514, -122.421147824905) 9 7 7 28861 5
14811 241276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010713.5875 2101085.71194 37.7497852786664 -122.405755620526 (37.7497852786664, -122.405755620526) 10 4 7 28859 19
14948 90869 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2045 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2008 12:00:00 AM 3 3x3   5989208.80531 2110541.29026 37.7745216791694 -122.480811390162 (37.7745216791694, -122.480811390162) 11 6 2 55 26
14984 68126 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1331 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 8   Permit Number 31876 6013566.56944 2105672.60835 37.7625390358578 -122.396211251447 (37.7625390358578, -122.396211251447) 14 3 8 28856 29
15070 19922 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
15558 91677 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 599 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007489.042117 2106191.625958 37.7636240956729 -122.417268041752 (37.7636240956729, -122.417268041752) 8 4 7 28859 19
15597 91581 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200x South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007370.010963 2108444.137303 37.7698022661703 -122.417839412441 (37.7698022661703, -122.417839412441) 8 4 9 28853 19
15680 91641 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1401X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007749.533216 2101489.31094 37.7507272674606 -122.416034053567 (37.7507272674606, -122.416034053567) 2 4 7 28859 19
15698 241342 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2122 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009546.72381 2104789.44467 37.7598895755605 -122.410052140597 (37.7598895755605, -122.410052140597) 2 4 7 28859 19
16220 179280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010456.33755 2094955.50587 37.7329386663832 -122.406213356571 (37.7329386663832, -122.406213356571) 10 3 7 309 28
16388 241286 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
16406 241355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2970 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009659.81185 2101050.9246 37.7496307742409 -122.409397182327 (37.7496307742409, -122.409397182327) 2 4 7 28859 19
16550 88330 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 544 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51318 6001416.8 2090660.3 37.7206352284922 -122.437157897339 (37.7206352284922, -122.437157897339) 9 7 6 28861 5
16583 241346 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6009581.66758 2105919.15522 37.7629934624139 -122.410011039795 (37.7629934624139, -122.410011039795) 8 4 8 28859 19
17020 82125 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 317 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2008 12:00:00 AM 5 3x3 Permit Number 50070 6006739.55759841 2104266.9934198 37.75829730851 -122.41972370977 (37.75829730851, -122.41972370977) 2 4 7 28859 19
17382 35346 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1124 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 8   Permit Number 38809 6012181.54645 2103168.5427 37.7555862611206 -122.400825637793 (37.7555862611206, -122.400825637793) 10 3 8 28856 29
18173 241284 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011470.02474 2101959.91095 37.7522279111039 -122.403201300403 (37.7522279111039, -122.403201300403) 10 4 8 28859 19
19316 241287 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
20067 91584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 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
20176 196977 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 209 Mississippi St 6 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6014040.95878 2106120.30389 37.7637946944947 -122.394601850808 (37.7637946944947, -122.394601850808) 14 3 8 28856 29
20202 136176 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2134 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6002833.9768 2118210.69092 37.7963624418193 -122.434227733841 (37.7963624418193, -122.434227733841) 13 9 1 57 17
20599 196997 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 11 : Tree Private 2     7 Width 4ft   6013762.67186 2100131.60985 37.7473355578075 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
20731 63489 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 319 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50934 6006645.5795298 2096080.30995427 37.7358132351331 -122.419467931102 (37.7358132351331, -122.419467931102) 2 7 7 28859 2
21100 241341 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009762.27519 2105459.58065 37.7617416960496 -122.409353942929 (37.7617416960496, -122.409353942929) 2 4 8 28859 19
21871 246838 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 399 Broderick St 1 : Tree Private 2     5 Width 4ft   6001188.47767 2109990.61312 37.7736986862745 -122.439331993472 (37.7736986862745, -122.439331993472) 15 5 11 29492 10
22012 90575 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2008 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989345.62252 2110602.70137 37.7746982485552 -122.480342614213 (37.7746982485552, -122.480342614213) 11 6 2 55 26
22095 241295 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007154.42592 2107655.79566 37.7676255312226 -122.418529207767 (37.7676255312226, -122.418529207767) 8 4 7 28853 19
22119 241283 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011469.09548 2101944.76887 37.7521862823701 -122.403203448894 (37.7521862823701, -122.403203448894) 10 4 8 28859 19
22150 91686 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007415.631785 2107493.688708 37.7671951252581 -122.417614236777 (37.7671951252581, -122.417614236777) 8 4 7 28853 19
22157 197002 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2251 Silver Ave 3 : Tree Private 2     6 Width 3ft   6012830.37736 2096288.90355 37.7367324078692 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
22375 87991 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 222 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51029 6008096 2113166 37.7828082078679 -122.41566260373 (37.7828082078679, -122.41566260373) 7 10 9 28852 36
23399 101632 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 6 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
23421 90874 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1941 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5989523.27614 2110553.23403 37.7745727468597 -122.479724461021 (37.7745727468597, -122.479724461021) 11 6 2 55 26
23653 90897 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992033.67177 2110642.90774 37.7749644818454 -122.471047125233 (37.7749644818454, -122.471047125233) 11 6 2 54 11
23759 95623 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 201 Capp St 4 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
23905 96578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 8 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
24305 31508 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2419 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35068 6011299.52328 2102275.53688 37.7530850270762 -122.403813131691 (37.7530850270762, -122.403813131691) 10 4 8 28859 19
24904 91704 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 3 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
25076 241291 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1225 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011156.6405 2102469.67171 37.7536100953402 -122.404320914102 (37.7536100953402, -122.404320914102) 10 4 8 28859 19
25956 241315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007487.69135 2105254.04954 37.7610496524471 -122.417206271746 (37.7610496524471, -122.417206271746) 2 4 7 28859 19
26140 136187 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 840 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010038.55828 2116686.60963 37.7925839636381 -122.409190650353 (37.7925839636381, -122.409190650353) 3 1 10 28857 4
26438 90871 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2033 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2008 12:00:00 AM 3 3x3   5989249.74132 2110541.7912 37.7745254339062 -122.480669822879 (37.7745254339062, -122.480669822879) 11 6 2 55 26
27091 90555 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992035.9437 2110699.81053 37.7751208528883 -122.471043412514 (37.7751208528883, -122.471043412514) 11 6 2 54 11
27312 88136 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 321 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51162 5997690 2096237 37.7357349780848 -122.450442028597 (37.7357349780848, -122.450442028597) 9 7 4 59 40
27838 90576 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2020 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989294.17784 2110601.65647 37.7746923899334 -122.48052049321 (37.7746923899334, -122.48052049321) 11 6 2 55 26
29262 91646 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1271 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007705.648787 2102264.402582 37.7528530260896 -122.416240700263 (37.7528530260896, -122.416240700263) 2 4 7 28859 19
29419 91588 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007384.392817 2107339.273033 37.7667693781679 -122.417711341871 (37.7667693781679, -122.417711341871) 8 4 7 28853 19
30264 241366 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1399 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010111.5288 2101104.25474 37.7498025060946 -122.40783888207 (37.7498025060946, -122.40783888207) 2 4 7 28859 19
31101 88015 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 2 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
31202 246856 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 Divisadero St 1 : Tree Private 2     4 Width 3ft   6001680.71036 2109929.19364 37.773558043107 -122.437624887779 (37.773558043107, -122.437624887779) 15 5 11 29492 10
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 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
31987 39269 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1998 12:00:00 AM 5   Permit Number 40882 6010051.67469 2116602.92631 37.7923549243012 -122.409139359294 (37.7923549243012, -122.409139359294) 3 1 10 28857 4
32350 84048 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1006 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49723 5995065.73258922 2090627.8481306 37.7201830572422 -122.459109050516 (37.7201830572422, -122.459109050516) 9 8 6 28861 24
32482 65937 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2826 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1990 12:00:00 AM 7   Permit Number 28956 5999433.3119 2118083.73409 37.7958202522453 -122.445985572784 (37.7958202522453, -122.445985572784) 13 9 1 57 17
32834 241370 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009531.75591 2102750.92335 37.7542914163323 -122.409959999651 (37.7542914163323, -122.409959999651) 2 4 7 28859 19
33458 90872 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2027 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2008 12:00:00 AM 3 3x3   5989286.8509 2110543.19375 37.7745314416669 -122.480541557806 (37.7745314416669, -122.480541557806) 11 6 2 55 26
34046 31982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 232 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12 3x3 Permit Number 35382 5994946.26899 2113981.48738 37.7842993574965 -122.461213955921 (37.7842993574965, -122.461213955921) 11 6 2 54 11
35315 88470 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1519 Innes Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51424 6015916 2096861 37.7384746486807 -122.387470605672 (37.7384746486807, -122.387470605672) 10 3 8 58 1
35434 91607 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 882 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007541.210677 2104526.186296 37.759054118783 -122.416969598799 (37.759054118783, -122.416969598799) 2 4 7 28859 19
35939 91612 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1108 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007615.164408 2103191.40433 37.755393273338 -122.416619275738 (37.755393273338, -122.416619275738) 2 4 7 28859 19
36145 241371 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2865 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009580.01982 2102754.75587 37.7543046444459 -122.40979336069 (37.7543046444459, -122.40979336069) 2 4 7 28859 19
36193 90586 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2200X Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5988739.41652 2110581.09487 37.7746036774674 -122.482437994797 (37.7746036774674, -122.482437994797) 11 6 2 55 26
37335 241348 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009609.90256 2105923.09061 37.7630058505491 -122.409913662092 (37.7630058505491, -122.409913662092) 8 4 8 28859 19
38784 22263 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1997 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
38813 90554 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992007.5751 2110699.64473 37.7751187568292 -122.471141532792 (37.7751187568292, -122.471141532792) 11 6 2 54 11
38921 91625 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1434 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007720.12849 2101296.976541 37.7501975073399 -122.416122118115 (37.7501975073399, -122.416122118115) 2 4 7 28859 19
39070 241380 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4050 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008348.5979 2096262.44881 37.7364091240834 -122.413592786804 (37.7364091240834, -122.413592786804) 10 7 7 28859 2
39352 136186 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010043.14101 2116645.97985 37.7924726608324 -122.40917192557 (37.7924726608324, -122.40917192557) 3 1 10 28857 4
39500 32941 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1546 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 12   Permit Number 37260 6013066.21805 2105223.63069 37.7612783887065 -122.397910300117 (37.7612783887065, -122.397910300117) 10 3 8 28856 29
39664 94083 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1355 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM 2 3x3 Permit Number 53468 6007661.58372 2117803.95708 37.7955184712527 -122.41749431113 (37.7955184712527, -122.41749431113) 5 1 10 28858 32
39809 88509 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way 4 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

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)
);