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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 86707 | 86707 | 7464 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.41430599230301 | (37.7557526290701, -122.414305992303) | |||
| 87059 | 87059 | 1438 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995477.38208 | 2115292.8933900003 | 37.787930676078794 | -122.45947151175501 | (37.7879306760788, -122.459471511755) | |||
| 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) | ||||
| 87555 | 87555 | 19303 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.44103321029101 | (37.7186921269443, -122.441033210291) | |||
| 88173 | 88173 | 6271 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.782778273754104 | -122.429763959937 | (37.7827782737541, -122.429763959937) | |||
| 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) | |||
| 89521 | 89521 | 6272 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003992.005369999 | 2113234.0209999997 | 37.782763424573005 | -122.429865551596 | (37.782763424573, -122.429865551596) | |||
| 89632 | 89632 | 215576 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 95 Kirkham St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | Width 3ft | 5994736.06961 | 2105294.2713 | 37.7604344559039 | -122.461311206651 | (37.7604344559039, -122.461311206651) | |||
| 91570 | 91570 | 1435 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995475.980819999 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | |||
| 93005 | 93005 | 7472 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6008329.443080001 | 2103061.47825 | 37.75507667179011 | -122.41413988378599 | (37.7550766717901, -122.414139883786) | |||
| 93568 | 93568 | 1421 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x12 | 5995527.212040001 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | |||
| 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) | |||
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 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) | |||
| 95650 | 95650 | 7425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | |||
| 95703 | 95703 | 6273 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003962.5783400005 | 2113230.61655 | 37.78275241032 | -122.42996711374701 | (37.78275241032, -122.429967113747) | |||
| 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) | |||||
| 104261 | 104261 | 137068 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997936.78651 | 2116362.08959 | 37.7910075087313 | -122.45103959183001 | (37.7910075087313, -122.45103959183) | |||
| 104287 | 104287 | 215601 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 155 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991211.33426 | 2091424.54649 | 37.7221482587196 | -122.472490339055 | (37.7221482587196, -122.472490339055) | |||
| 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) | ||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 117028 | 117028 | 137076 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 4 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6004731.627309999 | 2110853.90859 | 37.776270079140396 | -122.427137185641 | (37.7762700791404, -122.427137185641) | |||
| 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) | |||
| 119227 | 119227 | 1030 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | 3X6 | 6000847.46445 | 2090663.0926299999 | 37.7206105166164 | -122.43912610743799 | (37.7206105166164, -122.439126107438) | |||
| 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) | ||||
| 125401 | 125401 | 7486 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451004 | -122.414181457232 | (37.754459046451, -122.414181457232) | |||
| 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) | |||
| 129385 | 129385 | 1437 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.78800235781971 | -122.459478767425 | (37.7880023578197, -122.459478767425) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 131994 | 131994 | 199846 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1613 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.726622951149395 | -122.393068277245 | (37.7266229511494, -122.393068277245) | |||
| 133362 | 133362 | 185690 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984904.8934 | 2100540.6767 | 37.7468116841536 | -122.494961690438 | (37.7468116841536, -122.494961690438) | |||
| 133658 | 133658 | 180592 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1804 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 4ft | 6001143.73267 | 2091406.4041400002 | 37.72266833577 | -122.438155223402 | (37.72266833577, -122.438155223402) | |||
| 133735 | 133735 | 215638 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 81 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5991161.28352 | 2090567.01377 | 37.7197907884826 | -122.47260086035801 | (37.7197907884826, -122.472600860358) | |||
| 134549 | 134549 | 215585 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991388.97305 | 2092569.49487 | 37.725302283667396 | -122.471959698575 | (37.7253022836674, -122.471959698575) | |||
| 135449 | 135449 | 123482 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 138110 | 138110 | 215582 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5991378.73804 | 2092411.11653 | 37.7248668238178 | -122.47198354142999 | (37.7248668238178, -122.47198354143) | |||
| 139773 | 139773 | 97504 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 20X 10th St | 1 | 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) | |
| 140006 | 140006 | 1051 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2035X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000572.81835 | 2090254.9074400002 | 37.7194741008396 | -122.44004621634599 | (37.7194741008396, -122.440046216346) | |||
| 144014 | 144014 | 1218 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3575X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5993629.70146 | 2087487.1964900002 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | |||
| 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) | ||||
| 145404 | 145404 | 1420 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.45931355109501 | (37.7887935591586, -122.459313551095) | |||
| 145740 | 145740 | 123490 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5995673.905040001 | 2111757.95548 | 37.7782359793629 | -122.45853559389299 | (37.7782359793629, -122.458535593893) | ||||
| 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) | ||
| 147734 | 147734 | 180580 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | |||
| 149241 | 149241 | 215584 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5991387.10122 | 2092540.18841 | 37.7252217070935 | -122.471964034223 | (37.7252217070935, -122.471964034223) | |||
| 149316 | 149316 | 137071 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997945.511630001 | 2116314.45646 | 37.7908772203684 | -122.451005967078 | (37.7908772203684, -122.451005967078) | |||
| 149713 | 149713 | 137067 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997931.48984 | 2116393.73013 | 37.791094081978 | -122.45106020067 | (37.791094081978, -122.45106020067) | |||
| 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) | |||
| 152798 | 152798 | 123480 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995658.308019999 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | ||||
| 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) | |||
| 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) | |||
| 156335 | 156335 | 142234 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6004609.2702 | 2110836.2012 | 37.77621453898529 | -122.427559190874 | (37.7762145389853, -122.427559190874) | |||
| 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) | |||
| 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) | |||
| 158560 | 158560 | 123481 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995659.669480001 | 2112025.6512 | 37.7789701827075 | -122.458604223385 | (37.7789701827075, -122.458604223385) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 162620 | 162620 | 123479 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | ||||
| 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) | |||
| 163752 | 163752 | 182456 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1500 31st Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 5986548.9803 | 2104699.0505 | 37.758325556062104 | -122.489582412162 | (37.7583255560621, -122.489582412162) | |||
| 165193 | 165193 | 215592 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 177 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5995226.8577 | 2087383.90223 | 37.7112852083174 | -122.458317422904 | (37.7112852083174, -122.458317422904) | |||
| 165950 | 165950 | 215586 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5991393.3825900005 | 2092629.9672299998 | 37.725468580903 | -122.471948860848 | (37.725468580903, -122.471948860848) | |||
| 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) | |||
| 166700 | 166700 | 180582 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | |||
| 170241 | 170241 | 180589 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003010.99045 | 2094126.1928400001 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | |||
| 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) | |||
| 170582 | 170582 | 242796 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 2ft | 5997883.8658300005 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | |||
| 170878 | 170878 | 185719 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984913.7198 | 2100361.206 | 37.7463194231796 | -122.49491793929899 | (37.7463194231796, -122.494917939299) | |||
| 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) | |||
| 171488 | 171488 | 215651 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2105 09th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5993642.48221 | 2101265.6792599997 | 37.749309980671796 | -122.46480082800501 | (37.7493099806718, -122.464800828005) | |||
| 171899 | 171899 | 123484 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | 5995663.25844 | 2111930.13675 | 37.778708131625294 | -122.458584891633 | (37.7787081316253, -122.458584891633) | ||||
| 172059 | 172059 | 182465 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2400 Lawton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5986689.3022 | 2104396.9525 | 37.7575042689843 | -122.489074914666 | (37.7575042689843, -122.489074914666) | |||
| 172911 | 172911 | 105883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | ||||
| 173805 | 173805 | 123488 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5995672.61976 | 2111816.69318 | 37.7783971836602 | -122.458544293173 | (37.7783971836602, -122.458544293173) | ||||
| 175293 | 175293 | 199849 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1607 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | |||
| 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) | |||
| 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) | |||
| 175894 | 175894 | 137070 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5997942.37701 | 2116329.50618 | 37.7909183634316 | -122.451017898383 | (37.7909183634316, -122.451017898383) | |||
| 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) | |||
| 176952 | 176952 | 215598 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 48 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5991274.418330001 | 2092469.9979599998 | 37.725022460494706 | -122.472348449422 | (37.7250224604947, -122.472348449422) | |||
| 177374 | 177374 | 123487 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5995668.73883 | 2111844.87781 | 37.778474348143895 | -122.45855975947599 | (37.7784743481439, -122.458559759476) | ||||
| 177920 | 177920 | 182454 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1500 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 5986553.619 | 2104615.5531 | 37.7580965659316 | -122.489560229786 | (37.7580965659316, -122.489560229786) | |||
| 178804 | 178804 | 215588 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 551 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5991446.82162 | 2093469.8712 | 37.7277778402634 | -122.47182531290899 | (37.7277778402634, -122.471825312909) | |||
| 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) | |||
| 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) |
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");