575 rows where qSpecies_id = 123 sorted by PermitNotes

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)
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
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
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
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
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
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                      
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
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
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
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
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
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
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
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
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
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
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
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
39857 8913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4455X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5993194.92162 2112721.50101 37.7807388335807 -122.467181309852 (37.7807388335807, -122.467181309852) 11 6 2 54 11
39867 91624 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1424 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007717.03025 2101352.89464 37.7503508716121 -122.416136791792 (37.7503508716121, -122.416136791792) 2 4 7 28859 19
40738 100424 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200X Stonecrest Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
41188 91672 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 1 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
41845 91616 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1200X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007645 2102652 37.7539138699857 -122.416477888477 (37.7539138699857, -122.416477888477) 2 4 7 28859 19
42098 241379 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3702 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008438.87775 2097614.97452 37.7401279331501 -122.413376271417 (37.7401279331501, -122.413376271417) 2 7 7 28859 2
42514 90572 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1932 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989583.92326 2110610.46088 37.7747333989447 -122.479518860914 (37.7747333989447, -122.479518860914) 11 6 2 55 26
42600 91638 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1453 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007765.644065 2101198.536844 37.7499297732176 -122.415957751819 (37.7499297732176, -122.415957751819) 2 4 7 28859 19
42648 241281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011465.9993 2101906.42682 37.7520808305785 -122.403211459137 (37.7520808305785, -122.403211459137) 10 4 8 28859 19
42736 241305 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 697 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 Width 3ft   6007530.22491 2105637.84626 37.7621058621135 -122.417086361543 (37.7621058621135, -122.417086361543) 8 4 7 28859 19
43080 241352 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009685.74216 2105928.63246 37.7630253172965 -122.409651748936 (37.7630253172965, -122.409651748936) 8 4 8 28859 19
43855 91617 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1200X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007645 2102652 37.7539138699857 -122.416477888477 (37.7539138699857, -122.416477888477) 2 4 7 28859 19
45380 91682 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007432.064539 2107206.199481 37.766406671896 -122.417537020573 (37.766406671896, -122.417537020573) 8 4 7 28853 19
46530 136183 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6006523.02231 2120459.93681 37.8027469916359 -122.421622667864 (37.8027469916359, -122.421622667864) 5 9 1 28858 32
46855 91705 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 4 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
48378 213853 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 339 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5996569.29854 2106950.59972 37.7650876471008 -122.455090641935 (37.7650876471008, -122.455090641935) 15 5 11 29492 12
48428 90571 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1900 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2008 12:00:00 AM 3 3x3   5989655.61233 2110613.51621 37.7747459519392 -122.479271100153 (37.7747459519392, -122.479271100153) 11 6 2 55 26
49326 91582 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270x South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007359 2108191 37.7691065911809 -122.417859552844 (37.7691065911809, -122.417859552844) 8 4 7 28853 19
50197 91660 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 999 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 3 3x3   6007618.393891 2103856.158531 37.7572187178563 -122.416655196612 (37.7572187178563, -122.416655196612) 2 4 7 28859 19
50595 241318 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 280 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007336.81249 2108065.49507 37.7687607355409 -122.417927400355 (37.7687607355409, -122.417927400355) 8 4 7 28853 19
51857 241278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010738.66995 2101021.37362 37.7496100223844 -122.405664352824 (37.7496100223844, -122.405664352824) 10 4 7 28859 19
52753 241325 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007441.87524 2107194.22963 37.766374357512 -122.417502238664 (37.766374357512, -122.417502238664) 8 4 7 28853 19
52926 241317 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007335.93397 2108086.9588 37.7688196204438 -122.417931960818 (37.7688196204438, -122.417931960818) 8 4 7 28853 19
53423 91645 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007675.941296 2102071.044433 37.7523204379956 -122.416329740365 (37.7523204379956, -122.416329740365) 2 4 7 28859 19
53461 196972 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014458.90845 2102627.41024 37.7542271903342 -122.392911888877 (37.7542271903342, -122.392911888877) 10 3 8 28856 29

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