Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant
qSiteInfo ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 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) | |||
| 595 | 595 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 299x Avalon Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 867 | 867 | 5563 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005047.93676 | 2102495.8008 | 37.753338590028 | -122.42544803402399 | (37.753338590028, -122.425448034024) | |||
| 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) | |||
| 1214 | 1214 | 14441 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 57 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 4X4 | 5998815.3699 | 2112874.8656 | 37.781482766726896 | -122.447748586483 | (37.7814827667269, -122.447748586483) | |||
| 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) | |||
| 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) | |||
| 1687 | 1687 | 18887 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2407 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003191.46268 | 2115855.10762 | 37.789914898090004 | -122.432822394747 | (37.78991489809, -122.432822394747) | |||
| 2528 | 2528 | 138185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1865 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003940.6794 | 2114739.7851 | 37.786894968468 | -122.43015057261002 | (37.786894968468, -122.43015057261) | |||
| 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) | |||
| 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) | |||
| 3830 | 3830 | 14440 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 45 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 5998808.9399 | 2112938.4889 | 37.78165709226779 | -122.44777541277399 | (37.7816570922678, -122.447775412774) | |||
| 4023 | 4023 | 232380 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6001617.91184 | 2102022.2796 | 37.7518440201921 | -122.437275848296 | (37.7518440201921, -122.437275848296) | |||
| 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) | |||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 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) | ||||
| 5433 | 5433 | 8620 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113220.5634 | 37.7824608186771 | -122.446026081758 | (37.7824608186771, -122.446026081758) | |||
| 5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) | |||
| 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) | |||
| 6978 | 6978 | 6035 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001552.687000001 | 2112546.4084 | 37.780736975678295 | -122.438255270265 | (37.7807369756783, -122.438255270265) | |||
| 7106 | 7106 | 8639 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 5999285.607000001 | 2113327.5047 | 37.7827524611939 | -122.446154367514 | (37.7827524611939, -122.446154367514) | |||
| 7236 | 7236 | 8621 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113213.4566 | 37.782441305247104 | -122.446025570431 | (37.7824413052471, -122.446025570431) | |||
| 7592 | 7592 | 98477 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3020 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999352.2396 | 2114673.6817 | 37.7864525177898 | -122.44602070386999 | (37.7864525177898, -122.44602070387) | |||
| 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) | |||
| 8418 | 8418 | 98478 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3022 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 5999322.5683 | 2114670.9216 | 37.7864432448969 | -122.44612316014201 | (37.7864432448969, -122.446123160142) | |||
| 8476 | 8476 | 8633 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999163.0983 | 2113201.6118 | 37.7823997950612 | -122.44656913375401 | (37.7823997950612, -122.446569133754) | |||
| 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) | |||
| 8762 | 8762 | 8614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2660 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5998899.9753 | 2113233.2542 | 37.782471643857896 | -122.44748169838999 | (37.7824716438579, -122.44748169839) | |||
| 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) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 9880 | 9880 | 3771 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1100X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012538.0 | 2102781.0 | 37.75454202913279 | -122.39956569430599 | (37.7545420291328, -122.399565694306) | |||
| 9884 | 9884 | 173718 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 906 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 3x3 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 9912 | 9912 | 173731 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 484 Chenery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003566.0 | 2096120.0 | 37.7357482768139 | -122.43011807363199 | (37.7357482768139, -122.430118073632) | |||||
| 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) | ||||
| 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) | |||
| 10779 | 10779 | 831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1388 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5.5x6.5 | 5981551.002 | 2105650.5805 | 37.7606451268888 | -122.506937898142 | (37.7606451268888, -122.506937898142) | |||
| 10811 | 10811 | 823 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1381 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5981813.5224 | 2105689.4462 | 37.760767297588295 | -122.50603285620599 | (37.7607672975883, -122.506032856206) | |||
| 11179 | 11179 | 97318 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1026 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5989977.5691 | 2099069.2019 | 37.7430670461122 | -122.477313532312 | (37.7430670461122, -122.477313532312) | |||
| 11201 | 11201 | 19747 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 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) | |||
| 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) | ||||
| 11464 | 11464 | 97310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 916 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5990323.69 | 2099081.1313 | 37.7431198777207 | -122.476117623457 | (37.7431198777207, -122.476117623457) | |||
| 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) | |||
| 11593 | 11593 | 116739 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1678 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778366 | 5983788.3957 | 2103743.2164 | 37.755539548337204 | -122.49905895584999 | (37.7555395483372, -122.49905895585) | |||
| 11806 | 11806 | 15748 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4617 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002094.7066 | 2092005.3194 | 37.7243668615839 | -122.43491072988998 | (37.7243668615839, -122.43491072989) | |||
| 11842 | 11842 | 19713 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 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) | |||
| 12182 | 12182 | 19712 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 12286 | 12286 | 97316 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1000 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5990092.4633 | 2099074.5321 | 37.7430883471851 | -122.47691665284201 | (37.7430883471851, -122.476916652842) | |||
| 12647 | 12647 | 115149 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2430 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | Permit Number 777450 | 5987687.2149 | 2098724.2655 | 37.7419867848349 | -122.48520755477199 | (37.7419867848349, -122.485207554772) | ||
| 12649 | 12649 | 24533 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5981505.7764 | 2105644.9273 | 37.7606269413357 | -122.507093890918 | (37.7606269413357, -122.507093890918) | |||
| 13008 | 13008 | 19766 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 13014 | 13014 | 24510 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5981246.2202 | 2105482.1578 | 37.7601647328681 | -122.507979481979 | (37.7601647328681, -122.507979481979) | |||
| 13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
| 13254 | 13254 | 115458 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 476 FAIR OAKS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005502.0 | 2100939.0 | 37.7490896185955 | -122.423767101444 | (37.7490896185955, -122.423767101444) | ||||
| 13301 | 13301 | 187651 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 175 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998689.0 | 2104063.0 | 37.7572803991188 | -122.447551270828 | (37.7572803991188, -122.447551270828) | |||||
| 14337 | 14337 | 19746 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
| 14544 | 14544 | 19711 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 14667 | 14667 | 3750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012463.2126 | 2103693.82662 | 37.7570442824941 | -122.39988842642401 | (37.7570442824941, -122.399888426424) | |||
| 15820 | 15820 | 19764 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 16592 | 16592 | 19752 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 16910 | 16910 | 7017 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1055 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002366.0432 | 2110180.0215 | 37.774285696400206 | -122.435272167554 | (37.7742856964002, -122.435272167554) | |||
| 17299 | 17299 | 8210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992281.31882 | 2100517.50117 | 37.7471771044468 | -122.469453261968 | (37.7471771044468, -122.469453261968) | |||
| 17380 | 17380 | 4177 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3811 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005046.8356800005 | 2100458.58709 | 37.7477448104687 | -122.425306883625 | (37.7477448104687, -122.425306883625) | |||
| 17849 | 17849 | 26939 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005048.52765 | 2102486.42553 | 37.7533128811044 | -122.42544532345501 | (37.7533128811044, -122.425445323455) | |||
| 17876 | 17876 | 4225 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3982 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004042.0862300005 | 2100445.7636700002 | 37.747652784654704 | -122.428780340555 | (37.7476527846547, -122.428780340555) | |||
| 17928 | 17928 | 22547 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6001443.018180001 | 2098660.99719 | 37.7426047928778 | -122.437639954147 | (37.7426047928778, -122.437639954147) | |||
| 18018 | 18018 | 4976 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 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) | |||
| 18335 | 18335 | 8215 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992282.36795 | 2100542.6208599997 | 37.7472461372953 | -122.469451462412 | (37.7472461372953, -122.469451462412) | |||
| 18536 | 18536 | 8217 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992282.7442 | 2100560.49724 | 37.7472952429876 | -122.469451462429 | (37.7472952429876, -122.469451462429) | |||
| 18727 | 18727 | 3939 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 999X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002271.23678 | 2107631.4399099997 | 37.7672825369934 | -122.43541777162201 | (37.7672825369934, -122.435417771622) | |||
| 18961 | 18961 | 8216 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.56126 | 2100549.85323 | 37.7472660644888 | -122.469447862447 | (37.7472660644888, -122.469447862447) | |||
| 19157 | 19157 | 22548 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 19 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 6001457.66842 | 2098646.06303 | 37.7425646201593 | -122.437588228722 | (37.7425646201593, -122.437588228722) | |||
| 19162 | 19162 | 9363 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 256 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2x2 | 6001113.86641 | 2098278.49055 | 37.7415357993513 | -122.43875065912901 | (37.7415357993513, -122.438750659129) | |||
| 19720 | 19720 | 8219 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.90112 | 2100578.3571900004 | 37.747344348682795 | -122.469448761774 | (37.7473443486828, -122.469448761774) |
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");