Street_Tree_List

Data source: data.sfgov.org

2,124 rows where qSpecies = 3

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1656.604ms · Data source: data.sfgov.org