sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
187726 98767 2 26 1500X North Point St 10 5 1 1     16 3x3   6003313.437419999 2121061.12622 37.8042161969888 -122.432772427524 (37.8042161969888, -122.432772427524)
187708 96682 1 12 375@32nd Ave 32nd Ave 4 5 1 1   06/28/2011 12:00:00 AM 5   Permit Number 768040 5985880.71623 2113435.4542400003 37.7822742209113 -122.492536917229 (37.7822742209113, -122.492536917229)
187249 98829 2 21 1020 Union St 3 5 1 1     21 3x3   6008023.617869999 2119295.81426 37.7996351035429 -122.41634732658702 (37.7996351035429, -122.416347326587)
186807 96685 1 50 375@32nd Ave 32nd Ave 7 5 1 1   06/28/2011 12:00:00 AM 20   Permit Number 768040 5985883.85851 2113362.06041 37.782072886304704 -122.492520639753 (37.7820728863047, -122.492520639753)
186098 96686 1 100 375@32nd Ave 32nd Ave 8 5 1 1   06/28/2011 12:00:00 AM 25   Permit Number 768040 5985884.08947 2113350.81045 37.7820420106561 -122.49251901199499 (37.7820420106561, -122.492519011995)
183228 104173 1 296 1266 Washington St 2 5 1 1   08/27/2013 12:00:00 AM 2   Permit Number 769966 6008666.764169999 2117323.84982 37.7942567215292 -122.41398222199899 (37.7942567215292, -122.413982221999)
183154 113770 6 21 2550 Broadway 2 5 1 1     5     6001403.30227 2117311.89486 37.7938132775122 -122.43911370912501 (37.7938132775122, -122.439113709125)
182999 103192 3 104 1601X 28th Ave 9 5 1 3     0 3x4   5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
182258 95105 1 88 2200 Beach St 4 5 1 1   01/08/2008 12:00:00 AM 2     5999611.3063900005 2120892.8119799998 37.803543390775296 -122.445571780333 (37.8035433907753, -122.445571780333)
181092 98760 2 26 1500X North Point St 17 5 1 1     19 3x3   6003175.67956 2121043.58403 37.8041602168919 -122.433247894574 (37.8041602168919, -122.433247894574)
180960 92658 1 21 2201 Baker St 4 5 1 1   08/25/2009 12:00:00 AM 5   Permit Number 52915 5999791.1848 2116474.20228 37.7914213317691 -122.44463152831699 (37.7914213317691, -122.444631528317)
175961 98516 1 380 2X 13th St 2 5 1 1   02/22/2012 12:00:00 AM 1 3x3 Permit Number 768342 6009153.62635 2108341.99654 37.7696220261636 -122.41166269150601 (37.7696220261636, -122.411662691506)
174422 98523 1 380 2X 13th St 9 5 1 1   02/22/2012 12:00:00 AM 2 3x3 Permit Number 768342 6009019.69789 2108349.3944200003 37.76963482531271 -122.41212647008699 (37.7696348253127, -122.412126470087)
173812 98769 2 26 1500X North Point St 8 5 1 1     20 3x3   6003355.72677 2121066.39367 37.8042330583593 -122.43262645856701 (37.8042330583593, -122.432626458567)
173675 117056 2 26 214 Spruce St 1 5 1 1     12 3x3   5997140.09186 2115499.411 37.788593180684096 -122.453733787982 (37.7885931806841, -122.453733787982)
173674 109355 2 19 900x Chestnut St 2 5 1 1     12 5x45   6007469.51339 2120600.5219 37.8031863275346 -122.41835729337299 (37.8031863275346, -122.418357293373)
173453 106777 1 31 1177 De Haro St 2 5 1 1   06/03/2014 12:00:00 AM 5   Permit Number 773142 6012265.00001 2102937.69671 37.7549570630325 -122.400520812589 (37.7549570630325, -122.400520812589)
173136 98776 2 26 1500X North Point St 1 5 1 1     14 3x3   6003515.54038 2121088.88501 37.804303875477096 -122.43207501857 (37.8043038754771, -122.43207501857)
171997 109358 2 19 900x Chestnut St 5 5 1 1     7 5x45   6007454.77295 2120598.70497 37.8031805089291 -122.41840817430901 (37.8031805089291, -122.418408174309)
169267 71822 2 35 1300 26th Ave 1 5 1 1   09/11/1982 12:00:00 AM 3     5988042.7796 2106389.3653 37.763053797513706 -122.48454024385201 (37.7630537975137, -122.484540243852)
168446 115307 2 19 1309 Hyde St 1 5 1 1     10 2x2   6007522.861409999 2116889.0118 37.792998452176796 -122.41790942558501 (37.7929984521768, -122.417909425585)
166051 64856 1 18 18 Almaden Ct 1 5 1 1 1 02/03/1989 12:00:00 AM 2   Permit Number 25872 5995898.09877 2112568.97781 37.7804757138181 -122.45781873289499 (37.7804757138181, -122.457818732895)
165797 121508 4 21 300 Folsom St 3 5 1 1     6 3x3   6012258.9126 2112729.3972 37.78184252759429 -122.401229897449 (37.7818425275943, -122.401229897449)
165655 103189 3 15 1601X 28th Ave 2 5 1 3     12 3x4   5987449.3548 2104293.8827 37.7572656000244 -122.48643881405899 (37.7572656000244, -122.486438814059)
163077 87247 1 19 236323 Larkin St 6 5 1 1   02/19/2008 12:00:00 AM 2 3x3 Permit Number 50274 6006692.88945 2119331.74907 37.7996588510331 -122.42095469191601 (37.7996588510331, -122.420954691916)
162813 99285 2 46 2839 Pacific Ave 2 5 1 1     4     6000571.30245 2116798.91345 37.7923573884461 -122.441955660321 (37.7923573884461, -122.441955660321)
161933 116644 2 32 20 Hawthorne St 1 5 1 1     19 3x3   6012905.262159999 2114080.06239 37.7855871796405 -122.39908864853099 (37.7855871796405, -122.399088648531)
161413 98761 2 26 1500X North Point St 16 5 1 1     11 3x3   6003198.92766 2121046.5425 37.8041696588781 -122.43316765437599 (37.8041696588781, -122.433167654376)
161406 92599 1 21 2201 Baker St 8 5 1 1   08/25/2009 12:00:00 AM 5 3x3 Permit Number 52915 5999799.49653 2116432.67643 37.7913077869862 -122.444599784076 (37.7913077869862, -122.444599784076)
159658 98517 1 380 2X 13th St 3 5 1 1   02/22/2012 12:00:00 AM 3 3x3 Permit Number 768342 6009134.24812 2108342.72554 37.7696229407755 -122.411729771911 (37.7696229407755, -122.411729771911)
159418 112611 1 15 2195 Green St 2 5 1 1     10     6002596.08972 2118131.51512 37.7961315408952 -122.435045206767 (37.7961315408952, -122.435045206767)
155176 109361 2 19 900x Chestnut St 8 5 1 1     8 5x45   6007445.84949 2120597.53947 37.803176806427004 -122.418438971581 (37.803176806427, -122.418438971581)
154297 98768 2 26 1500X North Point St 9 5 1 1     14 3x3   6003334.441219999 2121062.9029099997 37.8042222665138 -122.432699869304 (37.8042222665138, -122.432699869304)
154176 117059 2 26 214 Spruce St 4 5 1 1     17 3x3   5997147.32541 2115449.33488 37.788456099723895 -122.453705143689 (37.7884560997239, -122.453705143689)
153085 98522 1 380 2X 13th St 8 5 1 1   02/22/2012 12:00:00 AM 2 3x3 Permit Number 768342 6009037.09649 2108348.63898 37.769633727256604 -122.412066235296 (37.7696337272566, -122.412066235296)
152984 92598 1 21 2201 Baker St 7 5 1 1   08/25/2009 12:00:00 AM 5 3x3 Permit Number 52915 5999796.94168 2116437.53805 37.7913209899324 -122.44460897334 (37.7913209899324, -122.44460897334)
151686 121503 4 6 299 Fremont St 3 5 1 1     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.39394375569401 (37.7884053276005, -122.393943755694)
151027 104174 1 296 1266 Washington St 3 5 1 1   08/27/2013 12:00:00 AM 2   Permit Number 769966 6008660.71895 2117323.02559 37.7942541188741 -122.414003080877 (37.7942541188741, -122.414003080877)
150375 98519 1 380 2X 13th St 5 5 1 1   02/22/2012 12:00:00 AM 2 3x3 Permit Number 768342 6009095.958219999 2108344.44492 37.769625513748295 -122.41186233737899 (37.7696255137483, -122.411862337379)
147679 109360 2 19 900x Chestnut St 7 5 1 1     6 5x45   6007448.76613 2120598.25036 37.803178922540205 -122.418428928878 (37.8031789225402, -122.418428928878)
147563 96683 1 100 375@32nd Ave 32nd Ave 5 5 1 1   06/28/2011 12:00:00 AM 28   Permit Number 768040 5985881.4573800005 2113426.06761 37.782248491261605 -122.49253366172199 (37.7822484912616, -122.492533661722)
147467 82811 1 12 2362 44th Ave 1 5 1 1   06/09/2008 12:00:00 AM 3 3x3 Permit Number 50731 5982709.1994 2099047.2891 37.742582474230396 -122.502443555218 (37.7425824742304, -122.502443555218)
146393 81679 1 35 1942 Vicente St 1 5 1 1 1 07/31/2009 12:00:00 AM 2 3x3 Permit Number 52863 5986874.2463 2097598.6809 37.738848836056 -122.487935819213 (37.738848836056, -122.487935819213)
146288 2099 3 60 1000X Bosworth St 7 5 1 2     10 3X3   6001184.3961352995 2095706.3375319 37.7344772801388 -122.438322562248 (37.7344772801388, -122.438322562248)
146286 103200 3 104 1601X 28th Ave 21 5 1 3   03/26/2013 12:00:00 AM   3x4 Permit Number 770085 5987489.0 2103696.0 37.7556262873159 -122.48625781590201 (37.7556262873159, -122.486257815902)
146273 107913 1 17 65X Newburg St 3 5 1 1   11/04/2014 12:00:00 AM 3   Permit Number 770183 6002412.156690001 2099793.63341 37.7457698026645 -122.434369920352 (37.7457698026645, -122.434369920352)
146150 102665 2 108 3399X Wawona St 6 5 1 1       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731)
146084 85088 6 82 1600 Chestnut St 1 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
146074 94447 6 17 1103 Gough St 4 5 1 1   08/06/2010 12:00:00 AM   3x3 Permit Number 53668 6005549.7 2113553.5 37.7837287235103 -122.424499312595 (37.7837287235103, -122.424499312595)
146003 97126 1 468 2690 Broadway 5 5 1 1   10/01/2007 12:00:00 AM     Permit Number 49710 6000755.5 2117242.9 37.7935869539564 -122.441350205853 (37.7935869539564, -122.441350205853)
145994 97860 1 26 895 Indiana St 7 5 1 1           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978)
145969 113486 2 59 30 PRESIDIO AVE 2 5 1 1       3x3   5998975.0 2116473.0 37.7913714231174 -122.44745541416201 (37.7913714231174, -122.447455414162)
145921 108288 2 11 1 HENRY ADAMS ST 13 5 1 1       3x3   6011517.4 2108140.5 37.769201076268395 -122.40347225564399 (37.7692010762684, -122.403472255644)
145895 111072 2 19 1450 IRVING ST 1 5 1 11       3x3   5991277.0 2106586.0 37.7637815143869 -122.473368628437 (37.7637815143869, -122.473368628437)
145801 107416 1 13 300 Seacliff Ave 2 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
145770 106524 1 43 2510 Jackson St 4 5 1 1         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971)
145604 10747 3 39 1120X Hudson Ave 7 5 1 2     12 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
145584 102008 2 17 1703 Castro St 5 5 1 1       3x3   6002624.0 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327)
145522 97036 7 477 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145467 104336 2 142 1X Beaver St 5 5 1 1       3x3   6002844.0 2106791.0 37.765007405875295 -122.43337660406901 (37.7650074058753, -122.433376604069)
145395 51619 1 50 396(REVISED) Diamond St 2 5 1 1   06/30/2009 12:00:00 AM   3x3 Permit Number 52286 6001775.40578603 2103546.80768569 37.756038960358296 -122.436840338915 (37.7560389603583, -122.436840338915)
145331 101702 2 17 2700 18th St 6 5 1 1   11/13/2012 12:00:00 AM   2x3 Permit Number 769052 6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152)
145290 106337 2 493 497 VALLEY ST 6 5 1 1   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779.0 2099138.0 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711)
145280 99376 6 177 1088 Ashbury St 1 5 1 1         Permit Number 768767 5998994.0 2106195.0 37.7631517661679 -122.44664985791401 (37.7631517661679, -122.446649857914)
145258 96222 6 17 176 Holladay Ave 1 5 1 1   05/18/2011 12:00:00 AM 18 3x3 Permit Number 767739 6010842.9 2100101.6 37.7470903528282 -122.405239158587 (37.7470903528282, -122.405239158587)
145213 97026 7 208 195B Kiska Rd   5 1 20 1         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114)
145137 77213 3 184 499X Hearst Ave 20 5 1 4 2 05/15/1999 12:00:00 AM 8 6x50   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
145111 112191 2 15 399X 05TH ST 2 5 1 1     15     6012019.0 2111820.0 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922)
144925 93163 1 98 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
144883 94942 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144816 99524 1 3 1501@Everglade Sloat Blvd 12 5 1 1   05/22/2012 12:00:00 AM     Permit Number 768821 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
144676 122851 2 17 742 Francisco St 1 5 1 1       3x3   6007760.0 2120975.0 37.8042308974981 -122.417378607523 (37.8042308974981, -122.417378607523)
144675 94622 1 291 1769 Armstrong Ave 1 5 1 1   10/13/2010 12:00:00 AM 3   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
144628 9747 3 272 710X McAllister St 3 5 1 2   05/24/2011 12:00:00 AM 3 4x4   6005653.6676 2112008.06895 37.779491220069296 -122.424029686189 (37.7794912200693, -122.424029686189)
144514 96603 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
144510 10758 3 39 1120X Hudson Ave 43 5 1 2     12 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144479 10750 3 2 1120X Hudson Ave 19 5 1 2     6 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
144417 102660 2 108 3399X Wawona St 1 5 1 1       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731)
144359 115437 2 3 1 PETER YORKE WAY 3 5 1 1       3x3   6005775.0 2114336.0 37.7858899958642 -122.423775516058 (37.7858899958642, -122.423775516058)
144210 106521 1 43 2510 Jackson St 1 5 1 1         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971)
144173 96099 2 17 2780X Bryant St 1 5 1 1       3x3   6009802.0 2101146.0 37.749899795942504 -122.408912195701 (37.7498997959425, -122.408912195701)
144156 94620 1 291 1799X Armstrong Ave 3 5 1 1   10/13/2010 12:00:00 AM 4   Permit Number 53777 6014054.0 2092727.0 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726)
144144 94944 6 540 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
143955 103545 2 26 905X Phelps St 2 5 1 1     10 6x12   6014832.8 2097357.7 37.7397784309436 -122.39125052869 (37.7397784309436, -122.39125052869)
143915 93160 1 17 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143907 114714 1 161 601X Somerset St 3 5 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010329.348040001 2091657.3697400002 37.7238755730654 -122.40642008068501 (37.7238755730654, -122.406420080685)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
143508 95265 3 15 2245 Jones St 3 5 1 4 2         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
143480 117482 4 191 601 PACHECO ST 4 5 1 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
143440 117372 1 54 1533 McAllister St 5 5 2 1   06/08/2016 12:00:00 AM 3 1x2.75   6001806.7 2111472.8 37.777803561930206 -122.437299621265 (37.7778035619302, -122.437299621265)
143329 93161 1 17 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143311 10754 3 39 1120X Hudson Ave 17 5 1 2     8 3X4   6017909.652863 2094654.0666341 37.73252506519629 -122.380424102302 (37.7325250651963, -122.380424102302)
143246 102383 2 28 471-473 Noe St 2 5 1 1   01/22/2013 12:00:00 AM 12 3x3 Permit Number 769850 6002995.0 2105507.0 37.7614904180073 -122.432762601795 (37.7614904180073, -122.432762601795)
143102 37235 1 20 2200X Moraga St 9 5 1 1   06/12/1998 12:00:00 AM     Permit Number 39797 5987459.55498562 2104367.82715752 37.757469225946295 -122.48640896705601 (37.7574692259463, -122.486408967056)
142964 107417 1 13 300 Seacliff Ave 3 5 1 1   09/04/2014 12:00:00 AM 3   Permit Number 773970 5986804.62098 2115681.98254 37.788496517491104 -122.489505906992 (37.7884965174911, -122.489505906992)
142748 37835 3 42 450X Moscow St 21 5 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003752.0 2090699.0 37.720873955994 -122.42908860130501 (37.720873955994, -122.429088601305)
142705 96486 2 70 1202 Stanyan St 1 5 1 1           5997433.0 2105848.0 37.762109700699895 -122.452023768999 (37.7621097006999, -122.452023768999)
142684 103276 2 46 2800X Pine St 3 5 1 1       3x3   6000456.3 2114876.5 37.7870723881298 -122.442215507279 (37.7870723881298, -122.442215507279)
142661 115088 2 317 2784X JACKSON ST 3 5 1 1       3x3   6000894.0 2116629.0 37.791909233816206 -122.44082692769199 (37.7919092338162, -122.440826927692)
142641 18431 1 21 1001X Potrero Ave 6 5 1 8   01/20/2016 12:00:00 AM 24 3X3   6010537.158904701 2103412.4254884 37.75616405148111 -122.406529656376 (37.7561640514811, -122.406529656376)
142598 121520 4 11 300 Folsom St 15 5 1 1       3x3   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
Powered by Datasette · Query took 2.658ms · Data source: data.sfgov.org