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            
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            
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)
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)
1547 251582 3 3 691x Ulloa St 1 16 1 2       3x3   5994175.0 2098101.0 37.7406512558576 -122.462729837498 (37.7406512558576, -122.462729837498)
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)
2700 20053 3 3 100 STAIRWAY53 2 1 1 2     12 30            
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)
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                    
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            
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)
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            
8078 20329 3 3 101X Sunset Blvd 17 1 1 2     42 60            
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            
9600 20367 3 3 262X Sunset Blvd 17 1 1 2     42 60            
9843 20458 3 3 495X Sunset Blvd 23 1 1 2     42 60            
9855 20400 3 3 262X Sunset Blvd 45 1 1 2     18 60            
9890 3755 3 3 1050 Carolina St 1 11 1 2     12 18   6012450.5971046 2103074.0676917997 37.7553418567665 -122.39988853682199 (37.7553418567665, -122.399888536822)
9909 173722 3 3 928 Carolina St 1 11 1 2     17 3x3   6012423.0 2103596.0 37.7567734300957 -122.400020627969 (37.7567734300957, -122.400020627969)
10214 173907 2 3 2200 Jerrold Ave 1 5 1 2           6012443.0 2099218.0 37.7447535037256 -122.399644080592 (37.7447535037256, -122.399644080592)
10388 2288 3 3 800X Brotherhood Way 3 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989397.47374 2088680.9253 37.714509804868605 -122.47855980688699 (37.7145098048686, -122.478559806887)
10567 20323 3 3 101X Sunset Blvd 11 1 1 2     12 60            
10721 2286 3 3 800X Brotherhood Way 1 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989102.32398 2088689.12288 37.714515172905294 -122.4795805509 (37.7145151729053, -122.4795805509)
10850 20451 3 3 495X Sunset Blvd 16 1 1 2     42 60            
10974 20418 3 3 453X Sunset Blvd 7 1 1 2     12 60            
11124 20380 3 3 262X Sunset Blvd 26 1 1 2     48 60            
11126 2292 3 3 800X Brotherhood Way 7 11 1 2     45 14M   5989842.77121 2088680.7511900002 37.7145351702246 -122.477020683771 (37.7145351702246, -122.477020683771)
11130 20306 3 3 50X Sunset Blvd 8 1 1 2     18 60            
11192 24264 3 3 350X Winding Way 2 11 1 2     24 8   6001155.71614 2086583.0952599999 37.709425288929296 -122.437768517615 (37.7094252889293, -122.437768517615)
11214 20374 3 3 262X Sunset Blvd 22 1 1 2     18 60            
11595 20431 3 3 485X Sunset Blvd 4 1 1 2     36 30            
11659 106061 3 3 12X Canyon Dr 1 3 1 2     40     6003256.93175 2086330.4794599998 37.7088509162175 -122.430488359046 (37.7088509162175, -122.430488359046)
11765 20396 3 3 262X Sunset Blvd 41 1 1 2     48 60            
12513 2291 3 3 800X Brotherhood Way 6 11 1 2     24 14M   5989707.10535 2088681.30853 37.714528829127495 -122.477489635265 (37.7145288291275, -122.477489635265)
12711 19749 3 3 100 STAIRWAY15 5 1 1 2     6 10ST            
12855 20286 3 3 20X Sunset Blvd 7 1 1 2     12 60            
12984 2293 3 3 800X Brotherhood Way 8 11 1 2     30 14M   5990043.7756199995 2088644.1713900003 37.71444639007029 -122.476323268498 (37.7144463900703, -122.476323268498)
13003 24273 3 3 350X Winding Way 11 11 1 2     12 8   6000864.27338 2086762.8945799998 37.7099024017335 -122.43878866537399 (37.7099024017335, -122.438788665374)
13180 20069 3 3 100 STAIRWAY55 2 1 1 2     36 40ST            
13202 20284 3 3 20X Sunset Blvd 5 1 1 2     12 60            
13213 2294 3 3 800X Brotherhood Way 9 11 1 2     45 14M   5990137.079530001 2088614.4864299998 37.714370293032204 -122.475998609661 (37.7143702930322, -122.475998609661)
13357 20454 3 3 495X Sunset Blvd 19 1 1 2     36 60            
13388 20313 3 3 101X Sunset Blvd 2 1 1 2     12 60            
13426 20293 3 3 20X Sunset Blvd 14 1 1 2     42 60            
13476 20287 3 3 20X Sunset Blvd 8 1 1 2     12 60            
13681 19775 3 3 100 STAIRWAY18 1 1 1 2     12 50ST            
13746 20338 3 3 101X Sunset Blvd 25 1 1 2     48 40            
13748 20343 3 3 101X Sunset Blvd 29 1 1 2     48 40            
14111 20421 3 3 453X Sunset Blvd 10 1 1 2     12 60            
14252 20285 3 3 20X Sunset Blvd 6 1 1 2     12 60            
14683 20337 3 3 101X Sunset Blvd 24 1 1 2     48 40            
14835 20387 3 3 262X Sunset Blvd 33 1 1 2     24 60            
14905 20283 3 3 20X Sunset Blvd 4 1 1 2     36 60            
15072 20052 3 3 100 STAIRWAY53 1 1 1 2     12 30            
15202 20339 3 3 101X Sunset Blvd 26 1 1 2     48 40            
15238 20432 3 3 485X Sunset Blvd 5 1 1 2     42 30            
15347 20288 3 3 20X Sunset Blvd 9 1 1 2     12 60            
15632 20427 3 3 453X Sunset Blvd 16 1 1 2     12 60            
16056 20402 3 3 262X Sunset Blvd 47 1 1 2     48 60            
16063 20307 3 3 50X Sunset Blvd 9 1 1 2     48 60            
16202 20435 3 3 485X Sunset Blvd 8 1 1 2     6 30            
16297 19969 3 3 100 STAIRWAY43 2 1 1 2     6 15            
16394 20368 3 3 262X Sunset Blvd 18 1 1 2     3 60            
Powered by Datasette · Query took 3.342ms · Data source: data.sfgov.org