Street_Tree_List

Data source: data.sfgov.org

416 rows where qSpecies = 143 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
5922 5922 20397 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 262X Sunset Blvd 42 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 60            
6436 6436 20340 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 27 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     48 40            
6592 6592 98837 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1101X Portola Dr 9 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
6719 6719 20066 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 100 STAIRWAY54 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 15ST            
7348 7348 20335 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
7578 7578 20324 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60            
7875 7875 20330 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60            
8763 8763 20326 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
9550 9550 20300 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 50X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 60            
9561 9561 20346 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 32 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 40            
9596 9596 102839 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1101X Portola Dr 2 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
10180 10180 20460 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 495X Sunset Blvd 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
13143 13143 20345 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 31 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 40            
14567 14567 98839 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1101X Portola Dr 4 Sidewalk: Property side : Yard 9 Tree 1 DPW 2                    
16804 16804 19778 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 100 STAIRWAY18 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 50ST            
16994 16994 20336 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 101X Sunset Blvd 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
32941 32941 119052 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 539 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5982216.76848 2112075.96454 37.7783265569214 -122.50511154623399 (37.7783265569214, -122.505111546234)
97677 97677 24742 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 50X Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 12x12   5982568.6363699995 2112600.93828 37.779788677407105 -122.50393321801701 (37.7797886774071, -122.503933218017)
177812 177812 185230 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2509 44th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 0ft   5982693.8052 2098008.2989 37.7397287878455 -122.50241990404 (37.7397287878455, -122.50241990404)
152465 152465 54486 Permitted Site 1 Pinus pinea :: Italian Stone Pine 143 535 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/11/1972 12:00:00 AM 8   Permit Number 10278 5983764.831730001 2112189.27219 37.7787286289905 -122.499764682948 (37.7787286289905, -122.499764682948)
170670 170670 118274 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 801 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     31 Width 3ft   5984451.13428 2110349.39905 37.7737171157491 -122.497254676861 (37.7737171157491, -122.497254676861)
183727 183727 184349 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1251 Sunset Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 0ft   5984659.3559 2106454.1603 37.763034095696504 -122.49624696060499 (37.7630340956965, -122.496246960605)
130076 130076 184742 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.49620937301201 (37.7624121488276, -122.496209373012)
74757 74757 184782 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984677.5396 2105882.9212 37.761466698486096 -122.49614192302401 (37.7614666984861, -122.496141923024)
162803 162803 184744 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.49612855837401 (37.7623384159342, -122.496128558374)
24492 24492 184737 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984694.2473 2106265.1087 37.76251705685429 -122.49611233651699 (37.7625170568543, -122.496112336517)
52904 52904 186688 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1401 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984691.4289 2105282.7412 37.759819585598294 -122.49604960675501 (37.7598195855983, -122.496049606755)
24643 24643 184784 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201)
31124 31124 184781 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1301 Sunset Blvd 42 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984718.1696 2105899.6288 37.761514952666396 -122.496002635394 (37.7615149526664, -122.496002635394)
43003 43003 186702 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1401 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23 Width 0ft   5984718.4366 2105146.0279 37.759445790880704 -122.49594611618099 (37.7594457908807, -122.495946116181)
56943 56943 186594 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518)
96752 96752 20511 Permitted Site 1 Pinus pinea :: Italian Stone Pine 143 1211X Sunset Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
128747 128747 20512 Permitted Site 1 Pinus pinea :: Italian Stone Pine 143 1211X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     24 60   5984783.690159501 2107169.3790132 37.7650051676015 -122.49586970049101 (37.7650051676015, -122.495869700491)
176641 176641 186417 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1601 Sunset Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984727.1251 2104191.8612 37.7568264235859 -122.49584568079901 (37.7568264235859, -122.495845680799)
48087 48087 186595 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984740.8383 2104479.6291 37.757617357388504 -122.49581948315 (37.7576173573885, -122.49581948315)
154045 154045 186592 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984742.0945 2104511.4521 37.757704808066 -122.495817486185 (37.757704808066, -122.495817486185)
53419 53419 186531 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.49581571217699 (37.7588251541556, -122.495815712177)
25773 25773 186433 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1601 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817)
31179 31179 186593 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541)
177230 177230 186248 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1701 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984775.1177 2103139.4669999997 37.753939651124604 -122.495602086568 (37.7539396511246, -122.495602086568)
56959 56959 186253 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1701 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984779.1353 2103090.988 37.753806776442396 -122.495584617514 (37.7538067764424, -122.495584617514)
157419 157419 186711 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1300 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494)
82062 82062 20767 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1692X Sunset Blvd 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 60   5984807.486919099 2103677.7923597 37.755419639160706 -122.495529849669 (37.7554196391607, -122.495529849669)
162866 162866 186254 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1701 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283)
175344 175344 186348 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1801 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984789.3132 2102727.1271 37.752808310778704 -122.495522585708 (37.7528083107787, -122.495522585708)
51377 51377 186343 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1801 Sunset Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5984811.8118 2102790.6052 37.7529839215525 -122.495449463877 (37.7529839215525, -122.495449463877)
176453 176453 186101 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1901 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984808.9821 2101715.6546 37.7500322370685 -122.495379978089 (37.7500322370685, -122.495379978089)
136822 136822 186102 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1901 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984817.1679 2101703.0611 37.7499981380626 -122.49535074292601 (37.7499981380626, -122.495350742926)
95336 95336 181382 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1500 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984896.9779 2104470.096 37.757600325199796 -122.49527879388 (37.7576003251998, -122.49527879388)
152558 152558 186099 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1901 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984856.2078 2101707.4688 37.7500125261534 -122.49521606791599 (37.7500125261534, -122.495216067916)
64115 64115 186098 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1901 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 0ft   5984859.9858 2101721.9514 37.750052512593705 -122.495204071455 (37.7500525125937, -122.495204071455)
42475 42475 186097 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1901 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5984866.2826 2101735.8043 37.7500909175156 -122.495183318527 (37.7500909175156, -122.495183318527)
71896 71896 184079 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1600 Sunset Blvd 80 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984934.15 2104045.1938 37.75643583792721 -122.49511890768 (37.7564358379272, -122.49511890768)
96565 96565 20978 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 2002X Sunset Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 40   5984887.616570599 2101567.3225095 37.7496295616808 -122.49509712324499 (37.7496295616808, -122.495097123245)
75220 75220 184087 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1600 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554)
156912 156912 185550 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2201 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984877.5845 2099886.0836 37.7450127509214 -122.495007861214 (37.7450127509214, -122.495007861214)
48590 48590 185705 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2101 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984891.1634 2100474.9689 37.7466304646766 -122.495004322509 (37.7466304646766, -122.495004322509)
22325 22325 21131 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 2292X Sunset Blvd 4 Median : Cutout 11 Tree 1 DPW 2     0 60   5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
128359 128359 21135 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 2292X Sunset Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
173174 173174 187017 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2501 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984955.1646 2097931.5729 37.7396507340198 -122.49459554554701 (37.7396507340198, -122.494595545547)
161617 161617 187012 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2501 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984974.837 2098002.6963 37.739847171136205 -122.494532769595 (37.7398471711362, -122.494532769595)
33579 33579 185295 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984962.8666 2097355.3585 37.7380690548117 -122.49452644909701 (37.7380690548117, -122.494526449097)
29459 29459 187394 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5985039.81 2100667.7899 37.7471685994587 -122.494504537591 (37.7471685994587, -122.494504537591)
67666 67666 185656 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 0ft   5985042.305 2100549.4408 37.746843791076 -122.49448718724301 (37.746843791076, -122.494487187243)
119596 119596 185637 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985047.0682 2100399.1831 37.7464315030837 -122.494459642192 (37.7464315030837, -122.494459642192)
163473 163473 185340 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 0ft   5984975.3236 2097003.7352 37.737104320503704 -122.494457466722 (37.7371043205037, -122.494457466722)
61731 61731 187396 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 49 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 0ft   5985054.0302 2100695.3416 37.74724508117 -122.494457396667 (37.74724508117, -122.494457396667)
160727 160727 185638 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 0ft   5985050.0993 2100407.4104 37.7464542704067 -122.49444976752501 (37.7464542704067, -122.494449767525)
34118 34118 185363 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 0ft   5984980.3483 2096870.9998 37.7367401586853 -122.49443031260901 (37.7367401586853, -122.494430312609)
137929 137929 185659 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2100 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985060.0587 2100566.7616 37.7468923883135 -122.494427074117 (37.7468923883135, -122.494427074117)
52628 52628 185362 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 87 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984999.1909 2096870.1623 37.7367389618664 -122.494365104774 (37.7367389618664, -122.494365104774)
68205 68205 185314 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985007.4607 2097237.2784 37.7377474483668 -122.49436356584499 (37.7377474483668, -122.494363565845)
184249 184249 184977 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2701 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984998.3534 2096742.4516 37.7363882534207 -122.494358589298 (37.7363882534207, -122.494358589298)
147903 147903 187345 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2200 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5985074.9529 2099709.2267 37.7445387020266 -122.494312372955 (37.7445387020266, -122.494312372955)
150966 150966 185360 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2601 Sunset Blvd 85 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985022.2207 2096895.7045 37.7368104416486 -122.49428736403799 (37.7368104416486, -122.494287364038)
63101 63101 184993 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2701 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29 Width 0ft   5985021.3833 2096558.6319 37.7358848813643 -122.49426542142099 (37.7358848813643, -122.494265421421)
149365 149365 185409 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2300 Sunset Blvd 24 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985081.6412 2099150.9001 37.7430060796886 -122.494248101225 (37.7430060796886, -122.494248101225)
114196 114196 21312 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 2501X Sunset Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60   5985074.890734901 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189)
170252 170252 185410 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2300 Sunset Blvd 25 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985099.6362 2099155.3989 37.7430194852088 -122.494186211855 (37.7430194852088, -122.494186211855)
66554 66554 185075 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2801 Sunset Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985040.8539 2096108.9226 37.7346512389504 -122.494164969235 (37.7346512389504, -122.494164969235)
41624 41624 185204 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2500 Sunset Blvd 57 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5985139.3342 2097991.4603 37.739825946299895 -122.49396318779199 (37.7398259462999, -122.493963187792)
134580 134580 185202 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2500 Sunset Blvd 55 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 0ft   5985155.2712 2097966.8909 37.7397594177965 -122.493906274966 (37.7397594177965, -122.493906274966)
61525 61525 185176 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2500 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5985156.5992 2097794.2406 37.739285444120604 -122.493888963204 (37.7392854441206, -122.493888963204)
134110 134110 187123 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2600 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     37 Width 0ft   5985149.3505 2097343.9312 37.73804859110621 -122.493880849001 (37.7380485911062, -122.493880849001)
187517 187517 187096 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2600 Sunset Blvd 32 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985160.1655 2097173.7115 37.7375818461267 -122.49383091628401 (37.7375818461267, -122.493830916284)
149328 149328 187102 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2600 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5985165.8082 2097224.4952 37.737721614714204 -122.493815148362 (37.7377216147142, -122.493815148362)
176887 176887 187090 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2600 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 0ft   5985165.3379999995 2097125.749 37.7374504565555 -122.493809499319 (37.7374504565555, -122.493809499319)
35598 35598 187095 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2600 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985178.0339 2097175.5923 37.7375880557056 -122.49376927619801 (37.7375880557056, -122.493769276198)
48068 48068 186902 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2700 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 0ft   5985182.8419 2096662.3766 37.7361791837873 -122.49371484567101 (37.7361791837873, -122.493714845671)
183507 183507 186897 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2700 Sunset Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 0ft   5985183.7588 2096592.6965 37.735987914462704 -122.493706542591 (37.7359879144627, -122.493706542591)
98898 98898 117252 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 2500x 34TH AVE 2 Side Yard : Yard 17 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
112260 112260 117251 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 2500x 34TH AVE 1 Side Yard : Yard 17 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
142324 142324 117253 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 2500x 34TH AVE 3 Side Yard : Yard 17 Tree 1 SFUSD 4       3x3   5985829.0 2097874.0 37.73954376030179 -122.491570003273 (37.7395437603018, -122.491570003273)
58967 58967 96572 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81160 81160 96570 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
86907 86907 96483 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
97749 97749 96481 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
109217 109217 96482 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
113578 113578 96571 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
138508 138508 96480 Significant Tree 6 Pinus pinea :: Italian Stone Pine 143 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout 5 Tree 1 SFUSD 4 FUF 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)

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 121.386ms · Data source: data.sfgov.org