sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
40111 178175 2 71 0 Gonzalez Dr 2 2 1 1     6     5989026.35056 2089515.5020599999 37.7167797908382 -122.47990357931002 (37.7167797908382, -122.47990357931)
56811 178172 2 71 0 Gonzalez Dr 7 2 1 1     2     5988133.68649 2089845.1312099998 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625)
127115 178176 2 71 0 Gonzalez Dr 3 2 1 1     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325)
132856 178174 2 71 0 Gonzalez Dr 5 2 1 1     2     5988358.3694 2089791.63303 37.717499145949 -122.48223265254101 (37.717499145949, -122.482232652541)
169232 178173 2 71 0 Gonzalez Dr 4 2 1 1     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364)
184043 178171 2 71 0 Gonzalez Dr 8 2 1 1     2     5988123.04078 2089845.83927 37.71763429155529 -122.483050036443 (37.7176342915553, -122.483050036443)
159159 178170 2 71 0 Serrano Dr 4 2 1 1     4     5989035.58475 2090454.3423900001 37.719358148051796 -122.479940326497 (37.7193581480518, -122.479940326497)
33800 178161 2 71 10 Brotherhood Way 16 4 1 1     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.46567970845899 (37.7124525633948, -122.465679708459)
38392 178159 2 71 10 Brotherhood Way 14 4 1 1     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432)
40640 178151 2 71 10 Brotherhood Way 4 4 1 1     3 Width 0ft   5993597.52442 2087641.3827799999 37.7118984245322 -122.46396744335199 (37.7118984245322, -122.463967443352)
50141 178167 2 71 10 Brotherhood Way 22 4 1 1     5 Width 0ft   5992858.09731 2087851.4953400001 37.7124327018762 -122.466538351485 (37.7124327018762, -122.466538351485)
75963 178152 2 71 10 Brotherhood Way 7 4 1 1     5 Width 0ft   5993523.09133 2087729.02455 37.7121347780763 -122.46423106162399 (37.7121347780763, -122.464231061624)
130721 178158 2 71 10 Brotherhood Way 13 4 1 1     5 Width 0ft   5993255.20411 2087840.2590599998 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673)
130784 178165 2 71 10 Brotherhood Way 20 4 1 1     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667)
146720 178155 2 71 10 Brotherhood Way 10 4 1 1     6 Width 0ft   5993366.44396 2087810.43567 37.71234928345479 -122.46477838452499 (37.7123492834548, -122.464778384525)
150293 178166 2 71 10 Brotherhood Way 21 4 1 1     5 Width 0ft   5992891.51235 2087851.5166099998 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421)
155336 178160 2 71 10 Brotherhood Way 15 4 1 1     6 Width 0ft   5993144.356269999 2087854.16093 37.712456535710395 -122.465549154771 (37.7124565357104, -122.465549154771)
156435 178169 2 71 10 Brotherhood Way 24 4 1 1     6 Width 0ft   5992786.910569999 2087851.5448200002 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099)
157655 178162 2 71 10 Brotherhood Way 17 4 1 1     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.46579770942301 (37.7124585223038, -122.465797709423)
160645 178163 2 71 10 Brotherhood Way 18 4 1 1     5 Width 0ft   5993033.97644 2087855.7565900001 37.712454549997204 -122.465930773993 (37.7124545499972, -122.465930773993)
162182 178153 2 71 10 Brotherhood Way 8 4 1 1     7 Width 0ft   5993495.89449 2087748.40295 37.712186418929896 -122.464326467118 (37.7121864189299, -122.464326467118)
164811 178154 2 71 10 Brotherhood Way 9 4 1 1     7 Width 0ft   5993415.347159999 2087786.9851099998 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932)
170076 178164 2 71 10 Brotherhood Way 19 4 1 1     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403)
171829 178157 2 71 10 Brotherhood Way 12 4 1 1     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.46503447098499 (37.712406882332, -122.465034470985)
173693 178156 2 71 10 Brotherhood Way 11 4 1 1     5 Width 0ft   5993327.478519999 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129)
179412 178168 2 71 10 Brotherhood Way 23 4 1 1     5 Width 0ft   5992821.74753 2087850.08942 37.712426743882 -122.46666388422899 (37.712426743882, -122.466663884229)
12961 87019 1 71 10 Osceola Dr 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49949          
166247 120262 2 71 100 24th Ave 6 17 1 1     26     5988353.58713 2115180.43805 37.7872097252822 -122.484109995805 (37.7872097252822, -122.484109995805)
16176 19976 3 71 100 STAIRWAY45 3 1 1 2     12 30ST            
16885 19980 3 71 100 STAIRWAY45 7 1 1 2     12 30ST            
10919 19986 3 71 100 STAIRWAY46 6 1 1 2     12 40            
7433 19666 3 71 100 STAIRWAY5 65 1 1 2     18 60ST            
11841 19663 3 71 100 STAIRWAY5 62 1 1 2     12 60ST            
11943 19664 3 71 100 STAIRWAY5 63 1 1 2     12 60ST            
14276 19667 3 71 100 STAIRWAY5 66 1 1 2     12 60ST            
107428 101036 3 71 1010X Portola Dr 10 7 1 2   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
118896 101040 3 71 1010X Portola Dr 14 7 1 2   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
144225 101034 3 71 1010X Portola Dr 8 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
123850 107158 2 71 101x Elsie St 1 14 1 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
9904 61559 3 71 1096 Carolina St 1 11 1 2   08/25/1984 12:00:00 AM 16   Permit Number 21519 6012461.11053783 2102868.78681941 37.75477878641421 -122.399837764002 (37.7547787864142, -122.399837764002)
118870 3773 3 71 1098 Carolina St 6 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
144047 108298 1 71 10X Greenwich St 1 7 1 1   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675)
159854 247525 2 71 1101 Waller St 6 17 1 1     2     6000029.935269999 2108491.2793400004 37.7695158962756 -122.443231851395 (37.7695158962756, -122.443231851395)
89948 98838 3 71 1101X Portola Dr 7 9 1 2   04/11/2013 12:00:00 AM 3     5994967.957909999 2097979.30417 37.740362747150996 -122.459979297607 (37.740362747151, -122.459979297607)
151346 132160 2 71 1141 Chestnut St 5 7 1 1     20     6006382.37262 2120397.93248 37.802568811663605 -122.422104980572 (37.8025688116636, -122.422104980572)
9686 173637 2 71 1155 Market St 99 1 1 1       3x3   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
92148 87013 1 71 1184 Oakdale Ave 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117)
83316 87018 1 71 1200 Oakdale Ave 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304)
120538 87017 1 71 1200 Oakdale Ave 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304)
9646 114139 2 71 1200X JUNIPERO SERRA BLVD 34 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9654 114138 2 71 1200X JUNIPERO SERRA BLVD 32 9 1 1   02/16/2016 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9658 114124 2 71 1200X JUNIPERO SERRA BLVD 17 9 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9665 114123 2 71 1200X JUNIPERO SERRA BLVD 16 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9672 114137 2 71 1200X JUNIPERO SERRA BLVD 33 9 1 1     26     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
55771 186733 2 71 1250 Sunset Blvd 2 9 1 1     2 Width 0ft   5984855.8629 2106397.0571 37.7628888152225 -122.49556310804701 (37.7628888152225, -122.495563108047)
64531 184348 2 71 1251 Sunset Blvd 14 9 1 1     1 Width 0ft   5984683.9949 2106431.9954 37.762974680362206 -122.496160108596 (37.7629746803622, -122.496160108596)
185501 184347 2 71 1251 Sunset Blvd 15 9 1 1     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.49624600189699 (37.7629440193232, -122.496246001897)
77480 8344 3 71 1300 Geary Blvd 10 11 1 2   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
80466 8349 3 71 1300 Geary Blvd 15 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
80484 8339 3 71 1300 Geary Blvd 5 11 1 2   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
88546 8341 3 71 1300 Geary Blvd 7 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
92710 8340 3 71 1300 Geary Blvd 6 11 1 2   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
108857 8348 3 71 1300 Geary Blvd 14 11 1 2   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
115283 8342 3 71 1300 Geary Blvd 8 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
117891 8351 3 71 1300 Geary Blvd 17 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
174392 181538 2 71 1300 Sunset Blvd 16 9 1 1     1 Width 0ft   5984897.5768 2105857.4141 37.761409549185 -122.495379035532 (37.761409549185, -122.495379035532)
174927 181557 2 71 1300 Sunset Blvd 35 9 1 1     2 Width 0ft   5984875.8554 2106073.5142 37.76200162774529 -122.495470098326 (37.7620016277453, -122.495470098326)
187908 181540 2 71 1300 Sunset Blvd 18 9 1 1     2 Width 0ft   5984863.0454 2105869.1102 37.7614396414651 -122.49549932614799 (37.7614396414651, -122.495499326148)
70507 184801 2 71 1301 Sunset Blvd 62 9 1 1     3 Width 0ft   5984720.8276 2105758.3732 37.7611272600096 -122.49598302148998 (37.7611272600096, -122.49598302149)
47480 194424 2 71 132 Kissling St 3 2 1 1     23 Width 5ft   6007931.050980001 2109095.29996 37.77162176316789 -122.41594490245599 (37.7716217631679, -122.415944902456)
65779 194426 2 71 132 Kissling St 5 2 1 1     19 Width 5ft   6007946.83693 2109121.1094299997 37.77169351738029 -122.415892125715 (37.7716935173803, -122.415892125715)
155635 194423 2 71 132 Kissling St 2 2 1 1     17 Width 5ft   6007917.867000001 2109077.33792 37.771571702413 -122.41598923453002 (37.771571702413, -122.41598923453)
175007 194425 2 71 132 Kissling St 4 2 1 1     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.41592168104799 (37.771655137004, -122.415921681048)
63541 234471 2 71 1350 Noe St 5 9 1 1     16     6003196.852580001 2100348.13678 37.7473368492221 -122.431696139568 (37.7473368492221, -122.431696139568)
60960 139214 3 71 1350x GEARY BLVD 8 11 1 2     29 Width 0ft   6004809.3749 2114055.503 37.78506526335679 -122.427096327106 (37.7850652633568, -122.427096327106)
62236 139330 3 71 1350x GEARY BLVD 4 11 1 2     31 Width 0ft   6005126.2471 2114101.4827 37.7852094256692 -122.42600332266599 (37.7852094256692, -122.426003322666)
70800 139359 3 71 1350x GEARY BLVD 9 11 1 2     28 Width 0ft   6004685.2851 2114039.9918 37.7850156556233 -122.42752453341801 (37.7850156556233, -122.427524533418)
131295 139356 3 71 1350x GEARY BLVD 5 11 1 2     24 Width 0ft   6005063.0942 2114090.4032 37.785175434752105 -122.42622102328698 (37.7851754347521, -122.426221023287)
176294 139358 3 71 1350x GEARY BLVD 7 11 1 2     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258)
179339 139329 3 71 1350x GEARY BLVD 3 11 1 2     13 Width 0ft   6005196.3246 2114113.3931 37.785246088934706 -122.425761723999 (37.7852460889347, -122.425761723999)
136877 181519 2 71 1400 Sunset Blvd 79 9 1 1     2 Width 0ft   5984899.8047 2105606.7824 37.76072151501489 -122.49535284581002 (37.7607215150149, -122.49535284581)
166214 181513 2 71 1400 Sunset Blvd 73 9 1 1     2 Width 0ft   5984909.8299 2105563.3396 37.7606028201969 -122.49531496977501 (37.7606028201969, -122.495314969775)
177368 181473 2 71 1400 Sunset Blvd 33 9 1 1     2 Width 0ft   5984918.4628 2105275.6702 37.759813465723795 -122.49526389807 (37.7598134657238, -122.49526389807)
34685 200547 3 71 1400x La Salle Ave 23 11 1 2     5 Width 0ft   6016201.7309 2095635.0286 37.7351242000527 -122.386397222999 (37.7351242000527, -122.386397222999)
45126 200542 3 71 1400x La Salle Ave 18 11 1 2     7 Width 0ft   6016191.4179 2095647.8311 37.735158782265394 -122.38643377144 (37.7351587822654, -122.38643377144)
45572 200536 3 71 1400x La Salle Ave 12 11 1 2     8 Width 0ft   6016175.6148 2095666.5235 37.7352092330314 -122.38648971191002 (37.7352092330314, -122.38648971191)
52015 200528 3 71 1400x La Salle Ave 4 11 1 2     19 Width 0ft   6016143.3115 2095696.7293 37.7352903838014 -122.38660350279801 (37.7352903838014, -122.386603502798)
53065 200527 3 71 1400x La Salle Ave 3 11 1 2     15 Width 0ft   6016132.8234 2095707.6369 37.7353197532414 -122.386640524716 (37.7353197532414, -122.386640524716)
58287 200617 3 71 1400x La Salle Ave 58 11 1 2     18 Width 0ft   6016444.7184 2095097.4319 37.7336615146436 -122.385519666546 (37.7336615146436, -122.385519666546)
66847 200559 3 71 1400x La Salle Ave 35 11 1 2     13 Width 0ft   6016309.6626 2095501.1365 37.7347625331555 -122.38601473032 (37.7347625331555, -122.38601473032)
136924 200613 3 71 1400x La Salle Ave 54 11 1 2     15 Width 0ft   6016431.4971 2095119.9571 37.733722632810604 -122.38556694616501 (37.7337226328106, -122.385566946165)
137881 200571 3 71 1400x La Salle Ave 41 11 1 2     17 Width 0ft   6016326.461 2095462.4873 37.7346573398722 -122.385953958726 (37.7346573398722, -122.385953958726)
153781 200572 3 71 1400x La Salle Ave 42 11 1 2     18 Width 0ft   6016330.8681 2095450.735 37.73462531430871 -122.385937902813 (37.7346253143087, -122.385937902813)
158905 200558 3 71 1400x La Salle Ave 34 11 1 2     8 Width 0ft   6016305.3951 2095506.8264 37.734777920300004 -122.38602988117901 (37.7347779203, -122.386029881179)
164960 200615 3 71 1400x La Salle Ave 56 11 1 2     13 Width 0ft   6016438.8423 2095106.2461 37.7336853915549 -122.38554059619301 (37.7336853915549, -122.385540596193)
165671 200567 3 71 1400x La Salle Ave 39 11 1 2     5 Width 0ft   6016322.0539 2095480.6054 37.7347068446432 -122.38597045824699 (37.7347068446432, -122.385970458247)
169856 200573 3 71 1400x La Salle Ave 43 11 1 2     17 Width 0ft   6016335.7649 2095440.4518 37.734597349697104 -122.385920256211 (37.7345973496971, -122.385920256211)
177190 200529 3 71 1400x La Salle Ave 5 11 1 2     16 Width 0ft   6016150.0239 2095691.2754 37.7352757800904 -122.386579915171 (37.7352757800904, -122.386579915171)
177231 200533 3 71 1400x La Salle Ave 9 11 1 2     6 Width 0ft   6016162.6096 2095677.4311 37.7352384631645 -122.38653543635799 (37.7352384631645, -122.386535436358)
181713 200526 3 71 1400x La Salle Ave 2 11 1 2     20 Width 0ft   6016126.5305 2095710.5736 37.735327468440204 -122.386662486514 (37.7353274684402, -122.386662486514)
184099 200557 3 71 1400x La Salle Ave 33 11 1 2     17 Width 0ft   6016298.6383 2095516.7839 37.734804887646796 -122.386053935891 (37.7348048876468, -122.386053935891)
Powered by Datasette · Query took 3.847ms · Data source: data.sfgov.org