sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2837 241584 2 37 38X Java St 3 2 1 1     7 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
2841 241585 2 37 38X Java St 4 2 1 1     8 Width 3ft   5999751.0 2107467.0 37.7666875731096 -122.444123063419 (37.7666875731096, -122.444123063419)
3028 191362 2 195 999 Key Ave 2 2 1 1     27     6013336.3333 2089743.8780099999 37.718789267498295 -122.39589132571999 (37.7187892674983, -122.39589132572)
3029 193472 2 196 1059 Jamestown Ave 1 2 1 1     8     6013665.43892 2089838.8488900003 37.719068342415596 -122.39476037791599 (37.7190683424156, -122.394760377916)
3033 253285 2 141 8245 Geary Blvd 1 2 1 1   08/15/2017 12:00:00 AM 3     5981372.0 2112274.0 37.7788205636315 -122.50804856364901 (37.7788205636315, -122.508048563649)
3040 189089 2 74 1033 Le Conte Ave 2 2 1 1     6     6012956.43123 2089677.63232 37.718586227543504 -122.397199861797 (37.7185862275435, -122.397199861797)
3041 182178 2 28 1799X Lawton St 5 2 1 1     8 Width 0ft   5988865.0 2104441.0 37.7577519603078 -122.48155379203999 (37.7577519603078, -122.48155379204)
3065 175836 2 49 101 Rhine St 3 2 1 1     5 Width 3ft   5994366.585519999 2086543.72285 37.70892880020671 -122.46122985488998 (37.7089288002067, -122.46122985489)
3254 244746 2 9 98 12th St 1 2 1 1     15 Width 3ft   6007069.86029 2109755.10428 37.7733849739584 -122.418970623803 (37.7733849739584, -122.418970623803)
3382 122965 2 141 98 09th Ave 4 2 1 1     5 Width 5ft   5993050.799269999 2114904.9128799997 37.786725565514004 -122.467838745487 (37.786725565514, -122.467838745487)
3405 180669 2 73 171 Winding Way 3 2 1 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
3411 181033 2 26 39 Curtis St 1 2 1 1     0 Width 4ft   6000587.53239 2088326.47 37.71417988317489 -122.439857163381 (37.7141798831749, -122.439857163381)
3413 180646 2 73 451 Rolph St 1 2 1 1     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236)
3423 251752 2 37 128 South Hill Blvd 2 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3430 180648 2 73 120 Seville St 1 2 1 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
3432 180655 2 37 128 South Hill Blvd 1 2 1 1     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3488 251753 2 37 128 South Hill Blvd 3 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3734 118035 2 2 450 38th Ave 1 2 1 1     21 Width 4ft   5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
3800 213446 2 18 530 Magellan Ave 2 2 1 1     5 Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3812 253561 2 44 530 Magellan Ave 1 2 1 1       Width 3ft   5993033.55222 2099443.36305 37.744271238444206 -122.46677405027799 (37.7442712384442, -122.466774050278)
3816 219559 2 119 4 Cortes Ave 6 2 1 1     28 Width 3ft   5993189.55754 2099585.29183 37.7446699411581 -122.46624493416799 (37.7446699411581, -122.466244934168)
3822 253559 2 18 4 Cortes Ave 5 2 1 1       Width 3ft   5993184.39566 2099612.1282900004 37.7447433294416 -122.46626473273199 (37.7447433294416, -122.466264732732)
3850 207785 2 103 290 Santa Clara Ave 1 2 1 1   09/28/2017 12:00:00 AM 3 Width 10ft   5993081.87997 2096205.8056700001 37.7353845093885 -122.46637169180299 (37.7353845093885, -122.466371691803)
3920 216755 2 73 115 Harold Ave 1 2 1 1   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.877280001 2090654.02957 37.720353912480995 -122.453151180205 (37.720353912481, -122.453151180205)
3943 216737 2 49 11 Lee Ave 1 2 1 1   10/04/2017 02:31:00 PM 3 Width 2ft   5996481.70655 2089974.5093900003 37.7184704425356 -122.45416736555799 (37.7184704425356, -122.454167365558)
3959 216642 2 49 50 Lee Ave 1 2 1 1   10/04/2017 01:57:00 PM 3 Width 2ft   5996528.83108 2090217.4765599999 37.7191402755735 -122.45402201441999 (37.7191402755735, -122.45402201442)
3999 181035 2 13 170 Rolph St 1 2 1 1   10/05/2017 04:20:00 PM 3 Width 4ft   6000927.8060099995 2088408.3131900001 37.7144239699579 -122.438686909772 (37.7144239699579, -122.438686909772)
4004 251722 2 26 18 Lobos St 2 2 1 1   10/05/2017 03:08:00 PM 3     5996685.56427 2088703.70423 37.7149927956564 -122.45337101855101 (37.7149927956564, -122.453371018551)
4006 216739 2 11 11 Brighton Ave 1 2 1 1   10/05/2017 08:12:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4014 216033 2 26 4 Lobos St 1 2 1 1   10/05/2017 03:13:00 PM 3     5996833.19651 2088697.5304900003 37.7149843051513 -122.452860296276 (37.7149843051513, -122.452860296276)
4026 216034 2 26 8 Lobos St 1 2 1 1   10/05/2017 03:11:00 PM 3     5996778.28459 2088695.06883 37.714974399131705 -122.45304991653099 (37.7149743991317, -122.453049916531)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4071 251734 2 49 856 Prague St 3 2 1 1   10/05/2017 08:08:00 AM 3 Width 6ft   6002039.2106099995 2086908.72872 37.7103696049432 -122.434738288839 (37.7103696049432, -122.434738288839)
4083 181036 2 13 170 Rolph St 2 2 1 1   10/05/2017 04:16:00 PM 3 Width 4ft   6000944.46471 2088397.62402 37.7143955675655 -122.438628565353 (37.7143955675655, -122.438628565353)
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4096 181028 2 48 95 Rolph St 2 2 1 1   10/05/2017 04:38:00 PM 3 Width 4ft   6000533.08885 2088674.4676599998 37.715132307492794 -122.44007027934201 (37.7151323074928, -122.440070279342)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4113 181027 2 48 95 Rolph St 1 2 1 1   10/05/2017 04:23:00 PM 3 Width 4ft   6000546.58685 2088667.2481099998 37.7151132526545 -122.440023107188 (37.7151132526545, -122.440023107188)
4117 216048 2 12 40 Lobos St 1 2 1 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
4129 216706 2 9 231 Faxon Ave 1 2 1 1   10/06/2017 08:40:00 AM 3 Width 3ft   5994712.86869 2090137.86358 37.718817384787606 -122.460293291921 (37.7188173847876, -122.460293291921)
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)
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)
9572 100227 2 22 542 Valley St 1 2 1 1     30   Permit Number 769993 6002426.0 2099190.0 37.7441131524814 -122.434278904907 (37.7441131524814, -122.434278904907)
10103 173844 2 143 2X Crestline Dr 1 2 1 1           5999319.0 2101169.0 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644)
10370 107580 2 44 100 Panama St 2 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.709603859212706 -122.468025367885 (37.7096038592127, -122.468025367885)
10524 107581 2 44 100 Panama St 3 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.946819999 2086830.9956900002 37.7096038591978 -122.46806839775299 (37.7096038591978, -122.468068397753)
11907 107582 2 44 100 Panama St 4 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.4734200002 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552)
12169 107579 2 44 100 Panama St 1 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943)
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)
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)
22945 104992 2 7 2423 47TH AVE 1 2 1 1   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.74123331264771 -122.505795454359 (37.7412333126477, -122.505795454359)
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)
Powered by Datasette · Query took 47.336ms · Data source: data.sfgov.org