sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10 122670 1 8 301x Hickory St 3 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
519 6766 3 8 1275 Fairfax Ave 11 1 1 2   04/10/2017 01:39:00 PM 3 3x3   6017299.75412 2096896.40625 37.7386484107882 -122.38268866835199 (37.7386484107882, -122.382688668352)
1173 190143 3 8 1200 Fairfax Ave 7 4 1 2   03/18/2017 10:47:00 AM 3 Width 4ft   6017523.521480001 2096815.65975 37.738439056714704 -122.381909364434 (37.7384390567147, -122.381909364434)
1275 4132 1 8 3550 Cesar Chavez St 3 1 1 2   05/09/2017 12:00:00 AM 3 3x3   6006390.9849 2100603.33536 37.7482181038931 -122.420669151754 (37.7482181038931, -122.420669151754)
1278 231178 2 8 3298 Cesar Chavez St 1 1 1 2   05/09/2017 12:00:00 AM 3 3x6   6007881.72523 2100615.5936 37.7483356677609 -122.41551506969101 (37.7483356677609, -122.415515069691)
1280 231193 2 8 3400 Cesar Chavez St 2 1 1 2   05/09/2017 12:00:00 AM 3 3x6   6007038.27508 2100609.92371 37.7482726540762 -122.41843130396799 (37.7482726540762, -122.418431303968)
1281 231175 2 8 3100 Cesar Chavez St 1 1 1 2   05/09/2017 12:00:00 AM 3 4x4   6008989.553669999 2100618.8922900003 37.7484069327314 -122.41168444520599 (37.7484069327314, -122.411684445206)
1296 231177 2 8 3200 Cesar Chavez St 2 1 1 2     3 Width 3ft   6008330.40398 2100615.02413 37.7483593136265 -122.41396350442 (37.7483593136265, -122.41396350442)
1302 4080 3 8 3200X Cesar Chavez St 4 1 1 2   05/09/2017 12:00:00 AM 3 3X6   6008284.97439 2100614.30528 37.7483547882437 -122.414120548517 (37.7483547882437, -122.414120548517)
1304 231176 2 8 3100 Cesar Chavez St 2 1 1 2     3 4x4   6008965.15097 2100617.87341 37.7484027661782 -122.411768757547 (37.7484027661782, -122.411768757547)
1308 231174 2 8 3092 Cesar Chavez St 1 1 1 2     3 Width 3ft   6009165.99895 2100621.73745 37.7484246412851 -122.411074499805 (37.7484246412851, -122.411074499805)
1411 183698 1 8 1341 42nd Ave 12 1 1 1     3 Width 0ft   5983051.8246 2105805.0517 37.761157531744104 -122.501758745065 (37.7611575317441, -122.501758745065)
2109 114982 2 8 178 Cervantes Blvd 1 1 1 1     3 3x3 Permit Number 777197 6001108.037930001 2121318.19726 37.804796720156396 -122.440422811758 (37.8047967201564, -122.440422811758)
4301 139643 2 8 1100 DIVISADERO ST 3 1 1 1   10/10/2017 09:46:00 AM 3 Width 0ft   6001420.8793 2112266.7216 37.779961529168204 -122.43869120897 (37.7799615291682, -122.43869120897)
4646 160597 2 8 766 Vienna St 1 1 1 1 1 10/18/2017 01:25:00 PM 3 Width 0ft   6002414.55284 2089084.1537799998 37.716364146664205 -122.433596398053 (37.7163641466642, -122.433596398053)
4650 160596 2 8 762 Vienna St 1 1 1 1 1 10/18/2017 01:30:00 PM 3 Width 0ft   6002428.15191 2089106.63112 37.71642663607071 -122.43355099850599 (37.7164266360707, -122.433550998506)
4743 148019 2 8 605 Italy Ave 1 1 1 1 1 10/25/2017 12:12:00 PM 3 Width 3ft   6002175.19846 2088993.45658 37.7161015284444 -122.43441724168301 (37.7161015284444, -122.434417241683)
4744 161281 2 8 587 Naples St 1 1 1 1 1 10/25/2017 12:04:00 PM 3 Width 0ft   6002852.8609 2090206.41919 37.719470499446395 -122.432161491969 (37.7194704994464, -122.432161491969)
4749 161284 2 8 567 Naples St 1 1 1 1 1 10/25/2017 03:30:00 PM 3 Width 0ft   6002918.80865 2090311.02788 37.7197614706043 -122.43194100068199 (37.7197614706043, -122.431941000682)
4766 161282 2 8 579 Naples St 1 1 1 1 1 10/25/2017 03:28:00 PM 3 Width 0ft   6002876.7147 2090246.5176400002 37.7195819533337 -122.432081900155 (37.7195819533337, -122.432081900155)
4780 161285 2 8 523 Naples St 1 1 1 1   10/25/2017 03:51:00 PM 3 Width 0ft   6003073.26111 2090557.89007 37.7204480544147 -122.431424726881 (37.7204480544147, -122.431424726881)
4828 161283 2 8 571 Naples St 1 1 1 1 1 10/25/2017 03:40:00 PM 3 Width 0ft   6002905.32345 2090290.85572 37.719705317820896 -122.431986174531 (37.7197053178209, -122.431986174531)
11197 122672 1 8 301x Hickory St 5 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
13318 187687 1 8 399X Ash St 1 1 1 1   02/27/2017 12:00:00 AM 3              
13330 187688 1 8 399X Ash St 2 1 1 1   02/27/2017 12:00:00 AM 3              
13333 187689 1 8 399X Ash St 3 1 1 1   02/27/2017 12:00:00 AM 3              
13561 44761 1 8 761 Tehama St 4 1 1 1   12/23/2014 12:00:00 AM 3   Permit Number 773697 6009135.35285 2110344.07901 37.775118251745 -122.411867394277 (37.775118251745, -122.411867394277)
16083 30613 1 8 1286 Folsom St 1 1 1 1 1 02/24/2016 12:00:00 AM 3   Permit Number 775151 6009246.0909 2109942.5257 37.774021892488 -122.411455949977 (37.774021892488, -122.411455949977)
16583 44760 1 8 761 Tehama St 3 1 1 1   12/23/2014 12:00:00 AM 3 3x3 Permit Number 773697 6009127.693419999 2110338.43035 37.7751023121433 -122.41189349079399 (37.7751023121433, -122.411893490794)
17477 4067 3 8 3096 Cesar Chavez St 1 1 1 2   04/01/1995 12:00:00 AM 3 3X3   6009129.76815 2100619.82183 37.7484173495801 -122.411199650344 (37.7484173495801, -122.411199650344)
18308 122668 1 8 301x Hickory St 1 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
18309 122669 1 8 301x Hickory St 2 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
18311 122671 1 8 301x Hickory St 4 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
18313 122673 1 8 301x Hickory St 6 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
18322 122675 1 8 301x Hickory St 8 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
18323 122674 1 8 301x Hickory St 7 1 1 1   11/10/2016 12:00:00 AM 3 3X3            
19563 109843 2 8 431 PIERCE ST 3 1 1 1   04/06/2015 12:00:00 AM 3 4x4 Permit Number 774456 6002625.0 2110137.0 37.7741822723418 -122.434373313194 (37.7741822723418, -122.434373313194)
21978 4079 3 8 3200X Cesar Chavez St 3 1 1 2   01/06/1998 12:00:00 AM 3 3X3   6008309.37499 2100615.3209700002 37.7483589476023 -122.414036243399 (37.7483589476023, -122.414036243399)
23301 26453 3 8 401X Keith St 1 1 1 2   06/04/1998 12:00:00 AM 3 3X3   6017690.9643 2096738.1132099999 37.7382353746521 -122.381325031738 (37.7382353746521, -122.381325031738)
23399 248028 2 8 415 Franconia St 1 1 1 1     3 Width 3ft   6010000.45294 2098632.85848 37.7430103745335 -122.408048720871 (37.7430103745335, -122.408048720871)
24911 47896 1 8 639 Broderick St 2 1 1 1 1 06/20/2002 12:00:00 AM 3 3x3 Permit Number 45640 6001064.0564 2110917.2604 37.7762359450792 -122.439828836132 (37.7762359450792, -122.439828836132)
27036 231200 2 8 3399 Cesar Chavez St 1 1 1 1     3 Width 3ft   6007140.13481 2100524.8991799997 37.7480449295337 -122.418073048237 (37.7480449295337, -122.418073048237)
27980 192754 2 8 1195 Fairfax Ave 13 1 1 1     3 Width 3ft   6017744.167219999 2096569.5580900002 37.7377754928445 -122.381129364447 (37.7377754928445, -122.381129364447)
28778 231191 2 8 3415 Cesar Chavez St 1 1 1 1     3 Width 3ft   6006945.26425 2100523.93824 37.7480313210083 -122.418746836492 (37.7480313210083, -122.418746836492)
28990 104830 1 8 3210 Jackson St 1 1 1 1   03/31/2014 12:00:00 AM 3   Permit Number 771109 5998850.28087 2116282.3685 37.790840871551296 -122.44787320750099 (37.7908408715513, -122.447873207501)
32437 231199 2 8 3636 Cesar Chavez St 4 1 1 1     3 Width 3ft   6005923.7545 2100590.88969 37.7481575867153 -122.422283938475 (37.7481575867153, -122.422283938475)
34335 201443 2 8 50 Middle Point Rd 3 2 1 1     3 Width 5ft   6018205.670580001 2096108.31022 37.736534461697104 -122.379501674263 (37.7365344616971, -122.379501674263)
38144 201442 2 8 50 Middle Point Rd 2 2 1 1     3 Width 5ft   6018207.71631 2096124.7676 37.736579763236705 -122.37949574413601 (37.7365797632367, -122.379495744136)
42934 192765 2 8 1101 Fairfax Ave 1 1 1 1     3 Width 3ft   6017733.36726 2096290.7725799999 37.7370094071445 -122.381147327493 (37.7370094071445, -122.381147327493)
44797 94604 1 8 1045 Scott St 1 1 1 1   10/13/2010 12:00:00 AM 3 4x4 Permit Number 53774 6001884.2634 2112097.0876 37.7795221073771 -122.437076010522 (37.7795221073771, -122.437076010522)
46523 192762 2 8 1151 Fairfax Ave 16 1 1 1     3 Width 3ft   6017784.77544 2096401.4066 37.7373160238005 -122.380977273785 (37.7373160238005, -122.380977273785)
54248 130425 2 8 842 Sansome St 2 10 1 1     3 Width 3ft   6012127.88855 2118699.30676 37.7982271771027 -122.402103014136 (37.7982271771027, -122.402103014136)
61814 192768 2 8 1101 Fairfax Ave 5 1 1 1     3 Width 3ft   6017764.14104 2096144.7820599999 37.736610244861005 -122.381030780757 (37.736610244861, -122.381030780757)
63205 98683 1 8 5224 California St 1 1 1 1   03/07/2012 12:00:00 AM 3   Permit Number 768705 5991362.651930001 2114124.744 37.784485814122895 -122.473622344489 (37.7844858141229, -122.473622344489)
67276 192760 2 8 1151 Fairfax Ave 13 1 1 1     3 Width 3ft   6017794.54346 2096459.61932 37.7374764035002 -122.38094754671002 (37.7374764035002, -122.38094754671)
69231 192786 2 8 1190 Fairfax Ave 17 1 1 1     3 Width 3ft   6017834.847490001 2096507.59848 37.737610369220704 -122.380811529649 (37.7376103692207, -122.380811529649)
70120 231143 2 8 2857 Cesar Chavez St 1 1 1 1     3 Width 3ft   6010376.44019 2100661.4980599997 37.7486016206723 -122.406891600982 (37.7486016206723, -122.406891600982)
71342 201450 2 8 96 Middle Point Rd 5 2 1 1     3 Width 7ft   6018200.75737 2095847.6313 37.735818417881106 -122.379500558206 (37.7358184178811, -122.379500558206)
72915 208528 2 8 2574 15th Ave 1 1 1 1     3 Width 3ft   5991762.28899 2097924.21103 37.7400265849559 -122.471059114781 (37.7400265849559, -122.471059114781)
73243 192759 2 8 1151 Fairfax Ave 12 1 1 1     3 Width 3ft   6017794.14245 2096468.18892 37.7374999117835 -122.380949528801 (37.7374999117835, -122.380949528801)
73257 192778 2 8 1190 Fairfax Ave 1 1 1 1     3 Width 3ft   6017805.41834 2096342.2173900001 37.7371546413706 -122.380901787387 (37.7371546413706, -122.380901787387)
73678 208533 2 8 1245 10th Ave 1 1 1 1     3 Width 5ft   5992969.96959 2106979.3295 37.764959381307605 -122.467541820422 (37.7649593813076, -122.467541820422)
76446 231198 2 8 3636 Cesar Chavez St 3 1 1 1     3 Width 3ft   6005940.89889 2100590.84766 37.748158438366794 -122.42222465067199 (37.7481584383668, -122.422224650672)
76773 31146 1 8 500 Hearst Ave 1 1 1 1 1 03/21/1995 12:00:00 AM 3   Permit Number 34853 5998061.9745 2094408.9527900002 37.73073687780529 -122.44902432803002 (37.7307368778053, -122.44902432803)
79302 4285 3 8 4310X Cesar Chavez St 1 1 1 2   04/07/1995 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
79730 99039 3 8 200X Bartlett St 13 1 1 4 2   3 3x3   6006692.0 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314)
85368 107344 1 8 390 28th Ave 1 1 1 1   01/24/2015 12:00:00 AM 3   Permit Number 774019 5987178.52527 2113313.79878 37.7820159849006 -122.488038192901 (37.7820159849006, -122.488038192901)
85607 25976 3 8 2065 Oakdale Ave 7 1 1 2   02/24/2016 12:00:00 AM 3 2x3   6012647.581347 2097234.3690945 37.739318274919896 -122.398797486611 (37.7393182749199, -122.398797486611)
93389 94135 1 8 150 Peralta Ave 2 1 1 1   06/11/2010 12:00:00 AM 3 3x3 Permit Number 53499 6009988.7 2100136.6 37.7471386620606 -122.40819539283301 (37.7471386620606, -122.408195392833)
95933 109388 1 8 172X Prospect Ave 1 1 1 1 1 02/12/2015 12:00:00 AM 3 3x3 Permit Number 774502 6006834.59164 2098690.08898 37.74298975220871 -122.418999487845 (37.7429897522087, -122.418999487845)
97265 115371 2 8 86 FREDERICK ST 1 1 1 1   02/01/2016 12:00:00 AM 3 3x3   5999609.0 2107783.0 37.767547127962104 -122.444636930271 (37.7675471279621, -122.444636930271)
98004 109841 2 8 431 PIERCE ST 1 1 1 1   04/06/2015 12:00:00 AM 3 4x4 Permit Number 774456 6002625.0 2110137.0 37.7741822723418 -122.434373313194 (37.7741822723418, -122.434373313194)
98439 4287 3 8 4310X Cesar Chavez St 3 1 1 2   01/27/1998 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
102150 42215 1 8 200X Dore St 2 1 1 1 1 06/23/2000 12:00:00 AM 3 3X3 Permit Number 42481 6009422.03433075 2109152.33438426 37.7718620785354 -122.410791511353 (37.7718620785354, -122.410791511353)
105193 117299 1 8 66 Lobos St 1 1 1 1   06/06/2016 12:00:00 AM 3   Permit Number 778517 5996255.6 2088726.3 37.7150301835094 -122.454858780509 (37.7150301835094, -122.454858780509)
105713 40250 3 8 3351X 23rd St 1 1 1 4 2 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285)
113366 4172 3 8 3795 Cesar Chavez St 3 1 1 2   09/15/2014 08:17:00 AM 3 4X4   6005296.67379 2100472.2695 37.7477964909484 -122.424443928769 (37.7477964909484, -122.424443928769)
115049 108819 2 8 2850 CESAR CHAVEZ ST 1 1 1 2   01/06/2015 12:00:00 AM 3 3x3   6010441.0 2100764.0 37.7488866808005 -122.40667557539301 (37.7488866808005, -122.406675575393)
115862 108506 1 8 1351 15th Ave 1 1 1 1 1 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773651 5991435.99283 2106225.38034 37.762800554258206 -122.47279242987 (37.7628005542582, -122.47279242987)
116015 97497 2 8 1520 Jerrold Ave 1 1 1 1 1 03/03/2010 12:00:00 AM 3 3x3   6015724.7 2096772.7 37.7382215976335 -122.388125873954 (37.7382215976335, -122.388125873954)
116097 104831 1 8 3210 Jackson St 2 7 1 1     3 3x3   5998893.9 2116279.9 37.7908365867802 -122.447722110161 (37.7908365867802, -122.447722110161)
119065 98218 3 8 1501X 42nd Ave 12 1 1 10 6   3 3x25   5982958.4 2104692.7 37.758097840563 -122.50199954491 (37.758097840563, -122.50199954491)
119326 107572 1 8 390x 28th Ave 2 1 1 1   01/24/2015 12:00:00 AM 3   Permit Number 774019 5987178.05055 2113333.68134 37.782070549050395 -122.488041296595 (37.7820705490504, -122.488041296595)
124251 93970 1 8 3400 Cesar Chavez St 3 1 1 1     3 3x3 Permit Number 53400 6006959.5 2100632.2 37.7483293848143 -122.41870528613501 (37.7483293848143, -122.418705286135)
126956 109842 2 8 431 PIERCE ST 2 1 1 1   04/06/2015 12:00:00 AM 3 4x4 Permit Number 774456 6002625.0 2110137.0 37.7741822723418 -122.434373313194 (37.7741822723418, -122.434373313194)
129380 108740 1 8 114 Coleridge St   1 1 1 1 01/05/2015 12:00:00 AM 3 3x3   6006642.81745 2099018.83265 37.743881607568895 -122.419685912101 (37.7438816075689, -122.419685912101)
130082 130424 2 8 842 Sansome St 1 10 1 1     3 Width 3ft   6012129.23244 2118685.48448 37.7981892994573 -122.40209739158999 (37.7981892994573, -122.40209739159)
139970 107452 1 8 150 CARMEL ST 1 1 1 1   10/06/2014 12:00:00 AM 3 3x3 Permit Number 773425 5998064.4 2105394.7 37.760901199172295 -122.449807340042 (37.7609011991723, -122.449807340042)
146201 4286 3 8 4310X Cesar Chavez St 2 1 1 2   04/07/1995 12:00:00 AM 3 2X3   6001895.2244565 2100336.5410682997 37.747231143218606 -122.43619623965799 (37.7472311432186, -122.436196239658)
151153 130426 2 8 842 Sansome St 3 10 1 1     3 Width 3ft   6012124.42235 2118721.37553 37.7982875791671 -122.40211656062401 (37.7982875791671, -122.402116560624)
151393 192769 2 8 1101 Fairfax Ave 6 1 1 1     3 Width 3ft   6017765.0269 2096131.82631 37.736574719840796 -122.38102681746 (37.7365747198408, -122.38102681746)
153238 231179 2 8 3298 Cesar Chavez St 2 1 1 1     3 Width 3ft   6007865.21134 2100614.7853099997 37.7483325201375 -122.415572117257 (37.7483325201375, -122.415572117257)
153539 201377 2 8 100 Middle Point Rd 1 2 1 1     3 Width 10ft   6018193.606000001 2095600.54319 37.7351395682275 -122.379508124199 (37.7351395682275, -122.379508124199)
154870 192764 2 8 1151 Fairfax Ave 23 1 1 1     3 Width 3ft   6017749.0379099995 2096343.9059099997 37.737156165722105 -122.38109683956499 (37.7371561657221, -122.381096839565)
157305 92399 1 8 1919 22nd St 2 1 1 1   07/29/2009 12:00:00 AM 3 3x3 Permit Number 52800 6012333.07109 2103736.18677 37.7571533378831 -122.400341483281 (37.7571533378831, -122.400341483281)
158241 248029 2 8 415 Franconia St 2 1 1 1     3 Width 3ft   6010002.39099 2098647.04811 37.7430494446815 -122.40804302006599 (37.7430494446815, -122.408043020066)
161113 184268 2 8 3939 Kirkham St 3 1 1 1     3 Width 0ft   5982564.7762 2104878.5059 37.758584879204705 -122.503374600179 (37.7585848792047, -122.503374600179)
161142 192761 2 8 1151 Fairfax Ave 15 1 1 1     3 Width 3ft   6017790.5398699995 2096422.0287099998 37.7373729661834 -122.380958776542 (37.7373729661834, -122.380958776542)
161321 192771 2 8 1101 Fairfax Ave 9 1 1 1     3 Width 3ft   6017777.64619 2096075.2558099998 37.7364200850155 -122.38097925499201 (37.7364200850155, -122.380979254992)
162214 229202 2 8 409 Jersey St 1 1 1 1     3 Width 3ft   6002413.31573 2101482.56842 37.7504072857819 -122.434486649535 (37.7504072857819, -122.434486649535)
162712 192746 2 8 599 Keith St 18 1 1 1     3 Width 3ft   6017608.70475 2096636.8224 37.737952708754705 -122.381602405133 (37.7379527087547, -122.381602405133)
Powered by Datasette · Query took 3.751ms · Data source: data.sfgov.org