sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3 119263 3 3 495X Lakeshore Dr 1 3 1 2       10x30            
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
162 251231 2 3 164 Serrano Dr 1 1 1 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
437 20292 3 3 20X Sunset Blvd 13 1 1 2     36 60            
455 234501 3 3 2423 Market St 2 2 1 2     12 Width 8ft   6002117.5892 2105782.84009 37.7621980066439 -122.435816935712 (37.7621980066439, -122.435816935712)
556 20399 3 3 262X Sunset Blvd 44 1 1 2     42 60            
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
934 251409 2 3 95x Andover St 1 14 1 1       3x3   6007642.0 2098274.0 37.741892697320296 -122.41617822056101 (37.7418926973203, -122.416178220561)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1272 251489 3 3 900 Bosworth St 31 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1273 251481 7 3 32 Peralta Ave 1 13 1 2       3x3   6010779.0 2100499.0 37.7481779538542 -122.40548810426901 (37.7481779538542, -122.405488104269)
1282 251482 3 3 900 Bosworth St 1 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1283 251493 3 3 900 Bosworth St 35 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1286 251492 3 3 900 Bosworth St 34 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1288 251487 3 3 900 Bosworth St 29 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1290 251486 3 3 900 Bosworth St 28 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1295 251491 3 3 900 Bosworth St 33 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1298 251490 3 3 900 Bosworth St 32 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1299 251494 3 3 900 Bosworth St 36 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1316 251488 3 3 900 Bosworth St 30 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1322 251483 3 3 900 Bosworth St 8 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1332 251484 3 3 900 Bosworth St 7 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1338 251485 3 3 900 Bosworth St 6 7 1 2           6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072)
1347 251504 3 3 620x Noriega St 1 11 1 2       3x3   5992030.0 2103590.0 37.7555988620986 -122.470546036282 (37.7555988620986, -122.470546036282)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1547 251582 3 3 691x Ulloa St 1 16 1 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1620 251543 2 3 0X Bay Shore Blvd Off Ramp   17 1 1                    
1648 251606 6 3 52R Amber Dr 1 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1708 251660 6 3 1050 North Point St 4 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1710 251657 6 3 1050 North Point St 1 1 1 1       6x6   6005628.0 2121390.0 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187)
1772 173895 2 3 326x Dellbrook Ave 2 13 1 1     3 3x3   5997295.0 2102064.0 37.7517118802849 -122.452228008054 (37.7517118802849, -122.452228008054)
1841 20401 3 3 262X Sunset Blvd 46 1 1 2     12 60            
2042 20405 3 3 262X Sunset Blvd 50 1 1 2     6 60            
2100 178279 2 3 900 Brotherhood Way 6 7 1 2     4 Width 0ft   5987917.15522 2088760.91322 37.714643374877895 -122.48368218070499 (37.7146433748779, -122.483682180705)
2268 4983 3 3 5300 Diamond Heights Blvd 2 1 1 2   07/10/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001475.6363 2098933.58975 37.7433551224547 -122.43754668724199 (37.7433551224547, -122.437546687242)
2399 253072 2 3 1350 46th Ave 1 9 1 1       5x10 Permit Number 780489 5981849.666569999 2105897.22193 37.761339917853896 -122.50592325662 (37.7613399178539, -122.50592325662)
2502 253119 5 3 185 Belgrave Ave 1 13 1 1         Permit Number 780239 5997636.85301 2104869.74588 37.759435335978296 -122.45124816933 (37.7594353359783, -122.45124816933)
2503 253120 1 3 815 Buena Vista Ave West 1 9 1 1       10x100   6000071.60031 2108311.04493 37.769023393565604 -122.44307478834801 (37.7690233935656, -122.443074788348)
2700 20053 3 3 100 STAIRWAY53 2 1 1 2     12 30            
2760 251575 6 3 300 Sussex St 1 2 1 1   08/02/2017 12:00:00 AM 3 3x3 Permit Number 780395 6001194.0 2096647.0 37.737060666835205 -122.438356728037 (37.7370606668352, -122.438356728037)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2976 198801 2 3 150 Executive Park Blvd 3 9 1 1     0 Width 4ft   6013745.097 2086994.3966599999 37.7112624653484 -122.394285983735 (37.7112624653484, -122.394285983735)
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)
3138 253254 6 3 270 Castenada Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
3147 253098 6 3 1290 Portola Dr 2 9 1 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3319 4982 3 3 5300 Diamond Heights Blvd 1 1 1 2   08/31/2017 12:00:00 AM 3 3X3 Permit Number 780192 6001462.73007 2098944.10019 37.743383247851604 -122.437592066128 (37.7433832478516, -122.437592066128)
3537 102838 2 3 1101X Portola Dr 1 9 1 2                    
3799 178336 6 3 401 Ocean Ave 2 9 1 6     29 Width 8ft   5998664.9682 2091522.93582 37.722847017548204 -122.44673211618999 (37.7228470175482, -122.44673211619)
3803 178335 6 3 401 Ocean Ave 1 9 1 6     33 Width 8ft   5998656.04486 2091523.1214700001 37.72284701755029 -122.44676297552601 (37.7228470175503, -122.446762975526)
3818 178337 6 3 401 Ocean Ave 3 9 1 6     29     5998676.28102 2091524.0079700002 37.7228506076618 -122.44669308741301 (37.7228506076618, -122.446693087413)
4187 20426 3 3 453X Sunset Blvd 15 1 1 2     12 60            
4260 20045 3 3 100 STAIRWAY52 1 1 1 2     12 10            
4482 20388 3 3 262X Sunset Blvd 34 1 1 2     24 60            
4528 19968 3 3 100 STAIRWAY43 1 1 1 2     12 15            
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
5057 123370 2 3 785 03rd Ave 3 2 1 1     41 Width 4ft   5995014.0 2110353.0 37.7743403969856 -122.46071658922399 (37.7743403969856, -122.460716589224)
5104 253785 3 3 1675X 15th Ave 1 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5106 253787 3 3 1675X 15th Ave 3 11 1 2       3x3   5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
5112 253808 6 3 2 Garfield St 2 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5120 253810 2 3 281 Ralston St 5 9 1 1       3x6   5992187.95019 2089731.22021 37.7175552771373 -122.46899127483299 (37.7175552771373, -122.468991274833)
5161 253809 6 3 2 Garfield St 3 17 1 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5176 253818 2 3 219 Concord St 2 1 1 1 1         5999956.6131 2087048.59536 37.7106351918399 -122.44194619318 (37.7106351918399, -122.44194619318)
5183 211164 2 3 25 Burnside Ave 7 1 1 1     1 Width 3ft   6001259.23547 2095941.97308 37.7351285371507 -122.438080692094 (37.7351285371507, -122.438080692094)
5282 20344 3 3 101X Sunset Blvd 30 1 1 2     24 40            
5456 20311 3 3 50X Sunset Blvd 12 1 1 2     36 60            
6219 20290 3 3 20X Sunset Blvd 11 1 1 2     42 60            
6407 20308 3 3 50X Sunset Blvd 10 1 1 2     48 60            
6784 20408 3 3 262X Sunset Blvd 53 1 1 2     12 60            
7028 20295 3 3 20X Sunset Blvd 16 1 1 2     6 60            
7080 20425 3 3 453X Sunset Blvd 14 1 1 2     18 60            
7092 19853 3 3 100 STAIRWAY29 3 1 1 2     12 100ST            
7096 20070 3 3 100 STAIRWAY55 3 1 1 2     6 40ST            
7176 19977 3 3 100 STAIRWAY45 4 1 1 2     24 30ST            
7292 20433 3 3 485X Sunset Blvd 6 1 1 2     6 30            
7424 20416 3 3 453X Sunset Blvd 5 1 1 2     18 60            
7658 20289 3 3 20X Sunset Blvd 10 1 1 2     42 60            
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
8010 115555 2 3 3897 Clay St 1 1 1 1     20 3x3   5996212.11985 2115219.4068 37.7877711202849 -122.45692415093201 (37.7877711202849, -122.456924150932)
8078 20329 3 3 101X Sunset Blvd 17 1 1 2     42 60            
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8485 20457 3 3 495X Sunset Blvd 22 1 1 2     12 60            
8592 121500 5 3 251X Pennsylvania Ave 1 13 1 2                    
9506 20420 3 3 453X Sunset Blvd 9 1 1 2     12 60            
9521 20394 3 3 262X Sunset Blvd 39 1 1 2     36 60            
9593 94859 1 3   1 1 1 1       3x3 Permit Number 53932          
9600 20367 3 3 262X Sunset Blvd 17 1 1 2     42 60            
9639 114121 2 3 1200X JUNIPERO SERRA BLVD 14 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
Powered by Datasette · Query took 4.155ms · Data source: data.sfgov.org