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                    
870 117001 3 54 1X Bernal Heights Blvd 1 7 1 2                    
1177 251471 3 137 2423 Market St 1 7 1 2                    
1493 103663 2 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
2196 119600 6 34 4357x Mission St 2 7 1 1         Permit Number 774415          
3723 253167 3 12 1X Brotherhood Way 1 7 1 2                    
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7764 103662 2 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                    
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
10665 103665 2 17 350X Hickory St 4 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          
11415 103667 2 17 350X Hickory St 6 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          
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
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                    
16457 93053 1 105     7 1 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
19583 119914 3 3 400X Brotherhood Way 1 7 1 2       100x100            
86068 121227 3 116 4299x 17th St 3 7 1 2                    
156682 175042 2 5 98 San Diego Ave 1 7 1 1     33     5992757.09235 2086323.81583 37.7082322293939 -122.466776470378 (37.7082322293939, -122.466776470378)
150864 178273 2 3 98 San Diego Ave 2 7 1 1     17     5992768.65673 2086361.85687 37.708337348457896 -122.46673926632499 (37.7083373484579, -122.466739266325)
77391 92760 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
78407 92764 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
82826 92763 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
83452 92762 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
86127 92761 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
96352 92759 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
106998 92755 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
113684 92767 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
116515 92766 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
124823 92756 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
127045 92765 1 2 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
140658 92758 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
144843 92757 1 6 528 Carter St   7 1 1   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608)
30008 178244 2 3 62 Tomaso Ct 4 7 1 1     17 Width 8ft   6009170.0421 2086265.24197 37.7090049835504 -122.410047143074 (37.7090049835504, -122.410047143074)
37802 178243 2 3 62 Tomaso Ct 3 7 1 1     26 Width 8ft   6009152.06447 2086268.0035 37.7090115585089 -122.410109471469 (37.7090115585089, -122.410109471469)
180452 177816 2 1 60 Tomaso Ct 1 7 1 1     15 Width 3ft   6009147.33252 2086269.1354099999 37.7090144012735 -122.41012590570601 (37.7090144012735, -122.410125905706)
132971 178242 2 3 62 Tomaso Ct 2 7 1 1     17 Width 8ft   6009144.65272 2086270.07017 37.709016817728 -122.41013523347401 (37.709016817728, -122.410135233474)
183568 176102 2 47 62 Tomaso Ct 5 7 1 1     20 Width 8ft   6009173.04361 2086270.9274900001 37.709020763061396 -122.41003717048099 (37.7090207630614, -122.410037170481)
53016 180001 2 37 62 Tomaso Ct 6 7 1 1     22 Width 8ft   6009181.15123 2086279.38185 37.709044431429604 -122.41000974567899 (37.7090444314296, -122.410009745679)
999 251422 2 47 480x De Long St   7 1 1       3x3   5992963.0 2086633.0 37.709093057147996 -122.466087289133 (37.709093057148, -122.466087289133)
160633 176276 2 190 62 Tomaso Ct 7 7 1 1     12 Width 8ft   6009192.32266 2086308.3659400002 37.7091246419674 -122.40997318013201 (37.7091246419674, -122.409973180132)
25780 178245 2 3 62 Tomaso Ct 8 7 1 1     39 Width 8ft   6009206.68729 2086340.63676 37.7092140561483 -122.409925810128 (37.7092140561483, -122.409925810128)
25522 175043 2 5 199 Shakespeare St 2 7 1 1     6 Width 8ft   5993498.29454 2086678.39145 37.709248559547504 -122.464240538697 (37.7092485595475, -122.464240538697)
46040 187495 2 100 100 Walbridge St 1 7 1 1     8     6005184.36761 2086469.76682 37.709342367834395 -122.423836763664 (37.7093423678344, -122.423836763664)
59904 187497 2 100 100 Walbridge St 3 7 1 1     6     6005151.09396 2086478.68565 37.7093649785846 -122.42395239669399 (37.7093649785846, -122.423952396694)
48408 187498 2 141 100 Walbridge St 4 7 1 1     3     6005143.26682 2086489.02091 37.7093929151184 -122.42398018305599 (37.7093929151184, -122.423980183056)
163407 187499 2 100 100 Walbridge St 5 7 1 1     8     6005135.10052 2086491.02363 37.7093979531098 -122.42400854947999 (37.7093979531098, -122.42400854948)
23442 187500 2 141 100 Walbridge St 6 7 1 1     2     6005130.65162 2086494.3835099998 37.709406927448796 -122.424024164397 (37.7094069274488, -122.424024164397)
134081 187501 2 141 100 Walbridge St 7 7 1 1     3     6005123.3425 2086496.8566299998 37.7094133054443 -122.42404960170099 (37.7094133054443, -122.424049601701)
73009 187502 2 141 100 Walbridge St 8 7 1 1     4     6005111.53197 2086501.51554 37.7094254309976 -122.424090751982 (37.7094254309976, -122.424090751982)
60503 187503 2 141 100 Walbridge St 9 7 1 1     2     6005106.379430001 2086503.4563099998 37.7094304690223 -122.424108697959 (37.7094304690223, -122.424108697959)
48420 187504 2 100 100 Walbridge St 10 7 1 1     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354)
162173 177805 2 1 62 Tomaso Ct 9 7 1 1     25 Width 8ft   6009236.846480001 2086428.13607 37.709456001673296 -122.409827747151 (37.7094560016733, -122.409827747151)
154599 177647 2 2 451 Tocoloma Ave 1 7 1 1     10 Width 5ft   6012423.949469999 2086414.60679 37.7095969506192 -122.398811566514 (37.7095969506192, -122.398811566514)
38897 177806 2 1 62 Tomaso Ct 10 7 1 1     25 Width 8ft   6009249.93875 2086480.54598 37.709600642326606 -122.409786194885 (37.7096006423266, -122.409786194885)
147478 177648 2 2 451 Tocoloma Ave 2 7 1 1     7 Width 5ft   6012427.630469999 2086427.74351 37.7096332265644 -122.398799765591 (37.7096332265644, -122.398799765591)
136625 175549 2 61 62 Tomaso Ct 11 7 1 1     21 Width 8ft   6009261.65543 2086500.8991200002 37.709657184513 -122.40974713551901 (37.709657184513, -122.409747135519)
47525 177649 2 2 451 Tocoloma Ave 3 7 1 1     8 Width 5ft   6012431.1901 2086436.64385 37.709657863481205 -122.398788087022 (37.7096578634812, -122.398788087022)
153886 177650 2 2 451 Tocoloma Ave 4 7 1 1     8 Width 5ft   6012434.26652 2086449.4800599997 37.7096932805964 -122.39877835455201 (37.7096932805964, -122.398778354552)
173643 187485 2 21 700 Velasco Ave 1 7 1 1     7 Width 9ft   6006777.87289 2086579.02758 37.7097322050565 -122.41833708111 (37.7097322050565, -122.41833708111)
184202 177807 2 1 62 Tomaso Ct 12 7 1 1     19 Width 8ft   6009274.965480001 2086528.64182 37.7097341062031 -122.409703090337 (37.7097341062031, -122.409703090337)
155889 187486 2 21 700 Velasco Ave 2 7 1 1     9 Width 9ft   6006768.10436 2086582.6135 37.7097415013489 -122.41837109707 (37.7097415013489, -122.41837109707)
157169 187487 2 21 700 Velasco Ave 3 7 1 1     12 Width 9ft   6006739.4924099995 2086592.2880099998 37.709766454838096 -122.418470670891 (37.7097664548381, -122.418470670891)
57550 187488 2 21 700 Velasco Ave 4 7 1 1     5 Width 4ft   6006708.59512 2086603.96966 37.7097967907675 -122.418578285583 (37.7097967907675, -122.418578285583)
181907 187489 2 21 700 Velasco Ave 5 7 1 1     3     6006684.44019 2086612.8401400002 37.7098197873211 -122.418662398253 (37.7098197873211, -122.418662398253)
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)
181734 175012 2 5 81 Gillette Ave 2 7 1 1     4 Width 8ft   6013182.79855 2087056.1572599998 37.71140077569589 -122.396233767795 (37.7114007756959, -122.396233767795)
37054 175013 2 5 81 Gillette Ave 3 7 1 1     6 Width 8ft   6013185.59041 2087064.24232 37.7114231310315 -122.396224684625 (37.7114231310315, -122.396224684625)
33886 175014 2 5 81 Gillette Ave 4 7 1 1     3 Width 8ft   6013188.07866 2087071.7521799998 37.7114438900863 -122.396216610525 (37.7114438900863, -122.396216610525)
47330 175015 2 5 81 Gillette Ave 5 7 1 1     22 Width 8ft   6013189.92411 2087076.3672900002 37.7114566649583 -122.39621055536999 (37.7114566649583, -122.39621055537)
174696 175016 2 5 81 Gillette Ave 6 7 1 1     12 Width 8ft   6013191.1859 2087080.9939 37.711469438930294 -122.396206518314 (37.7114694389303, -122.396206518314)
3034 253070 2 3 132 Sagamore St 2 7 1 1       Width 0ft Permit Number 780451 5995539.3842400005 2087458.9579900003 37.7115092483173 -122.45724268539699 (37.7115092483173, -122.457242685397)
767 251382 2 58 731 Huron Ave 1 7 1 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
3748 175358 2 12 1 Brotherhood Way 3 7 1 1     3 Width 5ft   5992915.27224 2087806.8926400002 37.7123135327144 -122.466337499576 (37.7123135327144, -122.466337499576)
3733 175357 2 12 1 Brotherhood Way 2 7 1 1     3 Width 5ft   5992890.63105 2087809.5806900002 37.7123194916216 -122.466422861444 (37.7123194916216, -122.466422861444)
3740 175359 2 12 1 Brotherhood Way 4 7 1 1     7 Width 5ft   5993023.53483 2087808.23472 37.7123234639353 -122.465963412176 (37.7123234639353, -122.465963412176)
3747 175360 2 12 1 Brotherhood Way 5 7 1 1     5 Width 5ft   5993054.1062900005 2087811.2090200002 37.7123333942521 -122.46585796488002 (37.7123333942521, -122.46585796488)
128128 93153 2 211 222 Sadowa St 2 7 1 1     6 3x24   5994796.0 2087777.0 37.7123397937745 -122.45983502172301 (37.7123397937745, -122.459835021723)
3738 175361 2 12 1 Brotherhood Way 6 7 1 1     3 Width 5ft   5993097.02114 2087813.9243700001 37.7123433254574 -122.465709836634 (37.7123433254574, -122.465709836634)
107166 98714 3 3 500X Brotherhood Way   7 1 2           5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
33613 181300 2 224 101 Nueva Ave 3 7 1 1     48 Width 4ft   6013063.40285 2087533.07945 37.712703665812796 -122.39667984502199 (37.7127036658128, -122.396679845022)
167463 181301 2 224 101 Nueva Ave 4 7 1 1     4 Width 4ft   6013065.73831 2087544.18077 37.7127342778318 -122.39667255061701 (37.7127342778318, -122.396672550617)
147931 181302 2 224 101 Nueva Ave 5 7 1 1     4 Width 4ft   6013064.24149 2087553.26 37.712759124299296 -122.396678360222 (37.7127591242993, -122.396678360222)
168919 181303 2 224 101 Nueva Ave 6 7 1 1     15 Width 4ft   6013062.584369999 2087561.0422 37.712780400456 -122.39668463301399 (37.712780400456, -122.396684633014)
71645 175280 2 12 201 Tocoloma Ave 3 7 1 1     2     6012813.92638 2087567.88235 37.7127853395403 -122.397544560234 (37.7127853395403, -122.397544560234)
162192 175281 2 12 201 Tocoloma Ave 4 7 1 1     2     6012823.449990001 2087568.74091 37.7127882272645 -122.39751170352699 (37.7127882272645, -122.397511703527)
169297 175017 2 5 101 Nueva Ave 7 7 1 1     1 Width 4ft   6013060.88681 2087564.6207700002 37.712790132022704 -122.39669075108101 (37.7127901320227, -122.396690751081)
Powered by Datasette · Query took 13.205ms · Data source: data.sfgov.org