Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1048 | 1048 | 251423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5999946.0 | 2089791.0 | 37.718164612456604 | -122.44217960719999 | (37.7181646124566, -122.4421796072) | ||||
| 3284 | 3284 | 253385 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1100 Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004275.0 | 2112509.0 | 37.780788718892204 | -122.428834805692 | (37.7807887188922, -122.428834805692) | |||||
| 3375 | 3375 | 253429 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2198 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7 | 5992046.0 | 2112030.0 | 37.7787737730441 | -122.471105555235 | (37.7787737730441, -122.471105555235) | ||||
| 19652 | 19652 | 99912 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005509.050559999 | 2101091.11643 | 37.7495076933522 | -122.42375353501998 | (37.7495076933522, -122.42375353502) | ||||
| 56269 | 56269 | 1048 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | ||||
| 77976 | 77976 | 99913 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768933 | 6005509.050559999 | 2101091.11643 | 37.7495076933522 | -122.42375353501998 | (37.7495076933522, -122.42375353502) | |||
| 85887 | 85887 | 117255 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 87541 | 87541 | 121665 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
| 88227 | 88227 | 51907 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 157 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.42559837996599 | (37.7428856098168, -122.425598379966) | |||
| 94173 | 94173 | 117256 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 94783 | 94783 | 39243 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | |||
| 98822 | 98822 | 51906 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 157 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.42559837996599 | (37.7428856098168, -122.425598379966) | |||
| 99073 | 99073 | 108311 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 439x ARLINGTON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329168998 | (37.7354814316621, -122.42878329169) | |||||
| 109973 | 109973 | 99911 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005460.7 | 2101331.3 | 37.750164452601794 | -122.42393781012501 | (37.7501644526018, -122.423937810125) | ||||
| 111256 | 111256 | 104704 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | ||
| 119155 | 119155 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 1636 Bush St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665.0 | 2115204.0 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | |||
| 121533 | 121533 | 93024 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 128580 | 128580 | 82168 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | |||||
| 143144 | 143144 | 105784 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||
| 144992 | 144992 | 93023 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 136173 | 136173 | 185691 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984865.9917 | 2100533.4848 | 37.746789659782 | -122.49509567655001 | (37.746789659782, -122.49509567655) | |||
| 163579 | 163579 | 215612 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 53 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991154.50456 | 2090649.59615 | 37.720017146953 | -122.472630310457 | (37.720017146953, -122.472630310457) | |||
| 184481 | 184481 | 185713 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984850.6272 | 2100403.3767 | 37.746431518886105 | -122.49513921196301 | (37.7464315188861, -122.495139211963) | |||
| 160 | 160 | 175377 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.715161983326794 | -122.471751215951 | (37.7151619833268, -122.471751215951) | |||
| 789 | 789 | 175382 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991305.518069999 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | |||
| 837 | 837 | 175374 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991412.70367 | 2088734.1730099998 | 37.714772806192606 | -122.47159830692699 | (37.7147728061926, -122.471598306927) | |||
| 37961 | 37961 | 185716 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984901.6243 | 2100400.4346 | 37.746426426174395 | -122.49496265549601 | (37.7464264261744, -122.494962655496) | |||
| 159718 | 159718 | 215608 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 48 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991156.01629 | 2090675.51857 | 37.720088411035206 | -122.47262697396799 | (37.7200884110352, -122.472626973968) | |||
| 161666 | 161666 | 215607 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 47 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991157.54734 | 2090681.2167900002 | 37.7201041455671 | -122.47262209693301 | (37.7201041455671, -122.472622096933) | |||
| 798 | 798 | 175378 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 5991360.88178 | 2088922.0136900002 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | |||
| 11261 | 11261 | 936 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.0300900002 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | ||
| 17067 | 17067 | 11708 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | ||
| 19036 | 19036 | 11747 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.94649 | 2092660.64259 | 37.725546648332504 | -122.4723190326 | (37.7255466483325, -122.4723190326) | ||
| 20933 | 20933 | 11752 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991283.50431 | 2092598.4954900001 | 37.7253758086322 | -122.47232640343799 | (37.7253758086322, -122.472326403438) | ||
| 36173 | 36173 | 137082 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008777.375519999 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | |||
| 41079 | 41079 | 215635 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.257019999 | 2090584.0200099999 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | |||
| 57358 | 57358 | 215626 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 68 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991156.30566 | 2090612.66695 | 37.7199158527268 | -122.47262139367099 | (37.7199158527268, -122.472621393671) | |||
| 63629 | 63629 | 215620 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 62 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991138.86268 | 2090625.2601299998 | 37.7199494208 | -122.472682605115 | (37.7199494208, -122.472682605115) | |||
| 69819 | 69819 | 180585 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458428999 | (37.7275472199251, -122.43765458429) | |||
| 124683 | 124683 | 10723 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 130396 | 130396 | 215622 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 64 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991146.64961 | 2090624.8002099998 | 37.7199486087273 | -122.472655655135 | (37.7199486087273, -122.472655655135) | |||
| 136462 | 136462 | 215621 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 63 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991148.3674800005 | 2090618.2199 | 37.7199306402575 | -122.47264923758999 | (37.7199306402575, -122.47264923759) | |||
| 147002 | 147002 | 83273 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 3 | 6008750.425980001 | 2118601.9970299997 | 37.797770897055294 | -122.413783193943 | (37.7977708970553, -122.413783193943) | ||
| 171388 | 171388 | 137079 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008755.558119999 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | |||
| 179443 | 179443 | 137080 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.79763977591279 | -122.41375141818999 | (37.7976397759128, -122.41375141819) | |||
| 179478 | 179478 | 215604 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 38 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991153.81619 | 2090748.1801 | 37.7202877943298 | -122.472639873854 | (37.7202877943298, -122.472639873854) | |||
| 183192 | 183192 | 215611 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 51 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991153.406 | 2090660.89558 | 37.720048108812705 | -122.472634931171 | (37.7200481088127, -122.472634931171) | |||
| 184159 | 184159 | 215648 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 92 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991148.46508 | 2090549.7895400003 | 37.7197427529995 | -122.472643913597 | (37.7197427529995, -122.472643913597) | |||
| 188100 | 188100 | 215642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 85 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991146.327190001 | 2090562.0053700001 | 37.7197761709066 | -122.47265219363999 | (37.7197761709066, -122.47265219364) | |||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 33957 | 33957 | 137078 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | |||
| 38177 | 38177 | 215644 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991153.983659999 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | |||
| 39462 | 39462 | 215649 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 93 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991151.37081 | 2090546.73366 | 37.7197345305043 | -122.472633646933 | (37.7197345305043, -122.472633646933) | |||
| 58824 | 58824 | 215633 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 76 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991148.619390001 | 2090586.20981 | 37.719842763020104 | -122.472646034205 | (37.7198427630201, -122.472646034205) | |||
| 75277 | 75277 | 215631 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 74 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991145.11917 | 2090589.24121 | 37.719850883885606 | -122.472658354026 | (37.7198508838856, -122.472658354026) | |||
| 77875 | 77875 | 106884 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 6 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 125523 | 125523 | 106883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 4 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 129670 | 129670 | 215602 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 166 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991204.303730001 | 2091328.4883700002 | 37.7218840999401 | -122.47250764202101 | (37.7218840999401, -122.472507642021) | |||
| 155249 | 155249 | 215634 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 77 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991150.9321800005 | 2090583.20344 | 37.7198346421452 | -122.47263782070101 | (37.7198346421452, -122.472637820701) | |||
| 155297 | 155297 | 215637 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 80 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991151.99496 | 2090577.2658 | 37.7198184003677 | -122.47263371439699 | (37.7198184003677, -122.472633714397) | |||
| 175491 | 175491 | 137081 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | |||
| 176243 | 176243 | 215636 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 79 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991147.9135 | 2090580.90098 | 37.7198281454204 | -122.472648087333 | (37.7198281454204, -122.472648087333) | |||
| 55354 | 55354 | 215614 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 55 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991140.92054 | 2090646.29638 | 37.7200073002795 | -122.472677024844 | (37.7200073002795, -122.472677024844) | |||
| 60171 | 60171 | 242791 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1001 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6005175.70924 | 2096892.8816200001 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | ||||
| 94262 | 94262 | 106880 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 3 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 5 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 136034 | 136034 | 137077 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2955 Steiner St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6001974.0393199995 | 2118352.39854 | 37.796702688621004 | -122.437213445266 | (37.796702688621, -122.437213445266) | |||
| 185313 | 185313 | 215647 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 90 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991141.92136 | 2090550.26747 | 37.719743686490396 | -122.472666567521 | (37.7197436864904, -122.472666567521) | |||
| 187609 | 187609 | 215640 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 83 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991139.98278 | 2090571.01197 | 37.71980053355961 | -122.472674780143 | (37.7198005335596, -122.472674780143) | |||
| 1790 | 1790 | 26629 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | ||
| 53965 | 53965 | 215613 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 54 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991146.23554 | 2090648.32868 | 37.720013188138296 | -122.47265880098699 | (37.7200131881383, -122.472658800987) | |||
| 54677 | 54677 | 215629 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 72 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991145.86247 | 2090596.3241400002 | 37.7198703748925 | -122.47265630087 | (37.7198703748925, -122.47265630087) | |||
| 62692 | 62692 | 215609 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991151.21969 | 2090669.8888599998 | 37.7200726755881 | -122.472643143781 | (37.7200726755881, -122.472643143781) | |||
| 73830 | 73830 | 215605 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 39 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991158.3667 | 2090738.6198 | 37.7202618075092 | -122.472623447724 | (37.7202618075092, -122.472623447724) | |||
| 129875 | 129875 | 215617 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 59 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991151.604669999 | 2090631.8002400002 | 37.71996811591 | -122.47263903747299 | (37.71996811591, -122.472639037473) | |||
| 150428 | 150428 | 242795 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1671 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009731.24755 | 2099988.4352599997 | 37.7467174150944 | -122.409075193563 | (37.7467174150944, -122.409075193563) | |||
| 152540 | 152540 | 180586 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 177 Santa Rosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001346.13618 | 2093162.98872 | 37.7275030272355 | -122.437581294937 | (37.7275030272355, -122.437581294937) | |||
| 170489 | 170489 | 215610 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 50 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991146.77446 | 2090663.32778 | 37.7200544031655 | -122.472658031161 | (37.7200544031655, -122.472658031161) | |||
| 179042 | 179042 | 215595 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 400 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991368.98283 | 2094166.96047 | 37.7296873689589 | -122.47214519097 | (37.7296873689589, -122.47214519097) | |||
| 38027 | 38027 | 215623 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 65 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991145.2526 | 2090614.88415 | 37.7199213008035 | -122.472659761464 | (37.7199213008035, -122.472659761464) | |||
| 54836 | 54836 | 215643 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 86 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991150.43358 | 2090559.55238 | 37.7197696732999 | -122.47263782068701 | (37.7197696732999, -122.472637820687) | |||
| 129995 | 129995 | 215632 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 75 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991152.25672 | 2090589.68226 | 37.7198525080596 | -122.472633714394 | (37.7198525080596, -122.472633714394) | |||
| 144278 | 144278 | 2933 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1834 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | ||
| 160644 | 160644 | 215625 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991149.7740400005 | 2090612.8046400002 | 37.719915852707295 | -122.472643981029 | (37.7199158527073, -122.472643981029) | |||
| 70971 | 70971 | 215639 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 82 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991150.62056 | 2090568.4216099998 | 37.719794036843794 | -122.472637820681 | (37.7197940368438, -122.472637820681) | |||
| 136479 | 136479 | 215618 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 60 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991156.49559 | 2090631.32735 | 37.719967100580796 | -122.472622096952 | (37.7199671005808, -122.472622096952) | |||
| 166173 | 166173 | 124694 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5995618.45318 | 2113098.44712 | 37.78191342592 | -122.45882449658501 | (37.78191342592, -122.458824496585) | |||
| 157916 | 157916 | 215630 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 73 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991138.04395 | 2090591.7564599998 | 37.7198573805858 | -122.47268299363998 | (37.7198573805858, -122.47268299364) | |||
| 19243 | 19243 | 39175 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | |
| 66816 | 66816 | 124642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | |||
| 157547 | 157547 | 215619 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 61 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991156.50194 | 2090623.6682099998 | 37.719946070837395 | -122.472621516875 | (37.7199460708374, -122.472621516875) | |||
| 11865 | 11865 | 939 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | |||
| 153233 | 153233 | 185963 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2001 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984881.7314 | 2101336.1941 | 37.7489946017929 | -122.495100432866 | (37.7489946017929, -122.495100432866) | |||
| 158658 | 158658 | 215606 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 40 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5991163.46661 | 2090729.52448 | 37.7202371292081 | -122.47260515641399 | (37.7202371292081, -122.472605156414) | |||
| 175424 | 175424 | 215628 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 71 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5991139.39343 | 2090599.4181400002 | 37.7198784957874 | -122.47267888733299 | (37.7198784957874, -122.472678887333) | |||
| 19211 | 19211 | 19069 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.45913384457701 | (37.711496124512, -122.459133844577) | |||
| 19476 | 19476 | 11625 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 300X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | |||
| 46257 | 46257 | 97505 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672.0 | 2110712.0 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | |
| 50637 | 50637 | 117189 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.793960957890896 | -122.415375111785 | (37.7939609578909, -122.415375111785) | |||
| 66806 | 66806 | 123958 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.46559031264799 | (37.7830615134244, -122.465590312648) | |||
| 70741 | 70741 | 215579 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 851 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991331.01602 | 2091664.09591 | 37.7228129287478 | -122.472094084291 | (37.7228129287478, -122.472094084291) |
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");