sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2489 119760 3 35 101X Octavia St Frontage West 2 1 1 2       4x4            
2492 119762 3 35 101X Octavia St Frontage West 4 1 1 2       4x4            
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2508 119759 3 35 101X Octavia St Frontage West 1 1 1 2       4x4            
3019 20034 3 16 100 STAIRWAY51 5 1 1 2     3 ST            
3403 19880 3 198 100 STAIRWAY33 12 1 1 2     6 25ST            
3951 20035 3 16 100 STAIRWAY51 6 1 1 2     3 ST            
4106 20001 3 198 100 STAIRWAY46 21 1 1 2     6 2            
6573 19697 3 84 100 STAIRWAY9 1 1 1 2     3 15ST            
7527 20039 3 16 100 STAIRWAY51 10 1 1 2     3 ST            
9515 19958 3 84 100 STAIRWAY40 3 1 1 2     3 15ST            
9562 19696 3 84 100 STAIRWAY9 -3 1 1 2     12 15ST            
10575 20040 3 16 100 STAIRWAY51 11 1 1 2     6 ST            
10800 19957 3 84 100 STAIRWAY40 2 1 1 2     3 15ST            
11812 20044 3 16 100 STAIRWAY51 15 1 1 2     3 ST            
12896 19960 3 84 100 STAIRWAY41 18 1 1 2     6 25ST            
12976 20042 3 16 100 STAIRWAY51 13 1 1 2     3 ST            
14604 19885 3 198 100 STAIRWAY33 17 1 1 2     6 25ST            
14695 20043 3 16 100 STAIRWAY51 14 1 1 2     3 ST            
16368 19956 3 84 100 STAIRWAY40 1 1 1 2     12 15ST            
186679 179670 3 198 300x Winding Way 6 11 1 2     7 Width 0ft   6001487.80324 2086473.7350700002 37.7091438874604 -122.436612949055 (37.7091438874604, -122.436612949055)
10613 16409 3 198 1186X Munich St 2 1 1 2     42 TR   6001094.970430001 2087182.82135 37.7110685499383 -122.43802139438401 (37.7110685499383, -122.438021394384)
11288 95020 3 35 57 Leland Ave 1 1 1 2     3 3x3   6010631.1241 2087198.2876 37.711648722790706 -122.40506305817699 (37.7116487227907, -122.405063058177)
143612 94987 3 35 36 Leland Ave 1 1 1 2   08/08/2015 03:25:00 PM 3 3x3   6010827.4 2087210.2 37.711692402207106 -122.40438551024401 (37.7116924022071, -122.404385510244)
11741 94992 3 35 66 Leland Ave 1 1 1 2     3 3x3   6010640.4822 2087242.4042 37.7117703812114 -122.40503381823 (37.7117703812114, -122.40503381823)
11545 26790 3 35 106 Leland Ave 1 1 1 2   06/03/2015 09:40:00 AM 3 3X3   6010430.5942 2087350.2448 37.7120547543657 -122.405766843704 (37.7120547543657, -122.405766843704)
12910 26795 3 35 159 Leland Ave 1 1 1 2   12/15/2010 12:00:00 AM 3 3x3   6010135.8151 2087452.9607 37.712320301990204 -122.40679292443501 (37.7123203019902, -122.406792924435)
12204 95003 3 35 176 Leland Ave 1 1 1 2     3 3x3   6010111.9182 2087516.8174 37.7124943023778 -122.406880017452 (37.7124943023778, -122.406880017452)
11150 28262 3 18 3624 San Bruno Ave 1 1 1 2   03/20/2003 12:00:00 AM 12 3x3   6012194.4874599995 2088681.14992 37.715807638979705 -122.399763675165 (37.7158076389797, -122.399763675165)
23228 28259 3 18 3562 San Bruno Ave 1 1 1 2   01/21/2004 12:00:00 AM 10 3x3   6012127.60331 2089140.68412 37.717065698801 -122.400027111788 (37.717065698801, -122.400027111788)
18995 19331 3 18 301 Shields St 1 1 1 2   10/05/2000 12:00:00 AM 6 3x3   5993203.76699 2089824.45321 37.7178699121392 -122.465486857851 (37.7178699121392, -122.465486857851)
23282 19344 3 198 526 Shields St 1 1 1 2     7 3X3   5992574.47288 2089868.5056099999 37.717954554544605 -122.467665232592 (37.7179545545446, -122.467665232592)
21015 19321 3 18 120 Shields St 1 1 1 2   05/26/2010 12:00:00 AM 3 3X3   5993639.27417 2089852.22483 37.7179712747243 -122.46398352863001 (37.7179712747243, -122.46398352863)
97015 10703 3 18 130X Shields St 1 1 1 2     6 3x3   5993684.4832438 2089860.5757616002 37.717996809726 -122.46382786766 (37.717996809726, -122.46382786766)
11481 28255 3 18 3476 San Bruno Ave 1 1 1 2   02/25/2003 12:00:00 AM 6 3x3   6012058.005419999 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219)
114369 28253 3 18 3432 San Bruno Ave 1 1 1 2   02/23/2002 12:00:00 AM 3 3X3   6012031.1541281 2089723.1062284 37.718659534499295 -122.40040137877199 (37.7186595344993, -122.400401378772)
93800 22521 3 18 6600 03rd St 1 11 1 2   02/20/1992 12:00:00 AM 3 3X3   6012847.5284056 2089784.7633558998 37.7188743244909 -122.39758380657601 (37.7188743244909, -122.397583806576)
142091 22527 3 18 6600 03rd St 7 11 1 2     3 3X3   6012847.5284056 2089784.7633558998 37.7188743244909 -122.39758380657601 (37.7188743244909, -122.397583806576)
12903 28302 3 18 3410 San Bruno Ave 2 1 1 2     8 3X3   6012014.9954 2089805.7813099998 37.7188856424495 -122.40046303743799 (37.7188856424495, -122.400463037438)
12009 28254 3 18 3410 San Bruno Ave 1 1 1 2   02/23/2002 12:00:00 AM 8 3X3   6012011.64722 2089824.91922 37.7189380045612 -122.400475954423 (37.7189380045612, -122.400475954423)
12793 13368 3 18 900 Mansell St 1 1 1 2     6 3X50   6009218.46856 2090025.7710400003 37.719333336630896 -122.410145089137 (37.7193333366309, -122.410145089137)
10377 28246 3 18 3326 San Bruno Ave 1 1 1 2   02/23/2002 12:00:00 AM 3 2X3   6011947.80562 2090200.17318 37.7199648154144 -122.400722979282 (37.7199648154144, -122.400722979282)
12568 28244 3 18 3260 San Bruno Ave 1 1 1 2   03/20/2003 12:00:00 AM 12 2X3   6011894.92216 2090508.59301 37.7208087239121 -122.40092743836 (37.7208087239121, -122.40092743836)
12039 28243 3 18 3230 San Bruno Ave 1 1 1 2   01/21/2004 12:00:00 AM 8 2X3   6011870.75873 2090643.72462 37.7211784199346 -122.401020454343 (37.7211784199346, -122.401020454343)
154431 178903 3 35 10x Mansell St 3 11 1 2     1 Width 0ft   6011814.45609 2090752.0893599999 37.7214728265024 -122.401222688486 (37.7214728265024, -122.401222688486)
54864 178902 3 35 10x Mansell St 2 11 1 2     3 Width 0ft   6011813.97335 2090761.03311 37.721497357285706 -122.401224985361 (37.7214973572857, -122.401224985361)
27753 178904 3 35 10x Mansell St 4 11 1 2     1 Width 0ft   6011792.88406 2090769.7339700002 37.7215200714836 -122.401298496839 (37.7215200714836, -122.401298496839)
12282 17504 3 18 132 Persia Ave 1 1 1 2     12 3X3   6002139.261969999 2091310.46109 37.7224614665061 -122.43470704369 (37.7224614665061, -122.43470704369)
49497 215224 3 198 400x Miramar Ave 5 3 1 2     29     5995369.41897 2092571.1657099999 37.7255363969609 -122.45819989143101 (37.7255363969609, -122.458199891431)
123989 215225 3 198 500x Miramar Ave 1 3 1 2     39     5995372.41973 2092668.0374099999 37.7258025558202 -122.458196526156 (37.7258025558202, -122.458196526156)
20454 11707 3 198 700X Junipero Serra Blvd 24 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991285.0756 2092761.86788 37.7258244795155 -122.47233287588399 (37.7258244795155, -122.472332875884)
17812 11706 3 198 700X Junipero Serra Blvd 23 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991285.17012 2092766.3520900002 37.7258367975107 -122.47233287588399 (37.7258367975107, -122.472332875884)
20821 11704 3 198 700X Junipero Serra Blvd 21 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991287.4864300005 2092781.25675 37.7258778560565 -122.472325954681 (37.7258778560565, -122.472325954681)
22042 11684 3 198 700X Junipero Serra Blvd 16 11 1 2     24 2X2   5991290.8523 2092837.83415 37.7260333983166 -122.472318441749 (37.7260333983166, -122.472318441749)
19253 11682 3 198 700X Junipero Serra Blvd 14 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991292.04747 2092854.5841700002 37.726079458872796 -122.472315530658 (37.7260794588728, -122.472315530658)
22085 11660 3 198 700X Junipero Serra Blvd 2 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991300.569019999 2093059.05917 37.726641389479795 -122.472300971514 (37.7266413894798, -122.472300971514)
171275 199981 3 35 1200x Shafter Ave 1 11 1 2     2 Width 0ft   6017028.9443 2092601.7798 37.7268412531355 -122.38332614590799 (37.7268412531355, -122.383326145908)
119612 96804 3 35 1200X Revere Ave 1 22 1 2           6017205.4 2092876.1 37.7276042330013 -122.38273521775801 (37.7276042330013, -122.382735217758)
184636 199678 3 35 1400x Underwood Ave 1 11 1 2     3 Width 0ft   6015628.2568 2092949.4044 37.72771825330071 -122.388192580507 (37.7277182533007, -122.388192580507)
85394 15994 3 198 236 Moncada Way 7 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
92030 15990 3 198 236 Moncada Way 3 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
102492 15993 3 198 236 Moncada Way 6 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
109325 15997 3 198 236 Moncada Way 10 1 1 2     12 3x5   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
113428 15996 3 198 236 Moncada Way 9 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
114178 15995 3 198 236 Moncada Way 8 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
122881 15992 3 198 236 Moncada Way 5 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
122923 15999 3 198 236 Moncada Way 12 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
127640 15991 3 198 236 Moncada Way 4 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
146275 15998 3 198 236 Moncada Way 11 1 1 2     12 35M   5992398.75579 2093455.53191 37.7277935021904 -122.468533444909 (37.7277935021904, -122.468533444909)
175278 199890 3 84 1200x Quesada Ave 1 11 1 2     3 Width 0ft   6017354.2822 2093058.6837 37.7281137963921 -122.382233221943 (37.7281137963921, -122.382233221943)
14968 26618 3 16 1295 Bay Shore Blvd 1 1 1 2     6 3X3   6011596.48977 2093221.8488599998 37.7282421152608 -122.402149690774 (37.7282421152608, -122.402149690774)
21531 29579 3 198 500X Junipero Serra Blvd 1 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991348.44459 2093803.51532 37.7286882509598 -122.472189710993 (37.7286882509598, -122.472189710993)
11924 27095 3 18 711 Silver Ave 3 1 1 2     12 2X3   6006067.91108 2093593.9714799998 37.7289537443201 -122.421288656069 (37.7289537443201, -122.421288656069)
11602 27093 3 18 711 Silver Ave 1 1 1 2     12 2X3   6006091.0826900005 2093593.66537 37.7289542101608 -122.421208528251 (37.7289542101608, -122.421208528251)
80236 114819 3 198 251x TRUMBULL ST 1 11 1 2     8 3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
82267 114834 3 198 251x TRUMBULL ST 16 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
82903 114822 3 198 251x TRUMBULL ST 4 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
88602 114838 3 198 251x TRUMBULL ST 20 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
91881 114825 3 198 251x TRUMBULL ST 7 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
91988 114837 3 198 251x TRUMBULL ST 19 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
92251 114828 3 198 251x TRUMBULL ST 10 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
93073 114824 3 198 251x TRUMBULL ST 6 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
103270 114823 3 198 251x TRUMBULL ST 5 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
105377 114831 3 198 251x TRUMBULL ST 13 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
105813 114826 3 198 251x TRUMBULL ST 8 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
108332 114830 3 198 251x TRUMBULL ST 12 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
110359 114827 3 198 251x TRUMBULL ST 9 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
113520 114821 3 198 251x TRUMBULL ST 3 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
122170 114832 3 198 251x TRUMBULL ST 14 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
122392 114820 3 198 251x TRUMBULL ST 2 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
139109 114829 3 198 251x TRUMBULL ST 11 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
139389 114836 3 198 251x TRUMBULL ST 18 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
140404 114835 3 198 251x TRUMBULL ST 17 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
141123 114839 3 198 251x TRUMBULL ST 21 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
143671 114833 3 198 251x TRUMBULL ST 15 11 1 2       3x3   6004998.0 2094336.0 37.7309308121175 -122.425040194756 (37.7309308121175, -122.425040194756)
78561 14625 3 18 15 Matthew Ct 1 1 1 2   02/12/1998 12:00:00 AM 12 3X4   6017974.7726653 2094204.2737729999 37.7312936151853 -122.380167719121 (37.7312936151853, -122.380167719121)
102400 6398 3 18 4X Matthew Ct 2 1 1 2   02/13/1998 12:00:00 AM 12 3X3   6018041.9202743 2094226.9871977002 37.7313596862419 -122.379937152762 (37.7313596862419, -122.379937152762)
88204 14623 3 18 10 Matthew Ct 2 1 1 2   02/12/1998 12:00:00 AM 6 3X4   6018016.8978124 2094239.2837711999 37.7313920698281 -122.38002451510201 (37.7313920698281, -122.380024515102)
145234 14624 3 18 14 Matthew Ct 1 1 1 2   02/12/1998 12:00:00 AM 6 3X4   6018000.3078284 2094247.4364445 37.7314135402286 -122.38008243669701 (37.7314135402286, -122.380082436697)
14939 6391 3 16 16 Espanola St 1 1 1 2   12/27/2007 12:00:00 AM 6 3X3   6018056.47068 2094273.68663 37.7314887164161 -122.379890092347 (37.7314887164161, -122.379890092347)
97122 16435 3 18 1299X Newcomb Ave 4 1 1 2   02/27/2008 12:00:00 AM 3 3x3   6016431.7799349995 2094795.0104810002 37.7328304099415 -122.385543330143 (37.7328304099415, -122.385543330143)
Powered by Datasette · Query took 31.283ms · Data source: data.sfgov.org