sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1317 14834 1 142 1288 McAllister St 2 1 1 1     12 3X3   6003007.4145 2111705.9811 37.7785120037891 -122.433162602474 (37.7785120037891, -122.433162602474)
1881 199699 2 142 2098 Jennings St 2 1 1 1     3 Width 0ft   6015522.8982 2092787.4061 37.727267599979704 -122.388545507017 (37.7272675999797, -122.388545507017)
2322 103821 1 142 1032 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006936.4893 2114526.0013 37.786477191411294 -122.419770562808 (37.7864771914113, -122.419770562808)
3269 253386 2 142 726 El Camino Del Mar 1 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3272 253387 2 142 726 El Camino Del Mar 2 8 1 1           5986306.0 2114851.0 37.7861857583172 -122.491169854158 (37.7861857583172, -122.491169854158)
3520 103828 1 142 999 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006926.6281 2114230.9021 37.785666365842296 -122.419783733241 (37.7856663658423, -122.419783733241)
4182 253620 6 142 1120 South Van Ness Ave 3 8 1 1       Width 3ft   6007603.98274 2103104.1444200003 37.755153048679205 -122.41665176419201 (37.7551530486792, -122.416651764192)
4580 142832 3 142 1553 POLK ST 1 10 1 2   11/01/2009 12:00:00 AM 9 Width 0ft   6006643.2439 2116275.8765 37.791265392276 -122.420909404242 (37.791265392276, -122.420909404242)
4604 142833 3 142 1549 POLK ST 1 10 1 2   11/01/2009 12:00:00 AM 9 Width 0ft   6006645.4552 2116252.8795 37.7912023728705 -122.42090011974501 (37.7912023728705, -122.420900119745)
4713 103826 1 142 1000 Polk St 2 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006957.18445 2114384.03926 37.786088564267395 -122.41968888625401 (37.7860885642674, -122.419688886254)
5370 103797 1 142 1201 Polk St 2 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006813.15784 2115040.73173 37.78788356611221 -122.42023380524599 (37.7878835661122, -122.420233805246)
6052 103780 1 142 1245 Polk St 2 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006784.96564 2115238.8671 37.7884260084052 -122.420345413822 (37.7884260084052, -122.420345413822)
6196 103853 3 142 1507 Polk St 2 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006668.0099 2116095.4388 37.790771351094605 -122.420810898748 (37.7907713510946, -122.420810898748)
6353 20138 1 142 1000 Steiner St 1 1 1 1     6 3X3   6002950.7346 2111726.0933 37.7785640114636 -122.43336011714199 (37.7785640114636, -122.433360117142)
6554 20146 1 142 1006 Steiner St 2 1 1 1     6 3X3   6002941.3315 2111813.3334 37.7788030175273 -122.43339888180901 (37.7788030175273, -122.433398881809)
6945 103827 1 142 1000 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006958.82902 2114372.08795 37.7860558415396 -122.419682348183 (37.7860558415396, -122.419682348183)
6969 103818 1 142 1100 Polk St 2 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006909.68769 2114740.53907 37.787064749582 -122.4198785191 (37.787064749582, -122.4198785191)
7052 103779 1 142 1245 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006784.20926 2115254.40862 37.7884686389629 -122.42034913431499 (37.7884686389629, -122.420349134315)
7313 103796 1 142 1201 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006810.240669999 2115055.78241 37.7879247271976 -122.420244966752 (37.7879247271976, -122.420244966752)
7593 20139 1 142 1000 Steiner St 2 1 1 1     6 3X3   6002949.1674 2111752.2131 37.7786356410017 -122.433367405651 (37.7786356410017, -122.433367405651)
7733 103820 1 142 1033 Polk St 1 1 1 1   11/01/2009 12:00:00 AM 3 3x3   6006885.572000001 2114524.1828 37.786469329784204 -122.41994659523199 (37.7864693297842, -122.419946595232)
7959 14833 3 142 1288 McAllister St 1 1 1 2     12 3X3   6003019.4296 2111708.0707 37.7785184228745 -122.43312118705799 (37.7785184228745, -122.433121187058)
7969 114847 2 142 2200 Green St 1 1 1 1     15 3x3   6002442.62774 2118155.32308 37.7961881963905 -122.435577919296 (37.7961881963905, -122.435577919296)
8779 20145 1 142 1006 Steiner St 1 1 1 1     6 3X3   6002942.8987 2111794.0047 37.778750034657605 -122.433392078669 (37.7787500346576, -122.433392078669)
8870 103858 3 142 1475 Polk St 2 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006691.391 2115929.0779 37.790315883136 -122.42071818597401 (37.790315883136, -122.420718185974)
8938 103857 3 142 1475 Polk St 1 10 1 2   11/01/2009 12:00:00 AM 3 3x3   6006690.1878 2115953.9432 37.7903840892726 -122.42072411493 (37.7903840892726, -122.42072411493)
10414 28700 1 142 2593 San Bruno Ave 1 1 1 1   04/28/2008 12:00:00 AM 16 3x3   6011048.2422 2093513.6383 37.729012691472896 -122.40406554132299 (37.7290126914729, -122.404065541323)
10832 87534 3 142 2515 San Bruno Ave 1 1 1 2     16     6010931.8007 2093898.1841 37.7300620671282 -122.404495148402 (37.7300620671282, -122.404495148402)
11194 15688 1 142 4199 Mission St 1 1 1 1   05/04/1995 12:00:00 AM 3 3X3   6003628.481269999 2094078.5751200002 37.7301465241442 -122.429756492581 (37.7301465241442, -122.429756492581)
11421 24893 1 142 3195 San Bruno Ave 1 1 1 1   03/14/1996 12:00:00 AM 18 2X3   6011845.1957 2090907.7685 37.7219020046048 -122.401127363027 (37.7219020046048, -122.401127363027)
11693 24891 1 142 2780 San Bruno Ave 1 1 1 1     18 2X2   6011255.8917 2092657.8069999998 37.726674356421704 -122.403287496484 (37.7266743564217, -122.403287496484)
11695 24912 1 142 3106 San Bruno Ave 1 1 1 1   03/14/1996 12:00:00 AM 16 2X3   6011710.6178 2091173.2445 37.722623438850604 -122.401611216966 (37.7226234388506, -122.401611216966)
11766 24901 3 142 2895 San Bruno Ave 2 1 1 2   11/19/2015 12:00:00 AM 16 3X9   6011438.8335 2092223.5829 37.725492282424604 -122.40262454667 (37.7254922824246, -122.40262454667)
11954 24916 1 142 3180 San Bruno Ave 1 1 1 1   03/14/1996 12:00:00 AM 16 2X3   6011786.8435 2090915.654 37.7219204011149 -122.401329626814 (37.7219204011149, -122.401329626814)
12100 28704 1 142 3004 San Bruno Ave 2 1 1 1   04/28/2008 12:00:00 AM 16 3x3   6011587.3423 2091581.4466 37.7237373984555 -122.402066038858 (37.7237373984555, -122.402066038858)
12135 15689 1 142 4199 Mission St 2 1 1 1   05/04/1995 12:00:00 AM 3 3X3   6003642.63298 2094097.24722 37.7301985948914 -122.429708899543 (37.7301985948914, -122.429708899543)
12323 87525 1 142 2600 San Bruno Ave 1 1 1 1     18 4x8   6011029.3764 2093400.1095 37.72869991097971 -122.404122775515 (37.7286999109797, -122.404122775515)
12462 115357 4 142 270 Ocean Ave 1 1 1 1   01/27/2016 12:00:00 AM 3 3x6   5999894.51999 2091641.8812799999 37.723243775973394 -122.442490363056 (37.7232437759734, -122.442490363056)
12544 24857 1 142 2500 San Bruno Ave 1 1 1 1   03/01/1996 12:00:00 AM 20 3X3   6010898.5282 2093826.1579 37.7298624387628 -122.404605107856 (37.7298624387628, -122.404605107856)
12652 28672 1 142 3100 San Bruno Ave 1 1 1 1   04/28/2008 12:00:00 AM 16 3x3   6011704.8351 2091194.7980000002 37.7226822976708 -122.401632720761 (37.7226822976708, -122.401632720761)
12960 87419 1 142 2488 San Bruno Ave 2 1 1 1     20 4x8   6010849.4762 2093988.7302 37.730306086621496 -122.40478612814199 (37.7303060866215, -122.404786128142)
13030 24858 3 142 2500 San Bruno Ave 2 1 1 2   11/16/2001 12:00:00 AM 20 3X4   6010904.8349 2093807.9386 37.7298127648541 -122.404582022711 (37.7298127648541, -122.404582022711)
13059 87418 1 142 2488 San Bruno Ave 1 1 1 1     20 4x8   6010844.0455 2094008.351 37.730359657675 -122.40480628373899 (37.730359657675, -122.404806283739)
13074 24882 3 142 2350 San Bruno Ave 1 1 1 2     30 2X2   6010484.31378 2095044.6297900002 37.733184946628 -122.406122911744 (37.733184946628, -122.406122911744)
13136 24892 3 142 2780 San Bruno Ave 2 1 1 2     18 2X2   6011265.8799 2092627.3166 37.726591193941104 -122.403250823482 (37.7265911939411, -122.403250823482)
13150 87541 1 142 2603 San Bruno Ave 1 1 1 1     18     6011083.9894 2093392.2028 37.728681252168705 -122.40393341780899 (37.7286812521687, -122.403933417809)
13196 24855 1 142 2450 San Bruno Ave 1 1 1 1   03/01/1996 12:00:00 AM 15 3x3   6010769.7667 2094249.4065 37.731017393341 -122.40508004410401 (37.731017393341, -122.405080044104)
14370 75081 3 142 172 Russ St 2 1 1 2   09/09/1995 12:00:00 AM 4 8x9   6010488.28034 2111342.3731400003 37.7779351433246 -122.407257684389 (37.7779351433246, -122.407257684389)
14419 96663 3 142 1400X Mendell St 3 1 1 2     12 3x3   6014978.6151 2095394.6292 37.7343963311622 -122.390609217071 (37.7343963311622, -122.390609217071)
14472 12222 1 142 1543 La Salle Ave 1 1 1 1   05/23/1996 12:00:00 AM 6 3X3   6015840.7459 2095893.0455 37.7358126735457 -122.387663285334 (37.7358126735457, -122.387663285334)
15521 96662 3 142 1400X Mendell St 2 1 1 2     12 3x3   6015000.5996 2095419.9114 37.734466970583206 -122.390534974863 (37.7344669705832, -122.390534974863)
16212 96661 3 142 1400X Mendell St 1 1 1 2   06/26/2012 12:00:00 AM 6 3x3   6015012.1415 2095435.3006 37.7345098664919 -122.390496145326 (37.7345098664919, -122.390496145326)
16715 104026 2 142 782 Wisconsin St 1 1 1 1     12 3x3   6012702.6895 2103864.8187599997 37.7575271374861 -122.399072220626 (37.7575271374861, -122.399072220626)
17079 4224 1 142 3978 Cesar Chavez St 1 1 1 1   04/15/1995 12:00:00 AM 3 3X3   6004063.19493 2100446.35832 37.74765561211429 -122.428707390249 (37.7476556121143, -122.428707390249)
17760 614 3 142 3130 24th St 1 1 1 2     18 3X3   6008131.4648 2102133.22317 37.752516771554205 -122.41475886214899 (37.7525167715542, -122.414758862149)
19871 16685 3 142 250X Noe St 1 11 1 2   05/25/2010 12:00:00 AM 3 3X3   6002901.6582 2106832.0518 37.7651233950804 -122.43318011235 (37.7651233950804, -122.43318011235)
20194 18470 1 142 1221 Potrero Ave 1 1 1 1   11/21/2003 12:00:00 AM 12 3X3   6010619.64201 2102143.08548 37.752683339465705 -122.406154975289 (37.7526833394657, -122.406154975289)
20204 16686 3 142 250X Noe St 2 11 1 2   06/06/1998 12:00:00 AM 3 3X3   6002901.0969 2106818.0205 37.7650848366999 -122.433181051108 (37.7650848366999, -122.433181051108)
23543 245283 2 142 399 San Jose Ave 1 1 1 1     6 Width 3ft   6006236.70804 2100879.7389700003 37.748968348918794 -122.42122226179501 (37.7489683489188, -122.421222261795)
23581 179576 2 142 150 Italy Ave 1 1 1 1     5 Width 2ft   6001080.83583 2089635.4329400002 37.717802070884794 -122.438245835497 (37.7178020708848, -122.438245835497)
23646 197780 2 142 1809 19th St 6 9 1 1     11 Width 6ft   6012306.168880001 2105129.4527 37.760977438687206 -122.40053238956999 (37.7609774386872, -122.40053238957)
23764 197793 2 142 66 Ceres St 1 4 1 1     16 Width 3ft   6013832.07065 2093815.87712 37.7299977259065 -122.394462716674 (37.7299977259065, -122.394462716674)
23768 215139 2 142 810 Darien Way 3 1 1 1     12 Width 2ft   5993967.99913 2094114.77996 37.7296941579575 -122.463156396067 (37.7296941579575, -122.463156396067)
23791 245271 2 142 217 Ogden Ave 1 2 1 1     8 Width 4ft   6008459.65813 2096082.8630400002 37.7359222563084 -122.41319610842501 (37.7359222563084, -122.413196108425)
23799 142837 2 142 1409 POLK ST 2 1 1 1     10 Width 0ft   6006720.9693 2115724.3916 37.7897555322672 -122.420601310832 (37.7897555322672, -122.420601310832)
23877 215142 2 142 600 Portola Dr 5 1 1 1     15 Width 3ft   5997147.4382 2099712.0801 37.745245634987995 -122.452568576882 (37.745245634988, -122.452568576882)
24349 245242 2 142 882 York St 2 1 1 1     14 Width 3ft   6009904.77367 2104105.1123200003 37.7580306148353 -122.40876553542401 (37.7580306148353, -122.408765535424)
24745 240970 2 142 4210 21st St 3 1 1 1     14 Width 5ft   6001417.4535300005 2103381.77195 37.755565461578605 -122.43806643331499 (37.7555654615786, -122.438066433315)
25139 245353 2 142 40 Pond St 1 1 1 1     12 Width 3ft   6003161.02626 2106276.4725200003 37.7636126186575 -122.432243341071 (37.7636126186575, -122.432243341071)
26088 184889 2 142 1201 Sunset Blvd 78 9 1 1     6 Width 0ft   5984679.4382 2106701.786 37.763715182625106 -122.49619577469801 (37.7637151826251, -122.496195774698)
26192 136529 2 142 3601 Broderick St 3 1 1 1     9 Width 3ft   5999666.6912 2120931.30198 37.8036522357126 -122.44538288853501 (37.8036522357126, -122.445382888535)
26301 245318 2 142 45 Mirabel Ave 2 1 1 1     15 Width 3ft   6007552.12465 2099948.94937 37.7464866805288 -122.41660760567301 (37.7464866805288, -122.416607605673)
26394 245339 2 142 4230 24th St 1 1 1 1     12 Width 3ft   6001657.3727 2101778.0038900003 37.751175540640205 -122.437121899671 (37.7511755406402, -122.437121899671)
26574 245297 2 142 1536 Noe St 1 1 1 1     13 Width 3ft   6003292.09068 2099305.46316 37.7444793082671 -122.431292397034 (37.7444793082671, -122.431292397034)
26971 142866 2 142 1010 Polk St 2 1 1 1     8 Width 0ft   6006958.8566 2114380.7051 37.7860795036749 -122.419682864396 (37.7860795036749, -122.419682864396)
27268 197791 2 142 340 Arkansas St 2 4 1 1     14 Width 3ft   6012898.99071 2105404.50767 37.7617657223333 -122.39850136517 (37.7617657223333, -122.39850136517)
27439 199676 2 142 1438 Underwood Ave 2 1 1 1     9 Width 0ft   6015463.3731 2093112.0896 37.7281558172955 -122.388773943405 (37.7281558172955, -122.388773943405)
27523 197764 3 142 1150x Tennessee St 9 3 1 2     14 Width 8ft   6015565.1078 2103547.1261299998 37.7568139175333 -122.389150557161 (37.7568139175333, -122.389150557161)
27640 179601 2 142 901 Delano Ave 3 9 1 1     11 Width 6ft   5998646.13957 2089569.69223 37.717482785492 -122.446656735947 (37.717482785492, -122.446656735947)
27780 245345 2 142 466 Hill St 1 1 1 1     13 Width 3ft   6003300.1227 2103327.9706099997 37.755524624263394 -122.431551739942 (37.7555246242634, -122.431551739942)
28304 240881 2 142 2318 22nd St 3 9 1 1     3 Width 5ft   6011232.67405 2103729.80119 37.7570743809943 -122.404146651544 (37.7570743809943, -122.404146651544)
29624 240962 2 142 95 Eagle St 2 1 1 1     7 Width 3ft   5999817.7202 2104451.34743 37.75841114588761 -122.443675625443 (37.7584111458876, -122.443675625443)
29638 197767 3 142 1150x Tennessee St 14 3 1 2     14 Width 8ft   6015569.446690001 2103464.9174599997 37.756588430534 -122.38912981161002 (37.756588430534, -122.38912981161)
29925 136559 2 142 1200 Mason St 2 1 1 1     6 Width 3ft   6009435.38581 2117472.07438 37.794706848389 -122.41133317000099 (37.794706848389, -122.411333170001)
30015 179628 2 142 599 Somerset St 8 9 1 1     4 Width 6ft   6010332.78013 2091733.53575 37.7240849010885 -122.40641358074801 (37.7240849010885, -122.406413580748)
30616 246455 2 142 405 Duncan St 4 2 1 1     12 Width 4ft   6003830.51573 2099804.43405 37.7458798656648 -122.42946621029199 (37.7458798656648, -122.429466210292)
30892 245269 2 142 207 Bennington St 1 1 1 1     11 Width 3ft   6007122.3181 2096929.8532099999 37.7381727341921 -122.41787985679701 (37.7381727341921, -122.417879856797)
31566 179618 2 142 104 Burrows St 1 17 1 1     6     6011168.50385 2093508.14959 37.729004339277395 -122.403649399324 (37.7290043392774, -122.403649399324)
31871 136566 2 142 1218 Broadway 2 1 1 1     13 Width 4ft   6007796.91649 2118215.26217 37.796655426567995 -122.41705519283998 (37.796655426568, -122.41705519284)
32135 215152 2 142 739 Lakeview Ave 1 1 1 1     9 Width 2ft   5994637.17315 2089906.08202 37.71817661334929 -122.460538153038 (37.7181766133493, -122.460538153038)
32166 240984 2 142 426 Castro St 1 1 1 1     5 Width 3ft   6002286.66719 2105716.35154 37.7620250481505 -122.43522740403499 (37.7620250481505, -122.435227404035)
32426 240875 2 142 3498 26th St 1 1 1 1     14 Width 6ft   6006590.994390001 2100878.65509 37.7489853398132 -122.419997058715 (37.7489853398132, -122.419997058715)
32897 245304 2 142 371 Laidley St 1 1 1 1     28 Width 3ft   6003869.89796 2096618.9998400002 37.737135624318 -122.429102948069 (37.737135624318, -122.429102948069)
32915 197811 2 142 41 Dore St 4 1 1 1     12 Width 2ft   6008628.59591 2110107.11154 37.7744391520861 -122.413603620921 (37.7744391520861, -122.413603620921)
33031 240871 2 142 2913 Mission St 1 1 1 1     2 Width 3ft   6007129.38723 2101389.6911299997 37.750418847457205 -122.418171515021 (37.7504188474572, -122.418171515021)
33150 247208 2 142 800 Duboce Ave 4 9 1 1     12 Width 6ft   6001877.88305 2108298.3747 37.7690914279487 -122.43682607218 (37.7690914279487, -122.43682607218)
33275 240861 2 142 1706 Dolores St 5 2 1 1     11 Width 6ft   6005275.96554 2098387.85198 37.7420719868226 -122.424367303401 (37.7420719868226, -122.424367303401)
33691 179622 2 142 599 Somerset St 2 9 1 1     3 Width 6ft   6010361.21232 2091638.8627900002 37.7238265393343 -122.406308627159 (37.7238265393343, -122.406308627159)
33713 71641 2 142 1327 Kearny St 1 1 1 1 1 10/07/1995 12:00:00 AM 9     6011027.0266 2119468.0848 37.800276548465 -122.405966529737 (37.800276548465, -122.405966529737)
34314 245253 2 142 1090 Hampshire St 2 1 1 1     13 Width 3ft   6010233.17575 2102878.70236 37.754681555732496 -122.40754330998001 (37.7546815557325, -122.40754330998)
34423 245286 2 142 717 Duncan St 4 9 1 1     11 Width 5ft   6001933.71504 2099694.24845 37.7454697460286 -122.436017189543 (37.7454697460286, -122.436017189543)
Powered by Datasette · Query took 6.341ms · Data source: data.sfgov.org