sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1138 44040 8 21 2504 Jackson St 1 1 1 1   11/30/2012 12:00:00 AM 3   Permit Number 769379 6002104.9323 2116736.7445400003 37.7922739619269 -122.436644820121 (37.7922739619269, -122.436644820121)
1723 112197 8 44 2570 Jackson St 1 1 1 1   07/16/2015 12:00:00 AM 3 3x3   6001886.22681 2116705.46829 37.792175654341605 -122.43739930364599 (37.7921756543416, -122.437399303646)
3768 228283 8 44 2036X 15th St 6 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3773 228285 8 44 2036X 15th St 8 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3775 228281 8 44 2036X 15th St 4 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3776 228280 8 44 2036X 15th St 3 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3780 228286 8 44 2036X 15th St 9 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3781 228284 8 44 2036X 15th St 7 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3791 228279 8 44 2036X 15th St 2 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
3795 228282 8 44 2036X 15th St 5 2 1 1     3 Width 3ft   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
8183 112515 8 51 2646 Greenwich St 1 1 1 1     2 3x3   6000218.93903 2118886.7143900003 37.7980698532985 -122.443324869154 (37.7980698532985, -122.443324869154)
8240 111918 8 51 41 Toledo Way 1 1 1 1   07/02/2015 12:00:00 AM 3 3x3 Permit Number 773012 6001705.38657 2120044.83908 37.801334410325104 -122.438264349848 (37.8013344103251, -122.438264349848)
8965 107967 8 15 2405x Scott St 4 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001240.6892800005 2116684.58018 37.792081580751294 -122.439631370586 (37.7920815807513, -122.439631370586)
9707 110499 8 51 900X JESSIE ST 1 1 1 1     2 3x3   6007667.0 2110717.0 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872)
11899 113090 8 9 1213 Silver Ave 1 1 1 1   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.6087200001 37.7303322746045 -122.41230559972999 (37.7303322746045, -122.41230559973)
12209 113082 8 172 414 Somerset St 1 1 1 1   09/08/2015 12:00:00 AM 3 3x3   6010030.65327 2092539.3572 37.726280612054204 -122.40751477809499 (37.7262806120542, -122.407514778095)
12972 92206 8 44 443 Madrid St 1 1 1 1   07/22/2015 12:00:00 AM 3 3x3 Permit Number 775730 6002885.09645 2091274.7684400002 37.7224057768794 -122.432126318576 (37.7224057768794, -122.432126318576)
13395 110744 8 172 2300x Mariposa St 4 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010545.16814 2106015.79361 37.76331276399971 -122.406685416098 (37.7633127639997, -122.406685416098)
13845 117146 8 49 928 Toland St 1 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011982.52405 2098055.99364 37.741537203178 -122.401154691646 (37.741537203178, -122.401154691646)
13873 110741 8 172 2300x Mariposa St 1 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010604.54028 2106019.5636299998 37.7633264372932 -122.40648033199498 (37.7633264372932, -122.406480331995)
13959 110743 8 246 2300x Mariposa St 3 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010565.192009999 2106016.80838 37.7633166706365 -122.406616231274 (37.7633166706365, -122.406616231274)
14083 108447 8 87 696 Pennsylvania Ave 1 1 1 1     12 3x3   6014378.0974 2104018.3558400003 37.7580419391129 -122.393288684138 (37.7580419391129, -122.393288684138)
14294 110746 8 172 2300x Mariposa St 6 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010517.260009999 2106013.51672 37.7633049506856 -122.406781781161 (37.7633049506856, -122.406781781161)
14802 24222 8 76 54 Whitney Young Cir 1 1 1 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
15089 117148 8 49 928 Toland St 3 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011961.8463 2098027.63913 37.7414581941431 -122.401224196662 (37.7414581941431, -122.401224196662)
15363 110742 8 172 2300x Mariposa St 2 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010595.22782 2106018.33058 37.7633225306396 -122.40651245401101 (37.7633225306396, -122.406512454011)
15752 117149 8 49 928 Toland St 4 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011929.155180001 2097982.19203 37.7413315821976 -122.40133403893499 (37.7413315821976, -122.401334038935)
15833 117147 8 49 928 Toland St 2 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011972.25416 2098042.58697 37.7414998183769 -122.40118925978001 (37.7414998183769, -122.40118925978)
16141 116230 8 26 49 Grace St 1 1 1 1   09/02/2014 12:00:00 AM 3 2.5x4 Permit Number 770598 6008318.164030001 2110322.45497 37.7750129977898 -122.414692709823 (37.7750129977898, -122.414692709823)
16786 110745 8 298 2300x Mariposa St 5 1 1 1   05/05/2015 12:00:00 AM 3 3x3   6010533.01376 2106015.32988 37.763310810661295 -122.406727421634 (37.7633108106613, -122.406727421634)
18013 109951 8 147 400x CLEMENTINA ST 11 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
18623 117138 8 49 2203x NEWCOMB AVE 3 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
18811 19154 8 26 64 Sanchez St 1 1 1 1   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.274019999 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168)
18918 109119 8 44 2036x 15TH ST 5 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
19435 16276 8 2 690 Monterey Blvd 1 1 1 1     18 3X3   5997552.36845 2094747.2906 37.7316367142582 -122.45081049312799 (37.7316367142582, -122.450810493128)
25738 95912 8 12 858 34th Ave 1 1 1 1   03/17/2011 12:00:00 AM 4   Permit Number 767389 5985440.58134 2110021.2041 37.772873924382296 -122.49380788423099 (37.7728739243823, -122.493807884231)
27410 108451 8 87 696 Pennsylvania Ave 3 1 1 1     7 3x3   6014380.97285 2103975.72487 37.7579250434155 -122.393275756387 (37.7579250434155, -122.393275756387)
29879 97159 8 138 1079 Le Conte Ave 6 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012757.6057400005 2089814.3813 37.7189506418481 -122.397896712286 (37.7189506418481, -122.397896712286)
33388 103092 8 250 1540 Jones St 2 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008422.05981 2117808.6375599997 37.7955740826282 -122.41486325634399 (37.7955740826282, -122.414863256344)
42795 103093 8 250 1540 Jones St 3 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008420.39916 2117820.52002 37.79560661561779 -122.41486984389401 (37.7956066156178, -122.414869843894)
44012 114160 8 21 2250 Vallejo St 2 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002777.5161 2117854.22202 37.7953804657925 -122.43439760046499 (37.7953804657925, -122.434397600465)
50489 108536 8 11 1036X Mission St 2 1 1 1       3x3   6009831.243980001 2112235.16984 37.780349758914795 -122.40959364419399 (37.7803497589148, -122.409593644194)
51328 109935 8 11 260 05th St 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011302.0 2112245.5 37.780460426865396 -122.404506314811 (37.7804604268654, -122.404506314811)
53719 98437 8 21 1840 Washington St 1 1 1 1   02/13/2012 12:00:00 AM 4 4x12 Permit Number 768068 6005870.33263 2116931.58044 37.7930221942694 -122.423630300016 (37.7930221942694, -122.423630300016)
62298 114159 8 21 2250 Vallejo St 1 1 1 1   11/03/2015 12:00:00 AM 3 3x3 Permit Number 770124 6002793.85496 2117859.65506 37.795396310934294 -122.434341453993 (37.7953963109343, -122.434341453993)
62948 103091 8 250 1540 Jones St 1 1 1 1   03/20/2013 12:00:00 AM 3 3x3 Permit Number 768649 6008424.20559 2117797.21945 37.7955428518875 -122.414855023041 (37.7955428518875, -122.414855023041)
64007 102480 8 21 1456 Chestnut St 1 1 1 1   01/25/2013 12:00:00 AM 3 3x3 Permit Number 768914 6004877.03101 2120232.9115400002 37.80203068792579 -122.427302455863 (37.8020306879258, -122.427302455863)
71351 101919 8 15 1401X California St 1 1 1 1   12/07/2012 12:00:00 AM 9 3x3 Permit Number 769132 6007497.406219999 2116101.25633 37.7908340376155 -122.417941633898 (37.7908340376155, -122.417941633898)
72331 97157 8 138 1079 Le Conte Ave 4 1 1 1   08/25/2011 12:00:00 AM 2   Permit Number 768080 6012734.70575 2089832.2191 37.7189983454895 -122.397977119771 (37.7189983454895, -122.397977119771)
73660 97156 8 138 1079 Le Conte Ave 3 1 1 1   08/25/2011 12:00:00 AM 3   Permit Number 768080 6012721.62132 2089840.20593 37.7190195469812 -122.39802290784401 (37.7190195469812, -122.398022907844)
77374 109950 8 147 400x CLEMENTINA ST 10 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
77418 114246 8 21 54 COMMONWEALTH AVE 2 1 1 1       3x3   5996571.0 2114184.0 37.7849487713586 -122.45560763225201 (37.7849487713586, -122.455607632252)
77589 110797 8 58 440 29th St 1 1 1 1   05/06/2015 12:00:00 AM 3     6003697.7 2098979.2 37.743606443306206 -122.42986661573299 (37.7436064433062, -122.429866615733)
77766 100060 8 11 260 05th St 3 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
77847 103466 8 8 890X Sansome St 2 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
78583 98287 8 246 300 Mangels Ave 3 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
78687 108260 8 62 45 Belcher St 1 1 1 1   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.5446900004 37.768614322037294 -122.430103370918 (37.7686143220373, -122.430103370918)
79039 112619 8 406 3534 24th St 1 1 1 1   08/12/2015 12:00:00 AM   3x3   6005980.0 2102026.6 37.752102890525606 -122.42219142885 (37.7521028905256, -122.42219142885)
79684 107964 8 15 2401x SCOTT ST 1 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.0 2116670.0 37.792033311180504 -122.440130949989 (37.7920333111805, -122.440130949989)
79719 112585 8 48 3400x WAWONA ST 6 5 1 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
80528 108822 8 120 101x FREMONT ST 2 1 1 1       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
80666 85452 8 17 275 Guerrero St 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138.0 2107427.0 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748)
80836 103465 8 8 890X Sansome St 1 1 1 1           6012118.0 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264)
81380 112795 8 88 1235 40th Ave 1 1 1 1   08/20/2015 12:00:00 AM   3x3   5983624.1 2106731.7 37.763735444165796 -122.49984801640899 (37.7637354441658, -122.499848016409)
81444 101926 8 147 1099X Hyde St 3 1 1 1   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639.0 2116135.7 37.790936579280896 -122.417454166812 (37.7909365792809, -122.417454166812)
81451 98286 8 246 300 Mangels Ave 2 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
81723 85457 8 17 265 Guerrero St 3 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
82275 109948 8 147 400x CLEMENTINA ST 8 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
82447 98285 8 246 300 Mangels Ave 1 9 1 1   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506)
82449 112583 8 48 3400x WAWONA ST 1 5 1 1     1 4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
82994 113610 8 41 595 ALABAMA ST 1 1 1 1   10/05/2015 12:00:00 AM   3x3   6009000.0 2105472.0 37.7617330585457 -122.41199123457899 (37.7617330585457, -122.411991234579)
82999 109123 8 44 2036x 15TH ST 9 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
83145 118340 8 11 1 Franklin St 1 1 1 1       3x3   6006507.0 2110162.0 37.774470501260296 -122.42094653529199 (37.7744705012603, -122.420946535292)
83581 43568 8 44 601 29TH ST 2 1 1 1   07/20/2000 12:00:00 AM     Permit Number 43230 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
83777 103097 8 478 1199X Pacific Ave 1 1 1 1   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.41497276422399 (37.7958257402639, -122.414972764224)
84121 117143 8 49 2203x NEWCOMB AVE 8 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
84197 113998 8 44 1110 SOUTH VAN NESS AVE 1 1 1 1   10/27/2015 12:00:00 AM 3 3x3   6007591.0 2103152.0 37.75528371898589 -122.41670005245301 (37.7552837189859, -122.416700052453)
84595 102523 8 62 2192 Funston Ave 1 1 1 1   01/29/2013 12:00:00 AM   3X3 Permit Number 769544 5992300.8 2100554.8 37.7472806432819 -122.46938861272601 (37.7472806432819, -122.469388612726)
86995 85449 8 17 287 GUERRERO ST 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798.0 2107491.2 37.7670971345308 -122.42320921716801 (37.7670971345308, -122.423209217168)
87817 112830 8 26 2265 MISSION ST 1 1 1 1   08/21/2015 12:00:00 AM 3 3x3   6006944.0 2105170.0 37.760788269780996 -122.41908070679399 (37.760788269781, -122.419080706794)
87984 108821 8 120 101x FREMONT ST 1 1 1 1   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258)
88189 113605 8 41 2900 18TH ST 3 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
88888 113602 8 41 550 FLORIDA ST 3 1 1 1   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233.0 2105681.0 37.762319994612604 -122.411200142124 (37.7623199946126, -122.411200142124)
88908 107533 8 17 130 MATEO ST 1 1 1 1   02/05/2015 12:00:00 AM 3 3x3 Permit Number 774373 6003821.3 2096389.2 37.7365018950939 -122.429254591879 (37.7365018950939, -122.429254591879)
89850 113613 8 41 595 ALABAMA ST 4 1 1 1   10/05/2015 12:00:00 AM   3x3   6009000.0 2105472.0 37.7617330585457 -122.41199123457899 (37.7617330585457, -122.411991234579)
90414 112573 8 88 56 ROCKWOOD CT 1 1 1 1   12/31/2015 12:00:00 AM   3x6 Permit Number 776002 5995685.0 2098946.0 37.7430582687021 -122.457569991387 (37.7430582687021, -122.457569991387)
90793 113600 8 41 550 FLORIDA ST 1 1 1 1   10/05/2015 12:00:00 AM 1 3x3 Permit Number 773946 6009233.0 2105681.0 37.762319994612604 -122.411200142124 (37.7623199946126, -122.411200142124)
92212 109944 8 147 400x CLEMENTINA ST 4 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93245 112892 8 216 1X WEBSTER ST 4 9 1 1       3x3   6004219.0 2108568.0 37.769964530341895 -122.428747509741 (37.7699645303419, -122.428747509741)
93248 109945 8 147 400x CLEMENTINA ST 5 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93411 109120 8 44 2036x 15TH ST 6 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
93713 109942 8 147 400x CLEMENTINA ST 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3   6011439.0 2112324.0 37.780683624939606 -122.40403789076099 (37.7806836249396, -122.404037890761)
93779 109124 8 44 2036x 15TH ST 10 1 1 1       12x6   6003817.0 2107261.0 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651)
94493 110787 8 17 850x SANCHEZ ST 1 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
94702 112368 8 16 550 Jessie St 1 1 1 1   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727)
95513 117140 8 49 2203x NEWCOMB AVE 5 1 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011983.0 2098083.0 37.7416113834488 -122.4011549432 (37.7416113834488, -122.4011549432)
95747 85451 8 17 281 GUERRERO ST 1 1 1 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356)
95825 113796 8 191 331 TERESITA BLVD 2 29 1 1       3x3   5997873.0 2098382.0 37.741635103508294 -122.44996387489401 (37.7416351035083, -122.449963874894)
96009 112370 8 16 550 Jessie St 3 1 1 1   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727)
97450 113603 8 41 2900 18TH ST 1 1 1 1   10/05/2015 12:00:00 AM   3x3   6009122.0 2105484.0 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816)
97598 100059 8 11 260 05th St 2 1 1 1   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068)
Powered by Datasette · Query took 2.891ms · Data source: data.sfgov.org