sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
692 176334 2 103 287 Hester Ave 7 17 1 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 2 103 287 Hester Ave 5 17 1 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
1320 251503 3 143 800X Bosworth St 15 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1324 251501 3 143 800X Bosworth St 13 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1326 251502 3 143 800X Bosworth St 14 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1335 251499 3 143 800X Bosworth St 11 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1341 251498 3 143 800X Bosworth St 10 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1348 251500 3 143 800X Bosworth St 12 17 1 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1524 251544 2 27 863X Ocean Ave   17 1 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1573 251597 9 148 1650 Valencia St 1 17 1 1           6006336.0 2100501.0 37.747934015176504 -122.42085202386299 (37.7479340151765, -122.420852023863)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1817 251719 6 116 1301 Clayton St 1 17 1 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
1875 251783 3 47 610 Clipper St 5 17 1 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
1918 251819 3 159 298X Corbett Ave 1 17 1 2       3x3 Permit Number 778898 5999572.0 2105342.0 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505)
2610 253145 6 26 801X Santiago St 1 17 1 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2768 219151 2 108 1500 16th Ave 5 17 1 1     15 Width 4ft   5991179.47447 2105124.8493 37.759763935780704 -122.47359934526101 (37.7597639357807, -122.473599345261)
2774 219153 2 108 1500 16th Ave 7 17 1 1     8 Width 6ft   5991180.54312 2105148.28148 37.759828336219705 -122.473597358645 (37.7598283362197, -122.473597358645)
2776 219152 2 108 1500 16th Ave 6 17 1 1     15 Width 6ft   5991180.06905 2105137.8500200002 37.759799666743 -122.473598237272 (37.759799666743, -122.473598237272)
3257 253379 2 10 899 Waller St 1 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3261 253388 2 129 30 Grand View Ave 1 17 1 1       3x3   6000475.0 2103841.0 37.756772747069604 -122.44135867200701 (37.7567727470696, -122.441358672007)
3262 253382 2 10 899 Waller St 4 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3270 253380 2 10 899 Waller St 2 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3271 253381 2 10 899 Waller St 3 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3279 253383 2 10 899 Waller St 5 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3280 253389 2 116 30X Grand View Ave 2 17 1 1       3x3   6000475.0 2103841.0 37.756772747069604 -122.44135867200701 (37.7567727470696, -122.441358672007)
3399 251598 2 17 900x Moraga St 1 17 1 1   09/06/2017 12:00:00 AM 3 3x3 Permit Number 780206 5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
3552 253469 7 114 701 Stanyan St 5 17 1 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
3586 253468 3 213 801X Alemany Blvd 1 17 1 2                    
3610 115725 2 198 250X Octavia St 2 17 1 5                    
3743 175363 2 12 1 Brotherhood Way 8 17 1 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 6 25 2 Garfield St 1 17 1 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
9694 173632 2 3 3300X Market St 1 17 1 1                    
9916 173733 3 47 14 Richland Ave 1 17 1 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
9987 173779 6 148 99X Cleveland St 2 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10000 173780 6 55 99X Cleveland St 3 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10004 114140 6 3 1200X JUNIPERO SERRA BLVD 5 17 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
15743 115724 2 198 250x Octavia St 1 17 1 5                    
23489 247849 2 5 152 Chapman St 1 17 1 1     15     6009118.007540001 2098230.0964599997 37.74185503078979 -122.41107154552401 (37.7418550307898, -122.411071545524)
23842 248194 2 177 216 Esmeralda Ave 13 17 1 1     12     6007325.73728 2098765.61768 37.7432247818956 -122.41730658752199 (37.7432247818956, -122.417306587522)
23934 248050 2 16 38 Rutledge St 7 17 1 1     5     6010496.13368 2099436.61391 37.7452450531093 -122.406391405264 (37.7452450531093, -122.406391405264)
24297 248119 2 86 108 Brewster St 9 17 1 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
24579 247929 2 103 1099 Esmeralda Ave 2 17 1 1     37     6010384.7561099995 2098766.60945 37.743399135274295 -122.40672932282301 (37.7433991352743, -122.406729322823)
24649 194268 2 113 900 Quint St 3 17 1 1     7 Width 3ft   6014100.1568599995 2097559.70841 37.7402924173605 -122.393797854205 (37.7402924173605, -122.393797854205)
24680 187543 2 3 1400 Somerset St 3 17 1 1     35     6011384.82868 2088240.1087599997 37.714551459646394 -122.402531250636 (37.7145514596464, -122.402531250636)
24856 248244 2 108 296 Esmeralda Ave 4 17 1 1     5     6006798.41265 2099004.72131 37.7438516246444 -122.41914689812799 (37.7438516246444, -122.419146898128)
25114 249640 2 237 2400 Lyon St 6 17 1 1     7     5999291.5931400005 2117167.12216 37.79329538582 -122.446409970041 (37.79329538582, -122.446409970041)
25256 238433 2 18 272 Corbett Ave 8 17 1 1     8 Width 3ft   5999629.6727599995 2105348.1757099996 37.7608628875441 -122.444390425487 (37.7608628875441, -122.444390425487)
25273 237871 2 16 200 Corbin Pl 3 17 1 1     4 Width 3ft   6000061.7105 2105723.34521 37.761917651093704 -122.44292314469 (37.7619176510937, -122.44292314469)
25440 237908 2 72 3911 21st St 4 17 1 1     18     6002345.78312 2103531.79558 37.7560301412935 -122.43486671293002 (37.7560301412935, -122.43486671293)
25566 214228 2 16 714 Detroit St 16 17 1 1     5     5999467.5472800005 2095443.9032 37.733658896535 -122.444239403229 (37.733658896535, -122.444239403229)
25663 188593 2 5 1 20th St 1 17 1 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
25720 196053 2 258 2399 Lane St 8 17 1 1     22     6013983.40604 2092884.07422 37.727447595718395 -122.393874328035 (37.7274475957184, -122.393874328035)
25721 190755 2 348 1999 Revere Ave 1 17 1 1     21     6012974.9721800005 2095942.04055 37.7357880468688 -122.397574892566 (37.7357880468688, -122.397574892566)
25897 134510 2 15 100 Fulton St 9 17 1 1     18 Width 4ft   6008017.687530001 2112101.62184 37.7798812789472 -122.415858138542 (37.7798812789472, -122.415858138542)
25968 249846 2 190 289 Greenwich St 3 17 1 1     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.40464628970601 (37.8028098362532, -122.404646289706)
25982 247919 2 103 1098 Esmeralda Ave 4 17 1 1     22     6010242.48982 2098715.3752200003 37.743250496220895 -122.40721763491001 (37.7432504962209, -122.40721763491)
26079 134508 2 15 100 Fulton St 7 17 1 1     17 Width 4ft   6008055.00417 2112104.50717 37.7798912991906 -122.41572924771499 (37.7798912991906, -122.415729247715)
26278 249950 2 70 303 Filbert St 5 17 1 1     9 Width 0ft   6011359.33086 2120056.95578 37.801912024192795 -122.404858102512 (37.8019120241928, -122.404858102512)
26288 247985 2 26 495 Peralta Ave 1 17 1 1     7     6009773.5395 2099699.6998799997 37.7459269802441 -122.40890858338001 (37.7459269802441, -122.40890858338)
26362 196123 2 16 2300 20th St 1 17 1 1     6 Width 4ft   6011242.42693 2104654.95461 37.7596151915071 -122.404178032517 (37.7596151915071, -122.404178032517)
26378 118551 2 1 8140 Geary Blvd 5 17 1 1     18     5981667.59483 2112398.2493 37.7791791285325 -122.50703522193999 (37.7791791285325, -122.50703522194)
26546 191706 2 190 1499 Rankin St 7 17 1 1     1 Width 3ft   6012685.03055 2096691.5436200001 37.7378298766422 -122.39862992054701 (37.7378298766422, -122.398629920547)
27269 250005 2 16 232 Filbert St 3 17 1 1     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735)
27802 206466 2 234 747 Detroit St 1 17 1 1     7     5999436.63595 2095454.0058900001 37.733684872551606 -122.444346998137 (37.7336848725516, -122.444346998137)
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)
27927 247528 2 180 1101 Waller St 9 17 1 1     2     6000060.08033 2108486.82414 37.7695053822964 -122.443127261125 (37.7695053822964, -122.443127261125)
28120 178856 2 72 121 Delta St 1 17 1 1     18     6009824.00265 2088991.8165400003 37.71652823335621 -122.407979098955 (37.7165282333562, -122.407979098955)
28127 191847 2 39 2101 Newcomb Ave 1 17 1 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
28161 249840 2 92 305 Greenwich St 3 17 1 1     5 Width 0ft   6011283.33525 2120383.34662 37.8028039654926 -122.405144080631 (37.8028039654926, -122.405144080631)
28786 214229 2 16 714 Detroit St 17 17 1 1     9     5999467.99685 2095449.76583 37.7336750195872 -122.444238270085 (37.7336750195872, -122.444238270085)
28898 250221 2 88 312 Filbert St 2 17 1 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
28950 132461 2 243 1109 Chestnut St 3 17 1 1     12     6006461.025 2120401.5247299997 37.8025831108771 -122.42183305885901 (37.8025831108771, -122.421833058859)
29143 248220 2 1 70 Fair Ave 1 17 1 1     18     6007112.652530001 2099342.90806 37.7447979012027 -122.41808429785499 (37.7447979012027, -122.418084297855)
29144 205629 2 146 714 Detroit St 18 17 1 1     5     5999458.60233 2095454.85434 37.7336884554611 -122.444271115125 (37.7336884554611, -122.444271115125)
29239 211277 2 3 232 Edna St 4 17 1 1     43     5998792.56249 2095483.7387400002 37.7337297433315 -122.44657587878599 (37.7337297433315, -122.446575878786)
29301 250202 2 3 203 Union St 3 17 1 1     12 Width 0ft   6011755.5651 2119757.15751 37.8011109908426 -122.403465834184 (37.8011109908426, -122.403465834184)
29447 206472 2 234 714 Detroit St 11 17 1 1     7     5999457.34155 2095426.0503099998 37.733609294436796 -122.444273404802 (37.7336092944368, -122.444273404802)
29484 190646 2 322 230 Middle Point Rd 4 17 1 1     8 Width 8ft   6018218.4425 2096359.44868 37.7372247426365 -122.379474956329 (37.7372247426365, -122.379474956329)
29637 247866 2 141 398 Mayflower St 1 17 1 1     24     6009543.35492 2098406.93767 37.7423644418716 -122.40961330563101 (37.7423644418716, -122.409613305631)
29648 196372 2 84 1700 Armstrong Ave 7 17 1 1     1     6013890.9677099995 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931)
29739 187574 2 58 72 Bishop St 1 17 1 1     10     6010842.8913900005 2089488.5588 37.71794917929 -122.404492242147 (37.71794917929, -122.404492242147)
29793 247852 2 36 80 Bradford St 1 17 1 1     27     6009577.25002 2098193.0016099997 37.741778919360705 -122.409481010838 (37.7417789193607, -122.409481010838)
29820 187571 2 58 73 Bishop St 2 17 1 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
30032 247924 2 103 1098 Esmeralda Ave 9 17 1 1     23     6010297.695230001 2098727.78354 37.7432876562154 -122.40702762254499 (37.7432876562154, -122.407027622545)
30048 132396 2 110 2836 Larkin St 2 17 1 1     40     6006504.32212 2120945.10898 37.804078096188704 -122.421721861273 (37.8040780961887, -122.421721861273)
30197 196336 2 353 1750 22nd St 6 17 1 1     9     6012821.16046 2103795.98592 37.757344738798 -122.398657667323 (37.757344738798, -122.398657667323)
30408 248049 2 16 38 Rutledge St 6 17 1 1     8     6010499.7614 2099438.0486 37.7452491953942 -122.40637896223 (37.7452491953942, -122.40637896223)
30472 247853 2 36 80 Bradford St 2 17 1 1     25     6009574.28658 2098178.5899099996 37.7417391819242 -122.40949024059401 (37.7417391819242, -122.409490240594)
30481 247913 2 1 399 Franconia St 4 17 1 1     4     6009968.0552900005 2098803.93583 37.743478301698296 -122.40817280665001 (37.7434783016983, -122.40817280665)
30657 220393 2 175 20 Deming St 1 17 1 1     5 Width 3ft   5999466.4358 2105239.81948 37.7605560532329 -122.44494719845801 (37.7605560532329, -122.444947198458)
30719 249951 2 137 303 Filbert St 4 17 1 1     15 Width 0ft   6011370.2265099995 2120056.34585 37.8019109584873 -122.40482035527799 (37.8019109584873, -122.404820355278)
30768 223720 2 47 10 Crescent Ave 3 17 1 1     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196)
30996 247856 2 141 80 Bradford St 5 17 1 1     32     6009566.847130001 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008)
31185 247857 2 141 80 Bradford St 6 17 1 1     8     6009575.64001 2098128.64759 37.7416021270253 -122.409482036966 (37.7416021270253, -122.409482036966)
31230 187779 2 5 230 Middle Point Rd 2 17 1 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
31259 201730 2 3 1411 Phelps St 5 17 1 1     20     6013762.45417 2095926.0507 37.7357879596321 -122.39485111951001 (37.7357879596321, -122.39485111951)
31284 247949 2 180 7 Joy St 2 17 1 1     11     6010404.2439 2098872.53529 37.7436910749942 -122.406669401896 (37.7436910749942, -122.406669401896)
Powered by Datasette · Query took 2.597ms · Data source: data.sfgov.org