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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 18729 | 18729 | 4825 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 72 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3X3 | 6006134.02134 | 2097745.6697400003 | 37.7403571145946 | -122.421354819194 | (37.7403571145946, -122.421354819194) | |||
| 21184 | 21184 | 4827 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6006160.77573 | 2097729.74879 | 37.74031490761921 | -122.421261182679 | (37.7403149076192, -122.421261182679) | |||
| 22222 | 22222 | 4815 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005920.0488599995 | 2097862.788 | 37.740666628859294 | -122.42210297059799 | (37.7406666288593, -122.422102970598) | |||
| 87130 | 87130 | 10269 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 215X Haight St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 6X12 | 6005099.693995 | 2109521.3764509996 | 37.7726320769714 | -122.42576907222299 | (37.7726320769714, -122.425769072223) | |||
| 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) | |||
| 18582 | 18582 | 4840 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 138 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6006436.16175 | 2097581.71528 | 37.7399239624285 | -122.42029850157499 | (37.7399239624285, -122.420298501575) | |||
| 95268 | 95268 | 11318 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1216X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/1990 12:00:00 AM | 60 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
| 116654 | 116654 | 28140 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 525X Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6007061.2074168 | 2097884.914897 | 37.7407916822017 | -122.418158839049 | (37.7407916822017, -122.418158839049) | |||
| 10605 | 10605 | 1293 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5991961.87152 | 2087160.6390900002 | 37.7104840184951 | -122.46958569253701 | (37.7104840184951, -122.469585692537) | |||
| 101060 | 101060 | 11326 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 50 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 128599 | 128599 | 11231 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/1990 12:00:00 AM | 50 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 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) | |||
| 21191 | 21191 | 4812 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 28 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 46 | 3X3 | 6005885.45019 | 2097879.1399 | 37.7407095759957 | -122.422223761224 | (37.7407095759957, -122.422223761224) | |||
| 103086 | 103086 | 11230 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1050X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 45 | 3X4 | 6018085.661882901 | 2094069.8743192002 | 37.7309306978843 | -122.379775016493 | (37.7309306978843, -122.379775016493) | ||
| 9063 | 9063 | 4830 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 44 | 5x5 | 6006270.256805 | 2097668.3997492 | 37.740152628556 | -122.42087828555401 | (37.740152628556, -122.420878285554) | |||
| 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) | ||||
| 112180 | 112180 | 26802 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 18512 | 18512 | 4810 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 20 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005841.28363 | 2097904.31782 | 37.7407762175496 | -122.42237826114099 | (37.7407762175496, -122.422378261141) | |||
| 18996 | 18996 | 28137 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 418 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X5 | 6006961.256569999 | 2097891.09385 | 37.740803021841295 | -122.418504870321 | (37.7408030218413, -122.418504870321) | |||
| 21650 | 21650 | 1996 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 175 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6007331.5108 | 2098053.7261799998 | 37.741270411207296 | -122.41723618861201 | (37.7412704112073, -122.417236188612) | |||
| 85513 | 85513 | 11303 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 96922 | 96922 | 11305 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1201X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017591.0151778 | 2093928.8426978001 | 37.7305161553992 | -122.38147530581499 | (37.7305161553992, -122.381475305815) | ||
| 124644 | 124644 | 11327 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1223 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/1993 12:00:00 AM | 40 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | ||
| 33628 | 33628 | 176389 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 700x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6009439.980830001 | 2090047.93275 | 37.719406601704 | -122.40938096396499 | (37.719406601704, -122.409380963965) | |||
| 158262 | 158262 | 176380 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 229 Hester Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6012521.81555 | 2087619.26728 | 37.7129101627473 | -122.398557799413 | (37.7129101627473, -122.398557799413) | ||||
| 170233 | 170233 | 199346 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 467 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 6ft | 6014392.30341 | 2104959.03416 | 37.7606256274859 | -122.39330537915501 | (37.7606256274859, -122.393305379155) | |||
| 7761 | 7761 | 23444 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 9 | 6005977.75981 | 2117720.35574 | 37.795194036322705 | -122.423314692816 | (37.7951940363227, -122.423314692816) | |||
| 19295 | 19295 | 5760 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 398 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6003950.51884 | 2108401.53413 | 37.7694922566853 | -122.42966430666999 | (37.7694922566853, -122.42966430667) | |||
| 56308 | 56308 | 199365 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | Width 8ft | 6009969.14716 | 2108168.58479 | 37.7691915908542 | -122.408829584245 | (37.7691915908542, -122.408829584245) | |||
| 88912 | 88912 | 14871 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 91909 | 91909 | 14872 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 96819 | 96819 | 14870 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 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) | ||||
| 109964 | 109964 | 1773 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2000X Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4X4 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 177148 | 177148 | 248496 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 0ft | 5997529.2628 | 2107821.3875 | 37.7675336345309 | -122.451833202371 | (37.7675336345309, -122.451833202371) | |||
| 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) | |||
| 54305 | 54305 | 199397 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 937 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 6015818.29952 | 2096458.58261 | 37.7373642805443 | -122.387780339289 | (37.7373642805443, -122.387780339289) | |||
| 54771 | 54771 | 176387 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011480.82156 | 2090667.2216900003 | 37.7212211781905 | -122.402370013862 | (37.7212211781905, -122.402370013862) | |||
| 57543 | 57543 | 224011 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 84 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005029.023080001 | 2096988.2407799999 | 37.738215023894 | -122.42512158818701 | (37.738215023894, -122.425121588187) | ||||
| 67100 | 67100 | 176388 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 32 | Width 0ft | 6011438.192840001 | 2090648.2271599998 | 37.7211666433202 | -122.40251603501001 | (37.7211666433202, -122.40251603501) | |||
| 153010 | 153010 | 224448 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 36 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6006371.64374 | 2109173.2323 | 37.7717479515507 | -122.421344528235 | (37.7717479515507, -122.421344528235) | |||
| 4566 | 4566 | 176382 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2112 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6011978.0 | 2087840.0 | 37.7134859388755 | -122.40045291074101 | (37.7134859388755, -122.400452910741) | |||
| 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) | |||
| 8547 | 8547 | 23445 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2100X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005972.56611 | 2117769.9625 | 37.7953299508697 | -122.423336192004 | (37.7953299508697, -122.423336192004) | |||
| 17259 | 17259 | 4834 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 108 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5x5 | 6006318.50135 | 2097642.9115299997 | 37.7400853628581 | -122.420709666225 | (37.7400853628581, -122.420709666225) | |||
| 25829 | 25829 | 218789 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 380 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999445.613919999 | 2094740.51345 | 37.7317263020196 | -122.44426470386101 | (37.7317263020196, -122.444264703861) | ||||
| 70359 | 70359 | 139620 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6001417.4951 | 2112473.8357 | 37.7805300194093 | -122.43871776158998 | (37.7805300194093, -122.43871776159) | |||
| 86602 | 86602 | 5245 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 108720 | 108720 | 120968 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 79x Bradford St | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 30 | 3x3 | 6009615.0 | 2098188.0 | 37.7417673011584 | -122.409350130422 | (37.7417673011584, -122.409350130422) | |||
| 111415 | 111415 | 11292 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/13/1990 12:00:00 AM | 30 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | ||
| 141336 | 141336 | 5243 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 143972 | 143972 | 5244 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 154600 | 154600 | 224031 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 822 Clayton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 5998688.13035 | 2107403.24761 | 37.766451833222604 | -122.447794742535 | (37.7664518332226, -122.447794742535) | |||
| 176451 | 176451 | 199344 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 4ft | 6015727.94816 | 2106771.64308 | 37.7656767749832 | -122.38881249299801 | (37.7656767749832, -122.388812492998) | |||
| 188809 | 188809 | 246135 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1556 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 5998164.5983 | 2108256.0986 | 37.7687636084249 | -122.449666999674 | (37.7687636084249, -122.449666999674) | |||
| 23085 | 23085 | 11553 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/1997 12:00:00 AM | 29 | 3X3 | 6018940.8378099995 | 2097294.9489700003 | 37.7398332568108 | -122.377042159778 | (37.7398332568108, -122.377042159778) | ||
| 24715 | 24715 | 200566 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1440 McKinnon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 0ft | 6016135.6208 | 2095382.4464 | 37.734427000383 | -122.386608184543 | (37.734427000383, -122.386608184543) | |||
| 38240 | 38240 | 176381 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2020 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 6012133.88275 | 2088039.9913700002 | 37.714043767182105 | -122.39992815667699 | (37.7140437671821, -122.399928156677) | |||
| 17697 | 17697 | 4413 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1108 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6x9 | 6004403.04195 | 2102416.52833 | 37.753084468576205 | -122.427672567341 | (37.7530844685762, -122.427672567341) | |||
| 20730 | 20730 | 4823 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 66 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6006092.06915 | 2097770.47064 | 37.74042284693579 | -122.421501634396 | (37.7404228469358, -122.421501634396) | |||
| 23178 | 23178 | 11964 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1009X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6015715.011390001 | 2096321.03931 | 37.7369808923559 | -122.38812786163 | (37.7369808923559, -122.38812786163) | |||
| 25039 | 25039 | 199364 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 6ft | 6009993.3485 | 2108173.3882400002 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | |||
| 48142 | 48142 | 224439 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3883 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6003903.27581 | 2102441.01038 | 37.7531234083377 | -122.429402602143 | (37.7531234083377, -122.429402602143) | |||
| 101721 | 101721 | 18107 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3067 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3x3 | 5999321.271546599 | 2114616.8679369 | 37.7862947536085 | -122.446123757059 | (37.7862947536085, -122.446123757059) | |||
| 134377 | 134377 | 224017 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 91 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6004994.74234 | 2096924.0742900001 | 37.7380369005842 | -122.425235549407 | (37.7380369005842, -122.425235549407) | ||||
| 146356 | 146356 | 199366 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 9ft | 6009946.07759 | 2108167.65587 | 37.769187748042704 | -122.40890931543801 | (37.7691877480427, -122.408909315438) | |||
| 168540 | 168540 | 199394 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 818 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6015978.55484 | 2096747.59262 | 37.738166719509394 | -122.387246410905 | (37.7381667195094, -122.387246410905) | |||
| 27310 | 27310 | 199370 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3550 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | Width 4ft | 6016015.91083 | 2099228.15232 | 37.74497989792071 | -122.38729023576799 | (37.7449798979207, -122.387290235768) | |||
| 27587 | 27587 | 224437 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6006291.67485 | 2097655.32793 | 37.7401179434992 | -122.420803302726 | (37.7401179434992, -122.420803302726) | |||
| 29793 | 29793 | 247852 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6009577.25002 | 2098193.0016099997 | 37.741778919360705 | -122.409481010838 | (37.7417789193607, -122.409481010838) | ||||
| 51360 | 51360 | 110401 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 419X 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 27 | 3x3 | 5990271.90904 | 2112469.3758 | 37.779877404965504 | -122.4772748837 | (37.7798774049655, -122.4772748837) | ||
| 63071 | 63071 | 138599 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2630 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6001313.0958 | 2114947.1478 | 37.7873151619105 | -122.43925625600001 | (37.7873151619105, -122.439256256) | |||
| 74211 | 74211 | 247098 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2301 Castro St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6002743.01525 | 2098640.44771 | 37.7426221983472 | -122.433143479687 | (37.7426221983472, -122.433143479687) | ||||
| 96793 | 96793 | 224018 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1300 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003591.19163 | 2095672.05268 | 37.734519741983 | -122.42999903253299 | (37.734519741983, -122.429999032533) | ||||
| 158585 | 158585 | 199396 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 822 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6015911.756680001 | 2096647.34572 | 37.737887762395296 | -122.38747037626301 | (37.7378877623953, -122.387470376263) | |||
| 174662 | 174662 | 141604 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1890 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5998742.3324 | 2110445.1748 | 37.7748072887689 | -122.447826286931 | (37.7748072887689, -122.447826286931) | |||
| 188514 | 188514 | 141287 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1855 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 6001856.4282 | 2112885.6951 | 37.7816858418255 | -122.43722878495701 | (37.7816858418255, -122.437228784957) | |||
| 1150 | 1150 | 246081 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1390 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999109.7278 | 2108387.5264 | 37.769178502070204 | -122.44640733565201 | (37.7691785020702, -122.446407335652) | |||
| 40266 | 40266 | 246174 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1602 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5997866.0088 | 2108213.3997 | 37.768629281127296 | -122.45069671469 | (37.7686292811273, -122.45069671469) | |||
| 53025 | 53025 | 141296 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1835 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6002071.6645 | 2112917.5067 | 37.7817854213105 | -122.436486447843 | (37.7817854213105, -122.436486447843) | |||
| 64197 | 64197 | 224004 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2 McCoppin St | 5 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6006363.216469999 | 2109170.7903299998 | 37.77174077135479 | -122.42137350531 | (37.7717407713548, -122.42137350531) | |||
| 77097 | 77097 | 199347 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1100 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 6ft | 6013918.13926 | 2106206.1968099996 | 37.764023708663295 | -122.39503266563 | (37.7640237086633, -122.39503266563) | |||
| 162370 | 162370 | 224436 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 98 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6006240.51388 | 2097682.8061900004 | 37.7401905088725 | -122.42098214730801 | (37.7401905088725, -122.420982147308) | |||
| 162867 | 162867 | 224012 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 85 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005023.67021 | 2096975.18783 | 37.738178881048704 | -122.425139167258 | (37.7381788810487, -122.425139167258) | ||||
| 2566 | 2566 | 139641 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1780 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | Width 0ft | 6001669.0 | 2112367.0 | 37.7802509803634 | -122.437840034507 | (37.7802509803634, -122.437840034507) | |||
| 12006 | 12006 | 1294 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 4000X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991953.08243 | 2087152.92109 | 37.7104623187479 | -122.469615507754 | (37.7104623187479, -122.469615507754) | |||
| 18235 | 18235 | 4828 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 85 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6006188.87424 | 2097766.1175 | 37.740416352027204 | -122.421166610858 | (37.7404163520272, -122.421166610858) | |||
| 22192 | 22192 | 4813 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 29 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6005915.07365 | 2097910.62237 | 37.740797690665396 | -122.422123570454 | (37.7407976906654, -122.422123570454) | |||
| 23931 | 23931 | 140150 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 280 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5998837.1325 | 2109760.3619 | 37.772932385832895 | -122.447449052578 | (37.7729323858329, -122.447449052578) | |||
| 24596 | 24596 | 138923 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 970 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6003200.9063 | 2110690.9965 | 37.7757360824046 | -122.432420728644 | (37.7757360824046, -122.432420728644) | |||
| 26359 | 26359 | 199356 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2151 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6011640.657000001 | 2104629.31608 | 37.759567037301004 | -122.40279894282301 | (37.759567037301, -122.402798942823) | |||
| 30472 | 30472 | 247853 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 80 Bradford St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009574.28658 | 2098178.5899099996 | 37.7417391819242 | -122.40949024059401 | (37.7417391819242, -122.409490240594) | ||||
| 32141 | 32141 | 140165 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 210 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5998802.9582 | 2110001.4341 | 37.7735923554748 | -122.447584621644 | (37.7735923554748, -122.447584621644) | |||
| 50774 | 50774 | 199342 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1801 03rd St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 4ft | 6015732.89393 | 2106644.75831 | 37.7653286510121 | -122.38878652777201 | (37.7653286510121, -122.388786527772) | |||
| 56985 | 56985 | 224016 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1000 San Jose Ave | 90 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005001.85234 | 2096930.1779200002 | 37.7380540614461 | -122.425211400785 | (37.7380540614461, -122.425211400785) | ||||
| 65172 | 65172 | 200147 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 2911 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 6013569.8497 | 2091214.9407 | 37.7228415002198 | -122.39518713528 | (37.7228415002198, -122.39518713528) | |||
| 66055 | 66055 | 206268 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 576 Dewey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 6ft | 5994062.286309999 | 2099409.86302 | 37.74423857324471 | -122.463214504856 | (37.7442385732447, -122.463214504856) | |||
| 67214 | 67214 | 218790 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 370 Monterey Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5999688.29402 | 2094714.6188400001 | 37.7316690439961 | -122.443423853031 | (37.7316690439961, -122.443423853031) |
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");