575 rows where qSpecies_id = 123 sorted by Zip Codes

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)
6080 19758 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY15 16 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
9823 19923 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
15070 19922 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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
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
55308 88011 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 144 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51041 6008609 2112967 37.7822906254359 -122.413873752004 (37.7822906254359, -122.413873752004) 7 10 9 28852 36
61643 88017 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 601 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51044 6008420 2114150 37.7855282422492 -122.414611351671 (37.7855282422492, -122.414611351671) 7 10 9 28852 36
65987 87988 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
66669 88027 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 121 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51050 6008492.3 2112899.8 37.7820995557553 -122.414272727386 (37.7820995557553, -122.414272727386) 7 10 9 28852 36
67085 241273 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 55 Haight St 2 : Tree Private 2     3 Width 3ft   6005874.88911 2109629.37494 37.7729723901943 -122.423095264536 (37.7729723901943, -122.423095264536) 7 9 11 28852 10
87658 87989 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
88344 87993 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 248 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51031 6008142.6 2113255.6 37.7830568472778 -122.415507732402 (37.7830568472778, -122.415507732402) 7 10 9 28852 36
92525 88014 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 1 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
99310 87994 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 248 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51031 6008142.6 2113255.6 37.7830568472778 -122.415507732402 (37.7830568472778, -122.415507732402) 7 10 9 28852 36
110478 88010 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 301 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51039 6008988 2113534 37.7838687491965 -122.412602670053 (37.7838687491965, -122.412602670053) 7 10 9 28852 36
119445 87990 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
143335 87451 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 345 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2007 12:00:00 AM 3 3x3   6005911.17036 2110956.31285 37.7766178884522 -122.423064096477 (37.7766178884522, -122.423064096477) 7 9 11 28852 10
155593 87995 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 120 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51032 6009094.1 2112956.3 37.7822884772374 -122.412194758861 (37.7822884772374, -122.412194758861) 14 10 9 28852 36
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
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
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
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
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
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
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
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
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
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
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
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
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
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
49759 88162 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 365 Clementina St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51185 6011732.3 2112447.5 37.7810391100489 -122.40303190845 (37.7810391100489, -122.40303190845) 6 2 9 28853 34
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
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
53988 91694 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007404.295323 2108246.270012 37.7692608986091 -122.417706796624 (37.7692608986091, -122.417706796624) 8 4 7 28853 19
56814 241333 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 259 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007398.77752 2108173.34419 37.7690603509832 -122.417720712761 (37.7690603509832, -122.417720712761) 8 4 7 28853 19
59684 91684 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 387 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 5 3x3   6007418.830408 2107437.729103 37.7670416532981 -122.41759920657 (37.7670416532981, -122.41759920657) 8 4 7 28853 19
60684 241329 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 349 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007417.32507 2107664.81767 37.7676651004942 -122.417620510295 (37.7676651004942, -122.417620510295) 8 4 7 28853 19
62289 91591 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007414.001232 2106821.277656 37.7653487502341 -122.41757221445 (37.7653487502341, -122.41757221445) 8 4 7 28853 19
67006 91687 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 373 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007414.352338 2107516.072508 37.7672565139252 -122.417620248867 (37.7672565139252, -122.417620248867) 8 4 7 28853 19
74482 91579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 170 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   06/19/2013 01:09:00 PM 3 3x3   6007322.882921 2108766.782992 37.7706855226421 -122.418025303656 (37.7706855226421, -122.418025303656) 8 2 9 28853 19
80892 120913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     5 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
83333 196981 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2460 Alameda St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009761.09751 2107855.1809 37.7683194004524 -122.409527097504 (37.7683194004524, -122.409527097504) 8 4 8 28853 19
84099 91688 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 349 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007406.675646 2107650.375519 37.7676248464865 -122.417656321662 (37.7676248464865, -122.417656321662) 8 4 7 28853 19
86391 241321 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 356 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007355.98691 2107612.7207 37.7675186027402 -122.417828978541 (37.7675186027402, -122.417828978541) 8 4 7 28853 19
88350 91701 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 101x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007269.02291 2109328.047293 37.7722235898389 -122.41825140648 (37.7722235898389, -122.41825140648) 8 2 9 28853 19
89764 241327 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007424.50403 2107516.88319 37.7672593111026 -122.417585193005 (37.7672593111026, -122.417585193005) 8 4 7 28853 19
95941 91580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200x South Van Ness Ave 1 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
96550 91587 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 362 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 4 3x3   6007371.2189 2107569.74946 37.7674014710001 -122.417773246729 (37.7674014710001, -122.417773246729) 8 4 7 28853 19
105405 91590 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007414.001232 2106821.277656 37.7653487502341 -122.41757221445 (37.7653487502341, -122.41757221445) 8 4 7 28853 19
105683 241297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1534 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007142.6566 2107359.78421 37.7668120908263 -122.418548923599 (37.7668120908263, -122.418548923599) 8 4 7 28853 19
106489 91706 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 5 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
118012 241319 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007346.30903 2107764.0705 37.7679336290724 -122.417873182915 (37.7679336290724, -122.417873182915) 8 4 7 28853 19
119219 88203 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 436 Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51208 6011221 2112104 37.7800673738175 -122.40477656867 (37.7800673738175, -122.40477656867) 14 2 9 28853 34
120740 88157 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 353 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51181 6011830.6 2112533.5 37.7812807348582 -122.402697887639 (37.7812807348582, -122.402697887639) 6 2 9 28853 34
123994 121589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007359 2108191 37.7691065911809 -122.417859552844 (37.7691065911809, -122.417859552844) 8 4 7 28853 19
128361 91689 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 335 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007402.197577 2107728.718925 37.7678397070843 -122.417677364286 (37.7678397070843, -122.417677364286) 8 4 7 28853 19
128961 91690 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 315 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007395.800334 2107840.638089 37.7681466508094 -122.417707425394 (37.7681466508094, -122.417707425394) 8 4 7 28853 19
129945 91693 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 253 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007399.603267 2108201.969765 37.7691389965346 -122.417719885805 (37.7691389965346, -122.417719885805) 8 4 7 28853 19
133771 91586 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 356 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007369.299728 2107603.325202 37.7674935541002 -122.417782265097 (37.7674935541002, -122.417782265097) 8 4 7 28853 19
134217 91699 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 143 South Van Ness Ave 2 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
139041 241316 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007332.32989 2108125.54734 37.7689253726442 -122.41794716295 (37.7689253726442, -122.41794716295) 8 4 7 28853 19
139468 91692 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 263 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007399.273892 2108147.255986 37.7689887468538 -122.417717146452 (37.7689887468538, -122.417717146452) 8 4 7 28853 19
140031 241328 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 373 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007423.72887 2107548.58471 37.7673463124187 -122.417590121285 (37.7673463124187, -122.417590121285) 8 4 7 28853 19
143144 91583 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 280 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3     6007340.222146 2108038.912892 37.7686879390349 -122.417913721993 (37.7686879390349, -122.417913721993) 8 4 7 28853 19
143430 91578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 160 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/2013 01:03:00 PM 4 3x3   6007300.496664 2108846.846012 37.7709040967706 -122.418108415168 (37.7709040967706, -122.418108415168) 8 2 9 28853 19
144571 91703 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 2 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
144829 241322 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 442 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007381.66806 2107115.42092 37.7661545793962 -122.417704898167 (37.7661545793962, -122.417704898167) 8 4 7 28853 19
149728 91698 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 143 South Van Ness Ave 1 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
150797 88158 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 353 Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51181 6011830.6 2112533.5 37.7812807348582 -122.402697887639 (37.7812807348582, -122.402697887639) 6 2 9 28853 34
153861 120915 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
153876 241326 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 395 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 Width 3ft   6007429.44982 2107410.61084 37.7669677904545 -122.417560553376 (37.7669677904545, -122.417560553376) 8 4 7 28853 19
155550 91589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 442 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007397.135958 2107116.333394 37.7661579552478 -122.417651462281 (37.7661579552478, -122.417651462281) 8 4 7 28853 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
55110 196970 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015850.66313 2105843.80284 37.7631359267068 -122.388323281596 (37.7631359267068, -122.388323281596) 14 3 8 28856 29
58715 196964 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 500 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6015932.05228 2105848.00164 37.7631519652185 -122.3880420744 (37.7631519652185, -122.3880420744) 14 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)
);