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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23186 | 23186 | 17762 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 6005688.226009999 | 2115553.43335 | 37.7892278664309 | -122.424162343438 | (37.7892278664309, -122.424162343438) | ||||
| 28308 | 28308 | 67884 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 5X Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1993 12:00:00 AM | 15 | Permit Number 31577 | 6003921.69231 | 2093425.09481 | 37.72836881267121 | -122.428696258429 | (37.7283688126712, -122.428696258429) | ||
| 28860 | 28860 | 51570 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2005 12:00:00 AM | 17 | Permit Number 47867 | 5988337.51894 | 2114460.53389 | 37.7852321378524 | -122.48411277430401 | (37.7852321378524, -122.484112774304) | |
| 40659 | 40659 | 62578 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 739 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 9 | Permit Number 22783 | 6011302.7424099995 | 2104925.74778 | 37.7603620991639 | -122.403988486898 | (37.7603620991639, -122.403988486898) | |
| 50076 | 50076 | 58511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1430 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1979 12:00:00 AM | Permit Number 17687 | 5998871.25967783 | 2108358.36156462 | 37.7690847998305 | -122.447230081169 | (37.7690847998305, -122.447230081169) | |||
| 55714 | 55714 | 107425 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1600X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997832.17799 | 2108247.26578 | 37.7687203321672 | -122.450816174345 | (37.7687203321672, -122.450816174345) | |||||
| 57547 | 57547 | 38224 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 14 | Permit Number 40351 | 6014264.59569 | 2102044.43409 | 37.7526156672934 | -122.39354307806101 | (37.7526156672934, -122.393543078061) | |
| 62464 | 62464 | 62579 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 741 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1986 12:00:00 AM | 10 | Permit Number 22784 | 6011303.77085 | 2104898.93824 | 37.7602885436105 | -122.40398304329399 | (37.7602885436105, -122.403983043294) | |
| 78284 | 78284 | 36808 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 78413 | 78413 | 51528 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 81696 | 81696 | 51527 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2900 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47830 | 6014679.41969777 | 2089453.24857655 | 37.7180658851091 | -122.39122846992599 | (37.7180658851091, -122.391228469926) | |||
| 83231 | 83231 | 36833 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 84347 | 84347 | 106497 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772114 | 5997541.6 | 2108881.8 | 37.770445962098705 | -122.451867038975 | (37.7704459620987, -122.451867038975) | ||||
| 89868 | 89868 | 36789 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 94007 | 94007 | 112375 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 42 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 95397 | 95397 | 105511 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 772834 | 6003196.1616 | 2109801.36502 | 37.7732931051579 | -122.432373588443 | (37.7732931051579, -122.432373588443) | ||||
| 95666 | 95666 | 36809 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1290 Egbert Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39532 | 6014916.278192299 | 2090716.3266444001 | 37.721547191141205 | -122.39049795372 | (37.7215471911412, -122.39049795372) | ||
| 96253 | 96253 | 41569 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 63 Ruth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2000 12:00:00 AM | Permit Number 42084 | 6001453.1346338 | 2091658.26221962 | 37.723377473003104 | -122.437103713844 | (37.7233774730031, -122.437103713844) | |||
| 97104 | 97104 | 50378 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 102914 | 102914 | 112377 | Property Tree 7 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 107199 | 107199 | 112376 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 24 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 116970 | 116970 | 34459 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1960 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | Permit Number 42077 | 6008233.26269903 | 2119182.7725058 | 37.7993365057546 | -122.415613869084 | (37.7993365057546, -122.415613869084) | ||
| 117616 | 117616 | 36790 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1314 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39526 | 6015468.42166203 | 2090653.62366449 | 37.7214056358126 | -122.388584951991 | (37.7214056358126, -122.388584951991) | ||
| 123678 | 123678 | 97297 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 450 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5994062.8 | 2112448.2 | 37.7800384821655 | -122.46415907596202 | (37.7800384821655, -122.464159075962) | |||||
| 124008 | 124008 | 106918 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 274 PUTNAM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009044.8 | 2096077.1 | 37.7359392652864 | -122.41117262558201 | (37.7359392652864, -122.411172625582) | |||||
| 128144 | 128144 | 50377 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1620 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47039 | 6011351.83248495 | 2120835.88186523 | 37.804050345434 | -122.404938924734 | (37.804050345434, -122.404938924734) | |||
| 146060 | 146060 | 106499 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 420X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997462.73555 | 2109001.92463 | 37.770771276139705 | -122.452148498658 | (37.7707712761397, -122.452148498658) | |||||
| 146328 | 146328 | 36834 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2715 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | Permit Number 39537 | 6015005.69395491 | 2090908.83002417 | 37.7220807273762 | -122.390202307194 | (37.7220807273762, -122.390202307194) | ||
| 148918 | 148918 | 62209 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 227 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1985 12:00:00 AM | 16 | Permit Number 22331 | 5988338.57879 | 2114482.10714 | 37.7852914335725 | -122.48411069019699 | (37.7852914335725, -122.484110690197) | |
| 169973 | 169973 | 61914 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1985 12:00:00 AM | 12 | Permit Number 21965 | 6016347.85341 | 2101137.90293 | 37.75024205603879 | -122.386275546874 | (37.7502420560388, -122.386275546874) | ||
| 170634 | 170634 | 38226 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 11 | Permit Number 40351 | 6014262.677019999 | 2102083.6302 | 37.752723184838295 | -122.393552456191 | (37.7527231848383, -122.393552456191) | ||
| 183147 | 183147 | 66382 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 661 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | 12 | Permit Number 29508 | 6003420.5252 | 2110677.1492 | 37.7757105120941 | -122.431660023451 | (37.7757105120941, -122.431660023451) | |
| 16272 | 16272 | 107070 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 400X Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2014 12:00:00 AM | 3 | 20x6 | Permit Number 773144 | 6015880.83246 | 2106317.74548 | 37.7644389427302 | -122.388252013943 | (37.7644389427302, -122.388252013943) | |
| 18226 | 18226 | 4848 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 229 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 2x3 | 6006739.96805 | 2097466.29285 | 37.7396241527309 | -122.419239878116 | (37.7396241527309, -122.419239878116) | |||
| 6636 | 6636 | 2588 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1710 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/12/1999 12:00:00 AM | 18 | 3 | 6005206.687000001 | 2115142.0135 | 37.788071009916 | -122.42579911500499 | (37.788071009916, -122.425799115005) | ||
| 1068 | 1068 | 11520 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/01/2017 12:00:00 AM | 6 | 3X3 | 6018495.90717 | 2096693.85175 | 37.738158246093 | -122.378538834904 | (37.738158246093, -122.378538834904) | ||
| 1843 | 1843 | 9890 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1700 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005344.337040001 | 2115550.48459 | 37.7892003471598 | -122.42535194865299 | (37.7892003471598, -122.425351948653) | |||
| 3956 | 3956 | 15038 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1017 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6015648.0 | 2096190.0 | 37.7366173719863 | -122.388350408836 | (37.7366173719863, -122.388350408836) | |||
| 6238 | 6238 | 8189 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1279 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001660.1742 | 2111123.4233 | 37.7768359307235 | -122.437781474603 | (37.7768359307235, -122.437781474603) | |||
| 6681 | 6681 | 10654 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 930 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003365.9666 | 2110715.3678 | 37.7758123582585 | -122.431851484644 | (37.7758123582585, -122.431851484644) | |||
| 7002 | 7002 | 5239 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1100 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001407.3425 | 2112393.2913 | 37.780308287354295 | -122.438747110907 | (37.7803082873543, -122.438747110907) | |||
| 7110 | 7110 | 10652 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 931 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003404.4622 | 2110674.9336 | 37.775703518104 | -122.431715431116 | (37.775703518104, -122.431715431116) | |||
| 7531 | 7531 | 8183 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001748.9425 | 2111188.325 | 37.777019181607706 | -122.437479047598 | (37.7770191816077, -122.437479047598) | |||
| 7855 | 7855 | 10655 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 937 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003345.7495 | 2110667.1791 | 37.775678897926 | -122.43191797899799 | (37.775678897926, -122.431917978998) | |||
| 7947 | 7947 | 2629 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1872 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004578.2934 | 2115053.5876 | 37.787792683911 | -122.427966943787 | (37.787792683911, -122.427966943787) | |||
| 8329 | 8329 | 8190 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1280 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6001658.902000001 | 2111173.1154 | 37.7769723003903 | -122.437789435412 | (37.7769723003903, -122.437789435412) | |||
| 8867 | 8867 | 10653 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 930 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003401.4158 | 2110719.799 | 37.775826534714106 | -122.43172917338 | (37.7758265347141, -122.43172917338) | |||
| 9234 | 9234 | 4832 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 104X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | 3X3 | 6006272.0 | 2097672.0 | 37.7401626122958 | -122.420872513823 | (37.7401626122958, -122.420872513823) | |||
| 9298 | 9298 | 17755 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005983.055346799 | 2115593.0882202997 | 37.789353391125104 | -122.42314508816901 | (37.7893533911251, -122.423145088169) | |||
| 9377 | 9377 | 17756 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1634 Pine St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6005973.81147 | 2115593.81965 | 37.7893548777914 | -122.423177122971 | (37.7893548777914, -122.423177122971) | |||
| 9401 | 9401 | 4822 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 60 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6006061.0289274 | 2097780.9763268996 | 37.7404499429552 | -122.421609705422 | (37.7404499429552, -122.421609705422) | |||
| 13431 | 13431 | 11527 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018609.30332 | 2096848.22468 | 37.738588373848295 | -122.378157476493 | (37.7385883738483, -122.378157476493) | |||
| 13473 | 13473 | 11540 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018782.49291 | 2097080.98118 | 37.7392370206652 | -122.37757481115 | (37.7392370206652, -122.37757481115) | |||
| 13479 | 13479 | 22442 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 6025 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6013654.8805 | 2091521.7057 | 37.7236885437418 | -122.394914674123 | (37.7236885437418, -122.394914674123) | |||
| 13488 | 13488 | 3672 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 108 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017032.375109999 | 2098991.89434 | 37.7443874218329 | -122.383759005485 | (37.7443874218329, -122.383759005485) | |||
| 13507 | 13507 | 11536 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018721.15121 | 2096997.58655 | 37.739004655647 | -122.377781119206 | (37.739004655647, -122.377781119206) | |||
| 13546 | 13546 | 11531 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018661.768080001 | 2096921.7146599998 | 37.7387930541475 | -122.37798117610501 | (37.7387930541475, -122.377981176105) | |||
| 13576 | 13576 | 3696 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016376.57655 | 2099377.09307 | 37.7454088259626 | -122.386053488085 | (37.7454088259626, -122.386053488085) | |||
| 13710 | 13710 | 3708 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016594.5506 | 2099214.51013 | 37.744974467789504 | -122.385288434823 | (37.7449744677895, -122.385288434823) | |||
| 13776 | 13776 | 3680 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | |||
| 13810 | 13810 | 11546 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018856.19666 | 2097185.73418 | 37.7395287121888 | -122.37732724037701 | (37.7395287121888, -122.377327240377) | |||
| 13853 | 13853 | 11518 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018467.96004 | 2096661.77747 | 37.7380686358665 | -122.37863323672899 | (37.7380686358665, -122.378633236729) | |||
| 13880 | 13880 | 3671 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | |||
| 13907 | 13907 | 3714 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016696.4691699995 | 2099138.87958 | 37.744772439592204 | -122.384930747455 | (37.7447724395922, -122.384930747455) | |||
| 13958 | 13958 | 3709 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016611.7626 | 2099202.9223 | 37.7449436021699 | -122.38522811100201 | (37.7449436021699, -122.385228111002) | |||
| 13998 | 13998 | 11516 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018445.80461 | 2096632.24283 | 37.737986318204605 | -122.378707789643 | (37.7379863182046, -122.378707789643) | |||
| 14283 | 14283 | 11524 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018572.85172 | 2096797.82035 | 37.7384479645089 | -122.378280011831 | (37.7384479645089, -122.378280011831) | |||
| 14381 | 14381 | 3679 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.744685084848896 | -122.384279393677 | (37.7446850848489, -122.384279393677) | |||
| 14511 | 14511 | 11548 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018882.85871 | 2097216.8887400003 | 37.7396157251883 | -122.377237214629 | (37.7396157251883, -122.377237214629) | |||
| 14535 | 14535 | 3713 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016679.4743 | 2099151.07612 | 37.7448049887681 | -122.384990362612 | (37.7448049887681, -122.384990362612) | |||
| 14593 | 14593 | 3718 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.584419999 | 2099032.41565 | 37.7444879156766 | -122.384435379316 | (37.7444879156766, -122.384435379316) | |||
| 14596 | 14596 | 3733 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017103.99643 | 2098828.8007400003 | 37.743943558756705 | -122.38349999984501 | (37.7439435587567, -122.383499999845) | |||
| 14617 | 14617 | 11525 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018584.76615 | 2096814.86638 | 37.7384954262103 | -122.37824000008499 | (37.7384954262103, -122.378240000085) | |||
| 14633 | 14633 | 11522 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018545.03968 | 2096763.4476400001 | 37.738352050906 | -122.37837378772801 | (37.738352050906, -122.378373787728) | |||
| 14692 | 14692 | 3717 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016818.97287 | 2099045.87092 | 37.7445238319196 | -122.384500671891 | (37.7445238319196, -122.384500671891) | |||
| 14711 | 14711 | 11538 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018744.95776 | 2097030.5986900001 | 37.7390966122121 | -122.377701096637 | (37.7390966122121, -122.377701096637) | |||
| 14717 | 14717 | 3720 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016885.74999 | 2098998.54038 | 37.7443975643918 | -122.38426647223999 | (37.7443975643918, -122.38426647224) | |||
| 14752 | 14752 | 3664 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 100 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017168.62408 | 2098888.98032 | 37.744112371380204 | -122.383280718132 | (37.7441123713802, -122.383280718132) | ||
| 14775 | 14775 | 11542 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018808.16459 | 2097116.8368799998 | 37.739336887696396 | -122.377488536484 | (37.7393368876964, -122.377488536484) | |||
| 14867 | 14867 | 3710 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1990 12:00:00 AM | 12 | 3X3 | 6016627.8913900005 | 2099188.4950200003 | 37.7449048800496 | -122.385171335 | (37.7449048800496, -122.385171335) | ||
| 14940 | 14940 | 26805 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1491 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015969.8239 | 2095448.3954 | 37.734598903014295 | -122.38718600253901 | (37.7345989030143, -122.387186002539) | |||
| 14990 | 14990 | 3727 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017002.99503 | 2098909.3169299997 | 37.7441590569979 | -122.383854848043 | (37.7441590569979, -122.383854848043) | |||
| 15014 | 15014 | 11529 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018637.527419999 | 2096885.1095 | 37.7386912077413 | -122.37806244962401 | (37.7386912077413, -122.378062449624) | |||
| 15019 | 15019 | 11534 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018698.318659999 | 2096968.53923 | 37.7389236393092 | -122.37785804901002 | (37.7389236393092, -122.37785804901) | |||
| 15189 | 15189 | 3712 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016661.27341 | 2099164.52322 | 37.7448409049843 | -122.385054235166 | (37.7448409049843, -122.385054235166) | |||
| 15190 | 15190 | 3701 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/2000 12:00:00 AM | 3 | 3X3 | 6016463.92851 | 2099311.9747200003 | 37.745234858406 | -122.385746898422 | (37.745234858406, -122.385746898422) | ||
| 15231 | 15231 | 11541 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018795.49875 | 2097098.36536 | 37.7392854707446 | -122.377531048337 | (37.7392854707446, -122.377531048337) | |||
| 15280 | 15280 | 3725 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016971.06909 | 2098934.28119 | 37.7442258388522 | -122.383966980005 | (37.7442258388522, -122.383966980005) | |||
| 15289 | 15289 | 22103 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3550 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015999.32561 | 2099148.4464 | 37.7447601233736 | -122.387342025935 | (37.7447601233736, -122.387342025935) | |||
| 15305 | 15305 | 3683 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016838.589430001 | 2099135.269 | 37.7447703855426 | -122.384439066524 | (37.7447703855426, -122.384439066524) | |||
| 15306 | 15306 | 22434 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 6000 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6013550.0151 | 2091475.3264 | 37.7235553639507 | -122.395273931127 | (37.7235553639507, -122.395273931127) | |||
| 15310 | 15310 | 3668 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 104 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017100.61527 | 2098941.7519 | 37.7442535127858 | -122.38351955288 | (37.7442535127858, -122.38351955288) | |||
| 15313 | 15313 | 22105 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3550 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6015990.42325 | 2099120.8516599997 | 37.7446838608656 | -122.38737088427 | (37.7446838608656, -122.38737088427) | |||
| 15340 | 15340 | 3684 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016817.82171 | 2099151.7639099997 | 37.744814528777795 | -122.384512026728 | (37.7448145287778, -122.384512026728) | |||
| 15381 | 15381 | 3665 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 101 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017153.34624 | 2098900.7145700003 | 37.74414374693129 | -122.383334362693 | (37.7441437469313, -122.383334362693) | |||
| 15426 | 15426 | 3670 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 106 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017067.53558 | 2098965.3092900002 | 37.744316368207706 | -122.383635576218 | (37.7443163682077, -122.383635576218) | |||
| 15456 | 15456 | 3728 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017021.23739 | 2098897.913 | 37.744128752548704 | -122.383790975489 | (37.7441287525487, -122.383790975489) | |||
| 15457 | 15457 | 3729 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017037.38715 | 2098884.5074400003 | 37.744092836325 | -122.38373419946998 | (37.744092836325, -122.38373419947) | |||
| 15479 | 15479 | 11521 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018533.508280001 | 2096747.4741099998 | 37.738307555143706 | -122.378412549408 | (37.7383075551437, -122.378412549408) | |||
| 15508 | 15508 | 11512 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018400.60741 | 2096569.54507 | 37.7378116707805 | -122.378859707612 | (37.7378116707805, -122.378859707612) |
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");