Data source: data.sfgov.org
This data as json, CSV (advanced)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162 | 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 | 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 | ||||||||
| 556 | 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 | ||||||||
| 1708 | 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 | 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) | ||||
| 1841 | 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 | 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 | ||||||||
| 2268 | 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) | |
| 2700 | 2700 | 20053 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 3319 | 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) | |
| 4187 | 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 | 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 | 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 | 4528 | 19968 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 5176 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | ||||||||
| 8010 | 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 | 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 | ||||||||
| 8485 | 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 | ||||||||
| 9506 | 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 | 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 | 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 | 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 | ||||||||
| 9843 | 9843 | 20458 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 9855 | 9855 | 20400 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 9983 | 9983 | 173627 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||
| 10567 | 10567 | 20323 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10850 | 10850 | 20451 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 10974 | 10974 | 20418 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11124 | 11124 | 20380 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 11130 | 11130 | 20306 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11214 | 11214 | 20374 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11595 | 11595 | 20431 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 30 | ||||||||
| 11765 | 11765 | 20396 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 12711 | 12711 | 19749 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 12855 | 12855 | 20286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13180 | 13180 | 20069 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
| 13202 | 13202 | 20284 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13357 | 13357 | 20454 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 13388 | 13388 | 20313 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13426 | 13426 | 20293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 13476 | 13476 | 20287 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13681 | 13681 | 19775 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 13746 | 13746 | 20338 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 13748 | 13748 | 20343 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 14111 | 14111 | 20421 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14252 | 14252 | 20285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14683 | 14683 | 20337 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 14835 | 14835 | 20387 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 14837 | 14837 | 94862 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 14905 | 14905 | 20283 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 15072 | 15072 | 20052 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 15202 | 15202 | 20339 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 15238 | 15238 | 20432 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 30 | ||||||||
| 15347 | 15347 | 20288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 15632 | 15632 | 20427 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16056 | 16056 | 20402 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 16063 | 16063 | 20307 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 16202 | 16202 | 20435 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 16297 | 16297 | 19969 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 16394 | 16394 | 20368 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 16828 | 16828 | 20461 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | ||||||||
| 19651 | 19651 | 20575 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1392X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
| 20371 | 20371 | 9649 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 420X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999128.38767 | 2111347.91542 | 37.77730804103229 | -122.446555809153 | (37.7773080410323, -122.446555809153) | |||
| 22323 | 22323 | 21142 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 22345 | 22345 | 21141 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2292X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984947.8628076 | 2099601.6268993 | 37.7442358239277 | -122.49474388696001 | (37.7442358239277, -122.49474388696) | |||
| 23115 | 23115 | 5045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5399X Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6002018.5391 | 2098420.87622 | 37.741978183035606 | -122.435632798636 | (37.7419781830356, -122.435632798636) | ||||
| 24665 | 24665 | 20951 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 25194 | 25194 | 211098 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | Width 4ft | 5994586.4001400005 | 2099476.04195 | 37.7444504634195 | -122.46140704199699 | (37.7444504634195, -122.461407041997) | |||
| 27187 | 27187 | 20695 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1592X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | |||
| 32412 | 32412 | 21086 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 33011 | 33011 | 211096 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 32 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 3ft | 5993627.58197 | 2099243.34173 | 37.743756295614205 | -122.464705516968 | (37.7437562956142, -122.464705516968) | |||
| 34344 | 34344 | 55599 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 642 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1973 12:00:00 AM | 12 | Permit Number 11573 | 5982597.2205300005 | 2111395.81021 | 37.776481429538705 | -122.503745058688 | (37.7764814295387, -122.503745058688) | ||
| 41858 | 41858 | 211167 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 87 Lippard Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 4ft | 6001932.41069 | 2095548.8110900002 | 37.7340872661014 | -122.435725166204 | (37.7340872661014, -122.435725166204) | |||
| 42746 | 42746 | 21487 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2792X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 44183 | 44183 | 21077 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 47274 | 47274 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 49630 | 49630 | 20735 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1601X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
| 51437 | 51437 | 21387 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2601X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | |||
| 58730 | 58730 | 20690 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984826.8631 | 2104357.0018991 | 37.7572856948155 | -122.49551293462 | (37.7572856948155, -122.49551293462) | |||
| 62497 | 62497 | 21311 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2501X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | 5985074.890734901 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | |||
| 62679 | 62679 | 184390 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2001 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981341.9754 | 2101226.7255 | 37.748486165253 | -122.507332592891 | (37.748486165253, -122.507332592891) | |||
| 66190 | 66190 | 20482 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 42 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 66635 | 66635 | 21451 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2701X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 67566 | 67566 | 87917 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
| 69099 | 69099 | 211097 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 500 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | Width 8ft | 5994510.98243 | 2099836.3031200003 | 37.745435309198896 | -122.461693934723 | (37.7454353091989, -122.461693934723) | |||
| 69379 | 69379 | 122419 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) |
JSON shape: default, array, newline-delimited
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");