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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11465 | 11465 | 107858 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2908 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778432 | 5981789.5382 | 2096536.8762 | 37.735635490547 | -122.505437384685 | (37.735635490547, -122.505437384685) | |
| 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) | |||
| 12762 | 12762 | 116742 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1638 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2016 12:00:00 AM | 3 | 6x3 | Permit Number 778698 | 5983780.8141 | 2103988.0199 | 37.756211265636296 | -122.499103262084 | (37.7562112656363, -122.499103262084) | |
| 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) | |||
| 13181 | 13181 | 117441 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1204 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778732 | 5989885.5669 | 2107139.7037 | 37.765221164359495 | -122.47822160390498 | (37.7652211643595, -122.478221603905) | |
| 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 | ||||||||
| 14583 | 14583 | 25961 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 2x3 | 6011423.37679 | 2098134.57194 | 37.7417217530491 | -122.403093568809 | (37.7417217530491, -122.403093568809) | ||
| 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) | |||
| 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) | |
| 15432 | 15432 | 25962 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2193 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 2X3 | 6011447.1772300005 | 2098118.06457 | 37.7416777564365 | -122.40301011353901 | (37.7416777564365, -122.403010113539) | ||
| 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) | |||
| 17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
| 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) | |||
| 18962 | 18962 | 29617 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991168.23882 | 2090896.94142 | 37.7206970910675 | -122.472600860348 | (37.7206970910675, -122.472600860348) | ||
| 19078 | 19078 | 16995 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 900 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6002566.6368 | 2109915.0941 | 37.7735696608208 | -122.43455933158998 | (37.7735696608208, -122.43455933159) | ||
| 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) | |||
| 20221 | 20221 | 4226 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3982 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004028.819080001 | 2100444.38934 | 37.7476482601598 | -122.42882611964501 | (37.7476482601598, -122.428826119645) | |||
| 20254 | 20254 | 23999 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 300 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5992235.8832 | 2097133.9008 | 37.7378839736291 | -122.469364124733 | (37.7378839736291, -122.469364124733) | |||
| 20399 | 20399 | 8212 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992284.57704 | 2100523.9125099997 | 37.7471948966366 | -122.46944246202 | (37.7471948966366, -122.46944246202) | |||
| 20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
| 20958 | 20958 | 3909 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002142.832230001 | 2107666.80115 | 37.7673723370035 | -122.43586443430901 | (37.7673723370035, -122.435864434309) | |||
| 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) | |||||
| 21139 | 21139 | 8218 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8X25 | 5992283.97023 | 2100569.2840400003 | 37.7473194401374 | -122.46944786245199 | (37.7473194401374, -122.469447862452) | |||
| 21350 | 21350 | 5101 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2629 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6002336.13825 | 2096372.73058 | 37.7363724838986 | -122.43438824303101 | (37.7363724838986, -122.434388243031) | |||
| 21615 | 21615 | 8213 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992288.54504 | 2100526.93925 | 37.7472034366016 | -122.469428961394 | (37.7472034366016, -122.469428961394) | |||
| 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) | ||||
| 22423 | 22423 | 18155 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005677.61973 | 2114458.9667 | 37.7862221342749 | -122.42412117337099 | (37.7862221342749, -122.424121173371) | |||
| 22514 | 22514 | 18154 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005654.5988300005 | 2114457.04911 | 37.7862155692388 | -122.42420068332899 | (37.7862155692388, -122.424200683329) | |||
| 22671 | 22671 | 18156 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005730.74632 | 2114465.38856 | 37.786242766547105 | -122.42393782586399 | (37.7862427665471, -122.423937825864) | |||
| 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) | ||
| 23048 | 23048 | 8638 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 0 | 5999322.495 | 2113336.6421 | 37.782779656634396 | -122.44602740853901 | (37.7827796566344, -122.446027408539) | |||
| 23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
| 23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
| 23246 | 23246 | 8613 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2660 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 20 | 5998899.2985 | 2113220.7326 | 37.7824372241255 | -122.447483138223 | (37.7824372241255, -122.447483138223) | |||
| 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) | |||
| 24433 | 24433 | 232350 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 500x 27th St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6002774.61344 | 2100063.62492 | 37.746531703279096 | -122.433135885834 | (37.7465317032791, -122.433135885834) | |||
| 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) | |||
| 25830 | 25830 | 61870 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 3657 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1985 12:00:00 AM | 18 | Permit Number 21910 | 5997325.23307 | 2115369.87037 | 37.7882481090091 | -122.453083875833 | (37.7882481090091, -122.453083875833) | ||
| 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) |
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");