sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
58867 247173 2 30 141 Buena Vista Ave East 1 4 1 1     6 Width 4ft   6001348.76723 2108505.96887 37.7696313440465 -122.438671125768 (37.7696313440465, -122.438671125768)
58900 191352 2 30 1750 04th St 6 1 1 1     4 Width 5ft   6015101.55033 2107682.6315900004 37.768143412117894 -122.391042763138 (37.7681434121179, -122.391042763138)
59034 129459 2 30 458 Jackson St 1 1 1 1     13 Width 3ft   6011895.81451 2118092.21584 37.7965472956624 -122.402863344166 (37.7965472956624, -122.402863344166)
59171 207090 2 30 1400 Ulloa St 4 1 1 1     3 Width 3ft   5991605.432 2098443.60055 37.741443622419894 -122.47163929621 (37.7414436224199, -122.47163929621)
59281 54994 1 30 685 16th Ave 1 1 1 1   09/12/1972 12:00:00 AM 7   Permit Number 10872 5990951.59437 2110751.2702900004 37.77519937131321 -122.47479813592301 (37.7751993713132, -122.474798135923)
59332 200004 2 30 1450 Griffith St 6 1 1 1     2 Width 0ft   6017626.5562 2092285.3405 37.7260053809224 -122.38123820192101 (37.7260053809224, -122.381238201921)
59444 80749 1 30 375 Munich St 1 1 1 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52325 6004167.50654 2090267.3011900003 37.719712117607 -122.42762157938101 (37.719712117607, -122.427621579381)
59463 207089 2 30 1400 Ulloa St 3 1 1 1     2 Width 3ft   5991620.77866 2098444.2951599997 37.7414464175195 -122.471586283874 (37.7414464175195, -122.471586283874)
59498 227593 2 30 501 14th St 2 1 1 1     5 Width 2ft   6005330.86399 2107797.8602 37.7679127764864 -122.42484679046301 (37.7679127764864, -122.424846790463)
59549 105029 1 30 1550 04th St 4 1 1 1     4 6x6   6015077.74883 2108086.46133 37.769250919128 -122.391153321267 (37.769250919128, -122.391153321267)
59805 176969 2 30 134 Craut St 3 1 1 1     3 Width 3ft   6004020.786 2094067.71187 37.7301389032718 -122.428399470475 (37.7301389032718, -122.428399470475)
60052 207078 2 30 769 Joost Ave 2 1 1 1     3 Width 2ft   5997019.6459099995 2094987.9782900002 37.73226707514829 -122.452669575238 (37.7322670751483, -122.452669575238)
60304 191330 2 30 1108 04th St 1 1 1 1     2 Width 5ft   6014815.79386 2110104.2477700002 37.7747767728644 -122.392200554832 (37.7747767728644, -122.392200554832)
60379 191358 2 30 1780 04th St 4 1 1 1     3 Width 5ft   6015118.78707 2107382.7546599996 37.7673209722044 -122.390962181167 (37.7673209722044, -122.390962181167)
60646 191259 3 30 900x Carolina St 27 3 1 2     17     6012470.08805 2103421.28043 37.7562963136528 -122.39984551077299 (37.7562963136528, -122.399845510773)
60958 48733 1 30 1235 30th Ave 1 1 1 1   09/25/2002 12:00:00 AM 2   Permit Number 46013 5986739.234 2106838.4777 37.764210939174106 -122.489081723593 (37.7642109391741, -122.489081723593)
61026 191297 2 30 740 04th St 7 1 1 1     3 Width 2ft   6014617.26494 2110308.92783 37.7753277532976 -122.39290163570101 (37.7753277532976, -122.392901635701)
61686 105315 1 30 2101 Laguna St   1 1 1         Permit Number 770797 6004250.84301 2116191.67517 37.7908990545176 -122.429181041856 (37.7908990545176, -122.429181041856)
61696 4545 3 30 66 Cleary Ct 8 1 1 2     6 3X3   6004823.98553 2113713.43923 37.784126867550995 -122.427021407244 (37.784126867551, -122.427021407244)
61708 227660 2 30 195 Beacon St 1 9 1 1     8 Width 2ft   6003113.10037 2097586.0775 37.73974812787179 -122.43178856828101 (37.7397481278718, -122.431788568281)
62074 94211 1 30 465 Missouri St 6 1 1 1   06/22/2010 12:00:00 AM 3 3x3 Permit Number 53589 6013546.79092 2104912.40006 37.760450569952205 -122.39622637625799 (37.7604505699522, -122.396226376258)
62217 250619 2 30 114 28th Ave 1 2 1 1     4 Width 4ft   5987113.722030001 2115192.60557 37.7871708695801 -122.48840049988002 (37.7871708695801, -122.48840049988)
62276 200097 2 30 1528 Yosemite Ave 2 1 1 1     1 Width 0ft   6015067.4938 2092354.869 37.7260546913573 -122.390089647295 (37.7260546913573, -122.390089647295)
62411 176924 2 30 525 Edinburgh St 1 1 1 1     1 Width 3ft   6002840.55904 2090695.62 37.720813038882206 -122.43223893347799 (37.7208130388822, -122.432238933478)
62414 191272 2 30 659 04th St 3 1 1 1     6 Width 3ft   6014208.1321 2110827.64494 37.776729299941394 -122.394353258399 (37.7767292999414, -122.394353258399)
62582 207087 2 30 1400 Ulloa St 1 1 1 1     2 Width 3ft   5991668.56365 2098444.306 37.7414492117217 -122.471421062245 (37.7414492117217, -122.471421062245)
62772 185051 2 30 2715 41st Ave 1 9 1 1     3 Width 0ft   5983667.0512 2096660.9577 37.736086492552 -122.49895536756901 (37.736086492552, -122.498955367569)
62886 227610 2 30 400 Prospect Ave 6 9 1 1     25     6006250.04952 2097648.9456700003 37.7400980729811 -122.420946773391 (37.7400980729811, -122.420946773391)
62932 108753 2 30 200x Hester Ave 1 1 1 1     4 3x3   6012766.4768 2087726.3545799998 37.713217830719294 -122.397719670851 (37.7132178307193, -122.397719670851)
63792 64471 1 30 2332 Washington St 1 1 1 1   07/06/1988 12:00:00 AM 4   Permit Number 25341 6003518.39121 2116605.0137 37.7919924858215 -122.431744816269 (37.7919924858215, -122.431744816269)
63865 98154 1 30 466 15th Ave 2 1 1 1   05/09/2012 12:00:00 AM 1   Permit Number 768787 5991271.26635 2112266.2977400003 37.779377741026394 -122.473802878969 (37.7793777410264, -122.473802878969)
64265 129441 2 30 144 Cyril Magnin St 1 1 1 1     3 Width 4ft   6010109.81427 2114257.21673 37.7859174259901 -122.40877263106199 (37.7859174259901, -122.408772631062)
64273 176978 2 30 100 Winding Way 3 1 1 1     1 Width 5ft   6002453.716630001 2086834.19677 37.7101884805901 -122.433300348445 (37.7101884805901, -122.433300348445)
64313 200002 2 30 1450 Griffith St 4 1 1 1     1 Width 0ft   6017646.9261 2092314.6221 37.726086906985 -122.381169818775 (37.726086906985, -122.381169818775)
64332 227614 2 30 210 Holladay Ave 2 1 1 1     4 Width 3ft   6010810.25772 2099834.79777 37.746355946971605 -122.405333247626 (37.7463559469716, -122.405333247626)
64448 200105 2 30 1528 Yosemite Ave 10 1 1 1     1 Width 0ft   6014949.7328 2092444.2049 37.7262934578304 -122.39050298275801 (37.7262934578304, -122.390502982758)
64660 176932 2 30 56 Lois Ln 1 1 1 1     8 Width 2ft   6012552.9526 2087748.4178 37.7132665190974 -122.39845923552299 (37.7132665190974, -122.398459235523)
64750 129447 2 30 1190 Pine St 2 1 1 1     8 Width 3ft   6008246.65377 2115911.69756 37.7903556945065 -122.41533583927799 (37.7903556945065, -122.415335839278)
64760 191282 2 30 751 04th St 4 1 1 1     6 Width 2ft   6014441.41184 2110601.16162 37.77612039236389 -122.393530413818 (37.7761203923639, -122.393530413818)
64764 191274 2 30 659 04th St 5 1 1 1     6 Width 3ft   6014170.53603 2110866.45323 37.7768337688053 -122.394486033405 (37.7768337688053, -122.394486033405)
65391 129455 2 30 855 Chestnut St 4 9 1 1     5 Width 6ft   6007721.09596 2120576.41129 37.8031342846798 -122.41748497255199 (37.8031342846798, -122.417484972552)
65427 191281 2 30 751 04th St 3 1 1 1     6 Width 2ft   6014459.12873 2110582.79031 37.776070933269 -122.39346783987301 (37.776070933269, -122.393467839873)
65596 129426 2 30 2149 Broadway 2 10 1 1     3 Width 4ft   6003248.10705 2117506.03033 37.7944511216749 -122.432744393832 (37.7944511216749, -122.432744393832)
65837 124124 2 30 61 Stanyan Blvd 1 1 1 1     1 Width 2ft   5996360.44357 2112557.14678 37.7804697796635 -122.45621841836599 (37.7804697796635, -122.456218418366)
65976 129416 2 30 218 Presidio Ave 1 1 1 1     3 Width 3ft   5999044.58564 2115840.24858 37.789638031029206 -122.44716909230301 (37.7896380310292, -122.447169092303)
66250 31765 1 30 1850 Ulloa St 5 1 1 1   06/19/1995 12:00:00 AM 3   Permit Number 35249 5990223.0095 2098395.3195 37.7412309773369 -122.47641565864299 (37.7412309773369, -122.476415658643)
66258 101283 2 30 2001 Irving St 2 1 1 1     6 3x3   5989499.782000001 2106476.1919 37.7633769390525 -122.479507377657 (37.7633769390525, -122.479507377657)
66308 105031 1 30 1550 04th St 6 1 1 1     4 6x6   6015081.19497 2108038.83155 37.7691203294602 -122.391138071471 (37.7691203294602, -122.391138071471)
66851 191268 2 30 538 Delancey St 5 9 1 1     4     6015150.51675 2113731.33336 37.7847545135408 -122.391296270324 (37.7847545135408, -122.391296270324)
66909 129449 2 30 884 Union St 1 1 1 1     6 Width 3ft   6008727.37725 2119383.41122 37.799915172210206 -122.41391825502899 (37.7999151722102, -122.413918255029)
67146 105243 1 30 616 Cambridge St 1 1 1 1   01/07/2014 12:00:00 AM 2 3x3 Permit Number 770335 6007163.0512 2091665.3874599999 37.723719949895 -122.417366048922 (37.723719949895, -122.417366048922)
67199 207064 2 30 134 Taraval St 4 1 1 1     1 Width 3ft   5993028.0499599995 2099189.22218 37.743573114522206 -122.466774605159 (37.7435731145222, -122.466774605159)
67213 51275 1 30 744 18th Ave 1 1 1 1 1 08/18/2004 12:00:00 AM 3   Permit Number 47650 5990394.326 2110291.56377 37.7739048349937 -122.476692239116 (37.7739048349937, -122.476692239116)
67225 247478 2 30 309 Pierce St 1 1 1 1     6 Width 0ft   6002704.2967 2109689.8401 37.772958982719494 -122.43406704066099 (37.7729589827195, -122.434067040661)
67462 191307 2 30 601 04th St 10 1 1 1     4 Width 5ft   6015158.98774 2107685.52339 37.76815453943829 -122.390844293528 (37.7681545394383, -122.390844293528)
67551 191285 2 30 720 04th St 1 1 1 1     6 Width 2ft   6014337.49405 2110565.62241 37.776017035092 -122.39388740780001 (37.776017035092, -122.3938874078)
67555 89658 3 30 2849X Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989742.13076 2111923.12979 37.7783468130036 -122.479067633531 (37.7783468130036, -122.479067633531)
68001 191319 2 30 1505 04th St 7 1 1 1     4 Width 5ft   6015133.57873 2108141.42692 37.7694049406179 -122.390964049067 (37.7694049406179, -122.390964049067)
68229 101282 2 30 2001 Irving St 1 1 1 1     7 3x3   5989468.7375 2106475.7724 37.7633739839128 -122.479614718585 (37.7633739839128, -122.479614718585)
68569 191348 2 30 1750 04th St 2 1 1 1     3 Width 5ft   6015095.009190001 2107795.26302 37.7684523103469 -122.39107326184299 (37.7684523103469, -122.391073261843)
69047 227628 2 30 4222 22nd St 1 1 1 1     2 Width 4ft   6001065.76771 2102912.44614 37.754256799634796 -122.43924903191002 (37.7542567996348, -122.43924903191)
69112 187585 2 30 748 University St 1 7 1 1     19     6008708.47344 2090752.4419999998 37.7213000235466 -122.411959282496 (37.7213000235466, -122.411959282496)
69127 191321 2 30 1507 04th St 1 1 1 1     3 Width 5ft   6015124.1638400005 2108316.2837099996 37.769884536484206 -122.391008838006 (37.7698845364842, -122.391008838006)
69337 129433 2 30 2201 Clay St 5 1 1 1     2 Width 4ft   6004155.37388 2116318.23991 37.791241164293496 -122.429520390877 (37.7912411642935, -122.429520390877)
69501 227638 2 30 326 San Jose Ave 3 1 1 1     5 Width 5ft   6006175.20644 2101155.72627 37.7497226795546 -122.421454532416 (37.7497226795546, -122.421454532416)
69520 176931 2 30 68 Lois Ln 1 1 1 1     5 Width 2ft   6012597.15839 2087748.03583 37.713267932833794 -122.398306417307 (37.7132679328338, -122.398306417307)
69654 227617 2 30 115 Nevada St 1 1 1 1     10 Width 2ft   6009080.60999 2097991.13845 37.7411968070922 -122.411183978775 (37.7411968070922, -122.411183978775)
69772 207085 2 30 2091 10th Ave 1 1 1 1     3 Width 3ft   5993168.90781 2101284.1521799997 37.749333387335895 -122.466439786693 (37.7493333873359, -122.466439786693)
69926 227665 2 30 46 Gough St 3 1 1 1     3 Width 3ft   6006330.78292 2109566.87483 37.7728264958779 -122.421513830121 (37.7728264958779, -122.421513830121)
70045 191341 2 30 1450 04th St 6 1 1 1     3 Width 5ft   6015063.13507 2108364.25056 37.770012856238395 -122.391223290338 (37.7700128562384, -122.391223290338)
70158 98192 2 30 1020 Green St 1 1 1 1     15 3x3   6008091.62981 2118948.72517 37.7986859077751 -122.41608738562799 (37.7986859077751, -122.416087385628)
70505 227648 2 30 154 Danvers St 1 1 1 1     10 Width 3ft   5999992.54639 2104934.00184 37.7597463657249 -122.443105663906 (37.7597463657249, -122.443105663906)
70657 129393 2 30 3700 Sacramento St 1 1 1 1     17 Width 4ft   5997126.155040001 2115061.06795 37.7873888086001 -122.45375034092 (37.7873888086001, -122.45375034092)
70706 105027 1 30 1550 04th St 2 1 1 1     3 6x6   6015075.4785400005 2108137.72551 37.7693915533068 -122.391164757946 (37.7693915533068, -122.391164757946)
70774 31727 1 30 2460 20th Ave 2 1 1 1 1 07/27/2011 12:00:00 AM 1 3x3 Permit Number 767614 5990175.918 2098661.7302 37.7419597410001 -122.476597940821 (37.7419597410001, -122.476597940821)
70808 176942 2 30 19 Lois Ln 2 1 1 1     7 Width 2ft   6012304.7570400005 2087878.1106900002 37.713608800166504 -122.39932618916299 (37.7136088001665, -122.399326189163)
70856 122542 2 30 2233 Post St 2 1 1 1     3 3x3   6001449.1657 2113870.4558 37.784366584009206 -122.43870830313499 (37.7843665840092, -122.438708303135)
71134 187130 2 30 2600 Sunset Blvd 66 9 1 1     1 Width 0ft   5985156.874 2097417.7557 37.73825173359629 -122.49386027578899 (37.7382517335963, -122.493860275789)
71525 97676 1 30 2562 Green St 2 1 1 1     5     6000785.23545 2117926.05562 37.7954644138979 -122.441296359259 (37.7954644138979, -122.441296359259)
71641 191357 2 30 1780 04th St 3 1 1 1     3 Width 5ft   6015116.28501 2107414.99409 37.767409355789 -122.390973089032 (37.767409355789, -122.390973089032)
71664 227629 2 30 62 Natick St 1 1 1 1     2 Width 3ft   6003056.07384 2095532.6693400003 37.7341067067448 -122.431839162348 (37.7341067067448, -122.431839162348)
71788 191354 2 30 1750 04th St 8 1 1 1     4 Width 5ft   6015105.755890001 2107627.1199 37.7679912225533 -122.39102433602899 (37.7679912225533, -122.391024336029)
71984 191276 2 30 659 04th St 7 1 1 1     6 Width 3ft   6014137.59227 2110902.38763 37.776930605110394 -122.394602513603 (37.7769306051104, -122.394602513603)
72025 191277 2 30 659 04th St 8 1 1 1     7 Width 3ft   6014120.49796 2110919.7593900003 37.7769773536703 -122.394662865301 (37.7769773536703, -122.394662865301)
72449 227655 2 30 2 Belcher St 1 1 1 1     8 Width 3ft   6003762.03013 2108315.13286 37.769244345078704 -122.430310116133 (37.7692443450787, -122.430310116133)
72581 89663 3 30 2827 Anza St 1 1 1 2   03/19/2008 12:00:00 AM 3 3x3   5989854.97314 2111927.2213 37.7783645996222 -122.47867757338301 (37.7783645996222, -122.478677573383)
73208 49756 1 30 1171 Goettingen St 1 1 1 1 1 06/04/2003 12:00:00 AM 1   Permit Number 46552 6011373.3818 2089351.75942 37.71760318852571 -122.40264894398899 (37.7176031885257, -122.402648943989)
73474 191349 2 30 1750 04th St 3 1 1 1     3 Width 5ft   6015096.10016 2107767.4364 37.7683759650927 -122.39106754304899 (37.7683759650927, -122.391067543049)
73709 191332 2 30 1108 04th St 3 1 1 1     4 Width 5ft   6014847.27565 2110066.45331 37.774674745668996 -122.392089008326 (37.774674745669, -122.392089008326)
73740 200018 2 30 1008 Revere Ave 1 1 1 1     1 Width 0ft   6018250.1161 2092086.6599 37.7254942451327 -122.37906877917801 (37.7254942451327, -122.379068779178)
74170 129446 2 30 1329 Washington St 1 1 1 1     14 Width 3ft   6008344.2402 2117236.00141 37.7939973921104 -122.415091973713 (37.7939973921104, -122.415091973713)
74191 191290 2 30 720 04th St 6 1 1 1     6 Width 2ft   6014418.027919999 2110488.47672 37.7758096856109 -122.393603417186 (37.7758096856109, -122.393603417186)
74356 186817 2 30 1200 Sunset Blvd 110 9 1 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
74636 227650 2 30 154 Danvers St 3 1 1 1     12 Width 3ft   6000006.33119 2104908.8667200003 37.759678136855996 -122.443056184107 (37.759678136856, -122.443056184107)
74708 129392 2 30 31 Casa Way 1 1 1 1     3 Width 3ft   6001624.74168 2121508.73342 37.80534928880979 -122.438648369353 (37.8053492888098, -122.438648369353)
74868 121865 2 30 574 18th Ave 2 1 1 1     3 Width 3ft   5990352.3789099995 2111462.4285 37.7771172745488 -122.476922909403 (37.7771172745488, -122.476922909403)
75243 129405 2 30 3545 Scott St 1 1 1 1     5 Width 3ft   6000706.97602 2120551.39476 37.8026684412687 -122.44175565829399 (37.8026684412687, -122.441755658294)
75435 176937 2 30 18 Lois Ln 1 1 1 1     5 Width 2ft   6012312.20962 2087899.37244 37.7136675960583 -122.399301921852 (37.7136675960583, -122.399301921852)
75466 129435 2 30 2201 Clay St 7 1 1 1     4 Width 4ft   6004184.0136 2116319.13373 37.7912452400168 -122.429421362005 (37.7912452400168, -122.429421362005)
75814 191355 2 30 1780 04th St 1 1 1 1     5 Width 5ft   6015114.26665 2107471.16871 37.7675634870034 -122.39098399692699 (37.7675634870034, -122.390983996927)
75888 191302 2 30 601 04th St 5 1 1 1     4 Width 5ft   6015174.0673 2107416.87345 37.767417722189705 -122.390773357708 (37.7674177221897, -122.390773357708)
Powered by Datasette · Query took 2.674ms · Data source: data.sfgov.org