sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
11938 19762 3 97 100 STAIRWAY16 1 1 1 2     3 30ST            
11951 19967 3 97 100 STAIRWAY41 5 1 1 2     6 25ST            
78897 20969 3 97 2002X Sunset Blvd 9 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
79162 20965 3 97 2002X Sunset Blvd 5 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
109094 20967 3 97 2002X Sunset Blvd 7 1 1 2     3 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
177476 32581 1 97 1314 33rd Ave 1 1 1 1 1 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.762566049362704 -122.492024105228 (37.7625660493627, -122.492024105228)
63634 182440 2 97 1530 33rd Ave 1 1 1 1     3 Width 0ft   5985926.0511 2104791.6519 37.7585434265078 -122.49174356193998 (37.7585434265078, -122.49174356194)
148086 182304 2 97 2531 Kirkham St 4 1 1 1     3 Width 0ft   5986925.2797 2105029.7497 37.759255527351606 -122.488305322992 (37.7592555273516, -122.488305322992)
134064 206001 2 97 1830 18th Ave 1 1 1 1     16 Width 4ft   5990646.261940001 2102911.1762200003 37.7536548815855 -122.47528182930701 (37.7536548815855, -122.475281829307)
122019 205987 2 97 1639 17th Ave 1 1 1 1     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541)
171108 206012 2 97 650 Vicente St 5 1 1 1     6 Width 3ft   5990870.16608 2097736.47672 37.739459475161794 -122.474129983014 (37.7394594751618, -122.474129983014)
45525 206011 2 97 650 Vicente St 4 1 1 1     5 Width 3ft   5990881.65673 2097736.82059 37.739461084972206 -122.47409027886299 (37.7394610849722, -122.474090278863)
172191 206010 2 97 650 Vicente St 3 1 1 1     8 Width 3ft   5990906.39798 2097737.17838 37.7394635005399 -122.47400476141199 (37.7394635005399, -122.474004761412)
164290 206009 2 97 650 Vicente St 1 1 1 1     5 Width 3ft   5990946.443519999 2097737.21302 37.7394659152092 -122.47386630538 (37.7394659152092, -122.47386630538)
44285 206008 2 97 600 Vicente St 5 1 1 1     6 Width 3ft   5990990.06403 2097739.22497 37.7394739659536 -122.47371563298701 (37.7394739659536, -122.473715632987)
74726 206007 2 97 600 Vicente St 3 1 1 1     4 Width 3ft   5991032.21326 2097741.2680200003 37.739482016692904 -122.473570049822 (37.7394820166929, -122.473570049822)
150091 206006 2 97 600 Vicente St 2 1 1 1     5 Width 3ft   5991049.3393 2097743.54574 37.7394892625221 -122.473511002145 (37.7394892625221, -122.473511002145)
157059 206005 2 97 600 Vicente St 1 1 1 1     4 Width 3ft   5991064.94409 2097743.51009 37.7394900683054 -122.47345704553001 (37.7394900683054, -122.47345704553)
101854 114592 2 97 70 LOMITA AVE 2 1 1 1     6 3x3   5991433.0 2104626.0 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822)
126890 206004 2 97 10 Lomita Ave 1 1 1 1     7 Width 3ft   5991469.80126 2104851.05791 37.7590289864229 -122.472575296214 (37.7590289864229, -122.472575296214)
121279 112815 2 97 10 LOMITA AVE 1 1 1 1       3x3   5991472.0 2104830.0 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736)
186595 206002 2 97 1593 15th Ave 2 1 1 1     4 Width 3ft   5991725.37276 2104496.31776 37.758069753342205 -122.47166556633199 (37.7580697533422, -122.471665566332)
34084 206003 2 97 1593 15th Ave 1 1 1 1     4 Width 3ft   5991725.497880001 2104502.2556 37.7580860643266 -122.471665566325 (37.7580860643266, -122.471665566325)
117344 57469 1 97 71 Cerritos Ave 1 1 1 1 1 12/08/1987 12:00:00 AM     Permit Number 24965 5992451.26080169 2092911.00734917 37.7263014049972 -122.46831233823299 (37.7263014049972, -122.468312338233)
33051 123914 2 97 389 09th Ave 9 1 1 1     2 Width 3ft   5993078.53663 2112857.8084299997 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963)
132092 206014 2 97 120 San Benito Way 1 1 1 1     7 Width 3ft   5992843.12782 2095854.05613 37.7344049138512 -122.467171573123 (37.7344049138512, -122.467171573123)
54347 206013 2 97 130 San Benito Way 1 1 1 1     12 Width 3ft   5992845.13508 2095810.8192900002 37.7342863121439 -122.467161490835 (37.7342863121439, -122.467161490835)
187567 218314 2 97 437 Castenada Ave 2 2 1 1     7 Width 0ft   5993129.70143 2099920.62697 37.7455872325622 -122.466476271275 (37.7455872325622, -122.466476271275)
60183 218315 2 97 437 Castenada Ave 1 2 1 1     7 Width 0ft   5993144.55141 2099923.03964 37.7455947140337 -122.46642509806401 (37.7455947140337, -122.466425098064)
168692 205988 2 97 1469 09th Ave 1 1 1 1     15 Width 4ft   5993333.43827 2105504.18267 37.7609299931406 -122.46617747513099 (37.7609299931406, -122.466177475131)
65825 205992 2 97 452 Kenwood Way 3 1 1 1     3 Width 3ft   5993371.398019999 2093686.3141400001 37.728483309840996 -122.46518778469299 (37.728483309841, -122.465187784693)
45186 205991 2 97 452 Kenwood Way 2 1 1 1     3 Width 3ft   5993388.91946 2093682.37508 37.72847350453279 -122.465126926677 (37.7284735045328, -122.465126926677)
73260 205990 2 97 452 Kenwood Way 1 1 1 1     3 Width 3ft   5993405.09676 2093676.5167599998 37.7284583518695 -122.46507057606001 (37.7284583518695, -122.46507057606)
69557 205989 2 97 566 Dewey Blvd 3 1 1 1     5 Width 6ft   5994108.82044 2099457.01961 37.744370734026 -122.46305702188499 (37.744370734026, -122.463057021885)
176560 205994 2 97 334 Pacheco St 2 2 1 1     9 Width 3ft   5994253.11993 2101023.44894 37.7486800649323 -122.462671676761 (37.7486800649323, -122.462671676761)
154445 205993 2 97 334 Pacheco St 1 2 1 1     10 Width 3ft   5994259.77922 2101011.29176 37.7486470679175 -122.46264776740401 (37.7486470679175, -122.462647767404)
119338 113383 2 97 146 CASTENADA AVE 2 1 1 1     7 3x3   5994461.0 2101055.0 37.7487786662853 -122.46195512222401 (37.7487786662853, -122.461955122224)
34571 206020 2 97 146 Castenada Ave 1 2 1 1     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.46188794817499 (37.7487957447457, -122.461887948175)
66533 206019 2 97 99 Merced Ave 2 1 1 1     13 Width 3ft   5994816.51833 2099704.78199 37.745091768175605 -122.460627918846 (37.7450917681756, -122.460627918846)
43855 206018 2 97 99 Merced Ave 3 1 1 1     12 Width 3ft   5994828.29695 2099714.01169 37.7451177882671 -122.460587859436 (37.7451177882671, -122.460587859436)
116284 2744 1 97 1 Cabrillo St 1 1 1 1     6 3X3   5995591.7347 2110770.58853 37.775520208006604 -122.458748349075 (37.7755202080066, -122.458748349075)
32711 124322 2 97 115 Jordan Ave 1 2 1 1     8 Width 3ft   5996192.87314 2113669.7360400003 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619)
51566 124321 2 97 115 Jordan Ave 2 2 1 1     14 Width 3ft   5996193.40211 2113658.2283900003 37.783483467186706 -122.45687595100901 (37.7834834671867, -122.456875951009)
43464 206016 2 97 1500 Plymouth Ave 2 1 1 1     3 Width 3ft   5995893.6658 2094152.61505 37.7299087874515 -122.45650193453899 (37.7299087874515, -122.456501934539)
67325 206015 2 97 351 Montecito Ave 1 2 1 1     23 Width 3ft   5995922.8819 2094068.30815 37.7296789783055 -122.45639483786199 (37.7296789783055, -122.456394837862)
151522 206017 2 97 59 Hazelwood Ave 2 2 1 1     9 Width 3ft   5996580.0039099995 2094034.75678 37.72962455671671 -122.454120687124 (37.7296245567167, -122.454120687124)
91986 67186 1 97 281 Carl St 1 1 1 1 1 05/06/1992 12:00:00 AM     Permit Number 30634 5996869.12207945 2106987.0610707 37.765204956904604 -122.454056265196 (37.7652049569046, -122.454056265196)
43510 225058 2 97 283 Carl St 1 1 1 1     5 Width 3ft   5996870.764690001 2106986.93981 37.76520471814 -122.454050575073 (37.76520471814, -122.454050575073)
55625 225059 2 97 245 Carl St 1 1 1 1     20 Width 4ft   5997024.32382 2107012.23049 37.7652829636624 -122.453521279988 (37.7652829636624, -122.453521279988)
162230 225060 2 97 243 Parnassus Ave 2 1 1 1     10 Width 3ft   5997087.67897 2106671.87912 37.76435207719771 -122.453277577199 (37.7643520771977, -122.453277577199)
1249 237914 3 97 1001 Stanyan St 1 1 1 2     21 Width 4ft   5997227.0 2107052.0 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368)
129912 225061 2 97 1289 Stanyan St 1 1 1 1     8 Width 6ft   5997502.5049 2105021.0962900002 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786)
31832 222918 2 97 140 Carl St 1 1 1 1     15 Width 3ft   5997702.832359999 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974)
100270 54886 1 97 140 Carl St 1 1 1 1   08/16/1972 12:00:00 AM   3x4 Permit Number 10751 5997750.13061777 2107162.33224107 37.7657366841835 -122.45102172287201 (37.7657366841835, -122.451021722872)
53992 222919 2 97 121 Carl St 1 1 1 1     9 Width 3ft   5997880.24105 2107132.61559 37.765662537824895 -122.45056955843701 (37.7656625378249, -122.450569558437)
127787 58566 1 97 119 Carl St 1 1 1 1   04/16/1979 12:00:00 AM   3x3 Permit Number 17756 5997901.33257876 2107130.89979942 37.7656590338964 -122.450496484092 (37.7656590338964, -122.450496484092)
142476 68375 1 97 175 Alma St 1 1 1 1 1 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.76299319850379 -122.45048498278999 (37.7629931985038, -122.45048498279)
68238 222920 2 97 957 Cole St 1 1 1 1     13 Width 4ft   5998076.5165 2106905.9783799998 37.765051481758 -122.449874352843 (37.765051481758, -122.449874352843)
177491 222921 2 97 957 Cole St 2 1 1 1     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.44986610424601 (37.7649946607859, -122.449866104246)
59009 206021 2 97 42 Stanford Heights Ave 1 1 1 1     13 Width 3ft   5997867.55836 2095818.65061 37.7345964514605 -122.449798003996 (37.7345964514605, -122.449798003996)
71127 222923 2 97 88 Parnassus Ave 2 1 1 1     14 Width 4ft   5998162.74598 2106870.63901 37.764959382183704 -122.449573561064 (37.7649593821837, -122.449573561064)
35330 125967 2 97 3440 Clay St 1 1 1 1     11 Width 6ft   5998347.68841 2115559.3339299997 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485)
42030 206000 2 97 419 Flood Ave 3 9 1 1     7     5997987.32263 2094070.28162 37.729802697139604 -122.44925801953801 (37.7298026971396, -122.449258019538)
124297 59670 1 97 98X PARNASSUS AVE 3 1 1 1 1 08/09/1993 12:00:00 AM 15 3x3 Permit Number 32228 5998297.0 2106864.0 37.76494883262271 -122.449108733904 (37.7649488326227, -122.449108733904)
120218 51670 1 97 848 Clayton St 1 1 1 1         Permit Number 47948 5998713.82301338 2107188.47532501 37.765863591183 -122.44769041413299 (37.765863591183, -122.447690414133)
27876 222922 2 97 848 Clayton St 1 1 1 1     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315)
35726 222928 2 97 912 Clayton St 2 1 1 1     11 Width 4ft   5998758.16977 2106859.07637 37.764961679071796 -122.447513315894 (37.7649616790718, -122.447513315894)
140677 56842 1 97 910 Clayton St 1 1 1 1 1 04/29/1992 12:00:00 AM 3   Permit Number 30536 5998759.08975741 2106864.1829233 37.76497575295679 -122.447510501506 (37.7649757529568, -122.447510501506)
90392 67184 1 97 912 Clayton St 1 1 1 1 1 05/06/1992 12:00:00 AM     Permit Number 30631 5998760.11857013 2106856.81248154 37.7649555743728 -122.447506412542 (37.7649555743728, -122.447506412542)
133409 222927 2 97 912 Clayton St 1 1 1 1     8 Width 4ft   5998760.527480001 2106841.60616 37.764913845009 -122.44750390358 (37.764913845009, -122.44750390358)
81979 56848 1 97 1025 Clayton St 1 1 1 1   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.763644027141396 -122.447272227776 (37.7636440271414, -122.447272227776)
174584 222924 2 97 1025 Clayton St 1 1 1 1     12 Width 4ft   5998822.080680001 2106365.6721900003 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019)
92019 94581 1 97 1025 Clayton St 2 1 1 1       4x4   5998825.0 2106371.0 37.763625362932 -122.44724703752199 (37.763625362932, -122.447247037522)
23379 222925 2 97 1025 Clayton St 2 1 1 1     12 Width 4ft   5998825.08997 2106348.09575 37.763562478748604 -122.44724507779499 (37.7635624787486, -122.447245077795)
97514 56845 1 97 980 Clayton St 1 1 1 1   08/02/1974 12:00:00 AM   4x4 Permit Number 14078 5998833.42862215 2106621.08669964 37.7643125198309 -122.447235885769 (37.7643125198309, -122.447235885769)
174435 222926 2 97 980 Clayton St 1 1 1 1     11 Width 4ft   5998842.04298 2106555.36385 37.7641325536076 -122.447201360861 (37.7641325536076, -122.447201360861)
163059 225062 2 97 139 Downey St 1 1 1 1     10 Width 3ft   5998883.5307 2107364.0663900003 37.76635541778779 -122.44711607094601 (37.7663554177878, -122.447116070946)
167323 225063 2 97 247 Downey St 1 1 1 1     4 Width 3ft   5998979.478759999 2106681.18548 37.7644858801306 -122.44673506598998 (37.7644858801306, -122.44673506599)
185355 225064 2 97 253 Downey St 1 1 1 1     4 Width 3ft   5998981.0777900005 2106664.05961 37.7644389481338 -122.446728303069 (37.7644389481338, -122.446728303069)
174545 205998 2 97 30 Molimo Dr 4 1 1 1     7 Width 2ft   5998781.20203 2096512.5772400002 37.736554040821204 -122.446689155601 (37.7365540408212, -122.446689155601)
57071 205997 2 97 30 Molimo Dr 3 1 1 1     7 Width 2ft   5998801.07075 2096511.7970599998 37.736553033585295 -122.446620405109 (37.7365530335853, -122.446620405109)
127952 82121 1 97 44 Molimo Dr 1 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.44659355011801 (37.7365973852663, -122.446593550118)
45915 205996 2 97 30 Molimo Dr 2 1 1 1     5 Width 2ft   5998822.4881 2096514.65172 37.736562095172296 -122.446546561796 (37.7365620951723, -122.446546561796)
157892 205995 2 97 30 Molimo Dr 1 1 1 1     6 Width 2ft   5998862.6525 2096533.61775 37.7366164654663 -122.446409060855 (37.7366164654663, -122.446409060855)
20488 82142 1 97 30 Molimo Dr 2 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
106363 82092 1 97 30 Molimo Dr 4 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
111792 82143 1 97 30 Molimo Dr 1 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
113829 82141 1 97 30 Molimo Dr 3 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355)
161602 225042 2 97 979 Ashbury St 2 1 1 1     10 Width 4ft   5999193.16537 2106656.55415 37.764430453131105 -122.44599421345801 (37.7644304531311, -122.445994213458)
3892 222929 1 97 979 Ashbury St 1 1 1 1   03/21/1979 12:00:00 AM 10 Width 4ft Permit Number 17592 5999199.8898 2106672.6396 37.7644750037296 -122.445972112616 (37.7644750037296, -122.445972112616)
155584 138737 2 97 2945 BUSH ST 1 1 1 1     5 Width 0ft   5999415.669 2114277.6236 37.7853686673978 -122.44577276106199 (37.7853686673978, -122.445772761062)
185909 57320 1 97 2728 Sutter St 1 1 1 1   08/31/1976 12:00:00 AM 15   Permit Number 16145 5999531.6355 2114001.5838 37.7846173544843 -122.445351698652 (37.7846173544843, -122.445351698652)
142096 10409 3 97 1398 HAIGHT ST 2 1 1 2     24 3x3   5999436.0 2108778.0 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847)
135516 247504 2 97 1398 Haight St 1 1 1 1     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.44514278745399 (37.7703040400286, -122.445142787454)
169707 57317 1 97 2706 Sutter St 1 1 1 1   08/31/1976 12:00:00 AM 13   Permit Number 16141 5999606.4685 2114016.4513 37.7846624482509 -122.44509387174801 (37.7846624482509, -122.445093871748)
40687 57316 1 97 1515 Lyon St 1 1 1 1   08/31/1976 12:00:00 AM 13   Permit Number 16140 5999629.2653 2114178.0114 37.7851073514303 -122.445026621162 (37.7851073514303, -122.445026621162)
39980 30908 1 97 1511 Lyon St 1 1 1 1   03/13/1995 12:00:00 AM 7   Permit Number 34730 5999634.2212 2114153.2322 37.7850395970423 -122.44500769339199 (37.7850395970423, -122.445007693392)
65703 138239 2 97 1509 Lyon St 1 1 1 1     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871)
65381 138240 2 97 1509 Lyon St 2 1 1 1     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243)
47133 138241 2 97 1509 Lyon St 3 1 1 1     11 Width 0ft   5999646.1152 2114082.8594 37.784847050450104 -122.444961483404 (37.7848470504501, -122.444961483404)
25551 138242 2 97 1509 Lyon St 4 1 1 1     8 Width 0ft   5999647.1063 2114070.9654 37.7848144491807 -122.444957199215 (37.7848144491807, -122.444957199215)
Powered by Datasette · Query took 6.219ms · Data source: data.sfgov.org