sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2357 39974 1 21 0 Steiner St 4 1 1 1         Permit Number 41235          
3821 46195 1 21   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
5109 36635 1 21   10 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
5809 46193 1 21   4 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
6461 34901 1 21   7 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
6892 36621 1 21   5 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
7024 34903 1 21   4 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
8059 34906 1 21   1 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
8112 36618 1 21   8 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
9577 36622 1 21   4 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
9973 34904 1 21   3 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
10415 47411 1 21 2722 Funston Ave 1 1 1 1   05/14/2002 12:00:00 AM     Permit Number 45322          
10516 46191 1 21   5 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
10947 34905 1 21   6 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
11359 36625 1 21   1 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
11887 46194 1 21   3 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
11991 46192 1 21   6 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
12032 39973 1 21 0 Steiner St 3 1 1 1         Permit Number 41235          
12274 33081 1 21 221 Greenwood Ave 2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37335          
12314 36623 1 21   3 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
12645 30435 1 21 3229 Barker St 1 1 1 1   05/11/1956 12:00:00 AM     Permit Number 88          
12886 33080 1 21 221 Greenwood Ave 1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37335          
12930 36616 1 21   11 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13312 20032 3 21 100 STAIRWAY51 3 1 1 2     3 3X3ST            
13700 36624 1 21   2 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13764 36627 1 21   9 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13775 46199 1 21   7 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
14367 46202 1 21   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
15451 34902 1 21   5 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
15515 39976 1 21 0 Steiner St 5 1 1 1         Permit Number 41235          
15835 19850 3 21 100 STAIRWAY27 1 1 1 2     3 10ST            
15974 36620 1 21   6 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
16053 36610 1 21   7 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
16211 34900 1 21   2 1 1 1   09/05/1997 12:00:00 AM     Permit Number 38505          
11889 87695 3 21 2630 Bay Shore Blvd 1 1 1 2   01/23/2008 12:00:00 AM 3     6010495.31841 2086065.48531 37.7085306829266 -122.40545271269501 (37.7085306829266, -122.405452712695)
171493 58008 1 21 36 Santa Barbara Ave 1 1 1 1   08/24/1977 12:00:00 AM 10   Permit Number 16974 5993293.611959999 2086427.3278599998 37.708547398612794 -122.46492972693599 (37.7085473986128, -122.464929726936)
160891 177329 2 21 2610 Bay Shore Blvd 4 1 1 1     7 Width 3ft   6010501.25874 2086080.5894099998 37.708572487900895 -122.405433245075 (37.7085724879009, -122.405433245075)
12915 87687 1 21 2610 Bay Shore Blvd 2 1 1 1     4 3x3   6010522.05865 2086133.85401 37.70871990477921 -122.40536510614099 (37.7087199047792, -122.405365106141)
48575 177328 2 21 2610 Bay Shore Blvd 1 1 1 1     6 Width 3ft   6010526.80865 2086149.78348 37.708763909485796 -122.405349810469 (37.7087639094858, -122.405349810469)
123433 29249 3 21 2600 Bay Shore Blvd 1 1 1 2   03/14/2006 12:00:00 AM 3 3x3   6010557.087504701 2086190.1499448998 37.708876440573796 -122.405248002787 (37.7088764405738, -122.405248002787)
11791 1865 1 21 2555 Bay Shore Blvd 3 1 1 1     6 3X3   6010708.42536 2086342.04995 37.709301987375206 -122.404735641836 (37.7093019873752, -122.404735641836)
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)
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)
11526 1872 1 21 2550 Bay Shore Blvd 2 1 1 1   07/02/1997 12:00:00 AM 3 3X3   6010689.185380001 2086549.45702 37.709870410169 -122.40481673101101 (37.709870410169, -122.404816731011)
154735 81046 2 21 35 Laura St 1 1 1 1 1 03/22/2003 12:00:00 AM 0     5997413.7835 2086913.9109900002 37.7101201491898 -122.450725028737 (37.7101201491898, -122.450725028737)
116522 31040 1 21 1142 Prague St 1 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34799 6000861.46493561 2086848.36005116 37.7101369112208 -122.438804492218 (37.7101369112208, -122.438804492218)
37476 177325 2 21 499 Lathrop Ave 2 1 1 1     4 Width 3ft   6012707.89529 2086680.32707 37.7103423833654 -122.397848820678 (37.7103423833654, -122.397848820678)
183355 177326 2 21 499 Lathrop Ave 3 1 1 1     1 Width 3ft   6012697.69197 2086683.76637 37.7103512587691 -122.39788432681101 (37.7103512587691, -122.397884326811)
148596 177327 2 21 499 Lathrop Ave 5 1 1 1     4 Width 3ft   6012676.28456 2086691.4385799998 37.7103711329041 -122.397958853633 (37.7103711329041, -122.397958853633)
158388 70302 1 21 2 Argonaut Ave 1 1 1 1   02/19/2008 12:00:00 AM 9 3x3 Permit Number 50275 6008251.84805 2086827.4021299998 37.7104970532627 -122.41326029305401 (37.7104970532627, -122.413260293054)
53468 44401 1 21 1159 Munich St 1 1 1 1 1 03/23/2001 12:00:00 AM 8   Permit Number 43755 6001322.64573 2087056.41932 37.7107344230292 -122.43722545029101 (37.7107344230292, -122.437225450291)
154602 80931 2 21 1111 Munich St 1 1 1 1 1 03/22/2003 12:00:00 AM 7     6001747.57084 2087049.21095 37.710738776641996 -122.435756299834 (37.710738776642, -122.435756299834)
69479 80747 2 21 1111 Munich St 2 1 1 1 1 03/22/2003 12:00:00 AM 6     6001772.74556 2087054.04067 37.7107534679609 -122.435669635744 (37.7107534679609, -122.435669635744)
10526 1853 1 21 2445 Bay Shore Blvd 3 1 1 1   12/01/1991 12:00:00 AM 6 3X3   6011002.0813 2086868.5454799999 37.710764047595895 -122.40375773612499 (37.7107640475959, -122.403757736125)
56745 106453 2 21 27 Winding Way 1 1 1 1     12     6002753.37537 2087052.6668099998 37.7108053471734 -122.432280260948 (37.7108053471734, -122.432280260948)
37756 177391 2 21 27 Winding Way 2 1 1 1     23 Width 6ft   6002763.35309 2087066.1098599997 37.7108428246043 -122.432246735124 (37.7108428246043, -122.432246735124)
11397 1847 3 21 2401 Bay Shore Blvd 1 1 1 2   11/23/1992 12:00:00 AM 6 3X3   6011018.94328 2086899.6940900001 37.710850517399294 -122.403701647223 (37.7108505173993, -122.403701647223)
48000 77997 2 21 924 Rutland St 1 1 1 1 1 08/03/2002 12:00:00 AM 5     6009714.16253 2086968.8520900002 37.710967436463704 -122.408216166539 (37.7109674364637, -122.408216166539)
93924 49780 1 21 308@ BLANKEN Tocoloma Ave 1 1 1 1 1 06/24/2006 12:00:00 AM     Permit Number 46566 6012576.33668152 2087040.28713415 37.711323435173796 -122.39832875716499 (37.7113234351738, -122.398328757165)
72346 44440 1 21 131 Seville St 1 1 1 1 1 03/23/2001 12:00:00 AM 11   Permit Number 43772 6001589.30817 2087293.5830400002 37.7114007774922 -122.43632076831001 (37.7114007774922, -122.43632076831)
108661 92790 1 21 242 Sagamore St 1 1 1 1   10/21/2009 12:00:00 AM   3x3 Permit Number 53007 5994587.0 2087471.0 37.7114875681215 -122.460535223932 (37.7114875681215, -122.460535223932)
41894 177321 2 21 1222 Naples St 3 2 1 1     9 Width 8ft   6001045.82775 2087348.99146 37.71152202140421 -122.438203139287 (37.7115220214042, -122.438203139287)
129393 69415 1 21 144 Seville St 1 1 1 1 1 05/09/1994 12:00:00 AM     Permit Number 33520 6001498.01524641 2087340.50878812 37.7115244375894 -122.436639656352 (37.7115244375894, -122.436639656352)
12224 95538 1 21 1220 Naples St 2 1 1 1     7     6001061.1187 2087367.06647 37.711572521034604 -122.438151583834 (37.7115725210346, -122.438151583834)
188077 69403 1 21 1220 Naples St 1 1 1 1 1 05/09/1994 12:00:00 AM 6   Permit Number 33507 6001071.30066 2087381.77877 37.7116134968267 -122.438117445581 (37.7116134968267, -122.438117445581)
126872 50828 1 21 79 Kempton Ave 1 1 1 1   03/19/2004 12:00:00 AM     Permit Number 47347 5992329.33717846 2087607.86910297 37.7117332358721 -122.46834817880101 (37.7117332358721, -122.468348178801)
158814 177390 2 21 501 Rolph St 1 1 1 1     3 Width 3ft   6002484.29135 2087521.98733 37.71207873771 -122.43324378918899 (37.71207873771, -122.433243789189)
175523 78721 2 21 115 Rey St 1 1 1 1 1 10/28/2000 12:00:00 AM 7     6008722.75942 2087395.11673 37.71208230802971 -122.41167280256701 (37.7120823080297, -122.411672802567)
161835 81049 1 21 1239 Athens St 1 1 1 1 1 09/11/2015 12:00:00 AM 3   Permit Number 773468 6001528.59209 2087552.56023 37.7121084216401 -122.436549143022 (37.7121084216401, -122.436549143022)
74602 44391 1 21 102 Cordova St 1 1 1 1 1 03/22/2001 12:00:00 AM 4   Permit Number 43750 6001720.67463 2087557.55104 37.712133038777104 -122.435885607952 (37.7121330387771, -122.435885607952)
25412 49553 1 21 1275 Athens St 1 1 1 1   05/05/2003 12:00:00 AM 5 3x3 Permit Number 46443 6001403.3817 2087572.5099099998 37.71215608300871 -122.43698333301 (37.7121560830087, -122.43698333301)
123206 49554 1 21 1275 Athens St 2 1 1 1   05/05/2003 12:00:00 AM   3x3 Permit Number 46443 6001366.47031855 2087579.35452031 37.7121727787169 -122.437111399043 (37.7121727787169, -122.437111399043)
185849 177388 2 21 1011 Munich St 2 1 1 1     2 Width 4ft   6002480.547069999 2087582.3869599998 37.712244369460294 -122.433261043589 (37.7122443694603, -122.433261043589)
51233 177389 2 21 1011 Munich St 4 1 1 1     3 Width 4ft   6002499.03249 2087613.4887400002 37.7123308167966 -122.43319937345301 (37.7123308167966, -122.433199373453)
88374 1836 3 21 2190X Bay Shore Blvd 1 1 1 2     6 3X3   6011449.2894285 2087454.5820611 37.7123981596303 -122.402253250732 (37.7123981596303, -122.402253250732)
1857 251765 2 21 23 Seville St 3 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1870 251767 2 21 23 Seville St 5 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1871 176854 2 21 23 Seville St 1 2 1 1     12 Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
1876 251766 2 21 23 Seville St 4 2 1 1       Width 6ft   6001915.0 2087651.0 37.7124006661461 -122.435220643728 (37.7124006661461, -122.435220643728)
12947 87653 3 21 2180X Bay Shore Blvd 2 1 1 2     12     6011545.44829 2087485.71058 37.7124889994373 -122.401923081412 (37.7124889994373, -122.401923081412)
11453 1831 3 21 2155 Bay Shore Blvd 5 1 1 2     12 4x4   6011874.06348 2087549.91911 37.71268363791079 -122.40079178733299 (37.7126836379108, -122.400791787333)
163647 42734 1 21 2155 Bay Shore Blvd 6 1 1 1 1 06/26/2000 12:00:00 AM 24   Permit Number 42735 6011889.3836199995 2087568.31883 37.7127350143717 -122.40074012757401 (37.7127350143717, -122.400740127574)
12384 1828 3 21 2144 Bay Shore Blvd 1 1 1 2     12 3X3   6011802.738969999 2087632.59723 37.7129066769684 -122.40104411460199 (37.7129066769684, -122.401044114602)
71492 177320 2 21 48 Concord St 1 1 1 1     2 Width 3ft   5999675.46135 2087889.84317 37.7129290440003 -122.44297828661199 (37.7129290440003, -122.442978286612)
63785 177323 2 21 110 Newton St 4 1 1 1     5 Width 2ft   6000963.79305 2087874.93252 37.7129614726723 -122.438524331244 (37.7129614726723, -122.438524331244)
79622 1827 3 21 2142 Bay Shore Blvd 1 1 1 2     12 3X3   6011820.2937054 2087653.754231 37.712965749133 -122.400984924928 (37.712965749133, -122.400984924928)
23394 177322 2 21 110 Newton St 2 1 1 1     4 Width 2ft   6000954.81094 2087902.84558 37.7130376047797 -122.438557375049 (37.7130376047797, -122.438557375049)
10641 87649 3 21 2132 Bay Shore Blvd 1 1 1 2   01/23/2008 12:00:00 AM 3     6011869.04727 2087711.09521 37.7131259154971 -122.400820441523 (37.7131259154971, -122.400820441523)
24945 31011 1 21 101 Morse St 1 1 1 1 1 03/13/1995 12:00:00 AM 9   Permit Number 34782 6000906.10436 2087937.38156 37.713129662086395 -122.438728194053 (37.7131296620864, -122.438728194053)
109441 31010 1 21 101 Morse St 3 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992)
121601 31012 1 21 101 Morse St 2 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34782 6000957.44438381 2087943.44267066 37.7131492251602 -122.438551179992 (37.7131492251602, -122.438551179992)
11351 1825 3 21 2122 Bay Shore Blvd 1 1 1 2   01/23/2008 12:00:00 AM 3 3x3   6011914.69441 2087767.06521 37.7132821439374 -122.400666598098 (37.7132821439374, -122.400666598098)
69925 39954 1 21 219 Raymond Ave 1 1 1 1 1 01/25/1999 12:00:00 AM 4   Permit Number 41216 6009930.68457 2087811.2783400002 37.7132926893855 -122.407527167157 (37.7132926893855, -122.407527167157)
26413 69393 1 21 35 Morse St 1 1 1 1 1 05/09/1994 12:00:00 AM 13   Permit Number 33497 6001235.31343 2088039.6013 37.7134290580849 -122.437597654505 (37.7134290580849, -122.437597654505)
11706 1824 3 21 2108 Bay Shore Blvd 1 1 1 2     36 3X3   6011980.13832 2087849.66723 37.71351260240579 -122.40044619853201 (37.7135126024058, -122.400446198532)
75159 1819 3 21 2108 Bay Shore Blvd 1 1 1 2     12 3x3   6011992.2021463 2087865.1033243 37.7135556595937 -122.40040558497401 (37.7135556595937, -122.400405584974)
74312 49764 1 21 279 Raymond Ave 1 1 1 1 1 06/04/2003 12:00:00 AM 8   Permit Number 46558 6009585.78252 2087937.96014 37.713621219820396 -122.408728204567 (37.7136212198204, -122.408728204567)
95680 49763 1 21 274 Raymond Ave 1 1 1 1 1 06/04/2003 12:00:00 AM 3   Permit Number 46557 6009611.27991 2087971.1438799999 37.713713763653104 -122.408642415516 (37.7137137636531, -122.408642415516)
Powered by Datasette · Query took 23.824ms · Data source: data.sfgov.org