575 rows where qSpecies_id = 123 sorted by qAddress

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)
115556 50665 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2004 12:00:00 AM 5   Permit Number 47244 6000927.33064 2091848.93503 37.7238711151562 -122.438934974279 (37.7238711151562, -122.438934974279) 9 7 6 28861 25
60418 88523 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 10 Valdez Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51454 5996417 2093827.6 37.7290464055545 -122.454669245202 (37.7290464055545, -122.454669245202) 9 7 4 28861 40
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                      
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
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
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
132267 91658 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1073 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007642.630657 2103418.725072 37.7560189888407 -122.416540390694 (37.7560189888407, -122.416540390694) 2 4 7 28859 19
88879 241357 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6008659.53051 2102232.08888 37.7528178906343 -122.412939704518 (37.7528178906343, -122.412939704518) 2 4 7 28859 19
114516 241358 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 6ft   6008654.31002 2102275.26835 37.7529361586965 -122.412960810713 (37.7529361586965, -122.412960810713) 2 4 7 28859 19
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
134611 241336 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 11 Lundys Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007215.53058 2099620.48751 37.7455658619754 -122.417748235597 (37.7455658619754, -122.417748235597) 2 7 7 28859 2
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
71899 136184 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6006503.30451 2120455.88239 37.8027347473741 -122.421690613452 (37.8027347473741, -122.421690613452) 5 9 1 28858 32
109489 25585 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1100 Cortland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/21/1997 12:00:00 AM 30 3X3   6008661.2482385 2097297.4630516 37.7392685988549 -122.412584962687 (37.7392685988549, -122.412584962687) 10 7 7 28859 2
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
111765 91613 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1116 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007617.645495 2103146.62493 37.7552704588724 -122.416607523387 (37.7552704588724, -122.416607523387) 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
77309 91657 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1133 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007662.546411 2103059.279009 37.7550331520704 -122.416446055556 (37.7550331520704, -122.416446055556) 2 4 7 28859 19
142131 91614 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1140 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007588 2102997 37.7548579556474 -122.416699447347 (37.7548579556474, -122.416699447347) 2 4 7 28859 19
67599 91656 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1141 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007665.027497 2103014.499609 37.7549103375799 -122.416434303552 (37.7549103375799, -122.416434303552) 2 4 7 28859 19
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
61838 90896 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992053.33041 2110644.47867 37.7749699321879 -122.47097923688 (37.7749699321879, -122.47097923688) 11 6 2 54 11
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
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
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
108205 91655 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1155 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007669.369399 2102936.135663 37.7546954122234 -122.416413737633 (37.7546954122234, -122.416413737633) 2 4 7 28859 19
81154 91654 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1169 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007673.711302 2102857.771696 37.7544804867979 -122.416393171829 (37.7544804867979, -122.416393171829) 2 4 7 28859 19
84687 91615 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1176 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007636.253645 2102810.779435 37.754349350274 -122.416519382003 (37.754349350274, -122.416519382003) 2 4 7 28859 19
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
157671 91653 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1199 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007683.015377 2102689.848948 37.7540199323813 -122.416349102661 (37.7540199323813, -122.416349102661) 2 4 7 28859 19
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
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
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
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
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
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
54319 241288 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 16 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6011465.27105 2102063.55943 37.7525122416483 -122.403225029932 (37.7525122416483, -122.403225029932) 10 4 8 28859 19
103971 241282 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011466.58759 2101921.66983 37.7521227174025 -122.403210496885 (37.7521227174025, -122.403210496885) 10 4 8 28859 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
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
132385 44257 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 122 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2001 12:00:00 AM 9   Permit Number 43690 5993988.26127 2114691.75826 37.7861943888941 -122.464579892109 (37.7861943888941, -122.464579892109) 11 6 1 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
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
67242 241290 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1227 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011160.10458 2102427.21865 37.753493722159 -122.404305946667 (37.753493722159, -122.404305946667) 10 4 8 28859 19
60767 91618 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1240 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007656.818859 2102429.616316 37.7533039196294 -122.41642126514 (37.7533039196294, -122.41642126514) 2 4 7 28859 19
87982 91650 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 3 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
105398 91651 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 4 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
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
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
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
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
56651 91619 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1286 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007670.444381 2102173.036115 37.7526001749043 -122.416355973027 (37.7526001749043, -122.416355973027) 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
102562 241293 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011113.70254 2102244.24348 37.7529887195714 -122.404453537112 (37.7529887195714, -122.404453537112) 10 4 8 28859 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
46451 87968 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 1 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
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
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
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
56282 87763 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1303 Fell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6001194 2110018 37.7737741980345 -122.439314854348 (37.7737741980345, -122.439314854348) 15 5 11 29492 10
94675 35355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1315 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 12   Permit Number 38817 6011731.8197 2102219.99473 37.7529566614441 -122.402314252327 (37.7529566614441, -122.402314252327) 10 3 8 28856 29
142984 31525 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1330 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 12 4x4 Permit Number 35080 6011118.50482 2102111.69571 37.7526250409161 -122.404427600678 (37.7526250409161, -122.404427600678) 10 4 8 28859 19
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
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
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
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
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
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
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
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
110684 94081 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1355 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2010 12:00:00 AM 3 3x3 Permit Number 53468 6007606.52221 2117796.21393 37.7954941122185 -122.417684284801 (37.7954941122185, -122.417684284801) 5 1 10 28858 32
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
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
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
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
149994 91642 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007742.379122 2101613.996265 37.7510692229497 -122.41606762223 (37.7510692229497, -122.41606762223) 2 4 7 28859 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
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
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
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
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
152731 213852 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1386 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991160.08427 2105986.1579 37.7621277372307 -122.473729238831 (37.7621277372307, -122.473729238831) 1 8 11 56 12
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
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
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
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
78586 241277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010729.0783 2101044.09639 37.749671877762 -122.405699121544 (37.749671877762, -122.405699121544) 10 4 7 28859 19
102687 241279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010767.41286 2100951.64139 37.7494201602129 -122.405560047672 (37.7494201602129, -122.405560047672) 10 4 7 28859 19
153411 241275 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010636.10474 2101276.89456 37.750305890826 -122.406037027383 (37.750305890826, -122.406037027383) 10 4 7 28859 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
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
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
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
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
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
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
96199 91639 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1435 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007760.067233 2101299.189418 37.7502058289413 -122.415984163776 (37.7502058289413, -122.415984163776) 2 4 7 28859 19
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

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