Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 52542 | 52542 | 131729 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 299 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000632.65423 | 2121592.5821 | 37.8055230279355 | -122.442087629562 | (37.8055230279355, -122.442087629562) | |||
| 25983 | 25983 | 131696 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000612.30159 | 2121584.19581 | 37.805498841559896 | -122.44215746010799 | (37.8054988415599, -122.442157460108) | |||
| 154622 | 154622 | 131730 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 299 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000654.39491 | 2121581.01271 | 37.805492500428 | -122.44201156220501 | (37.805492500428, -122.442011562205) | |||
| 136503 | 136503 | 131697 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000608.885530001 | 2121557.35058 | 37.8054249370849 | -122.44216735356301 | (37.8054249370849, -122.442167353563) | |||
| 69617 | 69617 | 131731 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 299 Cervantes Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000725.63577 | 2121533.6715599997 | 37.8053665737798 | -122.44176162442601 | (37.8053665737798, -122.441761624426) | |||
| 34530 | 34530 | 131698 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000612.76504 | 2121531.38925 | 37.805353875335896 | -122.44215206329099 | (37.8053538753359, -122.442152063291) | |||
| 165490 | 165490 | 131699 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000615.89724 | 2121506.99628 | 37.8052870772908 | -122.442139471852 | (37.8052870772908, -122.442139471852) | |||
| 77901 | 77901 | 95656 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 86113 | 86113 | 95657 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 87499 | 87499 | 95651 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 89855 | 89855 | 95653 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 91775 | 91775 | 95650 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 98265 | 98265 | 95649 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 120345 | 120345 | 95655 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Cervantes Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 142677 | 142677 | 95654 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 144569 | 144569 | 95652 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 499@Scott Marina Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000674.0 | 2121505.0 | 37.805284907113 | -122.441938257064 | (37.805284907113, -122.441938257064) | |||
| 55011 | 55011 | 131700 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000620.58826 | 2121482.5709599997 | 37.805220279254705 | -122.442121483639 | (37.8052202792547, -122.442121483639) | |||
| 30181 | 30181 | 131701 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6000623.28685 | 2121462.32768 | 37.8051648504292 | -122.44211069086201 | (37.8051648504292, -122.442110690862) | |||
| 94455 | 94455 | 114582 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 BEACH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002979.0 | 2121285.0 | 37.8048119223389 | -122.43394578498999 | (37.8048119223389, -122.43394578499) | |||
| 109110 | 109110 | 114583 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 BEACH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002979.0 | 2121285.0 | 37.8048119223389 | -122.43394578498999 | (37.8048119223389, -122.43394578499) | |||
| 117594 | 117594 | 114580 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 BEACH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002979.0 | 2121285.0 | 37.8048119223389 | -122.43394578498999 | (37.8048119223389, -122.43394578499) | |||
| 133821 | 133821 | 131769 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 787 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007533.34863 | 2120903.60484 | 37.804022109787 | -122.418157889387 | (37.804022109787, -122.418157889387) | |||
| 89317 | 89317 | 85483 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 123690 | 123690 | 85484 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 52201 | 52201 | 131767 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007044.7048 | 2120715.74188 | 37.8034787699919 | -122.419835539578 | (37.8034787699919, -122.419835539578) | |||
| 59114 | 59114 | 131766 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007046.8227699995 | 2120698.6660599997 | 37.803432003442396 | -122.419826997845 | (37.8034320034424, -122.419826997845) | |||
| 58113 | 58113 | 131703 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 15 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002059.94104 | 2120580.8033 | 37.802826185928 | -122.43707583099199 | (37.802826185928, -122.437075830992) | |||
| 40182 | 40182 | 131702 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 15 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002085.7752 | 2120558.53695 | 37.80276651681179 | -122.436984836681 | (37.8027665168118, -122.436984836681) | |||
| 151251 | 151251 | 58055 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1951 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 6 | Permit Number 17024 | 6002508.23206 | 2119853.3281 | 37.8008542011299 | -122.435472445005 | (37.8008542011299, -122.435472445005) | ||
| 58111 | 58111 | 131732 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1957 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002493.34846 | 2119850.49884 | 37.800845587415104 | -122.435523745933 | (37.8008455874151, -122.435523745933) | |||
| 52722 | 52722 | 58056 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1957 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1977 12:00:00 AM | 5 | Permit Number 17025 | 6002479.0246 | 2119847.84274 | 37.8008374809215 | -122.435573122311 | (37.8008374809215, -122.435573122311) | ||
| 129286 | 129286 | 53959 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1972 12:00:00 AM | Permit Number 9674 | 6004995.7689664 | 2119500.86037361 | 37.800027377944495 | -122.42683940106701 | (37.8000273779445, -122.426839401067) | |||
| 25027 | 25027 | 131695 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1661 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004976.36068 | 2119500.2240400002 | 37.800024533360705 | -122.42690651583901 | (37.8000245333607, -122.426906515839) | |||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 27901 | 27901 | 131768 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 940 Green St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6008521.12765 | 2119017.9011 | 37.7988999869032 | -122.41460607901699 | (37.7988999869032, -122.414606079017) | |||
| 163665 | 163665 | 131694 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1699 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6004942.7915199995 | 2118803.18958 | 37.798108757064796 | -122.426973006318 | (37.7981087570648, -122.426973006318) | |||
| 176815 | 176815 | 143359 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1699 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004931.6707 | 2118802.2471 | 37.7981055404278 | -122.42701142046499 | (37.7981055404278, -122.427011420465) | |||
| 86623 | 86623 | 107513 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 GREENWICH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999743.0 | 2118796.0 | 37.797793624169 | -122.444965226189 | (37.797793624169, -122.444965226189) | ||||||
| 151711 | 151711 | 143532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2001 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6003351.2703 | 2118581.8709 | 37.797410952833296 | -122.43246431528401 | (37.7974109528333, -122.432464315284) | |||
| 58260 | 58260 | 143531 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2001 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003323.1573 | 2118580.5634 | 37.7974057685705 | -122.43256150006 | (37.7974057685705, -122.43256150006) | |||
| 188014 | 188014 | 113280 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6003340.59835 | 2118579.59665 | 37.7974041031652 | -122.432501080454 | (37.7974041031652, -122.432501080454) | ||||
| 174982 | 174982 | 52214 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2001 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/2005 12:00:00 AM | 17 | Permit Number 48397 | 6003318.2213 | 2118578.20562 | 37.797399014802 | -122.432578411388 | (37.797399014802, -122.432578411388) | ||
| 7131 | 7131 | 116025 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1425 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 3x3 | 6006694.6941 | 2118351.37216 | 37.796967084814 | -122.42087880533501 | (37.796967084814, -122.420878805335) | ||
| 89600 | 89600 | 103266 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2365 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001713.0 | 2118319.0 | 37.796596142729896 | -122.43811430510799 | (37.7965961427299, -122.438114305108) | ||||
| 129264 | 129264 | 103265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2365 UNION ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001713.0 | 2118319.0 | 37.796596142729896 | -122.43811430510799 | (37.7965961427299, -122.438114305108) | |||||
| 76639 | 76639 | 131727 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2750 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5999177.276880001 | 2118259.18627 | 37.796287373624 | -122.44688412951 | (37.796287373624, -122.44688412951) | |||
| 163025 | 163025 | 105843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2740 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x9 | Permit Number 772454 | 5999179.30231 | 2118231.5166 | 37.796211515799605 | -122.446875129086 | (37.7962115157996, -122.446875129086) | ||
| 8062 | 8062 | 110903 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005480.89181 | 2117982.83198 | 37.7958866752705 | -122.425052620105 | (37.7958866752705, -122.425052620105) | |||
| 2855 | 2855 | 110902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005485.732559999 | 2117962.0378900003 | 37.795829853409295 | -122.425034389936 | (37.7958298534093, -122.425034389936) | |||
| 112978 | 112978 | 111298 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300X FRANKLIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005562.0 | 2117912.0 | 37.795696769899294 | -122.424766928636 | (37.7956967698993, -122.424766928636) | ||||
| 159091 | 159091 | 52591 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/27/2006 12:00:00 AM | 24 | Permit Number 48684 | 6005626.503190001 | 2117904.3459900003 | 37.7956793968408 | -122.424543191035 | (37.7956793968408, -122.424543191035) | ||
| 5086 | 5086 | 110900 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300x Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6005496.29651 | 2117906.44165 | 37.795677796936495 | -122.42499387908998 | (37.7956777969365, -122.42499387909) | |||
| 41226 | 41226 | 131752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005571.69035 | 2117900.5185 | 37.7956657919092 | -122.424732581057 | (37.7956657919092, -122.424732581057) | |||
| 167556 | 167556 | 131751 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6005602.995519999 | 2117899.87458 | 37.795665791896894 | -122.424624213638 | (37.7956657918969, -122.424624213638) | |||
| 46979 | 46979 | 131753 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6005546.70177 | 2117895.20308 | 37.795649785753604 | -122.42481866775299 | (37.7956497857536, -122.424818667753) | |||
| 47040 | 47040 | 131754 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6005523.755419999 | 2117889.5545099997 | 37.7956329801424 | -122.424897664214 | (37.7956329801424, -122.424897664214) | |||
| 75161 | 75161 | 41044 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1444 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2000 12:00:00 AM | Permit Number 41825 | 6007214.22869275 | 2117785.20726397 | 37.795441807697294 | -122.41904090928001 | (37.7954418076973, -122.41904090928) | ||
| 151846 | 151846 | 131750 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1715 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6005305.5059400005 | 2117794.9451099997 | 37.7953608767593 | -122.425646109704 | (37.7953608767593, -122.425646109704) | |||
| 35388 | 35388 | 53227 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1419 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1969 12:00:00 AM | 13 | 3x3 | Permit Number 6110 | 6007265.78904 | 2117749.89162 | 37.795347743065 | -122.41885999550301 | (37.795347743065, -122.418859995503) | |
| 8885 | 8885 | 53229 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1435 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 6112 | 6007249.74611 | 2117746.2070299997 | 37.795336722764795 | -122.41891524533999 | (37.7953367227648, -122.41891524534) | |
| 30452 | 30452 | 131764 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007026.74159 | 2117749.85493 | 37.7953341794929 | -122.419687137974 | (37.7953341794929, -122.419687137974) | |||
| 85073 | 85073 | 105050 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2835 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771766 | 6002056.0 | 2117852.0 | 37.7953333833033 | -122.436894002104 | (37.7953333833033, -122.436894002104) | |||
| 42437 | 42437 | 131765 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007015.710940001 | 2117748.69184 | 37.7953303645668 | -122.41972522333599 | (37.7953303645668, -122.419725223336) | |||
| 184821 | 184821 | 131744 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6000643.38971 | 2117843.6395400004 | 37.7952300397944 | -122.44178125031401 | (37.7952300397944, -122.441781250314) | |||
| 59211 | 59211 | 131748 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2621 Green St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000554.35554 | 2117844.3203 | 37.7952268355 | -122.44208937065399 | (37.7952268355, -122.442089370654) | |||
| 168465 | 168465 | 131747 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2621 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000509.412269999 | 2117838.25243 | 37.7952076133946 | -122.442244445228 | (37.7952076133946, -122.442244445228) | |||
| 46518 | 46518 | 131745 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2761 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000588.687530001 | 2117833.1066900003 | 37.795198002331794 | -122.44196977160802 | (37.7951980023318, -122.441969771608) | |||
| 150928 | 150928 | 131746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2621 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000485.91006 | 2117834.9484099997 | 37.7951972019456 | -122.442325529026 | (37.7951972019456, -122.442325529026) | |||
| 76644 | 76644 | 131743 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000645.36321 | 2117825.80498 | 37.795181183232 | -122.441773141117 | (37.795181183232, -122.441773141117) | |||
| 58000 | 58000 | 131742 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000648.257180001 | 2117809.9934900003 | 37.795137933933795 | -122.44176199223499 | (37.7951379339338, -122.441761992235) | |||
| 182272 | 182272 | 131763 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1457 Jones St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 3ft | 6008417.06699 | 2117517.79175 | 37.794775211263705 | -122.414859937834 | (37.7947752112637, -122.414859937834) | |||
| 122187 | 122187 | 99628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1856 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005263.1 | 2117519.3 | 37.7946016288287 | -122.425773211932 | (37.7946016288287, -122.425773211932) | ||||
| 23645 | 23645 | 131755 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1856 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6005252.93645 | 2117501.9314 | 37.7945533647075 | -122.425807142281 | (37.7945533647075, -122.425807142281) | |||
| 130255 | 130255 | 131760 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1350 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6008501.62739 | 2117179.1057599997 | 37.793850013919396 | -122.414543368407 | (37.7938500139194, -122.414543368407) | |||
| 61230 | 61230 | 131762 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 24 Priest St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6008325.68222 | 2117173.18984 | 37.793823884108896 | -122.41515173816799 | (37.7938238841089, -122.415151738168) | |||
| 134945 | 134945 | 131759 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1350 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6008504.851969999 | 2117159.14189 | 37.7937953791974 | -122.41453079766899 | (37.7937953791974, -122.414530797669) | |||
| 181863 | 181863 | 131761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 24 Priest St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6008326.19973 | 2117161.77492 | 37.7937925706325 | -122.415149139144 | (37.7937925706325, -122.415149139144) | |||
| 161849 | 161849 | 131749 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2424 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6003697.91067 | 2116832.49049 | 37.7926272533989 | -122.431139921469 | (37.7926272533989, -122.431139921469) | |||
| 163213 | 163213 | 131758 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008573.70037 | 2116368.91585 | 37.791629479864795 | -122.414236639307 | (37.7916294798648, -122.414236639307) | |||
| 41556 | 41556 | 131712 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5998504.875 | 2116569.78161 | 37.7916102829449 | -122.449089004562 | (37.7916102829449, -122.449089004562) | |||
| 179582 | 179582 | 131713 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998501.34187 | 2116568.43338 | 37.791606378991 | -122.449101131933 | (37.791606378991, -122.449101131933) | |||
| 184453 | 184453 | 131714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998496.90584 | 2116567.36238 | 37.791603184595104 | -122.44911640329398 | (37.7916031845951, -122.449116403294) | |||
| 135456 | 135456 | 131715 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998491.43186 | 2116566.313 | 37.791599990194705 | -122.449135267491 | (37.7915999901947, -122.449135267491) | |||
| 70891 | 70891 | 131716 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3250 Pacific Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 5998485.19807 | 2116566.1841 | 37.7915992797271 | -122.449156826952 | (37.7915992797271, -122.449156826952) | |||
| 8703 | 8703 | 2829 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6008547.0936900005 | 2116310.73962 | 37.7914682476113 | -122.414324580422 | (37.7914682476113, -122.414324580422) | |||
| 3267 | 3267 | 2831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6008484.02773 | 2116302.9533599997 | 37.791443325609606 | -122.414542237062 | (37.7914433256096, -122.414542237062) | |||
| 6574 | 6574 | 2832 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008465.75544 | 2116301.4842 | 37.7914382651038 | -122.414605355047 | (37.7914382651038, -122.414605355047) | |||
| 66867 | 66867 | 131741 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6000273.04756 | 2116436.32711 | 37.7913448210684 | -122.44296157632 | (37.7913448210684, -122.44296157632) | |||
| 22903 | 22903 | 131740 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6000252.76516 | 2116432.30199 | 37.7913326127476 | -122.443031463558 | (37.7913326127476, -122.443031463558) | |||
| 64283 | 64283 | 131739 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2911 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6000239.33655 | 2116430.67525 | 37.7913273804943 | -122.443077809215 | (37.7913273804943, -122.443077809215) | |||
| 165758 | 165758 | 131738 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2911 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6000212.4749300005 | 2116427.2103 | 37.7913163350409 | -122.443170500539 | (37.7913163350409, -122.443170500539) | |||
| 133273 | 133273 | 53674 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1970 12:00:00 AM | 27 | 3x3 | Permit Number 6615 | 6000847.30796 | 2116375.23213 | 37.7912097941415 | -122.44097026868401 | (37.7912097941415, -122.440970268684) | |
| 97056 | 97056 | 89006 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2200 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51758 | 6003287.9 | 2116231.2 | 37.7909530209385 | -122.432515604779 | (37.7909530209385, -122.432515604779) | |||
| 73443 | 73443 | 131737 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6000792.75525 | 2116183.5365400002 | 37.7906803407803 | -122.441145259657 | (37.7906803407803, -122.441145259657) | |||
| 157009 | 157009 | 131736 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6000776.55932 | 2116181.75535 | 37.7906745275563 | -122.44120116870701 | (37.7906745275563, -122.441201168707) | |||
| 26327 | 26327 | 131735 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000766.13673 | 2116181.54807 | 37.7906733647218 | -122.441237215332 | (37.7906733647218, -122.441237215332) | |||
| 59506 | 59506 | 131734 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000749.28539 | 2116178.9335 | 37.7906652258746 | -122.441295332225 | (37.7906652258746, -122.441295332225) | |||
| 189120 | 189120 | 98169 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2941 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 19 | 3x3 | Permit Number 775039 | 6000613.54695 | 2116154.22533 | 37.7905896504327 | -122.44176320452299 | (37.7905896504327, -122.441763204523) |
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");