sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11148 20065 3 100 100 STAIRWAY54 12 1 1 2     3 15ST            
15304 19794 3 100 100 STAIRWAY19 16 1 1 2     18 50ST            
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
138478 24290 3 100 386 Winding Way 1 1 1 2     12 3X17   6000963.19469 2086697.3561200001 37.709728074949204 -122.43844208303699 (37.7097280749492, -122.438442083037)
32439 194391 3 100 828x Jamestown Ave 4 11 1 2     19 Width 5ft   6014866.8225 2088973.5540099998 37.7167591360948 -122.39054719349899 (37.7167591360948, -122.390547193499)
30035 194392 3 100 860x Jamestown Ave 5 11 1 2     17 Width 5ft   6014755.052209999 2089115.5775900001 37.7171429037943 -122.39094345187799 (37.7171429037943, -122.390943451878)
151174 194393 3 100 860x Jamestown Ave 9 11 1 2     18 Width 5ft   6014647.11529 2089218.63866 37.7174198994758 -122.391323741894 (37.7174198994758, -122.391323741894)
41784 194394 3 100 920x Jamestown Ave 4 11 1 2     19 Width 5ft   6014490.42947 2089308.0420799998 37.717656686497506 -122.39187158462799 (37.7176566864975, -122.391871584628)
183995 194395 3 100 920x Jamestown Ave 9 11 1 2     20 Width 5ft   6014427.53162 2089348.9061599998 37.7177653992236 -122.392091851971 (37.7177653992236, -122.392091851971)
80229 18563 3 100 1700X Quesada Ave 18 11 1 2     30 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
85028 18558 3 100 1700X Quesada Ave 13 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
86395 18554 3 100 1700X Quesada Ave 9 11 1 2     12 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
94802 18548 9 100 1700X Quesada Ave 3 11 1 2     30 19   6014793.6967997 2095004.1424748 37.7333138733401 -122.39122125893199 (37.7333138733401, -122.391221258932)
16811 18551 9 100 1700X Quesada Ave 6 11 1 2     30 19   6014649.71614 2095074.3239900002 37.733498586072294 -122.391723949223 (37.7334985860723, -122.391723949223)
16768 18555 9 100 1700X Quesada Ave 10 11 1 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
13621 18556 3 100 1700X Quesada Ave 11 11 1 2     30 19   6014603.96741 2095108.67042 37.7335903547148 -122.391884517749 (37.7335903547148, -122.391884517749)
16559 18559 3 100 1700X Quesada Ave 14 11 1 2     30 19   6014565.4208 2095135.4289 37.733661688034104 -122.392019656183 (37.7336616880341, -122.392019656183)
14049 18560 3 100 1700X Quesada Ave 15 11 1 2     12 19   6014546.06488 2095149.2171099999 37.7336984729967 -122.392087539714 (37.7336984729967, -122.392087539714)
35928 194284 3 100 1700x Quesada Ave 20 3 1 2     31     6014504.15008 2095180.2076400002 37.733781239407 -122.392234619349 (37.733781239407, -122.392234619349)
166815 194285 3 100 1700x Quesada Ave 28 3 1 2     30     6014471.94536 2095201.4069599998 37.7338376601657 -122.39234744377701 (37.7338376601657, -122.392347443777)
150397 194286 3 100 1700x Quesada Ave 29 3 1 2     36     6014450.16973 2095221.3993900002 37.7338913460907 -122.392424127176 (37.7338913460907, -122.392424127176)
39870 194287 9 100 1700x Quesada Ave 32 3 1 2     31     6014435.322380001 2095233.3766599998 37.733923408722795 -122.392476296866 (37.7339234087228, -122.392476296866)
107507 96673 3 100 1449 Mendell St 1 1 1 2     30 4x4   6014955.39834 2095258.9558 37.7340225115191 -122.390680007822 (37.7340225115191, -122.390680007822)
35608 194288 9 100 1700x Quesada Ave 37 3 1 2     34     6014411.93404 2095259.01392 37.733992504551296 -122.392558950849 (37.7339925045513, -122.392558950849)
58702 194289 9 100 1700x Quesada Ave 38 3 1 2     48     6014396.14271 2095264.76436 37.734007417094 -122.39261394888901 (37.734007417094, -122.392613948889)
70141 194290 3 100 1700x Quesada Ave 40 3 1 2     27     6014381.3022300005 2095272.57767 37.7340280466394 -122.39266580380101 (37.7340280466394, -122.392665803801)
54354 194291 9 100 1700x Quesada Ave 41 3 1 2     38     6014364.32912 2095287.3135099998 37.7340675655682 -122.39272551607701 (37.7340675655682, -122.392725516077)
27134 194292 3 100 1700x Quesada Ave 43 3 1 2     38     6014354.24031 2095291.86255 37.734079495961396 -122.392760714642 (37.7340794959614, -122.392760714642)
27594 194293 3 100 1700x Quesada Ave 46 3 1 2     28     6014318.796490001 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337)
54350 194294 3 100 1700x Quesada Ave 49 3 1 2     27     6014297.19865 2095334.47415 37.7341933303645 -122.392960907318 (37.7341933303645, -122.392960907318)
80018 25143 3 100 1798X Dolores St 9 11 1 2     50 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
99831 25146 3 100 1798X Dolores St 12 11 1 2     50 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
103351 25147 3 100 1798X Dolores St 13 11 1 2     90 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
113894 25144 3 100 1798X Dolores St 10 11 1 2     50 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
122371 25145 3 100 1798X Dolores St 11 11 1 2     90 20   6005303.475850901 2097774.014097 37.740388080432204 -122.42422853472999 (37.7403880804322, -122.42422853473)
19402 25141 3 100 1750X Dolores St 7 11 1 2     70 20   6005346.329580001 2097965.45382 37.740916150253604 -122.424093974258 (37.7409161502536, -122.424093974258)
19258 25140 3 100 1750X Dolores St 6 11 1 2     90 20   6005337.960390001 2097982.3892099997 37.74096217846979 -122.424124115947 (37.7409621784698, -122.424124115947)
47964 234371 3 100 1750x Dolores St 5 3 1 2     35     6005338.50183 2098008.71997 37.7410345073494 -122.42412411595 (37.7410345073494, -122.42412411595)
148964 234370 3 100 1750x Dolores St 4 3 1 2     35     6005335.592730001 2098044.06455 37.7411313913144 -122.42413668757 (37.7411313913144, -122.42413668757)
68375 234369 3 100 1750x Dolores St 3 3 1 2     18     6005339.90624 2098058.76544 37.7411720001789 -122.42412281821899 (37.7411720001789, -122.424122818219)
123736 234368 3 100 1750x Dolores St 1 3 1 2     21     6005333.75186 2098133.92444 37.7413780222889 -122.42414944174 (37.7413780222889, -122.42414944174)
94540 106114 3 100 1752X DOLORES ST 1 3 1 2           6005197.0 2098194.1 37.741535528464496 -122.424626562024 (37.7415355284645, -122.424626562024)
78381 23674 3 100 319 Virginia Ave 3 11 1 2     3 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
17005 25139 3 100 1700X Dolores St 5 11 1 2     90 20   6005326.84877 2098252.91312 37.741704348480795 -122.42418177058599 (37.7417043484808, -122.424181770586)
21419 25138 3 100 1700X Dolores St 4 11 1 2     90 20   6005319.278030001 2098285.9295200002 37.7417945765605 -122.424210295287 (37.7417945765605, -122.424210295287)
20678 25137 3 100 1700X Dolores St 3 11 1 2     90 20   6005325.6404800005 2098301.13362 37.7418366828201 -122.424189377061 (37.7418366828201, -122.424189377061)
17024 25136 3 100 1700X Dolores St 2 11 1 2     90 20   6005320.97591 2098341.7574 37.741947963130706 -122.424208394127 (37.7419479631307, -122.424208394127)
19284 25135 3 100 1700X Dolores St 1 11 1 2     90 20   6005318.690690001 2098391.09531 37.742083304809206 -122.424219803815 (37.7420833048092, -122.424219803815)
47477 234367 3 100 1650x Dolores St 5 3 1 2     44     6005309.50054 2098532.58451 37.7424712831236 -122.424261641173 (37.7424712831236, -122.424261641173)
18061 25129 3 100 1650X Dolores St 4 11 1 2     40 20   6005306.59795 2098578.64869 37.7425976010056 -122.424274952941 (37.7425976010056, -122.424274952941)
19082 25127 3 100 1650X Dolores St 3 11 1 2     40 20   6005306.7238300005 2098611.50649 37.7426878281697 -122.424276854096 (37.7426878281697, -122.424276854096)
21602 25126 3 100 1650X Dolores St 2 11 1 2     40 20   6005303.102530001 2098649.37036 37.7427915892743 -122.424292067924 (37.7427915892743, -122.424292067924)
18142 13388 3 100 218 Marietta Dr 1 11 1 2     6 5   5997667.5215300005 2098758.8322 37.7426580336411 -122.45070150968999 (37.7426580336411, -122.45070150969)
17398 5707 3 100 1600 Dolores St 1 1 1 2     100 3X3   6005241.864159999 2098983.9941 37.74370693182271 -122.424527610259 (37.7437069318227, -122.424527610259)
18284 25123 3 100 1550 Dolores St 4 11 1 2     90 20   6005274.82817 2099143.28527 37.744146170621704 -122.424424956245 (37.7441461706217, -122.424424956245)
19053 25122 3 100 1550 Dolores St 3 11 1 2     90 20   6005275.20405 2099188.4733700003 37.7442702680707 -122.42442687003 (37.7442702680707, -122.42442687003)
20326 25115 3 100 1550X Dolores St 2 11 1 2     90 20   6005272.16967 2099229.32207 37.7443822579348 -122.424440267208 (37.7443822579348, -122.424440267208)
21512 25120 3 100 1550 Dolores St 1 11 1 2     90 20   6005269.99247 2099258.02767 37.744460954018 -122.424449836913 (37.744460954018, -122.424449836913)
109462 25117 3 100 1548X Dolores St 4 11 1 2     90 20   6005242.6409807 2099315.8732106998 37.7446182400704 -122.42454852673201 (37.7446182400704, -122.424548526732)
16918 25119 3 100 1500X Dolores St 6 11 1 2     30 20   6005258.69008 2099408.1764 37.7448725899054 -122.42449959638999 (37.7448725899054, -122.42449959639)
21986 25118 3 100 1500X Dolores St 5 11 1 2     90 20   6005257.61936 2099436.85892 37.74495128509079 -122.42450533857 (37.7449512850908, -122.42450533857)
18928 25116 3 100 1500X Dolores St 3 11 1 2     90 20   6005256.05434 2099495.31423 37.7451117016422 -122.42451490734301 (37.7451117016422, -122.424514907343)
18585 25121 3 100 1500 Dolores St 2 11 1 2     24 20   6005252.19486 2099522.95164 37.745187369700105 -122.424530218294 (37.7451873697001, -122.424530218294)
17235 708 3 100 1504X Dolores St 2 1 1 2   11/06/2015 02:27:00 PM 3 6x6   6005213.6425 2099570.03766 37.745314479891896 -122.42466687479799 (37.7453144798919, -122.424666874798)
86700 25109 3 100 1496 Dolores St 2 11 1 2     90 20   6005218.8222955 2099617.195839 37.7454442580108 -122.424652317948 (37.7454442580108, -122.424652317948)
22048 25106 3 100 1450X Dolores St 6 11 1 2     90 20   6005241.17775 2099713.8788799997 37.74571099007721 -122.424581892451 (37.7457109900772, -122.424581892451)
19857 5683 3 100 1488 Dolores St 1 1 1 2   05/08/1997 12:00:00 AM 12 6   6005201.38668 2099720.6305299997 37.745727281286705 -122.42471996446301 (37.7457272812867, -122.424719964463)
20817 25112 3 100 1450 Dolores St 5 11 1 2     90 20   6005235.506709999 2099747.61613 37.7458033045753 -122.42460390154699 (37.7458033045753, -122.424603901547)
21855 25111 3 100 1450 Dolores St 4 11 1 2     90 20   6005242.59316 2099769.2409599996 37.745863081619895 -122.424580935573 (37.7458630816199, -122.424580935573)
20892 25110 3 100 1450 Dolores St 3 11 1 2     90 20   6005236.31225 2099800.23492 37.7459478292265 -122.42460485845301 (37.7459478292265, -122.424604858453)
21388 25107 3 100 1400X Dolores St 7 11 1 2     70 20   6005229.6240300005 2099972.88313 37.7464215039571 -122.424640264758 (37.7464215039571, -122.424640264758)
17078 25113 3 100 1400 Dolores St 6 11 1 2     30 20   6005228.94357 2100007.06865 37.7465153311328 -122.424645049125 (37.7465153311328, -122.424645049125)
17629 25102 3 100 1400X Dolores St 2 11 1 2     90 20   6005226.05485 2100086.94121 37.7467344797311 -122.424660718923 (37.7467344797311, -122.424660718923)
17004 25108 3 100 1400 Dolores St 1 11 1 2     30 20   6005223.671490001 2100130.84124 37.7468548845426 -122.424672082757 (37.7468548845426, -122.424672082757)
117928 25097 3 100 1388X Dolores St 2 11 1 2     90 20   6005167.2006822 2100254.8047856004 37.747192070496 -122.424876171578 (37.747192070496, -122.424876171578)
133800 234346 3 100 1350x Dolores St 7 3 1 2     33     6005214.83803 2100265.33674 37.74722367943539 -122.424712194312 (37.7472236794354, -122.424712194312)
71379 234345 3 100 1350x Dolores St 6 3 1 2     34     6005211.50018 2100294.54181 37.7473036813364 -122.424725813644 (37.7473036813364, -122.424725813644)
17487 25100 3 100 1350X Dolores St 5 11 1 2     60 20   6005208.528519999 2100314.21379 37.7473575282405 -122.424737488671 (37.7473575282405, -122.424737488671)
19964 703 3 100 1375X Dolores St 1 1 1 2     70 3X3   6005257.21277 2100319.77841 37.747375556949 -122.424569537574 (37.747375556949, -122.424569537574)
17756 25098 3 100 1350X Dolores St 3 11 1 2     90 20   6005207.855169999 2100363.5353099997 37.7474929157794 -122.424743325238 (37.7474929157794, -122.424743325238)
19687 25091 3 100 1350 Dolores St 1 11 1 2     80 20   6005204.68058 2100428.03656 37.7476698420965 -122.42475889070299 (37.7476698420965, -122.424758890703)
106112 25094 3 100 1348 Dolores St 4 11 1 2     40 20   6005177.2486108 2100480.3758406 37.747812004334705 -122.424857472056 (37.7478120043347, -122.424857472056)
20790 25095 3 100 1300 Dolores St 5 11 1 2     80 20   6005196.77931 2100544.39428 37.7479888873864 -122.424794489489 (37.7479888873864, -122.424794489489)
17425 25099 3 100 1300X Dolores St 4 11 1 2     70 20   6005195.84744 2100584.78774 37.7480997459068 -122.42480058509899 (37.7480997459068, -122.424800585099)
21503 25093 3 100 1300 Dolores St 3 11 1 2     80 20   6005193.32199 2100633.40551 37.7482330964805 -122.424812776293 (37.7482330964805, -122.424812776293)
20879 25092 3 100 1300 Dolores St 2 11 1 2     80 20   6005189.02223 2100681.47449 37.7483648399821 -122.424831064022 (37.7483648399821, -122.424831064022)
17620 25096 3 100 1300X Dolores St 1 11 1 2     90 20   6005188.030230001 2100718.94336 37.748467664846295 -122.42483715961001 (37.7484676648463, -122.42483715961)
17276 25090 3 100 1250X Dolores St 5 11 1 2     90 20   6005182.99372 2100845.43458 37.7488146961375 -122.424863573617 (37.7488146961375, -122.424863573617)
21135 25089 3 100 1250X Dolores St 4 11 1 2     90 20   6005180.26353 2100884.10883 37.748920732509 -122.424875765702 (37.748920732509, -122.424875765702)
19587 25088 3 100 1250X Dolores St 3 11 1 2     90 20   6005178.85274 2100929.77786 37.7490460494561 -122.424883892899 (37.7490460494561, -122.424883892899)
20929 25087 3 100 1250X Dolores St 2 11 1 2     90 20   6005179.035519999 2100967.22192 37.7491488725392 -122.42488592444401 (37.7491488725392, -122.424885924444)
17792 25085 3 100 1200X Dolores St 5 11 1 2     70 20   6005165.443630001 2101134.8464599997 37.7496083631354 -122.424944849843 (37.7496083631354, -122.424944849843)
17316 25084 3 100 1200X Dolores St 4 11 1 2     90 20   6005164.22411 2101175.53736 37.7497200220711 -122.42495196167499 (37.7497200220711, -122.424951961675)
Powered by Datasette · Query took 10.646ms · Data source: data.sfgov.org