Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 35 | 183515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2562 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779639 | 5988336.7554 | 2097879.9474 | 37.7397063254514 | -122.482899813956 | (37.7397063254514, -122.482899813956) | |
| 191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
| 263 | 263 | 141358 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 654 | 654 | 122328 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3015 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779630 | 5996535.0 | 2111432.0 | 37.7773904414434 | -122.455533202662 | (37.7773904414434, -122.455533202662) | |
| 694 | 694 | 120738 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700x 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 4ft | 5989768.19982 | 2110516.41697 | 37.7744858825371 | -122.478874537994 | (37.7744858825371, -122.478874537994) | ||
| 717 | 717 | 106656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | |
| 720 | 720 | 104746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989767.16587 | 2110527.4876599996 | 37.774516219561704 | -122.478878924469 | (37.7745162195617, -122.478878924469) | |
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 1262 | 1262 | 251479 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1214 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 779194 | 5987090.84961 | 2106996.2792700003 | 37.7646647351899 | -122.48787719677 | (37.7646647351899, -122.48787719677) | ||||
| 1333 | 1333 | 187634 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779931 | 5987142.0 | 2114987.0 | 37.786607985699604 | -122.48828755026399 | (37.7866079856996, -122.488287550264) | |||
| 1412 | 1412 | 120316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779745 | 5988743.0107 | 2113100.3508099997 | 37.7815210589505 | -122.482610207249 | (37.7815210589505, -122.482610207249) | |
| 1545 | 1545 | 142037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1549 | 1549 | 142039 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 1550 | 1550 | 142038 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1499X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6000824.0 | 2111032.0 | 37.7765373235881 | -122.44066748676701 | (37.7765373235881, -122.440667486767) | |||
| 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) | |||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 4547 | 4547 | 131706 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 4551 | 4551 | 131707 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 135 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997495.0 | 2115921.0 | 37.789771092089794 | -122.452536302556 | (37.7897710920898, -122.452536302556) | |||
| 5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 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) | |||
| 5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5601 | 5601 | 116211 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996580.5135 | 2114939.45555 | 37.7870235965959 | -122.455629343026 | (37.7870235965959, -122.455629343026) | |
| 5802 | 5802 | 122541 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2233 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779046 | 6001437.2497 | 2113869.2014 | 37.7843624618515 | -122.438749438347 | (37.7843624618515, -122.438749438347) | |
| 7159 | 7159 | 116209 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996627.1701 | 2114945.18052 | 37.787041993130295 | -122.455468336508 | (37.7870419931303, -122.455468336508) | |
| 7502 | 7502 | 116210 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3801 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778748 | 5996604.94532 | 2114941.4574599997 | 37.787030495305 | -122.455544959643 | (37.787030495305, -122.455544959643) | |
| 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) | |||
| 8281 | 8281 | 114455 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1985 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6000100.5375 | 2111597.9948 | 37.7780501757265 | -122.44321080446801 | (37.7780501757265, -122.443210804468) | |||
| 8845 | 8845 | 101651 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5999032.2983 | 2113371.3303 | 37.782858325822 | -122.447033859882 | (37.782858325822, -122.447033859882) | |||
| 9615 | 9615 | 138532 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1670 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6001631.8101 | 2114208.4561 | 37.785305035186894 | -122.438100638619 | (37.7853050351869, -122.438100638619) | ||||
| 9779 | 9779 | 114426 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 486 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 4x4 | 5985968.50007 | 2112632.43388 | 37.7800744897886 | -122.49217408228901 | (37.7800744897886, -122.492174082289) | |||
| 9808 | 9808 | 121557 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | |
| 9810 | 9810 | 121556 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 779269 | 6003622.0 | 2102696.0 | 37.7538076209017 | -122.430393500907 | (37.7538076209017, -122.430393500907) | ||
| 9833 | 9833 | 173705 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 181 Addison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002695.0 | 2097057.0 | 37.738271693727796 | -122.433196386583 | (37.7382716937278, -122.433196386583) | ||||
| 9861 | 9861 | 118901 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980648.88475 | 2109606.3629099997 | 37.7714533859213 | -122.510351791198 | (37.7714533859213, -122.510351791198) | |
| 9868 | 9868 | 173714 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699x 29th St | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | ||||
| 9873 | 9873 | 118917 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 855 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 4x4 | 5980738.79777 | 2109987.23765 | 37.772504459681 | -122.510069084185 | (37.772504459681, -122.510069084185) | ||
| 9874 | 9874 | 118902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980610.1556400005 | 2109606.19987 | 37.771450653513206 | -122.510485742594 | (37.7714506535132, -122.510485742594) | |
| 9946 | 9946 | 173747 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2799x 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981791.0 | 2096580.0 | 37.735753982711294 | -122.50543552617201 | (37.7357539827113, -122.505435526172) | ||||
| 10037 | 10037 | 122341 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 401 04th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2017 12:00:00 AM | 3 | 3x3 | 5994600.0 | 2112752.0 | 37.780903582725 | -122.462322713118 | (37.780903582725, -122.462322713118) | ||
| 10039 | 10039 | 106657 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 10 | 3x3 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | ||
| 10258 | 10258 | 173932 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109x Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003491.0 | 2094313.0 | 37.7307824159859 | -122.430248501015 | (37.7307824159859, -122.430248501015) | |||||
| 10642 | 10642 | 113534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3601 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5981793.2608 | 2096687.6431 | 37.7360496742075 | -122.505435686033 | (37.7360496742075, -122.505435686033) | |||
| 11232 | 11232 | 110349 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1948 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5989635.8842 | 2106540.7717 | 37.7635621624427 | -122.479041373687 | (37.7635621624427, -122.479041373687) | |||
| 11276 | 11276 | 110108 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4130 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | 5981417.4705 | 2103534.0756 | 37.75482594364829 | -122.507242691355 | (37.7548259436483, -122.507242691355) | ||
| 11284 | 11284 | 105132 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1619 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | 3x3 | Permit Number 777355 | 5981562.16 | 2104041.1764 | 37.756226819608 | -122.50677993398399 | (37.756226819608, -122.506779933984) | ||
| 11349 | 11349 | 104508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 Dichiera Ct | 1 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 14 | 5998566.299869999 | 2087993.98473 | 37.7131516918716 | -122.446819386407 | (37.7131516918716, -122.446819386407) | ||||
| 11510 | 11510 | 107860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3667 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 777933 | 5981683.9506 | 2096685.2741 | 37.7360367363779 | -122.505813433386 | (37.7360367363779, -122.505813433386) | |||
| 11968 | 11968 | 105207 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2928 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5981748.5891 | 2096534.5072 | 37.7356265760949 | -122.50557878346301 | (37.7356265760949, -122.505578783463) | |||
| 15372 | 15372 | 116055 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/30/2016 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.40328006754801 | (37.7611252557522, -122.403280067548) | |
| 18158 | 18158 | 96243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100X 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005866.5 | 2100251.5 | 37.7472224703829 | -122.42245781101299 | (37.7472224703829, -122.422457811013) | |||
| 20976 | 20976 | 108213 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 126 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995164.0 | 2113575.0 | 37.783195780257 | -122.46043122472 | (37.783195780257, -122.46043122472) | |||||
| 21679 | 21679 | 210472 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 624 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993801.69661 | 2106684.35823 | 37.764197452264106 | -122.464643687651 | (37.7641974522641, -122.464643687651) | ||||
| 22884 | 22884 | 119188 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5980787.759319999 | 2110046.86087 | 37.7726710552755 | -122.509904154395 | (37.7726710552755, -122.509904154395) | |||
| 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) | |||
| 22912 | 22912 | 210552 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 414 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5995155.65345 | 2100448.38141 | 37.7471530116111 | -122.459509101961 | (37.7471530116111, -122.459509101961) | |||
| 22975 | 22975 | 114454 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1985 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2016 12:00:00 AM | 3 | 3x3 | 6000094.0 | 2111584.0 | 37.7780113768023 | -122.44323241454501 | (37.7780113768023, -122.443232414545) | ||
| 23432 | 23432 | 232311 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1210 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997778.57601 | 2106237.8657400003 | 37.763199962017495 | -122.450856672402 | (37.7631999620175, -122.450856672402) | |||
| 23578 | 23578 | 181600 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980858.6373 | 2105611.0043 | 37.7604956636473 | -122.50932949211399 | (37.7604956636473, -122.509329492114) | |||
| 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) | |||
| 23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
| 23806 | 23806 | 232314 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007320.806890001 | 2098778.15204 | 37.7432589210582 | -122.417324523624 | (37.7432589210582, -122.417324523624) | ||||
| 23867 | 23867 | 232408 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6002395.6787 | 2098158.1545599997 | 37.7412782244979 | -122.43430999392099 | (37.7412782244979, -122.434309993921) | |||
| 23868 | 23868 | 182925 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2630 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5982150.6342 | 2097187.3229 | 37.737442682143204 | -122.50423712648701 | (37.7374426821432, -122.504237126487) | |||
| 24163 | 24163 | 194035 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6012914.68454 | 2106566.8968 | 37.7649582598465 | -122.398528655089 | (37.7649582598465, -122.398528655089) | |||
| 24344 | 24344 | 232330 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6002073.993430001 | 2098798.17814 | 37.743017315492295 | -122.435468040134 | (37.7430173154923, -122.435468040134) | |||
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 24632 | 24632 | 124488 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3015 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 5996527.76957 | 2111462.12046 | 37.7774727294111 | -122.45556039254299 | (37.7774727294111, -122.455560392543) | |||
| 24721 | 24721 | 244203 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 530 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004029.0238 | 2109765.535 | 37.773241915468205 | -122.429490048832 | (37.7732419154682, -122.429490048832) | |||
| 24757 | 24757 | 210558 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 140 Hernandez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 5995578.737319999 | 2099631.293 | 37.7449338085654 | -122.457986999419 | (37.7449338085654, -122.457986999419) | |||
| 24948 | 24948 | 186573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 44 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5984743.4554 | 2104652.876 | 37.758093198452 | -122.49582321186399 | (37.758093198452, -122.495823211864) | |||
| 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) | |||
| 25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
| 25169 | 25169 | 232371 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 109 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999451.75369 | 2107695.0323799998 | 37.767296616782396 | -122.44517449760001 | (37.7672966167824, -122.4451744976) | |||
| 25191 | 25191 | 184668 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1670 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5983786.0370000005 | 2103786.6846 | 37.7556587615187 | -122.49907032440001 | (37.7556587615187, -122.4990703244) | |||
| 25620 | 25620 | 141384 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6000753.3021 | 2110038.3082 | 37.7738048706395 | -122.440840751605 | (37.7738048706395, -122.440840751605) | |||
| 25950 | 25950 | 232321 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1027 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001337.57778 | 2100767.91475 | 37.7483838939011 | -122.43815543204201 | (37.7483838939011, -122.438155432042) | |||
| 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) | |||
| 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) | |||
| 26378 | 26378 | 118551 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8140 Geary Blvd | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 5981667.59483 | 2112398.2493 | 37.7791791285325 | -122.50703522193999 | (37.7791791285325, -122.50703522194) | ||||
| 26460 | 26460 | 182920 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2738 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5981601.7141 | 2096643.1406 | 37.735916208709504 | -122.506094630091 | (37.7359162087095, -122.506094630091) | |||
| 26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
| 26665 | 26665 | 210567 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 583 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6000102.08366 | 2095631.3268099998 | 37.7342096989166 | -122.442059080555 | (37.7342096989166, -122.442059080555) | |||
| 26669 | 26669 | 210574 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 222 Ridgewood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5996816.481980001 | 2094866.93739 | 37.731923082681206 | -122.453363219651 | (37.7319230826812, -122.453363219651) | |||
| 26734 | 26734 | 141019 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 400 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997825.3169 | 2112597.8673 | 37.7806655664219 | -122.451153693978 | (37.7806655664219, -122.451153693978) | |||
| 26767 | 26767 | 247424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 418 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6002692.6593 | 2110101.2986 | 37.7740880853883 | -122.434136715187 | (37.7740880853883, -122.434136715187) | |||
| 26814 | 26814 | 185398 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2300 Sunset Blvd | 11 | unknown : Yard 19 | Tree 1 | Private 1 | 6 | Width 0ft | 5985116.1317 | 2099019.9363 | 37.7426485067542 | -122.49411919382099 | (37.7426485067542, -122.494119193821) | |||
| 26890 | 26890 | 245141 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 230 Central Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999865.7869 | 2109339.0698 | 37.771834353658704 | -122.443860551446 | (37.7718343536587, -122.443860551446) | |||
| 26950 | 26950 | 232415 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6002483.65032 | 2097689.74607 | 37.7399970763969 | -122.43397234527201 | (37.7399970763969, -122.433972345272) | |||
| 27011 | 27011 | 210522 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5995082.26055 | 2089674.2189 | 37.717565568077504 | -122.45898290776 | (37.7175655680775, -122.45898290776) | |||
| 27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) | |||
| 27056 | 27056 | 118069 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 450 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5985028.86259 | 2112823.44645 | 37.7805439813248 | -122.49543875674699 | (37.7805439813248, -122.495438756747) | |||
| 27103 | 27103 | 194036 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 198 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6013693.35133 | 2106219.8544799997 | 37.764048707105495 | -122.395811103495 | (37.7640487071055, -122.395811103495) | |||
| 27203 | 27203 | 210530 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 717 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5992156.75064 | 2089178.54268 | 37.7160359561589 | -122.46905891645399 | (37.7160359561589, -122.469058916454) | |||
| 27210 | 27210 | 118030 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984259.34297 | 2112813.72518 | 37.7804722014619 | -122.498100130783 | (37.7804722014619, -122.498100130783) | |||
| 27451 | 27451 | 232290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6004782.10663 | 2096684.4357 | 37.737366892177704 | -122.425953683239 | (37.7373668921777, -122.425953683239) |
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");