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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 27456 | 27456 | 137716 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1715 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6000894.9856 | 2111365.2022 | 37.7774562545891 | -122.44044583067199 | (37.7774562545891, -122.440445830672) | |||
| 27643 | 27643 | 181815 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2159 Santiago St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986329.9743 | 2099566.0897 | 37.7442190511422 | -122.489962295681 | (37.7442190511422, -122.489962295681) | |||
| 27741 | 27741 | 247440 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 411 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002662.5381 | 2109990.6164 | 37.7737824699372 | -122.434232995209 | (37.7737824699372, -122.434232995209) | |||
| 27816 | 27816 | 98414 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1950 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | Permit Number 10048 | 6001966.8495 | 2115276.3833 | 37.7882563383359 | -122.437017989682 | (37.7882563383359, -122.437017989682) | ||
| 28257 | 28257 | 184670 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1674 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983787.3849 | 2103767.4777 | 37.7556061038013 | -122.499064243948 | (37.7556061038013, -122.499064243948) | |||
| 28286 | 28286 | 123346 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5994637.6503 | 2112621.39371 | 37.7805471408016 | -122.46218298840701 | (37.7805471408016, -122.462182988407) | |||
| 28598 | 28598 | 247434 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 415 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002654.5463 | 2110037.7678 | 37.773911482391796 | -122.434264011685 | (37.7739114823918, -122.434264011685) | |||
| 28663 | 28663 | 139104 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1310 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999794.8944 | 2113362.4726 | 37.7828775449523 | -122.444394968217 | (37.7828775449523, -122.444394968217) | |||
| 28767 | 28767 | 182950 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2403 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5990117.7426 | 2098930.2885 | 37.7426937581019 | -122.47681870798 | (37.7426937581019, -122.47681870798) | |||
| 28891 | 28891 | 210482 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992578.85706 | 2099157.09112 | 37.7434589563754 | -122.46832545275299 | (37.7434589563754, -122.468325452753) | |||
| 29254 | 29254 | 210471 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1672 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5991206.46834 | 2104010.5749 | 37.7567059962049 | -122.473424713099 | (37.7567059962049, -122.473424713099) | |||
| 29664 | 29664 | 182169 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1515 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5989576.3537 | 2104441.2002 | 37.7577938469224 | -122.479093679176 | (37.7577938469224, -122.479093679176) | |||
| 30081 | 30081 | 139425 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1397 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000185.9654 | 2113663.7739 | 37.783727145735796 | -122.443063675246 | (37.7837271457358, -122.443063675246) | |||
| 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) | |||
| 30773 | 30773 | 247433 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 415 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002656.9439 | 2110054.5506 | 37.7739576998834 | -122.43425691806401 | (37.7739576998834, -122.434256918064) | |||
| 31050 | 31050 | 119202 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5981058.93539 | 2109762.95865 | 37.7719075327332 | -122.508945060001 | (37.7719075327332, -122.508945060001) | |||
| 31308 | 31308 | 181437 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Lower Great Hwy | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5980841.348999999 | 2105728.8419999997 | 37.7608181926765 | -122.50939803508601 | (37.7608181926765, -122.509398035086) | |||
| 31460 | 31460 | 182904 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2958 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5981700.1948 | 2096535.1841 | 37.7356255864855 | -122.50574614840299 | (37.7356255864855, -122.505746148403) | |||
| 31490 | 31490 | 199752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1555 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014842.8005 | 2092447.5888 | 37.7262968166738 | -122.39087288178601 | (37.7262968166738, -122.390872881786) | |||
| 31754 | 31754 | 245016 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 209 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999835.8727 | 2109238.691 | 37.7715570324875 | -122.443956812942 | (37.7715570324875, -122.443956812942) | |||
| 31934 | 31934 | 182166 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1521 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5989522.953 | 2104437.9039 | 37.7577816948216 | -122.47927811775601 | (37.7577816948216, -122.479278117756) | |||
| 32416 | 32416 | 111290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 285 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776047 | 5990541.73439 | 2113523.7121099997 | 37.7827879717093 | -122.476418488313 | (37.7827879717093, -122.476418488313) | |
| 32461 | 32461 | 232382 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 795 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6001307.04772 | 2102006.18851 | 37.7517821612399 | -122.438349704471 | (37.7517821612399, -122.438349704471) | |||
| 32892 | 32892 | 131757 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 755 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008986.6989400005 | 2115264.8401099998 | 37.788621146006605 | -122.412729575233 | (37.7886211460066, -122.412729575233) | |||
| 33053 | 33053 | 119258 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6011770.8518 | 2105153.5101900003 | 37.761013626490204 | -122.402385519974 | (37.7610136264902, -122.402385519974) | |||
| 33178 | 33178 | 182783 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1790 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5989709.7208 | 2103167.2369999997 | 37.7543036278795 | -122.478539284935 | (37.7543036278795, -122.478539284935) | |||
| 33386 | 33386 | 131733 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2999 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000450.462280001 | 2116133.47283 | 37.7905233758091 | -122.442325975968 | (37.7905233758091, -122.442325975968) | |||
| 33450 | 33450 | 245105 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 250 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5999853.8212 | 2109427.1506 | 37.7720755187291 | -122.443908271008 | (37.7720755187291, -122.443908271008) | |||
| 33856 | 33856 | 119195 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 850 La Playa | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980799.52647 | 2109772.2275400003 | 37.771917686863205 | -122.50984304652201 | (37.7719176868632, -122.509843046522) | |||
| 33896 | 33896 | 96037 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2024 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6012798.80107 | 2095988.64888 | 37.7359062123914 | -122.39818725804301 | (37.7359062123914, -122.398187258043) |
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");