sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1148 251463 2 136 3440 16th St 2 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1156 251462 2 136 3440 16th St 1 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
1157 251464 2 136 3440 16th St 3 5 1 1       3x3   6003947.0 2106622.0 37.7646058870383 -122.429549548663 (37.7646058870383, -122.429549548663)
5853 105967 2 136 2878 Vallejo St 1 1 1 1   05/03/2016 12:00:00 AM 3 4x6 Permit Number 772750 5999833.56214 2117445.14774 37.7940897102319 -122.44455471813 (37.7940897102319, -122.44455471813)
7453 105968 2 136 2878 Vallejo St 2 1 1 1   05/03/2016 12:00:00 AM 3 5x6 Permit Number 772750 5999819.974169999 2117444.58508 37.79408738997179 -122.444601693316 (37.7940873899718, -122.444601693316)
10034 109404 2 136 355 CHRISTOPHER DR 1 9 1 1       3x3   5995347.2 2103110.3 37.7544729812167 -122.45903946490299 (37.7544729812167, -122.459039464903)
22829 251126 2 136 120 Saint Germain Ave 3 1 1 1       3x3   5998052.0 2104136.0 37.7574444146042 -122.44975951647301 (37.7574444146042, -122.449759516473)
22830 251124 2 136 120 Saint Germain Ave 1 1 1 1       3x3   5998052.0 2104136.0 37.7574444146042 -122.44975951647301 (37.7574444146042, -122.449759516473)
22837 251125 2 136 120 Saint Germain Ave 2 1 1 1       3x3   5998052.0 2104136.0 37.7574444146042 -122.44975951647301 (37.7574444146042, -122.449759516473)
23265 5743 3 136 1760 Dolores St 1 1 1 2     1 3X3   6005273.48821 2098170.5035099997 37.7414750573209 -122.424360413724 (37.7414750573209, -122.424360413724)
23357 17461 3 136 2019 Palou Ave 1 1 1 2     4 3X3   6012621.10335 2096891.2056099998 37.7383745447599 -122.398864958367 (37.7383745447599, -122.398864958367)
23856 223819 2 136 1201 Vermont St 25 9 1 1     3 Width 4ft   6011464.41366 2102201.65675 37.75289137874 -122.40323770855 (37.75289137874, -122.40323770855)
24281 223831 2 136 100 Santa Marina St 6 7 1 1     4     6006175.86532 2097493.16654 37.7396661564679 -122.421192213677 (37.7396661564679, -122.421192213677)
25958 191004 2 136 1200 20th St 4 9 1 1     4 Width 3ft   6014284.50499 2104834.6903 37.760278216687205 -122.39366950473999 (37.7602782166872, -122.39366950474)
27222 190998 2 136 801 Minnesota St 5 9 1 1     6 Width 3ft   6015256.25071 2104772.25868 37.7601607427304 -122.39030430192601 (37.7601607427304, -122.390304301926)
27302 124237 2 136 285 Stanyan St 2 1 1 1     1 Width 1ft   5996676.38035 2110910.45447 37.775966525811896 -122.455006429336 (37.7759665258119, -122.455006429336)
27647 223848 2 136 163 Corwin St 4 13 1 1     5 Width 3ft   6000598.61266 2104296.68505 37.758030988052 -122.44096386459299 (37.758030988052, -122.440963864593)
27912 191009 2 136 1350 Rankin St 4 17 1 1     5 Width 2ft   6012766.95212 2096886.7999200001 37.7383705733355 -122.398360372158 (37.7383705733355, -122.398360372158)
27929 142997 2 136 9 Houston St 4 1 1 1     2 Width 0ft   6008266.826 2120846.8676 37.8039075806775 -122.41561561388201 (37.8039075806775, -122.415615613882)
29662 223849 2 136 163 Corwin St 5 13 1 1     5 Width 3ft   6000601.16124 2104292.97169 37.7580209372281 -122.440954784152 (37.7580209372281, -122.440954784152)
30931 57854 1 136 801 Vermont St 1 1 1 1   04/14/1977 12:00:00 AM 3   Permit Number 16796 6011320.9894199995 2104586.6510799997 37.7594320346834 -122.40390151613701 (37.7594320346834, -122.403901516137)
32781 223827 2 136 100 Santa Marina St 2 7 1 1     4     6006190.11427 2097485.70732 37.7396464784009 -122.421142417311 (37.7396464784009, -122.421142417311)
33020 126433 2 136 2601 Francisco St 2 9 1 1     6 Width 6ft   5999055.06177 2119708.37443 37.800259473158704 -122.447411378646 (37.8002594731587, -122.447411378646)
33538 207422 2 136 140 Bella Vista Way 1 1 1 1     5 Width 3ft   5998335.54163 2097096.4043400001 37.7381316225622 -122.448272015461 (37.7381316225622, -122.448272015461)
35205 223840 2 136 2145 Castro St 3 10 1 1     5 Width 10ft   6002711.92837 2099262.74028 37.7443291052999 -122.433295425556 (37.7443291052999, -122.433295425556)
36066 223820 2 136 1201 Vermont St 27 9 1 1     3 Width 4ft   6011461.07467 2102226.45341 37.7529592784527 -122.403250999655 (37.7529592784527, -122.403250999655)
36804 176179 2 136 445 Naples St 3 1 1 1     5 Width 2ft   6003347.6645 2090993.45154 37.7216595581304 -122.43050726549299 (37.7216595581304, -122.430507265493)
37700 126432 2 136 2750 Geary Blvd 4 1 1 1     2 Width 1ft   5998549.737000001 2113237.1729599996 37.7824623826667 -122.44869364731599 (37.7824623826667, -122.448693647316)
39704 200493 2 136 3239 Jennings St 1 1 1 1     8 Width 0ft   6013517.2414 2090039.3064 37.719610517873704 -122.395286677972 (37.7196105178737, -122.395286677972)
39816 223841 2 136 1548 Noe St 2 9 1 1     7 Width 2ft   6003280.5948 2099265.14761 37.7443679596294 -122.43132927013 (37.7443679596294, -122.43132927013)
39905 223852 2 136 3710 21st St 1 1 1 1     4 Width 3ft   6003652.42128 2103638.06127 37.7563960214646 -122.430355505816 (37.7563960214646, -122.430355505816)
40613 176175 2 136 89 Ottawa Ave 4 10 1 1     1 Width 2ft   5998972.727519999 2088619.88467 37.7148934808181 -122.445459617764 (37.7148934808181, -122.445459617764)
43814 191002 2 136 1200 20th St 2 9 1 1     4 Width 3ft   6014292.84021 2104834.71715 37.7602787535777 -122.393640678782 (37.7602787535777, -122.393640678782)
44305 191011 2 136 1540 Newhall St 2 2 1 1     5 Width 6ft   6014228.979169999 2095505.16644 37.734658226800796 -122.39320870561701 (37.7346582268008, -122.393208705617)
45687 223828 2 136 100 Santa Marina St 3 7 1 1     4     6006183.12873 2097474.29354 37.739614744910604 -122.421165760098 (37.7396147449106, -122.421165760098)
45929 200492 2 136 1092 Jamestown Ave 5 1 1 1     6 Width 0ft   6013522.7867 2090014.3525 37.7195423078427 -122.395265762628 (37.7195423078427, -122.395265762628)
48003 191018 2 136 801 Bay Shore Blvd 7 9 1 1     1 Width 8ft   6010873.51773 2095150.95249 37.73349864813579 -122.404784804195 (37.7334986481358, -122.404784804195)
48137 223837 2 136 1201 Douglass St 1 9 1 1     5 Width 2ft   6001376.71765 2100230.2222599997 37.746909744083204 -122.437981578698 (37.7469097440832, -122.437981578698)
48902 202080 2 136 52 Gould St 1 4 1 1     6 Width 2ft   6012726.46882 2090908.8088599998 37.7219539853837 -122.398081078675 (37.7219539853837, -122.398081078675)
51485 207415 2 136 70 Marcela Ave 1 2 1 1     2 Width 4ft   5994671.908890001 2100681.03345 37.74776398852129 -122.461198701481 (37.7477639885213, -122.461198701481)
51504 191019 2 136 1751 Silver Ave 4 9 1 1     5 Width 2ft   6011288.24464 2095271.1885 37.7338519630013 -122.403359422808 (37.7338519630013, -122.403359422808)
52383 207417 2 136 850 Quintara St 5 1 1 1     4 Width 2ft   5990746.38049 2101133.08021 37.7487784984387 -122.47480582713001 (37.7487784984387, -122.47480582713)
54282 176180 2 136 314 Tocoloma Ave 1 2 1 1     11 Width 3ft   6012557.69703 2086963.50527 37.7111115690056 -122.398387796956 (37.7111115690056, -122.398387796956)
54396 201357 2 136 1 Bitting Ave 19 9 1 1     4     6012930.1032300005 2092562.90102 37.7265071269946 -122.397493109117 (37.7265071269946, -122.397493109117)
54455 191000 2 136 900 Tennessee St 4 9 1 1     7 Width 3ft   6015461.00601 2104768.16108 37.760160847055296 -122.389595858273 (37.7601608470553, -122.389595858273)
54478 190997 2 136 801 Minnesota St 3 9 1 1     7 Width 3ft   6015256.7715 2104755.60023 37.7601150310956 -122.39030133685301 (37.7601150310956, -122.390301336853)
54953 176177 2 136 190 Foote Ave 10 9 1 1     3 Width 8ft   5998654.0159 2088359.7147099997 37.7141609137615 -122.44654250762301 (37.7141609137615, -122.446542507623)
57193 247001 2 136 401 Valley St 1 17 1 1     5 Width 8ft   6003204.32988 2099186.4435 37.744147533977795 -122.431587360294 (37.7441475339778, -122.431587360294)
58337 191003 2 136 1200 20th St 3 9 1 1     4 Width 3ft   6014288.23164 2104834.71281 37.760278485575796 -122.393656617482 (37.7602784855758, -122.393656617482)
59118 207421 2 136 7 Cresta Vista Dr 1 1 1 1     3 Width 3ft   5995137.11013 2096198.58173 37.735483049008 -122.459265520615 (37.735483049008, -122.459265520615)
59355 223824 2 136 3101 17th St 2 4 1 1     5 Width 1ft   6008016.50496 2106169.76352 37.7635937274947 -122.41544215982799 (37.7635937274947, -122.415442159828)
59459 207414 2 136 2 Lurline St 2 1 1 1     2 Width 3ft   5992083.39749 2104933.95265 37.759292091184705 -122.4704592472 (37.7592920911847, -122.4704592472)
60189 191007 2 136 1429 Rhode Island St 3 2 1 1     2     6012039.8637 2101705.15061 37.7515602022655 -122.401212795961 (37.7515602022655, -122.401212795961)
60233 176171 2 136 46 Kelloch Ave 1 10 1 1     17 Width 6ft   6008338.63627 2086231.2816700002 37.708865101208204 -122.412918213412 (37.7088651012082, -122.412918213412)
63401 191020 2 136 2019 Palou Ave 2 7 1 1     4 Width 3ft   6012619.01947 2096888.03059 37.7383657107066 -122.398871940681 (37.7383657107066, -122.398871940681)
63486 200495 2 136 3239 Jennings St 4 1 1 1     6 Width 0ft   6013536.65 2090071.1919999998 37.7196991487764 -122.39522182131999 (37.7196991487764, -122.39522182132)
63555 207420 2 136 746 Foerster St 1 9 1 1     5 Width 3ft   5998157.11941 2096037.86642 37.7352149287304 -122.44881268338301 (37.7352149287304, -122.448812683383)
63940 176176 2 136 190 Foote Ave 9 9 1 1     2 Width 8ft   5998664.09337 2088350.7446400002 37.7141368596079 -122.44650703118499 (37.7141368596079, -122.446507031185)
65510 126434 2 136 1425 Jefferson St 2 1 1 1     3 Width 2ft   6002370.67136 2121569.77606 37.8055593011865 -122.436071357532 (37.8055593011865, -122.436071357532)
65778 190999 2 136 900 Tennessee St 3 9 1 1     7 Width 3ft   6015461.30451 2104782.94295 37.7602014514497 -122.389595858288 (37.7602014514497, -122.389595858288)
66042 223825 2 136 3101 17th St 3 4 1 1     2 Width 1ft   6008027.95935 2106170.28892 37.7635958139266 -122.41540257978001 (37.7635958139266, -122.41540257978)
67078 223835 2 136 2100 Folsom St 2 1 1 1     4 Width 1ft   6008066.579580001 2106159.15106 37.7635674025314 -122.415268215666 (37.7635674025314, -122.415268215666)
67210 191015 2 136 2701 Phelps St 3 9 1 1     5 Width 3ft   6011786.474719999 2093252.28188 37.72833628057529 -122.401495039187 (37.7283362805753, -122.401495039187)
68292 191013 2 136 1540 Newhall St 4 2 1 1     4 Width 6ft   6014211.22756 2095480.9391299998 37.7345907173738 -122.393268384633 (37.7345907173738, -122.393268384633)
68299 176169 2 136 30 Kelloch Ave 1 10 1 1     17 Width 8ft   6008410.17529 2086203.98853 37.7087941752841 -122.41266903556999 (37.7087941752841, -122.41266903557)
68458 247145 2 136 500 27th St 15 7 1 1     5     6003145.29919 2100074.31823 37.7465820851075 -122.43185485912599 (37.7465820851075, -122.431854859126)
69096 223833 2 136 2700 18th St 3 4 1 1     8 Width 2ft   6009765.40934 2105513.7939299997 37.7618907290033 -122.40934692912701 (37.7618907290033, -122.409346929127)
70148 126436 2 136 33 Normandie Ter 4 9 1 1     6 Width 3ft   6000899.166669999 2117400.62389 37.794028205590294 -122.44086442836901 (37.7940282055903, -122.440864428369)
70882 200247 2 136 3225 Jennings St 1 1 1 1     7 Width 0ft   6013551.8996 2090073.2715 37.7197057067439 -122.395169254095 (37.7197057067439, -122.395169254095)
70950 191001 2 136 900 Tennessee St 7 9 1 1     7 Width 3ft   6015462.33524 2104739.93407 37.7600834154452 -122.38958928963699 (37.7600834154452, -122.389589289637)
72924 223856 2 136 4132 17th St 6 10 1 1     1 Width 3ft   6001453.75395 2105861.01375 37.7623749212873 -122.438118485182 (37.7623749212873, -122.438118485182)
73332 223839 2 136 1201 Douglass St 3 9 1 1     5 Width 2ft   6001375.46533 2100241.14483 37.7469396636504 -122.437986691344 (37.7469396636504, -122.437986691344)
73931 223821 2 136 1315 Utah St 1 4 1 1     1 Width 3ft   6010905.03625 2102087.35489 37.752546274702794 -122.405164102267 (37.7525462747028, -122.405164102267)
80042 112741 2 136 2514 CLAY ST 2 5 1 1       3x3   6002696.0 2116178.0 37.7907733646004 -122.43455974658 (37.7907733646004, -122.43455974658)
82709 46248 1 136 1675 Hawes St 1 1 1 1   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798)
86057 94469 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
89776 98528 1 136 428 11th St 1 8 1 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
93173 52845 1 136 11X Guy Pl 3 1 1 1   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014349.88850075 2114221.0453464002 37.7860546845502 -122.394100496655 (37.7860546845502, -122.394100496655)
93747 26415 3 136 34 Maple St 12 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
101423 52849 1 136 50 Lansing St 6 1 1 1   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014349.88850075 2114221.0453464002 37.7860546845502 -122.394100496655 (37.7860546845502, -122.394100496655)
101916 26413 3 136 34 Maple St 10 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
103402 101698 2 136 2700 18th St 2 5 1 1       2x3   6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152)
103566 94487 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
104384 98316 2 136 1800X Clay St 1 5 1 1       2x2   6006008.9 2116666.9 37.7923032687502 -122.42313202643899 (37.7923032687502, -122.423132026439)
105424 26414 3 136 34 Maple St 11 5 1 2     3 10   5996568.2197254 2116061.2858977 37.790103136313206 -122.455752999345 (37.7901031363132, -122.455752999345)
106973 102811 1 136 50 Lansing St 8 1 1 1     5 3x3 Permit Number 48860 6014354.6 2114220.8 37.7860542727502 -122.394084178828 (37.7860542727502, -122.394084178828)
107335 52847 1 136 11X Guy Pl 1 1 1 1   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014349.88850075 2114221.0453464002 37.7860546845502 -122.394100496655 (37.7860546845502, -122.394100496655)
109279 102813 1 136 50 Lansing St 10 1 1 1     5 3x3 Permit Number 48860 6014354.6 2114220.8 37.7860542727502 -122.394084178828 (37.7860542727502, -122.394084178828)
117618 52848 1 136 50 Lansing St 7 1 1 1   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014349.88850075 2114221.0453464002 37.7860546845502 -122.394100496655 (37.7860546845502, -122.394100496655)
118464 98529 1 136 428 11th St 2 8 1 1   02/22/2012 12:00:00 AM   3x3 Permit Number 768342 6009030.0 2108561.0 37.7702164230423 -122.41210579217699 (37.7702164230423, -122.412105792177)
119324 102814 1 136 50 Lansing St 11 1 1 1     5 3x3 Permit Number 48860 6014354.6 2114220.8 37.7860542727502 -122.394084178828 (37.7860542727502, -122.394084178828)
120056 223842 2 136 3922 22nd St 3 10 1 1     7 Width 4ft   6002306.42247 2102988.7945 37.7545369555235 -122.434964002506 (37.7545369555235, -122.434964002506)
122128 52846 1 136 11X Guy Pl 2 1 1 1   06/22/2006 12:00:00 AM 5 3x3 Permit Number 48860 6014349.88850075 2114221.0453464002 37.7860546845502 -122.394100496655 (37.7860546845502, -122.394100496655)
122993 102812 1 136 50 Lansing St 9 1 1 1     5 3x3 Permit Number 48860 6014354.6 2114220.8 37.7860542727502 -122.394084178828 (37.7860542727502, -122.394084178828)
124170 121579 2 136 742X Dolores St 1 1 1 1     3 1x1   6004940.0 2104032.0 37.757550534457295 -122.425930645849 (37.7575505344573, -122.425930645849)
124810 70611 1 136 1355 Bush St 2 1 1 1   10/04/2013 12:00:00 AM     Permit Number 770302 6007018.06454335 2115342.51032554 37.7887237195829 -122.419546283037 (37.7887237195829, -122.419546283037)
125819 110920 2 136 77 FEDERAL ST 6 1 1 1       2x1   6014792.0 2113102.0 37.783006604033204 -122.392492594241 (37.7830066040332, -122.392492594241)
126549 94468 7 136 4128 17th St   6 1 1         in landscaped area 6001502.0 2105859.0 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108)
129687 191021 2 136 1951 Revere Ave 8 7 1 1     7     6013036.60828 2095880.65863 37.7356229367385 -122.397357487761 (37.7356229367385, -122.397357487761)
130215 126429 2 136 2965 Broderick St 1 9 1 1     7 Width 4ft   5999956.74721 2118771.72266 37.7977391617965 -122.444223858445 (37.7977391617965, -122.444223858445)
130253 223823 2 136 3101 17th St 1 4 1 1     2 Width 1ft   6008008.73592 2106169.28223 37.7635919693097 -122.415468996495 (37.7635919693097, -122.415468996495)
Powered by Datasette · Query took 2.774ms · Data source: data.sfgov.org