Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 126064 | 126064 | 9313 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 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) | |||
| 91528 | 91528 | 12533 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 129 LAKE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 80 | 3X3 | 5995062.0 | 2114816.5 | 37.786598736379105 | -122.460874108141 | (37.7865987363791, -122.460874108141) | ||
| 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) | |||
| 65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 54380 | 54380 | 194099 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 6016735.93504 | 2095074.45923 | 37.733614544669706 | -122.384511236201 | (37.7336145446697, -122.384511236201) | ||||
| 129850 | 129850 | 244081 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1600 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 43 | Width 0ft | 5998790.9441 | 2109040.9235 | 37.770954351947296 | -122.447557026238 | (37.7709543519473, -122.447557026238) | |||
| 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) | |||
| 102948 | 102948 | 109902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1534 SHRADER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5997915.3 | 2105444.6 | 37.7610296801598 | -122.45032660600701 | (37.7610296801598, -122.450326606007) | |||
| 141464 | 141464 | 114054 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4422 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 5x5 | 6000476.0 | 2101726.0 | 37.750965527219 | -122.441203471187 | (37.750965527219, -122.441203471187) | |||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 76383 | 76383 | 232394 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 45 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 3ft | 6003880.35265 | 2106887.72771 | 37.765331737480295 | -122.42979901882799 | (37.7653317374803, -122.429799018828) | |||
| 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) | |||
| 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) | |||
| 71281 | 71281 | 232353 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 6ft | 6003304.68613 | 2099994.68694 | 37.74637247023129 | -122.43129803308099 | (37.7463724702313, -122.431298033081) | |||
| 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) | |||
| 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) | |||
| 151928 | 151928 | 232302 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1534 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 4ft | 5997889.799869999 | 2105442.36752 | 37.761022090923795 | -122.450414638525 | (37.7610220909238, -122.450414638525) | |||
| 175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
| 34033 | 34033 | 177850 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1260 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 6ft | 6001426.1792 | 2087609.14768 | 37.7122579779848 | -122.43690715954399 | (37.7122579779848, -122.436907159544) | |||
| 41840 | 41840 | 232365 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6004309.242980001 | 2096567.7661599999 | 37.7370198087262 | -122.427580283426 | (37.7370198087262, -122.427580283426) | |||
| 54114 | 54114 | 210568 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 163 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 5ft | 5999033.69954 | 2095485.54294 | 37.7337484681112 | -122.445742329568 | (37.7337484681112, -122.445742329568) | |||
| 56871 | 56871 | 194048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1242 19th St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013830.06416 | 2105268.62635 | 37.761444447624 | -122.395271611894 | (37.761444447624, -122.395271611894) | |||
| 155753 | 155753 | 194045 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013807.05349 | 2105290.79153 | 37.7615040286026 | -122.395352749639 | (37.7615040286026, -122.395352749639) | |||
| 161127 | 161127 | 177831 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6003962.8397 | 2094273.86284 | 37.730701668441895 | -122.428614487595 | (37.7307016684419, -122.428614487595) | |||
| 43960 | 43960 | 232361 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 869 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6000744.54456 | 2101976.60754 | 37.751668928482204 | -122.440292790492 | (37.7516689284822, -122.440292790492) | |||
| 64474 | 64474 | 248576 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 811 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 0ft | 5997625.7139 | 2107687.8398 | 37.7671724703286 | -122.45148995870599 | (37.7671724703286, -122.451489958706) | |||
| 67467 | 67467 | 232373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1520 Masonic Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | Width 3ft | 5999724.322980001 | 2107246.96096 | 37.766081879088 | -122.44419952100401 | (37.766081879088, -122.444199521004) | |||
| 69526 | 69526 | 177851 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1260 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 6ft | 6001405.83426 | 2087613.5591099998 | 37.712268934433 | -122.436977793197 | (37.712268934433, -122.436977793197) | |||
| 124215 | 124215 | 106155 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 174 STILLINGS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5999619.6 | 2095804.2 | 37.7346568605649 | -122.443739589791 | (37.7346568605649, -122.443739589791) | |||
| 162072 | 162072 | 210516 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 212 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5998671.88838 | 2093815.67028 | 37.7291427269309 | -122.44687309392401 | (37.7291427269309, -122.446873093924) | ||||
| 137153 | 137153 | 177830 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6003869.42584 | 2094268.83295 | 37.7306825704475 | -122.42893707528201 | (37.7306825704475, -122.428937075282) | |||
| 167409 | 167409 | 210548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1535 Plymouth Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 5995792.50445 | 2094281.41203 | 37.7302566245384 | -122.456860970872 | (37.7302566245384, -122.456860970872) | |||
| 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) | |||
| 37741 | 37741 | 177836 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005089.4768199995 | 2092569.03703 | 37.7260842891429 | -122.424598299682 | (37.7260842891429, -122.424598299682) | ||||
| 80150 | 80150 | 838 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4255X Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 30 | 3x3 | 5981362.6566223 | 2105522.5911084 | 37.7602826110734 | -122.50757979099501 | (37.7602826110734, -122.507579790995) | ||
| 90609 | 90609 | 120119 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 699X 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001710.0 | 2099417.0 | 37.744695775282004 | -122.436770916391 | (37.744695775282, -122.436770916391) | |||
| 93600 | 93600 | 11449 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3 | 5995514.85453 | 2115936.98374 | 37.789701328403794 | -122.459388527967 | (37.7897013284038, -122.459388527967) | |||
| 103762 | 103762 | 115780 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401X MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999527.0 | 2107685.0 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | |||
| 114117 | 114117 | 114775 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 FREDERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 5999527.0 | 2107685.0 | 37.7672733650738 | -122.444913510993 | (37.7672733650738, -122.444913510993) | |||
| 127929 | 127929 | 106934 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 725 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 9x6 | 6002468.8 | 2103993.4 | 37.7573045800385 | -122.43447428318501 | (37.7573045800385, -122.434474283185) | |||
| 50372 | 50372 | 119204 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 851 48th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5981054.81855 | 2109824.51434 | 37.772076303922205 | -122.50896387162399 | (37.7720763039222, -122.508963871624) | |||
| 52622 | 52622 | 194098 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 389 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 7ft | 6013425.60382 | 2110329.05815 | 37.7753167635898 | -122.397025307881 | (37.7753167635898, -122.397025307881) | |||
| 149665 | 149665 | 210537 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1427 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5991566.4324900005 | 2098375.46288 | 37.741254277373 | -122.471769177213 | (37.741254277373, -122.471769177213) | |||
| 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) | |||
| 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) | |||
| 42977 | 42977 | 105374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 127 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 5993372.2 | 2093864.2 | 37.7289717869451 | -122.46519792761299 | (37.7289717869451, -122.465197927613) | |||
| 51891 | 51891 | 248548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 136 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5999227.0741 | 2107711.1577 | 37.7673280658329 | -122.445952789289 | (37.7673280658329, -122.445952789289) | |||
| 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) | |||
| 41968 | 41968 | 245001 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 221 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5999831.2193 | 2109275.5852 | 37.7716580691907 | -122.443975560572 | (37.7716580691907, -122.443975560572) | |||
| 46568 | 46568 | 232340 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 691 29th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002112.62766 | 2098832.12217 | 37.7431127119846 | -122.435336881217 | (37.7431127119846, -122.435336881217) | ||||
| 53426 | 53426 | 232343 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 685 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6002200.5465400005 | 2098838.1570900003 | 37.7431342750257 | -122.43503331323099 | (37.7431342750257, -122.435033313231) | ||||
| 56393 | 56393 | 232297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 301 Putnam St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 9ft | 6009073.4894199995 | 2095823.27697 | 37.73524393096471 | -122.411055511504 | (37.7352439309647, -122.411055511504) | |||
| 56975 | 56975 | 232389 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 25 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002657.06447 | 2105749.66648 | 37.7621375497266 | -122.433948726371 | (37.7621375497266, -122.433948726371) | |||
| 58319 | 58319 | 141573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6000484.1528 | 2110668.7166 | 37.7755204805101 | -122.44181703345501 | (37.7755204805101, -122.441817033455) | |||
| 59881 | 59881 | 141571 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 GROVE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6000522.0944 | 2110671.7279 | 37.775530910627 | -122.441686000863 | (37.775530910627, -122.441686000863) | |||
| 133273 | 133273 | 53674 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1970 12:00:00 AM | 27 | 3x3 | Permit Number 6615 | 6000847.30796 | 2116375.23213 | 37.7912097941415 | -122.44097026868401 | (37.7912097941415, -122.440970268684) | |
| 167980 | 167980 | 232292 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 10ft | 6006575.0369 | 2098117.47597 | 37.7414028660575 | -122.41985633551701 | (37.7414028660575, -122.419856335517) | |||
| 172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
| 177620 | 177620 | 210577 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 371 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5997627.625030001 | 2093788.53301 | 37.72900850132 | -122.45048122525499 | (37.72900850132, -122.450481225255) | |||
| 1011 | 1011 | 232310 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1018 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2016 12:00:00 AM | 26 | Width 3ft | Permit Number 17854 | 5997696.0 | 2107004.0 | 37.7652988449505 | -122.451197528579 | (37.7652988449505, -122.451197528579) | |
| 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) | |||
| 52560 | 52560 | 131721 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 451 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 5998142.44354 | 2114904.79672 | 37.7870179407648 | -122.45022294085501 | (37.7870179407648, -122.450222940855) | |||
| 56061 | 56061 | 232364 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6004285.24489 | 2096599.68732 | 37.737106099566 | -122.427665529246 | (37.737106099566, -122.427665529246) | |||
| 132942 | 132942 | 210544 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 587 Dewey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5994033.45225 | 2099305.95334 | 37.743951602279104 | -122.46330666736601 | (37.7439516022791, -122.463306667366) | |||
| 136262 | 136262 | 177829 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003826.80299 | 2094267.18245 | 37.7306756258798 | -122.429084311385 | (37.7306756258798, -122.429084311385) | |||
| 150964 | 150964 | 232363 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 301 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6004253.20124 | 2096600.10182 | 37.7371054250736 | -122.427776348197 | (37.7371054250736, -122.427776348197) | |||
| 154193 | 154193 | 232299 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 108 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6005119.98151 | 2099339.98705 | 37.7446775233394 | -122.424974374591 | (37.7446775233394, -122.424974374591) | |||
| 163421 | 163421 | 194046 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6013804.04007 | 2105323.21797 | 37.761592896918394 | -122.395365443572 | (37.7615928969184, -122.395365443572) | |||
| 167556 | 167556 | 131751 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6005602.995519999 | 2117899.87458 | 37.795665791896894 | -122.424624213638 | (37.7956657918969, -122.424624213638) | |||
| 187126 | 187126 | 142895 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1015 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6000919.8741 | 2115393.3679 | 37.788517982728294 | -122.440648735369 | (37.7885179827283, -122.440648735369) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 38897 | 38897 | 177806 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009249.93875 | 2086480.54598 | 37.709600642326606 | -122.409786194885 | (37.7096006423266, -122.409786194885) | |||
| 52201 | 52201 | 131767 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 6007044.7048 | 2120715.74188 | 37.8034787699919 | -122.419835539578 | (37.8034787699919, -122.419835539578) | |||
| 53946 | 53946 | 122845 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2X Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5999031.283 | 2113317.8597 | 37.782711451453096 | -122.44703352321699 | (37.7827114514531, -122.447033523217) | |||
| 53960 | 53960 | 232354 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 6003303.21337 | 2100010.18921 | 37.746414952387 | -122.431304232109 | (37.746414952387, -122.431304232109) | |||
| 54955 | 54955 | 247427 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 433 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6002640.9603 | 2110148.8535 | 37.7742157250355 | -122.43431895136001 | (37.7742157250355, -122.43431895136) | |||
| 56910 | 56910 | 232413 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 2ft | 6002454.82765 | 2097697.74661 | 37.7400174082831 | -122.434072573816 | (37.7400174082831, -122.434072573816) | |||
| 66435 | 66435 | 131722 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 451 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5998141.840030001 | 2114887.60099 | 37.7869706912948 | -122.45022378889601 | (37.7869706912948, -122.450223788896) | |||
| 80904 | 80904 | 105375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 133 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5993389.1 | 2093898.7 | 37.7290674900164 | -122.465142008345 | (37.7290674900164, -122.465142008345) | |||
| 84555 | 84555 | 2254 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 410X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 90353 | 90353 | 104983 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 5715 DIAMOND HEIGHTS BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000755.2 | 2097122.9 | 37.738342408402204 | -122.439907965606 | (37.7383424084022, -122.439907965606) | |||
| 98286 | 98286 | 30056 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 410X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 157284 | 157284 | 113297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 162 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2015 12:00:00 AM | 25 | 3x3 | Permit Number 776713 | 5991196.72746 | 2114338.44012 | 37.7850629536775 | -122.47421197891501 | (37.7850629536775, -122.474211978915) | |
| 162173 | 162173 | 177805 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009236.846480001 | 2086428.13607 | 37.709456001673296 | -122.409827747151 | (37.7094560016733, -122.409827747151) | |||
| 172806 | 172806 | 232342 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 687 29th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6002180.92651 | 2098835.3599099996 | 37.74312548054821 | -122.435100953944 | (37.7431254805482, -122.435100953944) | ||||
| 176868 | 176868 | 95004 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 220 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6009838.7213 | 2087613.1663 | 37.7127435660796 | -122.40783106419701 | (37.7127435660796, -122.407831064197) | |||
| 180343 | 180343 | 177809 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 968 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6002194.0253 | 2088207.5246700002 | 37.7139446016244 | -122.434296011252 | (37.7139446016244, -122.434296011252) | |||
| 180900 | 180900 | 232341 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6002137.6004 | 2098831.04756 | 37.7431111795389 | -122.435250455448 | (37.7431111795389, -122.435250455448) | ||||
| 53691 | 53691 | 232409 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 275 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6002843.978680001 | 2097939.74109 | 37.7407039471414 | -122.432744333589 | (37.7407039471414, -122.432744333589) | |||
| 54942 | 54942 | 247437 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 400 Pierce St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 0ft | 6002701.7149 | 2110019.7981 | 37.773864819164096 | -122.434099563044 | (37.7738648191641, -122.434099563044) | |||
| 57725 | 57725 | 54294 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1950 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 24 | 3x3 | Permit Number 10048 | 6001969.7317 | 2115259.0901 | 37.78820901946921 | -122.437006779209 | (37.7882090194692, -122.437006779209) | |
| 59114 | 59114 | 131766 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007046.8227699995 | 2120698.6660599997 | 37.803432003442396 | -122.419826997845 | (37.8034320034424, -122.419826997845) |
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");