sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
78769 116833 6 60 1750 Geneva Ave 1 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
81752 116834 6 60 1750 Geneva Ave 2 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
95921 116835 6 60 1750 Geneva Ave 3 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
110125 116836 6 60 1750 Geneva Ave 4 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
114433 116837 6 60 1750 Geneva Ave 5 7 1 1           6004521.4 2087037.7 37.710864341935 -122.42616849363998 (37.710864341935, -122.42616849364)
107838 104193 6 177 122 Arch St 1 7 1 1           5992720.4 2088013.1 37.712868482575104 -122.467026013031 (37.7128684825751, -122.467026013031)
91767 104749 6 3 1X Junipero Serra Blvd Off Ramp 1 7 1 1         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719553998 (37.7132507161795, -122.47185719554)
113067 104750 6 3 1X Junipero Serra Blvd Off Ramp 2 7 1 1   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719553998 (37.7132507161795, -122.47185719554)
145474 114257 6 151 50x CHUMASERO DR 1 7 1 1           5990913.0 2088468.0 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941)
123839 114250 6 60 131 FONT BLVD 1 7 1 1     36     5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9655 114155 6 128 1200X JUNIPERO SERRA BLVD 16 7 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10002 114158 6 259 1200X JUNIPERO SERRA BLVD 6 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10011 173616 6 26 1200X JUNIPERO SERRA BLVD 15 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
89097 114144 6 140 1200x JUNIPERO SERRA BLVD 1 7 1 1     10     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
89972 114147 6 3 1200x JUNIPERO SERRA BLVD 4 7 1 1     7     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
118401 114145 6 140 1200x JUNIPERO SERRA BLVD 2 7 1 1     6     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
140509 114146 6 140 1200x JUNIPERO SERRA BLVD 3 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
11662 102569 6 41 0 Diaz Ave 1 7 1 1   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.8197400002 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439)
108061 104751 6 5 13X JUAN BAUTISTA CIR 2 7 1 1           5989494.0 2090180.0 37.7186314952818 -122.47833572411999 (37.7186314952818, -122.47833572412)
89406 114379 6 5 443X ARBALLO DR 1 7 1 1     36     5988110.0 2090275.0 37.718811899837206 -122.483126550771 (37.7188118998372, -122.483126550771)
108075 116951 6 24 299 Tara St 1 7 1 1           5997754.0 2090179.6 37.7191064490611 -122.44978436622101 (37.7191064490611, -122.449784366221)
113595 114068 6 62 8 HIGUERA AVE 1 7 1 1     20     5987898.0 2090420.0 37.719197693995795 -122.48386996767 (37.7191976939958, -122.48386996767)
86962 114103 6 62 5 ACEVEDO AVE 2 7 1 1     15     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
103750 114102 6 62 7 ACEVEDO AVE 1 7 1 1     18     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
88441 114094 6 55 239x VIDAL DR 1 7 1 1     24     5987668.0 2090475.0 37.7193353179991 -122.484669012602 (37.7193353179991, -122.484669012602)
94574 114097 6 306 221x VIDAL DR 1 7 1 1     14     5987664.0 2090556.0 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519)
104403 114100 6 146 21x ACEVEDO AVE 1 7 1 1     10     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
118949 114101 6 146 21x ACEVEDO AVE 2 7 1 1     7     5988027.0 2090598.0 37.7196939458216 -122.48343711113998 (37.7196939458216, -122.48343711114)
96627 104900 6 146 317 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
99835 104913 6 28 608 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
102326 104898 6 1 310 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
118620 104908 6 1 500 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
119511 104899 6 193 314 Gonzalez Dr 2 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
140531 104916 6 3 700 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
142126 104912 6 39 606 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
143237 104888 6 47 146 Gonzalez Dr 1 7 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
82402 114388 6 16 361x ARBALLO DR 1 7 1 1     7     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
99779 114394 6 253 134x TAPIA DR 1 7 1 1     28     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
138436 114384 6 82 418X SERRANO DR 2 7 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
144120 114104 6 85 400x ARBALLO DR 1 7 1 1     12 3x3   5988116.0 2090625.0 37.7197732605649 -122.48313145165001 (37.7197732605649, -122.48313145165)
80921 104904 6 26 417 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
124358 104909 6 3 533 Gonzalez Dr 1 7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
125203 114389 6 15 345x ARBALLO DR 1 7 1 1     8     5988176.0 2090635.0 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788)
104018 104932 6 26 717 Gonzalez Dr 1 7 1 1           5990427.0 2090598.0 37.7198333383806 -122.47514125414499 (37.7198333383806, -122.475141254145)
142616 104933 6 26 755 Gonzalez Dr 1 7 1 1           5990427.0 2090598.0 37.7198333383806 -122.47514125414499 (37.7198333383806, -122.475141254145)
72156 104935 6 62 835 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
99811 104936 6 62 837 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
109347 104937 6 62 839 Gonzalez Dr 2 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
114209 104934 6 62 805 Gonzalez Dr 1 7 1 1           5990419.0 2090610.0 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631)
98711 105649 6 47 3 Gonzalez Dr 1 7 1 1           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93217 114390 6 82 23x PINTO AVE 1 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
144388 114393 6 253 118x TAPIA DR 1 7 1 1     36     5988638.0 2090878.0 37.72049829773871 -122.48134562114099 (37.7204982977387, -122.481345621141)
81688 93931 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
99064 93932 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
89464 100191 6 3 1201 Holloway Ave 1 7 1 1           5992431.5 2091178.1 37.721542125529396 -122.46825464021099 (37.7215421255294, -122.468254640211)
121702 95777 6 518 30 Onondaga Ave   7 1 1   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.721861535681704 -122.437972107548 (37.7218615356817, -122.437972107548)
53190 94850 6 17 1107 Bowdoin St 1 7 1 1   11/17/2010 12:00:00 AM     Permit Number 53929 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
98300 94851 6 5 1107 Bowdoin St 2 7 1 1   11/17/2010 12:00:00 AM 12   Permit Number 774691 6009593.0 2091048.0 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301)
84808 100529 6 17 720 Victoria St 1 7 1 1   09/24/2012 12:00:00 AM     Permit Number 769203 5993611.6 2091925.6 37.723662667106 -122.464229627127 (37.723662667106, -122.464229627127)
121106 102478 6 70 760 Victoria St 4 7 1 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
138493 102479 6 34 760 Victoria St 5 7 1 1           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167)
128360 106364 6 36 155 BORICA ST 1 7 1 1           5992696.0 2092292.5 37.724617268406604 -122.467421338179 (37.7246172684066, -122.467421338179)
98850 108305 6 17 360 GAMBIER ST 1 7 1 1   02/06/2015 12:00:00 AM 3   Permit Number 774454 6006059.9 2092154.5 37.725000818070995 -122.42121417648599 (37.725000818071, -122.421214176486)
108351 106363 6 47 101 URBANO DR 1 7 1 1     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025)
171221 112905 6 5 2401 Keith St 1 7 1 1     25     6014331.87009 2092225.76664 37.725659374776605 -122.39262364628901 (37.7256593747766, -122.392623646289)
144561 118359 6 3 8 Keystone Way 1 7 1 1     20 3x3   5994105.0 2092664.0 37.72571856099329 -122.46257757783 (37.7257185609933, -122.46257757783)
126830 100124 6 431 40@ San Ramon Eastwood Dr 1 7 1 1           5995635.0 2092781.0 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
3283 253384 6 203 55 Cerritos Ave 1 7 1 1       10x10   5992588.0 2092941.0 37.7263916542788 -122.46784182223999 (37.7263916542788, -122.46784182224)
98505 100433 6 152 200X Stonecrest Dr 3 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
99170 100432 6 90 200X Stonecrest Dr 2 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
114083 100431 6 90 200X Stonecrest Dr 1 7 1 1           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264)
129429 100423 6 38 155 Winston Dr 1 7 1 1           5990788.0 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965)
96055 107245 6 17 140 CEDRO AVE   7 1 1           5991993.7 2093259.3 37.727231291852604 -122.469919436342 (37.7272312918526, -122.469919436342)
Powered by Datasette · Query took 11.808ms · Data source: data.sfgov.org