sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
46563 221509 2 109 1201 San Jose Ave 38 7 1 1     2     6004439.440880001 2096038.0117799998 37.735572586401894 -122.42709240931102 (37.7355725864019, -122.427092409311)
67739 187784 2 109 101 Pennsylvania Ave 35 7 1 1     4     6014258.31464 2106694.98019 37.765384711161104 -122.393890307196 (37.7653847111611, -122.393890307196)
76798 187783 2 109 101 Pennsylvania Ave 26 7 1 1     4     6014314.48936 2106550.7653 37.764991850418895 -122.393685915597 (37.7649918504189, -122.393685915597)
171233 221443 3 109 100x Guerrero St 16 11 1 2     1 Width 3ft   6005451.42839 2107920.02985 37.7682550341586 -122.42443846228599 (37.7682550341586, -122.424438462286)
29150 221508 2 109 1201 San Jose Ave 15 7 1 1     1     6004291.813569999 2095940.5809 37.73529671397821 -122.427595874056 (37.7352967139782, -122.427595874056)
67326 221557 3 109 1000x Guerrero St 15 11 1 2     3 Width 3ft   6005743.02813 2102638.73526 37.7537703032837 -122.42305441913099 (37.7537703032837, -122.423054419131)
148926 221442 3 109 100x Guerrero St 15 11 1 2     1 Width 3ft   6005450.9028900005 2107942.8086599996 37.768317549645 -122.42444190036699 (37.768317549645, -122.424441900367)
133864 221441 3 109 100x Guerrero St 14 11 1 2     1 Width 3ft   6005450.56053 2107974.49254 37.768404526663396 -122.424445338474 (37.7684045266634, -122.424445338474)
180267 221556 3 109 1000x Guerrero St 14 11 1 2     3 Width 3ft   6005741.57845 2102677.06839 37.753875475376 -122.42306215689501 (37.753875475376, -122.423062156895)
181350 187782 2 109 101 Pennsylvania Ave 14 7 1 1     1     6014325.58247 2106437.08289 37.764680319857995 -122.39363958970199 (37.764680319858, -122.393639589702)
4437 221480 3 109 400x Guerrero St 13 11 1 2   04/29/2015 05:03:00 AM 1 Width 3ft   6005548.13055 2106148.7780400002 37.7633970583515 -122.423978006683 (37.7633970583515, -122.423978006683)
42902 221440 3 109 100x Guerrero St 13 11 1 2     1 Width 3ft   6005447.60224 2108007.88033 37.7684960344855 -122.424457946087 (37.7684960344855, -122.424457946087)
93719 110771 3 109 300X GUERRERO ST 13 11 1 2   06/19/2015 10:10:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
100063 110650 3 109 400X GUERRERO ST 13 11 1 2   04/29/2015 05:03:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
141015 110784 3 109 1000X GUERRERO ST 13 11 1 2   05/26/2015 02:11:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
150263 221520 3 109 1200x Guerrero St 13 11 1 2     6 Width 3ft   6005805.491090001 2101500.8171 37.7506493670819 -122.422757545722 (37.7506493670819, -122.422757545722)
159086 221493 3 109 500x Guerrero St 13 11 1 2     2 Width 3ft   6005583.08285 2105563.4275 37.7617917972666 -122.42381549380801 (37.7617917972666, -122.423815493808)
178254 221510 3 109 1300x Guerrero St 13 11 1 2     7 Width 3ft   6005838.80296 2100921.0233299998 37.7490592658716 -122.422601154533 (37.7490592658716, -122.422601154533)
182798 221555 3 109 1000x Guerrero St 13 11 1 2     2 Width 3ft   6005738.9106 2102712.57542 37.753972818908 -122.423073906548 (37.753972818908, -122.423073906548)
4340 221479 3 109 400x Guerrero St 12 11 1 2   04/28/2015 07:46:00 PM 1 Width 3ft   6005545.66803 2106187.37905 37.7635029085615 -122.42398926890199 (37.7635029085615, -122.423989268902)
4413 221467 3 109 300x Guerrero St 12 11 1 2   06/19/2015 10:14:00 AM 1 Width 3ft   6005513.55753 2106751.9184 37.765051186799 -122.424140480012 (37.765051186799, -122.424140480012)
5127 152423 3 109 700x Guerrero St 12 11 1 2     0 Width 3ft   6005645.11359 2104396.78205 37.758591964470895 -122.423518008854 (37.7585919644709, -122.423518008854)
42667 221530 3 109 1100x Guerrero St 12 11 1 2     11 Width 3ft   6005772.5167 2102115.11175 37.75233421815221 -122.422915228372 (37.7523342181522, -122.422915228372)
47104 221492 3 109 500x Guerrero St 12 11 1 2     2 Width 3ft   6005579.45797 2105601.3239599997 37.761895647375205 -122.42383072560301 (37.7618956473752, -122.423830725603)
48680 221505 3 109 600x Guerrero St 12 11 1 2     2 Width 3ft   6005615.32825 2104975.43597 37.760179131174795 -122.423662162075 (37.7601791311748, -122.423662162075)
76663 221554 3 109 1000x Guerrero St 12 11 1 2     4 Width 3ft   6005736.5559 2102753.56312 37.754085228758505 -122.423084962814 (37.7540852287585, -122.423084962814)
94846 110770 3 109 300X GUERRERO ST 12 11 1 2   06/19/2015 10:14:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
110419 109704 3 109 600x GUERRERO ST 12 11 1 2   02/28/2015 10:40:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
118657 115521 3 109 200x Guerrero St 12 11 1 2           6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
120306 110649 3 109 400X GUERRERO ST 12 11 1 2   04/28/2015 07:46:00 PM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
134894 221423 3 109 800x Guerrero St 12 11 1 2     6 Width 3ft   6005658.05131 2104209.2390900003 37.7580777456208 -122.42345993152901 (37.7580777456208, -122.423459931529)
139744 110783 3 109 1000X GUERRERO ST 12 11 1 2   05/26/2015 02:16:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
151374 221444 3 109 200x Guerrero St 12 11 1 2     1 Width 3ft   6005482.048359999 2107327.01142 37.766628476241294 -122.42429036821301 (37.7666284762413, -122.424290368213)
159995 221439 3 109 100x Guerrero St 12 11 1 2     1 Width 3ft   6005446.76573 2108031.65533 37.768561267704705 -122.424462530821 (37.7685612677047, -122.424462530821)
182320 221521 3 109 1200x Guerrero St 12 11 1 2     7 Width 3ft   6005805.669319999 2101529.55059 37.7507282726947 -122.422758971142 (37.7507282726947, -122.422758971142)
4316 221478 3 109 400x Guerrero St 11 11 1 2   04/29/2015 05:18:00 AM 1 Width 3ft   6005544.06849 2106215.1538 37.763579081143604 -122.423996776447 (37.7635790811436, -122.423996776447)
4319 221466 3 109 300x Guerrero St 11 11 1 2   06/19/2015 10:17:00 AM 2 Width 3ft   6005511.21858 2106780.74139 37.7651301958204 -122.42415061986601 (37.7651301958204, -122.424150619866)
4362 221445 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 1 Width 3ft   6005479.31495 2107369.2041700003 37.7667441731271 -122.424302823815 (37.7667441731271, -122.424302823815)
4487 221504 3 109 600x Guerrero St 11 11 1 2   02/21/2015 11:05:00 PM 2 Width 3ft   6005611.75297 2105011.45268 37.7602778227802 -122.42367708812901 (37.7602778227802, -122.423677088129)
5168 152422 3 109 700x Guerrero St 11 11 1 2     0 Width 3ft   6005644.9376300005 2104427.7274700003 37.7586769234173 -122.423520817442 (37.7586769234173, -122.423520817442)
32093 221522 3 109 1200x Guerrero St 11 11 1 2     18 Width 3ft   6005804.6365 2101559.54048 37.750810559762705 -122.42276467376999 (37.7508105597627, -122.42276467377)
68227 221553 3 109 1000x Guerrero St 11 11 1 2     3 Width 3ft   6005734.111409999 2102791.4847 37.7541892146839 -122.42309611170799 (37.7541892146839, -122.423096111708)
75610 221438 3 109 100x Guerrero St 11 11 1 2     2 Width 3ft   6005446.19377 2108068.2932700003 37.7686618344154 -122.42446711555901 (37.7686618344154, -122.424467115559)
86005 110628 3 109 400X GUERRERO ST 11 11 1 2   04/29/2015 05:18:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
94270 110769 3 109 300X GUERRERO ST 11 11 1 2   06/19/2015 10:17:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
97329 115520 3 109 200x Guerrero St 11 11 1 2   02/09/2016 10:50:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
106423 109703 3 109 600x GUERRERO ST 11 11 1 2   02/21/2015 11:05:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
121580 110782 3 109 1000X GUERRERO ST 11 11 1 2   05/26/2015 02:21:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
150449 221531 3 109 1100x Guerrero St 11 11 1 2     0 Width 3ft   6005769.92765 2102140.767 37.7524045154572 -122.422926004956 (37.7524045154572, -122.422926004956)
179323 221491 3 109 500x Guerrero St 11 11 1 2     1 Width 3ft   6005578.642000001 2105634.14294 37.7619857144891 -122.423835881448 (37.7619857144891, -122.423835881448)
185178 221511 3 109 1300x Guerrero St 11 11 1 2     6 Width 3ft   6005835.54562 2100976.57743 37.749211620932606 -122.422616365666 (37.7492116209326, -122.422616365666)
773 221437 3 109 100x Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.3361400003 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027)
3111 118355 3 109 100X Guerrero St 10 11 1 2   07/15/2016 06:48:00 AM 3              
4359 221446 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 1 Width 3ft   6005477.30623 2107402.8649 37.7668364840384 -122.424312165974 (37.7668364840384, -122.424312165974)
4384 221465 3 109 300x Guerrero St 10 11 1 2   06/19/2015 10:21:00 AM 2 Width 3ft   6005511.348730001 2106807.4282299997 37.76520347889029 -122.42415206777599 (37.7652034788903, -122.424152067776)
4419 221477 3 109 400x Guerrero St 10 11 1 2   04/29/2015 05:29:00 AM 1 Width 3ft   6005543.73868 2106251.90953 37.763679985054495 -122.424000531101 (37.7636799850545, -122.424000531101)
4517 221503 3 109 600x Guerrero St 10 11 1 2   02/21/2015 11:06:00 PM 2 Width 3ft   6005610.53101 2105047.42068 37.7603765134773 -122.423683871708 (37.7603765134773, -122.423683871708)
5113 152421 3 109 700x Guerrero St 10 11 1 2     0 Width 3ft   6005642.99765 2104457.73967 37.7587592203909 -122.42352966049 (37.7587592203909, -122.42352966049)
66900 221490 3 109 500x Guerrero St 10 11 1 2     3 Width 3ft   6005576.38505 2105666.63585 37.7620748049423 -122.423845997918 (37.7620748049423, -122.423845997918)
81226 110627 3 109 400X GUERRERO ST 10 11 1 2   04/29/2015 05:29:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
102576 110781 3 109 1000X GUERRERO ST 10 11 1 2   05/26/2015 02:26:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
105592 115519 3 109 200x Guerrero St 10 11 1 2   02/09/2016 11:45:00 AM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
126939 110768 3 109 300X GUERRERO ST 10 11 1 2   06/19/2015 10:21:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
144040 109702 3 109 600x GUERRERO ST 10 11 1 2   02/21/2015 11:06:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
159464 221532 3 109 1100x Guerrero St 10 11 1 2     8 Width 3ft   6005770.103999999 2102168.30473 37.7524801376575 -122.42292735211201 (37.7524801376575, -122.422927352112)
174460 221422 3 109 800x Guerrero St 10 11 1 2     6 Width 3ft   6005661.88318 2104154.96713 37.7579289437835 -122.42344282103001 (37.7579289437835, -122.42344282103)
176544 221552 3 109 1000x Guerrero St 10 11 1 2     3 Width 3ft   6005734.10722 2102815.94179 37.754256367947704 -122.423097864468 (37.7542563679477, -122.423097864468)
182868 221512 3 109 1300x Guerrero St 10 11 1 2     7 Width 3ft   6005835.43443 2101000.02463 37.749275995297296 -122.422618416129 (37.7492759952973, -122.422618416129)
737 221436 3 109 100x Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.768836694985396 -122.424492330751 (37.7688366949854, -122.424492330751)
4215 118354 3 109 100X Guerrero St 9 11 1 2   07/15/2016 06:05:00 AM 3              
4334 221464 3 109 300x Guerrero St 9 11 1 2   06/19/2015 10:25:00 AM 2 Width 3ft   6005509.872909999 2106837.4843200003 37.7652859224425 -122.42415931 (37.7652859224425, -122.42415931)
4336 221476 3 109 400x Guerrero St 9 11 1 2   04/29/2015 09:37:00 AM 1 Width 3ft   6005539.0927099995 2106307.4884599997 37.7638323293302 -122.42402055271799 (37.7638323293302, -122.424020552718)
4348 221447 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 1 Width 3ft   6005477.00515 2107432.0079200002 37.7669164868187 -122.424315280345 (37.7669164868187, -122.424315280345)
4481 221502 3 109 600x Guerrero St 9 11 1 2   02/21/2015 11:07:00 PM 2 Width 3ft   6005607.7078 2105081.85863 37.760470912626296 -122.42369608451 (37.7604709126263, -122.42369608451)
5118 152420 3 109 700x Guerrero St 9 11 1 2     0 Width 3ft   6005641.8915099995 2104501.69931 37.7588798608311 -122.42353661133998 (37.7588798608311, -122.42353661134)
41002 221513 3 109 1300x Guerrero St 9 11 1 2     7 Width 3ft   6005831.83209 2101056.03846 37.7494295931996 -122.42263485302799 (37.7494295931996, -122.422634853028)
51561 221489 3 109 500x Guerrero St 9 11 1 2     2 Width 3ft   6005574.236269999 2105711.57302 37.7621980705008 -122.423856625205 (37.7621980705008, -122.423856625205)
81262 110626 3 109 400X GUERRERO ST 9 11 1 2   04/29/2015 09:37:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
86793 115518 3 109 200x Guerrero St 9 11 1 2   02/09/2016 12:33:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
107320 109701 3 109 600x GUERRERO ST 9 11 1 2   02/21/2015 11:07:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
116936 110767 3 109 300X GUERRERO ST 9 11 1 2   06/19/2015 10:25:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
124792 110780 3 109 1000X GUERRERO ST 9 11 1 2   05/26/2015 02:30:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
143107 221551 3 109 1000x Guerrero St 9 11 1 2     2 Width 3ft   6005731.5319 2102850.00284 37.7543497463656 -122.423109191463 (37.7543497463656, -122.423109191463)
155282 221421 3 109 800x Guerrero St 9 11 1 2     7 Width 3ft   6005663.971419999 2104121.3615 37.7578367884406 -122.42343320997499 (37.7578367884406, -122.423433209975)
188083 221533 3 109 1100x Guerrero St 9 11 1 2     8 Width 3ft   6005767.42939 2102227.70946 37.75264309841 -122.422940823082 (37.75264309841, -122.422940823082)
727 221435 3 109 100x Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.768908269319795 -122.424501499347 (37.7689082693198, -122.424501499347)
1879 221463 3 109 300x Guerrero St 8 11 1 2   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.42417958883301 (37.7654588242817, -122.424179588833)
2766 118353 3 109 100X Guerrero St 8 11 1 2   07/15/2016 05:58:00 AM 3              
4326 221448 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 1 Width 3ft   6005473.21673 2107488.5662700003 37.767071568632105 -122.42433240701 (37.7670715686321, -122.42433240701)
4412 221475 3 109 400x Guerrero St 8 11 1 2   04/29/2015 10:13:00 AM 1 Width 3ft   6005538.26376 2106334.58706 37.763906688864495 -122.42402534700001 (37.7639066888645, -122.424025347)
4526 221501 3 109 600x Guerrero St 8 11 1 2   02/21/2015 11:08:00 PM 2 Width 3ft   6005604.17413 2105138.97106 37.7606275304574 -122.423712366728 (37.7606275304574, -122.423712366728)
5122 152419 3 109 700x Guerrero St 8 11 1 2     0 Width 3ft   6005637.900330001 2104551.94757 37.7590176055009 -122.423553987148 (37.7590176055009, -122.423553987148)
25270 221523 3 109 1200x Guerrero St 8 11 1 2     7 Width 3ft   6005797.77147 2101666.82906 37.751104762181 -122.42279603761101 (37.751104762181, -122.422796037611)
38301 221488 3 109 500x Guerrero St 8 11 1 2     2 Width 3ft   6005571.71667 2105739.51079 37.7622746387822 -122.42386732621999 (37.7622746387822, -122.42386732622)
73212 221514 3 109 1300x Guerrero St 8 11 1 2     8 Width 3ft   6005830.22915 2101083.18072 37.7495040291878 -122.42264232458 (37.7495040291878, -122.42264232458)
80319 115517 3 109 200x Guerrero St 8 11 1 2   02/09/2016 12:52:00 PM 3     6005415.2 2107753.5 37.767795737129205 -122.424551925681 (37.7677957371292, -122.424551925681)
81008 110625 3 109 400X GUERRERO ST 8 11 1 2   04/29/2015 10:13:00 AM 3 3x3   6005439.0 2106552.0 37.7644980484366 -122.42438413571101 (37.7644980484366, -122.424384135711)
92681 109700 3 109 600x GUERRERO ST 8 11 1 2   02/21/2015 11:08:00 PM 3 3x3   6005435.8 2105392.6 37.7613144297161 -122.42431273662201 (37.7613144297161, -122.424312736622)
93547 110779 3 109 1000X GUERRERO ST 8 11 1 2   05/26/2015 02:35:00 PM 3 3x3   6005663.0 2103080.0 37.7549773975701 -122.423362541701 (37.7549773975701, -122.423362541701)
99866 110766 3 109 300X GUERRERO ST 8 11 1 2   06/19/2015 10:29:00 AM 3 3x3   6005492.0 2106949.0 37.7655911088206 -122.424229059984 (37.7655911088206, -122.424229059984)
147617 221420 3 109 800x Guerrero St 8 11 1 2     5 Width 3ft   6005663.71373 2104068.90036 37.7576927278639 -122.423430371709 (37.7576927278639, -122.423430371709)
Powered by Datasette · Query took 6.128ms · Data source: data.sfgov.org