sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
158901 51084 1 1 1358 47th Ave 1 1 1 1   07/22/2004 12:00:00 AM 5   Permit Number 47542 5981543.7588 2105841.1993 37.7611680849155 -122.50697708881701 (37.7611680849155, -122.506977088817)
171017 62031 1 1 136 Blake St 1 1 1 1   06/13/1985 12:00:00 AM 10   Permit Number 22104 5997893.5089 2112867.4203 37.7814095924872 -122.45093722878 (37.7814095924872, -122.45093722878)
37875 248551 2 1 136 Frederick St 4 1 1 1     19 Width 0ft   5999146.8244 2107700.2558 37.767293549242396 -122.446229576322 (37.7672935492424, -122.446229576322)
51891 248548 2 1 136 Frederick St 1 1 1 1     28 Width 0ft   5999227.0741 2107711.1577 37.7673280658329 -122.445952789289 (37.7673280658329, -122.445952789289)
62652 248550 2 1 136 Frederick St 3 1 1 1     17 Width 0ft   5999176.8044 2107705.1011 37.767308565322 -122.446126228732 (37.767308565322, -122.446126228732)
175257 248549 2 1 136 Frederick St 2 1 1 1     23 Width 0ft   5999200.4251 2107707.5237 37.7673165660452 -122.446044702662 (37.7673165660452, -122.446044702662)
73390 181687 2 1 1364 45th Ave 1 1 1 1     15 Width 0ft   5982164.3610000005 2105821.0447 37.7611492752094 -122.504829234381 (37.7611492752094, -122.504829234381)
46816 232301 2 1 137 Alma St 1 1 1 1     13 Width 4ft   5997988.61805 2106186.55691 37.7630711026695 -122.450126511942 (37.7630711026695, -122.450126511942)
79226 55388 1 1 1377 09th Ave 1 1 1 1   11/01/1972 12:00:00 AM   3x3 Permit Number 11325 5993310.46042535 2106120.10977525 37.762619842052494 -122.466301708727 (37.7626198420525, -122.466301708727)
10811 823 3 1 1381 46th Ave 1 1 1 2     20 3X3   5981813.5224 2105689.4462 37.760767297588295 -122.50603285620599 (37.7607672975883, -122.506032856206)
118169 181691 2 1 1388 45th Ave 1 1 1 1     3 Width 0ft   5982169.1175 2105676.9231 37.760753838231395 -122.504802104494 (37.7607538382314, -122.504802104494)
10779 831 3 1 1388 47th Ave 1 1 1 2     14 5.5x6.5   5981551.002 2105650.5805 37.7606451268888 -122.506937898142 (37.7606451268888, -122.506937898142)
146734 139429 2 1 1391 Baker St 6 1 1 1     8 Width 0ft   6000193.6053 2113611.7266 37.7835846728808 -122.443033505103 (37.7835846728808, -122.443033505103)
127395 20582 3 1 1392X Sunset Blvd 20 1 1 2     12 60   5984737.8310875995 2105717.624989 37.7610163726955 -122.49592120853 (37.7610163726955, -122.49592120853)
71292 139428 2 1 1393 Baker St 5 1 1 1     8 Width 0ft   6000190.7404 2113626.0515 37.783623842014606 -122.44304444562401 (37.7836238420146, -122.443044445624)
12649 24533 3 1 1395 47th Ave 2 1 1 2     25 3X3   5981505.7764 2105644.9273 37.7606269413357 -122.507093890918 (37.7606269413357, -122.507093890918)
70893 139426 2 1 1395 Baker St 3 1 1 1     8 Width 0ft   6000188.3529 2113650.8814 37.783691882385604 -122.443054489221 (37.7836918823856, -122.443054489221)
72725 139427 2 1 1395 Baker St 4 1 1 1     8 Width 0ft   6000190.7404 2113640.3765 37.783663174767796 -122.44304547473 (37.7836631747678, -122.44304547473)
30081 139425 2 1 1397 Baker St 2 1 1 1     8 Width 0ft   6000185.9654 2113663.7739 37.783727145735796 -122.443063675246 (37.7837271457358, -122.443063675246)
146778 139424 2 1 1399 Baker St 1 1 1 1     9 Width 0ft   6000185.4879 2113675.2338 37.7837585844376 -122.44306615049801 (37.7837585844376, -122.443066150498)
24757 210558 2 1 140 Hernandez Ave 1 9 1 1     27 Width 3ft   5995578.737319999 2099631.293 37.7449338085654 -122.457986999419 (37.7449338085654, -122.457986999419)
150167 210559 2 1 140 Hernandez Ave 2 9 1 1     24 Width 3ft   5995558.80371 2099639.21584 37.744954417407705 -122.45805649901699 (37.7449544174077, -122.458056499017)
144084 833 3 1 1400 47th Ave 1 1 1 2     14 3X3   5981556.8759975 2105533.8452968 37.760324951376504 -122.50690892383801 (37.7603249513765, -122.506908923838)
13014 24510 3 1 1400 48th Ave 1 1 1 2     15 3X3   5981246.2202 2105482.1578 37.7601647328681 -122.507979481979 (37.7601647328681, -122.507979481979)
23747 186497 2 1 1400 Lower Great Hwy 17 19 1 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
27012 186514 2 1 1400 Lower Great Hwy 15 19 1 1     4 Width 0ft   5980897.7615 2105153.3803 37.759241466452295 -122.509160198369 (37.7592414664523, -122.509160198369)
30380 186493 2 1 1400 Lower Great Hwy 23 19 1 1     2 Width 0ft   5980884.8182 2105286.9549 37.7596074608269 -122.509214881201 (37.7596074608269, -122.509214881201)
46197 186496 2 1 1400 Lower Great Hwy 16 19 1 1     2 Width 0ft   5980891.5487 2105237.2527 37.7594713896823 -122.509187913256 (37.7594713896823, -122.509187913256)
47007 186501 2 1 1400 Lower Great Hwy 29 19 1 1     3 Width 0ft   5980893.6197 2105317.501 37.7596918505514 -122.50918671014799 (37.7596918505514, -122.509186710148)
49038 186494 2 1 1400 Lower Great Hwy 19 19 1 1     2 Width 0ft   5980884.3005 2105262.6215 37.7595406177816 -122.50921486458799 (37.7595406177816, -122.509214864588)
49295 186515 2 1 1400 Lower Great Hwy 1 19 1 1     3 Width 0ft   5980905.2686 2104984.8589 37.7587791976552 -122.509121721574 (37.7587791976552, -122.509121721574)
49608 186504 2 1 1400 Lower Great Hwy 32 19 1 1     4 Width 0ft   5980883.7828 2105343.3876 37.7597623477539 -122.50922265288601 (37.7597623477539, -122.509222652886)
51431 186843 2 1 1400 Lower Great Hwy 33 19 1 1     7 Width 0ft   5980882.2296 2105351.6713 37.759785000838704 -122.509228639712 (37.7597850008387, -122.509228639712)
52894 186485 2 1 1400 Lower Great Hwy 25 19 1 1     9 Width 0ft   5980894.6551 2105298.8627 37.7596407361809 -122.50918174518299 (37.7596407361809, -122.509181745183)
58408 186491 2 1 1400 Lower Great Hwy 21 19 1 1     8 Width 0ft   5980895.1728 2105273.4939 37.759571111269004 -122.509178070846 (37.759571111269, -122.509178070846)
58818 186492 2 1 1400 Lower Great Hwy 22 19 1 1     2 Width 0ft   5980885.336 2105278.6712 37.759584746696 -122.509212475259 (37.759584746696, -122.509212475259)
61319 186489 2 1 1400 Lower Great Hwy 35 19 1 1     4 Width 0ft   5980878.6055 2105387.9124 37.759884294807 -122.509243864844 (37.759884294807, -122.509243864844)
63349 186499 2 1 1400 Lower Great Hwy 27 19 1 1     1 Width 0ft   5980882.7473 2105311.2882 37.7596741509783 -122.50922385032601 (37.7596741509783, -122.509223850326)
65556 186486 2 1 1400 Lower Great Hwy 26 19 1 1     2 Width 0ft   5980884.8182 2105306.6287 37.759661479426796 -122.509216342217 (37.7596614794268, -122.509216342217)
69350 186498 2 1 1400 Lower Great Hwy 18 19 1 1     2 Width 0ft   5980888.4423 2105252.2669 37.7595124312164 -122.5091997715 (37.7595124312164, -122.5091997715)
70661 186503 2 1 1400 Lower Great Hwy 31 19 1 1     4 Width 0ft   5980885.336 2105334.0684 37.759736851483396 -122.50921658916701 (37.7597368514834, -122.509216589167)
129570 186495 2 1 1400 Lower Great Hwy 20 19 1 1     3 Width 0ft   5980891.5487 2105262.6215 37.7595410451172 -122.509189797166 (37.7595410451172, -122.509189797166)
131767 186507 2 1 1400 Lower Great Hwy 8 19 1 1     5 Width 0ft   5980898.797 2105106.7845 37.759113588816 -122.509153157003 (37.759113588816, -122.509153157003)
147843 186500 2 1 1400 Lower Great Hwy 28 19 1 1     2 Width 0ft   5980882.7473 2105316.9833 37.7596897880858 -122.509224273257 (37.7596897880858, -122.509224273257)
150810 186483 2 1 1400 Lower Great Hwy 38 19 1 1     5 Width 0ft   5980878.6055 2105409.1394 37.7599425780444 -122.509245441233 (37.7599425780444, -122.509245441233)
157531 186484 2 1 1400 Lower Great Hwy 24 19 1 1     2 Width 0ft   5980883.7828 2105293.6854 37.7596258798004 -122.50921896188801 (37.7596258798004, -122.509218961888)
167996 186482 2 1 1400 Lower Great Hwy 37 19 1 1     3 Width 0ft   5980889.9955 2105407.5862 37.7599389849374 -122.50920593411199 (37.7599389849374, -122.509205934112)
174165 186511 2 1 1400 Lower Great Hwy 12 19 1 1     5 Width 0ft   5980895.6906 2105140.9548 37.7592072275053 -122.509166437696 (37.7592072275053, -122.509166437696)
178803 186506 2 1 1400 Lower Great Hwy 6 19 1 1     1 Width 0ft   5980906.3041 2105016.4405 37.7588659727132 -122.50912048557801 (37.7588659727132, -122.509120485578)
181911 186516 2 1 1400 Lower Great Hwy 2 19 1 1     3 Width 0ft   5980905.2686 2104991.5894 37.758797677676704 -122.509122221366 (37.7587976776767, -122.509122221366)
182255 186502 2 1 1400 Lower Great Hwy 30 19 1 1     5 Width 0ft   5980892.5842 2105334.0684 37.7597372788194 -122.509191521679 (37.7597372788194, -122.509191521679)
160469 232372 2 1 1400 Masonic Ave 1 1 1 1     20 Width 3ft   5999600.40255 2107689.23069 37.7672891703849 -122.44465992710899 (37.7672891703849, -122.444659927109)
53960 232354 2 1 1401 Noe St 2 2 1 1     25 Width 6ft   6003303.21337 2100010.18921 37.746414952387 -122.431304232109 (37.746414952387, -122.431304232109)
54731 232355 2 1 1401 Noe St 3 2 1 1     22 Width 6ft   6003303.86784 2100027.43262 37.746462335861295 -122.43130319968999 (37.7464623358613, -122.43130319969)
71281 232353 2 1 1401 Noe St 1 2 1 1     36 Width 6ft   6003304.68613 2099994.68694 37.74637247023129 -122.43129803308099 (37.7463724702313, -122.431298033081)
38293 232374 2 1 1401 Rivoli St 2 1 1 1     3 Width 5ft   5997728.65176 2105894.8974 37.7622553995774 -122.45100460999201 (37.7622553995774, -122.451004609992)
120079 186675 2 1 1401 Sunset Blvd 32 9 1 1     2 Width 0ft   5984701.897000001 2105453.5805 37.760289275720204 -122.496026006908 (37.7602892757202, -122.496026006908)
122028 186674 2 1 1401 Sunset Blvd 31 9 1 1     10 Width 0ft   5984709.4341 2105459.8614 37.760306962768205 -122.49600040337201 (37.7603069627682, -122.496000403372)
131528 186676 2 1 1401 Sunset Blvd 33 9 1 1     2 Width 0ft   5984702.3158 2105448.5558 37.76027550382771 -122.496024187798 (37.7602755038277, -122.496024187798)
83269 115781 2 1 1401X MASONIC AVE 2 1 1 1   03/23/2016 12:00:00 AM 3 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
103762 115780 2 1 1401X MASONIC AVE 1 1 1 1     30 3x3   5999527.0 2107685.0 37.7672733650738 -122.444913510993 (37.7672733650738, -122.444913510993)
83577 20596 3 1 1401X Sunset Blvd 7 1 1 2     6 60   5984800.4502922995 2105635.4093669 37.760794298851295 -122.495698574627 (37.7607942988513, -122.495698574627)
161736 181598 2 1 1402 Judah St 2 1 1 1     14 Width 0ft   5981310.4394 2105514.4681 37.760257231374105 -122.507759779879 (37.7602572313741, -122.507759779879)
53078 43995 1 1 141 Hampshire St 1 1 1 1   09/08/2000 12:00:00 AM 6   Permit Number 43551 6009986.76566 2107516.11876 37.767401055952604 -122.408722606278 (37.7674010559526, -122.408722606278)
119890 43991 1 1 141 Hampshire St 4 1 1 1   09/08/2000 12:00:00 AM     Permit Number 43551 6009974.46243584 2107504.86062599 37.767369454596 -122.408764367283 (37.767369454596, -122.408764367283)
169640 232398 2 1 141 States St 2 1 1 1     24 Width 3ft   6001393.83562 2106197.3100900003 37.763294900763 -122.438349814208 (37.763294900763, -122.438349814208)
172996 232397 2 1 141 States St 1 1 1 1     23 Width 3ft   6001376.809309999 2106198.41743 37.7632969727984 -122.438408781833 (37.7632969727984, -122.438408781833)
183143 183616 2 1 1411 45th Ave 1 1 1 1     14 Width 0ft   5982133.8491 2105471.1201 37.7601866870275 -122.504908829221 (37.7601866870275, -122.504908829221)
48536 54077 1 1 1416 44th Ave 1 1 1 1   05/10/1972 12:00:00 AM 12   Permit Number 9800 5982488.8605 2105444.4291 37.7601342805878 -122.503679056793 (37.7601342805878, -122.503679056793)
35388 53227 1 1 1419 Pacific Ave 1 1 1 1   07/18/1969 12:00:00 AM 13 3x3 Permit Number 6110 6007265.78904 2117749.89162 37.795347743065 -122.41885999550301 (37.795347743065, -122.418859995503)
61646 210518 2 1 142 Jules Ave 2 1 1 1     18 Width 4ft   5994473.91746 2090866.03275 37.7208030150215 -122.461171998782 (37.7208030150215, -122.461171998782)
7131 116025 1 1 1425 Vallejo St 2 1 1 1   05/02/2016 12:00:00 AM 3 3x3   6006694.6941 2118351.37216 37.796967084814 -122.42087880533501 (37.796967084814, -122.420878805335)
98366 120122 2 1 1426X Douglass St 1 1 1 1   08/22/2016 12:00:00 AM 3 3x3 Permit Number 776978 6001386.0 2099547.0 37.7450343054892 -122.437900552772 (37.7450343054892, -122.437900552772)
149665 210537 2 1 1427 Ulloa St 2 1 1 1     29 Width 3ft   5991566.4324900005 2098375.46288 37.741254277373 -122.471769177213 (37.741254277373, -122.471769177213)
173881 232322 2 1 1430 Douglass St 1 9 1 1     21 Width 6ft   6001368.29061 2099487.1068599997 37.7448688460173 -122.437957499335 (37.7448688460173, -122.437957499335)
113608 51648 1 1 1430 Masonic Ave 1 1 1 1   03/16/2005 12:00:00 AM     Permit Number 47932 5999618.72813404 2107626.34389142 37.7671175447299 -122.444592021369 (37.7671175447299, -122.444592021369)
24163 194035 2 1 1433 17th St 1 1 1 1     28 Width 3ft   6012914.68454 2106566.8968 37.7649582598465 -122.398528655089 (37.7649582598465, -122.398528655089)
96875 113665 2 1 1435 17TH ST 1 1 1 1       3x3   6013045.0 2106578.0 37.7649960058226 -122.39807870262501 (37.7649960058226, -122.398078702625)
8885 53229 1 1 1435 Pacific Ave 1 1 1 1   08/08/2016 12:00:00 AM 3 3x3 Permit Number 6112 6007249.74611 2117746.2070299997 37.795336722764795 -122.41891524533999 (37.7953367227648, -122.41891524534)
70718 183638 2 1 1439 41st Ave 2 1 1 1     6 Width 0ft   5983390.9386 2105000.715 37.758968963556704 -122.500526439198 (37.7589689635567, -122.500526439198)
149972 183634 2 1 1439 41st Ave 1 1 1 1     6 Width 0ft   5983390.5373 2105027.2054 37.7590416751759 -122.50052978577 (37.7590416751759, -122.50052978577)
66259 183628 2 1 1443 47th Ave 1 1 1 1     16 Width 0ft   5981521.3591 2105256.7888 37.7595621418689 -122.507011205649 (37.7595621418689, -122.507011205649)
143633 121087 6 1 1443 47th Ave 1 1 1 1       3x3 Permit Number 778784 5981521.320719999 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719)
75161 41044 1 1 1444 Pacific Ave 1 1 1 1 1 01/29/2000 12:00:00 AM     Permit Number 41825 6007214.22869275 2117785.20726397 37.795441807697294 -122.41904090928001 (37.7954418076973, -122.41904090928)
109300 97998 2 1 1450 Mariposa St 4 1 1 1       3x3   6012865.0 2106120.0 37.7637284123596 -122.39866913856501 (37.7637284123596, -122.398669138565)
112171 97997 2 1 1450 Mariposa St 3 1 1 1   03/09/2016 12:00:00 AM 3 3x3   6012865.0 2106120.0 37.7637284123596 -122.39866913856501 (37.7637284123596, -122.398669138565)
40075 100079 2 1 1451 44th Ave 1 1 1 1     14 3x6   5982451.9345 2105243.3429 37.759579983868605 -122.503791871245 (37.7595799838686, -122.503791871245)
165819 183632 2 1 1455 44th Ave 1 1 1 1     13 Width 0ft   5982451.9345 2105212.4374 37.759495126142 -122.503789582339 (37.759495126142, -122.503789582339)
182272 131763 2 1 1457 Jones St 1 10 1 1     16 Width 3ft   6008417.06699 2117517.79175 37.794775211263705 -122.414859937834 (37.7947752112637, -122.414859937834)
141348 115094 2 1 1460 Masonic Ave 2 1 1 1       3x3 Permit Number 777177 5999642.2 2107532.2 37.766860388537104 -122.444504069146 (37.7668603885371, -122.444504069146)
76036 37096 1 1 1467 47th Ave 1 1 1 1 1 06/01/1998 12:00:00 AM 7   Permit Number 39696 5981524.9714 2105106.2752 37.759149087294794 -122.506987547698 (37.7591490872948, -122.506987547698)
117353 108117 2 1 148 28TH AVE 2 1 1 1           5987142.8 2114987.8 37.786610228944504 -122.488284841308 (37.7866102289445, -122.488284841308)
143795 108116 2 1 148 28TH AVE 1 1 1 1           5987142.8 2114987.8 37.786610228944504 -122.488284841308 (37.7866102289445, -122.488284841308)
1333 187634 2 1 148 28th Ave 2 1 1 1       3x3 Permit Number 779931 5987142.0 2114987.0 37.786607985699604 -122.48828755026399 (37.7866079856996, -122.488287550264)
28261 250625 2 1 148 28th Ave 1 2 1 1     13 Width 4ft   5987117.9845 2114972.6519400002 37.7865671888719 -122.488369582106 (37.7865671888719, -122.488369582106)
156513 250626 2 1 148 28th Ave 2 2 1 1     11 Width 4ft   5987115.7577 2114991.54475 37.7866189331721 -122.488378675159 (37.7866189331721, -122.488378675159)
111980 100294 2 1 1482 06th Ave 1 1 1 1           5994335.4 2105438.4 37.760807128362 -122.46270738304199 (37.760807128362, -122.462707383042)
134032 210536 2 1 1482 06th Ave 1 1 1 1     23 Width 4ft   5994312.93494 2105441.26855 37.7608137107938 -122.462785287219 (37.7608137107938, -122.462785287219)
134016 232401 2 1 149 Fillmore St 1 1 1 1     16 Width 3ft   6003773.51439 2108951.71112 37.7709928843343 -122.430315816029 (37.7709928843343, -122.430315816029)
125466 110020   1 1490X Douglass St 1 9 1 1       9x9   6001386.81709 2099547.0285 37.745034430207795 -122.437897729467 (37.7450344302078, -122.437897729467)
30452 131764 2 1 1492 Pacific Ave 1 10 1 1     13 Width 3ft   6007026.74159 2117749.85493 37.7953341794929 -122.419687137974 (37.7953341794929, -122.419687137974)
Powered by Datasette · Query took 15.662ms · Data source: data.sfgov.org