sf-trees

Data source: data.sfgov.org

Custom SQL query returning 68 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
184245 50918 1 66 2477 21st Ave 1 1 1 1 1 04/26/2004 12:00:00 AM 3   Permit Number 47420 5989820.2795 2098517.5722 37.7415432867093 -122.477817075256 (37.7415432867093, -122.477817075256)
183187 206695 2 66 140 Hamerton Ave 1 1 1 1     3 Width 3ft   6001321.914580001 2095363.51303 37.7335437842173 -122.437822570471 (37.7335437842173, -122.437822570471)
176247 206515 2 66 1019 Lawton St 2 1 1 1     3 Width 2ft   5991033.61709 2104484.17502 37.7579963659675 -122.47405704351601 (37.7579963659675, -122.474057043516)
175342 200074 2 66 1500 Van Dyke Ave 2 1 1 1     3 Width 0ft   6014921.0644 2093162.4986 37.728264158228896 -122.39065226097 (37.7282641582289, -122.39065226097)
175120 206659 2 66 41 Alton Ave 3 2 1 1     3 Width 3ft   5994198.61036 2101541.1054 37.750098278721 -122.462897719553 (37.750098278721, -122.462897719553)
174439 206625 2 66 80 Ventura Ave 1 2 1 1     3 Width 3ft   5994283.13326 2101793.571 37.7507963531822 -122.46262374828999 (37.7507963531822, -122.46262374829)
173302 183679 2 66 3627 Irving St 2 1 1 1     3 Width 0ft   5984438.7811 2106305.4338 37.7626128114068 -122.49699886391899 (37.7626128114068, -122.496998863919)
171736 206609 2 66 44 Sola Ave 1 2 1 1     3 Width 4ft   5994867.729069999 2100768.79557 37.7480162285692 -122.46052792862601 (37.7480162285692, -122.460527928626)
165826 206688 2 66 629 Los Palmos Dr 3 1 1 1     3 Width 3ft   5996101.05251 2095948.39142 37.7348514596286 -122.455914747394 (37.7348514596286, -122.455914747394)
157581 206499 2 66 245 Lawton St 2 1 1 1     3 Width 2ft   5993488.07663 2104571.6485200003 37.7583784177465 -122.46557490416001 (37.7583784177465, -122.46557490416)
157023 206694 2 66 125 Chilton Ave 1 1 1 1     3 Width 3ft   6001630.15209 2095380.35715 37.733607556928 -122.43675811218999 (37.733607556928, -122.43675811219)
152678 206603 2 66 160 Magellan Ave 4 2 1 1     3 Width 4ft   5995045.25769 2100752.48094 37.7479816442318 -122.459912864313 (37.7479816442318, -122.459912864313)
151039 206692 2 66 582 Los Palmos Dr 2 1 1 1     3 Width 3ft   5996416.06092 2095880.8714400001 37.7346841407625 -122.45482078325199 (37.7346841407625, -122.454820783252)
149027 206693 2 66 609 Rockdale Dr 1 1 1 1     3 Width 3ft   5997804.54909 2098010.1173 37.740610086694396 -122.45017375511999 (37.7406100866944, -122.45017375512)
148911 206583 2 66 180 Dorantes Ave 2 2 1 1     3 Width 3ft   5993643.85712 2099778.24608 37.7452259461282 -122.464688076401 (37.7452259461282, -122.464688076401)
148248 206529 2 66 13 Madrone Ave 3 1 1 1     3 Width 3ft   5992989.732419999 2099015.25675 37.7430932380525 -122.466894452432 (37.7430932380525, -122.466894452432)
142150 115536 4 66 99X Lech Walesa St 1 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
134815 206702 2 66 860 Teresita Blvd 6 9 1 1     3 Width 10ft   5998869.22619 2095565.73707 37.733959270110795 -122.446316727449 (37.7339592701108, -122.446316727449)
132226 206527 2 66 13 Madrone Ave 1 1 1 1     3 Width 3ft   5992983.90563 2098997.49136 37.7430441224891 -122.46691330850099 (37.7430441224891, -122.466913308501)
131108 63003 1 66 1239 42nd Ave 1 1 1 1   09/22/1986 12:00:00 AM 3   Permit Number 23411 5983024.3565 2106665.5091 37.763518489811 -122.501917412441 (37.763518489811, -122.501917412441)
130622 223035 2 66 99 Manchester St 1 1 1 1     3 Width 3ft   6008263.26696 2099462.20339 37.7451901540099 -122.414114116572 (37.7451901540099, -122.414114116572)
130438 244873 2 66 49 Lyon St 4 1 1 1     3 Width 0ft   6000342.3248 2109115.5777 37.7712478709156 -122.442196132801 (37.7712478709156, -122.442196132801)
120364 115538 4 66 99X Lech Walesa St 3 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
119316 206672 2 66 370 Yerba Buena Ave 2 1 1 1     3 Width 3ft   5995263.98331 2095214.4393900002 37.732788127968995 -122.458755649049 (37.732788127969, -122.458755649049)
119103 206513 2 66 1023 Lawton St 6 1 1 1     3 Width 2ft   5990992.34085 2104483.78156 37.757992894562 -122.47419976413 (37.757992894562, -122.47419976413)
117382 82954 2 66 660X Clementina St 3 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
116485 200075 2 66 1500 Van Dyke Ave 3 1 1 1     3 Width 0ft   6014900.2728 2093175.985 37.7283000356482 -122.390725081061 (37.7283000356482, -122.390725081061)
107733 84504 2 66 650X Clementina St 2 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
107468 84505 2 66 650 Clementina St 1 1 1 1 1 10/14/2006 12:00:00 AM 3 3x3   6009485.16866501 2110503.49163991 37.775575580460206 -122.410668559049 (37.7755755804602, -122.410668559049)
100905 82953 2 66 660X Clementina St 4 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96209 82955 2 66 660X Clementina St 2 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
96002 82952 2 66 660X Clementina St 5 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
89728 82956 2 66 660X Clementina St 1 1 1 1 1 06/11/2005 12:00:00 AM 3 3x3   6009636.0 2110586.0 37.7758105844997 -122.41015262108601 (37.7758105844997, -122.410152621086)
89451 115539 4 66 99X Lech Walesa St 4 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
78927 115540 4 66 99X Lech Walesa St 5 1 1 1   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
77159 176073 2 66 774 Edinburgh St 1 1 1 1     3 Width 2ft   6001923.16259 2089317.3719 37.7169766182659 -122.43531155267999 (37.7169766182659, -122.43531155268)
77157 223048 2 66 3880 23rd St 1 1 1 1     3 Width 5ft   6003922.515380001 2102484.70879 37.7532444831531 -122.429339183778 (37.7532444831531, -122.429339183778)
76722 206547 2 66 120 Dorantes Ave 1 2 1 1     3 Width 4ft   5993889.308780001 2099967.60077 37.7457600139093 -122.463853094571 (37.7457600139093, -122.463853094571)
74719 206524 2 66 35 Madrone Ave 1 1 1 1     3 Width 3ft   5992940.67499 2098878.9332 37.742716096581894 -122.467054169341 (37.7427160965819, -122.467054169341)
73565 223025 2 66 380 Fair Oaks St 1 1 1 1     3 Width 3ft   6005467.6636 2101500.58617 37.750629666539396 -122.423925765973 (37.7506296665394, -122.423925765973)
72284 206690 2 66 616 Los Palmos Dr 2 1 1 1     3 Width 3ft   5996131.5818 2095962.98776 37.7348932897948 -122.45581025245001 (37.7348932897948, -122.45581025245)
69850 206611 2 66 49 Sola Ave 4 2 1 1     3 Width 4ft   5994869.30829 2100730.97603 37.7479124764813 -122.460519727717 (37.7479124764813, -122.460519727717)
69773 223051 2 66 24 Buena Vista Ter 1 1 1 1     3 Width 3ft   6001422.87059 2107990.68113 37.7682207070445 -122.438377882942 (37.7682207070445, -122.438377882942)
68623 63086 1 66 1209 41st Ave 1 1 1 1   11/25/1986 12:00:00 AM 3   Permit Number 23570 5983326.3714 2106866.623 37.7640884282736 -122.500887729919 (37.7640884282736, -122.500887729919)
66433 95111 1 66 649 Cayuga Ave 2 1 1 1 1 12/28/2010 12:00:00 AM 3 3x3 Permit Number 54039 6001701.74477 2093288.67335 37.727868340851295 -122.43636094730101 (37.7278683408513, -122.436360947301)
61039 206671 2 66 370 Yerba Buena Ave 3 1 1 1     3 Width 3ft   5995266.43425 2095204.88442 37.732762033223 -122.45874648408899 (37.732762033223, -122.458746484089)
58097 206689 2 66 616 Los Palmos Dr 1 1 1 1     3 Width 3ft   5996145.20311 2095954.15677 37.734869823774 -122.45576252094901 (37.734869823774, -122.455762520949)
57958 183317 2 66 1209 41st Ave 2 1 1 1     3 Width 0ft   5983329.0993 2106834.4338 37.7640002060456 -122.50087591440399 (37.7640002060456, -122.500875914404)
53148 206498 2 66 245 Lawton St 1 1 1 1     3 Width 2ft   5993516.66966 2104572.87128 37.7583834242608 -122.465476106443 (37.7583834242608, -122.465476106443)
52949 206549 2 66 308 Pacheco St 1 2 1 1     3 Width 6ft   5994338.43004 2100748.81738 37.7479309089808 -122.462356761175 (37.7479309089808, -122.462356761175)
50581 38530 1 66 2550 31st Ave 1 1 1 1   09/16/1998 12:00:00 AM 3   Permit Number 40512 5986784.3655 2097886.9498 37.7396351026284 -122.48826775932 (37.7396351026284, -122.48826775932)
50360 206528 2 66 13 Madrone Ave 2 1 1 1     3 Width 3ft   5992986.65204 2099006.05822 37.7430678034305 -122.466904434898 (37.7430678034305, -122.466904434898)
49506 206607 2 66 2 Sola Ave 2 2 1 1     3 Width 4ft   5994975.69537 2100714.97086 37.7478746501056 -122.460150689128 (37.7478746501056, -122.460150689128)
48597 47077 1 66 135 Beaumont Ave 1 1 1 1 1 05/03/2002 12:00:00 AM 3   Permit Number 45064 5996788.5617 2112098.8644 37.779236022786606 -122.454704245524 (37.7792360227866, -122.454704245524)
44246 206584 2 66 180 Dorantes Ave 1 2 1 1     3 Width 3ft   5993659.8453 2099783.1011200002 37.745240198571295 -122.464633144905 (37.7452401985713, -122.464633144905)
43403 223031 2 66 38 Parnassus Ave 1 1 1 1     3 Width 4ft   5998471.48427 2106911.98504 37.7650905653978 -122.448508695418 (37.7650905653978, -122.448508695418)
42780 200073 2 66 1500 Van Dyke Ave 1 1 1 1     3 Width 0ft   6014933.989 2093151.8218 37.7282355589188 -122.390606833955 (37.7282355589188, -122.390606833955)
36423 206512 2 66 1023 Lawton St 5 1 1 1     3 Width 2ft   5990980.22345 2104481.19226 37.7579850830548 -122.47424148188401 (37.7579850830548, -122.474241481884)
35264 206544 2 66 337 Pacheco St 1 2 1 1     3 Width 3ft   5994178.74316 2101030.22278 37.7486943803622 -122.462929360401 (37.7486943803622, -122.462929360401)
29329 206551 2 66 308 Pacheco St 3 2 1 1     3 Width 6ft   5994320.14066 2100781.15308 37.74801864146029 -122.462422349606 (37.7480186414603, -122.462422349606)
17882 52665 1 66 1200 Page St 1 1 1 1   01/14/2016 12:00:00 AM 3 3x3 Permit Number 774794 6000815.0 2109317.0 37.77182785317 -122.440575583218 (37.77182785317, -122.440575583218)
17038 115537 4 66 99X Lech Walesa St 2 1 1 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
16408 78332 3 66 50 Pomona St 15 1 1 4 2 07/01/2009 12:00:00 AM 3 3x3 Permit Number 52305 6014106.86245 2094390.7581099998 37.73159150443121 -122.393552939125 (37.7315915044312, -122.393552939125)
16162 51360 3 66 50 Pomona St 12 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014114.6767 2094431.72556 37.7317044268964 -122.39352878961999 (37.7317044268964, -122.39352878962)
14652 51358 3 66 50 Pomona St 14 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014110.4538 2094404.7193099998 37.7316300385939 -122.393541499766 (37.7316300385939, -122.393541499766)
13409 51359 3 66 50 Pomona St 13 1 1 4 2 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014112.78564 2094416.99761 37.73166388187129 -122.393534297068 (37.7316638818713, -122.393534297068)
2031 251786 2 66 300 Coleridge St 1 1 1 1   06/16/2017 12:00:00 AM 3 3x3   6006195.0 2098242.0 37.7417233638646 -122.42117921336501 (37.7417233638646, -122.421179213365)
1013 223102 2 66 247 28th St 1 1 1 1   04/27/2017 12:00:00 AM 3 Width 3ft Permit Number 779888 6004283.79281 2099537.35517 37.74517218196571 -122.42787981341101 (37.7451721819657, -122.427879813411)
Powered by Datasette · Query took 6.393ms · Data source: data.sfgov.org