sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
13879 50774 1 48   1 1 1 1         Permit Number 47304          
1835 251742 2 48 300 Naylor St 2 1 1 1       3x3   6002771.0 2086560.0 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389)
186108 176878 2 48 526 Lathrop Ave 17 1 1 1     1 Width 3ft   6013154.94381 2086496.55313 37.709862662502104 -122.396290845073 (37.7098626625021, -122.396290845073)
31319 176877 2 48 526 Lathrop Ave 14 1 1 1     2 Width 3ft   6013098.43993 2086515.08302 37.709910397621705 -122.396487432357 (37.7099103976217, -122.396487432357)
4432 172375 2 48 216 Naylor St 1 1 1 1   10/11/2017 07:37:00 AM 3 Width 2ft   6002574.0 2086750.0 37.7099641176609 -122.432878614235 (37.7099641176609, -122.432878614235)
146826 176876 2 48 526 Lathrop Ave 11 1 1 1     2 Width 3ft   6013031.567530001 2086536.06642 37.7099642921874 -122.396720027609 (37.7099642921874, -122.396720027609)
135940 176875 2 48 526 Lathrop Ave 7 1 1 1     2 Width 3ft   6012929.76757 2086570.3757 37.710052832254796 -122.39707427417801 (37.7100528322548, -122.397074274178)
52735 176874 2 48 526 Lathrop Ave 3 1 1 1     1 Width 3ft   6012843.86934 2086597.3532 37.7101221250005 -122.397373047849 (37.7101221250005, -122.397373047849)
13144 108829 1 48 545 Lathrop Ave 3 1 1 1   01/06/2015 12:00:00 AM 3   Permit Number 773819 6012931.90275 2086607.7470099998 37.7101555653976 -122.397069513169 (37.7101555653976, -122.397069513169)
80279 108768 1 48 500X Lathrop Ave 7 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
103563 108764 1 48 500X Lathrop Ave 3 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
103975 108778 1 48 500X Lathrop Ave 17 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
115794 108772 1 48 500X Lathrop Ave 11 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
127494 108775 1 48 500X Lathrop Ave 14 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
4276 180842 2 48 87 Laura St 3 1 1 1   10/10/2017 03:54:00 PM 3 Width 2ft   5997291.8877 2087045.22216 37.710473721248 -122.45115578601299 (37.710473721248, -122.451155786013)
140964 108825 1 48 146-150X Gillette Ave 2 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773819 6013072.89275 2086799.9167400002 37.7106910734067 -122.39659568235001 (37.7106910734067, -122.39659568235)
3992 159336 2 48 523 Ellington Ave 1 1 1 1   10/05/2017 10:36:00 AM 3 Width 0ft   5998080.57171 2087152.95418 37.7108146533454 -122.448437690352 (37.7108146533454, -122.448437690352)
3982 159338 2 48 517 Ellington Ave 1 1 1 1   10/05/2017 11:04:00 AM 3 Width 0ft   5998112.9338 2087183.20699 37.7108995709325 -122.44832801714199 (37.7108995709325, -122.448328017142)
4070 159339 2 48 517 Ellington Ave 2 1 1 1   10/05/2017 11:12:00 AM 3 Width 0ft   5998126.4578599995 2087195.02696 37.710932799068104 -122.44828212563 (37.7109327990681, -122.44828212563)
64001 69398 1 48 1174 Munich St 1 1 1 1 1 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.4410400002 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606)
57165 176885 2 48 191 Rey St 1 1 1 1     1 Width 3ft   6008580.05361 2087004.5673599998 37.7110019335603 -122.412138452652 (37.7110019335603, -122.412138452652)
17806 25338 3 48 297x Sagamore St 1 1 1 2   10/03/2015 02:44:00 PM 3 3X3   5994177.957230001 2087395.7640200001 37.7112574471386 -122.46194351998699 (37.7112574471386, -122.461943519987)
11504 25763 3 48 1682 Geneva Ave 1 1 1 2   08/20/2015 06:02:00 PM 3 2X3   6004184.86566 2087196.3858299998 37.711281031873 -122.42734293164801 (37.711281031873, -122.427342931648)
4077 159345 2 48 461 Ellington Ave 1 1 1 1   10/05/2017 11:39:00 AM 3 Width 0ft   5998268.07471 2087327.6085 37.7113049331395 -122.447802205131 (37.7113049331395, -122.447802205131)
4058 159346 2 48 461 Ellington Ave 2 1 1 1   10/05/2017 11:49:00 AM 3 Width 0ft   5998276.6806 2087336.8062099998 37.7113306798385 -122.44777312285 (37.7113306798385, -122.44777312285)
4091 159347 2 48 461 Ellington Ave 3 1 1 1   10/05/2017 11:27:00 AM 3 Width 0ft   5998288.37354 2087349.92963 37.711367382076396 -122.44773365338999 (37.7113673820764, -122.44773365339)
4072 159348 2 48 461 Ellington Ave 4 1 1 1   10/05/2017 11:44:00 AM 3 Width 0ft   5998312.68186 2087372.3667799998 37.711430378688796 -122.447651252104 (37.7114303786888, -122.447651252104)
4258 19062 3 48 174 Sagamore St 1 1 1 2   10/10/2017 08:47:00 AM 3 3X3   5995225.08055 2087462.80286 37.7115017488702 -122.458329272374 (37.7115017488702, -122.458329272374)
65576 176919 2 48 140 Seville St 1 1 1 1     3 Width 5ft   6001505.61042 2087336.29034 37.71151328628479 -122.436613103724 (37.7115132862848, -122.436613103724)
1848 251743 2 48 143 Cordova St   1 1 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
1836 251749 2 48 601 Prague St   1 1 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
179772 176916 2 48 380 Rolph St 1 1 1 1     3 Width 3ft   6001888.93185 2087835.8979599997 37.7129068748214 -122.43532396063601 (37.7129068748214, -122.435323960636)
150268 49761 1 48 366@ REY Leland Ave 2 1 1 1 1 06/04/2003 12:00:00 AM 4   Permit Number 46555 6008949.54261 2087928.8807700002 37.713560633393 -122.41092664676 (37.713560633393, -122.41092664676)
157761 116545 3 48 1041x Naples St 1 3 1 2     2 3x3   6001537.057630001 2088100.5912 37.7136136745151 -122.436559085032 (37.7136136745151, -122.436559085032)
146422 116546 3 48 1041x Naples St 2 3 1 2     3 3x3   6001545.434780001 2088113.86518 37.7136505979649 -122.43653108014401 (37.7136505979649, -122.436531080144)
30642 176917 3 48 1002x Naples St 9 3 1 2     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224)
64250 116547 3 48 1041x Naples St 3 3 1 2     4 3x3   6001554.67745 2088129.8106 37.7136949057732 -122.436500274771 (37.7136949057732, -122.436500274771)
59010 116551 3 48 1002x Naples St 7 3 1 2     4 3x3   6001523.56178 2088140.13665 37.713721490625 -122.43660856033199 (37.713721490625, -122.436608560332)
158984 116549 3 48 1041x Naples St 5 3 1 2     4 3x3   6001562.82912 2088145.2407900002 37.713737736870705 -122.43647320339599 (37.7137377368707, -122.436473203396)
151872 116550 3 48 1002x Naples St 6 3 1 2     5 3x3   6001534.78323 2088160.3445099997 37.7137776146169 -122.43657122050399 (37.7137776146169, -122.436571220504)
51471 116543 3 48 1041x Naples St 6 3 1 2     5 3x3   6001574.8493099995 2088164.89401 37.713792383287796 -122.43643306305 (37.7137923832878, -122.43643306305)
156295 116548 3 48 1002x Naples St 4 3 1 2     3 3x3   6001544.87474 2088178.1549900002 37.713827091712396 -122.436537614614 (37.7138270917124, -122.436537614614)
23771 116544 3 48 1041x Naples St 7 3 1 2     5 3x3   6001586.02621 2088182.95127 37.713842599620904 -122.436395723209 (37.7138425996209, -122.436395723209)
44260 116540 3 48 1002x Naples St 3 3 1 2     3 3x3   6001555.506159999 2088195.95431 37.713876568835396 -122.43650214175399 (37.7138765688354, -122.436502141754)
24383 116552 3 48 1041x Naples St 8 3 1 2     3 3x3   6001598.03525 2088202.06693 37.7138957693564 -122.436355582838 (37.7138957693564, -122.436355582838)
158635 116539 3 48 1002x Naples St 2 3 1 2     3 3x3   6001567.487380001 2088213.7256900002 37.7139260459311 -122.436462001442 (37.7139260459311, -122.436462001442)
171144 176918 3 48 1041x Naples St 9 3 1 2     4     6001604.803669999 2088215.9120200002 37.713934169489704 -122.43633317895599 (37.7139341694897, -122.436333178956)
11046 116538 3 48 1002x Naples St 1 3 1 2     1 3x3   6001578.1015800005 2088233.43486 37.7139807660769 -122.436426724612 (37.7139807660769, -122.436426724612)
4130 216848 2 48 258 Farallones St 1 1 1 1   10/06/2017 02:39:00 PM 3 Width 3ft   5994378.76562 2088424.12647 37.7140926462446 -122.461323980613 (37.7140926462446, -122.461323980613)
4192 216845 2 48 194 Farallones St 1 1 1 1   10/10/2017 07:48:00 AM 3 Width 3ft   5995118.95449 2088413.12295 37.714105005620205 -122.458764825742 (37.7141050056202, -122.458764825742)
4282 251444 2 48 244 Farallones St 1 1 1 1   10/10/2017 07:40:00 AM 3 3x3   5994545.0 2088436.0 37.7141348140673 -122.460750275072 (37.7141348140673, -122.460750275072)
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)
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)
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)
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)
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)
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)
4266 181021 2 48 179 Rolph St 1 1 1 1   10/10/2017 12:49:00 PM 3 8x6   6000934.6994199995 2088437.13017 37.71450348711 -122.438665147076 (37.71450348711, -122.438665147076)
47585 176883 2 48 96 Alpha St 4 7 1 1     1     6011048.63475 2088252.8219299999 37.7145675926038 -122.40369417294501 (37.7145675926038, -122.403694172945)
172938 176884 2 48 96 Alpha St 2 7 1 1     1     6011062.55449 2088258.87965 37.7145850034576 -122.40364648639601 (37.7145850034576, -122.403646486396)
159962 207028 2 48 227 Ramsell St 1 4 1 1     1 Width 3ft   5992956.15905 2088729.24095 37.7148484391912 -122.46626317241001 (37.7148484391912, -122.46626317241)
39635 207026 2 48 229 Lobos St 2 1 1 1     2 Width 3ft   5994724.722630001 2088692.2453700001 37.71484874224021 -122.460147642199 (37.7148487422402, -122.460147642199)
11819 115757 1 48 1718 Cayuga Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.2129099998 37.715109392747294 -122.44840583185899 (37.7151093927473, -122.448405831859)
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)
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)
137158 207029 2 48 835 Sargent St 1 4 1 1     7 Width 3ft   5991723.94975 2089189.17612 37.7160401362134 -122.47055564102301 (37.7160401362134, -122.470555641023)
178180 207030 2 48 835 Sargent St 2 4 1 1     7 Width 3ft   5991738.49074 2089190.01168 37.716043271265704 -122.470505441771 (37.7160432712657, -122.470505441771)
86290 40470 1 48 43 Lakeview Ave 6 1 1 1   06/15/1999 12:00:00 AM     Permit Number 41555 5997449.10168169 2089159.83978526 37.7162889747674 -122.450764790718 (37.7162889747674, -122.450764790718)
55458 207027 2 48 43 Lakeview Ave 1 4 1 1     7 Width 3ft   5997356.5626300005 2089224.02458 37.716459913666704 -122.451089274853 (37.7164599136667, -122.451089274853)
62998 176882 2 48 371 Wilde Ave 1 1 1 1     1 Width 3ft   6010924.50069 2089093.90072 37.7168700890604 -122.404182392406 (37.7168700890604, -122.404182392406)
167979 95712 1 48 642 Athens St 1 1 1 1 1 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819)
21386 19350 3 48 618 Shields St 1 1 1 2   10/06/2014 12:00:00 AM 3 3X3 Permit Number 774109 5992350.09465 2089866.75515 37.7179367902328 -122.468440675709 (37.7179367902328, -122.468440675709)
36288 31158 1 48 600 Head St 1 1 1 1 1 07/28/2001 12:00:00 AM 1   Permit Number 34860 5993522.80361 2089878.90243 37.71803781197371 -122.464388049089 (37.7180378119737, -122.464388049089)
139293 38921 1 48 749 Lakeview Ave 1 1 1 1 1 11/02/1998 12:00:00 AM     Permit Number 40731 5994544.80644489 2089901.89590816 37.718159804985795 -122.460857119734 (37.7181598049858, -122.460857119734)
13068 109689 1 48 836 Russia Ave 1 1 1 1 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774161 6003406.50306 2089728.7354700002 37.7181902596385 -122.430213694415 (37.7181902596385, -122.430213694415)
3971 251681 2 48 4 Lee Ave 1 1 1 1   10/04/2017 02:36:00 PM 3 3x5   5996550.0 2089909.0 37.7182944850221 -122.453926576307 (37.7182944850221, -122.453926576307)
41516 46433 1 48 2St. Ankeny St 1 1 1 1 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011103.47209 2089684.5822599998 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234)
44865 46434 1 48 2St. Ankeny St 2 1 1 1 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174)
43685 46431 1 48 2St. Ankeny St 3 1 1 1   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.40365624942899 (37.7185939356546, -122.403656249429)
2122 252898 2 48 501x Mount Vernon Ave 3 1 1 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
3974 162331 2 48 26 Lee Ave 1 1 1 1   10/04/2017 02:09:00 PM 3 Width 0ft   5996526.61739 2090076.5104099999 37.7187530886569 -122.454019490912 (37.7187530886569, -122.454019490912)
3950 162332 2 48 36 Lee Ave 1 1 1 1   10/04/2017 02:06:00 PM 3 Width 0ft   5996526.7373 2090117.21242 37.718864853708205 -122.45402201441001 (37.7188648537082, -122.45402201441)
11936 109688 1 48 610 Russia Ave 1 1 1 1 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774167 6002866.933730001 2090069.7229400002 37.719095959684 -122.432103090885 (37.719095959684, -122.432103090885)
4142 216723 2 48 51 Miramar Ave 1 1 1 1   10/06/2017 08:05:00 AM 3 Width 2ft   5995305.86266 2090248.9874099998 37.7191565973781 -122.458251599737 (37.7191565973781, -122.458251599737)
4270 252889 2 48 301x Howth St 2 1 1 1   10/10/2017 03:58:00 PM 3 3x3   5997131.0 2090234.0 37.7192201544045 -122.451941749186 (37.7192201544045, -122.451941749186)
98279 120680 4 48 522 Moscow St 1 1 1 1   08/23/2016 12:00:00 AM 3 3x3   6003717.0 2090174.0 37.719430440149104 -122.42917217063999 (37.7194304401491, -122.42917217064)
59233 108371 1 48 575 Paris St 1 1 1 1 1   1 3x3   6001620.80772 2090281.19611 37.719605888781295 -122.43642558878 (37.7196058887813, -122.43642558878)
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)
24388 63507 1 48 574 Paris St 1 1 1 1   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.43653782327401 (37.7196774559426, -122.436537823274)
154067 176880 2 48 3333 San Bruno Ave 1 1 1 1     2 Width 3ft   6012013.01229 2090122.1042900002 37.719754090752204 -122.40049209994801 (37.7197540907522, -122.400492099948)
3913 253116 2 48 1000 Cayuga Ave 26 1 1 1   10/04/2017 12:00:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3918 253108 2 48 1000 Cayuga Ave 18 1 1 1   10/04/2017 11:41:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3928 253114 2 48 1000 Cayuga Ave 24 1 1 1   10/04/2017 11:55:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3937 253112 2 48 1000 Cayuga Ave 22 1 1 1   10/04/2017 11:51:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3968 253118 2 48 1000 Cayuga Ave 28 1 1 1   10/04/2017 01:35:00 PM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3973 253110 2 48 1000 Cayuga Ave 20 1 1 1   10/04/2017 11:46:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
3935 160073 2 48 1000 Cayuga Ave 16 1 1 1   10/04/2017 11:36:00 AM 3 Width 0ft   6000082.999340001 2090399.7386 37.7198438772755 -122.44174972458201 (37.7198438772755, -122.441749724582)
98150 43741 1 48 840 Mount Vernon Ave 3 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
103046 43742 1 48 840 Mount Vernon Ave 4 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
112382 43739 1 48 840 Mount Vernon Ave 1 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
114348 43740 1 48 840 Mount Vernon Ave 2 1 1 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
Powered by Datasette · Query took 12.305ms · Data source: data.sfgov.org