sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4144 216652 2 49 329 Faxon Ave 1 2 1 1   10/06/2017 08:15:00 AM 3 Width 4ft   5994725.9247 2090785.7094700001 37.7205969659665 -122.460295076156 (37.7205969659665, -122.460295076156)
4146 216707 2 26 230 Faxon Ave 1 2 1 1   10/06/2017 08:46:00 AM 3 Width 3ft   5994758.05727 2090129.91465 37.7187981581945 -122.460136518501 (37.7187981581945, -122.460136518501)
4150 216749 2 73 26 Granada Ave 1 2 1 1   10/06/2017 08:25:00 AM 3 Width 3ft   5995639.9781599995 2090086.85434 37.7187306119189 -122.45708497580699 (37.7187306119189, -122.457084975807)
4152 216685 2 80 111 Ashton Ave 2 2 1 1   10/06/2017 08:11:00 AM 3 Width 3ft   5994133.1609 2090669.8719900001 37.720244788744104 -122.46233566126101 (37.7202447887441, -122.462335661261)
4153 216751 2 26 31 Granada Ave 1 2 1 1   10/06/2017 08:38:00 AM 3 Width 3ft   5995599.77101 2090122.1597400003 37.718825243070604 -122.45722650749799 (37.7188252430706, -122.457226507498)
4163 216683 2 77 129 Ashton Ave 1 2 1 1   10/06/2017 08:06:00 AM 3 Width 3ft   5994135.07503 2090797.4570099998 37.7205952167724 -122.462338293592 (37.7205952167724, -122.462338293592)
4183 180766 2 49 1206 Naples St 1 2 1 1   10/10/2017 09:29:00 AM 3 Width 8ft   6001093.57723 2087421.33847 37.7117233858917 -122.438043283865 (37.7117233858917, -122.438043283865)
4184 180651 2 77 178 Seville St 2 2 1 1   10/10/2017 09:53:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4196 251778 2 77 178 Seville St 4 2 1 1   10/10/2017 10:02:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4205 251774 2 73 120 Seville St 3 2 1 1   10/10/2017 10:14:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4209 180663 2 49 355 Chicago Way 1 2 1 1   10/10/2017 01:48:00 PM 3 Width 6ft   6002383.84355 2086445.14687 37.709116270155604 -122.43351405884898 (37.7091162701556, -122.433514058849)
4220 181020 2 48 183 Rolph St 1 2 1 1   10/10/2017 12:41:00 PM 3 Width 4ft   6000952.49174 2088426.9301099998 37.714476492181895 -122.438602919392 (37.7144764921819, -122.438602919392)
4227 181017 2 48 197 Rolph St 1 2 1 1   10/10/2017 11:28:00 AM 3 Width 4ft   6001019.31887 2088386.79799 37.7143700996689 -122.43836906510201 (37.7143700996689, -122.438369065102)
4231 180667 2 108 344 Chicago Way 2 2 1 1   10/10/2017 01:51:00 PM 3 Width 6ft   6002403.88387 2086502.6359 37.709275259527296 -122.43344890203998 (37.7092752595273, -122.43344890204)
4244 180664 2 170 339 Chicago Way 1 2 1 1   10/10/2017 01:55:00 PM 3 Width 6ft   6002468.5653 2086489.08528 37.7092417219876 -122.43322438540399 (37.7092417219876, -122.433224385404)
4245 181019 2 48 191 Rolph St 1 2 1 1   10/10/2017 12:36:00 PM 3 Width 4ft   6000981.45407 2088409.26942 37.714429647391896 -122.438501549606 (37.7144296473919, -122.438501549606)
4249 180650 2 77 178 Seville St 1 2 1 1   10/10/2017 09:41:00 AM 3 Width 7ft   6001253.45718 2087396.1433599999 37.7116632967974 -122.437488893205 (37.7116632967974, -122.437488893205)
4254 180668 2 108 360 Chicago Way 1 2 1 1   10/10/2017 01:45:00 PM 3 Width 6ft   6002314.90905 2086461.72548 37.709157880008 -122.433753490754 (37.709157880008, -122.433753490754)
4257 181010 2 48 215 Rolph St 1 2 1 1   10/10/2017 11:17:00 AM 3 Width 4ft   6001139.6561 2088316.9005900002 37.7141850209845 -122.437948129327 (37.7141850209845, -122.437948129327)
4271 180665 2 108 316 Chicago Way 1 2 1 1   10/10/2017 02:13:00 PM 3 Width 6ft   6002643.65919 2086652.61793 37.7097006784091 -122.432630907484 (37.7097006784091, -122.432630907484)
4272 251777 2 77 178 Seville St 3 2 1 1   10/10/2017 09:57:00 AM 3 Width 7ft   6001223.66869 2087409.71788 37.7116988757881 -122.43759282156601 (37.7116988757881, -122.437592821566)
4273 181018 2 48 197 Rolph St 2 2 1 1   10/10/2017 11:31:00 AM 3 Width 4ft   6001005.57228 2088396.0469099998 37.714394713229105 -122.43841724088999 (37.7143947132291, -122.43841724089)
4284 175543 2 13 187 Seville St 1 2 1 1   10/10/2017 09:37:00 AM 3 Width 6ft   6001178.343719999 2087386.3168 37.7116320444605 -122.43774780171302 (37.7116320444605, -122.437747801713)
4293 216862 2 49 272 Sadowa St 1 2 1 1   10/10/2017 08:43:00 AM 3 Width 3ft   5994260.82584 2087785.69998 37.7123328897311 -122.461685361516 (37.7123328897311, -122.461685361516)
4296 251775 2 73 120 Seville St 4 2 1 1   10/10/2017 10:17:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4306 181011 2 48 207 Rolph St 1 2 1 1   10/10/2017 11:21:00 AM 3 Width 4ft   6001121.315830001 2088326.0025400002 37.714208969932706 -122.438012171843 (37.7142089699327, -122.438012171843)
4315 216902 2 49 174 Bright St 1 2 1 1   10/11/2017 11:02:00 AM 3 Width 3ft   5993764.72474 2088364.55203 37.7138937098892 -122.46344200363899 (37.7138937098892, -122.463442003639)
4358 180653 2 170 245 Chicago Way 1 2 1 1   10/11/2017 07:56:00 AM 3 Width 6ft   6002847.75966 2086772.69306 37.7100419513527 -122.43193406871299 (37.7100419513527, -122.431934068713)
4400 251729 2 26 35 Bruce Ave 2 2 1 1   10/11/2017 10:39:00 AM 3 Width 3ft   5997172.50242 2091270.81822 37.7220693917577 -122.45187305021099 (37.7220693917577, -122.451873050211)
4415 216758 2 26 35 Bruce Ave 1 2 1 1   10/11/2017 10:35:00 AM 3 Width 3ft   5997172.50242 2091270.81822 37.7220693917577 -122.45187305021099 (37.7220693917577, -122.451873050211)
4451 216718 2 48 978 Capitol Ave 2 2 1 1   10/13/2017 11:36:00 AM 3 Width 3ft   5995057.03199 2090421.24862 37.7196152839906 -122.45912417326299 (37.7196152839906, -122.459124173263)
4467 216711 2 11 922 Capitol Ave 1 2 1 1   10/13/2017 12:14:00 PM 3 Width 3ft   5995050.42243 2090071.97473 37.7186558809545 -122.45912174238998 (37.7186558809545, -122.45912174239)
4484 251776 2 73 120 Seville St 5 2 1 1   10/13/2017 12:12:00 PM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4488 216714 2 11 934 Capitol Ave 1 2 1 1   10/13/2017 11:10:00 AM 3 Width 3ft   5995052.942530001 2090158.7504099999 37.7188942912315 -122.459119311509 (37.7188942912315, -122.459119311509)
4734 181032 2 184 51 Curtis St 1 2 1 1   10/24/2017 12:14:00 PM 3 Width 4ft   6000613.84351 2088248.98957 37.7139686369286 -122.439760670618 (37.7139686369286, -122.439760670618)
4769 194422 2 71 199X Kissling St 1 2 1 1     52 Width 5ft   6007901.53326 2109054.5781799997 37.771508291196 -122.41604412194401 (37.771508291196, -122.416044121944)
4797 214559 3 18 1342 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 3 Width 3ft   5991532.56497 2106606.32246 37.7638521099028 -122.472486197695 (37.7638521099028, -122.472486197695)
4821 214558 3 18 1340 Irving St 1 2 1 2   02/18/2009 12:00:00 AM 4 Width 3ft   5991564.93185 2106609.34919 37.7638622938456 -122.472374472204 (37.7638622938456, -122.472374472204)
4903 239064 3 9 68 12th St 3 2 1 2   10/31/2016 12:00:00 AM 3 Width 3ft   6007045.28032 2109725.44965 37.77330216528821 -122.41905354577699 (37.7733021652882, -122.419053545777)
5045 123372 2 160 785 03rd Ave 1 2 1 1     6 Width 4ft   5995014.0 2110353.0 37.7743403969856 -122.46071658922399 (37.7743403969856, -122.460716589224)
5057 123370 2 3 785 03rd Ave 3 2 1 1     41 Width 4ft   5995014.0 2110353.0 37.7743403969856 -122.46071658922399 (37.7743403969856, -122.460716589224)
5245 205593 2 12 30 Vasquez Ave 2 2 1 1     7 Width 3ft   5995699.652000001 2100090.8564 37.746202601761105 -122.45760214624201 (37.7462026017611, -122.457602146242)
9497 122159 2 60 547 15th Ave 1 2 1 1     17 Width 4ft   5991246.192840001 2111684.05416 37.7777776077222 -122.473847129053 (37.7777776077222, -122.473847129053)
9934 102961 3 12 1299X Junipero Serra Blvd 4 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9935 102960 3 12 1299X Junipero Serra Blvd 3 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9936 102965 3 12 1299X Junipero Serra Blvd 9 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9937 102966 3 12 1299X Junipero Serra Blvd 10 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9939 102963 3 12 1299X Junipero Serra Blvd 6 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9940 102969 3 12 1299X Junipero Serra Blvd 12 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9941 102968 3 12 1299X Junipero Serra Blvd 11 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9943 102967 3 12 1299X Junipero Serra Blvd 13 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9944 11821 3 12 1299X Junipero Serra Blvd 2 2 1 2   03/09/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
9945 102971 3 12 1299X Junipero Serra Blvd 18 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9947 11824 1 12 1299X Junipero Serra Blvd 14 2 1 13   03/13/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
10103 173844 2 143 2X Crestline Dr 1 2 1 1           5999319.0 2101169.0 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644)
10991 116458 6 267 777 Brotherhood Way 1 2 1 1     12 10x20   5989819.39068 2088633.8654 37.7144050769972 -122.477098071327 (37.7144050769972, -122.477098071327)
13306 187657 6 5 2072 15th Ave 1 2 1 1       3x3   5991666.0 2101424.0 37.7496305363998 -122.47164701446 (37.7496305363998, -122.47164701446)
13307 187654 6 47 375 Woodside Ave 1 2 1 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
18835 114526 6 3 1 TIOGA AVE 2 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
19238 104509 2 2 80 DICHIERA CT   2 1 1     14     5998620.0 2088043.0 37.7132893442667 -122.446637305723 (37.7132893442667, -122.446637305723)
19268 104883 2 3 132 Gonzalez Dr 1 2 1 1           5990322.1 2090011.1 37.718215776001294 -122.475461023549 (37.7182157760013, -122.475461023549)
22365 141244 2 21 31 COMMONWEALTH AVE 2 2 1 1     10 Width 0ft   5996487.1971 2114345.4775 37.7853873361438 -122.455909239222 (37.7853873361438, -122.455909239222)
22816 208166 2 328 15 Santa Rita Ave 2 2 1 1     3 Width 3ft   5993909.69845 2100938.88006 37.7484280758139 -122.463853078355 (37.7484280758139, -122.463853078355)
22821 197331 2 45 1501 25th St 12 2 1 1     3     6014124.123369999 2101967.77095 37.752397360459 -122.39402349321199 (37.752397360459, -122.394023493212)
22882 176369 2 39 0 Font Blvd 2 2 1 1     13     5990491.08034 2089186.3269 37.7159609464097 -122.47481676917101 (37.7159609464097, -122.474816769171)
22887 120259 2 82 130 24th Ave 3 2 1 1     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601)
22906 240229 2 180 116 Crescent Ave 13 2 1 1     2 Width 10ft   6006267.81246 2095797.32513 37.7350149365947 -122.42075393896299 (37.7350149365947, -122.420753938963)
22912 210552 2 1 414 Dewey Blvd 1 2 1 1     21 Width 3ft   5995155.65345 2100448.38141 37.7471530116111 -122.459509101961 (37.7471530116111, -122.459509101961)
22986 250821 2 22 45 Sea View Ter 2 2 1 1     9 Width 4ft   5986295.23656 2114137.57517 37.7842262706806 -122.49115456935 (37.7842262706806, -122.49115456935)
23367 208982 2 103 320 Santa Clara Ave 1 2 1 1     45 Width 3ft   5993096.565780001 2095876.3159599998 37.7344806601409 -122.46629697974501 (37.7344806601409, -122.466296979745)
23375 218050 2 16 72 San Rafael Way 2 2 1 1     4 Width 3ft   5991878.2117099995 2095609.0189900002 37.7336763568794 -122.470489732417 (37.7336763568794, -122.470489732417)
23387 213501 2 18 787 Faxon Ave 1 2 1 1     8 Width 3ft   5994873.7468 2093233.8423799998 37.7273274525845 -122.459961359351 (37.7273274525845, -122.459961359351)
23396 218586 2 37 3666 19th Ave 1 2 1 1     1 Width 3ft   5990534.77048 2091965.7217599999 37.7235950079882 -122.474868513494 (37.7235950079882, -122.474868513494)
23401 202171 2 16 20 Kalmanovitz St 3 2 1 1     8 Width 2ft   6013157.586080001 2093193.49557 37.7282512748665 -122.39675089323799 (37.7282512748665, -122.396750893238)
23402 123384 2 5 735 03rd Ave 3 2 1 1     15 Width 4ft   5995024.54572 2110548.53973 37.7748779041184 -122.460694283234 (37.7748779041184, -122.460694283234)
23409 218091 2 16 62 Eastwood Dr 1 2 1 1     4 Width 3ft   5995658.864080001 2092992.02847 37.726708612908 -122.45722974236601 (37.726708612908, -122.457229742366)
23417 183167 2 54 2422 45th Ave 1 2 1 1     0 Width 0ft   5982411.0498 2098597.3573 37.741329561902596 -122.50344114283101 (37.7413295619026, -122.503441142831)
23425 236043 2 26 821 Duboce Ave 1 2 1 1     16 Width 3ft   6001824.27489 2108233.40905 37.768910001429 -122.43700684760701 (37.768910001429, -122.437006847607)
23431 213073 2 16 50 Castenada Ave 3 2 1 1     7 Width 3ft   5994467.524230001 2101712.07423 37.7505832012692 -122.46198020334299 (37.7505832012692, -122.461980203343)
23444 201445 2 8 50 Middle Point Rd 5 2 1 1     4 Width 5ft   6018205.83588 2096062.22823 37.7364079387746 -122.379497902505 (37.7364079387746, -122.379497902505)
23445 222731 2 270 1435 Douglass St 3 2 1 1     4 Width 2ft   6001402.34337 2099545.22287 37.7450303552734 -122.437843913168 (37.7450303552734, -122.437843913168)
23447 140934 2 26 120 JORDAN AVE 2 2 1 1     9 Width 0ft   5996249.4558 2113606.8719 37.7833456744969 -122.456678312901 (37.7833456744969, -122.456678312901)
23448 121887 2 5 50 18th Ave 1 2 1 1     15 Width 5ft   5990232.62779 2114784.35142 37.78623140306821 -122.47758002792801 (37.7862314030682, -122.477580027928)
23452 207071 2 30 1927 08th Ave 3 2 1 1     11 Width 6ft   5993749.481269999 2102344.6615 37.752278758765605 -122.464509159894 (37.7522787587656, -122.464509159894)
23456 122922 2 160 2 11th Ave 7 2 1 1     7 Width 6ft   5992430.88304 2114907.16681 37.7866959384714 -122.469983652903 (37.7866959384714, -122.469983652903)
23481 218410 2 16 205 Castenada Ave 2 2 1 1     4 Width 0ft   5994280.90702 2100599.38004 37.7475172792951 -122.462544833698 (37.7475172792951, -122.462544833698)
23485 206309 2 60 226 Sadowa St 1 2 1 1     16 Width 3ft   5994744.569130001 2087779.6169999999 37.712344021541796 -122.46001297051599 (37.7123440215418, -122.460012970516)
23492 202174 2 75 100 Kalmanovitz St 1 2 1 1     21 Width 2ft   6013138.83373 2093054.0318599998 37.7278672922301 -122.39680594795401 (37.7278672922301, -122.396805947954)
23514 190971 2 47 800 Vermont St 11 2 1 1     42     6011272.24417 2104307.20268 37.7586620081736 -122.40405043579099 (37.7586620081736, -122.404050435791)
23523 208876 2 235 24 Sotelo Ave 2 2 1 1     2 Width 4ft   5993960.680430001 2101012.29566 37.7486325942246 -122.463682112736 (37.7486325942246, -122.463682112736)
23530 222049 2 12 201 Treat Ave 12 2 1 1     6 Width 6ft   6008976.23011 2107818.47181 37.768174596097104 -122.41223929451401 (37.7681745960971, -122.412239294514)
23531 212068 2 60 65 San Pablo Ave 1 2 1 1     19 Width 6ft   5994349.34377 2097659.88165 37.7394500943456 -122.46209504585501 (37.7394500943456, -122.462095045855)
23538 213933 2 82 2176 16th Ave 1 2 1 1     7 Width 3ft   5991344.08373 2100608.05246 37.7473715261751 -122.472700716564 (37.7473715261751, -122.472700716564)
23539 122063 2 163 5 17th Ave 2 2 1 1     7 Width 5ft   5990505.08019 2115005.32961 37.786853953760705 -122.476653573827 (37.7868539537607, -122.476653573827)
23557 213451 2 18 4 Cortes Ave 1 2 1 1     11 Width 3ft   5993177.52134 2099659.6696900004 37.7448734694269 -122.466291957027 (37.7448734694269, -122.466291957027)
23577 118033 2 141 89 Shore View Ave 1 2 1 1     17 Width 6ft   5984120.82492 2112822.3596099997 37.780487786596204 -122.498579960483 (37.7804877865962, -122.498579960483)
23592 218660 2 37 70 Eastwood Dr 2 2 1 1     14 Width 3ft   5995653.32428 2093064.51564 37.726907327111 -122.45725413468901 (37.726907327111, -122.457254134689)
23600 135193 2 15 35 Bay St 4 2 1 1     18 Width 8ft   6010885.4927900005 2121705.9799599997 37.806413341469 -122.40661408636801 (37.806413341469, -122.406614086368)
23638 179012 2 18 575 Lisbon St 3 2 1 1     2 Width 6ft   6001860.73543 2090148.2767900003 37.719254552441704 -122.435586742551 (37.7192545524417, -122.435586742551)
23640 218911 2 32 623 Laguna Honda Blvd 4 2 1 1     1 Width 4ft   5995731.43182 2099885.12493 37.745639539837605 -122.457477374284 (37.7456395398376, -122.457477374284)
Powered by Datasette · Query took 39.832ms · Data source: data.sfgov.org