sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
116973 108643 2 17 315X PACIFIC AVE 1 1 1 1 15     3x3   6012408.6 2118423.0 37.7974841688946 -122.40111223755501 (37.7974841688946, -122.401112237555)
111940 105173 2 2 1601X NEWCOMB AVE 2 1 1 16 14   13 4x4 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074)
144922 110534 2 22 100X ASHBURY ST 2 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
126853 110533 2 11 100X ASHBURY ST 1 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
125707 110537 2 17 100X ASHBURY ST 5 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
121101 110540 2 22 100X ASHBURY ST 8 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
99848 110538 2 17 100X ASHBURY ST 6 1 1 10 13     3x3   5998750.0 2110223.0 37.7741976920008 -122.447783765196 (37.7741976920008, -122.447783765196)
117298 108904 1 13 565 Banks St 1 1 1 1 12 01/09/2015 12:00:00 AM 3 3x3 Permit Number 772986 6008567.7 2096169.9 37.7361673058735 -122.41282871497101 (37.7361673058735, -122.412828714971)
112977 118285 2 12 199X JULES AVE 1 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
112534 108521 1 120 1969 17th Ave 1 1 1 1 12 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773668 5990944.21476 2102008.8699 37.751194650539205 -122.47418561882401 (37.7511946505392, -122.474185618824)
80969 108934 1 49 361 Elsie St 1 1 1 1 12 01/12/2015 12:00:00 AM 3 3x3 Permit Number 774685 6006490.6 2097118.7 37.7386556931549 -122.42007742591001 (37.7386556931549, -122.42007742591)
62495 118286 2 12 199X JULES AVE 2 1 1 1 12     3x3   5994418.0 2091201.0 37.7217195365393 -122.461389557582 (37.7217195365393, -122.461389557582)
143269 108106 2 43 1990X Laguna St 1 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
136121 106963 2 44 2728 Union St 2 1 1 1 11   14     5999920.02374 2118149.14648 37.7960276377095 -122.444306168018 (37.7960276377095, -122.444306168018)
121707 108254 2 19 1798X Washington St 1 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
120202 108107 2 43 1990X Laguna St 2 1 1 1 11         6004838.0 2115780.0 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027)
112717 108257 2 19 1798X Washington St 4 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
105668 108258 2 19 1798X Washington St 5 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
98097 108256 2 19 1798X Washington St 3 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
97433 107716 2 17 2400X 25th Ave 2 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
92163 108259 2 19 1798X Washington St 6 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
80890 108255 2 19 1798X Washington St 2 5 1 1 11     2x2   6006327.679880001 2116970.1583 37.7931539244622 -122.422050592495 (37.7931539244622, -122.422050592495)
50491 107717 2 17 2400X 25th Ave 3 1 2 1 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
164897 104619 2 21 800 Folsom St 2 1 1 1 10   7 4x4 Permit Number 770959 6012190.226 2112753.6665 37.781905333235294 -122.401469228728 (37.7819053332353, -122.401469228728)
151790 104620 2 21 800 Folsom St 3 1 1 1 10   10 4x4 Permit Number 770959 6012183.3573 2112747.2558 37.7818873476901 -122.401492540712 (37.7818873476901, -122.401492540712)
145040 104625 2 21 250 04th St 3 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
144668 110414 2 19 419X 18TH AVE 15 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
140020 104622 2 21 266-286X 04th St 2 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
132930 110400 2 60 419X 18th Ave 1 1 1 10 10   28 3x3   5990269.5497 2112500.03817 37.77996145844129 -122.477285287094 (37.7799614584413, -122.477285287094)
125272 110420 2 20 419X 18TH AVE 18 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
121695 111379 2 3 301x OCEAN AVE 1 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
115819 110406 2 19 419X 18TH AVE 7 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
113498 104624 2 21 250 04th St 2 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
108530 110402 2 19 419X 18TH AVE 3 1 1 10 10     3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
107894 111381 2 3 301x OCEAN AVE 3 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
101265 110403 2 256 419X 18TH AVE 4 1 1 10 10   22 3x3   5990240.0 2112557.0 37.7801161452828 -122.477391675869 (37.7801161452828, -122.477391675869)
95314 104621 2 21 266-286X 04th St 1 1 1 1 10     4x4 Permit Number 770959 6012142.0 2112916.0 37.7823483723512 -122.401647482717 (37.7823483723512, -122.401647482717)
90733 104623 2 21 250 04th St 1 1 1 1 10     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.40196713530099 (37.7824643544146, -122.401967135301)
51360 110401 2 36 419X 18th Ave 2 1 1 10 10   27 3x3   5990271.90904 2112469.3758 37.779877404965504 -122.4772748837 (37.7798774049655, -122.4772748837)
44757 104618 2 21 800 Folsom St 1 1 1 1 10   8 4x4 Permit Number 770959 6012200.3 2112763.2826 37.7819322989016 -122.401435053146 (37.7819322989016, -122.401435053146)
43480 111380 2 3 301x OCEAN AVE 2 5 1 10 10   24 3x3   5999454.0 2091552.0 37.7229718629586 -122.44400669588998 (37.7229718629586, -122.44400669589)
100855 114731 7 103 934 BRANNAN ST   13 1 1 9     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
27975 107435 2 340 418 19th Ave 2 1 1 1 9   32 3x3   5990007.15475 2112492.97382 37.779926833827794 -122.478192501966 (37.7799268338278, -122.478192501966)
144389 90741 3 483 4499X Cabrillo St 4 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981694.399658999 2110276.0019259998 37.7733536396946 -122.50678504147801 (37.7733536396946, -122.506785041478)
143887 90271 3 180 4100X Balboa St 4 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5982889.660166 2111040.818849 37.7755239169344 -122.502707160377 (37.7755239169344, -122.502707160377)
143872 90262 3 2 3826 Balboa St 2 1 1 2 8 04/22/2008 12:00:00 AM 3 3x3   5983743.727194999 2111071.775823 37.7756590695628 -122.49975507253001 (37.7756590695628, -122.49975507253)
143779 90972 3 51 3227 Balboa St 1 1 1 2 8 11/13/2008 12:00:00 AM 3 3x3   5985599.860262999 2111098.856457 37.7758421685745 -122.49333633811001 (37.7758421685745, -122.49333633811)
143691 91888 3 18 1104 Irving St 1 1 1 2 8 02/18/2009 12:00:00 AM 3 3x3   5992367.653968 2106623.490856 37.763947549515 -122.469599153768 (37.763947549515, -122.469599153768)
143644 90881 3 223 1855 Cabrillo St 1 1 1 2 8 02/20/2008 12:00:00 AM 3 3x3   5989882.489844 2110573.171827 37.7746483516209 -122.478483342296 (37.7746483516209, -122.478483342296)
142392 90497 3 460 319 25th Ave 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5988052.709 2113836.722691 37.7835027435823 -122.485052332629 (37.7835027435823, -122.485052332629)
142077 91685 3 131 383 South Van Ness Ave   1 1 2 8 03/01/2007 12:00:00 AM 3 3x3   6007417.550958999 2107460.112945 37.767103042082795 -122.417605218645 (37.7671030420828, -122.417605218645)
141899 90288 3 180 4790X Balboa St 1 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5980763.025413 2110963.934321 37.7751876098256 -122.51005785431002 (37.7751876098256, -122.51005785431)
141454 90654 3 1 3400 Cabrillo St 3 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5985083.076571 2110439.01327 37.7740001866718 -122.495075331328 (37.7740001866718, -122.495075331328)
141260 90748 3 483 4331 Cabrillo St 2 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5982206.432655 2110294.58511 37.773434802186706 -122.505015255541 (37.7734348021867, -122.505015255541)
141033 90799 3 7 3525 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5984702.125295 2110385.161127 37.77383001476171 -122.496389112099 (37.7738300147617, -122.496389112099)
140471 89620 3 12 3745 Anza St 2 1 1 2 8 03/21/2008 12:00:00 AM 3 3x3   5987075.727746 2111832.790252 37.7779435589789 -122.48828495071001 (37.7779435589789, -122.48828495071)
139900 91017 3 460 457 25th Ave 1 1 1 2 8 11/17/2008 12:00:00 AM 3 3x3   5988087.568302 2112897.540762 37.7809260463619 -122.48486281200898 (37.7809260463619, -122.484862812009)
129285 90673 3 7 3750x CABRILLO ST 3 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5984009.0 2110380.0 37.7737752151611 -122.498786325695 (37.7737752151611, -122.498786325695)
128985 90767 3 7 3927 Cabrillo St 1 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5983459.813129 2110340.073929 37.77363336363379 -122.50068306696998 (37.7736333636338, -122.50068306697)
128081 89567 3 141 4949X Anza St 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5983344.613126 2111698.2533150003 37.7773557666221 -122.50118203175501 (37.7773557666221, -122.501182031755)
127581 90265 3 2 3850X Balboa St 3 1 1 2 8 04/22/2008 12:00:00 AM 3 3x3   5983673.104561 2111069.198097 37.775647847474 -122.49999917917499 (37.775647847474, -122.499999179175)
127391 90662 3 1 3518 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5984718.446788 2110425.779815 37.7739424981767 -122.49633565193199 (37.7739424981767, -122.496335651932)
127228 90762 3 7 4025 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5983154.65976 2110328.999009 37.7735850356272 -122.501737802253 (37.7735850356272, -122.501737802253)
127154 90676 3 7 3816 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5983797.540277 2110392.357405 37.773796740286 -122.49951870039301 (37.773796740286, -122.499518700393)
125345 90733 3 483 4525 Cabrillo St 1 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5981604.755434 2110272.748468 37.773339427416296 -122.50709488652001 (37.7733394274163, -122.50709488652)
124975 90867 3 223 2133 Cabrillo St 1 1 1 2 8 02/19/2008 12:00:00 AM 3 3x3   5989018.500813 2110541.8150979998 37.774512057064904 -122.481469721054 (37.7745120570649, -122.481469721054)
123325 90647 3 1 3320 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5985333.500383999 2110448.101901 37.7740397988057 -122.494209755562 (37.7740397988057, -122.494209755562)
123318 90671 3 7 3730 Cabrillo St 2 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5984065.2455360005 2110402.073206 37.773839120575104 -122.49859339731701 (37.7738391205751, -122.498593397317)
122758 90659 3 7 3500X Cabrillo St 2 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5984771.763559 2110427.714833 37.773950934325796 -122.49615136588801 (37.7739509343258, -122.496151365888)
120737 90704 3 7 4226 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5982526.4863330005 2110346.2271189997 37.773595421125 -122.503911988256 (37.773595421125, -122.503911988256)
120709 90295 3 180 4899X Balboa St 5 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5980415.19176 2110911.332666 37.775022659049704 -122.51125715579398 (37.7750226590497, -122.511257155794)
120567 90212 3 51 2349X Balboa St 2 1 1 2 8 04/10/2008 12:00:00 AM 3 3x3   5988326.615747 2111197.527168 37.77627220634061 -122.48391114694901 (37.7762722063406, -122.483911146949)
119884 90298 3 180 4527 Balboa St 1 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5981574.06475 2110953.226782 37.77520601375029 -122.507251541607 (37.7752060137503, -122.507251541607)
119261 90929 3 37 4425 Anza St 2 1 1 2 8 11/10/2008 12:00:00 AM 3 3x3   5984963.926317 2111755.997226 37.7776092710215 -122.49558464338101 (37.7776092710215, -122.495584643381)
118636 90471 3 80 534 25th Ave 1 1 1 2 8 03/20/2008 12:00:00 AM 3 3x3   5988147.641992 2112343.937312 37.779409506079396 -122.484614370085 (37.7794095060794, -122.484614370085)
116619 89568 3 141 4939 Anza St 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5983374.388584 2111699.374735 37.7773605941443 -122.501079113369 (37.7773605941443, -122.501079113369)
115329 90636 3 12 3112 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5985977.353735 2110471.4693 37.7741416146835 -122.49198430858401 (37.7741416146835, -122.491984308584)
115210 90934 3 2 4044 Balboa St 2 1 1 2 8 11/11/2008 12:00:00 AM 3 3x3   5983069.087957 2111047.373036 37.775552455582 -122.50208697176501 (37.775552455582, -122.502086971765)
114650 90270 3 2 4036 Balboa St 1 1 1 2 8 04/22/2008 12:00:00 AM 3 3x3   5983092.910649 2111048.243721 37.7755562457499 -122.502004629102 (37.7755562457499, -122.502004629102)
114588 90645 3 1 3300X Cabrillo St 2 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5985392.933158999 2110450.258895 37.774049198972605 -122.49400432939699 (37.7740491989726, -122.494004329397)
113995 90935 3 2 4044 Balboa St 3 1 1 2 8 11/11/2008 12:00:00 AM 3 3x3   5983069.087957 2111047.373036 37.775552455582 -122.50208697176501 (37.775552455582, -122.502086971765)
113765 90260 3 2 3816 Balboa St 1 1 1 2 8 04/22/2008 12:00:00 AM 3 3x3   5983773.153295 2111072.849875 37.7756637452827 -122.499653361397 (37.7756637452827, -122.499653361397)
113762 90657 3 17 3450 Cabrillo St 2 1 1 2 8 12/07/2015 12:00:00 AM 3 3x3 Permit Number 776853 5984933.7362440005 2110433.593284 37.7739765609982 -122.495591517296 (37.7739765609982, -122.495591517296)
113740 89640 3 460 3349X Anza St 1 1 1 2 8 03/21/2008 12:00:00 AM 3 3x3   5988302.001433 2111876.734088 37.7781356853217 -122.484046112267 (37.7781356853217, -122.484046112267)
113701 90256 3 2 3230 Balboa St 1 1 1 2 8 04/22/2008 12:00:00 AM 3 3x3   5985586.651007 2111138.404753 37.7759499842691 -122.493384946077 (37.7759499842691, -122.493384946077)
112945 90779 3 7 3801X Cabrillo St 4 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5983846.387262001 2110354.103876 37.7736945730016 -122.49934690614201 (37.7736945730016, -122.499346906142)
112407 90502 3 460 401X 25th Ave 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5988073.547859 2113275.972392 37.7819642960053 -122.484939086563 (37.7819642960053, -122.484939086563)
111630 90646 3 1 3300X Cabrillo St 3 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5985392.933158999 2110450.258895 37.774049198972605 -122.49400432939699 (37.7740491989726, -122.494004329397)
111065 90246 3 180 3020 Balboa St 1 1 1 2 8 04/21/2008 12:00:00 AM 3 3x3   5986239.468923001 2111161.958067 37.7760528187899 -122.491128444049 (37.7760528187899, -122.491128444049)
110680 89569 3 141 4939 Anza St 2 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5983374.388584 2111699.374735 37.7773605941443 -122.501079113369 (37.7773605941443, -122.501079113369)
110381 89471 3 12 3828 Anza St 1 1 1 2 8 03/21/2008 12:00:00 AM 3 3x3   5986811.689623999 2111863.354052 37.7780120700323 -122.48920058722601 (37.7780120700323, -122.489200587226)
109619 89531 3 2 5050 ANZA ST 1 1 1 2 8 03/26/2008 12:00:00 AM 3 3x3   5982937.0 2111755.0 37.7774876321748 -122.502596276346 (37.7774876321748, -122.502596276346)
109216 90573 3 223 1942 Cabrillo St 1 1 1 2 8 02/15/2008 12:00:00 AM 3 3x3   5989607.117119 2110603.2040279997 37.7747148208537 -122.47943809850099 (37.7747148208537, -122.479438098501)
109181 90915 3 12 3228 Anza St 1 1 1 2 8 11/10/2008 12:00:00 AM 3 3x3   5988669.966739 2111929.945878 37.7783032057889 -122.482777102874 (37.7783032057889, -122.482777102874)
109118 90951 3 361 4899X Balboa St 1 1 1 2 8 11/11/2008 12:00:00 AM 3 3x3   5980415.19176 2110911.332666 37.775022659049704 -122.51125715579398 (37.7750226590497, -122.511257155794)
109052 90297 3 180 4545X Balboa St 2 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5981520.769284 2110951.300184 37.7751975846267 -122.50743575643 (37.7751975846267, -122.50743575643)
107566 90958 3 361 4605 Balboa St 1 1 1 2 8 11/12/2008 12:00:00 AM 3 3x3   5981330.506527999 2110944.422301 37.775167490626 -122.508093395898 (37.775167490626, -122.508093395898)
106994 90294 3 180 4899X Balboa St 4 1 1 2 8 04/24/2008 12:00:00 AM 3 3x3   5980415.19176 2110911.332666 37.775022659049704 -122.51125715579398 (37.7750226590497, -122.511257155794)
106408 90755 3 7 4125 Cabrillo St 1 1 1 2 8 04/07/2008 12:00:00 AM 3 3x3   5982844.302046 2110317.735204 37.773535873704205 -122.50281052448 (37.7735358737042, -122.50281052448)
106353 89561 3 141 5033 Anza St 1 1 1 2 8 03/27/2008 12:00:00 AM 3 3x3   5983081.723549 2111688.543497 37.7773136653868 -122.502090718872 (37.7773136653868, -122.502090718872)
105740 90747 3 483 4331 Cabrillo St 1 1 1 2 8 04/14/2008 12:00:00 AM 3 3x3   5982206.432655 2110294.58511 37.773434802186706 -122.505015255541 (37.7734348021867, -122.505015255541)
Powered by Datasette · Query took 3.068ms · Data source: data.sfgov.org