sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
799 175049 3 12 80X Junipero Serra Blvd 17 1 1 2   01/18/2008 12:00:00 AM 1 Width 3ft   5991326.81361 2089039.5683900001 37.715606377909495 -122.47191742058 (37.7156063779095, -122.47191742058)
1221 19739 3 105 100 STAIRWAY14 17 1 1 2     6 40ST            
1263 138399 3 79 2445 PINE ST 17 1 1 2     4 Width 0ft   6002411.2137 2115044.4135 37.7876446559027 -122.435463964972 (37.7876446559027, -122.435463964972)
3097 1165 3 200 2849X Alemany Blvd 17 1 1 2     25 3X3   5997618.33471 2088040.74004 37.7132258706419 -122.45009922742399 (37.7132258706419, -122.450099227424)
3130 253319 2 47 2 Euclid Ave 17 1 1 1           5999085.0 2114289.0 37.7853810185166 -122.446917590697 (37.7853810185166, -122.446917590697)
3806 177110 6 55 401 Ocean Ave 17 9 1 6     6 Width 5ft   5998978.57855 2091518.5364400002 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081)
3841 253549 3 41 1000 Cayuga Ave 17 13 1 2   09/27/2017 11:46:00 AM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3949 160074 2 11 1000 Cayuga Ave 17 1 1 1   10/04/2017 11:38:00 AM 3 Width 0ft   5999996.87806 2090379.50245 37.719783405947204 -122.442045963044 (37.7197834059472, -122.442045963044)
4581 142526 3 26 301 FRANCISCO ST 17 1 1 4     10 Width 0ft   6009810.3798 2121222.957 37.8050268727325 -122.410300597206 (37.8050268727325, -122.410300597206)
4684 253645 3 39 1200x La Salle Ave 17 1 1 2 3 03/11/2006 12:00:00 AM   3x3   6017461.0 2094327.0 37.731602238049504 -122.381952476407 (37.7316022380495, -122.381952476407)
4979 8629 3 1 2600 Geary Blvd 17 11 1 2     12 20   5999229.0905 2113208.3802 37.78242214856029 -122.44634131765899 (37.7824221485603, -122.446341317659)
5038 83035 5 78 100X Cargo Way 17 1 1 9   04/10/2017 09:50:00 AM 3     6018541.89406 2097818.9676900003 37.741250126083706 -122.37845792741501 (37.7412501260837, -122.378457927415)
5386 44855 1 17   17 1 1 1   04/25/2001 12:00:00 AM     Permit Number 43922          
5863 9461 1 22 800X Golden Gate Ave 17 1 1 3   12/15/2005 12:00:00 AM 3 3X3   6005331.3816 2112388.6106 37.780517893039395 -122.425171696602 (37.7805178930394, -122.425171696602)
6115 20296 3 47 20X Sunset Blvd 17 1 1 2     42 60            
6779 46294 1 33   17 1 1 1   01/31/2002 12:00:00 AM     Permit Number 44564          
6835 35197 1 2   17 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7111 13449 3 15 2X Market St 17 1 1 2     6 4X4   6013948.95434 2117105.18569 37.793951570762296 -122.39568978495001 (37.7939515707623, -122.39568978495)
7332 13489 3 15 200X Market St 17 1 1 2     45 4x4   6013490.62846 2116671.2522 37.7927345856821 -122.397245205595 (37.7927345856821, -122.397245205595)
8078 20329 3 3 101X Sunset Blvd 17 1 1 2     42 60            
9145 3860 1 11 201X Cashmere St 17 1 1 1   08/16/1996 12:00:00 AM 12 3X3   6016272.1162427 2096165.2075516998 37.73658386065979 -122.386190822782 (37.7365838606598, -122.386190822782)
9335 3814 1 11 101X Cashmere St 17 1 1 1   08/16/1996 12:00:00 AM 6 3X3   6017067.4579304 2095837.0108628003 37.7357266870687 -122.383418119044 (37.7357266870687, -122.383418119044)
9600 20367 3 3 262X Sunset Blvd 17 1 1 2     42 60            
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)
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)
10279 45897 1 17   17 1 1 1   12/06/2001 12:00:00 AM     Permit Number 44451          
10701 20452 3 47 495X Sunset Blvd 17 1 1 2     36 60            
10741 27075 3 2 801 Silver Ave 17 1 1 2     12 4   6006793.50583 2093649.9353599998 37.7291482901427 -122.418784183564 (37.7291482901427, -122.418784183564)
11080 48233 1 17   17 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45761          
11230 27210 1 20 302 Silver Ave 17 1 1 1   11/28/2000 12:00:00 AM 3 3X3   6003698.299930001 2093465.5644 37.728467287514206 -122.42947142096901 (37.7284672875142, -122.429471420969)
11584 19594 3 176 100 STAIRWAY4 17 1 1 2     12 60            
11610 35704 1 85   17 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
12581 1281 3 60 3995X Alemany Blvd 17 1 1 2     12 3X3   5992683.69403 2087456.96265 37.7113393439098 -122.46711247059099 (37.7113393439098, -122.467112470591)
13219 24279 3 1 350X Winding Way 17 11 1 2     6 8   6000809.6312 2086798.35513 37.709996659695 -122.43898005820299 (37.709996659695, -122.438980058203)
13431 11527 3 36 101X Jennings St 17 1 1 2     12 3X3   6018609.30332 2096848.22468 37.738588373848295 -122.378157476493 (37.7385883738483, -122.378157476493)
13536 78330 3 282 50 Pomona St 17 1 1 4 2 07/15/2000 12:00:00 AM 3 3x3   6014096.48223 2094344.10726 37.7314628339206 -122.39358556204999 (37.7314628339206, -122.39358556205)
13547 36637 1 33   17 1 1 1   05/20/1998 12:00:00 AM     Permit Number 39461          
13632 19618 3 40 100 STAIRWAY5 17 1 1 2     6 30            
13785 12137 3 37 1400X La Salle Ave 17 1 1 2   01/28/2016 09:03:00 AM 3 3X3   6016395.84509 2095364.00428 37.7343907648187 -122.385707210442 (37.7343907648187, -122.385707210442)
14315 19833 3 129 100 STAIRWAY25 17 1 1 2     18 60X            
14341 35444 1 62 790 Peninsula Ave 17 1 1 1   03/16/1998 12:00:00 AM     Permit Number 38883          
14604 19885 3 198 100 STAIRWAY33 17 1 1 2     6 25ST            
14612 19719 3 105 100 STAIRWAY13 17 1 1 2     12 40ST            
14712 19997 3 105 100 STAIRWAY46 17 1 1 2     12 40            
15124 35187 1 12   17 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
15189 3712 3 36 401X Cargo Way 17 1 1 2     18 3X3   6016661.27341 2099164.52322 37.7448409049843 -122.385054235166 (37.7448409049843, -122.385054235166)
15309 6525 3 15 1200X Evans Ave 17 11 1 2   09/14/2006 12:00:00 AM 3 15   6017423.67126 2097218.66072 37.7395401020993 -122.382282630765 (37.7395401020993, -122.382282630765)
15643 19759 3 235 100 STAIRWAY15 17 1 1 2     3 20ST            
16291 21875 3 12 1900 03rd St 17 1 1 2   01/25/1995 12:00:00 AM 3 3X3   6015645.87724 2106637.96445 37.7653051733068 -122.38908702634701 (37.7653051733068, -122.389087026347)
16726 51106 1 56 420@ 6TH ST Berry St 17 1 1 1   07/27/2004 12:00:00 AM     Permit Number 47557 6013008.01748439 2109097.62504611 37.7719122726701 -122.398383421945 (37.7719122726701, -122.398383421945)
16873 44558 1 17   17 1 1 1   04/29/2001 12:00:00 AM     Permit Number 43835          
17215 29296 3 11 400X Portola Dr 17 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5997789.65443 2099947.6050400003 37.745929104439796 -122.450364887145 (37.7459291044398, -122.450364887145)
17717 98 1 11 900X 14th St 17 1 1 1     18 3X3   6002352.6347900005 2107680.7629400003 37.7674225884029 -122.435139756108 (37.7674225884029, -122.435139756108)
17990 21036 3 119 2101X Sunset Blvd 17 1 1 2     12 60   5984980.9284488 2100900.997098 37.7478054765444 -122.49472533299699 (37.7478054765444, -122.494725332997)
18063 11685 3 12 700X Junipero Serra Blvd 17 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991290.62257 2092826.93511 37.726003458970105 -122.472318441739 (37.7260034589701, -122.472318441739)
18314 122661 1 6 300x Hickory St 17 1 1 1   11/10/2016 12:00:00 AM 3 3x3            
18901 29590 3 60 800X Junipero Serra Blvd 17 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991297.67299 2091930.7639 37.723543203431504 -122.47222877213301 (37.7235432034315, -122.472228772133)
19650 29875 3 21 1900X Evans Ave 17 1 1 2   09/11/2006 12:00:00 AM 3 4x4   6014068.912189701 2099730.7814701 37.746251993267 -122.394057835868 (37.746251993267, -122.394057835868)
19688 29608 3 12 900X Junipero Serra Blvd 17 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991185.36807 2091033.22274 37.721072277433 -122.472551581098 (37.721072277433, -122.472551581098)
19693 45729 1 9 235 02nd St 17 1 1 1   10/05/2001 12:00:00 AM     Permit Number 44392 6013350.5591251 2114341.46161867 37.7863297261158 -122.397566379799 (37.7863297261158, -122.397566379799)
20382 53127 1 17 601@ NOE ST Duboce Ave 17 1 1 1   10/30/2006 12:00:00 AM     Permit Number 49066 6002808.44176413 2108284.12633652 37.7691051487822 -122.43360630927201 (37.7691051487822, -122.433606309272)
20786 29273 3 11 300X Portola Dr 17 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5998795.79674 2100195.7409 37.746667956864705 -122.446903651091 (37.7466679568647, -122.446903651091)
20904 12016 3 39 1230X La Salle Ave 17 1 1 2   11/09/1992 12:00:00 AM 6 3X3   6017323.1168478 2094452.6646717 37.7319396729967 -122.382437910438 (37.7319396729967, -122.382437910438)
20983 38398 1 17 1000 Van Ness Ave 17 1 1 1   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622)
21414 29328 3 11 1250X Portola Dr 17 11 1 2   10/14/2005 12:00:00 AM 3 3X3   5993805.9299800005 2097861.77346 37.7399731364485 -122.463988569318 (37.7399731364485, -122.463988569318)
21937 29584 3 5 500X Junipero Serra Blvd 17 11 1 2   02/12/2016 12:00:00 AM 3 3X3   5991345.88941 2093701.3780900002 37.728407659786 -122.47219110225299 (37.728407659786, -122.472191102253)
22663 26770 1 11 1661 Pine St 17 1 1 1     6 3X3   6006197.69813 2115570.77894 37.789304245831 -122.42240086201099 (37.789304245831, -122.422400862011)
23067 3507 3 194 201X Cargo Way 17 1 1 2     4 3X3   6017965.040030001 2098144.3870599996 37.7421118483876 -122.380475117526 (37.7421118483876, -122.380475117526)
23080 18562 3 330 1700X Quesada Ave 17 11 1 2     2 19   6014525.2512300005 2095171.8151599998 37.7337593670062 -122.392161079069 (37.7337593670062, -122.392161079069)
23747 186497 2 1 1400 Lower Great Hwy 17 19 1 1     2 Width 0ft   5980894.6551 2105244.501 37.7594914745751 -122.509177708249 (37.7594914745751, -122.509177708249)
23941 250276 2 15 43 United Nations Plz 17 2 1 1     12 Width 0ft   6008392.62375 2112125.224 37.7799671560941 -122.414562734397 (37.7799671560941, -122.414562734397)
24175 221317 3 115 3500x Cesar Chavez St 17 3 1 2     11 Width 10ft   6005983.198059999 2100540.62132 37.74802291412821 -122.422074813715 (37.7480229141282, -122.422074813715)
24381 205069 2 12 851 Junipero Serra Blvd 17 2 1 1     3 Width 3ft   5991341.17231 2091818.7337900002 37.723238113832004 -122.472070242354 (37.723238113832, -122.472070242354)
24581 191958 2 39 1322 Hudson Ave 17 1 1 1     20 Width 3ft   6017653.96329 2094797.5572 37.732904949909994 -122.381318065575 (37.73290494991, -122.381318065575)
25133 198661 2 46 1670 Owen St 17 9 1 1     3 Width 8ft   6013934.2668 2107404.04412 37.7673136301584 -122.39506079103 (37.7673136301584, -122.39506079103)
25787 189282 2 141 1310 Indiana St 17 23 1 1     2     6015006.25242 2102364.64044 37.753536067647 -122.39100065687 (37.753536067647, -122.39100065687)
25934 202590 2 11 625 King St 17 2 1 1     8 Width 4ft   6012160.02147 2108668.06589 37.7706855257355 -122.401286527748 (37.7706855257355, -122.401286527748)
26664 207878 2 55 1541 12th Ave 17 1 1 1     6 Width 4ft   5992430.64291 2104640.28912 37.75850584000379 -122.469236940844 (37.7585058400038, -122.469236940844)
26897 249733 2 60 2500 Broderick St 17 4 1 1     22 Width 3ft   6000186.12585 2117239.7585400003 37.7935458766883 -122.4433200551 (37.7935458766883, -122.4433200551)
27098 249881 2 180 230 Greenwich St 17 13 1 1     16 Width 0ft   6011514.20842 2120460.74576 37.803029388647104 -122.404350588107 (37.8030293886471, -122.404350588107)
27106 195241 3 15 1400x Evans Ave 17 3 1 2     5     6016370.1217 2098002.92096 37.7416352733631 -122.38598003597299 (37.7416352733631, -122.385980035973)
27414 186546 2 3 1501 Sunset Blvd 17 19 1 1     3 Width 0ft   5984749.2128 2104853.9681 37.758645678551105 -122.495818134238 (37.7586456785511, -122.495818134238)
27616 239170 2 147 1400 Potrero Ave 17 1 1 1     4 Width 2ft   6010748.55016 2100997.3935 37.749544730724296 -122.405628497759 (37.7495447307243, -122.405628497759)
27904 210220 3 239 198x San Anselmo Ave 17 3 1 2     15     5993632.14987 2096264.78649 37.7355781918881 -122.464473499973 (37.7355781918881, -122.464473499973)
28711 141635 2 144 1801 GROVE ST 17 1 1 1     3 Width 0ft   5999100.4781 2110425.5241 37.7747737968525 -122.44658597745399 (37.7747737968525, -122.446585977454)
28752 222686 2 58 1201 San Jose Ave 17 7 1 1     1     6004284.84781 2095906.59844 37.735203011805204 -122.427617536921 (37.7352030118052, -122.427617536921)
28786 214229 2 16 714 Detroit St 17 17 1 1     9     5999467.99685 2095449.76583 37.7336750195872 -122.444238270085 (37.7336750195872, -122.444238270085)
29046 194625 2 26 131 Shipley St 17 1 1 1     7 Width 2ft   6011983.78945 2112208.25417 37.7803962370307 -122.402145051162 (37.7803962370307, -122.402145051162)
29316 189392 2 368 800 19th St 17 9 1 1     3 Width 10ft   6014986.11495 2105335.88571 37.7616933529833 -122.391277980795 (37.7616933529833, -122.391277980795)
29719 128586 2 32 401 Washington St 17 1 1 1     14 Width 3ft   6013211.38418 2117897.25259 37.796085342709496 -122.39829746727 (37.7960853427095, -122.39829746727)
30039 129910 2 11 3101 Van Ness Ave 17 1 1 1     15 Width 3ft   6005467.679169999 2121063.89893 37.804345751526704 -122.425317698873 (37.8043457515267, -122.425317698873)
30157 194823 2 26 502 Beale St 17 1 1 1     10 Width 6ft   6015860.261580001 2113977.77101 37.7854705393653 -122.388857976238 (37.7854705393653, -122.388857976238)
30235 193977 2 2 599 Keith St 17 1 1 1     15 Width 3ft   6017598.84707 2096624.78326 37.737919107391896 -122.381635651288 (37.7379191073919, -122.381635651288)
30245 200301 2 328 300 Spear St 17 2 1 1     5     6015414.78725 2115487.52698 37.7895912833718 -122.39050472932101 (37.7895912833718, -122.390504729321)
30458 179736 2 198 201 Trumbull St 17 9 1 1     9 Width 4ft   6004921.59693 2094359.59302 37.730991277113795 -122.425306011263 (37.7309912771138, -122.425306011263)
30962 229293 2 21 500 Dolores St 17 2 1 1     9 Width 6ft   6004930.67222 2104696.88853 37.7593756346006 -122.42601023528 (37.7593756346006, -122.42601023528)
31795 202089 2 259 1 Gould St 17 2 1 1     5     6012847.10312 2091145.2908299998 37.722610035407904 -122.39768065196199 (37.7226100354079, -122.397680651962)
33389 250592 2 34 2201 Golden Gate Ave 17 9 1 1     23 Width 7ft   5998381.460969999 2111351.09812 37.7772740876697 -122.44913988818999 (37.7772740876697, -122.44913988819)
33704 238799 2 15 3100 Harrison St 17 1 1 1     16 Width 3ft   6008984.92439 2101131.84931 37.7498151388585 -122.411736693099 (37.7498151388585, -122.411736693099)
33971 213165 2 2 951 Junipero Serra Blvd 17 1 1 1     15 Width 3ft   5991289.23593 2091020.58342 37.721043584566495 -122.47219162297199 (37.7210435845665, -122.472191622972)
34090 200282 2 62 1 Lane St 17 1 1 1     3 Width 3ft   6017049.10078 2097031.29718 37.7390049434275 -122.383564705169 (37.7390049434275, -122.383564705169)
Powered by Datasette · Query took 17.86ms · Data source: data.sfgov.org