sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
41498 214201 2 25 145 Maywood Dr 2 1 1 1     11 Width 2ft   5994272.70142 2095629.8656 37.733871759758394 -122.462212852568 (37.7338717597584, -122.462212852568)
41692 107848 2 25 407 09th St 9 1 1 1     7 3x3   6009766.34192 2109306.87193 37.7723057020722 -122.40961143144101 (37.7723057020722, -122.409611431441)
42737 239675 2 25 689 Dolores St 1 2 1 1     25 Width 9ft   6005030.3991 2104342.90235 37.7584093076526 -122.425640136401 (37.7584093076526, -122.425640136401)
42807 43677 1 25 656 02nd Ave 1 1 1 1 1 07/25/2000 12:00:00 AM 8   Permit Number 43320 5995359.11762 2111077.33678 37.776349084718596 -122.45957524379101 (37.7763490847186, -122.459575243791)
42864 197567 2 25 100 15th St 8 1 1 1     16 Width 5ft   6011782.82118 2107497.01248 37.767449026680495 -122.402508917767 (37.7674490266805, -122.402508917767)
42873 46597 1 25 170St. 09th Ave 1 1 1 1 1 11/13/2004 12:00:00 AM 11   Permit Number 44725 5993070.73118 2114361.72785 37.7852352793736 -122.46773026674101 (37.7852352793736, -122.467730266741)
42918 138403 2 25 1850 PIERCE ST 6 1 1 1     9 Width 0ft   6002027.5911 2114900.905 37.7872288234819 -122.436780945176 (37.7872288234819, -122.436780945176)
43291 197532 2 25 651 Missouri St 8 9 1 1     7     6013605.01625 2103874.9640900004 37.757605236406995 -122.39595229975299 (37.757605236407, -122.395952299753)
43292 113589 2 25 370 Drumm St 1 1 1 1     11 3x3   6013618.317290001 2118086.59987 37.796627904610204 -122.39690267003799 (37.7966279046102, -122.396902670038)
43437 197539 2 25 33 Guy Pl 2 1 1 1     6 Width 2ft   6014318.065 2114410.62146 37.7865734481466 -122.394223875652 (37.7865734481466, -122.394223875652)
43559 31153 1 25 45 Staples Ave 1 1 1 1 1 03/21/1995 12:00:00 AM 10   Permit Number 34856 5999668.77928 2093756.1386900002 37.729036168077705 -122.443422496853 (37.7290361680777, -122.443422496853)
44138 239690 2 25 1521 Sanchez St 1 1 1 1     16 Width 3ft   6003983.46456 2099388.15936 37.744745530090796 -122.428907662057 (37.7447455300908, -122.428907662057)
44139 200675 2 25 1535 Newcomb Ave 5 1 1 1     13 Width 0ft   6015661.7831 2095333.6223 37.7342666958117 -122.388243005014 (37.7342666958117, -122.388243005014)
44389 59288 1 25 2067 Greenwich St 1 1 1 1   08/20/1980 12:00:00 AM 17   Permit Number 18625 6003010.51633 2119230.45541 37.7991724689015 -122.433689789967 (37.7991724689015, -122.433689789967)
44413 200830 2 25 1550 16th St 2 1 1 1     10 Width 0ft   6011811.2987 2107032.5363 37.766175269536205 -122.402377754798 (37.7661752695362, -122.402377754798)
44525 21850 3 25 199X Cabrillo St 2 1 1 2     10 3X3   5995144.904080001 2110755.8457 37.775454035467796 -122.46029296446699 (37.7754540354678, -122.460292964467)
44607 197563 2 25 100 15th St 4 1 1 1     13 Width 5ft   6011871.68658 2107504.14213 37.767473563784996 -122.40220204389799 (37.767473563785, -122.402202043898)
44660 140664 2 25 536 Stanyan St 1 1 1 1     11 Width 0ft   5996926.8557 2109499.2642 37.7721061302796 -122.4540380318 (37.7721061302796, -122.4540380318)
44932 179450 2 25 49 Brookdale Ave 5 9 1 1     13 Width 6ft   6006580.779159999 2087379.51909 37.7119190900695 -122.41907501532499 (37.7119190900695, -122.419075015325)
45066 70152 2 25 231 08th Ave 1 1 1 1 1 06/12/1993 12:00:00 AM 7     5993349.447480001 2113931.04039 37.78406881848979 -122.46673468365299 (37.7840688184898, -122.466734683653)
45132 179472 2 25 416 Vienna St 1 1 1 1     15 Width 4ft   6003621.62429 2091003.33187 37.7217022030671 -122.42956096376999 (37.7217022030671, -122.42956096377)
45178 239695 2 25 49 Jersey St 2 1 1 1     13 Width 4ft   6004807.135419999 2101616.24717 37.7509099321629 -122.426218161243 (37.7509099321629, -122.426218161243)
45376 32233 1 25 1588 Treat Ave 1 1 1 1 1 08/22/1995 12:00:00 AM 16   Permit Number 35549 6008740.58515 2099494.1022900003 37.7453045396752 -122.412465880499 (37.7453045396752, -122.412465880499)
45696 40608 1 25 2756 Golden Gate Ave 2 1 1 1   07/16/1999 12:00:00 AM 12   Permit Number 41618 5996415.12538 2111289.35266 37.7769918898751 -122.45593757087 (37.7769918898751, -122.45593757087)
45807 240555 2 25 133 Vicksburg St 1 1 1 1     12 Width 5ft   6004136.97088 2102299.45232 37.752747951271 -122.428584348611 (37.752747951271, -122.428584348611)
45870 214171 2 25 1337 06th Ave 1 1 1 1     11 Width 2ft   5994229.270690001 2106420.5092700003 37.7634976322383 -122.46314569683001 (37.7634976322383, -122.46314569683)
46150 239714 2 25 872 Duncan St 1 1 1 1     8 Width 3ft   6000978.62192 2099691.67862 37.745408384388 -122.43931955855 (37.745408384388, -122.43931955855)
46348 197519 2 25 1055 Natoma St 2 4 1 1     7 Width 3ft   6007591.229180001 2109427.92338 37.772515957284206 -122.417143942455 (37.7725159572842, -122.417143942455)
46358 179434 2 25 122 Santos St 4 9 1 1     15 Width 6ft   6006514.55403 2086760.1932299999 37.710214821715496 -122.419260003144 (37.7102148217155, -122.419260003144)
46443 200679 2 25 1535 Newcomb Ave 9 1 1 1     19 Width 0ft   6015689.2638 2095313.8362 37.7342138898064 -122.388146614226 (37.7342138898064, -122.388146614226)
46462 200672 2 25 1535 Newcomb Ave 2 1 1 1     14 Width 0ft   6015595.8297 2095380.8889 37.734392825730794 -122.388474327143 (37.7343928257308, -122.388474327143)
46825 179482 2 25 0 Serrano Dr 3 2 1 1     10     5988878.80429 2090370.98469 37.719120158641296 -122.48047615337 (37.7191201586413, -122.48047615337)
47230 240537 2 25 21 28th St 1 1 1 1     5 Width 3ft   6005750.77925 2099620.18871 37.7454825047108 -122.422813105861 (37.7454825047108, -122.422813105861)
47246 64355 1 25 230 04th St 1 1 1 1   04/21/1988 12:00:00 AM 8   Permit Number 770960 6011932.302 2113111.4722700003 37.782873389928795 -122.40238669808399 (37.7828733899288, -122.402386698084)
47632 62229 1 25 107 Capistrano Ave 1 1 1 1 1 09/30/1985 12:00:00 AM 9   Permit Number 22354 6001481.45016 2093645.47099 37.728835505929396 -122.43714804475701 (37.7288355059294, -122.437148044757)
48114 240565 2 25 131 Caselli Ave 1 1 1 1     15 Width 3ft   6000404.48259 2104877.48466 37.7596146626978 -122.441676928051 (37.7596146626978, -122.441676928051)
48286 215017 2 25 832 Detroit St 1 1 1 1     9 Width 3ft   5999463.89862 2095685.88724 37.734323119609606 -122.44426940102801 (37.7343231196096, -122.444269401028)
48306 179432 2 25 122 Santos St 2 9 1 1     12 Width 6ft   6006549.425009999 2086808.7283400001 37.7103500527955 -122.419142922204 (37.7103500527955, -122.419142922204)
48654 124458 2 25 41 Willard St North 3 1 1 1     14 Width 4ft   5996118.46825 2111510.19918 37.7775812452699 -122.45697977108601 (37.7775812452699, -122.456979771086)
48668 179445 2 25 50 Santos St 2 9 1 1     10 Width 6ft   6006641.641 2087043.6428599998 37.7110002716098 -122.418840853438 (37.7110002716098, -122.418840853438)
48810 183900 2 25 2101 22nd Ave 3 1 1 1     8 Width 0ft   5989432.8197 2100761.3499 37.7476816186189 -122.479320872687 (37.7476816186189, -122.479320872687)
48874 215006 2 25 1315 03rd Ave 1 1 1 1     14 Width 4ft   5995155.473540001 2106606.4972900003 37.764061618685005 -122.45995575296101 (37.764061618685, -122.459955752961)
48880 197526 2 25 301 Utah St 3 1 1 1     13 Width 4ft   6010646.79925 2106595.9922 37.764911543656794 -122.40637478936002 (37.7649115436568, -122.40637478936)
49033 118221 2 25 699 37th Ave 5 1 1 1     8 Width 3ft   5984455.23409 2111482.2118900004 37.776827734448105 -122.49732413820101 (37.7768277344481, -122.497324138201)
49154 118227 2 25 699 37th Ave 11 1 1 1     2 Width 3ft   5984452.03524 2111621.56677 37.77721017528479 -122.497345493843 (37.7772101752848, -122.497345493843)
49441 239733 2 25 2002 Castro St 8 1 1 1     12 Width 3ft   6002632.00291 2099712.5863900003 37.745559743 -122.433603933486 (37.745559743, -122.433603933486)
49719 136405 2 25 897 Green St 3 10 1 1     8 Width 3ft   6008967.16736 2119019.94772 37.7989306555735 -122.413062774033 (37.7989306555735, -122.413062774033)
49766 214997 2 25 324 Holloway Ave 1 1 1 1     15 Width 4ft   5995789.64183 2091235.7059799999 37.721893680423 -122.45665069048799 (37.721893680423, -122.456650690488)
49879 200844 2 25 1919 16th St 4 1 1 1     8 Width 0ft   6010817.914 2106923.6397 37.7658207601783 -122.40580602510201 (37.7658207601783, -122.405806025102)
50273 179467 2 25 291 France Ave 4 1 1 1     6 Width 2ft   6001663.653519999 2090093.9083 37.7190940729046 -122.436264090339 (37.7190940729046, -122.436264090339)
50278 240579 2 25 3560 21st St 1 1 1 1     15 Width 3ft   6004617.41249 2103694.30226 37.756605059890006 -122.42702223251601 (37.75660505989, -122.427022232516)
50574 240562 2 25 3818 18th St 1 1 1 1     13 Width 3ft   6004117.0123 2105424.98126 37.761328784908 -122.428876176805 (37.761328784908, -122.428876176805)
50694 118217 2 25 699 37th Ave 1 1 1 1     4 Width 3ft   5984459.3393 2111410.10949 37.776630002637 -122.497304613296 (37.776630002637, -122.497304613296)
50722 240572 2 25 210 Collingwood St 2 1 1 1     19 Width 3ft   6002036.98136 2104624.07975 37.7590117527075 -122.436012807155 (37.7590117527075, -122.436012807155)
50851 200842 2 25 1919 16th St 2 1 1 1     5 Width 0ft   6010705.6887 2106916.0312 37.7657935922594 -122.40619365455 (37.7657935922594, -122.40619365455)
50939 200829 2 25 1550 16th St 1 1 1 1     5 Width 0ft   6011839.8305 2107032.5363 37.7661768622321 -122.402279068281 (37.7661768622321, -122.402279068281)
51097 47786 1 25 445 Francisco St 2 1 1 1   06/11/2002 12:00:00 AM 8   Permit Number 45558 6009129.7041 2121124.5774 37.804718567986704 -122.41264920318999 (37.8047185679867, -122.41264920319)
51181 136415 2 25 640 Davis St 7 1 1 1     3 Width 4ft   6013156.852000001 2118810.40691 37.7985896092893 -122.398550270302 (37.7985896092893, -122.398550270302)
51448 92261 3 25 4545 Anza St 9 1 1 2   07/23/2009 12:00:00 AM 12 3x3 Permit Number 52708 5984639.1399 2111735.34775 37.7775335493935 -122.49670664793301 (37.7775335493935, -122.496706647933)
51527 179437 2 25 121 Santos St 1 9 1 1     7 Width 6ft   6006551.53826 2086713.5575599999 37.71008885278471 -122.419128872099 (37.7100888527847, -122.419128872099)
51699 179433 2 25 122 Santos St 3 9 1 1     13 Width 6ft   6006535.42412 2086786.7518099998 37.7102889213719 -122.419189754426 (37.7102889213719, -122.419189754426)
51758 197569 2 25 801 Howard St 1 1 1 1     13 Width 3ft   6011744.637069999 2113111.42965 37.7828627950365 -122.403035941152 (37.7828627950365, -122.403035941152)
51841 179460 2 25 110 Italy Ave 2 1 1 1     11 Width 2ft   6000997.30077 2089688.71555 37.7179436214658 -122.43853839394698 (37.7179436214658, -122.438538393947)
51874 183899 2 25 2101 22nd Ave 2 1 1 1     9 Width 0ft   5989428.0919 2100803.1123 37.747796012582704 -122.479340275734 (37.7477960125827, -122.479340275734)
51882 179443 2 25 20 Santos St 2 9 1 1     11 Width 6ft   6006639.5983 2087274.4168099998 37.711633813430204 -122.418864269997 (37.7116338134302, -122.418864269997)
52120 118224 2 25 699 37th Ave 8 1 1 1     4 Width 3ft   5984451.82255 2111562.02768 37.7770466856492 -122.49734183318701 (37.7770466856492, -122.497341833187)
52151 239712 2 25 88 Santa Marina St 2 1 1 1     10 Width 3ft   6006164.570119999 2097549.79113 37.7398209981319 -122.421235287575 (37.7398209981319, -122.421235287575)
52358 43759 1 25 249 17th Ave 2 1 1 1   07/26/2000 12:00:00 AM 9   Permit Number 43395 5990535.981790001 2113705.55195 37.783286919680705 -122.476451677439 (37.7832869196807, -122.476451677439)
52385 239682 2 25 3685 24th St 1 1 1 1     15 Width 7ft   6005238.007069999 2101931.5191900004 37.751799940838204 -122.424750590868 (37.7517999408382, -122.424750590868)
52817 197564 2 25 100 15th St 5 1 1 1     13 Width 5ft   6011853.28866 2107502.0789900003 37.7674668719146 -122.402265535131 (37.7674668719146, -122.402265535131)
52898 47230 1 25 890 Girard St 1 1 1 1 1 07/28/2003 12:00:00 AM 6   Permit Number 46770 6011503.10296 2090822.5709799998 37.7216489793918 -122.40230391012 (37.7216489793918, -122.40230391012)
53158 197573 2 25 801 Howard St 5 1 1 1     12 Width 3ft   6011805.47785 2113169.35516 37.7830252422689 -122.402829531459 (37.7830252422689, -122.402829531459)
53204 240563 2 25 10 Hancock St 2 1 1 1     6 Width 3ft   6004179.51855 2105131.83325 37.7605274080343 -122.42863909661999 (37.7605274080343, -122.42863909662)
53232 123753 2 25 99 Cabrillo St 1 1 1 1     10 Width 4ft   5995463.5723 2110766.04178 37.7755003566036 -122.459191361341 (37.7755003566036, -122.459191361341)
53238 50628 1 25 1198 Gilman Ave 1 1 1 1   10/14/2004 12:00:00 AM     Permit Number 47728 6014541.97081926 2090297.22948146 37.720375661427205 -122.39176255443 (37.7203756614272, -122.39176255443)
53284 197543 2 25 101 Rhode Island St 1 1 1 1     24 Width 4ft   6011744.4821 2107062.59215 37.7662540659871 -122.40261097552799 (37.7662540659871, -122.402610975528)
53313 197550 2 25 101 Rhode Island St 8 1 1 1     17 Width 3ft   6011736.4606800005 2107238.9435 37.766737839213796 -122.402651123063 (37.7667378392138, -122.402651123063)
53981 118228 2 25 699 37th Ave 12 1 1 1     5 Width 3ft   5984449.813999999 2111641.4618599997 37.7772646712772 -122.49735464678001 (37.7772646712772, -122.49735464678)
54130 200066 2 25 1563 Shafter Ave 1 1 1 1     17 Width 0ft   6015094.0337 2094004.9347 37.730586913455205 -122.39011312209601 (37.7305869134552, -122.390113122096)
54299 118236 2 25 680 38th Ave 4 1 1 1     12 Width 5ft   5984154.15255 2111259.59719 37.7761988481286 -122.49834920754101 (37.7761988481286, -122.498349207541)
54306 240575 2 25 3971 20th St 1 1 1 1     6 Width 3ft   6003902.14198 2104194.35497 37.7579376141555 -122.429531555935 (37.7579376141555, -122.429531555935)
54514 200831 2 25 1550 16th St 3 1 1 1     15 Width 0ft   6011784.6689 2107029.6831 37.766165948693796 -122.40246966197901 (37.7661659486938, -122.402469661979)
54642 214183 2 25 347 Santa Ana Ave 2 1 1 1     17 Width 3ft   5992610.48002 2094547.7964400002 37.730804817991704 -122.467880927762 (37.7308048179917, -122.467880927762)
54669 179439 2 25 65 Blythdale Ave 4 9 1 1     10 Width 6ft   6006794.78813 2086912.99237 37.7106501547416 -122.418302281839 (37.7106501547416, -122.418302281839)
54777 114770 1 25 110 Frederick St 4 1 1 1       3x3   5999469.36873216 2107750.31436605 37.7674494126495 -122.445117544708 (37.7674494126495, -122.445117544708)
54855 179483 2 25 0 Serrano Dr 3 2 1 1     8     5988918.9165199995 2090347.02209 37.7190566943955 -122.48033574940399 (37.7190566943955, -122.480335749404)
54975 113592 2 25 370 Drumm St 4 1 1 1     13 3x3   6013608.47765 2118139.1354900002 37.7967716072789 -122.39694040288799 (37.7967716072789, -122.396940402888)
55322 239696 2 25 112 Parnassus Ave 1 1 1 1     22 Width 4ft   5997951.3916 2106835.98646 37.7648521416436 -122.450302081196 (37.7648521416436, -122.450302081196)
55379 179487 2 25 100 Capistrano Ave 5 1 1 1     15 Width 4ft   6001448.45649 2093575.59463 37.728641765884106 -122.437257104634 (37.7286417658841, -122.437257104634)
55609 136404 2 25 897 Green St 2 10 1 1     7 Width 3ft   6008943.49637 2119016.81507 37.7989207252599 -122.413144462145 (37.7989207252599, -122.413144462145)
55960 197531 2 25 2006 22nd St 1 2 1 1     12 Width 6ft   6012046.11634 2103763.76948 37.7572130681337 -122.40133582769501 (37.7572130681337, -122.401335827695)
56016 124457 2 25 41 Willard St North 2 1 1 1     6 Width 3ft   5996114.41784 2111533.6822599997 37.7776454910208 -122.456995481723 (37.7776454910208, -122.456995481723)
56147 179476 2 25 245 Wilson St 2 2 1 1     4     5994306.081069999 2086649.9682200002 37.7092170428021 -122.461446662549 (37.7092170428021, -122.461446662549)
56526 214173 2 25 2252 17th Ave 1 1 1 1     10 Width 3ft   5991053.76562 2100086.62004 37.7459229980593 -122.47366657496401 (37.7459229980593, -122.473666574964)
56796 215019 2 25 113 Stillings Ave 3 9 1 1     22 Width 10ft   6000031.68078 2095690.19732 37.7343673311927 -122.44230670979601 (37.7343673311927, -122.442306709796)
56840 248529 2 25 45 Beulah St 4 1 1 1     7 Width 0ft   5997709.9004 2107802.0064 37.7674907631986 -122.451207005854 (37.7674907631986, -122.451207005854)
56877 239719 2 25 4818 25th St 2 10 1 1     12 Width 10ft   5999936.15376 2101092.9328900003 37.7491965123129 -122.44302484724199 (37.7491965123129, -122.443024847242)
56961 117877 2 25 734 41st Ave 1 1 1 1     14 Width 3ft   5983242.29307 2110782.48705 37.774835329522794 -122.501468223794 (37.7748353295228, -122.501468223794)
57171 197523 2 25 1919 16th St 2 1 1 1     6 Width 3ft   6010718.525880001 2106914.57132 37.7657903018022 -122.40614915038799 (37.7657903018022, -122.406149150388)
57225 239741 2 25 1455 Noe St 3 1 1 1     12 Width 4ft   6003319.3931599995 2099769.2537700003 37.745754316715704 -122.43123108934401 (37.7457543167157, -122.431231089344)
57606 214196 2 25 185 Upland Dr 1 1 1 1     5 Width 3ft   5993973.13885 2093823.0159 37.7288933413334 -122.46311746621599 (37.7288933413334, -122.463117466216)
Powered by Datasette · Query took 2.914ms · Data source: data.sfgov.org