sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
24183 175768 2 20 0 Gonzalez Dr 2 2 1 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24841 175769 2 20 0 Gonzalez Dr 1 2 1 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
41434 175767 2 20 0 Gonzalez Dr 1 2 1 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
44057 175774 2 20 0 Gonzalez Dr 1 2 1 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
44691 175766 2 20 0 Gonzalez Dr 5 2 1 1     13     5989094.03032 2089506.27121 37.7167583770722 -122.47966897135001 (37.7167583770722, -122.47966897135)
59851 175772 2 20 0 Gonzalez Dr 5 2 1 1     9     5989911.02174 2089222.5365 37.716026738112 -122.47682434649201 (37.716026738112, -122.476824346492)
154455 175771 2 20 0 Gonzalez Dr 4 2 1 1     5     5989791.935380001 2089208.15493 37.7159803412063 -122.477234910356 (37.7159803412063, -122.477234910356)
167088 175765 2 20 0 Gonzalez Dr 1 2 1 1     18     5988629.85447 2089774.3019599998 37.7174673468061 -122.481292995899 (37.7174673468061, -122.481292995899)
171701 175770 2 20 0 Gonzalez Dr 5 2 1 1     27     5989758.80887 2089246.54995 37.7160838423675 -122.477352214341 (37.7160838423675, -122.477352214341)
180214 175773 2 20 0 Gonzalez Dr 2 2 1 1     14     5990089.9017900005 2089410.48117 37.716553162587296 -122.476219779021 (37.7165531625873, -122.476219779021)
168676 185068 2 20 1 Crestlake Dr 1 1 1 1     2 Width 0ft   5989159.6219 2096046.6038 37.7347202832405 -122.47992059791001 (37.7347202832405, -122.47992059791)
40 222540 2 20 1 Newburg St 3 1 1 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
43 222539 2 20 1 Newburg St 2 1 1 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
66 222538 2 20 1 Newburg St 1 1 1 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
131647 175755 2 20 10 Ruth St 2 2 1 1     1 Width 2ft   6001686.67815 2091578.8653 37.7231727394058 -122.43629071923401 (37.7231727394058, -122.436290719234)
54979 221358 2 20 100 Berkeley Way 2 1 1 1     12 Width 3ft   6000996.09085 2097469.1732900003 37.73930690338871 -122.439099895546 (37.7393069033887, -122.439099895546)
153123 221357 2 20 100 Berkeley Way 1 1 1 1     12 Width 3ft   6001001.40276 2097453.08562 37.739263032671204 -122.439080376676 (37.7392630326712, -122.439080376676)
61227 140862 2 20 100 Jordan Ave 3 2 1 1     2 Width 0ft   5996243.3642 2113769.3144 37.783791348572706 -122.456711139169 (37.7837913485727, -122.456711139169)
146237 41633 1 20 100 Jordan Ave 3 1 1 1   06/01/2000 12:00:00 AM     Permit Number 42113 5996241.92564567 2113793.75965037 37.7838583861175 -122.456717884501 (37.7838583861175, -122.456717884501)
78978 87642 1 20 1002X Laguna St 1 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
107812 87643 1 20 1002X Laguna St 2 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
84820 103510 2 20 100X Leroy Pl 4 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
92027 103511 2 20 100X Leroy Pl 5 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
111092 103509 2 20 100X Leroy Pl 3 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
121213 103508 2 20 100X Leroy Pl 2 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
128766 103507 2 20 100X Leroy Pl 1 1 1 1     8 3x3   6008356.0 2116660.0 37.7924164947138 -122.41501049488501 (37.7924164947138, -122.415010494885)
7980 12325 1 20 1015 Laguna St 1 1 1 1   06/25/1997 12:00:00 AM 6 4X4   6004759.9403 2112401.4167 37.7805207570776 -122.427149495677 (37.7805207570776, -122.427149495677)
72258 47216 1 20 102 Colby St 1 1 1 1 1 05/09/2002 12:00:00 AM 4   Permit Number 45167 6008173.05313 2093488.0369799999 37.728781330768896 -122.41400351077299 (37.7287813307689, -122.414003510773)
98121 47220 1 20 102 Colby St 3 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
115878 47217 1 20 102 Colby St 6 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
120251 47218 1 20 102 Colby St 5 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
124336 47221 1 20 102 Colby St 4 1 1 1 1 05/09/2002 12:00:00 AM     Permit Number 45167 6008165.27144692 2093507.30784615 37.7288338073717 -122.414031775389 (37.7288338073717, -122.414031775389)
173434 47219 1 20 102 Colby St 2 1 1 1 1 05/09/2002 12:00:00 AM 6   Permit Number 45167 6008176.9578 2093476.05572 37.7287486521041 -122.413989164793 (37.7287486521041, -122.413989164793)
25248 188298 2 20 1022 Minna St 3 4 1 1     10 Width 3ft   6007537.97287 2109701.89036 37.7732652094644 -122.41734758044 (37.7732652094644, -122.41734758044)
54041 188299 2 20 1022 Minna St 4 4 1 1     4 Width 3ft   6007530.7890099995 2109693.3141 37.7732412569071 -122.41737182255501 (37.7732412569071, -122.417371822555)
22257 125 1 20 1032 14th St 3 1 1 1   05/14/1990 12:00:00 AM 18 3X3   6002008.22654 2107658.0827 37.767340750994 -122.436329391899 (37.767340750994, -122.436329391899)
136571 175789 2 20 1038 Silver Ave 2 1 1 1     6 Width 3ft   6007776.24891 2093611.0245700001 37.7290967338157 -122.415383996168 (37.7290967338157, -122.415383996168)
97541 30674 1 20 1040 Minna St 1 1 1 1 1 03/26/2005 12:00:00 AM     Permit Number 34599 6007565.37727332 2109755.15641274 37.77341300719829 -122.417256559972 (37.7734130071983, -122.417256559972)
127539 30676 1 20 1040 Minna St 3 1 1 1 1 01/30/1995 12:00:00 AM 11 3x3 Permit Number 34599 6007565.37727332 2109755.15641274 37.77341300719829 -122.417256559972 (37.7734130071983, -122.417256559972)
115613 27054 1 20 1048X Silver Ave 2 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6007856.910540001 2093638.04837 37.7291754686195 -122.41510705369 (37.7291754686195, -122.41510705369)
134658 221333 2 20 105 Holladay Ave 1 1 1 1     12 Width 3ft   6010957.14091 2100465.72663 37.7480965515124 -122.404869753242 (37.7480965515124, -122.404869753242)
79262 37017 1 20 1050 Treat Ave 1 1 1 1 1 05/29/1998 12:00:00 AM     Permit Number 39630 6008600.86286293 2102426.42877225 37.7533482108195 -122.413156329636 (37.7533482108195, -122.413156329636)
182888 221350 2 20 1050 Treat Ave 1 1 1 1     8 Width 4ft   6008608.79456 2102405.13937 37.753290200197895 -122.413127394812 (37.7532902001979, -122.413127394812)
27078 188288 2 20 106 Langton St 4 4 1 1     3 Width 3ft   6010227.812000001 2110667.04277 37.7760662630739 -122.40811110056299 (37.7760662630739, -122.408111100563)
68007 188285 2 20 106 Langton St 1 4 1 1     6 Width 3ft   6010183.94442 2110713.51419 37.776191406445705 -122.40826612929199 (37.7761914064457, -122.408266129292)
164398 188287 2 20 106 Langton St 3 4 1 1     6 Width 3ft   6010207.19158 2110684.55446 37.776113191502496 -122.408183667747 (37.7761131915025, -122.408183667747)
175531 188286 2 20 106 Langton St 2 4 1 1     5 Width 3ft   6010191.871780001 2110704.80693 37.776167942238295 -122.408238092013 (37.7761679422383, -122.408238092013)
107908 41599 1 20 11 Haight St 5 1 1 1   06/01/2000 12:00:00 AM     Permit Number 42106 6006168.11250893 2109650.54781373 37.7730470683498 -122.42208247198299 (37.7730470683498, -122.422082471983)
54422 204645 2 20 111 Ashton Ave 1 1 1 1     6 Width 3ft   5994132.807630001 2090689.3393400002 37.7202982210683 -122.462338293601 (37.7202982210683, -122.462338293601)
107272 39648 1 20 111 Ashton Ave 1 1 1 1 1 05/25/2002 12:00:00 AM     Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
145840 39649 1 20 111 Ashton Ave 2 1 1 1   12/29/1998 12:00:00 AM 5 3x20 Permit Number 41042 5994130.09830184 2090661.11089351 37.720220556524204 -122.462345612464 (37.7202205565242, -122.462345612464)
164499 204646 2 20 111 Ashton Ave 3 2 1 1     5 Width 3ft   5994133.91606 2090657.47285 37.7202107871682 -122.462332152117 (37.7202107871682, -122.462332152117)
51832 222565 2 20 111 Precita Ave 2 1 1 1     10 Width 3ft   6007123.52166 2100080.2988 37.7468232221335 -122.418098981082 (37.7468232221335, -122.418098981082)
97590 104767 2 20 1111 CASTRO ST 2 1 1 1     14 4x4   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658)
100229 104766 2 20 1111 CASTRO ST 1 1 1 1     14 3x3   6002562.6 2102271.3 37.7525814287469 -122.434026788658 (37.7525814287469, -122.434026788658)
90638 111230 2 20 1113 SCOTT ST 3 1 1 1       3x3   6001842.0 2112262.0 37.779972512780105 -122.4372340286 (37.7799725127801, -122.4372340286)
83690 57741 1 20 112 Conrad St 1 1 1 1   12/29/1976 12:00:00 AM 10 3x3 Permit Number 16659 6001762.0 2096689.0 37.7372082800729 -122.436395904515 (37.7372082800729, -122.436395904515)
159023 114552 1 20 1121 Kansas St 1 1 1 1   11/24/2015 12:00:00 AM 1   Permit Number 777071 6011681.54455 2103150.14548 37.7555078447183 -122.402553516927 (37.7555078447183, -122.402553516927)
11557 27528 3 20 1136 Silver Ave 1 1 1 2   11/25/2002 12:00:00 AM 3     6008310.55132 2093825.05625 37.729714434952506 -122.413551995327 (37.7297144349525, -122.413551995327)
103711 39650 1 20 114 Ashton Ave 1 1 1 1 1 12/29/1998 12:00:00 AM     Permit Number 41043 5994182.55528924 2090689.21166175 37.7203007349832 -122.462166324336 (37.7203007349832, -122.462166324336)
28171 221347 2 20 115 Bronte St 1 1 1 1     7 Width 2ft   6009327.08226 2096770.42354 37.7378588087266 -122.41024559558001 (37.7378588087266, -122.41024559558)
65637 222567 2 20 115 College Ave 2 1 1 1     3 Width 3ft   6004467.78746 2096013.76695 37.735507618486096 -122.42699267809601 (37.7355076184861, -122.426992678096)
148647 222566 2 20 115 College Ave 1 1 1 1     3 Width 3ft   6004480.72884 2096010.51075 37.73549940946629 -122.426947702995 (37.7354994094663, -122.426947702995)
179938 221344 2 20 116 Ellsworth St 1 1 1 1     24 Width 3ft   6008115.05984 2098024.5819 37.74123443831 -122.414524882834 (37.74123443831, -122.414524882834)
45511 221338 2 20 117 Valley St 1 1 1 1     7 Width 3ft   6005011.955130001 2099285.1526 37.7445208578632 -122.425344007646 (37.7445208578632, -122.425344007646)
83301 10882 3 20 1175X Hudson Ave 15 1 1 2     6 3X4   6017544.4990408 2094830.7506973 37.732990049052205 -122.381698823278 (37.7329900490522, -122.381698823278)
70295 221361 2 20 118 College Ave 1 1 1 1     8 Width 2ft   6004573.07294 2095957.02532 37.7353577716318 -122.426624626942 (37.7353577716318, -122.426624626942)
161247 175781 2 20 119 Madison St 1 1 1 1     11 Width 3ft   6005510.38459 2093087.28862 37.7275310563876 -122.423180067012 (37.7275310563876, -122.423180067012)
53944 221365 2 20 1190 Diamond St 1 1 1 1     12 Width 4ft   6001927.1952 2100682.80135 37.748183708409 -122.43611046183099 (37.748183708409, -122.436110461831)
81253 56623 1 20 1190 Diamond St 1 1 1 1           6001932.70639357 2100631.3679946 37.7480427977008 -122.43608772434999 (37.7480427977008, -122.43608772435)
63668 175754 2 20 12 Farragut Ave 1 1 1 1     4 Width 2ft   5997730.99268 2086963.4604 37.7102743532383 -122.449632264321 (37.7102743532383, -122.449632264321)
45600 57691 1 20 120 Conrad St 1 1 1 1   12/13/1976 12:00:00 AM 8 3x3 Permit Number 16595 6001759.0 2096663.0 37.7371367196384 -122.436404416578 (37.7371367196384, -122.436404416578)
85326 106091 3 20 1200 HUDSON AVE 12 1 1 2     8 3x3   6017390.0 2095089.0 37.733690618402704 -122.382250932174 (37.7336906184027, -122.382250932174)
12154 26999 1 20 1200 Silver Ave 1 1 1 1   05/27/1999 12:00:00 AM 6 3X3   6008714.80501 2094009.36438 37.7302431967539 -122.41216746208401 (37.7302431967539, -122.412167462084)
52875 186786 2 20 1200 Sunset Blvd 60 9 1 1     4 Width 0ft   5984829.112000001 2106870.9818 37.7641885128796 -122.495690587985 (37.7641885128796, -122.495690587985)
44455 222555 2 20 121 Coleridge St 1 1 1 1     9 Width 3ft   6006651.1877 2098952.76416 37.743700669854796 -122.419652282953 (37.7437006698548, -122.419652282953)
103715 33501 1 20 121 Coleridge St 1 1 1 1 1 11/25/1996 12:00:00 AM     Permit Number 37595 6006663.30728315 2098959.97627538 37.7437211553943 -122.41961088786002 (37.7437211553943, -122.41961088786)
72824 221349 2 20 121 Ellert St 1 1 1 1     13 Width 2ft   6007249.14169 2097018.19512 37.7384224381557 -122.41744762190399 (37.7384224381557, -122.417447621904)
177509 181743 2 20 1219 32nd Ave 2 1 1 1     4 Width 0ft   5986121.7407 2106913.1555 37.7643799229814 -122.491222922878 (37.7643799229814, -122.491222922878)
180337 181742 2 20 1219 32nd Ave 1 1 1 1     2 Width 0ft   5986119.9697 2106920.2395 37.7643992701936 -122.491229569586 (37.7643992701936, -122.491229569586)
113716 35090 1 20 122 Hugo St 1 1 1 1 1 05/03/2003 12:00:00 AM     Permit Number 38632 5995399.98940883 2107075.75682232 37.7653641436682 -122.459144031764 (37.7653641436682, -122.459144031764)
10673 121353 2 20 1221 37th Ave 1 1 1 1   09/27/2016 12:00:00 AM 3 3x3   5984567.3281 2106871.8527 37.76417557031971 -122.496596073864 (37.7641755703197, -122.496596073864)
10976 26998 3 20 1223 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 6 3X3   6008728.29906 2094063.8664 37.7303936047791 -122.41212466153499 (37.7303936047791, -122.412124661535)
84733 116949 2 20 123 WEST PORTAL AVE 2 1 1 1       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321)
121155 116948 2 20 123 WEST PORTAL AVE 1 1 1 1       3x3   5992936.0 2097647.0 37.7393332491746 -122.46698079132099 (37.7393332491746, -122.466980791321)
10667 26997 1 20 1231 Silver Ave 1 1 1 1   06/25/1999 12:00:00 AM 6 3X3   6008770.22229 2094084.7874099999 37.7304534015961 -122.41198120438801 (37.7304534015961, -122.411981204388)
35176 43892 1 20 1233 Howard St 2 1 1 1   08/03/2000 12:00:00 AM 6   Permit Number 43498 6009086.19652 2110571.7349400003 37.7757405834934 -122.412053529658 (37.7757405834934, -122.412053529658)
44902 43889 1 20 1233 Howard St 6 1 1 1   08/03/2000 12:00:00 AM 4   Permit Number 43498 6009135.81805 2110617.1891 37.775868173909004 -122.411885088422 (37.775868173909, -122.411885088422)
69711 43893 1 20 1233 Howard St 3 1 1 1   08/03/2000 12:00:00 AM 5   Permit Number 43498 6009099.28139 2110583.2527799997 37.7757729429148 -122.41200907978201 (37.7757729429148, -122.412009079782)
135995 43888 1 20 1233 Howard St 1 1 1 1 1 08/29/2011 12:00:00 AM 6 3x3 Permit Number 767585 6009068.61437 2110555.25783 37.775694354731606 -122.412113186199 (37.7756943547316, -122.412113186199)
170092 43890 1 20 1233 Howard St 5 1 1 1   08/03/2000 12:00:00 AM 5   Permit Number 43498 6009124.11279 2110606.98987 37.77583951252829 -122.41192485917 (37.7758395125283, -122.41192485917)
181552 43891 1 20 1233 Howard St 4 1 1 1   08/03/2000 12:00:00 AM 5   Permit Number 43498 6009112.33188 2110593.08814 37.7758006806963 -122.41196462987499 (37.7758006806963, -122.411964629875)
11300 26996 1 20 1239 Silver Ave 1 1 1 1   12/14/2000 12:00:00 AM 3 3X3   6008815.333330001 2094106.20179 37.730514731765396 -122.41182676109399 (37.7305147317654, -122.411826761094)
153300 33288 1 20 1242 Sacramento St 1 1 1 1 1 11/13/1996 12:00:00 AM 7   Permit Number 37449 6008832.98278 2116682.76958 37.7925058062477 -122.41336172668699 (37.7925058062477, -122.413361726687)
167932 221364 2 20 1243 Douglass St 1 1 1 1     10 Width 3ft   6001375.81776 2100058.24789 37.7464374920934 -122.437972374152 (37.7464374920934, -122.437972374152)
153717 69152 1 20 1245 30th Ave 1 1 1 1 1 02/05/1994 12:00:00 AM 5   Permit Number 33187 5986742.1857 2106776.7875 37.764041727251396 -122.48906697906 (37.7640417272514, -122.48906697906)
10145 173881 2 20 1245 Willard St 1 1 1 1       3x3   5996703.0 2107106.0 37.7655220059747 -122.45463943175601 (37.7655220059747, -122.454639431756)
134933 181746 2 20 1246 22nd Ave 1 1 1 1     7 Width 0ft   5989272.8487 2106849.4285 37.7643885611619 -122.480319577317 (37.7643885611619, -122.480319577317)
153879 181761 2 20 1246 22nd Ave 2 1 1 1     7 Width 0ft   5989269.0192 2106863.9805 37.7644282944678 -122.480333887539 (37.7644282944678, -122.480333887539)
40165 32579 1 20 1247 33rd Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 5   Permit Number 37053 5985814.1748 2106726.0184 37.763848120851705 -122.49227291177401 (37.7638481208517, -122.492272911774)
31367 204614 2 20 1255 Kirkham St 1 1 1 1     9 Width 2ft   5990910.22691 2105165.14407 37.7598589779192 -122.474533471065 (37.7598589779192, -122.474533471065)
Powered by Datasette · Query took 11.597ms · Data source: data.sfgov.org