sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6948 20002 3 60 100 STAIRWAY46 22 1 1 2     6 2            
7696 19998 3 60 100 STAIRWAY46 18 1 1 2     12 40            
10647 19755 3 60 100 STAIRWAY15 13 1 1 2     6 3X3            
16139 19754 3 60 100 STAIRWAY15 12 1 1 2     6 3X3            
189144 121399 3 60 349X Cargo Way 1 1 1 2                    
107109 1851 3 60 2401 Bay Shore Blvd 10 1 1 2   01/17/1991 12:00:00 AM 12 3X3   6011063.3259362 2087019.7277799998 37.7111825850692 -122.403556689346 (37.7111825850692, -122.403556689346)
188789 1301 3 60 4000X Alemany Blvd 9 11 1 2     32 10   5991772.09471 2087046.42932 37.7101594558675 -122.470233284447 (37.7101594558675, -122.470233284447)
10466 1196 3 60 3080 Alemany Blvd 1 1 1 2   06/11/1992 12:00:00 AM 28 3X3   5996438.01379 2087205.1874 37.7108640234246 -122.45411848649799 (37.7108640234246, -122.454118486498)
10644 1838 3 60 2201X Bay Shore Blvd 2 1 1 2     12 3X3   6011226.77764 2087216.18178 37.71173113716571 -122.403005565662 (37.7117311371657, -122.403005565662)
13163 1267 3 60 3995X Alemany Blvd 5 1 1 2     24 3X3   5992203.06147 2087231.00688 37.710691168335096 -122.468757212784 (37.7106911683351, -122.468757212784)
11884 1270 3 60 3995X Alemany Blvd 7 1 1 2     12 3x3   5992245.7583099995 2087252.3125599998 37.7107521351809 -122.46861119345101 (37.7107521351809, -122.468611193451)
91843 1272 3 60 3995X Alemany Blvd 11 1 1 2     18 3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
123541 1279 3 60 3995X Alemany Blvd 15 1 1 2     12 3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
11364 1271 3 60 3995X Alemany Blvd 9 1 1 2     12 3X3   5992356.50735 2087300.8185599998 37.7108917180496 -122.468231949349 (37.7108917180496, -122.468231949349)
13079 1273 3 60 3995X Alemany Blvd 10 1 1 2     12 3X3 Permit Number 771193 5992398.03069 2087322.1494900002 37.710952685801104 -122.46808998688499 (37.7109526858011, -122.468089986885)
12454 1277 3 60 3995X Alemany Blvd 14 1 1 2     12 3X3   5992498.771269999 2087369.1133 37.7110874546035 -122.46774522006099 (37.7110874546035, -122.467745220061)
10580 1280 3 60 3995X Alemany Blvd 15 1 1 2     12 3x3   5992520.10718 2087379.1823 37.71111633361279 -122.467672210425 (37.7111163336128, -122.467672210425)
12581 1281 3 60 3995X Alemany Blvd 17 1 1 2     12 3X3   5992683.69403 2087456.96265 37.7113393439098 -122.46711247059099 (37.7113393439098, -122.467112470591)
79082 11840 3 60 1400X Junipero Serra Blvd 12 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
87684 11839 3 60 1400X Junipero Serra Blvd 14 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
93762 11846 3 60 1400X Junipero Serra Blvd 18 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
95638 11841 3 60 1400X Junipero Serra Blvd 13 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
99517 11834 3 60 1400X Junipero Serra Blvd 6 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
101567 11830 3 60 1400X Junipero Serra Blvd 2 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
106431 11831 3 60 1400X Junipero Serra Blvd 3 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
138707 11843 3 60 1400X Junipero Serra Blvd 20 11 1 2     3 2X2   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
139771 11844 3 60 1400X Junipero Serra Blvd 16 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
139855 11845 3 60 1400X Junipero Serra Blvd 17 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
140080 11835 3 60 1400X Junipero Serra Blvd 7 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
144436 11832 3 60 1400X Junipero Serra Blvd 4 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
144641 11847 3 60 1400X Junipero Serra Blvd 19 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
145215 11837 3 60 1400X Junipero Serra Blvd 9 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
145667 11836 3 60 1400X Junipero Serra Blvd 8 11 1 2     3 6X6   5991384.4577741 2088377.8376777 37.7137927618926 -122.47166998341001 (37.7137927618926, -122.47166998341)
78324 30038 3 60 1400X Junipero Serra Blvd 1 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
89892 30039 3 60 1400X Junipero Serra Blvd 10 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
102800 30041 3 60 1400X Junipero Serra Blvd 22 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
105964 30045 3 60 1400X Junipero Serra Blvd 26 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
117831 30043 3 60 1400X Junipero Serra Blvd 24 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
119448 30040 3 60 1400X Junipero Serra Blvd 21 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
126132 30042 3 60 1400X Junipero Serra Blvd 5 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
127507 30044 3 60 1400X Junipero Serra Blvd 25 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
128129 30046 3 60 1400X Junipero Serra Blvd 27 11 1 2     3 6X6   5991408.898027 2088383.098472 37.7138086207581 -122.47158589282199 (37.7138086207581, -122.471585892822)
120792 1764 3 60 2000X Bay Shore Blvd 4 1 1 2   12/30/1992 12:00:00 AM 12 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
113869 26378 3 60 2623 San Jose Ave 1 1 1 2     18 4X4   5997606.3009019 2089136.049585 37.7162326497335 -122.45021972279301 (37.7162326497335, -122.450219722793)
62175 212292 3 60 1000x Junipero Serra Blvd 2 11 1 2     6 Width 0ft   5991164.37326 2089829.54432 37.7177660575462 -122.472536442798 (37.7177660575462, -122.472536442798)
95442 29636 3 60 1110X Junipero Serra Blvd 9 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
98950 29632 3 60 1110X Junipero Serra Blvd 5 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
99891 29635 3 60 1110X Junipero Serra Blvd 8 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
100149 29637 3 60 1110X Junipero Serra Blvd 10 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
103060 29629 3 60 1110X Junipero Serra Blvd 2 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
103985 29638 3 60 1110X Junipero Serra Blvd 11 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
108232 29628 3 60 1110X Junipero Serra Blvd 1 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
140900 29634 3 60 1110X Junipero Serra Blvd 7 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
143674 29630 3 60 1110X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
145795 29633 3 60 1110X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991107.8990450995 2089843.5367701 37.717801208369 -122.47273266668002 (37.717801208369, -122.47273266668)
170614 212293 3 60 1000x Junipero Serra Blvd 3 11 1 2     9 Width 0ft   5991165.05081 2089858.71083 37.717846180842294 -122.472536226064 (37.7178461808423, -122.472536226064)
154256 212294 3 60 1000x Junipero Serra Blvd 4 11 1 2     9 Width 0ft   5991166.95703 2089883.0190299999 37.7179130355286 -122.472531408396 (37.7179130355286, -122.472531408396)
186690 212295 3 60 1000x Junipero Serra Blvd 6 11 1 2     9 Width 0ft   5991170.53267 2089939.6813400001 37.7180688232854 -122.472523177809 (37.7180688232854, -122.472523177809)
71529 176016 3 60 700x Mansell St 30 11 1 2     31 Width 0ft   6009216.97292 2089964.58671 37.7191652533595 -122.410145941702 (37.7191652533595, -122.410145941702)
162733 212296 3 60 1000x Junipero Serra Blvd 10 11 1 2     10 Width 0ft   5991176.06439 2090044.25898 37.7183562879852 -122.472511677268 (37.7183562879852, -122.472511677268)
67053 212297 3 60 1000x Junipero Serra Blvd 11 11 1 2     5 Width 0ft   5991177.8274300005 2090064.7629799999 37.7184126889791 -122.47250707726002 (37.7184126889791, -122.47250707726)
31562 212298 3 60 1000x Junipero Serra Blvd 12 11 1 2     5 Width 0ft   5991179.120709999 2090094.55389 37.7184945623549 -122.47250477768699 (37.7184945623549, -122.472504777687)
146358 212299 3 60 1000x Junipero Serra Blvd 14 11 1 2     5 Width 0ft   5991184.2984 2090150.76712 37.7186492097602 -122.47249097667401 (37.7186492097602, -122.472490976674)
104551 17603 3 60 918 Persia Ave 1 1 1 2     80 3X3   6003916.62917 2090182.06037 37.7194638711075 -122.428482700528 (37.7194638711075, -122.428482700528)
173416 212300 3 60 1000x Junipero Serra Blvd 16 11 1 2     7 Width 0ft   5991186.31185 2090192.49351 37.7187638967107 -122.472487057435 (37.7187638967107, -122.472487057435)
184198 212301 3 60 1000x Junipero Serra Blvd 17 11 1 2     5 Width 0ft   5991188.84719 2090215.0879099998 37.7188260821255 -122.47247994019199 (37.7188260821255, -122.472479940192)
75985 176015 3 60 600x Mansell St 1 11 1 2     16 Width 0ft   6010073.5317400005 2090236.70222 37.7199604006417 -122.40720430245399 (37.7199604006417, -122.407204302454)
163038 212302 3 60 1000x Junipero Serra Blvd 18 11 1 2     3 Width 0ft   5991190.15994 2090239.4345099998 37.7188930078858 -122.47247717658001 (37.7188930078858, -122.47247717658)
52489 212303 3 60 1000x Junipero Serra Blvd 19 11 1 2     10 Width 0ft   5991192.118419999 2090269.21075 37.7189748794765 -122.47247257657601 (37.7189748794765, -122.472472576576)
157693 212304 3 60 1000x Junipero Serra Blvd 20 11 1 2     5 Width 0ft   5991192.55124 2090289.74279 37.7190312804608 -122.472472576553 (37.7190312804608, -122.472472576553)
58519 212305 3 60 1000x Junipero Serra Blvd 21 11 1 2     3 Width 0ft   5991194.3003 2090309.58448 37.7190858620976 -122.47246797653901 (37.7190858620976, -122.472467976539)
41461 212306 3 60 1000x Junipero Serra Blvd 22 11 1 2     7 Width 0ft   5991196.13313 2090333.39999 37.719151359714395 -122.472463376508 (37.7191513597144, -122.472463376508)
68407 212307 3 60 1000x Junipero Serra Blvd 23 11 1 2     12 Width 0ft   5991200.212719999 2090369.09522 37.7192496061609 -122.47245187595 (37.7192496061609, -122.47245187595)
66442 212308 3 60 1000x Junipero Serra Blvd 24 11 1 2     7 Width 0ft   5991201.47803 2090397.56088 37.7193278390954 -122.47244957640801 (37.7193278390954, -122.472449576408)
60017 176014 3 60 500x Mansell St 1 11 1 2     45 Width 0ft   6010647.65151 2090407.8799299998 37.7204625334973 -122.405231805915 (37.7204625334973, -122.405231805915)
166561 212309 3 60 1000x Junipero Serra Blvd 25 11 1 2     4 Width 0ft   5991201.91083 2090418.0925900002 37.719384239169294 -122.472449576413 (37.7193842391693, -122.472449576413)
32028 212310 3 60 1000x Junipero Serra Blvd 26 11 1 2     11 Width 0ft   5991202.259869999 2090434.6504900001 37.7194297232904 -122.472449576395 (37.7194297232904, -122.472449576395)
86755 30140 3 60 410X Mansell St 2 11 1 2     18 M   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
55711 205076 3 60 1000x Junipero Serra Blvd 27 11 1 2     12 Width 0ft   5991204.8696099995 2090463.7504 37.7195097755318 -122.472442675902 (37.7195097755318, -122.472442675902)
42645 176013 3 60 300x Mansell St 2 11 1 2     32 Width 0ft   6010939.71676 2090487.4301 37.7206972862266 -122.40422782077101 (37.7206972862266, -122.404227820771)
39182 205077 3 60 1000x Junipero Serra Blvd 28 11 1 2     12 Width 0ft   5991206.77223 2090490.8774299999 37.719584369801396 -122.47243807587601 (37.7195843698014, -122.472438075876)
158549 205078 3 60 1000x Junipero Serra Blvd 29 11 1 2     9 Width 0ft   5991207.21899 2090512.07145 37.7196425892212 -122.47243807587601 (37.7196425892212, -122.472438075876)
73785 205079 3 60 1000x Junipero Serra Blvd 30 11 1 2     13 Width 0ft   5991209.0936900005 2090537.87387 37.7197135448202 -122.47243347583 (37.7197135448202, -122.47243347583)
174777 205080 3 60 1000x Junipero Serra Blvd 31 11 1 2     8 Width 0ft   5991211.60542 2090562.33735 37.7197808608892 -122.47242657625 (37.7197808608892, -122.47242657625)
31596 205081 3 60 1000x Junipero Serra Blvd 32 11 1 2     8 Width 0ft   5991210.7499 2090584.88401 37.7198427189488 -122.47243117628099 (37.7198427189488, -122.472431176281)
72304 205082 3 60 1000x Junipero Serra Blvd 34 11 1 2     7 Width 0ft   5991216.27623 2090657.6545099998 37.720042848675604 -122.47241737616501 (37.7200428486756, -122.472417376165)
69407 205083 3 60 1000x Junipero Serra Blvd 35 11 1 2     6 Width 0ft   5991217.1837 2090700.70485 37.720161106826 -122.472417376171 (37.720161106826, -122.472417376171)
67638 205084 3 60 1000x Junipero Serra Blvd 36 11 1 2     4 Width 0ft   5991220.51447 2090732.43963 37.720248435491904 -122.472408175222 (37.7202484354919, -122.472408175222)
20236 29626 3 60 900X Junipero Serra Blvd 35 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991174.60245 2090776.1353200001 37.720365755664794 -122.47257006037901 (37.7203657556648, -122.472570060379)
156267 205085 3 60 1000x Junipero Serra Blvd 38 11 1 2     4 Width 0ft   5991225.77549 2090792.62573 37.720413996187 -122.47239437511601 (37.720413996187, -122.472394375116)
182927 205086 3 60 1000x Junipero Serra Blvd 39 11 1 2     12 Width 0ft   5991226.90116 2090814.4677099998 37.7204740340313 -122.472392075543 (37.7204740340313, -122.472392075543)
65755 205087 3 60 1000x Junipero Serra Blvd 40 11 1 2     5 Width 0ft   5991229.32936 2090834.95737 37.7205304341251 -122.47238517504499 (37.7205304341251, -122.472385175045)
44624 205088 3 60 1000x Junipero Serra Blvd 41 11 1 2     11 Width 0ft   5991229.30633 2090865.43732 37.7206141232198 -122.47238747550301 (37.7206141232198, -122.472387475503)
169141 205089 3 60 1000x Junipero Serra Blvd 42 11 1 2     6 Width 0ft   5991231.16702 2090890.57712 37.7206832586037 -122.47238287549601 (37.7206832586037, -122.472382875496)
70422 205090 3 60 1000x Junipero Serra Blvd 44 11 1 2     4 Width 0ft   5991232.93514 2090942.88536 37.7208269864641 -122.472380575028 (37.7208269864641, -122.472380575028)
17935 29599 3 60 900X Junipero Serra Blvd 8 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991176.65606 2091094.6598 37.7212404641514 -122.472586172621 (37.7212404641514, -122.472586172621)
87249 29605 3 60 910X Junipero Serra Blvd 14 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152466998 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236)
112917 29604 3 60 910X Junipero Serra Blvd 13 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152466998 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236)
127749 29603 3 60 910X Junipero Serra Blvd 12 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991188.7321263 2091104.0152466998 37.7212668508959 -122.472545111236 (37.7212668508959, -122.472545111236)
111045 11732 3 60 900X Junipero Serra Blvd 10 1 1 2     36 4X6   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
93174 24409 3 60 901X Junipero Serra Blvd 8 1 1 2   02/18/1998 12:00:00 AM 6 3x3   5991288.1161497 2091224.4470027 37.7216032788517 -122.472210346501 (37.7216032788517, -122.472210346501)
Powered by Datasette · Query took 57.03ms · Data source: data.sfgov.org